Senthil Dhanapal

Migration and Cloud experience:

• Migrated on-prem servers to Azure Cloud services.
• Incorporated cloud architecture into new facility planning, reducing need for on-site equipment and technical support personnel.
• Migrated numerous legacy systems to newer technologies, reducing costs and enhancing efficiency of computing tasks.
• Supported DataBricks projects

Data Science:

• Developed Python notebooks for database metrics analysis
• Developed processes to identify parameter sniffing using statistical methods like Z-Scores and Interquartile range (IQR) to proactively solve production slowness by 15%
• Identified application grouping for migration using K-Means clustering based on CPU, Disk IO usage.

Data Architecture:

• Demonstrated leadership skills in managing projects from concept to completion.
• Helped coordinate full system life cycle from requirements to design and implementation.
• Designed data models for complex analysis needs.
• Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Generated customized architecture specifically optimized for several database technologies.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
• Identified and automated business processes to increase productivity of business analysts by 10 times
• Created Partition solutions for large tables, including customized lookup sharding strategy
• Proposed and developed database archiving project using C#, which was less invasive and archived more orders per hour by 40%
• Redesigned Order Search component and increased its speed by 3 times and reduced hardware cost by over 50%
• Collaborated with cross functional teams like Release Management, Certification team, Business Intelligence team and development team making recommendations which improved overall efficiency by 75% (Deployment tool, SQL Traceloader, CRUD generator, etc).
• Developed documentation for database development practice and implemented practice across multiple app development team

Data governance and security:

• Conducted impact and risk assessment on data management project, identifying security model risks, SQL injection risks and sensitive data exposure risks.
• Managed identification, protection and use of sensitive data..

SQL Optimization:

• Optimized SQL procedures to improve them by over 99.8%, which saved hardware capacity by 40%
• Developed processes to identify parameter sniffing using statistical methods like Z-Scores and Interquartile range (IQR) to proactively solve production slowness by 15%
• Analyzed SQL trace data, XEvent Data, DMV info and SQL query plans to identify slow queries and bottlenecks, and optimized them by adding/modifying indexes, rewriting queries and changing tables design.

Data warehouse and Business Intelligence:

• Developed and deployed ETL processes using SSIS.
• Developed ETL processes using C# tool for better parallelism and overcome SSIS limitations.
• Designed DW databases using star and snowflake schema.
• Built SSAS cubes and built dashboard with KPIs out of them.
• Developed and deployed SSRS reports (RDLs).
• Managed permissions in SSRS.

Production support:

• Monitored production systems using SQL SENTRY, Perfmon, SQL Profiler, XEvent Profiler etc.
• Managed SQL Instances on-prem and Azure (IAAS, PAAS).
• Created and maintained SQL Inventory to increase DBA productivity by 80%.
• Handled Capacity Management and proactively addressed capacity issues.
• Created centralized system for database maintenance activities like reindexing, fragmentation calculation and storage, which helped reduce DBAs work by over 75%.
• Setup and maintained Transaction Replication for VLDBs using multiple publications which reduced replication downtime by 8 to 10 times.
• Strategized backup and recovery projects.
• Supported Disaster Recovery projects.
• Setup Always On, TLog shipping and database mirroring for farm of SQL databases.
• Converted int to bigint datatypes on many large tables efficiently to successfully keep up growth of data.
• Resolved problems, improved operations and provided exceptional service.

Automation and Programming:

• Created C# tools to automate database maintenance activities for orchestration and parallelism.
• Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
• Developed SQL Trace loading process using C# and that reduced load time and production performance analysis by over 24 hours.
• Developed C# tools for loading XEvent profile data.
• Developed CRUD generator using C#, which was proposed and implemented for multiple application team to standardize database development practice.

Leadership and Management:

• Automated database deployment process by proposing C# tool, managed offshore team to get it developed and deployed.
• Coordinated and supported Offshore database team.
• Lead database team.

Data Architecture:

• Redesigned part of their health care application to increase efficiency by 65%
• Supported new projects on open-source systems

SQL Optimization:

• Optimized SQL procedures to improve them by over 99.8%, which saved hardware capacity by 65%.
• Analyzed SQL trace data, XEvent Data, DMV info and SQL query plans to identify slow queries and bottlenecks, and optimized them by adding/modifying indexes, rewriting queries and changing tables design

Production support:

• Monitored production systems using Perfmon, SQL Profiler, XEvent Profiler etc
• Managed SQL Instances on-prem
• Created and maintained SQL Inventory
• Managed database maintenance activities like reindexing, fragmentation calculation and storage
• Strategized backup and recovery projects
• Setup and maintained TLog Shipping.
• Resolved problems, improved operations and provided exceptional service.

Automation and Programming:

• Migrated SQL data to MongoDB by developing C# tool

Data Architecture:

• Demonstrated leadership skills in managing projects from concept to completion.
• Helped coordinate full system life cycle from requirements to design and implementation.
• Designed data models for complex analysis needs.
• Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Generated customized architecture specifically optimized for several database technologies.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
• Created Partition solutions for large tables, including customized lookup sharding strategy
• Revamped incomplete database archiving project and archived several 1000s of orders and order-children data.
• Collaborated with cross functional teams like Release Management, Certification team, Business Intelligence team and development team making recommendations which improved overall efficiency by 35%.

Data governance and security:

• Conducted impact and risk assessment on data management project, identifying security model risks, SQL injection risks and sensitive data exposure risks.
• Managed identification, protection and use of sensitive data..

SQL Optimization:

• Optimized SQL procedures to improve them by over 99.8%, which saved hardware capacity by 40%
• Analyzed SQL trace data, XEvent Data, DMV info and SQL query plans to identify slow queries and bottlenecks, and optimized them by adding/modifying indexes, rewriting queries and changing tables design

Data warehouse and Business Intelligence:

• Developed and deployed ETL processes using DTS
• Designed DW databases using star and snowflake schema.
• Built SSAS cubes.
• Developed and deployed SSRS reports (RDLs)
• Managed permissions in SSRS

Production support:

• Monitored production systems using Perfmon, SQL Profiler etc
• Managed SQL Instances on-prem
• Created and maintained SQL Inventory to increase DBA productivity by n-fold.
• Handled Capacity Management and proactively addressed capacity issues.
• Setup and maintained Transaction Replication.
• Strategized backup and recovery projects
• Supported Disaster Recovery projects
• Setup Always On, TLog shipping and database mirroring for farm of SQL databases.
• Converted int to bigint datatypes on many large tables efficiently to successfully keep up growth of data.
• Resolved problems, improved operations and provided exceptional service.

Automation and Programming:

• Created C# tools to automate database maintenance activities for orchestration and parallelism
• Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
• Developed SQL Trace loading process using T-SQL

Leadership and Management:

• Coordinated and supported Offshore database and appdev team.
• Lead database team.

Data Architecture:

• Helped coordinate full system life cycle from requirements to design and implementation.
• Designed data models for complex analysis needs.
• Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Generated customised architecture specifically optimised for several database technologies.
• Identified and automated business processes to save company cost of 2 full time contractors.
• Collaborated with cross functional teams like Release Management, and development team making recommendations.

Data governance and security:

• Managed identification, protection and use of sensitive data..

SQL Optimization:

• Optimized SQL procedures to improve them by over 99.8%
• Analyzed SQL trace data, sysprocesses to identify slow queries and bottlenecks, and optimized them by adding/modifying indexes, rewriting queries and changing tables design.

Data warehouse and Business Intelligence:

• Developed and deployed ETL processes using VB 6 and special string parer library for web analytics projects.

Production support:

• Monitored production systems using Perfmon, SQL Profiler etc.
• Managed SQL Instances on-prem.
• Handled Capacity Management and proactively addressed capacity issues.
• Setup and maintained Transaction Replication..
• Strategized backup and recovery projects.
• Setup TLog shipping for farm of SQL databases.
• Resolved problems, improved operations and provided exceptional service.

Automation and Programming:

• Created and supported VB 6.0 tools to automate for content management and web analytics ETL.
• Designed internal process improvements to automate repetitive tasks, shortening data delivery times.

Production support:

• Managed SQL Instances on-prem.
• Handled Capacity Management and proactively addressed capacity issues.
• Handled backup and recovery of databases.
• Resolved problems, improved operations and provided exceptional service.

Automation and Programming:

• Developed tools in VB to support and customize their ERP data for HR and Finance modules.
• Implemented/Customized Ramco’s indigenous ERP system called Marshal for their Finance Department
• Developed several reports for accounting like aging reports, payroll reports etc.

• Completed professional development in Financial Analysis and Financial Management