SUMMARY:

Seeking a career opportunity conducive to personal and professional growth.

TECHNICAL SKILLS:

Operating Systems: Windows 3.x,95,98,2000,,Vista,Windows 8, NT 4.0 Server; MAC; Digital Unix; Sun Solaris, Linux, zOS, Familiar with Unix, MS DOS and all Windows operating systems. Worked extensively troubleshooting operating system, networking and dial up connectivity issues for users of these platforms. Familiar with the installation and configuration of network peripherals.

Software Applications: In depth knowledge of MS Office Suite, PCAnywhere, SecureCRT, and TOAD. Working knowledge of web authoring and graphic design applications such as Front Page, Photoshop and Dreamweaver. Intermediate knowledge of call tracking applications such as McAffee, Remedy, Tivoli and Heat. Familiar with Peoplesoft financial module. IBM Optim LUW & zOS, Informatica ILM TDM, CA Test Data Maker.

Hardware Skills: Experienced in installation, configuration, and troubleshooting of various hardware components. This includes printers, modems, disk drives, satellite multicasting, sat dish configurations, spectrum analyzers, MRTG, Viacast satellite receivers, Unix/NT servers, Hughes VSAT satellite gear, VOD systems, and other components. Knowledgeable on laptops, desktops, POS systems.

Database Systems: Intermediate knowledge of Oracle 8 - 9i, 10-11g; DB2 database systems. Familiar with Oracle architecture, administration, backup and recovery, performance tuning, network administration as well as PL/SQL packages, stored procedures and triggers. Currently studying for Oracle OCP DBA certification track. Intermediate knowledge of Microsoft Access. Working knowledge of Microsoft SQL Server, DTS Packages; Integration, Reporting and Analysis Services.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, Ga

Software Engineer/Optim Technical Consultant

• Reviewed and analyzed 600 DB2/IMS tables for personal identifiable information.
• Gathered requirements, designed, developed, tested, implemented ETL/Data Masking processes for DB2 zOS using IBM Optim ver 7.1.
• Loaded 600 million rows after data transformation to target DB2 subsystems.
• Performed numerous Enterprise Level Test Domain assessments for large Fortune 500 companies.

Confidential, Atlanta, Ga.

Optim Test Data Management Lead

• Installed/ Configued InfoSphere Discovery 4.5.1 on client’s application server
• Executed column analysis/PF Key discovery across multiple schemas for database table relationship, data types discovery
• Compared two test environments to production for environmental discrepancies and reconciliation.
• Developed automated processes on Optim 7.1 for zOS to refresh store fiscal data across environments
• Developed IBM Group/ Batch policies for ensuring Optim application security.
• Developed Enterprise sub setting and Refresh Strategies.

Confidential, Atlanta, Ga

Optim Technical Consultant

• Installed Optim 9.1 Data Privacy Solution, configured workstation/server in clients development environment.
• Leveraged BTRG’s custom Data Manufacturing application to accelerate requirement gathering and development cycles.
• Reviewed 3200 Oracle EBS tables for personal identifiable information.
• Succesfully masked Oracle EBS Application with automated masking solution utilizing Bat scripts and Optim pr0command.
• Reviewed Macys Optim 7.1.2 Data Growth Solution environment, made suggestions on improving archive and Native Application Restore
• performance and security.

Confidential, Hartford, CT

QA Analyst/Optim Technical Consultant

• Responsible for managing communication between nine offshore consultants and coordinating masking activitieswhile interacting with enterprise subject matter experts (SME) to discover technical requirements to implement masking solution.
• Analyzed databases with inadequate domain boundaries to identify correct application table inventory.
• Due to nonexistence of backend referential integrity, worked with application developers to analyze code and DB2 catalog index details to discover database relationships.
• Explicitly defined Optim relationships to maintain data integrity while extracting subsetted production data.
• Built internal Optim object components such as legacy tables access definitions, table/column maps, extract files, convert files, control files required for data masking batch jobs.
• Utilized extended data functionality to mask/load batch flat files containing production data.
• Successfully implemented enterprise masking solution of 50+ applications using IBM Optim Test Data Management module.
• Successfully implemented program level ICD 10 masking solution for provider collaboration to mask inbound 837 claims after EDI conversion via batch processing for Virtual Test Environment end to end testing.
• Successfully implemented program level unmasking solution to unmask outbound 837 claims, 277CA transactions, ERA files for provider collaboration testing.
• Meet with application developers, information architects and other SME to gather key application, domain
• knowledge and business logic in order to design masking solution that maintained referentially intact data and application integrity.
• Analyze application logical data model and mine physical model table level attributes via enterprise level repository.
• Build IBM Optim access definitions and relational objects on zOs after analyzing logical and physical models to
• determine entities that were actually implemented in Development and QA environment.
• Build Optim convert requests to mask clone production tables using hash/key look up and provide load ready files and punch cards for subsequent load of DB2 tables in production Gold Copy and Virtual Test Environment.
• Design and build DB2 start tables which houses key identifiers for subsetting production extracts.
• Performance Tune Extract/Convert processes for optimum performance and CPU utilization by utilizing key
• lookups or table scan depending on performance evaluation.
• Design, build, execute incremental load of production claims into Virtual Test Environment.
• Troubleshoot batch job abends when execution fails.
• Document all data masking processes and internal Optim components on IBM Rational Clear Case and team SharePoint.
• Analyzed application APIs to determine source of integrated data across multiple applications and domains.
• Created automated processes via Zeke scheduling, JCL and Optim ETL processing to sanitize production data.
• Create/execute test cases to validate that outputs maintain referential integrity and log defects.
• Maintain source code version control in Endevor.

Confidential, Atlanta, Ga.

Database Infrastrucure Consultant-Optim

• Manage Optim Installations and customizations remotely and at client sites.
• Archive client production data in Oracle, SQL Server, Informix, UDB/DB2 and Sybase environments.
• Initiate and execute offline data archive for client application decommissioning projects.
• Import mainframe copy book flat file data into Optim for Data Archive.
• Install Optim Test Data source data in client development environment for application testing.
• Enforce client’s business level Data Privacy requirements by encrypting production data via IBM Optim Infosphere Module.
• Analysis, Estimation, Design, Development, Testing, Implementation of data masking solutions.
• Developed shell scripts to analyze the database and identify table level column mappings
• Monitoring Optim, archive extracts and load jobs.

Confidential, Charlotte, NC

SQL Developer

• Project managed reverse auction internet market site from concept to creation.
• Developed integrated MySql backend custom solution for live service/product bidding.
• Transitioned website from development to live production server for quality assurance testing.

Confidential, Atlanta, Ga

Jr. Database Administrator

• Primarily responsible for all backend database development in Oracle 9i.
• Developed PL/SQL stored procedures according to application design specifications.
• Responsible for creating and administrating development instance.
• Lead SQL developer for City Mobile Project.

Confidential, Sandy Springs, Ga

DSS Jr. Database Administrator

• Responsible for the administration of multiple development and production instances of Oracle 8i.
• Responsible for all user schema administration.
• Lead for all backend development.
• Developed pl/sql stored procedures and triggers.
• Wrote technical specifications and production scripts for SQL/PL/SQL development of DSS applications accessing
• Data Warehouse.
• Tested SQL scripts in development instance before live production.
• Supported Extraction, Transformation and Loading of data with tools such as SQL Plus, TOAD and SQL*Loader.
• Administered and enforced user security policies.

Confidential, Alpharetta, Ga

AdFlash System Analyst

• Responsible for the Distribution of commercial advertisement spots in the format of mpeg and dvl files to remote
• headend sites via TVRO and VSAT satellite feed.
• Provisioned 400 new headends, supervised remote hardware installs, administrated and configured servers remotely via PCAnywhere for network communication between NT Receive Servers and Sun Solaris Severs on local LAN.
• Manually inserted spots in Oracle and SQL Server database via FTP when automation delivery failed.
• Developed shell scripts.
• Required to troubleshoot NT/Unix server issues, ftp files, run batch files, and resend missing files on Seachange and
• nCube Inserters (Unix digital Alpha servers.).

Confidential, Atlanta, Ga

Certified Help Desk Professional

• Provided 3rd tier technical client/server support of proprietary software, Windows 95, 98, 2000,NT; Mainframe and other supported operating systems.
• Provided 1st tier technical support of Peoplesoft Financial Module; worked with consultants to determine the
• appropriate technical solution to client requests for change in General Ledger, Purchasing, Accounts Payable,
• Accounts Receivable, Billing, Asset Management and Projects modules; Maintained existing, develop new or
• modified records and tables; logged inbound calls and escalated to functional leads when call could not be resolved.
• Provided technical support of internet browser, internet mail, web publishing, POS, and FTP applications.
• Created/troubleshoot new user accounts on Exchange Server; troubleshoot network and intranet connectivity via LAN/WAN.
• Assisted users with creating and troubleshooting Excel Spreadsheets, Access databases and forms, word documents and Power Point Presentations.
• Logged 50+ inbound calls daily
• Resolved all trouble tickets with an average first call resolution of 90%.