SUMMARY

• Power BI Developer with an experience of nearly 6 years in design, development, analysis of databases and business intelligence solutions including SQL scripts, database objects, ETL frameworks, data conversion and reporting.
• Proficient in integrating database objects with T - SQL such as stored procedures, UDFs, triggers and indexes to create complex scripts and batches.
• Skilled in implementing error handling procedures in SSIS packages with event handlers, row redirects, checkpoints, and loggings.
• Experienced in developing Power BI reports and dashboards from multiple data sources using data blending and managing database views available to all BI and DW applications.
• A result-oriented professional with excellent analytical & communication skills.

TECHNICAL SKILLS

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

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

Programming Language: Java, R, JavaScript, PowerShell, Bash

Cloud Technologies: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share)

SDLC: Agile, Scrum, Waterfall, and Spiral

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Power BI Developer

Tools: and Environment: Power BI, SAP HANA, PowerShell Azure, Power BI JavaScript library, Ctrl-M, SharePoint

Responsibilities:

• Participated in daily and weekly scrum meetings and weekly status meetings with team members.
• Present reports changes and updates in the daily and weekly status meetings
• Collect comments and feedbacks from end users in UAT and KT sessions.
• Backup. PBIX files with certain name conventions in server folder.
• Config the ODBC driver to connect multiple databases.
• Data modeling inside of Power BI with mashup code and query editor.
• Benchmark different connect methods with Power BI and Azure Data Lake.
• Realize the business requirements with DAX.
• Realize dynamic rank, time comparison and dynamic RLS with rankx, sumx, except and other DAX functions.
• Create KPI style indicators inside power BI environment with emoji.
• Optimize the report performance with creating measure group, bookmark group and calculate columns.
• Utilize new features such as advanced visuals and filters pane.
• Utilize the PowerShell script to handle automation refreshment.
• Utilize the Power BI embed service to customize visuals with PwC dashboard pane.
• Generate technical document for offshore team to maintain developed reports and workspaces.
• Complete the Power Shell script to update datasets in Windows node. Triggered by Ctrl-M server.
• Provide help and guide to end client to create ad-hoc reports themselves.

Confidential, Scottsdale, AZ

Power BI Developer

Tools: and Environment: SQL Server 2016, SSIS, SSAS, SSMS, SSDT, T-SQL, Erwin, TFS, Power BI, SQL Profiler, DTA

Responsibilities:

• Participated in daily scrum meetings and weekly status meetings with team members.
• Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT process for creating data quality rules in COSMOS.
• Converted unstructured streams in COSMOS to structured stream and performed required aggregation on that data using scope studio by writing scope scripts.
• Gathered business requirements as part of Datamart design and report generation from stakeholders.
• Created stored procedures, user defined functions, views to support front end applications.
• Handled errors in SQL utilizing if-else, try-catch, @@error and raiserror () functions.
• Optimized slowly running SQL codes utilizing indexes, partitions SQL Profiler and DTA.
• Implemented Inmon methodology to extract DataMart from existing data warehouse to store Student Insurance details utilizing SSIS packages.
• Maintained ETL strategies while extracting data from different sources such as SQL Server, flat files and Excel.
• Utilized various tasks and transformations such as Execute SQL task, Lookup, Merge, and Union All as part of ETL process.
• Configured checkpoints to start the package from point of failure in SSIS.
• Created OLAP cubes with multiple fact, dimensions, hierarchies, calculations using SSAS.
• Created new calculations and KPI’s such as average time to settle a claim, net profit margin, gross profit margin utilizing multidimensional expressions (MDX) in SSAS.
• Incorporated custom visuals based on business requirements in Power BI desktop.
• Configured on-premises Power BI gateway for refreshing datasets of Power BI reports and dashboards.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Formulated complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel and line better business analysis.
• Published Power BI reports in Power BI service and created dashboards from published reports.
• Utilized recently introduced Power BI to create self-service BI capabilities and used tabular models.
• Deployed TFS (Team Foundation Server) for cross-functional team collaboration for effective sharing and as version control software tool.

Confidential, Dallas, TX

Power BI Report Writer

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

Responsibilities:

• Transformed business requirements to technical and functional requirements through JAD sessions.
• Executed dimensional modeling with ER-win and designed and built relational data mart.
• Enhanced existing stored procedures, functions and triggers as per requirements.
• Modified the performance of queries with modifications to the existing indexes and partitions.
• Designed and modified dynamic SQL batches for performing bulk operations in the OLTP environment.
• Created a DataMart from OLTP systems, flat files and Excel in SSIS.
• Filtered bad data from the legacy system deploying derived columns, lookups, fuzzy lookups, and conditional splits.
• Deployed SSIS packages to test/production environments utilizing parameters in SSISDB Catalog.
• Optimized slowly running SSIS packages by managing buffer sizes and configuring properties.
• Scheduled SQL Server Agent job files to start SSIS package execution and report generation.
• Built Tabular model SSAS cubes with tables, perspectives, hierarchies, calculations and KPIs for analyzing business requirements.
• Created new calculations and KPI such as average life of products, profit margins utilizing DAX in SSAS.
• Identified slowly running reports from execution logs and optimized them utilizing caching and snapshot.
• Created interactive dashboards by extracting data from different sources in Power BI Desktop.
• Scheduled data and cache refresh utilizing data gateways on Power BI services.
• Created hierarchies in Power BI reports using data visualizations like Bar chart, Line chart, pie charts, forecast charts.
• Worked with both live and import data in to Power BI for creating reports.
• Used different type of slicers available in Power BI for creating reports.
• Transformed the visualizations in Power BI reports and dashboards as per client requirements.
• Made use of Team Foundation Server (TFS) for the version control and project co-ordination.

Confidential, Beaverton, OR

BI Developer

Tools: and Environment: SQL Server 2012, T-SQL, SSIS, SSAS, SSRS, SSDT, Erwin, Power Pivot

Responsibilities:

• Participated with the project team to define project requirements in JRD meetings.
• Executed data modeling (Star Schema) with Erwin for the ETL strategy.
• Created multiple constraints such as Primary Keys, check and default in logical phase to maintain integrity of database tables.
• Created database objects such as stored procedures, triggers, indexes, views, and UDFs.
• Developed user defined functions to provide custom functionalities according to the requirements.
• Extracted and loaded data from multiple sources (Excel, CSV, flat files, SQL Server, MySQL) to the staging area.
• Utilized various transformations such as lookup, fuzzy lookup, merge, union all, SCD in SSIS.
• Handled run time errors in SSIS utilizing error redirection, event handlers and precedence constraints during ETL loads.
• Enhanced data source view by adding new dimensions and facts in SSAS as per requirements.
• Optimized SSAS cube utilizing aggregations, user defined hierarchies and appropriate storage modes.
• Identified rendering issues (Excel, PDF, flat files) in SSRS before deploying report to server.
• Delivered reports on daily, weekly and monthly basis utilizing standard and data driven subscriptions.
• Formulated analytical reports/dashboards from multidimensional models to identify critical KPIs utilizing Power Pivot.