Data Analyst
Resume:
Prachi Shinde
SQL Developer
ac4dah@r.postjobfree.com
linkedin.com/in/prachi-shinde
Hard working and motivated experienced professional with proven data analytics skills and ability to provide data driven business solutions. Also, I am highly focused and efficient employee.
Skills
Data Analysis, ETL, SQL, Teradata SQL, SSIS, Power BI, Power Pivot, Tableau, Qlikview, Requirement Analysis, Data Sampling, A/B Testing, SAS JMP, SSPS, SSRS, SSAS, Business Analysis, Predictive Analytics, Data Modeling, Market Research, Business Development, Problem Solving, Decision Making
Team Management, Presentation, Communication
Experience
07/2016– 12/2017
Business Data Analyst / Bank of America, Charlotte (NC)
Responsible for creating critical compliance test analysis documents and Business Requirement Documents (BRD).
Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
T-SQL in constructing User Functions, stored procedures, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
Working on live site issues to fix slow running stored procedures, triggers etc. and provide Root cause analysis.
Experience in Data Analysis, understanding trends and patterns in data.
Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages.
Developed dashboards and ad-hoc reports using MS Power BI for senior management team for analysis.
Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
Recommended internal process changes using data analysis.
Collaborated with different stakeholders from various business units to validate and approve compliance tests independently.
08/2015 – 05/2016
Market Research Analytics/ MAGNET Manufacturing, Akron (OH)
Analyzed company’s business practice and product performance to determine potential growth.
Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points from SQL Servers, Flat files, Access DB and Oracle DB.
Designed and implemented data models and reports in PowerPivot, Power BI to help clients analyze data to identify market trends, competition and customer behavior.
Provided in-depth market research reports for qualitative and quantitative methods.
Used algorithms like regression, clustering and decision trees to analyze the data on SAS JMP.
Collaborated with different stakeholders from MAGNET to understand client’s businesses, their operational and manufacturing strengths.
Recommended new product lines based on data driven analysis.
Responsible for introducing products in new categories resulting in 40% increase in overall portfolio.
02/2014-12/2014
Business Development Associate/ Leo Coats India Pvt. Ltd, India
Worked on planning the growth opportunities and new revenue streams for the company and present new services or solutions.
Developed the Requirement Management Plan after collaborating with clients.
Analyzed company’s business practices, industry best practices globally and provided solutions to clients as per the requirements.
Accredited for collaborating and integrating the knowledge gained from client feedback, market research and sales. Responsibilities included managing strategic relationship and alliances with partners, vendors and customers.
Experience in data modeling, predictive analytics, A/B Testing.
03/2013 – 09/2013
HR Analytics Intern / Honeywell, Pune (India)
Prepared quantitative data for statistical analysis- transformation of the unstructured data into structured data formats (excel).
Used algorithms like regression and decision tree.
Designed and implemented automated HR competency matrix application using Excel Macros, Visual Basics and analyzed the data using SPSS.
Experience with different phases of project life cycle- SDLC Process (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
Experience in Agile- Scrum methodology.
Education
Masters Management Information Systems 01/2015 – 05/2016 University of Akron, OH, USA
M.B.A. Marketing and Human Resources 06/2012 – 04/2014 Hyderabad, India
Bachelor of Engineering Electronics and Telecommunication 06/2006 – 05/2011 Pune, India
Contact this candidate