SUMMARY

• Highly motivated SQL server/Power BI developer with around 7+ years of IT Experience having multiple skill set and extensive working experience in Data warehousing and Business Intelligence Technologies with expertise in SQL Server Development, MSBI Stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI for building, deploying and managing applications and services through a global network of Microsoft - managed data centers.
• Experienced in client requirement Analysis, Physical, Logical design, development Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2014/2012, SSIS and SSRS 2012/2014/2016.
• Strong ability to analyze user requirements, Business Requirement Specifications.
• Experience in configuration and maintain Report Manager and Report Server for SSRS, deployed and scheduled the reports in Report Manager.
• Expert in creating and developing Power BI Dashboards in to rich look and tested Power BI reports of Database and verified it with the source data.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2014.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER functions.
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Extensive knowledge in Tuning T-SQL queries to improve the database performance.
• Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL in SSRS.
• Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).
• Analyze large databases and recommend appropriate optimization for the same.
• Expertise in Power BI, Power BI Pro, Power BI Mobile, Power BI Embeded, Power BI Premium
• Good knowledge of Defining, Developing and Deploying Star Schema, Snow flake Schema and Dimensional Data modelling using MS SQL Server Analysis Services (SSAS) on EDW.
• Worked on Power BI which acts like a cloud service that works with Excel to provide a Self-Service BI.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Support the business users and resolved issues pertaining to all the Supply chain management and distribution modules after go-live.
• Creating, designing and developing data models
• Excellent knowledge of all the phases of Software Development Life Cycle (SDLC).
• Involved in keeping the team focused and on track and also established meeting times, places and agendas.
• Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.
• Involved in Coordinating meetings with the product committee, project manager and functional management to discuss project impediments, needed resources or issues/delays in completing the task.
• Also have knowledge on various industries like insurance, finance, health care, retail.

TECHNICAL SKILLS

BI Tools: POWER BI, SSIS, SSRS, SSAS

RDBMS Servers: MS SQL Server 2016/2012

Operating Systems: Windows

Programming Languages: PL/SQL, T-SQL

Databases: Oracle, SQL Server, DB2, Azure DevOps

Office Applications: MS Outlook, MS Project, MS-Excel, MS Visio

Configuration Tools: Team Foundation Server (TFS)

Data Base Monitoring Tools: SQL Profiler

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, Florida

BI Developer

Responsibilities:

• Designing, developing and maintaining business intelligence solutions by creating visualizations and reports for various projects like SCM (Supply Chain Management), Opioid Analysis.
• Worked on various reports with data sourced from Azure DevOps.
• Built Burn up, Burn down and many other PMO related charts/reports for various Projects to track the progress and take necessary project related decisions.
• Worked on integration of Azure DevOps and Power BI to make use of the work item types from Azure Devops to get analytical solutions for PMO team.
• Embedded reports in Confluence page so that users within the organization can consume the reports.
• Created Workspaces in Power BI Service and created RLS for many reports to maintain Manager Level and other roles visibility in Confluence pages.
• Created multi-layer queries in Azure DevOps to maintain optimized Data Modeling in Power BI and improve performance of reports.
• Translated business needs to technical specifications. Develop and execute database queries and conduct analyses.
• Worked on POC’s like Pharmacy Channel Utilization and Prescriber Channel Utilization dashboards and deploy in Power BI Report Server.
• Worked closely with the IT team and key business stakeholders across all departments to maintain and improve reporting services infrastructure and ensure reports are delivered accurately and in a timely manner.
• Worked as Power BI developer in creating reports like Benefits Tracker Report, Activity WIP report for SCM (Supply Chain Management) project which involved multiple DAX queries to create user-friendly dashboards.
• Worked on dashboards for Opioid Analysis Project in two phases.
• Created Dynamic Measures using DAX to enhance the reports with multi-selection within the dashboard level.
• Used multiple card visuals in the dashboard to analyze various KPI’s involving Opioid Data Analytics.
• Worked along with database team to design and implement schemas which efficiently and accurately render data through Power BI.
• Create DAX queries in Power BI to analyze the data in different scenarios as per business requirements.
• Connecting to multiple datasets to bring all of the relevant data together in one place and create reports, dashboards, KPI’s that provide a consolidated view of different data sources.
• Worked as the solo developer in BI-SSRS Remediation Project which involved migrating existing reports which are in SVN to Gitlab and changed from BART to Jenkins.
• Migration of existing SSRS Reports to newer version using Visual Studio 2017, as well as debugging, and troubleshooting in each environment.
• Worked on Migration of SSRS Reports for various Projects like Provider Profiling, Quality Measures, CAC, ECL, MyBlueInsight, FinancialInformatics, RxScorecards.
• Performed validation of every report in Dev, Test, and Stage and deployed to Power BI Report Server through Jenkins.
• Worked as the main Developer in deploying the SSRS reports through Jenkins instead of BART.
• Involved in migrating reports which are in SVN to Gitlab and validating those reports through UI (BlueBI application).
• Worked in different Project methodologies like AGILE, Waterfall and Kanban.
• Ensuring quality of reports and visualizations through troubleshooting end user issues.
• Crafting and executing queries upon request for data and presenting information through reports and visualizations using Power BI and other Microsoft tools.
• Optimized Power BI dashboards with a focus on usability and performance.
• Published the finished dashboards, reports in Report Server for the use of report consumers.
• Involved in understanding complex data structures and data models to formulate efficient read-write data strategy.
• Worked on projects that may be assigned on an ad hoc basis and possibly assisting other corporate initiatives as necessary.

Confidential

Power BI developer/Admin

Responsibilities:

• Used Power BI Desktop to connect various data sources like Azure, SQL Server, SAP HANA and worked with different visualizations and created dashboards.
• Used various Data Visualizations with Power BI and published reports to Power BI Services and Premium.
• Worked on adding tiles to the dash boards, images to the dashboards using Power BI services.
• Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Developed Tabular Model infrastructure in SSAS for various Lines of Business and created over different interactive Dashboards using various visualizations in Power BI Desktop
• Created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, etc.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting services.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.
• Expertise in Data Modeling in Power BI Designer using bi-directional and single directional filtering between fact and dimension tables
• Using Power BI connect live to Analysis Services models both tabular and Multidimensional cubes.
• Developed Reports to visually explore data and create an interactive report Excel and Power BI also Power Maps.
• Created Static and Dynamic Row-Level-Security in Power BI Desktop and assigned roles to users via service.
• Created Power BI template files and gave input parameters to the file for filtering the entire report accordingly
• Provided Alerts and subscriptions for dashboards in Power BI Service.
• Installed and Configured Enterprise and personal gateways in Power BI service.
• Worked with conditional formatting and fonts with Power bi visuals to understand the data better.
• Using a Query Editor in Power BI performed certain operations like fetching data from different file.
• Working with import and direct query, creating calculated columns and measures in Power BI.
• Merge Queries and Append Queries, remove columns and split columns, choosing required columns in the data.
• Created Power BI Reports using the Tabular SSAS models in Power BI desktop and published them to Dashboards using cloud service.
• Used Live connections of tabular model and multidimensional cubes from SSAS to Power BI
• Worked with import and direct query, creating custom tables in Power BI
• Using a Query Editor in Power BI performed certain operations like fetching data from different file.
• Created Drilldown and Drill through in Power Bi Reports by going to start and end of data structure.
• Working with table and matrix visuals, Worked with different level of filters.
• Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector
• Created dimensions by defining Parent-Child relationships, using different dimension types.

Confidential, Dallas

SQL Power BI Developer

Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
• Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Used various Data Visualizations with Power BI and published reports to Power BI Services.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tool
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Populated data store with CRM Data (Oracle) using Integration Services (SSIS) as catalyst for ETL process.
• Created Databases, Tables, Views, Indexes and Created and maintained Roles and Database users.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Scheduling Jobs and Alerting using SQL Server Agent in Power BI
• Created datasets for reports using T-SQL and stored procedures
• Performed DBA tasks like Backup, Restoration of tables and Stored Procedures and Refreshing Databases on weekly basis.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Confidential, Windsor, Connecticut

MSBI Developer

Responsibilities:

• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, cleaned and Standardized Data meeting the business standards using Fuzzy/exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions .
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
• With the help of TFS, managed repositories, build processes, testing infrastructure and lab deployment while easily collaborating and reporting status.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted with vendors, developers and customers to manage the business requirements.