SUMMARY

• Confidential is a senior technical consultant with eleven years of consulting experience in leading global delivery teams, crafting Systems Integration, Data warehousing, and Business Intelligence solutions.
• As a team leader, subject matter expert, business analyst, ETL architect, designer and developer, Confidential has provided thought leadership and delivery excellence on several client engagements that involved requirements gathering, solution outlining, solution design and implementation.
• Successfully delivered IT solutions to the Insurance, Pharmaceuticals, Manufacturing and health care, Energy industries.
• Expertise in Enterprise Data Management, managing the Enterprise DW project from planning to production implementation, with emphasis on business requirements, analysis, design, development following the quality process and Methodologies.
• Expertise in gathering User Requirement and creating Use cases, ability to translate business needs into technical requirements and apply multiple technical solutions to business needs, performed various system and data analysis techniques and maintain client standards.
• Performed data profiling, data analysis and data integration, applied various data cleansing/validation rules, implemented data standards and architecture/designed the relational and BI models for OLTP and OLAP (dimensional modeling) environment.
• Proven expertise in designing and solving complex data design and data retrieval/integration issues.
• Expertise in handling Metadata data management for Global Metadata Architecture and repositories by maintaining industry policies and standards.
• High experience in tuning, data retention, data recovery and archiving/purging the data.
• Highly proficient in writing UNIX shell scripts, ETL tools and PL/SQL queries applying proper tuning techniques, executing test scripts for verifying the Source - To-Target mapping, Data loading and Data presentation. Designed and executed multiple batch processing application to server different complex systems.
• Excellent leadership, organization and communication skills with both internal and external clients.

TECHNICAL SKILLS

Languages: Unix Shell Scripting,C,C++,J2EE,Perl, Awk.

ETL Tools: Informatica Power Center 6.x/7.x/8.x/9.x, Power Exchange for Mainframes, Data Stage, Talend Integration Services, Power Exchange for SAP.

Databases: Oracle Database Technologies, DB2 Database Technologies, SQL Server Database Technologies, TeraData Database Technologies, MS-Access.

Reporting: Business Objects (Designer 5.0, Supervisor, Reporter & WEBI), Cognos 8

Job Scheduler: Autosys, Control M and Informatica.

PROFESSIONAL EXPERIENCE

Confidential

ETL ARCHITECT/DESIGNER

Responsibilities:

• Performed User requirement analysis and extensively interacted with the business clients.
• Actively involved in the ETL Architecture and modeling discussion of the EDW/Foundation layer.
• Extracted data from SAP BW Extractors using Informatica Power Exchange.
• Designed and developed the Audit Balance and Control load and reject strategy.
• Performed Data volumetric analysis of each source system to design the load balance mechanism.
• Designed and developed the ETL load strategy for optimal load performance.

Environment: Informatica Power Center 9.1, Oracle 11g, SQL Server 2008 R2,Visio, Erwin, SharePoint.

Confidential, NEW JERSEY

SENIOR ETL CONSULTANT

Responsibilities:

• Consolidate User requirements into mapping rules.
• Lead the effort to individually understand different universities data and how it fits into the warehouse.
• Develop Talend mapping templates for reusability.

Environment: Talend, Oracle 11g, Shell Scripting.

Confidential, LOS ANGELES

ETL LEAD ARCHITECT

Responsibilities:

• Heavily involved in ETL Architecture, Design, Development and Implementation.
• System Study and Data Analysis for finalization of truth of source from across the systems.
• Performed Data profiling and gap analysis per the project requirements.
• Developed ETL process specifications.
• Designed/Developed Audit, Balance, and Control process and Tables (ABC).
• Developed and maintained the Erwin model both physical and logical models.
• Developed Stored procedures for complicated ETL processes.
• Extensively worked on Informatica Partitioning for optimal usage of the CPU and the Network.
• Performance fixes on the database and Informatica.
• Preparing environment for development and test bed for system testing.
• Conduct the end user meetings for the project certification.
• End to End project documentation

Environment: Informatica Power Center 8.6.1,9.1, UDB DB2 BCU, Shell Scripting, Oracle 10g.

Confidential, SAN FRANSCISCO

ETL ARCHITECT/DESIGNER

Responsibilities:

• Involved in data architecture and data modeling discussion, decision-making, and implementation sessions.
• Designed the ETL process optimally based on the client’s limitations.
• Extensively profiled Source Systems for specific patterns.
• Lead the effort in designing and implementing the ETL solution to feed external systems.
• Created Deployment Groups for code migration.
• Extensively worked with Data Profiling (with Data Explorer) of Source Systems to get specific Data Patterns.
• Extensively worked with Data Cleansing of source data.
• Extensive Collaboration with the users to get the business requirements.

Environment: Informatica Power Center 8.6.1, UDB DB2 BCU ver(9.1), Oracle 11g, SQL Server, Unix Shell Scripting, Visio, Erwin, SharePoint. Perl.

Confidential, NEW JERSEY

ETL ARCHITECT/LEAD

Responsibilities:

• Designed the detailed ETL Architecture and implemented Informatica mappings to support loading the data warehouse.
• Involved in data architecture and data modeling discussion, decision-making, and implementation sessions.
• Designed the Change Data Capture (CDC) to pull incremental data from the Source systems.
• Designed Autosys JIL scripts to schedule the workflows and their dependencies.
• Involved in Administration and migration activities of Informatica.
• Extensively written stored procedures for source to target system load validation.
• Resolved Performance bottlenecks on the database and Informatica sides.
• Generated feeds to the downstream systems.

Environment: Informatica Power Center 8.6.1, Oracle 11g, SQL Server 2008, Cygwin,Visio, Erwin, MetaData Reporter, SharePoint.

Confidential, PHILADELPHIA

ETL ARCHITECT/DESIGNER

Responsibilities:

• Designed the detailed ETL Architecture and implemented Informatica mappings to support loading the data warehouse, complete with reusable mappings for Primary Keying, Foreign Keying and reprocessing of data to handle delays in any parent/reference tables.
• Conversion of Legacy System Replacement into Enterprise Data Warehouse.
• Involved in modeling claims Subject Area of Data warehouse and Data marts.
• Involved in data architecture and data modeling discussion, decision-making, and implementation sessions.
• Lead the effort in designing and implementing the ETL solution to feed external accounting and book-keeping systems.
• Data integration consulting for Insurance industry client specializing in Worker’s Compensation system on the claims side and also handling conversion data for the legacy Claims Data Warehouse.
• Designed Power Exchange Data maps for Main Frame Files using cobol copy books.
• Analysed Legacy Cobol Programs to convert them into Informatica Mappings.
• Designed Autosys JIL scripts to schedule the workflows and their dependencies.
• Extensively written stored procedures to convert data type from EBCDIC to ASCII and sequencing transactions.
• Manipulated Files using Perl.
• Extensively worked with Data Cleansing of source data.
• Extensive Collaboration with the users to get the business requirements.
• Generated Performance/MetaData Reports using MetaData Manager.

Environment: Informatica Power Center 8.6.1, Power Exchange for MainFrames, Cobol, UDB DB2 BCU ver(9.1), Oracle 11g, SQL Server, Unix Shell Scripting, Visio, Erwin, MetaData manager, Informatica Data Explorer 8.5, Informatica Data Quality 8.6, SharePoint. Perl.

Confidential, LOS ANGELES

ETL DESIGNER

Responsibilities:

• Developed ETL process specifications.
• Extensively worked on Audit, Balance, and Control Tables.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment

Environment: Informatica Power Center 8.1.1, UDB DB2 ver(8.2),UNIX (AIX-5.1), Shell Scripting, DB Artisan, MS-Access, SQL Optimizer, Clear Case, Cognos .

Confidential, LOS ANGELES

ETL TECHNICAL LEAD

Responsibilities:

• Heavily involved in ETL Architecture, Design, Development and Implementation.
• Extensively Worked on Trillium data quality tool.
• Coordinating off shore teams and implemented Code migration scripts.
• Extensively worked on meta-data repository tables for Error Handling.
• Created shell scripts for process automation and dynamic parameter files

Environment: Informatica Power Center 7.2.1, UDB DB2 ver(8.2),UNIX, Trillium V6,Test Director, XML, Shell Scripting, Oracle, Autosys,J2EE7 IBM MQ Series.