Shruti Deshmukh

  • Monmouth Junction US-NJ


I am a results oriented Data Analytics Specialist with over 9 years of visible achievements, including 7+ years with a BIG4, in project management, enterprisereporting, data visualization and data analysis. Expert troubleshooting skills combined with effective communication, quality control and accurate needs assessment abilities to consistently contribute to increasedproductivity. Self-motivated and supportive individual who drivesresults in team performance, consistently exceeding organizational expectations.Applies stronganalytical, architectural, organizational, and problemsolving skills to identify deficiencies and shortfalls, and then recommend improvements and enhancements. A strategicthinker with the ability to articulate complexsituations, identify key issues and determine the course of action.


  • Expert in building sophisticated relational databases in SQL Server & MS Access
  • Proficient in design and development Crystal Reports and Web analytics
  • Demonstrated experience in back-end programming with MS SQL and understanding of databases such as creation of stored procedures, user-defined functions, views, reports.
  • Proficient in design and development of ETL processes.
  • Proficient in designing Business Objects Universes, Web Intelligence and Desktop Intelligence Reports.
  • Demonstrated effective & efficient use of MS Excel (VBA, Macros, and Pivot tables), PowerPoint, and Visio in integrating and creating Infographic style data visualization reports

What Drives Me?

  • Challenging, stimulating activities and work settings
  • Deep diving in research on potential solutions to critical problems
  • Identifying and solving problems by determining options, pros/cons
  • Explore innovative ways of doing things
  • Developing a vision to get from today to tomorrow
  • What can I do today?” & “What could I do differently?”


  • Project Management
  • Database Design
  • Crystal Reports
  • Data Analysis and Reporting
  • Statistical Analysis        
  • Electronic Survey and reporting 
  • Process Design and mapping
  • Presentation Design    
  • Requirements Gathering



  • Resourcefulness
  • Adaptability
  • Optimism
  • Empathy
  • Calm under pressure.


  • Facilitating the work of others
  • Simplifying processes
  • Solving problems
  • Establishing good relationships
  • Providing high-quality reports and information.

Work History

Work History
Jul 2009 - Present

Manager - IT


Overall managed 120+ Infrastructure management reports from help desk systems to high end system monitoring tools. Managed reporting projects right from initiation thru implementation (includes requirements gathering, design, and execution). Assessed business needs to create and produced requirements and project scope document. Overall accountability for firm wide Business Objects BI platform.

  • Identified and recommended more than 20 process improvements to maximize report generation efficiencies and reduce time to market by 30%
  • Successfully managed multiple projects at any one time and work with relevant teams to ensure smooth service delivery
  • Implemented standard templates/formats for statistical reports (including trends, results, forecasting)
  • Championed standardization of field mappings, data dictionary, and universe and report documents
  • Designed, created, implemented, and tested data flows, workflows, scripts, and jobs for multiple projects
  • Study and understanding the business Scenarios of the existing systems, understanding the data and validating the data by applying the current business rules
  • Developed reports automation in Excel using VBA code
  • Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs
  • Communicated with the Database team and other programmers to guide them with the reports integration to implement Crystal reports in web based applications
  • Coached a team of Crystal Reports Developers, developed the reports as well as got them done by team on time for the releases
  • Performed necessary upgrades to data warehouse by creating new extraction procedures for data staging. Schema modifications included new data fields, indexing schemes and population rules
  • Updated data flow diagrams, data model, population procedures, and scripts. 
  • Received several Encore Awards: Encore awards are given for going above and beyond a person's responsibilities
Aug 2004 - Jun 2009

Senior Associate IT


  • Responsible for creating the complex enterprise reports (On demand, Adhoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc)
  • Designed, Developed and Implemented around 45 plus reports for 4 infrastructure departments
  • Worked with the end users and higher management to gather requirements for reports and data analysis
  • Responsible for scheduling the meetings with the existing application owners to discuss about the data and draw data extracting scenarios for the centralized repository
  • Created views and stored procedures for Reports using complex SQL, PL/SQL, T-SQL
  • Performed Troubleshooting, Optimizing, and fine-tuning the database Queries for efficiency & improved response time
  • Integrated Helpdesk ticket information with application usage information – this assisted project teams to compare usage Vs trouble tickets
  • Published the reports on a central server scheduled the reports depending on the users request to receive in different formats
  • Handled administrative tasks via Crystal Enterprise for reports publication, scheduling, user security
  • Involved in migration of the reports with the application /database upgrades


Jun 1995 - May 1998


Osmania University



ITIL Foundation v2011