Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

SHOBHITA TIWARI

Summary

Experienced Business Technology Consultant with 10 years of expertise in Data Engineering, Data Analytics, Reporting Solutions, Project Delivery, and Program Management. Successful track record in driving operational excellence through innovative data solutions, establishing robust data governance practices, and leading cross-functional teams to meet organizational goals. Proficient in advanced analytics, data visualization, project management, and promoting collaboration across departments. Skilled at translating complex data insights into actionable recommendations for senior leadership.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Business Technology Consultant

ZS Associates
07.2023 - Current
  • Strong expertise in designing and implementing end-to-end analytics solutions using modern technologies (AWS S3, EMR, EC2, RDS, Python, Tableau/Qlik, SQL), creating architectures and presenting actionable insights to senior leadership.
  • Mapping the client's business needs into the system features being implemented ensuring Agile development methodology is followed throughout the span of project.
  • Worked across omnichannel operations and reporting workstream encompassing dynamic targeting, NBA enabling business to track and measure effectiveness and design reports to visualize customer engagement index – CEI cohorts across US and Ex-US markets
  • Led project for rationalization of Patient Support Program reports and responsible for designing of solution, managing development on Tableau & Power BI, coordination across cross functional teams & demo to clients.
  • Designed and lead process improvement initiatives, identifying system bottlenecks and bringing in operational efficiency in legacy systems – 30% reduction in overall processing time and 12 days faster turnaround time in operations cycle.
  • Led a cross-functional team of 15 members (including product managers, UI/UX designers, developers, data engineers, and QA team) facilitating regular status
    meetings, resolving conflicts, and ensuring on-time delivery of project milestones
  • As the overall project manager from offshore, worked with various Business, IT and PMO stakeholders to conduct project activities in an agile collaborative manner managing the full product life cycle, from ideation to deploy, such as product evaluation, architectural-fit, platform capabilities, gap assessment, maturity mapping, implementation governance, risk mitigation
  • Collaborated with client executives to define project scope, objectives, and success criteria, aligning technology solutions with business goals, ensuring compliance with architectural best practices, standards, and guidelines

Business Technology Associate Consultant

ZS Associates
12.2020 - 06.2023
  • Extensively worked on APLD (Anonymized Patient Level Datasets such as SHS, IQVIA LAAD, Optum, Komodo) to design and implement Analytics & Data Quality Management Framework to deliver fit-for-purpose data ensuring seamless integration of various data sources into a unified platform
  • Independently drive the rationalization & revamping of existing Transparency system by automating the backend pipeline and revamping the existing set of reports enabling in 1-day execution turnaround for end-users.
  • Experience in collaborating with cross-functional business & IT teams to gather requirements, translate business needs into technical specifications, designing custom solutions to support global teams and clients for strategic decision-making.
  • Designed and integrated an AI-powered chatbot UI within Qlik Sense using custom extensions and REST APIs, enabling field representatives to access reports and insights through natural language queries.
  • Working in the Digital & Operations space with good experience in varied aspects of Data Warehousing Data Profiling, Data Modeling, Data Quality Management, ETL Development and Data Visualization Reporting Solutions, Storyboarding, Insights Generation.
  • Conducted training sessions for junior analysts on analytics techniques, SQL, Tableau and best practices.

Business Analyst

Housing.com
03.2019 - 12.2020
  • Gathering of business and technical requirements from Marketing, Delivery, Product team and derive metrics and KPIs to track business performance.
  • Experienced in building and maintaining ETL pipelines (Pentaho) to automate processes/jobs and using SQL/Python queries to perform data analysis and data profiling.
  • Created functional, technical design and data mapping documents for the same.
  • Generated dashboards/reports to comprehend Renewal, retention, business, marketing, user behavior, and engagement etc. using Tableau/Python.
  • Used Google Analytics, and Firebase platform, transformed data in BigQuery to perform multiple analysis to help increase traffic, user conversion, supply, leads on platform.
  • Supported the design of A/B tests and customer segmentation analysis to refine marketing and sales tactics.
  • Created visualizations and dashboards in Tableau for executive reporting, enhancing decision-making and business strategy.

Sr. BI Consultant

Icon Resources and Technologies
08.2017 - 03.2019
  • Led development project for Insurance client to build a Customer Data Mart.
  • Utilized SQL for functional requirement analysis and data model recommendations.
  • Designed & developed ETL jobs and transformations using Pentaho and developed Customer 360 Dashboard (which includes premiums, claims) in QlikView and Tableau.
  • Implemented regression models to predict customer behavior and developed on-demand NPrinting reports.
  • Received 'Star Icon Award' for excellent multitasking and project management.
  • Lead as business analyst at client onshore office for requirement gathering, solution design and demo.

System Engineer

Infosys Ltd
09.2015 - 06.2017
  • Worked in ETL project on Informatica, and performed cleansing of data using various PowerCenter transformations to meet business logics.
  • Converted QlikView charts into Qlik Sense and optimized applications.
  • Wrote SQL queries to extract data for ad-hoc analysis and reporting.

Education

Bachelor of Technology - Electronics and Communication Engineering

Guru Gobind Singh Indraprastha University
06.2015

Skills

    SQL, Data Engineering, Pentaho, Informatica, Business Analytics, Advanced Excel, AWS, Tableau, Qlik Sense, Power BI, Python, A/B Testing, Statistics, Snowflake, Agile Methodology, Google Analytics

Certification

  • PSM1 Certification, 10/01/22
  • Microsoft Certification: 70767 Implementing a Data Warehouse, 01/01/18

Timeline

Business Technology Consultant

ZS Associates
07.2023 - Current

Business Technology Associate Consultant

ZS Associates
12.2020 - 06.2023

Business Analyst

Housing.com
03.2019 - 12.2020

Sr. BI Consultant

Icon Resources and Technologies
08.2017 - 03.2019

System Engineer

Infosys Ltd
09.2015 - 06.2017

Bachelor of Technology - Electronics and Communication Engineering

Guru Gobind Singh Indraprastha University

Similar Profiles

CREATE PROFILE
SHOBHITA TIWARI