Power Bi Data Analyst

Tokshika Sharma

+1-860-***-**** *********@*****.*** www.linkedin.com/in/tokshika-s-619619201

SUMMARY

Over 5 years of experience delivering data-driven solutions across finance, healthcare, and manufacturing. Proven success with U.S. clients including Mr. Cooper Group, Change Healthcare, and AgFirst. Skilled in business requirements gathering, process mapping, and functional specs.Proficient in SQL, Python, and RESTful APIs for analytics and automation. Hands-on with Tableau, Power BI, and cloud platforms (Azure, AWS Redshift, GCP BigQuery). Experienced in ETL development, API integration, A/B testing, and Agile/Scrum delivery.

TECHNICAL SKILLS:

•BI/ETL Tools: Tableau (Desktop, Server, Reader), Power BI, Google Data Studio, SAP BI/BW, MicroStrategy, SSRS, SSIS, Azure Data Factory, Apache NiFi, Python ETL, SQL ETL

•Databases & Cloud: SQL Server, Oracle, MySQL, PostgreSQL, Teradata, Azure, AWS Redshift, GCP BigQuery, RDBMS

•Modeling Tools: MS-Visio

•Reporting Tools & Testing: SQL Server Reporting Services (SSRS), Power BI, A/B Testing

•Languages: T-SQL, SQL, PL/SQL, Python (Pandas, NumPy, Scikit-learn, TensorFlow), C, C++, Java, VB

•Operating Systems: Windows 10/11, Unix

•Office Tools: Microsoft Office Suite (2013 and newer), Outlook, Google Workspace

•Methodology: Agile, Scrum, SDLC, Waterfall

•APIs & Process: RESTful APIs, JSON, Postman, Swagger, Process Mapping, SWIFT MT/MX (Cash Transactions)

PROFESSIONAL EXPERIENCE

Mr. Cooper Group May 2024 - Present

Senior Data Analyst Coppell, Texas

Led the design and development of Power Apps solutions to address business needs.

Created visually appealing and intuitive user interfaces, optimizing user experiences.

Customized and extended Power Apps functionality using Power Platform connectors and RESTful APIs.

Collaborated with stakeholders to elicit and document requirements and define project scopes.

Managed project timelines, budgets, and resources to ensure successful implementations.

Conducted user training and provided ongoing support for Power Apps solutions.

Utilized Power BI, Google Data Studio, and Tableau for reporting and dashboard creation, providing clear overviews of expense allocations across projects.

Developed custom dashboards in Google Data Studio to track SEO performance metrics, providing actionable insights for the marketing team.

Leveraged Azure Data Factory to orchestrate and automate data workflows, ensuring seamless data integration from multiple sources into Azure SQL Data Warehouse and Azure Synapse Analytics.

Designed and implemented Azure Data Lake Storage Gen2 solutions, organizing raw data into structured datasets for further analysis using Azure Databricks and Synapse Analytics.

Utilized A/B testing methodologies to optimize meta titles and descriptions, resulting in a 25% increase in click-through rates.

Produced monthly SEO reports highlighting key performance indicators (KPIs) and presented findings to senior management for strategic decision-making.

Collaborated with cross-functional teams to deploy Power BI dashboards and reports on Azure, providing actionable insights to stakeholders and driving data-driven decision-making.

Stayed abreast of industry trends and algorithm updates, adjusting SEO strategies accordingly to maintain a competitive edge.

Directed data collection, processing, and analysis efforts using RDBMS technologies such as MySQL and SQL Server.

Engineered hypothesis-driven A/B test plans to optimize website user experience, email marketing campaigns, and product features.

Analyzed A/B test outcomes for continuous iterative improvements, contributing to the company’s growth and success.

Managed and executed SQL query reviews and database schema updates to support reporting needs.

Collaborated with development teams to understand data sources and align integration solutions with business requirements.

Participated in meetings, reviews, and user group discussions to ensure thorough understanding and documentation of business flows.

Utilized Azure DevOps for CI/CD pipeline management, version control, and deployment automation.

Documented integration processes using JSON and RESTful API specifications.

Change Healthcare Apr 2022 - Dec 2023

Senior Data Analyst Nashville, Tennessee

Collaborated with the customer service team to elicit, analyze, and document business requirements from diverse data sources for comprehensive report development.

Developed reports showcasing customer profile analysis, satisfaction rates, and product performance to support service operations.

Created visual heat maps segmented by demographics such as age, salary, and job category, aiding detailed business analysis.

Extracted and integrated data from flat files, T-SQL Server, and other structured sources as part of ETL and reporting workflows.

Designed customized queries and optimized data filters to enhance accuracy and reduce data load times.

Implemented Azure DevOps pipelines to streamline CI/CD for data analytics solutions.

Applied machine learning algorithms using Python (Scikit-learn, Pandas, NumPy) to format and analyze data for predictive insights.

Troubleshot and deployed Python fixes to maintain critical applications supporting both customers and internal teams.

Developed Python scripts to parse JSON documents and load structured data into databases.

Used Postman to test and validate RESTful API integrations across analytics workflows.

Generated capacity planning reports through graphical visualizations using Python packages.

Executed log analysis and predictive forecasting using Python libraries to support operational planning.

Engineered calculated fields, mappings, and hierarchies to design comprehensive reports.

Implemented user filters to highlight specific customer or product performance metrics.

Applied Geo Maps, Heat Maps, Drill-through, and Drill-down functionalities to enhance report interactivity.

Designed dual-axis bar charts, donut charts, and pie charts for improved data visualization.

Developed storytelling dashboards in Tableau and published them on Tableau Server for on-demand insights.

Created interactive dashboards in Power BI to complement Tableau visualizations and expand accessibility.

Annotated reports with comments and captions to clarify analysis details and support stakeholder understanding.

Ensured timely deployment of reports to optimize operational efficiency and decision-making.

Used JIRA and Confluence for project tracking, sprint planning, and documentation of analytics workflows.

AgFirst Jul 2020 - Mar 2022

Data Analyst Columbia, SC

Performed data analysis using Python, SQLite, and MySQL, delivering actionable insights to support strategic decision-making for the Business Development team.

Integrated external data sources—including on-prem databases, APIs, and third-party feeds—into GCP using Cloud Data Fusion and Cloud Storage for streamlined ingestion and transformation.

Prepared weekly Data Quality Review checks and presentations, leveraging advanced T-SQL queries and transaction-level data manipulation to ensure accuracy and integrity.

Monitored and enhanced Power BI report automation using PostgreSQL, optimizing sorting, summarizing, and statistical functions.

Designed and developed reports and dashboards from SAP BI/BW and relational data sources, demonstrating strong data visualization skills.

Built and maintained Python models, conducted code reviews, and debugged to ensure optimal performance and reliability.

Conducted exploratory data analysis (EDA) and created visualizations using Pandas, NumPy, and Matplotlib, delivering stakeholder-ready insights.

Developed and maintained machine learning models using Scikit-learn and TensorFlow to predict customer behavior and improve targeting.

Designed and deployed SSRS reports and dashboards to support business intelligence initiatives.

Streamlined real-time data ingestion pipelines using Apache NiFi, enabling seamless integration across Azure and GCP ecosystems.

Automated ETL pipelines using Python and SQL to generate structured outputs such as CSV files.

Created comprehensive Master Data Workbooks documenting ETL requirements, mapping rules, physical data structures, and data element descriptions.

Visualized SQL Server data through Power BI dashboards to drive departmental decision-making.

Collaborated with cross-functional teams using JIRA, Slack, Outlook, and Google Hangouts for coordinated Agile project execution.

Optimized SQL datasets to design and develop new Power BI reports and dashboards.

Ensured audit compliance through thorough management of user accounts and access controls across data projects.

Performed detailed data analysis and quality checks to maintain high data integrity.

Enhanced execution efficiency by leveraging SAS macros, custom Python classes, and Spark/PySpark APIs.

Automated report scheduling in SSRS to ensure timely delivery to stakeholders.

Created interactive visualizations with drill-down and drill-through functionalities in Power BI.

Presented bi-monthly progress reports to the Director, showcasing strategic team achievements.

Developed CI pipelines to standardize software development and testing before production deployment.

Designed Business Intelligence reports in SSRS and MicroStrategy based on detailed business requirements.

Constructed custom DAX functions for robust Power BI reporting and metric customization.

Optimized ETL pipelines using GCP services like Cloud Dataflow, BigQuery, and Cloud Dataproc for efficient data processing.

Managed daily Power BI Gateway refresh schedules to maintain current and accurate dashboards.

Utilized SAP Business Objects for enterprise reporting and data visualization.

Migrated and implemented Business Objects Enterprise Reports, adapting to dynamic software environments.

Repeatedly developed comprehensive reports and dashboards using data from SAP BI/BW and data warehouses, reinforcing enterprise visualization expertise.

Drug Plastics & Glass Co Inc Dec 2018 - Jun 2020

Data Analyst New Berlin Ville, Pennsylvania

Designed, developed, and maintained Power Apps applications to streamline business processes.

Implemented responsive and user-centric UI/UX designs to enhance overall usability.

Integrated Power Apps with multiple data sources and external systems to ensure accurate data synchronization.

Actively participated in testing and quality assurance efforts to deliver robust, bug-free applications.

Collaborated with business analysts and end-users to elicit, analyze, and document business requirements.

Presented detailed Power Apps solutions and provided comprehensive documentation for management review.

Engaged in requirements gathering and technical discussions regarding the reporting data model.

Developed functional specifications and demos for various ad-hoc user acceptance scenarios.

Designed and developed analytical reports by blending data from multiple sources in Tableau Desktop.

Utilized advanced Tableau features to merge disparate data connections into unified dashboards with synchronized filters.

Created custom prompts, calculations, conditions, and filters to enhance analytical reports and dashboards.

Employed Python APIs to extract daily data from multiple vendors efficiently.

Implemented data exploration techniques using Python SciPy to identify patterns and select key features.

Developed Factor Analysis and Cluster Analysis models using Python SciPy to segment customers effectively.

Supported the migration of an EDW to AWS using EMR and additional technologies.

Conducted SQL testing on AWS Redshift databases to ensure data integrity.

Generated category-based analysis groups to facilitate application field segmentation.

Utilized page cards to create dynamic visualizations highlighting revenue and expense trends.

Performed predictive analysis using classification algorithms (e.g., Decision Tree, Naïve Bayes, SVM), clustering (K-means), associ- ation rule mining, and network analysis.

Created Bullet graphs to evaluate profit generation using measures and dimensions sourced from MS SQL Server, MS Access, and MS Excel.

Combined multiple views and reports into interactive dashboards using Tableau Desktop.

Designed, created, and published customized interactive reports and dashboards via Tableau Server, incorporating automated scheduling.

Developed action filters, sets, parameters, and calculated sets to optimize worksheet and dashboard performance.

Implemented Tableau type conversion functions when connecting to relational data sources.

Maxgen Technologies Pvt.Ltd Aug 2016 - Aug 2018

Data Analyst India

Engaged in eliciting and analyzing user requirements to transform them into actionable Tableau dashboards and reports.

Crafted complex SQL queries and optimized them to efficiently retrieve required data while managing performance issues.

Utilized views, stored procedures, and custom SQL queries to validate data across spreadsheets and MySQL databases integrated with Tableau.

Designed interactive reports and dashboards using advanced Tableau features such as LOD expressions, actions, filters, calculated fields, groups, sets, hierarchies, and parameters.

Applied advanced analytics techniques including calculations, parameters, background images, maps, and data blending within Tableau.

Managed Tableau Server and Desktop installations including configuration, user and group creation, project management, and privilege assignments in a multi-server environment.

Developed tables and views to facilitate data load transformation and extraction processes.

Distilled complex data sets by performing multi-table JOIN operations and intricate SQL queries.

Facilitated data import/export processes by developing robust SQL queries to extract data from SQL Server databases into Excel for comprehensive analysis.

Streamlined data analysis workflows from SQL to Excel, producing effective visualizations of essential business metrics.

Enhanced operational efficiency by 24% through optimized time management, streamlined service delivery, and expedited ticket resolution.

Contact this candidate