DINESH SINGH

Ph: +1-425-***-**** email:aczz6h@r.postjobfree.com

Professional Summary

Over 9.4 years of experience in development of Data Warehousing and Business intelligence solutions.

2.6 Years of Experience on MSBI-Power BI/SSRS/SSIS/Report builder with Oracle / SQL Server and Excel.

3 Years of Experience on BI Apps (OBIA)-Finance/Procurement/Projects

4 years of experience on ETL Informatica Power Center and DAC

4 years of experience OBIEE (Administration, Answers, Dashboards) for complex queries that are necessary for structured and ad-hoc reporting.

3.6 years of Experience on Oracle Warehouse Builder 10g R2/11g.

Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.

Having good Knowledge in Upgrade/Cloning/migration of OBIEE/BI Apps/OBIA /Informatica/DAC

Employment History

Working with CMM Level5 MindTree Ltd. NJ USA as a Module Lead since Sep 2013 to till date

Worked with Hexaware Technologies Ltd Chennai as a Senior Software Engineer since Jul 2012 to Mar 2013.

Worked with Forbes Marshal Pvt. Ltd. Pune as a Senior Technical Specialist since June 2011 to Jul 2012.

Worked with TCS Kollkata as a IT Analysist since Feb 2011 to May 2011 date

(Pay roll of WDC)

Worked with Rapid Effect Pvt. Ltd. Pune as a Senior Technical Specialist since Jul 2006 to Jan 2011.

Education

Bachelor of Computer Application (BCA).

Technical Skills

ETL and OLAP Tools

BI Apps, OBIA, OBIEE, Informatica, DAC, SSRS, SSIS, Power BI

RDBMS

Oracle 11g,10g, 9i, 8i,MSSQL Server

Programming Languages

SQL, PL/SQL

Business Intelligence Tools

OBIEE(10g,11g),OBISE1

Linguistic Skills

English, Hindi.

Project #1: Zebra Dashboard

Client : Zebra Technologies USA

Duration : Since Mar 2017 to till date

Environment : SSRS /Power BI Report builder

Source Database : Oracle and Excel

Role : Technical and Report Developer

Description:

Zebra is mainly into manufactures and sells marking, tracking and computer printing technologies. Its products include thermal barcode label and receipt printers, RFID smart label printers/encoders/fixed & handheld readers/antennas, and card and kiosk printers that are used for barcode labeling, personal identification and specialty printing principally in the manufacturing supply chain, retail, healthcare and government sectors.

Involved for Development activities for Sales and Supply Chain Dashboards and Analytics

Responsibilities: Development: Developed varies types of Analysis and Dashboards using Power BI and SSRS from Oracle and Excel Database.

Connect Power BI to Oracle and Excel for create various type of Dashboard and Reports.

Requirement gathering from End Client /End Users and providing solution for fulfill the goal.

Project #2: Bemis Sales Portal (BSP)

Client : Bemis Inc USA

Duration : Since Sep 2016 to Mar 2017

Environment : SSRS /Power BI Report builder

Role : Technical and Report Developer

Description:

Bemis Company, Inc. is a global manufacturer of flexible packaging and products. It’s also manufacturing for pressure-sensitive materials and crafts flexible and rigid plastic packaging for food, consumer products, medical and pharmaceutical.

Involving for Development and Support activities for Bemis Sales Portal (BSP).

Responsibilities: Development: Developed varies types of Analysis and Dashboards using SSRS

Project #3 Ticket Transaction History

Client : Microsoft USA

Duration : Since May 2016 to Sep 2016

Environment : SSRS and Power BI /Report builder

Role : Tech Lead and Report Developer

Description:

Involved for Development and Support of Ticket Transaction system for Microsoft. Using this system Microsoft can analyze day to day ticket flows and there status.

Responsibilities: Create dashboard and Analysis for Identifying ticket status

Project #4: TT-SITA-SFS-AMS

Client : SITA EARO UK

Duration : Since Sep 2013 to Mar 2016

Environment : BI Apps (Finance and Procurement / Projects Analysis)

Role : Module Lead

Description:

SITA is the world's leading specialist in air transport communications and information technology (IT). SITA work closely with every sector of the air transport community, innovating, developing and managing business solutions over the world's most extensive network - one that forms the "communication backbone" of the global air transport industry

Involved for Support and Development activities of BI Apps application

Responsibilities:

FS and TS design documents.

Development: ETL Mappings/ Work flow /Task / DAC Execution plans and OBIEE Reports (Answers/ Dashboards/ Alerts).

Support and Monitor: DAC Jobs and Data loading status and Logs / ITSM ticket.

Involved of code moving/Release activities from Dev/UAT/Prod Environment.

Project #5: GenMax European Version

Client : Spirax Sarco UK

Duration : Since Jun 2011 to Jun 2012

Environment : Oracle Warehouse Builder (10g R2) and OBISE

Role : ETL and Reports

Description:

Spirax Sarco is manufacturing unit. The Building and maintaining steam and industrial fluid plant, supplying an individual steam trap for the plants.

This Project is for the boiler efficiency monitoring system with built in analytics support.

Data for various parameters from different sensors are shown in real-time

and as well as historical data is saved to the data warehouse for analytical reporting purposes.

Responsibilities:

Designed the ETL Mapping using OWB 10gR2 to load data from CSV and Oracle into the Oracle staging area.

Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.

Project #6: Javelin Volume (BSM.EIP. Retail)

Client : British Telecommunication

Duration : Since Feb 2011 to May 2011

Environment : Oracle Warehouse Builder (10gr1)

Role : ETL Developer

Description:

This is project for generate the Customer Order “Re-Pricing for Low level Corporate Business” As per existing information, the business management identifies the low level corporate business and from Application they can re-price of the customer’s Order.

For that, Data is keeping into the Data mart.

Responsibilities:

Designed the ETL Mapping using OWB 10gR1 to load data from CSV and Oracle into the staging area.

Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.

Designed the LDM and KPI.

ETL Solution Design Document.

Project #7: Forbes Marshall Score Card BI Implementation

Client : Forbes Marshall

Duration : Since Apr 2010 to Jan 2011

Environment : Oracle Warehouse Builder (10gr2), OBIEE

Role : ETL Tech Lead

Description:

Forbes Marshall has been building steam engineering and control instrumentation solutions that work for process industry. Forbes Marshall’s business practices and processes have combined into a singular philosophy of being trusted partners who provide innovative solutions.

Score card Implementation:-

Balance score card is applicable to every individual, every Brach, every division and company as a whole. So participation of every individual is getting measured. Which Forbes Marshall wishing to get it through BI dashboards. Other than this there are some analytics reports on sales with some statutory reports on finance.

Responsibilities: Write the connectors, Write the ETL specification, create oracle procedure, Create mappings Using OWB 10gr2.

Designed the ETL Specification for STG and DW Areas.

Designed the ETL processes using OWB 10gR2 to load data from multiple sources into the staging area.

Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.

Designed the LDM and KPI.

Project #8: Billing Analysis for Wipro

Client : Wipro (3DNetwork)

Duration : Since Nov 2008 to Mar 2010

Environment : OBISE1

Role : ETL Tech Lead

Description:

3D Networks (W3D), a Wipro Subsidiary, is a leading systems integrator and a voice and data convergence specialist offering customized and integrated business communications solutions. RapidEffect therefore proposes the iAnalyze Enterprise reporting framework for this requirement.

This is project for generate the “Billing and Invoicing Analytics” for Wipro (3D Network).

RapidEffect has Build the data warehouse and BI solution for Billing and Invoicing. The client has three sources system (Sybase, CDR file, SQL server)

Responsibilities: Write the connectors, Write the ETL specification, create oracle procedure, Create mappings Using OWB 10gr2.

Designed the ETL Specification for STG and DW Areas.

Designed the ETL processes using OWB 10gR2 to load data from multiple sources into the staging area.

Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.

Designed the LDM and KPI.

Project #9: Retail Management for COR

Client : Hertz India Limited

Duration : Since Jan 2008 to Oct 2008

Environment : OWB 10g r2, Oracle 10g r2 Discoverer

Role : ETL Developer and Report Developer

Description:

Carz on Rent is the Licensee for Hertz in India, operates out of all major business cities and also fast expanding into state capitals and tourist destinations across India. rapidEffect is proposes to provide analytical solution to Carz on Rent for its analytical requirement in the areas Finance and Sales by providing a state of the art decision support system.

Responsibilities: Write the connectors, Write the ETL specification, create oracle procedure, Create DTS Packages, Create Analytics/report using oracle discoverer.

Designed the ETL Specification for Source System to STG and STG to DW.

Implemented the ETL processes using OWB 10gr2 to load data from sources system (SQL Server) into the staging.

Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.

Create Analytics and dash board analysis using oracle Discoverer.

Project #10: Sales Analysis for UIL

Client : Uniparts India Limited

Duration : Since May 2007 to Dec 2007

Environment : Oracle, Informatica 7.1, Oracle 10g R2 Discoverer

Role : ETL Developer

Description:

Gripwel Group / Uniparts India Limited (UIL) is the one of the largest manufacturers and exporters of tractor 3-point linkage parts. Rapid Effect proposes to provide Business Intelligence application to UIL for its analytical requirement in the areas of operations, finance and sales.

Responsibilities: Write the ETL specification, Create report using oracle discoverer.

Designed the ETL Specification for Source System to STG and STG to DW.

Implemented the ETL processes using Informatica Power Center to load data from sources system (SQL Server) into the DW (Oracle).

Developed mappings using Informatica Power Center for data loading. Created Workflow, scheduled & monitored session using Informatica Workflow Manager.

Create Analytics and dash board analysis using oracle Discoverer.

#11: Retail Management System for Mocha

Client : Impresario Saudi Arabia

Duration : Since Jul 2006 to Apr 2007

Environment : Oracle, Informatica 7.1, Oracle 10g R2 Discoverer

Role : ETL Developer

Description:

Impresario Entertainment and Hospitality Private Limited contains Mocha, Finale, Saltwater and Donet as its products. This project is to provide business intelligence analytics (BIA) solution for Impresario by creating a Data Warehouse for Retails Analysis System.

Responsibilities:

Write the ETL specification, Create report using oracle discoverer.

Designed the ETL Specification for Source System to STG and STG to DW.

Implemented the ETL processes using Informatica Power Center to load data from sources system (SQL Server) into the DW (Oracle).

Contact this candidate