Software Engineer Data

MRUNMAYI D. KOKARDEKAR

*** ******** **, ******, ** 48187 217-***-**** ******************@*****.*** SUMMARY:

• Recent Master’s Graduate in Business Analytics coupled with 4 years of Professional Experience in Data Analysis and Software Development. Solution-driven, process-oriented and organized professional with strong analytical skills.

• Demonstrated history of producing accurate and timely work productivity while meeting deadlines under pressure.

• Committed to ongoing professional development and research to ensure currency and innovation in management and problem-solving. EDUCATION:

Master of Science, Business Analytics with Management Information Systems January 2017 - April 2018 College of Business, University of Michigan-Dearborn GPA: 3.71/4 Dearborn, MI Relevant Coursework: Data Mining and Forecasting, Applied Statistical Modeling, Spreadsheet Modeling and Applications, Predictive Modeling, Business Intelligence, Information Management. Bachelor of Engineering, Electronics and Communications Engineering August 2007 – August 2011 Marathwada Institute of Technology GPA: 3.5/4 Aurangabad, Maharashtra, India TECHNICAL SKILLS:

• JMP Pro, R, SQL, Python • Tableau, QlikView, Alteryx • Microsoft Excel (Pivot Table, Macros, VLOOKUP),

• Stat::Fit, Simio • Minitab, MATLAB • Microsoft – Access, PowerPoint, Word, PowerBI

• C, C++, Java • Data Mining and analytics • Requirement gathering and analysis

• SDLC, Agile Methodology • Oracle 10g Database • Oracle Siebel CRM 7.8, 8.0 (Certified)

• Oracle Siebel CRM 8.0 Certification; Tableau Certification, Introduction to R Certification. ANALYTICS PROJECTS:

Data Mining Project: Flint Water Crisis

• Analyzed Data and applied Data Mining algorithms – Regression Analysis, K-NN, Naïve Bayes, Neural Nets, Ensembles; identified the areas of Flint where the water lead content was at high risk. Results of analysis helped the city of Flint to start the work of changing lead pipes in the identified high-risk areas.

• Data cleaning and validation was performed using software JMP Pro which is a business unit of SAS. Visuals were plotted in Data Visualization Software Tableau and QlikView to resent the results.. Applied Forecasting Project: Bob Hill’s Call Center

• Identified the pattern of number of incoming calls to a customer service call center and forecasted the number of staff required to handle the increasing demand of calls. Different forecasting methods – ARIMA, MA, AR were applied using software Minitab.

• Based on results and analysis, forecasting model was suggested to employ a mixture of permanent and temporary staff. Information Management Project: NEMO Health Database

• Implemented a solution that helped NEMO health to ensure limited waste in spending due to travel and query on where the spending is taking place. The Project increased overall efficiency, information integrity and allowed NEMO Health to easily gather and organize the travel data in a retrievable manner, provided management with concise data to make economic decisions.

• Performed requirement elicitation and created data /process flow models and entity relationship diagrams; Designed logical database and ensured that the design met the client’s requirements. Designed physical database and implemented it using Microsoft Access. Performed functionality testing.

Business Intelligence Project: Border Crossing/Entry Data Analysis

• Analyzed the U.S.-Canada and U.S.-Mexico crossing (incoming and land) data provided by Bureau of Transportation Statistics to understand the trends of Border crossing. Plotted visuals in Tableau to gain insights about the data.

• Developed a Dashboard in Tableau which would provide the total number of crossings of each Border when field values are entered. PROFESSIONAL EXPERIENCE:

Infosys Public Limited Pune, Maharashtra, India

Technology Analyst August 2014 – June 2015

• Worked as a Product Developer on Oracle suite green field implementation for Canadian Public-Sector client.

• Analyzed Client’s business requirements and processes through document analysis, workshops, and collaborating with cross- functional teams to design and develop logical product model structure and Siebel UCM Application as per client’s requirements.

• Extracted and compiled, analyzed and validated data by running data manipulation SQL queries on Oracle database.

• Developed Test Cases and Use Case diagrams; Performed Functionality & Regression testing.

• Performed data analysis using SQL queries to develop and modify Order Management Journey. Tech Mahindra Limited Pune, Maharashtra, India

Software Engineer July 2011 – August 2014

• Performed duties as Developer of the Product Model Team in the project - OneView which is a path breaking CRM implementation of BT Retail, performing Creation/Modification of Products & Product Catalogs, Handling issues related to Products and Pricing.

• Worked closely with manager to analyze & document business requirements; Evaluate risks related to requirements implementation, testing processes; Identify and reconcile errors in client data to ensure accurate business requirements

• Extracted, compiled and analyzed data using SQL queries which included views, triggers, sequences, constraints, stored procedures, functions, cursors and packages on Oracle database to develop new functionalities, debug the errors, and update the existing ones.

• Worked on Agile Delivery Cycle and cater to CMMI processes for every delivery.

Contact this candidate