Thomas Santiago

About Thomas Santiago

Professional Summary:•20 years of relevant experience in Information Technology including data analysis, database design, development, testing, implementation, support and enhancements of BI / Data Warehousing and web based client/server applications.•Currently working as a Data Modeler for CHAMPS Medicaid claims processing system of Michigan Department of Health & Human Services (MDHHS) and related ancillary solutions.•Experienced in Data Modeling of OLTP (3NF) and OLAP Data warehouse applications (Dimensional, Star & Snowflake Schema) as well as data analysis.•Expert in data modeling tools like Erwin and SQL Data Modeler.•Worked as a Data/ETL Architect and designed/implemented ETL solutions.•Experience in writing, testing, and implementing of Stored Procedures, Packages, Functions, Triggers and Views at database using SQL and PL/SQL.•Experienced in development, support and enhancements of Data Integration applications using ETL (Datastage, Oracle PL/SQL and Informatica).•Involved in writing Unix Shell Scripts for various tasks.•Performed Application DBA Activities in Oracle. Activities such as Users/Schema Maintenance with Security, Datapump, Export/Import, Materialized Views/Logs, SQL*Loader, Maintenance of all Database Objects, Tablespace/Storage Management, DB Backup, Statistics Gathering/Analyze of Objects, External Tables, UTL File, SQL Loader, Partitioning tables, ASM Disk Group/Member Maintenance and Oracle Golden Gate Replication monitoring•Experienced in Data Migration and supported for database migration•Extensively involved in MARS Database Migration from Solaris to Linux environment which is one among the top 5 complex/critical/high visibility applications of General Motors (GM)•Experience and knowledge in Health Care, Manufacturing, and Insurance domains.•Have gained full SDLC experience in many projects and involved in project management activities.•Certification: Oracle Certified Associate (OCA), Six Sigma Green Belt

Experience

1. Sr Data Modeler

   Acentra Health

   Dec 2014 — Present · Lansing, MI, US

Education

• St. Mary's Higher Secondary School, Dindigul

  High School

• Arulanandar College, Karumathur, Madurai

  Bachelor of Science (B.Sc.), Mathematics

  1992 — 1995

• Kurinji college of Arts & Science

  Master's Degree, Computer Applications

  1995 — 1998

Skills

• Shell Scripting
• Sql
• Big Data
• Linux
• Software Project Management
• Business Intelligence
• Oracle Database Administration
• Sdlc
• Datastage 8.7
• Java
• Oracle Dba
• Oracle HR
• Pl/Sql
• Databases
• Oracle Golden Gate
• Data Warehousing
• Active Directory
• Data Modeling
• Windows Server
• Database Design
• Data Migration
• Oracle
• Toad 9.0
• Data Analysis
• Etl
• Software Development Life Cycle (Sdlc)
• Microsoft Sql Server
• Application Dba
• Oracle Pl/Sql Development
• Entrepreneurship
• Erwin 9.0