Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

S. Aparna

Summary

Highly skilled in writing SQL queries and optimizing them in Oracle, SQL Server, and PostgreSQL. Proficient in data analysis and data profiling using complex SQL on various source systems, including Oracle and SQL. Experienced in utilizing Excel and MS Access to extract and analyze data based on user requirements. Over 5 years of experience in data analysis, report generation, data verification and validation, data transformation, integration, and extraction. Proficient in MS Word, Excel, PowerPoint, and Power BI. Familiar with HTML, CSS, JS, and Python programming languages. Strong understanding of IT concepts, data structures, programming logic and techniques, business applications, and DBMS. Worked in Waterfall (SDLC), TDD, BDD, and Agile project environments. Skilled in creating dashboards and reports using Power BI and Power BI Services. Demonstrates excellent analytical and communication skills with the ability to work independently or as part of a team. Highly motivated team player with strong organizational skills and the ability to adapt quickly to challenges in a changing environment. Excellent interpersonal skills with a proven track record of problem-solving under high-stress situations.

Overview

1
1
Certification

Work History

Power BI Data Analyst

NFP
  • Working closely with business users, gathering requirements for Gap analysis on Power BI Dashboard requirements and translating them into functional Specification
  • Ingesting data from three different data sources and performing required transformations in SQL Server and Power BI query editor
  • Develop multidimensional models that are compatible with data warehouse standards to have all three-data source mutual fields in one database for developing custom calculations to eventually build dashboards
  • Performing effective data modelling for the imported tables to have well defined business relationship cardinality
  • Analyzing data issues within reports by designing and building DAX queries sourced from OLAP (online analytical processing) cubes in Power bi query editor, applying data mining algorithms on source database to have minimum data processing on Power BI azure server side
  • Developing calculations in DAX which are custom to the required KPI, to generate accurate and performant resultant on large datasets
  • Designing effective layouts using themes and report grids, working closely with our UX design team
  • Implementing navigation features in Power BI (e.g
  • Bookmarks, drill-through) to guide business users through a compelling data-driven story
  • Implement row level security on dataset security layer models in Power BI to have accomplish business security risk management across the Power BI Service
  • Adapt in developing, publishing and scheduling of Power BI reports as per the business requirements
  • Working with business users to manage User Acceptance Testing (UAT) processes and fixing any defects identified
  • Publishing reports via the Power BI service, managing them through distribution of apps and monitoring usage/data refreshes/security access
  • Assigning Workspaces to Power BI Premium Capacity
  • Creating and Managing Power BI App within the Power BI Framework
  • Working with Power BI Gateway configuration and Deployment pipeline to streamline the Report deployment from test to production
  • Designing Role level security on Report level to publish reports from different department under single Power BI App workspace without compromising data confidentiality
  • Shaping an approach for governance and deployment of Power BI and Planning a Power BI Enterprise Deployment including advising on licensing, distribution/sharing, training and support Project
  • Collaborated with cross-functional teams to identify key performance indicators for business intelligence projects.
  • Improved company decision-making through comprehensive data visualization tools and dashboards.
  • Developed user-friendly documentation for BI tools, fostering better understanding among non-technical stakeholders.

SQL Developer

Vito soft Technologies
  • Leveraged SQL to extract and analyze large data sets, improving data analysis efficiency by 20%
  • Executed ad-hoc queries and created reports that provided critical data for business decisions
  • Streamlined the data collection process, increasing data quality and reducing errors by 10%
  • Spearheaded the implementation of data warehousing solutions, leading to an improvement of data storage and retrieval by 40%
  • Developed data warehouse structures resulting in an organized and accessible database system
  • Proficient in Data Cleansing techniques, Microsoft Office Suite, including Excel, Outlook, PowerPoint, graph making, formulas, pivot table

Education

MS - Applied Information Technology, DBMS

Towson University
Maryland
01.2020

Skills

  • Power BI
  • EXCEL
  • MS Access
  • Oracle
  • MySQL
  • PostgreSQL
  • SQL
  • PL/SQL
  • Data Cleansing techniques
  • Microsoft Office Suite

Certification

  • MS in Applied Information Technology, DBMS, Towson University, 05/20
  • Analyzing and Visualizing Data using Excel, Coursera
  • Core data Analysis and Presentation, Coursera

Timeline

Power BI Data Analyst

NFP

SQL Developer

Vito soft Technologies

MS - Applied Information Technology, DBMS

Towson University
S. Aparna