We provide IT Staff Augmentation Services!

Senior Sql Developer/architect Resume

Reston, VA

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

Hire Now