SUMMARY:

• Over 7+ years of IT experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2016/2012/2008 with various business domains like Financial, Banking sector
• Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server-based applications.
• Excellent T-SQL Development Skills to write Complex Queries involving Multiple Tables, great ability to Develop and Maintain Stored Procedures, Triggers, User Defined Functions, Views
• Experience in writing complex SQL queries involving Inner and Outer joins, Temp Tables, Global Temp Tables, Derived Columns
• Proven ability in Performance Tuning, Query Optimization
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
• Experienced in Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal Skills
• Well versed with Tuning SQL Queries & Stored Procedures to improve performance
• Extensive experience in T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data Warehousing
• Extensive experience in SQL Server Integration Services (SSIS) and Reporting Services (SSRS) and experience creating Drill-down and Drill-through Reports, writing Expressions in SSRS and Fine-tuning Reports
• Expert in creating Simple to Parameterized Dynamic Reports and Complex Reports including Tabular Reports, Matrix Reports, Charts, Graphs, and Sub-reports using SSRS in Business Intelligence Development Studio (BIDS)/Data Tools
• Experience in Creation, Configuration, Development, and Deployment on various servers of Reports using SSRS
• Expertise in Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS) Packages for integrating data using OLEDB connection from varied sources by using multiple transformations including Data Conversion, Conditional Split, Bulk Insert, Merge and Union All
• Experience in developing different types of reports using Tableau and Power BI.
• Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Experience in Dimensional Data Modeling and Cube Development, Designing of STAR, SNOW FLAKE Schemas, Partition, Aggregation and Optimization using SSAS
• Expert in designing Crystal reports, Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 ) and Excel Pivot
• Created SSRS projects and reports in BIDS, sort and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.
• Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014 , calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions
• Experienced in agile environment
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling DSV diagrams, Fact and Dimensions Tables using Analysis Services.

TECHNICAL SKILLS:

Databases Tools: Business Intelligence Development Studio, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), SQL Server Analysis Service, SQL Server Management Studio

ETL Tools: DTS Data Transformation Services Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Report, Tableau, Power BI

Database: SQL Server 2011, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g, My SQL

Programming: SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, MS Access, ORACLE 10g/11g, My SQL, T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, Windows 2008, Unix.

Other Tools: MS WORD, MS EXCEL, MS VISIO, MS Power Point, OLAP & OLTP

PROFESSIONAL EXPERIENCE:

Confidential, Southlake, TX

Power BI / SQL 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
• Created SSIS Packages 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.
• Proven Power BI development experience with desktop and Pro versions. Familiarity with DirectQuery functionality within Power BI
• Development of Microsoft Power BI dashboards and dashboard templates
• Provide analytical, complex and specialized client service analysis using Power BI dashboards
• Involved in developing and supporting Microsoft BI and reporting capabilities (PowerPivot, PowerBI, PowerView, SQL Server Reporting Services) Experience implementing enterprise software solutions
• Used Tableau to create visual interactive dashboards using calculations, parameters and workbooks for decision making.
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent
• Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse
• Identified the dimension, fact tables and designed the Data-Mart using Star schema
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access
• Worked with SQL queries using MS Access for data manipulations
• Wrote T-SQL queries, Stored Procedures and used them to build packages
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012
• Developed complex T SQL code for Customer Imports and other interfaces for the PAT and Portal.
• Created and Maintained various database in MS Access to track activities and progress.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS
• Developed calculated columns and measures using DAX in Power BI
• Generated multi parameterized reports in MS SSRS 2012 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 drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• 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
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Provided daily support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution
• Involved in testing, bug fixing and documenting the work for the project at each and every phase

Environment: MS SQL Server 2012/2008/R2, DTS, PowerBI, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential, Dallas, Texas

Power BI / SQL Developer

Responsibilities:

• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Developed different types of tabular reports, matrix reports, charts and graphs report that aggregate data using SQL Server Reporting Services.
• Responsible for setting up subscriptions of the reports via SQL Reports Distribution (SQL-RD)
• Embedded the reports on to application using MS Report Viewer in Visual Studio 2010.
• Involved in query optimization in SSRS by designing required indexes partitions after analysis using SQL profiler and examining execution plans in SQL server Management studio.
• Created reports from Web Services and using MDX on cubes in SSAS to create reports in SSRS.
• Planned the complete backup (with suitable recovery model) of various Databases.
• Involved in development of OLAP cubes, designed Star Schema, Snowflake Schema & Fact Tables, Created Partitions, Aggregations and Calculated Members in SSAS.
• Created Clustered and Non- Clustered Indexes on tables for performance optimization of complex stored procedures.
• Ultimate Software Implementation and Conversion from ADP processing completed for 5 Hospitals, this included time clock configuration and mapping, import to Multiport of all employee data, setup of all employees and data exports for direct deposit and positive pay files, and a variety of employee related deductions.
• Implementation of any new business, Complete Company setup of multiport software including applications for all applicable Federal, State and Local Taxes. Meeting required deadlines for Company startup.
• Performance tuning of the stored procedures, user defined functions and long running queries.
• Providing information and assistance to the Database Architects on physical models, setup and maintenance of metadata.
• Connect to the data sources in Azure SQL Server and deploying the reports to share point by plugging the reports to the Azure SQL data sources.
• Developed dashboards with Power BI which display key KPIs for business analysis and decision making.
• Wrote database triggers for automatic updating, auditing of the tables.
• Deployed SSIS packages across development, test and production environments using project deployment model
• Improved the performance of the slow running queries by using performance tuning.
• Worked in creating stored procedures, views, materialized Views.
• Involved in managing and automating Control flow, Data flow and Events using Microsoft .NET framework for SSIS packages.
• Developed report specifications, created and modified reports using Tableau
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Worked on creating Stored Procedures, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.
• Trained teammates in using JIRA/Confluence.

Environment: Power BI 2.X, SQL Server 2016, Tableau, T SQL Services Integration Services 2016, Visual Studio 2015, SQL Server Reporting Services 2016, SQL Server Management Studio, Excel, C# 4.0

Confidential, Alden, NY

Power BI / SQL Developer

Responsibilities:

• Involved in SDLC of the project from requirements gathering phase to technical design, development and testing phase.
• Extensively involved in building the Data Warehouse environment with Azure cloud implementation of the ODS having multiple layers of data.
• Worked extensively in writing and debugging complex stored procedures, views, triggers and user-defined functions.
• Designed the Data warehouse, performed mappings from Source to the Target tables.
• Extensively used the DAX queries to build the Data Model in the backend.
• Involved in designing, developing and testing ETL strategy to populate the data from various source systems feeds using SSIS.
• Worked on Azure Active Directory. Microsoft Azure date storage and Azure Data Factory, Data Lake, Big Data on Azure.
• Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Migrated SQL server to MS Azure cloud. And extending domain services to Azure.
• Developed custom Azure Runbooks and connections to the REST API which will send email/text messages whenever there is a failure in scheduled pipelines at every stage.
• Used DAX studio to extract data form different Azure analysis services cubes.
• Calculated Tables, Custom transformations (M-language) and Dynamic KPI (DAX) are used.
• Used basic statistics functions that are available in DAX to provide insights on descriptive analytics.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, DAX, Partitions, KPI’s & MDX Queries and DAX using SSAS 2012.
• Involved in Provisioning, Configuring and Publishing Web and Worker Roles in Azure PAAS.
• Used various functions in DAX to build running totals, YTD and MTD Values
• Created and maintained various databases in MS Access to track activities and progress.
• Provided daily support to the client/technical teams for system wide tasks such as monitoring, alerting, testing, bug fixing/problem resolution & documentation

Environment: MS SQL Server 2012/2008/R2, DTS, Power BI, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, MS-Access, SQL Server Query Analyzer, ETL, Erwin, Red Gate SQL Source Control.

Confidential, ATLANTA, GA

MS SSRS/SQL BI Developer

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005/2008 databases servers.
• Worked with business/functional analysts to determine reports and analytical requirements.
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Documented Report Models and Report Templates for other Team Members.
• Created Prototypes of some complex reports and validated from the production.
• Developed Use Case Documents and Technical Documentation for some reports to Hand-off to the Offshore Development Team.
• Categorized reports into batch reports and on demand reports and scheduled it according to that.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Worked on Microsoft dynamics and created reports based on the customer requirements.
• Worked in Agile environment
• Developed complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments.
• Worked on Database space management, performance monitoring and alert management.
• Worked with business analysts and testers to manage the data as a part of data modelling
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL.
• Involved in loading data from the legacy systems into MS SQL server 2005 using SSIS packages.
• Worked on Team Foundation Server (TFS) to maintain the web application portal for reporting services
• Created user variables, property expressions, script task in SSIS.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Business Objects: Responsible for Coordinating with Application Developers in the integration and utilization of Crystal Tools in the development of applications.
• Modify report content and export reports in multiple formats based on user input in Crystal

Environment: SQL Server 2005/2000, Business Intelligence Tool 2005, Visual Studio 2003, DTS/SSIS, T-SQL, Unix, Shell scripts, Oracle 10g.

Confidential, Charlotte NC

SQL Server Developer/SQL Server DBA

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server 20 (2003, 64-bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, T-SQL, MS-Access, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, ERWIN.