Power Bi Data Analyst

Jhansi C

Data Analyst / BI Developer

Mobile No: 813-***-****

E-mail: **************@*****.***

PROFESSIONAL SUMMARY:

•Around 5+ years of IT Experience as MSBI developer in Database Design, testing, Power BI report and business intelligence of Microsoft SQL Server in Development and Production Environments with various business domains like Financial and Healthcare.

•Expert in Financial Reporting, Analysis, Budgeting, Forecasting the data in Power BI by generating on-demand and scheduled report for business analysis and management decisions.

•Power BI Expertise with a strong focus on financial reporting, analysis, budgeting, and forecasting. Proven ability to generate on-demand and scheduled reports that drive business analysis and strategic decision-making.

•Hands on experience in installing, configuring, upgrading and migrating both on-premises and Azure cloud systems with High Availability groups.

•Expert in writing T-SQL Queries, Stored Procedures, Common Table Expressions (CTEs), and User Defined Functions, Indexed Views and Triggers for data consistency and data manipulation.

•Expertise in performing most of the SQL server enterprise manager and management studio functionality using T-SQL scripts.

•Proficient in data modeling, Normalization/ Denormalization techniques on database tables.

•Extensive experience in creating packages for data extraction, transforming and loading (ETL) and Analyzed and understand existing reports, Design and enhance new or existing database Modeling.

•Proficient in creating and deploying SSIS packages from heterogeneous sources like Excel, CSV, Oracle, flat file, text format data by using multiple transformations in SSIS such as data conversion, conditional split, bulk insert, merge, aggregate, derived column and union all.

•Experience in Creating and Updating Clustered / Non-Clustered / Column store Indexes to keep up the data Performance.

•Monitor Database performance and fix them on a timely process and keep a track on Jobs that run daily.

•Designed and developed the Microsoft Power BI visualization solutions like Dashboards, Standard Reports, Scorecards, Drill down reports, Drill through reports, charts and Ad - hoc Reports.

•Explored data in different ways and across multiple visualizations using Power BI Desktop and Service.

•Responsible for creating SQL datasets for Power BI and Ad-hoc Reports and created multiple kinds of power BI reports and Dashboards and explored the data in different new visualizations.

•Good Knowledge of ETL Processes such source, mapping, transformation, staging areas and created various ETL documents such as ETL Mapping documents, Data Mapping documents.

•Experienced in Creating DAX Expressions create Date to yearly columns and implement partitions in Tabular Models

for power BI.

EDUCATION:

Bachelor’s in medicine and surgery, M.N.R. Medical college Hyderabad. jan 2016

Data Analysis Course from 360 DigiTMG, Hyderabad, Dec 2016

Master’s in Bioinformatics and Computational Biology, Tampa, FL, May 2024

Technical Skills:

Database

MS SQL SERVER 2017/2016/2014 / 2012 /2008 / 2005, MS Access, MySQL, Power Pivot, Multi-dimensional Cubes, Azure SQL Database.

Programming Langua

T-SQL, C, C++, .NET

DB Tools

SSMS, BIDS, SSDT

ETL Tools

Data Transformation Services(DTS), SQL Server Integration Services (SSIS), Azure Data Factory, One Automation and BI Transform loading

Reporting Tools

SQL Server Reporting Services (SSRS), Tableau, Crystal Reports, Power BI

Data Modeling Tool

ERWIN, data modeling capabilities within Power BI.

SQL Server Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio.

Application Packages

MS Outlook

Professional Experience:

ZT System, Secaucus, NJ Sep 2024 – Till-Date Power BI / Data Analyst

Responsibilities:

•Involved in creating different financial reports based on the business request and ad hoc requirements using Power BI desktop and server. Prepare financial deliverables (monthly, quarterly, accrual and budgetary reports) for funding agencies.

•Create Dashboards and visualization of different types for analysis, monitoring, budget forecasting, management and better understanding of the business performance metrics.

•Created Dashboards Scorecards, views, pivot tables, charts, for further data analysis.

•Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway and deployed web embedded power BI dashboards refreshed using gateways by using workspace and data source

•Designed, developed and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.

•Worked on changing Source file path in Power BI from Shared location for Business with No Gateway.

•Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc and Validate and developed Meta Data for all developed reports in Microsoft Power BI Desktop.

•Worked on changing Source file path in Power BI from Shared location for Business with No Gateway.

•Used various sources to pull data into Power BI such as Multiple Excel files, SQL Server, SQL Azure etc and Validate and developed Meta Data for all developed reports in Microsoft Power BI Desktop, and created the data flow and automated reports with incremental refresh and scheduled the job to run on daily bases.

•Created Data Modeling by understanding and connection multiple table relationship in Power BI desktop.

•Developed complex calculated columns and measures query’s using Data Analysis Expressions (DAX) in Power BI to show good data analysis techniques.

•Hands-on Experience in MDX Expressions, DAX Expressions, Power BI Power Pivot, Power integrated with Share Point and in creating dashboards in Power BI visualization tools.

•Developed SSAS cube and dimension models as per snowflake and star schema.

•Created dimensional usage mapping, measures, KPI, cube partitioning and writing MDX queries as per requirements.

•Conducted as-is and to-be analysis to identify gaps and improve business processes.

•Created process models, workflow diagrams, and reports using MS Word, MS PowerPoint, MS Excel, and SmartDraw.

•Gathered and analyzed business requirements to optimize project deliverables.

Environment: MS SQL Server 2012/ 2014/ 2016, Microsoft Management Studio, Microsoft Visual Studio, Power BI, Power Pivot, Tableau, DAX.

National Life Group, Montpelier, VT Jan 2024– May 2024 SQL / BI Developer (Intern)

Responsibilities:

•Collaborated with business analysts to gather requirements and develop technical specifications for reporting solutions.

•Developed and deployed SSIS packages for ETL processes and created reports using SSRS, Tableau, and Power BI. Environment: MS SQL server 2012 / 2014, SSDT, T-SQL, Visual Studio, SSIS, SSRS, SSAS, Microsoft SQL Server 2012, MS Office

•.Performed system analysis and design using UML diagrams, data flow diagrams, and wireframes.

•Used Agile and Waterfall methodologies to document system requirements and design solutions.

University of South Florida, Tampa, FL Aug 2023 – Dec 2023 Power BI Developer

Responsibilities:

•Migrated the Data for multiple locations through Mapping, and Data Analyzing from Source to Target for better performance to pull the reports.

•Created a report package for the front end team to easily load data for internal and external application system.

•Created Power BI Dashboard to visualize the summary of applicants with applications and requisitions based on their status.

•Designed & Developed share point Work-flows & Data-flows to extract data from Workday and multiple files to SQL Server.

•Worked around Conditional split, Data conversion, Error handling, lookup, data conversion optimization, Merge and Merge Join in SSIS to pull the associates location data from excel sheet joining with internal tables and updating the actual table.

•Performed source system data analysis in order to manage source to target data mapping.

•Data validation and troubleshooting various data processes in development and production environments.

•Designing database schema based on data modeling of business requirements and entities.

•Completed full technical documentation for database to display metadata of database objects and data flow right from the source to the end system.

•Attended sessions for sprint plan, retro, sprint updates in a timely and daily manner on project updates.

Environment: MS SQL Server 2016 (SSIS), T-SQL, Hadoop HIVE, JIRA, Power BI, GIT, Putty, Microsoft Power BI service, Power BI Desktop, MS Office 365, DAX, Microsoft Azure SQL Database.

University of South Florida, Tampa, FL Jan 2023 – July 2023 Data Developer

Responsibilities:

•Analyze large databases and recommend appropriate optimization for the same.

•Worked on support issues and developed new changes in the result set with quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.

•Writing Complex SQL queries using inner joins and outer joins and validating the information in the database is matching the information on the healthcare Application.

•Participated in Database Development using complex Stored Procedures, joins, Triggers, Functions, Constraints, Indexes, Views and Materialized Views as required in a SQL Server environment.

•Created different type of reports which include: Cross-tab, Sub reports, Drill-down and Parameterized, Linked reports and deployed and scheduled Reports in Reports Manager using SSRS to generate all daily, week, monthly and quarterly Reports.

•Prepared various code designs and ensured efficient implementation of the same.

•Monitor Database performance and fix them on a timely process and keep a track on Jobs that run daily.

•Supported Application by creating objects that are need and participate on release process.

•Coordinating with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.

•Performed tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications.

•Attend standup’s and DBA Standup and participate in team meetings, quarter meetings and weekly iteration planning’s.

•Led stakeholder meetings and requirement-gathering workshops, ensuring clear communication.

•Conducted user interviews and brainstorming sessions to capture business needs effectively.

SearchEngineLabs, Hyderabad, Telangana June 2020 – July 2022 SQL Developer / BI Developer

Responsibilities:

•Developed and managed Healthcare reports using Power BI desktop and server, including dashboards, scorecards, pivot tables, and various visualizations for analysis, budget forecasting, and performance monitoring.

•Set up Power BI environments, including workspaces, gateways, and app publishing, with a focus on webembedded dashboards and data refresh automation.

•Designed and implemented Power BI visualizations including dashboard, scorecards, and reports for budget forecasting and business performance monitoring.

•Connected to diverse data sources like SQL Server, Excel, Oracle, and SQL Azure to create complex Power BI reports and dashboards with advanced DAX expressions and data modeling.

•Strong understanding of IT infrastructure, databases, APIs, and cloud technologies.

•Familiarity with software development methodologies such as Agile and DevOps.

Environment: MS SQL server 2012 / 2014, MS Office, SSDT, T-SQL, Tableau Desktop, Tableau Server/Administrator Visual Studio, SSIS, SSRS, SSAS, Microsoft Azure SQL Database.

SearchEngineLabs, Hyderabad, Telangana Nov 2016 – May 2020 SQL Developer / BI Developer

Responsibilities:

•Developed and Optimized Stored Procedures and Functions using T-SQL

•Designed and optimized SSIS packages for ETL processes, integrating data from heterogeneous sources.

•Developed and maintained SSAS cubes and created analytical reports in Tableau and Power BI.

•Enhanced data integrity and performance through stored procedures, triggers, and indexes.

Environment: MS SQL server 2012/2014, MS Office, SSDT, T-SQL, Visual Studio, SSIS, SSRS, SSAS.

Contact this candidate