Joseph R Chen

New York, NY ***** Phone: 678-***-**** Email: ad3apt@r.postjobfree.com

Motivated IT professional with 15+ years of experience developing scalable database solutions for large-scale enterprise business applications. Demonstrated proven ability to take the technical lead in software development projects, successfully developed and implemented 20+ software releases, data migrations, BI Analytics, and numerous database technology upgrade projects. A committed team player with strong analytical and problem-solving skills in Data Modeling, T-SQL programming, Shell scripting, Performance Tuning, Data Migration, and ETL processes. Seeking opportunities in a new organization to leverage my database technical skills.

Work Experience:

Senior DBA \ Data Architect

Logility American Software, Atlanta, GA

Jan 2016 – June 2023

Key projects:

• DBA team lead responsible for designing, implementing, and optimizing enterprise data solutions for Supply Chain Business Application software development releases in SQL Server, Oracle, MySQL, and Azure, supporting 800+ customers in 80 countries with total software revenue exceeding $120 million.

● Performed high-level data architecture designs in alignment with the enterprise business strategy and software requirements, including conceptual model, data modeling, data flows, data quality, data governance, data analysis and integration.

● Led the development of cloud-based database implementations and upgrades leveraging Azure and AWS infrastructures and services.

● Led the migration of on-prem databases to Azure using various migration methods including DMA, DMS, Azure Data Studio, Log shipping, Replication, and Backup & Restore.

● Performed data profiling and analysis of existing systems to migrate NoSQL structure dataset and documents to MongoDB.

● Collaborated with cross-functional teams to ensure proper integration of business applications and sys- tems to exchange data using APIs, SSIS, SSAS and ETL process.

● Created DevOps CI/CD pipelines to build, test, and deploy database upgrades to QA and Production servers, which led to a 50% reduction in software deployment time.

● Worked closely with the Business Analytics team to create multidimensional OLAP cubes using SSIS and SSAS for data analytics and reporting.

● Created ETL data pipelines using to collect and analysis data for inventory forecasting using PowerShell and Python scripts leveraging Azure data solutions (Azure Synapse Analytics, Azure Data Factory and Databricks).

● Worked closely with Customer Support team, provided technical guidance in database performance tuning, database maintenance and security plans for 100+ terabyte size of enterprise databases on hosting environments (SQL Server, Oracle, MySQL, MongoDB, and Azure SQL).

● Configured Always-On high availability and disaster recovery plans on hosting environments to ensure business continuity, including setup failover clusters, availability groups, and transactional replication.

● Demonstrated high analytical and problem-solving skills, recognized as an escalation point of contact for the business to address data-related technical issues. Senior Database Developer

McKesson Healthcare, Atlanta, GA

July 2001 – Jan 2016

Key projects:

● Served as development DBA lead responsible for designing, implementing, and optimizing secure database solutions supporting application development for healthcare’s Electronic Medical Record system, used in 500+ hospital facilities as a mission-critical business operation tool to manage terabyte size of medical records for HIPPA requirements.

● Developed and implemented the first data-focused business intelligence tool using SSIS and SSAS for HIM billing department to streamline revenue recognition, resulting in more than $34 million in software bookings.

● Served as a subject matter expert on database technology for application development team, provided technical guidance and advice on application data integrity, database optimization, and consistency.

● Developed various high availability architectures and processes to eliminate server downtown, including Failover Clusters, Availability Groups and Transactional Replication.

● Developed SQL Server and Oracle queries and scripts to validate the data completeness, integrity, and accuracy of medical records for HIPAA compliance.

● Improved the HL7 process by developing automated SQL jobs to check and validate inbound HL7 documents for potential errors, which reduced the HL7 processing errors by 50%.

● Designed and developed an ICD upgrade utility for large hospitals to update the latest version of diagnoses and procedure codes on live production systems with no server downtime required.

● Enabled the business to recognize additional revenues by designing custom migration tools for hospitals to migrate from legacy applications to the latest version of SQL Server

● Winner of McKesson’s Innovative Development of Excellence Award for development of data pre- conversion methodology, which reduced the software upgrade server downtime at large hospital sites from more than 24+ hours to less than one hour.

Database Developer

WebMD, Atlanta, GA

2000 – 2001

Key projects:

● A member of the Enterprise Application DBA team responsible for installing, administering, maintaining, and supporting large-scale enterprise production servers on multiple database platforms (Sybase, SQL Server, and Oracle).

● Improved the company's fact-based decision-making process by creating OLAP cubes to extract critical financial and sales data from multiple database sources into a centralized data warehouse for ad hoc analysis & reporting purposes.

Education:

Purdue University

Bachelor of Science

West Lafayette, Indiana

Industrial Management/Computer Science

Skills:

Database Platforms: Microsoft SQL Server, Oracle, Sybase, MySQL, MongoDB, and Azure SQL Server. Data Warehouse: Data Lake, Synapse Analytics, Azure Data Factory, Databricks, Snowflake, Programming: T-SQL, PL SQL, PowerShell, C++, Python, Java, Shell scripting. Database Expertise: Data modeling, Data Warehouse, SSIS, SSRS, SSAS, ETL, OLTP, OLAP.

Contact this candidate