SUMMARY

• 5+ years of experience in IT industry with firsthand knowledge of all facets of Software Development Lifecycle (SDLC) including requirements gathering, analysis, design, development, reporting, testing, implementation, and post implementation support.
• Knowledge in Computer Architecture, Networking, Client/Server Environments, Web Applications, OLTP Systems.
• Proficient in Relational Database Management Systems (RDBMS).
• Extensive Experience in SQL Server 2012/2014/2016 Database Creating Database Objects, Procedures and Functions
• Expertise in Transact - SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.
• Expertise in creating packages using SQL Server Integration Services (SSIS)
• Experience in implementing business logic using Stored procedures, Functions and Views
• Good interaction skills with developers, managers and team members to coordinate job tasks.
• Extensive experience in partnering with supporting roles such as architects, data modelers, technical leads & multiple vendors to ensure that requirements are feasible and in alignment with corporate standards and long-term strategy
• Experience in System Testing, UAT Support, Production Support and Maintenance Services.
• Experience in Configuration Management tools like Team Foundation Server
• Good communication / interpersonal skills, excellent ability to communicate ideas, issues and proposed solutions to both business and technology clientele.

TECHNICAL SKILLS

Languages: C, C#, Java, HTML, XML

Testing Tools: HP Quality Center

Databases: Microsoft SQL Server 2008/2012/2014/2016 , Oracle 11g

Web Technologies: ASP.Net, .Net, .Net 3.5/4.0/4.5, Java

Operating System: Windows Server 2008/2012

Version Control Tools: Microsoft Team Foundation Server

Other Tools: SQL Developer, HP Service Center, Microsoft Visual Studio 2010//2013/2015 SQL Server Integration Services, SQL Server Data Tools, Microsoft Visio, Microsoft Office Suite, SQL Server Reporting Services

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Server Developer/Analyst

Responsibilities:

• Created new tables, stored procedures, user defined functions, triggers for Application Developers
• Involved in performing data conversions from flat files into a normalized database structure.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Worked extensively in writing complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Deployment of database changes and database objects using T-SQL (stored procedures, functions, triggers, executing SQL scripts) in UAT
• Programming SSIS packages using SQL Server Data Tools
• Created SSIS packages using Look up, Derived Column, Conditional Split, Multicast and Data Conversion.
• Minor enhancements to SSIS packages in MeDB to support new requirements
• Tracked trouble ticket request for request made by end users
• Documenting System requirements using standard templates
• Assisted development & testing teams in Integration Testing

Environment: SQL Server 2014/2016, MVS, COBOL, DB2, CICS, JCL, VSAM, .Net, Requisite Pro, Harvest, HP Service Center, .Net 4.5, HP Quality Center, IIS 6.0/7.5, Visual Studio 2012/2015

Confidential, Boston,MA

SQL Server Developer

Responsibilities:

• Worked closely with Application Development Team and assisted in database object design
• Successfully developed and delivered several database projects for eBooks application enhancements
• Created stored procedures to be used with the UI for DML operations.
• Maintained existing stored procedures that are called from the Exceptions Queue & Asset Events module.
• Created User Defined Functions for eReportal application
• Created test data to unit test the functionality of newly created database objects.
• Created new stored procedures, views to implement new functionality for Client Books application team.
• Worked closely with testing team and helped the team in creating test data
• Worked with Reporting team to identify datasets for reports and created stored procedures for the team to retrieve the data.
• Creation of SSIS packages to perform the data warehouse load for the Asset Data Services load process
• Created SSIS packages using Look up, Derived Column, Conditional Split
• Deployment of SSIS packages using file-system deployment & SQL Server deployment

Environment: SQL Server 2014/2012, .Net 4.0, T-SQL, SQL Server Reporting Services, IIS 7.5, Windows Server 2010/2012, Microsoft Visio, Microsoft TFS, Microsoft BI Development Studio/ SQL Server Data Tools, WCF services.

Confidential, New York, NY

SQL Developer

Responsibilities:

• Creation of stored procedures using T-SQL to support ad-hoc reports created in Underwriting application
• Created databases and schema objects including tables, indexes and applied constraints to support the Billing module
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Extensively used Joins and sub-queries for complex queries involving multiple tables
• Created views to restrict access to data in a table for security.
• Developed stored procedures, functions, views and triggers.
• Developed SSIS packages to perform the data warehouse load for the Reinstatement module
• Developed source to target specifications.
• Created test data to unit test the functionality of newly created database objects.
• Created new stored procedures, views to implement new functionality for the internal billing application.
• Worked closely with test team and helped the team in creating test data
• Worked with Reporting team to identify datasets for reports and created stored procedures for the team to retrieve the data.

Environment: SQL Server 20008, .Net 4.0, T-SQL, IIS 7.5, Windows Server 2010, Microsoft TFS, Business Intelligence Development Studio, WCF services

Confidential

SQL Server Developer/Analyst

Responsibilities:

• Created new tables, stored procedures, user defined functions, triggers for Application Developers.
• Design, Development and Testing of database routines
• Minor enhancements to SQL procedures and functions in the Logistics module
• Involved in performing data conversions from flat files into a normalized database structure
• Followed up with business analysts to clarify and document requirements.
• Worked extensively in creating stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions
• Extracted and collected data to create needed reports
• Analyzing different user requirements and coming up with specifications for the various database applications
• Programming SSIS packages using SQL Server Business Intelligence Studio
• Diagnosed and addressed operational data requests
• Performed analysis and presented results using SQL, SSIS, MS Access, Excel
• Obtained and analyzed the informational business requirements from various clients.
• Documenting System requirements using standard templates
• Assisted development & testing teams in Integration Testing

Environment: SQL Server 2008, ASP.Net 4.0, C#, Web Services, Oracle 11g, MVS, COBOL, DB2, CICS, .Net, Requisite Pro, Harvest, HP Service Center, .Net 3.0, HP Quality Center, IIS 7.5, Visual Studio 2010/2008, Windows Server 2008 R2