AMRUTA KAMBLE

ac39dq@r.postjobfree.com +1-469-***-**** https://www.linkedin.com/in/amruta-kamble SUMMARY

* ***** *********** ************ ** requirement gathering, analyzing, problem solving and troubleshooting data for business solutions. Proficient in Advanced Excel and preparing analysis reports through analytics and visualization tools. PROFESSIONAL EXPERIENCE

Business Analyst Intern, Seceon Inc., Westford, MA, USA, www.seceon.com Jun 17 - Aug 17

• Performed feasibility analysis to define data requirements and modified present layout for various CRM modules to analyze the performance of the Sales and Marketing team

• Developed and customized complex Tableau reports providing critical CRM data insights, improved Email Campaign and Opportunity efficiency by 39%

• Implemented innovative solutions of CRM module, helped CEO, Business/Technical leads in process improvement

• Designed infographics for marketing team by analyzing customer requirements and product features System Engineer, IBM India Private Limited, Pune, India, www.ibm.com/in-en/ Sept 14 - Jun 16

• Executed 300+ back end, front end test cases in Shell Scripting within strict deadlines with 100% accuracy

• Analyzed data trends in millions of customer transactions to meet the SLA deadlines

• Developed and modified complex SQL queries for quick retrieval of data speeding up the process by 70%

• Created excel reports along with daily dashboards for audit thereby improving project’s performance index

• Trained and mentored 4 new employees for a smooth onboarding with the team EDUCATION

The University of Texas at Dallas M.S., Information Technology, and Management (GPA - 3.66) May 18 University of Pune B.E., Electronics, and Telecommunications May 14 TECHNICAL SKILLS

Analytics: R, Advanced Excel, Data Analysis Toolbox (Regression, Hypothesis Testing), Tableau 10.3, QlikView 12 Programming: Java, C, C++, MATLAB, HTML, Shell Scripting Databases: Oracle Server, MS SQL Server, SQL, MS Access, SAP HANA Other Skills: Vtiger CRM, R-Studio, SAP BOBJ, Adobe Illustrator, Agile Project Management, MS Office, MS Project, Erwin, JIRA, SNOW

ACADEMIC PROJECTS

O’Comets (System Analysis and Project Management) Aug 17 - Dec 17

• Proposed and built on an idea of a customized open source community to address the needs of UTD community, prepared Functional Specification document

• Modeled the proposed system using BPMN model and transformed the model into detailed design using context diagram, use case description and diagram, sequence diagram, class diagram and database schema High Performance Analytics (Qlikview, SQL Server) Aug 17 - Dec 17

• Implemented ER and Dimensional model in Qlikview and solved the loops using Qlikview scripting components

• Analyzed the resultant data, finding the insights and providing recommendations about death rates in U.S. Data Warehouse Design for Airbnb, (Erwin, SQL Server, SAP Business Objects) Jan 17 - Apr 17

• Developed database in SQL Server implementing Data Warehousing and ETL concepts for transaction reporting

• Built Universes for ER diagram as well as dimensional model in SAP Information and Universe Design Tool Analysis of Hospitals in U.S. for 2016 (Data Preprocessing, Tableau, R) Feb 17 - Apr 17

• Developed dashboards of complex datasets for analytical and operational usage, alerting and monitoring the critical issues of expensive diseases in the U.S. (Documentary Link - https://goo.gl/e9A9wK) Predicting Earning Potential on Adult Dataset (R, Data Scrubbing, Data Mining) Sept 16 - Nov 16

• Performed data validation and cleansed 7% missing data by imputing values using MICE and multiple imputations

• Handled class imbalance problem using SMOTE and applied variety of models to find out the earning potential Data Management (MS Access, MS Visio, SQL) Sept 16 - Nov 16

• Designed a database for storing, accessing and managing the consultancy data increasing the profitability by 30%

• Created forms and reports facilitating easy database entry that reduced the waiting time by 15% LEADERSHIP EXPERIENCE AND ACHIEVEMENTS

Director of Marketing, Consulting Club - The University of Texas at Dallas Jan 17 - Apr 17

‘Manager’s Choice Award’ twice for outstanding performance, IBM Nov 15