MAHESH VAKHARIA

Resi: 416-***-**** Cell: 240-***-****

Summary:

20+ years of experience, providing comprehensive & cost effective solutions to leading enterprise businesses in Finance, Manufacturing, Insurance, Healthcare, Retail etc. Served in various capacities as Project Manager, Delivery Manager, Lead Architect, Automation Engineer, Business Analyst, Manages Service provider, System Analyst and Sr. Developer.

Expertise in various phases of end-to-end Project management, SDLC including facilitation to PMO, Steering Committee advisory, business case presentation, technical architect, prototype and pilot project setup, requirement analysis, process diagrams, data models, analytical analysis, SOW, budgeting & forecasting, risk analysis and management, issues and change management, quality and performance analysis, release management etc.

Experience:

Cognizant Technology (Project manager, Lead Architect) SEP 2013 – FEB 2017

- Corelogic, Jenark Property Management - Manage Service Lead, 250 clients across USA – Automated scripts for agile

change management reporting, training plan and scheduling for offshore resources, defects tracking, issues management,

providing alternate solutions for source control & release management of 250 production servers.

- AXA – Mexico BigBang Migration Project Manager, facilitate RFP, RFI, RFQ and POC for landscape of 250 databases,

50 projects for Auto, Home and Health Insurance applications, analytical analysis and inventory of 90,000 programs

and 450 interfaces & automated scripts. Budgeting, T&E estimates and engagement management.

-JP Morgan - Lead Business analyst - Loan Origination application maintenance, enhancement, DevOps Lead - Automate Build and Deployment - Dev, QA and UAT automated daily Release Management Schedules, Jenkins and Jack daily deployment, artifact uploads and setup and configuration revising automated scripts for full release cycle on various platforms

- Franklin Templeton – Project Manager - Data Integration for K2 Mutual Funds, automate daily uploads for Positions,

Security Masters, Daily Transactions, Fund level Financials, Swaps etc,

Control-M scheduler configuration, setup and implementation for processing 8 daily uploads

- Northern Trust – Project Manager, Lead for the Robotic Automation with BluePrism. POC engagement, PMO facilitation,

Steering Committee advisory, Budget forecasting and ROI estimations, project planning, scheduling and implementation

for three major applications

- Cigna/QANI – Project manager, multiple projects, vendor management, 16 reports rollout for Cigna & QANI integration

Claims management, subrogation claims recovery, Cobra facilitation

- Technologies used: Open Edge 8 - 11.2 4GL, Gui, ADM2, App server, SAX complex XML processing, Jenkins, Jack,

Control-M, BluePrism, .Net VB,

Caidan Management Inc (Meridian), Detroit, Michigan (Consultant) OCT 2012 – JUL 2013

- Project Manager - Hedis analysis and support, implemented project for new measures supplemental data, DM

stratification, analysis and reports for Asthma and Diabetes and Well child care,

maintained Hedis real-time sample member reports

and fusion charts for different line of business using automated Planet press pdf process.

Developed application to centralize call center monitoring and reporting.

Lead the Agile development and implementation with Business Analyst, QA, and UAT testers, using Jira for agile

repository and change management reporting.

- Lead Production/Application support and maintenance for Members, Providers, Disease Management, Claims processing

- Technologies used: Open Edge 10-11.2 4GL, Gui, ADM2, App server, Linux, SAX complex XML processing, Planet press

IFDS (Canada) Ltd. ( DST Systems, State Street ) Toronto, Canada (Tech Lead, manager ) JUN 2011 – OCT 2012

- DST-CORFAX-iFAST insured and classic Segregated Funds back office processing, transfers, exchange, maturity, fees,

Commissions, top ups, guarantees enhancements – Lead the requirement analysis, design, resource allocation, agile testing with QA off shore team, risk & defects management and svn release management.

-Project Manager - Batch, scheduled and automated cycle interfaces development for various extracts and uploads with Fund serve, FASAT and clients databases for daily and schedule updates for reconciliation, database sync.

- Setup and configured in house developed tools to automate databases management

- Technologies used: Progress 10.2 4GL, Char, ADM2, App server, Linux, Win Runner, Agile

SDD Inc. Delray Beach, FL (Consultant) MAY 2011 – JUN 2011

- Lead Broad soft PBX Cloud portal 4gl interfaces, maintenance enhancement for PMS (Property Management System) using

4GL socket, complex xml, soap web services, asynchronous App server calls on multi-tier platform

- Project manager - Watchdog automation application development for real time monitoring of processes and services,

automated two new processes Http Listener and Minibar transaction processing application

- Technologies used: Open Edge 10.1c 4GL, Web speed, 4GL Socket Soap Web services, App server asynchronous calls

Brave Point Inc., Atlanta, GA (BI Consultant) JAN 2011 – APR 2011

- Logi XML 10 Sales & Inventory Data warehousing, BI development for A/R, A/P and Sales drill down analysis, reporting

with Heat Map charts, selectable Scatter charts, Analysis grids, Crosstab reports, schedule outputs in excel, cvs, pdf, word,

Xml and advance features like local search, alphabetical navigation etc. using Jason, JQuery automated libraries.

-Web speed interface development and implementation for Money Penny Payroll application with Profit Zoom Accounting

Application.

-ADP Corporation, maintenance for automated EEV – Employment Eligibility Verification enterprise web services with DHS (Department of Homeland and Security) and SSA Web service request and response maintenance for Employment approval etc.

- Technologies used: Open Edge 10, Web speed, JQuery, DHTML, Jason, Logi XML 10

Astro Exports Inc. Toronto, Canada (Consultant) JUL 2009 – MAR 2010

-Design and developed documents management system for AutoCAD drawings and design specification in Web speed 3.1

-Ticket City affiliate program implementation with XML Web services to display available tickets for popular

Events using PHP, CURL, XSLT, Java script and AJAX enabled shopping cart

- Technologies used: Open Edge 10, Web speed, PHP, Linux

Data Business Forms (Data Group), Toronto, Canada (Sr. Analyst/developer) DEC 2008 – MAY 2009

-Help lead and facilitate design and implementation integration matrix, cross site considerations, development and production roll out common custom ERP application modifications and Internationalization.

-Analyze, developed, and monitored agile testing and production rollout of 15 major ERP reports automated translation to French.

-Implemented Pearl scripts enhancements for UNIX char report framework for Excel and Pdf reports in French.

-Monitored vendor software releases to identify changes affecting Web speed report framework for intranet and internet users for French release.

-Review and guide on WAP and WML protocols for incorporating mobile reports for sales team.

-Technologies used: Open Edge 10.1B03 4GL, Web speed, Pearl, WAP, WML, custom ERP ( 400 users ), HP Unix

Caterpillar Inc, Peoria, IL (Sr. System Analyst, MFG/PRO) NOV 2007 – NOV 2008

- Responsible for design, implementation and maintenance of several key automated EDI real-time and batch interfaces,

including EDI 810/850/856 for various eB2.1 enterprise sites.

-Facilitate MFG/Pro 8.6 to MFG/Pro eB2.1 migration for various modules and database tables as per QAD guidelines.

-Monitored QAD software releases (patches) to identify changes affecting major sites and implementation of the approved.

-Primary responsible for managing quarterly Book closing and Profit and loss accounts for major sites.

-Created training manual and lead technical knowledge transfer for Kanban implementation.

-Analysis for SONIC ESB 7.0, Sonic MQ migration for FTP batch interfaces with DB2 corporate legacy database.

-Configured and managed Control-M automation batch processes for daily interfaces processing.

-Technologies used: Open Edge 10.1 4GL, MFG/Pro 8.6 – eB2.1 ( 24 sites ), Sonic ESB 7.0 workbench, Sonic MQ 7.0, HP Unix

CMA Inc., Ottawa, Canada ( Sr. Software Engineer ) FEB 2007 – AUG 2007

-Primary responsible for maintenance and support of Corfax ( DST System ), Global portfolio accounting, Performance

System, Investor record keeping and Global transfer modules for CMA Mutual funds (MD, Saxon).

-Support and enhancements to Fund SERV network and other night batch interfaces

-Lead Progress 9.1 to Progress 10 migration initiative, analysis for application and database modules.

-Facilitate reverse engineering business logic from Corfax to .Net Oracle Data warehouse and BI applications.

-Design Quick ref card: Data Types Compatibility for ETL and interfaces: JDBC types, Java types, Open Edge SQL,ODBC types, SQL-92 types, 4GL-ABL-SQL types

-Technologies used: Open Edge 10 4GL, Progress 9.1d 4GL, Oracle 10, Sun Solaris

Prudential Finance Inc. Edition, NJ (Business Analyst) SEP 2006 – JAN 2007

-Facilitate All State Annuity database conversion to Prudential Annuity system part of new acquisition project.

-Design and developed custom ETL processes for All State system integration.

-Developed Equifax credit score inquiry automation process for Prudential annuity system.

-Lead, requirements, design, development, testing Web speed internet application for ETL programs review and remote parameters update.

-Technologies used: Open Edge 10 4GL, Web speed 3.1, Sun Solaris, Win NT, Java script, Apache, Tomcat

Schlosser Forge Co., LA, CA (Sr. Progress developer/analyst) NOV 2005 – APR 2006

-Lead design, develop, user testing and rollout of many custom modules for Epicor ( Vantage )

-Developed Inventory Stock rollback reports for Mfg. items and purchased raw materials, aging analysis, overhead variance

and material cost variance analysis, saving 20% in inventory cost over six months.

-Lead design and developed automated Document Asset management system in Web speed 3.1 to comply with regulations to

maintain information for 25 years, all material specifications and manufacturing processes for every parts made for aero industry.

- Technologies used: Open Edge 10 4GL, Web speed 3.1, Sun Solaris, Win NT, Win 2000 server, Java script, Apache,

IFDS (Canada) Ltd. ( DST Systems, State Street ) Toronto, Canada (Sr. Business Analyst) MAY 2005 – OCT 2005

- Facilitate Corfax implementation for new client ABN Germany bank, database migration, maintained ETL processes,

-Lead development and testing to automate process for full shot database conversion on various fields, Product, client codes

-Responsible for customization and support for Corfax, Fund SERV and night batch interfaces for various IFDS clients.

-Technologies used: Progress 9.1 4GL, Custom ETL, Erwin, UML

Innova8 Inc., New York, NY (Web speed Consultant) APR 2005 – APR 2005

-Responsible for online freight management application analysis and modifications for Carrier Logistics Inc.,

serving transport operators UPS, FedEx etc.

-Technologies used: Progress 9.1 4GL, Wes peed 3.1, Win NT, Erwin,

Franklin Templeton Companies, Fort Lauderdale, FL (Sr. System Analyst) NOV 2004 - APR 2005

-Lead developer for App server real-time interface for SunGard (STN) FIX network for equity, fixed income order

routing, price discovery, order execution and post trade processing application.

-Responsible for maintaining and support Global funds, equity, derivatives and foreign exchange instruments portfolio accounting and investment management application.

-Enhanced report for settlement payment notices output to excel report.

-Progress data analysis and mapping support to Informatica ETL team for BI, Data warehouse applications

-Technologies used: Progress 9.1 4GL, AIX Unix, Win NT, Erwin

R & B Inc. Philadelphia, PA (MFG/PRO Analyst) APR 2004 – APR 2004

-Lead developer for Sales Order processing for Priority 75 PTO ( Pack to Order ) Automotive items, 5 new custom programs

and cron process to real-time update inventory transactions for 75 PTO items, created 7 new menu items and 3 new side-tables.

-Technologies used: Progress 9.1 4GL, MFG/PRO 9.0 eB, AIX Unix

Avery Denison Inc., Cleveland, OH (MFG/PRO Analyst) MAR 2004 – MAR 2004

-Key development and testing support for modifying MQ series shared memory real-time inventory transaction

messages to XML messages using DOM and SAX 4GL API, rewriting 4 real-time interface programs

- Technologies used: Progress 8.2 4GL, MFG/PRO 8.5, SUN OS, MQ series

Principal Financial Group, Des Moines, Iowa ( Sr. Analyst/developer ) APR 2003 – OCT 2003

-Key support and maintenance responsibility for Residential Mortgage Finance – registration, processing and approval

Application

- Designed, developed, unit testing and rollout of important processes – Automated transfer packages to Mortgage Insurance

companies – Automated Inflation rate update for daily revision - Social Security Number validation - modifications to several key batch interfaces – Business Objects implementation using persistent session library and dynamic functions.

-Lead analysis, design and development of web Mortgage refinance on-line application – auto fill legacy database member information in 6 pages web speed portal, automated credit score inquiry and final approval in real-time, interface approved refinance loan information back to legacy DB2 database.

-Technologies used: Progress 9.14GL, Web speed 3.1, App server, HP Unix, Java script, ADM2, DHTML, DOM, CSS

Astro Exports Inc. Toronto, Canada (Consultant) JAN 2002 – JAN 2003

-Dapasoft : Materials Management MRP package enhancements with new CRM modules – VB 6.0, NT 4.o, MS SQL 7.0,

MTS, Crystal Report8.0

-Kenilworth : Web registration and data staging application design, development and rollout – MySQL 3.0, Flash, JSP,

Javascripts, CSS, DOM, Appache, Tomcat 4.0

-RabDesign : QAD Mfg/Pro 7.3 DBA support, maintenance, customization – DecAlpha Unix cron shell scripting for night

Batch jobs, multi volume database backup scripts, migration analysis for MFG/pro 7.3 to 8.5

Onerail (Canada) Inc., Toronto, Canada (System Analyst/programmer) AUG 2001 – NOV 2001

-Lead developer, unit testing and production rollout for challenging Sonic MQ, Orient Express – online railway reservation

application, gui front-end development for online reservation system, trains availability, booking confirmation, seat allocation

and passenger tour updates using Sonic MQ JMS middleware and c interfaces with Informix database in multi-tier platform

-Lead application developer and rollout for automatic passenger address fill using available dll and UK Postal code database

-Technologies used: Progress 9.1 4GL, Sonic MQ, App server 9.1, AIX Unix, ADM2, XML, XSL, DOM & SAX API

Radio Beacon Inc. Toronto, Canada (System Analyst) JUN 2001 - AUG 2001

-Responsible for enhancements to Multi-Caster Forecasting system, isolate multithread engine components and implement

additional pipeline functionalities, conversion of modules to ActiveX for web migration.

-Worked on conversion of the SQL queries to server side MS SQL store procedures and Oracle 8 store procedures.

-Technologies used: Visual Studio, Visual C++, MS SQL, Oracle 8, Win NT 4.0

PrimeTech Institute, Toronto, Canada (Teaching Associate, Lecturer) NOV 2000 – JAN 2001

-Teach Java 2.0, JDK 1.2, JSP, servlet, EJB architecture, covered many chapters from Beginning Java 2 – Ivor Horton

-Teach Visual basic 6.0 and database Application using MS SQL 6.0

Equity Retirement Rewards, Toronto, Canada (Sr. System Analyst) DEC 2000 - MAY 2001 & APR 2000 - AUG 2000

-Lead developer for POS Transactions management application for daily batch files import/export and batch control management with gui front end, XML parsing using DOM API for Sponsor partner’s transactions.

-Responsible for design, development and testing of Equity RRSP Point Card system, new member registration web application, customer service screens, transaction statements,

-Technologies used: Progress 9.1 4GL, Web speed 3.1, DG Unix, Java script, ADM2, DHTML, DOM, CSS, Erwin

APAK Systems Ltd. Mississauga, Canada (Sr. Progress developer) JUN 1999 - JAN 2000

-Support and maintenance for Apak’s Leasing Finance Management system, new modules development, testing and rollout

PAPP (Pre Auth Payment) module, UDF user defined field’s implementation, Key Performance Indicator reports

-Support migration of ASSET 2.5 to ASSET 3.0, database conversion of 2M records for Apak vendors

-Lead design, developer, and rollout Invoicing module using VB 6.0 ActiveX controls, Crystal reports, and customization for Apak vendors ( MTC, Wittern, Pyxis, Neon ).

-Technologies used: Progress 8.3 4GL, NT 4.0, VB 6.0, Crystal Reports, Erwin, Visio

AT & T Canada, Toronto, Canada (System Analyst/Programmer) APR 1999 - MAY 1999

-Lead Network Analysis application developer for Cisco, Baystack hubs & routers using SNMP protocols, MIBS

Objects data feeds, C++ World Net network interfaces and Progress chui front end.

-Assist HP Open View automated scripts – monitoring – mapping and updating Progress 8.2 database.

-Developed progress programs for Round Trip Transit Delays over OSPF – line and bar chart reports for Network engineers.

-Technologies used: Progress 8.2 4GL, HP-SUN-SCO Unix, C++, Visio

Data Business Forms, Brampton, Canada (Sr. Progress Developer) OCT 1998 – MAR 1999

-Assist custom (Syteline) ERP database merge project for Data Business Forms locations – Brampton/Granby to centralize operations for Finance and Manufacturing modules, performed delta analysis, comparison and conversion.

-Lead developer for Imprint and EDI transactions interfaces.

-Enhancement development/testing support for additional A/R modules: Customer sales Stratification, Aging Analysis, system wide expansion of packing slip and order number from 6 to 8 digits

-Performed MS Project timeline reports & Erwin database revisions for Brampton / Granby ERP Merge project

-Technologies used: Progress 8.0 4GL, SCO - Alpha Unix, Visio, Erwin

Fidelity Investment Canada Limited. Toronto, Canada (System Analyst) APR 1998 – SEP 1998

- Responsible for Maintenance – schema revisions & implementation of SSR (System Service Request) for Corfax

(Transaction accounting & information system for the Mutual Fund Application) developed by DST System.

Customization, programs modifications, addition of new reports, menu items & 7x 24 call supports for the Corfax.

-Development Support for Time Keeping System using Visual Jbuilder, Java 2, DHTML, Java servlets

-Technologies used: Progress 8.2 4GL, SCO – Sun Solaris Unix, PVCS, Visio, Erwin, Jbuilder, JDK 1.2, Apache, Tomcat

Canadian Tire Acceptance Ltd., Welland, Canada (Sr. Tester / Project manager) FEB 1998 – MAR 1998

-Weekly Review of Year 2000 Strategy plans, Development of Master CTAL TEST PLAN summarizing schedules for

11 major projects and 17 sub projects – Infrastructure, AS400 AIX, Novell, Sun Unix, Telecom, Lotus Notes,

EDI Polling, Switch, Print, Desktop etc

-Consolidate Work Efforts Estimate for Year 2000 projects using MS Project and analyze as per the Pape phases

-Responsible for Summarize Current status of Test Environment for the Year 2000 projects and flag internal & external critical dependencies between the projects

-Technologies used: MS project, Visio

KPMG-VERSA Systems Inc., Toronto, Canada (System Analyst/Programmer) JAN 1997 - JAN 1998

-Key responsible for migration of the VAX legacy database to QAD MFG/PRO 8.5 & customization of MFG/PRO

to review the Invoice History & Purchase Orders from the legacy history database, CIM load legacy data,

New products classifications & configuration/costing/pricelist with DIGITAL Unix, Progress 8.0 Char

-Lead Development of QAD MFG/PRO ERP Inventory reports with Actuate 2.0 AFC, SCO Unix and Gui client

-Assist Migration of Progress 4GL, HP Unix 10 Char custom MRP application from 7.3 to 8.2, about 1200 program files and 36 databases

- Development of IMN (Interac Monetary Network) switch, transaction header splitting module in HP UX 9, C++

Informix backend, design documentation in UML & Erwin.

-Worked on Varnet ERP system enhancement - development of Eng. Bill of Material’s update module, create-copy-append new Bill of Materials, import schematics data in Gui front end using smart objects technology

- Assist development of EDI processes for Transaction set 810/850/856, interface similar to CIM load for Varnet database

RETAIL SYSTEMS GROUP, Markham, Ontario, Canada (Software Engineer) AUG 1996 - DEC 1996

-Key design, developer, testing and production update of on-line real-time communication interface in

Visual C++ (external DLL) for Meal Plan, Point Of Sale transaction processing and authorization application

using ISC networked Omron 4541 cash registers with keyboard, magnetic card reader, bar-code reader, weighing machine

-Assist System design, development and implementation of Meal Plan, Point Of Sale application from chui to Gui front end.

-Key developer and tester of various Crystal reports - Users YTD summary, charge posting, transaction log, aging and consolidated reports

-Technologies used: Progress 8.0 4GL, Visual C/C++, NT, Visio

C M Inc., Markham, Ontario, Canada (Software Engineer) JULY 1996 - JULY 1996

- Worked for design, development - Notes module for contacts management package Maximizer in Visual Basic 5.0

- Developed ODBC 2.0 driver interface for Maximizer 2.0 database & Visual Basic 5.0

- Maintained - Brokerage house portfolio management package in Visual Basic 5.0, NT, MSSQL & Crystal reports.

Education:

B. E. (Mech.) (First class honors)

S. P. COLLEGE OF ENGINEERING, UNIVERSITY OF BOMBAY, Bombay, India

- Sp. Industrial Engineering

M. Eng. (System Test Tech.) (Incomplete)

UNIVERSITY OF WALES, Cardiff, UK

- Project work on ICL 1901 & PDP11 in machine language (real-time feedback control system simulation), Fortran and Pascal

Training:

Post Graduate Student & Research Assistant

UNIVERSITY OF TORONTO, Toronto, Canada

- Project work on Hybrid Finite Element Methods, research award from Atomic Energy of Canada

for Finite Element methods using Fortran, PL1, IBM 370/165 MVS system

Progress 7/8 Database Administration: Certification

- Progress affiliated course conducted by KPMG-VERSA

Modern Internet Tools and Object Oriented Programming in Java: Certification

RYERSON POLYTECHNIC UNIVERSITY, Toronto, Canada.

- Award in recognition of professional development using Java, HTML, CSS, Java Script, Jbuilder

Sonic ESB 7.0 Workbench and Sonic MQ Training

Progress Software Corporation

-ESB Processes, Web Service – WSDL, Database Service, Java Service

BIRT Training – Building Rich Internet Content with BIRT

Actuate Corporation

-Installing and using Actuate BIRT report Designer Pro release 10, MySQL Database service

-Creating, Formatting simple reports, reports with parameters

-Creating Charts, Hyperlinks, Flash charts

Contact this candidate