Business Analyst Data

Patel Nikitaben Jayeshbhai

Business Analyst / Data Analyst

Arlington, TX, 76018 814-***-**** ********@*****.*** LinkedIn Summary

* ***** ** ******** ********** as a Business Analyst and Data Analyst, specializing in data-driven insights, strategic decision-making, and business process optimization.

Proficient in requirements gathering, stakeholder communication, process improvement, and translating complex business needs into actionable technical solutions.

Skilled in building scalable ETL pipelines, designing data warehouses using Star and Snowflake schemas, and implementing Slowly Changing Dimensions (SCDs) up to Type 3.

Hands-on experience with Python, SQL, R, and AWS services (Glue, Redshift, S3) for data transformation, analysis, and warehousing.

Experienced in creating interactive dashboards and reports using Tableau, Power BI, and Excel to deliver actionable insights to stakeholders.

Proficient in statistical modeling, regression analysis, and machine learning techniques using Scikit-learn and XGBoost to support predictive analytics and business forecasting.

Strong knowledge of SQL Server administration including installation, configuration, performance tuning, partitioning, backup and recovery, and transaction log management.

Skilled in troubleshooting SQL issues using Execution Plans, Traces, and third-party tools, and experienced in T-SQL query optimization and resolving blocking issues.

Experience creating Business Process Management (BPM) flowcharts using MS Visio to document business workflows and systems.

Involved in SharePoint documentation, user group management via Active Directory, and integration of policy and architecture updates.

Participated in effort estimation for enhancement features and ensured timely delivery aligned with business expectations.

Ensured training and knowledge transfer for users on new features, enhancements, and system upgrades.

Actively interfaced with business and technical teams throughout the software development lifecycle to ensure successful project outcomes.

Superior communication (verbal and written), teamwork, and problem-solving skills with a strong ability to deliver high- value solutions that meet business needs.

Key Skills

Programming & Analysis: Python (Pandas, Numpy, Scikit-Learn, Pyspark), R, SQL, Excel

Operating Systems: Windows, UNIX, Linux

Methodologies & Frameworks: Agile, Hybrid, Waterfall, Scrum, Kanban, SAFe, Dojo

Prototyping & Modeling Tools: Balsamiq, MS Visio, Lucidchart, AutoCAD, MS Office Suite, ETL Tools (Informatica, SSIS)

BI & Visualization Tools: MS Excel, Power BI, Tableau, QlikView, Crystal Reports, SSRS, SSAS, Matplotlib, GGplot

Programming & Analysis: Python (Pandas, NumPy, Scikit-learn, PySpark), R, SQL, T-SQL, VB, VB.Net, M code

Machine Learning & Statistical Techniques: XGBoost, ARIMA, Regression Analysis, Sentiment Analysis, Predictive Analytics, Data Mining, Time Series Forecasting

Databases: SQL Server, PostgreSQL, MySQL, MS Access, Oracle 11g, AWS Redshift, Google BigQuery

Data Warehousing Concepts: OLAP, OLTP, ROLAP, MOLAP, Slicing/Dicing, Drill Down/Roll Up, Pivot Tables

Web Technologies & APIs: HTML, CSS, JavaScript, XML, JSON, SOAP, REST, AJAX, AngularJS, J2EE

API & Testing Tools: Postman, Swagger 2.0, SOAP UI, Selenium, Cucumber, UFT, HP ALM, HP LoadRunner, SonarQube

Agile & Collaboration Tools: JIRA, Confluence, SharePoint, TFS, IBM Lotus

Documentation & Project Tools: MS Word, MS Project, MS Office Suite

Cloud & Big Data Platforms: AWS (Redshift, S3), Google Cloud Platform (BigQuery), Apache Spark

Development & Integration Tools: Visual Studio, SSMS, BIDS, SQL Profiler, Git

Protocols & Authentication: HTTP, IMAP, SOAP, SAML, OAuth 2.0

Supply Chain & ERP Systems: IBM Sterling OMS, IBM Watson, E2open, SAP ERP, SAP HANA, SAP HYBRIS Professional Experience

Business Analyst / Data Analyst Aug 2024 – Present United Health Group, USA

Experienced in bridging business needs with technical solutions by gathering requirements, analyzing workflows, and delivering data-driven insights.

Led end-to-end implementation of ITSM platform upgrades, including stakeholder alignment, vendor evaluation, budgeting, and project management.

Built and optimized machine learning models for forecasting and customer retention using Python, R, and Scikit-learn, improving decision-making accuracy.

Designed and deployed Tableau dashboards using OLAP cubes and dimensional modeling to support public health reporting and supply chain monitoring.

Streamlined data processing workflows on AWS Redshift and BigQuery, applying indexing and partitioning to significantly reduce reporting time.

Directed EMPI enhancement initiatives by replacing HL7 messaging with peer-to-peer integrations, enabling high-volume record matching.

Created project documentation including scope, risk, cost, RACI charts, and testing plans to support seamless execution and delivery.

Automated manual business processes using Excel VBA, pivot tables, and dynamic dashboards, enhancing accuracy and saving operational time.

Conducted in-depth statistical and cost optimization analyses using SQL, Pandas, and visualization tools to drive measurable business impact.

Mentored junior analysts and collaborated with cross-functional teams to implement scalable data solutions and foster knowledge sharing.

Business Analyst / Data Analyst Jan 2020 – July 2022 Informative Web Solutions, India

Applied NLP techniques and sentiment analysis using Python (NLTK, Pandas) to analyze survey responses, uncovering insights that guided product improvements and increased satisfaction.

Designed and optimized ETL pipelines using Apache Spark and PySpark to transform and load web data from REST APIs, reducing processing time and enabling downstream analytics.

Developed interactive dashboards in Tableau and Power BI, using data blending, DAX, and calculated fields to monitor KPIs, track campaign performance, and drive strategic decisions.

Conducted time series forecasting using ARIMA and seasonal decomposition in R to predict demand trends, contributing to cost reduction in inventory management.

Created ad hoc reports and enterprise scorecards in SSRS and Power BI, including dynamic visuals, subtotals, and data import from SQL Server and Analysis Services.

Performed complex SQL querying and database administration, including tuning, backup planning, permission control, and performance optimization with SQL Profiler.

Led requirements gathering and SME interviews for MDM and multi-domain models, translating business rules into technical specifications and data standards.

Supported QA testing efforts by creating test plans, verifying business scenarios, and collaborating on user acceptance testing during release cycles.

Migrated legacy reports into Power BI and developed custom DAX measures to fulfill business intelligence needs, enhancing analytics capabilities across teams.

Academic Background

Master in Data Science Jan 2023 to Dec 2024

Gannon University, Erie, PA

Reference

Will be provided upon request.

Contact this candidate