Professional Summary

• Nearly 10 years of IT experience.
• 7 years of experience in Development and Enhancement of Data Warehousing projects using Extract, Transformation, Load ETL process including data cleansing, data load into ODS Operational Data store and then into Data Warehouse - Informatica Power Center 7.x, 8.x and 9.x.
• 2 years of experience in Pentaho Data Integrator PDI ETL tool Kettle and GIT.
• Experience with OBI Applications like Oracle Financial Analytics and Human Resource Analytics HR Analytics .
• Very good knowledge and experience in Relational Database Management Systems like Oracle 8i, 9i 10g and 11g, MS SQL Server and MySQL.
• Had been working in Linux and UNIX environments all through 8 years.
• Good knowledge in Dimensional Data Modelling both physical and logical models using Sybase Power Designer and TOAD data modeler.
• Extensive experience with DAC Data Warehouse Administration Console 9.x and 10.1.3.4.1 and Informatica Scheduler.
• Proficiency in Data Warehousing Concepts for designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema and also managing metadata.
• Extremely high level of understanding and development experience with Informatica Power Center, including various transformations look up, source qualifier, filter, union, aggregator, normalizer, expression, etc. , mappings/ mapplets, workflows/ worklets.
• Full hands on with all tools of INFA Informatica Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager and Repository Administration Console.
• Basic experience with Informatica Administration tasks in Informatica Repository Administration Console like creating new users/groups, providing privileges, working with nodes, domains and Integration service.
• Experience with OBIEE 10g/11g Administrator and Answers/Dashboards to handle support situations individually.
• Experience with GIT source code management and version control tool.
• Experience in Performance Optimization and Data Quality.
• Have knowledge in PL/SQL Stored Procedures, views and materialized views and DB performance optimization tasks like partitioning, Exchange partitioning 11g technique .
• Involved in various phases of SDLC, which include Analysis, Design, Development, Testing and Implementation.
• Implemented Agile Development Methodologies to achieve short term goals and deliver timely results for the users and continual work on progressing to achieve final goal of meeting all the requirements of users.
• Around 2 years of experience in Mainframe Technologies COBOL II, IMS-DB/DC, DB2, JCL, IDMS.
• Excellent written and verbal communication and analytical skills in corporate environment and the ability to perform independently as well as in team environments.

Professional Experience

Confidential

Senior ETL Developer

Environment: Informatica Power Center 7.1.4/9.1.0, Pentaho Kettle, Oracle 10g/11g, PL/SQL, Toad Data Modeler, Sybase Power Designer, DAC 10x, GIT, OBIEE10g/11g, Remedy, Windows, Red Hat Linux, MS Visio

Responsibilities

• Informatica Power Center ETL Developer Expertise in developing, maintaining and supporting ETL projects using Informatica power center tool. Along with that, majorly used SQL, PLSQL, Linux shell scripting. Oracle was the main Warehouse Database. Worked on pulling data from multiple sources like Oracle, MS SQL, My SQL, Flat Files etc.
• Data Modeller Data Modelling of star and snow flake schemas for Remedy marts, CRM data mart and several other data marts. Used Sybase Power Designer for modelling.
• Used a special Kimball's design strategy for re-designing CRM to store history on some facts in the fact table.
• All SDLC phases exposure Every project involved interaction with users/business people to gather business requirements and convert them to technical requirements. Solely responsible for the whole SDLC life cycle of each project assigned.
• Development, Maintenance and Support Played major role in Oracle Financial Analytic application upgrade project in doing ETL customizations using Informatica Power Center tool based on business requirements. Maintained and supported Oracle Financial Analytics Warehouse and experienced Data Warehouse Administration Co nsole Scheduler tool.
• Major ETL Developments Also warehoused and maintained most of the BMC Remedy data and supported crucial billing information warehouse on TNS devices.
• Testing and Deployment Migration of code from Development to test and then to Production following TNS Standards of Deployment, after conducting scrutinized testing at all levels - Functional testing, Unit testing, Integration testing, Regression Testing and UAT as part and parcel of each project.
• Job Scheduling using DAC Scheduled jobs using Data Warehouse Administration Console scheduler and was primary responsible person in the company for handling job runs.
• Data Integrator Was handling very large volumes of data in financials each full reload processed more than 200GB data . Improvised job performance by 90 by doing code changes in Informatica ETL and working with DB Administrator for modifying most complicated source qualifier SQL queries and some complex stored procedures.
• Documentation Created Design Documents and Mapping Specifications documents, test case documents and Fact qualifier matrix documents throughout different phases of the projects.

Confidential

Description

Build data marts for Help Desk, Circuit Order, Carrier Trouble Ticket, Trouble Ticket, Equipment, Equipment Replacement, etc. Remedy forms.

Confidential

Description

Oracle Financial Analytic applications were upgraded from 7.9.3 to 7.9.6.Also upgraded Informatica from 7.1.4 to 9.1.0, DAC 10.1.3.4.1 and OBIEE from 10.1.3.4.1 to 11.1.1.7.1. This upgrade project involved most of the Financial Analytic application mapping customizations. The customizations varied from high complexity to low complex mappings. DAC Upgrade and merge process was used to upgrade and merge DAC objects.

Confidential

Description

Microsoft CRM Dynamics 4.0 had to be warehoused and maintained for users to see opportunities of customers and related products and activities of sales reps information on reports. The requirement for storing history data on activities and opportunities has been worked on as an on-going project currently.

Confidential

Description

• Synapse is a TNS device delivered to customers for which they are billed. This ware house includes all information related to Synapse device and its customer.
• COMMSXL, CNP, etc. are some Key Performance Indicators in Payments business division of TNS. All information related to these subject areas is warehoused and maintained.
• Availability subject area includes data related to various Devices' uptime and down time and database uptime and down time.

Confidential

Environment: Informatica Power center 8.6, Oracle 10g, SQL, and PL/SQL

Description

The Wall Street Channel manages aspects of the sourcing and pricing of bulk and mini-bulk Acquisitions. There are currently three channels of business that source and purchase bulk and mini-bulk acquisitions, each channel currently have their own set of products and processes. This project will encompass multiple business units and result in a heightened need for a central data repository.

Confidential

Environment: Informatica Power center 8.6, Oracle 10g, SQL, and PL/SQL

Description

The second phase of the Performing Servicing Data Mart project will focus on data from the Rekon 2000 application, which manages the lien release process for the purposes of data analysis and for operational reporting.

Confidential

Environment: Informatica Power center 7.x, Oracle 10g, SQL, and PL/SQL

Description

This FDPA data warehouse is maintained to enable Pharmaceutical management and sales team to analyze the business over a period of time. Budgeting and forecasting decisions are based on the reports produced using this data warehouse. This is a Data Warehousing implementation involving Informatica using Oracle as database.

Confidential

Informatica Developer

Responsibilities

• Understand the whole business logic to be a part of Data Model Mapping Document review team.
• Extracted data from various sources like flat files and oracle tables.
• Developed complex Informatica mappings, mapplets and workflows and tested thoroughly unit testing and regression testing .
• Deployed the code to production successfully.
• Worked extensively to improve performance of the ETL jobs.

Confidential

Environment: Informatica Power center 7.1, Oracle 9i, MS SQL, PL/SQL, UNIX Shell Scripting, Windows, Toad, MS Visio.

Description

The Information Technology management team provides leadership, strategic direction, and support services at all levels for each of the business units within the Consumer Lending Group. The dashboard will allow senior IT managers the ability to quickly identify issues within the IT environment that ultimately impact our business partners.

Confidential

Environment: Informatica Power center 7.1, Oracle 9i, MS SQL, PL/SQL, UNIX Shell Scripting, Windows, Toad, MS Visio.

Description

Originations Operations is responsible for creating a Monthly Dashboard for key decision makers to manipulate, analyze, and report key performance indicators KPI . This is a manual process which resulted to deliver REL Operations Dashboard.

Confidential

Responsibilities

• As a Team Member report to Module Leader for all tasks and task status
• Continuous Client interaction at all stages for obtaining and understanding their requirements
• Convert the Functional requirements into a Tech Spec document
• Design the System Analysis and Design documents
• Do Coding of the Tech Spec prepared
• Perform Unit Testing on the modules coded
• Release the modules developed, into production environment and monitor the jobs till all of them were found to be successful in production region

Confidential

Analyst Programmer Primary Resource

Environment: COBOL II, DB2, IMS-DB, IMS-DC, JCL

Description

SE OFAC Daily Reports Enhancement project is taken up for the US government to impose trade restrictions and block the property of certain governments, and persons associated with that government. Restrictions also apply to Specially Designated Nationals SDNs such as terrorists and drug traffickers. The Office of Foreign Assets and Control OFAC maintain a list of these SDNs. The SDNs are searched for in the database on the basis of name and address and new matches found are entered into DB2 tables. An automated solution, i.e., online screening system is provided through this project for improving the Daily Based Report generation process and avoiding human errors.

Confidential

Analyst Programmer

Environment: COBOL II, DB2 and JCL.

Description

Merchant Based Conversions project is to search for the SE numbers in the database and generate new SE numbers. The generation of new SE Numbers includes pre-edit process that does the conversion of input record to a formatted layout and carries out Edit Checks, Risk Matrix Checks, and Duplicate Checks. In this process, records are marked good and bad and based on all the three criteria, SE number will be generated. Rigorous testing is done to check whether there are any duplicate SE numbers or invalid SE numbers.

Confidential

Environment: COBOL II, DB2, VSAM, JCL

Description

This application is to enable employees enter their hours of work day-to-day. This application helps find out time spent on each project by each employee and also for internal billing purpose in between different groups. In Back end HR can track vacation used and vacation left for each employee. It has online vacation request form to request vacation from the manager. Each employee has login id and their profile page to update their contact information, location and can update skill sets for HR uses.