MIKE MEHTA
E-mail: **********@*****.***
Summary of Skills:
SAP PLM (Functional / Some Technical)
Teamcenter PLM (Technical / Functional Architect)
Systems Data Warehousing Reporting SAP PLM
Tools Tools MM, PP, QM, PM
ECC 6.0 BW BI 7.0 Business Obj DMS
UNIX BEx Crystal Rep Project Systems
Windows BWA Xcelsius
Oracle Authorizations BO Admin
ABAP, C, C++, Shell / Bat scripting, XML
Teamcenter PLM / SAP PLM:
. SAP PLM 7.1, ECC 6.0
. Plant maintenance, Quality Management, Material Management,
cFolders, cProject
. Document Management (DMS), eBOM, mBoM
. Routings & Variant Configuration
. Systems integrations, Authorizations, Security model
. Product & Process Requirement Management, Impact analysis
. Workflow expert, process charts & solutions
. Defense & Aerospace experience
. BW BI7.0 & BO for reporting
. Technical & Functional Architect on Teamcenter PLM
. Graduate certificate from Stanford University
. Technical & Functional Architect - PLM Systems (Teamcenter)
. Strong IT Administration on UNIX & Windows based servers
. Set up database servers (Oracle), Application servers &
corporate servers many times
. Strong scripting - .bat files as well as UNIX shell scripts
. Designed user based, role based & site based, object & project
based security
. Project Lead on ( PLM ) Product Lifecycle Management projects
. Lead enterprise wide deployment projects & managed a group of
people up to 35resources (internationally)
. Worked with Sr Management to resolve issues & concerns
. Fluent in explaining technical things to non-technical
professionals
. Exceptional people skill
. US Citizen
. SAP BW 7.0, ECC 6.0s, BWA (Accelerator) SAP BW Security -
Authorizations
. Physical Infoproviders, Virtual InfoProviders
. Monitoring, Analyzing, Load Processes
. Process Chains, Lifecycle Management
. Flat Files, Generic Extractions using Views / Tables & flat
files,
. Performance Tuning - Aggregates, Indexing etc
. Generic & Enhanced DS from SD, MM, LO-Cockpit, PP, Basis
tables, FI
. Star Schema, Snowflakes schema
. Performance Tuning - Aggregates, Indexing etc
. Filtering, Abstraction, Currency Conversion, Business Rules
. Used BXe Query Designer, Analyzer etc
. Infocubes, Data Store Objects, InfoObjects, Datasources,
Infoproviders
. Data Mart, Multi-cube, Infoset, Virtual Provider, Remote Cube,
Real Time IC
. Deep knowledge of Dimensioning
. Business Objects
. Crystal Reports
. Xcelsius
Experience:
June 02-Current Independent Consultant - PLM Consultants LLC
SAP PLM / Teamcenter PLM
I have been in a senior project lead role on assessment phase
twice so far to provide initial assessment to implement SAP PLM
projects by interviewing Sr. Executives & by conducting
workshops consist of senior executives, Business Leads & SMEs.
Documented requirements and at the end, provided end-to end
reports that included mapping of business requirements to SAP
functional modules, current & future PLM systems state.
Identified sun-set candidates, pain areas & gathered high level
information on current data & processes.
I have hands on experience on ECC 6.0 & PLM 7.x systems (DMS,
cProjects, Folders, Material Management, Varian Configuration,
Routings, Plant maintenance, Production Planning, Quality
Management, Change Management etc) as well as SAP BW/BI & BO.
I have hands on working experience on SAP Routings & Variant
Configuration experience which is one of the most complex areas.
I maintained Routings and changed eBOM / mBOMs, added
inspections, created parallel routings, maintained time to
perform tasks, set-up work centers, created materials, reports,
added resource/tools, created operation ref sets, mass releases
etc etc. Created characteristics, classes etc for data model of
SAP PLM
I have provided analysis on integrations of SAP PLM modules to
the clients and aligned with ERP implementations. Identified
GAPs and provided impact analysis.
. Lead enterprise wide PLM system implementations
. Communicated effectively with top management, consultants &
helpdesk people during implementation
. Involved in planning and budgeting
. Worked on GAP list, discussed with the team & proposed
solutions
. Coordinated client & software vendors for solutions
. Coaching, training administrators about developing &
implementing BOM for system integration
. Helped administrators & power users to troubleshoot problems
on either errors in installations or Business modeler (BMIDE)
developments of Item Types, Forms, Dataset Types, Statuses,
Workflows, ACLs, Business Rules, Change Items, Organization
and almost every part of the systems.
. Performed Administration, Installation & Development work
. Currently using TcUA 2008 & Tested Beta version of TcUA 2007
& 08 (Unified Architecture)
. Business Modeler (BMIDE) of Tc2007 & 2008 Beta version
. Created Test, Training, Dev & Prod environments from scratch
as well as upgraded from previous versions
. Configured Teamcenter Application & Corporate servers, Oracle
(9 & 10g) servers, Global Services, Websphere, JBoss, Apache,
BCT & FlexLM in two tier / four tier environment using UNIX &
Windows OS.
. Made changes to JVM heap settings / Garbage collection for
performance issues
. Worked extensive hours during successful implementations of
multi-site production sites by leading the team. It required
great planning, people skills & leadership qualities
. Deployed Test, Dev & Production environments from scratch
using iMAN, TC 2005 & now Tc2007 - 2008 with Catia or NX
. Installed patches for iMAN & Teamcenter as well as UG NX Cad.
. Resolved every single customer's issues pre & post
installations with an utmost professional attitude
. Installed Oracle Database servers & fine tuned for
performance, set up back up using RMAN, used Enterprise
Manager
. Discussed with Siemens for additional features requirements /
corrections in Tc2008 (Next Version)
. Installed and configured 4 tier OTW Rich Clients, 2-tier Rich
Clients & Thin clients over 20 times
. Worked extensively on IDSM / ODS services issues in multi-
site set-up
. Resolved issues regarding ODS / IDSM services, TCFS / FMS,
Global services, Licensing related, Listener Services & many
complex issues during installations
. Scheduled and planned installations & migrations by
coordinating with the helpdesk, outside consultants & project
managers.
. Performed iMAN V9 to TC2005 Upgrades
. Converted Enterprise Life Cycles to TcUA 2007 Workflows. This
required knowledge of both systems. I created may be largest
workflows. It had deep rooted tasks & sub-processes with
approximately 3500 - 4500 tasks! This required in-depth
knowledge of not only workflows & handlers but complete
business modeler knowledge, queries & Business Rules & many
other features. After all Gap Analysis, research,
recommendations to UGS for enhancements I trained, instructed
& guided a team of people to successfully migrating TC
Enterprise LC to TcUA Workflows
. Created Item Types, Dataset Types, Forms Types and LOVs,
imported / exported files & data using PLM / XML.
. Ran many utility commands in iMAN 9.1.3.5, which were
dsa_util, database_verifier, Install_types, Clear_locks
ugmanager_refile and many others. Changed Preferences in 2005
& 2007 TcUA
. Used Access Manager, Organization, Query Builder, Report
Designer and all other applications.
. Configured ugtopdf, file_import, ug_import & other custom
coded programs for data migration.
. Used Teamcenter Enterprise, Teamcenter Community, Teamcenter
Engineering & TcM on Sun Solaris servers with Windows
clients.
. Worked on custom scripts to set up the environment as well as
variables
. Used TcM to Oracle for a data migration work. Worked closely
with UGS on testing.
. Integrated UG NX4 with iMAN & Catia with Tc 2005
. Supervised consultants on site
My clients include Swagelock, Home Depot, Lockheed Martin,
Northrop Grumman, United Technologies, and General Electric to
name just few.
. BW / BI / ECC : Worked on BW 7.0 / 3.5 & ECC 6.0 so far,
now focusing more on Business Object projects as well
. Creation of DSO, Info cube, Infoset, Data mart, Process
Chains, Update rules and the corresponding info objects
based upon the data source available in the source system
. Creation of various DS, info sources, transferring
structure, assigning various source systems for extraction
of data & scheduling of jobs for extraction
. Generic Data Sources from Views and Function Modules, DB
connect and Flat - Files
. Maintaining structural changes for the master data at the
data source level and incorporating the same in the BW side
. Installing BW statistics in Development server and
incorporating the same to production environment for
further analysis and developments
. Thorough knowledge of multi-dimensional modeling and data
analysis, data warehousing concept, trends and best
concepts
. Extensive experience in support, Data loads, Validation and
trouble shooting of transaction data and Master data,
Change management, Transport Management, Roles & Security,
System Checks, Performance tuning and process chains
. Built process chains for master data and transaction data.
Responsible for Creating Process chains for cutover and
delta which includes plan, maintain, source & deliver.
Scheduling and monitoring the process chain.
. Monitoring of data uploads-master as well as transactional
on a daily basis and enabling delta uploads
. Front End -Report Generation-Worked extensively in BXe
Analyzer in building queries, saving it in workbooks,
created custom queries using variables and created
aggregates for frequently used queries. Business Object is
being introduced shortly.
. Developed flexible queries using filters, navigational
attributes in BEX analyzer to facilitate data analysis in a
drill down or summarized way to give detailed levels of
information, Exported Xcelsius visualizations to various
applications (Power point, PDF etc),
. Evaluated statistical performance using BW Statistics and
suggested recommendations to Basis support for
optimization. Improved data load and query performance by
doing Compression, creating Aggregates, Indexes, Data
packet size.
. Extensive experience in support, Data loads, Validation
. Business Objects: Created Queries, Reports using Alerters,
Charts, Formulas, Conditions, and Operators etc.., created
schemas using Joins & Tables, Designed Universes, worked on
Xcelsius visualizations also worked on BO administrations
tasks...
Training / Knowledge of...
. Crystal Reports: Designed Optimized Web Reports, Built
queries, Filters and prompts, Sorting, Grouping and totaling of
data, Accessed data sources, created and updated OLAP reports
. BO Admin work: Creating Users and User Groups, Applied and
managed access & security settings, Created folders, published
Universes and Reports, Managed Enterprise Applications
Dec 97-June 02 Lucent Technologies Inc. Norcross GA
SAP R/3 was implemented in 1997-1998
I worked with PWC consultants on requirement gathering, end user
training & process developments. I got involved in PP & MM
development teams.
I was responsible for UG CAD Customization on UNIX servers.
Apr 97-Dec 97 Ward Machinery Co. (Contract work) Cockeysville, MD
I worked on UGS PLM systems to set up client server environment
using Unix servers & performed system administration duties
Dec 95-May 96 Unison Industries, Jacksonville, FL
Studied the products and introduced 3D solid modeling
techniques. It became very useful and saved time & money hugely.
Client was using Unigraphics and Autocad 2D.
Feb 95-Dec 95 B E Aerospace Industries, Jacksonville, FL
I was responsible to train Unigraphics V9 users for Version 10.
Discussed and planned training with Engineering Manager and
System Administrator. I showed different solid modeling &
assembly and component techniques. Design Airplane interiors
and galley products
Aug 88-Feb 95 International Paper Box Machine Co., Nashua, NH
UGII CAD System Management: Performed system management duties
like file permissions, monitoring, back-ups, system security,
plotter related problems etc. etc. I installed UG CAD software
on HP-UX workstations. Wrote many shell scripts using VI editor.
I attended many users' group meetings.
Designed and detailed many fast moving machine parts of paper
box folder gluer machines. I created 3D layouts using wire frame
and surface modeling using UG V9.
Education:
Project Program & Portfolio Management (Graduate Certificate)
from Stanford University, California, 2010
Bachelor of Science, Gujarat University, India, 1983
Hobbies / Interests:
. Member of PIONEER club: Serving community, worked on several
school projects.
. Produced & directed a TV show pilot. Displayed excellent
Project Management skills as a producer.
Citizen of United States of America