SUMMARY:

• Technical Team Leader experienced in
• Coordinating activities across functional and operational teams
• Providing technical leadership and guidance for geographically diverse teams
• Hands on knowledge and understanding of multiple technologies
• Specializing in Test Data Management (TDM) with a focus on Informatica TDM
• Results Oriented
• Provide Solutions with Value Add for the Enterprise
• Project Management Background
• TDM Solutions Architect
• Team Lead
• PII Data Discovery across Enterprise Application Portfolio
• Architect Data Masking Strategy for highly integrated non - production environments
• Developed Enterprise TDM Roadmap including
• Data Refresh from Production
• Data Subsetting
• Data Masking of PII
• Test Data Generation
• Provisioning multiple environments from Golden Copy
• Technical Sales Support for TDM Practice
• Architect TDM Solutions for Customers
• Prepare and deliver Technical Proposals for Customers
• Provide technical support to Sales Team as needed
• Develop Project Implementation Plans
• Participate in and Lead /Mentor Implementation Team
• TDM Consultant
• Masked 350+ Non-Production DBs to meet Compliance Deadline
• Collaborated with multiple Application Teams to identify data elements for masking in 30+ Applications
• Worked directly with IT Security and Compliance to ensure Policies were consistently followed
• Created Test Data Management Strategy that met the following goals
• Provide current masked production data for multiple Dev and QA DB instances
• Consistent repeatable process with the ability to automate
• Minimize impact to non-production environments resulting in shorter down times and quicker access for Dev and QA teams to refreshed test data
• Subset significantly reduced space consumption (60 TB to 2 TB of test space) while supporting additional test DBs
• Created Data Reset and Update Process for Environments eliminating need for Trainers to find or create new test data for every session
• Coordinated activities across multiple operations teams including Storage, OS, and DBA teams.
• Technical Team Lead Enterprise Data Quality and Data Governance
• Assess current state of data quality providing previously unseen insight to areas of concern
• Using assessment results, worked with Data Stewards to identify specific requirements for ongoing monitoring and quality trending
• Created framework for reporting Data Quality and Data Integrity issues across all enterprise applications.
• Provided to Data Stewards with actionable items to improve Data Quality and Data Integrity resulting in improved application accuracy. IE:
• Identified and quantified actual instances of suspected anomalies created by faulty interfaces that had been suspected as source of ongoing Customer Service issues
• Identified Cost Accounting discrepancies outside acceptable tolerances. This shortened discovery and correction cycles to days from weeks and reduced the number of correction adjustments
• Provided statistical data capture and created Management Dashboards of Data Quality Trending Over Time for multiple organizational levels of Management
• Provided Drilldown to anomaly details providing users with quick focus on actionable items
• Coordinated activities of diverse remote on-shore and off-shore team
• Collaborated with MDM Project team to create definition of Golden Record
• Strong background in Information Technology in many project roles
• Team Lead, Project Manager
• Developer, Data Analyst, Architect
• Systems Analyst and Designer.
• Technical understanding and expertise across multiple
• Languages, Database technologies, and Operating Systems
• Platforms - Client Server, Web, N-tiered and Mainframe
• Functional understanding of business processes in
• Manufacturing, Distribution, ERP
• Medical, Health Care
• Retail, eCommerce
• HR, Finance, GL, AR, AP
• Leading geographically diverse teams, onshore and offshore
• Strengths
• Ability to bridge communications between Business and IT
• Ability to quickly become the Subject Matter Expert for all areas supported.
• Multiple programming languages
• Experience and mentoring developers and end-users.
• Expert troubleshooting skills across multiple technical tiers.
• Broad Technical background
• Project Management background

TECHNICAL SKILLS:

Languages: Informatica TDM ILM, Informatica Workflows, ETL, SQL, PL/SQL, T SQL, Java, Struts, Spring, Hibernate, jQuery, Axis, JSON, JavaScript, CSS, XML, XSLT, HTML, J2EE, Servlets, JSP, Java Beans, EJB, JDBC, PHP, SQL, UML, COBOL

Server Environments: Informatica PowerCenter, Tomcat, Microsoft Reporting Services, BEA WebLogic Server, WLS, WebLogic Portal, WLP, WebSphere Application Server, WAS, JRun, IIS, CICS, IMS/DC

Operating Systems: Linux, Windows (Various), Unix (Solaris), Mainframe MVS

Database: Oracle, SQL Server, DB2, Access, MySQL Informix, IMS DLI, IMS DB, VSAM

Development Tools: Informatica TDM, Informatica Power Center, Informatica Power Exchange, Informatica Data Analyst, SQL Developer, Teradata SQL Assistant, Visual Studio, .Net, SSRS, SSIS, CDC,, WebLogic Workbench, Eclipse, Visual Age for Java, VAJ, JRun Studio, WebSphere Studio Application Developer, WSAD, Crystal Reports, ASP, Visio, Easytrieve, Quickjob, EBCDIC

Other: Data Quality, Data Cleansing, Data Masking, Data Scrubbing, Data Subsetting, Object Oriented Analysis and Design, OOAD, CVS, Model-View-Controller, MVC, Full System Development Life Cycle, FSDLC, SDLC, MS Office Suite, MVS Utilities

PROFESSIONAL EXPERIENCE:

Confidential, Teaneck, NJ

Contractor - TDM Solutions Architect

Responsibilities:

• PII Data Discovery across 150 Applications and 600 non-production databases
• Create and execute Interview process with Application SMEs to validate discovery results
• Identified specific Databases with Customer PII requiring Production TDE Encryption
• Successfully masked all identified customer
• Design custom masking rules where required
• Team Lead for on-site and offshore team members
• Developed Enterprise TDM Strategic Roadmap
• Data Refrsh from Production
• Masking PII Data
• Additional Test Data Generation
• Provisioning multiple environments from Golden Copy

Environment: Informatica TDM, Informatica Power Exchange, MS SQL Server DB, DB2 zOS, VSAM, QSAM, DB2 iOS, Oracle DB, Teradata, Windows, zOS, iOS, SharePoint

Confidential, Naperville, IL

Sr Principal Consultant/Solution Architect

Responsibilities:

• Member of Solution Architect Group
• Specializing in TDM
• Prepare Technical Proposals for Customers
• Support Sales Team in Presenting Proposals
• Participate in Implementation to Lead and Mentor Team Members

Environment: Informatica ILM, Informatica ETL, Oracle DB, MS SQL Server DB, Linux, Windows

Confidential

Responsibilities:

• Evaluate Existing internal Informatica Best Practices Components
• Interviewed Consultants for features repeatedly asked for by clients
• Conducted POC based on findings
• Established Vision for further development
• Created Detailed Project plan to harden framework and produce User Documentation
• Tech Lead and Project Participant for Development Effort

Environment: Informatica ETL, Oracle DB, MS SQL Server DB, Linux, Windows

Confidential, Boca Raton, FL

TDM Consultant

Responsibilities:

• Developed long-term Enterprise Test Data Management Strategy
• Provide Databases for Performance Test, User Acceptance Test, QA Test, Application Development, and other Non-Production Environments as required
• Provide a consistent and repeatable process to support 30+ Applications and 350+ Databases
• In corporate PHI Data Masking at initial Production copy
• Provide Subset DBs from Masked Data to Reduce Non-Prod space consumption
• Automate process to reduce human resources required to execute periodic refresh
• Conduct Knowledge Transfer and

Environment: Informatica ILM, Informatica ETL, Oracle DB, MS SQL Server DB, Active Batch Scheduler, Linux, IBM Flash Copy

Confidential

Responsibilities:

• Create and Execute Informatica Workflows to Mask PHI Data in all Non-Production DBs for new Applications as they migrated from Development to support
• Liaison between Compliance Managers and Application Teams and of required TDM Masking for Compliance
• Develop Consistent Masking Processes for Periodic Refreshes
• Conduct Knowledge Transfer and

Environment: Informatica ILM, Oracle DB, MS SQL Server DB, MS SS Reporting Services, Active Batch Scheduler, Linux

Confidential

Responsibilities:

• Design and develop automated daily process to reset Environment
• Update All Application Critical Dates to current Date or equivalent offset
• Remove all updates from previous sessions
• Provide ability of mid-day reset on request
• Coordination with Lead Trainer to identify data scenarios required for Sessions.
• Generated or modified existing data to satisfy scenarios
• Conduct Knowledge Transfer and

Environment: Informatica ILM, Informatica ETL, Oracle DB, MS SQL Server DB, Active Batch Scheduler, Windows

Confidential, Boise ID

Consultant

Responsibilities:

• Create and Execute Informatica Workflows to Mask PHI Data in all Non-Production DBs
• Identify Performance Issues and work with Application Teams and DBAs to tune performance
• Create additional masking rules as needed
• Develop Consistent Masking Processes for Periodic Refreshes
• Provide and Knowledge Transfer

Environment: Informatica ILM, Informatica ETL, Oracle DB, MS SQL Server DB, MS SS Reporting Services, Active Batch Scheduler, Linux

Confidential

Responsibilities:

• Design, build and implement web application enhancements to allow end-user to select criteria and generate ad hoc queries and display results back to user

Environment: MS SQL Server, Java, Spring, Hibernate, .Net, Web services, Windows

Confidential, Boise ID

Senior Software Engineer

Responsibilities:

• Tech Lead coordinating activities of technical team in multiple remote on-shore and off-shore locations
• Design, build and implement a framework for monitoring and reporting Data Quality and Data Integrity anomalies across multiple enterprise applications
• Framework included extracting data from multiple enterprise level applications and technologies to a common database
• Periodic production of detailed reports of data anomalies
• Periodic production of graphical representation of specific problem areas with drilldown to detail:
• Periodic production of multiple Dashboards by Subject Area for different levels of Management indicating current conditions and up to 13 weeks of data quality trending.
• Ongoing process to conduct Data Assessments
• Use Data Assessment to refine requirements for Data Monitor to in corporate into above framework.
• Regularly juggle priority changes associated with complex environment and assignments
• Lead teams across multiple IT disciplines to troubleshoot and resolve production issues.
• Coordinated activities across multiple IT disciplines to determine requirements, develop, and implement requested enhancements
• Created standard and repeatable deployment processes across all applications supported.

Environment: Informatica DQ, Informatica ETL, Oracle DB, MS SS DB, MS SS Reporting Services, ESP Scheduler, MS Excel, SQL Server, DB2, Teradata, Solaris, Windows

Confidential

Responsibilities:

• Successfully coordinated activities across multiple support teams to transition support from one outsourced vendor to another
• Regularly juggle priority changes associated with complex environment and assignments
• Lead teams across multiple IT disciplines to troubleshoot and resolve production issues.
• Coordinated activities across multiple IT disciplines to determine requirements, develop, and implement requested enhancements
• Coordinated activities of team members onsite, remote, and offshore.
• Created standard and repeatable deployment processes across all applications supported.
• Created standard and repeatable source code management strategies to support a frequent enhancement deployment cycle.
• Research and fix reported bugs.

Environment: Java, J2EE, BEA WebLogic Server, WLS, BEA WebLogic Portal, WLP, BEA WebLogic Integration, WLI, Linux, Sun Solaris, Oracle SQL Server, LDAP, Microsoft.Net Windows IIS

Confidential, Meridian ID

Consultant

Responsibilities:

• Research and develop requested enhancements.
• Research and fix reported bugs.

Environment: PHP, HTML, JavaScript, SQL Server

Confidential, Idaho Falls, Idaho

Consultant

Responsibilities:

• Developed requirements, obtained approval designed and coded enhancement.
• Project delivered on time and within budget.

Environment: PHP, HTML, JavaScript SEARS

Confidential, Boise, Idaho

Technical Consultant / Senior Technical Consultant

Responsibilities:

• Took the lead to coordinate activity of IT volunteers including PM, Analysts, and Developers.
• Obtained management buy-in to use this project to further develop Object Oriented Analysis and Design (OOAD) System Development Life Cycle Methodology utilizing UML and the Rational Unified Process (RUP).
• Obtained management buy-in to use this project to provide Java experience to developers that had but not yet been assigned to a Java project.
• Coordinated efforts across several departments to identify available hardware, identify available application sever and database instances, obtain buy-in and approval from Enterprise Architecture Services, and Application Operations.
• Lead Designer for rewrite and added features and functions including:
• Additional columns and tables in database.
• Security framework to group users and grant access according to function and to restrict access by some groups at the row level.
• Date driven cut-off mechanism to restrict data entry by security group.
• Dynamic menu content based on security access permissions.
• Ability to enter, allocate and track coat quantities by size.
• Visual scheme to restrict allocations to predefined quantities.
• Ability to quickly rebalance volunteer workloads at distribution sites.
• Mechanized campaign reset function to reinitialize database annually.
• Additional features and functionality significantly reduced the manual processes required to support the annual campaign.

Environment: Java, J2EE, Servlets, JSP, Java Beans, JDBC, SQL, HTML, JavaScript, XML, XSLT, Struts, UML, Visio, VAJ 4.0, WAS 3.5, Windows 2000, Solaris, Informix

Confidential

Responsibilities:

• Significantly reduced the redundancy of project control information entered into these four systems.
• Reduced time spent entering Weekly Status Reports for 100+ PMs.
• Provided Senior Management a consistent view of project information across all IT Departments.
• Provided Senior Management better control over unapproved project work.
• Significantly reduced the time and effort to produce monthly detail and summary reports containing information from all four of the prior systems distributed to Senior IT and Business Managers
• Project delivered ahead of schedule and under budget.
• Led analysis and design sessions.
• Designed and developed Project Status Control and Weekly Status Report Entry Pages
• Designed and developed all Project Summary Reports

Environment: Java, J2EE, Servlets, JSP, Java Beans, JDBC, SQL, HTML, JavaScript, VAJ 4.0, WAS 3.5, Crystal Reports, ASP, Visio, Windows 2000, Solaris, Informix

Confidential

Responsibilities:

• Extended monthly planning window from mid-month right up to last day of the month.
• Eliminated monthly distribution and postage expense.
• Eliminated distribution and overnight charges for frequent last minute changes.
• Provided easy access to completion statistics for government mandated compliance action items.
• Annual savings estimated at $100,000 - $150,000 in distribution expense plus minimized risk for non-compliance penalties.
• Integrated with other enterprise systems to eliminate redundant administrative functions.
• Project delivered on time and on budget.
• Actively participated in application and database design.
• Developed weekly extract of MVS DB2 information of Store, District, Region
• Developed weekly Informix reload of Store, District, Region
• Developed all reports

Environment: Java, J2EE, Servlets, JSP, Java Beans, JDBC, SQL, HTML, JavaScript, UML, JRun Studio, Visio, JRun, Windows 2000, Solaris, MVS, Informix, DB2

Confidential

Responsibilities:

• Provided enterprise-wide access to available software components to help reduce development effort and standardize common functionality.
• Integrated with corporate database metadata repository
• Project delivered ahead of schedule and on budget.
• Actively participated in application and database design.
• Developed all of the JSPs

Environment: Java, J2EE, Servlets, JSP, Java Beans, SQL, HTML, JavaScript, VAJ 3.5.3, WAS 3.5, Windows 2000, Solaris, Informix

Confidential

Responsibilities:

• Provided IT managers the ability to post job descriptions and enter desired skills.
• Provided IT associates the ability to search for open positions based on their skills.
• Project delivered on time and on budget.
• Developed all of the Job Posting maintenance and query components

Environment: Java, Servlets, JSP, SQL, HTML, JavaScript, Kawa, JRun, Windows 2000, Solaris, and Informix

Confidential

Responsibilities:

• Developed several templates to be used by technical team to standardize similar functions.
• Conducted all technical reviews and QA testing.
• Developed and conducted for end-user community for Quickjob basics and standard templates
• Templates and very well received and provided sound base of knowledge for the team to move forward with Quickjob.
• Project completed ahead of schedule and under budget.

Environment: MVS, JCL, Utilities

Confidential

Responsibilities:

• Gathered requirements; Identified candidate software and conducted evaluations.
• Presented findings and made recommendations; Coordinated installation of selected software.
• Provided minimal post implementation support to answer questions and provide basic product overview as requested.

Environment: Windows 2000, MVS, Solaris

Confidential

Responsibilities:

• Developed conversion process model used to convert all data.
• Developed mainframe and server scripts to mechanize multiple iterations of data conversion
• Created migration strategy for phased implementation.
• Coordinated efforts of analysts performing functional data mapping.

Confidential, Estates, Illinois

Project Manager / Senior Project Manger

Responsibilities:

• Acknowledged Subject Matter Expert (SME) for all aspects of the technical and functional areas of the application.
• Project Manger for many large- and small-scale projects including enhancements, maintenance, break-fix, and upgrade conversions.
• Resource Manager for project team that ranged from 8 - 15 analysts and developers.
• Developed and managed a departmental budget that ran $2.5 - $3.5 million.

Environment: MVS, COBOL, CICS, IMS, VSAM