PROFESSIONAL SUMMARY:

• Over 8 years of IT Experience in Database Design, Development, and business intelligence of Microsoft SQL Server 2016/2014/2012/2008 R2in Development, Test and Production Environments with various business domains.
• Experience in complete MSBI Stack including data analysis, database design, data mapping and conversion and data load with SSIS, SSAS and SSRS.
• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Developed PL/SQL Triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored Procedures, Functions and Packages for moving the data from staging area to data mart.
• Good knowledge on Database Administration operations like Backup, Restore and excellent knowledge in Transact - SQL (DDL, DML, DCL).
• Created data base on Microsoft Azure, setting up connection strings and connecting SQL server AZURE databases from locally installed SQL Server Management Studio(SSMS) for developers
• Experienced in redesigining and successfully migrating applications to new platforms.
• Hands on experience in implementing complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server by Play Now Radio">Analysis Services (SSAS) and Reporting solutions using Microsoft by Play Now Radio">SQL Server Reporting Services (SSRS).
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform Drill through and drill down operations in SSRS.
• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, tablix).
• Created and scheduled subscriptions for the reports using SSRS 2008/2012.
• Created SharePoint sites, lists, libraries, imported several spreadsheets to SharePoint lists
• Extracted, transformed, and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema.
• Experienced in providing 24X7 production support for critical ETL processes and strategic financial reports.
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.
• Conversant with all phase of Software Development Life Cycle (SDLC).
• Good Experience working and implementing processes in different bussiness domains like Finance and Mortgages.

TECHNICAL SKILLS:

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Crystal Reports, Power BI, Tableau

Relational Databases: SQL Server 2016/2014/2012/2008 R2/2005, MS Access, SQL Server Azure

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS

Ticketing Tools: Incident Management (ICM)

Other Tools: Microsoft Office 2003/2007/2010 and 2013, Powerpoint.

Data Modeling Tools: Microsoft Visio 2003/2007/2010, Erwin and Power Builder.

SQL Server Tools: SQL server Management Studio, Microsoft Visual Studio 2010/2013/2015

Programming languages: C,SQL,PL/SQL,T-SQL,.NET,C#

Data Modeling: Physical and Logical Data Modeling

Data Warehousing & BI: Star Schema, Snowflake schema, Facts and Dimensions tables

Operating Systems: Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers

PROFESSIONAL EXPERIENCE:

Confidential

POWER BI DEVELOPER

Responsibilities:

• Created and maintained interactive Power BI reports/dashboards based up on business requirement.
• Worked directly with Product Owners/Customers in a day-day basis to deliver various data products like Dataflows, Reports, Dashboards,Datesets in an Agile environment.
• Used various sources to pull data intoPower BI such as Azure SQL data warehouse, Sql Server, SAP BW, ODBC, Excel, Amazon Redshift, Oracle Database.
• Created Workspace and content packs for business users to view the developed reports.
• Designed and created paginated reports using Power BI Report Builder.
• Migrated various Legacy Reports/Tableau reports into Power BI.
• Integrated Custom Visuals based on business requirements using Power BI desktop using R and Python.
• Created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
• Used Power BI Desktop to analysis multiple data sources to visualize the reports.
• Developed complex calculated measures /Custom Columns using Data Analysis Expression language (DAX).
• Extensively worked on large datasets in Power BI by using various techniques like Incremental Refreshes and Query Folding techniques.
• Used Power Platform(Power BI, PowerApps, PowerAutomate) to create end-end soutions.
• Implemented row level security to define roles and rules in Power BI Desktop to restrict access based on regions.
• Created applications using PowerApps and embeded it in Power BI reports.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2010, MS Office, Windows 10, Power Platform (Power BI, Power Apps, Power Automate),Palantir Cloud Suite.

Confidential

APPLICATION SUPPORT ENGINEER.

Responsibilities:

• Creating Power BI reports and Dashboards based on the requirement of the client.
• Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
• Created and maintained the data sources in On Premises Gateway to schedule refreshes in Power BI.
• Involved in troubleshooting, resolving, and escalating Power BI issues.
• Created monthly reports in Power BI based on the tickets for reducing the issue count in the future.
• Providing 24X7 production support for critical ETL processes and strategic financial reports.
• Created new database objects like procedure, functions, packages, triggers and views using T-SQL in development production environment for SQL server.
• Scheduling theSSISpackages to run as jobs on periodic basis according to the requirement using SQLServer Agent.
• Creating complex T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation
• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI reports.
• Used Incident Management (ICM) to create tickets for various productivity issues to ensure transparency and prioritize work flow.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), Informatica, SQL Server Analysis Services (SSAS), Visual Studio 2010, MS Office, Windows 8, Power BI Desktop/Service.

Confidential

MSBI DEVELOPER

Responsibilities:

• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including Tables, Clusters, Indexes, Views, Sequences Packages and Procedures.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation, and allocation routines for delivering the desired KPI’s in the Cubes.
• Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.
• Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations.

Environment: MS SQL Server 2008R2/2012/2014, Oracle 9i/10g/11g, SSIS, SSRS, Management Studio, Visual Studio,DTS, Windows 7,MS Office 2010/2013,Windows Server 2008, and Windows Server 2008 R2,Visio 2010/2013,Power BI Desktop, Power BI Service.

Confidential

SQL/ BI DEVELOPER

Responsibilities:

• Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development, and testing
• Worked extensively in writing and debugging complex stored procedures, views, triggers, and user-defined functions
• Designed the Data warehouse and done the mappings from Source to the Target tables
• Worked extensively on SSIS packages to implement the data load strategy
• Involved in designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access, and CSV files to data warehouse
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2008R2 Analysis Services
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008R2
• Generated multi parameterized reports in MS SSRS 2008R2 allowing users the ability to make selections before executing reports; thus, making them user friendly
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS
• Worked on several complex drilldowns, parameterized reports and on reports that call sub reports using SSRS
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Automated and executed Office 365 procedures utilizing Windows PowerShell.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs

Environment: MS SQL Server 2008R2, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio(BIDS), SSDT, SQL Server Query Analyzer, ETL.