Post Job Free

Resume

Sign in

Power Bi Sql Server

Location:
Tempe, AZ
Posted:
August 01, 2023

Contact this candidate

Resume:

N Annapurna Ch (H* – EAD) +1-623-***-**** Power BI Developer/SQL adynr2@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 5 + years of IT Experience working as a Business Intelligence Developer (Power BI) involved in the analysis, design, development, testing, and implementation of business applications with good analytical skills.

Proficient in understanding business processes/ Functional requirements and translating them into technical requirements. Good understanding of the overall Software Development Life Cycle(SDLC).

Successfully developed and published applications using various technologies like Power BI.

Experience in creating Power BI reports and dashboards with Good rich visuals.

Worked on different sources like Excel, Flat file, Tables, and Sharepoint online to load data into Power BI.

Experienced in Microsoft Business Intelligence Suite (Power Pivot, Power View, Power Query, Power Maps, Power BI Desktop, Power BI Service, Power BI Mobile App).

Created various visuals using Line/Bar charts, Guage charts, Tree charts, Pie charts, Tables, Funnel, Histogram charts, Matrix, Card, and Multilevel cards involving the concept of DAX calculations, Drilldown & lot more.

Worked on different levels of filters like Page level filters, Report level filters, Visual level filters to reduce the data size into visual of report.

Good Knowledge of Power BI Data Modeling and Data Warehousing concepts like Star Schema, Snow Flake Schema, Dimensions, and Fact tables.

Created Power BI Apps and connected them with Live datasets for real-time analysis.

Hands-on experience in SQL queries on SQL Developer and Oracle databases.

Proficient in working and delivering in Agile Methodology, Scrum Ceremonies, and User Stories.

Interact with Technical Lead, Business Analyst, SQA Lead, and Scrum Master for review of user stories and business requirements in the JIRA tool.

Good knowledge of data sources including Sales, Claims, Patients, Service Requests, Interactions, Alignments, etc., and data profiling.

Extracted, transformed, and loaded data from various heterogeneous data sources and destinations like Excel, CSV, and Tables using connectors and created reports based on business requirements.

Maintains best practice guidelines in report development.

Excellent analytical, problem-solving, business interaction, written and verbal communication skills. Self-motivated and ability to work productively within diverse teams.

Good Experience working and implementing processes in different bussiness domains like Life Sciences and Insurance.

Education details

Master of Computer Applications from Andhra University, India.

Bachelor of Science in Mathematics, Statistics, and Computer Science from Andhra University, India.

TECHNICAL SKILLS

Reporting Tools

Power BI

Databases

Oracle, SQL Server and Teradata

Tools

SQL Developer, TOAD, SQL server Management Studio, SAS

Languages

SQL, C, C++, Qlik Scripting

Scripting Languages

Java Script, VB Script, UNIX

Operating Systems

Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers

PROFESSIONAL EXPERIENCE

Healthcare & Life Sciences March 2020-Till Date Role: Power BI Developer (Remote)

Responsibilities:

Created and maintained Power BI reports/dashboards based up on business requirement.

Developed Power BI model used for market data.

Used various sources to pull data into Power BI such as Sql Server, Excel, SQL etc..

Created Workspace and content packs for business users to view the developed reports.

Designed and created data extracts, supporting Power BI.

Integrated Custom Visuals based on business requirements using Power BI desktop.

Created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.

Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.

Developed calculated measures using Data Analysis Expression language (DAX).

Healthcare & Life Sciences Jun 2018 – Feb 2020 Role: BI Developer/Data Analyst (Remote)

Responsibilities:

Gathering requirements from Clients, Working with Business Analysts and Leads to develop the dashboards and providing demos.

Responsible for the implementation, analysis, design, development, administration and support of the Qlik dashboard.

Responsible for the development of enhancements, change requests, and support requests.

Involved in Planning, Defining, and Designing data based on business requirements and provided documentation.

Published the dashboard reports to Power BI service for navigating the developed dashboards on web.

Developed SQL queries using stored procedures, common table expressions (CTEs), and temporary table to support Power BI reports.

Involved in troubleshooting, resolving, and escalating BI issues.

Used Incident Management (ICM) to create tickets for various productivity issues to ensure transparency and prioritize work flow.

Create reports for internal teams and/or external clients.

Collaborate with team members to collect and analyze data.

Developed scenarios for Unit, Integration testing to ensure that all the components work correctly after integration.



Contact this candidate