SUMMARY

• Over 7+ years of strong experience in the IT industry as a MS Power Bi / MSBI include experience in design, development, implementation and administration of database systems using MS - SQL Server 2014/2012/2008 R2/2008 for both OLTP & Data Warehousing Systems applications with various business domains.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.
• Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL
• Expert in developing T-SQL/PL-SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues.
• Extensive experience with all phases of Software Development Life Cycle in different environments like Healthcare, Banking, Insurance, and Information Technology.
• Application knowledge in software development life cycle (SDLC), Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Well versed in Using MDX (Multi-Dimensional Expressions) Queries to retrieve data from Multi-dimensional SSAS Cubes.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets forPowerBIand Ad-hoc Reports.
• Expert on creating multiple kind ofPowerBIReports and Dashboards.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Experienced on creating multiple kind of Report inPowerBIand present it using Story Points.
• Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI andSSAS.
• Migrate existing data into thePowerBI.
• Extensive experience in designing, developing, and delivering business intelligence solutions using PowerBI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX)
• UsedDAX(Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Created complexDAXcalculations in PowerBI, created data models and implemented one to many relationships.
• Experienced in using SSRS, creating well-formed reports and web-based reports for financial applications and transactions.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in report generation usingServer Reporting Services (SSRS) from relational databases and OLAP cubes.
• Deploying and scheduling reports using SSRSto generate all daily, weekly, and monthly and Quarterly Reports including status.
• Created user defined functions in SSRS using VB script.
• Worked on creating multiple SSRS reports in Drill-through mode and Cross Tab Reports
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Created several reports using SSRS like parameterized report, drill through reports, linked and sub reports.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
• Hands on experience in designing and implementing SharePoint Visual web parts, web parts, Timer jobs, Sand boxed solutions, Event handlers, custom workflows, site definitions, site templates, custom master pages, custom page layouts, content types, dashboards, site columns, lists, libraries, variations and Content Hubs.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.

TECHNICAL SKILLS

Databases: SQL Server 2014/2 R2/2005, Oracle 8i/9i/10g/11g,12c, MYSQL

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio (BIDS), SQL CMD.

Languages: T-SQL, MDX, Java, Swift, Android, AJAX, JSON, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA

OLAP: SQL Server Reporting Services (SSRS), SSAS, SSIS, Crystal Reports 9.0/8.5, OLAP, Erwin, Tableau, Power BI.

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003/2008/2012, Windows …, Unix, Linux, Ubuntu, Mac OS … .

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

PowerBI Developer

Responsibilities:

• Participate in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Designed and implementedSSASTabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Designed and implemented Row Level Security & Roles forSSASTabular Model. And deployed into SQL SERVER ANALYSIS SERVER 2016.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models
• Setting up PowerBI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.
• Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
• Created Dashboard and the App Workspace for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
• Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.
• Used One Drive for storing different versions of Power BI report.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI andSSAS

Environment: MS SQL Server 2016, MS SQL Server Analysis Services (SSAS), EDW, Yardi, PowerBI Desktop, PowerBI Service, Data Gateway, DAX, T SQL, SQL Profiler, XML, MS Excel, Windows 8, DAX Studio, M Query.

Confidential, Chicago, IL

PowerBI Developer

Responsibilities:

• Participate in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Developed and Published dynamic and complex Financial and Sales Reports in PowerBI.
• Used DAX to create complex measure and calculated columns.
• Setting up PowerBI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2, Salesforce and Intacct.
• Created many calculated columns and measures using DAX inPowerBIbased on report requirements.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQLqueries, stored procedures and SSIS packages to load the data into warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.

Environment: MS SQL Server 2008R2, MS SQL Server Integration Services (SSIS), Salesforce, Intacct, PowerBI Desktop, PowerBI Service, Data Gateway, DAX, T SQL, SQL Profiler, XML, MS Excel, Excess, Windows 8.

Confidential, Bloomington, IL

SQL/SSIS/SSRS/SSAS/POWER BI Developer

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL, SSAS and Excel and gives PPT presentation near client for this on a daily basis.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Create and manage Reports subscriptions and schedules SSRS reports.
• Designing and implementing a variety of SSRSreports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R 2/2012/2014/2016.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Created many calculated columns and measures using DAX inPowerBIbased on report requirements.
• Involved in Tabular Data Warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQLqueries, stored procedures and SSIS packages to load the data into warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created several cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes and good experience in SSAS.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, PL SQL,DAX, OLAP and OLTP.
• Developed impactful reports using SSRS, MS Excel, Pivot tables and Tableau to solve the business requirements.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.

Environment: MS SQL Server 2014/2012/2008 R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), DAX, Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel, Excess, Windows 8.

Confidential, Elizabeth Town, KY

SQL BI(SSIS/SSAS/SSRS) Developer

Responsibilities:

• Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool.
• Maintained all the SQL documents including installation and data conversion Procedure documents.
• Developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data Warehouse.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Complex business requirements were transformed into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS 2012.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Creating multi-dimensional cubes using SSAS and designing DW schemas.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
• Created Calculated Measures and Key Performance Indicators in SSAS using MDX.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Good Knowledge in writing/Designing the Excel Macros to for data retrieval from SQL/ SSAS sources using VBA.
• Creating and maintaining/modifying T-SQLqueries, tables, views, stored procedures and functions that are required for front end business logic and report generation.
• Experienced in reviewing many T-SQLissues using management studio for better performance and working on performance tuning for slow running queries using Profiler.
• Deployed the SSIS Packages to the MSDB as well as File System based on the requirements.
• Designed ETL Packages with Microsoft SSIS 2012 to pull data from various sources like DB2, SQL Server, Teradata, Flat Files and other systems to individual Data marts which ultimately go into Enterprise Data Warehouse (EDW).
• Involved in the development of custom SQL, T-SQL, custom stored procedures, functions, and triggers.
• Created Teradata External loader connections such as Upset and Update, Fast load while loading data into the target tables in Teradata Database.
• Worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients.
• Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages to run sequentially using SQL Server Agent job and windows Scheduler.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2008R2.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008R2.
• Used breaks, calculations, sorts, filters, and sections to enhance data presentation in reports.
• ETL process was documented for future references.

Environment: SQL Server 2014/2012/2008 R2 Enterprise Edition, .NET Framework, XML, T-SQL, SSIS, SSRS, SSAS, DAX, VisualStudio.NET IDE, Agile, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access, Visual Studio.

Confidential, High Point, NC

SQL BI Developer

Responsibilities:

• Gathered report requirements and determined the best solution to provide the results in a Reporting Services.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Installed and configure servers and clients using SQL Server 2012, Upgraded SQL databases.
• Query optimizations (T-SQL or Query Analyzer) using query analyzer and Index tuning wizards.
• Developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data Warehouse.
• Developed ETL solutions inAlteryxand SSRS.
• Worked on writing queries to source and load the data to SQL Server and Oracle databases usingAlteryxand SSIS.
• Trouble shooting and resolving close week issues in the reports. These vary from identifying missed data, updatingDAXfunctions and modifying SSIS packages.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Created SSIS Packages which contained different transformations and tasks.
• Troubleshoot SSIS Packages and convert to SSRS Reports.
• Design, deployment, and maintenance of various SSRSReports in SQL Server 2012/2008.
• Developed SSIS packages using various transformations such as Conditional Splits, Fuzzy Look Ups, Aggregations, and Multicasting.
• Actively involved in developing Complex SSRSReports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Created packages in SQL Server Integration services which import the data from share point to reporting server database using connection strings.
• Developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data Warehouse.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Involved in monitoring and tuning report performance by analyzing the execution plan of the reports.
• Extensively involved in using Formula fields, parameter Fields, Group Selection, and Record Selection in Crystal Reports.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact, and Dimensions Tables using MS Analysis Services.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Developed web pages for embedding deployed SSRS reports using ASP.NET.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Knowledge of Database Performance monitoring tools
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created ETL SSIS packages both design and code to process data to target databases
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database

Environment: MS SQL Server 2012/2008R2/2008, MS SQL Server reporting services (SSRS), Integration Services (SSIS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server.