SUMMARY:

• 13+ years of IT industry experience with expertise in CA Data Maker and IBM Optim Test Data Management on both Mainframes and distributed systems.
• Successful implementation of CA Data Maker and IBM Optim for Test Data Management, Data Privacy in testing environments for large clients like Confidential, Confidential Pharmaceuticals and BCBS.
• Served the roles of CA Data Maker and IBM Optim Consultant, Data Analyst, ETL Test Analyst, Quality Assurance analyst and Production support.
• Experience in Data Analysis, Data Mapping, Data Modeling, Data Entity Relationship Diagram and strong understanding of Relational DBMS.
• Extensive experience creating OPTIM access definitions, relationships, column maps, table maps, and performing extracts, conversions, exports/imports, inserts/loads.
• Handled multiple applications on different data sources like DB2 for iSeries/AS/400, Oracle, SQL Server, XML files, DB2 for LUW and flat files using OLE DB/ODBC
• Scripted and executed SQL queries to retrieve information from the database based on the input values.
• Presented workshops to Client Application teams to showcase Sub - Setting & Masking solutions
• Govern Changes for Data for Test environment to QA and Acceptance environments for major US Finance and Mortgage organization.
• Lead POC with IBM Optim Test Data Management for delivering Data Masking & Sub-Setting solution.
• Collaborated with IBM & BTRG (Implementation Partner) to deliver Data Privacy solution.
• Interviewed application teams to understand and document Application Architecture, Configuration, Dependencies, Data sources, Services and other interactions.
• Implement Test Data Management for 3 biggest applications and databases at BCBS.
• Provisioned multiple environments where database and applications can be tested & deployed.
• Created multiple data repositories in the test environment for Health Care clients.
• Categorized Power MHS (iSeries/AS/400) tables in Sub-set, Full-set or Exclude for Sub-setting effort.
• Categorized 4700 Power MHS tables in several modules to include tables in IBM Optim Access Definitions logically.
• Strong knowledge of ITIL standards and Atrium CMDB. Experience in customizing ITSM applications with CMDB such that business requirements are met and application functionality are enhanced.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/9.0.1/8.6.1/ x (Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor), Power Exchange 9.0.1, Informatica Analyst

Data Modeling: Relational and Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Erwin, MS Visio

Databases: Oracle 11g/10g/9i, MS SQL server 2012/08/05 R2, MS-Access, Teradata V12

Programming: SQL, UNIX, SQL Tuning/Optimization, C, PL/SQL, HTML, JavaScript, ASP, JAVA

Tools: SQL *Plus, SQL* LOADER, MS Office, ILM, Active Batch, TOAD, Data Studio, PuTTy

OS: Sun Solaris, Windows 7/98/95/NT/2000/2003/XP/Vista.

PROFESSIONAL EXPERIENCE:

Confidential, Chevy Chase, MD

Test Data Management Consultant

Responsibilities:

• Implemented Test Data Management Proof of Concept design using CA Data Maker
• Installed CA Data Maker 3.8 suite of products for Data Sub Setting and Data Privacy
• Auto Policy application understanding for Copy and Clone functionality
• Umbrella Policy Clone and Copy workflow development using CA Data Maker
• Data Masking using CA Fast Data Masking for Production to Lower environment copy
• Data Sub-setting using CA Data Maker to Copy data from Production to Staging environments
• Load Test environment architecture design to combine Auto and Umbrella policies data
• Document data flow from several key applications like Policy, Billing, Reporting, BBS and BCS
• CA Javelin automation development to design Copy workflows
• Gold Copy design and legacy data synchronization using CA Data Maker
• Data Masking validation automation for source and target databases
• Discover and Identify data relationships across applications
• Create New Projects, Versions, Data Sets, Data Groups, Extracts and Data Pool in Data Maker
• Documented testing and development procedures and operational tasks activities

Environment: IBM Optim, IBM Discovery, CA Data Maker, CA Javelin Workflow Automation, MS SQL Server 2012, Toad, PL/SQL, Excel, MS Visio, CA Agile Workflow

Confidential, Bloomfield, CT

Test Data Management Consultant

• Designed frame work for Data Masking Proof of Concept for several Application teams.
• IBM Optim Designer Installation, Configuration and Administration
• IBM Discovery Installation, Configuration and Administration
• Data Sub-setting from Production and Pre-Production environments
• New Pre-Production Environment Build, Configuration and Administration
• Data Sub-setting from source using reference data
• Data Sub-setting from source without reference data
• Discover and Identify data relationships across applications
• Revised Data Masking Exits and Functions to remediate previous flaws and to prove successful Data Masking capabilities in Development region.
• Used standard & customized Exit routines for Masking Dentacom Applications using IBM Optim
• Held information gathering workshops with Application team leads and Subject Matter Experts.
• Responsible for analyzing different applications for Mainframes and Servers to locate sensitive and restricted data while using a test environment that needs to be fully protected to ensure security of client information at all times.
• Designed Data Masking PHI (Personal Health Information) Masking Function worksheet with application specific data type.
• Completed Data Masking and Sub-Setting Pilot successfully Dentacom Application teams.
• Worked with several applications SMEs and DBAs to understand and document custom tables
• Data Discovery performed for various applications on Oracle, DB2 and I-Series using IBM-Discovery tool to identify key relationships and mappings for Data Masking.
• Completed Data Masking for all applications and data bases with sensitive customer information across pre-production environments to meet set guide lines and government policies.

Environment: IBM Optim, IBM Discovery Studio, Oracle 11g, SQL Server 2008, CA LISA, Hadoop, Flat Files, XML files, Windows 2003, RFC for Change Requests, Erwin 3.5, Toad 7.0, Unix, MS Visio

Confidential, Durham, NC

Test Data Management Consultant

• Interviewed and Evaluated Data Masking and Service Virtualization product vendors like CA, Informatica, Solix, IBM, HP and Voltage for initial LRS 1 project startup.
• Project Lead for Test Data Management for LRS (Lower Region Strategy) 1st & 2nd phase projects for Blue Cross Blue Shield of North Carolina for Data Sub-Setting and Masking of Non-Production environments
• Managed Data Masking and Sub-Setting Pilot successfully for Siebel-Service First, PowerMHS (iSeries/AS/400) and One View in phase 1 of LRS project.
• Completed Proof of Concept with IBM Optim Test Data Management for delivering Data Masking & Subsetting solution.
• Held workshops with IBM Optim Test Data Manager for Data Masking on-going solution.
• Performed Data Sub-Setting using IBM OPTIM 9.1 to Sub-set One View, Siebel and Power MHS applications used by BCBSNC in Pre-production environment.
• Surpassed BTRG results independently by delivering a 52% size reduction for One View transaction data size.
• Redesigned and reduced target region size initially achieved by IBM- BTRG professionals by re-designing Optim Access Definitions and Extract jobs.
• Debugged application issues in Habitat for the current LRS 2 project.
• IBM InfoSphere Optim 9.1 trained by BTRG experts for more advance IBM Optim techniques, Config file creation, Node and Database cataloging from IBM DB2 Command Line Processor.
• Created Federated Server Nicknames for PowerMHS (iSeries/AS/400) tables to connect to Optim
• Used custom developed Import utility to import Access Definition, Primary Keys and Relationships in Optim from spreadsheets.
• Masked DB2 data, sequential files, and VSAM files on the Mainframe for IBM Optim Pilot.
• Utilized Erwin, Toad and Data Studio for Reverse Engineering and Data Modelling.
• Worked with BCBS Subject matter experts to identify Sub-setting strategy for specific applications.

Environment: IBM Data Studio, IBM InfoSphere Optim, CA LISA, Oracle 10g/9i, MS SQL Server 7.0/2000, Flat files, Main Frames, SQL*Loader, Hadoop, Erwin 3.5, Toad 7.0, Unix, windows 2003, UNIX.

Confidential, Charlotte, NC

Test Data Management Consultant

• Involved in Remedy CMDB Data Modeling and Asset Management for Animal Health project.
• Asset management for several teams of Confidential spread worldwide for site consolidation project.
• Managing reconciliation of applications environments, software components, infrastructure hardware, servers, mainframes and network hardware.
• Assisted Team leads and Project managers in managing SDLC which includes Requirements gathering and Project Planning, Generate Design, Functional Specs, and Test scripts.
• Assisted in Testing and debugging and custom developed Test and Bug Tracking system.
• Atrium Discovery and Dependency Mapping (ADDM Version 8.2) and BMC Pro-Active Net Performance.
• Monitored SIEM Dashboard to identify suspicious activities that need to be investigated.
• Updated Knowledge Articles and SOPs for tier 1 and trained teams in batches.

Confidential, Reston, VA

Production Support and Data Governance

• Involved in Installation, patching, maintaining and supporting the Remedy AR Systems Administration.
• Successfully customized ITSM modules Such as Incident Management (HD), Problem Management, Change Management (CM), Asset Management (AM) and modules according to client Requirements.
• Effective use of the Migrator tool to identify differences and move workflow from Development, Testing and to Production.
• Worked on ITSM Customizations for Incident, change, Problem Management.
• Successfully implemented Customizations to ITSM Notification engine and developed few new Notifications to Change Management and Task Management Modules.
• Developed Custom Applications as per the client requirements and to support ITSM customizations.
• Developed Remedy workflow, forms, reports and filters and workflows for custom automation within forms.
• Successfully loaded foundation data into ITSM 7.x with the help of Data Management Tool.
• Integrated ITSM Incident and Change Management Modules with 3rd party apps by publishing Web services.
• Other Activities Include Remedy Application Support, On-Call Support, preparing documentation as per the customer requirement.
• Worked on different bug fixes within Incident Management, Change Management, Asset Management and Problem Management.
• Successfully created new Vendor and View forms for different Customizations in Incident, Problem and Change Management modules.
• Provide technical support for the BMC BladeLogic Client Automation 8.2 (formerly called BMC Configuration Management or Marimba) distribution system and general application troubleshooting.
• Worked on Mid-Tier Configuration as per the requirement.
• Worked on In-Depth log file analysis of AIE and Reconciliation activities.
• Customized the CMDB Classes and Asset forms according to Customer Requirements to Store Client Specific information.
• Worked on CMDB reconciliation and merged the data sets.
• Good knowledge of Change Management Approval process and Assignment engine.
• Worked on Remedy Notification Engine and the email engine including the within-application email system and modified Template models.
• Worked on Customized email functionality for incident management.
• Worked on customizations of Change Management and Incident Management templates.
• Monitoring email alerts concerning suspicious activities that need to be investigated.
• Provided 24x7 Incident Management support of the application.
• Performed OS/Network Administration tasks.

Technologies: BMC Remedy AR System 5.x/6.x/7.x, BMC Remedy IT Service Management Suite (ITSM 7. x), BMC Remedy Service Desk 7.x, BMC Remedy Change Management 6.x/7.x, BMC Remedy Asset Management 7.x, BMC Remedy Mid-Tier 6.x/7.x, BMC Remedy Email Engine 6.x/7.x, BMC Remedy Migrator 6.x/7.x, BMC Remedy Data Management Tool, BMC Remedy Import 6.x/7.x, Windows Server 2003, SQL Server 2005

Confidential, Washington, DC

BMC Incident, Change & Problem Management

• Development and implementation of Help Desk (HD), Change Management (CM) according to business requirements.
• Perform Remedy ITSM 7.x System Administration.
• Assisted Team leads and Project managers in managing SDLC which includes Requirements gathering and Project Planning, Generate Design, Functional Specs, and Test scripts.
• Assisted in Testing and debugging (also created user friendly custom developed Test and Bug Tracking system).
• Involved in support processes including the ability to submit, monitor, and manage help desk cases, change requests, and asset inventory records.
• Developed Reports using Crystal Reports.

Technologies: BMC Remedy AR System 5.x/6.x/7.x, BMC Remedy Action Request System 5.x/6.x/7.x, BMC IT Service Management Suite 6.x/7.x, BMC Remedy Service Desk 7.x, BMC Remedy Change Management 7.x, BMC Remedy Asset Management 7.x, Crystal Reports XI, Windows Server 2003, UNIX, Oracle 10g, 9i, PL/SQL, SQL Server 2000, IIS server 6.0, MARS 6.0.

Confidential, Rockville, MD

Business Objects Developer

• Interacted with Business Users in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Extensively created and maintained complex Business Objects Universes and Reports using the Designer and Reporting modules like Crystal Reports XI, Desktop Intelligence and Web intelligence.
• Developed Crystal reports from Universes and published developed crystal reports to the Central Management Console and crystal Enterprise Environment.
• Worked with Crystal Report for creating complicated reports including sub-reports, parameter based reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports.
• Performed OS/Network Administration tasks.

Technologies: Business Objects XIR2 (CMC, CMS, CCM, Designer, DeskI, Web Intelligence, Info View, Dashboard Manager, QAAWS, Import Wizard), Business Objects 6.5.1(Supervisor, Designer, Reporter, Web Intelligence), Xcelsius 2008, SQL Server 2000, TOAD, SQL, PL/SQL, Windows 2003 Server, Crystal Reports XI, TOAD, PL/SQL, Oracle 9i, Windows NT.