Omkar Sanjay Gawade Email and Phone Number

▪ Transitioned all ETL processes from Matillion to a custom-developed Python tool, incorporating advanced error logging and time tracking features to enhance the maintenance of the production database.▪ Successfully created ETL pipelines to make sure data is up to date to production databases.▪ Fabricated a classification model using XGboost classifier and automated machine learning ops to make sure model stays above the threshold model metrics using CI/CD methodologies.▪ Successfully implemented NLP methods to use bag of words, lemmatization and VADER libraries to get sentiment analysis, word cloud and automated topic detection.▪ Refactored legacy sql scripts to make them more efficient and reduce redundancies.▪ Successfully configured dev ops for data team using github to have version control, QA stage and push to production from Github to snowflake as soon as sql script is changed.▪ Generated synthetic data using deep learning methods to successfully anonymize data for product demos.▪ Successfully automated public API to incorporate external data into dbms tools to have extra data fields for machine learning models.

▪Successfully captured requirements and built an automated Topic detection and phrase extraction model by using LDA (latent dirichlet allocation) and Rake (Rapid automatic keyword extraction) methods to create a parent-child phrase hierarchy for all center departments.▪Successfully acted as a product owner for upgrading QA systems – the process entailed capturing QA requirements, prioritize features, market research, vendor feature comparison, competitive price analysis, scalability and sync with current systems. ▪Owned amazon contact lens integration, setup and PCI/PII audits for transcription, analytics and call dispositions. Captured requirements and formulated user stories to manage developers to build a function to block PII/PCI info from call audio.▪Captured requirements and successfully built and launched automated QA model in R programming which helps QA team track agent metrics like average sentiment, call dispositions and agent transfer rate.

▪Developed a single point Power BI reporting for all BPO centers of the Frontdoor Inc; this drove the average Courteous & Friendly score for call centers to rise from 3.6 to 4.1 (~14% increase).▪ Formulated ETL in SAS to create dataset that powers Cash-in-Lieu reporting and visualizations; The report made Finance aware of Outside authorizations of $22.75 M and CR reimbursements of $11.1M being processed as Cash-in-Lieu. ▪ Developed query in SAS and designed PBI dashboard which reports out all the customer discounts that company gives out.▪ Developed a validation tool which helped BPO managers validate the actual saves/cancels in the customer retention drives; The tool helped the team validate 15k saves since development. ▪ Developed text mining models to analyze numerous customer survey, social media and employee survey text. The text models provided various insights such as sentiment analysis, time series and department distribution.▪ Served as technical liaison in creation of a cost matrix to collect approx. repair cost over all 50 states, markets, zip code and trades. The matrix created was divided by trades the field reps serve; 5 million data points were collected by the tool.

Roles and Responsibilities:▪ Project Management support to the director of Vocational Truck team.▪ Leading the corporate audit for the Vocational Truck team.▪ Collaborating with Product Strategy, Sales. Finance and Design Department to collect information to build a Business Case for a new Product.▪ Leading Lesson's Learned workshops and documenting the top Lesson's learned for the program.▪ Managing and tracking the part releases for the vocational truck team.▪ Ad-hoc requests for Senior VP of Engineering Daimler Trucks North America.▪ Data Analytics using R to recommend the Truck features and characteristics to the sales team.▪ Data Visualizations in Tableau to ensure effective Decision making.▪ Planning and Execution to enhance responsibilities for the subject matter experts at Daimler.▪ Engineering Building Remodel Project planning and Coordination.▪ Implementing and managing an active Milestone tracker system for Technical system meetings.▪ Data and Resource Management to DSI- Intranet from the existing system.

The Dauch center for the Manufacturing Enterprises(DCMME)▪ Mange the project management, logistics and schedule meetings for all projects under DCMME.▪ Research, collect and analyze data profiling for various organizations and education centers in Indiana.▪ Educate the organizations about digitization of processes and interlink organizations to reduce costs.

1.Benchmark suppliers to determine best supplier and evaluate if the global supplier can manage all locations2.Analyze and determine cost, demand, feasibility of the global supplier and local suppliers.3.Perform quality management and maintenance planning of facilities in the plant.

Flair Automation Solutions is a Pune based organization started in May 2014. Flair automation solutions provide solutions for automotive body welding lines with expertise in Process, Mechanical & Controls Design, Assembly, Integration, Installation and Project Management. My tenure at Flair automation solutions has provided me with exposure to both technical and management sectors, each and every project has been unique in terms of skill requirement, approach and execution. I joined Flair Automation Solutions in march 2016 as a Project Trainee Engineer. The profile was unique as I was addressed to management aspects of engineering as well. The Roles and Responsibilities at the firm are listed as follows:• Detailing and dimensioning on Catia V5.• Analysis functions involving calculating strengths, Flow rates, Pressure drop and Failure points.• Layout work on AutoCAD.• Management functions entail maintenance and handling of tracker sheets that include standardizing of manufacturing parts, managing hour tables of projects, project reports and resource management.• Communicating with various suppliers and solving the queries in regard to projects.• Site Management.Projects:1. Timing Belt Calculation and Selection.2. Strength calculation and verifying the safety of the bolts and beams.3. Pillow plate and boiler selection.4. Mahindra Industrial Sealant-Flow rate, pipe size and nozzle selection5. Valiant pipe size and pump selection for air and water.6. JBM site installation and management.7. Maruti Suzuki Gurgaon site Press shifting, installation and management.8. Mahindra-ICV Roof takeout system installation and management.

QuEST Global, is an engineering consulting firm, founded in 1997. They began by offering various engineering services, primarily to Aerospace & Defence and Aeroengines industries. QuEST Global Services employs over 7500 workers across 9 countries with delivery centers in the US, Singapore, UK, Germany, Italy, Spain, France, Japan, and India.Global on highway trucks (GOHT), Caterpillar Inc.1.Converted design files from Catia to Unigraphics according to the customer requirements.2.Documented and Communicated the project report and status to the team lead and project manager.