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.
• 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.
• Led optimization of Comfy Insights platform & Data API, achieving 17.4% improvement in workplace efficiency, employee experience, & carbon footprint reduction.

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.
• 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.

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.
• 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.
• Experience with automated underwriting systems, product & pricing engines, Loan Origination Systems (LOS), web conferencing tools, such as GoToMeeting and GoToWebinar

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.

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.

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.
• 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.
• 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.

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