SUMMARY:

• Senior data warehouse consultant with over 20 years’ data warehousing experience specialized in data integration (ETL) and data presentation; Over 20 years’ consulting experience in various industries; 18 years’ experience with Informatica PowerCenter in terms of architecting, development and administration; Proven effectiveness in teamwork and supervisory experience; High rate of success and client satisfaction through the development life cycle; Outstanding troubleshooting and problem solving skills

TECHNICAL SKILLS:

Technology and Tools: Informatica PowerCenter, Informatica Cloud, Informatica EIC/EDC, Informatica PowerExchange, Oracle, PL/SQL, Teradata, MS SQL Server, T - SQL, DB2, Cognos, BusinessObjects, ERWIN/ERStudio, UNIX/LInux, Shell/Perl scripting, Data Modeling, Dimensional modeling, AWS Cloud Computing, Informatica BDM, Hadoop(Spark/PIG//Hive)

PROFESSIONAL EXPERIENCE:

Sr. Data Integration Lead/Architect

Confidential

Responsibilities:

• Design Business Intelligence/Data Warehouse solutions to achieve business goal or customer engagements through in-depth analysis, coordination and negotiation with key decision makers.
• Apply 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
• Hands-on expertise of Installation, Administration, Upgrade on Informatica product
• Provide strong, visible leadership to a team of Informatica developers
• Administer and optimize the existing InformaticaETL implementation and providing guidance and operational support.
• Develop and enforceETLdevelopment standards and best practices
• Lead theETLteam and guide on best design principles and implementation methodologies
• Support software upgrades, software documentation, research of new software versions
• Define and review procedures to performETL 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
• Implement Informatica Metadata Manager with business glossary

Confidential

Responsibilities:

• 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 and document
• 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

Confidential

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

ETL Architect and Informatica Lead

Confidential

Responsibilities:

• 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

Senior ETL Developer

Confidential

Responsibilities:

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

Senior ETL Developer

Confidential

Responsibilities:

• 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

Senior ETL Developer

Confidential

Responsibilities:

• 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

ETL Developer

Confidential

Responsibilities:

• 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
• 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
• 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
• 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

Data Warehouse Consultant

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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
• 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

Technical Consultant

Confidential

Responsibilities:

• Deploy, configure and install reporting software.
• Install, configure and administer Oracle database 7.1 on DEC ALPHA OpenVMS 6.x and DEC UNIX with DECNET and TCP/IP
• Plan database capacity and physical layout includes rollback segment, temporary segment, control file, and redo log file
• Monitor system performance, user session, CPU and memory usage, disk space usage with Oracle Enterprise Manager and command line utilities
• Create database objects, such as tables, views, database links, synonyms and triggers
• Perform database and application tuning
• Convert and migrate system data with PL/SQL and PRO*C
• Maintain databases with export/import, backup/restore