Swaroopa Contact: +1-509-***-****

Software Development Engineer Email ID: ad0i0m@r.postjobfree.com

Professional Summary:

●Around 8+ years of experience in developing Power BI reports and dashboards from multiple data sources available to all BI and Datawarehouse applications.

●Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

●Developed POWER BI model used for financial reporting of P & L and Headcount.

●Worked with filters/calculated columns/measures/relationships and transformations of Edit Query section.

●Used Table, Matrix, Bar, Card, Gauge, Slicer’s visualizations.

●Worked on Custom Visualizations like multi slicer and Hierarchy slicer.

●Worked on DAX expressions like Calculated Column and Measure, filters, Aggregate, Mathematical Functions etc.

●Worked on On-Premises Gateway to refresh the data sources/creating a live connection with Tabular SSAS.

●Experience in Using multiple join statements to retrieve data from multiple tables

●Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.

●Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning.

●Experience in MS Business Intelligence tools like SQL Server Integration Services, Reporting Services.

●Created ETL packages using SSIS to move data from various heterogeneous data sources.

●Worked with Financial companies for application related pricing and security applications

●Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

●Expertise in POWER BI, POWER BI Pro, Power BI Mobile.

●Expert in creating and developing POWER BI Dashboards into rich look.

●Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.

●Experience in developing Dashboard Report, Parameterized Reports, linked reports, Sub reports by Region, Year, Quarter, Month and Week.

●Used various sources to pull data into POWER BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.

●Developed Excel Power View, Power Query and PowerPivot dashboards for data analysis

●Skilled in developing complex SQL queries using stored procedures, common table expressions (CTEs) and temporary table to support POWER BI and SSRS reports.

●Expertise in generating on-demand and scheduled reports with SSRS for business analyses and managerial decisions.

●Created SSIS packages to import data from Access, Excel, XML, OLE DB Source and Flat Files.

●Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.

●Excellent analytical & interpersonal skills combined with a willingness to learn new things.

●Experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access.

●Used SQL Azure extensively for database needs in various applications.

●Work with Quality Assurance Team on issue reporting, resolution, and change control.

Technical Skills:

Reporting Tools

Power BI, SSRS, Tableau Desktop

.NET Technologies

ASP.NET, C#.NET, Java Script, IIS

Database Servers

Oracle 11G, MS SQL Server 2012/2016, T-SQL

Cloud Technologies

Microsoft Azure, AWS

Application Servers

IIS 7.0

IDE / Utilities

MS Business Intelligence Development Studio, Visual Studio, MS Visio

Source Control Tools

MS Visual Source Safe (VSS), TFS, Tortoise SVN, GIT

Methodologies

Agile, Waterfall

PROJECT EXPERIENCE:

Client

Infinite Computer solutions Inc, Remote

Duration

Aug 2022 – Sept2023

Role

Software Development Engineer

Responsibilities:

Worked on PowerBI desktop, building reports and dashboards for Balancing agreements, Claims and Contracts data.

Published PBI reports on Powerbi Service Portal and scheduled datasets refresh.

Worked on Power automate for dataset refresh and other Microsoft flows for email attachments.

Worked on Power apps for write back to database functionality and other report tool tips and conditional formatting.

Worked in Production support for SSRS, SSIS packages through Jira tickets.

Worked on Store procedures and query performance and Optimization support.

Worked on Adding new columns in base tables and backfill data from source ODS Database to another DB DataMart’s.

Worked extensively with DAX functions in Powerbi like CALCULATE, SUM, SUMX, ALL, ALLEXCEPT, RELATED, RELATEDTABLE functions.

Experience in using slicers and other tiles and visuals like bar, pie, clustered graphs in the powerbi reports.

Worked on On-Premises Gateway to refresh the data sources/creating a live connection.

Worked on Other Data connections like SharePoint Files and azure data bricks data.

Worked on ADF pipelines to load data from source to other Target Databases and jobs monitoring.

Well versed in using user defined aggregations and data modelling concepts.

Experienced working with different sources like Oracle, SQL server and azure data bricks.

Environment: Power BI, Power view, SQL Server 2008/2016, Visual Studio 2017, 2019 SSDT, SSIS, SSRS, SSAS, T-SQL, Azure SQL

PROJECT EXPERIENCE:

Client

Fiserv, Chicago

Duration

Aug 2020 – Aug 2022

Role

Sr Power BI/MSBI/SSAS/SSRS Developer

Responsibilities:

●Designed and developed SSIS packages for extracting data from multiple data sources and loading data into destination tables.

●Expert in removing the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS.

●Used Microsoft flow -power automate for refreshing Powerbi datasets and email attachments.

●Established error handling techniques such as try catch and error functions for creating a robust T-SQL code.

●Implemented Row level Security as part of security in Power BI.

●Created SSIS packages to extract data from OLTP and SQL server systems and Scheduled Jobs to call the packages and Stored Procedures.

●Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2012.

●Enhanced end-user interaction with data by enabling mobile capability in Tableau Online.

●Created complex SSAS cubes with fact measures groups and multiple dimension hierarchies.

●Created a multitude of reports and dashboards with SSRS and Power BI

●Wrote calculated columns, measured queries in Power BI desktop to show good data analysis techniques.

●Developed Reports using efficient data retrieval techniques Designed different types of reports like drill down, drill through, sub reports, parameterized reports, and cascading reports in SSRS 2008R2/2012.

●Created Parameterized Report, Dashboard Report, linked report and SubReport by Year, Quarter, Month, and Week.

●Worked on all types of transformations that are available in Power BI query editor

●Created Reports using Charts, Gauges, Tables, matrix.

●Experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access.

●Used SQL Azure extensively for database needs in various applications.

●Work with Quality Assurance Team on issue reporting, resolution, and change control.

Environment: Power BI, Power view, SQL Server 2008/2016, Visual Studio 2015, SSDT, SSIS, SSRS, SSAS, T-SQL, Azure SQL

PROJECT EXPERIENCE:

Client

American Express, Phoenix, Arizona

Duration

Dec 2019 – July2020

Role

Sr Power BI/MSBI/SSAS/SSRS Developer

Responsibilities:

●Designed and developed SSIS packages for extracting data from multiple data sources and loading data into destination tables.

●Expert in removing the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS.

●Automated Power Query refresh using power shell script and windows task scheduler.

●Work in Ad-Hoc request for Payer to parse SOE number from each Auth request.

●Established error handling techniques such as try catch and error functions for creating a robust T-SQL code.

●Implemented Row level Security as part of security in Power BI.

●Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.

●Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2012.

●Enhanced end-user interaction with data by enabling mobile capability in Tableau Online.

●Created complex SSAS cubes with fact measures groups and multiple dimension hierarchies.

●Created a multitude of reports and dashboards with SSRS and Power BI

●Wrote calculated columns, measured queries in Power BI desktop to show good data analysis techniques.

●Developed Reports using efficient data retrieval techniques Designed different types of reports like drill down, drill through, sub reports, parameterized reports, and cascading reports in SSRS 2008R2/2012.

●Created Parameterized Report, Dashboard Report, linked report and SubReport by Year, Quarter, Month, and Week.

●Worked on all types of transformations that are available in Power BI query editor

●Created Reports using Charts, Gauges, Tables, matrix.

●Experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access.

●Used SQL Azure extensively for database needs in various applications.

●Work with Quality Assurance Team on issue reporting, resolution, and change control.

Environment: Power BI, Power view, SQL Server 2008/2016, Visual Studio 2015, SSDT, SSIS, SSRS, SSAS, T-SQL, Azure SQL

PROJECT EXPERIENCE:

Client

Merck & Co, Madison – NJ

Duration

Oct 2017 – Nov 2019

Role

Sr Power BI/MSBI/SSAS/SSRS Developer

Responsibilities:

•Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc Reports, and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

•Worked on Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.

•Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow tasks and data flow transformation.

•Scheduled Automatic refresh and scheduling refresh in Power BI service.

•Designed and created data extracts, supporting SSRS, Power BI, Tableau, or other visualization tools reporting applications.

•Creating data blending in case of merging two different datasets using Tableau

•Worked extensively with CALCULATE, SUM, SUMX, ALL, ALLEXCEPT, RELATED, RELATEDTABLE functions.

•Maintained security of the dashboards in Power BI Service through content packs

•Created cached reports and snapshots and scheduled the delivery through emails.

•Incorporated error redirection during ETL loads in SSIS Packages.

•Implemented slowly changing transformations with SSIS to maintain historical data in the data mart.

•Participated in creating ad hoc analysis and reporting requests in a timely manner with Excel Power Pivot/View.

•Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.

•Created Drill Down Reports, Drill Through Report by Region.

•Created stored procedures and SQL queries to pull data into power pivot model.

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

PROJECT EXPERIENCE:

Client

Allstate, IL

Duration

Nov 2015 – Sep 2017

Role

MSBI Developer

Responsibilities:

Worked on design and development of a data warehouse solution to satisfy the Business Intelligence reporting environment for Actuarial Valuation & Analysis (AVA) Team.

An end-to-end application development and support project involving enhancement, requirements elaboration, design, build, testing, and implementation using C#, ASP.NET 2.0, VB.net, DTS and SSIS 2008.

Migration/Upgrade of SSIS packages to higher versions.

SSRS report deployments to SharePoint 2010 custom libraries and involved in

maintaining SharePoint site security.

Developed SSRS reports for the business in Agile project environment.

Optimize SSIS packages and reduce redundancy of code in script components.

Implement Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Used Power query to Merge and shape data sources to match data analysis

requirements or prepare it for further analysis and modeling by tools such as Power

Pivot and Power View.

Creation & Migration of various DB Objects like Tables, Primary Keys, Foreign Keys,

Indexes, Stored Procedures, functions across multiple environments

Analyze complex issues, distilling and communicating their relevant aspects.

Understand the client and project requirements (both functional and non-functional) by studying the existing documentation and assimilating inputs from SMEs and seeking clarifications, if any, to participate efficiently in the Development and Testing phases of the project.

Experience in Designing and Data modeling logical/Physical Designs using ERWIN, Database Diagrams etc. and Reverse/Forward engineer the data models

Create program specifications and unit test plans for software programs by studying functional and non-functional requirements and the application architecture document and converting the assigned functionalities into pseudo code/algorithms/test cases.

Environment: MS Office Suite 2003/2007, CSS, HTML 5, JavaScript, SQL Server 2008, ASP.NET 2.0,C#, VB.Net, jQuery, Windows Vista/XP,SSIS 2008,Oracle 9g, SVN

PROJECT EXPERIENCE:

Client

ICICI Bank, India

Duration

May 2014 – Jan2015

Role

MSBI/SSAS/SSRS Developer

Responsibilities:

●Writing TSQL, PL/SQL, stored procedures, functions and complex queries for migrating legacy Oracle 10g to SQL Server 2008.

●Experience working in multiple projects both OLTP and OLAP (Data warehouse) databases.

●Designed and developed SSRS reports exactly like the Crystal Reports (Migration of Crystal Reports to SSRS Reports).

●Created complex Stored Procedures, SSIS Packages, Triggers, Cursors, Tables, and Views and other SQL JOINs and statements for applications.

●Designed and developed SSIS (ETL) packages for Data Extraction, Transforming and Loading the data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).

●Migrating SSIS packages from SQL Server 2008 version to SQL Server 2012 version.

●Experience in implementing Event Handlers, Checkpoints and Logging to maintain active SSIS packages.

●Automating the SSIS packages execution through SQL Mail Agent jobs, scheduling the jobs adding notifications for success and failure.

●Designed and Developed Drill-through, Drill-down, Cross Tab (Matrix) Reports and Sub-Report using SSRS.

●Applying optimization techniques to improve the performance of the queries and taking care of performance issues across TSQL, SSIS and SSRS reports.

●Optimized the performance of queries by Data Manipulations which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.

●Performed Unit Testing for migrated procedures, functions and RDLs.

●Implemented the Best Practices and Coding Standards for SQL Server, SSIS & SSRS.

●Experienced working in Development, Testing and Production servers.

Environment: MS SQL Server 2008/2012, Oracle, MS SQL Server Reporting Services, SQL Server Integration services, ETL, Data Modeling, T-SQL, SQL Profiler, XML, MS Access, Excel

Contact this candidate