SUMMARY

• Around 8 years of IT experience in system design, development and maintenance
• Over 6 years of technical and functional experience in Data Warehousing, ETL tool - Informatica
• Extensively worked on data extraction, transformation, loading with various databases using Informatica
• Extensive experience in Power Center Designer, Workflow Manager and Workflow Monitor
• Proficient in RDBMS databases including Oracle, Teradata, SQL Server, and DB2
• Experience in Oracle database development using SQL Tuning, PL/SQL and Stored Procedures
• Highly proficient in creating transformations, mappings, mapplets, tasks, sessions and workflows
• Expertise knowledge in Performance Tuning to resolve the bottleneck and optimize session performance
• Sound understanding of data warehousing concepts, dimensional modeling, Star and Snowflake schemas
• Good understanding of dimensional modeling and relational database management systems
• Remarkable experience with the migration of data from eclectic systems to single database
• Expertise knowledge in installing, configuring, upgrading Power Center 7, 8, and 9.1
• Working experience in UNIX shell scripting to manage and schedule workflows
• Extensive experience with different types of SSH client like Putty and WinSCP for UNIX platforms
• Working experience in Informatica Data Explorer (IDE) to provide data profiling and data quality
• Working experience on JIRA to monitor, track and fix bugs and defects on the workflows.
• Good experience with Power Exchange CDC to capture real time updates as soon as they happen
• Development experience on Windows, UNIX (Solaris, HP UX, AIX) platforms, Linux

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 6/7/8/9.1, IDQ, IDE, Power Exchange, BASE SAS,SAS/ MACRO

Databases: Oracle7/ 8i/9i/10g/11g, SQL Server 2000/2005/2008 , DB2, Teradata

Operating System: Windows, UNIX (Solaris) - WinSCP, Putty

Scripting: UNIX Shell Scripting, PL/SQL scripts

RDBMS Load Tools: SQL Developer, SQL * Plus (Oracle), T-SQL (SQL Server)

Reporting Tools: Business Objects, Power Builder

Data Modeling Tools: TOAD 7.6/8/9.5/9.7 , SQL Developer, Erwin 3.x/4.xOffice Applications MS Office Suites including Excel, Word, Access, Outlook, Visio

Languages: SQL, PL/SQL, C, C++Web skills JavaScript, Flash, ASP, HTML, DHTML

PROFESSIONAL EXPERIENCE

Confidential, TN

Senior Informatica Developer

Responsibilities:

• Extracted historical data from five different legacy systems to load data into single target database.
• Designed numerous maps which has complex transformation logics to manipulate and load data
• Extensive usage of Lookup Transformation to match data from multiple tables to retrieve data
• Worked as Business Analyst to analyze, write and design business requirements for ETL implementation
• Led a part of the ETL team to delegate tasks and deliverables to be submitted on time
• Contributed to help Quality Analysts help understand the design and development of the ETL logic
• Worked with ETL leads and contributed to conclude on the development of the project.
• Designed complex mappings involving target load order and constraint based loading
• Created Tasks, Worklets and Workflows to using Informatica Workflow Manager
• Produced Unit Test Results using Unit Testing to validate the mapping development
• Extensive experience in creating database objects using Oracle, SQL Server, Flat files, XML
• Used WinSCP, Putty to schedule workflows though shell scripts and command line
• Used UNIX scripting as pre/post-session commands to clear caches, and drop tables and indexes
• Worked with SQL Developer to access database and do the analysis on data validity
• Worked on LLD and HLD to document the requirements, logic, analysis involved in the project
• Worked on JIRA to track and fix bugs in the code by analyzing the logs in Informatica

Environment: Informatica Power Center 8.6 /9.1, Oracle 10g, SQL Developer, XML, PL/SQL, WinSCP, Putty, JIRA UNIX, Mainframe, and Windows, MATT

Confidential, Philadelphia PA

Informatica Developer

Responsibilities:

• Worked with various Databases for extracting the files and loading them into different databases
• Worked mainly on troubleshooting the errors which were occurred during the loading process
• Worked extensively on SQL SERVER 2008 R2 for creating the views and altering the tables as per the requirement and also worked on SSIS depending upon the requirement
• Extensively worked on creating mapping parameters and variables which are used in various workflows for reusability
• Worked extensively on stored procedures in MySQL 5.0 and was involved simultaneously in scripting various other SQL queries
• Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, and Sequence Generator
• Extensively used MS View for creating many tables and altering them in SQL database
• Extensively worked with Slowly Changing Dimensions Type1, Type2, for Data Loads
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level
• Involved in writing Stored Procedures in SQL and extensively used this transformation in writing many scenarios as per the requirement
• Extensively worked with Source Qualifier Transformation to join the homogeneous sources
• Extensively worked with Joiner Transformation to join the heterogeneous sources
• Extensively worked with both Connected and Un-Connected Lookups
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Worked with re-usable objects like Re-Usable Transformation and Mapplets
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation
• Developed jobs using DT Studio 8.6 Version
• Extensively used SQL Override function in Source Qualifier Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Responsible for migrate the workflows from development to production environment
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters
• Responsible for Performance in Informatica Power Center at the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used Source Analyser and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.

Environment: Informatica Power Center 9.1,Informatica B2B Data Transformation Studio 8.6 Erwin 4.2,O, SQL server 2008 R2, Access, Flat files, UNIX shell scripting, Windows XP.

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Developed transformation logic and designed various complex Mappings and Mapplets using the Designer
• Worked with Lookup, Aggregator, Expression, Router, Filter, Update Strategy transformations
• Extensively used Debugger to troubleshoot the mappings before the normal run of the workflow
• Worked with pmcmd command line program to start/stop/schedule workflows
• Extensively used SQL and PL/SQL scripts and worked in both UNIX and Windows Environment
• Fine-tuned ETL processes by considering mapping and session performance issues

Environment: Informatica Power Center 7.1, Windows XP, Oracle 9i, ER Win, SQL Server2000, UNIX

Confidential, Raleigh, NC

Data Warehouse/ETL Developer

Responsibilities:

• Provided a data model for each of the different products that are offered by the Bank such as ATM Cards, Visa Charge Cards, Credit Cards, Internet Banking, Personal Loans
• Defined and captured metadata and rules associated with ETL process
• Participated in the detailed requirement analysis and designed data marts and star schemas
• Designed data extract layouts i.e. data fields that will be loaded from these sources to the staging area in the data warehouse environment
• Created mapping routines, which will map data from Bank data source to Data warehouse
• Worked on ETL specification, design and implementation using Informatica and PL/SQL
• Designed number of mappings with complex transformations using Informatica
• Involved in performance tuning and monitoring (both SQL and Informatica) considering the mapping and session performance issues
• Performed job scheduling using Informatica

Environment: Informatica Power Center 7.1/8.1, SQL, PL/SQL, Oracle 9i, UNIX (Solaris)

Confidential, Waco, Texas

SAS Programmer /ETL Developer

Responsibilities:

• Performed SAS programming required for data analysis and reporting in Unix environment
• Experience with developing ETL Processes using Base SAS Data Step processing code (writing ETL code in SAS)
• Created routine Customer mailing list for Direct Mailing and Telemarketing
• Generated listing in Ad-hoc upon request by Client/Vendor using SAS, DDL and DML in SQL and DB2 program. Extensively used proc SQL for creating ad-hoc reports and graphs as per the requirements of the users
• Proc SQL, Proc Import, Proc Export were used to retrieve data from databases like Oracle, and Excel using Spotfire
• Used SQL queries include DDL and DML commands extensively to check the data integrity, data verification and validation
• Load flat files in to Teradata RDBMS using Loading tools
• Created tables, views in Teradata, according to the requirements
• Involved in the risk and loss analysis with regression models
• Involved in updating and maintaining the databases like Sybase and Oracle using SQL and mainly DDL and DML.
• Involved in the design of the data warehouse
• Responsible for configuring the ODBC drivers to connect to oracle database from SAS which facilitated the extraction of data
• Involved in dynamic data exchange of data between different remote systems
• Developed macros, Shell Scripting and views to integrate complex business rules
• Developed stored procedures for managing complex business logic using SAS EBI
• Maintained and enhanced existing SAS reporting programs for marketing campaigns
• Created Data Models for different level of Marketing based on the reports generated from EUC systems
• Used DDL and DML in SQL and PROC SQL Pass through Facility to work with Oracle, DB2
• Worked with Enterprise Miner for marketing campaigns doing statistical analysis using regression models
• Moved data set across platforms (from PC and Mainframe to UNIX and Vice Versa) and dealt with VBA during migration

Environment: BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ STAT, SAS EG, SAS/CONNECT and SAS/ACCESS, SAS/ENTERPRISE MINER, SAS BI, IBM Web sphere, RDBMS, ORACLE, DDL, DML, NCR Teradata, MVS, UNIX, Windows NT

Confidential

System Analyst/ Informatica Developer

Responsibilities:

• Used Power Builder as the front end and SQL Server 2000 as the back end
• Designed SQL and stored procedures for the business reports on a monthly basis
• Documented business requirements by facilitating sessions between business and technical team
• Involved in systems design and implementation of standardized business processes
• Generated and compiled reports based on findings with probable causes and possible solutions tosystemsissues
• Extensively have used Joins in order to get records from different tables
• Implemented Triggers to enforce Integrity constraints, Cursors for data extraction and to carry out updates of new fields, and exceptions for run-time error handling
• Involved in maintaining and first level troubleshooting of the database
• Analyzed and wrote logics, codes, tests for software solutions involving database extraction
• Designed and implemented a new information database for supporting interfaces
• Ensured accurate data transfer from sources into the newly designed system
• Performed extraction from SQL Server 2000 and Oracle 9i to analyze the results using Informatica
• Worked on Stored Procedures using PL/SQL for customers placing regular orders
• Used OLAP tool for slicing and dicing data and analyzing results
• Coordinated with other technical teams to ensure compatibility with other modules and applications
• Consulted with users and stakeholders to ensure that requirements are met
• Familiarized with software development lifecycle and configuration management

Environment: Informatica 6.1/7.1, Oracle 9i, SQL Server 2000, SQL, PL/SQL, Windows XP, JAVA Script, Oracle 7i, Power Builder, SQL Server 2000, Win XP, MS Office Suite