Frederick (FRED) Ong (MBA)

MCSE, MCDBA, MCP+I, Certified Sybase Administrator

Email: ad29dz@r.postjobfree.com Cell: 832-***-**** U.S.Citizenship

LinkedIn: https://www.linkedin.com/in/frederick-ong-7b893016/

SUMMARY

A team player with broad technical knowledge and creative problem solving.

Implement and manage projects in the oil and gas, legal, financial, and clinical industries.

Streamline and automate processes and functionalities between users and technologies.

Conceptualize and design projects using technologies to leverage company profit and growth.

Lead company to cope with change in technology and strategic problem solving.

Optimize, preserve, protect, retain, and secure company data from breach and security threats.

Experience in RDBMS, Database scripting, Data migration, Data integration, physical design, database integrity, data warehousing, normalization, maintenance, performance and tuning.

TECHNICAL SKILLS

Machine Learning, AI, AWS. EC2, S3, Postgres RDS, DataBricks,Data Governance, Azure Data Factory, Azure blob storage, Imparter, JIRA, GitHub, Salesforce CRM, NetSuite ERP, Business Intelligence SSIS, SSRS, SSAS, MSSQL Server (6.5, 7.0, 2000, 2005, 2008, 2012, 2014, 2016), Sybase, Crystal Reports, Power BI, Cloud Technology, Windows 2003, 2008, 2012, 2016, Citrix, IIS, Office, Transact SQL,TSQL PL/SQL,Powershell, CozyRoc, DB Artisan, ODBC, OLEDB, MSDE, Inertia, Petra, PHDWIN, Seven Lakes, Neopharma, Quorum, MAS 500, Sales Logix, Vineyard, Knowledge Sync,, Impromptu, MP2,, BCP, SFTP,,EDI, Peregrine(TLW), True Commerce, VB.NET, C#, DTS, XML,RAVE Medidata INFORM, SAS, DBMSCOPY,ERP, CMMS, SOX, HIPPA, iManage, Elite, Lexis Nexis InterAction CRM, UltiPro, In-app, eDiscovery, Record Management (IRM), OpenText, DMS,BOX.

EXPERIENCE

SolarWinds

Database Architect & Development Katy, TX/ Austin, TX September 2021 – Present

Data Conversion and Data Cleansing and Data consolidation using Data Bricks, Glue, Azure Data Factory, SSIS ETL from multiple cloud platforms like Salesforce CRM, NetSuite ERP and others.

Work with Project delivery team to migrate on premises application and data to cloud flow process into Azure & AWS by building solution and identify roadblocks.

Create framework to modernize streamlining data retrieval to improve internal and external clients.

Define data architecture and design and security requirements that are compliance covering both data and infrastructure.

Conceptualize and design to automate process to maximize company profit and growth.

Document new process and identify key steps for migration.

Automate regular analytic and metric reports for management based on complex data extraction projects.

Transform daily user manual processes by utilizing technology to reduce cost and promote user efficiency and errors.

Plan and develop to automate analytic reporting to replace aging reporting using Tableau, Power BI, SSRS, SSAS, and SSIS.

Work on customer PI & PII data to be compliant with CCPA & GDPR regulations to ensure data is secured & encrypted.

Collect data into data lakes and use algorithms for machine learning and AI.

Ernst & Young/Duke Energy

Consultant/ Database Architect & Development Charlotte, NC December 2019 – March 2021

Develop and Improve data flow process into Azure environment by building a solution to identify discrepancies.

Create framework to modernize streamlining data retrieval to improve internal and external clients.

Develop security requirements and compliance covering both infrastructure, incident response, forensics and cloud native architecture.

Manage and train junior consultants in SQL database administration including integration and development for various DMS/DERMS assignments.

Automate regular analytic and metric reports for management based on complex data extraction projects.

Plan cost reduction and user efficiency and reduce errors by utilizing technology to transform daily user processes.

Data Conversion from PDF to ASCII and Data Cleansing and Data consolidation using Data Bricks, Glue, Data Factory, SSIS ETL from multiple cloud platforms.

Energy Service Expert (Solar Energy) Houston, TX July 2018 – July 2020

MIS Manager/ Data warehouse Architect & Development/ Consultant

Develop AWS Cloud architecture and scalable solutions including orchestration & buckets.

Collaborate with AWS Internal and external users to help them learn and use AWS services such as AWS API VPC, route53, Gateway, S3, EC2, and Database Service (RDS).

Project engagement for proving the use of AWS services by supporting cloud solutions that include migration of existing applications and development of new applications using AWS cloud services.

Create database SSIS integration between different platforms and develop automation between cloud and on premises.

Manage SQL database administration including upgrades and development assignments for various projects.

Plan & Develop data migration and mapping for company acquisition.

Design and Develop data integration for power utilities consumption and billing into data warehouse Redshift and data lakes using Databricks Glue, Crawler pipelines on CMMS, DMS & DERMS projects.

Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

Surge Energy America Houston, TX Apr 2017 –July 2018

Consultant (Contract)

Automated and executed operational processes and procedures to ensure uptime and performance in a high availability in cloud environment.

Proactively identified, managed, and corrected data quality issues with reports provided to CR managers.

Provide 24/7 availability of data and solve end-user SSRS reporting and accessibility problems.

Led efforts to analyze data for source/target mappings, created T-SQL scripts for data processing and automation between Neopharma and Inertia.

Collaborated with multiple applications to understand and implement detailed requirements for Integration and other reporting needs for Seven Lakes, Neopharma, Petra, and PHDWIN.

Developed, documented and validated complex business rules vital for MDM data transformation.

Developed ETL scripts to enable weekly processing datasets into MDM for Inertia and Seven Lakes, Neopharma, and Quorum with SSIS.

Identified issue and Data Cleansing and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.

Plan, develop and support Master Data Management (MDM) integration for Financial, Land, oil and gas production.

Provided Azure support including strategic design and architectural mentorship, assessments.

Worked with SSAS in creating cubes, data source views, named queries, dimensions and deploying analysis services projects.

Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.

Preventive Healthcare Solutions Houston, TX Aug 2016 – Feb 2017

Data warehouse Architect & Management

Plan and create multiple Teradata systems including independent marts, development/oat, disaster recovery, and the enterprise warehouse.

Manage/Monitor Teradata system performance, including workload management and throttling in Application, query performance and tuning, physical node behavior, and distribution.

Install and maintain terabyte databases using Microsoft SQL Server 2008 2012, and 2014 in Azure environment.

Manage projects by Implement data mining and cleansing on large historical databases and administer database servers of the SDLC, including development, QA, and production.

Create documents for database integration workflows and data process transactions between businesses in Azure environment.

Support software developers in designing and developing efficient methods of working with database integration with SSIS & Azure Data Factory.

Perform control database security and encryption for auditing.

Develop support highly available database systems, using techniques such as Always On, and log shipping.

Develop developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.

Create partitioning for very large database tables and SDLC for retention and retirement.

Responsible for checking new data for accuracy and removing inaccurate or corrupt data.

Present and train database virtualization new technology for data mining, data modeling and data warehousing to management and technical team.

Articulate project goals and scope, translated business needs into technical terms and documents, prepared detailed work breakdown structures (WBS) and instilled shared accountability for achieving project milestones.

HBR Consulting Chicago, IL Sept 2015 - June 2016

Senior Consultant

Provide planning, solution and development to consolidate and integrate customer Teradata for cloud technology.

Develop planning for data cleansing and remove duplication and incompatible data to achieve clean and accurate data.

Manage project for SDLC and implementation for company data governance and DR.

Create new documents and Train users on transition of new applications.

Create design documents and collaborate with customers and internal team members to develop analytical solutions.

Plan and configure to help customer data servers for better performance, processes, and secure environment. Identify customer’s business objectives, processes, technology stacks, and important data assets.

Work with customers to provide workflow in their industry for efficiency and better rates and revenues.

Bracewell & Giuliani LLP Houston, TX Oct 2012 – Oct 2015

Database Management in Administrating, Developing, Integration, and Planning

Manage and resolve design issues during development stage.

Automate & Integrate UltiPro data into Elite and Chrome River financial systems.

Maintains organization's effectiveness and efficiency by defining, delivering, and supporting strategic plans for implementing information technologies.

Completes projects by coordinating resources and timetables with user departments and data center.

Verifies application results by conducting system audits of technologies implemented.

Preserves assets by implementing disaster recovery and back-up procedures and information security and control structures.

Recommends information technology strategies, policies, and procedures by evaluating organization outcomes; identifying problems; evaluating trends; anticipating requirements.

Implement information technology strategies, procedures, and policies and identify business needs for marketing and accounting departments.

Plan and create automate job for data integration and for analytic reporting.

Plan and Create company SQL 2012 Always on Available for Disaster Recovery.

Plan and Create Performance tuning by running SQL profiler, tracer and reorg, reindex, and update statistics.

Administration and development for MSSQL 2005, 2008, 2012 servers.

Plan and Create Monitor server disk space, monitoring logs, ensuring jobs have run successfully, checking for errors in consolidated report format.

Lumers (Healthcare). Austin, TX Apr 2012 – Oct 2012

Sr. Data Conversion Consultant / Data Warehouse Development

Team Project on Teradata database, data modeling, dimensions, and integration for data warehouse by using SSIS and SSAS.

Implement Reporting Analysis by integrating with vendors and clients using ETL architecture.

Develop entire software development life cycle across numerous software and hardware platforms in a various industry.

Create Planning, design, development, Implementation, and Analysis of data warehouse, ETL, client/server, and mainframe transactional applications.

Apply development lifecycle methodologies for Structured and iterative data warehouse.

Configure production and development for MSSQL 2005, 2008, 2012 database administration disaster recovery.

ICON Clinical Research Inc. (Healthcare). Sugar land, TX Nov 2006 – Apr 2012

Database Administration, Management, Planning, Development, and Integration

Manage integration team both on site and off site spread across the globe. Categorized DB Administration, Application, Operation, Production, Change Management, NOC, On-call support and performance optimization.

Plan and implement Disaster recovery for SQL servers including Database Mirroring and Log shipping.

Implement SQL security NT and SQL mixed mode for internal users and plan and test upgrade for MSSQL 2000, 2005, and 2008 Servers.

Reviewing time of the projects and identified risks related to the project.

Create and applied training programs for internal employees.

Process, review, and query clinical trial data integrate into Oracle Clinical database or an Electronic Data Capture (EDC) System

Planning, constructing, testing and maintenance of databases with GCP and GDP.

Developed SDLC for Clinical Data and the process is compliance to SOX.

Configure ETL Clinical Data for Phase Forward INFORM, RAVE Medidata, CTMS, Fisher Medio, and OCRDC system.

Transform Clinical Data using ANSI-SQL, XML, Active X and VB Script, C#, SAS.

DBCC, Performance and Tuning MSSQL 2000 and 2005, and 2008 servers using SQL profiler, show plan, and index wizard.

Use DTS and SSIS Local packages for exporting and importing data to EDC.

Create store procedures, views, and triggers for Data migrations and reporting’s.

Plan and create batch scripts to automate jobs.

Working on testing of Clinical database, queries optimization and performance.

Cerner Corporation (Healthcare). Kansas City, MO Apr 2006 - Oct 2006

Database Administration and Report Development

Created Stored procedures, views, triggers for replication.

Created Financial & Inventory & EMR Reporting using Crystal Report and Reporting services.

Performed and tuned Sybase SQL Anywhere servers.

Troubleshot errors, deadlocks, and queries.

Created Financial & Inventory & EMR Reporting using Crystal Report and Reporting services.

Proven experience of Planning, Design, Implementation, Performance tuning, and Maintenance.

Proven experience of DBA Activities (Backup & Recovery planning, Mirroring, Replication, SQL Agent Jobs etc.)

Xerox (Affiliated Computer Services) Houston, TX July 2005 - Apr 2006

DBA /Data Center Manager

Hired, trained and supervised a 4-member team providing Data Center operations and Development support.

Planned and managed to team members of 3 to perform upgrades from SQL 2000 to SQL 2005.

Planned and managed to team members Installed SQL 2005 on a Win 2003 platform.

Managed Data flow from remote sites and used Management Studio for Admin.

Direct team members to perform and tune MSSQL 2000 and 2005 servers.

Managed a team to monitor database growth by automating the process.

Planned and outlined the team of maintenance Plans for Reorg, Reindex, and DBCC options.

Ensured the database was compliant to SOX.

Planned with the team to create Integration Services and Local packages for exporting and importing data from Datawarehouse.

Tekgraf Corporation Greenville, SC Nov 2001- July 2005

DBA Manager/Network Manager

Managed a group of team members to perform migration data into SQL 2000 &SQL2005 Data warehouse and Data Mining.

Managed a group of team members to perform Installed and Configure MSSQL 7.0, SQL 2000 on Win 2000 & Win2003.

Report to CFO to layout Financial & Inventory Reporting using Crystal Report and SRSS.

Directed team members develop standard for created Stored procedures, views, and triggers to customize report and MAS 500 ERP application.

Managed a team for Database configured Memory, locks, cache Management, and Parallel Processing.

Managed a team for performed and tuned by binding the large tables, indexes and temped to the memory.

Report to CIO on the day-to-day hardware and software conditions for proactive decision making.

Rockwell Automation Greenville, SC Aug 2000 - Oct 2001

DBA/Network Administrator

Configuration and implementation of MSSQL 6.5, MSSQL 7.0, MSSQL 2000, Sybase and Oracle on both LAN and WAN.

Administered Kronos application and extracted employee payroll and timesheet data for reporting purposes.

Performed database disaster recovery on MSSQL 6.5 & 7.0, 2000 by restoring the master and Medb database backups and reconfiguring the server for the appropriate network libraries and security mode.

Troubleshot SQL client connectivity, TCP/IP packet transfer, communication failure, and slow queries over WAN by using NETIQ, HP OPENVIEW, and WINDOWS NETWORK MONITOR.

Database migration from Mainframe database & Text file to MSSQL 7.0 on Windows NT & 2000 platform including using TS\SQL, DTS, local packages, FTP, bop, and DB artisan.

Implement security SQLDMOSecurity_Mixed mode to authenticate Windows NT, Windows 2000, and MSSQL users and groups.

Completed MSSQL 6.5 & MSSQL 7.0 Administration, Performance and Tuning courses

Performance and Tuning including filegroups, cache management, DBCC, reindexing, APF, parallel processing.

Implemented physical design by Creating, Normalizing the tables by enforcing rules, defaults, indexes, and locking scheme.

Used show plan to optimize stored procedures and triggers for performance purposes.

Scheduled DBCC, reindexing, and Backup Maintenance plan to monitor daily database backup and database performance.

Upgraded MSSQL 6.5 & MSSQL 7.0 to SQL 2000 by using upgrade wizard.

Resource allocation planning, DSS and implement OLAP, logical process manager, Database Change Control and create security.

Troubleshot long queries, deadlocks, rollback transactions, and connectivity problems using SQL Profiler.

Datastream Systems Greenville, SC Apr 1998 – Aug 2000

Senior Research Analysts (DBA)

Integrated Windows2000, NT, Win98, Win95, and MSSQL (6.5 & 7.0) and Access.

Wrote TS\SQL scripts for MSSQL 6.5 and 7.0 servers.

Troubleshot and MSSQL7.0 server performances and scheduled Maintenance backup.

Data Conversion and import queries in Paradox, Microsoft Access, MSSQL.

Trained and consulted CMMS and EAM (MP2) software for customers in an Enterprise environment.

Implemented Web link, Data procedures that integrates with IIS 4.0.

Troubleshot installation failures and repair ODBC in Windows 2000, Windows NT, Windows98, MSSQL, Oracle and IIS.

EDUCATION

Texas A & M -Commerce 2010-2013

MBA for Information System and Data Management

Brigham Young University-Hawaii 1995-1998

Bachelor of Science in Information System and a minor in Business Management

Completed senior projects using the following software: Visual Basic Client Server, Visual J++, Windows NT, Novell NetWare, Author ware, Microsoft FrontPage, and System Design Methodologies.

Contact this candidate