SUMMARY:

• Over 10 years of IT experience in Data Warehousing Development, Migration and Maintenance projects using Informatica, Teradata, Oracle, UNIX and other technologies in various domain which includes Airlines, Insurance, Healthcare, and Financial Bank. I’m a local hire and don’t require H1B/L1 Visa sponsorship.
• Extensive knowledge in all areas of Software Development Life Cycle (SDLC), involved in various phases such as requirements, analysis/design, development and testing.
• Experience in Data Warehouse/Data Mart development life cycle using dimensional modeling of Star, Snowflake schema, OLAP, ROLAP, MOLAP, Fact and Dimensional table.
• Experience in analyzing, writing and modifying Business Requirements Specs (BRS), Functional Specs (FS), Standard Operating Procedures (SOP), Technical Requirement, Test Plan, and ETL Design documentations.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities from heterogeneous sources like SAP, DB2, Teradata, Flat files etc.
• Expertise in writing Shell and BTEQ scripts on UNIX/LINUX environments.
• Experience in developing stored procedures, functions, triggers, packages at database and form level.
• Hands on experience in Mainframe, ESP DBMS tool, Informatica, Tidal and Control - M schedulers.
• Optimized the solutions by performance tuning at SQL, ETL and Database level.
• Worked in Onshore/Offshore model, mentored onsite team and managed an offshore team.
• Excellent analytical, presentation, communication & interpersonal skills, multi-task with an ability to interact with a wide range of people and enthusiastic in learning new tools and business environment
• Successfully managed complex IT projects using SDLC (Waterfall) and Agile/Scrum methodologies.
• Rigorously managed scope to ensure commitments are achieved within timeline, cost, and quality parameters.
• Helped in managing and mitigating issues and risks in project. Also assisted in managing organizational resources efficiently within a time period and budget.

TECHNICAL SKILLS:

BI Tools: Informatica PowerCenter 10/9.6/9.1/8.6/8.1/7.1 , and PowerExchange 9.1/8.6/8.1

Databases: Oracle 11g/10g/9i, Teradata 13.11, DB2 UDB, MS SQL Server 2008 and MS-Access

Languages: SQL, PL/SQL, C++, HTML, Java, Shell and BTEQ script

Version Control: Visual source safe, PVCS dimensions, Clear Case and Documentum

Job Scheduler: Informatica Scheduler, ESP DBMS, Tidal, Control-M, and Autosys

Software and Tools: Microsoft Office Suite, Toad, SQL Developer, SQL Loader, SQL*Plus, HP ALM, Putty, Winscp, Filezilla, PVCS Tracker, Erwin 7.1\4.5, MS-Visio, and SharePoint

Reporting Tools: COGNOS, HYPERIAN, and CRYSTAL Report

Operating Systems: LINUX, HP UNIX 10.2, Sun Solaris, Windows 98/NT/2000/XP/WIN 7

PROFESSIONAL EXPERIENCE:

Confidential

Lead Informatica Developer

Responsibilities:

• Analyzed the existing enterprise data warehouse (EDW) system, processes, standard documents, source systems and other information during transition.
• Participated in knowledge acquired sessions, created documents of understanding and conducted play back session to complete the transition.
• Provided 24X7 support services includes day/night jobs monitoring, production defect fixes, follow ups with source teams, developers and other team members for the resolution of issues.
• Analysis of impacted jobs for outage/downtime activities of Database Server, Informatica, UNIX/LINUX, SAP and DB2.
• Developed and modified UNIX shell scripts, MLOAD, FLOAD scripts and tested them in UNIX server.
• Worked on various break-fix and enhancement small projects to support the existing system and enhanced it features.
• Converted daily mainframe job to hourly job to retrieve most updated data for jobs impact analysis and reporting purpose as process improvement. Performed error handling, troubleshooting using various log files.
• Analyzed SAP data sources and interviewing source system experts; defining, analyzing and validating data objects; identifying the relationship among data objects.
• Utilized Lookup, Aggregator, Joiner, Union, Expression, Filter, Update strategy, SQL and Normalizer, Router, Transaction Control, Sequence Generator, Source Qualifier transformations to model various standardized business processes and implemented business logics.
• Implemented slowly changing dimensions (SCD) - type I & II in different mappings as per the requirements and performed target load order in multiple target instances.
• Mentored onsite team of 3 developers and managed an offshore team of 9 developers. Provided guidance to less experienced personnel. Conducted quality assurance activities such as peer reviews.
• Identified and resolved technical problems related to performance, functionality and coordinate with end users as necessary. Optimized the solutions by performance tuning at SQL, ETL and Database level.
• Rigorously managed scope to ensure commitments are achieved within timeline, cost, and quality parameters. Achieved and documented the scope of new development IT capital projects.
• Assisted in developing and maintaining cost effective project plans that meet organizational objectives and timelines for both technology solutions and business process improvement.
• Assisted in Identifying key project stakeholders both internally and externally, including vendors, and managing those relationships in support of a comprehensive approach to each project.
• Prepared BI Weekly status report (WSR), Defect tracker, Leave tracker, Team Competency tracker, BI Monthly portfolio based report, Customer feedback presentations, CSS, and Projection forecasting reports.
• Scheduled BI weekly/monthly meetings to monitor progress of the project as per the schedule/budget and ensuring timely completion and delivery of the project to the client.
• Developed effective working relationships with client team, and managed client expectations.

Environment: Informatica PowerCenter 9.6.1, DB2 UDB, Oracle 11g, SQL Assistant Teradata 13.1, Winscp, Secured BoxPutty, ESP Scheduler, HP QC Center, Service manager, Knova, SharePoint, Sun Solaris UNIX and Windows Enterprise 2000.

Confidential

Lead ETL Developer

Responsibilities:

• Participated in the business analysis process and the development of ETL requirements specifications.
• Involved in Source Data Analysis and Data Profiling and prepared Mapping Specification document.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Extracted the data from various sources like Flat files, XML files, Excel files, Oracle databases and populated into Teradata database.
• Developed various mappings for Billing, Claims, Payment process, M&T Lockbox process, Pharmacy, Medicare, Med claim. Also prepared mappings to offload data from legacy systems into tables.
• Increased code reusability using shortcuts, mapplets, reusable transformations, re-used mappings, reusable sessions and worklets to reduce redundancy in code.
• Handled versioning and dependencies in Informatica.
• Developed shell, BTEQ, MLOAD scripts and parameter files in UNIX server.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system.
• Data Analysis and validation by running SQL queries against source/target tables using SQL Assistant.
• Used Teradata loading utilities like Multi Load, Fast Load and TPump based on the mapping/functional requirements.
• Extensively used Informatica debugger to troubleshoot data issues and error conditions.
• Used UNDRALEU tool for ETL code review of various mapping, session and workflow.
• Prepared the error handling document to maintain the error handling process.
• Used PL/SQL procedures and functions in mappings to build business rules to load data.
• Used Pushdown Optimization to push the transformation logic on to the Database both on the Source and the Target sides where ever possible to improve performance of the mapping.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test and supported the UAT for the client.
• Monitored the ETL jobs, generated tickets and fixed the bugs and logged them in HP ALM.
• Extensively used Tidal Enterprise Scheduler for running the shell scripts, performing actions, event tasks, scheduling the workflows and dynamically updating the parameter file.
• Participated in daily Sprint Scrum meetings, monthly Retro meetings, IT Staff team meetings and training sessions.
• Prepared BI Weekly status report (WSR), Defect tracker, Leave tracker, Team Competency tracker, BI Monthly portfolio based report, Customer feedback presentations, CSS, and Projection forecasting reports.
• Scheduled BI weekly/monthly meetings to monitor progress of the project as per the schedule/budget and ensuring timely completion and delivery of the project to the client.
• Developed effective working relationships with client team, and managed client expectations.

Environment: Informatica PowerCenter 9.1, PowerExchange 9.1, DB2, Informatica Data Quality 9.1, Oracle 11g, TOAD, SQL Developer, Surveyor, Winscp, XML SPY, Putty, Tidal, SQL* Loader, HP ALM, QVCS, UNIX and Windows Enterprise 2000.

Confidential

Sr. ETL Developer

Responsibilities:

• Gathered Business requirements by interacting with Business Analyst and analyzed the requirements to translate into technical Specifications.
• Involved in Data modeling, designing of Data mart in Star schema methodology with conformed and granular dimensions and fact tables.
• Extracted the data from various sources like Flat files, XML files, Excel files, Oracle databases and populated into Teradata database.
• Applied the concept of Change Data Capture (CDC) and imported the source from Legacy systems and Operational systems using Informatica Power Exchange (PWX).
• Developed number of complex Informatica mappings, mapplets, and reusable transformations to implement the business logic as per the requirements.
• Extensively used unstructured data transformation (UDT) for transforming unstructured and semi-structured data files like PDF, MS-Word and Excel.
• Responsible to write complex SQL and T-SQL queries and PL/SQL procedures to perform database operations according to business requirements.
• Used Teradata for running the SQL Queries to check the data loaded to the Target Tables.
• Involved in creation of BTEQ Script for validation to maintain the data quality.
• Developed UNIX shell scripts to customize the server scheduling jobs.
• Worked with the testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
• Attended production implementation calls and coordinated with the build engineers during migration of the code and was highly acknowledged.
• Prepared estimates tracked each and every task and strictly adhered to the estimated deadlines.
• Extensive knowledge in promoting packages (code) across DEV, QA, preproduction and production.
• Assisted the other ETL developers in resolving complex issues and coordinated with off-Shore team.
• Prepared the error handling document to maintain the error handling process.
• Participated in daily Sprint Scrum meetings, monthly Retro meetings, IT Staff team meetings and training sessions.

Environment: Informatica PowerCenter 9.1, PowerExchange 9.1, DB2 UDB, Oracle 11g, Teradata 13, SQL Server 2008, TOAD, AS400, Autosys, QVCS, Sun Solaris UNIX, Windows Enterprise 2000.

Confidential

Informatica Developer

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis and project- coordination.
• Assisted in preparing Business requirement specification, Functional specification and Test plan report documentations using System Development methodology (SDM).
• Analyzed the existing business logics to determine the reusability of the code.
• Created mapping parameters, session parameters, mapping variables and session variables.
• Written SQL queries to validate the data in both source and target databases.
• Optimized the SQL override to filter unwanted data and improve session performance.
• Scheduled and run the workflow using CRONTAB and PMCMD command in UNIX.
• Extensively used Informatica debugger to troubleshoot data issues and error conditions.
• Prepared unit testing document covering field to field’s validations and source to target count.
• Participated in project meetings to discuss about all the ongoing issues.

Environment: Informatica PowerCenter 8.6.1, DB2 UDB, Oracle 10g, Teradata 12, VS2008, TOAD, Service Manager, SharePoint, AS400, UNIX, Windows Enterprise 2000 and Autosys.

Confidential

Informatica Developer

Responsibilities:

• Involved in analysis and design phase of the project and provided necessary functional and design documentation as to how the EDW module will be designed.
• Analyze technical requirements of the project and gather source system information to achieve it.
• Developed complex mappings using Normalizer, Connected Lookup with dynamic cache, Update strategy and Transaction control for populating target table in efficient manner.
• Performed data manipulations using various Informatica transformations like Joiner, Sorter, Expression, Router, Aggregator, Filter, and Sequence generator.
• Prepared SQL queries to validate the data in both source and target database.
• Utilized UNIX shell scripts for adding the header to the Flat file targets.
• Used workflow manager for creating, validating, testing and running sequential and concurrent batches and sessions and scheduling them to run at specified time.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test and supported the UAT for the client.
• Fix on errors - Deployment of code and data fixes by performing root cause analysis, and application performance improvements.
• Participated in project meetings to discuss about all the ongoing issues.

Environment: Informatica PowerCenter 8.1, Oracle 10g, DB2 UDB, SQL*Plus, Visual source safe, FileZilla, Flat Files, Windows XP and UNIX (AIX 6.2).

Confidential

ETL Developer

Responsibilities:

• Gathered Business requirements by interacting with Business Analyst and analyzed the requirements to translate into technical Specifications.
• Developed Informatica mappings, mapplets, and reusable transformations to implement the business logic as per the requirements.
• Extracted the data from various sources like Flat files, XML files, Excel files, Oracle databases and populated into Teradata database.
• Implemented slowly changing dimensions (SCD) - type I & II in different mappings as per the requirements and performed target load order in multiple target instances.
• Involved in writing and modifying UNIX shell scripts.
• Written SQL and T-SQL queries to validate the data from source and target tables.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test and supported the UAT for the client.
• Participated in daily Sprint Scrum meetings, monthly Retro meetings, IT Staff team meetings and training sessions.

Environment: Informatica Power Center 7.1, Oracle 9i, UNIX (AIX6.2), Harvest, SQL Loader, Autosys, Visio, TOAD, SQL Developer, Windows XP.

Confidential

BI ORACLE PL/SQL Developer

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages as well as insights into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Developed and modified database objects like Tables, Views, Materialized Views, Stored Procedures, Functions, Triggers and Packages using Oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the Fact Tables and Materialized Views to enhance the performance.
• Generated server side PL/SQL scripts for data manipulation and validation for remote instances.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Wrote Sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Developed Master tables for automatic creation of primary keys.
• Assisted in providing support for the Java based application for debugging errors and testing.
• Created Indexes on the Tables for faster retrieval of the data.
• Extensively used the advanced features of PL/SQL like Records, Tables, Collections and Dynamic SQL for improving query performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developed Procedures to create database objects dynamically based on user inputs.
• Fine-tuned Procedures/SQL queries for maximum efficiency in various databases using Oracle Hints for rule based optimization.
• Troubleshoot the errors using Exception handling for the ease of debugging and displaying the error messages in the application.
• Involved in the continuous enhancements and fixing of production problems.

Environment: Oracle 9i, Sybase, SQL*Plus, PL/SQL Developer, SQL*Loader, Java, PVCS dimensions, Windows Enterprise 2000, UNIX.