SUMMARY

• Eight Plus (8+) years of Total IT experience in Business Requirements Gathering and Analysis, Application Design, Dimensional Data Modeling, Data Modeling, Development, Testing of software systems in Health Care, Insurance, Pharmaceutical, and Consumer study industries.
• Strong experience in implementing Data Warehousing Applications including Analysis, Architecture, Design, Development and reporting using Informatica PowerCenter 9.1/8.x/7.x, Power Exchange, Reporting Tool - Business Objects XI- 3.1.
• 3+ Years of extensive experience of Teradata13/12 databases using BTEQ, Utilities- MLoad, FLoad, Tpump, TPT, Fast Export for loading, exporting of data from databases.
• Strong knowledge of Teradata architecture, Indexes
• Extensively used scheduling tools Informatica Scheduler, Tidal and Data cleansing & profiling tool Informatica Data Quality, and Informatica Data Explorer.
• Proficient in Dimensional Data modeling and Relational Star Join Schema/ Snowflake models, FACT & Dimensions tables, Physical & logical data modeling and Ralph Kimball and Bill Inmon Methodologies.
• Strong database experience using Oracle 11g/10g/9i/8i/7i, SQL Server 2008/2005, Teradata 13, EBS R12 Financial, SQL, SQL*Loader, TOAD, MS Access and UNIX Shell scripting.
• Extensive Experience with Object oriented programming language - PL/SQL.
• Experience in Software Development Lifecycle includes Requirements Analysis, Data Analysis, Data Modeling, Object Oriented Analysis, System Integration and Software configuration Management.
• Worked in Scrum Environment and worked as Scrum lead.
• Ability in handling multiple projects simultaneously in confined work schedules. Coordination skills related to management of the offshore resources.
• Extensive experience and knowledge of the project lifecycle, including requirements gathering, development and execution.
• Ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Team player with good communication skills, written skills, technical documentation skills and also a self-motivated individual with exemplary analytical and problem solving.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.1/8.x/7.x, ETL, Data mart, OLAP, OLTP, Mapplets, Transformations, Tidal, SQL*Plus.

Dimensional Data Modeling: Dimensional Data Modeling and Relational Data Modeling using, Star Join Schema/Snowflake modeling, FACT & Dimension tables, Proficient with Ralph Kimball and Bill Inmon Methodologies.

Business Analysis/Data Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, MS Project, MS Access, MS Office, Visio.

Database: SQL Server 2008/2005, Oracle 11g/10g/9i/8i/7i, SQL*Loader, Teradata, DB2, Oracle EBS R12 Financial.

Programming: SQL, PL/SQL, T- SQL, Unix Shell Scripting, HP Quality Center

Environment: Windows NT/XP/2003, Unix, Sun Solaris, MS-Dos

Reporting Tools: Business Objects XI- 3.1

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. Informatica Developer

Responsibilities:

• Gathered requirements from business users and created a technical design documents.
• Participated in the Design Meetings, and prepared technical and mapping documentation.
• Created staging environment, loaded data by cleansing data and rejecting unwanted records which doesn’t qualify basic requirements.
• Created mapplets for trimming, MD5 Calculations and customized logic for project.
• Used Designer and Workflow manger extensively.
• Loaded data from multiple sources into staging using Informatica - SQL Server, Oracle, Flat files, Excel.
• Extensively used transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator, look up, Sorter, Source Qualifier, Update Strategy etc.
• Extensively used reusability concept. Shortcuts are created to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Used Workflow manager to create reusable sessions. Incorporated mail tasks for failure alerts and successful finish notifications.
• Deployment groups are created in Repository manager to deploy objects across environments.
• Debugged mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• Developed MLoad, Fload, scripts to load staging, Dimesions and facts according to the requirement.
• Loaded data into Teradata staging using Informatica.
• Used BTEQ and SQL Assistant as front-end tools to issue SQL commands.
• Developed appropriate Priamry, secondary, PPI indexes such a way that there is even distribution of data across all AMPs.
• Loaded tables into Netezza in most efficient way from flat files.
• Adhered to strict standards of the clients for frame work, Migration processes.
• Used Active batch scheduler for running the jobs.
• Implemented Performance tuning techniques at Informatica level and Database level for better performance of loading or updating the table
• Coordinated code review meetings and code change meetings with client.
• Adhered strictly to client naming conventions, description of objects and protocols for code migrations accordingly.
• Worked closely with reporting team, Cognos, to generate reports.
• Migrated code multiple environments - Test and Prod.
• Provided production support on shift basis and solved crucial production issues.

Environment: Informatica Power Center 9.5, Teradata 13,Netezza 7, Oracle 11g, MS SQL Server 2008/2012, Flat files, Excel, SQL Developer, SS Management Studio, Unix, BO, Active Batch, Aginity.

Confidential, San Diego, CA

Sr. Informatica Developer

Responsibilities:

• As an Informatica developer I performed requirements gathering, developed Analysis & Design document (A&D), developed Project time line.
• Created ETL overview & Code walk through documents.
• Created a shared centralized folder environment for all objects to maintain integrity and efficiency.
• Worked with PowerCenter Designer in developing mappings, to load Constituents, Funds tables and related, to extract and load the data from various sources - DB2, EBS R12 Financial, SQL server and Flat files.
• Created reusable Mapplets.
• Used Slowly Changing Dimensions Type I, Type II techniques in the Mapping Designer to load dimension tables - Name, Address, Relationship, Fund, Accounts, Transactions, Demographics, and Constituents, and Fact table - Gift.
• Implemented Change Data Capture and frame work.
• Used the Target Load Ordering.
• User Workflow manager to create sessions and workflows. And also used it to have a better performance.
• Monitoring the Workflow performance and the status with Workflow Monitor.
• Worked on Repository Manager to import and export mappings across various environments, create and manage user profiles.
• Used parameterization for integrity and easy maintenance.
• Build- in mapping Variable/Parameters and created Parameter files for imparting flexible runs of sessions/ mappings based on changing variable values.
• Used views, Triggers appropriately for data integrity and security.
• Tuned performances of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval and at database level.
• Wrote complex SQL Queries involving multiple tables with joins.
• Setting of sessions to schedule the load at required frequency using PowerCenter Workflow Manager and PMCMD.
• Performed Unit Testing and Involved in tuning Session and Workflows for better Performance.
• Developed frame work jobs.
• Created Shell Scripts to perform data validation during Unit Testing and System Testing deploying them into test environment and later into Production.
• Documented all the implementation and changes post deployments related to project.
• Worked with minimum supervision and mentored internal developers.
• Assisted in production support with on call support.

Environment: Informatica Power Center 9.5, SQL Server 2012, DB2, EBS R12 Financial, Toad for DB2, Flat Files, UNIX.

Confidential, Los Angeles, CA

Informatica Developer / Lead

Responsibilities:

• Work closely with clients to understand new requirements and design efficient solutions.
• Analyze existing manual processes and automating them.
• Develop mappings, sessions, Workflows to bring in data from various sources across multiple stages - Staging, ODS, Reporting (Datamart).
• As a Lead managed an off- shore team of 4 resources.
• Used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migration of data from various heterogeneous sources like Oracle, SQL Server, Oracle EBS 12, and Flat files to Oracle,Teradata.
• Used parameterization for better use of mappings and sessions.
• Implemented Slowly Changing Dimensions - I, II, III based on the requirements.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions and eliminating bottlenecks.
• Developed MLoad, Fload, TPump scripts to load staging, Dimesions and facts according to the requirement.
• Loaded data into Teradata staging using Informatica and Teradata utilities.
• Developed appropriate Priamry, secondary, PPI indexes such a way that there is even distribution of data across all AMPs
• Used BTEQ andSQL Assistant as front-end tools to issue SQL commands
• Developed stored procedures using object oriented language - PL/SQL and T-SQL.
• Created and Monitored sessions and workflows for daily extract jobs using Informatica Power Center, Workflow Manager and Workflow Monitor.
• Deployed objects across various environments from various developer folders in DEV/QA/PRD.
• Worked closely with Tidal admin to schedule the jobs based on their dependencies.
• Documented the changes and development related to project.
• Tier 3 level production Support with on call support.
• Work in Scrum Environment.

Environment: Informatica Power Center 9.1, Teradata 13, Oracle EBS 12, Oracle 11g/10g, SQL Server 2008/2005, Flat files, PL/SQL, Unix, Tidal 6.

Confidential, Hartford, CT

Informatica Developer/Lead

Responsibilities:

• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data.
• Worked closely with Business Analysts and SME’s to understand Business requirements and change requests of clients and implement with my team.
• Worked in Scrum Environment and worked as Scrum lead.
• As a lead over looked the 3 resources of my team - PL SQL Developer, BO Developer and business analyst.
• Used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy, and Joiner while migrating data from various heterogeneous sources like Oracle, SQL Server, and Flat files to Oracle.
• Developed mappings to bring in data from various sources across Staging, ODS to Reporting.
• Made changes in mappings with data changing capture capability for sources which have data added rapidly.
• Worked extensively on bug fixing of the existing mappings, performance tuning for better performance with best performance techniques and making existing objects to adhere to standards set up for the project.
• Created mapping variables and parameters for incremental loading.
• Handled Slowly Changing Dimensions (Type I, Type II, Type III) based on the business requirements.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions and eliminating bottlenecks.
• Validated the following HIPAA EDI transactions as 837(Health Care Claims or Encounters), 835(Health Care Claims payment/Remittance), 270/271 (Eligibility request/Response) and 834(Enrollment/Disenrollment to a health plan) by developing mappings.
• Created and Monitored sessions and workflows for daily extract jobs using
• Informatica Power Center, Workflow Manager and Workflow Monitor.
• Deployed objects across various environments from various developer folders in development --- two test environments and Production.
• Created Folders for New users and managed their privileges.
• Experience in Insurance Claims process procedures and knowledge of basic adjudication and insurance business rules.
• Documented the changes and development related to project.
• Assisted in production Support as Tier 2 level.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, SQL Server 2008/2005, HP Quality Center, Flat files, PL/SQL, UNIX, BO XI 3.1.

Confidential, LA

Informatica developer

Responsibilities:

• As a Informatica developer I performed requirements gathering, developed Analysis & Design document (A&D), developed Project time line.
• Created ETL overview & Code walk through documents.
• Created Data Model Structure with all related entities and relationship with each entities based on the rules provided by the business manager using Erwin 7.2.
• Worked with PowerCenter Designer in developing mappings and Mapplets to extract and load the data from various sources - Oracle, PeopleSoft, and SQL server.
• Created reusable Mapplets transformations to load data from operational data source to Data Warehouse and involved in capacity Planning and Storage of data.
• Developed complex mappings in understanding the various requirements - Slowly Changing Dimensions Type I, Type II - Time Stamping in the Mapping Designer.
• Applied data change capture for capturing the data which changes rapidly.
• Used pushdown optimization techniques for distributing load across resources for better performance.
• Monitoring the Workflow performance and the status with Workflow Monitor.
• Worked on Repository Manager to import and export mappings to various environments, create and manage user profiles.
• Build- in mapping Variable/Parameters and created Parameter files for imparting flexible runs of sessions/ mappings based on changing variable values.
• Developed command tasks to automate the Pre session jobs.
• Tuned performances of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Wrote complex SQL Queries involving multiple tables with joins.
• Involved in writing of Triggers and Stored Procedures with object oriented Language -- PL/SQL.
• Setting of sessions to schedule the load at required frequency using PowerCenter Workflow Manager and PMCMD.
• Used the Target Load Ordering with Stored Procedures to update database.
• Performed Unit Testing and Involved in tuning Session and Workflows for better Performance.
• Modified Workflows and Mappings to accommodate the new features of log files in Informatica 9.1.
• Created Shell Scripts to perform data validation during Unit Testing and System Testing deploying them into test environment and later into Production.
• Documented all the changes and implementation related to project.

Environment: Informatica Power Center 9.1, SQL Server 2008/2005, Oracle 11g/10g, PeopleSoft, PL/SQL, Windows XP.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Worked with IMS Data (Xponent Plan Track and DDD) for Sales & Marketing Analysis.
• Worked on Data Modeling aspects for Conceptual, Logical and Physical Modeling using Erwin.
• Responsible for ETL using Informatica 8.6.
• Worked with PowerCenter Designer tools in developing mappings and mapplets to extract and load the data from various sources.
• Used all Transformations such as Expressions, Filters, Joiners, Aggregators, Lookups, Update strategy, Sequence Generator, Routers and XML to load consistent data into database.
• Developed various Informatica mappings using various transformations like Sorter transformation, Aggregator transformation, Normalizer Transformation, HTTP transformation, XML parser transformation and Joiner transformation.
• Created reusable Mapplets transformations to load data from operational data source to Data Warehouse and involved in capacity Planning and Storage of data.
• Developed complex mapping such as Slowly Changing Dimensions Type II - Time Stamping in the Mapping Designer.
• Monitoring the Workflow performance and the status with Workflow Monitor.
• Worked on Repository Manager to create and manage user profiles.
• Built - in mapping Variable/Parameters and created Parameter files for imparting flexible runs of sessions/ mappings based on changing variable values.
• Developed various command tasks to automate the Pre session jobs. Did performance tuning to improve the load.
• Developed MLoad, Fload, scripts to load staging, Dimesions and facts according to the requirement.
• Loaded data into Teradata staging using Informatica and Teradata utilities.
• Wrote complex SQL Queries involving multiple tables with joins.
• Involved in writing of Triggers and Stored Procedures with object oriented Language -- PL/SQL.
• Setting of sessions to schedule the load at required frequency using PowerCenter Workflow Manager and PMCMD.
• Converted SQL/Procedures and SQL Loader Scripts to Informatica mappings.
• Used the Target Load Ordering with Stored Procedures to update database.
• Performed Unit Testing and Involved in tuning Session and Workflows for better Performance.
• Made necessary changes in the profile files and configuration files for the new version 8.6 repositories.
• Modified Workflows and Mappings to accommodate the new features of log files in Informatica 8.6.
• Modified Shell Scripts to facilitate the implementation of Informatica Upgrade Project.
• SQL PL/SQL Coding and UNIX Scripting.
• Created Shell Scripts to perform data validation during Unit Testing and System Testing.
• Documented all the changes and implementation related to project.
• Created various connection objects in Informatica, one connection object per database.

Environment: Informatica PowerCenter 8.6, Power Exchange, Oracle 11g, IMS Data, Non IMS Data, Teradata 13, SQL, UNIX, Toad.

Confidential, St Louis, MO

Informatica Developer

Responsibilities:

• Analyzed business requirement and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Gathered business requirements and performed detail analysis.
• Gathered user requirements from end users.
• Requirement analysis in support of Data Warehousing efforts.
• Designing and customizing data models for Data Warehouse supporting data for multiple sources on real time.
• Used Repository Manager to create user groups, users and managed users by setting up there privileges and profile.
• Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval
• Created multiple catalogs and resolved loops by creating table aliases and contexts.
• Organized data in the report by using Filter, Sorter, Rank, and Highlighted data with Alerts.
• Provided Production support by monitoring the process running daily.
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Developed MLoad, Fload,TPump scripts to load staging, Dimesions and facts according to the requirement.
• Loaded data into Teradata staging using Informatica and Teradata utilities.
• Created Schema Objects like Indexes, Views and Sequences.
• Wrote Stored Procedures to check source data with Warehouse data and if not present, wrote the record to the spool table and used spool table as Lookup Transformation in mapping.
• Experienced in backup and restoring Repository.
• Performance tuning of Oracle PL/SQL script.
• Created various data marts from data warehouse and generated reports using Business Objects.
• Use of BO Designer Module to implement Universes, Linkages between tables, creating prompts and queries, parsing the Universes applying contexts and Alias table to remove cyclic dependences.
• Worked with BO Supervisor for creating Repository, Creating and Managing universes, creating categories, creating and managing users, giving access permission for business objects.
• Responsible for Error handling, debugging and troubleshooting Sessions
• Worked closely with reporting team to generate various reports using Business Objects 6.x.

Environment: Informatica PowerCenter 7.1, Teradata 12, Oracle 9i, UNIX Shell Scripting, SQL, PL/SQL, Toad, SQL*Loader, SQL Server 2005, UNIX.

Confidential

DW Informatica Developer

Responsibilities:

• Source data analysis and design.
• Extensively used Informatica PowerCenter as an ETL tool to Extract, Transform and Load data from remote sources to DW.
• Wrote Shell Script and stored procedures to automate the aggregate building process.
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner transformation.
• Created multiple mapping using Reusable Transformations and Mapplets.
• Created, launched and scheduled sessions and batches using PowerCenter Server manager.
• Developed prototype for designed interface and estimated the performance criteria.
• Extensively worked on the database triggers, Stored Procedures, Functions and Database Constraints.
• Used connected and unconnected Lookups in various complex mapping.
• Reviewed and documented existing SQL*Loader and ETL Scripts.
• Worked on Debugging, Troubleshooting and documentation of the data warehouse.
• Responsible for development, test and productions mapping migration using repository manager and also used Repository manager to maintain the metadata, security and reporting.
• Tuning the Informatica Repository and Mappings for optimum performance.
• Customized data by adding calculations, summaries and functions.
• Performed Unit testing and Integration testing and handled production support issues.

Environment: Informatica PowerCenter 7.1 Designer, Repository Manager, Oracle 8i/7i, Win 2000.