It Professional Resume
Plano, TX
Summary:
An IT professional with proven analytical abilities and organizational skills with more than 8 years of expertise in Windows/Desktop(WinForms), and Web Application development (WebForms) (MVP, N-tier Architecture) with more than 7 years of .NET technologies(.NET 1.1/2.0/3.5)
- Experience in Designing, Developing, Implementing, Testing and Supporting Software Solutions for Fortune 1000 companies with a very good knowledge on the Software Development Life Cycle.
- Worked extensively on Windows Applications using C# .Net, VB.Net, VB 6.0 and on Web based Applications using HTML, ASP, ASP.NET and JavaScript with good experience in Web Services, ADO.NET, ADO.NET DATA Service, LINQ to SQL, AJAX, Remoting, Multithreading, Reflection, Delegates,. Have good knowledge in deploying and configuring Websites in IIS. Capable of developing Business components in C# and VB and deploying the same in COM+ server.
- Posses Good Experience in N-Hibernate and implementing solutions using the Modal View Presenter architecture.
- Good experience in managing enterprise IT project life cycle through all phases.
- Expertise in business process analysis and in creating Business Process Requirements (BPR), Software System Requirements (SSR) and Functional Requirement Specs.
- Gained substantial knowledge in SQL Server 7/2000/2005 and in developing SQL Queries, Procedures, Triggers and other Database operations such as profiling and DTS services. Also possess good knowledge in .Net Reporting Services and Crystal Reports.
- Have a good understanding of the Dot Net Framework and developed Applications and Services for Windows Platform using the same.
- Gained good understanding of the HP3000 operating system and also learnt QUICK and QUIZ programs (COGNOS provided utilities to program on HP3000).
Technical Skills:
Operating Systems: Windows Vista/XP/2000/NT/98/95.
Languages: Visual Basic 6.0, C, C++, VB .Net, C# .Net, ASP .Net, Classic ASP.
Databases: MS SQL Server 2000/2005/7.0, Oracle 8i, 9i, 10i MS Access.
Programming Environments: Visual Studio.NET 2003 /2005, Visual Studio 6.0.
Web Technologies: ASP.NET, WebServices, ASP 3.0, XML, XSD,XSLT, SOAP,WSDL,HTTP,XAMLXML Schemas, HTML,CSS, DHTML.
Web Servers: IIS 7.0/6.0/5.0.
Middleware: ATL COM, COM+, COM/DCOM, .Net Remoting, Web Services,
Queue (MSMQ), Active directory API.
Data Access: ADO.NET, ADO, SQLDMO.
Scripting Languages: VB Script, Java Script.
Tools: BizTalk Server 2002, COGNOS POWER HOUSE TOOLS, Trackwise 7.0, Minisoft ODBC,
HP Quality Center.
Modeling: UML, Model-View-Controller (MVC), IOC, DI, Enterprise Architect.
Version Control Tools: Visual Source Safe, Clear Case and Borland Star team
Others: MS Office, MS Excel 2000 & 2003.
Education:
MASTERS DEGREE in Computer Applications
BACHELORS DEGREE in Computer Technology
Certifications
Basics of Supply Chain Management: APICS
Trackwise Administrator: Sparta Systems
Programming Concepts: Brain Bench
Data Modeling Concepts: Brain Bench
Software Configuration Management: Brain Bench
Requirements Analysis: Brain Bench
Software Testing Basics: Brain Bench
Methodology: JRAD (Joint Rapid Application Development), Waterfall
Professional Experience
Client: Confidential, Dec 2011 - Feb 2012
Project: ICP
Description: XO Communications is a telecommunication company and ICP is their Customer Portal. The ICP runs on a .Net 3.5 platform with most of its data coming from an Oracle Backend Database. This website is developed based on a Modal View Presenter design pattern.
Responsibility:
- As a senior .Net Developer I was involved part of the Custom Controls team I developed several Customized Controls like the Customizable Grid View control that could display Hierarchical Data and have varied editable controls on them.
- Designed and developed the changes that were needed to update all hardcoded dropdown values to a List-Of- Values from the database.
- Creating N-Hibernate mappings to query the Siebel Database.
- Worked extensively on custom logging on the batch upload screen to track user actions to the back end Oracle table.
Client: Confidential, Irving Aug 2011 - Dec 2011
Project: SSAR Integration
Description: The SSAR Integration is project which is a part of the Bank wide Re Certification program. The intent here is to get all individual applications in Metlife Bank into one Certification and Access Management Platform.
Responsibility:
- As a Business/ System Analyst, is responsible for the gathering the administrative requirements for 20 applications.
- Working with the Business Owners on a day to day basis to get an understanding of the existing certification and access management process.
- Documenting the SSAR Integration requirements for each and every application as Business Requirements and System Requirements Specs.
- Presenting the Requirements to the Business, Certification and Access Management teams for their approvals and working with the Developers to get them implemented.
- Designing the system and preparing Functional Specs.
- Working with the Development team to get the integration components developed in ASP.
- Developing System and User Acceptance test cases and testing the applications as they get developed.
Client: Confidential, Plano TX April 2011 - Aug 2011
Project: PI Invoice Reconciliation
Description: The PI Invoice Reconciliation system is a .Net based web application which loads the Server listing information from HP and from PepsiCo's Configuration Management Data base, and reconciles the server configurations between the 2 feeds and highlights the differences to make sure the invoices are generated for the right configurations.
Responsibility:
- As an Onsite Project Leader, was responsible for development and management of budgets, determining project scope, liaising between clients and staff throughout project lifecycle, and ensuring objectives were met.
- Interfaced with business users to prepare Business Process Requirements (BPR) and Software System Requirements (SSR).
- Ensured all artifacts complied with corporate SDLC Policies and guidelines
- Lead a 5 member team and managed the design, development and the implementation of the Reconciliation effort.
- Designed Test Strategy and managed the system testing activity.
- Traced test cases and functional specifications to SSRs and BPRs
- Also owned and managed the data base lining activity at onsite.
Environment: .NET 3.5, C#, ASP.Net, C#, SQL Server 2005
Client: Confidential, Plano TX Jan 2010 - April 2011
Project: Test Metrics and Tools Management for One-Up Release 7
Description: The "One Up" initiative in PepsiCo has been an ongoing project which has been executed as different Releases. In each release, a set of Mainframe applications get migrated to SAP.
Responsibility:
- Lead the Tools and Metrics team, Designing and Developing Dashboards and Reports to track the status of the testing efforts on the Release 7 roll out.
- Developing tools to aid the testing mainframe applications and also to assist cross platform (Mainframe and SAP) testing.
- Training the new members on the different Testing tools and Metrics, used as a part of the Release 7 project.
- Planning and Managing the Design and Development Activities.
Environment: .NET 2.0, C#, SQL server 2005, XML, XPath, XSLT, ADO.NET, Borland Star Team, HP Quality Center, Business Objects Reporting, VB Macros for Excel 2003
Client: Confidential, Plano TX April 2009 - Jan 2010
Project: SPM 3 - Route Planning System for FLNA
Description: SPM3 a Windows application was developed in 2009 to replace it predecessor SPM which was an Excel macro based tool. SPM3 serves as a Route Planning tool that helps Route Sales Representatives and District Sales Leads in PepsiCo to plan their sales.
Responsibility:
- Worked on a JRAD (Joint Rapid Application Development) model and developed the SPM 3 application in C# .Net which replaces the existing excel based version called SPM 2.
- Created Functional Description documents detailing the functionality of the modules as and when they get developed, to aid testing of the different releases in the JRAD model
- Developed tools to help excel based users to be able to use excel shortcuts to browse through the data in the new application as well.
- Performed Unit, Integration testing and coordinated the User Acceptance Testing for both the pilot 1 and 2 releases.
- Managed the software configuration and versioning using Borland Star Team.
- Used HP Quality Center extensively to track defects and to take them to completion.
- Supported the pilot implementation of the application.
- Developed, Deployed and tested the application enhancements that were planned for National Rollout.
Environment: .NET 2.0, C#, SQL server 2005, XML, ADO.NET, Borland Star Team, HP Quality Center, VB Macros for Excel 2003
Client:Confidential, Roswell, GA May 2008 - Apr 2009
Project:
- Operational Assistance for 20 (.Net, ASP and Access) based applications in Kimberly Clark Healthcare Portfolio.
- Trackwise Implementation for Compliant Handling in Kimberly Clark
Description: The internet and intranet sites are the back bone of the Kimberly Clark Healthcare portfolio. All new promotions and products need to be made available on the internet and intranet sites. The intranet based sites include sites for Payroll processing, Incentive Calculations, Complaint Handling etc. Each of the internet site pertained to a product in the healthcare portfolio of Kimberly Clark.
Responsibility:
- Lead a technical team as a part of the Operational Assistance and New Project Development engagements for Kimberly Clark under the Health Care Portfolio.
- Designed and Developed promo sites like HAI Watch and the Kimberley Clark Intranet site, in ASP.Net and Classic ASP.
- Was responsible for resolving and ensuring high customer satisfaction with a very quick turn around on Severity 1 and Severity 2 issues.
- Provided guidance and helped the team resolve Severity 3 and 4 issues and made sure that the Service Level Agreements were met.
- Handled the estimation, planning and execution of enhancements and small projects for the Health Care portfolio in Kimberly Clark.
- Unit tested the individual delivery pieces, Performed project integration and performed Integration testing. Coordinated the User Acceptance Testing for the enhancements.
- As a certified Trackwise Administrator, was involved in the configuration activities of the Complaint Handing system in Trackwise.
- Also took care of user training and post implementation support for the new "Trackwise" based Compliant Handling system.
Environment: Microsoft Visual Studio.NET, MS SQL Server 2000, Access 2003, Classic ASP
Client: Confidential, PA Nov 2007 - Apr 2008
Project: Support and maintenance of 15 (.Net, Classic ASP and Access) based applications in Saint Gobain
Description: Support and maintenance of 15 (.Net, Classic ASP and Access) based applications in Saint Gobain
Responsibility:
- Was taking care of the Level 2 and Level 3 support and maintenance of 15 applications which included Windows Applications in VB.Net, Web Based Applications that were developed using ASP.Net, Classic ASP and Several client server and windows applications developed on a Microsoft Access platform.
- Designed, Developed and Unit Tested various enhancements to the applications
- Was concurrently, providing offshore a technical and functional transition on the applications.
- Taking care of the day to day issues with these applications and making sure we meet the Service Level Agreements (SLA) in fixing them.
Environment: Microsoft Visual Studio.NET, MS SQL Server 2000, Access 2003, Classic ASP, Oracle
Client: Confidential, Greer SC June 2006 to Nov 2007
Project: VISION
Description: The existing VI Order to Cash System used by MPF (Mitsubishi Polyester Films) ran on a HP 3000 and was about 20 years old. The technology was near obsolete and the system did not address the growing business needs. The objective of our project was to re-engineer the existing HP 3000 based Order to Cash used by MPF at its manufacturing division in Greer into a more reliable, robust and scalable solution.
The Business Process Cycle covered the entire business process from the Order Creation for a Customer, Order management, Invoicing and Cash Receipt. The cycle begins when customer demand is identified. This demand must be confirmed and converted to an order to either start production or ship product from inventory. The order is then tracked through production, warehousing and shipment. Once items are shipped, an invoice is created and finally payment is recorded.
- The key functionalities of this project are identified as
- Order Management
- Customer Management
- Inventory Management
- Shipping & Billing
- Accounts Receivable
- VI Interfaces
- Feedback & COA
The HP 3000 system was to be converted to a robust Microsoft .NET web application using ASP.NET and VB.NET.
Responsibility:
- Played roles in design, development and testing with responsibilities such as
- Shouldering overall responsibilities to understand Client Processes and to work efficiently to meet targets and deliver solutions in accordance with Cognizant quality control standards and business practices and procedures.
- Have developed a level of competency, which helps to anticipate issues and solve them in advance.
- Imparting domain and technical knowledge to the new entrants and also fellow team members.
- Also responsible to perform the analysis for various enhancements gathering requirements from the Clients, perform impact analysis to find out the systems/programs that could be potentially affected by proposed change(s), coding, and testing and implementation activities.
- As part of rollout type of works, the responsibilities include performing analysis on the business requirements and development of high level and detailed system design, test environment set-up, Data Migration Activities, system testing, implement the system in to the production environment and providing warranty support.
- Preparation of the following various technical and functional documents (where applicable depending on the request types) Requirement Specification document, High Level Analysis and Approach document, High Level Design Document, Detailed Design Document, System test plan and test procedure document and implementation plans.
- Was part of the Maintenance and Support team providing a 24/7 support for the VISION and Films Material Flow system for more than 8 months.
- Further responsibilities also comprise of ensuring top quality deliverables from Cognizant to client and collection of project metrics.
Environment: Microsoft Visual Studio.NET, MS SQL Server 2000, HP300, Cognos Powerhouse Tools QUIZ, QUICK, QTP, Minisoft ODBC
Client: Confidential, Greer SC July 2005 to June 2006
Project: FMF (Film Material Flow)
Description: The objective of the Film Material Flow project was to re-engineer the existing HP 3000 - Turbo Image based Film Material System used by MPF at its manufacturing division in Greer into a more reliable, robust and scalable solution. The key objectives of the project include.
- Data Consolidation and removal of redundancy
- Enhanced User Friendly Interface
- Reporting Accuracy and Data Standardization
- Ease of Maintenance
- Elimination of manual interaction in identified flows
- Scalability
The HP 3000 system was to be converted to robust Microsoft .NET web application using VB.NET.
Responsibility:
- Got involved in Knowledge Transfer sessions with the client to get an initial understanding of the project and the film lines.
- Analyzed the Requirements by reading through the existing HP3000 code.
- Was Involved in training sessions educating the team on the business process in Mitsubishi
- Reviewed Design Documents for the Business Components and Batch Applications and submitted the same for client review.
- Developed a lot of interface programs (Windows Applications using Vb.Net) to make the application interact with various devices in the manufacturing plant like the Programmable Logic Controllers for Weighing stations, Conveyer Platforms and Roll Storage arms.
- Designed a key interface wherein the new application interacts with another HP3000 system. Did a lot of analyses around this interface and played the key role in identifying the interfacing portions.
- Reviewed and tested the VB.Net Code.
- Took part in User Application Testing team and did a lot of code changes to accommodate new client requirements.
- Took total control on the DB environment setup for development server and the QA server.
- Was also involved in setting up the application and its dependent components on the production environment.
- Was part of the Maintenance and Support team providing a 24/7 support for the Films Material Flow system for over 3 months.
Environment: VB, ASP.NET, ADO.NET, HTML, JavaScript, SQL, HP3000, COGNOS Power House Tools (QUICK, QUIZ and QTP), Minisoft ODBC.
Client: Confidential, Oct 2004 - June 2005
Project: Ready Set Grow
Description: The Schwan Food Company with millions of customers and more than 6000 employees handles large volumes of data related to its customers, employees, products, sales, assets, regions etc. In order to handle such voluminous data the Schwan Food Company used Mainframe systems to validate, store and process the data. This mainframe system ran on a base of about 4-5 million lines of code. Since such a system is non user friendly, bulky and very difficult to maintain, The Schwan Food Company decided to rewrite all the Mainframe applications in .Net thereby eliminating the Mainframe systems over a period of time and move to a more robust, user friendly and easy to maintain .Net environment.
Responsibility:
- Analyzed the Requirements for the Accounts Receivables and the Commissions Module from the related COBOL code.
- Prepared the Design Documents for the Business Components and Batch Applications.
- Developed the Business Components and Batch Applications.
- Developed Windows based tools in C# that would help teams to test their Business Components.
- Created the Test Cases and necessary Test Data to test the Components and Batch Applications.
- Performed the Unit Testing for the Components and Batch Application.
- Performed the Parallel Testing of Batch Applications with the Mainframe System.
- Supported the onsite team during System Testing
Environment: C#, ASP.NET, ADO.NET, HTML, JavaScript, SQL Server 2000, MSMQ, COBOL
Client: Confidential, Jan 2004 - Oct 2004
Project: National Insurance Database
Description: The National Insurance Database is a system built to report prior insurance history for a driver. Insurance policy information is collected from contributing insurance companies in any format that is convenient, timely, and contains the required policy data elements. The policy data is reformatted, validated, and loaded into the National Insurance Database. Contributing insurance companies may access the policy data to determine prior insurance for a driver at the time of writing a new policy. Access will be provided through an Internet application or through an integrated connection with the insurance company. The company customers will be billed each time an insurance inquiry is completed and the customer will be invoiced each month. The key functionalities include Collect Insurance Data, Load Insurance Policies, Access Insurance Data, Bill Customers, Maintain Insurance Company Information, Maintain Product Information, Maintain Customer Information and Archive System Data
Responsibility:
- Analyzed the Requirements for the NIDB Website
- Prepared the Design Documents for the Business Components and WebPages
- Developed the Business Components and WebPages using C#.
- Created the Test Cases and necessary Test Data to test the Website.
- Performed the Unit Testing for the Components and Website.
- Supported the onsite team during System and Integration Testing
Environment: C#, ASP.NET, ADO.NET, HTML, JavaScript, SQL Server 2000, MSMQ, COBOL
Client: Confidential, Feb 2004 - July 2004
Project: CSI (Customer Service Index)
Description: The Customer Service Index (CSI) aimed at automating the process of evaluating the performance of the employees of Schwans on a monthly basis, calculating the incentives that they would be eligible for, setting targets for the next month and sending the incentive information to the payroll system. The system also allows the targets of the new month to be changed at any point during the course of the month.
Responsibility:
- Took up to the designing and development of the core batch applications of the project.
- Designed the "modify baselines" site used in the project, which was later developed in ASP. Net.
- Was involved in the development of Unit and System test cases for the project and performed both Unit testing and System testing.
Environment: C#, ASP.NET, ADO.NET, HTML, JavaScript, SQL Server 2000, MSMQ, COBOL
Client: Confidential, Sep 2003 - Feb 2004
Project: CC Telemoney Replacement
Description: CC-Telemoney replacement project emerged because the client Schwans wanted to replace the third party credit card processing tool Telemoney, which processed data from a tilda ‘~' separated file, with another third party tool called Super Charge which processed XML files and did not want any further changes in third party tools to affect any of the programs. For this we brought in a Schwans format and made all Schwans programs to interact in this format. And we had BizTalk Server 2002 to map this format to the format required by other third party tools.
Responsibility:
- Took up the design and development of the Application Integration Components (AIC's) using C#.
- Programmed with BizTalk Server 2002 to achieve integration with the C# code.
- Also developed Unit and System test cases for the project and performed both Unit testing and System testing.
Environment: C#, ASP.NET, ADO.NET, HTML, JavaScript, SQL Server 2000, MSMQ, COBOL, BizTalk Server 2002
Client: Confidential, Aug 2003 - Sep 2003
Project: Explore Next Generation - Explore NG
Description: The Explore NG aimed at providing an interface to the client to help the storing and maintenance of its customer, product and shipment information.
Responsibility:
- Developed and tested few serviced components in C#.
- Unit Tested the Explore NG site.
- Was involved in the coordination of the onsite - offshore communications on the proceedings of the module.
Environment: C#, ADO.NET, SQL Server 2000
