LiveCareer-Resume

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

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

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
  • Addis Ababa university

Job Titles Held:

  • Data Analyst
  • Power BI Developer
  • Sr. Power BI Developer

Degrees

  • Master of Science
  • Bachelor's degree

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: