Data Analyst, Business Analyst, Data Scientist, Database Manager

Nipa Shah

Jersey City, NJ +1-551-***-**** ************@*****.***

EDUCATION

Sacred Heart University, Fairfield, CT May 2025

Master of Science in Business Analytics GPA: 3.75/4.00 Indus University, Ahmedabad, Gujarat May 2018

Master of Business Administration (MBA) GPA: 3.89 /4.00 Gujarat University, Ahmedabad, Gujarat May 2016

Bachelor in Commerce Grade: 68%

SKILLS

Languages: Python, R, SQL.

Databases: Oracle, MS SQL, PostgreSQL, Redshift, Aurora, Snowflake, BigQuery Cloud & Big Data: AWS, Azure, Hadoop, Spark, Hive, Pig ETL/Integration: Dataiku, Alteryx, Pentaho, Informatica, Knime, ADF Visualization: Tableau, Power BI, Looker, QlikView, Excel (Advanced), ggplot Modeling/ML: Data Modeling, A/B Testing, Stats, scikit-learn, TensorFlow, Keras Tools: Jupyter, SQL Developer, SSMS, JIRA

CERTIFICATIONS Databricks – Generative AI fundamentals

Google – Looker studio for Creating Dashboard

Python Essential Training

Data Science Foundations

what is Generative AI

AWS Cloud Practitioner – CLF – C02

MySQL Essential Training

Supply chain basics

PROFESSIONAL EXPERIENCES

AdvanceInnovative LLC, New Jersey June 2024 - Present Sr. Data Analyst

• Examined data from underwriting, distribution, and other sources to provide insights related to agents & issue logs which helped the Relationship Team better understand and tailor communication with agencies.

• Created, maintained, and monitored data pipeline in Dataiku using SQL, HiveQL consisting of 100+ fields & 3-4 million rows replacing legacy database for new automated operation, resulting in $1M in savings.

• Built classification model in DataIKU to predict potential term policy lapses along with other data scientists in agile to replace manual process for Business Retention team, increasing customer outreach by 50%.

• Implemented the first MLOps framework in Dataiku at Lincoln and deployed a predictive model, created a model evaluation store, checks, and alerts as part of model governance and pipeline monitoring.

• Created dashboards, visualizations in Tableau to present insights, to the shareholders. Rock Technolabs, Ahmedabad, India May 2020 – Dec 2023 Data Analyst

• As the process owner, implemented and managed the curation of revenue data through ETL and distributed the revenue report to the entire organization daily, which led to 500+ hours of savings annually.

• Performed Point of Sale data and business analysis on major retailers like Amazon, Walmart, and Shark Ninja business categories to find trends, which types are winning and losing in actualized and forecasted POS data.

• Conduct statistical analysis on the forecast to generate data models for external stakeholders.

• Control all data mappings for the existing and new product developments across the organization's business system.

• Improved Data Management and liaising between IT and Business requirements of the Planning analytics team.

• Managed Data analysis on all new and existing business categories to provide accurate insights to respective clients utilizing QlikView.

• Gathered business requirements and created business requirement documents with technical details.

• Performed multiple forecast audits, such as Price and negative inventory audits, to reduce dynamic errors in the pricing, inventory, and Data management systems.

• Created proof of concepts on the process by writing technical documentation on processes.

• Perform UAT approvals from IT for Data governance & cross-functional business stakeholders.

• Streamlined multiple reports continuously to report KPIs weekly, which provides a realistic image of the existing macro-level state of Business through Domo.

• Expanded & implemented Data mining, gap analysis, and Root cause analysis for various cross functionals teams.

• Build dashboards in Domo for leadership teams & cross-functional groups using automated datasets.

• Generate monthly revenue numbers & data reports on international regions of Shark Ninja business.

• Successfully implemented migrating data from legacy systems to the Snowflake data warehouse for international regions.

• Conducted ad-hoc data analysis for the business and maintained documentation of new processes & systems.

• Mentored new joiners on a specific process.

Tech Ancubate Pvt. Ltd, Ahmedabad, India June 2018 – April 2020 Data Analyst

• Transformed raw data into meaningful insights using Tableau, improving team's decision-making process by 35%

• Automated data collection and integration system using Python, reducing data collection time by 15%

• Increased accuracy of quarterly sales projections by 20% using advanced statistical modeling techniques

• Introduced Power BI dashboards for real-time data monitoring, which increased the team efficiency by 25%

• Collaborated with cross-functional teams to identify KPIs and developed a SQL based querying system for easier access to key information.

TATA Motors Ltd., Ahmedabad, India June 2017 – August 2017 Jr. Data Analyst – Intern

• Utilized PMG catalog suite to automate business processes of various R&D teams.

• Created SQL reports for stakeholders and customers and calculated metrics for analysis.

Contact this candidate