Professional Experience

Santhosh Channa

Accomplished and highly experienced data architect with more than two decades of experience across different industry verticals. (Healthcare, Transportation and Telecommunication). 

Ø  Extensive experience in Database management, Data Modeling, Data Architecture and Data Governance.

Ø  Extensive record of providing exponential increases in throughput, accuracy and profitability to the tune of 30M+ savings for the enterprises.

Ø  Immense experience in understanding and synthesizing data into a unified, coherent vision and communicating that vision to a diverse audience.

Ø  Solid experience in translating business requirements into conceptual, logical, and physical data models.

Ø  Proven ability to deliver highly comprehensive Master Data Management designs to consolidate data across a wide range of business entities.

Ø  Experienced in managing Very Large Databases ranging from 2TB to 37TB.

Ø  Expert knowledge in providing the best solutions and practices on migrating databases between cross platforms using different Oracle Technologies including Golden Gate.

Ø  Experienced in leading and managing teams that provide 24/7 oracle technology services.

Ø  Provide mentorship, guidance and knowledge dissemination to Development teams for successful product development.  

Core Competencies: 

§  Database Design

§  Data Architect/Modeling

§  Data Integration

§  Performance Turning

§  HA Solutions (RAC)

§  Backup & Recovery

Technical Proficiency:

Platforms: Unix (Linux, HP, AIX, SUN), Windows

Database:         Oracle, SQL Server, MySQL, Netezza, PostgreSQL, Cassandra 

Cloud Related: AWS, Databricks, Google Big Query, Snowflake

Tools: All Oracle Provided Tools, Data Guard, Golden Gate, TOAD, DBeaver, OEM, RMAN, 

                        HP Data protector, Erwin, ER/Studio, AltoSoft(KoFax), Cognos, Tableau,

                        Talend, Veritas, RepliStor

Welltok – Roswell, Georgia

August 2017 to present

Enterprise Database Architect

Accomplishments Statement:

Ø  Provided technical leadership during mergers and acquisitions for data integration.

Ø  Conceived and Architected homegrown ETL (using Python for scripting and AirFlow for orchestration) to build EDW in Snowflake (AWS) which fetches data from multiple databases and files.

Ø  Successfully designed and developed ETL process (SQL) to convert the existing legacy ETL process which was built using Lua and homegrown database

CIOXHealth – Alpharetta, Georgia

October 2013 to August 2017

Senior Database Architect - Development

Accomplishments Statement:

Ø  Conceived and Architected Provider Data Management (PDM) using matching algorithms and machine learning techniques to make use of varied data sources and presented to the Business Stakeholders for buy-in.  This initiative resulted in maximizing revenue generation up to $90M from $60M and also streamlined the process.

Ø     Provided technical leadership during mergers and acquisitions for data integration.

Ø   Architected and Designed data model along with MDM for the new workflow process for Release of Information and Audit Management.

Ø  Exploring Big Data Ecosystems mainly focusing on Apache Spark to process unstructured data of more than 7.5 M documents per day to provide additional value-added services for the enterprise. 

My Responsibilities as Sr. Database Architect:

Ø  Exploring Big Data Ecosystems mainly focusing on Apache Spark to scale OCR functionality over 3 million documents we receive in a day.

Ø  Working on everything from infrastructure to integration to analysis and statistics.

Ø  Analyzing data from structured and unstructured sources to better utilize the data we have (ex., using NLP on medical records).

Ø  Operationalizing our data infrastructure both in terms of data flow reliability and statistical quality of inputs and outputs.

Ø  Working closely with the business to drive clarity on functional and technical requirements.

Ø  Working closely with merged organizations to integrate the products to streamline the data flow into one system.

Ø  Working on MDM and Enterprise Data Warehousing solutions to integrate recent mergers within organization.

Ø  Establish and document coding standards, guidelines, and best practices for development teams building solutions.

Ø  Mentored developers to make better decisions in database and data design keeping in view the future growth of the product portfolio.

Ø  Provided hands on support for critical issues and guided Production DBA’s and Development team for faster and efficient issue resolutions.

RelayHealth – Alpharetta, Georgia

July 2012 to September 2013

Senior Database Architect - Production

Project Summary:

Administering Clearing House database which ranges from 2TB to 40+TB size.

Worked on major migration by moving 10gR2 to 11gR2 databases from HP unix to Linux using GoldenGate.

Working closely with Development DBA’s and developers on architecting new projects and planning on data growth and working closely with Storage team for disk expansions.

Working on Galileo System (Clearing House) by providing support on production issues by analyzing and fetching the data from Oracle and Netezza.

Accomplishment(s):

Ø  Received numerous awards and appreciation for the accomplishments in both Relay Health and McKesson

Ø  Took the initiative to increase the efficiency, accuracy and drastically reduce deployment times by 80% with streamlined process and execution.

Ø  Enhanced existing ETL process between Oracle and Netezza by incorporating new algorithms and process, thereby increasing efficiency and maximizing revenue by removing licensing costs of 500K.

Ø  Made the data integrity, upgrade time and migration process highly efficient by coming up with a bullet proof concept of back loading data with SCN and having multiple groups in Golden Gate for migrating 10g to 11g from big endian to little endian OS. This effort resulted in cutover to new environment for 40+T database in only 2 hours. 

My Responsibilities as Sr. DBA/Architect:

Ø  Designed, developed and deployed home grown utility to handle table statistics based on metadata driven configuration which gives more flexibility to handle huge tables and tables with partitions etc.,

Ø  Providing 24/7 database administration support for 7-node Oracle 10g RAC and 2-node 11g production and 4-node QA 10g environments for databases ranging from 40GB to 40+TB.

Ø  Plan and roll out regular Oracle patches and upgrades from 11.2.0.2 to 11.2.0.3.

Ø Successfully migrated 7-node RAC 10g database to 2-node 11gR2 from HP-Unix to Linux environment using Golden Gate.

Ø  Closely monitoring the growth of the database and working thru the performance issues and planning on migrating 10g RAC database to 11g RAC from HP to Linux

Ø  Planning on rebuilding large indexes on off-peak hours to reclaim the space

Ø  Adding/altering ASM Diskgroup’s by co-coordinating with Sys Admin team

Ø  Moving Partitions from one tablespace to another tablespace due to space issues

Ø  Successfully tested and moved all of our Production and QA (around 20 databases) backup’s to HP DataProtector B6200 de-dup to gain backup storage space and to improve backup time by scheduling the jobs in different gateways using multiple channels.

Ø  Working closely with IBM on Netezza Backup issues and Netezza upgrades.

Ø  Analyzing and making decisions on the BI reports whether to run in Oracle or Netezza and helping developers to aggregate the data in Netezza and pushing the data into Oracle database for better performance in BI report execution and automating the process in Oracle Datawarehouse database

Ø  Creating Partitions and sub-partitions for better performance and to handle multiple Payor data processing simultaneously.

RelayHealth – Alpharetta, Georgia

May 2011 to July 2012

Senior Database Architect - Development

Project Summary:

Working on PCS (Payor Connectivity Services) which is based on “Hosting Solutions” concept that hosts multiple customers in a central location by avoiding too much of overhead on hardware and supporting the systems.

PCS hosts EDI (Electronic Data Interchange) data from various insurance companies in a centralized database with Oracle’s VPD (Virtual Private Database) technology to secure the information to its respective clients.

My Responsibilities as Sr. DBA/Architect:

Ø  Setting up and handling databases on 10g and 11g RAC Environment for Dev

Ø Providing continuous development support for developers in designing the new schema structure for new projects which integrates with the existing other schema structures in OLTP.

Ø  Analyzing and Designing the existing database tables for better normalization to handle large amount of EDI data to avoid huge data storage and redesigning the ETL process to push the data into multiple tables

Ø  Closely monitoring the growth of the database and working thru the performance issues and planning on migrating 10g RAC database to 11g RAC from HP to Linux

Ø  Planning on rebuilding large indexes on off-peak hours to reclaim the space

Ø  Implementing an automated process to refresh certain project related tables (which includes date range or complete refresh) from PROD to DEV with Falshback capability to revert back to its original state if needed.

Ø Working on Implementing and handling ETL process using Oracle Packages/Procedures to process the EDI data from staging to core tables simultaneously for multiple payors (clients).

Ø  Implementing Data Loads into stage tables using SQL*Loader direct paths and parallel for load multi-payors data in parallel.

Ø  Planning and Scheduling jobs which loads the data using SQL*Loader and ETL procedures in a way that it would not affect other clients data while one is working on it to provide 24/7 access to their EDI Data.

Ø  Shell scripting to automate SQL*Loader and ETL Process jobs and generate and send error reports to the customers.

McKesson Provider Technologies – Alpharetta, Georgia

August 2006 to May 2011

Senior Database Architect

Project Summary:

Horizon Meds Manager™ (HMM) is a proven pharmacy information management solution that captures details of medication used in both inpatient and outpatient settings. It also links encounters in order to create a patient medication profile across facilities. The solution meets the changing needs of today's pharmacist by integrating with the physician order entry (POE) application.

This eliminates the need for any manual transcription and helps the pharmacy to electronically receive, verify and send medication orders to automated dispensing and administration applications thereby ensuring patient safety. Medication Management of the patient is taken care in HMM by assurance of patients' Five Rights (right patient, right medication, right time, right route and right dose). HMM also allows pharmacists to maximize their productivity and play a more active role in patient care.

Accomplishment(s):

Ø  Conceived and architected a simplified installation and upgrade process of HMM product which replaced the existing, time consuming and resource heavy approach for all database upgrades. The new process resulted in upgrades to 300+ customers seamlessly compared to 1 or 2 customers per week. The comment received from one of our client was "even a 5th grader can perform HMM deployment now"..

Ø Designed and implemented a Delta Migration Approach to migrate our HMM product into McKesson’s EDM (Enterprise Data Model) with the flexibility of configurable acceptable downtime.

My Responsibilities as Sr. DBA/Architect:

Ø  Played a key role as a database architect in HMM Re-Architecture project.

HMM Re-Architecture project is to merge the existing HMM application into Enterprise level which is McKessons products of suits and also to move into three-tier architecture moving all the business logic handled in database procedures into application tier. As an architect, identified the enterprise level entities those can be used in common between HMM and Enterprise database model. Handled and involved in the DBCC call log for HMM and EDM (Enterprise Data Model) to necessitate the database changes.

Ø Designed a successful migration approach to migrate HMM from standalone to Enterprise solution with the down time less than a half hour using pl/sql methods and transportable tablespaces approach.

Ø  Designed Logical and Physical Database module using ErWin.

Ø Responsible for setting up RAC on Linux and adding/removing Nodes to existing RAC environments.

Ø  Successfully handled and supported all needs from Dev and QA team for their Database needs on RAC and non RAC platforms.

Ø  Installing and maintaining multiple oracles on the servers to accommodate different product release needs.

Ø  Upgrading 10g Rel1 RAC environments to 10g Rel2.

Ø Responsible for handling and maintaining off-shore team for implementing the migration approach and other regular DBA activities.

Ø  Responsible for Capacity planning and providing a solution for vertical or horizontal scalability to handle the performance and high availability at the client site.

Ø  Troubleshooting performance issues at the remote customer production sites.

Ø  Setting up ASM using raw file system and asmlib. Adding additional diskgroups to existing ASM instance.

Ø  Setting up the database on RAC using ASM and non ASM file systems.

Ø  Successfully implemented and managed a shell script utility for McKesson Corp. HMM product installation at the client places.

Ø  Working closely with ETL Processes to push the data and maintain consistency in warehousing database for BI reporting needs.

Ø  Implementing and maintaining RMAN scripts for cloning and backup purposes for both Dev./QA and remote customer environments.

Ø  Testing the performance and finding possible code changes such as ANSI SQL Syntax mandatory changes etc., with 11g in HMM app.

ACS Transport Solutions Inc., (formerly Ascom) – Norcross, Georgia 

April 2001 to August 2006

Systems Support Manager/Senior Database Administrator

My Responsibilities as Support Manager/Sr. DBA:

Ø  Lead DBA, Support and QA teams to handle 14 airports across United States.

Ø  Drove operational excellence on development and production environments by providing technical leadership, resolving operational database problems and ensuring continuous operational excellence proactively. Additionally defined, implemented and enforced technical & operational standards, identified future architecture needs, made recommendations and contributed to future architecture enhancements.

Ø  Involved in the bid process to gather statistics on transactions per minute for Capacity planning and to provide CTC estimates if elected in the bid process.

Ø  Successfully implemented and managed Parking Revenue Control System Environment for 14 (approx. 72 Production Databases and more than 80 Development Databases) airports.

Ø  Designing Logical and Physical Database module for Parking Revenue Control Systems.

Ø  Designed, Developed and Implemented Warehouse Management System for parking solutions using Oracle Packages, Procedures, db links and Oracle Jobs.

Ø  Implemented core business logic with in the Database using extensive procedures, packages, triggers and views.

Ø  Designed, Developed and Implemented Archival & Purge mechanism for OLTP and Warehouse databases.

Ø  Implemented Fail Over mechanism using Oracle Replication both in SE (using Materialized Views) and EE.

Ø  Implemented Automatic Fail over solutions using RepliStor.

Ø  Created and automated shell scripts for daily and weekly RMAN backups and for regular DBA tasks.

Ø  Providing 24/7 support for production environments

Ø  Troubleshooting performance issues and regular database health check using statspack.

Ø  Migrated database from 8.x to 9i

Ø  Maintaining Oracle Partnership Network membership and all Oracle related Licensing.

AT&T Solutions – Greensboro, North Carolina

Sep 1998 – April 2001

Senior DBA/Programmer

My Responsibilities as Sr.DBA:

Ø  Supporting development, test and production databases for ongoing development and testing.

Ø  Lead a team of two DBA’s (Dev and Production) and three Oracle Backend Developers.

Ø  Capacity planning for building Production Database.

Ø  Designed Logical and Physical Database modules.

Ø  Performing the DBA activities like installation, applying patches, migration, performance tuning, backup and recovery, and space management.

Ø  Designed and implemented the data warehousing mechanism using standard Oracle Packages and procedures.

Ø  Provided training to developers on Sql and Pl/Sql programming.

Ø  Designed and implemented Database packages for file handling (Loading data from external files into database after doing validations)

Ø  Migrated the existing Oracle 8.0.5.0.2 databases to 8i (8.1.6).

Department of State Treasurer – Raleigh, North Carolina

Apr 1998 – Sep 1998

Systems Analyst/DBA

My Responsibilities as Systems Analyst/DBA:

Ø  Involved in acquiring requirements from the user

Ø  Designed Conceptual, Logical and Physical Modules

Ø  As I possess professional experience as a DBA, I was involved in physical and logical design of the database.

Ø  Involved in writing Pl/SQL packages and procedures.

Ø  Performing the DBA activities: performance tuning, backup and recovery, role & user management and space management.

Tata Infotech Ltd – Bangalore, INDIA

Apr 1996 – Apr 1998

MIS Analyst/DBA

My Responsibilities as MIS Analyst/DBA:

Ø  Gathering the requirements from the users for application design

Ø  Physical and logical design of the databases for various applications

Ø  Developing the application and writing stored procedures and packages to perform few batch jobs for summarizing the data for huge tables. Used Pro*C for some batch programs

Ø  Involved in user training and system testing

Ø  Provided training to developers on Sql and Pl/Sql programming

Ø  Performed application tuning by analyzing trace files and explain plans.

Bhoruka Steels – Bangalore, INDIA

Feb 1995 – Apr 1996

Programmer

My Responsibilities as Programmer:

Ø  Was involved in System development

Ø  Implemented and maintained BIS

Ø  I was partly exposed to Database Administration.

Software Solutions Integrated – Chennai, INDIA

Mar 1994 – Feb 1995

Programmer

Developed an application Financial Accounting System for Balurghat Transport Inc.,