PROFESSIONAL SUMMARY:

• Microsoft Business Intelligence Developer with experience in developing Business Intelligence solutions. Strong troubleshooting and problem - solving skills. Strong ability to prioritize multiple tasks with excellent communication skills for management and end users. Proactive, fast learner, self-managing, and teamwork spirit.
• Strong experience in using Microsoft BI Stack (SQL, SSIS, SSRS, SSAS and Power BI). Worked with SQL Server 2012/2014/2016.
• Experienced in Microsoft Power BI, Power BI Pro, Power Query, Power Pivot, Power BI Service, Power BI Desktop, Microsoft Excel Pivot Table, and data models to gather information from multiple sources and deliver information to the end user.
• Proficiency with DAX skills and the ability to create and troubleshoot complex calculations and measures.
• Experienced with using Microsoft Power BI for the creation of dashboards, standard reports and ad-hoc reports.
• Excellent back-end skills in creating SQL objects such as Tables, Complex Stored Procedures, User- defined Functions, Views, Indexes, Triggers, Joining, system function.
• Experienced in SQL Performance Tuning to optimize slow running queries.
• Experienced in creating complex (SSIS) packages for ETL purposes. Performed data migration from various type of sources (Excel, Flat File, CSV, XML, OLTP DB, etc.), Data Conversions, Data Extraction/Transformation/Loading (ETL) using SSIS and SQL scripts.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Experienced in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
• Experienced in designing and developing a considerable number of reports in SSRS using the data from ETL Loads.
• Proficient in developing Drill-through and Drill-down reports, Parameterized reports, linked reports, sub reports, Matrix reports, and Chart reports using SQL Server Reporting Services (SSRS)
• Experienced in SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery, and Report security.
• Proficient knowledge in data marts, Operational Data Store (ODS), Star Schema modeling, and Snowflake modeling for Fact and Dimension tables.

TECHNICAL SKILLS:

Platforms: Windows (8, 10), MS SQL Server 2012/2014/2016.

Languages: DAX, T-SQL

Applications / BI Tools: SQL Server Integration (SSIS), SQL Server Reporting (SSRS), Power BI, SQL Server Analysis (SSAS), SQL Server Business Intelligence Visual Studio, SQL SERVER, SQL Profile, Query Optimizer

Healthcare, Mortgage, Sales, Transportation, Consumer Product Retail & Distribution

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, Illinois

Data Engineer-Power BI Developer

Responsibilities:

• Provided End-to-End solutions in Power BI from Report Development to Workspaces and App management, to Report Governance.
• Published developed reports to Power BI Service (Cloud).
• Migrated various reports built in (SSRS, Excel, Charito) to Power BI.
• Modeled data using DAX, Power Query according to business requirements.
• Management of access and troubleshooting of reports for resolution of issues.
• f senior level executives on self-service BI and creation reports.
• Versioning and Documentation and Knowledge transfer of all work to various Juice Plus project owners.
• Daily progress updates during standup meetings.
• Plan and Track the Work by Creating Work Items in Azure Board (Azure DevOps).
• Troubleshoot and created complex calculations using DAX.
• Developed Proof of Concepts (POC) for various projects using Power BI.
• Developed business logic using DAX to provide custom functionality inPower BIApplications.
• Scheduled refreshes through the Power BI gateway to refresh Dashboard at regular intervals and appropriate dependencies.

Confidential, Dallas, TX

Power BI Developer

Responsibilities:

• Provided End-to-End solutions in Power BI from Report Development to Workspaces and App management, to Report Governance.
• Published developed reports to Power BI Service (Cloud).
• Migrated various reports built in SSRS to Power BI.
• Modeled data using DAX, Power Query according to business requirements.
• Management of access and troubleshooting of reports for resolution of issues.
• f senior level executives on self-service BI and creation reports.
• Versioning and Documentation and Knowledge transfer of all work to various Juice Plus project owners.
• Daily progress updates during standup meetings.
• Troubleshoot and created complex calculations using DAX.
• Developed Proof of Concepts (POC) for various projects using Power BI.
• Developed business logic using DAX to provide custom functionality inPower BIApplications.
• Scheduled refreshes through the Power BI gateway to refresh Dashboard at regular intervals and appropriate dependencies.
• Implemented after insert, update and delete triggers to simultaneously populate multiple tables at once.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQLcode andSQLjoins for applications followingSQLcode standards.
• Created SSIS packages to extract the data from multiple sources like Excel, XML and OLTP and consolidate them into staging tables.
• Clean and transformed data from staging tables base on business requirements using various transformation and load them into a data warehouse.
• Maintained SSIS packages for production and test environment for incoming source application files.
• Scheduling Jobs and Alerting usingSQLServer Agent.
• Worked onSSISperformance tuning using counters, error handling, event handling, re-running of failedSSISpackages using checkpoints.
• Worked on Tabular Modeling Development & Multidimensional Modelling Development using SSDT.
• Built Measures in tabular model using DAX queries and created partitions in tabular model.
• Built KPIs in tabular based on the end user requirements, worked on Performance of SSAS tabular model.
• Processed and deployed tabular model and cubes to SSAS database.

Environment: SQL, SSIS, SSRS, Power BI, Excel, Flat files, XML, Visual Studio 2017, SQL Server 2014/2016.

Confidential

BI Developer

Responsibilities:

• Design and create an ETL solution to consolidate mortgage loan applications received from various sources. Numerous reports were also created to meet the client’s need.
• Work on all activities related to the development, implementation, administration, and support of ETL processes.
• Produce dashboards, Tabular and Matrix reports, charts, graphs, and gauges as per customer requirements using SSRS.
• Create of various Business Intelligence/ Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures using complex DAX calculation and transformations using Query Editor and Power Query Formula Language.
• Used SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse databases and use advanced SSIS tools (Derived Columns, Conditional Split, Look-up Transformation, Aggregations, Multicasting).
• Develop and modify coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis and tune SQL source queries for data load/usage of Stored Procedures for optimized performance.
• Enhance performance using optimization techniques - normalization and indexing, and performance tuning of queries and Stored Procedures. Also use Performance Tuning on existing ETL packages.
• Design various SSRS reports as requested by the client and created and developed Sub-Reports, Drill-down reports, Drill-through reports, Parameterized reports, and Matrix reports using SSRS.
• Use Trend Lines Statistics, Group Hierarchies, and Time Intelligence to create detailed and summary level reports and Dashboards with KPIs using Power BI.
• Help capture data modeling requirements using SQL queries that pulled data from multiple SQL Server databases using Power Query.
• Have created and managed app workspaces and collaborated with other Developers on creating complex reports and Dashboards.
• Implemented Power BI interactive dashboards-style reports utilizing slicer filters, Drill-down hierarchies, Drill through within or to another report.
• Rendered reports in different formats like PDF, Excel, etc. Scheduled to be executed automatically on a weekly or monthly basis and managed subscriptions.
• Applied security to reports on Item and Folder level and used Triggers, Linked servers, Dynamic coding, and Job processing.