Summary

• 9 yrs of experience in the IT industry in Design, Development, Support and Maintenance of Complex Distributed Business applications in multi-tired architecture.
• Experience in Database Design, Development, Implementation, Documentation and maintenance of Applications in Client/Server and Web Technologies.
• Experience in developing Web and Client/Server applications on Microsoft .NET platform using C#, VB.NET, ASP.NET, ADO.NET, AJAX, XML, XSL, SOAP, WSDL, Telerik RAD controls, Subsonic, ASP, Visual Basic, PowerBuilder.
• Experience in Visual Studio 2008, 2005, 2003 Oracle 10g/9i, SQL Server 2005/2000, Sybase, .NET Crystal Reports, T-SQL, PL/SQL, HTML, DHTML, XML Windows NT/2000/XP, Visual Source Safe, Team Foundation Server (TFS), Team City.
• Experience in working with Microsoft Commerce Server, BizTalk and SharePoint
• Experience in working with ERP systems such as PeopleSoft
• Experience in design the systems to transfer the data using ETL tools such as Informatica
• Expertise in writing Stored Procedures, Triggers and other database objects
• Possess knowledge of MVC, SilverLight, LINQ
• Excellent knowledge in working with Inventory system and supply chain business
• Excellent business knowledge in Manufacturing and Retail domain.
• Proficient in Design and Development of various N-tier projects using SDLC, Agile, JAD and RAD methodologies.
• Experience in System Requirement Analysis.
• Designed and developed various applications based on Component based Logical and Scalable Architecture as well as Service Oriented Architecture (SOA).
• Proficiency in using design patterns like Singleton, Factory, Adapter, Facade, Template Method.
• Experience in applying various software Engineering practices such as Function Point Counting.
• Well versed with SDLC and Agile methodologies of project development.
• Strong analytical, problem solving skills, self-starter with a track record of accomplishments.

• Excellent verbal, written communication and presentation skills, problem solving and conflict resolution skills, and detail oriented.
• Prepare Disaster Recovery Plan and Application Criticality Documents for High Availability and mission critical applications.

IT Skills and Competency

Operating Systems : Windows 2008 R2, 2003, 2000 server, 9x, NT, XP.
Languages and Front ends : C# 2.0, 1.0; Visual Basic 8, 7, 6, Power Builder 8, 7, 6.5, VBA,
Java
Web : .NET 3.5, 2.0, 1.1, 1.0, ASP.NET, VB.NET, ASP, HTML, XML, XSL,
XSLT, AJAX, Java Script, VB Script, ADO.NET, Subsonic,
Telerik RAD Controls, ADO, COM, COM+, SOAP, WSDL,
J2EE, JSP, Struts.
DBMS/RDBMS : MS-SQL Server 2005/2000, Oracle 10g/9i, PeopleSoft,
Sybase 12, MS-Access.
Tools and Utilities : Visual Studio 2008/2005/2003/2000, IIS 7.5/6.0, TFS, VSS,
SQL Server Enterprise 2005/2000, SQL Server Management
Express Studio, TOAD 9, SQL Navigator 4, Microsoft
Commerce Server 2007, SharePoint 2007/2003, Microsoft
Transaction Server, Microsoft Site Server, MS Visio 2000,
Team City, Install Shield 6.2, JCreator LE 2.5, MS Project
2000, Compuware 4.1, Redwood Cronacle, Embarcadero
Rapid SQL, IBM WebSphere 5.1

Professional Summary:

• Programmer Analyst II @ Mastech Holdings Inc, USA since Jan 07.
• Programmer Analyst @ Satyam Computer Services, USA since Nov 05.
• Sr. Developer @ Satyam Computer Services Ltd, India from Nov 03 - Oct 05
• Developer @ Tata Consultancy Services, India from Feb 03 - Sep 03.
• Developer Trainee @ Nagarjuna Fertilizers and Chemicals Ltd, Kakinada, India from Aug 02- Dec 02.

PROJECT PROFILE

Client: Confidential, NY Jan07-Till Date
Role: Primary Coordinator, Programmer Analyst, Support Analyst

Corning Inc., a Fortune 500 Company is a world leader in specialty glass making business since 150 years has many business lines such as Corning Optical Fiber (COF), Corning Cable Systems (CCS), Corning Life Sciences (CLS), Corning Display Technologies (CDT), Corning Environmental Technologies (CET) to name a few. The project is to Design, Develop and Support various applications across different business lines. Selected Projects include…

COF India LCF

The project is to customize and enhance various existing applications for the business expansion in India for Corning Optical Fiber Line of Business for sale of the goods as part of the Joint Venture and export of Fiber manufactured in India as proprietary fiber.

Responsibilities:

• Functional Requirement gathering from business users and customer support representatives of the Business.
• Document and analyze the requirements
• Prepare the Functional SRS and Provide high level estimates for the changes identified.
• Prepare the Technical SRS and identify the modules that will be affected with in various web based ecommerce and inventory management, warehouse and returns applications.
• Perform Impact Analysis for the changes to the applications in other areas such as Order Management and Shipping Modules of ERP System (Peoplesoft), Manufacturing Applications.
• Perform Technical design for ecommerce and inventory management, warehouse and returns applications.
• Design the security over the ecommerce applications for users/customers within and outside India.
• Application and Database Re-Design for the existing modules.
• Data modeling for new and modified database tables and views
• Worked on .NET2.0 application usingiText SharpPDF generator library.
• Identify the changes involved in each of the module affected.
• Provide detailed level estimates.
• Prepare the test plans and record them using HP Quality Center tool.

Environment : ASP.NET 2.0, ASP.NET 1.1, VB.NET, Java Script, ASP, VB, HTML, XML, Oracle 10g
Tools : MS Visio, MS Word, Visual Studio 2005/ 2003, Toad, HP Quality Center, TFS, VSS,
Team City

COF FDD Failure Process Notification

The project is to develop various jobs to create a notification process by ensuring all the customer and product specific configurations are needed with in ecommerce application when orders are created as well as for the validating the failed data deliveries for the customers and notify the business team so that a necessary action can be taken on fixing the issues.

Responsibilities:

• Estimate the requirements
• Design and develop new jobs to constantly check new orders created and validate all configurations as well as monitor the database tables for any failed entries.
• Re-Design the database tables
• Develop and deploy new console applications and host them as Windows service to monitor the delivery failures and setup a notification process to alert the business in case of any delivery failures.

Environment : .NET 3.5, C#, XML, Oracle 10g
Tools : Visual Studio 2008, Toad for Oracle, TFS.

COF Pallet Management

The project identifying the pallets that are shipped to the customers and/or moved between different legal entities of Corning Optical Fiber Line of Business and track them and consider pallets as a new inventory type and manage pallet Inventory in all warehouse facilities.

Responsibilities:

• Requirement gathering from managers, the warehouse users and customer support representatives of the Business.
• Analyze the requirements prepare the functional SRS.
• Identify the applications and modules that will be impacted for the change
• Prepare business requirement documents for the vendor apps such as HighJump software.
• Work with other technical teams to determine the design and impact of the changes downstream applications.
• Translate the functional specs to identify individual modules of various web applications involving Ecommerce, Inventory Management, Warehouse Management, Outsourcing Order Management and their components with PeopleSoft Supply Chain, ETL (Informatica) modules.
• Application and Database Re-Design for the existing modules.
• Application and Database Design for the new modules.
• Prepare Detailed Technical Specifications Document.
• Detailed Estimates for the changes.
• Generated PDF using Itext.
• Record the Specs in the Quality Center Testing Tool for UAT and Integration Testing.
• Code the requirements across various web applications.
• Enhance and modify various stored procedures.
• Provide pseudo code to Vendor for High Jump Changes.
• Integrate the application changes with High Jump Changes.
• Perform Unit and Integration testing.
• Impart training on the new functionality to the business users.

Environment : ASP.NET 2.0, ASP.NET 1.1, VB.NET, Java Script, ASP, VB, HTML, XML, Oracle 10g
Tools : MS Visio, MS Word, Visual Studio 2005, Visual Studio 2003, Toad for Oracle, HP Quality Center, TFS, VSS.

COF Global Ware Movement

The project involves integrating various Fiber manufacturing locations, Fiber coloring
locations, Warehouses and Vendors across the globe and track the ware between them and enhancing as well as adding new warehouse locations. Upgrade various web applications for the Corning Optical Fiber and sync them with the shared Supply Chain System for Corning Optical Fiber line of Business. Goal is to gather, analyze and design the requirement as part of the phase 1 of the project.

Responsibilities:

• Requirement Gathering from various business users from various business entities and the managers from various teams.
• Analyze the requirements and work with other teams to build a functional SRS.
• Provide a very High Level Estimate based on the functional SRS and the systems and modules impacted.
• Work with other technical teams such as PeopleSoft, Integration and Business Intelligence to determine the design and impact of the changes downstream to them and vice-versa.
• Translate the functional specs to identify individual modules of various applications that will be impacted. Applications include various Ecommerce, Inventory Management, Warehouse Management, Outsourcing Order Management, RMA applications and their components with PeopleSoft Supply Chain, ETL (Informatica) and BizTalk modules.
• Application and Database Re-Design for the existing modules.
• Application and Database Design for the new modules.
• Prepare Detailed Technical Specifications Document.
• Used Itext to merge hugePDFdocuments inC#as a separate console application.
• Detailed Estimates for the changes
• Record the Specs in the Quality Center Testing Tool for UAT and Integration Testing.

Environment : ASP.NET 2.0, ASP.NET 1.1, VB.NET, Java Script, ASP, VB, HTML, XML, Oracle 10g
Tools : MS Visio, MS Word, Visual Studio 2005, Visual Studio 2003, Toad for Oracle, HP Quality Center.

CCS FlexNAP

FlexNAP stands for Flexible Network Access Protocol is the core application for the Corning Cable Systems line of Business. CCS manufactures various cables and parts for the telecommunication industry. This application sits at the core of CCSs revenue model and is a backbone for their business operations. FlexNAP is the brand name of the cable which is especially built on the requirements of the customers. The application is designed and developed using Component based Logical and Scalable Architecture and starting from a small component exclusively for Verizon Customer to a massive E-Commerce application for all customers across the globe. The application facilitates the customers to build the cable as per their specifications and place the order. The application has a BizTalk interface to acknowledge the order confirmation to the users and also posting the order specifications to the manufacturing system implemented on SAP. The application uses excessive Java Scripting and Ajax technology. The application is a perfect example of Agile Methodology of project development spanned over a year with releases planned for every two months.

Responsibilities:

• System Requirement gathering and analyze the requirements to prepare functional specifications.
• Application and Database Design. Prepare technical specifications.
• Code various modules using ASP.NET, VB.NET, AJAX, Telerik RAD controls, XML, Subsonic, and SQL Server 2005.
• Generate order specifications in PDF format using ABCPDF.NET.
• Develop complex logic algorithms to design and plan the fibers in the cable/s as per the order requirements.
• Integration and System testing with data flowing from/to SAP via BizTalk Adapters.
• Post production support and address technical issues till date.
• Perform using Team Foundation Server and build/deploy using Team City.
• Carried out the Function Point Counting for the project.

Environment : ASP.NET 2.0, VB.NET, Ajax, Java Script, MS-SQL Server 2005, HTML, XML
Tools : Visual Studio 2005, SQL Server 2005 Enterprise, SQL Server 2005 Express
Studio, IIS 6.0, TFS, Team City, Telerik RAD controls, ABCPdf.NET 6.0,
Subsonic, BizTalk 2006

COF Warehouse Inventory (COFI)

COFI application is an Inventory application for Corning Optical Fiber line of business. Corning Optical Fiber business deals with manufacturing and supplying of Optical Fibers across the world and is the market leader. The Main functionality of this application is to receipt inventory, fulfill inventory for orders, pack the inventory and perform inventory check for various Warehouses of the business. COFI is interfaced with PeopleSoft and HighJump scanning application. Orders are created in PeopleSoft and are fulfilled using COFI Web Application. Order receipting to stock, picking items, packing fibers into containers are done using High Jump scanning utility and the status is validated and reports are printed using web tool. The application is interfaced to PeopleSoft using Informatica.

Responsibilities:

• Design the system from the functional specifications and prepare technical specifications.
• Design various interfacing jobs between Oracle and PeopleSoft using Informatica.
• Code various modules using ASP.NET, VB.NET, ADO.NET, Oracle.
• Database modeling and design using TOAD.
• Generate reports in PDF format using ABCPDF.NET version 5.0
• Develop PL/SQL package procedures in Oracle and implement business logic for Receipt Inventory, Pick and Pack the inventory, Re-induct the goods for High Jump scanning application screens.
• Develop Triggers to validate the transactions and ensure the data integrity.
• Integration and System testing with data flowing from/to various other systems such as PeopleSoft and High Jump.
• Impart training for the warehouse users and help them to handle the tool.

Environment : ASP.NET 2.0, VB.NET, Java Script, Oracle 10g, HTML, XML
Tools : Visual Studio 2005, TOAD 7.1, IIS 6.0, TFS, Team City, ABCPdf.NET 5.0,
PeopleSoft, HighJump scanning utility

COF OptoCommerce
COF OptoCommerce is the Ecommerce website for the Corning Optical Fiber business.
In the Optical Fiber World, an optical fiber without the data cannot be used for anything.
The application is used to track the orders, see and download the Fiber Data, send the data to the customers after the Orders are shipped. This is a legacy application built using VB, COM, and ASP. The system is designed based on SOA architecture. The application is authenticated using Microsoft Site Server and is interfaced between other systems using COM +.
The project is to automate sending the fiber data after the shipment to Tier2 customers that was carried out manually using Excel Macros. The application has a BizTalk interface which sends the files generated by the system to the customers.

Responsibilities:

• Requirement Analysis and design solution.
• Code various modules in ASP, VB 6, ADO, and Oracle 9i.
• Apply localization on the data that is sent to the customers across the globe.
• Database modeling and design using TOAD.
• Integration and System testing.

Environment : ASP, VB 6.0, Java Script, VB Script, Oracle 9i, HTML, XML, XSL, XSLT,
COM, COM+
Tools : Visual Studio 6, Visual InterDev, MS Transaction Server, MS Site Server, VSS,
SharePoint

CLS Federation/Voyager

CLS Federation and CLS Voyager are the Ecommerce portals for Corning Life Sciences business. The portal helps to view the product catalog, order items and track the orders. The CLS Federation portal is interfaced with ERP systems such as PeopleSoft for the business based out of Americas and CLS Voyager with SAP for EMEA (Europe and Middle East Africa) business. The portals are interfaced with PeopleSoft and SAP through BizTalk. The portals are implemented using Commerce Server 2007.

Responsibilities:

• Work with the Business Analyst and prepare Technical requirements for the interfacing modules.
• Coding various modules using ASP.NET, VB.NET, XML, ADO.NET, and SQL Server 2005.
• Customize web portal and extend Web Services for order specifications, order acknowledgement, order confirmation, tracking details, inventory details to/from PeopleSoft and SAP.
• Integration and System testing with data flowing from/to various other systems.

Environment : ASP.NET 2.0, C#, ADO.NET, Java Script, MS-SQL Server 2005, HTML, XML
Tools : Visual Studio 2005, SQL Server 2005 Management Studio/ Express Studio,
IIS 6.0, TFS, BizTalk Server 2006.

COF FiberSelect

COF FiberSelect is the Order Fulfillment application for Corning Optical Fiber business extensively used at the main plant and warehouse. FiberSelect helps to fulfill the orders in various methods that are created in Order Management system in PeopleSoft. The application also does the Audit and Demand Planning. The application has very complex algorithms for Fulfillment and Demand Planning. The application is directly connected to the PeopleSoft database and the tables are shared with other tables in the ERP system. Scope of the project is to enhance the functionality and incorporate features such as Spliced Management, Fiber Sets, and Excess Fiber calculation.

Responsibilities:

• Analyze the current system and understand the limitations of the application.
• Analyze the requirements, Design the system suitable to the requirements and prepare technical specifications.
• Code various modules using ASP.NET, VB.NET, XML, and ADO.NET.
• Specific Fiber Information is obtained from manufacturing systems through BizTalk interface.
• Integration and System testing with data flowing from/to PeopleSoft and MES
• Facilitate the application to interface with SharePoint by uploading documents for the orders being fulfilled by the application.

Environment : ASP.NET 1.1, VB.NET, Java Script, PeopleSoft, HTML, XML, MES
Tools : Visual Studio 2005, TOAD 7.1, IIS 6.0, VSS, SharePoint.

Client: Confidential, USA. Nov05-Dec06
Role: Primary Support Analyst, Onsite Coordinator

Tyson Foods Inc. is a Fortune 500 company and a leader in the Food and Retail Industry. Tyson Foods believes in Off-shoring Model for reduction of costs especially in IT Services. It has a huge IT team which carried out massive project of implementing ERP system using SAP to replace old systems which were in Mainframes and VAX-VMS. Most of the existing systems have been transitioned over to offshore for their regular support and maintenance. The project is to maintain and support various Mailing systems, Imaging Systems, Document Systems, Costing Systems, Reporting systems, Transport Systems, Product Description, Specification systems of Tyson Foods. Design and Develop interfaces to other systems. Enhance applications to latest versions.

Responsibilities:

• Coordinate with Business by gathering requirements.
• Analyze the requirements and prepare functional specifications.
• Design the system suitable to the requirements and prepare technical specifications.
• Code in ASP.NET, ADO.NET, C# and other client server and web technologies such as Visual Basic, Power Builder, ASP, Visual Basic, Java Script, VB Script, HTML, XML.
• Database modeling and designing using Embarcadero Rapid SQL, Compuware 4.1, SQL Navigator 4 and write the stored procedures in SQL Server 2000, Sybase with business logic.
• Integration and System testing with data flowing from/to various other systems.
• Build setup files using InstallShield, MSI installing the code/changes.
• Hosting and administration of the Web applications on IIS 6.0.
• Impart training on the application to the users.
• Provide 24/7 technical support for various business applications of Tyson Foods developed in Client Server and Web Technologies. Resolving daily production issues as part of the support activity.
• Design and develop interfaces to communicate between various systems on different environments (SAP, VMS, Mainframe, Client Server).
• Schedule and monitor various production jobs using Redwood Cronacle.
• Coordinate the work with various business teams of Tyson Foods as well as offshore team and responsible for timely delivery of the code and other deliverables.
• Configure the source code using Visual Source Safe.

Environment : ASP.NET 1.1/1.0, ASP, C#, Visual Basic, Java Script, VB Script, Oracle 9i,
MS-SQL Server 2000, Power Builder, Sybase ASE 12, HTML, XML
Tools : Visual Studio 2003, MS SQL Server 2000 Enterprise, IIS 6.0, VSS, TOAD,
SQL Navigator 4, Install Shield 6.2, JCreator LE 2.5, Compuware 4.1,
Redwood Cronacle, Embarcadero Rapid SQL

Client: Confidential, USA. Nov03-Oct05
Role: Team Lead, Developer

The project is carried out at Offshore Development Center in India on the basis of Design provided by the team in US.
Responsibilities:

• Estimation of - Effort, Time and Cost for the changes and enhancements.
• Code in ASP.NET, ADO.NET, C# and other client server and web technologies such as Power Builder, ASP, Visual Basic, Java Script, VB Script, HTML, XML and test the code. Code the interfaces for the systems to other systems in ASP.NET, C#. Power Builder, ASP, Visual Basic, Java Script, VB Script, XML.
• Detailed analysis of the requirements and preparing the test cases for the requirements.
• Prepare project plans using MS Project.
• Code and test the applications that need to be migrated from ASP to ASP.NET and various lower versions of PowerBuilder to their higher versions and ASP.NET.
• Code, enhance and maintain various jobs in .NET, C# that will be run as part of business activity.
• Performance tuning of various jobs by optimizing queries, modifying the cursors, creating the indexes.
• Distribute the work to other team members and responsible for the delivery of work from offshore.
• Create status reports, metrics and other deliverables to the client.
• Faced Internal and External Audits, Project Process Monitoring (PPM).
• Role of SCMA by maintaining all the deliverables to the Tyson Foods, Inc.
• Code various web pages and Business Logic and the control pages in JAVA, JSP, Struts for the Transport Execution System (TES) using IBM WebSphere with Oracle as the backend for the client.

Environment : ASP.NET 1.0, ASP, C#, Visual Basic, Java Script, VB Script, Oracle 9i,
MS-SQL Server 2000, Oracle 9i, Power Builder, Sybase, HTML, XML, Java,
J2EE, JSP, Struts
Tools : Visual Studio 03/00, MS SQL Server 2000 Enterprise, TOAD, IIS 6.0, VSS,
IBM WebSphere 5.1

Client: Confidential, India Feb03-Oct03
Role: Developer

The project is to develop various modules for Tata Consultancy Services own Remedy Tool for Application Support. The project also involves customization modules for the client.

Responsibilities:

• Requirement gathering and analysis.
• Database modeling and designing for the requirements
• Code the requirements in ASP.NET, C#, Java Script, XML, Excel VBA.
• Build stored procedures in SQL Server 2000 to implement the business logic
• Prepared test cases. Carried out Unit, Integration and system testing.
• Developed reports using .NET Crystal Reports.
• Build MSI and Implemented for an in-house Client “Master Craft”.

Environment and Tools : ASP.NET 1.0, C#, Visual Basic, Java Script, MS-SQL Server 2000,
HTML, XML, Visual Studio 2000, IIS 6.0, VSS

Client/ Employer: Confidential, Aug02-Dec02
Role: Developer Trainee
The project automates whole official tour program of an employee in the organization. The project is mainly divided into two phases: Pre-Tour and Post-Tour

Responsibilities:

• Analysis of the specifications and system design.
• Database modeling and design in Oracle 9i
• Coding in Visual Basic
• Used OLEDB to connect oracle.
• Perform unit testing and system testing.

Environment and Tools : Visual Basic, Oracle 9i, Visual Studio 6, MS Visio 2000

ACADEMIC QUALIFICATION AND CERTIFICATES:

• Master of Computer Applications (MCA),
• Bachelor of Science (Electronics)
• MDCA (Master Diploma in Computer Applications), a 2 year part time course from BDPS (Bureau of Data Processing Systems)