PROFESSIONAL SUMMARY:

• 6 years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server 2012/2008/2005 & Oracle 11g,12c.
• Strong experience in Confidential (BI) using Visual Studio 2014/2010/2008/2005.
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2012/2008/2005 databases and scheduled them according to requirements.
• Experience in creating batch job, scheduled, Monitor in different server using TWS scheduler.
• Experience in Migration of Data from Excel, Flat file using DTS, SSIS and other ETL Tools.
• Experience in working with Reporting tools like MS SQL Server Reporting service (SSRS).
• Experience in working with Monitoring tools like Oracle Grid,HPPM to monitor Top SQL, DB Instances,CPU Utilization.Memory Utilization.
• Experience in performing different server router restart by using Unix/Linux command line to resolve the sever issues.
• Experience in working with Data Warehousing and Confidential tools for developing various reports using QlikView BI.
• Experience on developing Facets Application Extensions on .NET platform for different application Group in Facets.
• Experiences in writing C# code on .NET Framework to develop different customize Facets Application Extensions on Upgrade project.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow - Flake Modeling, partitions, facts, dimension tables using MS Analysis Services.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Hands on experience with Data Modeling tool like Microsoft Visio.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and performing SQL tuning.
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recoveryandplanning.
• Performed database consistency checks at regular intervals.
• Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.

PROFESSIONAL EXPERIENCE:

SQL DEVELOPERUHG

Confidential, NC

Responsibilities:

• Worked closely with business analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions.
• Worked on creating SQL deployment packages and deploy them in different environment to resolve the production issue.
• Worked with clients to modify, update, and delete data by creating one run script as per the customer requirements.
• Regularly worked with DBA, Lead, and Manager in war room to resolve the performance issue by using SQL tuning in Database.
• Actively participated to resolve the application post production defect by modifying store procedure, C# for Facets customize application extension.
• Worked to implement and modifyIndex,Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Worked to migrate the data from one environment another environment as per the client's requirement by using CMU migration tool.
• Performed Monitoring of CPU,Memory, Database Instances,Instance Activity, Top SQL monitoring,Killing Top SQL, Job Monitoring,Monitoring Hosts,Storage Resource Tracking by using Oracle Enterprise Manager(Oracle Grid).
• Creating performance report to monitor the database, server, and application on daily, weekly basis by using HP performance manager and DC RUM tool.
• Worked closely with batch Support team to resolve Tivoli Workload Scheduler (TWS) issue by cancelling,killing Abend, Fail Job and removing them from TWS.
• Monitoring and Checking Job Streams for Status and Dependencies andClean-Up by Using ITG Self-Service.
• Designed SQL SSIS Packages in SSDT/ Confidential Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2012, 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, daily, weekly loads of data by creating the corresponding job tasks inTWS.
• Worked on SSIS 2012 to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Experienced on configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Worked with customers tointegrate Facets with third party applications or Web portals in order to reduce costs, enhance flexibility and improve, efficiencyby using Facets eXtended Integration (FXI).
• Closely worked with DBA and System Admin to install FXI, broker, FXI Core, FXI Foundation, FXI Adapters.
• Performing Unix/Linux command line to restart and fix server router which is detected by U2A (broker) monitoring script.
• Worked to detect and resolve the defect in Perlscript on Linux Red Hat platform by modifying and install zip, mailx functionality to send the batch job log files to email server.
• Experienced in performing FTP, ECG from source to destination between different server and upload, download the file in various environments.
• Worked facet frontend and backend for data analyzing purpose to perform the pre and post validation process after deployment the script to make changes in Database
• Worked to write and modify Store procedure toimplement business logic in facet extension and interface application.
• Used Execution Plan, SQL Profiler to trace the slow running queries and tried to Optimize SQL queries to improve performance and availability.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized report, ad-Hoc and parameterized reports by using Oracle Grid, HPPM
• Worked to compare, diagnosis, export, import,monitor,optimize,report data, duplicates data, schema, objects, Top session by using Toad for oracle.

Environment: FACETS, Oracle12c,11g, Toad for oracle 12, SQL developer, Visual studio 2015, IBM WebSphere, UltraEdit, RedHat Linux, Putty, Java, Share point, XML,.NET framework, DMReader, Service Now, TriZetto, Citrix, Service Catalog.

MSBI DEVELOPER

Confidential - Baltimore, MD

Responsibilities:

• Actively participated in interaction with users, team lead, DBA's and technical manager to fully understand the requirements of the system.
• 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 Confidential 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 QlikViewobjects for ease of use by the users.

Environment: SQL Server 2012/2008/2005 , SSIS, SSRS,QlikView, Visual studio 2008, FACETS,MS Visio 2007,XML, VB.Net.

SQL Developer

Confidential

Responsibilities:

• Migrating data from Legacy system to SQL Server using SQL Server Integration Services 2012.
• Used C# scripts to map records.
• Involved in SSIS Package creation from package design documents, build package and also perform Unit testing of the SSIS extract by building validation packages to check the accuracy of the data migrated.
• 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 different sources like SQL server 2008, MS Excel, MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• Worked on database configurations and Accessibility.

Environment: MS SQL Server 2012, Confidential, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, Visual Studio 2012, Microsoft Office, Team Foundation Server (TFS), SharePoint, CloudBerry, AZCopy, Azure.

SQL Server Developer

Confidential - Philadelphia, PA

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), SQL Server 2005 DTS, MSAccess 2003, MS Excel 2003, VB.Net, OLEDB, Visio 2003, Microsoft Outlook 2003, Windows 2003 Server/XP.

SSAS/ETL/SSRS Developer

Confidential - Wayne, NJ

Responsibilities:

• Designed SSIS packages to Extract data from different sources like SQL server 2008R2, MS Excel, MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• 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.
• Developing reports on SSRS on SQL Server (2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2008.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Involved in dealing with off short team
• Created and modified Stored Procedures, Functions, and Indexes
• Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best practices to maintain optimal performance.
• Developed dependent, dynamic menu objects to allow end-users selection and data filtering capabilities.

Environment: MS SQL Server 2008 R2, Oracle 11g, Confidential, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, Visual Studio 2005, Erwin, and SQL Profiler, Actuate Report.