SAP HANA Data Modeler and SAP BW admin. Certified HANA Associate. Responsible for creating data flows and implementing calculation views for various business units in a scrum methodology. Modeling Data and implementing SAP HANA Views. ETL of various data to Corporate data to SAP HANA, using technologies such as SAP BW and Data Services.

Temporarily assigned at Concur a SAP Company to Support DB Landscape that directly interfaces into SAP for migration. Collaborating with IT Dev teams to perform deployments and transfer data into into SAP.

Responsible for administering a SAP BOE BI Platform Landscape, ETL Tools and various DB / OS systems, such as HANA, SQL Server, Windows, SUSE and Data Services. While using cloud framework to manage OS instances. Have planned SAP BI migrations, patching and version upgrades. Designed and implemented ETL processes for various projects using various programming and scripting tools. All in collaboration with multiple globally located teams. Worked as Scrum Master and ran daily stand ups.

SAP Labs support of SAP ERP Systems for the Development Organization. Installation and support of SAP R/3 ERP Systems on various DB platforms, primarily SQL Server, Oracle and DB2. M&A projects specifically focused on migrating data to SAP landscape with implementation of Oracle RAC on Red Hat. Worked with remotely with teams in Palo Alto, and Monterrey Mexico.

Responsible for coordination of support for Oracle and SQL Server production database systems on Enterprise Class servers in a 24/7 environment. Unix AIX HACMP Clustering, Linux OS Clustering integration, Microsoft SQL Server Clustering, SAN integration, physical implementation , with UNIX and Windows Scripting. OS Security, monitoring and auditing. Research of new technologies and defining standards to improve DB systems and OS uptime. Strong understanding of Virtual platforms (VMware). Oracle and SQL Server RDBMS administration on PeopleSoft ERP and DB2 focus on Business Objects BI Technology. Worked with Data Warehouse team to implement new methods in increasing performance with DB technologies. Also Setup Oracle Enterprise Manger to Monitor, Alert, Performance diagnosis/tune, Capacity Plan and Backup/Recovery. Datacenter racking servers and cabling. Strong interfacing with Senior IT management and collaboration with IT applications teams, all processes completed through change management.

Responsible for supporting Oracle and SQL Server production database systems on Enterprise Class servers in a 24/7 environment. Administered Oracle RDBMS on HP-UX and Solaris, with SQL Server 2000 / 2005. DBA administration physical and VMware virtual hardware. Setup Oracle Enterprise Manager Infrastructure for monitoring, capacity planning and diagnosis. Installed SQL Server 2005 supporting Share Point and Microsoft Operations Management (MOM) environments. Worked with multiple IT groups to setup systems and coordinate rollouts of new systems. Carried on call pager.

Responsible for supporting Oracle and SQL Server production database systems on Enterprise Class servers and SANS in a 24/7 environment and coordinating DBA’s. Administered databases for PeopleSoft ERP on Oracle and SQL Server, IT Applications and 3rd Party Systems. Installed Oracle Database systems on UNIX and Windows with Clustering. Setup SQL Server Reporting infrastructure through Real Time Replication, Scripted refreshes and various other methods. Installed SQL Server on Windows Advanced/Enterprise Server with Microsoft Clustering. Setup daily administration jobs and monitoring through various methods. Performance Tuning, Capacity Planning, Recovery and hardware recommendations. Racked and cabled Servers, patched and setup Windows Severs. Strong interfacing with Senior IT management and collaboration with IT applications teams, all processes completed through change management. Carried on call pager / cell phone.

Application Integration service between London Drugs custom scheduling application and PeopleSoft ERP. Process composed of XML extractions though components with data transpositions processed in BizTalk. Tasks involved the design and implementation of components with SQL Server, with setup of BizTalk processes and validation in the PeopleSoft SQL Server Database.

Web-based transaction management system for documenting real estate transactions. Primary tasks were to design and program interfaces to SQL2000 OLTP database, which included DTS development, Data Migration, and SQL Administration. Secondary tasks included design and implementation of components for the web application.

A customer rewards and points management system. Primary tasks were to maintain, modify and design interfaces to SQL 7.0 OLTP database. This was accomplished through schema modifications and stored procedure design. Secondary tasks included the administration of the database and designing in house applications in VB 6.0.

Ministry of Forests Project• An asset management suite developed in a multi-tier Internet environment.Primary tasks included development of the presentation layer with ASP, VB Script and DHTML focusing on security and connection to the MTS tier through RDS. Secondary tasks included the testing of MTS components as well as the stored procedures and schema verification.Western Star Trucks Project• A visual scheduling system developed in a client / server architecture. Primary tasks included re-writing a VB 4.0 application to take advantage of SQL 7.0, ADO 2.0 and new generation controls. Secondary tasks also included maintenance, dealing directly with customers to explain and fix issues.BC Hot House Project• A produce management system developed in a client / server environment.Primary tasks were various from designing new modules to maintenance. New module design would include the modification of database schema to incorporate the new application. Maintenance issues would be resolved by dealing with the customer directly and updated live on client’s server.