Project Data

Mahesh Khond **** Windy Ridge Ct, Plano, TX, ***** Ph: 727-***-****

US Citizen ******.*****@*****.*** http://www.linkedin.com/in/maheshkhond

Summary of Qualifications

An accomplished highly motivated and skilled enterprise data architect with complete understanding of SDLC over 20 years of comprehensive experience in the Information Technology

Build conceptual, logical and physical data models for OLTP and OLAP systems

Developed staging, ODS and Reporting Presentation data models

Build snowflake, star schema data mart models

Extensive experience in development of new solutions, process implementation, estimating, planning, applications development, design, installation, implementation, support and team management

Developed policies, procedures, standards and processes for product delivery ensuring these are followed during SDLC

Responsible for projects completed by development teams that are located on-site, offshore, near shore

Ability to multitask in an effective and efficient manner and multiple time zones

Responsible for Service Level Agreements(SLA) are met and providing Estimated Time to Complete (ETC)

Consistently met and exceeded project goals by delivering project on time and within budget

Technical Expertise

Operating System: Windows, Linux, UNIX

Data Modeling: CA Erwin, CA Model Mart

Methodology: Agile and Waterfall

Database: Oracle, SQL Server, Teradata, Btrieve, Microsoft Access

Big Data: Cloudera Hadoop

Languages: ASP, JavaScript, Java, C, HTML, Visual Basic, Cold Fusion, Power Builder, VBScript, Pascal

IDE: Visual Studio, Oracle Forms, Web logic, IntelliJ IDEA

Web & Application Servers: Microsoft IIS, Cold Fusion, Web logic

Reporting Tools: Cognos, QlikView, Business Objects Enterprise XIR2, Crystal Report, Web Intelligence, Infoview, OBIEE, Microsoft SQL Server Reporting Services SSRS, Microsoft SQL Server Integration Services SSIS, Tableau Configuration Management: Perforce, TFS, PVCS Version Manager, Requisite Pro, VSS

Framework: J2EE, COM/DCOM

Tools: Toad, PL-SQL Developer, Oracle Enterprise Manager, Quality Center, Analytix Mapping Manger, Trillium, Oracle SQL Developer/Data Modeler, XMLPAD

Others: ADO, DAO, RDO, COM, DCOM, T-SQL, ActiveX, XML, XSD

Mainframe: OS390, TSO, ISPF, VSAM, JCL, COBOL, Easytrieve, Intertest, CA11, APC, Pan-Apt

Technical Specialization: B2C and B2B Solution Design

Education

Bachelor of Computer Engineering, Pune University, India

Diploma in Computer Technology, BVIOT, India

Oracle 9I DBA Certification (1/4 Exam)

Trained 25+ resources in Oracle in PwC IM University

Cloudera Hadoop, QlikView, OBIEE

Industry Knowledge

TAX, Compliance, Real Estate, Insurance, Commercial, Retail, Banking, Airline, Energy, Financial Services

Employment History

PricewaterhouseCoopers (PwC), Dallas, TX, USA (http://www.pwc.com) Dec-2003 till present

CITI Bank, Tampa, FL, USA (http://www.citi.com) May-2003 - Nov-2003

Tropicana, Tampa, FL, USA (http://www.tropicana.com/) Mar-2003-May-2003

CGI, Clearwater, FL, USA (http://www.cgi.com) Mar-1999 - Nov-2002

TCS, Mumbai, India (http://www.tcs.com) Jan 1996 - Mar 1999

Supertech, Pune, India (http://supertechsol.com/) Jun 1993 – Jan 1996

Professional Experience

PwC – GM Financials (https://www.gmfinancial.com) – Oct 2015 - Till Date Project involves development of the data warehouse using data vault methodologies. On this project I worked as a senior enterprise data architect to build the presentation layer and business layer data warehouse entities.

Developed Source to Target data mapping

Developed Erwin models for the presentation and business layer

Worked on RCA for production issues caused during data migration process and identifying solution

Technology Oracle, Erwin, Model Mart, SQL Server

PwC – JetBlue Airlines (http://www.jetblue.com) – May 2015 – Sep 2015 Project involves development of master data management information for loyalty customers of the airlines. On this project I worked as a senior enterprise data architect and SQL lead.

Developed Party Model for the Frequent Travel ID process

Developed SQL code to test web service response

Project involves onsite-offshore model

Technology Oracle, Erwin, Java, SQL Server, Tibco MDM

PwC – AT&T (http://www.att.com) – Mar 2015 - May 2015 Project involves development of consolidated data model for ATT home solutions and mobility business division. On this project I worked as a senior data architect lead to build data model.

Developed conceptual, logical and physical data model for mobility and home solutions business division

Project involves discussions with various team members from both business unit across different states

Conducted daily calls to gather business understanding about new data model

Technology Teradata, Erwin

PwC – Southwest Airlines (http://www.southwest.com) – Sep 2014 – Mar 2015 Project involves development of international airlines booking capture and feed data to the other internal systems. On this project I worked as a senior data architect, SQL lead and canonical model development lead.

Developed domestic booking data model for passenger booking from xsd files. Data is received in xml format and then transposed into oracle database

Developed the output xsd generation for enterprise wide model

Technology Oracle, Erwin, Java, XML, XSD, XMLPAD, PL-SQL Developer

PwC – Spectra Energy (http://www.spectraenergy.com/) – Jul 2014 – Sep 2014 Project involves assessment of the spend analysis. On this project I worked as a senior data architect and SQL lead.

Worked as a data architect to develop solution to load data into oracle database and build KPI tables

Developed Conceptual, Logical and Physical data model for the presentation layer

Conducted daily calls and status update to the higher management

Worked on data upload process from SAP system

Developed oracle packages, views, materialized views, functions, procedures

Technology Oracle, Toad, Tableau

PwC – Southwest Airlines (http://www.southwest.com) – Jan 2013 – Jul 2014 Project involves development of international airlines booking capture and feed data to the other internal systems. On this project I worked as a senior data architect and SQL lead.

Developed international booking data model for passenger booking from xsd files. Data is received in xml format and then transposed into oracle database

Developed Conceptual, Logical and Physical data model for ODS

Worked as a SQL lead to develop solution to verify Java team processed and populated data properly into the oracle database

Trained, mentored, Lead 12+ team members

Project involves onsite-offshore model

Conducted daily calls and status update to the higher management

Developed oracle packages, views, materialized views, functions, procedures

Query tuning for performance on materialized views based on xml objects and tables

Technology Oracle, Erwin, Java, XML, XSD, PL-SQL Developer

PwC – GM (http://www.gm.com) Mar 2011 – Dec 2012 - Project involves defining data warehouse application for the accounting department for forecasting purpose. Worked as a data and reporting architect on the project

Responsible for technical architecture of defining data model for staging, operational and reporting databases

Responsible for building conceptual, logical and physical data model using Erwin

Responsible for reporting architecture for defining reporting architecture, reporting model, report structures

Responsible for understanding requirements and discussion with client

Responsible for installation and configuration of software on the server and server access to the team

Responsible for defining report layouts

Worked with other PwC teams for setting up servers

Technology Oracle, Erwin, Cognos, DataStage, Business Objects, Crystal Reports, Weblogic

PwC – ADT (http://www.adt.com), Mar 2011 – Aug 2011 - Project involves defining data migration strategy for ADT's current acquisition of Brinks and for future acquisitions. Worked as a data architect on the project

Responsible for technical architecture of data migration strategy defined spoke & hub model of migration

Responsible for data architecture for defining target model, comparison of source and target model

Responsible for technical architecture of interfaces with different systems after sun setting source applications

Responsible for data profiling and data cleansing activity

Responsible for leading client teams for data analysis and data cleansing activities

Worked with external vendors for acquiring Analytix Mapping Manager Software for the client

Technology Oracle, Erwin, Microsoft SQL Server, Business Objects, Crystal Reports, Analytix Mapping Manager, Trillium, Oracle SQL Developer/Data Modeler

PwC – Tracker, Aug 2010 - Mar 2011 - Tracker application used by PwC for their TAX practice. Project involves creation of w2 tax forms for 10 banks within USA. Worked as a reporting and data architect on the project.

Team Lead of PwC and PwC India resources and responsible for task completion

Responsible for technical architecture of report delivery for each bank with less modification to the report files

Responsible for delivery of 600+ reports for banks with customization

Responsible for discussions with internal/external users of the project to gather requirement

Technology Oracle, Erwin, Microsoft SQL Server, SQL Server Reporting Service, SQL Server Integration Services, Business Objects, Crystal Reports

PwC - Conversion of All Independence & Compliance System Crystal Reports to SSRS, Sep 2009 – Jul 2010 PwC has been using crystal reports for the delivery of the reports to its users who are using these systems. Project involves conversion of crystal reports to the Microsoft SQL Server Reporting Services

Worked as a data and reporting architect

PwC, PwC India, TCS Uruguay co-ordination for resources, quality control and task completion

As a lead of 5 developers to assign work, discuss with testing team and business analyst to resolve defects

Gathering requirement from business analysts, business solution manager for evaluation of the technology and building solution

Responsible for Business Objects Scheduled reports information to be converted to the SSRS

Understanding Business Objects security and configuration so that it can be implemented in SSRS

Participated in providing input to the internal business users for the product and functionality of new system

Technology Oracle, Erwin, Microsoft SQL Server, SRS, SSIS, Business Objects, Crystal Reports

PwC – Tracker, Aug 2009 – Sep 2009 - Tracker is application used by PwC for their TAX practice. Project involves creation of w2 tax forms for 10 banks within USA. Project involves reverse engineering of Power Builder and Oracle code. Reverse engineered document helped business to write requirement documentation, when new system is getting built.

PwC and PwC India co-ordination for resources and task completion and support to offsite resources

Generated reverse engineering documents and helped business analysts to make them understand business process, which helped them to discuss with the business owners

Lead PwC India team of 3 developers to build the reverse engineering documents

Responsible for the produced deliverables and discussions with business analysts

Technology Oracle, Power Builder

PwC - Independence & Compliance System, Dec 2003 – Aug 2009 - PwC uses CES application for Independence & Compliance of its employees.

Worked as a data and reporting architect on the project

Lead team of 15 developers of PwC and PwC India for project completion and support to offsite resources and co-ordination of project delivery

As a lead on defect resolution, participated in meetings for acceptance, rejection of the defect from the testing team, assigning priority and getting issue resolved and deployment for the same

As a functional and technical expert on CES project participate with offshore teams and leads on knowledge transfer and providing feedback

Developed Conceptual, Logical and Physical data model for staging, ODS and reporting schema

Responsible for gathering requirement and discussion within firm-wide users about the product and support

Participated in providing estimation, solution and alternative solutions

Implemented and suggested new process to overcome the issues with data and performance improvement

Implemented code review process and made sure process is followed for CES deployments

Implemented code check-in deployment process and made sure process is followed for CES deployments

Interacted with different teams/organizations within the firm for the project needs

As a subject matter expert provide coaching and mentoring to the team and new team members on the process and application, by providing welcome to the CES document. This document helped on boarding new resources easily on project and become productive faster

Provided technical input on different product evaluation and suggesting to the firm along with pros and cons on the product

Provided weekly status report for defect resolutions by initiating weekly team meetings for onsite and offshore

Ensured code developed by team members is with specifications, reusable with standards and appropriate documentation for the same is created/updated

Escalated the issue to the management if additional help is needed on resourcing and/or any other conflicts related issues within team

Performed Code Reviews & deployments via change control process and support during deployment

Provided technical and analysis support to the project leads for enhancements and maintenance

Participated in Change Request, Defect Review meetings for upcoming tasks

Initial support for the production defects to do the research and finding out the root cause, suggesting work around, till the solution is decided and provided

Responsible for Business Objects architecture and implementation, applying patches and keeping system update with latest patches

Responsible for defining Business Objects Security, report processing using WEBI interface

Worked as a Business Objects Server administrator for updating code/users/support

Responsible for delivery of crystal reports automation using FTP, shared folder or email distribution

Developed oracle procedures, packages, triggers and asp front end

Developed crystal reports and publishing via business objects server for offline reporting module

Provided feedbacks to different teams within firm on business objects offline reporting architecture and giving guidance, on how to build the offline reports securely

Technology Oracle, Erwin, Web Logic, Business Objects Crystal Reports, UNIX

CITI Bank (http://www.citi.com), REMS, May 2003 – Nov 2003 REMS – Real Estate Management System CRS Corporate Realty Services is unit of CITI Bank USA, which maintains real estate information for the CITI.

Tropicana - (http://www.tropicana.com/) Crystal Enterprise Implementation, Mar 2003 – May 2003 As a consultant implemented crystal reports architecture and crystal reports enterprise servers.

CGI - BIEE Knowledge Management & Sales, Bell Canada, Sep 2002 – Nov 2002 Report system developed for Bell Canada to understand which products are selected by customer to gain web access.

CGI - GIOS Global Insurance Open Solution, Nov 2001 – Sep 2002 GIOS is an oracle-based insurance solution that administers wide range of insurance product lines

CGI - GEAC, Mar 2000 – Nov 2001 GEAC is an ERP Package, which provides Account Payable, Account Receivable, Payroll, Project Information, and HR activities. Web site for the company is processing data from GEAC.

CGI - Sales Pipeline Automation (SPA), Sep 1999 – Mar 2000 The SPA system gives information about the projects in the pipeline along with information such as when project is going to start, where, competitors.

CGI - Client Project Database Management (CPDB), Jul 1999 – Sep 1999 CPDB system gives pertinent information about what kind of project executed for the Industry and who was coordinator of the project.

CGI - Health Plan Services, Tampa, FL, Mar 1999 – Jun 1999 Health Plan Insurance Management System (HPIMS) - Health Plan Services uses HPIMS to issue and maintain insurance policies data. HPIMS is fully capable of computing and distributing commissions through channels defined by the user.

TCS - GE Financial Assurance Company, Seattle, WA, Feb 1997 – Mar 1999 - DSS system generates agent commission statements, when insurance policy transaction occurs.

TCS - GE Client Business Solutions, Inc. Fort Myers, FL, Jan 1996 – Feb 1997 - Accounts Payable (AP), AP generates reconciled ad-hoc report for the invoice generated, received and paid amounts to GE vendors.

Supertech - On-line Open Window Banking System, Jun 1993 – Jan 1996, India Bank's - Bankplus is a one open window banking application.

Contact this candidate