SUMMARY

• 9+ years of IT experience in software development, designing and implementing high quality business solutions, with major focus on Data Warehousing
• Over 9 years and 9 months of experience in ETL processes consisting of data sourcing, data transformation, mapping, conversion and loading using Informatica Power Center.
• Establishing and implementing the ETL best practices and guidelines by creating high performance and highly scalable ETL designs
• Extensive Experience in Analysis, Design, Development, Testing and Implementation of Data Warehouse Applications. Well versed with Star - Schema & Snowflake schemas for designing the Data Marts.
• Extensively designed, developed, implemented and tested generic/custom graphs/mappings (Extraction, Transformation and Loading )
• Participated in all phases of the System Development Life Cycle Analysis (SDLC), Business Modeling & Data Modeling
• Created and maintained documentation for operational support and metadata repositories.
• Extensive Experience in Teradata, Oracle 10g/9i, PL/SQL, Data Architecture, Data Modeling
• Involved in Logical Design and creating Database objects (tables, indexes, views, and stored procedures).
• Extensive experience working with Oracle, SQL, UNIX and Shell Scripting.
• Expert level knowledge in data modeling concepts like Star schema, Snowflake schemas, fact and dimensional modeling.
• Working as a Team leader with good communication, interpersonal and analytical skills.
• Possess strong ability to quickly adapt to new applications, platforms and languages.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• Quick understanding of Business and Project Environment can handle and deliver in high extreme pressure situations.
• Available to work immediately.

TECHNICAL SKILLS

Languages: C, C++, SQL and PL/SQL

Scripting Languages: Java script, Unix (Korn) Shell scripting

ETL Tools: Informatica Power Center (9.x/8.x/7.x). (Source Analyzer, Target DesignerTransformation Developer, Mapplet Designer, Mapping Designer, Transaction control, SCD(Type I, Type II and Type III), Task, Decision, Command) Power Exchange

Systems: Windows XP, Windows 98, Windows 2000, Windows 7, UNIX(AIX) and Mainframes

Databases: Oracle 10g/9i/8i/8.0, MS Office/Access, Teradata, Data Modeling and Architecture, Stored Procedures, Functions, Triggers and Packages

Other Tools: Cognos 8.4, ERWIN R8, Tivoli Work Scheduler, Crystal Reports, TOADMercury Quality Center, Rational RoseData warehouse Metadata, Data Mining, Data Staging, DTS, Data Mart, OLAP and OLTP.

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, CA

Senior Informatica Developer/Designer

Responsibilities:

• Actively participated in the Design Committee meetings for building the system and enhancing the same.
• Worked with the Business Analyst to translate the requirement documents into technical design documents and participated in implementing the processes using Informatica and Korn Shell scripts.
• Designed mappings using the transformations Joiner, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy transformations and Mapplets to load data into the target.
• Created data model using Erwin data modeling tool.
• Extensively used Informatica 9.1 in loading data from Flat Files, sources and oracle
• Involved in Production Support activities like running jobs in production for Billing cycle, member query analysis, and validation of data in production whenever any issues come in production
• Created shell scripts for atomization of job such as to move the file from one server to another, to start informatica work flow using pmcmd command.
• Responsible for creating shared and reusable transformations in Informatica shared folder and update the objects with the new requirements and changes.
• Worked on various applications like Ultra Edit, Telnet, putty, oracle 10g and SQL developer
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance
• Involved in coordinating with the release teams at the time of deploying/promoting the code to QA/Production.
• Developed various utilities to perform regular maintenance work like finding occupied space in Database for each table, Amount of free space left in Database, Archiving last six months data in UNIX.
• Involved in generating Cognos cube and deploy the cube in Production and generate Cognos reports for monthly billing results which consists of Bills/Refunds in production
• Involved in small enhancements in Cognos reports
• Worked with Tivoli Work Scheduling team for scheduling the jobs in production. Also worked on webforms for scheduling the jobs in Production
• Worked with ETL testing team closely for unit integration testing of Major Releases.
• Working as a Team Leader for a team size of 1 member at Onsite and three members from offshore.
• Actively Co- Ordinate with the off-shore team to track the assigned tasks and updates

Environment: Informatica Power Center 9.1/8.6.1 (Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Mapplet Designer, Repository Manager, Work Flow Manager), Ultra Edit, Oracle 10g, Tivoli Work Scheduler, PL/SQL, AIX Unix and Cognos 8.4.1

Confidential, Pasadena, CA

Senior Informatica Developer/Designer

Responsibilities:

• Extensively worked on understanding the business requirements and responsible for Categorizing and Prioritizing the requirements according to the time frame, system resources, human resources and other related factors.
• Involved in all phases of the Software Development Life Cycle Analysis, Business modeling and Data modeling.
• Analyze the various standard and custom processes, and suggesting the optimal solution to the client.
• Responsible for developing and maintaining the ETL (Extraction, Transformation and Loading) processes using Informatica Power Center.
• Developed complex mappings using transformations like Expression, Aggregator, Stored Procedure, and Look up, Filter, Joiner, Rank, Router, Transaction controlSource qualifier and Update Strategy.
• Used Dynamic lookup cache to synchronize data between target and lookup cache for Better performance.
• Wrote complex Stored Procedures to meet the business requirements.
• Created reusable transformations and Mapplets in order to use them in complex mappings
• Created tasks (session, command, assignment, decision, etc.), monitor sessions by using workflow manager and workflow monitor
• Involved in Migration of code from Abintio to Informatica 8.6.1
• Created Informatica Mappings while converting code from Abintio to Informatica 8.6.1
• Involved in Code migration from Teradata 12 to Oracle 10i
• Provided directory cleanup scripts and worked on SFTP scripts
• Involved in unit testing, integration testing and troubleshooting.
• Imparted technical and functional trainings to new team members.
• Prepared estimation and SLA summary documents.
• Responsible for maintaining the weekly and monthly status reports. Maintained/updated Data Dictionary,
• Guide the team in various aspects of the project like test cases, troubleshooting & documentation and in developing.

Environment: Informatica Power Center 8.6.1 (Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Mapplet Designer, Repository Manager, Work Flow Manager), Oracle 9.0, DB2, SQL, PL/SQL,SQL Teradata 12.0.

Confidential

Informatica Developer

Responsibilities:

• Extracted Data from Different Sources like oracle, flat files and XML files by using Informatica
• Involved in writing several complex SQL query to generate various reports.
• Cleanse the source data, Standardize the Vendors address, Extract and Transform data with business rules, and built Mapplets using Informatica Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Responsible for forming SQL queries as per the criteria selected by user.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Extensively worked on the performance tuning of the Mappings as well as the tuning of the sessions.
• Coordinated with customer in finding the sources and targets for data conversion.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyzed the sources according to Business rules and developed validated Database.
• Worked with less structured, more complex issues and served as a resource to others

Environment: Informatica Power Center 5.0, Windows NT, PL/SQL, Excel, SQL Server, Erwin, Source Analyzer, Warehouse Designer, Mapping designer, Mapplet designer, Transformation developer, Aggregate, Expression and Lookup.

Confidential

Informatica Developer

Responsibilities:

• Developed Automated Testing Framework that is used for regression testing using PL/SQL Stored Procedures.
• Involved in Triage and Parallel execution support activities.
• Modeling, Designing and performing code documentation
• Post Delivery support for UAT.
• Worked on resolving the Defect CQs by making necessary changes to Informatica mappings

Environment: Informatica Power Center 5.0, Oracle 10g/9i, Korn Shell Scripting, PL/SQL, TOAD