Jayaprakash Thirumalai

Senior Software Engineer

JK Tutorials•  August 2020 - Present

• Python Core Programming - linkedin skill certified, in the top 30% percentile. Data Types, Identifier, Tokens, Flow Control, Functions, Iterators, Generators, Exception Handling, File handling concepts, Data Structures and OOPs Concepts. • Data Science using R - Data Manipulation, Data Wrangling, Data Visualization, Statistical Analysis/Probability, Linear and Logistic Regression, Confusion Matrix, Decision Tree, Random Forest, UnSupervised Learning, Associate Rule Mining/Apriori/Recommendation Engine, Time Series, Sentiment Analysis. • Google Cloud Platform Fundamentals: Core Infrastructure, Essential Google Cloud Infrastructure Foundation – Coursera certifications • Linkedin skill certified in t-sql – in the Top 30% percentile • Working towards certifications in advanced python, data science, data engineering and cloud architect (Azure, AWS, GCP) • Technology Guidance and Tutoring young graduates

Senior Software Engineer

Aspen Dental•  August 2018 - July 2020

• Lead a four-member ERD team for an Enterprise Health Care Management System that includes Data Integration, Data Profiling, Data Migration(ETL), Enterprise Data Management, building a relational Database Mapping, Data Quality and Cleansing, Data Dictionary, Source to Destination mapping using complex transformational rules, Building Data Model(ERD) using ERWIN , Building Release notes, developed SQL programming standards, Developed Before and After migration sql scripts. Database Design, Development and Database Administration using Microsoft SQL Server 2017. • Managing Customers – Project Management, Tracking deliverables, daily Customer/SME/SCRUM meeting, discuss potential issues, its impact, propose changes and Presentation. • Migrating (ETL) an entire Product from AS400 , Access … to a Microsoft Technology stack using C#, .net core in the middle tier and the backend tier SQL Server 2017. The frontend is Angular. • Performance Tuning and Optimization, managing all database objects including indexes. • Storing the files in DropBox for sharing. Taking the database from DEV to QA to UAT to Production. • Automated a complex creation script generation using the Data Mapping sheet from Excel

Senior Software Engineer

JK Tutorials•  January 2015 - July 2018

• Technology Guidance and Tutoring – Guide Fresh Graduates, people wanting to move int IT, Python using IDLE/SPYDER/PyCharm/VSCode, Operational DBMS, Data warehouse using SQL Server ,tutoring in Data Science, Cloud Computing, C++ using Code Blocks, Java using Eclipse, Agile, Software engineering, Computer architecture and computer networks. • Accomplished Certifications - see at bottom, from Coursera (IV league schools) in Google Cloud, Python , from IBM in Big Data. • Recommend right hardware/software for the digital consulting services, technology training and building web sites. Recruit and Manage Tutors. • Working towards certification in Data Science, Machine Learning, Big Data, Python, R, PowerBI, MSBI, Mongo DB, AI and Deep learning with tensor Flow. • Building websites https:/t/prrsons.wordpress.com/ , https://vaanamprinters.wordpress.com/ and worked on final year projects for CSE students

Senior Software Engineer

Imprezzio•  August 2013 - December 2014

Lead the effort using SQL Server 2012 /2014 - • Developer – Design and Develop Big Databases, Data modeling, Table/Index/View/sproc/triggers, SQL Tracing, Index Mgmt, Missing, unwanted Indexes Report, Timeout Queries, source control, communication , presentation Agile Scrum and DevOps. • Sr DBA - Always On DB, Performance Tuning, Database Backup, Perfmon Data Collection, Automation, Database Mail for - Monitoring and Alerting –, Blocking, Open tran, Deadlock, CPU intensive queries, Distribute Big data evenly across spindles to improve performance.

Software Engineer

Expedia•  September 2009 - September 2011

Database Design, Development and Administration, Build and Deploy, DevOps, Agile Scrum, Automation of monitoring growth and alerting using SQL Server. Using SQL Trace. Manage T-SQL. Using DevOps tools to integrate from, development to operations deployment. Performance monitoring and Tuning.

Product Manager

Yahoo!•  January 2007 - September 2009

• Managed a next generation Big Data Postgres-SQL API, BigQuery/Cassandra like Columnar- peta byte Database Product https://ligadata.com/ . Data Warehouse Cloud DB that improved performance 20X and had the potential to save $ 4 million using commodity hardware. • Built the Reporting platform that integrated Yahoo! Search Metrics and Display Ads to provided key metrics page views, CTRs, segments …etc. • Evangelized & signed up 4 customers for the Alpha/Beta program • Built Product Roadmap, Managed Customers, Customer Positioning/Messaging and Presentation • Gathered Product Requirements (PRD), Use Cases, Data Feeds, Data Mapping, Data volumes, define and track SLA and deliverables on Dashboard • Orchestrated- Product Development, status meeting, Testing, Deployment and Documentation. • Conducted Product Training to 30 people at a time. • Zune Market Place and Zune BI – Big Data Ingestion Pipeline Monitoring and Alerting Automation, • Zune BI reports- Data Analytics(OLAP), Excel and Portal reports, deploying SSIS and SSAS packages. Database administration of Zune BI databases. • Architect , Develop and deploy a BI Dashboard for the Surface User Research team to improve user experience. • Gather requirements from business users, Architect, develop logical and physical model, wrote functional/ tech specs, develop ssis package, develop olap cubes, ssrs reports, pps/ProClarity reports on share point portal. • Built a DW database that improved and integrated Customer satisfaction scores worldwide. • Gathered Data and UI requirements, developed logical and physical model, ETL using XML & XSD, Developed Functional Specs, developed SSIS packages and OLAP cubes, SSRS/ProClarity reports.

Senior Software Engineer

Expedia•  September 2003 - December 2007

• Secured Expedia data - A $2 million data hashing & encryption project on OLTP and data warehouse touching 40 databases, 120 tables and 3 TB worth of data. • Implemented and verified Disaster Recovery procedures for more than 30 sql servers. • Deployed Clustering for HA & Replication for scalability of heavy transactional queries. • Proactive Monitoring and Alerting – of Performance, Availability and SLA metrics • Designed Logical, Physical data models, Create database, tables, views, sprocs, and triggers. • Streamlined and Improved Backup/Recovery Procedures. This improved Availability and saved cost. • Led a database engineering project to improve stability, availability and performance - Upgraded 70 odd SQL Servers to Windows 2003, eliminated bad query plans, online index maintenance improved performance of SQL Servers by 40 %, Improved availability and Increased Capacity for future growth. • Rolled out multiple Release of Database versions on the live site as well as EDW, developed Jump start document, Automated SQL Build. • Led the effort in Integrating Expedia and Hotels.com Lodging DB Platform – a $ 5 million complex project. • Deployed a Big Data DW effort that Reduced ETL time to 4 hours, improved performance by 30% for an .enterprise wide data warehouse solution • Built a Tool that Eliminated 20% live site issues an Instant Sales Data Capturing, Performance Monitoring and Alerting system each LOB and PoS. • As Sr. DBA Led the deployment of a new Enterprise Data Warehouse/BI initiative.

Senior Software Engineer

Microsoft•  June 2000 - September 2003

• Create - Logical, Physical data models, database, tables, views, sprocs, and triggers using SQL Server. • Monitoring, Alerting, Performance tuning, Replication and SQL Clustering. • Program Spec, test Plan to Develop and Manage C++ code using MVC. • Implemented Disaster recovery and business continuity procedures for a sleuth of Projects. • Identified critical SQL Server Bugs and had them fixed (SQLMail corruption, back up failure, memory leak) • Rolled out a Server and database Consolidation project that saved $300,000 annually for Microsoft • Led a migration of an enterprise wide application from SQL 6.5 to SQL 2K on 30 odd SQL Servers • Spearheaded the deployment of an Enterprise wide Database intensive Issue tracking system for 40,000 users, 3000 databases and 50 odd SQL Servers. • Pioneered an Automated tool to create sql databases. This saved 120k per year for Microsoft. • Deployed a Data warehouse Project to track user clicks using SQL Server Analysis services. • Retired an enterprise wide application that archived 3000 databases, 28 sql servers and saved $500,000 for MS. • Interviewed and Hired Team members. • Deployed a Data warehouse solution for Online Crash analysis.

Software Engineer

Infosys Limited•  August 1993 - May 2000

• As a SQL Server DBA (Consultant) Barnes and Nobles Jamesburg, NJ. • As a Systems Manager. Using Visual C++ and SQL Server. Customers - GE, Schenectady NY and GE, Ft. Myers FL. • As a System Analyst Infosys Technologies, Bangalore, India. Using Visual Basic and RPG. Customers - Nestle Switzerland, GE Connecticut and Reebok France.

IISC, Bangalore (Indian Institute of Science)

Mathematics, M.Tech•  August 1989 - July 1993

As a Metallurgical Engineer

University of Madras

Mathematics, BS•  July 1986 - June 1989

BS in Mathematics