Business Analyst Data Warehouse

Sparsh Bijawat

Objective

A detail-oriented data professional who is capable to work cross-functionally to design, develop and deploy strategies for your business as well as technical environment with experience in product ownership, business analysis, data gathering, statistical analysis, business intelligence, data visualization, data management, reporting, excellent problem-solving and technical skills. BUSINESS EXPERIENCE

Priority Health June 2022- Present

Business Analyst II

• Identified business challenges and opportunities for improvement and solved for them using analysis to make strategic or tactical recommendations

• Led Designing, coding, configuring, testing, debugging, deploying, documents, and maintained self-service reporting assets and Extract, Transform and Load (ETL) for the purpose of populating data warehouse assets and sending data outside of data warehouse assets

• Drafted epics / stories in JIRA prioritize the backlog, and actively led the agile development process to ensure my team, and other teams, are able to successfully completed their sprints during PI planning

• Created Quality Performance Metrics which improved our customer sat scores from 91% to 96%

• Translated and documented business program requirements and needs into a technical solution using visuals and creating data sources, metrics and automation. Visuals, data sources and automation were created from electronic health record (EHR) reporting tools and databases, (Clarity, Caboodle, Epic Registries, Epic Extract Framework, Custom Radar SQL metrics, Data Links, and Predictive Model configuration), cloud reporting systems (Snowflake, Azure, Oracle), and other EHR agnostic tools (SSIS, Go Anywhere, Tableau, Power BI)

• Provided analytics that can turn data into critical information in understanding a business problem

• Independently able to provide troubleshooting, maintenance, support, oversight and technical guidance

• Possesses knowledge of workflows in multiple business areas to support data development, analytics and quality improvement activities

• Involved problem frame-works, develop hypotheses, test and analysis, solution development, scope operational feasibility, lead implementation efforts and develop a monitoring plan

• Supervised in Agile ceremonies determining the nature and scope of project activities and processes to be developed or modified, working across teams to communicate development dependencies to accomplish final solution

• Worked with data architects as the architect designs relational and dimensional data models to verify that the model meets the use cases and aligns with strategic direction

• Led safety initiatives and risk mitigating measures based on ISO Standards where appropriate and completed all position and unit safety related competencies and requirements on a timely basis DNV GL, Okemos, US Aug 2018-May 2022

Business Data Analyst

• Forecasted site-level consumption using a variety of data modeling and machine learning techniques such as linear regressions, random forest algorithms, logarithmic regressions etc.

• Utilized R, Python, Power BI and MS SQL Server to automate reports for batch processing across large datasets

• Designed and implemented process improvement tools that reduced the work hours by 24% and increased the efficiency of the team by 30 %

• Handled a variety of quality control checks to ensure the accuracy and defensibility of the analysis

• Interpreted the results of data analyses to produce concise, meaningful conclusions and recommendations for client-facing reports and professional papers

• Developed and maintained products that deliver data visualizations, wrangling and validation reports using SQL Server, Azure DB, MS Access, Power BI and MS Excel to enable users to grasp concepts, identify patterns, and make better business decisions with a proven track record of decision making and problem solving based on analytics

• Managed and enhanced entire Small Business Energy Efficiency Program by constructing SQL data queries, reporting, analytical dashboard creation, and solved ad-hoc user issue requests using JIRA ticket management system

• Supervised project plan development and managed tasks and/or projects (including client interactions) and track progress using JIRA and Batch processing tools

214-***-**** ad6otl@r.postjobfree.com

https://www linkedin.com/in/sparshbijawat https://github.com/sxb1649

• Supporting direct-to-consumer marketing efforts for select products, and strategic intent for products distributed through multiple data channels. Help build targeted insights to inform the design and development of new customer experiences, as well as breakthrough technology and concepts designed to deliver on new go to market strategies

• Worked on the energy efficiency and renewable energy markets and regulatory ecosystems, developed, improved, and advanced repeatable analytic offerings

• Worked with internal staff and subcontractors to meet project objectives

• Interviewed business stakeholders to identify focus of research and expected project outcome (scope, background, business case, etc.)

• Designed and developed various analytical reports from multiple data sources by blending data on single workbook to generate visualizations and reports

• Created various weekly and monthly portfolio reports with in-depth statistical analysis and visualizations to show detailed information on net KWH and MCF usage and electric and gas incentive allocation Nuway Solutions LLC, Plano, US June 2018-Aug 2018

Business Analyst

• Proficient in data transformation, DAX Analytical functions, connection to external data sources: web, CSV, excel, SQL Server, Azure Blob storage, Azure Database and maintained dynamic row level security

• Built effective reports/dashboards using visualizations such as Power KPI matrix, Stacked Bar, Clustered bar, Donut, Waterfall, Gauge, Tree-map, Pie charts, Heat-maps, Histograms etc.

• Built, maintained and scheduled various reports in Power BI like Tabular Reports. Loaded from different data sources in Azure data cloud and created pipelines to ensure data flow

• Implemented advanced analytics/modelling projects, including data ingestion, data management (scripts, modeling), data extraction, and predictive models

• Initiated KPIs, developing, providing and monitoring ops performance dashboards on a regular basis

• Worked in a high performing transformational team shaping the next generation data and BI platforms

• Supported Business and Technical teams with expert guidance and consultancy in all matters relating to Business Intelligence, Analytics, and Reporting

• Used SQL development and querying tools, develop and troubleshoot various data warehouse and BI issues

• Real passion for statistics, number crunching and logical problem solving on intellectual challenges DevU.in, Bangalore, India August 2015-August 2016

Business Analyst

• Analyzed incoming customer businesses data with Google Analytics and generated 50 leads and a business of 800,000 Rupees

• Managed reports on Client interaction, Business Analysis and Requirement Gathering, and Web Content portfolio

• Used R to merge different file formats and loaded them in the database

• Extracted, cleaned, compiled and analyzed datasets to generate reports using python libraries such as Pandas, Numpy, Scipy, Requests. Implemented decision trees and clustering to rank top 5 best clients of the region

• Managed reports on Client interaction and Requirement Gathering and headed the web content portfolio

• Analyzed products and business requirements, created product strategies with Program Manager and Developers

• Supervised Customer Relationship Management, Customer Analysis using MS Excel and Social Media Marketing using Hootsuite, Sprinklr

• Requirement Gathering, Client Acquisition, and Customer Relationship Management

• Generated reports on Client interaction and used Python scripts for web scraping to generate data from online sites and applications

• Identified potential clientele making use of Company resources, internet search engines, referrals, networking and cold calling and conduct strong follow-ups with potential clients

• Generated leads, both online and offline using tools like Import-io, Google Analytics, using web scraping through Python

• Have worked on Anti-plagiarism online tools. Content creation and content correction

• Applied principles of data visualization to create intuitive stories using various graphs and statistical plots

• Prepared Business Requirement Document and Proposals for potential investors to invest in the product by generating insights out of data

Antz Age Pvt. Ltd, Delhi, India July 2014 - March 2015 Jr. Business Analyst

• Supervised conversion of 45 potential clienteles and generated 500,000 Rupees, analyzed products and business requirements, created product strategies with Program Manager and Developers

• Prepared a high-level system analysis and design project on our proposed Online training processes

• Developed a project charter, Scope Statement and Work Break Down Structures (WBS) to manage the project’s timeline. Created class diagrams, use case diagrams, sequence and state diagrams, control objects, test strategy and test cases and improved the project’s functionality

• Generated and managed 45 leads, both online and offline using tools like Import-IO, Google Analytics, Python Scripts

• Identified potential clientele making use of Company resources, internet search engines, referrals, networking and cold calling and conduct strong follow-ups with potential clients

• Generated reports on Client interaction and used Python scripts and Import-io to generate data from online sites and applications using web scraping. Loaded data from excel, csv and cloud files in the database and generated reports

• Ran analysis through about client interaction and activities through MS Excel Data Analysis CERTIFICATIONS and TECHNICAL SKILLS

Certifications: Data Analytics-R, Data Analysis-Python, Machine Learning, Alteryx, MS Excel, Power BI Analysis Tools: MS Excel, Tableau, Web Intelligence Tool, Universe Design Tool, PyCharm, RStudio Programming: R, Python, Pandas, Numpy, Seaborn, Ggplot2, Matplotlib, Sci-Kit, Machine Learning Software: SAP CRM, Microsoft Office Suite, SAP Business Objects, Information Design Tool Databases: MS Access, MS SQL Server, ER Win, Oracle SQL Developer, Snowflake AWS, Azure DB Project Management: JIRA, Visual Paradigm, Microsoft Project, Edraw Max, Microsoft Office Suite, DevOps Other: Web Crawling, Hadoop Stack, Data Warehousing, SharePoint, Google Analytics, Tableau EDUCATION

The University of Texas at Dallas May 2018

M.S in Information Technology and Management GPA 3.5 Rajasthan Technical University, Kota, India June 2014 B.Tech in Electronics and Communications GPA 3.2

Contact this candidate