Industries:

Domain experience in State Government's Child Support Enforcement and Tracking Systems, Manufacturing Industry for migrating legacy system to Modern systems and integration.

Functional Areas:

CSENet Finance Case Create Litigation Enforcement ,Requirements Gathering, Case Specifications, Case closure Case category changes due to different aid categories or different referrals Debit card processing Process Flows, Business Requirements, Functional Requirements and Specification gathering, data modeling, designing, development , Unit test and Implementation

Methodologies:

Methodologies: Object oriented analysis and design OOAD , Extreme programming using iterative methodology, Top-down, Modular, structured

Software Engineering processes: SEI CMM Level 5

Other Tool sets : Rational Clear case, Rational rose, Microsoft visio, Serena PVCS and change manager, IPF , GENIQU, MS Projects, Kronos, Cognos, Quest code tester, ETL tool - Informatica , Crystal reports

Application Development Tools:

Toad 10.1, IPF, APS APP master builder 4.0 case tool for cobol

Application Package:

Oracle developer suite 10g , IBM RPG, Micro focus APP master Builder APSBuilder, COBOL,MFcobol, UCB Cobol, ECL, Unisys workbench, JCL, CICS, Oracle 9i, Oracle 9iAS, Oracle 10gAS

Databases / DB Tools:

Oracle 10g, DMS1100, DB400, DB2, Unify, Sybase, RDMS, MAPPER

Desktop Tools:

TOAD 10.1, SharePoint for project management and documents handling, Kronos

Hardware:

Oracle 10g application server, Unisys clearpath, Unisys 2200 and Unisys A series, IBM AS/400

Methodologies / Techniques:

Object oriented analysis and design OOAD , Extreme programming methodology, Top-down, Modular, structured

Network Software / Communications:

CMS1100 communication management system, TCP/IP , FTP

Operating Systems:

Windows NT/2000/XP, Windows NT, OS1100,Unix,Linux, OS400

Programming Languages:

Oracle PL/SQL, C, C , SQLPLUS, UML, XML technologies XML, MFL, WSDL, XML Schema, XML transforming , Oracle forms 10g, Unisys/IBM COBOL, Oracle forms 10g, RPG400,Oracle 10g database development, Java, CICS/TIP/DPS screens using APS master screen builder, Unix Shell scripting, JavaScript, FoxPro, FoxBASE , MSACCESS

Confidential ,

Project Manager

ENFORCEMENT AND TRACKING CHILD SUPPORT SYSTEM

Principal Consultant Lead Designer/Senior Programmer/Lead Systems Analyst

• Requirement gathering and study.
• Prepared Use cases and data modeling
• Prepared solution design, ER diagram, generation of database objects and Technical design for the project
• Oracle database developer for new oracle tables, views, indexes
• DMS database developer for new DMS records and DMS sets
• Broadcasts and listeners developments in Oracle system for Legacy system to pass the current member assistance status and return back the same to oracle system.
• Mainframe coding and development of PL/SQL procedures and middleware TPcalls to share the data between two systems instantaneously to calculate the correct case category.
• Troubleshootied, Unit, String, Load, End to End testing, Regression testing using tool Quest code test.
• Generated SQL and PL/SQL scripts to install, create and drop Trading Exchange Connection database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• QA fixes and successful implementation along with DTA Beacon system

Environment:

Toad, Oracle 10g, PL/SQL, UML, Quest code tester, Unisys 2200/Clearpath,COBOL, DMS1100, App master Builder

Confidential

Principal Consultant

Amit was responsible for the following activities in this Project: -

• Requirement study, analysis, High Level and Low level design , Use cases for cleaning the current social security numbers in system and mark incorrect invalid by verifying information from various interfaces via web services, relational tables, dms records
• Coding all the Online and batch interfaces in PL/SQL and Oracle forms , broadcasts and listener for exchanging information from oracle system to mainframe and mainframe to oracle Mentored other team members in oracle database design and development.
• XML and web services with FCR federal case registry
• Developed stored procedures in PL/SQL
• Oracle Database developer for new oracle tables
• Unit, String, load testing using testing tool within packages
• Trouble shooting performance issues and bugs within packages, forms using DBMS Output, forms debugger, explain plan
• QA fixes and successful implementation along with another projects simultaneously

Environment:

Oracle PL/SQL,Unisys 2200/Clearpath,apsbuilder, COBOL,DMS1100

Confidential

Principal Consultant Senior Programmer/Lead Systems Analyst

• Requirement study, Design Solution and technical for conversion of direct deposit data from mainframe DMS system to Oracle database with the majority of functionality related to input functioning for CP EFT and web direct deposit updates to Oracle
• Oracle Database developer and instruct to team
• PL/SQL coding along with New middleware broadcasts and listeners
• Appropriate indexing to improve the performance of current debit card process
• SQL scripting for new oracle tables, views, indexes
• Unit , String and system testing
• ECL changes to invoke new PL/SQL procedures from mainframe overnight batch schedules

Environment:

Unisys 2200, ECL, Oracle 10g PL/SQL, XML and Oracle 10g database

Principal Consultant Senior Programmer/Lead Systems Analyst

Done over 15-20 projects for CSENET system for mostly Locate Only, Managing state case, Enforcement and Case state information functions on both incoming and Outgoing Requests/ Provides/Updates/Acknowledgments etc. It is not possible to mention each of the projects here.

Amit was responsible for the following activities in the area of Quick Locate, Case Inquiries, Managing state Cases and Enforcement modules of the CSENet system: -

• Responsible for day to day project activities and independently managing the application
• Process work flow developer for LO1 locates only, enforcement ENF, Managing state case MSC, Case state Information CSI transactions.
• Study the gap analysis for existing system and the new requirements.
• Identified the design approach for the application modules in phased manner and provided the same to the IRB Information resource Bureau and the Child support Enforcement provided solution design document and writing Technical specifications after signoff from the management.
• Currently Coding in APS builder of batch programming, APS screens to develop new online CSENET screens, Development of decision control tables, Reports.
• XML for incoming and outgoing information to other 50 states.

Environment:

Unisys 2200/Clearpath,COBOL,Toad, Oracle10g, PL/SQL

Project Leader, Senior Developer

• Business analysis of current case create system and identification of problems and the inability for the user to assign new participant pin to the same referral participants based . Allowed the flexibility to the user to determine the criteria by allowing them to view the various attributes related to the participants like demographic information and personnel and unique information to assign them to the case and mark the other invalid.
• Prepare solution design document and provided the technical solution for the project
• Prepare use cases and data modeling.
• Designed the High level and Low level processing, how the project should work and coded it.
• Developed the new screens, Oracle forms, programs and decision control tables
• Shadowing of case data to Oracle tables from mainframe records
• Unit and string tested and implemented it successfully

Environment:

Unisys 2200/Clearpath,COBOL, Toad, Oracle 10g, PL/SQL, ECL

Associate Consultant Business Analyst and Senior Project Programmer

• Attending project meetings to discuss business requirements and analyze the problem and creation of solution design document, Technical design document and process flow diagrams
• Amit was responsible for following project milestones
• Data modeling and Use case preparation
• Coding Online/Batch programs , middleware TP service calls in Oracle PL/SQL and COBOL
• Database development for Oracle tables and DMS records
• Unit testing and implementation

Environment:

Oracle 10g, PL/SQL, Unisys 2200, App master builder, Cobol , ECL, DMS1100

Senior Systems Business Specialist

• Coding for new batch/ Online/ Report programs required for Federal certification.
• Impact analysis of changes on the non-financial modules
• Active participation in study of Detail Design, Use Cases, Program Specifications and Technical Specifications
• Changes to the existing impacted non-financial programs
• Writing unit test plans and unit testing
• Writing extract programs for financial reports

Project Manager

• Involved in delivering the Technical trainings in C, C , Cobol, CICS, DB2, Java, HTML , UML, Windows 2000 networking, Window System Admin, UNIX
• Render technical support, systems administration support for the globally deployed E-learning System.
• Resolve Application / Administration Issues / User / Content / Server OS related 'issues.
• Ensure speedy resolution of Network / Response / Learner Progress related queries.
• Handled Server re-installation due to Hardware/ Software failure, Virus attacks etc.
• Involved in Setting up the LAN in windows environment in Client server architecture and Peer to peer network model using TCP/IP

Environment:

JSP, HTML, Java Script, Java, JDBC, Beans, Java Mail, Tomcat 4.1.29, SQL Server 2000, WIN 2000 Server, COBOL, CICS, DB2

Programmer/Business Analyst

• Requirement study, Design, Development of COMETS application's programs and online screens
• Implementation
• Testing of EFPLS programs
• Training to Users

Environment:

Unisys2200, COBOL,ECL, App master builder APS

Lead Systems Engineer/Instructor to Newly joined Software Engineers

• Working as a role-model for the NTPians
• Conducting the lab sessions for various streams on courses like Oracle, Mapper, COBOL, DMS 1100 and Software Testing
• Conducting the 7-days Project for various streams
• Training the participants in various streams on different courses like RDBMS Concepts, Software Testing, OOAD Object oriented analysis and design Concepts, Unified modeling language UML,Java, C, C , COBOL, Oracle,powerbuilder and Mapper
• Evaluating the NTPians and submitting their performance record

Environment:

C, C , Java,JDBC,Oracle,COBOL,CICS,DB2,Powerbuilder, Mapper , Unisys 2200

Systems Engineer/Testing Team Lead

Amit's activities included

• Preparation of Test scenario's according to SRS for in-house training system.
• Preparation of Test Cases according to test scenarios.
• Execution of Test cases.
• Filling of Defect Report forms if some requirements given in Test Cases don't match.
• Executing test cases after changes have been made.

Environment:

Visual Basic, Oracle, Winrunner,msprojects

Amit's activities included

• Requirement of the product in the market.
• Preparation of Feasibility Report of the Product.

Environment:

Unisys2200, Mapper

Systems Analyst/Business Analyst

The objective of this project was to study the existing system and requirements as per the Tender document of Army Transit camps and prepare a Technical Plan for the future computerized Transit Camp Management System for the Transit Camps at Jammu, Srinagar, and Chandigarh. It included following phases:

• System Requirement Study
• System Design
• System development
• System Testing and Acceptance
• Implementation
• Project Scheduling and Effort Estimation.

• Study of Existing system.
• Study of Tender document and Preparation of a Technical plan, which will meet all the requirements given in the Tender document.
• Calculations of Function points and according to that estimate the effort.
• Function point analysis calculation for the project
• Provide the technical response for request for proposal from client
• Preparation of project scheduling.

Environment:

Microsoft word, Functional Point Analysis study and calculations

Systems Analyst/programmer analyst

Amit's activities included

• Validating the results of phase 1 with the details provided by the client.
• Detailed study analysis of the application.
• Development of reusable asset tools which were used for other Y2K projects.
• Preparation of necessary inputs for the Impact Assessment tools.

Environment:

OS390, Cobol, DB2, CICS

Senior Software Engineer

Amit activities included

• Cycle of Impact Assessment of Mapper and COBOL Applications.
• Subsequent Renovation of Mapper and COBOL Applications.
• Development of reusable asset tools which were used for other y2k projects.
• Reviews and Testing of Impacted and renovated Rids.

Unisys2200, Mapper, TIP/DPS, Cobol

Engineer

Amit's activites included

• Preparation of SRS, System design, development for procurement planning PP , Materials management MM , Financial accounting management FAM , Customer order management COM , Production planning and development PPD , Quality Inspection QI
• Testing and Integration of above modules
• Preparation Of user manuals
• Training to users

Environment:

AS/400, RPG/400,DB/400, Unix , Shell scripting