OBJECTIVE:

• Project Leader /Tech Lead / Architect with extensive experience in information technologies. Areas of expertise in Masking, Column & Data Mapping, ETL, TDM / MDM, Data Archiving, Data Growth, Data Profiling applications with use of IBM OPTIM z/OS and Distributed (LUW), Informatica (ETL, ILM, DVO, DQ, Analyst, CLOUD), batch and online system design, programming, data architecture, Data modeling, Data Conversion/Cleaning, Data Mapping, Data warehouse and leadership expertise in a variety of application areas.

TECHNICAL SKILLS:

LANGUAGES: COBOL, CICS - Channels/Containers and Temp Storage, Microsoft Visual Studio .NET, SourceSafe, Visual Basic, Excel VBA, HTML, XML, C, IBM MQ SERIES, IMS/DC, UNIX/SCRIPT, MICROFOCUS COBOL., JCL, TSO/SPF, CA/Window-Job Scheduler, Changeman.

DATABASES: ORACLE-11g & R12, DB2, MSSQL, ACCESS, MYSQL, IBM-UDB, SYBASE, DATACOM, IMS, IDMS, S2K, ADABASUTILITIES/TOOLS: DATA WAREHOUSE ETL Tools - IBM-OPTIM (Distributed LUW and z/OS Platform), Informatica (ETL, ILM, DVO, DQ, Analyst, CLOUD), Data Profiling, Talend Open Source, Oracle SqlDeveloper, WINSQL, BI (BUSINESS OBJECT/Universe, Crystal Report, OBIEE), DB2 COMMANDER, MYSQL WORKBENCH, FILEAID, SPUFI, SDF, BMS, INTERTEST, XPEDITER, SMARTEST, SYNCSORT, ENDEVOR, EXCEL, WORD, POWERPOINT, VISIO, ACCESS, SQL, PANVALET.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

Consultant

Responsibilities:

• Involved in research, profile metadata, masking, validate / compare project of Test Data Management (TDM) and Test Data Privatization (TDP) with use of IBM OPTIM zOS (Mainframe), OPTIM Distributed (LUW) and Operational data stores (ODS). POC for Delphix Database Virtualization using integrated with source, target, VM, Delphix engine for provision virtual database to Development, UAT, QA teams. Knowledge of DMsuite for the masking.

Confidential, NJ

Consultant

Responsibilities:

• Developed and deployed Informatica DVO - Table Pairs (Aggregate: Count, Count Distinct, Count Rows, Sum), SQL Views, Lookup Views (Heterogeneous Database Tables), Import / Export Repository
• Metdata ( Table Pairs, PW Sources, SQL and Lookup Views, Join Views), Run Test, Generate reports.
• Extensively involved in Masking, Data Quality, Data Profiling and Informatica Analyst solutions.
• Developed 36 masking rules against 160 sensitive columns. Database: Oracle 11g

Confidential

Consultant

Responsibilities:

• Involved in Archiing, De-commissioning application, creating report against Optim archive file, Test Data Management and Masking with use of IBM OPTIM, ODM.

Confidential, IL

Consultant

Responsibilities:

• Developed and deployed the ETL processes, Data Quality, Data Profiling solutions with tool Inforfmatica to access data from various sources relational and non-relational in EDW environment. Database: Oracle R12

Confidential, NC

Team Lead Consultant

Responsibilities:

• Primary tasks included Resource Planning and Team Coordination.
• Analysis, Estimation, Design and Implementation of Data Masking solutions with OPTIM.
• Involved in requirement gathering with SMEs, DBAs to understand the Databases and their environments.
• Familiarize with Retail business through IBM Software Sterling, Genesis and its interfaces with the host and other Distributed Applications.
• Familiarize with MQ to interface with ESB and Sterling.
• Supporting releases with different phases of enhancements in Applications.
• Archiving, De-commissioning 10 applications with use of IBM OPTIM z/OS and Distributed(LUW).

Confidential, NJ

Team Lead Consultant

Responsibilities:

• Expertise in Masking, Column & Data Mapping, ETL, TDM, Data Archiving, Retiring and Data Growth 20 applications with use of IBM OPTIM z/OS and Distributed(LUW).
• Responsible for masking sensitive data SSN, CCN, Name and Bank Account with use of IBM OPTIM Tool.
• Extracting data from DB2 Database, Legacy VSAM, SEQ and IMS, Masking with use of OPTIM Column mapping, Exit routines on z/OS, TRANS SSN, CCN, Hash-LOOKUP, LOOKUP SUBSTR functions, loading to target.
• Coached OPTIM every day for one hour to coworkers.
• Wrote many OPTIM Column Exit modules which no one from Confidential did before.

Confidential

Sr. Consultant

Responsibilities:

• Define selection criteria to extract a relational subset of data.
• Convert the extracted data using Data Mapping, Transformation Techniques and mask confidential and sensitive data.
• Create table maps and column maps
• Define Relationships
• Compare converted data to the extract
• Insert, load or Update converted data to a target DB2 Database
• Utilize optional features such as Edit, Custom Exits in z/OS COBOL, Column Mapping or Lookup Table
• Import and Export OPTIM Objects
• Use of DB2 tools - WINSQL and DB2 COMMANDER
• Extracting data from 600 XML files with XMLSpy (Altova) software to feed the data to DB2 database.
• Created reports from Excel and Flat files with use of Excel VBA and DB2
• Setup OPTIM Jobs to reduce Data, synchronization and propagated data to 25 DB2 Schemas and 13 DB2 subsystems. Support nightly jobs.

Confidential, Schaumburg, IL

Team Lead Consultant

Responsibilities:

• The Claim system using DB2, SQL, COBOL, CICS - Channels/Containers and Temp Storage, IBM MQ SERIES, VSAM, Xpediter, FileAid Syncsort and ENDEVOR, JCL, CA/Window-Job Scheduler, TSO/SPF.
• Claim Data warehouse (CDW) using AIX UNIX/Script, SYBASE, DB2, COBOL, IBM-UDB, SQL and familiarized with ETL tools MS SSIS, SSAS & Talend OpenSource and Data Stage. High level management reports created with use of BUSINESS OBJECT/DESIGN, Universe, and Crystal Report. Involved in Data convesion to feed the data to UDB database for Data Warehouse project.
• Medical Manage Care Billing systems Using Aix UNIX/Script, VB.NET, SourceSafe, COBOL, DB2,, TSO/SPF, DbArtisan, MS SQL, Stored procedure, VSAM, Xpediter, FileAid and ENDEVOR. Involved in Data modeling, Data Conversion & data mapping for Express Script (Medicine Mail Order) interface project.
• Claim Auditing, Triage, Claim Evaluation, Vendor Management, Time Management systems using VB as a front end and ACCESS back end. ODBC connection to MS SQL server
• Supported 24/7 and enhanced vendor product CAPTIVA with Optical Scan Software - scan workcomp claims in batches separated from other medical bills, Validated against CICS DB2 Claim system and manipulate files before exporting to file formats, ClaimPack - automates the capture and processing of standard healthcare claim information from form UBs etc., InputAccel - Capture information from most paper or electronic sources, transform it into digital content, and deliver it into back-end systems SQL database. Cleared out stuck batches.
• Maintained, Enhanced and supported 24/7 Time and Billing system of Nurses time spent on Claims case using ASP.NET, VB, MS SQL and interface with Mainframe Claim system with DB2 and COBOL. Medical Invoice report created with use of Crystal Report and MS SQL database.
• SQL Programming - Building SQL queries inner and outer joint - Selecting, Updating and deleting rows, Setting up triggers, Stored procedures.
• MS Excel - Creating delimiter flat file, upload to Database, Import & Export data.
• Data Analysis - Mapping the data, Normalize database, Interfaces.

Confidential, Bannockburn, IL

Consultant, Team Lead

Responsibilities:

• Did Data modeling, Data conversion and Data mapping, Designed, coded, tested and implemented Re-Engineering Claims Denial project of Internal Billing system using COBOL, DB2, SQL, VSAM, Xpediter, FileAid, JCL, TSO/SPF, CA-Job Scheduler and Changeman.

Confidential, South Barrington, IL

Consultant

Responsibilities:

• Changed and tested 360 Online/Batch Programs of Inventory Finance system for upgrade and Y2K compliance using CICS, COBOL, VSAM, EZTRIEVE, FILEAID, JCL, TSO/SPF, CA-Job Scheduler. Analyzed and researched all GENERAL LEDGER feeder Systems, Involved in Data modeling, Data conversion and Data Mapping to feed the data to Oracle tables for ORACLE FINANCE Package.

Confidential, Long Grove, IL

Consultant

Responsibilities:

• Designed and developed complex CICS modules to acknowledge all users for batch jobs are running and done for Claim Processing System. Maintained and enhanced Programs using COBOL, CICS, DB2, QMF, SQL, Fileaid, VSAM, Xpediter and ENDEVOR, JCL, TSO/SPF, CA-Job Scheduler.
• Modified and tested applications developed in Visual Basic and Access database.

Confidential, Bannockburn, IL

Consultant

Responsibilities:

• Designed, coded, tested and implemented Prescription Service (Quantum Leap); system using COBOL, CICS, DB2, SQL, VSAM, Xpediter & FileAid, JCL, TSO/SPF, CA-Job Scheduler and Changeman.

Confidential, Riverwoods, IL

Consultant

Responsibilities:

• Maintained and enhanced Refund Anticipation Loan System; using COBOL/APS, CICS-Command, DB2, SQL, Smartest, Easytrieve, SAS, FileAid; JCL, TSO/SPF, CA-Job Scheduler Extensive use of Micro Focus Workbench & XDB.

Confidential, Hoffman Estates, IL

Consultant

Responsibilities:

• Responsible for Programming, Writing Test Cases and implementing Vendor Management and EDI interface systems with the use ofCOBOL/APS, CICS, DB2, SQL, IMS, JCL, TSO/SPF, CA-Job Scheduler, Intertest, SmartTest and FileAid, Extensive Use of Micro Focus Workbench and XDB.

Confidential, Glenview, IL

Consultant

Responsibilities:

• Maintained and made enhancement to Order Management System, using COBOL/APS, CICS, SQL, JCL, TSO/SPF.

Confidential, Schaumburg, IL

Consultant Team Lead

Responsibilities:

• Designed, programmed, tested, implemented, maintained and enhanced very large Oil Movement Inventory, AP/AR systems, using COBOL, CICS, Intertest, S2K, Sybase & FileAid JCL, TSO/SPF, CA-Job Scheduler. Extensively involved in Data modeling, Data Conversion and data mapping to update database.

Confidential, Schaumburg, IL

Consultant

Responsibilities:

• Developed, implemented and maintained large online/batch ‘Claims Processing’ system. Developed Command Manager System to manage all CICS functions. Developed check printing program using CICS, Troy Laser Printer Macro language.