SUMMARY:

• Having 10 years of experience in the field of Data Warehousing.
• Experience in client server Applications Design, Development, Implementation, Upgrade and Maintenance.
• Strong knowledge in OLAP Systems, Kimball and Inmon methodology and models, Dimensional modeling using Star schema and Snowflake schema.
• Extensive experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center Tools (Repository Manager, Designer, Workflow manager, Workflow Monitor and Informatica Administrator Console).
• Good experience in Data Cleansing, Data profiling and Data Analysis.
• Have experience working in all phases of SDLC utilizing Agile and Waterfall methodologies.
• Excellent knowledge and experience in Technical Design and Documentation.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions and Packages in distributed environment.
• .Net MVC is a model for building web applications using a MVC (Model View Controller) design.
• Utilize MicrosoftSharePointDesigner to develop workflows and customized functionality to meet business needs
• Assist with business process analysis and informal training on MicrosoftSharePointwith staff and clients
• Develop an understanding of internal processes and procedures and assist with making improvements
• Provide updates and advice on business processes and MicrosoftSharePoint - based solutions
• Excellent knowledge and experience in Technical Design and Documentation.
• Experience in PERL and UNIX Shell Scripting (Korn & Bourne) on UNIX & Linux platform.
• Involved in Performance tuning of Informatica mappings and sessions.
• Provide on-call support to production system to resolve any issues.
• Good exposure to development, testing, debugging, implementation, documentation, user training & production support.
• Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.
• Excellent skills in understanding business needs and converting them into technical solutions and easily adaptable to any new Technologies and Business environment.
• Experience in the migration of Informatica, Datastage and other ETL components to different environments.
• Working on Hadoop Hive and Impala for processing large scale data processing.
• Have experience leading the team and mentoring the junior team members.
• Excellent analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX

Prog. Languages: C, JAVA, Visual Basic, K-Shell, SQL, PL/SQL, Perl, .Net

Databases: Oracle 11g/10g/9i/8i, Sybase 12.5.2, DB2,MS Access, Main Frames

Tools: Toad, Embracedo DBArtisan, UC4, Humming Bird Exceed, Erwin, BOXI R2, Mercury Quality Center, MS Office, Putty, Hadoop.

ETL Tools: Informatica 7.x/8.x/9.x, PowerExchange, Metadata Manager

Version Control Tools: Microsoft VSS, Tortoise GIT, Perforce

EXPERIENCE:

Confidential, Chicago, IL

Lead Consultant

Responsibilities:

• Interact with Business, understand the requirements and then design the technical workflow to reach to the desired solution using Informatica Power Center 8.x/9x, Business Objects XI R3, Toad.
• Translating the business processes into ETL mappings for building the data marts.
• Leading and handling an offshore team responsible for understanding the data model, complex data analysis and designing complete solution for the purpose of client reporting.
• Support the daily running processes and answer user related queries.
• Conducting Reviews, Unit and System Testing to ensure good data quality for the data marts and reports.
• Experience with web development including ASP.Net, JavaScript, and AJAX
• Worked on different source systems like Mainframes, Xmls, Oracle, Flat Files.
• Doing sufficient project documentation so that it helps in the smooth functioning and serving as a knowledge base for new resource joining the project.
• Sending out release notes describing all the details around the deliverables so that the testing team and others have a clear picture on the same.
• Coordinating with other upstream and downstream data teams to ensure a smooth channel of communication between related groups.
• Developing reports in line with functional requirements using the Business Objects tool set.
• Creating high and low level design documents.
• Mentoring team mates with the business knowledge.
• Mitigating the risks and meeting the deadlines of the deliverables.

Environment: Informatica PowerCenter 8x/9x, Informatica Web Services, UNIX Shell, Oracle 10g/11g/Exadata, Toad, SQL Developer,XMLs Jira, HP Quality Center,.Net, Sharepoint, UC4, Windows 7.

Confidential

Lead Consultant

Responsibilities:

• Taking a lead in interaction with end-users and functional analysts to identify and develop business requirements and transform it into technical requirements
• Mentoring team mates with the business knowledge.
• Review project deliverables for completeness, quality, and compliance with established project standards.
• Mitigating the risks and meeting the deadlines of the deliverables.
• Translating the business processes into Informatica mappings for building the data marts.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage and ODS.
• Experience in C# programming language,Experience inASP.NET,
• Experience producing technical documentation related to requirements, specifications, traceability matrices, designs, or testing,
• Involved in Performance tuning at source, target, mappings, sessions and system levels.
• Support the daily running processes and answer user related queries.
• Creating tables, triggers and stored procedures to load the related data.
• Experience in Logical database design, data modeling using Erwin tool.
• Using Debugger to gain troubleshooting information from the mappings.
• Testing the data among various sources and targets.

Environment: Informatica 8.1.1, Oracle 10g/Exadata, UNIX, Autosys, Erwin, Windows XP.

Confidential

Consultant

Responsibilities:

• Worked on Dimensional modeling to Design and develop STAR Schemas, used ERwin, identifying Fact and Dimension Tables.
• Translating the business processes into Informatica mappings for populating the data marts.
• Worked with different Operation Data Sources such as Oracle, SQL Server and Legacy Systems, Excel, Flat files,XMLs. Used Informatica to extract data into Data Warehouse.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations to facilitate Daily, Monthly and Yearly Loading of Data.
• Using various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Router, Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer
• Involved in Unit and Integration Testing of the system.
• Preparing documentation of the entire technical process. Describing, Designing, development and testing.
• Responsible for Quality related work items using tools such as Perforce and VSS and Defect Management using tools such as Quality Center (QC).
• Installed and Configured Informatica 8x and migration of objects from 7x to 8x.
• Optimized the mappings by changing the logic and reduced running time.
• Using Debugger to gain troubleshooting information from the mappings.
• Involved in Production Support of the daily Batch runs.
• Used Business Objects 6.5/XI R2 to create ad hoc reports.
• Used Autosys and Informatica Scheduler for scheduling the batches.

Environment: Informatica 7.1.3/8x, Oracle 10g, Sybase 12.5, DBArtisan, UNIX, Autosys, BO XIR2, B.O 6.5, Quality Center, Perforce, Erwin.

Confidential

Software Engineer

Responsibilities:

• Used Informatica Power Center 7.1.2 for migrating data from various oltp servers/databases to the datawarehouse.
• Worked on Dimensional modeling to Design and develop STAR Schemas, used ER-win, identifying Fact and Dimension Tables.
• Translating the business processes into Informatica mappings for populating the data marts.
• Worked with different Operation Data Sources such as Oracle, SQL Server and Legacy Systems, Excel, Flat files,XMLs. Used Informatica to extract data into Data Warehouse.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations to facilitate Daily, Monthly and Yearly Loading of Data.
• Using various transformations like Source Qualifier, Filter, Expression, Sequence Generator, Router, Update Strategy, Joiner, Stored Procedure and Lookup to develop robust mappings in the Informatica Designer
• Involved in Unit and Integration Testing of the system.
• Preparing documentation of the entire technical process. Describing, Designing, development and testing.
• Installed and Configured Informatica 8x and migration of objects from 7x to 8x.
• Optimized the mappings by changing the logic and reduced running time.
• Using Debugger to gain troubleshooting information from the mappings.
• Involved in Production Support of the daily Batch runs.
• Informatica Scheduler for scheduling the batches.

Environment: Informatica 7.1.2, Oracle 9i, Windows, Unix

Confidential

Consultant

Responsibilities:

• Involved in the design, development and implementation of the supply chain datawarehouse process and data mart, used Informatica Power Center 7.1.2 for migrating data from various oltp servers/databases to the dwh.
• The data migration included identifying various databases where the information/data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Used relational sources and flat files to populate the data mart.
• Translated the business processes into Informatica mappings for building the data marts.
• Created complex Informatica mappings to load the data mart and monitored them.
• The mappings involved extensive use of transformations like aggregator, filter, router, expression, joiner, sequence generator.
• Configured the mappings to handle the updates to preserve the existing records using update strategy transformation.
• Used debugger to test the mappings and fix the bugs, conducting unit testing.
• Prepared source to target field level document and high level design document.
• Environment: Informatica 6.2, Oracle 8i, Windows