SUMMARY:

• 7 plus years of extensive experience in full life cycle of software development process including Database Design , Data Modeling , Data Visualization , Implementation and Support of Microsoft SQL SERVER 2016/2014 / 2012 / 2008 / 2005 in Development , Testing and Production Environments , Data Warehousing and applications for different domains.
• Experience in optimizing the queries by creating various clustered, non - clustered indexes, indexed views and user-defined functions and views, Common Table Expressions (CTE’S) along with Backup, Recovery models using MS SQL Server 2016/2014/2012/2008/2005.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE's, Table Variables and Stored Procedures.
• Extensive experience in using Microsoft BI Studio products like SSIS, SSAS and SSRS for implementation of ETL methodology in data extraction, transformation and loading along with data modelling and reporting.
• Excellent knowledge in Scheduling Jobs and Alerts using SQL Server Agent.
• Extensive knowledge in managing and automating Control Flow, Data Flow, Events and Logging programmatically using .Net framework for SSIS packages.
• Expertise in maintaining Batch Logging, Error Logging with Event Handlers and configuring Connection Managers using SSIS and hands on experience in trouble shooting database issues.
• Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.
• Hands on experience in creating ADF (Azure Data Factory) pipelines for migrating the on-premises data to Azure SQL data warehouse.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key constraints.
• Migrated the MySQL database to SQL Server 2016.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Hands on experience in installing, configuring, managing, upgrading and migrating, backup/restore, monitoring and troubleshooting SQL Server 2005/2008R2/2012/2016 database systems.
• Experience in Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Expertise in Performance Tuning, Query Optimization and maintaining Data Integrity using SQL Profiler.
• Experience in Database administration activities like backup, disaster recovery and maintaining DB security.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services ( MDS ), and Reporting Services (SSRS).
• Experience in developing different types of reports using Tableau and Power BI .
• Expertise in creating dashboard reports to support end users using SSAS.
• Experience in generating periodic reports based on the statistical analysis of the data using Power Pivot, Power View and Power BI.
• A team player with an inclination to work in a collaborative setting by coordinating with concerned teams.
• Strong interpersonal and communication skills to liaise with the relevant stakeholders of various work streams.
• A self-motivated individual with problem solving skills to develop creative solutions for addressing the problem statement.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2005/2008 R2/2012/2016, MS-Access

Web Technologies: HTML, ASP.Net, XML, Java Script and VB Script, J2EE

Languages: C, C++, JAVA, C#, Python, T-SQL, VB.NET, XML, PL/SQL.

Operating Systems: Windows Server 2005/2008 R2/2012

Version Control Tools: Visual Source Safe and SVN

Reporting Tools: Microsoft Reporting Services SSRS, Report Builder 3.0, Tableau Tool, Power BI

ETL Tools: SSIS 2008 R2/2012, Informatica Power Center 7.x/6.x and Power Mart 8.x/7.x

Packages: Microsoft Office and Microsoft Business Intelligence

Modeling Tool: Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. MSBI /SSRS/SSAS/SSIS Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Directly involved in requirement gathering and understanding business functions by interacting with the end users.
• 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 data driven subscriptions, reports that run on demand, cached the reports, snapshot of the reports and deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Profound knowledge of Site Template, List Template, Customized Master Pages, Security, Authentication and Excel Services for Share Point Services.
• Extensive knowledge of SharePoint Site customization and Workflow development using SharePoint Designer.
• Created 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 SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and also 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.
• Used Microsoft Power BI to build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Worked in Agile Methodology.
• Used Plan.io for Project management.
• Involved in configuration and deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving sub reports, matrix/tabular reports, charts and graphs.
• Responsible for creating datasets using T-SQL and Stored Procedures and involved in Data visualization.
• 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.
• Provided 24X7 production support to ensure timely and error free delivery of reports for seamless project execution.

Environment: MS SQL Server 2016/2014/2012/2008 R2, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel, Windows 7.

Confidential, Bentonville, AR

MSBI /SSRS/SSAS/SSIS Developer

Responsibilities:

• Creating SSIS Package Configurations and maintaining their tables by editing the values of the variables as per the requirement.
• Performed the deployment of the developed Packages into various environments and schedule them as Jobs through the SQL Server Agent.
• Generated daily, weekly, monthly subscriptions and dashboard reports for the analysis of managers and end users by using SSRS.
• Involved in Performance Tuning and Query Optimization using execution plan.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports. Configured the report server and generated the report models for user interactions.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Designed and developed ETL process using SSIS to load data from various sources like Oracle, MS Access, Excel Spreadsheet and DB2 into SQL Server databases.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created copies of operational databases using the Import/Export Wizard and OLAP/OLTP environment.
• Worked on SSIS Script component using Visual Basic Applications and C#, by creating generic C# components that can be used in the external packages in SSIS.
• Developed T-SQL Queries, Triggers, Functions and Stored Procedures by adding the new features to the existing stored procedures.
• Developed many stored procedures which acts as data source for the all the web-based and reporting applications here in this project. Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Generated Chart-Reports drill down reports, Drill through reports and Parameterized reports using SSRS.
• Responsible for MS SQL Server in Production, Test, Development and Replication and Cluster Server Environments. Resolved any deadlocks issues with the Database/Servers on a real-time basis.
• Performed the deployment of the developed Packages into various Environments and schedule them as Jobs through the SQL Server Agent.
• Created various types of reports such as drill down reports, matrix reports, sub reports, and chart reports using SQL server reporting services (SSRS).
• Hands on experience with Database development in OLTP and OLAP.
• Proficient in using SQL server integration (SSIS) to build data integration and workflow solutions Extract, Transform, and Load (ETL) solutions.
• Designed and developed ETL process using SSIS to load data from various sources like Oracle, MS Access, Excel Spreadsheet and DB2 into SQL Server databases.

Environment: MS SQL Server 2012/2014, Integration Services (SSIS), Reporting Services (SSRS), MS Visual Studio 2012, SQL Server Management Studio, MS Excel and Windows 7.

Confidential, Minnetonka, MN

MSBI 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.
• 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.
• Developed and maintained 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.
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports, thereby making them user friendly.
• Created views and Stored Procedures for generating report; Responsible for creating the reports based on the requirements using SSRS.
• Created and maintained various database in MS Access to track activities and progress.
• Worked on several complex drilldown, 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.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs on Tableau and Power BI.
• 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 every phase.

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

Confidential, Arlington, VA

MSBI Developer

Responsibilities:

• Worked in ODS team (Operations Data Storage) responsible for maintaining claims, members and providers information on daily base.
• Responsible for monitoring, troubleshooting and tracking day to day production issues and fixing them.
• Performed system deployments including SSIS Packages, SSRS Reports, Database Objects, software upgrades and implementing automations.
• Created Indexes, Constraints and Rules on Database Objects.
• Developed Stored Procedures to calculate metric values implementing business logic.
• Updated Business Logic in SQL Server Database objects like View, Stored Procedures as per changing requirements in production.
• Created SSIS package to load data from various sources like Flat Files, XML (Extensible Markup Language) Files, SQL Server, Excel to Data warehouse using various transformations like Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Implemented the Package Configurations and Logging for a smooth transition between DEV, QA, UAT and PROD environments.
• Created Multi-Dimensional databases and OLAP cubes for the analysis in specific areas.
• Created 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.
• Developed several reports using SSRS, designed and created report Templates, Bar Graphs and Pie Charts based on the financial data.
• Created Scorecards and Dashboard for senior management.
• 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 troubleshooting, enhancing and creating claims retro report templates.
• Implemented Data Driven Subscriptions and created Cache Plans for shared data sets.
• Liaised with Onsite / Offshore development and other technical teams for deployment and support to improve production application availability.

Environment: SQL Server 2005/2008/2008 R2/2012, Visual Studio 2010/2013, MS Office 2010.

Confidential

SQL Developer

Responsibilities:

• Worked with other database administrators, report writers, and project teams to refine reporting requirements based on customer's business needs.
• Created triggers that produces primary key (unique) automatically when a new record is inserted into the database. The intention is to maintain unique records to eliminate duplicate records.
• Reported parameters including single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created ad-hoc SQL queries for customer reports, executive management reports.
• Performed SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Created data loads and Upgrade scripts for data migrations and validations.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.
• 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 Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters.
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager.

Environment: SQL Server 2008/20, 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, ERWIN.