EXPERIENCE SUMMARY

• An accomplished Data Architect & ETL Consultant, 10+ years of experience in the field of Data Warehousing, Application Development & Pre - sales activities. Extensively worked in Informatica PowerCenter to create and manage complex Data model & ETL mappings. Worked with top-notch clients & organizations at onshore and offshore, in challenging environments and across domains. Implemented end-to-end solutions using industry-leading technologies. Designed & implemented innovative solutions to improve process, accelerate development, reduce costs and increase revenue.
• Expertise in designing and implementing ETL environments using traditional ETL strategies as well as tools like Informatica PowerCenter9.6/9.1/ 8.6/8.1.0/7.1.3 and IBM DataStage 8.1.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies
• Expertise in leading projects in the role of a Project Lead/Technical Lead managing large teams both onsite and offshore and delivering the projects within the Scope, Budget and Time.
• Expertise in Estimating Projects, Resource Planning and providing the Project Timelines based on requirements.
• Led ETL streams of work for large/complex program having onsite/offshore teams; manage scope, issues, dependencies, change control, and collaborated with account executive to create SOW, change orders.
• Experience with different RDBMS Databases Oracle, SQL Server, DB2 UDB, Netezza and Teradata having huge databases.
• Expertise in working with Push down optimization (PDO) of Informatica.
• Expertise in working with Teradata Utilities Fast load, Mload and Fast Export, BTEQ
• Expertise working with XML, Web services using Informatica.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Experience in loading data and troubleshooting, debugging mappings, tuning
• Expertise in developing SQL and PL/SQL codes through various functions, Triggers, procedures, and packages to implement the business logics of database in Oracle.
• Worked on various flavours of UNIX - Sun Solaris, AIX, HP-UX and Red Hat Linux.
• Expertise with UNIX Operating System AIX scripting, Shell scripting and Perl scripting.
• Worked on Business Intelligence tools like Business Objects.
• Excellent interpersonal and communication skills, and is experienced in working with senior management, business people/clients and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.1/8.6/8.1.0/7.1.3/7.1.2, PowerMart 5.1 Informatica Power Connect, IBM DataStage 8.1

Data Modelling: Erwin 4.5/4.0, Star schema, Snow-Flake schema

BI/OLAP Tools: Business Objects XI R3.1, Cognos PowerPlay 7, Impromptu 7/ Report Net 1.1 MR2, Infogix Assure

Database: Oracle 10 G/9.2/8.1.7, SQL Server 2000/2005, DB2 UDB 9.1/ 7.1Teradata Database 12.10

File Type: Fixed Width, Delimited, EBCDIC, XML

Database Utilities: SQL* Loader, TOAD, PL/SQL Developer, Squirrel SQL Client 2.2, Putty.

Job Schedulers: Control M, Autosys, Tivoli Maestro

Operating System: Windows 98/2000/NT/XP, UNIX, Linux, MS-DOS

Languages: Java, SQL, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, CA

Project Lead

Responsibilities:

• Responsible for overall ETL design and implementation - define and maintain environments, coding standards and migrations, data movement strategies from source through the data warehouse, Informatica folder structure and content, process flow, data delivery methods to downstream systems, testing strategies
• Gathered scope, created estimates, staffing model, and provided detailed task and work schedule planning
• Work with Business Analyst, Users and Architects to understand the business needs and Design the Data Model to fulfil the needs
• Prepare Technical Response for the business requirements
• Data Profiling and data Analysis to identify the data condition that needs to be managed during transformations.
• Provides the Optimal ETL Solution to extract and load the data from different source system to Eenrollment Data marts
• Support and fix the issues in warranty period.
• Prepared the Support document and Transition the project to the Support team.

Environment Informatica PowerCenter 9.1, Teradata 13, Oracle 10g, Infogix Assure, UNIX, XML

Confidential, TX

Lead Designer

Responsibilities:

• Work with Business Analyst, Users and Architects to understand the business needs and Design the Data Model to fulfil the needs.
• Create project estimates and get approval
• Prepare resource planning and timelines for the project
• Data Profiling and data Analysis to identify the data condition that needs to be managed during transformations.
• Provides the Optimal ETL Solution to extract and load the data from different source system to EDW.
• Establish and enforce technical standards for deliverables of projects.
• Design POC Mappings and help the ETL team on data acquisition techniques and loading strategies during the development phase.
• Query optimization and Informatica Code optimization to improve the Load time.

Environment: Informatica PowerCenter 8.6, IBM DB2 UDB 9.1, Teradata 12.10 SQL Server, Oracle 10g, SQL Assistance, Toad, UNIX

Confidential, NJ

Informatica Lead Developer

Responsibilities

• Manage and coordinate teams both onsite and offshore.
• Work on Informatica tools such as Source Analyzer, Warehouse Designer, Mapping Designer, Transformation Developer and Mapplet Designer.
• Work with Mapping variables, Mapping parameters and variable functions
• Develop mapplets to implement business rules that involved complex logic.
• Design and develop UNIX shell scripts as part of the ETL process to schedule tasks/sessions and create different jobs as per requirement in Control-M

Environment: Informatica PowerCenter 8.6, IBM DB2 UDB 9.1, SQL Server, Oracle 10g, Netezza, SQL, Winsql, UNIX.

Confidential, NC

Informatica Administrator

Responsibilities

• Create new projects setup also includes creating dev and test environments for various new applications
• Work on user request like granting access, catalogue databases, move requests etc
• Migrate mappings, sessions and workflows from test to prod using deployment groups
• Work on various change request to accommodate the new changes to the existing systems
• Create the Source and Target Definitions in Informatica Power Center Designer.
• Work on user request like granting access, catalogue databases, move requests etc

Environment: Informatica PowerCenter 8.6, IBM DB2 UDB 9.1, SQL Server, Oracle 10g, UNIX.

Confidential, TX

Informatica Developer/Admin

Responsibilities

• Manage and coordinate team of 11 resources at both onsite and offshore.
• Lead the design of the overall ETL data warehouse architecture: ETL strategy, staging database, and data quality
• Steered the team to build Informatica mapping for creating Audit Strategy reports
• Used Informatica repository tables for fetching the audit data (Status of Session, Workflow and error logs/messages)
• Designed Staging tables to load the records fetched from Informatica repository tables
• Produced detailed ETL design documents and specifications, and communicated business requirements into detailed ETL data mappings

Environment: Informatica PowerCenter 8.6/8.1.1,IBM DataStage 8.1, IBM DB2 UDB 9.1, SQL Server, Oracle 10g, BO XI R3, SQL, SquirreL, UNIX.

Confidential, TX

Informatica Developer

Responsibilities

• Prepared ETL Technical specification documents which help to create mappings.
• Created the Source and Target Definitions in Informatica Power Center Designer.
• Created SQL joins for reading from Sybase/Oracle.
• Extensively used ETL to load data from different source systems like Oracle, Flat files, into the Target database.
• Developed advanced mapping and re-usable transformations using Informatica Designer.
• Worked with Mapping variables, Mapping parameters and variable functions
• Performed Debugging and performance tuning of Mappings and error handling
• Developed Mapplets to implement business rules that involved complex logic.
• Designed and Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.

Environment: Informatica Power Center 8.1.1, Oracle 9i, SQL, Embarcadero Rapid SQL, Unix

Confidential, NJ

Informatica Developer

Responsibilities

• Worked on Informatica tools such as Source Analyzer, Warehouse Designer, Mapping Designer, Transformation Developer and Mapplet Designer.
• Created the Source and Target Definitions in Informatica Power Center Designer.
• Involved in development of Informatica jobs with required transformations like Aggregator, Filter, Lookup, Sorter, Joiner, Router, Rank, Update strategy Transformer etc.
• Extensively used ETL to load data from different source systems like Oracle, Flat files, into the Target database.
• Designed and Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
• Used Rapid SQL as a front-end tool, to issue SQL commands against Oracle RDBMS.

Environment: Informatica Power Center 7.1.1, Oracle 9i, SQL, Embarcadero Rapid SQL, UNIX

Confidential, CA

ETL Developer

Responsibilities

• Reviewed complete business requirements as required.
• Involved in the analysis of the existing system in Microsoft DTS packages.
• Responsible for creating informatica mappings for the corresponding existing DTS packages.
• Worked with informatica designer, workflow manager to create simple and complex informatica mappings, sessions and workflows.
• Developed Mapplets, and reusable transformations to prevent redundancy of transformation usage and maintainability.
• Involved in extensive testing of the mappings and workflows.
• Worked with various informatica transformations to successfully complete requirements.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Received applause awards twice in Deloitte for outstanding performance
• Recognised by TCS for Technical Excellence and Outstanding Performance.
• Got promoted on early recommendation for my Outstanding Performance.
• Involved in Customer Engagement & Workshop and member of Proposal team
• Authored a White Paper on Business Objects Reports Testing Automation.
• Coordinated and Participated in various Indian Cultural events in community