SUMMARY:

• Over 15 years experience in analysis, design, development and support of IBM mainframe applications primarily using CICS, DB2, COBOL, SQL, VSAM and JCL.
• Over 5 years full life cycle experience in migrating legacy mainframe applications from IBM mainframe to Microsoft Windows .net environment.
• Five years hands on experience with Microsoft SQL Server Integration services (SSIS) and Microsoft Reporting services (SSRS).
• Over 6 years of experience in Oracle PL/SQL skills (Stored Procedures, Functions), T - SQL and using RDBMS databases Oracle and SQL Server.
• Project planning - resources and implementation plan
• Project Estimates Development
• Project Scoping and Requirements Review and Sign off
• Project State Reporting to management
• Coordinating with Systems and User Testing teams across the enterprise
• Project Financials Forecasting and Reporting
• Design Review and Sign off
• Test plan and scripts Review and Sign off
• Deployment Planning and Management
• Tracking Issues/Risk and Coordinate Resolution
• Coordinate development effort with on-site and off-shore teams

PROFESSIONAL EXPERIENCE:

Confidential, Pennington, NJ

Senior IT consultant

Responsibilities:

• Responsible for interacting with business analyst evaluating reporting needs, reviewing data models, creating design document for project deliverables.
• Involved in end-to-end development and maintenance of Confidential One (ML1) reporting platform on GIRT.
• Defined detailed development tasks and estimates to develop project plans, test plans and implement the plans.
• Coordinated with offshore team to develop Mainframe batch process to load the data feeds from other systems such as Enrollment, Workflow, Strategy and KD into reporting database (DB2).
• Extensively used Microsoft SharePoint for Project Management tasks such as creating project estimate templates, project tracking lists, dashboards, and workflows.
• Developed number of DB2 Native Stored Procedures for ML1 Traditional Investments product line.
• Developed JCL, PROC’s, and COBO/DB2 programs to support reporting database.
• Analyzed and suggested recommendations for SQL Queries performance.
• Involved in end-to-end planning to support annual mainframe disaster recovery (DR) exercise.
• Extensively involved in writing/modifying Oracle PL/SQL procedures, functions, triggers, views, packages for Alternative Investment product line.
• Created metadata in Oracle DB to define report parameters, column names, column mappings and user permissions.
• Created excel templates for reports using advanced excel analytics such as pivot tables and vlookup.

Environment: IBM Z/OS, COBOL, DB2, SQL, JCL, FTP, DB2 PLATINUM UTILITIES, Endeavor, Microsoft .net, Oracle 11g, TOAD, PL/SQL, Visio, Excel, SSRS, Microsoft SharePoint 2010.

Confidential, Riverside, NJ

Legacy Solutions Analyst

Responsibilities:

• Interacted with business managers and other application support person for gathering requirement and preparing both functional and technical specs.
• Responsible for maintenance and enhancements of Universal Order Processing (UOPS) and Royalty applications (RAS) running in mainframe environment.
• Redesigned and developed CICS Order entry and Maintenance programs to support “E-Books” project.
• Wrote CICS subroutines to support E-Books product linking project to centralize the business logic.
• Wrote DB2 Stored Procedures to get ISBN, PO and Physical Inventory data.
• Participated in Mainframe disaster recovery (DR) exercise testing and user sign-off for legacy applications.
• Involved in full life cycle of mainframe re-hosting project including analysis, design, system integration testing and implementation.
• Coordinated the development, system testing and integration testing with a team of 8-10 off-shore developers.
• Developed over 25 SSIS (SQL Server Integration Services) Packages to replace Mainframe DB2 load/unload functionality.
• Developed over 35 SSRS (SQL Server Reporting Services) to replace the Mainframe based reports used to be generated by COBOL programs exclusively ran for this purpose.
• Converted CICS BMS screens to ASP.NET using Neokicks conversion utility.
• Worked with technology service group to create new websites for migrated CICS applications.
• Involved in migrating mainframe jobs to run on Windows server environment using Neobatch.
• Coordinated with DBA’s to convert mainframe DB2 databases to SQL SERVER.
• Developed brand new C# and VB.Net applications for E-Books project.
• Monitored and resolved the Legacy application performance issues.
• Used Autosys scheduler to create and monitor the job flows in the windows distributed environment.

Environment: IBM Z/OS, COBOL, VB.NET, C#,DB2, Xpeditor, Syncsort,SQL, JCL, VSAM, SQL, FTP, Fujitsu .NET COBOL,CICS, ASP.NET, VB.NET, NEOBATCH, Neokicks, EDI,PERVASIVE MAP DESIGNER, SSIS, SSRS, SQL SERVER, ORACLE APPS, Autosys, Unix Script, VI commands, PL-SQL, SQL Developer, SharePoint

Confidential, Philadelphia

Senior IT consultant

Responsibilities:

• Assisted in the development and maintenance of pharmacy provider network files.
• Supported COBOL/DB2 batch applications that load RXDB and NDC databases for pharmacy services.
• Assisted in development and implementation of FutureScrpits AWP-Based pricing functionality.

Environment: IBM Z/OS, COBOL, DB2, SQL, JCL, IDMS, VSAM, SQL, Xpeditor, FTP, Endeavor, Insync, Sync Sort, Easytrieve, Access.

Confidential, Bensalem, PA

Senior IT Consultant

Responsibilities:

• Responsible for maintenance and enhancements to purchase order application in mainframe environment.
• Developed 3 brand new CICS/COBOL/DB2 programs for factory entry, factory maintenance, and factory search by vendor/country.
• Developed a conversion process to convert the existing 8 digit factory id to10 digit factory id based on the business supplied rules.
• Developed 4 brand new CICS programs for SKU Inquiry, separating it from existing one screen SKU Inquiry/Maintenance.
• Developed batch process which extracts the mainframe data and transfer it to Elixir Server using FTP.

Environment: IBM Z/OS,COBOL, CICS, DB2, SQL, BMS, JCL, VSAM, Teradata Administrator 7.0, EDI, Elixir Technologies, ZEKE,Visual Basic, Oracle 9i, SQL, PL/SQL, Xpeditor, FTP, COMPAREX,IDMS, Control-M, Control-D, FILE-AID, MAX/Utilities, Sync Sort, PLATINUM UTILITIES

Confidential, Wilkesboro, NC

Programmer Analyst

Responsibilities:

• Coded over 10 new programs using COBOL, APS, JCL, CICS, VSAM and DB2.
• Developed PO maintenance screens (CICS) to support new cross dock PO types.
• Involved in the project converting Purchase order master VSAM file to DB2 Table.
• Analyzed the Usage of VSAM file in all affected Programs and replaced the code with embedded SQL Statements.
• Converted 10 -15 Assembler Payroll/Accounting programs to MVS COBOL.
• Performed production support and documentation.