SUMMARY:

• Over 14+ years IT experience with 10+ years of Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005, 2000 in Production, Test, Development
• Experience in Application domain knowledge in Insurance, Financial, Telephone - Cellular, Marine, Software, Manufacturing, Educational, Service, Tours & Travel industries.
• Experience in installation, configuration of MS SQL Server 2000, 2005, 2008, 2012
• Knowledge of Relational Database Management systems.
• Experience in Database Backup, Recovery and Disaster Recovery procedures
• Managing Projects, Deliver the Project within the Deadline as per SLA, managing on-site/off-shore model
• Recruiting appropriate resources for the Team / Resource management
• Experience working for enterprise level companies with more than 50000 employees
• Experience with SSIS, Data Transformation Services, Batch processes, Import/Export and Backup/Restore.
• Manual Testing, and Functionality Testing
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Experience in supporting Large Databases.
• Hands on experience in Troubleshooting database issues.
• Good Knowledge working with Facts, Dimensions.
• Experience in writing and debugging Stored Procedures and triggers using T-SQL queries.
• Experience in Data Modeling using Erwin Design Tool
• Knowledge of Networking Concepts and Object Modeling Technology.
• Good interpersonal, Analytical and Communication skills and a team player
• Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.
• Experience working in VMWare Virtual Environment ESX 2.x, 3.x
• Install and Configure SQL Server 2005 on Virtual Machines

TECHNICAL SKILLS:

Languages: VB6, SQL, Web Services, C, C++, Java, Perl

Operating Systems: Windows (2012, 2008, 2003, XP, Windows 10), VMWare - ESX

Databases: MS SQL Server (2012,2008, 2005, 2000), DTS, SSIS

Reporting: SQL Server Reporting Services

Tools: SQL, Erwin, TOAD, T-Sql, TFS, ClearCase, Notion TimeSheet

PROFESSIONAL EXPERIENCE:

Confidential, Arlington VA

Sr. SQL Server Developer

• Evolent Healthcare providing value based care by partnering with Health systems across nation.Clients includes Medicare, Medicaid, several TPAs(Third Party Administrators), healthcare provides.
• As as Sr. SQL Server Developer, need to adhere with HIPAA policies and rules while delivering best solutions to clientle, in Agile Project delivery methodology. The project is to bring User Assessment Data (Member / Patient) belongs to different kinds of Assessments, clients into a common format and load the data into IDENTIFI front end database, which can be used by CM (Care Managers) when providing Patient level service. The Assessment data was finally used by Rules Engine to calculate RAF (Risk Adjustment Factor), which will be used to rank Member or Patient, depending on the Risk score, to provide more value based services, both to Member and Physician.
• Closely work with Product Owner, Business Analysts to get various pieces of requirements Integrate EPIC Electronic Medical Records with eDW Attend Stand-ups to provide day-day status to Scrum Master, and other team members; SoS
• (Scrum of Scrums) to discuss cross team dependancies; Grooming sessions to manage work in deliverable PBI (Product Backlog Items) and Tasks.
• Writing Stored Procedures, Functions using TSQL; Design / Create database Objects ETL (Extract / Transform / Load) using SSIS. Event Handling, Logging, Configuring SSIS packages.
• Work with Member, Observation, Eligibility, Claim Datamarts, EDW github - Open Source Source Code Management

Environment: SQL Server 2012, T-SQL and SSIS, TFS for version controlling, Orion Rhapsody tool, .NET

Confidential,Herndon,VA

Senior Database Developer

• Amdocs providing solutions to optimize Cellular Networks for its clientele spread across different regions of globe.As a Senior Database Developer, had to perform tasks that require a high amount of technical expertise and experience by creating innovative solutions which meets the business requirements for COPS-SON tool set which was used in Radio Access Networks.
• COPS-SON is an intelligent and dynamic closed-loop system for self-organising networks (SON). COPS-SON is designed to continuously configure, optimise and self-heal mobile networks, ensuring that radio performance always remains at the optimum level and that the best possible end-user experience is achieved. It uses network-proven optimisation techniques to provide the most efficient and cost-effective self-optimising solution available to operators today.
• Perform capacity planning, database backup, restoration and optimization.
• Write T-SQL, Stored procedures, functions, CTEs, SQL Queries and review codes to enhance software solutions from the development to production.
• Import, Aggregate, provide Reporting Data for CM (Configuration Management and PM
• (Performance Management) counters originating at OSS (operational sourcing syste
• Requirements gathering, analysis, develop technical solution and implementation.
• Architect and implement Solutions to meet the current and projected future needs.
• Production Support, fix issues in production.
• Full SDLC - Agile Development Methodology - Modified waterfall method

Environment: Teradata 13, SQL Server 2005, Essbase for Excel

Confidential,Jersey City, NJ

SQL Server Developer

• SQL Server Developer - Data Loading into staging database from various Excel files, databases, so that, later processes consume staging data to load Star Schema - Dimensions and Facts.
• Data cleansing, adjusting existing staging tables to accommodate incoming data changes.
• Set up, schedule processes common shares across systems for data exports / imports from legacy sourcing systems into destination database.
• Source controlling using Microsoft Cloud TFS. Design/Create/Deploy SSIS packages for data loading using SQL Server 2012. ETL - Extraction, Transformation, Loading.

Environment: SQL Server 2012, Excel 2013, Microsoft Cloud TFS

Confidential, Charlotte, NC / Richmond, VA

SQL Server ETL Consultant

• Worked as SQL Server / ETL developer using SQL Server 2008 R2 for WITI - PMUWS Project.
• Developed and Managed Database for WITI - Wholesale IT Intelligence
• Wrote Triggers, Stored Procedures, Functions, TSQL.
• Created / Managed Table Indexes, Query Tuning
• Performed Defect tracking and closing by using HP Quality Center
• Designed and Deployed new SSIS Packages, Change existing SSIS Packages
• Created SSIS Packages, Configured SSIS packages for different environments using dtsconfig XML file
• Produced CSV, utilize CSV files as part of ETL Process
• Changed existing mappings as of new Dash Board requirements, Add newdata elements to existing mappings
• Source - Staging - End CSV file generation mapping
• SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
• Responsible for Code deployments / configurations/ config management in various environments
• Extract-Transform-Load data into SQL Server 2008 R2 database from various sources
• Scheduled SSIS packages using Autosys
• Understanding old mappings from retiring PlanView Oracle database, implement same and additional mappings using SQL Server 2008 R2 -PMUWS (Project Management Universal Work Station)
• Enhanced existing applications to meet new business requirements
• UAT / Production Support
• Enhanced existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
• Deployed the code in various environments i.e. DEV/SIT/UAT
• Created and maintained DB Change Log to track the state of the DB in each environment(Dev, Test, UAT, Pre-Prod)

Environemnt: SQL Server 2008 R2, VB.NET, Oracle 11g, Autosys, Share Point, SQL Server 2008 R2 Integration Services, Quality Center 10.0

Confidential, Herndon,VA

SQL Server Consultant

• Worked as SQL Server Consultant using SQL Server 2008 for CMH Project.
• Source Controling using IBM Rational ClearCase
• Developed and Managed Database for Collateral Management and Hedging
• Wrote Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL
• Created and maintained Physical Structures.
• Worked with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Created / Managed Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
• Defect tracking and closing by using HP Quality Center
• Agile - Weekly Sprints / releases - CRs
• Designed and Deployed SSIS Packages
• Created SSIS Packages, Configure SSIS packages for different environments using dtsconfig
• Produced CSV, utilize CSV files as part of ETL Process
• Produced XML Files for Tibco (Real Time Data Transfer)
• SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
• Responsible for Code deployments / configurations/ config management in various environments
• Create and Maintain Interface Control Documents (ICD)
• Implemented Security, Roles, Logins, and Permissions
• Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources
• Maintained Users / Roles / Permissions, Security
• Scheduling SSIS packages using Autosys, writing JIL Scripts
• Enhanced existing applications to meet new business requirements
• L3 Production Support on Rotation basis
• Enhanced existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
• Capacity Planning DBs, Disk Requirements
• Deployed the code in various environments i.e. DEV/SIT/UAT
• Created and maintained DB Change Log to track the state of the DB in each environment(Dev, Test, UAT, Pre-Prod)

Environemnt: SQL Server 2008, VB.NET, Oracle 10g, Sybase, Clear Case 7.1, Autosys, Share Point, SQL Server 2008 Integration Services, Quality Center 10.0, Compass Point

Confidential, Glen Allen,VA

SQL Server Developer / DBA

• Worked as SQL Server Developer / DBA using SQL Server 2008 for Atlas Data warehousing Project.
• Managed and update the Erwin models - Logical/Physical Data Modeling for Conslidated Data Store (CDS),
• Actuarial Data Mart (ADM), ReferenceDB according to the user requirements.
• Source Controling, environment specific script deployment tracking using TFS
• Exported the current Data Models into PDF out of Erwin and publish them on to Sharepoint for various users.
• Developed, Administered, and Managed corresponding databases: Consolidated Data Store, Reference
• Database (Source for the Code/Values of the Legacy Source Systems), and Actuarial Data Mart
• Wrote Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL) queries.
• Created and maintained Physical Structures.
• Worked with Dynamic Management Views, System Views for Indexing and other Performance Problems
• Analyzed the Legacy Data, Import the data into ReferenceDB that was verified and published by DMRB (Data Management Review Board)
• Liaision with ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.
• Day to Day maintenance of DBs, Staging, Backup / Restores of DBs.
• Deployed Scripts in different environments according to Configuration Management, Playbook requirements
• Created / Managed Files/Filegroup - Table/Index association
• Query Tuning, Performance Tuning
• Defect tracking and closing by using HP Quality Center
• Maintained Users / Roles / Permissions.
• Capacity Planning DBs, Disk Requirements
• Created Range and Hash(by using MOD function) Table Partitioning, Index management
• Created and maintained DB Change Log to track the state of the DB in each environment(Dev, UAT, T02, T03, Conversion, Pre-Prod, etc.)

Environemnt: SQL Server 2008, Team Foundation Server, Erwin 7.3, ModelMart 7.3, Share Point Server, Informatica 8.6, Cognos, Quality Center

Confidential, Glen Allen,VA

Lead SQL Server Developer/DBA, SQL Server 2005 Reporting Services, Integration Services

• Generated Dash Board Reports for Internal Users using SQL Server 2005 Reporting Services and Dundas Reporting
• Performed Application Testing, Debugging SIT, UAT, Test Clusters, Test Load Balancers
• App Testing in Dev, Production, DR
• UML Use Case diagrams, Conceptual Flow Diagrams, ER Diagrams by reverse engineering the databases using Visio 2003 for Datawarehouse
• Deployed various reports on SQL Server 2005 Reporting Server
• Responsible for Tuning the Databases, Auditing, Dynamic Management Views
• Database Capacity Planning, Maintenance Plans, Backup, Restore
• Data Modeling, Conceptual/Logical/Physical Modeling
• Created and maintained database for Incident, Problem Tracking, Metrics
• Worked with Sql, and Transact Sql (TSQL)
• Designed Reports as of Internal User needs
• Accessed SharePoint Server using Web Services to deploy reports on Reporting Server
• Worked with Stored Procedures, functions, triggers, Views
• Involved in creating tables, stored procedures, indexes
• Created and Maintained users
• Created/ Ran jobs with SSIS packages
• Designed, Created and Deployed various SSIS Packages (for ETL - Extraction, Transformation, Loading)
• Configured the Database Mail, Mail Operators using SQL Server 2005
• Created Jobs, Job Notifications
• General Day to Day Database Administration
• Imported Data from various sources like DB2, Oracle, Excel, XML
• Ensured Data Consistency, Analyzing the Data
• Detailed Documentation of all the existing and new processes, Created and Updated Data Dictionaries
• Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions

Environment: SQL Server 2005, SharePoint 2007, .NET, Windows XP, Excel, XML, DB2, Oracle, Reporting Services(SSRS), Integration Services, Dundas Reporting, Dash Boards

Confidential, Richmond, VA

SQL Server Developer / DBA / Data Analyst

• Created and maintained database for Server Inventory, Performance Inventory
• Worked with Sql, and T-Sql, VBA
• Involved in creating tables, stored procedures, indexes
• Created and Maintained users
• Designed and Deploy database structures for DataWarehouse
• Created / Ran jobs with SSIS packages
• Designed, Developed, Deployed SSIS Packages with WMI Queries
• Imported Data from various sources like Excel, SQL Server, Frontbase
• Collected Server Inventory data from users using InfoPath 2003/2007 into SQL Server 2005
• Created Linked Servers to other ODBC databases like Frontbase, and import data using Linked Servers
• Ensured Data Consistency, Analyzing the Data
• Generated Dash Board Reports for Internal Users using Sql Server 2005 Reporting Services
• Backing up the Database
• Rack/Stack HP Proliant Servers, installing base operating system
• Published PDF Reports obtained from Report Server on to Sharepoint Portal
• Deployed various reports on SQL Server 2005 Reporting Server
• Designed Reports as of User Requirements
• Involved in migrating servers i.e. physical to virtual, virtual to virtual
• Installed and Configured SQL Server 2005 on Virtual Machines
• Migrated hundreds of Physical Machines to Virtual Machines (P2V) by using VM Converter, P2V Assistant, Ghost and Virtual Machines (2.x) to Virtual Machines (3.x) - V2V by using ESX Migrator
• Conducted System Testing and functionality after virtualization
• Monitored the migrated System for next 48 hrs.
• Closely worked with UAT team

Environment: SQL Server 2005, Windows 2000, 2003 Server, MS Access, Excel, Frontbase, InfoPath 2003/2007, ESX 2.X, 3.X, SSIS, Reporting Services (SSRS)