SUMMARY:

• I am a highly experienced and capable IT professional with over 15 years of experience in Data Warehousing and Business intelligence.
• I am an expert at creating ETL solutions with Informatica and various database systems such as Oracle, SQL Server, Teradata, Netezza and others.
• I also experienced with Ab Initio development based on different components, working with multi - files system and developing graphs.
• I possess excellent troubleshooting and problem solving skills, and works well individually or in a team environment.

TECHNICAL SKILLS:

Development Languages: PL/SQL, Unix Shell scripts, Control-M, Autosys

Databases: Oracle 11g/10g/9i, Oracle Exadata, Teradata, Netezza, MS SQL Server 2005/2000

ETL: Informatica 9.6.1/9.1/ 8.6.1/8.1.1/7.1.3 /6.2 (Repository/Designer/Workflow Manager), Ab Initio 3.0.1.2

Reporting Tools: Cognos 8 (Report Studio/Query Studio/Analysis Studio), Cognos Impromptu, Cognos Transformer, Cognos PowerPlay

Data Modelling Tools: ERwin

Operating Systems: Unix, Linux, Windows NT/2000

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Warehouse Consultant / ETL Solution Designer

Responsibilities:

• Worked as ETL Solution Designer, ETL developer and “Data Integration Engineer”. Required cleaning up many incorrect Oracle packages, Stored Procedures, and other scripts in existing ETL process.
• Over 10 years of experience in using Informatica PowerCenter - Mapping Designer, Repository manager, Workflow Manager/Monitor. Extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experienced taking near-failure offshore project (worked over a year) back to local. Turning project status from "RED" back to "GREEN", and the project is delivered in 5 months.
• Responsible for project framework design (Such as Process Control, High volume data load and Error Handling) based on Informatica and oracle technology. Developing different POC for different framework.
• Involved in meetings with key stakeholders of the business and discussed on strategies and roadmaps for Informatica PowerCenter Grid implementation.
• Lead efforts to define and develop technical standards for data movement and transformation as well as review all designs to ensure those standards are meet. Provides guidance and expertise to resolve technical issues.
• As an Informatica lead consultant streamlined and tuned telecomm related ETL to be more efficient using Teradata and Oracle databases. Processing time for the business aggregation was reduced from 36 hours to 3 hours. Assist others in maximizing the usage of Informatica in ETL processes.
• Designed and implemented historical ETL load process to load high volume retail data (over 3TB) from DB2 ePOS transaction system to Netezza data mart.
• Designed high efficiency Ab Initio graphs to manipulate different high volume source files and load the data into the staging database in a narrow time windows .
• Developed Unix Shell Script and Netezza SQL scripts for retail ETL process.
• Used Tpump, Mload, Fload and BETQ scripts on Teradata for the ETL process.
• Developed Oracle PL/SQL packages and stored procedures to load data from source area to different data mart.
• Developed EReporting Data Warehouse, a data warehouse report system used for CIHI to generate analysis reports of Canadian Health Information from a variety of systems (DAD, CHRPS, CMDB and NACRS).
• Developed well-organized Control-M automating jobs which populate critical hourly data to Teradata data warehouse.

Environment: Informatica 9.6.1/9.1/9.0.1/8.6.1, Informatica Power Connect (VASM, Teradata TPT), Ab Initio 3.0.1.2, Unix, Oracle, DB2, Teradata, Control-M, Netezza, Autosys

Senior ETL Consultant

Responsibilities:

• Worked with the Data Warehouse development team as a Senior ETL Consultant and Data Analyst.
• Responsible for developing, enhancing, maintaining, and testing ETL processes, and provided production support for clients of Public Works and Government Services Canada.
• Developed HRRS Data Warehouse, a data warehouse report system used for PWGSC to generate analysis reports of employee/appointment/position data from a variety of systems (HRMS, LIMS, ITSS).
• Implemented Oracle SQL scripts to deploy new business in the Development, UAT, CERT and Production environment.
• Analyzed issues, provided time estimates for any system solution, and recommended resolutions for client's business requirements.
• Created Oracle dimension and fact tables (star schema).
• Developed SQL package and stored procedures to load data from source area to data warehouse area.
• Reviewed the procedures and methods used to manage the staging and production data feeds all through materialized views (replication).
• Delivered technology solutions within schedule, function and quality expectations.

Environment: Oracle 10g/9i, Cognos 8, TOAD 10.1/9.0, Unix, SQL

Senior Informatica Developer/Data Integration Consultant

Responsibilities:

• Completed ODS/BOSS Project, involved in delivering data in difference system such as WINS, TPA/MGA, ASPUC etc. In charge of implementation of ODS/BOSS Project. Jobs covered ACCOUNT, Submission, PRODUCER, PREMIUM, AP CHECK FEED, CARRIER FEED, etc.
• Interacted with business users to collect reporting requirements and prepared prototypes and received approvals from business owners.
• Delivered technology solutions within schedule, function and quality expectations.
• Analyzed issues, provided time estimates for any system solution, and recommended resolutions to client issues.
• Developed technical specifications based on the preferred and chosen solutions.
• Supported the ongoing development and maintenance of the enterprise wide critical systems in a mission critical environment.
• Tested and validated data on ReportNet reports as well as Cognos cubes.

Environment: Informatica PowerCenter 8.6.1/8.1.1/7.1.3, Informatica PowerConnect for MQ Series, Cognos 8, TOAD 9.0/8.0, Oracle 10g/9i, AS400 Mainframe

ETL Consultant

Responsibilities:

• Developed ETL mappings to extract and cleanse data from the staging area to the data presentation area with Informatica PowerCenter 7.1.2.
• Implemented unit test cleansing processes and adjusted mapping rules.
• Created various Cognos Impromptu reports for supporting business needs, collected feedback and monitored usage and satisfaction, and published reports to the web.
• Trained Cognos PowerPlay end users in creating business reports based on the generated cubes and drill down/up, slice and dice reports, and produced monthly, quarterly and ad-hoc reports for the sales department.

Environment: Informatica PowerCenter 6.2.2/7.1.2, Informix, AS400 Mainframe, SQL

Database Developer

Responsibilities:

• Created reports using Cognos and automated scripts to validate the integrity of the data based on end user needs.
• Developed ETL scripts to extract and cleanse data from SQL databases for loading into Cognos.
• Migrated different databases to the MS SQL Server database using Data Transformation Service tool (DTS).

Environment: Oracle, MS Access, MS SQL Server, Cognos

Database Developer

Responsibilities:

• Installed and maintained various system software and database systems such as Windows NT, and MS SQL Server.
• Developed a report design system, using SQL and PowerBuilder on a Windows based system.
• Designed and developed database applications on a SQL Server system with T-SQL.

Environment: MS SQL Server, Windows NT, SQL, PowerBuilder