SUMMARY:

• Over 4 years of IT experience in System design, development and maintenance in Business Intelligence field including Technical and Functional experience in Data Warehousing technologies involving ETL tool - Informatica Power Center.
• Experience in the areas of Banking, Insurance and Manufacturing Industries.
• Experience in different stages of ETL processes such as Extraction, Cleaning, Transformation and Loading using Informatica Powercenter (versions 8.x/9.x) involving wide variety of different data sources/targets - non-relational Databases such as Flat files, XML, Excel files, and other relational sources such as Oracle and SQL Server.
• Experience in developing ETL mappings and scripts in Informatica PowerCenter 8.x/9.x using Designer (Source Analyzer, Target Designer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor.
• Experience in implementing Data ware house projects involving in variety of roles from ETL developer to System Admin.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Worked on projects related to system migrations between different environments.
• Exposure to Job scheduling tools like Autosys, CA-7, ESP and Control-M.
• Implemented Slowly Changing Dimensions (SCD) both Type 1 & 2.
• Data modeling knowledge using Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables.
• Extensively involved in Optimization and Performance Tuning of Mappings and sessions in Informatica by identifying and eliminating bottlenecks.
• Experience in involving all phases of Software Development Life Cycle (SDLC) - Requirement gathering, Design & Development, Testing & Implementation.
• Performed technical writer duties which include preparing technical specifications and Operational procedures documents adhering to company standards.
• Extensive experience on database development using SQL Scripts (DDL & DML) / Views/ Procedures / Functions.
• Involved in Monthly/Daily production support duties as required.
• Extensively worked for Data Analyzing, Cleansing and Data Integration and worked to resolve inconsistencies in data.
• Experienced in Informatica Advanced Techniques like Dynamic Caching, Parallel processing to increase Performance throughput.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.x/9.x.

Databases: Oracle 9i/10g/11g, DB2, Teradata, SQL Server 2005/2008.

Data Modeling Tools: Microsoft Visio 2008.

Data Processing Tools: SQL *Loader, TOAD 7.6/9.0/10.1.6, SQL Plus, SQL Server Mgmt studio 2008.

Job scheduling Tools: AutoSys, Control-M, ESP, CA-7.

Languages: C, C++, SQL, PL/SQL, UNIX Shell Scripting.

Operating Systems: Windows 9x/NT/2000/XP, UNIX, Linux.

Office Applications: MS-Office 97/2000/03/08, Open Office Suites.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Informatica Developer/Analyst

Responsibilities:

• Involved in collecting requirements, analyzing data, design and development of Data warehouse.
• Involved in complete Design, Build, Test, QA, and Deploy of the Project.
• Extensively involved in Fine tuning of Informatica Code (mapping and sessions) by including SQL override to SQ and LKP transformations to obtain optimal performance and throughput.
• Code review, Testing and co-ordination with Testing team.
• Design, Develop and Testing of Mappings.
• Developed complex Informatica mappings using Unconnected Lookup, Sorter, Aggregator and Router transformations for populating target table in efficient manner.
• Migrated Mappings, Sessions, and Workflows from Development to Test.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created and monitored sessions and batches to run the mappings.
• Extensively worked on type 2 Slowly Changing Dimensions (SCD' s).
• Involved in creation of Technical specification document (Source to Target) for the project by conducting technical meetings.
• Interacting with the users and making changes to Informatica mappings according to the Business requirements.
• Written SQL overrides in Source Qualifier according to business requirements.
• Created workflows using Workflow Manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Created various Batch Scripts for scheduling various data cleansing scripts and loading process.
• Involved in Production Support and resolved production issues.
• Developed and documented Mappings/Transformations, Audit procedures for Informatica sessions.

Environment: Informatica Power Center 9.5, SQL Server 2008, Toad 9.0, Cognos, Windows XP Professional, Control-M, Microsoft Visio 2008, WinSCP.

Confidential, Harleysville, PA

Informatica Developer/Analyst

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, pilot, training and rollout to the field user and support for production environment.
• Involved in Daily support and Maintenance for Pre-existing Data marts in Enterprise dataware house (EDW) as a part of EDW support team.
• Working interactively with Analysts and Subject Matter Experts (SME’s) in mapping exercises (Source to target) as part of the requirements gathering.
• Extensively worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer to Extract Sources, Transform Data and Load into Target.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings etc.
• Build Workflows and Worklets to schedule, sequence and parameterize data loads into the different Datamarts and the Enterprise Data Warehouse.
• Worked on creating mapplets and reusable transformations to prevent redundancy of transfomation usage and maintainability.
• Developed Unix Shell Scripts for source file processing and to perform pre and post load validation activities and integrated them in Informatica PowerCenter.
• Extensively worked on Microsoft Visio on preparing data models as part of DB Design process.
• Developed SQL Stored Procedures/Views on Oracle database so as to support Daily Data mart Load validations and to generate daily control reports.
• Prepared technical specification documents as part of the project.
• Involved in Performance Tuning - initiated necessary steps to decrease the time in running workflows.
• Worked interactively with different work streams during testing phases of project development to ensure data validation successfully.
• Worked on configuring Informatica and file processing Job schedules for CONTROL-M scheduler.
• Written PL/SQL Procedures for Archiving the data.
• Documented Process flows as required for cross training/educational purposes.

Environment: Informatica Power Center 9.1, Oracle 10g, Unix, Linux, Control-M, Toad 9.0, OBIEE, Windows XP Professional, Clearcase, Microsoft Visio 2008, WinSCP .

Confidential, San Diego, CA

Informatica Developer/Analyst

Responsibilities:

• Worked with Informatica Power Center 9.1 - Mapping Designer for developing mappings consisting of wide range of transformations based on the business logic.
• Extensively worked with Informatica Power Center 9.1 - Workflow Manager to create workflows, worklets which consists of different type of tasks available.
• Worked extensively on different types of transformations like normalizer, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.
• Worked on scheduling operations using AUTOSYS.
• Worked on Performance tuning techniques to optimize the execution time of the Informatica workflows when converted to different environments.
• Worked extensively on pmcmd commands for processing workflows.
• Worked on different data sources such as Oracle, SQL Server 2008 and Flat Files.
• Worked with PL/SQL to rewrite Stored procedures/Functions as part of migration tasks.
• Analyzed the requirements and involved in preparing documents containing Functional and Technical Details of project.
• Developed various mappings and workflows which involved in building the fact and dimensional tables for Point-of - Sale data.
• Involved in Data Cleansing by developing various validation techniques during Data staging.
• Created different parameter files and changed Session parameters, mapping parameters and variables at run time.
• Developed UNIX shell scripts which were eventually used in workflows serving the purpose to build the Data mart.
• Responsible for creating business solutions for Incremental and full loads.
• Worked on PVCS Version Manager to deploy the necessary code and database archives to support distributed environment.
• Involved in Unit testing and developed Unit test documents.
• Involved in end-user training and providing the production system support.

Environment: Informatica Power Center 9.1, Sql Server 2008, Autosys, Business Objects, Windows NT, UNIX, TOAD 7.6, PVCS Version Manager.

Confidential

Informatica Developer

Responsibilities:

• Designed Parameter driven Informatica mappings and sessions for extracting, cleansing, transforming and loading the data from Complex Flat Files into the data warehouse.
• Used various transformations like Unconnected/Connected Lookups, Aggregator, Expression Joiner, Sequence Generator, Router for creating complex business logic in ETL.
• Developed logic using sequence generator transformation to replace missing keys and create unique keys.
• Created worklets and workflows in the workflow manager to synchronize OLAP system with OLTP system with the logic to run set of tasks at the scheduled times.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Used the update strategy to effectively migrate data from source to target.
• Used Repository Manager to migrate Informatica mappings across the development, test and production environments.
• Involved in extensive performance tuning by determining bottlenecks at targets, sources, mappings, sessions.
• Responsible for loading data into warehouse from different sources using Oracle loader to load millions of records and used Import/Export utility to load small tables.
• Extensively used PL/SQL for creating views, stored procedure, and indexes on the tables.
• Involved in error checking and testing of ETL procedures and programs in Informatica session log.
• Developed Component documentation as per Juniper Standards for every product designed.

Environment: Informatica Power Center 8.6, SQL Server 2005, Oracle 9i, Linux, Cognos, SQL Navigator, Visio, Windows XP, SunOS 5.6.

Confidential

PL/SQL Developer

Responsibilities:

• Initial system study and design.
• Normalized the database to remove data redundancy.
• Prepared Entity Relationship diagrams.
• Created database objects like tables, views, synonyms, indexes and sequences.
• Used SQL *Loader and Export, Import utilities to load the data.
• Modified existing reports as per the enhancement.
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing the scripts and reports.
• Calculated and monitored size and space for tables, clusters and indexes.
• Wrote procedures to replicate data from one table to another.
• Involved in generating SQL Reports.
• Debugging system application tuning by identifying long running reports.
• Developed/modified PL/SQL code like stored procedures, packages etc for interface.
• Involved in Unit testing, Integration testing and Load testing of the interface.
• Involved in documenting the modifications and intended functionalities of the interface.
• Helped in creating technical specifications by mapping the interface tables with the base tables.

Environment: Oracle 9i, Pl/Sql, Sql*Plus, Windows2000/NT, SQL*Loader