SUMMARY

• Over 10 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Experience with different phases of project life cycle following SDLC (Analyze, Design, Develop, Test, and Implement).
• In - depth knowledge of Transact-SQL (Data Definition Language, Data Manipulation language).
• Created tables, views, stored procedures, UDF, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Experience in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), OLAP, BI suite, Reporting and Analytics.
• Implemented/Created ETL Packages using SSIS, for large data transfers between MS-SQL Servers and automating using SQL jobs
• Implemented all transformations available on theSSIStoolbox. Used variables and expressions in SSIS packages.
• Created master and child packages, package configurations and SSIS logging.
• Understanding of various source transformations, including flat files, XML, and relational systems.
• Created SQL Jobs, Alerts, SQL Mail Agent, and scheduled SSIS packages.
• SQL Server 2008 OLAP database development including Data mining, working with slowly changing dimensions (SCD).
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Experience in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Drill-Through, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Created groups and measures, KPI’s using SSAS.
• Highly motivated and a conceptually strong individual with good analytical and design skills.
• Flexible, Enthusiastic, and project-oriented team player with solid communication skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

• MS SQL Server 2005/2008R2/2012/2014
• T-SQL
• SSAS
• SSIS
• SSRS
• SQL Server Business Intelligence Development Studio
• Visual studio
• Microsoft Visual Basic
• C#
• .Net
• Dashboard Designer
• BI Express
• Red Gate
• TFS
• AGILE
• Scrum
• SDLC
• Waterfall
• MS Access
• Excel
• MS Visio
• XML
• HTML
• Windows 2000 Server/Windows95/98/2000/XP/7/10.

PROFESSIONAL EXPERIENCE

Confidential, Fort Mill, SC

SQL/SSIS Developer

Responsibilities:

• Perform code and unit test activities for Business Intelligence project using the Microsoft suite of products including SSMS, SSIS.
• Perform requirements gathering/documentation and coordinate implementation of requested enhancements for the applications.
• Create and modify views according to technical specifications and business requirement coming from different manufacturers.
• Involve in designing the data-feeds including tables, views, stored procedures, and CTE.
• Write test scripts for testing the data to ensure accuracy before the reports are sent out to manufacturers.
• Schedule SQL, ETL job using SQL Server Agent.
• Ensure that all production changes are processed according to release management policies and procedures.
• Use JIRA to keep track of progress of Scrum (AGILE) and store all history versions of SQL, ETL code into DevOps.

Environment: MS SQL Server 2018, SQL Server Integration Services (SSIS), T-SQL, Microsoft Visual Basic, Microsoft .Net, XML, TFS, JIRA, Vistex application, Red Gate, MS-Office, Visual studio 2019.

Confidential, Fort Mill, SC

SQL/SSIS Developer

Responsibilities:

• Perform code and test activities for Business Intelligence project using the Microsoft suite of products including SSMS, SSIS.
• Perform requirements gathering/documentation and coordinate implementation of requested enhancements for the applications.
• Analyze and maximize database performance, ensuring stability, scalability, and integration of quality data architectures.
• Succeeded in maintaining high levels of business continuity through proper administration and support of all database functions.
• Involve in designing the data-feeds including tables, views, stored procedures, indexes, UDF, and CTE.
• Design high level ETL architecture for overall data transfer from the Patient Plus to text files, excel files with the help of SSIS.
• Work on transactional database in order to implement all requests coming from all clients to in corporate inbound and outbound data feeds.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Develop Unit Test Plans for SSIS packages for checking the functionality of each component.
• Schedule SQL, ETL job using SQL Server Agent.
• Ensure that all production changes are processed according to release management policies and procedures.
• Use Team Foundation Server for keep track of progress of Scrum (AGILE) and stored all history versions of SQL, ETL code.

Environment: MS SQL Server 2018, SQL Server Integration Services (SSIS), T-SQL, Microsoft Visual Basic, Microsoft .Net, XML, TFS, Enterprise Pplus application, Red Gate, MS-Office, Visual studio.

Confidential, Charlotte, NC

SQL Data Analyst

Responsibilities:

• Perform code and test activities for Business Intelligence project using the Microsoft suite of products including SSMS, SSIS.
• Design and develop SSIS packages to move data from different environments within the organization.
• Performance tune ETL processes.
• Create and modify views and stored procedures according to technical specifications and business requirement.
• Create configuration files to deploy packages in different environments.
• Write test scripts for testing the data in order to ensure accuracy.
• Perform requirements gathering/documentation and coordinate implementation of requested enhancements for the applications.
• Create and schedule ETL jobs using Autosys.
• Use Team Foundation Server to keep track of Releases and store all history versions of SQL, ETL code.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), T-SQL, Microsoft Visual Basic, Microsoft .Net, TFS, Autosys, MS-Office, Visual studio.

Confidential, Charlotte, NC

SQL Data Warehouse/SSIS Developer

Responsibilities:

• Perform code and test activities for Business Intelligence project using the Microsoft suite of products including SSMS, SSIS.
• Perform requirements gathering/documentation and coordinate implementation of requested enhancements for the applications.
• Analyze and maximize database performance, ensuring stability, scalability, and integration of quality data architectures.
• Succeeded in maintaining high levels of business continuity through proper administration and support of all database functions.
• Involve in designing the data warehouse and core Database for the system including tables, views, stored procedures, indexes, UDF, and CTE.
• Design high level ETL architecture for overall data transfer from the Patient Plus to Data Vault and then Data Vault to EDW with the help of SSIS.
• Work on transactional database in order to implement all requests coming from all clients to in corporate inbound and outbound data feeds.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Develop Unit Test Plans for SSIS packages for checking the functionality of each component.
• Schedule SQL, ETL job using SQL Server Agent.
• Ensure that all production changes are processed according to release management policies and procedures.
• Use Team Foundation Server for keep track of progress of Scrum (AGILE) and stored all history versions of SQL, ETL code.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS), T-SQL, Microsoft Visual Basic, Microsoft .Net, XML, TFS, Enterprise Pplus application, Red Gate, MS-Office, Visual studio.

Confidential, Minnetonka, MN

SQL/SSRS Developer

Responsibilities:

• Design, Develop and Deploy reports in MS SQL Server environment using SSRS.
• Design and implement Parameterized and Cascading Parameterized reports.
• Develop different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Ad hoc reports and distribute reports in multiple formats.
• Develop detailed test conditions and test cases to ensure quality of queries and reports.
• Work on CareOne reporting application to test the data in the report and troubleshoot any data questions.
• Communicate with BAs to get correct business requirement document for reporting purposes.
• Design and develop SSIS packages to extract data from different source SQL databases.
• Collaborate on problem resolution, team decisions and project planning.

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL, CareOne reporting application, Subversion (SVN), MS-Office, Visual studio.

Confidential, Charlotte, NC

BI Developer

Responsibilities:

• Perform code and test activities for Business Intelligence project using the Microsoft suite of products, including SSIS, SSAS, and SharePoint.
• Design and develop SSIS packages to move data from different environments within the organization.
• Schedule jobs to call packages and stored procedures, and create alerts for successful and unsuccessful completion of schedule jobs
• Performance tune ETL processes
• Create and modify views and stored procedures according to technical specifications and business requirement.
• Create configuration files to deploy packages in different environments.
• Write test scripts for testing the data to ensure accuracy.
• Develop, maintain, and execute SQL scripts/queries and validated completeness, integrity, and accuracy of data.
• Create OLAP cubes and dimensions for the analysis of sales in different locations using SSAS.
• Analyze and test data in the cube using SSAS.
• Generate reports using Dashboard and deploy them on SharePoint server.

Environment: MS SQL Server 2008 R2, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), T-SQL, Microsoft Visual Basic, Microsoft Visual C#, Microsoft .Net, SharePoint Server MOSS2007, Dashboard Designer, MS-Office, Visual studio