SUMMARY

• Overall 11+ years of IT experience in Database Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2014/2012/2008 with various business domains like Healthcare, Banking, Insurance Sector and Transportation.
• 3+ Years of extensive Experience in Microsoft Power BI
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expertise in writing T - SQL Queries using joins, Sub queries and Cursors in MS SQL Server 2008/2012/2014.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Monitoring and Tuning MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in managing and automating control flow, data flow, events and logging pro grammatically using Microsoft .NET framework for SSIS packages.
• Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split techniques.
• Extensive experience in developing reports and deploying reports in SSRS using Report Wizard, Report Builder and Report Manager.
• Experience in designing stylish report layouts including Tabular forms, Matrix (Cross /tab Report) form, ad-hoc, Conditional, Drill down, parameter, cascading parameters, Charts and Sub Reports.
• Experience in enhancing and deploying the SSRS Packages.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Support Experience in Microsoft Team Foundation Server (TFS) to allow for a secure code, SSIS Packages and Reports and use as a repository to compare modified and unmodified code.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Strong leadership, interpersonal, communication, and project management skills.
• Strong troubleshooting and problem-solving experience in a complex environment.
• Proven ability to work in both independent and team environments.
• Experience in developing, maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI
• Expert knowledge connecting Microsoft Power BI Desktop to various data sources. SQL Server, Azure DB.
• Expert knowledge creating DAX calculations in Power BI Desktop.
• Experience in creating dashboards, volume reports, operating summaries and presentations and graphs.
• Responsible for creating SQL dataset for Power BI and Ad-hoc Reports.
• Created, Maintained & refresh schedules for various reports in Power BI workspace and report server.
• Experience creating different visualizations using Slicers, Line, Pie, Histogram, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
• Work on Power BI modeling.
• Created custom columns, custom measures as per the User requirements. Also worked various customization in the report/Dashboard Vs Golden Copy.

TECHNICAL SKILLS

Database Management System: MS SQL SERVER 2016/ 2014/2012/2008 R2/2008, DB2, Oracle

Database Utilities: SQL Enterprises Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio.

Data Modeling Tools: ERWIN 7.3, Model Right 4.0

ETL Tools: SQL Server integration services (SSIS), BIDS.

Integration Services (SSIS): Import export data, Bulk insert, BCP

Reporting Tools: MS SQL Server Reporting Services, Power BI

Programming Language: TSQL, SQL, HTML and XML

Operating Systems: Windows 10

PROFESSIONAL EXPERIENCE

Confidential

BI developer

Responsibilities:

• Interacted with business users for understanding and gathering business requirements and involved in project planning, scheduling the database module with project managers.
• Creating Data Points for use by Decision engine using T-SQL, Stored Procedures and Functions.
• Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Developed Report Models for building customized Ad hoc reports. Played a Content Manager role on report server.
• Monitoring SQL server performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.
• Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Monitoring and scheduling daily, weekly and monthly SQL Server jobs and debug any issues related with failed jobs or data discrepancy.
• Monitoring SQL Error Logs, Scheduling Tasks, Database Activity, Eliminating Blocking and Deadlocks.
• Responsible for Query optimization and Performance tuning.
• Created SSIS packages to extract, transform and load data into the data warehouse on daily basis.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Identified the Data Source and defined them to build the Data Source Views.
• Created and scheduled SQL jobs to run SSIS packages daily.
• Created SSIS Packages for Incremental loading and slowly changing dimensions.
• Good experience in using different transformations like data Conversions, lookups, derived column transformations, for data cleaning to remove unnecessary columns, inconsistent data and unnecessary data like removing empty rows using SSIS.
• Created DTS (SSIS) packages to get data from various sources.
• Embedded Power BI reports on portal page and also managed access of reports and data for individual users using Roles
• Designed and implemented Dimensions and Measures according to business requirement. And loading data into Dimension Tables in SQL Server using SSIS Packages.
• Participated in development of OLAP cubes. Designed Star Schema, Snowflake Schema and Fact Less Fact tables.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Utilized Power BI desktop to design real time dashboards and scorecards for analytical decision.
• Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Published reports and dashboards designed in Power BI utilizing Power BI services and shared it across through Microsoft Office 365.

Environment: MS SQL Server 2016, Microsoft Visual Studio 2019, SSIS, SSRS, SharePoint, Power BI.

Confidential

MSBI developer

Responsibilities:

• Gathered requirements and designed technical document to implement the application.
• Designed and Developed data model using Model Right.
• Participate in project scope discussions and business requirements meetings
• Develop Stored Procedures, Views and used them for reporting in SSRS as per business requirements.
• Created SSIS packages to transfer data from SQL server using different SSIS components and used configuration files and variables for production deployment.
• Developed SSIS packages to perform Data loads from various types of sources files (Excel, Access, CSVS).
• Involved in daily loads (Full & Incremental) in to staging and ODs areas, troubleshooting process issues and errors.
• Created Several staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to Staging area and finally transfer into data marts.
• Implemented serval DAX functions for various fact calculations for efficient data visualizations
• Utilized Power BI to design multiple dashboards to display information required by different departments and higher-level management.
• Developed Power BI reports by creating calculated columns, conditional columns, measures as per the logic provided by the users.
• Developed a custom dashboard for the displaying high level data by integrating multiple slicers on a single page.
• Developed custom slicers to always show current month, previous month by default without refreshing the report.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint server as per business requirements.
• Design and develop basic to complex canned reports using SQL Server Reporting Services (SSRS).
• Created Cascaded Parameterized report, drill down and drill through reports.
• Used various types of report layout options like chart (bar, line, pie etc.), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Created new reports from the scratch for new requirements and modified some of the existing reports using SSRS.
• Provided documentation of reports and the development process in order to support the system.
• Developed Reporting Structures and Reports within SSRS.
• Update Requirements Documentation and assist with any updates discovered during the report implementation and UAT.

Environment: MS SQL Server 2016/2012/2008/2008 R2 (SSMS), T-SQL, Visual Studio 2019, TFS, Business Intelligence Development Studio (BIDS), Oracle 11g,10g, SSIS, SSRS, SSAS, OLAP, Excel, SharePoint, Power pivot, Power BI, DAX.

Confidential

MSBI Developer

Responsibilities:

• Created SSIS packages to extract, transform and load data into the data warehouse on daily basis.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Executed the DTSX Packages by using DT Exec Command.
• Created database objects on appropriate File groups to ease maintenance and improve data access performance.
• Developed SSIS packages to automate different FTP’s files and emailing to different clients.
• Identified the Data Source and defined them to build the Data Source Views.
• Created and scheduled SQL jobs to run SSIS packages daily.
• Created SSIS Packages for Incremental loading and slowly changing dimensions.
• Good experience in using different transformations like data Conversions, lookups, derived column transformations, for data cleaning to remove unnecessary columns, inconsistent data and unnecessary data like removing empty rows using SSIS.
• Created DTS (SSIS) packages to get data from various sources.
• Good at Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Designed and implemented Dimensions and Measures according to business requirement. And loading data into Dimension Tables in SQL Server using SSIS Packages.
• Participated in development of OLAP cubes. Designed Star Schema, Snowflake Schema and Fact Less Fact tables.
• Involved in assisting Business analysts in developing, maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Utilized Power BI desktop to design real time dashboards and scorecards for analytical decision.
• Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Published reports and dashboards designed in Power BI utilizing Power BI services and shared it across through Microsoft Office 365.
• Implemented dashboards and scorecards with Power BI for executive management for data insights as per business requirements.

Environment: MS SQL Server 2008,2008R2 and 2012, T-SQL, SSRS, SSIS Packages, ETL, Power pivot, Power view, Power BI, Excel, DAX, Power BI.

Confidential

MSBI Developer

Responsibilities:

• Working with different business users to adopt the data visualization - Power BI in the Organization and get insights from the data.
• Work with the technical Team to gain a good understanding of the database models used for reporting.
• Designed and Developed SSIS Packages to import data from Oracle database in the form of flat files transform and load data into SQL Server database.
• Worked on several transformations in Data Flow including Derived-Column, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more.
• Worked on Transformation of Data into SQL Server database by development of views, staging tables and loading data into tables using Stored Procedures.
• Upgraded SSIS packages for an entire Application from 2008 to 2012 using Project wizard and successfully deployed packages.
• Managed the complete migration of SQL Server 2008R2 to SQL Server 2012.
• Used Automated Processing Environment (APE) Application for Automating daily SQL jobs and for execution of packages automatically.
• Developed Package labels for test and production environments and execution of SSIS packages automatically.
• Provided organizational reporting and timely reports utilizing SSRS (SQL Server Reporting Services)
• Used SSRS for development of reports for Business users
• Developed different types of reports - Parameterized reports, Drill down reports, Ad- hoc reports, Snapshot reports and Sub reports.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and enabled capability to send excel file as an email attachment
• Developed several database structures, complex SQL queries, stored procedures, views, triggers and user-defined functions.
• Worked as Support team member for Microsoft Team Foundation Server (TFS) to allow for a secure code, SSIS Packages and Reports and use as a repository to compare modified and unmodified code.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Designed and implemented Dimensions and Measures according to business requirement. And loading data into Dimension Tables in SQL Server using SSIS Packages.
• Participated in development of OLAP cubes. Designed Star Schema, Snowflake Schema and Factless Fact tables.

Environment: MS SQL Server 2008/2012, SSIS, OLAP, SSRS, MS Visual Studio 2005, Windows, Power pivot, Power view, Power BI, Excel, DAX.

Confidential

MSBI Developer

Responsibilities:

• Extensively worked on TSQL for creating stored procedures, indexes and functions
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix reports and other features of reporting service.
• Worked on SSRS 2008 to generate about 30+ reports for various user groups and developer groups
• Deployed all the reports to reporting server, Excel & PDF.
• Developed Charts, Pie-Charts, Bar-graphs, series on SSRS
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML file) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for designing the SSIS packages to export data of flat file source to SQL Server Database
• Involved in enhancement of existing SSIS packages.
• Good knowledge in deploying SSIS packages to various environments.
• Implemented in unit testing and created unit test document
• Supported system testing and helped the testing team in execution of SSIS Jobs.
• Used various control flow tasks like FTP, Bulk insert task, Conditional Split, Multicast, Merge task and different data flow tasks.
• Provided many supporting documentations for the project.

Environment: MS SQL Server 2008/R2 Management studio, T-SQL, MS Excel, Windows-7, SSIS, SSRS.