Sandeep K. Badade PMP

Experience

• 

  Inference Systems Ltd

  Jan 2001 - Mar 2002

  Software Developer

  Pradnya Brokers BackOffice (Capital Market)The Objective of this project was to give a single web based solution to the brokers for his various BackOffice processing in Capital Market Segment. It’s a one-client internet to n-client Intranet BackOffice system (Web Based) for stock brokers for various Exchanges (NSE, BSE, NSEFO, and BSEFO). Worked as application developer.

• 

  Advent InfoSystems

  Dec 2004 - May 2006

  Software Engineer

  As it was a small scale company, I got chance to work in each phase of software life cycle. Involved in requirement analysis, used Data driven Architecture, extensive use of XML for hierarchical data, Data modeling and database design, batch processes using DTS and ActiveX VBScript, SQL Code optimization, Query tuning.This product for HIPAA (Health Insurance Portability and Accountability Act) is developed for the Health Care Industry of U.S.A. TransValKit parses an EDI transaction and shows errors in file, user can correct those and revalidate the file. • Performing the project startup activities including preparing the project startup documents at offshore.• Requirement analysis and creation of requirement analysis document.• Data driven Architecture.• Extensive use of XML for hierarchical data.• Use of Rule based engine.• Data modeling and database design.• Database development, Designing and developing batch processes using DTS and ActiveX VBScript, SQL Code optimization, Query tuning.• Ensuring adherence to Quality standards.• Leading and mentoring a team of developers.• Project status tracking and reporting.• Attending regular software quality audits including the Monthly, Quarterly and Delivery audits.• Tracking and resolving Project related issues.• Software Configuration Management using VSS.• Product Deliveries. Show less

• 

  Cognizant

  May 2006 - Nov 2009

  Associate

  SQL Server Developer DBA, Onsite Coordinator• Database Dev and DBA support for projects like IPM_LossShare, ELMOLite, AVIS Phase2• Servicing Data Mart• AVIS ELMO• SQL 2000 to SQL 2005 Database Upgrade Project • Database Bundle Development / Enhancement • Database Archiving• Loan Sales and Settlement Automation• SWAT Code Review & Performance Tuning

• 

  Fiserv

  Nov 2009 - Dec 2013

  Project Lead

  SQL Server Developer DBAProject Lead for Application Support Team / DBA Technology Management Group.BillMatrix® payments product has Web, mobile, IVR and agent-assisted payment functionality to meet customers at their bill payment points of preference while keeping costs under control.• Involved in requirement gathering discussion with clients, design discussions with team lead and architects.• Involved in building a new architecture for new clients on boarding.• Creating database objects tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and maintain data efficiently. • Ensured data integrity by developing triggers to insert or delete child records from master tables. In case of a deletion, the record would be moved intact to an archive table or be updated with a deleted flag.• Created DB scripts for new product features, client implementations and maintenance.• Performance tuning of existing database objects and stored procedures.• Created and designed reports for users in different departments in the organization using SSRS.• Developed SSIS packages for new clients data migration, incremental and full load user accounts import into DB.• Writing SQL Interfaces (Stored Procedures, Functions & Packages) for Data migration.• Responsible for Autosys scripting to generate EOD reports and files transmission to SFG.EPS Stabilization is the effort taken at BU level to stabilize all the core components of the system in terms of stability, increase performance, gain more business. Developed OD Import/Export SSIS package framework which was helped for multiple customers Smart Connection is a point solution framework provides a structured way to handle all transaction requests from different sources. It’s a complete package for Online/Offline payment processing. Worked on development piece and support for the product. Show less

• 

  ADP

  Dec 2013 - Dec 2014

  Technical Consultant

  • During my tenure many technical initiative stared by me which helped product from negative revenue to around 15 million dollar. Saved one of dying product to profitable. Was able to retain many key client with some real hard work and took right decision and right time.• Designed, Architected and executed one of most technical difficult project call Store migration.• Store migration project was huge success and got appreciation from highest CXO committee. As it was most highly visible and impact full project.• One of highest rating in first year of joining by new hire at senior level. And globally top 1% of performer. Show less

• 

  CDK Global

  Dec 2014 - now

  • Currently heading new Technology Initiative by CDK Globals in Data and Analytics Area. Overall I am having more than 15+ years of experience for managing, architecture and building highly scale able, mission critical, distributed applications. Spend majority of career in scaling enterprise product. Instrumental in bootstrapping the idea into product. Shaped up couple of acquisitions like ServiceEdge, Dealers Dashboard from scratch starting from understanding product, setting up technology stack, design, architecture and ramping the team. Have a understanding on industry best practices like Big Data, Hadoop, REST, Micro Services, DevOps, Domain Driven Design, API Driven Development, Containerisation, Cloud Native app stack and Behaviour driven Development. Working on many cloud technology like AWS(Amazon Web Services).• Have experience managing and running agile team across demographic. Worked as developer, Scrum master, proxy PO in the agile environment and managed sprint ceremonies for 1/2 weeks sprint.• Instrumental in setting up teams from scratch for different acquisition product. Right from resource hiring, setting up architecture, designing, applying best practices etc. Work at ground level with team and very much hands on.• Have right blend of technology, product and people management skills. Had a proven track record of setting up very high performing team.• Accountable for development, production support and implementation related activities.(Planning, design, development and release management)• Worked on different industry from Startups, Services and Product MNC. I build team, product and future leaders.• Playing a vital role of intermediate between clients and management by participating in strategic planning discussions to determine the scope and objectives. Show less • Responsible for Backend of India R&D and delivery operations of one of mission critical and key product line in Service Retail and Fixed Operation workflow for CDK global Dealer Management Product Suite. It is one of leading product in Auto mobile dealership Market in North America.• Shaped up ServiceEdge from scratch starting from understanding product, setting up technology stack, design, architecture and ramping the team.• Fully involved in Database Engineering activities with emphasis on OLTP & ETL design and development.• Architected and implemented a complete home grown, flexible, lightweight solution for Service Edge Reporting Database. This in-house solution has replaced the existing native Transactional Reporting which is not only is robust and scalable but also reduces any kind of maintenance overheads. This solution used and appreciated by 1000+ happiest Dealers.• Lead database architecture initiatives.• Leading and managing variety of database projects including migrating large high volume and transaction tables to support big numbers.• Database review, Performance and Optimisation (SQL and Database Optimisation)• Define and enforce database standards and best practices for database design and development• Review database design changes with the team to determine impact to the database.• Mentor and educate other members of engineering on database technology & best practices.• Collaborate with Chief Architect, Technical Architects, Technical leads and Product analysts on the overall architecture, design and development of the SMART Product.• Collaborate with the ETL/Reporting developers to define the development path for DW/Reporting.• Monitor Production & Development database and SQL Server performance. Show less

  • Senior Engineering Manager

    Jun 2021 - now

  • Engineering Manager

    May 2017 - Jun 2021

  • Database Architect

    Dec 2014 - May 2017