ONKAR MANDLEKAR

El Segundo, CA ***** Email: adcltd@r.postjobfree.com

www.linkedin.com/in/onkar-mandlekar-415378141/ Phone No: 213-***-**** Summary

12+ years of experience in database development.

Ability to design and implement high quality, maintainable, and robust database solutions for applications.

Strong knowledge of designing integrations, ETL, EDI, reporting and performance tuning.

Strong communication skills and an ability to collaborate with technical and business stake holders.

Extensive experience in designing database solutions for e-commerce and supply chain.

A genuine team player with experience of working with several successful AGILE teams.

Skills

Data modelling, Data warehousing, Microsoft SQL Server, MySQL, Redshift, T- SQL, SSIS, SSRS, SSAS, SQL Profiler, OLAP, OLTP, Python, JavaScript, Boomi, Crystal Reports, Tableau, Red Gate Tools, EDI

Education

Masters of Computer Science Dec 2006

University of Southern California, Los Angeles CA

Bachelor of Engineering (Computer Engineering) May 2004 University Of Mumbai, Mumbai, India

Work Experience

Branded Online — Sr. Database Engineer July 2018 – Current Supported 2 separate order management systems. A legacy system with SQL Server and an open source OMS, ‘Moqui’ with a MySQL database. Developed an ETL process to sanitize customer sensitive data & consolidate production, transactional MySQL data for further data analysis/warehousing. Developed a data migration process between the two OMSs by mapping the two data models. Used JSON format.

Onestop Internet Inc. — Sr. Database Engineer Dec 2010 – July 2018 Architected and implemented the schema and database solutions to support e- commerce websites and the supporting tools. (SQL Server, T-SQL, Redshift) Designed and implemented several data integrations and migrations using T-SQL, SSIS, Python, EDI, and Boomi.

Developed a data warehouse and an ETL process to support it. (SQL Server, AWS Redshift, Python)

Designed & implemented a fulfillment process integrating the OMS with a WMS. Redesigned the billing engine of the OMS to more intelligently support AUTH\SETTLE.

Built and maintained tools to Import\export product and transactional data. Developed several reports using SSRS and Tableau.

Supported major client websites like The Frye Company, True Religion, NYDJ, Katy Perry, 7 for all Mankind, Lyca Mobile.

Troubleshooting and performance tuning of SQL Server/database issues using SQL Profiler, Spotlight.

Collaborated extensively with developers, product owners and offshore teams. Motek/AFS Technologies — Software Engineer Feb 2007 –Nov 2010 Design and implement solutions for the Warehouse Management System (‘Priya’) and its web based applications. – (SQL Server, VC++, Python) Managed and trained an offshore development team.

Designed data interfaces between ‘Priya’ and several host and routing systems. Marshall School of Business (USC) - Database Developer Mar 2005 – Dec 2006 Aggregated contact information of over 100k users from 20 source databases. Restructured the schema for data consistency and rewrote all relevant processes in order to make the application more dependable – (SQL Server) Rewrote the process for account creation of graduate and undergraduate students. National informatics Centre (Branch of the IT ministry of India) – Internship 2003-2004 Financial accounting system (FACTS) SQL Server 2000, Visual Basic 6.0, Crystal Reports V9.0