Business Analyst

Jinank Parekh

Email Id: ********@*******.*** Cell: 551-***-****

LinkedIn: https://www.linkedin.com/in/jinank-parekh-7620399b/ Analytical and Tech-savvy individual with strong Technical and Business Analysis knowledge seeking an opportunity to grow and learn with applying Statistical and Methodical skills to help company achieve its long-term goals. EDUCATION

Masters in Information Systems GPA: 3.89/4

Stevens Institute of Technology, Hoboken NJ May 2018

• Courses: Web Analytics, Data & Knowledge Management, Financial Decision Making, Financial Management, IT Strategy, Process Innovation, Integrating IS Technologies, Introduction to Python, Introduction to Bloomberg Terminal. Bachelor of Engineering In Electronics GPA: 3.33/4 University Of Mumbai, Mumbai June 2014

TECHNICAL SKILLS

• Programming Languages: Python(Expert), SQL(Expert), R, Java

• Analytical Tools: Tableau (Expert), MS Excel(Expert), Power BI, R Studio, Qlik View, JIRA, Salesforce, Microsoft Visio, Advanced Excel(V-lookups, ), VBA, IBM Cognos Analytics, Adobe Analytics.

• Applications: MS Office, MS Project, Google Analytics, Google AdWords, AWS.

• Methodologies: Agile, Scrum, Waterfall, SDLC

• Financial Skills: Audit, Risk Management, Bloomberg Terminal, Financial Forecasting, Investment Management. PROFESSIONAL EXPERIENCE:

Fantasy Diamond Corporation: Business Analyst Intern Sep 2017 – Dec 2017

• Created and prepared UAT test plans, test cases and was involved in UAT testing and deriving business strategies.

• Developed use cases, workflow, responsible for generating business requirements document (BRD).

• Visualized data, conductive predictive analysis, researched and purposed strategies in pricing and product design.

• Followed Agile/Scrum Software Development Life Cycle methodology for project execution.

• Presented findings of the monthly sales KPI reports for continuous improvement to the higher level executives.

• Analyzed and wrote SQL queries to perform Data Validation initially at file level and then at the database level.

• Worked across Logistics, Finance, Customer Service, Sales and Manufacturing units to improve product reliability, automate reporting, minimizing waste and created stored procedures in SQL for automation purpose.

• Acting as a liaison between the stakeholders and users. Finrex Treasury Advisors: Business Analyst Dec 2014 – Jul 2016

• Build, automated and executed reporting processes using My SQL Server and Python.

• Conducted daily data quality checks and Data profiling for accurate and comprehensive reporting and Analysis.

• Developed business requirement documents (BRD), translate business requirements into functional requirements also wrote user stories in GWT (Given-When-Then) format for TO-BE process.

• Involved in all phases of Software development life cycle (SDLC) using Agile Scrum methodology. Conducted and participated in sprint planning meeting.

• Played a key role in User Acceptance Testing (UAT). Developed test plan, test scenarios, test cases for the live software.

• Analyzed logical and physical data models that capture current/future state data elements and data flows.

• Designed and Developed project templates based on Software Development Life Cycle (SDLC Methodology).

• Performed data queries to generate technical reports with the help of various graphs and charts using Tableau.

• Developed test case scenarios, test cases and followed up with the Development and Test team regularly. Perch Technologies Pvt Ltd: Business Analyst Intern Jun 2014 – Nov 2014

• Worked with Project Managers, Senior Management and stakeholders to define projects goals and requirements.

• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).

• Transformed a process for generating a quarterly sales report from Cognos to SQL. ACADEMIC PROJECTS:

Tracing Emotive Markers over Time Jan 2017 – May 2017

• Analyzed Eve Online user comments to interpret their emotions behind their reviews and calculated the relative frequency of a few words from the Harvard inquirer related to emotions.

• Developed an excel consolidator to derive the relative frequency based on the word count

• Generated visually appealing graphs on Tableau to map relative word frequency to time. Financial Modelling for Parker Hannifin and Clarcor Inc. Jan 2017 – May 2017

• Designed Cost to Growth Financial Derivative Model with assumptions of Gross Revenue, EBITDA, world economy, synergies and Net earnings.

• Developed and Constituted Different Scenarios which would show the different cases with the Merger. Yelp Data Tip Analysis Aug 2017 – Dec 2017

• Extracted and analyzed Yelp reviews with more than 70% accuracy to better understand customer behavior based on the

‘tips” given by them using Python.

• Identified gaps in current metrics and data capture strategies and collaboratively implement enhancements.

Contact this candidate