resume

Deepak Kumar PrasadP-1, 2nd Floor, Sector 41, Gurgaon -122001

Email: [email protected] Mobile: +91-9958363259

Synopsis:- Total IT Experience of around 5.10 years.- ETL and Database development spanning around 4.5 years.- Having 4.3 Years of Data warehousing experience using Informatica Power Center 8.x, 9.1.0.- 1.5 years of experience into data modelling and datawarehousing.- Having 3.5 Years of Experience in Oracle 9i/10g/11g SQL and PL/SQL Development.- 2+ years of Experience in Unix & Scripting.- 1 year experience into Amazon Web Serivices-EC2,S3 & Redshift- 6 months experience into Hadoop and Hive.- Hands on experience into Redshift database.- Hands on experience into writing complex sql queries.- Practical understanding of the Data modeling (Dimensional &

Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

- Extensively worked on Informatica Designer Components –Source Analyzer, Target Designer, Mapping Designer & Mapplet Designer, Transformation Developer, and Workflow Manager.

- Possess poised knowledge of Data Warehousing and Data Mart.- Experience in Development,Debugging, Unit testing and Implementation of ETL process.- Good experience in writing stored procedures, functions and triggers as per need of the

application.- Good Programming knowledge in writing PL/SQL Stored Procedures, Functions, Packages and

Triggers.- Expertise in PL/SQL coding for creating Packages, Procedures, Functions and Database Triggers,

Performance & Tuning [SQL, PL/SQL,Database]- Streamlining the live procedures for greater efficiency by decreasing the error rate.- Experience in writing shell scripts to automate report generation.- Experience in using basic UNIX commands.- Worked with DBA in creating and managing table, indexes, table spaces, triggers, db links and

privileges.- A thorough professional with good communication skills and a quick learner.- Dedicated and highly ambitious to achieve personal as well as the organizational goals.- Mentored freshers and trained them in ETL, SQL and Shell scripting.

Technical Skills:- ETL Tools: Informatica PowerCenter 9.1, 8.5,Pervasive, SSIS- Database: Oracle 10g, SQL Server- Scripting: Unix Shell Scripting- Tools Used: Toad 9.1- Languages: PL SQL- Operating Systems: Windows XP/ Windows 7, Linux

Academic Profile:- B.E in Computer Science from Laxmi Devi Institute of Engineering and Technology,

Alwar( Rajasthan University, Jaipur ) with 65.00% in 2009.- 12th from C.B.S.E board (D.A.V. Public School, Hehal, Ranchi) with 80.40% in 2004.

mailto:[email protected]



- 10th from I.C.S.E board (Bishop Westcott School, Khunti, Ranchi) with 80.40% in 2002.

Professional Experience:

Jun 2016 –Till date: Axtria India Pvt. Ltd. as an Senior Associate.PROJECT NAME: Commercial Data ProcessingCLIENT: JannsenROLE: Data Modeler/ETL developerDescription: Developing of a data warehouse which stores data of Customers, Products, Payers, Retail & Non Retail sales which is further used downstream systems. Involves technologies like Hadoop, Hive, Unix, PySpark.

Roles and Responsibilty:- Involved in analysis of business requirements and data from various sources like IMS, iConnect,

etc.- Developed normalized Logical and Physical database models to design OLTP system.- Created dimensional model for the reporting system by identifying required dimensions and

facts.- Used forward engineering to create a Physical Data Model with DDL that best suits the

requirements from the Logical Data Model- Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)

- Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.

- Involved in writing shell scripts to handle automations and increase efficiency of the system.- Integrated the work tasks with relevant teams for smooth transition from testing to

implementation.

October 2014 – April 2016: Axtria India Pvt. Ltd. as an Associate.PROJECT NAME: Project VectorCLIENT: JannsenROLE: Data Modeler/ETL developerDescription: Developing of a datamart for the client which stores data for Managed Market which is further used for reporting dashboards in Tableau. The data includes sales, lives and formulary. It involved Oracle database and flat files as sources. Involved loading data from these sources into Redshift as the target.

Roles and Responsibilty:- Involved in analysis of business requirements and data from various sources like IMS,

Valuecentric, Elandas, Opus, Trial Card, etc.- Developed normalized Logical and Physical database models to design OLTP system.- Created dimensional model for the reporting system by identifying required dimensions and

facts




- Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model

- Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)

- Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.

- Writing complex sql queries to load data into redshift.- Involved in writing shell scripts to handle automations and increase efficiency of the system.- Integrated the work tasks with relevant teams for smooth transition from testing to

implementation.

PROJECT NAME: Inventiv HealthCIENT: Inventiv HealthROLE: Informatica DeveloperDescription: This involved creation of multi-Tenant Data warehouse on cloud. I was responsible for Territory Time Off and SLN validation module. Territory Time off module includes the tracking of the sales reps alignment and to track the job done by them as we need to calculate the perks of the Sales reps as it’s the important component of their salary.SLN Validation includes the Service license Number for states, where we track the Doctor’s License Expiration to practice in the particular state.

Roles and Responsibility:- Involved in analysis of business requirements and keeping track of data available from various

data sources, transform and load the data into Target Tables using Informatica Power Center.- Prepared documentation for ETL strategies, source versus destination system mappings.- Identification and Documentation of various data sources including the detailed Table/File/Field

level mappings between the source and target systems.- Writing PL SQL procedures, functions and database triggers as per requirement.- Created Informatica Mappings to build business rules to load data using transformations like

Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.

- Created necessary test plans and design documents for the mappings.- Implemented SCD methodology including Type 1, Type 2 to keep track of historical data.

June 2013 – October 2014: AON Hewitt, Gurgaon as a Software Engineer.PROJECT NAME: Flexible Benefits - HRISCLIENT: Multiple clientsROLE: Informatica DeveloperDescription: The objective of this project is to load HRIS Information of employees for the client. The HRIS information includes demographic information, flexible benefit information etc. The data is loaded in the respective datawarehouse of the clients which is further used for report generation.The ETL code is designed and developed keeping in mind the multi–client approach.




Roles and Responsibility:- Involved in analysis of business requirements and keeping track of data available from various

data sources, transform and load the data into Target Tables using Informatica Power Center.- Prepared documentation for ETL strategies, source versus destination system mappings.- Identification and Documentation of various data sources including the detailed Table/File/Field

level mappings between the source and target systems.- Created Informatica Mappings to build business rules to load data using transformations like

Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.

- Created necessary test plans and design documents for the mappings.- Implemented SCD methodology including Type 1, Type 2 to keep track of historical data.

PROJECT NAME: Data ConversionCLIENT: Canadian Imperial Bank of CommerceROLE: Informatica DeveloperDescription: HW Data Conversion: Convert flat files as per AON Hewitt’s Database architecture. A flat file from the client requires extracting and transformationsand loading them to Oracle databases, considering business requirements and technical designs.

Roles and Responsibility:- Taking Client call for requirement understanding.- Analyzing FRDs and understanding the technical requirements.- Developed various kinds of mappings, Creation of reusable Informatica repository objects, i.e.

Mapplets, Reusable transformations.- Analyzing Business logic and develop Sql queries for source data extraction.- Developed complex mappings in Informatica to load the data from various sources into the Data

Warehouse, using different transformations like Update Strategy, Router, Lookup, Sequence Generator, Filter, Sorter, Joiner, Aggregator, etc.

- Developed mappings using Informatica Power Center to load the data in slowly changing dimensions.

April 2011 – June 2013: Tech Mahindra, Noida as a Technical Associate.

PROJECT NAME: TelecompassCLIENT: MTSROLE: Informatica Developer/PL SQL Developer

Foris Support System: Foris Support System (FSS) is a CRM used for loading of CDRs and generating all the MIS reports required from the business. Data loading from one source to target used for generating reports using ETL process. Client Interaction for requirement gathering, analysis and finalization. Documentation. Created Informatica Mappings to build business rules to load data using transformations

like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.




Writing PL SQL procedures, functions and database triggers as per requirement. Performance tuning of live procedures. Worked with DBA in creating and managing table, indexes, table spaces, triggers, db

links and privileges.

MTS MBONUS : This is a sub project in Telecompass, which is an application developed with an objective to increase the revenue of the company by giving a little extra to customers at each touch point / stage of life cycle with MTS. A desired behavior from MTS subscribers CHOOSE & USE. Documentation. Primary resource for Development and support of the application. Responsible for submission of Daily and Monthly MBONUS report. Designing new procedures to maintain the quality. Automating the daily and weekly activities.

Vodafone Falcon: This is joint project between Vodafone and MTS in which Vodafone will be marketing the HSD Products and network services will be provided by MTS. Development and support of the CRM. Designing new procedures to maintain the quality. Automating the daily and weekly activities.

Environment: Oracle 11g ,UNIXTools Used: Toad 9.5, Oracle SQL Developer

Extra-Curricular Activities:- Received certificates for athletics and Karate at school level.- Stood first in Business Plan at Sangram 2009 held at L.I.E.T. Alwar.- Collecting new software/freeware.- Have keen interest in Stock Market.

Personal Details:Date of Birth: April 29, 1986Permanent Address: V.P.O-Baroudi, Dist.: Ranchi, Jharkhand - 835205


resume

Documents