Sarojini Kumbhar

adtnrb@r.postjobfree.com/ +1-669-***-****

SUMMARY

• Around 10 years of IT experience in Database Design, Development, Data Warehousing, ETL in Business intelligence tools of Oracle, Tableau, Hadoop, Datastage, Teradata etc. with various business domains like Finance, Supply Chain, HR.

• Strong hands-on experience in dashboarding, data visualizations and analytics of complex datasets using Tableau desktop, Tableau Server, Tableau Prep, Tableau Public and multidimensional databases as Hadoop, Oracle.

• Created Tableau scorecards, dashboards using stack bars, bar charts, Trend line graphs or area charts or other combination of charts in Show me as per customer requirement.

• Good experience in creating custom Tableau views like Butterfly chart, Funnel chart, Donut chart as per business needs.

• Possesses detailed knowledge of handling and designing dashboard with large data volumes from multidimensional databases.

(Hadoop, Oracle)

• Implemented user group securities for dashboards along with routine tasks of dashboard scheduling and extract refresh on Tableau server.

• Expertise in using Hive Query for ETL to prepare big dataset ready for Tableau dashboards.

• Good exposure to Analytical modelling using ‘R’. Well familiar with R functionalities in Tableau.

• Excellent documentation & report writing skills, demonstrated ability to work with and support cross-functional project teams

• Proper understanding of technical trends, architectures and quick learner of new technologies and software.

• Good team leadership skills, ability to handle multiple tasks concurrently and invariably meet client expectations COMPETENCIES

Category Major Skills – Primary Minor Skills – Secondary Verticals Finance, HR, Supply Chain, Service Logistics Sales Domains /

Programming Skills

R, C, C++, PL/SQL Perl, HTML, Java

Tools & Techniques Tableau, R Studio, Power BI, Hive Query Language, Oracle EAS 9.3.1, Oracle EIS

7.1.6/9.3.1, Hyperion Web Analyzer, Datastage

Python, OBIEE 10g, Pentaho 5.4

Databases Hadoop, Oracle, MySQL, Teradata Netezza

Software Tools R Studio, Teradata SQL Assistant 12.0, Autosys, Notepad++, Toad, Hive Editor - HUE

Operating Systems Windows UNIX

ACADEMICS

Degree/Certification/Publication Year of Passing

Academic Qualification Bachelor of Engineering in Electronics and Telecommunication from Shivaji University

Maharashtra, India

2005

PROFESSIONAL EXPERIENCE

Zensar Technologies Ltd Pune May 2019 to July 2021 Project / Client Name - Global Service Logistics and Operations Business Analytics (GSLO BAC) / Cisco Systems Inc. Technologies – Tableau, Oracle PL SQL, Hadoop, Smartsheet, Microsoft Office, Rally tool Role: Technical Specialist

Project Profile

The Cisco Services, Global Service Logistics & Operations (GSLO) Business Analytics Center (BAC) is the one-stop shop for all Business Intelligence and Analytics needs within GSLO supporting the organization by transforming the data into insights for making better decisions BAC provides the breadth and depth of Order management, Asset Recovery Management, Planning, Service Delivery Performance (SDP), B2B Vendor Management areas to the business to make better decisions Contribution Highlights

• Day to day interaction with client for requirement gathering, effort estimation

• Technical assistance and mentoring to the team

• Defining framework / architecture for applications

• Develop data modelling scripts to extract the data required to meet functional areas as per business need

• Understanding gaps in existing IT solutions and proposing/designing process improvements, enhancements, and fixes

• Develop Data modelling scripts and Business flow diagrams to help build the dashboards

• Creation of reusable components / methods

• UAT Coordination with stake holders

• Coordinate with support team and extended teams for cross-team deliverable

• Performing the code review and fixes

• Weekly status meeting with client manager, Zensar manager and team members Zensar Technologies Ltd Pune Mar 2018 to Apr 2019

Project / Client Name - DCL-DIGITAL CUST LISTING/ Cisco Systems Inc. Technologies – Hadoop, HQL, Hue, MS Excel, R

Role- Technical Specialist

Project Profile

This project is aimed to analyze highly complex digital customer listening telemetry data. Various ETL techniques are used to process and decode, clean the data using hive. Mathematical models are built to analyze the processed data. This analysis is presented to the business to make critical business decisions based on customer feedback. Contribution Highlights:

• Responsible for requirement gathering from client

• Mentored team to Analyze, process and cleans highly complex large volume datasets (ETL)

• Performed cleaning and filtering on imported data using Hive

• Designed complex Hive queries and Data model

• Built statistical Models using ‘R’ to develop actionable insights & validation Zensar Technologies Ltd Pune Mar 2016 to Feb 2018

Project / Client Name –BIZ OPS KPI / CISCO Systems Technologies - Tableau, Hadoop, MySQL, MS Excel, Smartsheet, Oracle 11g, Toad, Perl, R Role - Senior Software Engineer

Project Profile

Dashboards under Quality Engagement department of CISCO enables decision makers with systematic metrics, data architecture and visualization to drive unprecedented customer/partner success. The BIZ OPS KPI dashboards helps communicate information clearly and efficiently to users using different data visualizations created using Tableau in combination with various databases Hadoop, MySQL.

Contribution Highlights

• End to end development of Tableau dashboards with Hadoop as backend to make complex and big data easily understandable

• Day to day interaction with client manager for requirement gathering, effort estimation

• Develop Data modelling scripts and Business flow diagrams to help build the dashboards

• Automation of tableau dashboards using automation scripts.

• Set Roles for specific users/theaters to provide data security.

• Create test plans to make sure that all dashboards/reports are giving accurate numbers and quality products.

• Used Statistical functions for analysis of data, developed Statistical Process Control charts which provide Standard deviation.

• Used Analytical Modelling using R to predict the business opportunities

• UAT Coordination with stake holders

• Coordinate with support team and extended teams for cross-team deliverable

• Optimization of reports to improve the performance to meet Business needs.

• Maintaining access level, publishing dashboards, scheduling extracts to server

• Maintaining project documentation

Zensar Technologies Ltd Pune Dec 2015 to Mar 2016

Project / Client Name – MDM Discount Dashboard / CISCO Systems Technologies - Tableau, Hadoop, MS Excel, MySQL

Role - Senior Software Engineer

Project Profile

MDM dashboard allows sales management the ability to monitor their MDM discounts vs target and determine quickly which sales regions, opportunity owners, and deal ID’s to focus on to help achieve their target. This report also provides the ability to look at MDM discount trends by quarter, by year, and by deal size. Contribution Highlights

• Responsible for complete Dashboard development life cycle on Tableau.

• Interact with business users and gather requirement, document it, analyzing the requirements and provide solutions to deliver best out of the product.

• Designed Tableau dashboards that give visualization/interactive reports which enables better visibility of business trends

• Created user level filter and user groups on tableau server.

• Set Roles for specific users/theaters to provide data security.

• Created test plans to make sure that all dashboards/reports are giving accurate numbers and quality products.

• Optimization of reports to improve the performance to meet Business needs.

• Published dashboards to server

• Scheduled database extracts and dashboard refresh on server Infosys Technologies Ltd Pune Feb 2011 to Apr 2011 Project / Client Name - BI Strategy / Bank of America Technologies – Datastage, Unix, Autosys

Role – Senior Systems Engineer

Project Profile

GTMS database was migrated to new server, and the regression testing for this has been carried out using test scripts and validation scripts in Datastage. The Datastage jobs were designed to compare the old and new database. UNIX scripts were used to automate the process of running Datastage jobs through autosys. Contribution Highlights

• Development of Datastage jobs & validation scripts in UNIX

• Development of Autosys jobs

• Unit testing and system integration testing of scripts and jobs.

• Providing fixes to the issues identified in testing phase.

• Creating and maintaining project documentation

Infosys Technologies Ltd Pune Jul 2010 to Jan 2011 Project / Client Name - GTMS / Bank of America

Technologies - Datastage, Autosys, Unix, Netezza

Role - Senior Systems Engineer

Project Profile

The project aimed to make effective use of Datastage & UNIX scripts. The project aimed to provide the ETL phase of HR & finance data of Bank using Datastage. This processed data is used to build the reports in OBIEE. To automate the batch processing of Datastage jobs, Autosys jobs were created in UNIX shell Contribution Highlights

• End to End execution of ETL project (Waterfall model)

• Complete Design & development of Datastage jobs

• Development of validation scripts in UNIX

• Design and development of Autosys jobs using UNIX shell scripts for scheduling of Datastage jobs

• Unit testing and system integration testing of the developed scripts and jobs.

• Providing fixes to the issues identified in UAT

• Post Production support

Infosys Technologies Ltd Pune Nov 2008 to Jun 2010 Project / Client Name - Associate Data & Information Management / Bank of America Technologies – Oracle Essbase 9.3.1, Hyperion Web Analyzer, Essbase Excel Add-In, Teradata SQL Assistant 12.0, Teradata Role - Senior Systems Engineer

Project Profile

The Associate data & Information Management (ADIM) is a Bank created system that provides consolidated, mission-critical data to specific personnel professionals and line managers. In this project we processed the HR data to organize it in the Multidimensional view using Essbase Cubes and to present the data to the user for Analysis purpose in the form of Web Analyzer reports & Drill through Reports.

Contribution Highlights

• Handled end to end development cycle of Project

• Gathering and Analysis of requirements, impact analysis, effort estimation.

• Complete Design of Multidimensional Data model using start schema in Essbase Integration Services

• Building Essbase Cubes in Essbase Administration Services.

• Design and Development of Web Analyzer Reports

• Design and development of Drill Through Reports

• Created detailed documentation of project

• Unit testing and system integration testing of the developed cubes and reports

• Providing fixes to the issues identified in testing phase.

• Post production support

Infosys Technologies Ltd Pune Nov 2006 to Oct 2008 Project / Client Name – KRAFT Foods Orbis Support / Kraft Foods Technologies - Oracle Financial Analyzer (OFA) 6.3, Oracle Express, Excel Add-In, Hyperion Web Analyzer Role - Systems Engineer

Project Profile

The ‘Operational Reporting & Business Information System’ (ORBIS) project aimed to create A standard P&L, Products, Channels, EVA, and Overhead solution for all Kraft International countries & Kraft North America to support the Financial Planning & Analysis process.

Unit wise Orbis components are:

• RDBMS – Integration layer that collects and stores all harmonized data. Role is to aggregate data, perform inter-company elimination, currency conversion (US$), and consistency checks between ORBIS components

• Backbone - OFA used for detailed segment reporting and planning data analysis in both KNAC and KIC Contribution Highlights

• Requirement gathering for change requests and impact analysis.

• Preparing Multidimensional Data Model & cube Design

• Complete Design of Reports for Consolidated financial data of all KRAFT backbones & Head quarters

• Handling User Access for consolidation layer of KRAFT.

• Data Consolidation layer Production Support

EMPLOYMENT HISTORY

Employer From To Designation

Zensar Technologies Ltd Dec 2015

Jul 2021

Technical Specialist

Senior Software Engineer

Free Lance work May 2011 Nov 2015 Software Developer Infosys Technologies Ltd Oct 2006 Apr 2011 Senior Systems Engineer

Contact this candidate