Databricks

Collaborate with Product and Engineering to make awesome products and features that customers love.

Lead Product Specialist

Senior Solutions Architect

• Provide technical leadership in a pre-sales and post-sales capacity for customers to support successful understanding, evaluation and adoption of Databricks
• Consult on architecture and design, bootstrap, and/or implement strategic customer projects
• Build references architectures, how-tos, and demo applications for customers
• Provide escalated level of support for critical customer operational issues
• Architect, implement, and/or validate integrations with 3rd party applications
• Evangelize Spark and Databricks across developer community through meetups and conferences
• Become an Apache Spark expert

Solutions Architect

• Understand overall data estate, IT and business priorities and success measures to design data architectures and solutions.
• Oversight of the design and standards of data products.
• Conduct research on data architecture and data management trends to use in planning and recommendations.
• Influence data strategy and provides direction to leadership. 
• Analyze and work with business and technical team members to assess existing data structures and processing patterns, and design forward-thinking data architectures to meet business and technical needs.
• Creates short-term tactical solutions to achieve long-term architecture objectives and overall data architecture roadmaps.
• Provide consultative services on projects focused on data architecture development and implementation of strategic technological directives.
• Support architecting Azure cloud-based data products needed to support the future state technology platform.
• Drive adoption of Enterprise Data Lake framework, and lead solution delivery to business and technical team members.
• Teamed up with Microsoft and Databrick's Architect's and Engineer's on a CodeWith for UtilizationIQ™ occupancy sensor project, using Azure Databricks, Azure EventHubs, and Azure SQL DB.  Continued with product development on the Azure Databrick's platform.

Data Solutions Architect

• Partner with business and internal/external stakeholders to understand current customer experiences, identify areas of opportunity, create and manage product vision and road map for both functional and technical levels
• Acts as primary point of contact for intake process to DevOps technology teams
• Manage product backlog and priorities with business and technology partners
• Work with business leaders to identify and articulate initiative scope, benefits, and ROI
• Collaborate with stakeholders to plan and manage product releases
• Effectively and efficiently communicate with technical and non-technical audiences, and leadership

IT Product Manager, Data and Analytics

•	Steered Cognos, SQL Server, and Informatica projects to turn around issues with data quality, report speed, and ETL on a new RED BI product line
•	Lead creation of new client customizable product line of dashboards using Tableau 
•	Lead creation of corporate wiki to aid in the sharing of artifact documentation relating to data, definitions, designs, and standard practices that are translated in a way that everyone can understand
•	Lead the vision of longer term business requirements, and technically translate into design documentation to technical teams
•	Communicated business priorities to the technology organization in order to drive effective business solutions 
•	Conducted research and analysis on goals of clients and teams to determine solution criteria, and develop solution plans that ensure successful rollout 
•	Facilitated requirements and design sessions with user community and communicates these requirements to the development team for the design and implementation of solutions 
•	Analyzed impact of proposed solution across the business, and ensure that solutions meet defined success criteria
•	Developed use cases to explain/demonstrate business requirements/specifications to IT team, and contributes business partner’s perspective during design reviews 
•	Provideed input to the development of formal business cases when enterprise wide business solutions are proposed

Lead Global Business Intelligence Analyst

Wintrust Financial

• Work closely with management, finance and business operations to analyze and document the needs of the organization. 
• Understand business objectives, assumptions, and constraints related to solution delivery.
• Ensure continuity of cross functional business requirements across departments and between project stakeholders.
• Conduct business process analysis, needs assessments, and preliminary cost benefit analysis.
• Lead stakeholder analysis and documentation of interdependent processes with other business units.
• Work with technical staff to design/develop business intelligence applications and data models.
• Use SQL Server Management Studio to create, analyze and modify tables, stored procedures, functions and schema. 
• Use SQL Server Reporting Services to develop new reports and modify current reports according to business requirements. 
• Use SQL Server Integration Services to develop impromptu packages for ETL processes. 
• Develop and modify queries for impromptu analysis.
• Manage and modified Other Real Estate Owned (OREO) management application.
• Brought existing application and warehouse databases, reports and packages under source control with Team Foundation Server 2013. 
• Managed server migration from 2 servers to 7 servers, including web, SQL, reporting and development servers.

Senior Business Analyst, Officer - Finance - Data Management

• Work closely with management, finance and business operations to analyze and document the needs of the organization. 
• Understand business objectives, assumptions, and constraints related to solution delivery.
• Ensure continuity of cross functional business requirements across departments and between project stakeholders.
• Conduct business process analysis, needs assessments, and preliminary cost benefit analysis.
• Lead stakeholder analysis and documentation of interdependent processes with other business units.
• Work with technical staff to design/develop business intelligence applications and data models.
• Use SQL Server Management Studio to create, analyze and modify tables, stored procedures, functions and schema. 
• Use SQL Server Reporting Services to develop new reports and modify current reports according to business requirements. 
• Use SQL Server Integration Services to develop impromptu packages for ETL processes. 
• Develop and modify queries for impromptu analysis.
• Created ETL processes for Stress Testing Models.
• Created New Note Report that utilizes business logic and technical specifications to determine the proper new notes in a given month. 
• Created Allowance for Loan Loss and Leases Analysis Report, report on the key metrics that affect ALLL for all loan groups (Commercial, Commercial Real-Estate, Consumer, Home Equity, Residential Real-Estate and Indirect Auto). 
• Manage and modified reporting for Troubled Debt Restructure (TDR) Loans and Discounted Cash Flow (DCF) for TDR Reporting. 
• Created and manage pricing and profitability model web application for new loans that assisted lenders in managing the Return on Assets (ROA) and Return on Equity (ROE) for new and existing deals. 
• Manage and modified Other Real Estate Owned (OREO) management application.

Business Analyst - Finance - Data Management

Colorado Technical University

•	Developed University wide Scorecard project where every department was interviewed, Key Performance Indicators were established, various databases mined for historical and budget data, and compared to current performance and displayed graphically.
•	Used advanced formulas and VBA programming in Excel and Access to create efficiency in modeling for various Key Performance Indicators for the Finance team in preparation for modeling and forecasting. 
•	Collaborated with all levels of management and staff in all departments to deliver ad-hoc reporting requests and developed efficiency with Excel, Access and VBA.
•	Utilized Data Warehouse in SQL Server to customize reports and Ad-Hoc queries that fit business needs, operational reporting that gained insight that was not found before. 
•	Created and modified various models using advanced formulas and VBA in Excel for Finance team to automate tasks and decrease forecast error and invalid data. 
•	Developed models for Ground campus student population to report and forecast attrition.
•	Developed model for student enrollment conversion to forecast conversion rates to yield increased accuracy. 
•	Handled ad-hoc data analysis for urgent Regulatory, Operational, Financial and Academic projects and delivered within scope.
•	Helped train and mentor the entry level Operations Analyst(s) on reports and the ongoing use of models developed for forecasting and analysis.
•	Researched and developed new modeling techniques to enhance forecasting ability using statistics and mathematics.
•	Present and deliver presentations using MS PowerPoint, and training on tools that were developed, to staff and management.

Senior Operations Analyst

American InterContinental University

•	Collaborated with internal team members, Enterprise IT staff, as well as business owners to perform ad-hoc requests and develop custom reports to track business metrics using Microsoft Access and SQL Server to develop queries, and use Excel to refine, and display data.
•	Used Excel and Access to automate the Month End Close process for various operating metrics where time to complete tasks was significantly reduced and accuracy of data increased.
•	Supported University initiatives that require technical automation by collaborating with business owners to ensure that business requirements are prepared, built and tested to ensure successful rollout.
•	Worked with Admissions department on developing Advisor metrics that defined an efficient advisor, mined various data sources and developed a balanced scorecard in Excel that increased efficiency for management to review advisors.  
•	Created, modified and queried Relational Databases in Access.
•	Interpreted and queried Relational Databases in Microsoft SQL Server.
•	Designed and implemented automated workbooks to increase efficiency and accuracy of population, revenue, and marketing metrics reporting to financial analytical system (SAP BPC).
•	Developed forecast models for population, attrition and graduates for financial impact analysis and reporting to financial analytical system (SAP BPC).
•	Supported University initiatives that require technical automation by collaborating with business owners to ensure that business requirements are prepared, built and tested to ensure successful rollout.
•	Present and deliver presentations using MS PowerPoint, and training on tools that were developed, to staff and management.

University Database Analyst

•	Analyzed process related issues and technical based solutions, using but not limited to Microsoft Office Visual Basic for Applications, that would decrease findings, increase productivity and offer tracking mechanisms for management.
•	Mined CampusVue report data for relevant data and created graphical analysis for management review, including fund analysis, start risk tracking analysis and other analysis on demand.
•	Planned, executed, developed over 25 projects that affected multiple departments within the University to speed up processes, allow transparency and decrease risk from errors.
•	Designed and implemented relational database systems in MS Access
•	Developed SQL queries in MS Access and SQL Server
•	Increased quality of records and time spent on managing keeping records for Financial Aid Advisor phone call quality scorecard by creating a database and a user interface easy to use for management.
•	Technical lead for Financial Aid department regarding all technical issues from programs to computer hardware, but limited to issues that did not require Help Desk or Application Development support.
•	Decreased process lag time for Georgia State Aid processing between multiple departments by creating database and user interface with Microsoft Access and Excel.
•	Present and deliver presentations using MS PowerPoint, and training on tools that were developed, to staff and management.
•	Review and modify Business Requirements as needed.

Financial Aid Process Analyst

•	Awarded Federal Aid to and maintained contact with continuing students.
•	Answered inbound calls from students and assisted with questions and concerns about Student Aid.
•	Initiated process development of sub department by automating tasks with Microsoft Excel and VBA.
•	Utilized Excel, VBA, and the company intranet to create a tool that enabled contacting and finalizing student aid faster by 1 to 2 minutes per student contact and finalizing packaging process by 2 to 5 minutes per package.

Senior Financial Aid Advisor - Subsequent Year Advisor

•	Audited student files for accuracy and compliance with Title IV regulations.
•	Followed the Department of Education verification guidelines regarding IRS documentation.
•	Created automated Specialist statistics board with MS Excel and VBA that held the count of documents processed for easier management of duties and tasks.

Senior Verification Specialist

•	Awarded Federal Aid to new students in compliance with Title IV regulations.
•	Maintained contact with students to ensure all documents are received and accurate.
•	Answered inbound calls and answered questions and concerns about Student Aid to students.

Financial Aid Advisor

FedEx Express

•	Answered inbound calls about package pickup, tracking and delivery. 
•	Resolved customer concerns and issues in a timely and efficient manner. 
•	Member of Representative Coaching Team to help coach other Representatives on quality and timely methods. 
•	Maintained high level of work ethic that enabled me to be a top performer on stats and call quality. 
•	Assisted management with information dissemination with creation of internal intranet site that enabled a central repository for local site information and sharing of best practices.

Customer Service Representative

With 17+ years of experience in data and analytics, I am a Lead Product Specialist at Databricks, the leading data lakehouse platform in the cloud. I collaborate with customers to understand their business needs, challenges, and goals, and help them leverage the power of Databricks to deliver data products that drive value, innovation, and growth.

I have a strong background in data management, networking, cloud, and project management, and I am proficient in Databricks, Spark, Delta, and SQL. I have also earned multiple certifications and honors for my performance and expertise. I enjoy working with technical and business leaders, architects, engineers, data scientists, and analysts across various domains and industries, and sharing best practices and insights on how to build, manage, and optimize data lakehouses with Databricks. I am passionate about enabling data-driven decision-making and empowering teams to succeed with data.

Taplio

Franco Patano's Linkedin Analytics

Franco Patano

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Franco Patano's Linkedin Analytics

Franco Patano

Want to drive more opportunities from LinkedIn?

Franco Patano's Linkedin Analytics