SUMMARY

• Highly successful IT Professional with:
• 2 years experience in Logistics and Customs Brokerage
• 5 years of experience in Auto Insurance Direct General Corporation
• 6 years of experience in Retail - Costco Wholesale and HEB Grocery
• Excellent Development/Testing skills
• Hands on experience on all phases of project life-cycle
• Good exposure to Web-based/Client-Server technologies
• Expertise as Business Analyst
• Knowledge of Waterfall Life Cycle models and Rational Unified Process
• A team player with:
• Excellent communications skills.
• Strong analytical, design skills and problem solving abilities.
• Result oriented, self-starter and able to work with minimum guidance.
• Proven ability to understand business problems and apply technology to formulate workable solutions.

SKILLS SUMMARY

EXPERIENCE HIGHLIGHTS

Confidential is one of the largest 3rd party logistics companies in the world, providing integrated global supply chain management solutions including transportation, warehousing, customs brokerage, freight forwarding, and import and export consulting services.

Responsibilities:

• The role is of a Sr. Systems Analyst with the following responsibilities - understanding the requirements as per requirements from Project Management team, creating design documents, developing and testing of code, setting up and assistance for User Acceptance Testing, post-install support, issue resolution/closure of tickets on issue-tacking application, communication with users, and communication with vendors for 3rd party application upgrades and maintenance.
• Played important role in migrating/upgrading the AS40, and portability testing of applications pre-migration, ensuring smooth transition of applications to the new environment, thereby utilizing and enhancing knowledge of operational support and work management on the AS400 - such as migrating job scheduler, printer maintenance, IO box maintenance, maintaining directory entries, out queue maintenance, job queue maintenance, subsystem maintenance, user profile maintenance.
• Confidential is a non-standard auto insurance provider, spanning across 13 states in the US. It also provides other add-on products such as life insurance and travel protection.

Responsibilities:

• The role was of a Sr.Programmer Analyst with the following responsibilities - understanding the requirements as per the design specs created by the Project Management team, creating technical specifications document, programming the code as per the design, unit testing the code, providing support to the client-server team and the user groups during integration/acceptance testing, source maintenance using ALDON ANALYZER, promoting the code to production box, data maintenance on the production box as per the project requirements, and once in a quarter production support and on-call support.

Confidential

• This project is implemented for a Grocery Company, which is one of USA's largest independently owned food retailers with stores throughout Texas and Mexico. The scope of this project is to transition the Production Support of altogether 150 different applications. The role was to take the lead of transition activities for the AS400 applications and some of the client-server applications.

Responsibilities:

• I was involved in analyzing the applications and transitioning knowledge to offshore team. I was also involved in gathering the user request, creating design documents as per the requirements, coding and testing the code before installation into production environment. The responsibility also involved maintenance of the existing code, user administration, and interaction with the software vendors for application patches and support. The AS400 application support involved maintenance of programs, creation of new programs, and preparation of queries/reports for the users.
• I was also involved in supporting the windows client/server applications - Transman/SQL, YMS, AXAPTA and XLR.

Confidential

Business Analyst

The role was that of a Business Analyst, for a Grocery Company, which is one of USA's largest independently, owned food retailers with stores throughout Texas and Mexico. The scope of this engagement was to work as part of their Strategies and Planning team.

Responsibilities:

• The initial assignment involved analyzing a decentralized system reaching the end of life/support and residing on an outdated environment, interacting with the vendor, presenting the information collected to architects, DBA and managers, and deciding on the centralized or decentralized higher versions of the system, as well as the environment to deploy the new system. The documents created included an Application Profile document on the applications residing in the In-Store Processor ISP , Evaluation Matrix sheet with weighted scores for the suggested systems, Scope Definition document, Project Charter, and Detailed Requirements document.
• Based on the above work the client specially requested me to continue on several other assignments which involved analyzing the needs/requirements of the users/business, discussion with other stake holders, identifying and evaluating suitable systems satisfying the goals and objectives and identifying the risks and constraints. The deliverables included Scope Definition, Evaluation Matrix, Resource Planning Worksheet, Project Charter, and Detailed Requirements documents. One of the assignments also included assisting the Project Manager in capturing the detailed requirements by conducting Use Case workshop with the stakeholders.

Confidential

Warehouse Manager Dashboard

The project aims at creation of a dashboard on the AS400 to view the key metrics at various departments in the store. This helps the manager to view various metrics in a single place, and take remedial actions as soon as possible.

Responsibilities:

I was involved in analyzing the requirements test planning, test environment setup, test script creation, scheduling the testing, bug tracking and reporting, conducting Bug Triage meetings, and managing the testing activities.

Confidential

Warehouse Relocation

The project was executed for the electronic transfer of inventory records from the old location to the new location.

Responsibilities:

I was involved in the creation of test scripts and testing of the programs.

Confidential

International Purchase Orders

The project aimed at separating the creation of international purchase orders from the US purchase orders.

Responsibilities:

My involvement in the project was to act as a liaison between the client and the offshore test engineers, collect and transfer the information to the offshore test team, review the test scripts created at offshore, and managing the test team.

Confidential

Operations Accounting Rewrite

The project was to test the Accounting System rewritten, as part of producing a better system conducive for future enhancements.

Responsibilities:

I am involved in requirements analysis, managing the offshore test engineers, test planning, test environment set-up, creation test scripts, integration testing, parallel testing, user acceptance testing, bug tracking and reporting, conducting bug triage meetings, and providing consolidated test status reports.

Confidential

Labor Scheduling

The project was to develop a system for reporting anticipated business and help estimate for the labor required at the POS registers.

Responsibilities:

I was involved in interacting with the client, managing the offshore development team, analysis, creating design specs, and unit testing the programs.

Confidential

Order Power Holiday Stabilization

The project involved enhancements to the client's Order Power system, before the Holiday season. During the Holiday season the client expects larger traffic on their E-com business. The project ensures that the system stays stable during this period.

Responsibilities:

Involved in the analysis, design, coding and testing of the programs modified. Acted as the Technical Lead, Coding Standards Champion and Configuration Controller for the project.

Software Used:

RPG/400, ILE RPG, CL/400, SEU, SDA, DFU, RLU, Hawkeye, TURNOVER, DB2/400.

Confidential

Tire Center Automation Maintenance

The project involved identifying the cause of certain bugs in the client's Tire Center application and fixing these bugs. It also involved enhancements to the existing system used at the Tire Center.

Responsibilities:

Involved in analysis, design, coding, testing and interaction with the onsite team. Acted as the Point of Contact at offshore.

Software Used:

RPG/400, ILE RPG, CL/400, SEU, SDA, DFU, RLU, Hawkeye, TURNOVER, DB2/400.

Confidential

Quarter End and Year End Processing

The project involved applying customizations to the Quarter End and Year End programs downloaded from the Lawson website. It also involved applying patches to hese programs. Patches are program changes supplied by Lawson after they release the latest version.These programs are used for reporting the Quarterly and Yearly taxes, to the State and the Federal Governments.

Responsibilities:

Involved in analysis of the customizations to the code, design, coding, testing and interaction with the onsite team. Acted as the Point of Contact at offshore.

Software Used:

RPG/400, ILE RPG, CL/400, SEU, SDA, DFU, DB2/400.

Confidential

Warehouse Depot Maintenance

This project involved the maintenance of programs involving warehouse and depot details. The TLOG phase of the project involved replacing 4 database files in the existing system with 4 new database files, and applying modifications to the Warehouse and Depot programs that use these files.

Responsibilities:

Involved in analysis, design, coding and testing the changes made to the programs. Acted as developer during the execution of the project.

Software Used:

RPG/400, ILE RPG, CL/400, SEU, SDA, DFU, RLU, DB2/400, Hawkeye, Turnover, Query/400.

Confidential

Lawson Upgrade

The Lawson Upgrade project consists of migration of Lawson HR Module ERP Package of the client, from version 6.1.1.7 to version 7.2.2.3. This includes database changes, incorporating these database changes in the programs, converting RPGs RPTs into ILE RPG and customizing the package as per the customer requirements.

Responsibilities:

• Involved in analysis of existing programs, preparation of design specifications, modification of the original programs, code reviews and testing.
• I was a Module Lead and also the Lead for the Extended Onsite Team at offshore during the execution phase of the project. Also, acted as Onsite Coordinator during the system support phase, and was responsible for 24x7 on-call support during this period.

Software Used:

AS400, Lawson, RPG/400, ILE RPG, CL/400, ILE CL, SEU, DFU, DB2/400.

Confidential

This project involved adding code to existing modules to accommodate two logic paths within each of the programs, one for English users and another for French users of the same application. This also involved adding French screens in addition to the existing English screens and also incorporating changes in the database to include French descriptions.

Responsibilities:

Involved in analysis, design, coding and. Acted as developer during the execution of the project.

Software Used:

RPG/400, ILE RPG, CL/400, SEU, SDA, DFU, RLU, DB2/400, Hawkeye.

Confidential

This project was an enhancement over my previous project Productivity Reports. This was for the 1- Hour Photo department of the client. This project had maintenance as well as report programs. This project was to measure and grade different warehouses depending on their productivity potential.

Responsibilities:

• Involved in design, coding and testing. Acted as developer during the execution of the project.
• Software Used:
• RPG/400, ILE RPG, CL/400, SEU, SDA, DFU, RLU, DB2/400.

Confidential

The project was to develop an automated reporting system for the 1-Hour Photo and Optical departments. This would allow the regional managers and the corporate office to access labor information and compare that to sales, productivity and other variables. The reports had to be generated timely so that regional managers could respond and react to labor overages or deficiencies. Regional managers could easily measure trends, holiday productivity and week-by-week activity.

Responsibilities:

Involved in design, coding and testing the programs. Acted as developer during the execution of the project.

Also, involved in the maintenance phase of this project after its delivery to onsite, which included changes to existing programs, and resolving issues that existed in the system.

Software Used:

RPG/400, ILE RPG, SEU, SDA, DFU, RLU, DB2/400.

Confidential

The Client usually takes back the returns when the material is not to the satisfaction of the customer. These materials would have been sold on a rebate. The projects aim was to help the warehouse personnel to identify the returns with an active rebate.

Responsibilities:

Involved in design, coding and testing of the programs. Acted as developer during the execution of the project. Also, was responsible for interacting with onsite team.

Software Used:

RPG/400, ILE RPG, CL/400, SEU, SDA, DFU, DB2/400.

Confidential

The project was to recreate the Freight Matrix Maintenance system for improving their Freight functions. A new module was developed that accepts and maintains the parameters for calculating the cost of shipping an item from one location to another.

Responsibilities:

Involved in design, coding and testing of the programs. Acted as developer during the execution of the project. Also, was responsible for interacting with onsite team.

Software Used:

RPG/400, ILE RPG, SEU, SDA, DFU, DB2/400.

The project was executed for Private Mortgage Insurance. This was a reverse engineering project which involved analyzing the existing RPG programs, figuring out the program logic and preparing the flow charts, which in turn makes a lot easier for converting the code to other languages.

Responsibilities:

Involved in analysis, review of the detailed flow charts and Data Flow Diagrams DFD prepared in MS Visio.

Software Used:

RPG/400, CL/400, MS Office, MS Visio.