Key Result Areas:

· Configured & deployed customer solutions by facilitating out of the box dashboards and designing approx. 60 customized dashboards for different clients based on VMware IT Business Management (ETL/BI) Solution

· Identified variances between expenses & costs to monitor budget variances and facilitated more effective planning and budgeting/forecasting of spend on IT

· Conducted business requirements workshops and organized end-user training sessions to educate clients on product configuration & implementation with understanding of overlapping functions and other interdepartmental dependencies

Highlights:

· Proficiently automated the flow of the cost models, resulted in redirecting 95% of IT finance resources from data collection and aggregation to data analysis and achieved 100% chargeback of IT services for IT Cost Optimization

Played a key role in compiling IT financial data for 30 data sources/systems into data visualization platform & data analysis of IT service costs at enterprise & individual department level in a short span of time of 1-2 months.

Key Result Areas:

· Variance Analysis: Provided meaningful, concise and clear variance analysis to senior management on financial issues and performance and reasons thereof

Highlights:

· Ensured smooth offshore transition, operational excellence, process enhancement and closure of monthly financial cycle amounted to $2 Billion yearly

· Remarkably automated & improved the business process for closing the monthly finance cycle within record time of 10 days as against to 25 days and got “Bravo Award” for the same; recommended the data quality methodology to VP Finance

Key Result Areas:

· Generated Tableau/SQL/Excel reports function cross-functional teams to support Migration Factory a global initiative with more than 450 resources

· Created more than 100 SQL Ad-Hoc reports supporting business decisions by providing insights to improve accuracy and reduce the timeline of decision making

· Built and published 10 customized interactive reports and dashboards in Tableau for different business lines

· Gathered MIS/BI requirements for migration project by working with multiple cross-functional projects to understand data usage to meet the business SLAs related to the delivery of data/reports

· Engaged in creating database objects like tables, views, procedures, triggers, and functions using MS SQL in Data Warehouse using linked servers to provide definition, structure and to maintain data flow efficiency