PROFESSIONAL SUMMARY:

• Around 7 years of strong IT industry experience as a MS SQL Server 2019/ 2017/ 2016/2014/2012/2008 R2/2008/2005, Data Warehouse Developer/BI Developer (SSIS, SSRS) in various domains. Maintained positive communications and working relationship at all levels.
• Skilled professional with experience in all stages of SDLC: planning, analysis, design, implementation and Worked with SDLC methodologies like Waterfall, RUP, Agile (Scrum).
• Extensive experience in SQL Server 2017/ 2016/2014/2012/2008 R2/2005, Business Intelligence in SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services.
• Proficient in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• 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.
• Created DDL and DML triggers.
• Exceptional Ability of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous system like Sybase Database using SQL tools (SSIS, DTS, Bulk Insert and BCP).
• Proficient in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file, Json, Xml using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS 2015/2012/2008 R2/2008/2005 and SQL commands.
• Designed, configured and deployed Microsoft Azure for a multitude of applications utilizing the Azure stack (Including Compute, Web & Mobile, Blobs, Resource Groups, Azure SQL, Cloud Services, and ARM), focusing on high - availability, fault tolerance, and auto-scaling.
• Thorough knowledge of C# programming concepts, SDLC, testing and debugging methods, system design, and implementation, database system, including DB2 and relational databases, program documentation, web and desktop application development
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase, Excel and MS Access.
• Expertise in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Proficient in designing, creating and maintaining reports in Accela Automation schema.
• Generated calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experienced in writing testing scripts for SSIS packages.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experience in creating KPI and Calculated Measures using SSAS.
• Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2012/2008R 2/2008/2005.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS) 2016/2014/2012/2008 R 2/2008/2005.
• Expert in using tools like SQL Profiler, Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Ability to handle Microsoft SQL Server Database Administration including planning, backup, and recovery strategies
• Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Proficient in Migration of database, successfully migrated database from SQL Server 2000 to SQL Server 2005, and SQL Server 2005 to SQL Server 2008 and SQL Server R 2/2012/2014/2016.
• Proficient in Migrating data from Sybase central to SQL Server 2014/2016
• An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics

TECHNICAL SKILLS:

SQL Server 2016/2014/2012/2008 R2/2008/2005, SQL Server Enterprise Manager, Query Analyzer, Transact-SQL (T-SQL), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Management studio (SSMS), Business Intelligence Development Studio (BIDS), MS Access, MS Visual Studio 2015,2012,2013, Bulk Copy Program (BCP), Microsoft Office, MS Visio 2003/2007, C, HTML, ASP .NET, Crystal Report, Erwin Data Modeler 7.3/4.1/4.0, Performance Point Server, Java script, Visual SourceSafe (VSS),SQL Server Profiler, Data Base Tuning Advisor, TFS, GIT, SVN.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

MS SQL Server Developer

Responsibilities:

• Defined and Designed data based on business requirement and provided documentation.
• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Involved in Migration of data from MS SQL server 2014 to MS SQL server 2017.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Responsible for writing T-SQL Queries, Stored Procedures, Views, Functions and Triggers.
• Deployed SSIS packages in customized AVANT GUARD application used for reports and imports.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Responsible for writing T-SQL Queries (DDL/DML), Stored Procedures, Views and Functions.
• Responsible for creating database tables, Views, Stored Procedures and Triggers to provide structure to Data warehouses, and capture updated and deleted data from OLTP systems.
• Designed and developed SSIS packages for loading data from ODS to Data Warehouse. Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Recognized the fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created tabular, matrix, chart, drill-down, drill-through reports using SSRS and generated report models using report builder for the end users.
• Performance tuning and query optimization od stored procedures
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management
• Worked on ETL SSIS Development, creating packages using various transformation techniques and also created jobs that are scheduled to run on daily basis and thus load into the Data Warehouse.
• Created SSIS package to load data from XML Files, Flat files, Ftp server, Sybase and SQL Server to SQL Server 2014/2016 by using Lookup, Derived Columns, Condition Split, OLEDB Command, ODBC Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Slowly Changing Dimension.
• Developed Validation Plans for SSIS packages for checking the functionality of each component and code
• Implemented the Master Child Package Model in the EDW and Data-Mart for easier maintenance and better performance of SSIS Packages review.

Tools: MS SQL Server 2015/2016, SQL BI Suite (SSMS, SSIS, SSRS), XML, MS Excel, MS Access 2007, SQL Profiler, Data Analyzer, SQL Server CE client, OLAP, Windows 7, Erwin r 7.3.,Net 4.0/4.5.,TFS 2005/2008/2010/2015 , JIRA Confluence.

Confidential, Charlotte, NC

MS SQL Server Developer/MSBI Developer

Responsibilities:

• Created SQL Server Reports based on the requirements using SSRS 2015.
• Involved in migration of SQL Server .
• Identified and documented all the reports, tables (subject areas) and ETL for each Business units.
• Documented the current and Gap Analysis across all the business units for ETL, Reports and Data.
• Identified the underline reports tables which are touching non- replicated tables.
• Create Naming standards and Data dictionary for EDW Phase.
• Create Data mart/ Dashboard/ KPI server with project plan.
• Participated in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment.
• Extensively used all features of MS SQL Server 2015/2012/2008 R2/2008/2005 as a SQL Developer.
• Created Cubes with Dimensions and Facts and calculating measures and dimension members using Multidimensional expression (MDX).
• Used JavaScript and .NET Validation Controls for performing client-side validations.
• Designed and Developed Web Services to synchronize data from Remote application database to Online Database using C .Net, ASP.Net, Visual Studio.
• Hands on experience on AVG front end application.
• Responsible for creating database tables, Views, Stored Procedures and Triggers to provide structure to Data warehouses, and capture updated and deleted data from OLTP systems.
• Upgrade enhancements, maintenance, production support and bug fixes for the project and the data models.
• Created SQL objects like Tables, Stored Procedures, Functions, and User Defined Data-Types.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Developed ETL jobs to load information into Data Warehouse from different relational databases and flat files.
• Scheduled jobs for executing the stored SSIS packages, Reports which were developed to update the database on daily basis using Autosys.
• Generated different reports using MS SQL Reporting Services and Crystal Reports.
• Created various Tabular and Matrix Reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters. And also converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Strong Experience in developing reports using Query Studio & Report Studio.
• Worked on designing and developing Data Warehouses, Data marts and Business Intelligence.
• Involved in using Informatica transformations for loading data from source to destination.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality.

Tools: SQL Server 2012/2008 R2/2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2008/2003, Oracle 9i, Crystal Reports, Performance Point Server 2007, Informatica Informatics Power Center 8.6.1/8.1.1/ 7.1 , Excel, Cognos 8.4/8.2, Framework Manager, SVN.

Confidential, Charlotte, NC

MS SQL Server Developer/SSIS Developer

Responsibilities:

• Defined and Designed data based on business requirement and provided documentation.
• Involved in migration of Sybase to SQL server 2014.
• Worked on ETL SSIS Development, creating packages using various transformation techniques and also created jobs that are scheduled to run on daily basis and thus load into the Data Warehouse.
• Created SSIS package to load data from XML Files, Flat files, Ftp server, Sybase and SQL Server to SQL Server 2014/2016 by using Lookup, Derived Columns, Condition Split, OLEDB Command, ODBC Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Slowly Changing Dimension.
• Developed Validation Plans for SSIS packages for checking the functionality of each component and code
• Implemented the Master Child Package Model in the EDW and Data-Mart for easier maintenance and better performance of SSIS Packages review.
• Used ASP.NET web form controls such as Grid View, List View, etc. for displaying data.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Planned and executed SSIS Package step process to load data, validate data and recommending task to resolve performance issue with loading data into the Data Warehouse.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on daily basis using Autosys.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Job overlap alert.
• Gathered user requirements from the users to develop the business logic and analyzed and designed software and database solutions and involved in cresting TDD (Technical Design Documents), FSD (Functional Specification Document).
• Worked in setup auditing, logging environment to track the status of the events like error raise, task fail.
• Designed tool to automatically add derived column, parameter and configuration value to the package.
• Created reports to retrieve data using function, views, cube and stored procedures using parameters.
• Created various database objects like stored procedures, functions, tables, views, triggers.
• Configured the report viewing security for various users at various levels using Report Manager.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Extensively used T-SQL in constructing Stored Procedures, Common Table Expressions (CTEs), User Functions, Indexes, User Profiles, Relational Database Models, Data Dictionaries, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Provided documentation for all kinds of SSIS packages.
• Designed and implemented stored procedures and Triggers (DDL & DML) for automating tasks.

Tools: MS SQL Server 2015/2016, Sybase Central, SQL BI Suite (SSMS, SSIS, SSRS), XML, MS Excel, MS Access 2007, SQL Profiler, Data Analyzer, SQL Server CE client, OLAP, Windows 7, Erwin r 7.3.,Net 4.0/4.5.,TFS 2005/2008/2010/2015 , SVN.

Confidential, Los Angeles, CA

MS SQL Server Developer/Report Programmer and SSIS Developer

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performing query plans and making sure each and every query is using appropriate useful Indexes.
• Understanding the report design Requirements and Constraints.
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating the integrity.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Deployed the created SSIS packages in Development and Testing environments.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Implemented Client and Server-side validations using JavaScript and ASP.Net validation controls .
• Developing and maintaining ETL jobs for the Data Warehouse using SQL Server Agent.
• Used Data Adapters and Datasets of ADO.Net to manipulate data in the SQL server database.
• Developed tabular, matrix, chart, Drill-down, parameterized and cascading reports (SSRS).
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed Custom/Conditional formatting reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created various Web forms for user login, account summary, loan applications and history pages using ASP.Net .
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.
• Created scorecards with executive summary dashboards using MS Office Performance point server 2007 Dashboard designer that display performance monitoring measures.
• Scheduled Backups and performed Restore operations for system test data.

Tools: SQL Server 2014/2016, Visual studio 2014, SSIS, SSAS, SSMS, XML, MS Excel, MS Access 2007 & Windows Server 2008 Access 2003 & Windows Server 2003, SQL Profiler, Data Analyzer, Erwin r 7.3,.Net 4.0/4.5.,TFS 2005/2008/2010/2013 , GIT.

Confidential, Chicago, IL

MS SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Designed data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.
• Gathered business requirements, provided architecture and design for financial module for Medicare Advantage program.
• Implemented Table, Views, Function, Stored Procedures and Triggers for load data and validation purpose.
• Worked with Agile Methodology tracking the product backlog and resolved the defects/Solution assigned in daily scrum.
• Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2012 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Warehouse.
• Converted DTS Package to SSIS package for synchronizes existing process (DTS migrations).
• Involved in Migration of SSRS 2005 to SSRS 2008 R2.
• Used Team Foundation Server to retain Project code during deployment process.
• Part of Code review during Production deployment and QA deployment.
• Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data into the Data Warehouse.
• Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C#.
• Created Cubes with Dimensions and Facts and calculating measures and dimension members using Multidimensional expression (MDX)
• Worked on methodologies with Agile and Scrum.
• Created Process for Error Details in Application system, Control-M Job, SQL agent Job to easily identify Issue for Support and Solution.
• Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012.
• Generated Sub-Reports, Crosstab, Conditional, Drilldown reports, Drillthrough reports and Parameterized reports using SSRS 2012.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Tools: MS SQL Server 2012, SSIS Package, SQL BI Suite (SSMS, SSIS, SSRS, SSAS), XML, MS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler, Erwin r 7.3.,Net 4.0/4.5.,TFS 2010.

Confidential

SQL Developer

Responsibilities:

• Involved in Creation of tables and procedures to update and clean the old data.
• Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule
• Involved in writing stored procedures to check the conversion errors.
• Involved in writing stored procedures to parse the full name in the legacy system and split it into First Name, Middle Name, and Last Name based on the business rules.
• Involved in rigorously tested and debugged all the scripts to test the validity of the data after the export/import/delete were done.
• Assisted with the Senior MS SQL developer in debugging of complex scripts and testing of procedures and functions

Tools: MS SQL Server 2000, T-SQL, SQL Query Analyzer, SQL Developer, DTS Designer, SQL Profiler, Index Tuning Wizard, Windows XP, MS Excel, MS Access.