Data Sql Server

Name : DEEPAK KUMAR

Phone : +1-919-***-****

E-mail : **.*****@*****.***

PROFESSIONAL SUMMARY:

8.5 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions. 3 years experience at client locations in USA and 5.5 years experience in India.

7+ years of experience in using Informatica PowerCenter 9.6/8.6 .

7+ years of experience in T-SQL,PL-SQL using Oracle 11g, SQL Server 2008, Informix.

2+ years of experience on other Scheduling and BI tools - ActiveBatch, Tableau, MS SSRS

Extensive experience in BI and expert in designing and developing solutions for Enterprise data warehouse (EDW) using Informatica Powercenter and Data Migrations.

Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows using Informatica Power Center and ActiveBatch.

Expertise in designing star schema and snow flake dimensional models, logical & physical modeling.

Vast experience in Designing and developing complex mappings from varied transformation logic like lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner etc.

Extensive experience in writing T-SQL for writing source qualifier SQL overrides.

Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.

Worked on onsite/offshore model.

Experience in mentoring and providing knowledge transfer to team members, support teams and customers.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 9.6/8.6

Databases: Oracle 11g, SQL Server 2008, Informix

Scheduling Tool: ActiveBatch

BI Tools: Tableau, MS SSRS

Programming Languages: T-SQL, PL/SQL, Unix Shell scripting, Informix 4gl, C, C++

EDUCATION:

B.Tech. in Electronics and communication engineering from Malviya National Institute of Technology Jaipur (MNIT Jaipur) in 2008

WORK EXPERIENCE :

Company: Accenture

Client: Biogen May 2014- till date

Role : Senior ETL Developer

BiogenComBI

Global Commercial Data Warehouse (GCDW) stores extracted analytical data from various sources like Hemphilia, Tecfidera, Aspect, Axis . Business user access this analytical data using Business Objects reporting tool.

Assigned Role Description: As a software Engineering professional, work across the Service Delivery Lifecycle to analyze, design, build, test, implement and/or maintain multiple system components or applications.

DETAILED RESPONSIBILITES:

Involved in ETL design, coding, testing and implementations.

Designed ETL processes for optimal performance.

Tuned the performance of complex Informatica and database objects and helped in reducing the overall batch run time.

Worked with cross functional teams to resolve the bugs and issues on timely manner.

Created the ETL best practices and mentored other team members.

Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup for designing and Optimizing. Used SQL over-riding in Source Qualifier for optimal performance.

Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

Created deployment documents, informatica install instructions, etc,.

Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to code.

Created SQL Queries to validate the data in both source and target databases.

worked on Unix scripting . Creating usnix scripts to handle the extracted file to make them available for other systems by renaming, ftp'ing, compressing .

Company: Tech Mahindra

Client : Client : CON-WAY May 2013 – May 2014

Role : WMS Developer

Warehouse Management System (PEVS+PSVS)

Con-Way, A Menlo Worldwide Company is amongst world leading Warehousing and Logistics US based Company. It uses Viaware Application for supporting its various customers for production. WMS team is responsible for fixing the bugs or amending new requirements as per customer’s requests. Technologies used are Informix 4gl, C/C++, which uses UNIX/Windows based platform & SQL Server 2008 as database.

ROLES AND RESPONSIBILITES:

PEVS:

Developing Enhancements for INFOR application – Viaware – For Production deployment

Interacting with Clients

PSVS:

Fixing issues and providing second level support for application Viaware for 22 customers and 32 Warehouses across globe.

Coordinating with various support teams and HP maintained Infrastructure teams and fixing issues within SLA.

Interacting with clients and customers, working on LIVE Production data/database.

Maintaining and bug/Issues tracking via JIRA and HP Service Center, HP Quality Center.

Reporting Project metrics to Client/Customers

Working with team of 10 at Onsite and offshore.

Company: Tech Mahindra

Client : CON-WAY Jan 2009 - May 2013

Role : ETL Developer

Menlo BI : Menlo Business Intelligence team gathers data from various Warehouse Management Systems (WMS) for the analysis purpose of product movement in the warehouse for varous client like Nike, Nike golf Raleigh, Triumph, Caterpiller, New Era, Diebold, Cannon, Tecktronics, Netapp, HP.

Con-Way Freight EBI (Enterprise Business Intelligence) builds Enterprise Data Warehouse and data models which moves data from point of origin into the Data Warehouse using Informatica (ETL tool), and collaborates on building microstrategy schema to expose the data for microstrategy analysis reporting which is readily available for Conway higher level management for decision making process on respective key performance indicators (KPI’s) such as line haul, freight flow, shipments, dock operations, weight & inspections, pricing,dock operations, finance, weight, inspections, pricing, driver run.

ROLES AND RESPONSIBILITES:

Worked with EBI DW and Menlo BI, which are prestigious projects of Con-way.

Involved in ETL design, coding, testing and implementations.

Designed ETL processes for optimal performance.

Expertise in replicating source data from MS SQL using Informatica Power exchange.

Created test cases to validate data.

Worked with Business Analysts, Informatica Developers and Informatica Administrators in Informatica Data Services.

Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.

Created database objects such as tables, views, stored procedures, functions in MS SQL.

Tuned the performance of complex Informatica mappings and database.

Worked with cross functional teams to resolve the bugs and issues on timely manner.

Created slowly changing dimensions & Fact tables to meet the business requirements.

Created the ETL best practices and mentored other team members.

Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup for designing and Optimizing.

Used SQL over-riding in Source Qualifier for optimal performance.

Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

Performed data validations by writing row count & column to column validation scripts.

Created deployment documents, informatica install instructions, etc,.

Involved in the defect analysis for UAT environment along with users to understand the data and to make any modifications to code.

Created SQL Queries to validate the data in both source and target databases.

Contact this candidate