SUMMARY:

Detail - focused Globally Integrated Data Architect with proven experience designing and deploying cutting-edge migration and data analytics solutions. Served as Administrator for systems, database and architecture in enterprise-level environments. Adept in working across business lines to deliver complex installation, migration and conversion projects on time and within assigned requirements and committed to providing exceptional post-implementation support.

EXPERTISE AREA:

• Database Architect/Engineer
• Database Administration
• Business Intelligence
• ETL
• SQL Development
• Data Governance (Collibra)
• Data Migration/Transformation
• Oracle, SQL Server, DB2, Postgres, Informix, MySql
• SQL, PL/SQL, T-SQL, PSQL, VB, C#, Python, Perl, Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

Responsibilities:

• Designed architecture for Development, Test, Staging and Production database environments for newly adopted enterprise application
• Designed backend data solution for newly implemented consumer web portal
• Worked closely with executive stakeholders, enterprise architects, data architects and data governance to define technical requirements for bringing bank in compliance with CCPA regulation
• Led data discovery effort to identify and map all enterprise data sources containing data which would fall under the purview of the CCPA regulation.
• Developed and enacted strategies for go-live testing and deployment.

Confidential

Enterprise Solutions Architect

Responsibilities:

• Supported multiple projects concurrently by defining and implementing consolidation and migration solutions.
• Developed enterprise-level technology frameworks and strategic architectures and participated in quality reviews.
• Managed software development life cycle of a suite of IBM tools for system data discovery, analysis and automation, optimizing migration planning and implementation.
• Partnered with IBM Research to advance Analytics for Logical Dependency Mapping software and visualization toolsets.
• Led multiple projects to design, develop and support internal finance and resource bidding tools, such as cost use case tables, migration techniques used in server migrations and reporting, including transformation costs summary, hours breakout, resource distribution and project plan hours reports.
• Developed Financial Database toolset enhancing tracking of project expense planning.
• Automated resource utilization reports for project bidding tool.

Global Solutions Architect

Confidential

Responsibilities:

• Led design and development of System Consolidation Object Processing (SCOPE) tool and designed several key features and methodologies.
• Created server sizing algorithms for determining best fit target strategies based on utilization histories and server capacity metrics.
• Designed and developed automated affinity dependency reports and wave planning toolset.

Global Solutions Architect

Confidential

Responsibilities:

• Led development of tool to facilitate server virtualization and data center migration projects.
• Utilized PL/SQL, Perl and Microsoft Visual Basic.
• Developed various systems in SCOPE tool such as DB2 integration with external Tivoli Dependency Discovery Manager (TADDM) databases.
• Created data-driven rules engine and server profiling analytics tool for determining server affinities.
• Implemented algorithms for source to target mappings for migration and virtualization projects.
• Designed transformation costing solutions for IBM SCE+ Cloud offering.

Global Solutions Architect

Confidential

Responsibilities:

• Chosen to lead project to consolidate several hundred Oracle instances in several Unix environments.
• Completed project on time and according to requirements by collaborating with client business owners / DBAs and Unix Architects to create wave plans, testing plans and project plans for flawless consolidation.

ERP Migration Specialist

Confidential

Responsibilities:

• Led team of IT specialists at international electronics manufacturing company to implement Baan ERP environment in over 12 European sites.
• Relocated for 13 weeks in Europe to support EMEA technical team.
• Created and managed project plans, served as Baan system administrator and provided routine Unix support. Led Oracle database integration project.
• Contributed to successful installation of over 15 Baan ERP environments by installing / updating customized Baan software, service pack and Baan / Oracle setups, enabling Bean environment for various development, training, and migration teams.
• Assumed primary responsibility for installing and configuring production Baan environment in the Boulder, Colorado data center by working with Oracle DBA’s, IT architects and system administrators to support several hundred users in Raleigh, Calgary and Columbia, SC.

Confidential, UT

IT Manager, Unix Administrator, DBA, Developer

Responsibilities:

• Led company-wide Baan ERP Implementation converting data from legacy application to Baan, utilizing Informix databases.
• Utilized multiple platforms to develop conversion scripts and user interfaces for accessing and converting databases.
• Rewrote and enhanced several existing 4GL routines, improving several mission-critical business processes.
• Monitored database engine performance and planned / implemented RDBMS performance and capacity improvements.