SAMUEL KOLAGANI

Cell: 614-***-****

ada2q3@r.postjobfree.com

HYPERLINK "http://www.linkedin.com/pub/samuel-kolagani/1a/596/a68" \h Samuel Kolagani LinkedInhttp://www.linkedin.com/pub/samuel-kolagani/1a/596/a68

SUMMARY:

Programmer Analyst/Project Lead with 18+ years’ experience in AS400 technology and 2+ years in enterprise web applications using J2EE technologies, WebSphere.

Expertise in Property and Casualty Insurance, Manufacturing, Logistics, Distribution and Banking domains

Expertise in System Analysis, Design, Development, and Maintenance skills of AS/400 platforms and IT systems running RPG/IV ILE (Free Format), RPG 400, RPG III, CLP, SQL/400, ALDON, MKS(Implementer), Hawkeye.

Experience in trouble shooting database files using SQL.

Excellent in Integration, System and Manual testing and providing UAT Support.

Technical Management of complete End to End software project life cycles and leading teams to meet the defined targets with high standards of quality.

Good experience in documentation; have created System Appreciation Document, Functional specifications, User Manual, Technical Design documents, Integration Test Plan, Unit Test Plan documents.

Evaluated numerous complex system problems and user requirements. Developed the ability to provide structured and modular solutions.

Proficient in managing multiple priorities and projects within tight deadlines.

Excellent analytical and problem-solving skills.

Expertise in Production support, solving production problems and providing permanent solutions.

Possess excellent communication, interpersonal skills and ability to work in a team as well as individually.

Excellent client relation skills and the drive to complete tasks effectively and efficiently where customer services and technical skills are demanded as well as the ability to communicate effectively with all levels of management and client community.

Authorized to work in the US for any employer

Technology Details:

Language: ILE RPG, RPG IV, RPG-FREE, (Embedded/Dynamic)/SQL, RPG/400, RPGIII, CL/400, COBOL/400, Embedded-COBOL/400,

Store Procedures

Job Control: CL Programming (CLP), SQL-Triggers, iSeries Navigator

Systems: AS400, iSeries(V7R2)

Tools: Query/400, RLU, DFU PFE, PDM, RSF, HAWKEYE, APLUS, STRANT,DBU40,ALDON, MQ, Lotus Notes, WDSC,FTP,SFTP, WebSphere

Implemented Database constraints (primary, unique, referential and check), SQL Stored procedures, Triggers.

DB2/400: DDS-Physical Files, Logical Files, Join Files, Data Dictionaries

Screen Design Aid (SDA): Menus, Display Files, Sub-file Programming

File Transfer Protocol (FTP) : Query/400 and Open Query File (OPNQRYF)

System Administration-PTFs : System Values, Basic Configuration

Security Administration-User Profiles, Authorization Lists, Object Authority

ROBOT Job Scheduler.

Operations- Backup & Restore, Print Management, Job Scheduler

UIM User Interface manager, IBM MQ Series API set, WebSphere

DDM Distributed Data DS, DDL HTML, XML

VISIO Flowcharting Software,

Change Management software -ALDON, MKS(Implementer), Hawkeye

Clarity, Lotus Notes, HP-ALM, Service Now, Peregrine, WDSC, JIRA

Web Technologies: JAVA2.0, WebSphere, Tomcat, Eclipse, DAO, HTML and XML, JSF

Knowledge of SYNON

Professional Certifications:

●Oracle Forms Developer Certified Professional (OCP)

●Oracle PL/SQL Developer Certified u (OCA)

●Master RPGIV certification- Brain bench

●Oracle Certified Professional, Java SE 6 Programmer

EDUCATIONAL QUALIFICATION:

Masters of science Degree in Electronic from ANDHRA UNIVERSITY,

VISAKHAPATNAM, 2000, A.P INDIA.

PROFESSIONAL EXPERIENCE:

Hub Group Sr. RPG Developer

Chicago, IL June 2018 to Current

Hub Group (NASDAQ: HUBG) is a transportation management company in North America, providing intermodal, truck brokerage and logistics services.

Hub Group customers and Vendor extracted and setup in the new Cloud ERP Financials

database. From that point forward ERP Financials will be the source system for Hub to updates and new accounts will be sent from the Cloud ERP Financials system and shared with the TPS customer database for as long as customer invoicing will be run in TPS.

Hub Group customers and Vendor extracted and setup in the new Cloud ERP Financials

database. From that point forward ERP Financials will be the source system for Hub to updates and new accounts will be sent from the Cloud ERP Financials system and shared with the TPS customer database for as long as customer invoicing will be run in TPS.

Projects included:

Import TM/TPS Customer/Vendor to ERP

Import TM/TPS -AR/AP Invoice to ERP (65K Invoices per day)

Import TM/TPS Shipments to OTM (SAW- Shipment-Invoice-PO and Carrier invoice

Import TM/TPS Purchase orders and Carrier Invoices OTM

OTM to matches the SAW (TPS purchase order) to the Carrier invoices and approves and creates voucher to ERP

Involved in design, enhancement and development for Implementation of Web services on applications

Create new RPG and SQLRPGLE programs to Migrate the Financial (AR and AP Invoices) from AS400 to third party vendor ERP System.

Coordinate with the business partners in designing the XML Schema definitions (XSD) and worked extensively on XML to transfer/receive Inbound and Outbound feeds.

Mentor and assisted team members in understanding the about Interfaces connected to Applications thru Webservices.

Efforts entail architecting platform with ability to connect to the following: AS400 DB2 Database; SOAP Web Services; HTTP Request/Response Model Services.

Projects were managed in an Agile (Scrum) framework and ticketed with JIRA.

Responsibilities:

Analyzing and translating business requirements to technical requirements

Involved Requirements gathering and created mapping documents for ERP XML tag/DB2 fields.

Used Jira/Agile methodology to develop the project.

Created complete Architect design and development.

Involved in developing 12 Programs without deviating to organization standards.

and used latest AS400 concepts to populated xml files 1MB size

Involved in different testing like unit testing, DA testing, Client QA testing, UAT

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, Fully Free RPGLE, (XMLSERIALIZE, XMLTABLE, XMLPARSE,XMLAGG,XMLELEMENT,XMLFOREST)

DDL and DML, Web Service, RPG/400, CLLE, DB2/400, MKS, IBM-RDI.9.5.1, XML, SOA, OTM, ERP, NetBeans.

Follett, Chicago, IL Tech Lead /Architect

Integrative-systems Nov 2017 to May 2018

Follett has more than 2000 bookstores across US in different universities and involved in retail business. As all the applications are migrating from JDA to MMS (material management system). Currently Tickets/labels are being created and printed by using a windows-based application WINDSS, But Now this project is to migrate to MMS and have capable to print tickets from web based application.

Ticket printing project is mainly classified as 4 parts depends on the time of generation and printing the labels.

1) When PO receiving (either fully/partial receiving), system will generate ticket batch

2) During PO Adjustment (Positive adjustment), ticket batch will be generated

3) During detail and ASN receiving, ticket batch will be generated

4) Manually user can create/maintain ticket batches(On-demand)

Basically, this project intended to create labels for the required SKU based on its UPC/ISBN, department details to handle 8 different ticket types and need to send to different types of printers (using Zebra and Cognitive printers). Batches will be created and can be maintained with many validations when required. Labels contain different parameters like barcode (EAN13+5 / Code39), item description, Author description, price etc., All these details will be fetched from the system at real time and is achieved by using SQLRPGLE programs.

Responsibilities: Actively participated in

Working as an on-site coordinator

Requirements gathering from the client and concerned teams

Analyzing and translating business requirements to technical requirements

Designing the programs and screens required

Guiding off-shore team and Developed programs using RPGLE, CLLE, Websmart, Presto screens

Involved in developing 15 Programs without deviating to organization standards.

Involved in different testing like unit testing, DA testing, Client QA testing, UAT

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CLLE, DB2/400, MKS, IBM-RDI.9.5.1, Zebra language, Cognitive language,

WEBSMART 11.3, Presto 5.6

Hardware: Barcode Scanners -Motorola

Label Printers: Cognitive-Advantage LX, Zebra-LP2824

CSS, Inc. Sr. RPG Developer/Architect

Werner Enterprises, Omaha, NE May 2017 to Oct 2017

Werner Enterprises is a very large transportation and logistics provider. Its core transportation software, billing, accounting, truck/trailer maintenance, and other software applications rely on multiple IBM System i's which are AS/400-based. Modernizing and web-enabling its applications has been an important goal for Werner, which is one of the reasons it has engaged CSS’s IT consulting services. On the IBM i platform, modernizing includes web enabling database applications that are written in Integrated Language Environment (ILE) RPG.

Currently on TLE- EDI 6.1 in a logistics environment (204,210,214,990…etc) on ISeries. With a base of 500+ trading partners, active, trading partner setup, mapping

Architectural design for Processing EDI Transaction into DB2 files using

MQ Series and XML.

Converting old TrustedLink System i (TLi) web database system with a newer RPG IV system.

Understands transportation industry EDI X12 standards and transaction sets for transportation and logistics.

Created SQL Scripts and MQ programs and Updated Production Programs

To complete 204,990 and 210, 214 transactions.

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CL/400, DB2/400, MKS, IBM-RDI.9.5.1,MQ Series, EDI X12 and XML, NetBeans, MQExplorer, Sterling B2B Integrator, SoapUI, Note++, RFHUTIL v7.5.0, X-Analysis 12.0.6

Apex Systems, Inc. Sr Programmer/Analyst

USFOODS Rosemount, IL Mar2016 to April 2017

ACOP: US Foods is one of America's leading foodservice distributors to restaurants, healthcare and hospitality facilities, government operations and educational institution.

Application ACOP provides for cut floor operations, finished goods costing, and analysis of yields. ACOP seamlessly integrates orders, invoices, and prices between Stock Yards districts and their customers, both broad-line division customers and direct customers. ACOP also provides the tools for counting and valuing WIP (work in process) inventory.

Developed order fulfilling process for RF-Guns to scan Barcode- UCC128.

Developed a process to deliver weights and quantities to Tandem to support order updates

Distribution Center (DC)/warehouse- maintenance Setup for stock orders for different stock yard.

Spilt order process for Fish/Meat for different DC.

Printing barcode labels and reports, Pick-order reports, In/Out of Room reports

Modified Butcher's Cut Test Yield formula at Maintenance screen

Loading data for new Yield formulas from Canopy into ACOP system.

Analyze newly converted data to establish a baseline measurement for new requirement.

Used agile methodology for project implementation using Jira.usfood.com

Used usfoods.sharepoint.com for documentation.

Worked with architects and subject-matter experts to design comprehensive solutions.

Tuning SQL Statements at SQL/400

Change Management software -ALDON.

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CL/400, EMBEDDED SQL, DB2/400, MKS, IBM Rational developer for iNavigator.

Motorola MC9200-Guns, wavelink telnet- software.

Apex Systems, Inc. Sr Programmer/Analyst

TAG Chicago, IL May 2015 to Feb 2016

Infor-APLUS Distribution: TAG (Trade associates group, ltd.) is a forty-year-old gift and home decor company based in Chicago, Illinois. tag's premium distribution to better independent retailers in both design and production.

Developed PROD Warehouse and Distribution batch programs and interactive screens.

Developed programs that reads from an Integrated File System (IFS) and converts to DB2 and emails reports in excel format using JAVA programs

Designed and developed subfile process for the Returns and Credits of products

utilizing the Infor-APLUS Distribution Software package for an EDI-based project centered on automating the processes for EDI Transaction sets 940/945 and 943/944 (Returns and Pre-Receiving). Knowledge of iSeries.

Change Management software -ALDON.

Technical Environment: AS/400, iSeries, ILE-RPG, SQL/400, ILE, RPG/400, CL/400, EMBEDDED SQL, DB2/400, MKS, IBM Rational developer for iNavigator.

Tata Consultancy Services. Systems Analyst

Bank of America Merrill Lynch, Chicago IL Oct 2014 to Apr2015

GMI (Global Market Infrastructures) experience which includes business analysis, planning, preparing, documenting steps, performing testing, GMI upgrades, and various customized applications to accompany GMI Sungard software.

Good understanding with the futures & options markets and exchanges.

Good understanding of trade lifecycle and back office functions like Client allocations, collateral, pricing of futures products, clearing, margining, settlement, etc.

Provided various GMI related reports for higher management

Experience in GMI Technical Production Support and troubleshooting with various aspects of GMI batch issue, user query, Client feeds etc.

Have ability to solve critical problems in an effective manner.

Writing utilities, Very Strong SQL expertise, can slice and dice GMI data in many ways based on user needs.

To support GMI system and business related queries.

Analysis, specification creation, testing, implementation, developments are mostly done using RPG free, RPG/400, RPGIV, ILE, CLLE, CL400 and other IBM iSeries tools and X-Ref Utility.

GMI Batch Processing: Jobs: FEMAINC, NPMAINC (PreBatch), OCMAINC, CDMAINC,N1MAINC at Job scheduler, and Monitor Jobs at Robot & AC.

Vendor interactions with Sungard for daily exchanges and LME,CME for daily batch files.

Change Management software -ALDON.

CGI Group Inc. TechLead/Analyst

CIGNA, Raleigh, NC Feb 2014 to Sep 2014

CIGNA– Power Managed Health CARE System (Pmhs) The system is also responsible for generating the statements for employees and also the reports for the employers. The Employee Statements gives a detail explanation of all the claims that were submitted by the employee in a quarter. The Employer Reports gives a report of all the employees and their claims.

PMHS is basically a development, maintenance and enhancement project

Team Size: 30 team members (10 members at Onsite + 20 members at Offshore).

Technical Lead/Developer:

Managed Offshore team by providing guidelines with Program Specification-PGS and SQL queries based on performance based.

Coordinated Code management and Deliverable on timely manner.

Followed CIGNA stranded for development and implementation.

Change Management software -ALDON.

WebSphere MQ V 1.2 - 5.3.1 & MQSI V2.1 support

Supported MQ Network, which grew from 5 to over 100 Queue Managers Troubleshoot and resolved MQSeries problems

Worked with MQ developers, assisting with architecture, design, development and implementation of messaging and integration applications designed to turn business needs and requirements into technology solutions.

Technical Environment: AS/400, ILE-RPG, SQL/400, ILE-COBOL, RPG/400, CL/400, COBOL/400, EMBEDDED SQL, MQSeries,DB2/400, ALDON, HAWKEYE, HP-Quality Center, GUI, iSeries

CGI Group Inc. Sr Developer/ Analyst

Mapfre Insurance, Columbus, OH Nov 2012 – Jan 2014

Agency Port application : Mapfre USA is a leading provider of personal lines in about 11 States in the continental US primarily through a unique partnership with AAA Club Agencies. The Insurance Business is run through two major applications Agency Portal (Agent web font-end) and SIS (Specialty Insurance System, back-end legacy application on AS/400) system. AgencyPortal application is a vendor application initially customized by a combination of in house and Vendor resources and currently maintained by in house resources.

Designed and developed server side component called “Reverse Mapping” in Web Based Endorsement projects for varies states.

Designed and developed “Effective Date” driven functionality in Agency Portal.

Developed MVP -Rules engine to handle better tier.

Developed xml tags for “Forward Mapping” in Agency Port application that interacts with legacy system’s middle-tier.

Developed DAO (DataAccessObjects /Store procedures) and deployed in

WebSphere

SIS-T21 (Agency Port will initiate Policy Quote transaction and will send ACORD XML request to XTS Server then it will be Parse Agency Port XML to T21 format data queue and populated into SIS database.

Bulk data transfers and MQ Websphere to fulfill immediate single policy data requests from AAA agents.

Developed functionalities “Viewing Policy Billing Information”, “Agency Payment Report” and “View Policy Documents” for Agency Port application.

Production Support.

Change Management software -MKS(Implementer)

Environment: AS/400, RPG/400, SQL/400, RPG-Free, ILE, AgencyPortal, SIS, J2EE (Servlets, JSP, JavaScript, HTML,XML), WebSphere, Tomcat, Eclipse, DAO,Tech21,

iSeries.

Mapfre Insurance, Columbus, OH Sr Programmer/Analyst

Oct 2007 – Nov 2012

SIS- V2 (Specialty Insurance System), which handles the overall Insurance functions like quote Processing, Policy issuance, renewal, endorsements and policy declaration printing for personal Auto, Home Owners and Mobile Homes..etc, Working as a part of team that is responsible for maintenance and enhancements of the product,

Worked on Rating engines (MVP /Artius System) continually demonstrate my ability to analyze, design, and code. Make the Rating systems versatile enough to help retro fit all new Auto States into the current system, ability to detach and plug into any new system.

Coordinate Implementation through standard test levels to production of RPG, Java and Rating DSL components as Implementation Coordinator phases of all rating related projects in company, which requires coordination with business analysts, developers from multiple platforms, and business partners. Oversee testing efforts for the New Product/New States project as Testing Coordinator.

Senior Programmer Analyst:

Developed Instruction and resultsets for MVP/Artius Rater Engines (Java Script).

For each state based on rate-filling.

Developed Interface Programs to pass/receive data though IBM's XML Toolkit supports

writing, via the DOM parser, SAX = Simple API for XML xmls to Raters-

MVP/Artius in Java

Developing MVP Instructions and validating MVP and Artius tables and Uploading to SIS System for New-Business and Endorsement, Renewal.

Developed New Rate Filling Projects to merge policies from different systems.

Worked as Implementation coordinator using MKS,

Working closely with DBA’s and Operations team and while code Management.

Change Management software -MKS(Implementer)

Bulk data transfers by FTP and MQ Websphere to fulfill immediate single policy data requests from AAA agents.

Prepared statistical data from reporting for AAIS /NAII for different sates

Prepared all statistical exhibits supporting increases/decreases to insurance rates/loss costs for several property and casualty personal line insurance.

Automated and streamlined creation of actuarial exhibits.

Automated assigned Risk policies for RI state.

Environment: AS400, RPGIII, RPGII, RPG/400, RPGIV -ILE, CL/400, XML, SQL/400 on AS/400, Lotus Notes, ADM, MKS (Implementer), Java, iSeries, MQ-Series

ABSI Inc. Programmer/Analyst

FedEx Ground, Pittsburgh, PA. May 2007- Sep2007

Vision project in extreme scheduling constraints from Seattle facility turns. AWAD (Automated Work Area Design-Vision Data) Store (Daily Operations Data) to AWAD, Download Daily operations Data – Full Refresh of Package.

AWAD populates its daily operations stop and package tables from the Vision Data Store. The first time data is ever loaded into AWAD or whenever there is a critical problem with the data, AWAD will need to fully refresh its data set to replicate exactly what is in the Vision Data Store’s stop and package tables. AWAD will request this from the Vision Data Store. Import Raw Historical Data to Create ADS AWAD queries the Vision Data Store Historical Database to build an aggregate data set. The required records will be migrated in their raw form from the Vision Data Store to AWAD. AWAD will then perform all the required calculations internally to build at a high level; AWAD will perform the following calculations:

oAggregate total stop/package counts for stops

oCalculate variances in stop/package counts for stops

oCalculate historical Work Area #/vehicle information

oCalculate Zip9 Disbursements (w/variance)

Programmer Analyst:

Created new ILE Programs and Service Programs

Written various Trigger programs based on the Business flow

Created SQL to the extent of designing and creating tables and indexes.

Automated programs to update Files different systems

Created Webservice Programs to get for address cleansing Stop Id and Stop Id type

Written complete DIRE process

Created BrokerQue Programs to for Extract and Transform Multiple DATAQ for Varies Jobs

Which in terns Update and insert Business Objects

Change Management software -MKS(Implementer)

Hands on experience in MQSeries triggering, handling messages from Back out queues and Dead letter queues.

Environment: AS/400,SQL (Embedded/Dynamic), Free-Format, ILE, SQL/400, RPG/400, CL/400, DB2/400, Query/400, DBU/60,Lotus Notes, using I-Series V5R4 WDSC 7.0.

ABSI Inc. Programmer/Analyst

Commerce Insurance Company, Webster, MA Dec 2006- April 2007

The Commerce Insurance Company provides personal and commercial property and casualty insurance in Massachusetts and New Hampshire. In Massachusetts, Commerce Insurance is the leading provider of both private passenger and homeowners insurance and is the second leading provider of commercial automobile insurance. Project’s scope was to develop a process at Commerce Quality Assurance Environment for Commerce Company, involved in all the phases of project life cycle development, which includes defining scope of the application, development, testing, and implementation.

Programmer Analyst:

Updating production applications in CQA removing hard coding.

Test Data gathering utilities, number of utilities that have been created and put to use in order to generate test data sets for the various CQA Environment.

Execution of jobs, cycles, under ROBOT, for the operational aspects of the applications in the CQA Environment.

Enable each Application and related jobs to run on CQA Environment fixing the failures

Facilitated Requirement gathering sessions with business users Departments like Underwriting, Premium accounting and Claims.

Liaised with Tech lead and other team members in analyzing the system, files, programs and reports, and prepared the System Impact Analysis Document

Extensive use of programming abilities in SQL/400, ILE, RPG/400 CL/400, QUERY/400.

Designing the screens and menus using Screen Design Aid and Sub file programming.

As part of Quality assurance and testing Using Report Layout Utility generate reports or generating it through programs.

Testing every Application, Jobs and program fixes and module.

Compare the test reports with production data to ensure the system is validated.

Written data pulling Programs and refreshing the Environment.

Environment: AS/400,SQL (Embedded/Dynamic), Free-Format, ILE, SQL/400, RPG/400, CL/400, DB2/400, Query/400, ALPLUS, STRANT, DBU/40,Lotus Notes, using iSeries V5R3 WDSC 6.0, iSeries

ABSI Inc. Programmer/Analyst

Accretive Commerce. Roanoke, VA. Jun2006- Dec 2006

Direct Marketing Management System(DMMS): Development in the areas of inventory management and supply chain management system. Worked on Inventory adjustment report to generate the list of all inventory adjustment by code on daily basis Also worked on ACT (Accounting Reconciliation Package) to reconcile inventory receipts, customer shipments, inventory adjustments and cost changes to validate the ending inventory value in the WMS (ware house management system) Involved in development of module involving unloading of shipment off the truck into a staging area and reconciliation of the same with the expected inventory and match the truck seal with seal numbers(license number) Also involved in modifying the merchandise inventory for forward pick locations to be assigned automatically to a location by WMS and assigning the new items or reserved items to a location based on the size of the item

Clients: American eagle, LLBeans, French toast, New York &company, CWDKids...etc

Programmer Analyst:

Debug/Design/Modify System Fixes and Programming,

Modification and Creation of new ILE Programs for RF(Scanner)and BARCODE Printing

Actively involved in bug fixing across the system

Warehouse Management Custom invoices with A/R Statement Information.

Done the modification of’ Pick batch module for verifying the item description and SKU of the merchandise item matches the Pick / Unpick items

Creating package slips, Stock reports for various locations

Unit testing, Aggressive testing DMMS system in AS/400

Change Management software -ALDON

Environment: AS/400,RPG/400, ILE, CL/400, DB2/400, Advanced DDS, Query/400, ALDON, WRKDBF, PFE, PDM, F, ACMS, HAWKEYE, RSF, iSeries, V5R3

ABSI Inc. Programmer/Analyst

First Chicago Insurance, Chicago, IL. July 2005 – May 2006

SIS- V2 (Specialty Insurance System), which handles the overall Insurance functions like quote Processing, Policy issuance, renewal, endorsements and policy declaration printing for personal Auto, Home Owners and Mobile Homes..etc, Working as a part of team that is responsible for maintenance and enhancements of the product, Currently use Jwalk, a Java based tool to transform the front-end green screens to GUI, which execute RPG Programs at the Backend.

Programmer Analyst:

Involved in Analysis and Design of the automated agent application

Development of interface programs using RPG ILE and CL on IBM AS/400

Analysis and design of CLUE display programs and screens development

Rater and Report generation.

Upload the data files to the system file through interfaces

Setting up different tables defined in the system, developing complex coverage formulas involving the driver information, discounts, and surcharges.

Developed programs in RPGIV & CL/400 to interact with the tables to generate the premium for different coverage defined for policy and/or business functionality

Production support and custom modification of the SIS 250 system that includes billing, claims, policy administration, and SRS reporting.

Change Management software -MKS(Implementer)

Environment: AS/400, RPG/400, ILERPG, CL, DB2/400, Query/400, MKS, iSeries

Sankhya Technologies Programmer

Legend Computers LLC. Muscat Dec2004 – May 2005

PMS (Pharmacy Management System) is being developed to provide a more comprehensive and holistic assessment of long-term care needs for elderly and disabled citizens. The application works in Off-line as well as online mode. In offline mode, it is a stand-alone java application that enables User to gather and information about clients in the databases on their laptops. In online mode, the User can export all the data he gathered offline to central database using and User can view/edit client details in the central database using the same front-end. This is achieved by calling the servlets. The User Interface is developed using JFC/Swing Components.

Programmer Analyst:

Involved in designing and developing the User interface.

Involved in developing middle-tier components.

Designed and developed various custom JFC/Swing components.

Developed Help System.

Developed a Print Interface.

Used to document the Object design models and their interactions

Environment: JDK 1.4, JDBC 2.0, SQL Server 2000

Sankhya Technologies Programmer

SJK Steel Corporation Aug2000 – Nov2004

MMMS(Manufacturing - Material Management System) Designed and developed a materials management system application in the client-server environment by utilizing on AS/400. This package kept track of all material indents, checked the requirement with the available stock in stores and released the purchase orders on approved vendors for the non-available items in the stock. The package also generated wide range of reports such as stock statements, material delivered to various projects (project-wise), and order placed on a particular vendor in a given period of time, etc.

Responsibilities:

Worked on the part of analysis, design development, testing

Designing database in DB2/400.

Designing screens in SDA and DDS.

Programming in CL/400, RPG/400.

Sub-File Programming

Environment: AS/400, RPGIII, CL/400, DB2/400, SQL/400and Query/400, SDA, DFU, and RLU

Contact this candidate