Data Management

Naren Deshpande

Email: *****.**@*****.*** Mobile: 404-***-****

Landline: 858-***-****

I seek a challenging position that will enable me to utilize my strong technical and leadership skills and play a key role in the architecture, design and delivery of business solutions.

SUMMARY OF QUALIFICATIONS

Extensive experience:

20 years of IT experience with an excellent track record in architecting and designing robust business solutions.

Domain expertise in OLTP/Data Warehouse, CRM, ERP systems (Manufacturing, Financials), Logistics, Telecom/Wireless, Semiconductor, Defense.

Proven Track Record:

Built high performance teams, managed large projects successfully.

Excellent communication skills and creative problem solver.

Technical Qualificiations

Oracle Certified DBA. Data Modeling and Solution Architecture expertise. Object Oriented Design. Oracle Expertise. Sybase, SQLServer, MySQL, Postgres experience. Technical Project Management.

SQL, PLSQL, Korn Shell, Perl, Java, C, C++

SKILLS

Domains

OLTP/Data Warehouse, CRM, ERP systems (Manufacturing, Financials), Logistics, Telecom/Wireless, Semiconductor, Defense.

Platforms

Unix (Aix, Solaris, HPUX), Windows NT/2000/XP

Software

Oracle 9iAS Application Server, J2EE, JSP, JSTL

Languages

SQL, PL/SQL, T-SQL, Java, C, C++, Unix Shell, Perl, HTML

Databases

Oracle, SQLServer, Postgres, Sybase, MySQL

Tools

TOAD/SQLNavigator, DB DeZign, OEM, Eclipse, Jdeveloper, ER Studio, GIT, Visual Sourcesafe, CVS, CMVC/6000, Visio, QuickRestore, Syncsort,

EDUCATION

M.S., Computer Science, Clemson University, South Carolina, U.S.A

B.S., Electrical Engineering, Mysore University, India

PROFESSIONAL ACCOMPLISHMENTS

Data Architect, Epsilon Inc., San Diego 2017 - Present

Analyzed data quality issues causing operational inefficiencies leading to customer dissatisfaction and burnout of production support personnel. Designed Operations Insights/Data Quality Management Solution for Operations Support and BI. Implemented data extract programs.

Implemented an automated ETL solution in Oracle/PLSQL to process automobile customer, sales and service data for over 3000 auto dealerships in the US on a 14TB database. (2013-2014)

Director of Software Engineering, XCM Solutions, Boston/Bangalore 2016 – 2016

Managed the development for XCM Solutions of a SaaS based tax/accounting workflow product and an IT staff of 30 technical professionals. Hired skilled professionals, built a High Performance team by setting up clear performance goals and following agile practices; reduced attrition rate and improved employee morale with clear goals, metrics and incentives.

Architected data archival strategy, implemented web-based work scheduler to schedule the work load of CPAs in the US and India. Reengineered Data Integration projects for robustness and manageability. Initiated data warehouse design to implement BI Reporting.

Solution Architect/Technical PM, UvaMobile Inc., San Diego, CA 2014 – 2015

Architected a cloud based mobile-friendly web application for a prepaid wireless service provider, UvaMobile, Inc to manage online signups, subscriber account management and dealer portal. Primary Business Analyst/Data Modeler for around a 100+ table database, subscriber life cycle management, inventory management for vouchers and SIMs. Implemented ER diagrams, Use cases, functional specs and pseudocode for the middle tier logic.

Managed a seven-member development team.

Founding Member/Solution Architect, Odyon Inc, San Diego, CA 2012 - 2013

Architected data model and designed solution for a calendar based mobile application on IOS for task and event management, project management and real time scheduling.

Solution/Data Architect, Simple Mobile, Irvine, CA 2011 - 2012

Architected and implemented Enterprise Operational systems for a leading MVNO company with over a million customers and revenue of over $700M

Architected SIM-Voucher Supply Chain Management Portal to manage Simple’s SIM/Vouchers over their life-cycle – Order Entry, Inventory Control, Receiving, Distribution and Reporting.

Designed CDR based reporting for voice and data usage reconciliation between MVNO and the carrier (T-Mobile) and identification of high usage/fraudulent subscribers.

Implemented Revenue and Tax reporting for online digital card, customer support and IVR credit card payment channels and aggregate reports based on zip-code.

Solution/Data Architect, Leap Wireless (Cricket), San Diego, CA 2006 – 2011

Architected and implemented Voucher Management application, rule-based Master data/reference data portal. Managed the reengineering of the enterprise data warehouse ETL. Built an archiving solution based on data-driven table partitioning and ensured timely daily score-card report.

Created Master Data/Reference data portal for Revenue Accounting and Revenue Assurance using rule-based Data validation & cleansing, reducing the month-end closing from 25 days to 5 days.

Implemented Voucher Management System for over 5 million subscribers with revenue over $1B.

Created Revenue Assurance reporting engine to augment third-party reporting (Chesapeake) to handle dynamic fees and commissions for APL (Alternate Payment Locations) vendors. This flexible solution enabled reporting to adapt to fast-changing business requirements quickly and reduced development/operational costs over 50%.

Data Architect, Syntricity, San Diego, CA 2005 - 2006

Enhanced semiconductor data warehouse application providing reports and visualization for web-based yield analysis and management. Designed and implemented a partitioning strategy for several large tables holding semiconductor wafer and die test information. Developed utilities to generate DDL for managing table partitions. Tuned several reports for performance for quicker response times.

Technical Manager/Architect, Perot Systems, Bangalore, India 2005 - 2005

Managed development team for a data migration project to migrate data from an IDMS database to an Oracle 9i/Solaris platform for a mission-critical J2EE Financial Application. Architected and implemented the data migration process for loading data and performing data validation, transformation, and reconciliation.

Development Manager/Tech Lead, 24 Hour Fitness, Carlsbad, CA 2004 - 2005

Tech Lead for a 24 Hour Fitness’ club membership application serving over 300 health and fitness clubs nation wide. Built interfaces between CRM application and the Oracle 11i backend system. Managed the cutover process for integrating new Oracle 11i back office system with Peoplesoft HR, third party POS applications and in-house applications. Implemented No-Call list management for both state and federal lists.

Designed and implemented several questionnaires for a web-based application for a fitness personal training application for trainers to input client information into the system using Oracle JEE, HTML, Struts, JSP, JSTL tag libraries, EJB, Javascript, Top link ORM, PLSQL.

Sr. Consultant, Mitchell Inc. 2002 - 2004

Enhanced automobile claims and appraisal software - Developed PL/SQL stored procedures to service XML based queries against the claims database. Developed batch programs in Korn Shell.

Project Lead/Oracle DBA, Cayenta Inc., San Diego, CA 2000 - 2002

Project lead for a major conversion project of a very large billing system database for Atlanta Gas and Light. Administered hosted and back-office application databases. Tuned performance of around 800 shell scripts/SQL DML statements and built installer with 500% improvement.

Carried out DBA support activities for large Oracle databases. Developed key DBA scripts for archive log backup, parallel table exports, database refresh scripts, automated database cloning, etc.

Tech Lead, AT&T, Alpharetta, GA 1998-2000

Tech Lead for processing summarized local phone company CDR records for Revenue Assurance. Implemented a PLSQL based billing system to run edit checks on summarized CDR data. Built automated regression testing tools.

Designed and built an automated data-driven workflow system to process data files containing call usage data.

Project Lead, Lucent Technologies/Vanstar, Atlanta, GA 1996-1998

Project Lead for implementing a product tracking system to track the manufacturing processes involved in jumper cable manufacture on a Solaris/Sybase platform from cutting to final assembly.

Implemented a C program to process electrical parameter measurements transmiteed by Visual Basic Stations using IP*Works socket communications.

Sr. Consultant, IBM, AWD, Austin, TX 1992 - 1996

Implemented Shop Order and Shipping modules and built interfaces with Floor Control, Order Entry and Distribution modules on an Avalon ERP platform on a Sybase/Unix system.

Added upgrades to CMVC a C/Unix Configuration Management application.

Contact this candidate