SUMMARY:

• Power BI Developer with a proven track record of high client satisfaction in various domains such as insurance, banking, hospitality and healthcare.
• Merit of designing data migration strategy to populate the data - mart with facts and dimensions.
• Skilled in developing visually-rich charts, maps, slicers, funnel, gauges utilizing Power BI, delivering actionable insights.
• An excellent team player with strong analytical, problem-solving, and communication skills.

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

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 Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share)

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, AZ

Power BI Developer

• Interpreted business requirements from JRD sessions to technical and function specifications.
• Gained experience in Business Requirements Gathering, GAP Analysis, Data Modeling, Development, Testing, Implementations and Documentation.
• Participated in converting business requirements into specification documents.
• Collected, stored, and retrieved business data for analysis and reporting purposes.
• Involved in developing Stored Procedures, Triggers, and SQL scripts for performing automation tasks.
• Proactively monitored, determined and solved issues at SQL/database/server levels.
• Created dashboards in line with the analytical uniformity using the advanced analysis features of Power BI Desktop.
• Created measures and calculated columns utilizing DAX in Power BI to answer business questions.
• Performed time series analysis using DAX expressions in Power BI.
• Deployed the Power BI reports to Power BI services and pinned visuals to make dashboards out of it.
• Shared dashboards and reports with user groups by using Power BI App and content packs.
• Formulated complicated reports like parameter-based reports, graphical reports, excel reports, drill-down chart and tabular report using SSRS.
• Created a multitude of reports and dashboards with SSRS and Power BI

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

Confidential, Dallas, TX

Power BI Reports Developer

• Collaborated with the project team to outline project requirements in JRD meetings
• Created Data Mart schema to deploy fact and dimension table and defined referenced relationships with the measure groups and fact tables.
• Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.
• Developed data reconciliation SQL queries to validate the overall data migration.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analyzed the data using Statistical features in Power BI to develop trend analysis.
• Published the developed dashboard, reports on the Power BI Services so that the end users can view the data.
• Successfully integrated custom visuals based on business requirements in Power BI desktop.
• Participated in the configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Created complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down chart and tabular report using SSRS.

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

Confidential

Los Angeles, CA

BI Developer

• Documented the business specification artifacts and functional specification artifacts.
• Planned, conducted, and directed business analysis problems.
• Participated in the creation/review of functional requirement specifications and supporting documents for business systems.
• Designed different project solutions to handle a wide array of reporting needs from different aspects.
• Proficient in scripting T-SQL queries, ranking functions, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Used SQL Server error logs and event viewer to troubleshoot issues.
• Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, and Event Viewer to achieve better performance, resolve dead locks/long running queries, accessibility and efficiency.
• Designed and developed SSIS packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Generated sub-reports, drill down reports, drill through reports and parameterized reports using SSRS.
• Utilized Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.

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

Confidential, Culver City, CA

SQL Server Developer

• Conducted JAD sessions with various SMEs to gather Business requirements and developed a detail BRD (Business Requirement Document), Functional Requirements for various web-based Applications.
• Designed and implemented clustered and non-clustered indexes on tables ensuring the efficiency and latency of queries.
• Designed and created data mapping document (DMD) by analyzing data sources and mapping to data mart schema.
• Monitored and resolved deadlocks in SQL Server databases with locks, isolation levels, and SQL Profiler
• Redesigned and improved existing stored procedures, indexes, triggers, CTEs, UDFs, and views with execution plans/statistics
• Incorporated error redirection during ETL loads in SSIS Packages
• Created SSIS Packages for performing ETL operations from the external source.
• Performed and worked with dimensions, measures, generating KPI, and MDX queries.
• Implemented role-based security for reports with report manager.
• Developed multiple reports in SSRS with features such as document maps, actions, conditional formatting

Tools: & Environment: SQL Server 2008 R2, T-SQL, SSIS, SSRS, Power Pivot, Excel, BIDS, SQL Profiler, MS Visual Studio, Erwin, MS Excel

Confidential, Brea, CA

SQL Developer

• Liaised between the business and technical teams towards providing feedback to both on implication of requests and escalating / resolving issues and conflicts.
• Strong Data Modeling experience using ER diagram, dimensional data modeling, star schema modeling, snow-flake modeling using tools like Erwin.
• Extensive experience in database design, normalization, selective de-normalization, forward/ reverse engineering of applications, conceptual, logical and physical data modeling using Erwin.
• Implemented error handing techniques (such as try catch and error functions) to create robust T-SQL code
• Involved in developing Stored Procedures, Triggers, and SQL scripts for performing automation tasks.
• Experience throughout developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Delivered reports with standard and data-driven subscriptions.

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