SHAILESH DIXIT

682-***-**** ac5kjc@r.postjobfree.com https://www.linkedin.com/in/shailesh-dixit/

A result oriented professional with 3.5 years of employment history as System Engineer. Seeking opportunity as Data or Business analyst utilizing my analytical thinking and business insights to help the organization comprehend its long-term goals.

Strong knowledge in SQL, Requirement Analysis, Change management with best coding standards and conventions.

Well versed with Agile, Waterfall methodologies and SDLC.

oSkilled in Data Extraction, Data Wrangling, Data Loading and Data Analysis using different Python APIs

oHands on experience with SAP configuration cases (Financial Accounting, Procurement, Fulfillment, Production, Material Planning) and Data Visualization (Tableau, SAP Lumira 2.0)

EDUCATION

Master of Science in Management Information Systems January 2017 - May 2018

The University of Texas at Arlington, TX 3.82/4.0

Related Coursework: Advance Business Statistics, Data Mining, DBMS, Data Warehousing and Business Intelligence, Enterprise Resource Planning, Project Management, Econometrics, Social Network Analysis, Analysis and Design

Bachelor of Technology in Electronics and Communication Engineering August 2009 - May 2013

SRM University, India 8.01/10.0

SKILLS

Database & Framework: SQL, Agile, Waterfall, ETL

Analytical & BI Tools: SAP BI Netweaver, R Studio, SAP Lumira 2.0, SAS, Tableau, UCINET, Weka, Advanced MS Excel

Programming Languages: Java, HTML, CSS, UNIX, Embedded System

Designing Language & Tools: Unified Modeling Language (UML), Websphere Portlet Factory, Rapid Application Developer

Others: MS Project, ServiceNow, SharePoint, Jenkins, Tectia SSH, HP Quality Centre, SOAP UI

Certifications: SAP Lumira 2.0 by openSAP, Udemy Advanced Excel, Intro to Python for Data Science.

PROFESSIONAL EXPERIENCE

Associate Analyst, The University of Texas at Arlington, TX July 2017 – May 2018

Analyzed the daily sales transactions for UTA Dining Services and performed market basket analysis. Increased the sales by 12%.

Prepared dashboards and stories using Tableau to envision and communicate results to senior leadership.

Filter and clean the data by reviewing computer reports. Identify, inspect and interpret trends or patterns in the dataset.

Acquired data from primary and secondary sources to maintain database.

System Engineer – Tata Consultancy Services Client - Citibank July 2013 – January 2017

Simplified and digitized Citi’s global consumer banking system as part of Customer Management Systems (CMS) team.

Migrated the applications to new servers and platforms. Saved the license cost and raised profit to 19%.

Worked closely with all stakeholders to determine solutions to any data/system problem at hand along with developing complex product change requests and fix production defects.

Use SQL, MS Excel and VBA to write queries and run various reports. Conduct system analysis, document findings and recommendation on data processes to increase the efficiency.

Involved in BA walk through, peer reviews, data preprocessing, managing data, analyzing data to get business insights.

ACADEMIC PROJECTS

Conveyor Belt Project (MS Project): Developed the Project Scope Statement, Priority Matrix, Work Breakdown Structure, Risk Assessment Form and Risk Response Matrix. Resolved the over allocation problem. Calculated Contingency and Management Reserves in addition to various matrix for project management.

LCA Petition Status Prediction for H-1B Visa (Machine Learning): Cleaned the dataset and did the random sampling to create 10 bins of equal size to handle the skewness of data. Outcome was true positive for highest category reduced from 98% to 67%. Applied Machine Learning algorithms & computed accuracy of generated models. Used best possible model of 73.67% to predict case status.

Universal Furniture Outlet (SQL): Discovered the entities and sketched the ER diagram. Created the relational schema of database in 4th normal form. Created the table and inserted data into it. Fetched the data from tables based on user requirements.

50 Women (Tableau, UCINET): Visualized the social network of 50 women over three years to find the density, reciprocity, centrality. Regressed friendship and sports over alcohol, drugs, smoking to find out how the dependent variable is related to other variables. Conducted the MR-COR to find the correlation among the attributes.

Data conceptualize (SAP BI, SAS, R studio): Created info cube to build a data warehouse and examined company's revenue generation using SAP BI. Checked for the assumption violation and found the outliers in X and Y along with the influential points. Predicted the best fit model for the dependent variable Sales price of a property.

Sterling MediCare (Analysis, Design Modelling): Constructed the System request and Economic feasibility Analysis. Derived Use Case and activity diagram from the functional requirements. Designed the class diagram, sequence diagrams and database model.