SUMMARY:

Senior data warehouse consultant with over 20 years’ of data warehousing experience specialized in data integration (ETL) and data presentation; Over 20 years’ consulting experience in various industries; High rate of success and client satisfaction through the development life cycle; Outstanding troubleshooting and problem solving skills

TECHNICAL SKILLS:

UNIX/Linux, Shell/Perl scripting, awk/sed, Data Modeling, Dimensional modeling, ERWIN/ERStudio, Informatica PowerCenter, Informatica PowerExchange, Informatica Data Quality, CDC, Oracle, PL/SQL, Teradata 12/13/14, MS SQL Server, T - SQL, DB2, Cognos, BusinessObjects, AWS Cloud Computing, Informatica BDM,Hadoop/PIG/Spark/Hive

PROFESSIONAL EXPERIENCE:

Confidential

Date Integration Architect

• Architect Business Intelligence/Data Warehouse solutions to achieve business goal or customer engagements through in-depth analysis, coordination and negotiation with key decision makers.
• Uses expertise to construct specific and detailed solutions that encompass process, technology, project and staffing plans.
• Plans, conducts and manages assignments generally involving large, high budgets (cross-functional) projects or more than one project.
• Serve as technical consultant to senior leadership in the IT organization and functional user groups.
• Drives changes in architecture, methodology or programming procedures

Confidential

• Provide strong, visible leadership to a team of Informatica developers.
• Implementing Informatica Cloud solution integrating dealer data with Sales force.
• Wrote Unix Shell scripting to pre-parsing of data files log the ETL steps automating the data integration process
• Administer and optimize the existing Informatica ETL implementation and providing guidance and operational support.
• Develop and enforce ETL development standards and best practices
• Lead the ETL team and guide on best design principles and implementation methodologies
• Support software upgrades, software documentation, research of new software versions
• Define and review procedures to perform ETL promotion of software packages to the proper environment, troubleshooting, and technical support
• Work closely with internal customers to ensure the software is configured and service level agreements are created and maintained for new integrations

Confidential

• Analyze existing ETL process to better understand the data integration environment
• Support existing ETL component and document the process
• Develop/test/implement data integration process required for new data using Unix Shell Scripts
• Assist Informatica admin in implementing Metadata Manager and demonstrate
• Assist project managers in working with business clients to collect potential data needs
• Perform stress testing on Informatica upgrade
• Suggest Informatica best practices and make effort to enforce
• Work with offshore support team to monitor the health of ETL environment

Infrastructure: UNIX (Shell Scripts), Informatica Powercenter 9.1, Netezza NPS/TWINFIN, Oracle, Teradata

Confidential

• Lead the effort of automating mapping generation and enhancing ETL environment of replicating the data warehouse from Oracle to Netezza platform
• Support existing ETL code include fixing defects, enhancing existing codes
• Research better replicating solutions on the market
• Automate job scheduling written in shell scripts
• Establish ETL development framework, documentation and enforce best practices

Confidential

• Modify k-shell scripts for database migration from Oracle to Teradata
• Update Tivoli job scripts for ETL load scheduling
• Update/modify Ab Initio graphs to accommodate database migration
• Work with off-shore team to ensure quality code delivery

Confidential

Datamart Informatica Lead

• Analyze source OLTP system (Jack Henry) and existing reporting ODS
• Convert the data in ODS into dimensional data mart with Informatica
• Design, develop essential building blocks for account analysis data mart
• Assist in designing staging and dimensional data model
• Mentor team members with ETL methodology and best practices
• Enforce data modeling and ETL standards and best practices

Confidential

ETL Architect and Informatica Lead

• Collect, analyze and document business requirements pertaining to data integration
• Architect enterprise data integration solutions and strategies
• Perform capacity planning on database and data integration
• Assess hardware and software in support of data integration
• Produce and document detailed ETL technical specifications and processes
• Design, implement and administer enterprise ETL architectures.
• Informatica suite Installation, configuration and administration(include security setup, backup/restore strategy, user implementation strategy)
• Design data models for staging, ODS and data marts
• Migrate data load processes onto Informatica platform
• Establish and enforce ETL and data modeling standards
• Mentor team members with ETL methodology and best practices
• Assist in establishing tasks and project scheduling
• K-Shell scripting to automate job scheduling and pre-process traffic data file
• Assist project manager in coordinating BI team resources to ensure quality system delivery

Infrastructure: Informatica 8/9 (High Availability and Grid), Oracle 11gR2, Sun Solaris, Cognos, ERStudio

Senior ETL Developer

Confidential

• Analyze technical requirement in Data Steward project
• Design; develop stored procedures for reference data access.
• Analyze, design background process for passenger and revenue reconciliation
• Develop process for manipulating hierarchical data.

Confidential

Senior ETL Developer

• Analyze the source from Basel II staging database and target XML format file
• Design ETL strategy for customer integration of AML group
• Document functional and nonfunctional requirement for ETL process
• Design, develop, unit test mappings and workflows to process source data to XML file
• Assist and mentor Basel II team on development

Confidential

Senior ETL Developer

• Design, test and deploy surrogate key generation strategy for parallel file processes in Enterprise Data Staging.
• Shell script maintenance job for stored procedures that is required in mapplet
• Populate calendar and fiscal time dimension tables for reporting purpose
• Document the mapplet and shell scripts

Confidential

ETL Developer

• Analyze source data from legacy systems, CRM and Financial system
• Architect data integration strategy, consolidate legacy transaction systems, CRM and Financial Management into PeopleSoft Enterprise Warehouse
• Design reporting strategy for Vender/Builder portal in PeopleSoft Enterprise Warehouse
• Establish and document standards for ETL and reporting implementation
• Design logical and physical data model for ODS and data warehouse

Confidential

Data Warehouse Consultant

• Collect data requirements, analyze various source systems
• Architect and document data flow processes
• Design, test, and implement ETL strategy
• Establish technical standards and practices
• Administer Informatica in development, testing and production environments
• Mentor other team members on Informatica practices

Confidential

• Identify and collect reporting requirements
• Analyze source structure serving reporting
• Architect reporting solution and document system design, data modeling
• Design universe, develop reports with BusinessObjects

Confidential

• Analyze legacy system, identify the requirements of ETL and reporting
• Design technical architecture for ETL and reporting with Informatica PowerCenter 4.7,T-SQL and BusinessObjects
• Design, test and implement ETL components
• Data modeling, assist reports and universe design
• Document design for ETL and reporting strategy

Confidential

Data Warehouse Consultant

• Analyze the data transfer requirements, design, test and implemented the data transfer programs with PL/SQL in the project of Earth Resources and Minerals Exploration and Land Information Ontario Data Warehouse on Sun Solaris 2.x
• Perform application performance tuning

Data Warehouse Consultant

• Demonstrate and create prototype data warehouse solution for prospects
• Educate clients with CA’s data warehousing solution
• Design detailed technical and business oriented presentation illustrating reasonable data warehouse solutions

Confidential

• Identify and analyze the business requirements for Enterprise Reporting, OLAP analysis
• Design and implement OLAP solution with InfoBeacon
• Design multi-dimensional and ODS model with ERWIN
• Design and implement ETL process with InfoPump and DecisionBase