SUMMARY:

• Over 9+ years of experience in database development and support of SQL Server 2014/2012/2008/2005/2000 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 wif 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 noledge of Relational Database Management Systems.
• Experience and understanding of Logical and Physical database design.
• Extensive noledge in maintenance and optimization of Database and Server using SQL tools (SQL Profiler, Index Tuning Wizard Indexes).
• Having teh good noledge on Database.
• Experience in designing complex reports including sub reports and formulas wif 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 noledge 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 2014/2012/2008/2000/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

Database Utilities: MS DTS, MS Enterprise Manager, DB2, SQL Profiler, SQLserver Query AnalyzerIndex Analyzer, DTS Backup Server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SSRS.

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

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 EXPERIENCE:

Confidential, Rochester, NY

SQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked on SSIS/SSRS/SSAS 2014 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 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 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 wif different data sources (SQL Server, Flat Files, Excel source files etc.) and tan 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)
• Workingon 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 wif 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 wif error handling.
• Worked wif 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 wif Finance team, Business people, Third party vendors, Product Managers and gathered 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 dat describe all teh data and relationships between teh data using Erwin.
• Based on business requirement, developed teh Complex SQL queries wif Joins and T-SQL, Stored procedure, Views, Trigger to implementing teh business rules and transformations.
• Analyzed database performance wif 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 wif 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

Confidential

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• Responsible for creating teh reports based on teh requirements using SSRS 2005.
• Created detailed reports for teh customers to halp them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for teh managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing teh ETL operations.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined teh Datasets for teh report generation.
• Wrote teh queries for teh drill down reports.
• Identified and added teh report parameters.
• Uploaded reports on to teh report manager and organized them in folders.
• Built TEMPeffective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Deployed teh generated reports on to teh server.
• Fine-tuned teh database objects and server to ensure efficient data retrieval.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005, MS Excel, Window XP