RAMACHANDRA KISHORE

Technical Lead

Houston, TX

Email: acql12@r.postjobfree.com

SUMMARY

Over 8 years of experience in IT industry with a wide range of experience in analysis, design, development, implementation of Web, Window Based Applications & Client Server Applications in various Microsoft related Technologies

Worked for fortune-500 clients (Shell Energy, Baker Hughes Incorporated, Devon Energy, Weatherford International) with offshore onsite delivery model

Expertise in Onsite-Offshore co-ordination and Change management, Release Management, Project management

Experienced in Effort Estimation, Database Design, and Migration

Ample domain experience in Oil & Gas industry

Experienced in all stages of Software Development Life Cycle (SDLC) including requirement gathering/analysis, design, integration, testing, deployment and post production maintenance and support

Expertise in Waterfall and Agile methodologies

Experienced in creating data flow diagrams including sequence diagrams, Interaction diagrams, Use-Case Diagrams

Advance knowledge on .NET Framework 4.5, 4.0, 3.5, 3.0, 2.0, 1.1 and 1.0

Expertise in designing & implementing various custom built solutions using ASP.Net 4.0, 3.5, 2.0, 1.1 in Visual Studio .Net 2010, 2008 and 2005

Good experience on web using Java Script, IIS, Master pages and CSS.

Expert knowledge working on IIS 7.5, 7.0 and 6.0 versions.

Experience with Model-View-Controller (MVC), Model-View-View-Model(MVVM) architecture.

Experience in GUI Design using WinForms and WPF.

Experience in working in Service Oriented Architecture and creating and consuming XML Web Services over SOAP in .NET using C# or VB.NET

Experience in creating and consuming WCF Services.

Experience in using Telerik UI Controls and Telerik Reports.

Consumed ADO.NET components like Data Adapter, Dataset to perform data operations. Extensively used ADO.NET to implement the data layer to communicate with different databases.

Worked on designing the Database Schema using Microsoft SQL Server 2005/2008 and Oracle 9i/10g/11g database object.

Expertise in using SSIS package and working knowledge of ETL using Informatica.

Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer

Expertise in using SAP Business Objects, SAP Crystal Reports.

Experience in using Entity Framework and LLBLGen Pro as OR Mapper.

Have solid understanding of Object Oriented concepts, Gang of Four design patterns.

Used Visual Source Safe (VSS), Tortoise SVN and Team Foundation Server (TFS) for source control.

Used Cruise Control .NET for Integration.

Used UC4 Software to schedule the batches.

Experience in writing Stored Procedures, Functions, Triggers using T-SQL and PL/SQL.

Experience in Data Modeling using Oracle SQL Developer.

Expertise in SSRS, SSIS packages.

Expertise in writing Automation Test Scripts.

Experience in migrating applications to Cloud Servers.

Managed the code repository by maintaining versions and sub versions of private assemblies and effectively did the administration.

Experience in the tools like @hand, Documentum Administrator, Samson, FxCop, Rational Functional Tester (RFT), Process Monitor, Input Accel, HP Quality Center.

TECHNICAL SKILLS

Languages: C#, VB.NET, VB, docBasic

Web Technologies: ASP.NET, MVC, Linq to SQL, Silverlight

Markup Languages: HTML, XML, XAML

Scripting Languages: JavaScript, VBScript, Classic ASP

RDBMS: MS SQL Server 2008, 2005, Oracle 10g, MS Access, SQL CE

Procedural Languages: T-SQL, PL/SQL

Operating Systems: Windows XP/7, Server 2003, 2008 R2, 2012 R2, Amazon Cloud

IDE: MS Visual Studio 2010, 2008, 2005, MS Visual Basic 6.0

Reporting: Crystal Reports, Telerik Reports, SSRS

Web Servers: IIS 7.5/7.0/6.0/5.1

Versioning Tools: Visual Source Safe 8.0 (VSS), Subversion (SVB), Team Foundation Server (TFS)

Advanced Concepts: Web Services with SOAP, WCF Services, WPF, Telerik UI Controls, SQL Server Integration Services (SSIS), LLBLGen Pro, Entity Framework, ETL using Informatica

Third Party Tools: @hand, Documentum Administrator, Samson, FxCop, Rational Functional Tester (RFT),

Process Monitor, Input Accel, HP Quality Center, Cruise Control .NET, UC4 Software, Smart Bear Test Complete, Entegrate Analytics

EDUCATION

Bachelor of Technology July 2003 –June 2007

PROJECT DETAILS

Client: Shell Energy, Houston, TX 05 Jan 15 – Till date

Project Name: Nucleus NextGen

Role: Technical Lead

Description: Nucleus NextGen is an Energy Trading application. At Shell Energy, this is being used by the Business Users for Power Trading, all across the globe. Based on the assigned roles, users will be able to use the application at different levels. The legacy application Nucleus has been upgraded to the latest technologies.

Role and Responsibilities:

•Involved in Analysis and Development of application using .NET framework 4.5

•Developed enhancements for the application using WPF, Telerik Controls, Telerik Reports.

•Used Oracle 11g as the central database.

•Created and consumed WCF Services for the application.

•Developed Stored Procedures, Packages, Functions, Triggers, Views etc using PL/SQL

•Used Team Foundation Server for version control.

•Developed Automation Test Scripts in VB using SmartBear Test Complete.

•Migrated Entegrate Analytics application from Windows Server 2003 to Cloud Server (Windows Server 2012).

Environment : .NET Framework 4.5, WPF, Telerik UI Controls for WPF, Telerik Reports, MVVM Pattern, WCF Services, Oracle 11g, Team Foundation Server (TFS) 2012, NuGet, Smart Bear Test Complete, Amazon Cloud Services, Visual Studio 2012.

Client: Weatherford International, Houston, TX 17 Nov 14 – 31 Dec 14

Project Name: AFE System

Role: Sr. Dot Net Developer

Description: AFE is the Authorization for Funds Expenditure system used at Weatherford International. This is a global application, which is used to create invoices for any material that is required by the staff. Anyone in the company will have access to create an AFE, which will go through the approval process based on the Region, Division etc. Once approved, all the invoices will be posted to ERP system, where the actual payments take place. AFE system also has the ability to forecast the funds for future years/quarters and the resources required etc.

Role and Responsibilities:

•Involved in Analysis and Development of application using .NET framework 4.0

•Developed enhancements for the application using ASP.NET in VB.NET

•Involved in the development of SSIS packages to send the information to ERP system

•Used SQL Server as the central database.

•Created and consumed Web Services for integration with other applications.

•Developed Stored Procedures, Functions etc using T-SQL

•Used Team Foundation Server for version control.

•Used TFS Work Items for Enhancements tracking..

Environment : .NET Framework 4.0, ASP .NET, VB.NET, Web Services, SQL Server 2012, Team Foundation Server (TFS) 2013, Windows Server 2012, Visual Studio 2013, WinMerge, Use Cases.

Client: Department of Economic Opportunity, Tallahassee, FL 06 Jan 14 – 14 Nov 14

Project Name: UI Connect

Role: Sr. Dot Net Developer

Description: Project Connect is a Reemployment Assistance (RA) modernization project intended to improve the claims, benefits, and appeals processes. Project Connect will replace the current collection of reemployment assistance systems, some which are more than 35 years old. In developing the new system, the Department is focused not just on new technology but also re-engineering processes for faster production, higher quality work products resulting in reduced costs, and improved service to claimants and employers.

The project scope covers all RA functions: initial claims and continued claims, wage determination, adjudication, appeals, benefit payment control and program integrity. Like the current system, Connect system will interface with various other state and federal systems for the data necessary to carry out the RA program.

Role and Responsibilities:

•Involved in Analysis and Development of application using .NET framework 4.0

•Involved in Analysis of application built on multi-tiered architecture

•Involved in the Development and Issue fixing in Batch Tier built on .NET 4.0 in C#

•Involved in Development of Reports using SAP Crystal Reports.

•Involved in the Design and Development of windows application for DOL (Department of Labour) using WPF.

•Used LLBLGen Pro for Object Relational mapping.

•Created and consumed WCF Services for integration with other applications.

•Used Oracle 11g as the central database.

•Used PL/SQL for Stored Procedures, Functions, Triggers.

•Developed Stored Procedures, Functions etc using PL/SQL, which are utilized in the Crystal Reports for reporting purposes.

•Extensively developed Stored Procedures, Functions, Triggers written in PL/SQL and utilized them in the Service Tier (WCF Services) for transactions.

•Used Team Foundation Server for version control.

•Used Cruise Control .NET as integration server.

•Used UC4 Software to schedule the batches.

•Used SAP Business Objects – Central Management Console for hosting the crystal reports.

•Used UC4 Software to schedule the batches.

•Used HP Application Lifecycle Management for Defect maintenance.

•Leading/mentoring a team of 3 resources.

Environment : .NET Framework 4.0, ASP .NET, C#, WPF, Oracle 11g, PL/SQL, WCF Services, Crystal Reports, NUnit, Team Foundation Server, Windows Server 2012, Visual Studio 2010, WinMerge, HP ALM, Use Cases.

Client: Baker Hughes Incorp., Houston, TX 02 Jan 12 - 31 Dec 13

Project Name: Doc Quest

Role: Technology Analyst

Description: Doc Quest is a web based system acting as common Portal to multiple applications – currently 38 applications – that are used by DocQuest users. The DocQuest users are the company users, belonging to different departments across like HS&E, Quality, Engineering, Manufacturing, Marketing, Operations accessing the Portal. The applications are used to store & distribute data of various other systems interfacing to Portal and its applications. The entire Portal has about 4.9 million documents saved from 263 locations from all the applications. The applications in the Portal use Documentum server to manage documents and metadata.

Role and Responsibilities:

•Actively involved in the docQuest upgrade project which involves working with Windows Server 2008 R2, IIS 7.0, Documentum 6.7.

•Involved in data migration activity using SQL Server for supplying the data feeds to SAP.

•Used T-SQL for Stored Procedures, Functions, Triggers.

•Bug fixes and enhancements on these applications and coordination with the offshore team on the same. Portal is built on Classic ASP, VB 6.0 and few sections on ASP .NET 2.0. Also, usage of DFC to communicate with Documentum.

•L3 production support for the 38 applications in the portal.

•Providing the estimates for the projects at High Level Design which helps the project managers to make budgetary decisions and resource allocation.

•Coordinating with Business users on the issues or changes required in the applications.

•Involved in Analysis, Design and Development of enhancements using ASP.Net 2.0

•Involved in Analysis of code rewrite of applications from VB6 to ASP.Net 4.0

•Involved in the docQuest upgrade project which includes working with Windows Server 2003/2008 R2, IIS 6.0/7.0, Documentum 6.5/6.7.

•Involved in data migration activity using SQL Server for supplying the data feeds to SAP.

•Leading offshore development/support team sized 4 resources.

•Involved in the Analysis and fixing of the performance issues in the application.

•Involved in the code re-write for handling the session management in the applications.

•Used Classic ASP, VB.NET, and VB6.

•Used SOAP Web Services for integration with different modules.

•Used Documentum Foundation Classes to connect with Documentum and access the repository.

•Used VBScript and JavaScript for validations.

•Used Visual Source Safe for version control.

•Used Web Services to trigger other applications to fetch the data.

•Used Quality Center to track the defects to closure.

Environment : .NET Framework 4.0/2.0, Classic ASP, VB 6.0, ASP .NET, VB.NET, Documentum, SQL Server 2008 R2, T-SQL, Web Services, IIS 7.5/7.0/6.0, Input Accel, JavaScript, VBScript, SOAP Web Services, Team Foundation Server, Visual Source Safe, Windows Server 2008/2003, Visual Studio 2010, WinMerge, HP Quality Center, docBasic, Estimations, Use Cases.

Client: Devon Energy, Oklahoma City, Oklahoma 08 Aug 11 – 31 Dec 11

Project Name: EEI Worker Data

Role: Technology Analyst

Description: Client had an immediate need to remediate a large number of legacy application systems that will be impacted by its new Enterprise Resource Planning (“ERP”) system, which was scheduled to go live on January 1, 2012. The Enable External Impacts Project’s objective was to ensure the legacy systems and applications continue to operate when client implements the new ERP system. The EEI project’s success and timeliness as it relates to the ENABLE timeline was critical to Client’s transformational agenda.

Role and Responsibilities:

Involved in Analysis, Design & Development of applications using .NET framework 3.5

Involved in Analysis of applications built in .NET 3.5, 2.0, 1.1, WPF, MVC 2.0, Silverlight, VB.

Involved in migration of the backend for the applications from Active Directory, iPlanet to MS SQL Server and Oracle.

Involved in Analysis of ETL applications using Informatica.

Involved in the system and integration testing in Dev environment and subsequently responsible in promoting the applications to Staging and further to Production.

Coordinating with Business Analysts on the issues or changes required in the applications

Leading/mentoring offshore development team sized 15 resources.

Used ASP.NET 3.5, MVC and Linq to SQL for development.

Used PL/SQL and T-SQL for Stored Procedures, Functions, Triggers.

Involved in design of Databases in SQL and Oracle.

Used Team Foundation Server for version control.

Used Agile Methodology in the project.

Environment: .NET 3.5/3.0/2.0, VB.NET, WPF, XAML, MVC, Linq to SQL, Silverlight, Web Services, WCF Services, VB 6.0, Oracle, SQL Server 2008, PL/SQL, T-SQL, iPlanet, Active Directory, ETL using Informatica, Team Foundation Server, Visual Studio 2010, MS SQL Server 2008, TOAD, WinMerge, HP Quality Center, Agile Methodology, Estimations, Use Cases.

Client: Baker Hughes Incorp. 01 Apr 08 – 06 Aug 11

Project Name: POWER

Role: Sr. Software Engineer (SSE)

Description: POWER project was a Field Mobility solution (FMS) using 3rd party tool which is used to optimize processes and information needed by companies who send technicians or staff “into the field” (or out of the office). FMS most commonly applies to service companies who typically have operations in the field. Field mobility creates a mobile system that connects the field worker with the corporate systems seamlessly. FMS improves field worker productivity, enhances customer service, automates paper processes, assist with regulatory compliance, reduces human error, inventory turnover etc. In this we were using licensed @hand tool which is also a Dot Net based product.

Role and Responsibilities:

Developer and SME (Subject Matter Expert). Responsible for developing the business solution for Client.

Involved in the client interfacing, Design, Development, Testing and Implementation of Field Mobility Solution.

Involved in Analysis, Design and Development using .Net framework 3.5/2.0

Actively involved in the integration of the applications with multiple applications.

Used SOAP Web Services for the integration of applications.

Used C# extensively for the development of windows application.

Used ASP.NET 3.5 for the web part of the application.

Used third party tool called ‘@hand’ for the development, which is also built on .Net framework 3.5

Used MS Access and MS SQL CE as the client databases.

Used MS SQL Server 2008/2005 as the server database.

Used T-SQL for Stored Procedures, Functions, Triggers.

Used SSIS Packages for ETL purposes, to send the information to SAP.

Used Crystal Reports for reporting functionality in the application.

Part of the development team, with a team size of 8.

Used Waterfall model of the SDLC.

Responsible for providing additional features which were not supported by the @hand product itself, like offline PDF report generation using Crystal Reports, E-mail functionality.

Worked around the SYNC feature (used to sync the remote data to a designated server) provided by the @hand product to customize it according to the requirement.

Involved in CMMi Audit representing the Functional group for POWER project, which contributed to CMMi Level 5 for the company.

Used Quality Center to track the defects to closure.

Environment: .Net 3.5/2.0/1.1, @hand tool, MS Access, MS SQL Server 2008/2005, T-SQL, MS SQL CE, Crystal reports, SOAP Web Services, Windows Services, SSIS, Sub Version, Visual Studio 2008/2005, HP Quality Center, WinMerge, Rational Functional Tester, FxCop, Waterfall Model, Estimations, Use Cases.

Employer: Infosys Limited

Infosys Training, 26 Nov 2007 – 31 Mar 2008

Mysore, India

Role: Trainee

Completed on job training from Infosys of 4.5 months on Dot Net Stream which had modules such as MS SQL Server 2005, ADO.Net 2.0, ASP.Net 2.0 web Applications and web services, programming using C#, HTML/JavaScript.

Process Experience

Change Management:

Maintain source code with proper versions.

Provide required access to the repository to the team members, based on their roles.

Maintain all project related documents, like Design documents, test cases, and release notes with correct and updated versions.

Conduct Bi-Weekly audits to make sure all the configurable items are updated and in place. Use a standard checklist for this audit.

Provide all the required documents during External Audits.

Represented the functional group in CMMi audit for the company.

Release Management:

After the development and unit testing is complete, responsible for pushing the changes to Dev environment and test the applications.

Once successful, move the changes to QA environment. Here, testing team will test the application and log the issues in HP Quality Center (QC). We track down the issues in QC to closure.

Then, we go ahead with the Production release and perform UAT with the users and work on the issues at run time.

After the successful completion of UAT, the applications will Go Live to all the users and we provide production support.

All these processes include proper documentation as well, like High Level Design document, Detailed Design Document, Test cases, Release Notes etc.

Activities & Awards

Received Most Valuable Player award in the project at Infosys.

Part of the team that received best project award multiple times.

Received Omega Platinum award for being part of Business Transformation project for Baker Hughes Incorporated.

Received award for representing functional group in CMMi audit.

Actively participated in many other events at organization level like Spark.

Proposed the idea of Field Mobility Solution for Supply Chain Management for the client and given a presentation to one of the Directors at Devon Energy.

Contact this candidate