SUMMARY

• Successfully managed design and development teams between five and ten employees to deliver on time and on budget data warehouses and business intelligence platforms. This includes the creation of requests for proposals for vendor selection, the gathering of user requirements, data governance and conformance, design of a high performance ETL process, development of algorithms, metrics, executive dashboards and the creation of highly responsive reporting platforms.Manage teams of between five and fifteen employees in development, reporting, testing and business analysis.
• Utilize data to drive business decisions, improve profitability, and streamline processes.
• Model, maintain and enhance the processes for Master Data Management (MDM), Enterprise Data, and Quality initiatives.
• Design and develop reports in Tableau, Cognos, SSRS, Qlikview, SSRS, and Microstrategy
• Development in Redshift, Glue, Athena, SQL Server, SSIS, SSAS, Oracle, Postgres, My SQL.
• Reporting platform development in Tableau, MicroStrategy, Crystal, SSRS, and QlikView.
• AWS Cloud Certification, EC - 2, S3, Spark, Hive, Pig, T-SQL, PL-SQL, Python, and SAS.
• Development of physical and logical data models utilizing Erwin, Visio and Toad
• Tracking of projects with Agile and Waterfall methodologies

PROFESSIONAL EXPERIENCE

Confidential

Tech Lead

Responsibilities:

• Developed comparative architectural designs in Azure and AWS to replace three physical servers with Oracle, Informatica, and Microstrategy with an Informatica, Postgres, Tableau configuration.
• Detailed the as is state for several 20 years old applications that were managing financial, gas leak, and repair data for the New York area.
• Created team, time, and resource estimates for phase one and two deployments.
• Created golden record with SAS for an integration of data from credit, risk and treasury for the Enterprise data warehouse group.
• Developed an AWS design utilizing Load Balancing, Cloud Front, Elasticache, and Red Shift for data warehouse storage.
• Evaluated Tableau, Qlikview, Spark, Postgres, and Cassandra, and Vertica as tools for the proof of concept for a big data solution..
• Managed an on and off-shore team of ten developers, analysts, and QA resources.
• Utilized Agile to manage a team of developers, subject matter experts, tester, and designers to provide a road map and strategic direction for the migration project.

Confidential

Business Intelligence Manager - Consultant

Responsibilities:

• Managed and mentored a team to develop a data warehouse and analytics platform which provided over 700 clients with both real and point in time reporting in SSRS and Tableau.
• Established the data of record from four disparate, overlapping and frequently contradictory databases. sources. This includes conformance, security, establishing a data history, creating an MDM process, and establishing a single level of granularity.
• Implemented changes to the transactional database to permit for a clean and streamlined real time warehouse and reporting platform.
• Developed standardized reports in SSRS and designed a Tableau analytics tool.
• Utilized an Agile methodology to track milestones and progress on time and on budget reporting.
• Utilized SAS and SQL to develop an analytics and reporting platform that established HR benchmarking and actionable insights for internal and external clients.
• Designed and developed physical and logical database including MDM for the import of data from 700 clients

Confidential

Data Architect and Manager of Business Intelligence

Responsibilities:

• Managed team of ten developers, tester and analysts to develop a business intelligence platform to manage digital advertising.
• Delivered proof of concept, and data architecture with an SFTP delivery of data, Informatica, Oracle, Microstrategy, and Tableau.
• Created a mapping between the existing data warehouse and six databases produced by a change of systems and vendors which control digital advertising and contracts.
• Managed the migration of Business Intelligence for the Confidential digital division to a new contract and ad serving system. This necessitated the management of a team of ten programmers, coordinated the efforts of three vendors, and oversaw the collection of requirements from a diverse end user community.
• Tracked project progress with an Agile approach that included weekly status meetings with users and daily updates with the development team and vendors.
• Performed a gap analysis to allow the linear (television) area of Discovery to transition to a new contract, tracking, and ad serving system. Coordinated and customized reporting requirements within the vendor system as well as develop a design plan and implementation for a general business intelligence system.
• Acted as the subject matter expert on both existing and new data models to allow seamless transition to a new system.

Confidential

Manager of Reporting and Analytics

Responsibilities:

• Managed cardio-thoracic and congenital reporting including surgeon report cards, mortality studies, success metrics and promotional materials.
• Designed the integration of cardio-thoracic data with data feeds from perfusion, oncology, radiology and mortality to establish best practices and forecast outcomes.
• Responsible for the development of a reporting platform that allowed for user generated reporting and coordination between medical specialty areas.
• Utilized a variety of reporting tools including Cogons, Qlikview, and SSRS.
• Managed an internal team to improve performance of a muti-terabyte data warehouse through the use of look up tables, incremental loads, checkpoints, cached record sets and revisions to the approach to slowly changing dimensions.
• Designed and implemented algorithms in SSIS and TSQL to improve the performance of ETL processes resulting in processing times cut by 70-90%.
• Worked with business users and subject matter experts to achieve data conformance between multiple data sources.
• Developed the physical and logical design using Toad Data Modeler to build a multidimensional warehouse to store television spots, available break information, finances, clients, networks and agency data.

Confidential .

Technical Manager Business Intelligence

Responsibilities:

• Senior SQL Server technical lead with responsibility for logical and physical database design as well as design and implementation of both OLTP and data warehousing applications.
• Managed the development of an online portal designed to meet the SLA and BI needs of a designated set of users. This necessitated data mapping, sourcing and on-boarding of metrics and KPIs for a balanced scorecard developed for executive oversight.
• Designed a reporting platform to streamline risk assessment and government reporting for foreign exchange and commodity hedging.
• Coordinated a team of internal developers as well as several off-shore teams in Europe, Asia, and Latin America. Responsibilities included establishing and forecasting the internal budget as well as shepherding those expenditures over $50,000 through the corporate approval process.
• Gathered requirements and managed new project implementations for treasury operations, foreign exchange trading, commodities, and cash management departments.

Confidential

Data Warehouse Architect

Responsibilities:

• Designed a commission application for private client financial analysts which included differentiation between payment tiers, new vs. old accounts, and assumed vs. actual revenue.
• Designed a Star Schema SQL Server database to support this new commission application, and integrated it with existing data from Access, Oracle, Excel, and other SQL Server databases. Utilized such tools as SSIS, SSAS, SSRS and Cognos to develop an analytic framework and reporting package.
• Implemented a high availability mirroring solution for a mission critical instrument trading application utilizing SQL Server 2005.
• Managed an internal team and off-shore resources in England, Singapore and India to coordinate the design and development of an improved business process and delivery of a highly responsive business intelligence system.
• Utilized SSIS, T-SQL and VB.Net to developed a data warehouse to integrate the data from eleven functional areas with seven separate SQL Server, Oracle, and Excel databases. This was being done in order to bring the Health Services division into compliance with State regulation as well as increase productivity in accordance with defined performance metrics.
• Developed workflows and designed processes surrounding the Utilization Management, Claims, Appeals, Approval, Denial and Partial Denial process.
• Created an audit tool for widespread use that standardized and automated the auditing process across department and management layers.