Informix Technical Analyst

Profile Summary

Result driven individual and technically proven leader with significant experience of 6+ years, predominantly in Informix 4gl Programming using UNIX, SQL with working in full product life cycle. Designed, implemented and supported complex business applications by playing both as a Project Lead and Technical Lead roles by effectively handling a small-sized team in providing quality deliverables and satisfaction to my Customers.

Experience Summary

• Experience in Analysis Design Development and Deployment of Informix in an enterprise environment and handling multiple projects

• Optimizing Informix SQL / 4GL programs

• Extensive knowledge with Unix Shell and Awk Scripting

• Experience in Quality Assurance testing Unit testing and User Acceptance Tests

• Intermediate C programming

• Provided technical support to customer enhancement and support department

• Familiar with EDI 810 820 inbound/outbound transaction sets

• Familiar with POS (Point of Sale), Ordering systems in Retail Industry

• Familiar with Rational Clearcase and Clearquest

• Familiar with Make files, Open Make

• Provided Informix programming and standards training to employees and customers.

Job Experience

Client/Company: The Home Depot, Store Support Center, Atlanta, GA / Tata Consultancy Services Ltd

Title: IT Analyst

Project: Special Services

Project Duration: February 2007 - Present

Project & Role Description

The Home Depot is the world’s largest home improvement specialty retailer and the second largest retailer in the United States. THD operated a total of 2079 retail stores in US, 143 stores in Canada, and 57 stores in Mexico. Special Services deals with ordering special order products at Home Depot stores. This application is widely used by store associates to order special/customized products for the Home Depot Customers. Few projects worked by me in special services includes

1. Ecatalog ordering: Fetching special order data to order special order products from catalog database maintained with latest products and catalogs from all vendors. This is to reduce the time spent by store associates over the systems and to help customers on the floor.

2. Provider Net: Application that can be accessed by the product or service providers/vendors to view, confirm and cancel the purchase orders. This application eliminates sending of purchase orders through manual or Auto fax. And the purchase orders are sent instantly through EDI.

3. Central Customer and Order Database: Maintaining a central database for all customer and order related information for all 2000+ stores

As a Technical Lead, my responsibilities include:

• Analyze Business Requirements to identify IT solutions (enhancements to existing solutions, or design of new ones) and migration strategies

• Look at requirements and solutions from an enterprise-wide point of view, i.e., across applications

• Work with Application Architects and others who understand the design of specific applications in detail

• Participate in the High Level Design (HLD) and Application Interface Design reviews to ensure applications implement the Solution Approach

• Help resolve architectural, deployment and support issues

• Design the application components and facilitates the working environment for the application development team members.

• Deliver the architectural deliverables to the client.

Tools Used: HP-UX, Linux, Microsoft Projects, Informix Database, Rational Unified process tools such as Clearquest, Clearcase.

Client/Company: Hewlett-Packard, Bangalore, India/Tata Consultancy Services Ltd

Title: System Analyst

Project: HP-UX Standard Library LibC – Current Product Engineering

Project Duration: October 2004 – February 2007

Project & Role Description

The LibC CPE (Current Product Engineering) team at HP-ISO owns around 1000 Application program Interfaces (APIs). The Support includes fixing Hotsites, Critical and Severe Defects, Enhancement Requests for future changes in HP-UX C Library. As a system Analyst, the scope of role includes product production support, design, development and Testing.

My responsibilities were:

• Analyze and redesign of Existing C Library Functions

• Act as Release coordinator for all versions of HP-UX Releases (HP-UX 11.00, 11.11, 11.23 and 11.31 Versions)

• Work on Break Fixes and Enhancements

• Handle Hotsites. Hotsites are hot defects that have high impacts on customers of HP. These defects will be handled with high priority.

• Development and Enhancements of new C library Functions

• Address Customer filed critical and severe defects as part of production support

• Documentation and Reporting

• Review of the System designs

• DP (Defect prevention) prime of the project

Tools Used: HP-UX UNIX Servers (PA-RISC and IPF Architectures), HP-UX 11.11, 11.23 and 11.31, UNIX, C, Shell Scripting, Makefiles, HP-UX ClearCase, HP-UX Jazz, Debuggers, Flexelint tool, CCover and Purify Tool.

Client/Company: Hewlett-Packard, Bangalore, India/Tata Consultancy Services Ltd

Title: Component Tester

Project: HP-UX Standard Library LibC Testing

Project Duration: May 2004 - October 2004

Project & Role Description

The Objective of the project is to test the application programs interfaces (APIs) of HP-UX C library both on PA-RISC and IPF processor based releases. The C library will be released as General Release/Site Specific patches and Regression and Compatibility testing will be run across various releases.

As a Component Tester, my primary responsibilities include:

• Triaging Test Failures

• Fixing Bugs in LibC Test Suites

• Testing the patches released by LibC Development Team

• Analysis of Test Results and fixing Environmental Related Errors.

• Fixing Test case defects based on LibC Component quality initiative

Tools Used: HP-UX UNIX Servers (PA-RISC and IPF Architectures), HP-UX 11.11, 11.23 and 11.31, UNIX, C, Shell Scripting, Makefiles, HP-UX ClearCase, HP-UX Jazz, Debuggers, Flexelint tool, CCover and Purify Tool.

Education

University/College Degree Year

Bharathiyar University, India Bachelor of Engineering with specialization in Mechatronics Engineering 4/2003

Training/ Continuing Education

Course Company/Vendor Date Taken

Training on Informix and 4gl Programming Tata Consultancy Services, Atlanta February 2008

Training on Unix Programming Tata Consultancy Services, Chennai August 2007

Training on ClearCase and HP-UX Jazz Tool Hewlett-Packard, Bangalore March 2006

Email Etiquettes Tata Consultancy Services, Chennai January 2005

Initial Learning Program Tata Consultancy Services, Chennai April 2004

Training Conducted

Course Presented To Date Taken

IBM Rational ClearCase & ClearQuest Tata Consultancy Services, Atlanta February 2010

Prokeytag and Its uses for pro-customers of The Home Depot. The Home Depot Special Services Team, Atlanta November 2009

Introduction to Special Services System and Special Order Services Improvement The Home Depot QA team, Atlanta September 2008

Knowledge Sharing Sessions on Customer Order Database and Central Customer Database The Home Depot Special Services Team, Atlanta March 2008

Knowledge Sharing Sessions on “Basics of OS” Tata Consultancy Services, Chennai August 2005

LibC Start-up, Assembly Stubs, Makefiles. Tata Consultancy Services, Chennai December 2004

Certifications

Certification Certification Status Year Certified

Brain bench – C programming Completed 2005

Brain bench - Unix Completed 2007

Skills

Operating System Unix, Windows, HP-UX

Languages Informix 4gl Programming, C, Unix, Shell Scripting, Java

Databases Informix database, SQL

Testing Tools HP – Test Director, IBM Rational Clearcase and Clearquest, Makefiles

Software Previews MS Office, Share Point server 2003, 2007

Personal Details

Date of Birth October 4, 1981

Sex Female

Nationality Indian

Marital Status Married

Date of Joining April 7, 2004

Designation IT Analyst

Location Atlanta, GA, United States

Passport Details F6863835

Issued at Chennai on March 29, 2006

Valid up to March 28, 2016

Visa Currently on H1B US Visa (Valid upto April 2012)

Contact Numbers Cell Ph: 404-***-****

Home Ph: 404474243

Email Id *****.************@*****.***

Reference

Provided upon request.

Contact this candidate