SUMMARY

• Over 7+ Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Server 2005/2008/2008R2/2012/2014/2017/2019 in Production, QA, and Development Environments.
• Experience in creating SSRS reports and developing SSIS packages
• Extensive Experience in database administration, design, development, and business intelligence of cosmos Microsoft SQL Server 2016/2012/2008 R 2/2005/2000.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block, and Unblock Transformations.
• Expert in creating SQL Queries, Functions, Stored Procedures, Triggers, Cursors, materialized views, and customized views.
• Extensive experience with different phases of the project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Responsible for troubleshooting and debugging the issues at the last stage of Escalation level, Proficient in legacy data conversion and interface development using SQL, PL/SQL, UNIX, and SQL*Loader.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Extensively used packages like DBMS STATS, UTL FILE.
• Expertise in handling errors using Exceptions.
• Good knowledge of logical and physical Data Modeling using normalizing Techniques.
• Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System, and User-defined Variables for SSIS Packages.
• Expert in configuring and creating SSIS solutions for high-performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data. Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files, and XML using DTS, SSIS.
• Developed complex SSIS packages for processing type 1, type 2, and type 3 data with multiple transformations like Slowly Changing Dimension, Merge, Lookup, Derived Column, and Conditional Split.
• Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Experience of Relational Database Management systems (RDBMS) and Database design issues like normalization and de-normalization.
• Experienced in debugging and troubleshooting SSIS packages using Breakpoints, Checkpoints, Error Handlers, Event Handlers, etc.
• Developing reports in Power BI using DAX functions.
• Experience in writing complex T-SQL (DDL, DML, and DCL) scripts in all MS SQL Server environments.
• Expert in designing SSRS and Power Pivot reports.
• Experience in creating jobs, alerts, and scheduling DTS/SSIS packages in SQL Server Agent on a daily/weekly/monthly basis.
• Work Experience on ticketing tools TFS and Jira.
• Extensive working experience with different methodologies like Agile (Scrum), Test-driven development (TDD), and Waterfall methodologies.
• Experience in building, deploying, and managing applications on the Microsoft Azure Cloud computing platform.
• Flexible, enthusiastic, and project-oriented team player with excellent written, verbal communication to develop creative solutions for challenging client needs. Worked on creating complex reports using Report Designer in SSRS.

TECHNICAL SKILLS

BI & DW Tools: SSIS, SSAS, SSRS, Data tools, Power BI, PowerShell, Azure Data Factory, Azure Data Lake Store, Azure Data Lake Analytics, crystal reports.

Database Utilities: Enterprise Manager, SQL Server Management Studio, BI Development studio, Visual Studio, Configuration Manager, SQL Server Profiler, SQL Query analyzer, SQL Server Agent

ETL Tools: Data Transformation Services (DTS), SSIS, Import/export wizard, Bulk Insert, BCPData Warehousing.

BI Tools: SSIS, SSRS, SSAS, Crystal Reports XI/X/9/8, Report Designer, Business Intelligence Development Studio(BIDS)

RDBMS: MS SQL Server 2016/2014/ 2012/2008/2005 , MYSQL, MS-ACCESS, Oracle 11g/10/9i, DB2

Programming: SQL, T-SQL, Power BI, Visual Basic, Visual C++, MY-SQL, JavaScript. Classic ASP, Asp.net.Net framework.

Web Technologies: Html, CSS

Operating System: Windows 98/XP/Vista/7/8, UNIX, Linux, Mac OSX

Data Modeling tool: Visual Studio, Adobe Photoshop, MS Office Suite, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Dayton, Ohio

MSBI Developer /SSIS Developer/SSRS Developer

Responsibilities:

• Upgraded SQL Server 2014 to SQL Server 2017 and migrated data from old systems to new systems.
• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Involved in SQL Server Configuration, Administration, Implementation, and Trouble-shooting for Business work.
• Migrated existing self-service reports and Ad-hoc reports to Power BI.
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Extensively used SSIS transformations such as Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL Task, Script Task, and Send Mail task.
• Actively monitored performances of queries on SQL server 2019 using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language.
• Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All and Copy Column, Derived Column using SSIS .
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Worked on the Development and implementation of SSRS reports and ran them as per the requirement.
• Responsible for the issues raised from the production and debugging and deploying the updates.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins, and SQL Scripts for Views and Materialized Views.
• Widely worked on to improve SQL Query performance, SQL Query analytics, and highly complex joins to populate the desired result set.
• Created Reports with the latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy, Lookups etc.
• Created various ad-hoc SQL queries for customer reports, executive management reports, and types of report types like tables, matrix, and sub reports.
• Developed Oracle scripts, Functions, and Packages using Oracle SQL developer.
• Created and managed database objects such as tables, views, indexes, stored procedures, and user-defined functions. Maintained user permissions, referential integrity, SQL agent jobs.
• Created Metadata reports in SSRS that give the information about the metadata of the jobs like Effective from, Effective to, Current or not current report, Execution times, and errors if there are any.
• Involved in creating measure groups using different fact tables and created calculated members, Advanced KPI’s and named set in SSAS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data as well as created interface stored procedures used in SSIS to load/transform data into the database.
• Designing and Developing the Dashboard Reports in Power BI using DAX.
• Migrating Oracle database source-based SSRS reports to SQL source-based by changing the Oracle source code to SQL code compatible.
• Used the Phabricator tool to verify the changes between existing script which is in source control to the script which I developed.
• Used the JIRA project management system to track the enhancements and developments on a daily basis.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012/2014/2017/2019.
• Expertise in building and migration of various DTS packages.
• Strong experience in creating and publishing packages in Framework Manager.
• Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.
• Created Unix Shell Scripts to load Data into tables and provide Administrative support for the Zena tool.
• Used Agile methodology for development.
• Maintained JIRA for tracking and updating project defects and tasks.
• Created Views, Materialized Views to get the values dynamically using joins and other SQL queries from the multiple tables.

Environment: : Microsoft SQL Server 2005/2008/2012/2014/2017/2019 , SQLServer Reporting Services (SSRS), SQLServer Integration Services (SSIS), Power BI Desktop, SharePoint, TFS, Visual Studio 2015, SQLServer Analysis Services (SSAS), T-SQL, SQL Profiler, XML, Team Foundation Server (TFS) 2012, Unix, MS Excel, Excess, Azure, Windows 8.

Confidential, Sterling, VA

MSBI Developer /SSIS Developer/SSRS Developer

Responsibilities:

• Involved in the installation of SQL server enterprise manager tools using SQL Setup.
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Designed and developed various abstract classes, interfaces, Inheritance to construct the business logic using .Net , ADO.NET, and SQL .
• Enforced referential integrity in the OLTP data model for a consistent relationship between tables and efficient database design.
• Created database tables, Indexes, triggers by writing SQL queries as per the database change request by the business.
• Worked on Bulk insert to load data from flat files obtained from various facilities every day.
• Experience in developing pipelines in Azure Data Factory using SQL Azure
• Azure SQL Server, Azure Data Factory and Data Bricks to create end-to-end data pipelines for collecting, cleansing and processing client data
• Created complex SQL queries, stored procedures, triggers, views, functions to implement business logic.
• Created and managed database objects such as tables, views, indexes, stored procedures, user-defined functions. Maintained user permissions, referential integrity, SQL agent jobs.
• Created Ad-hoc reports with complex t-SQL queries based on business requirements.
• Wrote complex T-SQL queries and stored procedures for the building reports in SSRS.
• Developed, scheduled, and generated a variety of reports like List, Matrix, Drill-Down, Chart, and Sub Report, and standardize company report by using Power BI and its DAX functions.
• Used SSRS to create reports, customized Reports, on-demand reports.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Enhancing and deploying the SSIS Packages from the development server to the UAT server.
• Worked on developing Report Structure with data definition, report layout, and report definition language.
• Created various Complex Formula Reports querying the database for Business Intelligence.
• Strong ability in defining query for generating drill through, drill-down reports, canned and cache reports with a drop-down menu option, sorting the data, defining subtotals and handling parameterized reports, and creating report layouts using SSRS.
• Developed a different kind of reports such a sub-reports, charts, matrix reports, linked reports. Creating SQL agent jobs after the successful development of ETL packages and SQL codes.
• Good T-SQL Programming techniques in query optimization and performance tuning.
• Experienced in creating nested Grouping, sorting columns and writing expressions per the business requirements.
• Worked in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Developed Drill down, Drill through, ad hoc, sub reports, Dashboards, Cached reports in SSRS. Distributed reports via SSRS in different formats to users on a weekly, monthly basis.

ENVIRONMENT: Microsoft SQL Server 2005/2008/2012/2014/2016 , MS Access, AZURE Data Factory, ETL Packages (SSRS, SSIS), PL/SQL, C#, HTML, IIS, Visual Studio 2012/2008/2005 , Visual Source Safe, DTS, T-SQL, VSS, TFS.

Confidential, Norwell, MA

MSBI Developer /SSIS Developer/SSRS Developer

Responsibilities:

• Worked in creating complex Stored Procedures, Triggers, Cursors, Tables, Views, Joins, and Statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2012 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in the development database for Warehouse system.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Performance tuning of Queries and Stored Procedures.
• Migrated old data from MS Access and Excel into SQL Server 2012 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, MDX, Conditional Split, Lookup, Aggregator, Multicast, and Lookup.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created different kinds of reports like List reports, cross tab reports, charts, Drilldown reports, Drill through Reports, Parameterized reports, Sub reports as well as managing the subscription of the reports (Standard and Data-Driven Subscriptions).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2008/2012).
• Integrated data from the Google Big Query DW into onsite DW using SSIS.
• Designed and created report models based on users’ requirements, explained and trained users to use the report builder to generate their own personalized reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly Reports including current status.
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Proficient in SSIS transformations like Lookup transformation Derived Column, Conditional Split, Merge Join, and Row Count.
• Worked with the report manager for deploying the reports across all the environments.
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Created Ad Hoc, Parameterized Reports, Linked Reports, Snapshots, Drilldown and Drill through reports using SQL SSRS.

Environment: SQL Server 2008/2012Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2008 & 2005.

Confidential, Lincolnshire, IL

MSBI Developer

Responsibilities:

• Responsible for gathering and defining user report requirements and developing appropriate interfaces for the reporting infrastructure environment to meet customer business needs, based on business processes and data entities between various systems.
• Developed appropriate layout and designs for required reports using the SSRS and Stored procedures to retrieve data from the SQL Server using appropriate SQL language ( T-SQL ) to provide optimal performance.
• Worked on extracting, transforming, and loading data using SSIS Import / Export Wizard .
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Deployed the generated reports directly on the client’s workstation.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services ( SSAS) for analyzing purpose.
• Maintained the physical database by monitoring performance, integrity, and optimize SQL queries for maximum efficiency using SQL Profiler.
• Widely used DDL and DML to write Triggers, Stored procedures to check the Data Integrity and payment verification at early stages before calling them.
• Used Team Foundation Server (TFS) as a tool for the repository of codes and version control, also maintains test scripts and documentation following the standards.
• Managing SQL servers by performing DBA tasks like Database Backup/Restore and by creating maintenance plans like Daily backup check DB and weekly rebuild and scheduling jobs on a daily/weekly basis, SQL Error logs for errors.
• Developed physical RDBMS data models using ERWIN and created DDL scripts for database schema and objects.
• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ Analysis Server (SSAS).
• Enhancing performance using optimization techniques-normalization, indexing, and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes.
• Designed SSIS packages using various control flow tasks like Data Flow Task, For Each Loop, Execute SQL Task . Actively involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command, and Conditional Split while designing SSIS Packages.
• Assisted the organization in performing data compilation, mining, and analysis required to evaluate the given data.
• Provided and defend conclusions and recommendations to customers based on the results of the analysis.
• Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.
• Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of the software development lifecycle.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, ERWIN, TFS.

Confidential

SQL Developer

Responsibilities:

• Plan, design, and implement application databases code objects, such as tables, stored procedures, functions, and views in partnership with business analysts and technical architects.
• Implemented complex business logic and processes through T-SQL stored procedures, Functions, Views, and advance query concepts.
• Collaborated and coordinated with business analysts to gather requirements for implementing data mart.
• Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2005/2008.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured, and extensible.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact, and Dimensions Tables using MS Analysis Services.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Extract data from the database and export to Excel files for Data Analyst to analyze the data.
• Scheduled Packages using SQL Server Agent Jobs to execute at a specified time on a weekly and monthly basis.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, T-SQL, Windows 2008 Advance Server, MS Excel, and MS Office.