PRADEEP SALI
Bentonville, AR, *****
***********@*****.***
SUMMARY:
• Over 15 years of IT Industries experience includes System studies, Estimation, Project coordination, Leadership, project management, Analysis, High Level Design, Major and Minor Enhancement, New Application Development, Functional and Technical Specification writing, Programmer Analyst, Business Analyst, Peer reviews, Production Support, Coding, Unit / Integration / System / User Acceptance Testing, Implementation, Post Implementation Support.
• Excellent Analytical Skill and Out of box thinking capabilities to solve complex business problems.
• Developing application within a disciplined development methodology such as SDLC and Leveraging the Global Delivery Model to meet business expectations and deliver high quality products and solutions which are within scope and on time.
• Extensively involve in business requirement meeting and created a functional and technical specification documents for busiess users and developers.
• Extensive experience in designing, development, testing and implementing a variety of IT applications in a number of different development, operational, and industry environments. Experience in Manual testing, created test plan, test cases and test envorment for achive accurecy.
• Good Domain Knowledge in Order Management System, Replenishment, POS, Iten Inventory system.
• Good experience in SQL, COBOL, PL/SQL, Microfocus COBOL, COBOL-85, Pro-COBOL, Server express COBOL, ACUCOBOL, HP-UX, SQL*PLUS, INFORMIX, Orcale, SQR Reports, Mainframe, JCL, DB2, CICS, UNIX, AIX, Unix / Perl Shell scripting, EDI Translator, SQL Stored Procedure, IMS, MVS, VSAM, ISAM, Teradata, Btrieve, APEX, Sybase, SAS. Good knowledge of INFORMIX, Oracle, DB2, ISAM, VSAM database.
• Good experience in Test-Driven Development (TDD)
• Good expericnce in TOAD, VI, ISPF, SPUFI, QMF, JOBTRAC, MQ-Series, Clear Quest, PVCS, Hummingbird and FTP.
• Worked as Project an d Tchnical lead in multi phases Application Develoment projects at Client–Onsite-Offsore, involved Project Management - Planning, Scheduling, monitoring using MSP. Managed 10 member of team.
• Good experience in Defect tracking, Involved in CAM (Casual Analsys Meetings) to prevent future defects.
• Significant experience in day-to-day production support and maintenance for the application developed using client server and Mainframe technologies. Tracking and resolving user’s technical issues of different severities/priorities using STARIT.
• Sound domain Knowledge of Wholesale Order Management, Insurance, Banking and Utility industries.
• Ability to work on batch as well as online programs.
• Self Motivated, Decision making, Goal Driven and ability to work independently as well as in team.
• Good leadership and people manaegement skill, Sucessfully managed project within SLA by consitently tracking record of all phases. Strong customer focus and teamwork.
• Worked as Customer support Lead and managed 15 Members of team.
TECHNICAL SKILLS:
Operating Systems Mainframe MVS, UNIX, AIX, SunOS Linux, Windows 98, Windows 2000
Programming Languages PL/SQL, SQL, SQL*PLUS, Oracle, MicroFocus COBOL, COBOL, SAS, CICS, Pro*COBOL, IMS, Basic C, VB
Scripts and Others UNIX / Perl shell Scripting, Stored Procedures, TSO/ISPF, IMS
Domains Banking, Insurance, Retail, SCT Banner Utility, Financial (GL / AR), EDI Translator
Database INFORMIX SQL, DB2, ISAM, VSAM, IDMS, Oracle, Teradata, Btrieve,
Tools & Utilities VI, TOAD, PVCS, Clear Quest, CONTROL-M, Hummingbird and FTP
EDUCATION:
• B.C.S. (Bachelor of Computer Science), University of Pune, Poona, India, 1992.
PROFESSIONAL EXPERIENCE:
WAL-Mart, Bentonville, AR
Lead Analyst /Project Management Jun 2009 to till date
Project: SAM Fresh to PI Conversion
The aim of this project is to interact with Business users and gather the requirement, analyze the requirement scope, technology, Code and write a technical specification document, also provide the estimation for development, testing and implementation efforts.
Roles and Responsibilities:
• Managing three member of team. Involve in weekly planning, scheduling.
• Scheduling meeting with Business users and understand the requirement associated applications/ systems for SAM Fresh to PI conversion.
• Interacting with the SME’s to understand the current process, environment structure, Code standards and Impact analysis.
• Analyzing the scope for this new requirement within current application.
• Analyzing the existing process to implement the changes of new requirement.
• Documenting the requirement into Technical specification documents.
• Estimating efforts based the on the technology involve for this requirement.
• Coordinating with POS, DC, GDIS and stores team to set up the integration test environment.
• Involve in Test-driven Development (TDD)- Responsible to Test, Code, Integrate, Deploy, Release, steer and repeat the test if needed .
Environment:
Microfocus COBOL, Pro*COBOL, Pro*C, Unix Scripting, SQL stored procedure, Mainframe COBOL, JCL, Changeman, PL/SQL, PRO-COBOL, UNIX, INFORMIX, Teradata, DB2, ISAM. Sun OS, AIX, VI, basic of VB.Net, PVCS, FTP, Windows XP.
Stride Rite, Lexington, MA
Business Analyst /Project Management Apr 2009 to May 2009
Project1: BabyGap - Requirement Gathering
The aim of this project is to interact with Business users and gather the requirement, analyze the requirement scope, technology and write a functional & technical specification document, also provide the estimation for development, testing and implementation efforts.
Roles and Responsibilities:
• Managing two member of team. Involve in planning, scheduling and monitoring.
• Scheduling meeting with Business users and understand the requirement Business processes and associated applications/ systems for BabyGap.
• Interacting with the SME’s to understand the current process, environment structure, Code standards and Impact analysis.
• Analyzing the scope for this new requirement within current application.
• Providing the suggestions to improve scope of the requirement.
• Analyzing the existing process to implement the changes of new requirement.
• Documenting the requirement into Functional / Technical specification documents as per the CTS standards.
• Knowledge sharing to Offshore
• Estimating efforts based the on the technology involve for this requirement.
• Responsible to Test, Code, Integrate, Deploy, Release, steer and repeat the test if needed – TDD process.
Environment:
Oracle 9i, PL/SQL, COBOL, PRO-COBOL, Unix Shell scripting, SQL Stored procedure, SQR Reports, UNIX, AIX, VI, Hummingbird, basic of PowerBuilder, PVCS, FTP, Windows XP.
Project2: Order Administration / Order Management System (OMNIA)
Lead Analyst (Knowledge Transfer) Mar 2009 to Apr-2009
The aim of this project is to maintain and 24/6 support the OMNIA application developed using PowerBuilder, Oracle PL/SQL, SQL*PLUS, Pro-COBOL which includes the functionality such as Order Entry/Maintenance, Credit Checking, Inventory, Invoicing, Shipping, EDI data Processing, Returns, GL, AR etc.
Roles and Responsibilities:
• Scheduling meeting with Business users and understand the Business processes and associated applications/ systems for OMNIA.
• Interview with the SME’s to understand test and build environment and process, code structure, standards and Impact analysis
• Involve understanding the Call Handling process, touch points, frequently occurring issues & resolutions.
• Walk thru the existing documentation structure, Key docs and write Functional and technical specification documents, Design document, Impact analysis documents for enhancements, Implementation Plan, Test Cases / Plan.
• Knowledge sharing to Offshore
• 24/6 Production Support and resolve the user issues based on the priorities.
• Involve in analysis of PL/SQL Package, Procedure, and COBOL code and provide the solution and make the necessary changes and unit testing as needed.
• Co-ordinate with DBA for any database Issues
• Involve in Unit testing, Integration testing, System testing and User acceptance testing
Environment:
Oracle 9i, PL/SQL, COBOL, PRO-COBOL, Unix Shell scripting, SQL Stored procedure, SQR Reports, UNIX, AIX, VI, Hummingbird, basic of PowerBuilder, PVCS, FTP, Windows XP.
Unified Grocers, Seattle, WA Apr 2008 to Feb 2009
Lead Analyst
Project: Corporate Information System (CIS)
The aim of this project is to write an interface to interact with corporate system and maintain existing application developed using VB.net, INFORMIX, Unix/Perl Scripting, SQL Stored procedure, MicorFocus COBOL, INFOMIX-SQL, Mainframe, MVS, which includes the functionality such as Item Maintenance, Warehouse maintenance, Vendor maintenance, Cost/Allowances Maintenance, Stored Maintenance, Deals/Promotions etc.
Roles and Responsibilities:
• Involve in meetings with the SME’s
• Reviewing the Requirements
• Writing and reviewing the technical specification documents as per the requirements
• Writing and reviewing of test plans and test cases as per the requirements for all the possible scenarios and Interactions of the device.
• Setting up of test environment to test the assigned features.
• Development of Unix/Perl Scripting, SQL Stored Procedures, COBOL code, Unit Testing, UAT and review of UNIX / Perl scripting, SQL Cards, stored procedures.
• Responsible to create test plan, test cases and test Data to be tested using SQL for achieve accuracy.
• Maintaining Traceability by checking frequently for changed or newly added requirements and changing the test cases accordingly.
• Provide support for System Integration testing
• Browsing and editing the INFORMIX database using the Dbaccess and ISQL for test data setup and troubleshooting data related issues.
• Review the project deliverables before moving into production.
• Pre and Post Implementation Support
• Involve in release coordination and code Deployment and Supporting Configuration management.
• Extensively involve in Test-driven Development
Environment:
Informix-SQL, Dbaccess, PL/SQL, SQL Stored procedure, UNIX/Perl Scripting, Stored procedures, UNIX, AIX, Microfocus COBOL Server express (Embedded PL/SQL), VI, Lotus Notes, FTP, Windows XP, reflection X.
CUNA Mutual Groups, Madison, WI Jul 2004 to Apr 2008
Business Analyst / Project Management/Programmer Analyst
Project: Insurance Tracking System & Policy Administration
The aim of this project is to tracks the Auto and real estate Loan and insurance information for credit unions or members of credit unions. TotalTrac is responsible for the various stages notices that sent to the members of credit union. TotalTrac is also responsible to generate policies based on Loans information. TT provides data to Billing and collection, Policy administration online system to print the volume of policies. TT provides data to online claim systems to process claims reported by members.
Roles and Responsibilities:
• Interacting with business for requirement gathering and other interfacing group of the project.
• Responsible for on-call support, maintenance of the Tracking application.
• Maintain the Service Level Agreement (SLA) and responding to work requests within SLA. Coordinating with Business users for requirement.
• Involve in impact analysis and detail design for new and existing requirements gathered by BA and writing technical specification document for offshore team.
• Modify existing Microfocus COBOL, Cobol-DB2 programs.
• Modify and code existing and new JCL’s
• Browsing of DB2 table via FILEAID and extraction of data from DB2 table by firing SQL queries for any trouble shooting or test data related issues.
• Browsing of IMS databases through the IMS FILEAID FIMS.
• Used MVS utilities to allocate new datasets, catalog/ uncatalog dataset, copy dataset, transmit dataset from one mainframe region to another using XCOM or NDM and dataset compare.
• Responsible for development and execution of Test Plans, Test Scripts and Test Cases for functional, regression testing based on business requirements for manual.
• Accountable for design, build and support of test environments.
• Write and execute Test Cases and Test Scripts for manual testing.
• Reviewed and Analyzed Business Requirement Documents (BRD) and software Change Requirements (SCR).
• Involved in developing testing methodologies and strategies.
• Reported defects and interacted with developers to resolve technical issues.
• Involved in technical specification and code review.
• Involve in release coordination and code Deployment and Supporting Configuration management.
• Co-ordination with DBA for any database related issues during testing.
• Conduct Peer Review and review the deliverables before moving into production.
• Involved in Defect Analysis and performed CAM (Casual Analysis Meeting) with team member to prevent future defects.
• Participated in status meeting to update status to other project personal.
• Involved in initial discussion for implementing new features
• Extensively involved in meetings and QA tech support for offshore development.
• Provided standard quality assurance on the overseas development.
• Mentoring a team of 10 members, project sizing and resource planning.
• Project Planning using MSP – Planning, Scheduling, Monitoring, Estimation
• Pre and post implementation support.
• Knowledge sharing with offshore team and subordinates.
Environment:
PL/SQL, SQL, Microfocus COBOL, SAS, UNIX, HP-UX, ISAM, MVS, TSO/ISPF, DB2, IDMS, COBOL II, CICS, U-SQL, JCL, Z/OS, VSAM, SAS, APEX, CONTROL-M, SPUFI, EDI Translator, VB, Lotus Notes, FTP, Word, Excel, Windows XP. VI, UNIX shells scripting, Microsoft .NET Framework.
SDI Tech (India) Pvt. Ltd. INDIA Jan 2004 to Jul 2004
Sr. Software Developer
Project: SCT Banner CIS Utility
The SCT Banner Customer Information System (CIS) supports operations of utility companies providing services such as: Electric, Gas, Water, Sewer, Garbage & Telecommunications, CIS provides automated capability to collect, manage, and analyze information about customers, service locations, accounts, services, and inventory. It maintains a General Ledger of the utility’s accounts receivable, and retains history data such as service history, credit history, billing history, account summaries, and audit history. CIS includes processes to calculate charges and print bills (as well as other customer communications), and to apply and distribute payments. Other processes compile data to produce a variety of standard reports.
The application is developed in Form 6i, Oracle (8i, 9i & 10g), Pro*COBOL, PL/SQL and Pro*C.
Roles and Responsibilities:
• Responsible for Functional analysis, Defect fixing, testing, Code existing and new PL/SQL procedure/Package, COBOL Code
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Maintenance & Enhancement in existing Pro*COBOL Charge Calculation, Delinquency process program, Letter editor & Letter Printing Objects using SunOS 5.8.
• Extensive testing during maintenance was done on the programs for achieving accuracy, timely processing of data.
• Interaction with client to resolving the migration related queries.
• Migration Coding from release 2.2.1.2.1 to 3.1, preparing the Check-List , Test Cases for Testing Source Code Version Control using PVCS.
• Analysis and Upgrading Migration Specification Document.
• Creating test data in Oracle 8i, 9i
• Prepare the Unit Test Plan
• Tracked and reported bugs and also generated reports using ClearQuest.
• Attending meeting for code review with clients
• Creating the test Data for the test cases to be tested using SQL in TOAD.
• Involved in Source Control Management (PVCS) .
• Extensive testing during maintenance was done on the programs for achieving accuracy, timely processing of data.
• Involved in Unit Testing and Batch Processing of JCL jobs
• Participated in status meeting with client to update status
• Delivery to onsite co-coordinator
• Use the TDD (Test Driven Development) concept
Environment:
Oracle 8i, 9i, 10g, SQL * PLUS, PL/SQL, Forms 6i & Reports 6i, Pro*COBOL, ACUCOBOL, TOAD, Pro*C, SunOS Linux, PVCS, ClearQuest, VI, Unix scripting, FTP
ONWARD eServices, INDIA Jun 2000 to Jan 2004
Sr. Programmer
Project: Total Bank Automation
The aim of this project is to maintain existing module and develop new Module for retail banks in India and it is having greatly enhanced banking package commonly uses in most of the nationalized banks. This Package (Modbanker®) is written in MF-COBOL and C++ having back-end as Btrieve. Modbanker® is a modular package bifurcated into SB, CA, CC, OD, Remittance, Clearing, Passbook Printing, Term Deposit, Term Loans, General Ledger and Vostro Cell.
Roles and Responsibilities:
• Project Leader of 4 team members for Term Loan (TL) and Remittance Module
• Responsible for planning the various activities and estimation for all the activities
• Team Management, planning, scheduling and monitoring.
• Participated in initial requirement gathering and interview with business users.
• Interacting with various bank’s business users to gather requirement
• Mainly Involved in Design, Development of Term Loan, Remittance module and GL module.
• Involved in developing the application with team.
• Involved in Unit Testing & QA testing.
• Participated in status meeting to update test status to other project personals
• Delivery to banking support team to implement the code in various banks.
• Involved in code reviews for other modules like Savings, Current etc, user training.
• Writing various COBOL program for Customer/Account Master Maintenance, Interest calculation, various financial reports and year end miscellaneous reports as per the bank requirement.
• Participated in ISO audits.
• Involve in Data conversion
• Documentation of System Overview.
• Knowledge sharing with the piers, Implementation team and subordinates.
• Organizing various team-building events.
• Debug COBOL code using COBOL debugger
• Involve in Configuration Management
• Used concept of TDD (Test-driven development)
Environment:
Micro Focus COBOL, Btrieve, MS-DOS, Novell Netware, PowerBuilder, INFORMIX, C
InfraSoft Ltd., INDIA Nov 1997 to May 2000
Executive Banking Software Operation
Project: Banking and Financial
The aim of this project is to develop and integrate various banking modules for retail banks in India such as Saving Bank, Checking Account, Loan, Deposit, Passbook Printing, General Ledger, Branch Account, Forex banking.
Various modules of the System I worked on are:
• Bills module
• Loans and Advances module
• Term deposits
• Locker operations
• Shares module
• Passbook printing
• Scanner operations
Roles and Responsibilities:
• Study and Analysis of the Existing System and User requirement at different banks
• Task Allocation/delegation to team members
• Involved in designing the system.
• Planning and estimation for various activities
• Involved strongly in Development of code and Unit testing
• Involved in Test plan preparation, Testing
• User Requirement/User manual documentation
• Helping Implementation team for implementing the product at various clients location
• Involved in many data conversion Projects in different environment.
• Lead Developer in the Development team.
Environment:
Micro Focus COBOL, Professional COBOL, Btrieve, MS-DOS, Novell Netware, PowerBuilder, INFORMIX, C
Project: Data Migration Nov 1997 to Dec 1998
It was a conversion project part of Banking and Financial Project in Infrasoft. It includes converting the data from old software to the new Software package and testing of the same. By writing COBOL Programs to extract data and put it in a format applicable to new System. It covered the following aspects:
1. Product master conversion
2. A/c master conversion
3. Address master conversion
4. Names master conversion
5. Balances
6. History file conversion
7. Signatures conversion.
8. Limits master conversion
Roles and Responsibilities:
I was fully involved in this project and it was an independent job. In this I was involved to write conversion program. It also includes implementation of software with online support. I converted three branches. It also includes online testing of Data.
Environment:
Professional COBOL, Mictofocus COBOL, ISAM, Btrieve, MS-DOS, Novell Netware Ver 3.x to 4.x.
Syscomp Computers., INDIA Sep 1993 to Nov 1997
Programmer / Customer Support Lead
Project: Banking and Financial Automation
The aim of this project is to enhance banking application modules for retail banks in India such as Saving Bank, Checking Account, Loan, Deposit, Passbook Printing, General Ledger, Branch Account.
Roles and Responsibilities:
• Customer Support Lead for 15 member of support team and my responsibility is to prioritize and categories the customer requirement and manage the support Engineer on customer site.
• Study and Analysis of the User and support engineers requirement at different banks
• Involved in designing the system.
• Involved strongly in Development of code and Unit testing
• Implementation of product at various clients location
• User Requirement/User manual documentation
• Lead Developer in the Development team.
• Involved in banking training program to understand banking concepts.
Environment:
Microfocus COBOL, ISAM, UNIX, Btrieve, MS-DOS, Novell Netware Ver 4.x, Window 95, Norton Editor, VI Editor, UNIX shells scripting.
Project: Inventory Billing System Sep 1993 to Nov 1997
Programmer
The aim of this project is to maintain and enhance Inventory online billing system for various Trading / Retail companies.
Various modules I worked on:
• Item Master Maintenance
• Party Master Maintenance (Both Creditors and Debtors)
• Stock Master Maintenance
• Online Billing on Pre printed or manual format.
• Cash / Bank / Sales and Purchase register Maintenance
• General Ledger
Roles and Responsibilities:
• On Call Support 24*7
• Customer Interaction
• System document
• Involved in CR analysis
• strongly in Development of code and Unit testing
• Implementation and support
Environment:
Microfocus COBOL, MS-COBOL, SAM, MS-DOS, Window 95, Norton Editor.