Data Analyst resume example with 7 years of experience
Jessica
Claire
resumesample@example.com
(555) 432-1000,
, , 100 Montgomery St. 10th Floor
:
Professional Summary
Around 7 plus years of experience in Data Analysis, Power BI, Power BI Pro, Power BI Mobile.
Experienced in creating Views, Constraints, Triggers, Joins, Cursors, Temp
Table, Table Variable, Functions, Batch Scripts, and numerous stored procedures consumed at various
stages of migration/cleansing process, reports, or data validation.
. Created logging to check the status of each pipeline and Data is moved to Azure Data Warehouse
from Azure storage
Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking
Functions, TOP(n), PIVOT, XML PATH, SQL, Physical, logical database design, and
Performance tuning.
Implemented Star and/or Snowflake schemas while designing relational database and data
warehouse as per business and report requirements.
Helped to develop backup and recovery strategy for databases on virtualization platform utilizing
Microsoft Azure.
Responsible for building reports in Power BI from the Scratch.
Creating Row-level securities and integrating with Power BI service portal.
Used Cross-Report Drill through to link source and target reports to drill through the necessary
information for the end-user.
Design, develop, and optimize data models
Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence
(BI), Visualize data, author reports, schedule automated refresh of reports and create and share
dashboards based on reports on Power BI desktop.
Strong Dashboard design experience and passionate practitioner of effective data visualization.
Familiarity with best practices around visualization and design.
Expert in creating and developing Power BI Dashboards into the rich look and tested
Power BI reports of the Database and verified it with the source data.
Implemented Power BI Gateway different sources to match analysis criteria and further modeling for
Power Pivot and Power View.
Utilized Query Editor to clean and format data and eliminate redundant information and append and
merge tables from various data sources.
Good Knowledge and experience on Power BI Gateways (Personal and Enterprise gateways).
Hand on experience in writing calculated columns and measures using DAX query language
Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter
Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time
Brush etc.) in Power BI according to the requirements.
Experienced in Error handling and Debugging coding issues and troubleshoot production problems.
Experienced in publishing Power BI Desktop reports created in Report view to the
Power BI service.
Used Power Query to acquire data and Power BI desktop for designing rich visuals.
Skills
Guest services
Inventory control procedures
Merchandising expertise
Loss prevention
Cash register operations
Product promotions
Education
North Carolina Agricultural and Technical State Technical University, Expected in 2019 ā āMaster of Science:Applied Mathematics - GPA:
Addis Ababa university, Expected in 2005 ā āBachelor's degree:applied mathematics and statics - GPA:
Work History
Tsr, Inc. - Data Analyst Warren, NJ, 06/2021 - Current
Project Specific Activities:
Used Power BI desktop to directly connect to database tables (Direct Query Mode) or import the files
into Power BI (Import Mode)
Developed documentation for business requirements, functional and technical specifications, and
development standards for assigned projects and applications
Designed reports utilizing custom filters and DAX expressions with excel, and written DAX Expressions,
Ower Query and Functions in Power pivot
Created database links and accessed the data through SQL statements
Analyzed source system data to assess data quality, working with technical and business
representatives to determine strategies for handling data anomalies that are identified
Implemented data migration from Microsoft Azure cloud platform to on-premises data servers utilizing
Zure cloud technology
Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions
Created hierarchies in Power BI to help end-users make accurate decisions based on the visualizations
Created custom KPI scorecards to help end-users visualize metrics according to their preference
Created multiple transformations and loaded data from multiple sources into the
Ower BI Dashboard
Worked using Column profiling to optimize columns and remove redundancies and errors from
individual columns
Developed complex SQL Views, Common Table Expressions, and Temporary Tables.
Involved in generating and maintaining SQL scripts
Participated in Daily stand-up Agile/Scrum meetings to discuss regarding the enhancements to be
made for the existing requirements
Used Power BI to extract data from different sources such as SQL Server, Excel, CSV files, load cleaned
the data, and loaded it into the Power BI canvas for visualization and analysis
Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled
slowly changing dimensions to maintain the history of the data.
Avanade - Power BI Developer Columbus, OH, 06/2019 - 05/2021
Coordinated with business users in analyzing business requirements and translating
them to technical specifications
Discussed with the team to come up with best possible visuals to show the requirements
Implemented several DAX functions for various fact calculations for efficient data visualization in Power
I
Published Power BI Desktop to the cloud
Performed tuning of SQL queries and Stored Procedures for speedy extraction of data to resolve and
troubleshoot issues in OLTP environment
Utilized Power BI Gateway to keep the dashboards and reports up to date
Provided guidance and insight on data visualization and dashboard design best practices in Tableau
Created many complex Queries and used them in Power BI Reports directly to generate reports on
the fly
Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple
tables & calculations from different databases
Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks
Checking the code into TFS (Stored Procedures, Views, Tables, Schema) for the deployment process
for the production environment
Created logging to check the status of each pipeline and Data is moved to Azure
Ata Warehouse from azure storage
Published Power BI Reports in the required origination's and Made Power BI Dashboards available in
Eb clients and mobile apps
Responsible for deploying the application for the Integration, Functional and
Ser Acceptance Testing
Adheres to department, organization and industry guidelines, standards, policies, and procedures
Created Page Level Filters, Report Level Filters, Visual Level Filters in Power
I according to the requirements
Used One Drive for storing different versions of Power BI report
Responsible for complete maintenance and delivery of scheduled releases
Developed custom-calculated measures using DAX in Power BI to satisfy business requirements
Responsible for creating critical compliance test analysis documents and
Usiness Requirement Documents (BRD).
Cognizant Technology Solutions - Sr. Power BI Developer Whitehouse Station, NJ, 04/2014 - 09/2018
Project Specific Activities:
Developed Power BI reports and dashboards from multiple sources using data blending
Explored data in a variety of ways and across multiple visualizations using Power BI
Performed and worked with dimensions, measures, DAX
Designed attractive dashboards with visualizations such as maps, funnel charts, waterfall charts, and
word cloud in Power BI
Assisted in production and non-production OLAP cubes, wrote queries to produce reports using SQL
server, SSAS
Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density
charts
Designing current databases by adding tables, relationships, creating stored procedures, views, and
performance tuning of SQL queries
Created gateways in power BI
Developed SQL queries to validate the data such as checking duplicates, null values, truncated values,
and ensuring correct data aggregations
Developed complex SQL Views, Common Table Expressions, and Temporary Tables
Created & maintained data sources in Cognos connection and used Framework manager's best
practices to create
Models, publish packages, designed several reports using Cognos Report Studio on
DW environment
Provided maintenance and development of bug fixes for the existing and new Power
I Reports
Involved in generating and maintaining SQL scripts
Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such
as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user
to make filters
Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision-
makers for strategic planning
Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data
massaging
Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
Implemented code check-in/check-out and managed multiple versions of complicated code within TFS
Performed thorough unit testing on all relevant platforms to ensure proper implementation
Responsible for building reports in Power BI from the Scratch
Creating Row level securities and integrating with Power BI service portal
Used Cross-Report Drill through to link source and target reports to drill through the necessary
information for the end user
Created and developed star and snowflake schema
Willing to relocate: Anywhere
Additional Information
Willing to relocate: Anywhere, Authorized to work in the US for any employer
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.
Resume Overview
School Attended
North Carolina Agricultural and Technical State Technical University