Joseph G. Estrella
Mobile number : +1-347-***-****
Email address : adcgw5@r.postjobfree.com
Resident address : Queens, New York, USA
Experience : 14+ yrs IT – COBOL, CICS, JCL, DB2 & MQ Series
Summary
Talented and accomplished business technology developer with demonstrated success in application design & development, system testing and production support. Have a solid background in Mainframe software engineering and had experience with enterprise wide implementations.
14+ years solid experience in COBOL, CICS, JCL, DB2 and MQ Series.
Wide spectrum of expertise in analysis, design, coding, testing and production support in Mainframe Environment.
Extensive consulting experience in developing and enhancing programs for clients in verticals like Savings bank, Investment bank, Credit card, Loans and Pharmaceutical companies.
Proven ability in interfacing with clients from analyzing critical solutions up to implementation.
Involved in a huge scale regulatory projects with very tight deadlines.
Proficient team player that enjoys challenging technical opportunities and developing, planning and evaluating efficient workable solutions to effectively meet organizational goals and objectives.
A highly technical and creative resource in both Mainframe and Windows platforms and respected for personal, technical and communications skills.
Skills
Programming Language : COBOL, CICS, JCL, MQ Series, EZtrieve
Database : QSAM, VSAM, DB2, SQL, Oracle, MS Access
Database Tools : FileAid, File Master, File Mngr, SPUFI, QMF, ISPF, IBM Table Editor
Mainframe Tools : ChangeMan, CA Librarian, Endeavor, EzyEdit, Infox
Testing Tools : InterTest, CEDF, XPEDITER, SmarTest, Omegamon, Abend-Aid
Prod Monitoring Tools : SDSF, TOM, TWS, CA-7, CA-View, CTRL-D, Websphere MQ
Data Transfer : Connect Direct NDM, FTP, TDE ISIS
Mainframe Emulator : Mocha TN3270, Hummingbird, IBM WebSphere HOD, IBM PCS, RDC
Operating System : MVS, OS/390, ZOS, Windows (2000, XP, Vista, 7), Mac OS
Hardware : IBM Mainframe, IBM Personal Computer, Mac Computer
Professional Experiences
Standard Chartered Bank Global Services
Jalan Teknologi 8, Taman Teknologi Malaysia, 57000 Kuala Lumpur, Malaysia
Lead Support Specialist – COBOL, CICS, JCL, VSAM, EZTRIEVE
Encora Technologies Sdn. Bhd. (September 2016 – July 2019)
oPrimarily responsible for the stability of the production environment of loans system.
oAnalyze the issues reported by users and provide workaround as well as permanent solution when possible.
oCreates Technical Design documents for all business requirements raised by users.
oAttends Quality Control and Project transition meetings to ensure every projects to be implemented in production follows the standards and well-tested.
oManages and resolves high severity incidents.
oCoordinates disaster recovery drills for all countries using the RLS system
oParticipates in mass release where all enhancements implemented by all applications are moved from B stage to Production stage.
oFine tune jobs to minimize MIPS and CPU time during batch processing.
oPerform root-cause analysis on all incidents and maintain repository for future reference.
oConducts knowledge transfer to offshore team in India.
oProvides 24/7 support on BAU and project related implementations.
Citibank
10 Anson Road #28-13, International Plaza, Singapore 079903
Software Consultant – MQ admin, COBOL, CICS, JCL, SYSTEMATICS (TS,GN)
WIPRO Pte. Ltd. (February 2013 – February 2016)
oUpdated TS/GN Systematics programs as required by Go To Common project.
oTroubleshoot problems, providing root cause analysis and remediation to mitigate future risk with appropriate steps.
oMaintain the MQ driver programs (CICS), which are responsible for getting and putting messages to queues.
oPerforms analysis of MQ infrastructure and make recommendations on improvements to meet business needs and future capacity.
oResponsible for implementation, deployment, configuration and administration of the Middleware Messaging Infrastructure MQ Series on mainframe platforms.
oConfigure MQ Mgrs, Listen, Remote, Transmit queues and SSL Channels.
oSupport various phases of application lifecycles from development up to prod deployment; perform the installation of patches, maintenance and upgrades.
oProvide on-call SIT, UAT and production support including occasional after office hours and during weekend.
oDefine transaction IDs in CICS regions that are used by the MQ messages.
A-IT Software Services Pte. Ltd. (June 2011 – February 2013)
oEnhance TS/GN Systematics online & batch programs and ensure that quality is never overlooked and strictly follows the coding standards.
oSupported problem determination and resolution, production changes, and maintenance following the Change Management processes
oPrepare and maintain clear and concise documentation required for all the projects.
oSetup new MLI by creating ICR and TBR to perform a specific task required by user.
oDefine and maintain tso ids in CICS environments using TS online screens that update EOR, SOR and TAR control files.
oCollaborate with other SI applications to provide project solutions and design.
oProvide 24/7 support in production and test environments.
oMonitor on a daily basis and ensure that all issues and abends in CICS environments and batch processing are being attended to.
oSetup MQ objects, control files and transaction IDs in new test environments.
CVS Caremark
15/f, Export Bank Plaza, Sen. Gil Puyat, Makati City 1200, Philippines
Team Lead – COBOL, CICS, DB2, JCL
Headstrong (July 2010 – June 2011)
oLead a team of 4 and assisted the members with design, code and testing.
oParticipate in technical design discussions or walkthroughs.
oIdentify process improvements and communicate such to the offshore team members
oRedesign applications to correct inefficiencies; improve program code and testing methods.
oIncrease productivity by resolving problems quickly and writing code efficiently.
oAnalyze high level software strategies and solutions through technical expertise.
oCode and perform component test of a module according to the established development, maintenance, project procedures and standards.
oCreate test scripts, execute and document the testing.
oEnsure zero defect for all changes being introduced in the production environment
oComplete resource recruitment and training to meet the demand of the projects.
American Express
Makati Stock Exchange Bldg., Ayala Avenue, Makati City 1200, Philippines
Senior Software Engineer – COBOL, CICS, DB2, JCL
Accenture (June 2009 – July 2010)
oDesign, code and test program modules.
oCreate test scripts; execute and document tests scenarios.
oParticipate in technical design discussions or walkthroughs.
oProvide user support by addressing business inquiries and issues.
oEnsure successful migration of work to production through participation in deployment activities.
oTrain, coach and give directions to less experienced team members.
Morgan Stanley
Makati Stock Exchange Bldg., Ayala Avenue, Makati City 1200, Philippines
Senior Software Engineer – COBOL, CICS, DB2, JCL
Accenture (August 2007 – May 2009)
oAnalyze, develop and customize batch and online programs for the System.
oInteract directly with end-user clients to get feedback, analyzed their requirements, answered queries and submitted reports.
oPrepare test plans, documented test conditions and expected results, executed test scripts and validated test results to ensure that promoted components follow the requirement specifications.
oEnsure high level of client satisfaction through the delivery of quality products on time.
Metrobank Technology Incorporated
PS Bank Center 777 Paseo de Roxas Makati City 1200, Philippines
Analyst / Programmer – SYSTEMATICS (IMPACS & ST), COBOL, CICS, JCL
Philippines Savings Bank (July 2006 – July 2007)
oAnalyze, develop and customize batch and online programs for Systematics, IMPACS.
oMonitoring batch processing for System Integration Testing, User Acceptance Testing and Mock Run of the applications on the production partition.
oPerform unit testing of changes made in the development environment to ensure that components follow the requirement specifications.
oInvestigate and provide solutions for production incident reports, systems integration testing (SIT) and user acceptance testing (UAT).
oTesting and Migration support of IM and ST components affected by OS upgrade from OS390 to ZOS including SRC, PRM and JCL.
Metropolitan Bank and Trust Company (May 2005 – June 2006)
oAnalyze, develop and customize batch and online programs for Systematics, IMPACS.
oCustomize and execute ad hoc JCLs for maintenance of accounts and products, including file definitions and utilization.
oProvided production and QA Testing support, monitoring and tracking project performance issues and resolving problem issues on a timely basis.
oCollaborates with various teams to provide business & system solutions and design.
oCoordinates business/user requirements and translates them into IT specifications.
Notable Projects
G2C Go to Common (Citibank ASPAC and USA)
oThis G2C project aims common modules and control files to be used by all countries in ASPAC and USA. Modified TS/GN programs, procedures and parameters to add country specific functionalities to cater this requirement.
oEnhanced the existing MQ process by creating 7 new MQ driver programs. MQ messages are distributed to these new drivers to increase the processing speed.
oModified most of the MQ listen and reply queues to align with MQ driver changes.
Unfair and Deceptive Acts and Practices law (American Express)
oUDAP implementation of Federal law in connection with consumer credit card accounts and deposit account overdraft services.
oModified the existing programs to correct the interest rate being charged to customer per transaction. Ensure that new interest rates will be charged to new trans only.
oCreated a program that will generate letter to be sent to customers whenever there are changes in their interest rates.
Branch Consolidation (Metrobank)
oCreated new batch programs and jobs that will merge 2 or more branches into 1 branch. These adhoc jobs run during weekend whenever there are requests by user.
Anti-Money Laundering Act Report (Philippine Savings Bank)
oDeveloped new batch program that will generate AMLA Report using the existing control files like IMBCR, IMACTM and IMACCM. The report is submitted to government agency on monthly basis to scrutinize money launderers.
oCreated online CICS screen that displays the daily suspected money launderers.
Mainframe Operating System upgrade from OS390 to zOS (Metrobank and PSBank)
oModified existing modules to be compatible with the new zOS.
oDefined JCL’s predecessors and successors in the new environments using TWS.
oMonitor daily batch jobs using Tivoli Workload Scheduler (TWS).
Education
EDUCATION
ATTAINMENT
INSTITUTION
COMPLETED
Tertiary
Bachelor of Science, Computer Science
Mapúa Institute of Technology
Dec. 2004
Secondary
High School Diploma, Loyalty Award
Claret School of Quezon City
Mar. 2001
Primary
High School Diploma, Loyalty Award
Claret School of Quezon City
Mar. 1997
Trainings
CICS Dump : Standard Chartered Bank, Malaysia 2019
MQ Series : Wipro / Citibank, Singapore 2012
Advanced COBOL : Accenture Manila Delivery Center 2008
Advanced CICS : Accenture Manila Delivery Center 2008
Advanced JCL : Accenture Manila Delivery Center 2008
Advanced DB2 : Accenture Manila Delivery Center 2008
Basic DB2 : Accenture Manila Delivery Center 2007
Mainframe Programmer & Support