Sr. Programmer/architect Resume
Brooklyn, NY
SUMMARY:
- I have 23 years of experience in the Information Technology Industry. He has worked as a Programmer/Analyst and Systems Analyst in the healthcare, retail and automotive industries. My prior positions have included the following job functions:
TECHNICAL SKILLS:
Technology and Tools: COBOL II,III, C#/C++/C, File - Aid, JCL/RACF, TSO/ISPF, ABEBND-AID, XPEDITER, Java, VSAM, SYNCSORT, DB2/SQL, IMS DB/DC, EASYTRIEVE, PUFI/QMF, PANVALET, MVS/zOS, CHANGEMAN, JES 2, CA-7/CA-11, CICS, FOCUS, AUTOSYS, Apache, Microstrategy, Hyperion v.9, Hyperion SQR, BMC utilities, BMC Control M, CA ACF2, Hardware, IBM 370/3090, HP 3000, Unysis 2200 TERADATA,UNIX Shell script, Oracle, Visual Basic 6.0, SQL server/MYSQL, PHP, PERL, PL-SQL/T-SQL, JAVA Script, Active Server Page, MQ Series, Sybase/ INFORMAKER,HTML/WML, WEBSHPERE, SAP CRM 5.0, SQL plus/Toad, Endeavo, UDB, DASTAGE, DATACOM, ADABAS/NATURAL, WEBFOCUS, PEOPLESOFT, AIX/Solaris/Linux, crystal report, ESSBASE, integration Services, ESSBASE, ASO/BSO, Visual Age, project management, CA manager suite, HP 9000, IBM PC, IBM AS 400, Ajax,Agile Windows NT 4.0/ 98/ 2000, VISIO, MS FrontPage, MS Word, MS Excel, MS Outlook, Visual, Age 3.5,4.0, Assembler, DCS, TERAMINER, MS project manager, ZPARM, Turbo Image, MOBIUS report
PROFESSIONAL EXPERIENCE:
Confidential
Sr. Programmer/architect
Environment: s: Windows NT 4.0/98/2000/ XP/XP server, IBM OS 390, zOS, UNIX, HP 3000, AIX, Solaris, Linux.
Responsibilities:
- Analyzed, coded, tested, implemented, supported we applications using core java, DB2, Oracle, SQL server, Sybase.
- Analyzed, coded, tested, implemented, supported informatica powercenter applications.
- Analyzed, installed, set-up security, production supported CA-7, CA-11 and other CA products.
- Analyzed, coded, tested, implemented, supported microservices applications.
- Coded, tested, implemented shell scripts doe UNIX systems scheduling applications
- Analyzed, coded, tested, implemented control M Unix scripting and Mainframe JCL interaction applications.
- Replaced mainframe JCL with tested and implemented the best practice for the Business requirements and applications.
- Analyzed, debugged using wind debug and other tools for windows and web application, fix the bug and maintain the consistency of databases and applications.
- Provided senior-level Production, Pre-Production, and Test support for a global .NET environment that relies on IIS and SQL Server and other databases and files.
- Experienced in a level-3 on-call rotation in support of our 24x7 QA and Production environments.
- Provide security set-up and monitoring for all applications and databases.
- Lead support of business critical outages, clear the path to resolution, and own the steps for prevention.
- Experienced in Windows Performance Monitor (Perfmon) and application monitoring and proactively using scheduler to prevent the data outage or applications breakdown.
- Experienced in IIS and web services middleware and administrate the databases SQL server and Oracle.
- Experienced in ASP.Net and debug and fix the applications,
- Analyzed, coded, tested, implemented, supported web- applications using Java and EXT-JS, CSS, Angular JS and Oracle or DB2 databases.
- Analyzed, coded, tested, implemented Dojo, Ajax, Agile,ext JS web applications.
- Analyzed, code, tested, implemented java application using UI for data transfer between different platforms.
Confidential, Brooklyn,NY
Sr. Programmer/architect
Environment: s: Windows NT 4.0/98/2000/ XP/XP server, IBM OS 390, zOS, UNIX, HP 3000, AIX, Solaris, Linux.
Responsibilities:
- Analyzed, coded, tested, implemented Dojo, ext JS web applications.
- Analyzed, coded, tested, implemented, supported informatica powercenter applications.
- Analyzed, installed, set-up security, production supported CA-7, CA-11 and other CA products.
- Analyzed, coded, tested, implemented, supported microservices applications.
- Analyzed, coded, tested, implemented, supported mobile application using UML.
- Analyzed, code, tested, implemented java application using UI for data transfer between different platforms.
- Analyzed, coded, tested, implemented, supported we applications using core java, DB2, Oracle, SQL server, Sybase.
- Analyzed, coded, tested, implemented, supported wed- applications using Java and Agile, Ajax,EXT-JS and Oracle or DB2 databases.
- Analyzed, coded, tested, implemented LOAN IQ software in applications.
- Analyzed, coded, tested, implementes web-application using Adobe Flex, Flash.
- Analyzed, coded, tested, implemented, supported AS400 RPG ILE applications.
- Implemented, supported and administrated Changeman configuration manager.
- Analyzed, coded, tested, implemented, supported Java web application using Strut.
- Experienced in migration from using outlook to Lotus note applications.
- Performed as project manager using project management tool.
- Lead FTP to Secure FTP conversion on the mainframe using Tectia SSH server for z/OS
- Experienced in Oracle environment with knowledge of triggers, views, packages, stored procedure, functions, constraints, cursors, indexes, table partitions.
- Analyzed, designed, coded, tested, implemented and production supported ETL coding using Imformatica, datastage.
- Analyzed, coded, tested, implemented, supported java application with microstrategy in mobile applications.
- Administrated Oracle databases for the company, performing fine tuning, back-up and databases recovery for Oracle databases.
- Configured, implemented, administrated FTP, EDI X12 with 850 translator.Analyzed, designed, coded, tested and implemented Sap for accounting application for company.
- Analyzed, coded, tested, implemented, maintained C++,PERL application.
- Analyzed, designed, coded, tested, implemented, supported Mainframe application in DB2, CICS, IMS, MQ series, also in JCL, CA7/11 setup and support.
- Expert in Mainframe applications, in TSO/ISPF, CLIST, REXX.
- Analyzed, designed, coded, tested, implemented and production supported java wed .
- Analyzed, coded, tested, implemented, Unix shell scripting for Huamn Capital management, payroll applications and inventory systems in UNIX platform.
- Analyzed, coded, tested, implemented, supported web- applications using Java and EXT-JS, CSS, Angular JS and Oracle or DB2 databases.
Confidential, Hyattsville, MD
Sr. Programmer/Java developer/Architect
Environment: s: Windows NT 4.0/98/2000/XP/7, IBM OS 390, zOS, UNIX, HP 3000, OS400, AIX, Solaris, Linux, Wintel .
Responsibilities:
- Analyzed, coded, tested, implemented web-application using Adobe Flex, Flash. Analyzed, code, tested, implemented java application using UI for data transfer between different platforms.
- Analyzed, coded, tested, implemented, supported informatica powercenter applications.
- Analyzed, installed, set-up security, production supported CA-7, CA-11 and other CA products.
- Analyzed, coded, tested, implemented, supported microservices applications.
- Analyzed, coded, tested, implemented Dojo, ext JS web applications.
- Analyzed, coded, tested, implemented, supported mobile application using UML.
- Analyzed, coded, tested, implemented, supported web applications using core java, DB2, Oracle, SQL server, Sybase.
- Analyzed, coded, tested, implemented, supported wed- applications using Java and, Agile, EXT-JS and Oracle or DB2 databases.
- Analyzed, coded, tested, implemented LOAN IQ software in applications.
- Analyzed, coded, tested, implemented, supported AS400 RPG ILE applications.
- Analyzed, coded, tested, implemented ASP.NET software in applications.
- Analyzed, coded, tested, implemented cognos report in applications.
- Analyzed, coded, tested, implemented, supported Java web application using Strut.
- Experienced in migration from using outlook to Lotus note applications.
- Implemented, supported and administrated Changeman configuration manager.
- Performed as Team lead to lead on-site and off-shore development and production support.
- Performed as project manager using project management tool.
- Analyzed, designed, coded, tested, implemented and production supported ETL coding using Imformatica, datastage.
- Experienced with unit, integration testing and test case creation.
- Analyzed, coded, tested, implemented, supported java application with microstrategy software in mobile applications.
- Experienced in Oracle environment with knowledge of triggers, views, packages, stored procedures, functions, constraints, cursors, indexes, table partitions.
- Modify and enhance existing CDW programs as required by Business Dept. PPMs. Resolve Production problems with existing programs and processes.
- Analyzed, coded C programs and embedded-C applications.
- Performed fine tuning for c applications and Sybase stored procedures using Rational rose and CLEARQUEST.
- Analyzed, coded, tested, implemented, supported C, C++ applications.
- Performed data analysis, performance tuning, data modeling, metadata management, and logical and physical database design, Data warehouse and business intelligence.
- Strong working knowledge of DB2 in an OS/390 (z/OS) environment, DDL,DCL, DML, SQL, etc.
- Experienced in Business Intelligence/Data warehousing tools for DB2
- Utilize ERWIN, or comparable data modeling tool.
- Experienced in BRIO/Hyperion Intelligence Designer.
- Experienced working with a variety of users and cross functional teams within the Organization.
- Analyzed, designed, coded, tested, implemented and supported in HP3000 and AS400 using DB400 and Turbo Image Database.
- Analyzed, designed, coded, tested, implemented and supported for converting HP300 Turbo Image database to Oracle database.
- Applications and Turbo Image Database to Java-based web-application using Oracle database.
- Analyzed, designed, coded, tested JAVA web-based application.
- Administrated UDB and DB2, Oracle databases for school district‘s Grade reporting and attendance reporting application.
- Worked as mainframe architect to provide technical solution and consultation to application business user group.
- Worked as mainframe architect to write specifications for web-based programs to connect with mainframe databases also provide production support for any link problem between web-program and mainframe databases.
- Performed data modeling from Turbo Image Database in HP 3000 and HP 900 and database programming to Oracle, SQL server databases .
- Analyzed, designed, coded, tested and implemented IMS DB/DC ( online and batch) with DB 400 application for School district.
- Analyzed, designed, coded, tested, implemented and supported XML application for Database modeling and online documentation.
- Analyzed, designed, coded, tested and implemented Hyperion (system 9.3) Interactive Reporting.
- Performed tuning for Hyperion interactive report performance¡£
- Technology supported on mainframe and distributed platforms using COBOL, CICS and Web enabled transactions, DB2/SQL UDB and Stored Procedures, MQ, IBM Debug, SAS, FTP, and VSAM.
- Performed data modeling using VBA and OLAP also can import excel data layout to database or download database to excel text file.
- Analyzed and designed the Essbase cubes for Hyperion application.
- Performed designing and executing test strategy, test plan, test scenarios, test cases and driving test execution, verify and aproove the test results.
- Analyzed, designed and created and executed test plane using Rational Test Manager, Rational Clearcase, Rational ClearQuest setup, installed, configured and administrated FTP, EDI.
- Analyzed, designed, coded, tested and implemented SAP for accounting applications for School district implemented, supported Mainframe application in DB2, CICS, IMS, MQ series, also in JCL, CA7/11 setup and support.
- Expert in Mainframe applications in TSO/ISPF, CLIST, REXX.
- Analyzed, coded, tested, implemented, supported web- applications using Java and EXT-JS, CSS, Angular JS and Oracle or DB2 databases.
- Analyzed, designed, coded, tested, implemented and production supported java-web applications.
- Configured, implemented, administrated FTP, EDI X12 with 850 translator.
Confidential, Detroit, MI
Sr. programmer/Java developer
Environment: Windows NT 4.0/98/2000, IBM OS 390, zOS, UNIX, AIX, Solaris, Linux.
Responsibilities:
- Analyzed, coded, tested, implemented LOAN IQ software in applications.
- Analyzed, coded, tested, implemented Dojo,Ajax, ext JS web applications.
- Analyzed, code, tested, implemented java application using UI for data transfer between different platforms.
- Analyzed, installed, set-up security, production supported CA-7, CA-11 and other CA products.
- Analyzed, coded, tested, implemented, supported web applications using core java, DB2, Oracle, SQL server, Sybase.
- Analyzed, coded, tested, implemented, supported microservices applications.
- Analyzed, coded, tested, implemented, supported wed- applications using Java andagile, EXT-JS and Oracle or DB2 databases.
- Analyzed, coded, tested, implemented web-application using Adobe Flex, Flash.
- Analyzed, coded, tested, implemented ASP.NET software in applications.
- Analyzed, coded, tested, implemented, supported AS400 RPG ILE applications.
- Analyzed, coded, tested, implemented, supported informatica powercenter applications.
- Analyzed, coded, tested, implemented cognos reports in applications.
- Analyzed, coded, tested, implemented, supported Java web application using Strut.
- Analyzed, designed, coded, tested, implemented and production supported ETL coding using Imformatica, datastage.
- Implemented, supported and administrated Changeman configuration manager.
- Experienced in migration from using outlook to Lotus note applications.
- Modify and enhance existing CDW programs as required by Business Dept. PPMs. Resolve Production problems with existing programs and processes.
- Experienced with unit and integration testing and test cases creation.
- Experienced in Oracle environment with knowledge of triggers, views, packages, stored procedures, functions, constraints, cursors, indexes, table partitions..
- Analyzed, coded C programs and embedded-C applications.
- Performed fine tuning for c applications and Sybase stored procedures using Rational rose and CLEARQUEST .
- Analyzed, coded, tested, implemented, supported C, C++ applications.
- Performed MEGAMON for systems and IMS, DM2 databases analysis and tuning and recovery.
- Performed TCPIP NETVIEW for network tuning, security check and recovery functionality as required.
- Performed integration, installation and customization for Tool set list including Setup and Customization according to standard model or customer specifics.
- Performed SMPE to install maintenance on required systems.
- Provide all required information to security setup as it pertains to audits.
- Designed and implemented, supported report generation and build as required.
- Provide installation and customization for Tool set list including Setup and Customization according to standard model or customer specifications.
- Performed MVS system Tuning and troubleshooting, databases recovery.
- Performed data analysis, performance tuning, data modeling, metadata management, and logical and physical database design. Data warehouse and business intelligence.
- Strong Working knowledge of DB2 in an OS/390 (z/OS) environment, DDL,DCL, DML, SQL, etc.
- Experience with DB2 V8 on z/OS, administration, recovery, utilities, monitors, etc.
- Experienced in Business Intelligence/Datawarehousing tools for DB
- Utilize ERWIN, or comparable data modeling tool.
- Experience in BRIO/Hyperion Intelligence Designer and/or SAS a plus.
- Experienced working with a variety of users and cross functional teams within the Organization.
- Analyzed, designed, coded, tested, implemented and supported File-aid MVS, data solution and FILe-Aid for DB2.
- Analyzed, designed, coded, tested, implemented and supported File-aid for IMS.
- Performed QA test for File-Aid MVS, File-aid Data solution, File-aid for DB2, File-aid for IMS.
- Fix bugs and troubleshooting for File-aid MVS, File-aid data solution, File-aid for DB2 and File-aid for IMS.
- Analyzed, designed, coded, tested, implemented and supported XML application for
- Database modeling and online documentation.
- Performed production bug fix and trouble shooting for File-Aid MVS, File-aid Data solution, File-aid for DB2, File-aid for IMS.
- Performed designing and executing test strategy, test plan, test scenarios, test cases and driving test execution, verify the test results. setup, installed, configured and administrated, implemented and production supported java web applications.
- Configured, implemented, administrated FTP, EDI X12 with 850 translator.
- Analyzed, coded, tested, implemented, supported informatica powercenter applications.
- Analyzed, coded, tested, implemented, supported web- applications using Java and, agile, ajax, EXT-JS, CSS, Angular JS and Oracle or DB2 databases.
Confidential, Dearborn, MI
Senior Programmer/ Java developer/Architect
Environment: Windows NT 4.0/98/2000, IBM OS 390, zOS, UNIX, AIX, Solaris, Linux, OS400.
Responsibilities:
- Analyzed, coded, tested, implemented web-application using Adobe Flex, Flash.
- Analyzed, coded, tested, implemented, supported informatica powercenter applications.
- Analyzed, installed, set-up security, production supported CA-7, CA-11 and other CA products.
- Analyzed, coded, tested, implemented, supported microservices applications.
- Analyzed, coded, tested, implemented Dojo, ext JS web applications.
- Analyzed, coded, tested, implemented, supported mobile application using UML.
- Analyzed, coded, tested, implemented, supported web applications using core java, DB2, Oracle, SQL server, Sybase.
- Analyzed, coded, tested, implemented ASP.NET software in applications.
- Analyzed, coded, tested, implemented, supported AS400 RPG ILE applications.
- Implemented, supported and administrated Changeman configuration manager.
- Analyzed, coded, tested, implemented cognos report in applications.
- Analyzed, coded, tested, implemented, supported Java web application using Strut.
- Performed as Team lead to lead on-site and off-shore development and production support.
- Analyzed, designed, coded, tested, implemented and production supported ETL coding using Imformatica, datastage.
- Analyzed, coded, tested, implemented, supported wed- applications using Java and EXT-JS and Oracle or DB2 databases.
- Implemented, supported and administrated Changeman configuration manager.
- Experienced in migration from using outlook to Lotus note applications.
- Experienced with unit, integration testing and test case creation.
- Experienced in Oracle environment with knowledge of triggers, views, packages, stored procedures, functions, constraints, cursors, indexes, table partitions.
- Performed fine tuning for c applications and Sybase stored procedures using Rational rose and CLEARQUEST .
- Analyzed, coded, tested, implemented, supported C, C++ applications.
- Analyzed, designed, coded, tested, implemented and production supported java wed applications.
- Worked as team leader for onshore and offshore team, also as project manager .
- Experienced with risk identification, quick problem solution and management .
- Performed MEGAMON for systems and IMS, DM2 databases analysis and tuning and recovery.
- Performed TCPIP Net view for network tuning, security check and recover functionality as required.
- Performed SMPE to install maintenance on required systems
- Provide all required information to security setup as it pertains to audits.
- Designed and implemented, supported report generation and build as required.
- Provide installation and customization for Tool set list including Setup and Customization according to standard model or customer specifications.
- Build and maintain all aspects of Host Network Automation utilizing REXX and CLIST.
- Worked as mainframe architect to write specifications for web-based program to connect with mainframe databases also provide production support for any link problem between web-program and mainframe databases.
- Worked as developing manager, gathering requirements from business users, coded specifications, using project manager to monitoring the process and scheduling for the developing project coordinated with users and developers to make sure every thing went as expected, and get proof from users to implemented the project to production.
- Analyzed customer s focus report requirements, designed, coded and tested and implemented FOCUS and TERADATA application for finance application, also worked as FOCUS database administrator and production support. Analyzed customer requirement for PEOPLESOFT and DB2 tables, coded, tested, implemented and maintained DB2 stored procedures and PEOPLESOFT application for Finance Application -ASR (Accounting System Renewal).
- Analyzed, designed, coded and tested, implemented and maintained ARIS (Account receivable input system).
- Analyzed, coded, tested, implemented and maintained MONEX application.
- Analyzed customer’s requirements for Hyperion enterprise and ESSBASE, designed, coded and tested implemented and maintained Hyperion enterprise and ESSBASE application.
- Performed ESSBASE database migration from Test environments to production environment.
- Analyzed, designed, coded, tested and implemented Hyperion (system 9.3) Interactive Reporting.
- Performed tuning for Hyperion interactive report performance
- Analyzed customer‘s requirements for EPSPEC and PFX application, designed, coded and tested, implemented and maintained EPSPEC and PFX application.
- Analyzed, designed, coded, tested and implemented and supported SAS programs for EPSPECS, PFX and Hyperion applications.
- Worked as TERADATA and FOCUS, DB2. Oracle, Sybase, SQL server database administrator.
- Performed data modeling between IMS, DB2, Oracle, TRADATA, FOCUS, MQ series and IDMS, using JCL, FTP, and SMP/E.
- Supported java web-page web application with Oracle database.
- Configured TCP/IP and Apache server and production support the application.
- Performed system analyst for system test setup, execution, verification and integration, implementation between different platforms.
- Collected test data, specified test plan, coded test script for automated test setup.
- Set-up and administered RACF for OS390and ZOS.
- Gather requirements, design and specified the specification for SAP applications and test and implemented the applications.
- Performed back-up and recovery, analysis support for DB2, UDB and Oracle, Sybase, SQL server. TERADATA, IDMS.
- Analyzed, designed, coded and implemented Sybase stored procedure in ASE platform.
- Analyzed, designed, coded, tested and implemented corporate manufacturing and management system (CMMS) for Confidential using CICS and DB2.
- Analyzed, designed, coded, tested and implemented VISTEON purchasing application using PEOPLESOFT Modules purchasing procurement and Oracle database.
- Performed testing using Mercury Win Runner Terminal Emulator developing automated test scripts from use cases, test scripts, and/or requirements documents for IDMS conversion to DB2.
- Analyzed, designed, coded, tested and implemented Customer service and part distribution application on AS 400 using COBOL, DB 400, IMS DB/DC and RPG III.
- Performed testing using Mercury Test Director to manage system defects & analyzing and interpreting Load Runner test results.
- Administered MQ Series on z/OS, including defining queue managers, queues, channels and MQ clusters.
- Analyzed, designed, coded, tested and implemented VISTEON PEOPLESOFT accounting system.
- Performed database design, database programming, database modeling, performance tuning for DB2, Sybase, Oracle, SQL server, TERADATA, IDMS, IMS database.
- Performed, analyzed, designed, coded, tested and implemented JAVA, C++, Visual C++ web-application connected with, IMS, DB2, SQL server, Oracle, Sybase databases.
- Performed data modeling from Turbo image Database in HP 3000 and HP 900 and database programming to Oracle, SQL server.
- Analyzed, designed, coded, tested, implemented and maintained IMS online and batch with DB2 applications.
- Technology supported on mainframe and distributed platforms using COBOL, CICS and Web enabled transactions, DB2/SQL UDB and Stored Procedures, MQ, IBM Debug, M204, SAS, FTP, and VSAM.
- Analyzed and designed the ESSBASE cubes for HYPERION application.
- Performed configuration and security set-up for DRE, also administrated and supported DRE application.
- Analyzed, designed, coded, tested and implemented WEBFOCUS and Focus applications .
- Performed designing and executing test strategy, test plan, test scenarios, test cases and driving test execution, verify the test results. setup, installed, configured and administrated FTP, EDI..
- Experienced in with Java and J2EE development and production support.
- Performed Data stage developer function for full SDLC.
- Configured, implemented, administrated FTP, EDI X12 with 850 translator.
- Analyzed, coded, tested, implemented, supported web- applications using Java and EXT-JS, CSS, Angular JS and Oracle or DB2 databases.
Confidential, Southfield, MI
Sr. Programmer/ Analyst/ Java programmer /Architect
Environment: Windows NT 4.0/98/2000, IBM OS 390, zOS, UNIX, AIX, Solaris, Linux, OS400.
Responsibilities:
- Analyzed, coded, tested, implemented web-application using Adobe Flex, Flash.
- Analyzed, installed, set-up security, production supported CA-7, CA-11 and other CA products.
- Analyzed, coded, tested, implemented Dojo, ext JS web applications.
- Analyzed, coded, tested, implemented, supported mobile application using UML.
- Analyzed, coded, tested, implemented, supported web applications using core java, DB2, Oracle, SQL server, Sybase.
- Analyzed, coded, tested, implemented LOAN IQ software in applications.
- Analyzed, coded, tested, implemented ASP.NET software in applications.
- Analyzed, coded, tested, implemented, supported Java web application using Strut.
- Performed as Team lead to lead on-site and off-shore development and production support.
- Performead as project manager using project management tool.
- Analyzed, designed, coded, tested, implemented and production supported ETL coding using Imformatica, datastage.
- Modify and enhance existing CDW programs as required by Business Dept. Resolve Production problems with existing programs and processes.
- Experienced with unit, integration testing and test case creation.
- Experienced in Oracle environment with knowledge of triggers, views, packages, stored procedures, functions, constraints, cursors, indexes, table partitions.
- Performed fine tuning for c applications and Sybase stored procedures using Rational Rose and Clear quest.
- Worked as mainframe architect to write specifications for web-based programs to connect with mainframe databases also provide production support for any link problem between web-programs and mainframe databases.
- Analyzed, coded, tested, implemented, supported C, C++ applications.
- Worked as mainframe architect to provide technical solution and consultation to appication business user group.
- Tested DB2 stored procedures and JAVA web programs together to ensure performance. Analyzed, designed, coded and tested DB2 stored procedures and JAVA programs to link to DB2 table for Daimler Chrysler Insurance Company s Dealer Floor Plan Insurance system.
- Performed data modeling between DB2, IMS, Oracle, Teradata, SQL server, MySQL, Sybase, UDB, and FOCUS using JCL, FTP, and SMP/E.
- Set-up and administered RACF for OS390.
- Specified ZPARM for DB2 recovery and storage process and troubleshooting when the processes are abended.
- Performed back up and recovery, analysis support for DB2, UDB and Oracle, Sybase, SQL server.
- Performed SDLC using MS project Manager for application.
- Analyzed designed, tested and implemented corporate manufacturing and management system (CMMS) for Daimler Chrysler Corporation using CICS and DB2.
- Administrated DB2, UDB, Oracle, Sybase, SQL server databases.
- Performed testing using Mercury Test Director to manage system defects & analyzing and interpreting Load Runner test results
- Analyzed, designed, coded, tested, implemented peoplesoft application for Chrysler Financial accounting applications.
- Performed database design, database programming, database modeling, performance tuning for DB2, Sybase, Oracle, SQL server, Teradata, IDMS, IMS database .
- Analyzed, designed, coded, tested and implemented JAVA, C++, Visual C++ web-application connected with, IMS, DB2, SQL server, Oracle, Sybase datbases.
- Analyzed, designed, coded, tested, implemented and maintained IMS oneline and batch with DB2 applications.
- Performed data analysis, performance tuning, data modeling, metadata management, and logical and physical database design, Data warehouse and business intelligence.
- Experience with DB2 V8 on z/OS, administration, recovery, utilities, monitors, etc.
- Experienced in Business Intelligence/Data warehousing tools for DB2.
- Utilize ERWIN, or comparable data modeling tool..
- Experienced working with a variety of users and cross functional teams within the Organization. setup, installed, configured and administrated FTP, EDI.
- Configured, implemented, administrated FTP, EDI X12 with 850 translator.
- Modify and enhance existing CDW programs as required by Business Dept. PPMs. Resolve Production problems with existing programs and processes.
- Analyzed, coded, tested, implemented, supported web- applications using Java and EXT-JS, Ajax, CSS, Angular JS and Oracle or DB2 databases.
Confidential, Dearborn, MI
Senior Programmer/ Analyst/java programmer
Environment: Windows NT 4.0/98/2000, IBM OS 390, zOS, UNIX, AIX, Solaris, Linux, OS400.
Responsibilities:
- Analyzed, coded, tested, implemented LOAN IQ software in applications.
- Analyzed, installed, set-up security, production supported CA-7, CA-11 and other CA products.
- Analyzed, coded, tested, implemented, supported mobile application using UML.
- Analyzed, coded, tested, implemented, supported web applications using core java, DB2, Oracle, SQL server, Sybase.
- Analyzed, coded, tested, implemented, supported web- applications using Java and EXT-JS, CSS, Angular JS and Oracle or DB2 databases.
- Analyzed, coded, tested, implemented ASP.NET software in applications.
- Analyzed, coded C, pro C programs and embedded-C applications.
- Modify and enhance existing CDW programs as required by Business Dept. PPMs. Resolve Production problems with existing programs and processes.
- Experienced in Oracle environment with knowledge of triggers, views, packages, stored procedures, functions, constraints, cursors, indexes, table partitions.
- Performed fine tuning for c applications and Sybase stored procedures using Rational Rose and CLEARQUEST.
- Experienced with unit, integration testing and test case creation.
- Analyzed, coded, tested and maintained java-web programs and COBOL, DB2 programs for GIROBS (Global Inventory Review and Obsolescence System). Analyzed, coded, tested, and implemented SDPR (Supplier Delivery Performance Reporting) system. Analyzed, coded, enhanced, maintained ASP programs and COBOL IMS/DB2 programs for GBO (Global Buy Optimization) system. Analyzed and coded Oracle stored procedures and control card for loading data into tables.
- Analyzed DB2 and Teradata table’s structures and do data modeling between DB2, Oracles and Teradata.
- Analyzed, designed, coded, tested and implemented Asp web application with Crystal report.
- Performed data modeling between DB2, IMS, Oracle, Teradata, and SQL server, FOCUS using JCL, FTP, and SMP/E.
- Set-up security for datasets and administered RACF for OS390.
- Performed back up and recovery, analysis support for DB2, UDB and Oracle.
- Performed SDLC using MS project Manager for application.
- Analyzed, designed, coded, tested and implemented corporate manufacturing and management system (CMMS) for Confidential using CICS and DB2 and using Visual C++ and JAVA for front web-based page.
- Performed testing using Mercury WinRunner Terminal Emulator developing automated test scripts from use cases, test scripts, and/or requirements documents for IDMS conversion to DB2.
- Performed database design, database programming, database modeling, performance tuning for DB2, Sybase, Oracle, SQL server, Teradata, IDMS, IMS databases .
- Analyzed, designed, coded, tested and implemented JAVA, C++. Visual C++ web-application connected with, IMS, DB2, SQL server, Oracle, Sybase databases .
- Analyzed, designed, coded, tested, implemented and maintained IMS online and batch with DB2 applications.
- Analyzed, designed, coded, tested, implemented and supported XML application for Database modeling and online documentation.
Confidential, Troy, MI
Sr. Programmer/Analyst/Java programmer
Environment: s: Windows NT 4.0, IBM OS 390, zOS, UNIX, AS 400, AIX, Solaris, Linux, OS400.
Responsibilities:
- Analyzed, coded, tested, implemented, supported web- applications using Java and EXT-JS, CSS, Angular JS and Oracle or DB2 databases.
- Analyzed, coded, tested, implemented, supported mobile application using UML.
- Analyzed, coded, tested, implemented LOAN IQ software in applications.
- Performed fine tuning for c applications and Sybase stored procedures using Rational rose and CLEARQUEST.
- Analyzed item master SKU/ITEM IMS database and designed new DB2 tables to replace old IMS databases. Converted old IMS DC screen programs to JAVA GUI web-based programs. Specified, coded, and tested the stored procedure for 3-tier web-screen program. Analyzed and designed new DB2 tables to replace old IMS databases.
- Used HIREL software from SWS software services to convert IMS databases to DB2 tables. Coded stored procedures for JAVA and DB2 connect/ODBC to connect to DB2 tables.
- Performed data modeling between DB2, IMS DB/DC, UDB, Sybase, Oracle, Teradata, and FOCUS using JCL, FTP, and SMP/E.
- Experienced using Lotus Notes and Crystal report, Sybase Infomaker.
- Analyzed, designed, coded, tested and implemented JAVA, C++, Visual C++ web-application connected with, IMS, DB2, SQL server, Oracle, Sybase databases
- Performed database design, database programming, database modeling, performance tuning for DB2, Sybase, Oracle, SQL server, Teradata, IDMS, IMS database.
- Analyzed, designed, coded, tested, implemented and maintained IMS online and batch with DB2 applications.
- Modify and enhance existing CDW programs as required by Business Dept. PPMs. Resolve Production problems with existing programs and processes.
Confidential, Dearborn, MI
Sr. Programmer/ Analyst
Environment: Windows 2000, IBM OS 390, ZOS, AIX, AS400.
Responsibilities:
- Performed fine tuning for c applications and Sybase stored procedures using Rational rose and CLEARQUEST .
- Developed and implemented a Part Obsolescence Disposition and Verification System. Specified, coded, and tested the stored procedures for web-screen program. Analyzed and designed new DB2 tables to replace old IMS databases. Performed Mercury test for ASP, COM and stored procedure. Coded stored procedures for ASP and COM to get data from DB2 table for a 3-tier web-screen program. Performed data modeling from DB2 to Oracle and Teradata using JCL, unload, and reload utility software and SYNCSORT.
- Analyzed, designed, coded, tested and implemented ASP web-appication connected with, IMS, DB2, Oracle, Sybase databases.
- Modify and enhance existing CDW programs as required by Business Dept. PPMs. Resolve Production problems with existing programs and processes.
Confidential
Sr. Programmer/Analyst
Environment: Windows 2000, IBM OS 390, ZOS, UNIX, AIX, Solaris, Linux, OS400, HP 300, Hp9000.
Responsibilities:
- Developed and implemented a parts supply and Global Warehousing System (GWS). Maintained and enhanced more than 5000 programs in production. Solved complicated report sequence problems by using special SYNCSORT and VSAM techniques. Specified, coded, tested and implemented the web screen Service Contract Systems using JAVA, JAVA Script, PERL, CGI and HTML. Specified, coded, tested and implemented MQ Series in both COBOL and CICS application for online and batch processes. Performed data modeling from DB2 to Sybase using JCL, unload and reload utility software, Easytrieve and SYNCSORT. Coded UNIX Shell Scripts for UNIX platform, and coded stored procedures for Sybase. Coded Visual Basic and C++ program using Sybase/UDB for part catalog systems.
- Performed data modeling between DB2, IMS, Oracle, Sybase, Teradata, and FOCUS using JCL, FTP, and SMP/E.
- Analyzed, designed, coded, tested and implemented JAVA, C++, Visual C++ web-application connected with, IMS, DB2, SQL server, Oracle, Sybase databases.
- Performed database design, database programming, database modeling, performance tuning for DB2, Sybase, Oracle, SQL server, Teradata, IDMS, IMS database.
- Performed data modeling from Turboimage Database in HP 3000 and HP 900 and database programming to Oracle, SQL sever .
- Modify and enhance existing CDW programs as required by Business Dept. PPMs. Resolve Production problems with existing programs and processes.
Confidential, Dearborn, MI
Sr. Programmer/ Analyst
Environment: Windows 2000, IBM OS390, ZOS, AIX, OS400
Responsibilities:
- Developed and implemented a new Automated Warranty Claims Processing system. Involved in production fixes and designing the eligibility batch systems, including a new batch load update process that accepts a variety of eligible input tape formats and updates the eligibility database using COBOL/COBOL II/COBOL 370 and IMS DB/DC and DB2.
- Changed JCL utilizing BMC unload software to replace IBM unload utilities.
- Performed database design, database modeling, performance tuning for DB2, Sybase, Oracle, Teradata,, SQL server, IMS databases.
Confidential
Sr. Programmer/ Analyst
Environment: Windows 95/98, IBM OS390, ZOS, AIX, OS400
Responsibilities:
- Analyzed, coded, tested, configured, implemented FTP and NDM processes between UNIX and mainframe platform.
- Analyzed, coded, tested, implemented and supported life and health insurance applications using java web applications and DB2, Oracle, SQL server, teradata databases.
- Analzed, coded, tested, implemented, java application using spring, strut for billing applications.
- Analyzed, designed, coded, tested, implemented and production supported java and ext Js web applications.
- Analzed, coded, tested, implemented, supported, java applications in policy claimand coverage applications.
- Analyzed, coded, tested, implemented and supported IMS DB/DC and DB2 online and batch applications.
- Analyzed, coded, tested, implemented, supported wed- applications using Java and EXT-JS and Oracle or DB2 databases.
- Analyzed coded, tested, implemented and supported CICS and MQ series applications.
- Experienced with unit, integration testing and test case creation.
- Modify and enhance existing CDW programs as required by Business Dept. PPMs. Resolve Production problems with existing programs and processes.
