Parthvi Shah

*** ****** *****, ********, ****, **202

ad4prk@r.postjobfree.com 614-***-****

Professional Summary

• Recent graduate student, looking for an opportunity to work in Data Analytic with a good opportunity to learn and grow. Good hands-on experience in Marketing, Planning and Analysis, and Reporting, Business Performance Management, MIS, and Analytics. Looking for a position where I can learn and grow in my career and as an individual.

• Experience in testing and validating data, performance tuning by using execution plans, database engine tuning advisor, and SQL server profiler.

• Experience in developing and analyzing dashboards in Looker and Power BI.

• Strong skills in SQL, data warehouse, data exploration, data extraction, data validation, reporting and excel. Utilize Microsoft excel and access to manipulate, cleanse and process large data set.

• Expertise in building complex SQL Queries to perform data mining, data analytics, and data extractions across databases.

• Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems.

• Created ETL jobs and custom transfer components to move data from smaller teams to centralized area

(SQL Server) to meet minimum capital requirements using SSIS.

• Statistical modelling including data extraction, manipulation, visualization, and validation techniques, reporting on various projects. Professional experience of working on different SDLC methodologies such as Agile (Scrum), Waterfall & Rational Unified Process. Education

The Ohio State University Columbus, OH

Bachelor’s in health information systems

Work Experience

Cardinal Health

PCD Team

Data Analytics Columbus, OH

• Collect PCD data from pharmacies for customers for recent three months.

• Correct any exceptions that we received, product, prescriber, and zip codes.

• Once data is cleared, passed to CSMP team to begin reg flag analysis.

• Present data to business team during calls while having knowledge about data received from pharmacies.

Path Robotics, Inc, US

Supply Chain Master Data Analyst Intern Columbus,

OH

• Generated automated reporting system for MRP using power bi, power automate.

• Rolled out MRP.

• Tableau Dashboard with drill down ability providing more customization and giving buyers the visibility to what was driving MRP requirements.

• Leverage NetSuite to implement lean procurement strategy reducing monthly inventory on-hand by $2M.

• Maintain all item master data and BOM accuracy for NetSuite’s MRP module. Developed and refined safety stock strategy by reducing dollar value by $330k without impacting service risk.

• Cross training across the organization for NetSuite’s reporting and best practices.

• Developed intricate algorithms based on deep-dive statistical analysis and predictive data modeling using Python that were used to deepen relationships, strengthen longevity, and personalize interactions with customers.

Homestead Property Management

Assistant Leasing/Marketing Manager

April 2022-December 2022

• Trained and managed a strong leasing staff.

• Oversaw leasing and marketing performance over social media, internet, walk-ins.

• Used Google Ads to advertise our property so we can rent more units.

• Helped organize and budget marketing events on property daily to ensure we get a good outreach using google analytics, to make reports weekly on our progress. Used these tools to better train staff on how to lease and outreach.

• Worked closely with the General Manager on meeting daily, weekly, monthly, and annual goals.

• Conducted tours for new incoming residents.

• Diligently pursued the closing of each sale, performed follow ups, completed paperwork.

• Administered and reviewed all lease paperwork

Conduent Columbus, OH

Business Analyst Intern, Remote

July 2020-March 2022

As a Business Analyst within Payments been responsible to work on product lines like Way2GO, EPPICARD, Direct Express and WIC. Closely worked with all business groups to meet business goals including technology, service delivery, fraud, business operations, infrastructure, card management etc.

• Requirements gathering/analyzing requirements documents for various IT projects.

• Collaborated in building a business analysis process improvement model.

• Collaborated with different State program PMs to work on product improvisation.

• Worked on Product Strategy. Analyzed and prepared cost benefit analysis to improvisation via business need.

• Worked on prioritizing change request and adding it to the queue.

• Worked with Product Manager on day-to-day basis in improvising the product and reducing cost for existing functionalities.

• Responsible for identifying scope creep’s gaps and having it work through change management process.

• Educated team on change impact to inflight projects vs change to product.

• Maintained documentation and worked with Stakeholder across the organization on change management process.

• Worked closely with Fraud Director and the team to identify vulnerabilities within the existing product and worked on providing solution to fix those vulnerabilities.

• Worked closely with Fraud team on identifying flaws in current One Time, Recurring and Direct Deposit solution and worked with business in redefining the requirements and helped drive the implementation on the technology side.

• Assisted business teams with UAT and sign off process. Skills

Technical Skills:

• Technical skills: SQL, Python, Tableau, PowerBi, Google Analytics

• Project Management Tools: MS Project

• Requirement & Traceability Matrix: Rational Requisite pro, MS Excel

• Change Management Tools: Rational Clear Quest, MS Office, Snag-It

• Operating Systems: MS-DOS, LINUX RH 9.x

Contact this candidate