SUMMARY

• Informatica Certified Professional ( Informatica Power Center 8.x) with hand on experience of Informatica Tools (Power Center / IDE / IDQ / DVO version 9.1)
• 10+ years of experience working in Information Technology Industry in different Business Sectors (Financial / Retail / Communication / Travel / Healthcare).
• 2 + year of experience working on Datawarehouse project in the capacity of a Project Manager / Technical Project Lead.
• 7 + years of experience in Datawarehouse projects involving Oracle/PL/SQL, Confidential, Unix/Informatica/Cognos.
• Experience in working with data warehouses and data marts using Informatica PowerCenter (Designer, Repository Manager, Workflow Manager, and Workflow Monitor) / Informatica Data Exchange / Informatica Data Quality.
• Fully conversant with all the Extraction Transformation Loading (ETL) methodologies.
• 3+ years of Data Modeling experience using ERWIN 3.x / 4.x, Confidential PowerDesigner 9
• Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables as well as Relational Models in 3NF)
• Conversant with all Three types of Slowly Changing Dimensions (SCD)
• Experienced with Informatica PowerExchange (5.x/8.x) for Loading / Retrieving data from mainframe systems.
• Experienced with Informatica Data Exchange / Informatica Data Quality tools for Data Analysis / Data Profiling and Data Governance.
• Extensive Unix Shell Scripting knowledge and experience.
• Extensive experience with relational databases (Oracle 8i/9i/10g, Sql Server 2000/2005, Confidential IQ, UDB/DB2).
• Experienced with IBM COGNOS Series 7/8 Products (Framework Manager / Report Studio).
• Reliable, responsible, hardworking and good team player.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter (6.x/7.x/8.x/9.x), MS SSIS 2005 / 2008

OLAP tools: COGNOS 8, OBIEE 9.x, BusinessObjects

Data Profiling: Informatica Data Quality, Informatica Data Exchange

RDBMS: Oracle, MS SQL Server, Confidential, DB2/UDB

Languages: J2EE, JSP, SQL, PL/SQL, HTML, XML, VB.NET

OS: UNIX/Solaris, Linux, Windows

Tools: Autosys, Erwin, MS Project, MS Visio, Serena ChangeMan Confidential PowerDesigner 9, Informatica PowerChannel, CVS, Embarcadero ER Studio

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. Datawarehouse Architect

Environment: Informatica Power Center 8.x/9.x, Oracle 11g, MS SQL Server 2005/2008 R2, Autosys 4.5/11, UNIX, Linux, Tortoise SVN, Informatica IDQ / IDE / DVO.

Responsibilities:

• Working as Senior Systems Analyst in the Investment Technology (Fixed Income & Equity) team.
• Working as a Lead Architect / Technical Lead on a Fixed Income Financial application using a multi - tier architecture. The application will save the company 1.5 Million dollars over next 5 years.
• The project was highlighted in an article on Morning Star. for which I was nominated as Employee of the Year .
• Worked on converting vendor based system into in house tool to save the company 25 thousand dollars each month.
• Work directly with the Business and the Business Analysts to understand the business requirements and document and effectively communicate to the team.
• Worked as an ETL Lead on the Informatica Upgrade Project from version 8.6 to 9.1.
• Senior member of Integration Competency Center (ICC) that oversees Architecture and Design Standards for the entire corporation.
• Mentor the Junior ETL Developers; organized formal Brown Bag Sessions to cover various topics of Data Warehousing / Informatica.
• Worked as a Lead ETL Architect on a couple of projects visible to Executive Committee of Janus.
• Created the complete ETL Architecture, including Load Strategies of acquiring the data from various internal / external sources, staging and massaging the data and loading them into the target Dimensional Data mart using a multi-tiered Architecture.
• Designed Error Handling / Reporting strategies at each tier of data load.
• Created Documentation Templates for ETL Design and Production Turnover.

Confidential, Aurora, CO

Lead ETL Architect - Consultant

Environment: Informatica Power Center 8.6.1, Oracle 10g, UNIX, TIVOLI, FTP, Mapping Architect for Visio (MAV), HL7, J2EE.

Responsibilities:

• Worked as the Lead ETL Architect for the CRDS program.
• Participated in design of the overall ETL Architecture, including Load Strategies of the data from Source to Target using multi-tiered Architecture.
• Designed Error Handling / Reporting strategies at each tier of data load.
• Extensively used Mapping Architect for Visio (MAV) to create Reusable, Repeatable pieces of code that increased the turnaround for the developers to create mappings in Informatica PowerCenter 8.6.1.
• Designed and Developed ETL Workflows using Informatica PowerCenter 8.6.1 and UNIX.
• Worked closely with the QA / System Testing teams to create test data and define Testing Strategies. Involved in Presenting the QA / System testing team with the detailed walk-through as well as overlooking the QA Testing effort in the capacity of the ETL Architect.
• Conduct design / code / test plan reviews with other developers and the team lead.
• Present ETL Architect / Best Practices to the freshly trained Informatica Developers at KP.
• Involved in interviewing and hiring process of the new consultants.

Confidential, Southlake, TX

ETL Team Lead - Consultant

Environment: Informatica Power Center 8.5, Teradata 11.x, Oracle 10g, COGNOS 8, UNIX, VersionOne, MS SharePoint

Responsibilities:

• Presently working as the ETL Team Lead / Developer in the BI/DW group, managing a team of onsite and off-shore developers.
• Concurrently worked on two successful projects for TPN Clients, BoA and CapitalOne as ETL Team Lead, managing a team of 4 and 3 developers for the each effort.
• Responsible for creating and maintaining project plans using Agile VersioOne, managed documentation using MS Sharepoint
• Maintain documents for Risks, Assumptions, Issues and Decisions and ensure effective communication within the team as well as different groups participating in the project.
• Developed several ETL scripts using Informatica PowerCenter 8.5, BTEQ, UNIX Scripts to load data from various systems to the Datawarehouse in Teradata.
• Worked with other members to establish and document Informatica Best Practice and Standards for the BI/DW group.
• Participated with the Clients / Business Users, BI Architects and BSA’s to facilitate and streamline Business / Technical Requirements process.
• Conduct design / code / test plan reviews with other developers and architects.
• Mentor Junior Informatica Developers in and outside the group.
• Directly involved in the hiring process of the new team members.

Confidential, San Francisco, CA

ETL Team Lead - Consultant

Environment: Informatica Power Center 8.x, Informatica Power Exchange, DB2/UDB, Oracle 10g, Trizetto Facets 4.6

Responsibilities:

• Worked as ETL Team Lead in the Shield Advance project responsible for Design and Implementation of Sales Management Reporting, Claims Daily and Claims Weekly Data Marts, implementing Trizetto Facets to replace the Legacy System.
• Responsible for ETL Resource Management of 5 developers including assigning tasks, conduct bi-weekly status meetings, maintaining the project RAID Document.
• Responsible for implementing and maintaining a project plan using MS Project for the above mentioned components.
• Conducted meetings with the Business User to identify Business Requirements and translate them to Technical Design Documents. .
• Designed and Developed ETL scripts using Informatica PowerCenter 8.5, Informatica PowerExchange 8.5 to source data from Trizetto Facets into the Rosetta Data Marts
• Further involved in mentoring the Junior Informatica developers.

Confidential, Cleveland, OH

Project Manager / Technical Project Lead / Lead ETL Developer - Consultant

Environment: Informatica Power Center 7.x / 8.x, Informatica Power Exchange, Informatica Power Channel, Informatica Data Quality Tool, Informatica Data Exchange, OBIEE, DB2/UDB, Oracle 9i/10g, MS SQL Server 2000/2005, UNIX, NDM, Serena, Autosys

Responsibilities:

• Worked as a Project Manager on Enterprise Data Warehouse project. The project was to build an enterprise wide data warehouse for the enterprise.
• Responsible for implementing and maintaining a project plan using MS Project, reporting weekly progress and monthly budget report/Burn rate/Projections to the management.
• Maintain a document for Risk Assumptions Issues Decisions (RAID) and ensure effective communication within the different groups participating in the project.
• Being ETL Lead / Senior ETL Architect of Informatica Center of Excellence group, responsible for handling various IS request for ETL services throughout Confidential ’s six portfolios.
• Involved in various projects; large to small at various levels in various capacities.
• Responsible for solutions analysis, ETL architect and conducting Informatica / Database / UNIX script reviews as well as co-coordinating the effort between different groups.
• In charge of On-site and Offshore development co-ordination, approval of work packets for offshore development that includes ETL design and test scripts.
• In charge of conducting design reviews / code reviews / test plan reviews with other developers and architects.
• Conducted POC for Informatica PowerExchange, Informatica Data Quality and Informatica Complex Data Exchange.
• Developed several ETL scripts using Informatica PowerCenter 7/8, Informatica PowerExchange 5/8 and Informatica PowerChannel. 8.x
• Developed Plans against Accuracy Rules using Informatica Data Quality 8.6 and integrated them with Informatica PowerCenter.
• Created handy documents on Informatica PowerExchange, Informatica Best Practice, Performance Tuning and Discovering Bottlenecks in Workflows.
• Responsible for presentations on Informatica COE services and Informatica Suite

Confidential, PA

Team Lead / Senior ETL Consultant - Consultant

Environment: Informatica PowerCenter 6.3, Oracle 9i, Erwin 3.5, PL/SQL, UNIX, Trade Stone Suite.

Responsibilities:

• Worked on the project as the Team Lead; involved in all the phases of project, starting from requirement analysis to production support.
• Analyzed and Reverse Engineered Freights and Logistics Warehouse for AE. Produced Detailed Design Documentation for the complete system.
• Conducted presentations with the management team to explain the derived business logic and participated in working sessions to finalize the Business and Data requirements for the new system.
• Re-designed the ETL Solution for AE Freight and Logistics System to implement with new requirements for AEO new brand - ‘Martin + Osa’
• In charge of architecting and approving application infrastructure design, conducting Informatica / Database / Unix script reviews, and aligning technical efforts.
• Created Technical Design Documents for various components within the main system (Shipping, Receiving, Freight Forwarders / Consolidators, Customs).
• Modeled a conceptual / logical database for the above mentioned components of the M+O system, designed tables, indexes and defined relations using Erwin.
• Designed and developed ETL scripts in Informatica PowerCenter 6.x for loading data into the Relational Oracle Database.

Confidential, St. Petersburg, FL

Datawarehouse / ETL Developer - Consultant

Environment: Informatica Power Center 7.1. Confidential IQ, Confidential Power Design 9.0, Oracle 9i, UNIX, Windows NT 4.0, CVS, First Logic, Micro Strategy.

Responsibilities:

• Worked on the project as a Senior Datawarehouse Consultant, was involved in fine-tuning the Confidential Industrial Warehouse Structure (IWS), design new ETL mappings and fine tune the existing ones.
• Used Confidential PowerDesigner 9 to modify existing warehouse designed in Dimensional Model (Star-Schema) based on client’s requirements.
• Foremost assignment was to Fine Tune existing Informatica sessions which took huge amount of time to complete. Optimized the jobs to between 60 to 70 % faster execution time.
• Designed and developed several ETL scripts using Informatica PowerCenter 7.1
• Worked on Custom Transformation Package (First Logic) for address verification and address cleansing.
• Worked extensively with the business users to gather and document requirements, perform analysis and update the Logical and Physical Data Models.
• Created UNIX Shell Scripts to use with Informatica Pre / Post Session Commands.

Confidential, Atlanta, GA

Sr. Systems Analyst

Environment: C#.NET, VB.NET, ASP.NET, MS SQL Server, Erwin 3.5, Autosys, CVS, Windows NT 4.0, Crystal Reoprts

Responsibilities:

• Worked on the complete project life cycle, including Analysis, Design, Development, Testing and Deployment of the product.
• Involved with the BDA/DA teams to visit local facilities to understand business / data requirements and create Solution Architect for the Software Package.
• Designed UI Screens and Web Forms using VB.NET / ASP.NET.
• Created and Unit Tested program logic and code using .NET components and Crystal Reports to create an Integrated Software Package.
• Created User Manuals and training materials for clients.

Confidential

Systems Analyst

Environment: Oracle 8i, MS SQL Server, MS .NET, Erwin 3.x, UNIX Shell scripting, Autosys

Responsibilities:

• As a Systems Analyst, worked on various development projects using .NET for the UI / Forms and Oracle / MS SQL Server as the data repositories.
• Worked on the complete project life cycle, including Analysis, Design, Development, Testing and Deployment of various projects / products.
• Responsible for Production Support for the Human Resource Management System and Accounts / Payroll Management System.
• Responsible for providing Support during regular work hours as well as on-call Support for after hours issues.
• Responsible for Code Development / Unit testing for the Design Algorithms created by the System Architects.
• Created Stored Procedures and Functions in Oracle 8i.

Confidential

Systems Developer

Environment: Oracle 7, C/C++, Visual Basic 6. Foxpro, Windows NT

Responsibilities:

• Part of the Confidential MIS department
• Team-member of the in-house software development team
• Assisted the DBA in design and development tasks