SUMMARY

• 5+ years of IT experience in Database Design, T - SQL, Data Modeling, Data and Database Security, Requirements Analysis, ETL Development, Businesses Intelligence, Report development, Database Administration, Application Development, Testing, Implementation and Deployments using SQL Server 2017/2016/2014/2012/2008
• Experience in Creating Complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Experience in Database Design, Development and business intelligence of Microsoft SQL Server.
• Strong experience in Business Intelligence (BI) using Visual Studio 2017/2016/2015/2010/2008/ 2005.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2017/2016/2014 /2012/2008/2005 databases and scheduled them according to requirements.
• Experience in Designing, developing and testing various Power BI visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases
• Provided technical support to create batch job, scheduled, monitor by using IBM TWS scheduler.
• Played an instrumental role in Migration Data from Excel, Flat file, OLE DB using DTS, SSIS and other ETL Tools.
• Developed various complex reports from different data sources such as SQL Database and Cubes by using Reporting tools like (SSRS) and expert in fine tuning the reports. Created many Drill through and Drill Down reports
• Experience in working with Monitoring tools like SQL Profiler, Oracle Grid, HPPM, TOAD to monitor Top SQL, DB Instances, CPU Utilization. Memory Utilization.
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView BI.
• Responsible for Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and performing SQL tuning.
• Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.
• Experienced various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Experience with healthcare, finance, accounting metadata and flat file from different vendors and analyzing by using different research methodology to use business logic and reasoning to identify the strengths and weaknesses of alternative solutions and applying appropriate logic to specific problems.
• Work assigned project tasks according to project schedules. Proactively identifies issues related to the quality, timeliness or budget of the project and communicates solutions to Business Unit Owner, Project Manager and Program Director.

TECHNICAL SKILLS

Languages: T-SQL, Pl/SQL, HTML

ETL Tools: SSIS, Data Stage, Visual Studio 2016,2015,2013,2012,2008

RDBMS: MS SQL Server 2016,2014,2012,2008

Reporting Tools: SSRS, POWER BI

Operating Systems: Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Unix, Linux

Database Tools: MS SQL Server, SQL Server BI (SSIS, SSRS), SQL Developer, DB2, DataStage, SQL Profiler, Query Analyzer, SQL Server Agent, SQL Prompt.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

MSBI Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• SQL Scripting, using Microsoft SQL Server Management Studio 2008 R2, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Worked with Client to resolve the Data issues in FACETS Environment
• Worked with ETL team to resolve some of the data (ETL) issues (SSIS is used to move the data from FACETS.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports basing on the requirements using SSRS 2012.
• Data migration (import & export - BCP) from Text to SQL server.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio 2008.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Build reusable macros to control QlikView objects for ease of use by the users.

Environment: SQL Server 2014/2012/2008/2005 , SSIS, SSRS, QlikView, Visual studio 2008, FACETS.

Confidential, Philadelphia, PA

SQL Server Developer

Responsibilities:

• Extensively involved in creating SSIS Packages to migrate data from various sources and loading them into SQL Server Database.
• Played major role on production support (operations) running and scheduling jobs, backups, cube refresh and so on.
• Handled day to day Service Requests (SR) coming from end users/customers.
• Used C# scripts to map records between CRM and Legacy database.
• Involved in SSIS Package creation from package design documents to package build.
• Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated.
• Creating High Level requirements documents and data mapping to FACETS by involving discussions with multiple stakeholders
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Build table relationships and wrote stored procedure to clean the existing data.
• Coordinated with front end developer to put in the business rules. Wrote stored procedure to check some of the rules at the backend at the time of entering data.
• Developed SQL Scripts to Insert/Update and Delete data in MS SQL database tables.
• Developed the project using iterative approach.
• Created new SSIS packages according the business rules.
• Participated in creating reports using SSRS.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

Environment: SQL Server 2008/2005, SQL Server 2008 Integration Services (SSIS), SQL Server 2008, Reporting Services (SSRS), Windows 2003 Server/XP.

Confidential, OH

SQL Developer

Responsibilities:

• Migrating data from Legacy system to SQL Server using SQL Server Integration Services 2012.
• Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity and recommend changes as necessary.
• Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Created Test packages to validate the SSIS packages build.
• Created and modified Stored Procedures, Functions, and Indexes.
• Experience in configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Have good business analytical and technical knowledge in Healthcare Membership, Benefits and Provider Modules in FACETS.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized report, ad-Hoc and parameterized reports using SQL server 2012 reporting Services.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Expertise in generating reports using MS Reporting Services 2012.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Excellent command on subscriptions, report snapshot and report cache.
• Designed SSIS packages to Extract data from various sources like SQL server 2008, MS Excel, MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS.

Environment: MS SQL Server 2012, Business Intelligence, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, Visual Studio 2012.