Post Job Free

Resume

Sign in

Project Manager

Location:
Bengaluru, KA, 560001, India
Posted:
May 22, 2016

Contact this candidate

Resume:

ANKIT SHRIVASTAVA E-mail : acuwc4@r.postjobfree.com

ETL/ PLSQL DEVELOPER Mob: +91-879*******

IT Professional with 4 years of experience of comprehensive technical and Management skill set and expertise in Application Programming, Maintenance, Operations & ability to work in multidimensional environment.

SUMMARY OF SKILLS

Working experience in Data Warehouse applications, responsible for the Extraction, Transformation and Loading (ETL) of data from multiple sources into one database.

Develop conceptual and logical ETL applications to populate the data warehouse and various application databases.

Experience in developing and troubleshooting of ETL mappings.

Extensively used Informatica client tools – Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Understanding of Problem Management.

Good technical knowledge in Informatica, PL/SQL, Unix Shell Scripting, Oracle 11G,SSRS,control-m.

Established best practice methodologies and documentation standards for ETL work.

Ability to easily grasp new concepts. Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules, capable of working efficiently under pressure.

An enthusiastic, project-oriented team player with solid communication and leadership skills. Also with an ability to develop creative solutions for challenging client needs.

Creating Knowledge Articles & Technical Documents.

Understanding of Quality tools & processes.

Academic Qualifications

B.E. in Computer Science Engineering (2007-2011)from Rajiv Gandhi Technical University with 73 %.

Intermediate : From M.P.Board (2006-2007) 66% aggregate.

High School : From M.P.Board (2004-2005) 80% aggregate.

Work Experience

Employer

Job Title

From Date

To Date

Dell International Services

Software Development Analyst

1/12/2013

Till Date

Dell International Services

SVC IT Dev Program Sr. Assoc.

11/6/2012

30/11/2013

Software Development Analyst JUNE 2012 – Till Date

PROJECT EXPERIENCE

1.PROJECT TITLE

ITEM USAGE SIMPLIFICATION

Client

DELL

Duration

May 2014 – Jan 2015

Role

SSRS,PL/SQL,ETL Developer

Solution Environment

Visual Studio 2008,Informatica 9, Oracle 11g, Toad, Control–M

Brief Project Description

As part of this project we migrated Item Usage UI (.net web application) into SSRS reports.

Roles and Responsibilities

RDBMS database development using T-SQL programming, queries, stored procedures, views.

Development of reports on SSRS on SQL Server (2008).

Generated drill down, drill through, sub reports, multi parameterized reports.

Managed documents in SharePoint portal

Worked on RDL files and Stored Procedures to fix the errors and modifications of the reports.

Optimized queries tuned and monitored server performance.

Performed unit testing and path testing for application.

2.PROJECT TITLE

DELL – ITEM USAGE

Client

DELL

Duration

Aug 2012 – Till Date

Role

ETL Developer

Solution Environment

Informatica 9, Oracle 11g, Toad, Composite, Control–M and Unix

Hardware

Windows XP Client Machines, Unix Server

Brief Project Description

Item Usage tool is a Global Reporting Dash Board Tool for providing Complete information data related to Inventory, PO, Forecast, Bookings, Demand and SLC for the selected Region, CCN and the respective Item number.

Roles and Responsibilities

Extraction and Loading of data from Sybase and Oracle databases and loading into reporting Staging & Final Table database.

Extensively used different transformations like source qualifier, filter, Stored Procedure, aggregator, expression, connected and unconnected lookup, router and update strategy.

Development & Maintenance of Stored Procedures & Packages which is responsible for data Loading into Staging Table & Final Table.

Development & Maintenance of Shell Script which is responsible for Calling Workflows & other Data transfer mechanism.

Creation of Technical Document System Specs (TDS) following Dell’s guidelines.

Preparation of Unit test Cases & Involved in Data testing .

Deployment & PIT Testing after every Release .

Involved in Optimal Performance Tuning planning & Implementation to meet Challenging Business needs & High Volume data transfers.

Developing and maintaining procurement Class 1 Application.

Adherence to SDLC.

Handling Incident resolutions.

Following Change management process for any Deployments & Release.

Always been a part of Release and Deployment Team.

Preparing Technical Specification Documentation.

Achievements :

CSM (Certified Scrum Master) Agile methodology.

Got promotion in one year.

Received two ‘Silver Award ’, ‘Bronze Award’ and one ‘On the Spot Award‘ for hard work and dedication shown towards the work .

Recognised for logo creation of brainwaves group.

Extra Curricular Activities :

Participated in “ROBOKRITI : A Workshop on Robotics” held at MANIT, Bhopal.

1st Position in Poster presentation.

1st Position in painting competition.

3rd Position in “Bharat KoJaano (G.K. Competition)” organized by Bharat VikasParishad.

STRENGHTS

Adherence to time line of project deliverables.

Team Player.

Quality of work & responsibilities shouldered.

Ease to adapt to changes.

Flexible professional and enjoys learning new skills.

PERSONAL INFROMATION

Date of Birth 16th May 1990

Nationality Indian

Sex Male

Declaration

I declare that all above mentioned details furnished by me is true to my knowledge.

Place: Bangalore Ankit Shrivastava



Contact this candidate