Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
Generic

Sonia Shetty

Data Analyst/Business Analyst
Canton,MI

Summary

Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Perceptive and logical Data Analyst communicates well with both technical professionals and end-users to identify and translate business requirements. Experienced driving data accuracy and integrity to exceed quality standards. Builds and leads teams of talented professionals to develop valuable process solutions and meet business objectives.

Overview

14
14
years of professional experience
7
7
years of post-secondary education

Work History

Data Analyst

Gift Of Life Michigan
Ann Arbor, MI
02.2020 - Current
  • Identified and documented detailed business rules and use cases based on requirements analysis.
  • Researched and resolved issues regarding integrity of data flow into databases.
  • Tested data prediction algorithms based on historical data.
  • Designed and implemented tools to support strategic value chain optimization initiatives.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Utilized data visualization tools to effectively communicate business insights.
  • Used statistical methods to analyze data and generate useful business reports.
  • Developed tables, views and materialized views using SQL.
  • Participated in requirements meetings to understand business needs.
  • Collaborated with business-unit leaders to identify and prioritize problems.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.

Data Analyst

Robert Half
Ann Arbor, MI
04.2019 - 02.2020
  • Identified and documented detailed business rules and use cases based on requirements analysis.
  • Researched and resolved issues regarding integrity of data flow into databases.
  • Tested data prediction algorithms based on historical data.
  • Designed and implemented tools to support strategic value chain optimization initiatives.
  • Identified, analyzed and interpreted trends or patterns in complex data sets.
  • Developed required policies and procedures that reflected actual goals, tasks and workflows, while meeting all regulatory compliance requirements.

Teaching Assistant (Statistics)

College Of Business, University Of Michigan
Dearborn, MI
10.2017 - 12.2018

• Assist professor with classroom instructions, prepare presentations for lectures and grade the exam papers.

• Participate in the assessment process using a variety of methods and techniques and provide effective timely and appropriate feedback to students to support their learning. Support with research projects; engaged in literature searches

Business Analytics - Capstone Program

Gardner-White
Auburn Hills, MI
09.2017 - 10.2017

• Performed data cleaning & transformation on data sets using Python

• Converted data into actionable insights by predicting and modeling future outcomes. Integrated customer survey data, sales, inventory of product from Oracle DB into Qlik sense dashboard/visualization toolsets for data intelligence and analysis

• Developed Predictive model using Winter method technique, Predictive Model is being used to generate sales forecast & raise the Purchase order for the product with suppliers

• Created project status reports in PowerPoint and communicate project progress to clients and presented the final report to stakeholders.

Manager, Business Excellence Advisory

Accenture
Bangalore, Karnataka ,India
05.2015 - 07.2016

• Promote a culture of continuous process improvement across the bank which will ultimately lead to reduced operating costs, expanded capacity, reduced operating risk, improved customer service and greater employee engagement.

• Worked with cross-functional teams to collect, manage data and analytic projects. Solving client analytics problems and communicates results and methodologies.

• Led opportunity identification, design conceptualization with elements of process re-engineering, development & deployment of automated solutions using robotics to deliver tangible benefits for the organization

• Collaborated with Senior management and operations teams to lead business excellence programs and acting as a change agent.

• Identified improvement opportunities in different areas of the business and defining them on a charter. Leading/mentoring/facilitating the chartered BE projects using appropriate tools & Methodologies, to their successful completion, in time

• Working aggressively with all the Functional heads to close all the gaps/ issues within their functions

• Maintain and manage critical data of the business along with meaningful dashboards. Ensuring clear documentation of all the work/ projects/ activities as a storyboard. Worked with Data analysis tools like Alteryx, Tableau, SPSS, Minitab, JMP pro

Business Analyst

Deutsche Bank Group
Bangalore, Karnataka,India
10.2013 - 04.2015
  • Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
  • Led cross-functional teams to analyze and understand enterprise-wide operational impacts and opportunities of technology changes.
  • Evaluated trends to understand competitive environments and assess current strategies.
  • Performed competitor bench-marking analysis to identify manufacturing savings opportunities and potential product enhancements.

• Gather requirements for business definition and facilitate JAD/JAR sessions with stakeholders to refine functional requirement

• Responsible to write User stories, creating Use Cases, Use case diagrams, Workflow Diagrams, Sequence Diagrams, and Class Diagrams etc.

• Expert in Tracking and Managing the Requirements using Requirement Traceability Matrix (RTM) that controls numerous artifacts produced by the teams across the deliverables for a project.

• Identify and remove obstacles that will keep the team from achieving their goals

• Support the product owner in maintaining the product backlog and scheduling next release

• Communicate with clients and inform the organization about the customer business needs

Manager, Business Excellence

Deutsche Bank Group
Bangalore, Karnataka ,India
12.2006 - 10.2013
  • Controlled costs and optimized spending via restructuring of budgets for labor, capital assets, inventory purchasing and technology upgrades.
  • Expanded cross-functional organizational capacity by collaborating across departments on priorities, functions and common goals.
  • Reduced process bottlenecks by training and coaching employees on practices, procedures and performance strategies.
  • Recruited and hired top performers to add talent and value to department.

• Drove high impact projects involving multiple stakeholders for Productivity Improvement, TAT reduction and Accuracy improvement. Exhibited the necessary analytical skill sets & project management attributes to lead & drive Six Sigma, Lean, LEAP & Kaizen Projects for continuous process improvement

• Led Six Sigma trainings for several businesses focusing on process mapping, value stream mapping, data analysis, process improvement techniques, lean principle & tools, visual management system & other process improvement techniques

• Conducted Capacity Modeling exercise to right size operations in offshore & onshore locations like Bangalore, NY, London, & BHM

• Created Predictive Model to predict incoming volumes enabling operations to plan better for staffing in peak/non-peak season & constraint-based business models to identify impact on capacity due to variation in constraints like processing rate, return rates, queries

Education

Master of Science - Business Analytics With Information Technology And

University of Michigan - Dearborn
Dearborn, MI
01.2017 - 12.2018

MBA - Finance

Besant Vidya Kendra
Mangalore,Karnataka,India
06.2002 - 04.2004

Bachelor of Science - Computer Science

Canara College
Mangalore,India
06.1999 - 04.2002

Skills

Data formatting

undefined

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Data Analyst

Gift Of Life Michigan
02.2020 - Current

Data Analyst

Robert Half
04.2019 - 02.2020

Teaching Assistant (Statistics)

College Of Business, University Of Michigan
10.2017 - 12.2018

Business Analytics - Capstone Program

Gardner-White
09.2017 - 10.2017

Master of Science - Business Analytics With Information Technology And

University of Michigan - Dearborn
01.2017 - 12.2018

Manager, Business Excellence Advisory

Accenture
05.2015 - 07.2016

Business Analyst

Deutsche Bank Group
10.2013 - 04.2015

Manager, Business Excellence

Deutsche Bank Group
12.2006 - 10.2013

MBA - Finance

Besant Vidya Kendra
06.2002 - 04.2004

Bachelor of Science - Computer Science

Canara College
06.1999 - 04.2002
Sonia ShettyData Analyst/Business Analyst