Bharat Arora

Developed and implemented action plans to reduce production defects using RCA technique leveraging data science to increase profitability for unit of 40+ employees. Achieved 30% reduction in production defects in 6 months. Led the optimization of unit of 40+ employees utilization by analysing the trend of low utilization areas, giving insights and recommendations. Met the target of utilization increase by 7% leading to focus on more revenue generation. Performed EDA, built insights and provided recommendations for optimization of demand and supply to deliver enhancement of web portal (NexGen Web) using data from MS TFS tool & estimation excel tool. Achieved 11% savings. Responsible for People, Project, conflict management, Quarterly/Annual performance review, Leadership connects to demonstrate Dashboard created in MS TFS, MS Power BI, MS Excel, MS Power point. Data Extraction using SQL from Oracle for 1 year to support a divestiture of department (Sikorsky) from a client (UTC). Performed EDA, Feature Engineering and provided insights and recommendation on financial planning for Raytheon client employees to support their Retirement.

Responsible for daily huddles/stand up meetings, Onshore/Clients calls, Requirement's analysis, Functional Testing of US clients UTC, Carrier & Raytheon including Data administration of 300k-400k US participants in Oracle Database. End-to-End Data EDA, Transformation, mapping, Feature Engineering & Data Load into Oracle for Rockwell Collins client. Data Validation of 50k records from 20+ table using complex SQL queries. Generated 10+ big SQL reports. Responsible for end-to-end Web functionality testing of HRS services (Defined Benefits) & release planning.

Creating RTM, Testcases, performing Testing & Reviews, identifying Test participants via SQL. Generate SQL reports. Responsible for Business analysis, requirement analysis, Writing Specifications, mentoring, coaching new hires. Created a tool in excel to pull the data from oracle and compare testing expected and actual results. (Hewitt)

Responsible for Configuration of Admin tool using internal application for clients like DCS. Used DB2 as back end. Responsible for functionality, Integration, regression testing. Used queries to pull test participants from DB2.