Ankit R Bhangdia Email & Phone Number

Munich, De

• Played a pivotal role in reporting service of Enlighted’s $1M GSA contract with Siemens Real Estate (SRE) crucial for capacity, space planning & implementing overall real estate business strategy for SRE• Implemented & finalized a proof of concept for a real-time data API, reducing data update latency from 24 hours to just 5 minutes for three major clients in the US and EU.• Led end-to-end data pipeline development, leveraging SQL, Hive, and raw data from IoT sensors to drive a 20% increase in space optimization efficiency for clients.• Investigate different issues pertaining to our data pipeline to figure out the 5Ws in case a data pipeline breaks and designed some logical schemas as well as devised indexing and partioning strategy for Comfy’s database tables• Own the data pipeline end to end in terms of scheduling, maintenance through different tools such as airflow, kubernates, jupyterhub, hive, kafka to streamline & automate the business process reducing manual intervention by 16%. • Led optimization of Comfy Insights platform & Data API, achieving 17.4% improvement in workplace efficiency, employee experience, & carbon footprint reduction.• Reduced the query processing time & improved dashboard performance by 43.2% through advanced database optimization techniques. • Secured purchase order, valued at $10,000, from one of our estemmed clients by creating impactful space optimization reports demonstrating product value.• Collaborated cross-functionally with DevOps, Product Managers, QA, Support, C-suite members & end clients to gather requirements and deliver timely solutions.• Orchestrated and automated an ETL pipeline for IoT raw sensor data, optimizing business processes for holistic reporting, leading to a 23% increase in customer satisfaction.• Automated data pipeline updates within our proprietary data platform called sMAP, reducing manual intervention by 70%, thereby optimizing processes and significantly improving operational efficiency.

Irvine, California, Us

Seattle, Wa, Us

• Improve the query performance by 47% by employing different mechanisms such as creating aggregate tables, temp tables, CTE, clustered & non-clustered indexed columns, subqueries in the reporting layer.• Play an instrumental role in migrating the existing 50+ MS EXCEL reports to the visualization tool i.e., Quicksight to better serve the business needs & assisted the business in walking through the snowflake schema for them to answer several adhoc questions on the fly.• Create 10+ POCs reports & dashboards for the existing excel report in the visualization tool to have the sign-off from the leadership for migrating to the new platform. • Improve the automation rate and increase the overall productivity by 38% by deduping the duplicate reports, creating temp tables. materialized views, aggregate tables. • Increased automation rate and productivity by 38% through process optimization and elimination of duplicate reports.• Architect technical solutions for new and existing reporting processes, including table/materialized view/common table expressions/ETL, data flows & report design across multiple source systems to slash the manual intervention & increase productivity by 27%• Perform analysis to identify and understand issues or events. Reconcile and validate data from multiple sources and drive resolution for critical organizational insights• Nimble reporting & research through hypothesis-driven modeling, dashboards, visualizations, and briefs & clearly communicate any potential data discrepancies and/or reporting downtime, including specific root cause, steps to resolution, & resolution date to a large end-user base• Collaborated cross-functionally to migrate 50+manual Excel reports to Quicksight, enabling ad hoc analysis and enhancing business insights, resulting in a 20% increase in productivity organization-wide.

Santa Ana, Ca, Us

• Led 33% improvement in Risk Management reporting efficiency through meticulous database optimization technqiues such as implementing stored procedures, sub-queries, co-related queries, views, indexing, triggers, partioning & by creating aggregate tables, resulting in proactive process streamlining.• Implemented automated reporting dashboards, slashing manual efforts by 40% and providing comprehensive portfolio visibility for strategic planning.• Enhanced executive decision-making agility by 30% with timely insights delivery, empowering leadership with actionable data.• Extensive experience in Design, Development, Unit Tests, and Maintenance of reporting objects, SQL, SQL Script stored procedures & UDF, relational & dimensional modeling, updating Slowly Changing Dimensions• Collaborate with different teams such as Marketing, Purchase, Funding, Verification, Accounting to assess reporting requirements & communicate with C-suite executives, higher management, SVP, Board of Directors resulting in a 25% boost in risk assessment accuracy via streamlined KRI reporting.• Experience with automated underwriting systems, product & pricing engines, Loan Origination Systems (LOS), web conferencing tools, such as GoToMeeting and GoToWebinar• Identify deviations from forecast/expectations and explain variances & Contribute to loss forecasts, demographic and credit limit utilization analysis• Prepare exhibits and supporting materials & designing and building important production automated reporting dashboards using Tableau Desktop, TabCmd, Tableau Server & Tableau Online• Create different automation package workflow for the repeated task using SQL Server & SSIS to streamline different business process & workflows leading to an overall productivity increase of 37%Championed migration of essential Excel report across multiple locations to Tableau, resulting in a 74.6% reduction in manual data collection time from diverse sources.

Fullerton, Ca, Us

Fullerton, Ca, Us

• Enhanced website functionality by integrating live Facebook feeds and improving usability using OmniUpdate, HTML, CSS, PHP, and JavaScript. • Conducted web-analytics over website using Google Analytics, MS EXCEL & Facebook Insights resulting in better understanding of targeted audience • Optimized course enrollment processes and reduced manual work hours for undergraduate students by implementing ER diagram and SQL queries on MS Access database, resulting in a 31.2% decrease in administrative workload.• Collected, organized, reviewed, identified and analyzed survey data for patterns & created business data model providing high level analytical support to the project which decreased the department’s operating cost by 20%• Responsible for performing vlookup and hlookup, handling missing values, created data cleansing and data conversion rules, and identified anomalies in the survey data using MS EXCEL leading to an overall increase of 39% in data accuracy.

Burbank, Ca, Us

• Performed ETL (gathering, inspection, cleaning, transformation & modelling) on research data to discover useful insights & involved in business process modelling to provide feasible solutions for a specific business need• Collaborated with stakeholders in 10+ JAD sessions to develop tailored reports and dashboards using DOMO, Snowflake, enhancing decision-making tools & churning out meaningful insights.• Created fully functional database using MS ACCESS for the project and designed entity relationship diagram, database diagram for the project enabling streamlined data analysis and visualization workflows.• Analyzed Nielsen TV ratings data, informing content and marketing strategies with insightful demographic analysis.• Designed and developed SQL queries, created VBA macros for automation and performed descriptive statistics, regression analysis and created correlation matrix, scatterplots, histogram using MS EXCEL to amplify data analysis & business intelligence for the entire department

New York, Ny, Us

• Articulated BRD, FSD, SRS & TSD after carefully identifying, prioritizing & clarifying stakeholder’s functional & technical requirements, also created acceptance criteria, design mockups & wireframes for web based application to streamline the entire SDLC• Demonstrated expertise in, application log analysis for SQL server, root cause analysis using .NET, XML & executed 300 + manual & automation regression test cases daily for web based application• Ensured 100% JIRA delivery by creating user stories & performed UAT to test new features, changes & bug fixes from a user’s perspective in a staging environment prior to deployment• Reviewed functional &technical specifications to develop test plans & developed test scripts to do functional testing & regression testing for web based application using HP QC, JIRA, Selenium & JAVA• Performed manual testing of windows XML services & client mobile application focusing on functional &end-to-end testing to ensure that the output accurately reflect business requirements as outlined in requirements document• Orchestrated the development of unified frameworks for metric collection and visualization, driving efficiency improvements across the software development lifecycle, resulting in a 25% reduction in reporting time.• Acted as the primary liaison for development teams, providing expertise in programming languages and tools essential for efficient metric tracking and reporting, supporting over 20 project teams.• Implemented robust data pipelines using ETL principles, ensuring seamless data flow and integration to support accurate metric analysis, processing 500,000 data points daily.• Defined and refined key metrics for teams and stakeholders, aligning them with organizational goals to drive performance and success, resulting in a 30% increase in productivity and efficiency.• Collaborated with cross-functional teams like DevOps, data engineering, and QA to streamline metric collection and reporting processes.

Completed SAS training at TechData solutions Pvt Ltd and worked on an in-house project based on their Payroll systemPreparing course material for the new trainee who have just joined the organization and thereby mentor them in case they have any queries

Master Of Business Administration - Mba, Information Technology Project Management

Master Of Science - Ms, Management Information Systems, General

Bachelor Of Engineering (B.Eng.), Information Technology