Fort Lauderdale, Florida, United States
Extensive proven experience as a Data Warehouse Architect and Developer. Enterprise-level solutions provider. Excellent knowledge of system design, development and implementation techniques on a full project life-cycle. Extensive experience in database optimization and performance tuning and meta-data. Strong analytical and design skills with proven ability to analyze business requirements and application problems Dynamic innovative professional with stellar communication/interpersonal skills, able to quickly hit the ground using best practices to lead teams with high standards of excellence delivering all projects on time.
2018 – Present Data Architect, UnitedHealth Group, Fort Lauderdale, FL Informatica Cloud ETL Developer and Admin. Formerly: Adaxa Technologies Oracle Autonomous Data Warehouse Admin. Responsibilities: • Administering and designing the full life cycle of the back-end development of the business’s enterprise data warehouse including the installation of Informatica ICSS and Oracle 18c in three separate environments for Development, QA and Production. • Gathering and documenting data mart reporting and other requirements to meet business needs of internal and external clients. • Assessing and applying Amazon Data Management Services for facilitation of Data Warehouse functions • Oracle 18c Database implementation, administration and performance. • Hands on Informatica ICSS ETL development and administration; review ETL jobs for consistency, quality and performance tuning. • Create data models, design and document ETLs, and validate results with business representatives. • Support implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity. • Maintain a high-level of data quality awareness; proactively work on identifying and improving data quality. • Create and maintain technical documentation, specifically data dictionaries, ERDs and operational documents Achievements: • Initiated the company’s first Data warehouse including selecting the appropriate ETL tool and database software combination then extensively unit testing and presenting proofs of concepts to executive team. • Responsible for successfully creating and maintaining the Data Warehouse and enlisting the aid of peers. • Translate business requirements into specifications that are used to implement user friendly environments, reports, and dashboards. • Prepare reports on analyses, findings, and project progress, and presents results to management and/or peers.
Responsibilities: • Complete the business analysis for the new enterprise data warehouse. • Create source to target documentation for all dimensions and fact tables. • Lead ETL team, assigning workloads and review progress. • Perform all Informatica Administrator duties. • Source data from Cerner and Lawson. Achievements: • Successfully designed and maintained the new enterprise data warehouse. • Supported and maintained the previous enterprise data warehouse while migrating all mappings and processes to the new enterprise data warehouse. • Develop, test and implement efficient ETL (Extraction, Transform and Load) code to populate data integration layers (data warehouses, ODS and data marts) to support business requirements using Informatica PowerCenter 9.6.1
2016 – 2006 Contractual Assignments: 2016 Sr. ETL Developer Interval Leisure Group , Coral Gables, FL 2015 – 2016 Sr. ETL Developer/Team Lead Stryker Corp., Kalamazoo, MI 2015 Sr. Consultant Clear Peak, Denver, CO 2014 – 2015 Sr. Data Warehouse Developer/Team Lead Tyco International, Boca Raton, FL 2014 Sr. Data Warehouse Developer American Express, Fort Lauderdale, FL 2013 – 2014 Sr. Data Warehouse Developer/Technical Lead Watsco Inc., Coconut Grove, FL 2012 – 2013 Sr. Data Warehouse Developer/Technical Lead/ Informatica Administrator Bayview Asset Mgmt., Coral Gables, FL 2011 – 2012 Sr. Data Warehouse Developer/Technical Lead BankUnited, Miami Lakes, FL 2010 – 2011 Sr. Data Warehouse Developer/Technical Lead Sun life Insurance, Toronto, Ontario 2009 – 2010 Sr. Data Warehouse Developer/Team Lead Manitoba Public Ins., Winnipeg, Manitoba 2008 – 2009 Sr. Data Warehouse Developer The Cooperators, Guelph, Ontario 2008 Sr. Data Warehouse Developer Bruce Power Plant, Tiverton, Ontario 2007 – 2008 Sr. Data Warehouse Developer Rogers Communications, Miss., Ontario 2006 – 2007 Sr. Data Warehouse Developer Govt. of Ont., Ministry of Edu., Toronto 2006 Sr. Data Warehouse Developer Marsh Canada, Toronto, Ontario
Responsibilities: • Responsible for production and maintenance of the entire data warehouse of the actuarial department. • Active contributor in designing, developing, and deploying Enterprise Data Warehouse, data marts, and enterprise reporting/business intelligence (BI) solutions. • Translate business requirements into appropriate specifications – passing structural changes to the DBA and incorporating transformations & loading changes primarily using SQL 2000 and Redbrick. • Responsible for the Extraction/Transformation/Load (ETL) processing of the organization's data into the Data Warehouse Environment. • Identify, research, and resolve data quality issues. • Monitor and tune the performance of ETL processes primarily using Informatica PowerCenter. • Migrate ETL processes to production environment(s) primarily using Informatica PowerCenter. • Respond to and resolve ETL-related problems (job failures, performance, data quality, etc). • Troubleshoot problems related to the Informatica software products, interact with appropriate vendor support to resolve problems, and apply maintenance and/or upgrades as needed. • Interacts with all levels of staff that use the data warehouse. • Bringing new products into the data warehouse primarily using Informatica PowerCenter. • Maintain current ETL (extraction, transformation and loading) process. • Investigate feasibility and analyze impact of changes to the business requirements upon all functional areas within the department. Achievements: • Provide audit trail (used by internal/external auditors and regulators), and management reports on all data loaded and performance tools. • Develop and maintain meta-data repository – with both business and system information primarily using Informatica Power Analyzer. • Liaise with other departments/projects to be aware of any changes (e.g. to source systems or business processes), analyze the impact to the current ETL process and plan for the appropriate incorporation.