SUMMARY:

• Power BI Reports Developer with an experience of nearly 7 years in the IT industry.
• Participated in all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Experience of working with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper - based and interactive web-based reports.

TECHNICAL SKILLS:

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER-win, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Integration Tool: SSIS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Cloud Experience: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Storage, Azure Data Warehouses, Data Factory, PowerShell

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Power BI Reports Developer

Tools & Environment: SQL Server 2016, SSRS, SSMS, SSDT, T-SQL, Erwin, TFS, Power BI, SQL Profiler, DTA

• Analyzed and documented business requirements by participating in JRD sessions.
• Conceptualized and designed OLAP tables and indexed and supported logical data models.
• Analyzed data systems and flows and documented related data elements and relationships.
• Developed multitude of database objects such as views, triggers and user-defined functions for business logic.
• Developed user defined stored procedures to write business logic for reporting and ETL operations.
• Created a multitude of reports using Power BI Desktop with a variety of visuals such as charts, tables, slicers, and gauges.
• Implemented common data shaping tasks such as changing data type, grouping rows, and filtering data utilizing Power BI.
• Incorporated the latest features in Power BI such as sync slicers, bookmarks, drill through effect to make reports more interactive and user friendly.
• Created workspace apps in Power BI to share dashboards and reports with co-workers and business users.
• Created dashboards in Power BI service by adding tiles from reports, Q&A, and quick insights.
• Utilized datasets in Power BI service for refreshing data and implementing gateway.
• Created complicated reports like parameter-based reports, graphical reports, drill-down, chart and tabular report using SSRS.
• Collaborated with other team members utilizing TFS.

Confidential, Irvine, CA

Power BI Developer

Tools & Environment: SQL Server 2012, Erwin, SSDT, Power BI, T-SQL, Erwin, MS Excel, TFS, DTA

• Performed requirement analysis and evaluated use cases according to client interaction.
• Outlined multiple constraints in logical phase of the data modeling life cycle.
• Created and managed schema objects such as tables, indexes, and integrity constraints.
• Wrote complex SQL queries and views for fulfilling the reporting requirements of customers.
• Monitored and resolved deadlocks in SQL Server databases with locks, and isolation levels.
• Implemented aggregate functions with group by options to view summarize data for better decision-making process .
• Created new hierarchies and managed relationships (active and inactive) in Power BI data models.
• Performed data messaging operations using Power Query editor in Power Bi desktop to clean data per requirements.
• Published Power BI reports to the Power BI self-service and troubleshoot deployment and performance issues.
• Developed Power BI Apps and deployed to Power BI App workspace to share multitude of dashboards and reports with user groups.
• Installed and configured Enterprise gateways to setup scheduled model/data refresh of Power BI reports.
• Successfully integrated custom visuals based on business requirements in Power BI desktop.
• Created data driven subscription reports by using Report Builder in SSRS.
• Implemented TFS for version control and change management of BI solution for cross-functional communications.

Confidential, Somerville, MA

BI Developer

Tools & Environment: SQL Server 2012, T-SQL, SSRS, SSMS, SSDT, SQL Profiler, Erwin, DTA, Power Pivot, Power View, Power Map

• Gathered the requirements from the business users for the different source systems.
• Created complex SQL queries, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).
• Contributed for the performance tuning of SQL queries and stored procedures.
• Integrated data from multiple sources such as SQL table into the staging area.
• Implemented error handling in TSQL scripts such as try…catch blocks, @@error and various error handling functions.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Implemented report access security at server, report, and report item levels in SSRS.
• Implemented snapshots, cache, and utilized stored procedure for report data set to get optimum performance.
• Implemented Power Pivot to develop data analysis prototype, Power View and Power Map to visualize reports on map.

Confidential, Dallas, TX

SQL/SSRS Developer

Tools & Environment: SQL Server 2012, T-SQL, SSRS, SSMS, SSDT, SQL Profiler, MS Visual Studio, Erwin, MS Excel, TFS

• Gathered business requirements to facilitate the planning and implementation of a data warehouse.
• Maintained referential integrity, domain integrity and column integrity by utilizing constraints.
• Normalized tables to remove redundancy and maintain system consistency.
• Wrote complex stored procedures, functions, and triggers to implement business logics.
• Optimized SQL queries with execution plans to improve performance.
• Developed code with respect to security vulnerabilities such as SQL injections.
• Defined data sources and data source views for OLAP Cubes utilizing SSAS.
• Designed and developed SSRS reports using data from OLAP.
• Developed various forms of reports such as drill down, drill through, parameterized, cascade parameterized reports using SSRS.
• Designed and created report templates, bar graphs, and pie charts based on data.

Confidential, Boston, MA

Database Developer

Tools & Environment: SQL Server 2008 R2, T-SQL, SSMS, BIDS, SSAS, SSRS, SQL Profiler, DTA, TFS

• Coordinated with business users to clarify business requirements pertaining to the database application.
• Created Entity Relationship (ER) diagrams for the proposed data mart.
• Improved performance with index analyses on tables and clustered and non-clustered indexes.
• Enforced business rules by creating constraints in both the production and relational data warehouse databases.
• Designed stored procedures for index maintenance, profiling data, staging procedures, and reporting databases.
• Redesigned existing stored procedures, triggers, UDFs, and views to improve the performance of queries.
• Created SSAS cubes to facilitate the reporting application.
• Created dashboard reports to support end users using SSRS.
• Designed reports using complex formulas and queried the database for generating different types of ad-hoc reports using SSRS.
• Used SSRS to create, execute, and deliver tabular, matrix and charts reports.