SUMMARY

• Over 9+ years of professional experience in IT with progressive experience in design, development, testing and implementation of Data warehouse applications.
• Experience in data modeling, data warehouse, Ralph Kimball models with Star/Snowflake Schema designs with analysis - definition, database design, testing, and implementation and Quality process.
• Experience in shell scripting for automating the administration job.
• Expertise in Installing and Managing Informatica Power center, Metadata Manager, Data Explorer and Data Quality.
• Strong knowledge in Informatica Administration including Installation, up gradation, Configuration, maintenance and troubleshooting.
• Analyze system performance and knowledge of system parameters for improvement of the utilization of system resources.
• Creative problem solver and articulate communicator, skilled in the process of translating business needs into technology solutions.
• Involved in the Analysis of Physical Data Model for ETL mapping and the process flow diagrams.
• Actively interacted with the Users in developing ETL design for Reporting layers.
• Extensive Data Warehouse and Data Migration development experience using Informatica Power Center, Oracle 7.x/8i/9i/10g/11g, MS SQL Server 7/2000/2005.
• Extensively used Informatica workflow manager and workflow monitor for creating and monitoring workflows, Worklets and sessions.
• Extensively worked with large databases in production environments.
• Strong Team working spirit, communication and relationship management skills.
• Designed the ETL processes using Informatica and Teradata to load data from Oracle, Flat Files, XML files and Excel files to staging database and from staging to the target Data Warehouse database.
• Performed data cleansing, data manipulations using various Informatica Transformations.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Collaborated onsite teams, interacted and well managed various offshore teams.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Strong Team working spirit, communication and relationship management skills.
• Created Mappings in Mapping Designer to load data from various sources using complex transformations like transaction control, Lookup (Connected and Un-connected), Joiner, sorter, Aggregator, Update Strategy, Filter and Router transformations.
• Experience with reading from Oracle, SQL server using Informatica Power Exchange.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter5.x/6.x/7.x/8.x/9.xPower Connects and Informatica APP

OLAP/DSS Tools: Business Objects 6.0

Database Modeling: Erwin 4.0/4.1

Databases: Teradata,Oracle7.x/8.x/9.x/10g,SQLServer 7.0/2000/2003 , Multi-Dimensional (OLAP), SFDC, DB2.

Languages: SQL, PL/SQL

DB Tools: Teradata SQL assistant, SQL* Plus, SQL* Loader, SQL*Forms

OS: MS-DOS 6.1, MS-WINDOWS 95/98/XP,UNIX

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA

Sr. Informatica Consultant

Responsibilities:

• Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.
• Interacted with Source system SME’s to analyze how various business processes have been tracked across the source tables.
• Designed Data warehouse target tables by using Dimensional Modeling Techniques - Star and Snowflake Schemas. Created Dimensions and Fact tables using Erwin.
• Extracted data from various data sources such as Flat file, DB2 and transformed and loaded into targets using Informatica.
• Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Designed and developed initial and incremental data loads using Informatica.
• Designed and Developed several Mapplets and worklets for reusability.
• Developed sessions using different types of partitioning techniques like round robin, hash key portioning for better performance.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided Nightly batch loads support and implemented solutions to correct the data issues raised by end user during production support phase of the project.

Environment: Informatica Power Center 8.6, SQL Server 2008R2, DB2, Flat files, SharePoint, Windows 7 Professional, UNIX, Shell Scripting.

Confidential, Pasadena, CA

Sr.Informatica ETL Developer

Responsibilities:

• Worked closely with the business users across different business Units to gather requirements for enhancing the existing process & functionality.
• Prepared customized reports to help client provide a strong competency in understanding risk & accordingly perform better customer selection & customer satisfaction.
• Functioned as the primary liaison between the business line, operations, & the technical areas throughout the project cycle. Worked on gathering, analyzing & documenting business requirements.
• Involved in database design using Star schema & Snow flake schema.
• Extensively used Informatica client tools Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server Manager.
• Performed Repository Administration tasks (Creating Repositories, Users, Assigning privileges, creating backups and recovery).
• Imported various sources, targets, and created transformations using Informatica Power Center Designer.
• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial load and incremental load.
• Extracted data from different sources such as Oracle, DB2, XML, flat files, SAP using Power Center.
• Data is coming from various sources like Oracle, SQL Server, Mainframe etc which will be loaded based on different frequencies as per the requirement. Used Power exchange for mainframe sources.
• Designed, developed and tested Informatica mappings using efficient transformations and used reusable transformations as well as Mapplets.
• Imported data from flat files using Teradata load utilities like Fast Load, Multiload, and TPump
• Performance tuning SQL queries and stored procedures
• Implemented the Mapping dependencies using informatica workflow manager and also done using through UNIX shell scripting.
• Wrote test plans and executed the same at UNIT testing and also supported for system testing, volume testing and USER testing.
• Performed ETL Testing and Involved in Debugging.
• Used parameter file to maintain the file names, locations and log file locations based on dates.
• Involved in creation of various different independent schemas around the database creation.
• Worked in creation of Mapplets and Worklets.
• Created various mappings which define denormalization of data.
• Involved in technical design and education offshore-team.
• Worked handling a team of developers in technical discussions and routing of data.
• Involved in extraction of data using delimited and fixed width flat files and various XML sources and targets.
• Involved in Production Support and various product release activities.

Environment: Informatica Power center 8.6.1/8.5, Oracle 9i, TOAD, UNIX, Mainframes My Extra, Windows XP,Informatica Power Exchange, Oracle 9i/10G,XML Spy, Flat Files.

Confidential, Irving, TX

Sr. Informatica Developer

Responsibilities:

• Involved in meetings with Technical architect and Business users to understand Business Requirements.
• Involved in designing dimensional modeling and implemented STAR flake, SNOW flake Schemas
• Worked on ERWIN to identify facts and dimensional tables by analyzing logical and physical Models
• Analyzed source files prior to extracting from flat files, SAP, SQL server.
• Extracted data from various Heterogeneous sources like Flat files, SQL server, Oracle.
• Worked on slowly changing Dimensions Type1, Type 2.
• Developed Complex mappings using various transformations like Expression, Update StrategyRouter Transformation, Aggregator, Filter, Sorter, sequence Generator, Lookup and Joiner.
• Used Debugger to identify errors in the mapping and Increased Performance by using various Performance tuning techniques
• Developed Tests cases based on business rules and modified mapping logic accordingly after Identifying errors
• Validated errors at various stages, during building mappings, and loading data into staging.
• Identified bottlenecks in Mappings, sessions and workflows and increased performance in Loading data.
• Optimized the performance of queries with modification in SQL queries, removed unnecessary Columns, eliminated redundant and inconsistent data, normalized tables, established joins and Created indexes wherever necessary
• Used Joins and other complex queries to view the results that meet the business decision.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, TriggersStored Procedure and Constraints.
• Created stored procedures, scripts for the Bulk application, tested them on the test Servers and moved them to production.
• Created Reports using Business Objects advanced functionalities like Optional promptsQueries - Slice and Dice- Analyzer Tool, Drill Down, @Functions, Cross Tab-, Detail, Formulae etc.
• Involved in Unit testing of the mappings and migrated repository from 9.0 to 9.0.1.
• Created mappings to load Incremental data into Teradata and also involved in Production Support

Environment: Informatica Power Center 9.0 Tools (Designer, Workflow Manager, Workflow Monitor), Oracle10g, SQL server 2005, Toad 9.5, Unix, Erwin 7.x.

Confidential, Alpharetta, GA

Sr. Informatica ETL Developer

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse.
• Involved in designing of star schema based data model with dimensions and facts.
• Used Informatica as ETL tool for building the data warehouse.
• Extensively worked on different subject areas like Product,Individials,Accounts,
• Scores, Billing, Services, Demographics, Call details and summary details.
• Created mappings with heterogeneous sources like flat files, DB2, Oracle databases and created targets in Oracle using Informatica Mapping Designer 7.1.4.
• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica 0Power center.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Sequence generator, stored procedure, Expression, Filter and Rank transformations.
• Created session variables to build sessions more effectively by using Informatica server manager.
• Having working knowledge of ERWIN 3.5.2 in converting logical data models into physical models.
• Developed mappings to dynamically use parameter files used by other mappings.
• Used touch files, event-wait tasks for scheduled job runs in Workflow execution.
• Duties included coordination, attending meetings, and the review of requirements, infrastructure setup, task assignments and code reviews.

Environment: Informatica Power center 7.x/8.5, Informatica Power Exchange, Oracle 9i/10G, ERWIN 3.5.2, PL/SQL, COBOL, MS Office, SQL Server 2000.

Confidential, Los Angeles, CA

Informatica Consultant

Responsibilities:

• Used Informatica to extract, transform and load data from multiple heterogeneous sources into Oracle
• Worked on Source Analyzer, Warehouse designer, Mapping & Designer and Transformations, Informatica Repository Manager and Workflow Manager and Monitor
• Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement
• Designed the change data capture logic in the Informatica mappings by incremental extraction of source data
• Used the transformations like Source qualifier, Router, Filter, Sequence Generators and Expression as per the Business requirement to create the mappings
• Developed complex aggregate, joiner, look up transformation rules (business rules) to generate consolidated data using Informatica Power Mart tool
• Tuned the Informatica mappings and the database SQL for better performance of the application
• Developed and tested all the backend programs, Informatica mappings and update processes
• Worked on creating dimensional data model in Erwin 4.0
• Generated complex reports using Business Objects and created aliases and contexts for solving the join problems in Business Objects

Environment: Informatica 7.1.2, Business Objects 5.1,Oracle 9i,SQL server 2000, ERWIN 4.0

Confidential

Informatica Developer

Responsibilities:

• Involved in design & development of operational data source and data marts in Oracle
• Reviewed source data and recommend data acquisition and transformation strategy
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle
• Used Power mart Workflow Manager to design sessions,
• Created parameter based mappings, Router and lookup transformations
• Created Mapplets to reuse the transformation in several mappings
• Used Power mart Workflow Monitor to monitor the workflows
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression, Lookups
• Created daily and weekly workflows and scheduled to run based on business needs
• Created Daily/weekly ETL process which maintained 100GB of data in target database
• Involved in Unit Testing, Integration Testing, and System Testing

Environment: Informatica Power mart 4.2, Oracle 8i, Erwin 3.5, Shell scripting, Windows 2000