PROFESSIONAL SUMMARY`

IT professional with *+ years of experience in Data Warehouse, Business Intelligence, requirements gathering and analysis, software design, development, testing and maintenance of software applications

Experience in ETL using Infosphere Information Server Datastage, Oracle and Unix.

Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator,Transformer

Experience in integration of various data sources (SQL Server,PL/SQL,Oracle,Teradata,Unstructure Data) into Staging area

Scheduled Datastage ETL loads using Datastage Director and Cron tab scheduler

Excellent Knowledge on IBM Cognos 10.1.1 BI Reporting tool Report Studio, Query Studio, Dashboard reports, Framework manager and Cognos administration

Created complex reports using Cognos report studio

Implemented various POCs using Qlik view reporting tool

Extensively used Oracle database through-out several projects

Experience in creating database design, end-end logical and physical data models

Experience in PL/SQL and SQL

Used Toad, Oracle SQL Developer to interact with Oracle database

Extensively used UNIX operating system

Used SVN and Star team version controls for code maintenance.

Extensivley used ERwin Datamodeling tool in the projects

Involved in development of all phases of software development life cycle (SDLC)

Excellent communication skills and ability to work effectively in all kinds of environments

Around 5 years of experience in Supply Chain Business in Pharma domain

TECHNICAL SKILLS

ETL Tools

Datastage 7.x,8.x & 11.x & SSIS

Reporting

IBM Cognos 10.1, Qlik view

Databases

Oracle, SQL Server

Tools

Toad, Putty, WinSCP, Pl/SQL developer

DataModeling Tools

ERwin

Version Controls

SVN & Star Team

Operating Systems

Unix, Windows

EMPLOYMENT SUMMARY

Organization

Tech Mahindra

Duration

5+ Yrs

Designation

Sr. Software Engineer

Project Domain

Healthcare and Life Sciences

Client

GlaxoSmithKline (GSK)

Description

GSK has a portfolio of products for major disease areas including asthma, cancer, virus control, infections, mental health, diabetes, and digestive conditions. It also has a large consumer healthcare division which produces and markets oral healthcare and nutritional products and over-the-counter medicines including Sensodyne, Boost, Horlicks, and Gaviscon.

PROFESSIONAL EXPERIENCE:

Client: GlaxoSmithKline Jun 2014 – Current

Role: Sr. ETL and Reporting Developer & On-site co ordinator

Project #1: Shipment Transport Analysis Tool

Tools & Technologies: IBM Infosphere Information Server Datastage 11.3, Oracle PL/SQL, Cognos Report Studio 10.1, Linux, StarTeam Tool

Project Description:

The Shipment Transport Analysis Tool (STAT) BI Solution functions as an information storage, analysis and reporting system for transportation and order-related data. It assists GSK’s Global Logistics Business in analyzing Transport Modeling in order to maximize Supply Chain efficiencies.

Contribution:.

Requirements gathering & analysis with business teams

Creating Technical solution design

Prepared high level and low level design documents for development purpose

Coded SQL queries to retrieve data from the database depending on the need

Upgarded Datastage project from 7.5 to 11.3

Managed and resolved design issues during different phases of Project

Coordinated with offshore team for development of respective modules

Created numerous complex queries involving joins and sub-queries for business requirements.

Created indexes for faster retrieval and improved query performance

Extensively used Todd Oracle Developer tool.

Used Cognos to develop reports such as KPI reports on shipments and order data analysis

Client: GlaxoSmithKline Dec 2013 – May 2014

Role: Sr. ETL Developer

Project #2: SKU Discontinuation System

Tools & Technologies: IBM Infosphere Information Server Datastage 9.1,IBM Cognos 10.0.1,Oracle PL/SQL,SQL Server,Unix, StarTeam Tool

Project Description:

SKU Discontinuation system provides the sites, franchises, markets and central teams a standard way of working and tools in the business to monitor and report discontinued SKUs against plan. The SKU discontinuation process as a performance management capability to track progress against plan, support the embedding of the standard process and avoid SKU proliferation.The maintaining of SKU complexity management shall be reflected into the KPI control measures of eradicating discontinued SKUs from all systems.

Contribution:

Requirements analysis with business teams

Created ETL jobs using join, Aggregator, Filter, Lookup, Joiner, Sort stages and guided team to design ETL jobs

Worked along with team creating Cognos reports using Cognos Reports studio

Prepared test cases for unit testing of ETL mappings

Worked with QA and support teams for project deployment and release

Used tools like winscp, putty and star team.

Client: GlaxoSmithKline May 2013 – Nov 2013

Role: Sr. ETL Developer

Project #3: MyLesson Reporting Tool for R&D / Vaccines Studies- ETL

Tools & Technologies: IBM Infosphere Information Server Datastage 8.5.1, Oracle PL/SQL,Unix, StarTeam Tool

Project Description:

Mylesson reporting tool provides training completion data and reports to R&D and Vaccines Clinical Study Teams who are required to monitor completion of training by Investigator Site Staff and External Study Personnel to comply with regulatory requirements.

Contribution:

Requirements analysis with business teams

Created ETL jobs using join, Aggregator, Filter, Lookup, Joiner, Sort stages.

Modified existing PL/SQL stored procedures and ETL jobs for reporting purpose

Prepared test cases for unit testing of ETL mappings

Coordinated with offshore team for development of respective modules

Worked with QA and support teams for project deployment and release

Used tools like winscp, putty and star team.

Client: GlaxoSmithKline Oct 2012 – Apr 2013

Role: ETL Developer

Project #4: Registration and Medication Ordering System

Tools & Technologies: IBM Infosphere Information Server Datastage 8.5.1, Oracle PL/SQL,VSED, SVN Tool

Project Description:

RAMOS (Registration and Medication Ordering System) is a clinical trials management and monitoring tool. It allows GSK staff to register, randomize subjects, dispense medication and monitor study enrolment, supplies and stock levels.

Contribution:

Requirements gathering and analysis with business team

Prepared high level and low level design documents

Created ETL jobs using real-time web services

Build of test cases for testing scripts.

Involved in support during testing phase and post production

Worked closely with users during UAT phase

Performed the deployemnet cativities of this application

Client: GlaxoSmithKline Jul 2011 – Sep 2012

Role: ETL/Reporting Developer

Project #5: DMS Malaysia Cognos Reporting System

Tools & Technologies: Microsoft BI-SSIS,Cognos 8.4.1,StarTeam Tool

Project Description:

Distributor Management System (DMS) system is a key system that helps GSK business gain competitive advantage across Asia Pacific region. DMS is also planned for replacement to local EIS (Executive Information System) system.

Contribution:

Created ETL jobs using Microsoft SSIS services.

Created various documents throughout the project life cycle.

Created various sales reports using Cognos reporting tool.

Involved in deployment & post deployment support.

EDUCATION:

Master Of Computer Applications (M.C.A) from Jawaharlal Nehru Technological University (JNTU) Hyderabad, India.

Contact this candidate