Sql Server .Net Developer

Rakesh Kagitapu

Mobile: 469-***-****

E-mail ID: **********@*****.***

Sr.NET Developer

EXPERIENCE SUMMARY

8+ years of experience in developing and supporting multi-tier Web based applications.

Involved in various phases of Software Development Lifecycle (SDLC) from Requirement Gathering, Analysis, Design, Coding & Unit Testing and Implementation.

Involved in Production support, Maintaining and Enhancing Enterprise Applications.

Experience in developing enterprise level applications with Service Oriented Architecture (SOA) using design patterns and standard practices.

Experienced in Agile development and Waterfall methodologies.

Executed projects in fast paced Sprints, which involves daily Scrums.

Involved in gathering requirements, designing application modules, database model, integrations and prepared Technical design documents and class diagrams.

Experienced in debugging complex issues and performed problem analysis and resolution.

Through understanding of various IT processes.

Experienced working in a multi team environment coordinating with various teams on a day-to-day basis to execute tasks.

TECHNICAL SUMMARY

Proficient programming skills in Microsoft .Net technologies involving ASP.NET MVC, Web API, WCF Service, C-Sharp (C#), LINQ, IIS, Entity Framework, NHibernate, SQL Server, Oracle.

Experience working on web based technologies like Web API, WCF, JavaScript, jQuery, SOAP, JSON, XSLT, and XML Web Services.

Worked with .NET Server controls, Web User Controls, Data Grid control, Form validation controls and created custom controls.

Expertise in designing ASP.NET based Graphical User Interfaces with CSS, JavaScript, AJAX and HTML

Experience in developing User Interface applications with dynamic pages and consistent layout, color and font using Master Pages and CSS, Themes

Experience in securing web applications using ASP.NET authentication and authorization mechanisms.

Experience in writing T-SQL and PL/SQL in MS SQL Server and Oracle database design and development in writing Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers and User Defined Functions.

Proficient in writing complex T-SQL (DDL, DML), XMLPATH, SQL programming, physical, logical database design and SQL Performance tuning.

Created ETL Packages using SSIS to validate, Extract, Transform and Load Database to data warehouse and data marts.

Solid understanding of Object Oriented Programming Conceptsincluding Inheritance, Abstraction, Encapsulation and Polymorphism.

Worked extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to access the database.

Strong Database skills with SQL Server, Oracle and Microsoft Access.

Experienced in test driven development methodology.

Well versed in Windows NT/XP/7/8, UNIX, Linux, Macintosh and client-server environments.

TECHNICAL SKILLS

Languages:

C#, VB, SQL, T-SQL, PL/SQL

Technologies

ASP.NET MVC, Web API, WCF, Web Services

Web Technologies:

HTML, HTML5, XML, CSS, Java Script, JQuery, AJAX, Web Services (REST and SOAP)

View Engines

ASPX view engine, Razor view engine

Web/Application Servers

IIS 8.5/8.0

Database Environments

SQL Server 2005/2008/2012, Oracle 9i/10g/11g and DB2

Operating Systems:

Windows NT/XP/7/8, UNIX, LINUX and Macintosh

Software Packages & Tools

Visual Studio2013/2012/2010/2008, Entity Framework, LINQ, NHibernate, SSRS

Project Methodologies

Agile, Waterfall SDLC

PROFESSIONAL EXPERIENCE

Client

DANA, Maumee, OH

Title: Full Stack Developer

Sep 2016 – Till date

Description:

Supplier Performance Feedback System(SPFS) is quality system designed to rate suppliers around the world for DANA. This is a Web migration project from classic ASP to ASP.net MVC, Entity Framework and SQL Server 2014. This project also has WEB API Restful service that pushes data from frontend to Data warehouse.

Responsibilities:

Design and developing the SPFS application with insights shared with BA.

Involved in gathering and preparing the requirements from clients for product design and enhancements.

Developed application using C#, ASP.NET MVC, Bootstrap, JQuery and SQL Server 2012,2014.

Worked with LDAP single sign on for ease of access for Users across the world. Designed LDAP user search wizard for ease of Admin user.

Used Log4Net for logging application errors that help Support with diagnosing Issues.

Worked with MVC Panels and used third party JavaScript libraries to enhance UI and increase Performance (Bootstrap-Select, Bootstrap-Duallistbox).

Designed Editor templates for customized Edit and responsive Grid.

Implemented Ajax calls for faster Browser response time and Calls to Controller.

Passing data as JSON Objects to Controller with Ajax calls.

Implemented Themes (jQuery Lightness) for User Interface uniformity throughout the application.

Involved in designing and development of Database, created data tables, relationships, stored procedures, triggers and functions using T-SQL.

Designed and developed reports using SSRS.

Developed and implemented User Controls for displaying user related data and summary information.

Implemented codes to extract data from excel and upload in SQL Server.

Designed and developed Restful Web API with JSON Serialization that fetches data from database consumed by IBM DataStage.

Created and worked with JSON Schemas for IBM DataStage when integrating with third part cloud services.

Environment: Visual Studio 2015, C#, .Net framework 4.5, JavaScript, JQuery, JSON, JQuery UI, SQL SERVER 2014 R2, SSRS, T-SQL, Serena, Restful services, XML, LINQ, Microsoft Enterprise Library, Log4Net, ASP.net MVC 5, Entity Framework.

Client

GEICO, Chevy Chase, MD

Title: Senior .Net Developer

Aug 2014 – Aug 2016

Description:

MSI Client is a migration project from Mainframe to .Net framework. This is a core application in GEICO which consists of business logic to find clients information and their related policies from their database. This application is developed as Web API Restful services which will be consumed by around 15 other systems in GEICO and migrated the data from DB2 to SQL Server 2012.

Responsibilities:

Design and developing the MSI Client application

Involved in requirements gathering and Validation sessions to validate the requirements.

Worked with Team Lead in creating the development tasks as per the requirements and assigning them to other developers.

Migrated the application from Mainframe to .Net 4.5 framework and DB2 to SQL Server 2012.

Involved in Client Search, CRU and DAL applications.

Worked on Client UI used by counselers in GEICO.

Developed SSIS packages to extract data from DB2 to SQL Server 2012 R2.

Created SQL Server Tables and wrote complex Stored Procedures, Queries those are required for the application.

Wrote dynamic SQL queries when and where needed.

Wrote Restful web API Services and consumed WCF services.

Processed various XML documents using C# and LINQ.

Used Fluent Validations to validate the input criteria.

Used MOQ for Unit testing the functionality.

Wrote many Unit tests and Integration tests to test the functionality of the application.

Involved in managing and coordinating with off-shore team and testing team.

Prepared release notes for each release and presented the same to testing team and other teams in GEICO.

Responsible for maintaining versions of source code in TFS.

Creating reports using SQL Reporting Services(SSRS) for customized and ad-hoc Queries.

Implemented Dependency Injection using Structure map.

Involved in code review meetings and presented my code to entire team for each release.

Effectively implemented latest technologies like LINQ and C# 4.5 techniques.

Used code review tools like StyleCop and Code Analysis which runs GEICO MSI rules to review the code base.

Debugging JSON response with SOAP UI.

Environment: Visual Studio 2013, C#, .Net framework 4.5, SQL SERVER 2012 R2, DB2, SSIS, T-SQL, TFS, WCF webservices, Restful services, XML, LINQ,JSON, Microsoft Enterprise Library, StyleCop, FluentValidations, MOQ, Structuremap.

Client

Merrill Lynch/BankofAmerica, Hopewell, NJ

Title: Sr .Net Developer

June 2011 – July 2014

Description:

Consolidated Investment Analytics is a timeseries based project where we do lot of timeseries analysis on various securities like HedgeFunds, Indices, Private Equity, Private Real Estate, Portfolio’s and Traditional funds.

Responsibilities:

Design and developing the CIA application

Migrating the CIA application from .Net 3.0 to .Net 4.0 framework, Production Support and Bug fixes.

Effectively handled caching techniques such as client side and server side caching of static objects in order to improve the performance of the application.

Deployed and maintained Win Forms application running as Windows Service.

Involved in designing and development of SOA services using Web Services/ WCF in C#.NET.

Migrated all the Remoting Wrappers to WCF using NetTcpBinding and installed it as Windows Service.

Effectively handled .Net Remoting and WCF running in one Windows Service.

Involved in designing and migration of winforms application to WPF application.

Used some WPF Infragistics xaml charts for effective charting, also used Infragistic Datagrid for effective data display.

More interactive charting is implemented for user interaction.

Developed and used user defined namespaces along with system-defined namespaces.

Designed Application using appropriate design patterns to enhance extensibility, and promote standards to program to an interface rather than implementation.

Involved in managing and co-ordinating with off-shore team.

Created Oracle Tables and wrote complex Stored Procedures, Views and User-Defined Functions those are required for the application.

Migrated Oracle database from 9i to 11gR2 for better performance

Involved in designing and developing Silverlight version of this project called CIA Light.

Responsible for maintaining versions of source code using SVN.

Created application architecture and design documents using UML including creations of different UML diagrams.

Experience in Using Infragistic tools for providing better user interface.

Effectively used code review tools like FxCop, WBSA to review the code base.

Environment: Visual Studio 2010/2012, C#.NET, Win Forms, .Net framework 3.0/4.0, Oracle 9i,11g, Microsoft Visio, Infragistic Controls (Winforms, WPF), Html, CSS, AJAX, JavaScript, IIS, SVN, TFS, WCF, Silverlight, WPF, Remoting, Microsoft Enterprise Library, FxCop, WBSA.

Client

Pen CS, Sydney, Australia

Title: Senior .Net Developer

Oct 2009 – May 2011

Description:

Pen CS has been a Leading Vendor in Health Informatics for the past 21 Years. Project Ferret is a Primary Health, Community Health, Care Planning and Reporting System. It is widely used at the state level by Queensland Health and Western NSW and Far West Local Health District for over 10 years.

Responsibilities:

Develop and maintain Project Ferret at the State level (Queensland Health and Western NSW & Far West Local Health District.

Creating Reports which involved complex SQL Queries.

Enhancing existing UI of Project ferret to meet client requirement.

Worked on in-house ticketing system developed with ASP.Net MVC, JavaScript for Validation and connected to SQL Server using ADO.Net.

Developing Crystal reports for State level reporting of health Informatics.

Developing Patches for Project Ferret with enhancements.

Maintenance of Citrix based and Terminal Services Servers with Periodic Patch updates

Upgrading and Performance Tuning of Oracle Database.

Personally involved with direct communication and issue solving with our major clients

Created tables, views, triggers, procedures and functions on oracle database to enhance product performance.

Administration and Knowledge on Oracle Applications.

Extensive experience in supporting and managing multiple Production, Test, Staging and Development instances.

Worked with in house testing team in creating Test Cases and also worked with NSW Health Test team on using Testing Environment.

Experience in code migration, database change management and data management through the various stages of the development life cycle

I have been involved in installation, configuration and administration of various Oracle Products like Oracle Database Server 9i/10g/11g.

I have been involved in 10g, 11g RAC installation and maintenance for high availability.

Cloning of Oracle databases using both Hot and Cold backups of the database.

I have proficient knowledge in Databases Creation, Database Configuration, Space management, and User management, Backup and Recovery, and Database Maintenance.

Worked on HealtheNet Integration in to Project Ferret for Western NSW Local Health District, created WCF service to transport Xml data across secure citrix network.

Created and parsed Xml documents with C# and LINQ for CHSP project that also involved validation of XSLT.

Working knowledge and understanding of CDA level 3 documents.

Environment: Visual Studio 2010, C#, .Net framework 4.0, VB.Net, C#, ASP.Net MVC, HTML, JavaScript, JQuery, SOAP, VB6, Oracle 9i & 11gR2/11g RAC / MS Access/SQL Server2008, WCF, Web Services, Microsoft Visio, TXT text control.

Client

GE Energy - Energy Services – India

Title: .Net Developer

Jul 2007 – Sep 2009

Description:

GE Power & Water started an initiative to consolidate the IT tools and Systems to manage end-to-end Outage process. This initiative mainly aims at identifying Business needs and enhancing the existing Outage Management Applications according to the Business requirements.

Responsibilities:

Worked with Business users in understanding the User stories and the requirements.

Involved in performing feasibility study and fit-gap analysis on the requirements.

Involved in Project planning sessions and Estimation process.

Prepared use case diagrams, Technical Design document of application and Database using Microsoft Visio.

Gather and analyze project requirements

Preparation of Functional and Technical Specification documents and getting sign off

Followed Use case, Functional Point Estimation Techniques for estimation

Created front end using ASP.NET, JavaScript, JQuery, HTML, CSS and implemented business logic and application code in C#

Enhance the system by design & developing, debugging, testing, and completing all project activities as per the client’s demands.

Create & maintain database objects like views and stored procedures using MSSQL 2008

Configure and maintain continuous integration builds for all product lines using open-source tools (CruiseControl.NET and Nant)

Designed UI pages with Razor views and partial views

Created View Models to encapsulate all models and classes used on the different views for a more organized, structured, and clean code

Used Interfaces to provide service and implementations

Written AJAX asynchronous calls

Consumed XML web services consumer modules for credit card authentication.

Improvised user experience using JQuery and used JQuery event handling mechanism to dynamically assign events on web controls

Implementation of controllers for loading pages and data from Domain field

Environment: Visual Studio 2008, C#, ASP.NET, PL/SQL, MSSQL Server 2008, AJAX, JavaScript, JQuery, Web Services, CSS, HTML.

Contact this candidate