Prakhar_Resume_Capgemini-MSBI

Visit Website Contact Author
no-image-4120

                                                       

 

 

 

 

Prakhar Shrivastava

in.linkedin.com/in/Prakhar
Shrivastava
             


Mail Id:prakhar07165@gmail.com;prakhar07165@hotmail.com
• Mobile: +91 8451991785

                                                                                                                               

P
R O F I L E:

PROFESSIONAL
SUMMARY – BI DEVELOPER

  • 5 years of experience as Business
    Intelligence Developer and Data Analyst in Production,
    Development and Staging Environments.
  • Strong Communication &
    Management skills with Excellent Role playing capabilities.
  • Extensive experience in Installation,
    Configuration and Updates of SQL Server.
  • Experience in BI
    Development and Deployment of DTS, SSIS packages
    from Excel, OLEDB,CSV,text
  • Experience in solving Real Time issues with Logging,
    package configuration, deployment of package, Error and Event
    Handling and performance tuning.
  • Experienced in programming tasks-Stored
    Procedures using SQL Server 2008/2012 with T-SQL.
  • Experienced in SDLC life cycle for Design,
    Development and Staging phases of the projects with support
    of Data-Flow, Process Models, E-R Diagrams.
  • Involved in migration of SSIS Packages 2008 CU5
    and troubleshoot migration issues.
  • Experience in providing Logging, Error
    handling by using Event Handler, and Custom Logging for SSIS Packages.
  • Experience in Performance Tuning in SSIS packages
    by using Row Transformations, Block and Unblock Transformations.
  • Expertise in generating reports using SQL
    Server Reporting Services, Crystal Reports, and MS Excel
  • Excellent T-SQL Developer skills including
    Stored Procedures, Indexed Views, User Defined Functions, Triggers, and
    Distributed Transactions.
  • Basic Understanding for SSAS tool
  • Intermediate level On SSRS

P
R O F E S S I O N A L    E X P E R I E
N C E 

Starting Career In Capgemini Consulting Mumbai from
1ST-MARCH-2011 TO Present

Career
Objecttive 

To be associated with a progressive organization which can provide me
with a dynamic work sphere to extract my inherent skills as a Professional, use
and develop my aptitude to further the organization’s objectives and also
attain my career targets in the progress with committed & dedicated  people

Experience
Summary 

 

Currenty Working as a Dataware Housing Consultant in the Technology
Services Division of Capgemini India Pvt. Ltd, Banglore since April 2014.
Worked as a developer on Microsoft sequel server 2008, PL SQL and Manual tester
for ETL ,SSIS reports. Had worked on Support, maintenance, testing and
enhancements for ETL tools and also worked with database Oracle(SQL) , DB2 and
Unix  scripting.Presently Working as a
database and SSIS developer.

 

T E C H N I C A L    S K I L L S

 

Operating System: Windows XP, 2000,2003,98

Databases / Programming Languages: Oracle 11i/10g, SSIS, Sequel server 2008, SQL, Basic
UNIX Shell scripting

Tools:  InfoSpheredatastage,
Informatica, OBIEE, SSIS, SSRS, SSAS

C
E R T I F I C A T I O N S:

 

Oracle
Certified Associate 9i(Cleared the paper 1z0-007)

 A C A D E M I C P R O F I L E

 

Graduation: Bachelor of Technology BE in Information and
Technology in 2010

From RGTU Bhopal 2006-2010

Marks in percentage: 72.22 %

P R O J E C T P R O F I L E

 

PROJECT#1:

Project Name: Sandvik Mining and Construction

Role: Team Member.

Organization: Capgemini Consulting Mumbai.

Duration: March 2011 to July 2011

Technologies: SSIS, QlickView, SQL PL/SQL, SQL Server 2005.

Project Description:

Sandvik
Mining and Construction or SMC are a business area within the Sandvik Group.
Aurora Data Mart (ADM) is a Business Intelligence solution for the companies
within SMC that uses the Aurora ERP system. Global Data Warehouse (GDW) is a
fairly complex data warehouse Implementation drawing data from 50 Source
Systems. The business goal is to have one common way of global reporting,
adopted by all SMC units, and to enable local reporting as required.

Contribution:

  • Data are loaded properly and in time before
    business hours
  • Resolve the incidents and requests as soon as
    possible so that performance and business do not get hit.
  • Prepare technical documentation.
  • Implement standard changes with the help of AM
    Tasks.
  • Grant access to various reports.
  • Adherence to SLA compliance

 

PROJECT#2:

Project Name: BRITISH AMERICAN TOBACCO
Role:
Team Member.

Organization: Capgemini
Consulting Mumbai.

Duration: August 2011 to
December 2012

Technologies: SSIS, Séquelle
server 2008, SQL Server 2008.

Project
Description:

The client is one of the world’s leading tobacco
companies. Project activities included Development of the information warehouse
of the company, including dashboard publishing for high end users, profiling
data provided then forwarding it to integrate it and insertion into the Data
warehouse.

Contribution:

  • Handling the extraction from the source.
  • Send the report to the end users
  • Documentation of extraction
  • Migration activities
  • Sap Bi Testing
  • Excel Reporting

 

PROJECT#3:

Project Name: TOPSI

Role: Team Member.

Duration: January 2013 to July 2013

Technologies: Squirrel, Toad, Putty, Control-M,
WinZip.

Project Description:

  • Worked on the Change Requests (Pl/SQL Code, Unix
    Scripts) by doing an initial impact analysis, estimations, and then test
    on ACCT ENV and final deployment into the Production environment.
  • Resolve functional and data issues with the ETL
    logics.
  • Worked on high-priority and critical ETL
    incidents and update work-log and status in BMC.
  • Maintained System Test, Integration Test,
    Acceptance Test and Production environments.
  • Communication with users and resolving their
    queries related to the retail business.
  • Ticket monitors using the BMC Remedy tool and
    register incidents via Service Desk.
  • Maintain all the Quality related processes by
    documenting the Installation Manual, Release      Note, System Documents, Unit Test
    Documents and Final Review Checklist.
  • Worked as a configuration Manager. Assist PQL in
    Quality Related Activities.

 

PROJECT#4:

Project Name : AOSMO

Role                 : Database
developer

Organization  : Capgemini Consulting Bangalore.

Duration         : August 2013-Till
Date

Technologies  : SSIS, Sequel server 2008, Command centre

Project Description:

The SMMAS organization is involved in each stage of a deal
starting from the pursuit stage to setting up services during transition to
being involved in delivering SMMAS services as a part of sustain.

Contribution:

  • Participates in project meeting(s) for project
    definition, needs assessment and design review.
  • Evaluates the needs and requirements of the users
    and provides technical expertise in the development of technical,
    structural and organizational specifications for SQL Database.
  • Determines appropriateness of data for Storage   and
    optimum storage organization.
  • Designs, develops, and integrates
    multi-dimensional database systems for internal and    external users/clients. Creates,
    documents and implements standards and/or modeling to Monitor and enhance
    the capacity and performance of the database. Codes complex programs and
    derives logical processes on technical platforms.
  • Performs analyses and reviews BI applications
    being released into production.