SUMMARY

• Over 9 years of experience in database development and support of SQL Server 2016/2014/2012/2008/2005 in production and development environment.
• Expertise in MS SQL Server, SQL/TSQL, Cursors, Views, SQL Stored Procedures.
• Experience in MS SQL Server Installation, Configuration, Upgrading, Performance Tuning, Query Optimization, Backup/Recovery, Client/Server Connectivity and running Database Consistency Checks.
• Experience in data migration between homogenous system using DTS Packages, Bulk Insert.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Good experience on 845 and 835 documents.
• Experience in developing and deploying SSIS packages with Integration services.
• Experience in performing administrative functions including Memory Cache Utilization, Backup and Recovery, Database Security and Object Permissions.
• Experience in Normalization and building Referential Integrity.
• Experience in managing database objects like tables, views, stored procedures, roles, user defined data types and function.
• Extensive knowledge of Relational Database Management Systems.
• Experience and understanding of Logical and Physical database design.
• Extensive knowledge in maintenance and optimization of Database and Server using SQL tools (SQL Profiler, Index Tuning Wizard Indexes).
• Having teh good knowledge on Database.
• Experience in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services.
• Very well experienced in using teh FACTES Reporting databases and teh data related to teh claims, grievances, providers, members, patients etc.,
• Handled Regulatory and Operational FACTES Reports to teh state projects.
• TEMPHas an excellent knowledge of teh Healthcare domain working on various units like Claims, Grievances, HIPAA, Pharmacy, MEDICAID and MEDICARE etc.,
• Excellent team player and efficient in handling multiple project priorities.
• 24x7 support and trouble shoot production issues on high availability system.

TECHNICAL SKILLS

RDBM/DBMS: MS - SQL Server 2016/2014/2012/2008/2005 & 7.0, Oracle 10g, MS Access, MS Excel

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio 2005/2008/2012 , 2014,2016,2017

Database Utilities: MS DTS, MS Enterprise Manager, DB2, SQL Profiler, SQL server Query Analyzer, Index Analyzer, DTS Backup Server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SSRS, OLDB, ODBC.

Languages: Transact-SQL, PL/SQL, C/ C++, HTML, XML, Sybase, C, C++, PL/SQL, T/SQL, JAVA, Java Script, VB Script, Share Point

Reporting Tools: SSRS, Crystal Reports 10.0, ERWIN, Tableau 10.2, Power BI

Application Packages: MS Office, Microsoft Visio 2007

Testing Tools: Win Runner 7.6, QTP 8.2, SQA Robot, and Jira

Operating Systems: Windows 2012/2008/2003/2000/ XP/98/NT, Mac, UNIX, DOS

PROFESSIONAL EXPRIENCE

Confidential, Boston, MA

Responsibilities:

• Worked on Sql Server2014/2016 (SSIS, SSRS) 2012/2017.
• Work as part of technical team and involved in design, development of ETL packages, data warehouse architecture, reporting and BI solutions;
• Worked on different transformations in SSIS to load data from different data sources to different types of destinations (excel, csv, text, sql etc.,)
• Worked with different connections sql, excel, csv, access db etc.
• Load data from MS Access db to sql tables.
• Migrating data from 2000 to 2014 and 2014 to 2016 Sql servers.
• Creating Database, tables, views, store procedures etc.
• Scheduling jobs in SSIS through Sql server integration services.
• Subscribing SSRS reports through report manager.
• Design Reports on SQL SSRS as per teh client requirement.
• Created different types of reports like tabular, matrix, ad-hoc, Cache, Drill through and drill down reports.
• Created different types of Charts in SSRS bar, pyramid, funnel, map, pie, Range, Area, indicators, KPIs, dashboards etc.
• Design and develop solutions for managing data movement in, out of and between various data systems, platforms and file types;
• Responsible for developing and testing stored procedures, user defined functions, triggers, views;
• Created different reports in Tableau 10.2 bar, pie, parameter reports, dashboards etc.
• Other objects that assist in teh implementation of business rules/logic;
• Manipulating data to provide meaningful insight;
• Troubleshoot issues and tune at all layers: database, ETL, Reports and presentation;
• Work with Director of Application Systems to ensure successful transition of VRM project deliverables to production environment;
• Follow established business, technical and project policies and guidelines aligned with OSD, ANF and EOTSS principals and standards to include teh following: use of best practices, meeting management project plans, status reports and dashboards, risk and issue tracking, change requests and resource management.

Environment: SQL Server 2014/2016 SSRS/SSIS(2000,2012,2017), Visual basic, XML, MS Access, Excel, Share point, EXCEL, TABLEAU 10.2, POWER BI, MS Access db, OLDB, ODBC

Confidential, Rochester, NY

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked on SSIS/SSRS/SSAS 2014/2016 SQL Server Staging and Live.
• Worked on SQL database to create Cubes on SSAS from scratch.
• Worked on SQL queries using Left Joins Extract data for Stolen Vehicles.
• Created SSRS Reports by Designing, create parameters, creating Subscriptions.
• Worked on SSIS Packages using Sql Scripts, Execute Sql task, Slowly Changing Dimension, derived Columns, XML task etc.
• Worked on Problem Solving on CUBES and SSAS projects.
• Created Documentation for Change Control after teh Task is completed.
• Worked on existing SSIS Packages.
• Worked on SSIS Parameters.

Environment: SQL Server 2012/2014/2016 SSRS, SSIS, SSAS Cubes, Visual basic, XML, MS Access, Excel, Share point, JIRA

Confidential, Rochester, NY

SQL Developer (SSIS/SSRS)

Responsibilities:

• Working on store procedures, indexes and tables.
• Working on 2012/2014/2016 SSIS/SSRS for creating reports.
• Creating different type of reports including: A Sub report, Drill-down and Parameter prompts, Linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.) and then loaded teh data into destination tables by performing different kinds of transformations using SSIS packages. Used various Data Flow Transformations like Lookup, Union All, Multicast, Cache Transform, and Conditional Split while developing teh packages.
• Scheduling jobs for SSIS Packages as per client requirement like daily, monthly etc.
• Working on QNXT Reports(SSRS)
• Working on QNXT transformation for existing SQL Store Procedures and SQL Queries.
• Working on QNXT Front End.

Environment: SQL Server 2012/2014 SSRS,SSIS MDX, Visual basic, XML, MS Access, Excel, Share point, JIRA, GBD FACETS, RAMS, EXCEL, QNXT

Confidential, Virginia Beach, VA

MS SQL DEVELOPER (SSRS)

Responsibilities:

• Worked on synonyms, views, tables, stored procedures
• Worked on Optimization by using Common Expression Tables, Temp Tables, and Global Temp Tables.
• Worked on 2005/2008/2012 SSRS servers for creating and generating reports.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins.
• Worked on Subscriptions for Generating Reports to run.
• Designed and created reports in different formats such as Excel, PDF, HTML, and CSV using SQL Server 2005/2008/2012 Reporting servers (SSRS).
• Created different types of reports like tabular, matrix, ad-hoc, and drill down reports.
• Wrote queries for Matrix reports.
• Worked on Matrix reports for 2005/2008/2012 servers.
• Worked on converting teh oracle coding to SQL coding.
• Load providers: New Add Provider, Networks Add, Address Add, Term Provider, Add Provider Group RAMS.
• Analyzing data for Providers data through FACETS.

Environment: SQL Server 2005/2008,2012 SSRS, MDX, Visual basic, XML, MS Access, Excel, Share point, JIRA, GBD FACETS, RAMS, EXCEL, FACETS

Confidential, Baltimore, MD

SQL Server (SSIS/SSRS) Developer

Responsibilities:

• Actively participate in gathering System Specification Requirements for teh project
• Working on Writing scripts on different Projects like PCMH, Accounts Search Lighting
• Working on Designing teh Reports Using SSRS
• Work on Microsoft SQL (2012 & 2008&2005)
• Created databases and database objects tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions in SQL Server 2012/2008
• Designed and created reports in different formats such as Excel, PDF, HTML, and CSV using SQL Server 2008/2012 Reporting servers (SSRS).
• Work on Data migrations, Environment refresh activities
• Wrote queries for Matrix reports.
• Work on Share Point to run teh reports for Testing Purpose.
• Worked on Matrix reports for 2008/2012 servers
• Worked on converting teh oracle coding to SQL coding using Facets Database.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2008 Reporting Services (SSRS) and Crystal reports
• Developed data model based on teh BA’s and teh reporting Team using SSRS, SSIS
• Responsible for creating Tabular, Matrix and Drilldown Reports using SSRS
• Responsible for migrating DTS package to SSIS
• Monitor on share point and work on threshold issues.
• Created SSIS Packages to (ETL) Extract, Transform and Load teh data into Reporting instance to generate teh reports easily and quickly.
• Coordinate resources with work load and Client needs.
• Wrote teh queries for teh drill down reports, identifying and adding teh report parameters and uploading reports on to teh report manager and organized them in folders

Confidential, Baltimore, MD

SQL Server (SSIS/SSRS) Developer

Responsibilities:

• Installed and configured MS SQL Server 2012/2008 Enterprise Edition on Development server.
• Created databases and database objects tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions in SQL Server 2012/2008.
• Responsible for Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups and also used SQL Lite when necessary.
• Experience in migrating databases from SQL Server 2008 to SQL Server 2012.
• Developed data model based on teh BA’s and teh reporting Team using SSRS.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Involved in writing stored procedures, functions and created teh reports (SSRS).
• Responsible for creating Tabular, Matrix and Drilldown Reports using SSRS.
• Responsible for modification of Revenue reports, Finance reports, Commission reports, Broker pricing reports and other reports used by teh business and teh finance teams.
• Involved in transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services (DTS/SSIS).
• Responsible for migrating DTS packages to SSIS.
• Created SSIS packages to download data from FTP sites and populating into different databases and tables.
• Communicated with Finance team, Business people, Third party vendors, Product Managers and gatheird teh information for teh project requirements.

Environment: SQL Server 2012/2008, Transact-SQL, Visual Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Framework 2.0, C#, OLTP, OLAP, Erwin, Performance Point Server, Team Foundation Server, ASP.NET, VB.NET, ADO.NET, XML.

Confidential, Virginia Beach, VA

MS SQL DEVELOPER (SSRS)/ (SSIS)

Responsibilities:

• Worked on synonyms, views, tables, stored procedures
• Worked on 2005/2008/2012 SSRS servers for creating and generating reports.
• Created SSIS Packages to (ETL) Extract, Transform and Load teh data into Reporting instance to generate teh reports easily and quickly.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins.
• Designed and created reports in different formats such as Excel, PDF, HTML, and CSV using SQL Server 2005/2008/2012 Reporting servers (SSRS).
• Created different types of reports like tabular, matrix, ad-hoc, and drill down reports.
• Worked on Tidal reports for time scheduling to run teh reports monthly, quarterly.
• Wrote queries for Matrix reports.
• Worked on Matrix reports for 2005/2008/2012 servers.
• Worked on converting teh oracle coding to SQL coding.

Environment: SQL Server 2005/2008,2012 SSIS, SSRS, Visual basic, Guide wire, XML, MS Access, Excel, Share point, Crystal Reports

Confidential, Philadelphia, PA

MS SQL DEVELOPER (SSIS/SSRS)

Responsibilities:

• Performed migration of data from different database like MS Access, MS Excel to SQL server.
• Involved in designing reviewing, and creating primary objects like Tables, Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Developed different SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Created SSIS Packages to (ETL) Extract, Transform and Load teh data into Reporting instance to generate teh reports easily and quickly.
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel.
• Created different reports like tabular, matrix, ad-hoc, drill down and drill through reports using SSRS.
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2008 Reporting Services (SSRS) and Crystal reports.
• Wrote teh queries for teh drill down reports, identifying and adding teh report parameters and uploading reports on to teh report manager and organized them in folders.

Environment: SQL Server 2005/2008, SSIS, SSRS, Erwin, .Net Frame Work, Visual basic, XML, MS Access, Excel, Share point, Crystal Reports.

Confidential, North Brunswick, NJ

MS SQL Server BI Developer/DBA

Responsibilities:

• Performed Migration of SQL Server 2005 to SQL Server 2008.
• Generated Logical and Physical Data Models using Erwin.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions by writing complex queries and joins.
• Migrated Stored Procedures from 2005 to SQL Server 2008 to refer to Dynamic Management Views.
• Created and Deployed of Ad-hoc and Customized Reports to satisfy business needs using SSRS.
• Created SSIS Packages to (ETL) Extract, Transform and Load teh data into Reporting instance to generate teh reports easily and quickly.
• Used SQLCMD utility in command prompt to access SQL Server.
• Deployed teh SSIS Packages to teh MSDB as well as File System depending on teh requirements
• Maintained all teh SQL documents include installation and data conversion Procedure documents.
• Monitored Indexes, file growths and analyzed blocking & locking issues to remove teh performance bottlenecks

Environment: MSSQL Server 2005/2008, ER-WIN, windows 2003/2005 platform, T-SQL, Excel, Access, Crystal Reports 9.0 and Windows NT, DTS, SSIS, SSRS

Confidential

MS SQL Server Developer

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all teh data and relationships between teh data using Erwin.
• Based on business requirement, developed teh Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing teh business rules and transformations.
• Analyzed database performance with SQL Profiler and Optimized indexes to improve query performance.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Extracted teh data from Flat Files, Transformed (Implemented required Business Logic) and Loaded into teh target Data warehouse using SSIS (SQL Server 2005)
• Involved in teh Migration of Databases from SQL Server 2000 to SQL Server 2008.
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2008 database
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS) and Crystal reports.

Environment: SQL Server 2005/2008, SSIS,SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, Share point (MOSS), ASP .Net, Crystal Reports, ER Studio, Performance point Server