SUMMARY

• 6 years of experience in Database programming, System Analysis, Design, Development & Support of MS SQL Server 2019/2014/2016/2012.
• Proficient in requirement analysis, system design, and Object Oriented Design (UML).
• Experience in logical and physical data modeling using ER Studio and Microsoft Visio.
• Extensive experience in the development of Reports using SQL Server 2016 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports and score cards in multiple formats using multi - dimensional objects.
• Extensive experience in SQL Server Analysis Services (SSAS) development.
• Expert level skills in designing, processing and partitioning cubes, Aggregations, KPI’s, Measures, Calculations, Actions, Translations and Perspectives.
• Experience in developing and managing reports and Dashboard using Power BI.
• Expert in monitoring SQL Server Performance, troubleshooting using SQL Profiler, Index Tuning Wizard (DTA), Windows Performance Monitor and Maintenance plan.
• Deployment of SSRS Reports and power view reports on SharePoint Portal and integrating Reports, Analysis Reports with SharePoint 2010(MOSS).
• Involved in configuring and using master data services to maintain data integrity in data warehouse.
• Good experience on developing and implementing backup and recovery strategies, creating and maintaining users and responsibilities.
• Extensive experience in T-SQL programming in creating and using Stored Procedures, Triggers, Functions and complex queries on various versions of SQL server.
• Exceptional versatility and adaptability, extremely diligent having excellent communication skills and ability to work both as individual and as a team member.
• Effective Team Player with excellent Analytical, Programming, Written and Verbal Communication skills.

TECHNICAL SKILLS

Databases: MS SQL server 2019/2016/2014/2012 , My SQL

Programming Languages: SQL, PL/SQL

BI Tools: MSBI

ETL Tools: BIDS/SSDT, SSIS, SSAS, SSRS.

OLAP/Reporting Tools: MS SQL Server Reporting Services 2014/2012/2008 R2, SSRS, MS Excel, Tableau, Power BI.

SQL Server Tools: SSMS, Query Analyzer, SQL server profiler, SQL Server Agent.

Data Modeling Tools: Erwin tool, Visual Studio 2010, Microsoft Visio, Business Intelligence Development Studio (BIDS).

Other Tools: MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio

Operating Systems: Windows Variants

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

SQL/MSBI Developer

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Created various types of reports such as complex drill-down reports, drill through reports, parameterized reports, matrix reports, Sub reports, non-parameterized reports and charts using reporting services based on relational and OLAP databases.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, using defined objects, chart.
• Extracted data from various sources like SQL Server 2019, CSV, Microsoft Excel and Text file from Client servers.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Designed and documented the entire Architecture of Power BI POC.
• Implementation and delivery ofMSBIplatform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server usingSSIS,SSRS.
• Monitoring SQL server performance using SQL Profiler to find performance and Deadlocks.
• Developed Employee scorecard reports which track all the employee metrics needed for the statistical analysis of Business.
• Involved in design, development, data analysis, identifying and gathering business requirements, user testing and maintenance of BI applications and information systems including database management systems like MS SQL Server.
• Extensively worked with SSIS tool suite, designed and created mapping using various SSIS transformations like OLEDB command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Created Datamarts for sales team to create Ad-hoc reports using report builder.
• Implemented Power BI gateway to keep Dashboards and reports up-to-date with on-premise data sources.
• Extensive use of Team foundation server for code check-in/check-out and managing source code changes.
• Developed custom calculated measures using DAX for various Fact calculations for efficient data visualization in Power BI.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing.

Environment: MS SQL Server 2019, SSIS, SSRS, Visual Studio 2012, Power pivot, T-SQL, Power BI, MS TFS, Windows

Confidential, Richmond, VA

MSBI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to load the shipping and customer data.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).
• Created custom logging and package configurations to change connection strings and variables dynamically. Used all types of containers in SSIS.
• Created package deployment utility and deployed packages into various environments. Involved in unit testing, SIT, UAT and data validations.
• Designed, processed and partitioned cubes using SSAS. Good experience in designing aggregations and Calculations. Experience in deploying SSAS objects using deployment wizard.
• Created calculated measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Writing variousT-SQLqueries,Stored Proceduresand used them to build packages.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Microsoft SQL Server reporting services.
• Created and maintained SSRS reports for External Reporting and Internal Activity Based Costing (ABC) for shipments tracking.
• Outstanding knowledge in creating drill down reports, Graphical reports, ad-hoc reports and drill through reports using the ROLAP/MOLAP as sources.
• Worked in agile methodology, participated in daily scrum meetings.

Environment: Agile, SQL Server 2016, SSIS, SSAS, SSRS, MDX, Power BI, MS Office, T-SQL, Windows.

Confidential, Toms River, NJ

MSBI Developer

Responsibilities:

• Analyzing and understanding the existing reporting environment.
• Worked closely with the Business analysts for requirements gathering, designing the database and creating workflow for report.
• Implementing the new reporting requirements for the business by making use of the new database and schema changes.
• Created one central SSIS Master Package to execute multiple child packages with Control Flow and Data Flow.
• Utilized Parent Package and XML Configuration to dynamically pass variable values on runtime.
• Participated in identifying data migration issues and resolved them.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created and scheduling maintenance jobs in new environment using SQL Server Mailing Agent in SQL Server.
• Extensively used variables, break point, check point, logging, package configuration and event handler in SSIS packages to meet the business needs.
• Involved in performance tuning to optimize queries and enhance the performance of databases, SQL queries, and stored procedures using SQL Profiler, Execution Plan and Index Tuning Wizard.
• Created Complex SSAS Cubes with multiple fact measure groups, and multiple hierarchies based on the OLAP reporting needs.
• Built MDX queries for Analysis Services & Reporting Services.
• Designed, developed, created and tested PivotTable/PivotChart reports based on OLAP cubes and offline cubes.
• Created multiple partitions and aggregations for the different measure groups for improving performance of the cubes.
• Resolving the SSAS cube connectivity and data issues as and when needed.
• Interacted with Business Users to help them understand to generate reports/look at the business data with various drill down options with Excel via connecting to SQL Server Analysis Services (SSAS).
• Supported the production environment for any Data or Logic Related Issues, Test and Debug the use case scenarios and migrate the code as needed by coordinating with the DBA Team.

Environment: SQL Server 2012, SQL Server Integration Services (SSIS), Reporting Services (SSRS), TFS, PowerShell, Pivot Tables, MS Visual Studio, SQL Profiler, Windows 2003/2007 Server OS.

Confidential, Chesapeake, VA

BI Developer

Responsibilities:

• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Progress Database, Excel, CSV, flat file, Text Format Data).
• Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables.
• Wrote complex Stored Procedures, functions and triggers as and when needed and to convert data logically as per the business requirements to improve the productivity of the claims processing system.
• Connected to the FTP Server and pull the group of Excel sheets into the SSIS from the folder located on FTP Server.
• Set up different kinds of transformations like Derived Column, Conditional Split, Lookup, Merge, Row Count, Data Conversion etc., in all the SSIS Packages.
• Set up ETL Jobs to run on a nightly basis into the Data marts by Scheduling SSIS Packages via SQL Server Agent.
• Coordinating the production deployment activities.
• Responsible for Performance Tuning of SQL commands and trouble shooting of Technical problems in SQL Server using SQL Profiler and the Database Engine Tuning Advisor.
• Documented all kinds of Reports and SSIS ETL Packages.
• Testing the new SSRS reports developed based on different filters and validating the outcome with the database.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Experienced in creating Ad-hoc reports, data driven subscription reports by using parameters, queries and reports in SSRS Report Builder, Developed data-driven subscription to end-users.

Environment: MS SQL Server 2012, TFS, T-SQL, SSIS, SSRS, Excel, Visual Studio 2008/2010, Windows Server 2008