SUMMARY:

• Sr Developer - Programmer/Analyst - Senior technical lead - experienced in all facets of the SDLC.
• Worked on conversions, new development, enhancements/maintenance and production support - with
• Agile and Waterfall methodologies.
• Have strong analytical skills ; well versed in designing, developing, coding, testing, debugging, planning, creating documentation and production support, identifying and fixing defects ALM.
• Experienced in Legacy Systems and Data Warehousing systems - OLTP, OLAP - written in COBOL, BAL, CICS, DB2, IMS, JCL, Syncsort, CLIST, REXX, SAS, EASYTRIEVE, XML, MVS and z/OS, Oracle, SQL, PL/SQL, SQL Plus, Unix, Windows, MS Office, Word, Excel, Project, MS Access, Visio.
• Highly skilled in troubleshooting and identifying solutions.
• Worked on designing, developing and testing - enhancements for database, ERP systems, retail, financial, insurance, telephone and manufacturing applications, order management processes, mainframe interfaces, QA, SOX. Worked closely with DBA and other MVS support personnel on supporting and optimizing/upgrading existing system functions and adding new functionality. Created/modified functions, stored procedures, packages, views, triggers, sequences.
• Proficient in DB2 and Oracle RDBMS: COBOL DB2, SQL, PL/SQL, Stored Procedures / functions / packages -proven experience with Sql Plus and performing operational support for clients and users; troubleshooting tickets and providing quick analysis and support for other areas as well.
• Made recommendations for improvements and code changes in order for the COBOL programs, PL/SQL stored procedures and functions to run faster - optimized code. Understand Web technology, Java, J2EE, .Net.
• Knowledgeable of Unix, SQL Server, T-SQL, C#, Object Oriented Programming.
• Have excellent communication skills.
• Able to satisfy the requirements of one or more user areas; work closely with client management to identify and specify complex business requirements and processes, research and evaluate alternative solutions and make recommendations.
• I am a team player with strong communication skills, attention to detail and ability to prioritize and consistently meet deadlines.
• Modified the code - COBOL programs, JCL, test routines. Performed the mass compiles and tested the product.
• Also performed testing using the scripts provided for the baseline - model office - and requirements for Confidential

TECHNICAL EXPERTISE:

Operating Systems: z/OS, MVS OS390, UNIX, Windows XP/7, VM/CMS, VSE,.Net

Programming Languages: SQL, PL/SQL, COBOL, PL/I, IBM Assembler, SAS, REXX, HTML, T-SQL, Java

Mainframe Applications: SQL, PL/SQL, TSO/ISPF, CICS, IDMS, BMS, IMS DB/DC, JCL, CLIST, VSAM, QuickjobFileAid, Version control tools Panvalet, ChangeMan, Endevor; MQ SeriesCOBOL Report Writer, IBM Utilities (SYNCSORT, IEBGENER, IEBPTCH, etc), AbendAidEASYTRIEVE, XPEDITER, Intertest, Insync, VSE, DOS/JCL, NDM (Connect Direct)

DB2 Utilities: BMC, IBM Load, IBM InfoSphere Optim Performance Manager, RC/Query

Non-Mainframe: PL/SQL, SQL Plus, UNIX, Red Hat Linux, Oracle Forms and Reports, Sql Server, SSIS, ETLSQL Developer, Benthic Golden, Lotus Notes, Remedy, Peregrine, NDM (Connect Direct)FTP, MS Office VISIO, HTML, MS Visio, HP Mercury Interactive Tools Test DirectorALM, Winrunner, Java

Databases: ORACLE 10g, Oracle 11g, SQL PLUS, DB2, SQL, QMF, SPUFI IMS DB/DC, IDMS, MS Access

Applications: Data Warehousing, Retail, Financials, Insurance, Telephone, Credit CardUtilities VENTYX Asset Suite, INDUS Passport

Insurance packages: LIFECOMM, Cyberlife, Life 70, Claims systems

Methodologies: SDLC Waterfall, Agile

PROFESSIONAL EXPERIENCE:

Consultant

Confidential, Chicago, IL

Responsibilities:

• Work as a Sr. Developer in the Mainframe CICS/DB2 and Oracle/Unix group for the Passport Maintenance and Support team.
• Development and enhancements were performed in a Changeman environment.
• Worked with the Business Unit to identify and fix ALM defects; performed data changes and production fixes.
• The application is VENTYX Asset Suite, Indus Passport - Invoicing, Accounts Payable, Accounts Receivable, Contract Management, Workflow Management, Inventory, Purchasing.
• The application is table driven; environment/operating systems are COBOL, CICS, DB2/MVS, Oracle/ Unix, Linux, SQL Server, Windows, Java, GUI front end, CICS.
• The client converted part of the application from mainframe to Unix/Linux; the remainder still mainframe and Windows.
• I modified and tested COBOL/CICS/DB2 programs interfacing with a GUI front end for user data entry.
• Also created/modified JCL and used IBM utilities - IEBGENER, IEBCOPY, IDCAMS, SYNCSORT; batch SPUFI, ICETOOL, SyncSort, DFSort, IBM Load, RC/Query, Infosphere Optim Manager for DB2.
• Converted JCL and CLISTs to stored procedures on the Oracle platform. Created, modified and supported Unix shell scripts.
• Converted Applications using BMC load utilities to IBM Utilities and CA utilities due to BMC not supporting those applications in the future. Created and maintained JCL jobs and CLISTs, screens, reports, tables. Work with complex DB2 and Oracle tables. Performed production support as needed. Responded to tickets and defects and created the necessary SOX documentation. Scheduled and monitored jobs on mainframe and Unix. Work with DBAs, BUs, different vendors and users in a fast changing environment using Waterfall and Agile methodology.

Consultant

Confidential, Naperville, IL

Responsibilities:

• Completed assignments on the mainframe database applications written in COBOL, DB2, Quickjob, JCL, CLIST, SQL, IMS. Used ChangeMan, FileAid, Xpediter, MQ Series(Webshere) and MS Office for testing and documentation- for the Retail industry.
• Designed and maintained CICS and batch applications creating/updating Db2 tables - developed COBOL, DB2 code, JCL streams and utilities.
• Used DCLGEN’s, SPUFI, QMF and other Platinum Utilities - DB2 Loader.
• Worked on an multi faceted OLAP data warehouse financial application on Unix/Red Hat Linux..
• Extracted and aggregated data from the Oracle data warehouse to be available to telemarketers and other departments.
• Designed, developed, tested, and maintained Oracle objects such as database packages, stored procedures, triggers and functions to support the applications; complex tables, terabytes of data, partitioned tables and indexes, views, optimization techniques and production support. Loaded vendor file data from files in UNIX to database tables using FTP, SQL loader and Connect Direct on the mainframe.

Consultant

Confidential, Schaumburg, IL

Responsibilities:

• Responsible for mainframe COBOL, IMS, DB2 applications.
• Responsible for maintenance of GDG’s used to store vendor files which came in via FTp and were destined to the Data Warehouse(DB2 UDB).
• The programs were stored in ChangeMan and IBM load libraries.
• Performed data extraction using queries, merges, upserts; the packages were optimized utilizing hints, cost-based optimizer, and optimal table join method practices.
• The application functions on Oracle 11g, DB2 UDB and UNIX (Korn Shell).
• Writing and executing the UNIX shell scripts to test the application components. The client uses agile methodology.

Confidential, Madison, WI

Sr. Developer - Team lead - Oracle PL/SQL

Responsibilities:

• Responsible for conversion - replatforming a Telecom application originally written in mainframe COBOL, Quickjob, Syncsort, DB2, CICS, ChangeMan - to Unix, OLTP, Subversion, ORACLE 10g - 11g - PL/SQL, Tibco, Oracle Middleware, Oracle Forms.
• Responsible for mainframe projects and changes - performed extensive reverse engineering analysis of the existing application, extracted the existing business rules and created design documentation for the replatforming project, met with the users and BA's to approve the documents, built the product, tested and performed string testing and UAT.
• Responsible for entire project; built the PL/SQL packages involved. Coded the functions and stored procedures, sequences, triggers, optimized the code to increase efficiency; rewrote packages to use same standard functions and procedures. Also performed unit testing and UAT using Oracle 11 g - Agile methodology.
• Provided production and user support - responded to tickets, performed analysis and troubleshooting in a timely manner and moved changes to production. Made recommendations for code changes and new development.

Confidential, St. Louis -MO

Sr. Developer - Senior database technical lead

Responsibilities:

• Responsible for Full Cycle Development - analysis, design, coding, unit and system testing, UAT and QA of a Billing and Remittance multiplatform application (Healthcare) for Medicare-Part D. Also worked on the HIPAA team for modifications and upgrades of programs and stored procedures. Oracle 10g .Senior technical lead.
• My role was programming in COBOL, JCL, Synscsort, CICS, IMS, DB2; preparing documentation, program design, changing code(stored in ChangeMan), testing, creating JCL streams, screens, reports, packages, FTP steps, stored procedures, production support, also educating customers.
• Attended daily meetings and conference calls with the management to achieve and meet deliverables /goals and deadlines.
• Worked with onshore/offshore teams as a senior technical consultant - also with SMEs, project managers and QA teams. Provided direction to QA testers after all elements were moved to QA. Solved issues in a timely manner and completed all tasks in time. Used Agile methodology.
• Used MS Office: Word, Excel for documentation; created business rules and stored in MS Access.

Confidential, Granite City, IL

Sr. Developer/tester - Senior database technical lead

Responsibilities:

• Was responsible for SDLC- maintenance and user requests - gathering requirements, creating documentation, design, coding, unit testing - also participated in System testing and UAT - of several modules belonging to an ERP application, COBOL programs and stored procedures, SQL, MQ Series, SAS, Easytrieve, PL/I, DB2, IDMS, IMS, transferring data between the client and vendors: the client’s mainframe application received adds/updates (XML messages) from vendors, validated and loaded incoming data, and responded indicating status of the update. Responsible for the ERP application upgrade.
• Worked on several service requests and tickets from users run queries and create reports as requested by the users and Business planning Units, wrote functional specifications, test plans, testing procedures and data for several IMS and DB2 in-house utilities; also used HP Quality Center: Test Director, Winrunner.
• Participated in writing use case documentation based on existing mainframe programs.
• Documented, communicated and reviewed with project team members and Business users