Developer Manager
Resume:
SARFRAZ ALI SATTI
KEY QUALIFICATIONS:
Experienced in the design, development and implementation of complex databases. More than 25 years of intensive programming experience in RPGLE/400, COBOL/400 and Oracle Developer/2000. Designed, developed and implemented many advanced systems on AS/400. Also, designed, developed and implemented an advanced, central relational database in Oracle 7.1 using Developer/2000. Experienced in building integrated systems comprised of different software types.
Environment:
IBM AS/400, OS/400, RPG, RPGLE, COBOL, SQL, QUERY, CL, HAWKEYE, DBU, TURNOVER, IBM PS/2, DOSC, FORTRAN, PASCAL, COBOL, FoxBASE, IBM/4331 DOS/VSE, COBOL, IBM-RISC/6000, AIX, MICRO FOCUS COBOL, PC/WINDOWS, MS OFFICE, DOS, LAN, Novell, ORACLE, DEVELOPER/2000, ACCESS
MAJOR PROJECTS:
TIECHE INC (Tieche Engineered Systems), CA
Jan 2018 – Present
Project: Operations
Role: Manager
Position: Operations Manager
Description: Working as a operations manager and main responsibilities are to look at the projects and coordinate with the engineer’s for the implementation of the software on the client site. Coordinate with the developer and tester for the new software release. Additional responsibilities are to control inventory, shipping, receiving at the warehouse,
IPMG (Insurance Program Manager Group), IL
Jan 2017 – Dec 2017
Project: Production Support
Role: Sr. Developer
Position: Contractor
Description: Worked as a team member to support existing application and provide production support. Additional responsibilities were to develop new programs based on the client requirement, debug and test new program to verify the results. Also responsible to build/create data on test box and verify results.
Environment: IBM-AS/400, RPGILE, CLLE, SQL
Bank of America, CA
May 2016 – Dec 2016
Project: HELOC Loans conversion from Merrill Lynch to BofA platform (ETL)
Role: Sr. Developer
Position: Contractor
Description: Worked as a senior developer to convert 100,000+ loans from Merrill Lynch system to BofA platform. This was an ETL project and got implemented in November 2016. Main responsibilities were to do the analysis of the data and prepare data mapping documents. Once mapping documents approved by LOB’s, other responsibility were to develop the program to load the data to iSeries.
Provide support to Quality assurance team in writing new test scripts and in executing these scripts on the test box.
Environment: IBM-AS/400, RPGILE, CLLE, SQL
Bank of America, CA
July 2014 – Dec 2015
Project: Customer Mailing Address & Statement
Role: Developer & Support production issues
Position: Contractor
Description: Worked as a leading developer to support Customer Mailing Address Application. Help Business Analyst in writing HLD, providing them with the design of the new database tables, flow diagram for the existing and new processes, and create workflow for the new application. Main responsibilities were to create a LLD’s (low level design) based on the HLD (high level design) requirement for the new functionalities/enhancement. After LLD got approved, responsible to develop & test new program to verify the result as per LLD’s. Test Scripts & test plans were also part of responsibility. Create OTR (one time program) to convert customer data of 5.2 million loans to new tables to support existing and new functionality.
Provide support to Quality assurance team in writing new test scripts and in executing those scripts on the test box.
Environment: IBM-AS/400, RPGILE, CLLE, SQL
Bank of America, CA
September 2013 - February 2014
Project: Bankruptcy
Role: Developer & Support production issues
Position: Contractor
Description: Worked as a team member to support Bankruptcy Application. Main responsibilities were to create a LLD’s (low level design) based on the HLD (high level design) requirement for the new functionalities/enhancement. After LLD got approved, responsible to develop & test new program to verify the result as per LLD’s. Test Scripts & test plans were also part of responsibility.
Environment: IBM-AS/400, RPGILE, CLLE, SQL
Bank of America, CA
November 2011 - June 2013
Project: Document Management Technology
Role: Developer & Support production issues
Position: Contractor
Description: Worked as a team member to support Document imaging data on DB2 database (I-Series). Main task was to support production related issues on day to day basis. Additional responsibilities were to create a LLD’s and once LLD got approved, main task was to develop & test new program to verify the result as per LLD’s. Also extract data from production and test systems based on adhoc request from LOB’s and testing teams. Also responsible to execute daily, weekly & monthly reports for LOB’s & management.
Environment: IBM-AS/400, RPGILE, CLLE, SQL
Creative Computing Solutions, CA
January 2008 - August 2011
Project: Data Conversion Project
Role: Developer & Support Conversion issues
Position: Contractor
Description: Worked as a team lead to convert servicing system data from DB2 database (I-Series) to main frame. Main task was to analyse existing database and worked as a liaison between teams of AS-400 & Main frames. During analysis, gathered requirement from main-frame and AS-400 and design a mapping documents which highlighted data need to be passed between 2 systems. Once mapping documents accepted by business folks on receiving system, main responsibility was to design & develop programs which can extract data from DB2 database and load into a flat file for mainframe team to use that data for conversion.
Liaison with the off-shore so that work distributed properly between team across different continents.
Environment: IBM-AS/400, RPGILE, CLLE, SQL
Woolwich Mortgage Company, UK, Countrywide Home Loans, CA
May 1999 – December 2007
Project: Joint Venture Global Servicing System
Role: Developer & Support production issues
Position: Sr. Developer – Countrywide Home Loans
Description: Worked as one of the leading Architecture on the GSS project. The scope of this project was to provide the Loan servicing to the client (Woolwich Mortgage which was also a Bank in UK). The client had the Loan servicing facility on their own machine (IBM Main frame) and a lot of other systems, which were fulfilling their need. The scope of this JV Global system was to develop new functionalities to support their mortgage and convert their existing data into the AS/400. Client had different functionalities on the servicing side and involved in designing and developing a new system to support all of their functionalities on a single machine. As the client was also a bank, so it issues the credit card to the customer against the mortgage loan. My main responsibility was to study the functionality of the existing ILP system and design the files & screen for the new system. We also have to highlight the gap analysis while doing the study of their existing system. Also my responsibility was to document the proposed system and create the test screen to give the demo to the users and explain the functionality of the new proposed Global system. We were providing Technical support to the UK user from USA. .
Environment: IBM-AS/400, RPGLE/400, RPG/400, CL, Query/400, Query Manager/400, SQL, HAWKEYE, DBU, TURNOVER
Countrywide Home Loans, Simi Valley, CA
April 1997 - March 1999
Project: Millennium/400 (Make Users application Year 2000 compliant)
Role: Support off-shore Conversion issues
Position: Contractor
Description: Worked as deputy team leader on the project and involved in the analysis and programming of the project. The project is to make the client application Year 2000 compliant. The client had multiple AS/400 machines which were connected to each other through optical connectivity and they had a very frequent use of the DDM Files (Distributed Data Management files). My responsibility on this project is the prepare all the deliverables which are required for the conversion of the programs like Program to files X-reference and to identify the date fields in the data files along with their formats. The user agree to expand the year field in the database and insert the century in date fields where year is of only two digit. After expanding the database, all their applications need to be changed. As according to the user requirement, the display and printer files are unchanged, mean the date fields in the display & printer files should keep as it is, but the database is expanded. In order to make their application compliant with this change, the sliding window concept is used which is, just before writing the display or printer file, take out the century portion from the year field. In the same way, after reading display file, insert the century in the Year field. Other than that, user also want to change the format of the date fields, and want the expanded date fields into the standard format which is *CYMD. As there are almost 16000 programs for the client, so they want to do this change in small packets. In this order, there was a proper segmentation for each packet. Each packet contains 150 physical files and all the programs which are using these files, were put into the packet. As all the conversion is done off-shore (Lahore, Pakistan), its also my responsibility to send all the programs to off-shore for conversion. I used the FTP (File Transfer Protocol) to upload and download the data/programs from PC to AS/400. I am also responsible for sending the programs/data from the client AS/400 machine to my company head office AS/400 machine. Its also my responsibility to review the code of the converted programs before passing it to the client. While in that review, if faced some problems in the code, I fixed it on-site. Also involved in writing some migration program which were used for the migration of data. The client had 8 AS/400 machines connected with each other through optical connectivity and their system had DDM (Distributed Data Management) files. The applications update the data files on the remote system.
Environment: IBM-AS/400, RPG/400, RPGLE, COBOL, CL, Query/400, Query Manager/400, SQL, HAWKEYE, DBU, TURNOVER
Countrywide Home Loans, Calabasas, CA
April 1997 – September 1997
Project: CSE (Countrywide Servicing Exchange System)
Role: Support off-shore Conversion issues
Position: Contractor
Description: Worked as the team leader on the project and involved in the analysis and implementation of the project. The project is to make the client application Year 2000 compliant in a classic style (Expand the database and the display/Printer file) . The user agree to expand the date field in the database and insert the century in date fields where year is of only two digit. After expanding the database, all their applications need to be changed. As a consultant, my responsibility is to find out all the programs, which were related to data files, which our client decided to expand. After pointing out the programs, I helped the client to point out the programs, which can be declared dormant. After different kind of analysis, the programs were sending to offshore (Lahore, Pakistan) for the conversion. For the CL’s, I converted all the CL’s here on-site. After receiving back those converted programs, I review the code and if there is any error in the code, I fixed it here on-site. Also my responsibility on that project is to migrate the data and to create a test environment for the new converted application. I also fixed the programs which were pointed out while testing the programs
Environment: IBM-AS/400, RPG/400,SQL,Query/400,CL
Economic Affairs Division, Ministry of Finance, Islamabad, Pakistan.
March 1995 – November 1996
Project: Aid and Debt Management System
Role: Developer & support production issues
Position: Sr. Developer – Systems Private Limited, Lahore, Pakistan
Description: Systems Analysis and Programming for the Aid Management Database of the Economic Affairs Division, Government of Pakistan. This was a project funded by the Asian Development Bank for the development of an Aid Management System using central relational database (Oracle 7.1) and local area network (Novell Netware). Responsible for analysis, design, development and implementation of the system. Also built the interface between the Aid Management System and DMFAS 5.0, which is a software developed in Oracle by UNCTAD, Geneva. The AMS system is fully integrated with the DMFAS system. Created views on the DMFAS and AMS systems so that data from both systems are available transparently to users, and both systems use each other’s data tables for their reports.
Environment: IBM Pentium Servers with Windows based Clients, Oracle Server running on Novell Netware and Oracle Tools (Developer/2000), and Excel running on MS Windows Client
Water and Sanitation Agency, Lahore Development Authority, Pakistan
October 1994 – February 1995
Project: Water and Sewerage Billing System
Role: Developer & support production issues
Position: Sr. Developer – Systems Private Limited, Lahore, Pakistan
Description: Involved in the programming of an accounts based, water and sewerage billing system which provides water bills for the city of Lahore. This system was initially developed on mainframe IBM 4331, but later it was converted to RISC 6000 machine. Converted all the Data entry programs and reporting module into the new system.
Environment: IBM-RISC/6000, Micro Focus COBOL
Excise and Taxation Department, Lahore, Pakistan
October 1993 – September 1994
Project: Motor Vehicle Registration and Tax Management System
Role: Developer & support production issues
Position: Sr. Developer – Systems Private Limited, Lahore, Pakistan
Description: Involved in the design, development and implementation of a Motor vehicle system. This system records information about new vehicles and automatically allots a new registration number to each vehicle. This system also automatically calculates the tax applicable on each vehicle according to its model and make. The system also has the ability to inform about stolen vehicles.
Environment: IBM-AS/400, COBOL/400,RPG/400, CL, SQL, Query/400
Irrigation Department, Sahiwal, Pakistan
Jan 1993 to September 1993
Project: Abiana Billing System(Canal Water)
Role: Developer & support production issues
Position: Developer – Systems Private Limited, Lahore, Pakistan
Description: Involved in the study, design and development of a computerised “ABIANA” billing system. A World Bank financed pilot project for the Ministry of Water and Power. This involved software development in the PC/DOS based network(Lantastic) environment using “C” language with an in-house developed, multi-lingual database and screen design aid. In particular, developed programs for Data Entry, Processing and Reports.
Environment: IBM-PC, C Language
EDUCATION:
Post Graduate Diploma in Computer Science, 1990,
University of Punjab, Lahore, Pakistan.
BSc. Mathematics and Statistics, 1988, University of Punjab, Lahore, Pakistan.
OTHER TRAINING: Courses in RPG/400,COBOL/400, SQL/400, QUERY/400, CL/400, OS/400,
AS/400, Fundamentals of Application Development Tools & Computer Systems
Conducted by IBM World Trade Corporation.
Training in System/36, QUERY/36, SSP, Oracle Developer/2000, and Fundamentals of Accounting. Data Modelling
Contact Info:
Cell: 805-***-****
Email: *******@*******.***
Reference can be provided on request.
Contact this candidate