SUMMARY:

• Delivering 75+ Analytics solutions (SDLC cycle) within time. Saving 35% of client budget bagging new engagement from client creating & implementing data driven strategies that fuel growth including revenue& profits.
• Conducting 50+ workshops/events, leading 100+ Volunteers in 5 days National Festival India Rising 2015 & 200+ volunteers.
• 2 years of extensive Tableau Experience in Enterprise Environment, in Tableau 8.x and 9.x as a Developer and Business Analyst. Extensive Tableau
• Experience in Enterprise Environment and Tableau Administration. Leading & implementing complex projects & teams mitigating risks, managing requirements & working with project stakeholders while managing expectations at the department & project levels.
• Trusted person known& respected for leading successful change in projects, & developing enduring business continuity, & building credibility with executive teams& staff.
• Turning dry analysis into an exciting story that influences the direction of the business.
• Expertise in Functional & Technical aspects of Resources Industry Application Outage Communication System (Ventyx),Business Analyst(Smart Grid Operations, Meter Reading Management, Outage Management System),Data Visualization Master (SAP Xcelsius, SAP Crystal Reports, Tableau, Ventyx Focal Point),Oracle Pl/SQL,HP Software (Mercury) - Quality Center.

TECHNICAL SKILLS:

• SAP-Analytics
• Ventyx OMS & Focalpoint
• Tableau
• Business Objects-Crystal Report 11.0
• MS SQL
• Oracle-PL/SQL 11g
• SAP-Lumira
• Testing
• HP Software - Quality Center
• Business Objects (BOBJ)
• Oracle-BI (OBIEE Plus)
• Oracle-Warehouse Builder
• BIRT (Report)
• Java Enterprise Edition

WORK EXPERIENCE:

Business Analyst & Rapid Prototyping Tableau

Confidential, Racine, Wi

Responsibilities:

• Developing 16+ Analytics solution from large, rich data sets& creating& implementing data driven strategies that fuel growth including revenue& profits.
• Modeling, Designing& implementing 3 statistical / predictive models& cutting edge algorithms utilizing diverse sources of data to predict demand, supply, risk& price elasticity.
• Experience with creating ETL processes to source& link data.
• Utilizing 16 Tableau dashboards to identify trends& relationships between different pieces of data& translating analytical findings into Demand Planning& supply planning that driving value.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensive experience in Data Analysis

Dashboard SME

Confidential, Orange, CT

Responsibilities:

• Proven track record of assisting client in deciding the new tool, picking the new tool in 1-2 weeks& delivering 40+ deliverables end to end solution on new tool successfully.
• Participating in all phases of the Software Development Life Cycle (SDLC) for 40+ custom Analytics deliverables on Crystal ---Reports 11.5& Oracle 11g Relational Database Management System (RDBMS) for 4 clients companies(CNG,BGC,UI,SCG)
• Requirement Gathering, Functional Design Writing 5+ FD’s, Technical Design Writing over 20+ TD’s docs for 4 client companies
• Creating Test Script Writing 50+ scripts for 4 client companies
• Building Reports delivering 35+ Crystal Reports 11.5 end to end.
• Building Dashboards delivering 5+ Ventyx Focal point dashboards end to end
• Expertise in Oracle 11g PL/SQL Developer in Analysis, Design& Implementation of Business Applications on Oracle-Relational Database Management System (RDBMS).
• Expertise in Oracle 11g SQL& PL/SQL building Tables, Views, functions, Complex database objects like Stored Procedures, Triggers.
• Expertise in Oracle supplied packages, Dynamic SQL.
• Expertise in XML Data types extraction from the database tables.
• Managing Defect Triage & Change Requests on HPQC & post production support.
• Training 5 client resources on the project technologies& building help docs for admins to add, modify, delete or change rights for different users of different departments.
• Transitioning Handover to client resources.
• Designed the data requirements (data needed from historical database side) by analyzing the existing database schema.
• Configured& trained users to use Crystal Reports 11.5 & Ventyx focal point.
• Interacted with the users to analyze the changes/improvement required in existing report

Technologies: Business Object 11.2, Crystal Enterprise 11.5, Crystal Reports 11.5, Oracle 11g Pl/Sql 1.5.5, MS Excel 2000, Ventyx Focal Point, Windows 2000,XP, IIS 5.0.

Tableau Dashboard SME

Confidential

Responsibilities:

• Interacting with business users & performing Gap Analysis of Client requirements for 5 Dashboard.
• Reviewing business requirements& analyzing data sources form Excel/Oracle SQL Server for design of 5 Dashboard,
• Developing, testing, & production rolling over of reporting& analysis projects within Tableau Desktop.
• Working closely with business power users to create 5 reports/dashboards using tableau desktop.
• Designing& building various 2 analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Creating prompts customized Calculations, Conditions& Filter (Local, Global), creating guided navigation links for various analytical reports& dashboards.
• Creating Bullet graphs to determine profit generation by using measures& dimensions data from Oracle SQL Server& MS Excel.
• Combining views& reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers,& End Users.
• Scheduling data refresh on Tableau Server for weekly& monthly increments based on business change to ensure that the views& dashboards were displaying the changed data accurately.
• Involving in report tuning& report optimizations.
• Creating Test Cases& documenting the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards& handled the performance issues effectively.
• Testing dashboards to ensure data was matching as per the business requirements& if there were any changes in underlying data. Implementing 5 Interactive Complex Dashboards successfully on Tableau 8.0 enabling client to interactively analyze Testing scenarios & activities across releases based on KPI’s Quality of Input, Quality of Output, Scope Stability, Test Type Complexity.
• Achieving 100% efficiency in 1 month post implementation.

Senior System Analyst

Confidential

Responsibilities:

• Increasing 100% customer base for Utility Client by Maintaining 4 meter readings Dashboards pulling data from OBIEE integrated with Oracle OWB.
• Improving performance by 70% by carrying performance tuning.
• Increasing efficiency by 800% by setting multiple PMO process.
• Establishing self as SME for Oracle warehouse builder& OBIEE dashboard tool.
• Working on various aspects of dashboards of client. Extensively researching on all the required module of the tool& completing a big learning curve in just 4 weeks.
• Maintaining successfully the dashboards& reports of client with real time data.
• Developing parallel 4 complex Xcelsius dashboard for another client EDF consolidating bulk data easing decision making which were strategic in getting the deal.
• Expertise on Oracle 11g PL/SQL Developer in Analysis, Design& Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Maintaining Tables, Views, functions, Complex database objects like Stored Procedures, Triggers, Oracle supplied packages, Dynamic SQL.
• Expertise in XML Data types extraction from the database tables
• Managing Defect triage& Change Requests using HPQC & giving post production support.
• Optimizing complex SQL query for returning the BI report sent to client reducing the time for migration to less than 1 minute compared to initial 2.5-3 hours hours.

Data Analyst& Business Intelligence Expert

Confidential

Responsibilities:

• Implementing 4 Interactive Complex Dashboards successfully on SAP Xcelsius 8.0 enabling client to interactively analyze Testing scenarios & activities across releases based on KPI’s Quality of Input, Quality of Output, Scope Stability, Test Type Complexity.
• Achieving 100% efficiency in 1 month post implementation.
• Working on Dashboard for Energy & Utilities helping in creating scorecards, to get an accurate picture of the company’s operational& financial health, to identify gaps, causes, & remedial measures.
• Integrating SAP BI with SAP BO, pulling the data directly from BI to Xcelsius through BOBJ. Successfully completing the Integration& pulling the data with the help of Query
• As A Web Service (QAAWS) & Web Intelligence (WebI) Reports presenting the complete consumption of the region along with detailed analysis of 4 separate regions.
• Also displaying live Google Maps on dashboard completing the Incident Dashboard, mapping different KPI's of assets& failure analysis, which would give the management an up to date firsthand information of the incident occurring in their distribution network with the detailed analysis of the reliability of the power supply, easing the management’s Decision Making getting insight on Electrical Distribution System & Utility Domain

Quality Research Analyst

Confidential

Responsibilities:

• Implementing the proof of concept project for Migration of the Outage Management Capabilities from Ventyx focal point to Oracle NMS bagging 2+ projects for Confidential
• Mapping the competency from Ventyx Focal Point tool to Oracle OMS for Outage management.
• Also Worked on creation of FD's& TD's for Outage Management creating scenarios& analyzing the capability of NMS tool for the following aspects to be mapped in the Oracle NMS 1)Customer Call Management 2)Crew Management Report 3)ETR Metrics 4)Storm Management System

Data Analyst& Business Intelligence SME

Confidential

Responsibilities:

• Implemented 22 Complex Dashboards& Reports successfully enabling client to consolidate& communicate outage messages to internal& external stake holders
• Picking the new tool in 3-4 weeks& delivering 22+ deliverables end to end solution on new tool Ventyx Focal Point successfully.
• Participating in all phases of the Software Development Life Cycle (SDLC) for 22+ custom Analytics deliverables on Ventyx FocalPoint working across all 4 modules of tool.
• Received Confidential Celebrating Excellence Award received by top 1% employees
• Also delivering 4 complex dashboards in SAP Xcelsius2008.
• Working in Oracle 10g SQL& PL/SQL building Tables, Views, functions, Complex database objects like Stored Procedures, Triggers.
• Developing batch files for importing& exporting dashboard package reducing the migration time by 400% to 3 hours compared to initial 10-12 hours.
• Increasing customer satisfaction by 200% because of successful delivery
• Increasing performance of queries post performance tuning by 600%

Data Analyst& Dashboard Expert

Confidential

Responsibilities:

• Picking the new tool in 3-4 weeks SAP Xcelsius 2008& delivering& maintaining 3 complex dashboards for Rex BSS DEx& 8 medium complex dashboards.
• Displaying successfully latest monthly view on dashboard for Res BSS according to Operation Group as well as All India Level, & The Adm 100 Dashboards give Weekly view on the various stages of deals in progress.
• Training 2 resources in the SAP Xcelsius tool for maintenance of the dashboard.
• Successfully developing another RES BSS DEx Weekly Status Reporting Dashboard depicting the overall work portfolio& Progress of RES BSS Dex team members helping the Management to leverage the team performance& achieve higher targets.