SUMMARY:

• 10+ years of experience in Analysis, Design, Implementation of Business Applications using SQL Server
• Proven ability to plan, coordinate and implement Full Life Cycle software development and maintenance projects.
• Excellent experience in SQL server Programming.
• Expert in developing stored procedures, Views, UDFs, Triggers, Performance Monitoring.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Worked with Database Administration for Backup & Recovery, Production Support.
• Transformed data from various data sources using OLE DB / MS Access connection by creating various SSIS/DTS packages.
• Created Reports with complex formulas and query the database for Business Intelligence.
• Good Business and System analysis skills to understand the requirements for the client applications.
• Excellent Experience in .NET Platform Technologies in Web Forms using ASP.NET, C#, Web Services.
• Able to work in an aggressive and demanding project schedule and environment.
• Excellent communication skills, experienced in interacting with the client providing technical support and knowledge transfer.
• Strong educational background, High Motivated team player, fast learner, and excellent communication skills.

TECHNICAL SKILLS:

RDBMS: SQL Server 2012/2008, MS Access

Languages: T - SQL, C#, ASP.NET, ADO.NET, Web Services

Tools: SQL Server Management Studio, Business Intelligence Studio, Visual Studio, Enterprise Manager

Reporting Tools: SSRS 2010/2008, Crystal Reports XI/10

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Senior SQL Developer/Architect

Responsibilities:

• Work closely with center for Medicare & Medicaid Services (CMS) to verify enrollment information.
• Was involved in re-designing the Clearing Database from version 2 to version 3.
• Create scripts for Data Migration from V2 to V3.
• Create SSIS Packages to load files received from CMS to SQL Server database
• Create automation processes to bulk load data for MARCO and TIPS systems.
• Mentor other developers on the team with best practices.
• Develop reports and automate to go out in monthly/weekly schedule.

Confidential, Long Island, NY

Senior SQL Developer

Responsibilities:

• Architect and design the database to accommodate new requirements.
• Communicate with end users to gather requirements.
• Convert complex workflows into database structures tables, views, stored procedures.
• De-normalize All Scripts Sunrise Clinical Manager tables to flattened tables.
• Developed SSRS reports using Inpatient, AEHR systems for assisting different departments to better streamline the process.
• Created Self Service tool for ED department using SSRS report model.
• Create ETLs to load data from Sunrise Clinical Manager.
• Schedule and Monitor ETL on SQL Server.
• Develop Stored Procedures, view, user defined functions
• Perform DBA activities/monitoring the databases.
• Performance tune the SQL queries using Execution Plans, Profiler.
• Develop custom SSIS packages/SSRS reports.
• Used Agile Development Methodology (Sprints, User Stories).
• Use Team Foundation Server for version control
• Customize the web application and perform application configuration.
• Involved in upgrading sunrise clinical analytics application from version 5.5 to version 11 and to version 12.0
• Install SolaSphere HotFixes needed for web application.

Environment: All scripts SCM 6.1, AHER, EMR, SQL Server 2012, Embercadero, BIDS, Data Tools, SSRS, SSIS, C#, ASP.net, .NET 3.5

Confidential, Long Island, NY

Senior SQL Developer

Responsibilities:

• Architect and design the SQL server database to meet the requirements.
• Participate in meetings with the users to gather the requirements and help design/create processes.
• Perform Database Administration Activities (i.e. Create Tables, Stored Procedures, Granting User Access, Functions, performance tuning).
• Assist other developers in solving database related issues & tasks.
• Create Database start-up, shutdown, IIS restart scripts.
• Create complex queries to pull daily information from other systems and schedule jobs using SQL Server Agent.
• Design Backup strategies to clients for their database depending on the needs.
• Using Linked Server to connect to Oracle database, remote servers.
• Provide Database recovery support.
• Resource monitoring, free up locking queries during heavy transactions in the database.
• Restoring and recovering Databases from backup.
• Database Change Control using Tortoise SVN.
• Develop SSIS Packages to load the Flat files received from the Bank to Migration Database.
• Write SQL queries, stored procedures to query data from sales force system.
• Performance monitoring and tuning for production databases.
• Create complex SSRS reports for monitoring conversion progress.
• Integrate reports to front end website using .net technology.
• Developed website using .net application (.net 3.5, Ajax, JQuery) to support the conversion process.
• Used Application blocks with Microsoft Enterprise Library.

Environment: SQL Server 2008/2005, Management Studio, SSRS, SSIS, BIDS, .Net 3.5, ASP.Net, ADO.Net

Confidential, Blue Bell, PA

Senior SQL Developer/Administrator

Responsibilities:

• Involve in meetings with the users and gather requirements.
• Built complex queries and stored procedures using T-SQL.
• Created SQL procedures and functions to migrate data between different servers.
• Worked in Production Support Environment as well as QA /TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Managing logins, roles, assigning permissions.
• Performance tuning of Databases and User applications.
• Provided user training and production support.
• Proactively resolved technical issues pertaining to production.
• Improved the performance of the application by rewriting the SQL queries.
• Coordinate with the Team about the database related issues & tasks.
• Involved in creating reports using crystal reports.
• Scheduled reports to go out periodically as per the user needs.
• Created tabular, bar chart reports.
• Developed SSIS Packages to load data from flat files to the Database.
• Extensively used Telerik controls throughout the application.
• Used DTOs to store and transfer data.
• Used JQuery, Ajax for rich client side interactivity.
• Created CLR procedures for better application performance.
• Consumed web services to gather clinical data from third party systems.

Environment: SQL Server 2008/2005, Management Studio, SSRS, SSIS, BIDS, .Net, ASP.Net, ADO.Net, C#, Telerik

Confidential, New York, NY

Database Developer

Responsibilities:

• Designed and implemented the front end interface using C#.net, asp.net, JavaScript.
• Defined and created Physical design of the database based on the given User Requirements.
• Actively involved in Normalization and De-normalization of the database.
• Create migration scripts to load data from legacy system to the Current system.
• Created and executed the test plans.
• Involved in designing and implementing the audit log mechanism.
• Taking periodic backup of databases and restoring them.
• Tuned the performance of sql queries using execution plans and sql profiler.
• Created SSIS packages to generate monthly and daily reports and used file system deployment to deploy the packages across different environments.
• Created SSIS packages to load data from flat files to sql server.
• Transformed data from various data sources using ODBC connection by creating SSIS packages
• Created the Front end report selection interface using .net framework.
• Involved in creating the stored procedures, views required for generating the reports.
• Installed and configured SQL Server Reporting Services on various environments (dev, test, production)
• Generating Ad-hoc Reports using SQL Server Reporting Services (SSRS) for online quotes application
• Developed complex reports by passing Multiple Parameters
• Used Common Table expressions in writing sql queries.
• Used Server Side and Client validation for the .net pages.
• Created user controls to gather MVA, IIL, Close Call info.
• Created Master pages and content pages to have consistent look.
• Consumed Web Services to obtain site, vehicle information.
• Used Application blocks with Microsoft Enterprise Library.

Environment: SQL Server 2005, SQL Server Management Studio, T-SQL, Crystal Reports XI, SSRS, C# asp.net, BIDS, Report Manager, SSIS/DTS packages, Visual Source Safe.

Confidential, Conshohocken, PA

Database Developer

Responsibilities:

• Create System Design Specifications, User Requirement Documents, And Functional Requirement Documents.
• Created high-level technical documentation to set standards, guidelines and best practices for writing SQL queries, User Defined Functions, SSIS Packages.
• Provide High-level disaster recovery plan during the production phase.
• Actively involved in Normalization & De-normalization of database.
• Wrote Views, Stored Procedures, and Triggers to transform data from different sources.
• Wrote SQL Stored procedures to process clinical data and generate validation error files, schedule the stored procedures to run on a daily and monthly basis.
• Created and scheduled SSIS packages to upload data from text files into the SQL Server database.
• Performed Database backups (operating system, flat file backups & export/import).
• Tuned SQL statements and Stored Procedures.
• Coded Procedures & User defined Functions in T-SQL.
• Taking periodic backup of databases and restoring them.
• Creating database tables, indexes and rules.
• Worked in a Team on SQL Server 2000 Application Development.
• Loaded data from MS Access, MS Excel, Text, and CVS into SQL Server 2000.
• Used JavaScript to perform the client side validation.
• SourceSafe is being used to for version control of the source code.
• Created various reports using Crystal Reports XI, Business Objects XI.
• Ensured Server & Application performance tuning and optimization.
• Assisted the Application team in data modeling and T-SQL coding.
• Created packages using SSIS for moving data from MS Access, MS Excel, Text, and CVS to SQL Server 2000.
• Involved in System testing.
• Created and executed the test plans.
• Used ADO.NET objects to manipulate oracle database.
• JavaScript, asp.net validation controls are used to validate the asp.net pages.
• Used C# to write the code behind ASP.NET pages

Environment: SQL Server, Visual Studio 2005, .NET Framework 2.0, C#.Net, Oracle 9i, ASP.Net, Web Services, SOAP, WSDL, Java Script, Visio, ADO.NET

Confidential, Ardmore, PA

Database Developer

Responsibilities:

• Developed Physical design of the database based on the given User Requirements.
• Created SQL Triggers and Stored Procedures to retrieve updated and deleted data from different servers.
• Created DTS packages for the extracting, transforming and loading the data from CSV, text files and different database servers.
• Creating database, tables, indexes and rules.
• Monitor replication process to pump the data into various database servers.
• Create Linked Server connections to connect to Oracle Database.
• Configured data mapping between different Databases.
• Performed Database backups and Restoration (operating system, flat file backups & export/import).
• Created and Scheduled Various SQL Jobs using SQL Server Agent to perform various Administrative tasks.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Used Query Analyzer, SQL Profiler to optimize SQL Queries.
• Loaded data from Flat files (.txt) into SQL Server 2000.
• Developed & executed several Optimized queries in SQL.
• Tested and compared Performance & Accuracy related queries under SQL Server SQL Server 2000.
• Ensured Server & Application performance tuning and optimization.
• Translating business requirements into technical design specifications.
• Prepared high-level documentation for the Database Design, Database objects Security and Rules.

Environment: SQL Server 2000, Enterprise Manager, Query Analyzer, T-SQL, C#.Net, ASP.net, Java Script, SourceSafe