SUMMARY:

• Over 16 years of experience as Data Warehouse Developer, Design and implementation.
• Specialized in Data Warehousing data transformation (ETL) and analysis in support of Business Intelligence.
• Extended 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
• Enterprise-level solution provider
• Client-server systems using several SQL databases development and performance tuning
• Excellent knowledge of system design, development and implementation techniques on a full project life-cycle
• Very good communication, interpersonal skills, professional attitude, innovative, flexible, dynamic and reliable
• Able to work unsupervised and contribute with constructive teamwork

TECHNICAL SKILLS:

Databases: Oracle 7.x / 8.x, 9i, 10g,11g, DB2 UDB 7.x/8.x, SQL Server 6.5/7/2000, Ms Access, Sybase, My SQL, IBM Redbrick, Cerner

Languages: SQL, PL/SQL, HTML, UNIX AIX.

Software Tools: Informatica PowerCenter 4.5 thru 10.2, Informatica Cloud Winter 2016, Erwin, DB2UDB utilities, SQL Navigator, Toad, Visio, Visual Source Safe, Ms Office, Hyperion Intelligence Explorer 8.3

Operating Systems: UNIX(HP-UX, AIX, IRIX), Windows NT4.0/2000,2003,2008 Windows 7/XP/95/98/3.x, Linux, Ms DOS.

Industry Sectors: Insurance, Investments, Financial Services, Tele Communications, Nuclear Power Station, Banking, Health Care

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect/ Team Lead

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, including complete installation in Linux environment.
• Design and maintain the new enterprise data warehouse.
• Support and maintain the previous enterprise data warehouse while we migrate all mappings and processes from it 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 Powercentre 9.6.1, 10.2
• Source data from Cerner, Lawson, Peoplesoft and Power Insight.
• Working on mayor project to migrate from Lawson Source system (financial and HR data) to Peoplesoft. Responsibilities include ETL, documentation and Data Architecture.

Confidential

Senior ETL Developer

Responsibilities:

• Provide a technical solutions to new business requirements.
• 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 Powercentre 9.6.
• Design data flow analysis
• Utilize Oracle database as the data warehouse target, AS400 as source.
• Do extensive data testing, troubleshooting analysis.
• Load and monitor data load/ETL jobs, troubleshoot and correct problems when required.

Confidential, Kalamazoo, MI

Senior ETL Developer / Team Lead

Responsibilities:

• Provide a technical solutions to new business requirements.
• 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 Cloud and Informatica Powercentre 9.6.
• Design data flow analysis
• Utilize Azure database as the data warehouse target, AS400 as source.
• Do extensive data testing, troubleshooting analysis.
• Load and monitor data load/ETL jobs, troubleshoot and correct problems when required.
• Tutor and lead junior offshore team members of on Informatica Cloud.

Confidential, Denver, CO

Senior Consultant

Responsibilities:

• Provide a technical solutions to new business requirements.
• Develop, test and implement efficient ETL (Extraction, Transform and Load) code to populate data integration layers (data warehouses and data marts) to support business requirements using Informatica Powercentre.
• Design data flow analysis.
• Utilize Oracle as the data warehouse target.
• Do extensive data testing. Optimization.
• Load and monitor data load/ETL jobs, troubleshoot and correct problems when required.

Confidential, Boca Raton, FL

SeniorData Warehouse Developer\ Team Lead

Responsibilities:

• Provide a technical solutions to new business requirements.
• 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 Cloud.
• Design data flow analysis
• Utilize Salesforce objects as the data warehouse target.
• Do extensive data testing.
• Load and monitor data load/ETL jobs, troubleshoot and correct problems when required.
• Tutor junior team members on Informatica and Data Warehousing.

Confidential, Fort Lauderdale, FL

SeniorData Warehouse Developer

Responsibilities:

• Design system integration architecture
• Design data flow analysis
• Provide a technical solutions to new business requirements.
• 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.
• Maintain and manage technical metadata for data warehousing environments.
• Develop guidelines and procedures governing enterprise-wide data collection and extraction.
• Develop and implement data naming conventions for enterprise data warehouse systems.

Confidential, Coconut Grove, FL

SeniorData Warehouse Developer / Technical Lead

Responsibilities:

• 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.
• Plan and support lifecycle of data warehousing infrastructure components including database, operating system, ETL tools as well as various vendor products.
• Optimize the data environment in order to efficiently access enterprise data.
• Monitor performance of data warehouse ETL processes to ensure service level agreements with our users are met and implement tuning as needed to address scalability issues typical in large data warehouse implementations.
• Maintain and manage technical meta data for data warehousing environments.
• Develop guidelines and procedures governing enterprise-wide data collection and extraction.
• Develop and implement data naming conventions for enterprise data warehouse systems.
• Work closely with the database administrators with physical database designs, performance metrics and backup/recovery requirements
• Support multiple test and QA data warehouse environments supporting multiple business units.
• Provides 24/7 support of multiple production data warehouses serving multiple business units. Continuous monitoring of key metrics associated with performance and resource utilization.Experience with MS SQL/ Server 2008 R2 or above
• Informatica PowerCenter version 8.6; Administration, Configuration and Development
• Informatica PowerExchange version 8.6 - Change data capture process

Confidential, Coral Gables, FL

SeniorData Warehouse Developer / Technical Lead / Informatica Administrator

Responsibilities:

• Lead the problem solving and troubleshooting effort for the Informatica projects.
• Lead the support and ownership of the Informatica platform, including rotating after-hours support.
• Develop strategies and ensure optimization of data acquisition, archived data recovery, and publication and integration of data into Informatica data targets.
• Respond quickly and effectively to production issues and taking responsibility for seeing those issues through resolution.
• Administrative tasks within Informatica platform such as stopping/starting Informatica Repository and Server processes, performing code migration, backup and restore of Informatica Repository, user creation and management, upgrades and security administration.
• Work closely with the Architect defining and modeling schemas.
• Design, develop and Unit Test the ETL components for the new projects i.e. mappings, transformations, mapplets, Informatica Workflows and source qualifier files.
• Support the Integration testing and UAT activities.
• Work closely with the BI reporting team, creating ETL solutions to solve difficult logical requirements.
• Load and monitor data load/ETL jobs, troubleshoot and correct problems when required.
• Tutor junior team members on Informatica and Data Warehousing.

Confidential, Miami Lakes, FL

SeniorData Warehouse Developer / Technical Lead

Responsibilities:

• Responsible for development, maintenance and support of the bank’s loan share process. Arguably the most important process in the systems integration team.
• Create data model, design, ETL development, staging and target tables, implementation and testing of a large new project to allow business users to run loan reports on an hourly basis.
• Created an efficient daily process by which the bank could maintain historical data from the daily loads provided by a third party.
• Develop, debug and unit test components (existing & new) of the application
• Used extensively Informatica PowerCenter mappings/sessions/workflows Oracle (Toad) / MS SQL

Confidential

SeniorData Warehouse Developer / Technical Lead

Responsibilities:

• Provide work estimates in support of assigned work
• Ensure that development work assigned follows applicable standards and that code is clear, efficient, structured and easily maintainable.
• Create design/specification documentation, ensuring that the design andspecifications are complete and that they accurately reflect not only the business & technical requirements but organizational needs and goals as well
• Construct, document, or integrate as required per system release
• Develop, debug and unit test components (existing & new) of the application
• Provide on-call overnight support on a rotation basis
• Contribute to the development of standards and guidelines
• Used extensively Informatica PowerCenter mappings/sessions/workflows Sybase/ MS SQL
• Manage a staff of six senior developers including one abroad.

Confidential

SeniorData Warehouse Developer / Team Lead

Responsibilities:

• Data warehousing, data marts, ETL, data cleansing.
• Application design and development for data warehouse based reporting systems.
• Used extensively Informatica PowerCenter mappings/sessions/workflows Sybase/ MS SQL
• Performed tuning and performance analysis of various data warehouse based systems
• Worked closely with the management team to configure and implement the data warehouse and ETL project methodology
• Mentored the DWBI team, team lead and project lead roles.

Confidential

SeniorData Warehouse Developer

Responsibilities:

• Create the design and road map for the data warehouse and BI group
• Implement/install and configure the Informatica PowerCenter 8.1.1
• Design and implement the purchase data mart; use extensively Informatica PowerCenter 8.1.1, for Oracle 10g.
• Design and implement the ETL integration from Legacy system data into an Object Oriented software product.
• Design and deploy XSD files and create XML targets.
• Work closely with business analysts, business users and architects.
• Performance tuning and optimization of the data warehouse databases.

Bruce Power Plant, Tiverton, Ontario

Role(s): SeniorData Warehouse Developer

• Data modeling, data management/storage
• Design, develop and Unit Testthe ETL components for the new projects i.e. mappings, transformations, mapplets, Informatica Workflows and source qualifier files.
• Support the Integration testing and UAT activities
• Application design and development for data warehouse based reporting systems (Cognos). Used extensively Informatica PowerCenter8.x mappings/sessions/workflows Oracle 10g
• Performed tuning and performance analysis of various data warehouse based systems
• Mentored the DWBI team, team lead and project lead roles.

Rogers Communications, Mississauga, Ontario

SeniorData Warehouse Developer

• Data modeling, data management
• Performance tuning and optimization for Oracle databases.
• Design, develop and Unit Test the ETL components for the new projects i.e. mappings, transformations, mapplets, Informatica Workflows and source qualifier files
• Application design and development for data warehouse based reporting systems (Cognos). Used extensively Informatica PowerCenter7.x mappings/sessions/workflows Oracle 10g
• Implemented the Velocity project methodology for data integration projects
• Designed and developed the main data model for Rogers’ Home Phone.
• Create scripts using PL/SQL
• Mentored the DWBI team, team lead and project lead roles.

Government of Ontario, Ministry of, Toronto, Ontario

SeniorData Warehouse Developer

Responsibilities:

• Data warehousing, data marts, ETL, data cleansing, scrubbing
• Load and monitor data load/ETL jobs, troubleshoot and correct problems if required.
• Support the Integration testing and UAT activities.
• Application design and development for data warehouse based reporting systems. Used extensively Informatica PowerCenter 6 mappings/sessions/workflows DB2, AS400
• Performed tuning and performance analysis of various data warehouse based systems resulting in DB2 performance improvement
• Develop, test and deploy full code package for ESDW in Visual Source Safe.
• Develop and/or update Technical documentations and operational manual etc.
• Mentor for the data warehousing team, taught courses on data warehousing and Informatica fine tuning

Confidential

SeniorData Warehouse Developer

Responsibilities:

• Perform data analysis to determine ETL design specifications.
• Design, development, test, document and deploy new mappings using Informatica PowerCenter and Visio.
• Perform QA testing of ETL processes.
• Design process to handle large amounts of data.
• Maintain the existing ETL processes to accommodate changes in source systems and business requirements.
• Use best standard practices and methodology.
• Analyze query plans, indexes, and locking behavior.
• Document, write and execute test scripts for validation and data loading using Oracle.
• Optimize design to handle large volumes of data.
• Instruct data warehouse novice staff on the use of Informatica.

Confidential

Data Warehouse Developer

Responsibilities:

• 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.
• Develop, test, implement, and maintain automated ETL processes primarily using Informatica PowerCenter.
• Develop automated audit processes to insure data is loaded as expected.
• Identify, research, and resolve data quality issues.
• Monitor and tune the performance of ETL processes primarily using Informatica PowerCenter.
• Perform QA testing of ETL processes.
• Migrate ETL processes to production environment(s) primarily using Informatica PowerCenter.
• Respond to and resolve ETL-related problems (job failures, performance, data quality, etc).
• Provide input regarding best practices, recommend and document ETL standards and procedures, and implement improvements to ETL infrastructure.
• 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.
• 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 in corporation.