SUMMARY:

• Well rounded IT professional with MBA and over 15 years of experience in design, development, project management and support of various Information technology systems in Financial (Wealth Management and Alternative Investments), Media, Retail and Health care domains.
• 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 SSRS (SQL Server Reporting Services) reports.
• 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.