Project Manager
Resume:
Akanksha Bhatt
Edison, NJ
********.*****@*******.***
Summary and Highlights
• More than 7 years of experience in IBM AS/400 iSeries Application development design, process analysis, and GUI design.
• Broad working knowledge and command over key skills, including but not limited to: SYNON, COBOL, DB2, SQL, QUERY/400, SQLRPG, Java, IDMS, DB2/400, RPGLE, RPG400, RPG Free form, RLU, SUBFILE, CL, CLLE, CONSTRAINS, Database Journaling, Procedures, and C++.
• Functioned as a Lead Systems Developer (Full-time employee), Senior Programmer Analyst, Consultant, and System Analyst in various aspects of SDLC and helped to develop and maintain applications on the IBM iSeries.
• Extensively worked on IBM iSeries to develop applications for clients on-site and off-shore.
• Major clients involved have been leaders in the publishing industry, retail business, and insurance service industry worldwide.
• Demonstrates strong problem solving and excellent analytical skills, with clear understanding of business concepts.
• Excellent communication skills and flexible ability to work as part of a team or independently.
• Highly motivated and energetic.
• Understands client’s requirements thoroughly and focuses energies on activities that directly impact the deliverable to the customer while maintaining quality standards. Satisfies tight deadline requirements.
Technical Skills
Operating Systems : OS/400, UNIX, MS-DOS, Windows (all versions)
Languages : SQL, I-SERIES, RPGILE, RPG free-form, RPG/400, RPG/IV, COBOL
Job Control : CL Programming (CL/400, CLLE)
Databases : DB2/400.
Other Tools : SYNON/COOL:2E/Advantage:2E, IBM Client Access/400, DB2 File Manager, Hawkeye, DBVisualizer, SEU, RLU, PDM, DFU, ISDB, DDS, Subfiles, Message Files, Printer files, Query, Debugger, Change management.
Hardware : AS/400, V2R2, V2R3, V3R3, V3R4, V4R5
Software (ADTs) : SDA, QUERY/400, SQL/400, DB2/400 Programming for AS/400 V2R2 V3R4, Program Development Manager, Data File Utility, Source Entry Utility, Report Layout Utility, MS Visual source safe, Visio.
¬Professional Experience
John Wiley & Sons, Somerset, NJ May 2009 to Present
Lead Systems Developer (Full-time Employee)
Wiley is a global publisher of print and electronic products, specializing in scientific, technical, medical and scholarly journals, encyclopedias, books, and online products and services; professional/trade books, subscription products, training materials, and online applications and websites; and educational materials for undergraduate and graduate students and lifelong learners..
Responsibilities:
• Prepare functional specifications for new business requirements and enhancements.
• Work with third party vendors for major Distribution Fulfillment projects.
• Joint management of Radio Frequency Identification (RFID) project across multiple phases that involved design and implementation for order fulfillment, returns processing, and data communications with vendors. Designed, coded, and enhanced logic for RFID functionality for conveyor systems, small parcel systems, and returns processing stations. The RFID project spans four facilities and includes subsidiary operations in Canada and Singapore.
• Worked on major warehouse management system (WMS) implementation between client and third party distribution vendor.
• Designed, coded, tested, job setup, implemented and presented credit card encryption-decryption processes. This assignment was very important component in moving JWS forward in achieving PCI compliance. One very important aspect of this effort included a new method for re-encryption of customer credit card numbers resulting in an encryption process that would not allow visibility to the encryption key.
• Unit and integration testing, preparation of test results documents, verification and validation of final solutions. Coordinate issue resolution with team members to ensure stable launch to production environment.
• Took initiative to reduce the time of data receiving from PAVE (RFID vendors) from 72 hours to 15 min. Worked with our 3rd. party providers (MOBILEXE & EXTOL) to completely rewrite the E2E. This involved XML schema writing.
• Successfully Simplified, recoded a very complex "spaghetti like" process that directly supported the send of ASN data to our global subsidiary partners (Australia) from both the USDC and RRD. This allowed Australia to vastly improve their receiving process for global partner shipments.
• Work as on-call person to support systems & processes 24x7.
• Involved in designing and creating logical files and physical files with DB2.
• Use structured programming input/output and logic control operations.
• Involved in designing and creating reports, often for senior management data analyses.
• Involved in data FTP communications to and from different systems.
• Validate and manipulate data using SQL.
• Develop new programs using SYNON, RPG, ILE, and CL/400 for the AS/400 platform.
• Develop complex sub-files which handle multiples files simultaneously.
• Carry out detailed analyses of existing systems developed on AS/400 using I-SERIES and CL.
• Transport developed and changed modules to test and production environments using change management tools and resolve associated complex issues.
Environment:
AS/400, SYNON, RPG, ILE, RPG Free-form CL/400, SQL/400, DB2/400, PDM, CM, XML and OS/400
Walgreens Co., Lincolnshire, IL May 2007 to April 2009
Lead Programmer/Analyst
SIMS (Vendor Receiving and Ordering)
Walgreens is one of the largest pharmacy chains in the world, with over 6000 spread across the USA. Walgreens is considered the leader in innovative drugstore retailing. Walgreens pioneered many store features over the last two decades that are becoming standards in the industry.
The project is designed to increase the efficiency of Stores by reducing inventory costs and outs on the shelves. It automates almost all major store operations. This application runs on all 6500 stores of Walgreens and is a major focus area in their future business strategy.
Walgreens is focusing on restructuring the Retail, Merchandising & Inventory Systems in their organization. Main aim is to providing application development and enhancement services in order to formulate a proper strategy and implementation.
Responsibilities:
• Prepared functional specifications based on client requirements and worked in conjunction with team members to receive project approval.
• Designed and developed program code.
• Supported the live stores to resolve production problems.
• Performed unit and integration testing, documented test results, and validated final solutions.
• Coordinated with User Acceptance Testing (UAT) team and fixed bugs promptly to ensure promotion to production system within specified deadlines and SLA.
• Coordinated with off-shore teams to gather exact requirements and to achieve objectives within the required time frame. Carried out detailed analyses of the existing systems.
• Involved in designing and creating logical files and physical files with DB2.
• Used structured programming input/output and logic control operations.
• Involved in designing and creating management reports.
• Utilized FTP for data and objects from different systems.
• Validate and manipulate data using SQL and DBVisualizer.
• Developed new structure programs using SYNON, RPG & CL/400 on the AS/400 platform.
• Performed error resolution with production applications in I-SERIES, CL and COBOL.
• Developed complex sub-files which handle multiples files at a time.
Environment:
AS/400, SYNON, RPG, COBOL, CL/400, SQL/400, DB2/400, PDM and OS/400
Wisconsin Educational Associates (WEA), WI April 2005 to March 2007
Lead Programmer
WEA Legacy Maintenance project
The Maintenance of AS400 Legacy System for Wisconsin Educational Associates (WEA) Trust involves maintenance and support of Claims and Eligibility applications on AS/400.
The Project undertakes maintenance of Claims and Eligibility applications of WEA Trust based on Change Requests in a cost effective and quality-oriented manner
Responsibilities
• Involved in designing and creating logical files and physical files with DB2.
• Developed complex sub-files using RPGIV, DB2, and RPGLE which handled multiples files.
• Analyzed and resolved issues related to the abnormal termination of programs.
• Involved in designing and creating indexes, primary keys, and secondary keys in DB2/400.
• Used structured programming input/output and logic control operations using RPGIV, RPGLE and CL.
• Involved in designing and creating reports using SDA and RLU.
• Validated and manipulated data using Query/400 and SQL/400.
• Developed programs using RPG/400 and CL/400 on the AS/400 platform.
• Carried out the detailed analyses of the existing systems developed on the AS/400 using RPGIV, RPGLE, and CL.
• Prepared functional specification documentation.
• Performed unit and integration testing and preparation of test results documents.
• Coordinated with UAT team and immediately resolved errors reported by the team.
• Utilized data storage and retrieval processes using SQLRPG, SQL/400 and DB2/400.
• Ensured timely implementation and followed strict adherence to deadlines.
• Followed the project execution process to meet all department process standards.
Environment:
AS/400, RPG IV, ILE RPG, CL/400, SQL/400, DB2/400, SDA, RLU and OS/400
Additional Projects
A summary of other assignments that I have handled in chronological order:
Organization Hexacom India Ltd.(Oasis Cellular), Jaipur, India
Project Title RF Planning in GSM Technology
Description Study of frequency allocation to GSM towers
Role Monitor frequency ranges of towers during call transfers. Report any abrupt changes.
Responsibilities Minimize the change factor by adjusting the frequency allocation to various towers thereby increasing call flow and managing call traffic.
Project Title Automatic Laser Detection and Defense System
Description Laser-controlled defense for Border Security using a mesh of lasers and identification logic.
Role Team Leader & Programmer
Responsibilities Analysis, design and coding
Languages C/C++ Java
Education
Bachelor of Engineering
Electronics and Communication
University of Rajasthan
Jaipur, India
Contact this candidate