PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Manager

Responsibilities:

• Installation validation
• Analysis of current use and configurations
• Converting current definitions and maps
• Recommendations on the use of our home grown interfaces
• Applying “best practices for Conversion
• Product optimization Performance and tuning Mentoring
• Conversions of all scripts for TDM and Data Privacy
• Applying new features and enhancements to current and future projects

Confidential

Tulsa Oklahoma

Responsibilities:

• Primary role of Implementation of OPTIM Data Discovery, Test Data Management, Data masking, Data Obfuscation and Data Sub - Setting while laying the foundation for the new TDM Department for the Bank.
• Evaluation and implementation of tools needed for data discovery, data masking, data storage, data protection, data deployment.
• Gathering data requirements from the different groups for the IBM Transition project and implementation of the OPTIM Tool.
• Provide Data Architect expertise in creation of QA Test Data Architecture and Data Models.
• Working with the business users, architects, Developers and QA to understand the data flow and the data needs of the projects in scope.
• Providing consultancy and support to IT management teams instituting Data Governance within BOKF
• Identifies data masking requirements by analyzing applications/data sources, interviewing appropriate resources.
• Setup best practices, procedures and process for data obfuscation across the customer organization.
• Propose architecture solution based on the requirements.
• Translate requirements into solution architecture and design specifications
• Building framework for data sub setting / data masking.
• Design and implementing the strategies to mask the sensitive data

Confidential . Sarasota FL

SR. Enterprise Data/Solutions Architect / DBA

Responsibilities:

• Defining, Implementing and administering the MDM processes for
• source identification, data collection, rule administration, error detection and correction, data consolidation, data distribution, data classification, taxonomy services, item master creation, schema mapping, product codification, data enrichment, data consolidation
• Data modeling, normalization, data storage, database object creation in the MDM database
• Database object creation in current system RDBMS
• Collaboration on MDM standards and policies
• Data governance policies and implementation
• Provide analysis and research on Optim Suite of TDM tools
• Identifying and implementing Data stewardship/owners
• Data profiling Management of all MDM Data Models
• Project Management of multiple sub projects and making presentations to Business and Technical Managers
• Coordination with Business managers, analyst and BI Teams

Confidential

Sr. Enterprise Data Architecture

Responsibilities:

• Defining, Implementing and administering the Enterprise-wide data architecture processes for
• new and legacy source identification, rule administration, data consolidation, data classification, schema mapping
• New product codification and data discovery
• Managed the DA road maps for clients and the Nielsen Corp.
• Member of Enterprise Architecture Review Team
• Served on Information Architecture board for Pepsico's various businesses data integration reviews
• Create MDM Road Maps
• Working hand in hand with Business analyst
• Manage team of Data architects and development DBAs
• Data modeling, normalization
• Database object creation in current system RDBMS
• Collaboration on DA standards and policies
• Data governance policies and implementation
• Profiling of discovered legacy data that meets new business requirements
• Management of all New projects Data Models

Confidential, Venice FL

SR. Lead Data Architect / DBA

Responsibilities:

• Defining, Implementing and administering the Enterprise-wide data architecture processes
• Working Economist, Financial and Business analyst
• Team lead for architects and SQL Database administration
• Create the enterprise data model
• Defined the data access layer and data architecture road map.
• Database object creation in current system RDBMS
• Introduce DA standards and policies
• Data governance policies and implementation
• Profiling of discovered legacy data that meets new business requirements
• Production DB support
• TDM/Optim Consultant

Confidential, Memphis TN

Principal Data Architect / Oracle DBA / Sybase / TDM Consultant

Responsibilities:

• Consultation on the benefits of implementing the OPTIM Tool.
• Database Design of MS SQL Server 2008
• Data Architect expertise in creation of QA Test Data Architecture and Data Models.
• Evaluation and implementation of tools needed for data creation, data mining, data storage, data protection, data deployment
• Gathering data requirements from the different groups for the IBM Transition project and implementation of the OPTIM Tool.
• Provide Data Architect expertise in creation of QA Test Data Architecture and Data Models.
• Working with the business users, architects, Developers and QA to understand the data flow and the data needs of the projects in scope.
• Providing support to QA and development teams during the duration of the SDLC for the projects to make sure that data requests are met satisfactory, completely and on a timely fashion.
• Working with all areas in IT and with the Business to understand the business relations from a data perspective, to implement tactical and strategic solution for data creation, mining, deployment to different environments.
• Maintain and govern gold copies and databases that store test data to be re-used in multiple test cycles.
• Evaluate ETL tools, IBM and Oracle ODI/CDC.
• Providing DBA and Optim admin support and development for BCBSMA. This includes Development, Testing and Model Office environments for Windows, OS390, OS400, ZOS, UNIX and Linux.
• Primary role of Implementation of OPTIM Test Data Management, Data masking and Data Obfuscation modules and Attunity for on databases in Oracle 10g, SQL Server 2008, UDB/DB2 v9.7.

Confidential, Princeton NJ

SR. DBA / OPTIM Consultant

Responsibilities:

• Provided DBA support and development for BMS retirement and archiving data of legacy systems. This includes Development, Testing and Production environments for Windows, OS390, OS400, ZOS, UNIX and Linux.
• Primary role of Implementation of OPTIM Data masking and archiving modules and Attunity for archiving of databases in Oracle 9i 10g, SQL Server 2005 and 2008, VSAM and UDB/DB2 v9.7 AIX and DB2400.
• Provided development and DBA support in SSRS, Crystal Reports, SQL statement tuning, indexing, to enhance development of retrieval and reporting of archived data during retention life cycles.
• Provided Enterprise DBA support for development Quality assurance, Testing and Production of the firms DB2/UDB LUW multiple environments.
• Primary role on Implementation of OPTIM for proof of concept of Test Data Management and Data masking in multiple environments.
• Responsible for evaluation of new features and performance for disaster recovery, HADR testing. The RDBMS was DB2/UDB V9.7, AIX V5.3, 6.1, HACMP, Linux and Windows 2003.
• Responsible for providing performance & tuning, disaster recovery, integration testing. The RDBMS was DB2/UDB V9.1, and V9.5 on AIX V5.3 HACMP, Linux Red hat and Windows 2003
• Utilized a variety of DBA productivity tools including IBM DBA suite, Sybase Power Designer and Quest’s TOAD.
• Initiated capacity planning and data security measures while allowing for high availability of databases in all environments.
• Provided DBA assistance in SQL statement tuning, indexing, and partitioning to improve application performance. Performed database patching, upgrades and migrations.
• Implemented and maintained Production 24/7 with business partner IBM Global Services.
• Provided DBA support for development and production of the firms SQL Server 2000 and 2005 environments. This included moving all servers from California to a new hosting company in Virginia.
• Services included using 3rd party DBA Productivity tools form Quest and Embarcadero for Data modeling, database optimization, and implementation of schema s.
• Monitoring of systems for optimum performance, capacity constraints and security measures and availability.
• Provided assistance in SQL statement tuning, DTS Packages, ETL, indexing, and partitioning to improve application performance.
• Performed database patching, upgrades and migrations. Implemented and maintained backup and recovery procedures.
• Installed maintained refreshes for development, QA, and test environments.

Confidential, CA

Sr. Lead DBA / Data Architect

Responsibilities:

• For over 40 major clients, provided Performance & Tuning, Development, Integration, Testing and Production Database Administration support for DB2e, DWE V9.1, DB2/ zOS v8.2, DB2/UDB V8.2, and V9.1 on AIX V5.2 & V5.3 HACMP, Windows 2000, 2003 and Windows XP, Vista using Quest Central and TOAD. SQL Server 2000, 2005 and Oracle 9i and 10g all DBA support services include DB2v8.2 to Oracle9i and 10g conversions.
• Provided DBA support for HADR setup for Disaster Recovery testing and implementation.
• New business and existing production applications for new IBM CNG (Commercial Non Global) over 40 accounts. Migration of Oracle9i and Sybase ASE12.5 to UDB/DB2 8.2 for Siebel. This includes DW, OLTP and OLAP databases and data warehouses projects, Migrations using ETL and Informatica
• New installs for multiple servers AIX, Linux, Windows, Instances and database construction. Used AIX K-Shell and Unix C-Shell for database scripts for monitoring and performance.
• Also provide DBA Steady State support for internal and external accounts on Siebel 7.5, 7.7 & 7.8 (all Siebel applications). People Soft Financial s v8.9. Provide DBA support on new RFS (Request for Service) work for New Accounts and installation of SQL Server 2005, Oracle 10g and UDB/DB2 V8.2 and V9.1 on AIX and Linux servers with application and data migration from legacy systems. This includes database Performance Tuning, monitoring production support.
• Provided development, integration, testing and Production Database Administration support for Siebel DB2/UDB V7.2, V8.1 & V8.2 on AIX V5.1 & V5.2 HACMP, Windows 2000, 2003 and Windows XP using Quest Central for DB2/UDB and Oracle 9i
• Provided backup DBA support for DB2 v7.1 ZOS People Soft v7 and 8 Financial s and HR.
• Point of contact for consultation services for MS SQL Server 2000 Database Administration support for Development and Test environments and Cog nos development DBA support.
• People Soft Financial s DB2v7.2 to Oracle 9i.
• All support services encompassed new development applications and existing production applications for Siebel 7.0, 7.5.3 & 7.7 (all in house applications).
• Provided Data analysis and architecture support for Large Data warehouse and spin-off Data marts ETL and DTS Packages, Migration of SQL Server 2000 DB to UDB/DB2 8.1 Operational data stores (ODS) design to support BCBS Siebel customers continuing needs. This also includes logical and physical data modeling using ERWIN4.0. I also provide support for BI reporting tools and Backup/Recovery and creating the Disaster Recovery Plan.
• Team lead for Siebel Upgrades across all applications to AIX 5.2, WIN2K3, Siebel 7.7 and DB2/UDB v8.2 (Stinger) all 64 bit.
• Performed Lead Project DBA tasks on developing ODS reporting database for Siebel using UDB/DB2v8.2 Q Replicator.

Confidential

Sr. Lead DBA / Data Architect

Responsibilities:

• Provided Production Database Administration support for DB2/UDB V7.2 & V8.1 on AIX V5.2, Windows 2000 and Windows XP using Quest Central for DB2/UDB.
• Consultation services for Sybase 12.5 and MS SQL Server 2000 Database Administration support for Development and Test environments.
• All support services encompasses new development applications and existing production applications including Siebel 7.0 and 7.5 CDP, Insight, People Soft Financial s and HR, Hyperion Essbase v6.2, Loan Liner, Claims, Pensions.
• Provided consultation services on Data Architecture and Business Intelligence issues and daily DBA monitoring tasks, activities and Event monitoring automation.
• Provided Information/Data modeling and Database Administration services to Drake Hospital on a total revamp of all patient care information systems.
• This included creating Entity Relationship Diagrams, Logical and Physical Data models, Database and data warehouse design, Capacity Planning, writing Disaster Recovery Plans, creating database objects, and providing DBA services in CACHE’ Object /Relational Database, Oracle 8i and 9i and DBA support for MS SQL Server 2000 and AS/400.
• Performing all database related duties including system administration for AIX and Linux. The system environment is ERWIN 4.01, Win 2K, AIX 5.2, Linux, Java, Visual Studio, Power Builder and AS400. Providing systems support for Eclipses Vendor Health care Applications, SCM XA, SRM, E-Web it and SDSM. Misys Health Care and Health Information Management (HIM) systems including Misys Lab and Pharmacy.
• Provided Data Architect, Data modeling, Database Administration and Database development services to U.S Bank on an Image Delivery Project.
• This included creating Entity Relationship Diagrams, Logical and Physical Data models, Database Design, Capacity Planning, writing Disaster Recovery Plans, creating database objects, writing development and BI solutions in Java, ASP, Cog nos, BRIO and Visual Studio and providing DBA services in DB2/UDB v8.1, 7.2 and DBA support for MS SQL Server 2000.
• Provided all database related duties including recommendations input into Enterprise System Architecture plans, on hardware, operating systems and RDBMS software procurement.

Environment was ERWIN 4.01, Win 2000, AIX 5.2, Java, Visual Studio, Perl, ASP, TIBCO, Web sphere and rational development environment.

Confidential, OR

Sr. Lead DBA / Data Architect Consultant

Responsibilities:

• For our clients, provided systems analysis, Logical Data Modeling, Database design and Database Administration for MS SQL Server 2000, DB2/UDB v7.1 and Oracle9i v9.2.0.1.
• Migrated and converted DB2/UDB/NT data and databases to Oracle 9i for New Immunization and Biological Threat systems.
• Provided management and consulting expertise to the Data Management/Architecture Group.
• Acted as the exclusive Oracle9i System and Database Administration support on NT 2000 and AIX 5.1 platforms.
• This included Apache Web server, ASP support and a myriad of other task covering all faucets of system and database support activities on People Soft on DB2/UDBv7.1.
• Previous assignments included providing our clients with database and system administration support for Microsoft SQL Server V6.5, V7.0 & 2000, Sybase ASE v11.5 & 12, Oracle V7.3.4, V8.0.6 & V8.1.6, V9i, DB2/UDB/AIX NT V7.1, and
• DB2/OS390 V6. I was responsible for SAP production support, middle ware support using Web Sphere, BMC DBA Suite, and system installs and implementation for Plant Operations, Supply Chain systems databases for JAVA/J2EE WEB based
• Systems for customers & Dealers, to Parts & CRM systems for Owner/Operators. I provided key logical and physical data modeling, database design, Stored Procedure, PL/SQL, T-SQL and ANSI SQL troubleshooting, and database creation, and DTS Packages for new development projects on MS SQL Server 2000. I was also supporting current versions and upgrades to Oracle based ADP Horizon applications for Human Resources Training and Payroll. Using AIX 4.3.3 and PL/SQL for Oracle and NT 4.0 and T-SQL for SQL Server. I served as systems support consultant for BMC Patrol and Change Manager DBA Suite for MS SQL server and on-call support for all Freight liner Plants SQL Servers worldwide.

Confidential St. Louis, MO

Sr. Lead Project DBA / Data Architect

Responsibilities:

• Provided Project leadership for database and systems support for Sybase v11.5, Microsoft SQL Server V7.0, DB2 OS/390 V6, Oracle RBDMS V8.1.6 and Oracle MVS/OS/390 Client new development projects.
• Team was also responsible for data modeling, database design, Package creation, PL/SQL, T-SQL and ANSI SQL troubleshooting, database creation, development and production support on Mainframe DB2 including Sysadmin for sub-system setting up z-parms, installs, recovery.
• Also performed system installs and implementation for a myriad of systems from JAVA WEB based online account access systems for customers.
• Migrated legacy DB2v6 to Oracle 8 and 8i databases.
• Provided DBA support for People Soft and chaired the Data Architecture Design Review Team and also designed databases for Bill payment and e-mail Surveillance systems for broker to customer communication. Using Solaris 2.6 for Oracle and NT 4.0 for SQL Server.

Confidential, Miami FL

Sr. Principal Technical Consultant

Responsibilities:

• Provided Data modeling, Data analysis, and support for a new Warehouse Management development project.
• This also included providing Database and System Admin support for DB2 V6.1 for VSE & VM. This was a CICS, VSE & VM, and Windows NT development environment.
• Provided technical consultation on capacity planning, Backup and Recovery, Performance and Tuning.
• Provided technical consultation on Oracle RDBM 8.0, DB2 UDB V.6.EE and installed Oracle & Sybase RDBMS, software on the NT 4.0 and 95 platforms. Also acquired and setup outside DBA tools.
• Performed initial database analysis, design and implementation for a JAVA WEB based Artist sales tracking system.
• Provided Production Sybase, Microsoft SQL Server V6.5, and Oracle V7.3 to Sybase V11.5 ASE conversion DBADM/SYSADM support for the corporate acquisition of RISCORP INS Co.
• Tasks consisted of upgrading all servers to the latest Y2K complaint releases, conversion of databases, performance enhancements and tuning of all servers, database design and construction, SYBASE V11.5 ASE Replication, backup and disaster recovery implementation.
• Designed and developed an automated system for SYBASE maintenance tasks.
• Provided Production and Development DBADM/SYSADM support for DB2 on the mainframe. This included Database design, Performance and tuning, and Disaster Recovery.
• Provided similar support for their Data Warehouse effort using DB2/2, Oracle on the Solaris server. Systems supported were OS/390, CICS 4.0, Oracle V7.3, DB2 V4.0, DB2/2 V2.2.1, and Solaris V2.5. I was responsible for full 24hr 7 days a week support for all DB2 mainframe systems.

Confidential, Miami FL

Sr. Project Consultant

Responsibilities:

• Responsible for converting the Visual Age Smalltalk Object Model for the New Underwriters Workstation project into a Logical Business Model, a Relational Model and a Relational Database. The goal was to have 100% persistence of all the Smalltalk objects. This was a Visual Age (Smalltalk), OS/2 Warp, and TOP Link development environment.
• Using Visual Age, BACHMAN Groundwork’s, ERWIN and DB2/2 2.1 to accomplish said tasks. This was a 3 tier Client Server system; which we installed in the Latin America Zone country of Brazil. Provided Data modeling, Data analysis, System and Database Administration support for a new Riscorp Insurance Operations (RIO) development project and all existing Sybase databases and Sybase Replication Servers. This was a Power builder, UNIX (Solaris), and Windows 95 and NT Development environment.
• Provided production support for existing SYBASE systems, which included capacity planning, Backup and Recovery, Performance and Tuning.
• Provided Data modeling, Data analysis and SAP and Oracle 7.3 Database Administration support for a new SAP Custom development project.
• Principal developer for creating SAP/DBA utilities using the APAB4 development language, Oracle PL/SQL and writing the Data conversion, using Sap’s built-in processes to convert legacy systems to the new SAP systems.
• Manager Responsible for Data modeling, Data analysis and DB2 V4 Mainframe support, Sybase Database Administration support team for a large new Client Server development project.
• Principal designer/developer along with managing the project DBAs, Data Architects and legacy system data conversion project efforts to the new systems. Used Power builder, Sybase V10, DB2 V4 and Solaris V2.3.
• Designed and built a major two way interface to the Mainframe for data concurrency and developed a DB2, MDI Gateway, Power builder and a CICS/ADW piece for the Mainframe.