Data Analyst Power Bi

Power BI developer/Data analyst

Venkata Sai Ram. N

Mobile: +1-919-***-****

Email: *********.*******@*****.***

Open to relocate mailto:******.*******@*****.***

Summary

Overall 11+ years of experience in various roles.

Experienced Data Analyst with 6 years of expertise in Data Analysis, Data Mining. Proficient in handling large datasets of both structured and unstructured dataset, including tasks such as Data Acquisition, Validation, Predictive Modelling, Data Visualization and ETL

Dedicated and highly accomplished Business Intelligence professional and proven expertise in business intelligence tools, Power BI

Experienced in designing and implementing ETL (Extract, Transform, Load), ensuring efficient data integration, transformation and loading processes

Hands-on experience with in-depth data analysis, leveraging datasets to drive business insights and inform strategic decisions.

Collaborated on requirement analysis, data cleaning, and analysis to deliver targeted data visualizations.

Experienced with using Microsoft Power BI for the creation of dashboards, standard reports and ad-hoc reports

Generated reports and charts by connection to different data sources like excel, sql. Server and implemented drill down functionality using Power BI Tool

Proficient in creating DAX queries in Power BI Desktop and establishing relationships between data sets

Involved in the design, development, and tracking of Key Performance Indicators (KPIs), including the creation of monitoring dashboards

Experience on the concepts of Star schema, Snowflake schema, Dimension &Fact tables

Experience with development for high performance including query folding, optimized joins and excluding unnecessary columns

Knowledge in creating edit interactions of Highlight action, Filter action add inter activity to the Visualization. Created Scorecards, Bookmarks for Reports.

Experience in creating different Data visualizations like Slicer, Line, Bar, Card, Multi card, Table, Pie chart, Donut chart etc

Skilled in data preparation through query editing, including tasks such as adding columns, changing data types, and combining data for data cleaning and shaping

Demonstrated experience in data transformation, metadata management, data dictionary creation, data loading procedures, and performance tuning strategies

Excellent knowledge in SQL like joins, aggregate functions, subqueries, manipulation of Data and Time etc

Excellent knowledge on Microsoft Excel concepts like Pivot table, VLOOKUP, Conditional Formatting etc

Proficient in Agile frameworks, with hands-on experience

Adept in developing, publishing and scheduling Power BI reports as per the business requirements.

Proficient in time management, adept at managing work plans, meeting tight deadlines, and handling multiple projects simultaneously.

A collaborative team player with a strong track record of productivity, commitment, and results-driven performance in both team and individual projects

Trained new hires and crafted policy documents, driving organizational efficiency and compliance.

Had knowledge on Qlik Sense and Tableau

Technical Skills

Database

SQL Server 2012/2016/2017/2019

Reporting Tools

Power BI, SAR, MS Excel, Qlik Sense, Tableau

Languages

SQL, DAX

Methodologies

Agile (Scrum)

Operating Systems

Windows, Mac

Bug Tracking

Radar

Data Quality

Data Governance, Data Lineage, Data Mining

Professional Summary

GlobalLogic

Role: Data analyst/ Power BI Developer April 2019 - June 2024

Responsibilities:

Conducted data refinement using SAR Analytics, correcting inconsistencies in over 3M records, which led to a 25% increase in data reliability and precision for strategic planning

Transformed and standardized partner-provided datasets to ensure compliance with suggested guidelines, enhancing data quality and integrity

Conducted in-depth data analysis, identifying and reporting data issues for resolution across more than 70 datasets, ensuring data quality and integrity

Utilized regular expressions to identify and filter invalid patterns in data, ensuring data accuracy and consistency

Applied data filtering based on requirements and facilitated seamless data export

Implemented Data Lineage methodology for data mapping and maintaining data quality

Analysed partitioned and bucketed data to compute various metrics for reporting purposes.

Conducted knowledge transfer sessions with clients to understand their Data Management systems and created metadata for future data use

Worked closely with peers in requirement analysis, Data Mining, Data analysis, Data cleansing and successfully designing the required visualization as per the requirement

Involved in ongoing production support and process improvements. Ran the DataStage jobs through third party schedulers.

Performed Data Enrichment jobs to handle missing values, normalize data, and select features

Built KPIs in Power BI based on the end user requirements

Developed a technical brief outlining project development stages and timelines based on the business brief

Generated trend reports by analyzing and comparing two datasets from the same partner, identifying key differences and trends

Skilled in Power Query Editor, in creating custom columns, conditional columns and transform data structures using Split columns, Merge columns

Created various interactive reports and Dashboards in Power BI

Created relationship b/w tables using Modelling in Power BI

Created Bookmarks to move from one page to other page based on requirement like moving forward and backward navigation

Created different filters like visual level filters and page level filters and report level filters as per reporting needs

Developed custom time-based calculations, including MTD, QTD, and YTD, to meet project requirements and provide actionable insights

Used Git for version control and followed Agile methodology and SCRUM process for project development

Collaborated with cross-functional teams through daily stand-up and scrum meetings, ensuring project updates, and aligning with project goals and objectives

Wipro

Role: Data Analyst July 2017 – March 2019

Responsibilities:

Analyzed and interpreted complex Requirement Specification documents to ensure project deliverables met client expectations

Implemented Agile Methodology for internal application development, ensuring efficiency and flexibility in project execution

Utilized SQL, Excel, and various Marketing/Web Analytics tools for business and marketing analysis

Worked with different data formats such as JSON and XML

Documented the flow of trade cycle data from source to target and performed QA on extracted, transformed, and exported data to Excel

Maintained and updated project Operational Maturity documents to ensure compliance with industry standards and best practices

Generated high-quality QBR (Quality-Based Reports) to provide actionable insights and drive process improvements

Tracked and analysed team performance metrics for WBR (Weekly-Based Reports), presenting data-driven insights to clients in weekly meetings to drive business growth.

Served as a mentor and coach for new employees, providing guidance and support to ensure successful onboarding and skill development

Randstad India Pvt Ltd

Role: Analyst Nov 2012 – Jun 2017

Responsibilities:

Conducted audits of assigned team member pages and provided feedback for quality improvement

Converting the given documents to comprehensible version using various software tools

Collaborated with Team Leads to conduct workflow analysis, identifying areas for improvement and delegating tasks to ensure efficient project execution.

Implemented strategic placement of consolidation, images, and event IDs in online brochures; improved visual appeal and boosted brochure interaction rate by 35% within three months

Educational Qualification

Completed B.Tech [ECE] in 2011 from Nalanda Institute of Engineering Technology with 63%

Contact this candidate