PROFESSIONAL SUMMARY:

• About 15+ Years of strong experience in working with Tables, Views, Stored procedures, index, T - SQL using SQL Server 2016/2014/2012/2008/2005
• Experience in leading several database projects in healthcare industries
• Always ready to learn new technology like spark, python, big data
• Expertise in finalizing business requirements gathering by working with stakeholders
• Comfortable working with source control, data collection, status reporting and project tracking product like Team Foundation Server
• Good knowledge of Agile methodology
• Specialists in front end reporting for SQL Server environments utilizing various reporting methodologies and tools to maximize performance and meet user requirements
• Good working experience in Microsoft Management Studio
• Designing and documentation of SQL Server Development strategies and requirements
• Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Informatica, Azure
• Solid experience in working with large databases and designing of data warehouse and data mart
• Identifying the performance bottlenecks in the database environment and organize the team meetings with DBA staff and explaining the application design and thus improving the outcomes of query performance
• Solid Data moving strategies across the organization using latest enterprise integration tools like SSIS and Import/Export wizard.
• Proficient in generating reports using Microsoft SSRS
• 24x7 support and trouble shoot production issues on high availability system.
• Excellent Verbal, Written Communication skills
• A well-organized, goal-oriented, highly-motivated effective team member with excellent analytical, troubleshooting, and problem solving skills

TECHNICAL SKILLS:

Databases: MS-SQL 2016/2014/2012/2008/2005

Development Tools: SQL Server Management Studio, Visual Studio

Reporting Tools: Microsoft SSRS 2014/2008/2005

Languages: SQL, PL/SQL, .net, C#

Operating System: Windows Server XP/2003/2000

ETL Tools: Microsoft SSIS 2014/2016, Azure Pipeline, Informatica

Productivity Tools: Microsoft office

Other Tools: Databricks, Salesforce

PROFESSIONAL EXPERIENCE:

Lead BI/ETL Developer/Scrum Master

Confidential, Durham, NC

Responsibilities:

• Currently designing database structure and working on azure data factory/pipeline for our new product launch.
• Responsible for maintaining existing data exports for our different clients.
• Responsible for providing data export to clients who are leaving us currently.
• Full stack developer for our team.
• Working on database migration/load for our new 2.0 product while supporting 1.0 issues reported by client.
• Performed scrum master’s duties such as daily standup, sprint planning, release planning, demo and retro.
• Participate in designing of data mart for EHR team.
• Successfully implemented TFS database project for my team as there was no source control before I joined.
• Standardized several process for our team.
• Defined database standards for team that each team member has to follow during product development cycle.
• Responsible for each production release.
• Responsible for creating/changing objects including stored procedures, views, tables, indexes etc to support our existing product.
• Responsible to support web developers and lead junior database developers.
• Rewrote existing month end reports to improve performance including query tuning and index optimization.
• Worked on ETL process and SSRS reports to support client needs.

Lead SQL Server Developer/Consultant

Confidential, Raleigh, NC

Responsibilities:

• Leading my team of four to implement existing automated process.
• Working closely with business to gather requirement and understand client’s needs.
• Providing weekly status to upper management.
• Created design documents and different SQL objects including tables, views, functions and stored procedures.
• Created SSIS packages and scheduled jobs to automate process.
• Participated in my team’s code reviews.
• Troubleshot existing issues in the system and fixed those bugs.
• Delivered my team’s project on time.

Senior SQL Server Developer/Consultant

Confidential, Charlotte, NC

Responsibilities:

• Involved in migration from old CCAR system to new CCAR system including SQL objects like tables, views, functions, stored procedures.
• Responsible to automate new CCAR system as much as possible including creating SSIS packages and jobs.
• Responsible for performance tuning of new CCAR system after implementation.
• Support and lead junior developers and provide status update on their work to upper management.

Senior SQL Server/ETL Developer

Confidential, Charlotte, NC

Responsibilities:

• Involved in various stages of project like scope and requirement gatherings, development, support QA group and support application after production install.
• Responsible for on-call schedule to support production issues and troubleshot application failures.
• Developed complex Informatica, and supporting SQL objects (stored procedures, tables, views, and functions) to fulfill business needs.
• Led off-shore team members and new team members on projects.
• Responsible for documentation of each process that I have designed.
• Managed multiple projects at same time.
• Provided quality work and efficiency.
• Worked at fast paced and intense pressure environment.

Senior SQL Server Developer

Confidential, Morrisville, NC

Responsibilities:

• Worked with Outcomes Research group to create ad-hoc reports each month for clients
• Using Import/Export wizard move client data to warehouse each month
• Worked on client reports using SSRS
• Experienced in working with Team Foundation Server
• Worked on project to fix warehouse issue like removing of duplication of rows, creating indexes, identity columns and changing data type of columns
• Worked on large standardization projects during release of new drug classes by clinical group
• Involved in creating new stored procedures, tables and release documents for couple of releases
• Involved in bug fixing and optimization of stored procedures for few small projects
• Involved in session of Agile methodology held by company to aware IT staff about Agile process

SSRS and SQL Server Developer

Confidential, VA

Responsibilities:

• Optimizing Database Queries for performance enhancements
• Used SQL Server SSIS to transfer data into and out of staging tables
• Design and implement database Schemas
• Creation of database diagrams
• Interacting with the users and troubleshooting the problems involved with the development of Stored Procedures, and triggers.
• Developed reporting methodology, implemented standardization for reporting, coordinates testing and Change Management for all products produced and supported by the Data Warehouse
• Defined quality assurance policies and procedures in conjunction with the Data Intelligence Group
• Facilitate and organize tasks and projects to maximize productivity
• Assisted in testing and through launch
• Maintained day-to-day production support thereafter

SQL Server Developer

Confidential, Newport Beach, CA

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database
• Created reports from database onto excel spread sheet using DTS
• Wrote complex stored procedures to process employees’ requirement and generating records between front End and back end
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database Optimization
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Created Users and Roles, and managed security and permission of database
• Checks, Update Database Statistics and Re-indexing