SUMMARY

• 10 years of IT experience with exposure to all phases of software development life cycle (SDLC) includes User Interaction, Business Analysis and Documentation, Data Analysis and Modeling, Solution Design, Development, QA Support, Production Deployment, Production/Customer Support, Maintenance, Enhancements and Quality Control of software
• Experience of Informatica Power Center and Power Connect products and coding languages. 6 years of development and 2 years of lead/architect experience in Informatica Power center products
• Excellent Data Analysis skills and worked as Data Analyst in number of projects
• Good in data warehousing concepts such as dimensional modeling, star and snowflake schemas, data marts, fact and dimension tables identification as well as application design. Worked on Data modeling using the CA ERwin tool as well as the Microsoft Access
• In depth experience of PL/SQL Development. I have used PL/SQL for a number of processes ranging from performing simple ORACLE Minus operations to complicated calculations
• Excellent skills writing shell scripts in UNIX and aware of basic UNIX commands. Also, have worked with Informatica specific Unix scripts
• In depth knowledge of relational database technology and the SQL language.
• Aware of the syntax and use of MDX Querying language
• Trained in COGNOS TM1 tool, and have used it in multiple projects
• Worked in projects that implemented ‘Agile methodology’ for design and development process
• Experience includes implementation of number of Datawarehousing projects as well as Java Applications and COGNOS EP based applications to support features needed by users
• Worked as Developer on projects involving a number of languages like Java, Visual Basic, Oracle PL/SQL, Informatica and COGNOS EP as well as COGNOS BI, and Teradata Basics
• Six Sigma Green Belt certified, and part of TCS Process Excellence Group
• Worked in roles as Technical Architect so have knowledge about documentation of Data Analysis, Documentation of technical design, as well as co - ordination of technical assignments with development team
• Worked in roles as Business Analyst, and so have knowledge about documentation of Business Requirements, User Interaction, Conduction JAD session organization as well as ‘Sprint meets’ and supporting QA and UAT
• Involved in the P.M.O (Project Manager’s Office) for quite a few these projects. So have a good knowledge about Client Orientation & Project Assessment, Scoping of project, Budgeting and Resource Allocation.
• Worked in environments that require development for parallel releases i.e. multiple releases simultaneously. This requiring a robust code management and Scope management process.
• Possess good communication, interpersonal skills and ability to work in a team as well as individually. I am innovative in Approach and enjoy learning new methods and ideas and putting them into daily practice
• Performed number of process improvements using Six Sigma methodology

TECHNICAL SKILLS

Operating Systems: Linux (Red Hat) and Windows

Programming Languages: Java, J2EE, PL/SQL, Visual Basic 6.0, UNIX Shell Scripting

Databases: MS SQL server, Oracle 9i, Oracle 10g, Microsoft Access, DB2, MS SQL server

Application Software: Informatica 8.1.4, CA Erwin, Business Object, COGNOS EP, COGNOS BI, COGNOS TM1, Mercury Quality Center, Toad, SQL Developer, Eclipse

PROFESSIONAL EXPERIENCE

Confidential, Weston, Massachusetts

ETL Architect

Responsibilities:

• Analyze the data in different source systems like the Liquid Hub ODS and Global Commercial Data Warehouse.
• Design the ETL process to load the different required data attributes in the MS Data Mart.
• Implement changes in the Informatica ETL Code to process the new data attributes as required.
• Implement Data Model changes in the Oracle Database and complete necessary Stored Procedure changes in the Oracle Database.

Environment: Power Center 9, Oracle 11g, PL/SQL Stored Procedures, Windows 2000.

Confidential, Little Rock, Arkansas

Team Lead

Responsibilities:

• Leading a team of 7 individuals which included Java Developers, Informatica Developers and System Analysts.
• Analyze the data in CURAM source system, and design the Web services for ‘MEC Update’. The MEC Update service will determine the Medicaid ID for the person once he/she is determined Eligible in CURAM.
• Prepare the Data model design in Erwin for tables that will store data.
• Design of ETL Architecture for the data to be loaded from CURAM to the ‘Landing’ tables and from the Landing tables to the Reference schemas and outbound systems.
• Design and Development of Informatica power center jobs that will provide data from CURAM to the MEC Common Table as well as external systems like the HP MMIS database and the HP OK Medicaid Card Printing Center. Data sent to HP MMIS database and the HP OK Medicaid Card Printing Center via data files.
• Design and development of code to extract data from Legacy system, ACES; which is a mainframes database and processing the data to the MEC Reference schema.
• Design and development of cron scripts to schedule Informatica job.
• Design UNIX shell scripts to process files and also sftp the files to servers out of DIS Network (Department of Information services)
• Development of Informatica Data Quality mappings in Informatica Developer, based on Business Rules provided. Also worked to integrate the Informatica DQ mappings with Informatica PowerCenter.
• Design and Development of Java code to process data to an EBCDIC file with Packed Decimal data columns, which is the format of the HP MMIS file. This Java code was integrated with Informatica Power Center with the help if Java Transformation.
• Designed ETL process to load the data provided by CMS - Center for Medicare and Medicaid Service; to the systems operated by Arkansas Department of Health Service.
• Developing Informatica code for web service using web services consumer transformation to integrate the Informatica powercenter with the web service for printing ‘Notices’ for eligible people
• Implemented Project using Agile methodology, to achieve timely and reliable delivery

Environment: Power Center 9, Oracle 11g, PL/SQL Stored Procedures, Windows 2000, dot net, MS SQL Server

Confidential, Minneapolis, MN

Solution Architect

Responsibilities:

• Responsible for overall Source system Analysis.
• Design of the service oriented system involving informatica power center, dot net and MS SQL Server Programmability
• Data model design in Erwin for tables that store data before transmission
• Design of ETL Architecture
• Development of Informatica power center jobs
• Developing informatica for web service using web services consumer transformation
• Development of DT (Informatica data transformations) Coding to process xml files into Oracle
• Implemented Project using Agile methodology, to achieve timely and reliable delivery
• Development of Espresso jobs to schedule and monitor informatica executions and Stored Procedure executions in Production from Espresso console

Environment: Power Center 9, Oracle 11g, PL/SQL Stored Procedures, Windows 2000, dot net, MS SQL Server

Confidential, Minneapolis, MN

ETL Architect

Responsibilities:

• Responsible for overall Data Analysis.
• Design of the service oriented system involving informatica power center, dot net and Informatica DT
• Data model design in Erwin for tables that store data before transmission
• Development of Informatica power center jobs
• Developing informatica for web service using web services consumer transformation
• Development of DT (Informatica data transformations) Coding to process xml files into Oracle
• Implemented Project using Agile methodology, to achieve timely and reliable delivery
• Design of portal for ease of business team access to data
• Leading offshore for development of dot net code for Portal
• Development of Espresso jobs to schedule and monitor informatica loads, Windows batch scripts and Stored Procedure executions in Production from Espresso console

Environment: Power Center 9, Oracle 11g, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, dot net, MS SQL Server

Confidential, Minneapolis, MN

ETL Architect and Development Lead

Responsibilities:

• Part of the architecture team responsible for overall System Analysis and service oriented Design, Informatica as well as web portal
• Data model design in Erwin for tables that store data before transmission, as well of control structures for eCommerce portal control process
• Writing complicated SQL for views, which extract data from the admin system, as required.
• Development of Informatica jobs.
• Development of espresso jobs on the espresso scheduling tool
• Co-ordination of the development of dot net code for eCommerce portal
• Review and pperformance tuning of all jobs so that the transmission of feed files meets SLA
• Creation of scripts to run on windows server
• Development of Oracle and MS SQL Server stored procedures
• Preparing deployment packages, since deployment was done to production via multiple releases, from Jan 2012 till June 2012
• Resolution of issues in production, as part of 60 day warranty support
• Development of Espresso jobs to schedule and monitor informatica loads, Windows batch scripts and Stored Procedure executions in Production from Espresso console

Environment: Power Center 9, Oracle 11g, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, dot net, MS SQL Server

Data Warehouse ETL Informatica Architect

Responsibilities:

• Architect responsible for overall System Analysis, which involved data analysis as well as ETL Job analysis service oriented Design of the architecture that is needed to achieve the CTQ
• Co-ordinate the implementation of the changes.
• Analyzing the impact of upgrading to Informatica version 9
• Review of all SQL Code used in the project for informatica and COGNOS for performance tuning.
• Working as informatica administrator to manage and maintain informatica development and QA repositories.

Environment: Informatica Power Center 8.6.1., Informatica Power Center 9, Oracle 11g, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, UNIX, Cognos Reports, MS SQL Server.

Confidential, Stamford, CT

Data Warehouse Architect

Responsibilities:

• Responsible for overall WSS Source system Analysis and Design
• Analysis of impact of WSS changes on the Data Warehouse
• Worked towards creating an automated reconciliation mechanism, using ORACLE Minus, that matches data between the WSS version 7.2.26 and version 7.3.13
• Worked towards creation of a deployment plan, for the Upgrade, with zero downtime.
• Analysis and ETL implementation of the new parameterized logic for aggregating cash flows from WSS, after applying event based logic on the data.
• Acting as reviewer of ETL code to check if code has followed standards and is performance tuned
• Review of COGNOS BI queries to check if data model is accurately utilized and query is optimized and suggest changes in data model if needed.
• Working as informatica administrator to manage and maintain informatica development Repositories.
• Implemented LDAP access for users on the informatica repository

Environment: Informatica PowerCenter 8.5.1., Oracle 11g, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, UNIX, Cognos Reports, MS SQL Server.

Confidential, Stamford, CT

ETL Architect and Development Lead

Responsibilities:

• Worked with Data Architect for Data Analysis and creating Data Mapping Specifications.
• Created ETL Design documents and Data Flow Diagrams.
• Designed the ETL and ELTL Jobs for nightly batch loads that will process and aggregate data as needed by the Tax users. These included PLSQL jobs as well as Informatica jobs.
• Designed ETL strategy for Daily Intraday loads that were needed at Quarter ends to provide data to the users as soon as possible.
• Worked to develop queries to extract data from Data Warehouse for COGNOS BI Reports
• Reviewed the SQL and PL/SQL Code as well as the informatica jobs and suggested points for performance tuning of the ETL Jobs.
• Worked closely with Business analysts to ensure the correct processing of data.
• Create number of jobs on informatica scheduling to execute and monitor informatica jobs.

Environment: Informatica PowerCenter 7.1, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, UNIX, Cognos Reports, MS SQL Server.

Confidential, Norwalk, CT

ETL Analyst Programmer

Responsibilities:

• Analysis of the time consumed by the ETL process and bottlenecks in the current ETL process. The analysis was done using Informatica Data Analyzer tool.
• Worked to come up with documentation and guidelines for the performance tuning of ETL jobs so that data can be available to the Business users as soon as possible.
• Documented a number of steps that needed to be implemented in Informatica, as well as at the database and in Infrastructure to improve the performance of the nightly batch window. These also included architectural changes in the ETL process as well as using various features of Informatica and the Oracle database.
• Implemented the road map set up in close co-ordination with the Infrastructure team and the QA team.
• Working as informatica administrator to manage and maintain informatica development and sandbox repositories.
• Create number of jobs on informatica scheduling to execute and monitor informatica jobs.

Environment: Informatica PowerCenter 7.1, Oracle 10g, PL/SQL Stored Procedures, Windows 2000, UNIX, Cognos Reports.

Confidential, Stamford, CT

ETL Lead

Responsibilities:

• Working as lead ETL consultant reporting to senior ETL Manager for Confidential Treasury.
• Created ETL coding specifications documents for other developers to follow. Coached and mentored other developers by doing their code walkthroughs.
• Analyzed data and created ETL Design documents and Data Flow Diagrams for number of modules.
• Designed batch process for refreshing the EDW using MD5 Change detection from Operational Store database.
• Worked with all the powercenter 7.1 transformations like Aggregate, Expression, Filter, Sequence Generator, Router, Joiner, Lookup and Stored procedure and SQL transformations.
• Created sessions/Tasks on Informatica Power Center Workflow Manager to create sessions to run with the logic embedded in the mappings.
• Created batches using Informatica Scheduler to run sessions and work flows.
• Promote changes via established ITG change control procedures.
• Worked closely with QA team on the HPQC tool for closure of defects and promotion of Bug Fixes.
• Worked on a number of PLSQL code pieces in Oracle. These were used as part of ELTL processes that were used for complicated data processing.
• Worked on number of UNIX scripts that were developed to schedule Informatica jobs for intraday runs, deal with triggers from the source system and interdependency amongst ETL Jobs.
• Designed and coded the ETL process to populate a number of Facts using different loading strategy (like Delete Insert, Insert Update) and Slowly changing dimension tables in EDW. The EDW sources data from the Normalized ODS source and used MD5 change detection.
• Designed and coded the ETL process to load normalized Data Structures in the ODS, Generic Tables, priming of core data available from the source systems and perform a delta process using ORACLE MINUS.
• Designed and coded the ETL process to load a Daily Snapshot Fact, for the Mark To Market business process. The ETL Process was robust to handle many scenarios like back-dated correction of data at the source, new back-dated data, selective Snapshoting etc.
• Worked on architecture and design of job to refresh EDW Facts multiple times a day at Quarter ends.

Confidential

ETL Analyst Programmer

Responsibilities:

• Involved in development of Generic Interface, which is a metadata based approach to loading. Instead of having a number of mappings, the metadata based approach, would use a single mapping and dynamic parameter file, along with a metadata file, to perform the requisite loading.
• Designed and coded the ETL process to populate the DWN using metadata approach.
• Designed batch process for refreshing the CEBS datamart from DWN and RWA (Risk Weighted Analysis) database.
• Code, test and document ETL processes.
• Created transformations like Aggregate, Expression, Filter, Sequence Generator, Router, Joiner, Lookup and Stored procedure, Union transformations.
• Develop the Funnel Interface to process the output of the Generic Interface and develop jobs as per the Omloop architecture, to ensure minimum loss of data.
• Completed design and coding of a Java component that was used in Informatica Java Transformation for complicated error handling and metadata based data processing.

Environment: Informatica PowerCenter 7, IBM DB2 Database 8, Windows 2000, UNIX, Java, Business Objects Reports.