SUSHIL PANDEY

• Seasoned, self-motivated and result-oriented technology leader with over 20 years of progressive technical and managerial experience in building high-performance global products and applications.
• Implementation of various multi-tier applications in a fast-track environment such as Toorak Data Platform / Prudential Digital Platform / Financial Data Platform / Order Management/ Banking product (Flexcube) and many others.
• Currently working as Principal Data Manager with Toorak Capitals, responsible for directing a highly empowered team of 10+ professionals (Data Engineers, BI developers, QA and DevOps) for building a highly scalable data platform.
• Multi-Domain expertise in Banking, Finance, Insurance and Supply Chain.
• Business value through architecture simplification, modernization, and process re-engineering.
• Communicated with business executives, to deliver the right solutions using Data Engineering, Data Analytics, Data Governance and Data Quality.
• Built successful stakeholder partnerships with teams like Marketing, Support and IT, based on communication, data-driven insights and problem-solving skills.
• Successful in building, managing and mentoring the global team to achieve organizational objectives.
• Experience in project planning and working with Agile methodologies (Sprint planning, daily scrum etc) with diverse teams.

• Cloud : AWS, GCP
• BigData : Hadoop, AWS S3, Hive, Spark, PySpark, Airflow
• Data Visualisation : Tableau, Business Objects
• Languages : Python, SQL, PL/SQL, Shell Scripting, HTML, Java Script
• RDBMS : Oracle, MS SQL, MySQL, PostgreSQL, AWS Aurora, RedShift
• NoSQL : Cassandra, Mongo DB, AWS DynamoDB, AWS DocumentDB
• Event Processing : Kafka, AWS Kinesis
• Configuration Tools : Github, PVCS Dimension 7, Flexmart, Star Team, Clear Case
• Monitoring Tools : OEM, OMD, New Relic, Splunk

• AWS Certified Solutions Architect – Associate
• Data Science Foundations: Choosing the Right Database
• DataStax Academy Apache Cassandra™ Developer Path
• ITIL V3
• ICAgile Certified Professional

Title:   Toorak Data Platform 

Environment:  AWS, ETL, Database Modeling, Delta Lake, ML, PySpark, Airflow, PostgreSQL, Redshift, Tableau

Responsibilities: 

• Designed and built a data platform using delta lake on AWS.
• Managing a team of 12 which includes a team of Data Engineers, Tableau Developer, QA and Devops.
• Work with business executives to deliver solutions that give insight from Dashboards and Reports.
• Data ingestion from various sources like files, databases, api into delta lake.
• Data validation and quality implemented via ML model and PySpark
• Implementation of Flyway as part of the CICD pipeline to automate database deployment.

Title:   Prudential Digital Platform (APAC and LATAM)

Environment: AWS, ETL, Database Modeling, Data Migration, Hadoop, Hive, Spark, Oracle, MySQL, PostgreSQL, Aurora, DocumentDB

Responsibilities:

• Designed and developed data platform on AWS and OnPrem.
• Developed the physical and logical data model for various applications and data platform.
• Work with technical product leads to design and deliver solutions that optimize use of data.
• Build a data pipeline to ingest data into data lake via batch and real time from Kafka events.
• Design and Implemented Database Migration plan from On prem Oracle to AWS Aurora.
• Tableau Dashboard Development
• Cross-team collaboration between different geo locations of APAC, LATAM and enforce best practices.
• Led the team of data engineers and devops.

Title:   FDP : Financial Data Platform

Services : Unireg, Subscription, Crash Reporter, UM, Survey, TEP, IDAudit, QBN

Environment: Oracle, MySQL, MSSQL, Cassandra, MongoDB, GoldenGate, SQL, 

PL/SQL, ETL, AWS EC2, S3, DMS, Aurora, RedShift and DynamoDB

Awards:  Star of Quarter: FY12-Q4, Service Ninja CTOF2014, 5yrs of service completion– 2015

Responsibilities: 

• Database Migration from Onprem(Oracle, MySQL) to AWS Infrastructure.
• Design and Implemented data migration with various replication technology and ETL tools.
• Database Design, Architect and Implementation (Onprem and AWS) for Mobile, FDS and Core Services by using Oracle (Biggest database size is 15TB), MySQL, MSSQL, Aurora, Dynamodb, MongoDB and Cassandra.
• Worked on ETL which was developed to refine the user data by using, api which fetch data in the form of csv files, then using sql loader data is loaded in the Oracle database. Data is further refined by PL/SQL.
• Worked with Business analyst team to implement dashboard and reporting solutions.
• Implemented multitenant database architecture.
• Query optimization and performance tuning related to application and reporting.
• Provisioned AWS services like MySQL, Aurora, DynamoDB, S3 via code by using cloud formation.
• Design and implemented multi-data center replication to support HA/DR by using Oracle Golden Gate, MSSQL mirroring and MySQL asynchronous replication.
• Actively involved with implementation of RTO of 5 minutes for various applications.
• Led a group of 5 reportees; enhanced morale, cross group collaboration and drive the best practices across organization.
• Mentor the professional development of each reportees by helping them build and execute personal development plans that map to our organizational goals.
• Handling incidents related to microservices by involving IOC end to end, being part of root cause analysis and suggesting architectural and process improvement to avoid issues in future.

Title: Distributed Order Management

Environment: Oracle 9i, 10g & 11g in AIX/Linux, DB2 UDB V9.5, SQL, PL/SQL, Clear Case, TOAD

Responsibilities: 

• Oracle and DB2 software installation and applying patches.
• Involved in DB Creation, Datafile Sizing, Backup, Maintenance and Migration.
• Assisting Development/QA/implementations teams.
• Assisting developers to optimize PL/SQL code and Query Tuning.
• Delivery of DB scripts for the product.
• Leading team of 3 DBA which supports Oracle and DB2, staff development and share the best practices across organization
• Recruit and hire talented DBA

Title: Land Transport Data Warehouse  : Apr.2006 – Sep.2006

Migration and Support of UNISURE : Apr.2005 – March 2006

Environment: Oracle9i, SQL, PL/SQL,SQL*Loader, Windows-NT, UNIX, PVCS Dimension, Toad

Responsibilities: 

• Analysis of a fault or enhancement.
• Developing or modifying database designs for fault, enhancement or new application.
• Application coding, unit testing and integration testing of fault, enhancement or new application.
• Deploying and confirming all supporting administrative tasks that ensure the application running properly in production.

Title: Implementation of Flexcube Corporate VERSION FCC4.6, Sep. 2004-Mar.2005

Implementation and Support of Flexcube Corporate FCC 4.0, 4.5, Oct. 2002-Aug. 2004

Development of Flexcube Corporate (MAIN) 4.3, 4.4, 4.4.1 and (CITI) 4.0, 4.1 release, Apr. 2001- Sep. 2002

Environment: Oracle8i/9i, Developer 2000(Forms 6i), SQL, PL/SQL, Windows-NT, UNIX, Business Objects 5.1.7

Responsibilities: 

• Impact analysis of new module UDF in all other modules.
• Analysis of the enhancement requests related with batch number.
• Development and enhancement of programs both front end and back end.
• Guide other team members about new module UDF.
• Unit, Integration and system testing.

Title: Development of www.joyn2win.com, Duration: Oct. 2000- Jan. 2001

Development of www.ecsteelindia.com and www.jmatri.com, Jan. 2000- Sep. 2000

Environment: Windows NT, HTML, ASP, Java Script, NetObjectsFusion, MS Access2000

Responsibilities: 

• Design Web Pages with ASP, Java Script and database is MS Access2000
• Hosted and maintenance of both of these sites which were on NT/Linux Server