PROFESSIONAL SUMMARY:

• Having 6+ years of experience in full Software Development Life Cycle - requirements gathering, analysis, design, development, testing and documentation.
• Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging and Maintenance of business applications using SQL Server 2014/2012/2008/2005, SSIS and SSRS 2005/2008/2012/2014/2016.
• Expertise in designing and developing Power BI visualizations according to business requirement documents and plans for creating Dashboards.
• Strong noledge on Power BI to import data from various sources such as SQL Server 2012/2014/2018, Azure SQL DB, MS Excel, SQL Server Analysis Services (Tabular Model), etc.
• Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).
• Strong Knowledge in Power BI on how to import, shape, and transform data for business intelligence, visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Hands-on wif creating solution driven views and dashboards by developing different chart types.
• Skilled in creating measures, calculated columns and performing time series analysis using DAX in Power BI.
• Responsible for creating Power BI reports and deploying to Power BI services.
• Experience in Navigation options including Bookmarks, Drill-thru, Buttons and Actions.
• Performed the time series analysis using DAX expressions in Power BI.
• Experience on publishing Power BI reports on Dashboards in Power BI server.
• Created hierarchies in Power BI reports using visualizations like Bar Chart, Line Chart.
• Worked wif both Import and Direct query mode to import data into Power BI for creating reports.
• Performed transformations like Merge, Append, Transpose, Pivoting, Unpivoting and splitting of the columns using Power Query.
• Experience wif Column (Field) Grouping, Hierarchies creations and usage.
• Experience wif Edit Interactions and Bookmarks including button and actions.
• Performed configuration of on-Premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Work wif Power BI Report Server for paginated reports and using Report Builder Tool.
• Experience in writing T-SQL Stored procedures, Views, Constraints, and Indexes using various DDL and DML commands.
• Excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS:

Power BI Tools: Power BI Desktop, Power BI Gateway, Power Query, DAX, Power BI App.

RDBMS Servers: MS SQL Server 2017/2016/2014/2012, Oracle 13c/12c/11g/10g

Operating Systems: Windows Server 2016/2012/2008/ XP, UNIX, Linux

Testing / Defect Tracking Tools: JIRA, Service Now

Web Technologies: HTML 5/HTML, JSON, XML

Programming Languages: JAVA

Methodologies: Agile, Waterfall

Others: Notepad++, Eclipse, HP Quality Centre, Git

EXPERIENCE:

Confidential, Atlanta

Power BI Developer

Responsibilities:

• Worked closely wif various teams across the company to identify and solve business challenges.
• Gathering and Analyzing requirements of clients, understand and convert then into solutions wif solid exposure to architecture, analysis, design, testing, development, deployment, documentation, and implementation.
• Import Data from different data sources to create Power BI reports and Dashboards.
• Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements.
• Transform, define, navigate the data from data source and performed merge and append queries using Power Query.
• Performed transformations like Pivoting, Unpivoting and Splitting of Columns using Power Query.
• Created different drill down reports using Power BI Desktop.
• Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI.
• Created hierarchies in Power BI Reports using visualizations like Bar Chart, Line Chart.
• Worked wif both Import and Direct query mode to import data into Power BI for creating reports.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created measures, calculated columns in Power BI Desktop to show good data analysis techniques.
• Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.
• Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

Environment: Power BI, DAX, Power BI Gateway, Power Query, MS SQL Server 2016/2014/2012. MS Excel, Windows 8/10, Team Foundation, SQL Server Integration Services (SSIS), Service Now, SQL Server Analysis Services (SSAS)

Confidential

Power BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed the dashboard layout.
• Designed different types of reports like drill down, drill through, sub reports, parameterized reports in Power BI.
• Published Power BI Reports in the required originations and made Power BI Dashboards available in Web Clients.
• Utilized T-SQL constructs such as joins, subqueries, derived tables and views for querying data.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created hierarchies and attributes as part of dimensional modeling.
• Responsible for creating datasets using T-SQL Stored procedures and involved in Data Visualization.
• Developed complex stored procedures and views to generate various drill-through reports, parameterized reports and linked reports using SSRS.
• Configured Data Gateways for automated and Manual data refresh from on-premises.
• Experience in custom visuals and groups creation in Power BI.
• Experience in scheduling refresh of Power BI reports, hourly and on-demand.

Environment: Power BI, DAX, Power BI Gateway, Power Query, MS SQL Server 2016/2014/2012. MS Excel, Windows 8/10, JIRA, JSON, MS SQL Server Management Studio SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Confidential

Power BI Developer

Responsibilities:

• Interacted wif Business SMEs on requirement gathering, understanding business and functional requirements.
• Develop Power BI data visualizations which are used for financial reporting of delinquency rates and Lian Originations for client.
• Connect to Various sources like to load the data into Power BI and build relationships between source tables.
• Wrote different DAX scripts inside Power BI to perform complex data analysis.
• Weekly presentations to business users about the reports and changes as per the requirements.
• Implemented Bookmarks between multiple visualizations between multiple dashboards in Power BI.
• Various location-based reports are developed so users can drill through the reports on their respective branches.
• Developed complex stored procedures and views to generate various drill-through reports, parameterized reports and linked reports using SSRS.
• Created and stored T-SQL queries to validate data between different sources and Power BI.
• Worked on publishing Power BI Reports to Dashboards in Power BI server and scheduling the dataset to refresh data in multiple intervals to automate the report data refresh using Power BI Enterprise gateway.
• Monitor, Triage, Track and resolve issues wif the Excel Power BI Reports.

Environment: Power BI Desktop, Power BI Service, DAX, Power BI Gateway, Power Query, MS SQL Server 2012, SQL Server Management Studio, MS Excel, Windows 8, MS SQL Server Management Studio SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).

Confidential

Power BI Developer

Responsibilities:

• Working wif Power query for intrinsic and Reusable Parameters wif Static/ Dynamic dropdown values.
• Involved in requirements analysis and data analysis to derive the business logic, validation of data mappings.
• As a Power BI developer responsible for the design, development, and production support of interactive data visualizations.
• Created Power BI Dashboards using different types of Slicers and different visualizations like Bar Charts, Line Charts, Pie Charts, Clustered Chart etc.
• Created stored procedures, SQL Joins and T-SQL Queries to implement business rules and created data sets required for power BI reports. Also used Azure data cubes data to import data to Power BI.
• Responsible for building reports in Power BI from the Scratch.
• Handled data coming from various data sources and destinations like excel, flat files, csv files.
• Hosted SSIS, SSRS noledge transfer, data quality issue meetings wif the client on a weekly/biweekly basis.
• Implemented parameters in reports for user input fields as per business requirements.
• Created the Dashboards wif Tiles and pins from reports, insights and shared it to user groups using Power BI Apps.
• Performed various complex calculations and created custom measures using Data Analysis expression (DAX).
• Worked wif Power BI Report Server for Paginated reports and using Report builder tool.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.

Environment: Power BI Desktop, Power BI Service, DAX, Power BI Gateway, Power Query, MS SQL Server 2012, SQL Server Management Studio, MS Excel, Windows 8