Pankita Mehta

Experience

• 

  Deloitte Consulting

  Jan 2010 - Jan 2012

  Business Technology Analyst

  Business Technology Analyst, Information Management • Analyzed and critically evaluated client requirements and created Data Flow Diagrams and Entity Relationship diagrams• Performed source system analysis, data analysis, data modeling and understood data requirements for a cancer research firm to bring new personalized treatment options for patients• Built data marts using Informatica from 9 clinical source systems consisting of 400,000 patients that provided greater insights and accelerated clinical trials• Extensively worked on all stages of Software Development Cycle (SDLC) including data gathering, data mapping, build, unit testing and system testingProject Management Analyst • Assisted the project manager to identify project level milestones and integrate them into an overall program level plan• Effectively managed a team of 15 members and ensured project was completed within deadline and within budget.Leadership Role• Initiated the “Teach for India” community initiative and headed a group of 80 volunteers as the community lead• Managed the budget, promotion and event planning resulting in appreciation for the initiative from the top leaders Show less

• 

  Kelley School of Business

  Jul 2012 - Dec 2013

  Graduate Assistant

  Majored in Data Warehousing, Web analytics, Data Mining.Minor in Enterprise Resource Planning, mainly SAP

• 

  EY

  Jun 2013 - Aug 2013

  Intern
• 

  EY

  Jan 2014 - Jul 2017

  Senior Consultant

  - Created interactive Tableau dashboards with filters and parameters to help the client’s audit team review financial transactions and suspicious activity. This accelerated the verification process and increased the likelihood of finding discrepancies by 20%- Evaluated SAP Financial Accounting and Controlling (FICO), Procure to Pay (PTP) and Order to Cash OTC data by building audit scenarios and performed data cleansing using SQL- Designed and created Informatica workflows to convert data from 3 legacy source systems and SAP to Peoplesoft readable data based on business rules- Analyzed time and expense data to identify wrongly charged expenses and created reports showing expense by geography, business unit and project code - Performed anti money laundering investigations for a leading bank and analyzed more than 500 money transfers and transactions to highlight suspicious activities and people- Headed a team of 6 members and reviewed their work before passing it along to the client- Served as a mentor and career development coach for 3 new professionals- Received EY BRAVO awards for outstanding work for all three years at EY- Led the functional team for the financial unit of an automobile dealership company and assisted the automation of financial forecasting and budgeting by using Hyperion Planning. Communicated directly with the client to perform requirement gathering and analysis. Methodically conducted unit and integration testing of the forecasted data and checked the performance of Hyperion Planning webforms- Used TIDAL to automate Informatica jobs and created dependencies for file, schedule and email notifications to communicate the status of the workflow to functional team Show less

• 

  Slalom

  Jul 2017 - now

  Data Architect-Converted large scale business requirements into manageable technical stories and created attributes mapping, data cleansing and data quality standards-Collaborated with cross-functional teams to define and document data governance requirements which resulted in improved data quality and trust in data-Itemized and cataloged data assets and data lineage to build cloud data warehouse on Snowflake-Led the design and implementation of data governance framework including data stewardship and ownership which improved data securityData Strategist -Reviewed existing systems, data maturity and recommended updates related to new tools, data quality, governance policy and database setup-Interviewed multiples stakeholders from various business units to understand pain points related to data usage and documented current state, created future state architecture and data management processData Team Lead /Project Manager -Led a team of engineers to migrate data into Snowflake and headed project planning, execution, scope, staffing, communications and milestone deliverables-Managed end to end delivery of data migration projects ensuring data quality, on time deliverables, within budget and meeting client expectations Show less

  • Principal

    Jun 2022 - now

  • Data and Analytics Consultant

    Jul 2017 - now

  • Senior Consultant

    Aug 2019 - Jun 2022

  • Information Management Consultant

    Jul 2017 - Jul 2019