1      10 Years of total IT experience in which 7 years of relevant experience in Data warehousing and 1 year of Data Migration and 1.5 year of Integration projects.

2      1 year Onsite (Norway) Experience in which proposed Datastage ETL tool to Client by Demo and got it implemented on our Project.

3      2 years’ experience on cognac reporting tool.

4      Worked on Agile framework & SAFE and board like JIRA & KANBAN.

5      Analyze the data from the sources, design data models and generate scripts to create necessary tables and corresponding records.

6     Strong experience on Datastage 11.5,IGC,Cognos,Oracle, Netezza and SQL Server in development.

7     Strong experience on Data Modelling using Erwin.

8      Performance tuning of jobs at job design level/ database level.

9      Scheduling of jobs by using Autosys tool.

10   Reviewing ETL jobs to maintain Quality Code.

11   Responsible for compliance to change management standards, including a lead role in design, developing TSDs (technical Specification), development, code reviews, implementation plans,

12   Involved in Data Modeling activities.

13   Creation of the low level design documents.

14   Good Exposure in UNIX to validate the data coming from Source.

15   Works within the team to make appropriate, effective decisions related to project and to initiate and follow-up on assigned tasks without supervision.

16   Experience In building Enterprise level Data warehouses.

17   Strong analytical & good communication Skills. Very keen and enthusiastic constant desire to learn.

Technical Skills:    

Technology     Tools 
DW/BI,BIGDATA    IBM Information Server (Datastage) -11.5,11.3,9.1,8.7,8.5,7.5,IGC,Cognos
Databases    Oracle 11g, Netezza 5.0, SQL Server 2005

Languages    C,C++,SQL,PL/SQL
Operating System    UNIX&Windows
Functional Areas    Banking,RetailManufacturing, Healthcare,Parmaceticals

Employment Profile:    

    Working as a Team Lead for Accenture, Bangalore from Aug 2014 to till date.

    Worked as a Senior Software Engineer for HCL Technologies, Bangalore from Dec 2013 till Aug 2014.

    Worked as a Senior Consultant for Cap Gemini, Bangalore from May 2010 till Dec 2013.

    Worked as a Senior Software Engineer for Virtusa, Chennai from April 2008 till March 2009.

    Worked as a Software Engineer for Accenture, Bangalore from July 2006 till April 2008.

Project Details:    

Project 1:

Project Title        :  NCS
Client            :  NORDEA, SCANDINAVIA
Role            :  ETL Developer
Environment                :  Data Stage 11.5,Oracle,Unix,Cognos
Duration        :  Aug 2014 till date

Description:  The purpose of this Project is to develop one common application for all the 4 Scandinavian countries to maintain the data of Collaterals such as Commercial and Real Estate, Shipping and oil Services. This application holds the data which is been migrated from Legacy systems. The Data is first been Cleansed before migrating. Datastage tool is used to perform Business Rules on the data which is to be migrated and to load into the collate application. 

Roles & responsibilities:

    Designed the High Level and Low level documents by discussing with business team in Erwin.
    Worked on Balanced optimization in Datastage 11.5 which reduces loading time to Databases.
    Creating the datamodel on the backend- this includes doing data transfornations, generating qvds, writing scripts,chosing the best schema that suits the data etc
    UI/Frontend –Developing creating charts , tables,lists,triggers, writing macros, doing calculations on the data to get required values, looking into color combinations, creating interactive objects for the user etc.

    Worked on Migration tool by changing the jobs from 8.5 to 11.5 for client requirement.
    Worked on Server routine and Parallel routine to process the complex requirements.
    Working on Agile Framework and working on Jira Board.

Project 2:

Project Title        :  e-bay BI-Platform
Client            :  e-bay, Pennsylvania 
Role            :  ETL Developer
Environment                :  Data Stage 9.0.1, UNIX, Oracle 11g, Netezza 5.0
Duration        :  Dec 2013 till Aug 2014

Description:  eBay provides Business data for Client users to evaluate performance of webstore metrics for several business areas.Data for the reports is sourced from multiple systems. The purpose of the eBay Enterprise ETL’s are to gather the data, cross reference and normalize data, and perform aggregations and calculations to improve reporting performance.

Clinets users can then access the standardized data to run standard reports and dashboards, or create self-service reports to investigate their business data and make decisions. Initial data and reports offered were prioritized by determining run statistics of base reports in the Net Accumen (V9/V10) reporting system.

ETL’s are broken out into business areas, loading dimensions and measures pertinent to the business area. Each individual business area is combined into a single workflow that can be erun in case of error. Data is loaded nightly, except for a real time feed which Aggregates order statistics every half hour for real time dashboard.

Roles & responsibilities:

    Analyze business requirements and preparing design documents for ETL code process.
    Coordinating with BI Team while developing jobs by raising issues.
    Support to the Development & Testing Team regarding Server Configuration and build related issues at Onsite/Offshore.
    Experience working with flat files, running ELT jobs concurrently.
    Preparation of Unit Test cases and Unit test results document and End –end testing of the jobs.
    Reviewing of the ETL jobs.
    Interacting with the client for the change requests (CRs) implementation including code enhancement and testing.
    Tuning SQL scripts for business purpose. 
    Job debugging/analysing for failures.

Project 3:

Project Title        :  Next Generation Sales Reporting (NGSR)
Client            :  GENERAL MOTORS, DETROIT
Role            :  ETL Developer
Environment                :  Data Stage 8.5, UNIX, Oracle 11g
Duration        :  Dec 2011 till Dec 2013

Description:  This Project is to centralize different sales reporting applications under one common data integration and reporting platform to reduce complexity, remove redundancies, and improve usability. The new application is called Vehicle Sales Tracking and Reporting (VSTAR) and the project is called Next Generation Sales Reporting (NGSR). We have multiple releases for this project. For the release 1 & release 2 of this project, one of the existing systems that to be migrated into VSTAR is EIS (Executive Information System). The Executive Information System (EIS) is a management reporting system to support executives for data review and decision-making.  This system provides users with a standard set of reports and graphs to review company performance and trends.
Roles & responsibilities:

    Analyze business requirements and preparing design documents for ETL code process.
    Coordinating with BI Team while developing jobs by raising issues.
    Support to the Development & Testing Team regarding Server Configuration and build related issues at Onsite/Offshore.
    Experience working with flat files, running ELT jobs concurrently.
    Preparation of Unit Test cases and Unit test results document and End –end testing of the jobs.
    Creation of the low level design documents.
    Reviewing of the ETL jobs.
    Interacting with the client for the change requests (CRs) implementation including code enhancement and testing.
    Interacting with TCS for Source files.
    Job debugging/analysing for failures.

Project 4:

Project Title        :  Aggregate Spend (AGS)
Client            :  Novo Nordisk, NJ
Role            :  ETL Developer
Environment                :  Data Stage 8.5, UNIX, Oracle 10g
Duration        :  July 2011 to Dec 2011
Description:  Aggregate Spend Integration System (AGS INT) which captures spend data from multiple data sources performs data validation checks, transformations and loads the transformed data into the Spend Repository. the extraction of Spend data from the Spend 

Repository based on the Cegedim Data Interface Document (DID) that will be sent to Cegedim AggregateSpend360(AGS360) for State and Federal Aggregate Spend compliance Reporting.
Roles & responsibilities:

    Designing and developing the jobs according to the client requirement on Datastage.
    Analyzing the mapping sheets and designed the Jobs.
    Coding and Reviewing ETL jobs in the Team.
    Job debugging/analysing for failures.
    Worked on HLD and LLD documents.
    Performed Unit Testing.

Project 5:

Project Title        :  Schneider Electric North America (SENA)
Client            :  SCHNEIDER, NA
Role            :  ETL Developer
Environment                :  Data Stage 8.0.1, UNIX, Oracle 9i
Duration        :  July 2010 to June 2011

Description: SENA is implementing a global Oracle based core system.  As part of this global initiative, SENA must initiate a lifecycle approach to the Remaining Product Load (RPL).  In this approach source files will be extracted from the Legacy systems and loaded into Oracle staging database, now all the objects (ETL processes) will extract source data from this staging area only and loading into Oracle for reporting purpose.
Roles & responsibilities:

    Development/Enhancing jobs according to the client requirement on Datastage.
    Preparing the design documents and analyzing the mapping sheets.
    Job debugging/analysing for failures.
    Coding and Reviewing ETL jobs in the Team.
    Worked on HLD and LLD documents.
    Updating the status to onshore, involving in the onshore-offshore calls.

Project 6:

Project Title                  : National Pricing system (NPS)
Client                            : Kaiser Permanente (KP)
Role                               : ETL Developer
Environment                 : DataStage 7.5.1(PX), Unix, SQL Server 2005
Duration                        : December 2008 to March 2009

Description: The National Pricing System (NPS) is an Experience Based Pricing system designed to provide consistent and accurate rating across the program while supporting product, segment and market requirements. NPS is developed as a pricing system for 

Kaiser Permanente.  At the heart of the system is what is referred to as the Rating 
Engine, which is the architectural component responsible for the calculations performed by the system.  The rating engine receives messages from the core application that initiate Rating Strings, which pull information from the database to perform a series of calculations ending in the rates for a particular quote.  

Roles and Responsibilities:

    Worked on Enhancement project.
    Analyzing existing shared containers. 
    Given Datastage Training in the Team.   
    Job debugging/analysing for failures. 
    Bug finding and fixing. 
    Creating HLD and LLD for the analysed shared containers.
    Perfoming Unit Testing.

Project 7:

Project Title                  : Informatics
Client                            : Independence Blue Cross (IBC)
Role                               : ETL Developer
Environment                  : DataStage 7.5.1(PX), Unix, oracle 9i
Duration                         : October 2007 to November 2008

Description: Independence Blue Cross and its subsidiaries are the Philadelphia region's largest health insurers with more than 2.6 million members locally, and 3.4 million overall. We employ nearly 9,500 people, annually process more than 32 million claims, and respond to over 6 million customer inquiries. The tables will be loaded once with historical data, and they will load incrementally on a daily basis.  This project specifically addresses historical and incremental data feeds from the Raw Data and Planmate extracts, for all claims except converted PPO claims.

Roles and Responsibilities:

    Involved in Design Phase.
    Involved in Design Walk Through
    Coding and Unit Testing
    Code Review and given estimation for Unit Testing
    Implemented Change Requests in the project.

Project 8:

Project Title        : General Practice Research Database (GPRD)
Client            : Medicines Healthcare Regulatory Agency (MHRA)
Role            : ETL Developer
Environment                : DataStage 7.5.1(PX), Unix, Oracle 9i
Duration        : August 2006 to September 2007

Description: MHRA (Medicines and Healthcare products Regulatory Agency) is the government agency which is responsible for ensuring the medicines and medical device work and are acceptably safe. MHRA enable greater access to product, and the timely 

introduction of innovative treatments and technologies that benefit patient and the public. The GPRD data is valuable to a range of users including government 
departments, pharmaceutical companies, academics and pharmaceutical regulators such as the MCA.  Services will be tailored for each of these groups enabling the MCA to 
set different price points for varying levels of service. All GPRD data will be stored permanently in an Oracle database called the Operational Data Store (ODS).  The data will be restructured and loaded into a Red Brick Data Warehouse (DW) to provide 
optimal performance.  The GPRD users will be provided with Business Objects tools for reporting and ad hoc research, dependent on their subscription level.  These tools will include the Set Analyzer tool to create patient cohorts for users requiring full research capabilities.

Roles and Responsibilities:

    Understanding existing business model and customer requirements.
    Work on Enhancement Project.
    Defects analysis and fixing (Data Correction if required).
    Code Review.
    Performing Unit Testing.