Sonia Shetty

Experience

• 

  HCL Technologies

  Dec 2004 - Dec 2006

  Senior Process Executive

  Nostro Reconciliation for Deutsche Bank, FrankfurtPost settlement function - Matching & ReconciliationMatching of internal ledgers and external statements in Smartstream & allocation of unmatched trades called nostro breaks for investigationReconciliation of Nostro accounts for OTC Derivative products using Smartstream Reconciliation toolInvestigation & resolution of nostro breaks as per the given SLAInteraction with Deutsche Bank's Middle Office w.r.t. any trade discrepanciesPreparation of daily MIS reporting results of work completed dailyInitial investigation of all incoming SwiftsConference calls with clients for quick resolution of trade discrepanciesInvestigation of Structured Derivative Trades, which includes High Yield trades requiring core investigationHandling incoming queries for Structured Derivative tradesAchievementsNominated by HCL as Subject Matter Expert (SME) to facilitate knowledge transfer from HCL to Deutsche Bank Global Services during the period Oct 06 to Dec 06'Star Performer' awardCross training imparted to members from Derivatives Documentation team in Nostro ReconciliationPreparation of DTP for GDS application - which is used in FX & MM deals Selected as a representative to attend conference calls with various clients on behalf of DB Frankfurt Experience in reconciliation of world major currencies like EUR & USDSoftwares used: SSR ,Summit ,CoronaSkills Involved: Investment Banking -Derivatives Products Show less

• 

  Deutsche Bank Global Services Pvt Ltd

  Dec 2006 - May 2015

  Development of a Pre-confirmation generation system for Fixed Income Business- Collection of business requirements, Creation of BRD, facilitation review and sign off of requirements with business users, validation with IT for feasibility-Responsible for project status reporting (progress vs plan / issues risks etc) on a weekly basis to program manager, business stakeholders, IT etc - Responsible for monitoring progress of each project phase from initiation to implementation and liaising with business stakeholders / Program manager / IT teamSoftwares used: Tableau, Minitab, MS Visio,Clarity.Skills Involved: Data Analytics, Statistics, BPM, Project Management, Show less • Lead high impact Six Sigma and Lean projects; Mentor Onshore & Offshore Six Sigma projects and Lean projects targeted to Save FTE (Increase efficiency), Increase Capacity, Accuracy, reduce risk exposure, generate value unlock.• Productivity analysis to eliminate 100% Non-STP volumes, Front to back process mapping to identify best practices, synergies between teams and standardization opportunities.• Identify constrains in existing system (technology) and propose plans for End user developed application (automation) to bridge gaps and improve efficiency.• Conduct Six sigma and Lean awareness training; Create platform where teams (operation and transformation) participate and brainstrorm topics / issues openly; Secure stakeholder and sponpors support (Buy-in) for change agenda.• Error rate tracking for teams; Identify failure modes with help of FMEA and add preventive checks to strengthen controls, Zero defect campaign, Gage R&R checks for reviewer certification, Green Star & team visual boards / huddles implementation. Show less Pre settlements and Post settlement function of Rates Derivatives Settlements Manage a small team of process executives (4-5 members)Monitoring the team's high risk and high value nostro breaks Weekly conference call with line managers and clientsEscalation of aged items to manager/client or MOParticipate in cross process trainingRunning daily reports on nostro outstandings and other internal reportsAssist process executives on break resolution and queriesUpdation of DTPs & KOPs to ensure they are accurate and currentPerform audit checks on process and preparation of Quality ReportsAssist Team Manager to distribute workPlanning and prioritizing workload and demandsBeing one of the senior members of the team, formulated plans to effectively handle quarterly Variance Swaps bulk expiryBack-up functions of Team Manager during his absenceAchievements'Star Performer' in Feb '08 for additional initiatives taken along with the daily SLAsWorked in different teams/process as per business requirements due to my flexibility and willingness to work across teamsSoftwares used: SSR ,Summit ,CoronaSkills Involved: Investment Banking -Derivatives Products Show less

  • Project Manager/Business Analysis

    Apr 2014 - May 2015

  • Six Sigma Black Belt, Manager - Transformation / Business Engineering

    Aug 2008 - Apr 2014

  • Process Supervisor - Product analyst

    Dec 2006 - Aug 2008
• 

  Deutsche Bank London - Birmingham

  Aug 2009 - Oct 2009

  Manager - Process Modeling

  Create process maps as per the BPMN standards using Telelogic & analyse processes identification of control points in the process

• 

  Deutsche Bank, Jacksonville USA

  Oct 2011 - Feb 2012

  Project Manager - iMPACT Capacity Modeling Deutsche Bank,

  --> Develop Capacity models to find out current resource utilization, Manager utility to measure cross team utilization opportunities.--> Use model output to analyse bottle neck stages, skill gap, standardization opportunities and forecast service performance.

• 

  Accenture India

  May 2015 - Jul 2016

  Business Advisory Associate Manager

  Strategic Consulting, leading transformation projects & Deployment of Six Sigma and Lean methodology.Responsibility of Operational Excellence for multiple clients, focused on:  Stabilizing newly migrated processes Interact with client/ internal stakeholders to drive and influence improvement objectives Driving Robotic Process Automation Improve SLA performance Driving Six Sigma and Lean projectSoftwares used: Tableau, Minitab, Microsoft Excel & Access, MS VisioSkills Involved: Data Analytics, Statistics,Six Sigma, Lean , Project Management Show less

• 

  Gardner-White

  Sept 2017 - Dec 2017

  Student Internship

  Completed a project as part of the Graduate program with the Gardner White to improve their Inventory Management System using Data Analytics concepts. The project was to propose an efficient Inventory management system to the company to optimize their Inventory management process. Developed Predictive model using Winter Method technique for forecasting the future sales numbers to plan their Inventory, Variables such as Purchase Order , Time delivery were considered to develop the model.• Integrated customer data from Excel into MS Access database and extracted relevant data using SQL• Developed Reports & Dashboards using Tableau and Qlik Sense for better visualization and analysis• Created Process flow/Simulation model using Alteryx • Prepared and presented reports to stakeholders• Model helped the company to improve their business process, enhance decision making and optimize storage of inventorySoftwares used: Tableau, Qlik Sense, R, JMP Pro, Minitab, SPSS, Microsoft Excel & Access, Alteryx.Skills Involved: Data Analytics, Statistics, Forecasting, Predictive Analytics Show less

• 

  University of Michigan-Dearborn

  Oct 2017 - Dec 2018

  Graduate Teaching Assistant

  Currently employed on a part-time basis in a on-campus role as a Graduate Teaching Assistant.

• 

  Robert Half

  Apr 2019 - Feb 2020

  Tableau Data Analyst

  • Developed and published multiple dashboards capturing Operational, Financial, and Project Performance metrics in Tableau.• Managed user, groups, folder structures, and security checks on Tableau server.• Utilized SQL Assistant to create advanced connections, join tables, and monitor queries for data blending.• Published reports and dashboards to Tableau server, utilizing URL's, Hyperlinks, and Filters for complex dashboards.

• 

  Gift of Life Michigan

  Feb 2020 - Mar 2023

  Business Intelligence Analyst(Power BI/Tableau)

  Key accomplishments include:* Developed and maintained over 50 SQL queries and views that streamlined business intelligence workflows, significantly improving data retrieval times by 40% across various departments within the organization.* Created complex reports using SSRS, including parameter-based, graphical, and drill-down reports, which enhanced the clarity of insights delivered to stakeholders by 35%.* Utilized Power BI and Tableau to gather, summarize data, and create impactful visualizations that led to a 25% increase in data-driven decision-making across the organization.* Collaborated with cross-functional teams to define report requirements, ensuring alignment with business objectives while reducing report generation time by 30%.Skills: SQL Development, Power BI, Tableau, SSRS Reporting, Data Visualization Show less

• 

  The University of Texas at Austin

  Jul 2023 - now

  Senior Business Analyst

  Key accomplishments include:* Spearheaded the deployment of Power BI and Tableau dashboards that transformed raw data into actionable insights, resulting in a 30% faster decision-making process across multiple university departments.* Enhanced operational efficiency by implementing Six Sigma methodologies that reduced process variation by 25%, significantly improving service delivery timelines for various university projects.* Developed SQL-based reporting services that streamlined data access for stakeholders, decreasing report generation time by 40%, which facilitated timely strategic decisions across the organization.* Collaborated with cross-functional teams to identify key performance indicators (KPIs), directly improving departmental performance metrics by 20% within the first year of implementation.Skills: Six Sigma Black Belt, Data Visualization, Power BI, Tableau, SQL Reporting Show less