Data Migration Management

Joseph Glorioso O. Berdan

Email: **********@*****.***

Mobile #: 707-***-****

**** ******* ***** ****** **** CA 95119

Professional Summary:

Over two decades of experience in database development, data migration, and system integration across diverse industries including data stewardship (Data Management)

Over two decades of experience in T-SQL writing complex queries (DML), creating objects (DDL), views, functions, triggers, CLR assemblies, and stored procedures (TCL)

4 years of experience in PL/SQL (Oracle 8i/Lite/10g) writing queries, functions, triggers, procedures, and packages

Proficient in modern technologies such as Confluent Kafka, Kubernetes, Streaming Data, and Google BigQuery.

Knowledgeable and experience in BI development (SSIS, SSAS and SSRS)

Hands-on experience in database installation on premise and virtual, configuration, backup and disaster recovery (MS SQL Server and Oracle)

Proven track records of delivering high-quality solutions in a dynamic environment with highest quality and professionalism

More than 10 years of excellent leadership as Lead, Chief IT Operation Support and Assistant Manager

Adept at leading Tech teams, mentoring new engineers, and driving successful project completions.

Proven ability to manage complex data migration projects, validate and optimize queries, and provide comprehensive support to development and business teams.

Excellent knowledge of Software development Life Cycle (SDLC) using agile, waterfall and big bang methodology

Very good knowledge and experience in Software Testing Life Cycle (STLC) from business use case preparation, functional, business requirements, acceptance criteria, planning, test case development, validation execution, reporting, and closure.

Diligent experience in source control, documentation, and change management

Tools Proficiency:

Azure Visual Studio, SSMS, Redgate, Visual Studio, Visual code, SSIS, SDT(BI), SQL Developer, MySQL, SOQL, Confluent (Apache Kafka), Cloud SQL, Google BigQuery, Google Cloud Storage, Data Fusion, Firestore, Airflow, Hadoop, Apache Storm, TalEnd BigData, Cassandra, Sharepoint, Toad, Tortoise, Jenkins, Bit Bucket, API, Visual Basic, C#, .Net Framework, MS Office (Excel and Access), Visual FoxPro, Clipper, Cobol, Java, and SAS JSL. And other project planning and scheduling tool like Primavera, MS Project, Confluence, and JIRA.

Experience:

Lead QA Database Engineer Feb 2021~Present

Database Developer III (Contractor) July 2018~Jan 2021

Rodan and Fields – San Ramon / San Francisco, CA, United States of America

Currently working as a QA lead to ongoing projects (Oceanus, DMGT, EDW data migration, BI Reporting migration, Apollo (Canada and Australia market data migration, Oceanus (GCP), and Finance DB migration projects). Mentor new QA engineers and lead as an example (totally hands-on) to properly execute test cases and queries to legacy databases and data lake. Strived to succeed to learn new technology (Confluent Kafka, Kubernetes, Streaming data, data fusion and Google Big Query) and able to manage and provide trainings or transfer knowledge to new QA engineers.

Successfully completed R+F Japan market project and played as one of the key role as the only QA engineer that helped the team of a well-off executed project and able to meet objectives without delay, performed data validation and supported business UAT. Successfully completed migration of R+F global services from AWS to Google cloud services platform; validating the code developments (Data Fusion, Cloud Storage, and Firestore) including SSIS and migrated data.

Successfully completed data migration projects such salesforce (Community cloud and Atlas Hybris) using integration packages in visual studio data tools (SSIS), the candidate developed a framework that would automate the validation of data from/to various data sources and target like flat files\MS Server\Workbench Salesforce\MYSQL and staging databases

Built fast performing framework using SSIS for data validation (Source vs Target)

Performed validation for operation support to EIS (Enterprise Information Systems) (On-premises databases such as (SSMS and MYSQL), BI data warehouse reporting, Data Management Integration application (Dell Boomi and Mulesoft), ECC (SAP), Commissions – business database engine, other third party vendor Okta/Gigya/Neverbounce/Global Solar, and other web services application)

Provided support to Dev, QA, and Business team in preparation of test data and query optimization

Performed review and validation of source code and BI reports/packages/projects

Produced and performed test scenarios applicable to user’s acceptance and criteria

Prepared and communicated test plans and test strategies to project team

Manage QA team (offshore) resources

MS SQL Server Database Developer III April 2015~ June 2018

Grifols Diagnostics Solutions - Emeryville, CA, United States of America

Successfully migrated legacy databases to SQL Server using SQL Server Data Tool (SSIS-ETL packages) and SSMA (SQL Server for MS Access) with applied restructuring of tables and/or introduction of new entities to facilitate new user requirements and functionality

Performed analysis and detail documentation such as specifications (design & functional) of several project database migration (MIMS – Manufacturing Information Management System, MicroID – Microbial Identification System, CAPA – Corrective and Preventive Action System (QA), ITS – Incident Tracking System, and QA Lookback System)

Implemented back-end data autonomous T-SQL audit trail (MS SQL Server)

Analyzed data governance and business rules in T-SQL to designed and developed user security and application role

Developed T-SQL stored procedures, views, functions and CLR’s as part of migration process that would ease system performance and part of front end integration processes like validations, verifications, calculations and data transformation

Created JSL (Jump) scripts for the integration of SAS JMP and SQL Server to generate control charts and plot data (Analytical)

Created complex packages using SSIS to extract, transform, and load data from different sources to destination such as Excel, SQL Server, and MS Access for internal departments like warehouse purchasing for Non-SAP materials and production (batch generated id information)

Conducted thorough functional and integration testing of newly developed databases including preparation of tests scripts (T-SQL) and data validation

Performed hyper care after deployment and continued monitoring of database activities including stewardship of master data

Managed code repository and change control

Provide support to end-user such as system presentation, user training, and personalize ad-hoc reporting

Conducted prompt support to incidents and/or requests for change to data and/or configuration of assigned systems and databases

Supported other business entities within the company in small scale database development in MS Access (Point-Of-Use Warehouse, TechServices Requisition, Manufacturing First to Last Workflow, Assay Request, Manufacturing Task Scheduling, Labeling System, and other adhoc reporting services)

Help built the creation of qualification documentation (IQ, OQ, and DM) prior to deployment of databases

Built relevant documentation to preserve knowledge of developed databases like User Guide and Data Mapping

Project Control System Integrator May 2011~ Oct 2014

Hatch & Technip JV – Koniambo Nickel SAS Project - Vavouto, New Caledonia

Successfully implemented integration of 4 databases using (Visual Studio DTS, Visual Basic, MS Excel, MS Access, and MS SQL Server)

Analyzed end-user data/report, enhanced system functionality by optimizing queries, indexes, triggers, and views of existing 4 applications (Project Timesheet; Alliance Timesheet; HR (SAP); and PAF Finance System)

Built and developed database warehouse and SSIS packages for consolidating data from different vendors and contractors in SFTP server, files were consumed and processed into data warehouse database.

Developed data visualization reports with SQL report builder and Crystal reports published in IIS and SharePoint

Create, administered and maintained job schedule for SSIS and SSRS server (Reporting Server)

Automate maintenance of SQL server thru SSIS packages

Administered maintenance plan and alerts for 3 SQL production servers including disaster recovery and identify possible improvements in database architecture without downtime operation.

Maintained data governance (user security access levels and roles)

Developed and implemented 2 applications in C# (Task and Resource Management; Contractor Manpower) from detail business analysis, system design and database architecture, unit testing, deployment and implementation, documentation of training manuals and user guide

Conducted regular checking of database performance (MS SQL Server 2008 and 2012)

Supported end-users and provide efficient training

Collaborated with teams leads and end users to build technical solutions in automating data transformation.

Assistant IT Development Manager Jan - May 2011

Aruze Gaming America Inc. Makati City, Philippines

Developed and implemented project (Software Development) schedule using MS Project to stakeholders to ensure the project is on track and forecast resource availability

Tasks to monitor resource performance

Assisted in the development and debugging under Linux and C programming

Lead IT Engineer/Sr. Analyst Apr 2006~ Mar 2010

Technoserve Construction Co. Inc., (TCCI) Makati City, Philippines

Performed research and development to upgrade/optimize system and database performance in developing queries, views, stored procedures, and interfaces

Accomplished conversion upgrade of MS Access queries and VBA into MS SQL views and stored procedures

Completed data migration, analysis, results sets for test/burnout and data manipulation (MS SQL Server 2005/2008 and Oracle 8i/10g)

Manages and monitors production site database, set user accounts and role (Active Directory and database users)

Evaluated business requirements and convert to specification for development

Established standard procedures in specifications, use cases, project setup, training guides, handover documents and manuals.

Managed schedules and delegates tasks to16 IT Personnel deployed at site and HQ

Developed and conducted 1 comprehensive training program (CMS Application) for end users and system owners

Conducted regular team meetings (issues, progress, and knowledge sharing)

Provides technical support to site projects and other teams

Performed for more than 3 years of programming in (MS Visual Studio, .Net framework, ASP.NET, C#, scripting), this web based project was developed because of the growing demand in project sites to facilitate sharing of information among sites using manageable technology from microsoft.

Db Construction Project Operation Support Chief 2009-2010 on-site assignment

JGC Construction International Ptv. Ltd. Int’l Business Park, Singapore

Planner/Scheduler 2008 on-sute assignment

Dung Quat Refinery Project Dung Quat, Vietnam

Sr. IT Engineer 2008 on-site assignment and 2009 remote support

Project: Dung Quat Refinery Project Dung Quat, Vietnam

Sr. IT Engineer 2004 Japan kick-off and from 2005 to 2007 on-site assignment

Low Sulfur Diesel Production Project Sitrah, Bahrain

Sr. Programmer/Analyst May 1999~ Apr 2006

J-Sys Phil. Inc.(J-Sys), Madrigal Business Park, Alabang, Muntinlupa City

Developed the company’s proprietary systems in Visual Basic and MS Access (Front End) and flat file (MS Access)/ Oracle 8i Database; migrate data to Oracle

Maintain, configure, troubleshoot, and install patches of Oracle and Unix environment platform

Conducted regular presentations of business processes, development progress, issues with technical solutions, user requirements, and functionality of systems/database to ensure alignment between stakeholders, system owners, developers, and IT

Ensures adequate testing of all system releases and proper recording of all modifications and issues

System Engineer (2004) at site and 2 Years (2006) remote support

Tuban Aromatic and Olefin Plant Project East java, Indonesia

IT Engineer (2003~2004) at site and (2006) remote support

Atyrau Revamp Refinery Project Atyrau, Republic of Kazakhstan

IT Engineer (2002~2003) at site and (2003 remote support

Crude Oil Production Plant Ourhoud Project Ourhoud, Algeria

Programmer (2002) at site and (2003) remote support

Silicone Plant G1 Project Map Ta Phut, Rayong, Thailand

Programmer Trainee (1999~2000) On-site and remote support

Bataan Polyethylene Plant Project Bataan, Philippines

EDP Programmer/Analyst 1997~ 1998

Amon Trading Corp., Pasig City

Assigned in all application development using Visual FoxPro, maintenance activities, data processing and production activities within the EDP department. Provide technical support for system networking (Novell).

Credit & Collection Programmer 1995-1996

Pilipino Telephone Corp., Makati City

Participated in the analysis, program design, coding and other tasks required to produce application output for Credit and Collection department.

Programmer 1994

Interphil Laboratories Inc. Sucat, Paranaque City

Handles program modification and development of Engineering systems and data processing and production activities within the Engineering Department.

Education and Training:

MIT Professional Education Applied Data Science Program – Jan 2023~ Apr2023

Edureka Apache Kafka Professional – May 22, 2020

MCPS: Microsoft Certified Professional – Certification Number: F933-3272

MTA: Microsoft Technology Associate (Database Fundamentals) – Certification Number F759-4025

Global Knowledge Incorporated CISCO Certified Network Associate Program, Network and System Administration/Administrator, 2004 - 2004

System Technology Institute Business Systems, Computer Programming, 1992-1999

New Horizons Programming with C# and .Net Framework Certification, 1992-1999

Pamantasan ng Lungsod Ng Maynila Bachelor’s in Computer Science, Computer Science 1993-1996

Pamantasan ng Lungsod Ng Maynila Associate’s degree, Computer Science 1991-1993

Contact this candidate