SUMMARY

• Over 8 years of strong IT experience in analysis, design, development and testing client server environment with focus on Data Warehousing application using tools like Informatica Power Center 9.x/8.x/7.x/6.x, Business Objects with Oracle, SQL Server databases and IDQ.
• Involved in Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Strong Data Warehousing ETL experience of using Informatica 9.6.1/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experience in using ETL methodologies for supportingDataExtraction,DataMigration, Data Transformation and loading usingInformaticaPower center 9.x/8.x/7.x/6.x, IDQ and Trillium.
• Performed the data profiling and analysis making use of Informatica Data Quality (IDQ).
• Experience working on Informatica transformations like normalizer, Lookup, Source Qualifier, Expression, Aggregator, Sorter, Rank and Joiner.
• Experience in SQL, PL/SQL, T-SQL and UNIX shell scripting.
• Strong Experience in managing offshore and onsite resources.
• Experienced in developing meta-data repositories.
• Practical understanding of theDatamodeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases
• Closely worked with business users in order to develop reports according to user requirements.
• Strong experience in Informatica Data Quality (IDQ), creating data profiles, custom filters, data cleansing and developing score cards.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server, DB2 8.0/7.0, UDB, No SQL Databases, Mongo DB, MS Access and Teradata
• Strong experience in writing complex SQL Queries, Stored Procedures and Triggers.
• Experience in Agile/Scrum, TDD and BDD methodologies
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent problem solving and analytical skills, committed team player with multitasking capabilities.
• Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms

TECHNICAL SKILLS

Operating Systems: Linux, Unix, Android, iOS, Windows 2010/2008/2007/2005/ NT/XP

ETL Tools: Informatica Power Center 9.x/8.x/7.x (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatic Server), IDQ

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2/UDB, Mongo DB, Teradata

Data modeling tools: Erwin, MS Visio

Languages: Java, JavaScript, HTML, Perl, SQL, PL/SQL, UNIX, Shell scripts, C++

Scheduling Tools: Autosys, Control-M

Tools: Selenium, QTP, Win Runner, Load Runner, Quality Center, Test Director, TOAD

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Informatica Developer

Responsibilities:

• Involved in gathering requirements, creating functional specifications, Created High Level Design, Detail level Design documents and participated daily stand ups.
• Designed and developed very complex mappings to integrate and validate data from various data sources and third party source systems.
• Imported mapplets and mappings fromInformatica (IDQ) to Power Center.
• Designeddatamodeling with team as per the requirement.
• Used forward engineering to create a PhysicalDataModel with DDL that best suits the requirements from the LogicalDataModel.
• Used Informatica Designer to create, Load, Update mappings using different transformations to move data to different data marts in Data Warehouse.
• Designed Informatica Mappings and Workflows to be re-startable after a failure.
• Developed data profiles, custom filers and score cards using IDQ.
• Developed error handling mechanisms to capture critical errors and send out e-mails to designated users in the distribution list.
• Design, Development and implementation ofdataload anddatavalidation processes using MS Access and SQL Server.
• Performed Unit testing, System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Involved in Informatica object migration from DEV to UAT to PROD repositories.
• Involved in various performance tuning techniques to reduce the execution time and memory usage while maintaining the data quality.
• Provided KT sessions to the customer upon migration to PROD.
• Precisely documented at every phase of the SDLC.

Environment: Informatica Power Center 9.6.1, IDQ, Oracle 11i/10g, Linux, Shell Scripts, Tableau, Windows XP Prof, SQL, PL/SQL, TOAD, Microsoft Visio & UNIX.

Confidential - Winston-Salem, NC

Informatica/ETL Developer

Responsibilities:

• Involved with business and product development teams to get the functional requirements and specking out the Technical Requirement Documents for thedataconversion.
• Involved in Full project life cycle (requirements gathering to implementation phase).
• Involved in Data Cleansing and Data Integration of the various data sources into one single Datamart (ASD).
• As an ETL consultant designed, developed and tested 100+ mappings/sessions/workflows to move data from source to staging to warehouse in a complex insurance industry.
• Administered Informatica repositories and Informatica server running on UNIX.
• Worked closely with the Business analyst to understand the various source data (D2000, NOAA, DSRA, CTS, ICM, PSFT, OLS).
• Involved in Version Control and Migration of repository from DEV to UAT Environment.
• Involved in Change Data Capture (CDC) mechanism for SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations.
• Ensured that system testing and change management procedures are followed.
• Developed Korn Shell scripts to pre-process data in UNIX.
• Worked closely with Business Analyst’s and DBA’s in understanding the Databases and Structures used in the Insurance environment.
• Involved in designing of star schema based data model with dimensions and facts.
• Designed and developed Informatica mappings for data load and data cleansing.
• Performed performance and tuning functions on Informatica sessions, batches and other related scripts.
• Worked on identifying Mapping Bottlenecks in Mappings and improved session performance by including partition points, modifying target load order and emphasizing more on SQL override in place of Joiners and Lookup transformations.
• Extensively applied SQL, PL/SQL programming skills in optimizing the session performance.
• Implemented design improvements that provided increased scalability of the target data mart. These included the increased parallelism to allow sessions to be spread across all available processors. This scalability proved crucial in allowing enterprise wide usage of the data mart.
• Provided On-Call support during the Production implementation.
• Ability to prioritize and manage multiple tasks with effective time management skills.
• Precisely documented all the mappings for further reference according to the Enterprise Standards.

Environment: Informatica Power Center, Informatica Data Quality (IDQ), Teradata, Windows 2003 server, PL/SQL, SQL, SQL Assistant, Unix/Linux, DB Visualizer.

Confidential - New York, NY

ETL/BI Developer

Responsibilities:

• Actively involved in gathering business requirements and performing GAP analysis.
• Translated Functional requirements into Technical specification documents.
• Developed ETL mapping spreadsheet and Fact-Dimension matrix prior to performing the ETL process.
• Involved in Data modeling for GL Data Mart to bring in various set of books assets and balances into the warehouse
• Used complex transformations such as Connected and Unconnected Lookups, Joiner, Router, Filter and Stored Procedure transformations for data loads
• Worked with Memory management for the best throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning
• Debugged and implemented the best practices in mappings, sessions and workflows for data extraction and loading into Slowly Changing Dimensions type 1 and type 2
• Created test plan cases and performed Unit, Volume and Performance tests.
• Created and scheduled Informatica workflows using Crontab application.
• Imported physical tables and created the required aliases, views, joins in the Physical layer of Siebel Analytics Admin tool.
• Developed the facts, dimensions, necessary hierarchies and the joins between the logical tables, added aggregates in the BMM layer.
• Implemented various performance tuning mechanisms by performing Query Optimization, Hints, running advice plans and explain queries on indexes and creating Materialized Views to execute the prompts on the Dashboards faster.

Environment: Informatica power center, IDQ, Microsoft Visio 2003, Oracle 8i/9i, PL/SQL, UNIX (Ksh) and WindowsNT/2000 and Siebel.

Confidential - Richardson, TX

ETL Developer

Responsibilites:

• Worked closely with Business Analyst in understanding the analytics requirements and creating the business models for generating reports as per the requirements.
• Analyzed business requirements and translated them into specifications and Worked as a team member for design and development of Operational Data Store.
• Assisted the ETL team in regard to schema and data model design.
• Recommended data modeling changes and ETL changes to improve maintainability, data quality and performance.
• Involved in development of SDE (Source Dependent Extracts) and SIL (Source Independent Loads) mappings.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Implemented complex mapping such as Slowly Changing Dimensions (Type 2) using Flag.
• Calculated measures and assigning these aggregation levels based on dimension hierarchies.
• Configured presentation layer of Siebel admin tool used by different user groups and also established the various standard queries, in order to support the presentation layer.
• Configured Security settings in Siebel Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Configured & published iBots to deliver analytics content based on schedule automated iBot queries to obtain weekly Sales for each region & send notification Alerts to Regional Managers
• Performed unit testing of the reports generated using Siebel Analytics tool.

Environment: Informatica, Siebel Analytics 7.8.2, Oracle 10g, SQL server 2005, Windows XP, Erwin.

Confidential - Newark, NJ

Senior Informatica Developer

Responsibilities:

• Prepared Conceptual Solutions and Approach documents and gave Ballpark estimates.
• Design and developed Amazon Redshift databases
• Worked with XML, Redshift, Flat file connectors.
• Prepared Business Requirement Documents, Software Requirement Analysis and Design Documents (SRD) and Requirement Traceability Matrix for each project workflow based on the information gathered from Solution Business Proposal document.
• Propagate all database changes (DDL & DML) to multiple databases and servers.
• Data modeling and design of data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Worked with MDM principle and SIF service with ability to debug SIF related issues.
• Creating and managing Virtual machines in Windows Azure and setting up communication with the help of Endpoints and also VM migrations from Transactional hosts.
• Worked on Inbound, Outbound and Carve-out Data Feeds and developed mappings, sessions, workflows, command line tasks etc. for the same.
• Deployed to ActiveVOS Console.
• Coordinated and worked closely with legal, clients, third-party vendors, architects, DBA’s, operations and business units to build and deploy.
• Used Data stage to manage the Metadata repository and for import /export for jobs.
• Used IDQ address validation transformation to generate CASS and AMAS report for US and China addresses.
• Createdslice and dice and drill downReports, Dashboards, and Scorecards usingOBIEE 11gfor various subject areas.
• Worked with various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.
• Worked with Connected and Unconnected Stored Procedure for pre-& post load sessions

ENVIRONMENT: Informatica - Power Center, Power Exchange, Teradata, Oracle 10G, MS AccessUNIX,Windows NT/2000/XP, SQL Server 2008, SSIS, OBIEE, Qlikview, Teradata, SQL Assistant, NetezzaDB2.