Resume

Sign in

SQL SERVER developer

Location:
San Jose, CA
Salary:
140,000
Posted:
April 23, 2020

Contact this candidate

Resume:

Professional summary:

** **** ***** ** ********** in executing various phases of Software development Life Cycle including System Study, Requirement Analysis, Design, Development, Implementation, Testing, Maintenance and Support.

Developed business components, web components and functionalities using Java/J2EE.

Technical expertise in Implementing Tables, Views, Stored Procedures, Joins, Functions, and Triggers using T-SQL.

Extensive experience in optimizing and tuning SQL Queries and Stored procedures.

Developed SSRS report and performed ETL activities using SSIS packages.

Involved in Reverse engineering of the legacy systems for systems upgrade.

Involved in ETL Data conversion project – to convert data from the legacy system to the new system using DTS Data Transformation Systems.

Performed Data Analysis of the existing system to identify the root cause of the issues reported.

Experience in developing User Interface websites using HTML, JavaScript, jquery, JSON, CSS, and Asp.Net.

Experience in WCF and Restful services.

Developed Data Access Layer (DAL), Business Logic layer (BLL) for implementing Business Processes using .Net Framework 4.0/3.5/2.0,1.1, C#, VB, Win Forms, Windows Services, ASP.NET, Web Forms, Web Services, ADO.NET, IIS, XML

Experience in enhancing the application based on the business needs.

Experience in working with IIS and Apache Tomcat Servers.

Excellent analytical skills with proficiency in debugging and problem solving skills.

Performed root cause analysis of the production issues and provided solutions.

Participated in design discussions with technical architects to arrive at design solution for system software.

Involved in requirement gathering discussion with clients and business analyst.

Prepared Technical design document, Use cases, Test cases and User manuals for various projects and good at Bug fixing, Unit & System testing.

Experience with version Controls like Visual Source Safe (VSS), Team Foundation Server (TFS), CVS, SourceTree, Github

Worked extensively with Agile Methodologies, Waterfall methodologies and Test-driven development.

Played Tech lead role in designing and developing Enterprise Level Line of Business products.

Excellent analytical skills with proficiency in debugging and problem solving skills.

Good communication skills, interpersonal skills, self-motivated, quick learner, team player,

Versatile to new technologies.

Education:

Bachelor of Engineering in Electronics and Communication from Anna University, India (2007)

Technical skills:

Operating System

Windows XP/Vista/2003, Windows 7, Windows 8, Windows 10

Microsoft Frameworks

.NET (1.1/2.0/3.5/4.0/4.5), Entity Framework

Programming Languages

PL SQL, C#, VB.Net, Java/J2EE, ASP.Net Web Forms, Web Service, Window Service, WCF, Java Script, HTML 5, CSS, XML, jQuery, JSON

Databases

SQL Server 2005, 2008, 2012, SSIS, SSRS, SSDT, Oracle

Tools

Eclipse, Visual studio 2015/2012/2010/2008/2005/2003, SQL Server Business Intelligence Development tools, SharePoint, JIRA, Proficy scheduler, Beyond Compare, Confluence, Jenkins, WinScp

Web Servers

IIS 6.0, IIS 7.5 & IIS 8.0, Apache Tomact

Version Controlling Tools

CVS, VSS, TFS, Github, SourceTree

EMPLOYMENT HISTORY

Cognizant Technology Solutions Private Ltd from December 2007 till March 2020

Guidewire Inc – Cognizant Technology solutions

San Jose CA, Chennai India. Jan 2018 – Mar 2020

Role: Senior Product Specialist

Responsibilities:

●Involved in Analysis and Design of requirement, Coding, Configuration, unit and Integration testing of an application using technologies: Java/J2EE, Velocity Framework, JavaScript, jQuery, Web services, SQL Server and Tomcat server.

●Implemented and configured various functionalities of Policy, Claim, Billing and Account.

●Handled the change requests for the systems in InsuranceNow product and fixed production issues.

●Performed Unit testing and Integration testing.

●Involved in Scrum meetings and Retrospective meetings

Environment: Java/J2EE, JavaScript, jQuery, HTML, CSS, Velocity, XML, Webservics, SQL Server 2008, MySQL, GitHub, CVS, Jenkins, Eclipse, Tomcat Server, JIRA, Share point, WinSCP, SourceTree

E. & J. Gallo Winery – Cognizant Technology solutions Jan 2016 – Dec 2017

Modesto CA

Role: Senior Associate

Responsibilities:

●Performed Extraction Transformation Load (ETL) of data using SSIS;

●Created various SSRS Reports using SSDT

●Used Rest Services to update the information online through ERP systems;

●Created Views, Stored Procedures, Jobs, Cursors, Queries to implement the business Rules.

●Configured Resources, Operations, Sub Operations and Defined Routes for the products that are being manufactured;

●Worked in Proficy Scheduler tool to define work orders and display the scheduled plan;

●Designed Shop floor screens using JSP, HTML to capture the Actual data during the work process.

●Involved in troubleshooting issues and provided fix.

●Worked in application deployment and Production Support activities.

●Demo Sessions to client on the implemented user stories and incorporating any changes requested.

●Participated in the agile methodology activities – SCRUM Meetings, Sprint Planning, Backlog Refinement Grooming, Retrospective Meetings and Demonstration of the development to the stake holders.

Environment: NET 4.5, ASP.Net, C#, JSP, HMTL, Rest Service, SSIS, SSRS, VS2015, SQL Server 2012, Proficy scheduler Tool

Chubb(ACE) Xcelerate – Cognizant Technology Solutions Jan 2012 – Dec 2015

Alpharetta GA, Chennai India

Role: Associate

Responsibilities:

Requirements analysis, Estimation, Design, Coding, Unit testing and Implementation of the application.

Played Tech Lead Role for development of Property/Inland Marine and Product Recall Line of Business products.

Worked in Major enhancements / Maintenance changes for various Commercial Insurance products.

Used T-SQL Queries, Store Procedures, Cursors, Joins to fetch Policy details and generate Reports using SSRS.

Developed SSIS packages to fetch the data from the Mainframe system and other SQL server application using Business Intelligence Development Studio.

Worked in DTS for data transformation from one database to other database during migration project.

Developed daily Jobs to do the daily activity which reduced the manual effort.

Created ETL jobs using SQL stored procedures, Cursors, SSIS to move data from flat file to database.

Enhanced application using .NET Framework, Object Oriented Principles (OOP), and n-Tier Architecture.

Integrated external web services to generate policy documents, to perform Authentication, Calculations. Worked in the Window Service (Xcelerate Genius Queue Service) to process the policy information from Xcelerate system to the interfacing system.

Maintained Policy Queue page to validate if the feeds are successful with Email trigger functionalities.

Responsible for issue resolution of Production incidents reported by business users. Closely tracked the progress of projects, Raise Risks, Provide deliverables and Present Weekly Status to customer.

Environment: .NET 2.0/3.5/4.0, ASP.Net, C#, Web Service, Window service, WCF, Web forms, Java Script, CSS, XML, SSIS, SSRS, VS2005/VS2010/VS2013, TFS, SQL Server 2008/2012, Genius

Chubb(ACE) Clearance Portal - Cognizant Technology Solutions Aug 2011 - Jan 2012

Chennai India

Role: Associate

Responsibilities:

●Requirement gathering and functional specification, clarification, estimation, design, coding, testing and preparation of test cases and execution.

●Worked in delivery documents such as Business Requirements document, Technical Design Document, proof of concept for the new web pages and the Search Engine.

●Design of Database/Application Architecture - Creation of new tables, mapping between various tables, creation of stored procedures and functions to handle various functionalities.

●Data migration of clearance data from Builders Risk application to Clearance portal using the Data Transformation Services package (DTS).

●Web services Integration with the Clearance portal to do various functionalities like Authentication, Genius Registration.

●Worked in webservices to make data flow between clearance portal and Inland Marine product.

●Developed data access layer using ADO.NET, invoked DB tables and stored procedures;

●Designed the web pages using ASP.NET VB, Used Master Pages and CSS for screen design; Performed Client side validation using Java Script, Business layer was developed using VB.Net.

Environment: VB .NET, ADO.NET, ASP.NET, NET Framework 3.5, Java Script, XML, SSIS, SQL Server 2005, Web Services, XML, Genius – General Insurance Underwriting software, VSS

Chubb(ACE) MGA Feed LSR - Cognizant Technology Solutions Nov 2010 - Jul 2011

Chennai India

Role: Associate

Responsibilities:

●Business Requirement gathering, Estimation, Analysis, Design, Development, Unit testing and System Integration testing for the projects

●Perform lead role in the Feed development includes the validation of the Feed file, Mail Trigger functionality and processing of feeds in the Genius system, monetary conversion in C# Dot net.

●Enhanced .Net Window service and used web services to handle new feeds.

●Designed T-SQL Queries, Store Procedures and SQL User Defined functions.

●Performed root cause analysis of defects and provided fix.

●Preparation of status reports about the various development tasks on a weekly basis.

●Coordination with interfacing teams for integration issue resolution and communication.

Environment: C# .NET, ASP.NET, NET Framework 2.0, SQL Server 2005, Web Services, Window Services, XML, XSLT, Genius – General Insurance Underwriting software.

Chubb(ACE) Builders Risk – Cognizant Technology Solutions May 2009 - Oct 2010

Chennai India

Role: Programmer Analyst

Responsibilities:

●Used VB.Net for application front end enhancements.

●Implemented business rules using Stored Procedures.

●Invoked external web service Tritech to get the Municipal City/County Rate Details.

●Used .Net Window Service to feed policy to the centralized system Genius (Mainframe System) using XML and Quote/Policy letter generation

●Used external DLL Aspose Excel/Word for merging the information with Quote/Binder templates and letter generation using .Net Window service.

●Creation of KT plan and Coordinating the knowledge transition with client and outgoing vendor and reporting progress on the same. Documenting System application flow, Technical flow, Data flow/Activity diagram utilizing Cognizant System Application Document template.

●Taking care of enhancements – involved in Requirements gathering, analysis of the requirements, Estimation, design, implementation, unit testing, Support and Production Maintenance of the application.

●Issue resolution of incidents reported by the business users.

●Application production deployment planning and execution.

●Development/defect resolution and perform lead role for development team.

Environment: VB.Net, ASP.NET, NET Framework 1.1, SQL Server 2000, Window Services, Web Services, XML, JavaScript, CSS

BBNT KR – Cognizant Technology Solutions Dec 2007 - May 2009

Chennai India

Role: Programmer Analyst

Responsibilities:

●Performed Requirement analysis for the change request.

●Design and development of web pages for the website using VB.net

●Worked in Queries, Store Procedures.

●Created tables to store data for developmend web user interface screens

●Created and executed unit test cases for multiple modules in the project.

●Provided issue resolution for the issues reported by the users.

●Performed unit testing and integrate testing of the module

Environment: C# .NET, ASP.NET 1.1, SQL Server 2000



Contact this candidate