Sql Server .Net Developer
Resume:
Karthik Reddy
************.*****@*****.***
Experience Summary
●7+ years’ experience in analysis, design, development, implementation, and testing of Web-based, client-server and N-tier architectures in Finance, Telecom, Logistics, Consulting, and IT
●Technical expert in technologies such as .NET Framework(1.x/2.0/3.0/3.5/4.0/4.5), ASP.NET, C#, Web Services, WCF, LINQ, IIS, SOAP, XML, XSL, XSLT, HTML,VB Script, Visual Studio 2008/2005/2003, AJAX and ADO.Net
●Experience developing Web-based applications in MVC architecture
●Experience developing Web applications in ASP.Net and MVC4 and knowledge of building in MVC5
●Worked with .Net Server Controls like Data Grid/Grid View, Data List, List View, Repeater Control, etc., to retrieve data from database and display to users
●Experience working with Windows Communication Foundation (WCF)
●Experience working with SharePoint
●Experience developing ASP.NET Web Services, Windows services
●Complete understanding of SDLC (Software Development Life Cycle)
●Good knowledge in Object Oriented Analysis and Design (OOAD) and SQL Server
●Working knowledge in Database Design, Management, and SQL Programming
●Experience designing, maintaining, and analyzing databases, Stored Procedures, and Triggers using SQL Server 2005/2008 and application interaction using ADO.NET
●Good knowledge and experience in Database Modeling Concepts, Query Optimization, and Query Building
●Excellent database programming skills in MS SQL Server 2005/2008/2012, Oracle, and MS Access
●Hands-on experience redesigning existing software to solving complex technical problems with object-oriented programming, Microsoft SQL Server, and advanced JavaScript
●Experience developing both front and back end software for cross-browser, highly interactive AJAX based applications
●Excellent data layer programming skills using PL/SQL, T-SQL stored procedures, functions, and triggers
●Good knowledge of HTML 5 and CSS3
●Excellent debugging capabilities to debug applications
●Worked in developing applications with Agile methodologies
●Excellent verbal and interpersonal skills; good analytical and debugging skills; systematic approach to system architecture design and programming tasks; excellent problem solving skills
Education
Bachelor of Technology, Computer Science and Engineering
Technical Summary:
Web Technologies
ASP.NET, HTML, XHTML,CSS 3, HTML5, DHTML, JavaScript
Programming Languages
C#,VB.Net, JavaScript, SQL and PL/SQL
Databases
MS-SQL Server 2005/ 2008/2012, SQL Server Integration Services (SSIS)
Technologies
Microsoft .Net Framework, ADO.NET, Entity Framework 6, Web Forms, MVC, WPF, XAML, WCF
Project Management
MS Office, MS Visio
Reporting Tools
SSRS, SSIS
Application/Web Servers
IIS 7.0/6.0/5.0
Version Control
MS – Visual Source Safe, MS- Team Foundation Server
Development Tools
Visual Studio 2014/2010/2008, Visual SourceSafe 6.0, Microsoft Visio
Experience Summary:
Project: Comerica Bank, Livonia, Michigan Jul 2015 – Present
Project: Check Replacement
Role: .Net Developer
Description: Comerica Bank is one of the largest bank holding company in the United States. The Check replacement is an in house project which is responsible for validating the check from third party vendors and clearing it and also for storing the data of the validated checks. The check with unrecognized format are validated manually and the information is sent to our system for processing. Based on the processed data daily, weekly and monthly reports are generated. Production support was provided if there was any complexity in viewing the reports.
Responsibilities:
●Played active role in all SDLC stages – requirements gathering, analysis and design, development, testing, debugging, and implementing and deploying of application
●Used AGILE for Release Planning, Iteration Planning, Tracking, etc.
●Performed unit testing on every assigned task before sending it for User Acceptance Test.
●Performed bug fixing and production support
●Worked with Network team and Server team to setup web servers, application servers and DNS.
●Used ADO.Net objects such as DataAdapter, DataReader, and DataSet for consistent data access.
●Created and Consumed WCF services in middle tier which is an interface between web server and Backend servers.
●Created a windows service which identifies the file drop in a folder and sends an email alert to the business user.
●Worked on Java script for the validations and Jquery to improve UI design and made it more cohesive
●Develop SQL Stored Procedures and complex queries in SQL Server 2008
●Create Entity classes and relationships between Entity classes using Entity Framework to manage relational data as objects
●Used Team Foundation Server for integrating, source control and Project tracking.
Environment: Visual Studio 2012, C#, ASP.Net, MVC 4, jQuery, Entity Framework, SQL Server 2008, SSIS, SSRS, WCF.
Project: Bank of America, Hopewell, NJ Jul 2014 – June 2015
Project: Correspondence Generation System
Role: .Net Developer
Description:Bank of America is the second largest bank holding company in the United States. The Correspondence Generation System is responsible for generating customer letters and archiving. The project involved the development of batch jobs, collecting data from different sources like Iseries, mainframes, etc., and the merging of data into letter templates and sending to third party vendors or internal printers for production and distribution. Additionally, the project developed a Web portal used to track progress of jobs and display previously performed job details.
Responsibilities:
●Actively participate in design, development, and bug fixes
●Perform Web portal re-write from classic ASP to ASP.Net MVC 4 and added new functionalities
●Play active role in all SDLC stages – requirements gathering, analysis and design, development, testing, debugging, and implementing and deploying of application
●Use MVC design pattern along with JQuery to develop Web portal
●Use JQuery as JavaScript Library for handling AJAX calls and client side validations
●Create WCF Services to consume template promotion automation service from other portal and applications
●Analyze bugs and design and code solutions.
●Develop SQL Stored Procedures and complex queries in SQL Server 2008
●Create Entity classes and relationships between Entity classes using Entity Framework to manage relational data as objects
●Used Team Foundation Server for integrating, maintenance, reporting and Project tracking.
●Performed unit testing on every assigned task before sending it for User Acceptance Test.
●Finally documenting the analysis and technical specification for future reference.
Environment: Visual Studio 2012 IDE, C#, ASP.Net, MVC 4, Json, XML, WCF, jQuery, Entity Framework, SQL Server 2008
Client: Dept. of Rehabilitation and Correction, Columbus, OH Oct 2013 – May 2014
Project: DOTS
Role: .Net Developer
Description:ODRC is a state department that manages Correction Institutions and Rehabilitation Facilities in the State of Ohio. DOTS is a Web portal developed in ASP.NET 1.0. The project involved the redesign and development of DOTS in ASP.NET 3.5 and the development of Web applications in ASP.NET Maintenance and enhancement were developed in Java.
Responsibilities:
●Actively participated in migration of existing application to .NET framework 3.5
●Played active role in all SDLC stages – requirements gathering, analysis and design, development, testing, debugging, and implementing and deploying application
●Involved in application enhancement in terms of speed, improved security, error logging, exception handling, and code reuse with object oriented design
●Used MVC design pattern for developing application in ASP.NET 3.5
●Used JavaScript for client side validation
●Created WCF Services responsible for communicating and providing real-time data from integrated server to client application
●Analyzed reported bugs, designed solutions, wrote code, and debugged existing programs
●Created database tables and implemented SQL Store Procedures, Triggers, and Complex Queries in SQL Server 2005.
●Partially involved in system study and database redesigning
●Documented application and created flow charts using Microsoft Visio
●Participated in JAD sessions
Environment: Visual Studio 2010 IDE, C#, ASP.Net, XML, ADO.NET, WPF, WCF, XAML, SQL Server 2005
Client: JP Morgan Chase, OH Aug 2012 – Oct 2013
Project: Risk Metrics
Role: .Net Developer
Description:JPMorgan Chase & Co. is an American multi-national banking corporation of securities, investments, and retail. It is the largest bank in the United States by assets. The project included the development of a Web-based application called Risk Metrics. Risk Metrics is an application used by all managers in the firm to track Action Plans, Assessments, and Risk Acceptance levels associated with the issues. Users can track issue statuses and export the data on screen to an Excel file.
Responsibilities:
●Actively participated in development and enhancement of application
●Developed a Web portal using ASP.Net MVC 3
●Played active role in all SDLC stages – requirements gathering, analysis and design, development, testing, debugging, and implementing and deploying of application
●Used MVC design pattern for developing Web application in ASP.NET 3.5
●Used JQuery as JavaScript Library for handling AJAX calls and client side validations
●Created WCF Services responsible for communicating and providing real-time data from integrated server to client application
●Analyzed reported bugs and fixing
●Created database tables and implemented SQL Store Procedures, Triggers, and Complex Queries in SQL Server 2008. Involved in system study and database redesign.
●Designed UI dropdown dependency and integrated its functionality with MVC using JQuery
●Maintained Source Code Version Control using SVN
Environment: Visual Studio 2010 IDE, C#, ASP.Net, MVC3, XML, LINQ, WCF, jQuery, Entity Framework, SQL Server 2008
Client:Harleysville Insurance, PA Sep 2011 – Jul 2012
Project: Finance Manager
Role: .Net Developer
Description:Finance Manager is an intranet Web portal that centralizes dispersed existing business processes into one repository. It processes and amortizes thousands of loans, bonds, deal expenses, and loan losses for a given month. Then, it creates summarized journal entry to be posted into PeopleSoft accounting system. All this data periodically needs to be exported into the mainframe Harleysville Insurance central repository database. This project additionally involved the migration of from classic ASP and VB 6.0 to ASP.Net and VB.Net.
Responsibilities:
●Extensively used ASP.Net for UI design with VB.Net acting as a code behind
●Created various Web Forms and user interface screens using VB.Net and ASP.Net
●Implemented complex financial processes by designing data and business layers utilizing VB.Net, ADO.NET, and XML
●Wrote and developed CSS files, Themes, and Skins to maintain same look and feel of Web pages
●Designed database and normalized tables
●Designed and developed Data Access Layer
●Used validation controls
●Created a number of various user controls for application
●Used AJAX advanced techniques for textbox autosuggest
●Used AJILE for Release Planning, Iteration Planning, Tracking, etc.
●Used ADO.NET for storage and retrieval of data from database
●Wrote code generation programs to auto generate VB.Net code as same type of code required at multiple places in application
●Used XML based procedures for ADO.NET objects to facilitate importing of large XML datasets into SQL Server 2005 database
●Used XML Web Services for exposing important financial calculation functions to all other applications
●Performed unit and system testing on queries and reports
Environment: CNET, VB.Net, ASP.NET, ADO.NET, AJILE, AJAX, SQL Server2005, HTML, Microsoft Visual studio.NET 2005, Windows 2005.
Client:DBA Direct, KY Jan 2010 – Aug 2011
Project: CIA
Role: .Net Developer
Description:DBA Direct is a pioneer and leader in data infrastructure management (DataIM) services. Leveraging its automation-rich Onguard IM platform, the company delivers comprehensive Data IM services for all major database platforms including Oracle, DB2 UDB, SQL Server, Informix, and Sybase on a 24x365 basis. The company’s clients span major industries including manufacturing, banking/finance, retail, utility, insurance, healthcare, education, and government.
Responsibilities:
●Involved in Software Development Life Cycle (SDLC) including design and development phase and testing of system
●Interacted with client to document business details and design Software Requirement Specifications and Project Management
●Involved in complex Graphical User Interfaces (GUI) using Win Forms
●Developed whole business logic in C
●Involved in migration of VB application to .NET 3.0
●Worked with DBA to design structure of database. Designed virtual database using Dataset and Data Tables using Integrity constraints and worked with Data Readers for data manipulation.
●Worked with MS-SQL Server 2000/2005 as back-end for storing data and worked with SQL
●Extensively worked on DTS packages to transfer data between two versions of data models, loading pricing, and availability criteria for various products from complex excel sheets having entirely different formats and attributes to one generalized database structure
●Designed and tested DTS/SSIS packages
●Migrated DTS packages to SSIS, modified packages accordingly to new features of SSIS, and carried out migration of databases from SQL Server 2000 to 2005
●Extensively worked with SQL Profiler and Index Tuning wizard for performance tuning of database
●Extensively worked on Stored Procedures and Triggers
●Performed bug fixing and production support
●Executed CLR Profiler for checking performance and scalability of existing intranet application
Environment: Visual Studio 2003/2005, .Net Framework 1.1/ 2.0/3.0,VB, Microsoft Business Intelligence Studio, VB.Net, C#, ADO, ADO.Net, SQL Server 2005/2008
Project: Turquoise Tours & Travel, TX Mar 2009 – Dec 2009
Project: Third party XML Web Services Integration with Payment Gateway
Role: .Net Developer
Description:The E-commerce application is used in the traveling domain. Users can search for hotels and apartments by entering search criteria. This search information is serialized into an XML request and transferred as an HTTP request to the server of the Web Service provider for execution. Upon successful validation of this request, the server sends the XML response to the client where this XML request is again de-serialized and parsed thru XSLT transformation and displayed into an ASPX form. The selected hotel can be booked through the payment gateway of the system.
Responsibilities:
●Studied API of Web Service provider to list out hotel search and booking engine
●Analyzed and designed Web page layouts and components for various database components for storing CRM data in database server using ASP.NET 2.0, AJAX, XML, XSLT, T-SQL, and Stored Procedures
●Developed interface for clients for online search
●Developed UI for accepting online orders using ASP .NET with implementation of AJAX technology
●Developed whole business logic in C
●Used MSXML for parsing clients’ stored data, scripted automation using ASP and XML for HTML pages to display response data, designed web pages using HTML/DHTML and Java scripts.
●Parsed client's data and provided status reporting using XML, XSLT, and CSS
●Used rich server controls of ASP.NET-like, Grid View, and Data List Controls
●Responsible for connectivity of database using ADO.NET and used Stored Procedure, Parameterized Queries, and Datasets
Environment: Visual Studio 2005,HTML, Java Script, ASP.NET 2.0, Web Services, C#, XML, AJAX, XSLT, XPATH, SQL Server 2008, T-SQL Stored Procedures, IIS Server 6.0, MS-Visio
Project: InfoTech, India Feb 2008 – Jan 2009
Project: Rent-A-Toll
Role: .Net Developer
Description:Rent-A-Toll is a solution for car renters who violate toll lanes throughout their journey. Rent-A-Toll employees log in and set up Toll Authorities and Rental Car Agencies they are going to work with. They send invoices to Rental Car Agencies and deposits to Toll Authorities. The Toll Authorities log in and view deposits sent by Rent-A-Toll and view violations made by customers.
Responsibilities:
●Analyzed specifications provided by client
●Involved in requirements gathering and functional and technical specifications
●Used N-tier architecture for Presentation Layer, Business Layer, and Data Access Layers coded using C
●Coded and debugged using ASP.NET and CNET
●Developed Web Forms using ASP.Net server controls and validated input using Java Script
●Used ADO.Net objects such as DataAdapter, DataReader, and DataSet for consistent data access
●Wrote database routines and Stored Procedures, and fixed standard specifications
●Using Crystal Reports to created reports needed by Middle Office and Back Office users
●Identified, researched, investigated, analyzed, defined, and documented business processes
●Involved in enhancing Business Layer to provide more interfaces and functions needed for system
●Used hybrid of Waterfall and Incremental methodologies as SDLC
Environment: .NET Framework 2.0, ASP.NET, Web Services, SOAP Messages, C# .NET, Visual Studio .NET 2003, JavaScript, VSS 6.0, IIS 6.0, HTML, DHTML, Crystal Reports. Oracle
Contact this candidate