CAREER SUMMARY:

• Having 7 years of full term experience in EAM Maximo from v4.0.3 to v7.5 . Well versed with technical and functional knowledge of entire Maximo tool In-depth experience in all the modules like Asset, PM, Work Order, Purchasing, Locations, Database Configuration, Inventory etc.
• Having 7 years of experience of all the modules and aspects of Computerized Material and Maintenance Management System, CMMS MAXIMO in J J MDD Medical Devices Diagnostics
• Involved in Full-Term implementation EAM Maximo project with the client Johnson Johnson including various geographies like APAC, EMEA, NA and Consumer .
• Extensively worked on an eCMMS Enterprise Asset Management EAM IBM MAXIMO ASSET MANAGEMENT tool.
• Experience in EAM Development, Design and Configuration using tools such as Application Designer, Database Configuration and Workflow Designer.
• Experience in Data Warehousing Informatica Power Center v9.1 and Oracle v9i and v11g . This includes analysis and development of mappings incorporating needed transformations using Informatica Power Center v9.
• Extensive experience of the upgrade process from Maximo v4.0.3 to Maximo v7.5.
• Well-versed with configurations in Maximo v7.5 and in-depth expertise in all the versions of Maximo v4.0.3, v4.1, v4.1.1, v5, v6, v7.1 and v7.5 .
• In-depth experience and knowledge of Maximo database and all the table structure linkages across the diverse Maximo versions.
• Strong experience in Data Warehousing and ETL using Informatica Power Center 9.1
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Excellent knowledge and in depth experience in Software Testing Life Cycle STLC in HPQC.
• 2.5 years of experience in Software Technical Design, Development, Implementation, Production support and Documentation of Client/Server, Internet/Web and Legacy Applications.
• Experience in both support and administration of Maximo7.5/7.1/6.2/5.0 application deployed on WebLogic8.1/Websphere6.1 application servers which includes configuration and deployment of Maximo and Mobile Maximo applications.
• Worked on reporting tools like BIRT, COGNOS, and OBIEE. Developed reports based on pie-graph, bar-graph, summary reports, detailed reports, comparison reports etc.
• Expertise in Oracle11g/9i/8i, UDB, PL/SQL, SQL Server, Stored Procedures, SQL plus and Database tools like TOAD and SQL Developer.
• Build and Deployed JAR, WAR and EAR packages using admin console and ant scripts.
• Extensively worked on Informatica Designer Components Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Excellent knowledge of Software Testing Life Cycle STLC .
• Very Good knowledge of Software Development life Cycle SDLC . Ad-hoc Testing and Performance Testing. Emphasized on Performance tuning.

TECHNICAL SKILLS:

• Expertise with all the versions of Maximo which includes Maximo v4.0.3, v4.1, v4.1.1, v5, v6, v7.1 and v7.5.
• OPERATING SYSTEMS : Windows NT/2000, UNIX, Windows XP, Vista, Windows 7, Windows 8.
• UPGRADE PROCESS : Expertise in execution of upgrade of Maximo from Maximo v4.0.3 to Maximo v7.5.
• Programming GUI : SQL, PL/SQL, SQL Plus, Java, HTML, C, C
• TOOLS : eCMMS Tool Enterprise Asset Management , Informatica Power Center v8.6.1,v9, HPQC, PL/SQL Developer, SQL Plus, TOAD, Edit , Editor, Microsoft Word, Excel, PowerPoint, Basics of Adobe Photoshop.
• Scripting Languages Ant Script, JavaScript, UNIX Shell Script GUI AWT/Swing, HTML and ML/XSLT.
• RDBMS MS-SQL Server, MS-Access, DB2 and ORACLE 11g/9i, PL/SQL Middle Ware Servlets 2.0, Web Services. EAM Application Maximo MXES and MEA.

ASSIGNMENT HISTORY:

Confidential

Role : Maximo Developer

Tools and Environment:

Upgrade Utility of Maximo, INFORMATICA v9, Maximo v4.0.3, v4.1, v4.1.1, v5, v6.2, v7.1 v7.5 , Maximo Enterprise Adapter MEA , Java 1.4, SQL, PL/SQL, J2EE, UNIX and Windows XP, WebSphere, Oracle 9i/11g. Oracle 9i, SQL Server 2005 and 2008, Windows 2003.

Key responsibilities:

The following are for the key responsibilities:

• Executed upgrade process for Maximo EAM Tool for 10 databases sizing from range of 10 GB to 50 GB each and ranging from Maximo v4.0.3 to Maximo 7.5.
• In-depth knowledge and experience in Maximo database level intricacies and table structures, linkages between various tables and all the system, set, site org level entities across all the versions of Maximo v4.0.3, v4.1, v4.1.1, v.5.2, v6, v7.1 and v7.5 .
• Involved in domain creation like SYNONYM, CROSSOVER and ALN domain specific to client requirements
• Extensively worked on APPLICATION DESIGNER and MIGRATION MANAGER.
• Involved in configuring the Maximo Enterprise Adapter MEA for inbound and output operation.
• Preparing and reviewing all the deliverables being delivered from Offshore.
• Expertise in DATA PORTING to convert SQL SERVER 2000 database objects into ORACLE 11g.
• Responsible for Security administration including configuration of security roles, group creation, new user setup, Active Directory modifications and troubleshooting failed LDAP synchronizations.
• Provided training, documentation, and support to users in EAM domain.

Confidential

Role : Maximo/Informatica Developer

Tools and Environment:

Maximo Integration Framework Maximo v7.5 , Informatica Power Center v9, Maximo 6.2, Maximo Enterprise Adapter MEA , SQL, PL/SQL, Windows XP, WebSphere, Oracle 9i/11g, SQL Server 2000, HPQC 10.

Key responsibilities:

• Maximo software development including coding, storage, version control, testing, and re-use.
• Implementation of business logic to transform, migrate and merge 10 Maximo databases including SQL Server 2000 and Oracle 11g into a single Maximo Database Oracle 11g .
• Designed Object Structures, External Systems, Enterprise Services, End Points and Publish Channels to migrate the Calibration data from legacy systems Gage Insite and Pilgrim into Maximo v7.5
• Extensively involved in Inbound and Outbound transactions using MIF.
• Conduct technical design meetings and collaborate with other team members on transforming system requirements to project deliverables.
• Create solutions based on utilizing IBM Maximo Integration Framework and Maximo Business Object customization.
• Create interface and technical solution design documents, including concept presentations, technical specifications, and interface control documents
• Designed Mappings, Mapplets, Sessions and workflows incorporating various transformations catering to business needs and requirements.
• Integrated Informatica Power Center v9.1 for data migration involving Maximo v4.0.3, v4.1, v4.1.1, v5.1, v6.2.8, v7.1 and v7.5

Confidential

Role : Maximo/Informatica Developer

Tools and Environment:

Tool : Maximo v7.1, Maximo v7.5, Informatica Power Center v9.1

Databases : Oracle 11g/9i, SQL Server 2000

Operating Systems : UNIX, Windows 2K/NT

Database GUI Tools : SQL Developer, SQL Plus, TOAD

Programming Languages : SQL, PL/SQL

Key responsibilities:

The following are for the key responsibilities:

• Designed Source Analyzer, Target Analyzer, Transformations and workflows to transform data involving 3 Maximo v7.5 Oracle 11g databases.
• Responsible for Configuring communication templates, roles, actions and escalations for use with creating Workflow processes as defined by the business requirements.
• Prepared Unified Data Model for transforming and migrating Maximo 7.5 data from 10 separate instances database to single Maximo 7.5 Database.
• Participate in meetings/discussions to document and implement change management process per Service Level Agreements SLA .
• Extensively worked on designing applications for Maximo v7.5 using Application Designer, Conditional Expression, Automation Script, Database Configuration and Escalations according to FRS Functional Requirement Specification and URS User Requirement Specification .
• Created mappings using Informatica Designer to build business rules to load data.
• Used flat file and Oracle as the source Maximo v7.5 and target Oracle database Maximo 7.5 .
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer Mapplets and Transformations Developer.
• Most of the transformations were used like the Source qualifier, expressions and joiner, Aggregators, Lookups, Filter, Rank and Update Strategy.
• Experience with dimensional modeling using star schema and snowflake models.

Confidential

Role : Informatica Developer

Tools and Environment:

ETL Tool : Informatica Power Center

Databases : Oracle 11g/9i, SQL Server 2000

Operating Systems : UNIX, Windows 2K/NT

Database GUI Tools : SQL Developer, SQL Plus, TOAD

Programming Languages : SQL, PL/SQL

Key responsibilities:

The following are for the key responsibilities:

• Requirement capturing from Business analyst on the project and review them with tech team.
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer Mapplet and Transformations Developer.
• Created mappings using Informatica Designer to build business rules to load data for Maximo v7.5 Oracle 11g database.
• Used flat file and Oracle as the source and the target is Oracle database for project team.
• Documentation of AS-IS process of the functional flow and present back to project teams
• Used Mapping Parameters and session parameters in various projects the development.
• Developing and modifying changes in mappings according to business logic.
• Performing Unit and functional Testing of components developed by COE.
• Part of COE for medical devices and diagnostics
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.