Power Bi Data Analyst
Resume:
Name- Adithya G
Contact- 217-***-****
Email- ****************@*****.***
Data Analyst
SUMMARY
Data Analyst with 2+ years of experience in Reporting & Dashboard development using Power BI and Tableau in developing various reports and Data Visualization.
Extensive understanding of ETL processes for various scenarios. Import data from multiple sources like SQL Server, Excel, Oracle into Power BI.
Created several calculated columns and measure using DAX formulas in Power BI based on report requirements.
Hands-on experience in writing SQL using RDBMS like Oracle, SQL Server etc.; also good in SQL tuning and Query Performance technique.
Working on MSBI Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App).
Hands on experience in following the SDLC methodologies like Waterfall model and Agile model.
Experience in writing complex SQL Queries involving various tables using SQL joins and writing Sub Queries.
Establish Best Practices for Enterprise Tableau Environment and application intake and Development processes.
SKILLS:
BI Tools
PowerBI, Tableau, OBIEE 11g/12c/OAS
Programming Languages
SQL, PL/SQL, Python, R programming
Database Technologies
Oracle 10g/11g, MySQL, SQL Server, PostgreSQL
ETL Tools
Snowflake, Informatica
Operating systems
Linux (Ubuntu, Centos, RedHat), Windows (XP/7/8/10)
Version Control
Git, Bitbucket
Development Methodologies
Agile, Waterfall
IDE and Build Tools
Jupyter Notebook, Visual Studio, Google Collab, Alteryx, Jira
EDUCATION:
Degree
University
Year of Passing
Major
Master’s
Eastern Illinois University
2023
Computer technology
Bachelor’s
Malla Reddy College of Engineering
2020
Electronics and Communications Engineering
EXPERIENCE:
Merizon Technologies LLC, Gilbert, AZ
Data Analyst/Power Bi
Responsibilities: Jan 2023– Present
Designed and developed insightful Power BI reports and dashboards to enhance operational efficiency.
Utilized DAX functions and M Language for advanced data manipulation.
Created and maintained Tableau dashboards, leading to a 20% increase in operational efficiency.
Automated ETL processes using Informatica to ensure timely and accurate data updates.
Developed Python scripts for data cleaning, manipulation, and visualization integrated with Power BI dashboards.
Ensured data quality through extensive data checks and validation processes.
Familiar with risk identification and escalation processes to manage data-related risks.
Utilized Python libraries like pandas and NumPy for efficient data handling and analysis.
Extensively used custom R-Visuals, Clustered Bar Charts, Clustered Column charts, Donut Charts, Hierarchy slicers, Waterfall charts, Scatter charts, Area charts, KPIs in power BI reports.
Used Power Query to perform column manipulations, including pivoting, unpivoting, and splitting.
Strong Skills in Data Modelling/Relationships (Star Schema, Snowflake Schema) and loading data from multiple data sources.
Designed and developed interactive dashboards and reports using Power BI to visualize business insights, leveraging experience with Qlik Sense.
Data cleaning, Data wrangling, Manipulation and Visualization. Extracted data from relational databases and performed complex data manipulations. Also conducted extensive data checks to ensure data quality.
Proficient in adhering to the Software Development Lifecycle (SDLC) process.
Responsible for creating SQL datasets for Power BI and Ad-Hoc reports.
Experience in working in an agile environment using JIRA, Rally etc.
I utilized Power BI's native ETL Functionality, automating Data Mapping and Integration. This strategic approach led to a 25% Reduction in migration-related challenges and ensured a smooth transition.
Expertise in data warehousing, ETL techniques, source and target system analysis, metadata, process management, reporting, and business intelligence.
Designed and maintained ETL processes to ensure consistent and efficient data synchronization between MongoDB and PowerBI.
Extracted and transformed ERP data from various modules (e.g., finance, HR, supply chain) into Power BI for unified reporting.
Experience in writing complex-SQL Stored Procedures and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.
Environment: Power BI Desktop, Tableau, Power BI Services, Power BI On-Premises Gateway (Standard mode and Personal Mode), SSIS, SSAS, SQL Server, SQL Server Agent, SSMS, MySQL, SQL, DAX, M- Language, Power Query, EXCEL, ETL.
TCS, Hyderabad, India
Data Analyst/Power BI Jun 2020 – July 2022
Responsibilities:
Developed SQL queries for data reconciliation and validation.
Created DAX expressions and partitioned tabular models for Power BI.
Utilized Power BI for statistical analysis and trend reporting.
Transformed and loaded MongoDB data into Power BI using Python and M queries.
Configured Power BI gateway for seamless dataset updates.
Engaged in data quality assurance and risk management practices.
Contributed to the requirements for the SSRS report layout. created complex storing techniques and carried out analysis of reports for reporting services.
Maintained several ETL operations and resolved any associated problems.
Designed and maintained SSIS packages to communicate with Teradata, Oracle, SQL Server, MySQL, and flat files, among other resources.
Produced numerous crucial reports every day and every month.
Using SQL profiler and the execution plan, several performance adjustments were made to improve performance.
Involved in optimizing PL/SQL queries to shorten stored procedures' overall run times.
Well-versed in Data Modeling, which is a tool used by companies to define and assess the data needs necessary to support operations within the framework of linked information systems.
Engage in active collaboration with client stakeholders to collect and record business requirements for the project plan.
Environment: Power BI, DAX, MS SQL Server 2016/2014/2012/2008R2, SQL, Team Foundation, JIRA, MS Excel, CSS, SSRS, SSIS, ETL, PL/SQL, Kanban board.
Contact this candidate