Gaurav Handa Email & Phone Number

Worldwide, Oo

• Interfacing directly with client stakeholders to gather functional and technical requirements and translate into project designs• Driving progress of scrum workstreams, creating user story definition, process design, and assessment of business and launch readiness• Tracking application defects, coordinating defect resolution efforts, and documenting resolution details in order to mitigate risks• Delivering user manuals, training videos, design document including presentations, gap analysis reports, process flow diagrams

Worldwide, Oo

Client Project: Integrated Eligibility• Setup data gateway to fetch with large volume of data from Oracle servers and build intuitive, scalable and robust PowerBI reports• Design and implement data transformations for multi-dimensional analysis, trends, and calculating cumulative counts• Heading entire application development lifecycle, which includes requirements gathering, application configuration design, businessprocess analysis, scripting, code deployments, enhancement validation, triage of defects, change request, escalations, and urgent issuesClient Project: Data Migration• Setting up the Cloud Data Platform for the business users and educating them on How to use Snowflake Environment• Design data conversion strategies from Teradata and facilitate data conversion, mapping, and cleansing workshops for M&O teamClient Project: Data Modernization• Defined and documented components and interdependencies across legacy systems and data migration to establish current state• Facilitated client discovery workshops to define strategic goals and prioritize the use cases that would deliver the greatest value• Led design of future state architecture by recommending technology integrations to deliver solutions addressing top client pain points

Boston, Ma, Us

• Created a Tableau dashboard for course evaluation by using data from a Qualtrics survey and the findings of a sentiment analysis• Extracted data from the EMSI API to train and validate a recommendation system based on the Apriori and Eclat algorithms.• Working on the design, development, and implementation of Cloud Platform, including Snowflake, for enterprise-level clients through all phases of the Agile and Waterfall project delivery life cycles.• Automated the ETL for data in Snowflake to update in Redshift and visualizations in Quick sight, increasing accuracy by 15% and saving 12 hours each week.• Investigating user-reported issues using Python to determine root causes and remedies, implementing changes, and coordinating with business units, end users, and technical delivery teams• Improved the performance of the Badges dashboard generated by the Credly API by leveraging DAX in PowerBI for trend analysis and calculating cumulative counts

Marlborough, Massachusetts, Us

• Developed scenarios to execute the capabilities of image recognition and audio-video high point detection in conjunction with business and partner teams to comprehend and collect product ("Athena's Owl") needs.• Monitored daily operations, tracked performance, directed work for quality checks, reverse bench marking, and accuracy analysis to prioritize deliverables that met the product's KPIs. • Started identifying root causes of problems, which resulted in a 30% reduction in error, along with data quality control and governance.•Utilizing Google Cloud Platform’s (GCP) Big Query, on Cloud to store database queries, data mappings, functions, and procedures for inserting, updating, and deleting data•Directly interacting with client stakeholders to collect functional and technical requirements, analyze client needs, and translate needs into project designs while using Tableau's Prep Builder, Desktop, and Server to create on-premises and cloud-based applications to deliver solutions.

Mumbai, Maharashtra, In

• Examined the "Robomate+" product's current features and user data in order to identify gaps and create a framework for solutions to improve client retention.• Creating technical and functional specifications for application development using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), and Visual Studio, including screen layouts, navigation flows, logic diagrams, data models, process models, and pseudo code.• Streamlining the ETL pipeline to load data into SSMS via SSIS (SCD, Merge Join, Lookup, derived column).• Promoted A/B testing, which led to an increase of 30% in sales, 5% in conversion rates, and 17% in click-through rates.•Support implementations of Cloud-based technologies, including data cleansing and conversions, interface design and development, and Systems Development Life Cycle (SDLC), utilizing PowerBI Desktop and Server• Produced reports using pivot charts, slicers, what-if analysis, and Vlookup tables on Excel for WoW, monthly, quarterly, and YoY timelines

Mumbai, Maharashtra, In

• Redesigned user interface for ERP solution ("Equipmax") using HTML, CSS3, JavaScript, Bootstrap, and PHP to satisfy client requirements in accordance with business logic• Collaborated with back-end developers to use SDLC and Agile development techniques to link back-end logic with front-end layers and to be certain that the product is cross-platform.• Collecting User Interface (UI) design information, creating cloud-based data models, writing scripts for test scenarios, conducting system testing, and offering technical support to clients at the enterprise level.• Tracking application defects, coordinating defect resolution efforts, and documenting resolution details utilizing Advance Excel• Coordinated with cross-functional teams on continuous product integration through sprint planning, backlog refinement, and task management • Documented procedure with all use cases and flowcharts, trained user teams, and presented to stakeholders and end users

Master'S Degree, Data Analytics Engineering

Bachelor Of Engineering (B.E.), Computer Science