Printing tool Download PDF

Summary

Dynamic and result oriented person with good communication skills.

• Total 9.5 years of experience in Business Analytics, Metrics and Revenue Assurance.
• Currently working with Citigroup as Assistant Manager for HR reporting team.
• Before this worked with CapGemini as Senior Consultant for Project Assignment which includes Requirement Gathering, implementation on online solution & testing. Project Feasibility and Sustain Support Analysis
• Analytical mind, blend of technical and functional expertise

Work experience

Jun 2014Present

Assistant Manager

CitiGroup
  • Leading Process and Adhoc Reporting Team
  • Responsible for preparing goals & reviews & growth of Resources
  • Trainings & mentoring resources to reach their goals
  • Ensuring Continuous improvement by identifying opportunity in  various areas
  • Ensuring all ad hoc requests are serviced within agreed SLA and of highest quality
  • Support advanced analytics projects related to predictive analytics, data mining, and advanced modeling
  • Continuously review existing processes and identify opportunities to drive standardization and efficiency while delivering highest quality reports
  • Ensure extremely high level of control environment in managing sensitive HR data and reporting, build solid process documentation and must deliver satisfactory Risk & Control review against any and all processes performed by the group
  • Facilitating reporting solutions that meet or exceed the needs of the client
  • Ensuring the delivery of analytics and reporting according to a defined schedule that supports the requirements of Analytics & Reporting and the client
  • Ensuring adherence to information security guidelines
  • Utilizing Oracle BO-WEBI, SQL, Excel, Access, Word and Power Point to extract and manipulate large amounts of data, perform analysis and create executive level reporting
  • Finding opportunity for automation of reports and process.

 

Automations

  • Automated various complicated reports for effort reductions total savings around 75% of total durations

 

Technical

  • Tech support to one of the most major process of MD Promotions

 

Process

  • Implemented Skill Matrix for Gap Trainings and work allocation
  • Introduce Lean A3 concepts for problem resolutions

 

 

 

 

Dec 2008Jun 2014

Senior Consultant

Capgemini India Pvt
  • Requirements gathering, understanding and programming report for online interface
  • Monitor Run activities for assigned projects (GM, Coco-Cola, COKE NA, and other coke Projects), which should primarily focus on the timeliness, quality and accuracy of information provided for the deliverable. Identify any Change Requests and communicate to the Overall Run Lead.
  • SPOC for Delivery Teams to provide/gather inputs on existing/new requirements. Analyze gaps between As-Is and In Scope activities for Run and communicate to Overall Run Lead
  • Developing the knowledge, technical skills and core consulting behaviors required to succeed in BI Application Services.
  • Develop Reporting Approach, template and methodology
  • Set up - Data extract and Database design for store procedures and codes, Connected Excel template for refresh and production
  • Participate in review meetings
  • Define process for consolidating RCAs & developing SIPs for Service Level breaches
  • Quality checks on SLA Report, Hosting Internal and Client SLA Review calls and track action items
  • Development of Contractual and Internal reports
  • Monitoring of Reporting Databases
  • Determines appropriateness of data for storage and optimum storage organization.
  • Designs, develops, and integrates Multi-Dimensional database systems for clients.
  • Collect, consolidate, analyze, and report on metrics specified in the Service Level Agreements (SLAs), as well as all other major metrics and measurements
  • Resource Management
  • Respond to ad-hoc requests such as to provide an analysis of projects with late milestones
  • Automation of Reports and Metrics, Creation of tools(Automated tool for generating reports and metrics)
  • Compliance monitoring with SLAs, flagging any areas of risk or concern
  • Implementing Best practice across projects
  • Analyze metrics data:
  • Identify trends, performance issues, and opportunities for improvement
  • Identify common failure modes
  • Identify projects that require executive review
  • Measuring the Overall Asset Effective (OAE)
  • Tools
    • Project Management Deck:- Deck for Transition & Run Team. All required details of the accounts are capture in the handbook which helps in running the account during the contract term.
    • Global Document Repository GDR Automations:- A tool is created to download the data from SharePoint to excel for creating compliance reports, Manual process is changed to automated process which provides authenticate and accurate data. Tool also provides 10 hrs savings per month.
    • Resource Management Portal: - Due to Multiple sources (Sponsor, RT Team, and GMID on-boarding Form) sending details to multiple points for on-boarding/off-boarding of resource in finance team to get update in Staffing roster. With limited details in roster leads to scattered process and high turnaround time is required to create resource based reports. High number of follow-ups is requires for processing on-boarding/off-boarding of resource.

 

A tool in SharePoint is created which captures & stores the data online and readily available to the stake holders. Online data also help in creation of resource based reports. Process follow-up by SMO is reduced by 20%. Service Desk manual effort is reduced as they don’t have to create multiple tickets for various tools, the effort saving will be around 20%.A single sponsor for submitting the request.  Same source data can be utilized by the Service Desk for submitting the request to Tools Team. A single form is available for submitting the request for user. Approximate Annual Savings: - 3,32,652/- INR.

 

An A3 is open to take the responsibility of maintaining resources details from GM finance Team. A framework work is created using SharePoint and database. Framework provides data capturing in Sharepoint and validation and approval process in SQl. SMO reports and process automated overall. Approximate efforts saving of 100 hrs in a month.

 

 

  • Processes
    • Project Staff FTE: - With help of Lean A3 tool, Process for collecting data is revamped and introduced the validations process, which helps in getting proper resource details and authenticate reporting to GM. Effort savings and process maturity is achieved.
    • Clarity Compliance: - Process gap is raised for not driving compliance and follow-up on clarity timesheet, A3 is raised and significance growth is achieved from 50% to 98%.

 

  • Effort optimizations
    • Training: - Scatter and unmanaged data cleanup process is changed by introducing Capgemini global id of each resource in my learning team training data and resource data. Which helps 8 hrs long process reduced to 2 hrs
    • Operating Asset Effectiveness (OAE): - Incorrect & unstructured queries which results in mismatch of tickets and hours volume. Execution of query takes long due to undefined exclusion criteria. A3 tool is used and significant results are obtained Query run time reduced to 18 minutes from 32 minutes & 20 exclusions are set.

 

Achievements

Received Project Star award for best performance

Mar 2008Dec 2008

Business Analyst

Hughes

Business Analyst in communication Job Profile Managing regional MIS Preparation of Flash information as per the process. Revenue Assurance. Billing Process.

  • Managing regional MIS
  • Preparation of Flash information as per the process.
  • Revenue Assurance.
  • Billing Process.
Jul 2006Aug 2007

Revenue Assurance in Airtel Bharti Mumbai

Revenue Assurance in Airtel Bharti Mumbai

Job Profile

  • Analyze gaps and opportunity areas for enhancing usage through study and analysis of behavior of the customer based on usage according to scheme/tariff, geographical segments, and vintage, in comparison to previous month and in comparison to other customers having the same profile.
  • Look at how tariffs are performing in terms of acquisition, ARPU, usage, envisaged vs. actual through a cost-benefit analysis.
  • Analysis of business cases to find out whether they are delivering what was promised. If not, seeking explanation from the sales team and coming up with solutions, for delivering the promised revenue, in consultation with them.
  • Tracking the efficiency of various programs through comparison of the achievement vs. targets set at the time of launch.
  • Monitor the performance of the top revenue accounts on daily/weekly basis.

Education

Feb 2006Dec 2007

Master in Business Administration MBA (DUAL Specialization)

NIMS - National Institute of  Management Studies

2 Year regular - Dual Specialization Course

  • SAP Consultancy
  • E-Business Management

2000

Graduate Diploma in Business Administration GDBA

NIMS - National Institute of Management Studies 

4 year regular course 

Oct 2002

Grade 12th - Senior Secondary

NIOS
Jun 2000

Grade 10th - Secondary 

Board of Secondary Education

Central Academy - Jodhpur Rajasthan

Certifications

2013

Lean & Six Sigma YB

Capgemini

Score  A

2011

ITIL Foundation V3

PeopleCert

Score - A

20052007

GNIIT in Information System Management

NIIT - National Institute of Information Technology

Track

Seminar

Project

Software

Sem 1

Data warehouse

-

Presentation on Datawarehouse

Sem 2

XML & VS.Net

Et all Super Store

In this, team has to automate the store by the way of making database in ms access & others software by giving the presentation documentation & demonstration. 

Sem 3

MS SQL 2005

BookTreasure online HR Management system

In this, team has to make project by the help of the vs.net & other software by giving Presentation, Documentation & Demonstration.

Sem 4

Business Intelligence

Speedster Motor Corporation

In this, team has to make project by Making Data warehouse and End User interface by giving Presentation, Documentation & Demonstration.

Skills

Business IntelligenceManagement
Microsoft SQL ServerMicrosoft Office
Business AnalysisSharePoint
Program ManagementITIL
Data WarehousingProcess Improvement
Crystal ReportsMSBI
DatabasesRevenue Assurance
Business ObjectsAnalytics
Requirements AnalysisLeadership
Software Project ManagementBusiness Process
Visual StudioTeam Management
TelecommunicationsConsulting
Solution ArchitectureRequirements Gathering