SUMMARY

• Extensive 6+ experience and specialized in Microsoft Power BI, Microsoft SQL server and Azure Cloud
• Demonstrated experience in Power BI for developing Dashboards, Visual Reports, KPI’s and Metrics
• Significant experience in Power BI for designing the UX, building the Prototypes and delivering the best User
• Created Power BI Workspaces and created AD groups for end users to access reports and dashboards.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Worked extensively with Advance analysis by creating toggle Buttons, Bookmarks, Drilldown, Drill through, Calculations, Parameters, Background images, Maps.
• Worked closely with business for gathering the requirements, extracting data from different sources, creating custom business rules, building data pipelines, reports, and data visualizations, collaborating with data engineers on data architecture and design
• Good experience in Deploying and Consolidating Multiple Instances into PowerBI Reports and Dashboards.
• Extensive experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, development, testing, troubleshooting, maintenance, and end user support.
• Experienced in all project phases using waterfall and agile methodologies.
• Expertise in Performance tuning, Optimization and Data integrity.
• Extensive experience in managing User Privileges, Access, Security (RLS) and all other PowerBI administrative tasks.
• Experience in creating Tables, Views, Schemas, joins, and several other SQL statements in support of applications.
• Excellent hands - on experience in using calculated columns, measures, groups, hierarchies and complex DAX queries.
• Extensive experience in designing and developing data visualization Dashboards, according to business requirements using Power BI Desktop and installing and managing the reports on a PowerBI data Gateway.
• Experience in creating bookmarks, Buttons, Filters and ToolTip.
• Experience in creating Dashboards from various sources with new Q&A feature in Power BI service.
• Experience in implementing Incremental refresh for dataset in Power BI Premium.
• Experience in designing various bookmarks and buttons in Power BI desktop.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS)
• Experience working in Cloud environments like Microsoft Azure and AWS.
• Worked on small- and large-scale projects and believes in teamwork.
• Excellent Communication & leadership skills.

TECHNICAL SKILLS

Languages: C, SQL, T-SQL

Web Technologies: ASP.Net, HTML, XML

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSAS

Operating System: Windows 95/98/2000/XP/NT, MS Dos and UNIX.

RDBMS Servers: MS SQL Server 2016/2014/2012/2008 R2/2005, MS-Access, DTS, SSIS PL/SQL, T SQL, .Net, C#, Java, Ruby, Python, Pig Latin.

Databases: NoSQL, DB2, MySQL, Oracle, SQL Server, Sybase MS Outlook, MS Project, M Excel, Power Pivot 2010, MS-Access

Configuration Tools: Team Foundation Server (TFS), GitHub

Data Base Monitoring Tools: SQL Monitor from Redgate, SQL Profiler (SQL Server)

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential - Northfield, IL

Responsibilities:

• Worked along with business users to gather the reporting requirements.
• Successfully migrated old legacy reports in Power BI reports and Dashboards.
• Created standard Power BI templates and Power BI theme for the organization to use.
• Created Workspaces, Apps and helped the IT team in setting up On-Premise data gateway.
• Implemented version control practice of Power BI reports.
• Implemented best practices for creating Power BI reports and Dashboards.
• Implemented RLS for some of the Sales reports.
• Conducted training sessions for users so that they get familiar with Power BI reports.
• Created start schema data model for Power users to do self-sufficient reporting.
• Created reports using, pie charts, column chart, scatter chart, slicers, Line Charts, KPI, and Table Matrix.
• Wrote complex DAX functions in Power BI and PowerPivot.
• Worked extensively with Advance analytics features within Power BI by creating composite model by connecting multiple data sources from Power BI service, SQL server, Azure and SharePoint.
• Implemented advance features like toggle buttons, bookmarks, tooltips, parameters, drill down, drill through, maps, calculation groups in Power BI reports.
• Familiar with external tools (DAX studio, Tabular Editor, Power Bi Helper) within Power BI.

Power BI Developer

Confidential - Naperville, IL

Responsibilities:

• Developed reports for Finance, Forecasting and Healthcare Analytics.
• Collaborated with senior management, subject matter experts, and IT teams to gather and create business requirements.
• Designed and developed Power BI graphical and visualization solutions and plans for creating interactive dashboards.
• Excellent understanding of unstructured requirements, ability to analyze, and translate process diagrams from stakeholders and create Power BI solutions.
• Utilized Power BI to create various analytical dashboards that depict critical KPIs for finance, forecasting and healthcare analytics with effectively using slicers and filters at the report level.
• Modified complex T-SQL stored procedures, functions and created database objects like tables, views, triggers.
• Collaborated with the ETL team to develop mapping and processes according to business requirements.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
• Created Drill Down Reports and Drill Through Reports by Region/Department/Fiscal Year/Month.
• Created bookmarks and Buttons in Power BI dashboards.
• Worked on the performance tuning of the data warehouse and modified the procedures and tables to enhance the performance of the data warehouse.
• Managed Row level security and created roles for users to restrict data for given data at the row level.
• Scheduled jobs for creating a snapshot of Power BI Reports and Dashboards and troubleshooting on datasets for Power BI sites
• Utilized Microsoft Power BI Power Query to extract data from external sources and modify data to by calculated columns as required in Excel and created SSIS packages to load excel sheets into database.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Experienced in developing test cases for UAT, QA and other phases involved in the project.

SQL BI Developer

Confidential

Responsibilities:

• Created different stored procedures and assigned cursors for running and also used stored procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Deployed SSIS packages and Reports to Production Servers.
• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provide high availability support.
• Created partition table for very large database for good performance.
• Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
• Deployed SSRS Reports in SharePoint for web based access for multiple end users
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema
• Created DataWarehouse Cubes in SQL Server Analysis Service (SSAS).
• Reviewed and developed data models and database designs with development teams

Environment: MS SQL Server 2008/2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, SSRS, SSIS, C#, OLAP, UML, Erwin.

Business Intelligence Analyst

Confidential

Responsibilities:

• Converted business requirements into technical specifications for developing business intelligence and SQL reports
• Define, designed and built BI dashboards, reports and metrics to meet the needs of Credible and Partner stakeholders
• Wrote complex SQL queries using joins, subqueries, views and stored procedures to retrieve data from the database
• Use various transformations such as an Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner to design ETL mappings to ensure optimized queries in ETL process
• Expert level capability in Yellowfin calculations and applying complex, compound calculations to large, complex data sets
• Performed ad-hoc requests for clients using customized SQL queries and maintain a 95% satisfaction on reports and tickets
• Engineered the concept of auditing the partner state reports using null data and data validation business rules using Yellowfin business intelligence tool and reduced the partner efforts by automating the reports to almost 90%
• Product owner and QA owner for 100+ product backlog item (PBI) over time and have a 96% report release efficiency
• Acted as a subject matter expert (SME) on state reports and Yellowfin BI for partners and work on numerous partner calls
• Involved in creation and execution of test plan, test scenarios and test cases - integration testing, negative testing and UAT
• Implemented permissions for users and ensure user security according to various clearance levels of business users

Environment: MS SQL Server 2015, Yellowfin BI, SQL, SSRS, TFS, JIRA, SSIS, T-SQL, MS Excel