SUMMARY:

Project Leader /Tech Lead / Architect with extensive experience in information technologies. Areas of expertise in Masking, Column & Data Mapping, ETL, TDM, Data Archive / Growth, Data Profiling solutions with use of IBM OPTIM z/OS and Distributed (LUW), Informatica TDM, Masking (in place), Power center, ETL, ILM, DVO, DQ,MDM, batch and online system designing, programming, Data architecture, Data modeling, Data Conversion/Cleaning, Cleansing, Data warehouse and leadership expertise in a variety of application areas.

TECHNICAL SKILLS:

COBOL, CICS: Channels/Containers and Temp Storage, Microsoft Visual Studio .NET, SourceSafe, Visual BasicExcel VBA, HTML, XML, C, IBM MQ SERIES, IMS/DC, UNIX/SCRIPT, 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, TDM, Masking ), Data Profiling, PowerCenter 9.6 and PowerExchange 9.5/8.6/.1, Talend Open Source, Oracle SqlDeveloper, WINSQL, BI (BUSINESS OBJECT/Universe, Crystal Report, OBIEE), DB2 COMMANDER, FILEAID, SPUFI, SDF, BMS, INTERTEST, XPEDITER, SMARTEST, SYNCSORT, ENDEVOR, EXCEL, WORD, POWERPOINT, VISIO, ACCESS, SQL, PANVALET.

APPLICATIONS: Health Care - TDM, Archiving, De-commissioning application with IBM Optim and Informatica. Telecommunication - Migration legacy application

INSURANCE: Data Warehouse, Test Data Management, Claims, Case Trakker& Billing, DBL, Accident & Health.

FINANCE: Auto Finance, Mortgage & Loan.

RETAIL: Enterprise order entry, reservations and shipping, Credit.

MANUFACTURING: Order Entry & Processing, Billing.

UTILITY: Service Order.

PHARMACEUTICAL: Order Processing, Prescription services.

PROFESSIONAL EXPERIENCE:

Optim - TDM Expert

Confidential, Deerfield, IL

Responsibilities:

• Involved in research, Discovery metadata for Masking for POC / POT of IBM distributed Optim 11.3 and Sybase 16.0.
• Setup relationship between tables of cross databases on same server.
• Popgate key field of parent table and its related tables.
• Developed LUA scripts with use of Optim Developer Manager.

Informatca ILM - TDM Expert

Confidential, Sacramento, CA

Responsibilities:

• Involved in research, Discovery metadata for Masking, masked 149 columns, 48 tables and 3 MS SQL-2012 Database with use of Informatica ILM - TDM and PowerCenter 9.6 Hotfix.
• I was only person who created TDM Projects, Policies, Domains, Rules, Plans, Workflows and executions. Trained client employees for Masking.

Optim Lead

Confidential, Sacramento, CA

Responsibilities:

• Involved in Archiving 14 Apps with use of IBM OPTIMzOS, Optim LUW, ODM and Seq Files, DB2, Oracle, MS SQL Databases and de-commissioning applications.
• I was a one who found a solution to create Oracle External Table from formatted extracted file from mainframe data store for archiving.Scheduled nightly jobs with use of zOS JCL and scheduler.
• Good exposure in Informatica MDM where IDD, data Cleansing, De-duping and Address correction wereperformed.
• Created and Configured all the components in MDM. Sub-setting, Masking sensitive columns, creating Gold copy from Production database in TDM project with use of InformaticaPowerCenter 9.6, ILM and Oracle 11g.

Optim Architect

Confidential, Phoenix, AZ

Responsibilities:

• Involved in Test Data Management and Masking with use of IBM OPTIMzOS and Vsam, Seq Files and IMS Database.
• Involved in writing Optim Exit routine in COBOL and Scheduled nightly jobs with use of zOS JCL and scheduler.
• Got training in TDM Datamaker /Grid-Tool

Confidential, Kansas City

Informatca ILM - TDM Expert

Responsibilities:

• Involved in research, Discovery metadata for Masking, masked 252 columns, 92 tables and 7 MS SQL 2012 Database with use of Informatica ILM - TDM and PowerCenter 9.6 Hotfix.
• I was only person who created TDM Projects, Policies, Domains, Rules, Plans, Workflows and executions. Trained client employees.
• Created mapping with Normalizer transformation to process de-normalize VSAM COBOL file containing OCCURS and REDEFINE.
• CreatedInformaticaPowerExchange (9.5)RegistrationandData mapto capture data inreal-timeandbatch mode from source IDMS database.inInformatica.
• Involved in data Cleansing, De-duping and Address correction in MDM project.

Confidential, Chicago

IBM OptimConsultant

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

Informatica 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 Informatica TDM and Masking, Power center 9.1 Data Quality, Data Profiling and Informatica Analyst solutions.
• Developed InformaticaTDM Sub-setting, Masking 36 masking rules against 160 sensitive columns.
• Involved in Data Archiving with use of Informatica ILM tool and Oracle database 11g.

Confidential

IBM Optim and Informatica Consultant

Responsibilities:

• Involved in Archiving, De - commissioning application, creating report against Optim archive file,Test Data Management and Masking with use of IBM OPTIM, ODM.
• Was Involved in TDM project Sub-setting, Masking sensitive columns with use of InformaticaPowerCenter 9.1.

Confidential, IL

Informatica Consultant

Responsibilities:

• Developed and deployed the ETL processes, Informatica TDM Sub-setting, Masking solutions with tool Inforfmatica to access data from various sources relational (Oracle E-Business Suite - R12) and non-relational in EDW environment.
• Involved in Data Archiving and sun-setting application solution with use of Informatica ILM Tool and Oracle database 11g.

Confidential, NC

Team Lead Consultant

Responsibilities:

• Originator and initiator of the OPTIM Test data management, Archiving, De - commissioning application projects:
• 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).
• Designed, developed and deployed the ETL processes, Data Quality, Data Profiling with tool Inforfmatica Power Center 8.6.1 to access data from various sources including relational and multi-dimensional Database systems in environment Buy and Pay Business Transformation processes into one single instance of Oracle R12. BnP includes various R12 Financials applications OM, CRM, AR, AP, GL and HR. Created reports and charts with BI tool OBIEE, Cognos. Have Extensive experience With Informatica ILM to mask SSN, CCN, Email, Name and address. Knowledge with Informatica CLOUD - Salesforce.com, Power Exchange, Apex, Transformation.

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, IL

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:

• Developed, Maintained, Enhanced following systems
• The Claim system using DB2, SQL, COBOL, CICS - Channels/Containers and Temp Storage, IBM MQ SERIES, VSAM, Xpediter, FileAidSyncsort 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 &TalendOpenSource 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.
• Business Object/ Crystal Report - creating universe from Claims datawarehouse and creating reports.