Maximo Functional Analyst Resume
Pittsburgh, PA
SUMMARY
- Over 17 years of experience in Information Technology, Maximo Implementation, System Administration, System Analysis, Business Analysis, Project Management, Master Data Management, Senior Report Developer, and Business Administration.
- Diverse background includes extensive knowledge of a variety of SDLC methodologies, deliverables and PMBOK.
- Analytical skills to identify potential problems and recommend solutions.
- Skilled communicator with the ability to write complex technical and functional specifications but can also write easily understood training material.
- An organized, take - charge professional with exceptional follow-through abilities and detail-orientation; able to plan and oversee multiple projects from conception to successful conclusions.
- Skilled in agile and waterfall project management methodologies. Known for ability to produce high-quality deliverables that meet or exceed timeline and budgetary targets.
- Extensive knowledge of eliciting and documenting requirements which includes client facing interactions.
- Vast knowledge of developing and supporting software solutions.
TECHNICAL SKILLS
- Expert Word, Expert Excel, Expert Access, PowerPoint, Crystal Reports, Actuate BIRT Reports, Cognos 7, 8, 10.2, & 11, Oracle 8i, 9i, 10i, 11, 12.1, Toad, MS Project, Report Builder, SQL Navigator, Primavera, SAP, Business Objects 6.5 & XI, Talend, SSRS, SSIS, SSAS, Informatica, Visual Basic, Actuate 7 & 8, Unix, etc.
- Installation, Build, Configuration and Deploy - Infrastructure and Meta-Data
- Asset Configuration Manager (ACM), Transportation, Linear Asset Manager, Tivoli Service Request Manager (TSRM), Tivoli Asset Manager IT (TAMIT), SmartCloud Control Desk, T-SQL, JavaScript, Python & PL/SQL
- Oracle, SQL Server, DB2, WebSphere and WebLogic
PROFESSIONAL EXPERIENCE
Confidential - Pittsburgh, PA
Maximo Functional Analyst
Responsibilities:
- Import and Export Data to integrate new sites into current production environment
- Analyze and format data
- Fulfill support issues utilizing Jira
Confidential - St. Louis, MO
Maximo Functional Analyst
Responsibilities:
- Train System Administrators and develop documentation
- Present overview of Maximo for IT Team and develop documentation
- Develop complex Actuate Birt Reports and Cognos 11 (Report Studio, Analytics, Framework Mgr)
- Review application build for best practices
- Cross-functional team testing strategy, analysis of existing test strategy, gap analysis, and working across teams to mature test integration strategies
- Planning and managing of testing resources
- Solid understanding of testing tools (HPQC), processes and usage
- Ability to provide test progress and quality status reports at different levels
- Create test scripts and use cases.
- Develop technical design documents for ClickSoftware, Maximo, EPOCH, GIS applications along with integration
- Utilize Jira, Blueprint, and Sharepoint for change management
Confidential - Atlanta, GA
Sr. Report Developer
Responsibilities:
- Develop complex Actuate Birt Reports and Cognos 10.2 Tools including installation
- Gather requirements, prepare and distribute progress reports; manage risks and issues; correct deviations from plans; and perform delivery planning for assigned projects
- Develop Workflows for Supply Chain
- Develop complex SQL queries, procedures and scripts
- Data mapping, data modeling, data analytics
- Unix scripting
- Train other Report Developers on both Birt and Cognos 10.2 Tools
- Test and report all report build metrics
Confidential - Beaumont, TX
Technical Lead / Business Analyst
Responsibilities:
- Elicit and document requirements for Maximo 7.5 new implementation including BRD, functional specifications and technical specifications
- Prepare and distribute progress reports; manage risks and issues; correct deviations from plans; and perform delivery planning for assigned projects
- Document user stories and develop use cases
- Maximo Workflows development
- Maximo Interface development
- Created structured QA process and methodology in line with project management methodology
- Planning and managing of testing resources
- Develop testing strategy; Create test scripts
- System admin duties including development of Actuate Birt reporting
- Data mapping, data modeling, data analytics
- Data cleansing and data upload
- Develop business requirements and process designs
- Unix scripting
- Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams
- Install and configure Maximo HSE, Maximo Integration Framework (ETL and integration tool), Migration Manager, WebSphere
Confidential - Atlanta, GA
Software & Hardware Asset Management Analyst
Responsibilities:
- Elicit and document requirements for SCCD / Maximo 7.6 enhancements
- Perform software asset management data analysis for IBM Licensing & MS Remediation
- Develop business requirements, write functional specifications, variety of business analysis tasks
- Utilize a variety of tools to obtain software data such as TADDM, Tivoli CMDB, SCCM, Report Builder, Excel
- Built reports using Report Builder, Cognos 10.2 tools
Confidential - Charlotte, NC
Sr. Data Analyst
Responsibilities:
- Data loading via the MIF for Maximo 7.6.3
- Validate the quality and quantity of data records
- Development of legacy systems extract scripts
- Perform data analysis, data mapping, data loading and data cleansing
- Utilize Talend as ETL tool as well as custom scripting
- Build associated documentation including business process and data diagrams
- Write PL/SQL scripts to perform a variety of tasks
- Write Unix scripts
Confidential - Evansville, IN
Sr. Business System Analyst / Maximo Business Analyst
Responsibilities:
- Elicit and document business requirements;
- Develop BRD
- Develop business process diagrams
- Perform IT testing including end-to-end testing
- Contracted to conduct business process analysis and identify key issues, gaps and needs
- Develop test cases and test strategies;
- Performed Data Analysis, Data Cleansing, Transformation and Integration for testing
- Develop, design, and test ESRI
- Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams
- Analyzed, created and maintained Master Data
- Develop functional specifications
- Act as liaison between developers, release management team and business
- Projects consist of utilizing a variety of software including:
Environment: CPAS, Banner, ESRI/ArcGIS, Tibco BusinessWorks, Tibco iProcess, Maximo 7.6 with Linear Asset, SQL Navigator, Toad for Oracle, Talend, FOCAS, Service Hub, SSIS, and Virynet G4
Confidential - Folsom, CA
Maximo Administrative Specialist / Functional Engineer
Responsibilities:
- Elicited and documented business requirements
- Developed and wrote Requirements Specifications, Report Specifications, Test Specifications and Use Cases;
- Lead customer demos
- Suggested process and technology improvements
- Analyzed, created, and maintained Master Data
- Data Migration via Migration Manager and PL/SQL scripts
- Performed Maximo system admin duties
- Maintenance and troubleshooting of Unix, Websphere, Oracle dB and Maximo
- Wrote complex queries for testing and reporting; UAT and End-to-End Testing
Environment: Maximo 7.5 with Linear Asset, Java, Toad, Sharepoint, Visio, Oracle dB, Agile / Scrum SDLC, BIRT Report Design, Maximo adhoc reporting, Excel/VBA, Access/VBA, MS Project, XML, WebSphere
Confidential - Peoria, IL
Sr. IT Analyst
Responsibilities:
- Manage all aspects of project delivery including budget, schedule, scope, weekly meetings, risks and issues
- Overall system maintenance of MRO MainControl (Maximo) system
- Maintenance and troubleshooting of SQL Server and MainControl
- Elicited and documented business requirements into logical and physical data models
- Installation of Remedy Asset Management, Smart Cloud (SCCD), and Hardicat Asset Management applications
- Responsible for the architecting and modeling business data from the MainControl Asset Management database to Remedy Asset Management, SCCD, and Hardicat Asset Management software database designs and schemas;
- Developed Gap Analysis, Performed Data Analysis, Data Migration, Data Cleansing, Transformation and Integration
- Analyzed, created, and maintained Master Data utilizing Configuration Management Database (CMDB)
- Created database objects such as tables, stored procedures, functions, packages, triggers, indexes and views utilizing SQL
- Mass data loads via T-SQL scripting and ITIC, UAT Testing
- Create Test Scripts and Test Plans
- Created various deliverables, including specification documents, data mapping and data analysis documents.
Environment: MRO MainControl (Maximo), Smart Cloud (SCCD), ITIC, SQL Navigator, T-SQL, SSIS, SSRS, Excel/VBA, Informatica, MS Access/VBA, ITIL Service Design, MS Project
Confidential - Salisbury, MD
Project Coordinator / Sr. System Analyst
Responsibilities:
- Solution Architect for installation and configuration of new implementation Maximo 6.2, System Admin., WebLogic, JSP, XML, TRM Rules Manager and Oracle activities; Responsible for maintenance and troubleshooting for entire Maximo system
- Gathered business requirements, and wrote functional and technical specifications
- Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams
- Develop functional and technical documentation
- Developed complex procedures, scripts, triggers, and packages utilizing PL/SQL
- Performed Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import and Data Export
- Analyzed, created, and maintained Master Data
- Created various specification documents, data mapping, and data analysis documents
- Extensive use of Application Designer, Database Configuration, Workflow, and Maximo Enterprise Adapter (ETL and integration tool)
- Led teams across broad technical, financial and business disciplines
- Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results
- Mitigated risk factors through careful analysis of financial and statistical data utilizing SAP
- Cross-functional team testing strategy, analysis of existing test strategy, gap analysis, and working across teams to mature test integration strategies
- Planning and managing of testing resources
- Create test scripts and use cases.
- Solid understanding of testing tools (HPQC), processes and usage
- Ability to provide test progress and quality status reports at different levels
- Anticipated and managed change effectively in rapidly evolving global business environments
- Liaison between Perdue and IHS parts cleansing effort
- Created technical documentation for knowledge transfer to Product Support
- Introduced software configuration management to company
- Performed UAT and end-to-end testing
- Installed and configured Syclo Mobile App to work with Maximo
- Managed the accomplishments of unit assignments through planning and controlling staff activities
- Report writing with Business Objects, Crystal Reports, Actuate Rptg, MS Access, and Excel pivots
- Trained business and technical users on use of Maximo and related products
- Troubleshoot problems and determine root cause
- Coordinated contracted report writer tasks
Environment: Maximo 6.2, Mobile Work Mgmt, SAP, Oracle, Toad, MS Office, MS Access, PL-SQL, VBA, DataLoader, DataEase, Crystal Reports, Actuate Reporting, Visual Source Safe, MS Project, WebLogic, RulesManager
Confidential - Mirimar, FL
Sr. Systems Analyst
Responsibilities:
- Gathered business requirements for software development in order to compose functional specifications, development plans, develop test plans, and test scripts for custom SQL Server
- Developed T-SQL stored procedures, triggers, packages, triggers, views and queries to retrieve data;
- Spearheaded the analysis of booking option code misuse
- Worked with auditing team to analyze present state of use and presented findings and recommendations to upper management
- Utilized Informatica as mapping and loading tool
- Utilized Mercury Test Director for testing
- Analyzed and developed adhoc requirements
- Collaborated directly with business units to assess the technical impact of business requirements and to reach consensus on alternative solutions when necessary in an effort to maintain a consistent yet flexible architecture
- Provided complex code for software functionality and performed T-SQL tuning and optimization; AS400 data analysis.
- Unix scripting
Environment: SQL, Mercury Test Director, AS-400, MS Office, SQL Navigator, Informatica, MS Access, ITIL, RUP
Confidential - Tallahassee, FL
Data Analyst / Report Writer
Responsibilities:
- Utilized Cognos Series 7 Tools for report development and delivery; Developed complex T-SQL scripts, stored procedures, and queries for data extracts from OLAP Cube built with Cognos tools
- Created data cubes, dimensions and KPIs using SSAS; Analyzed, created, and maintained Master Data for all reporting
- Report solutions included creating MS Access and Excel Pivot Tables
- Developed detail and summary reports as well as line and pie charts, trend analysis reports, and sub-reports; Insurance industry knowledge was required for effective report writing and metrics analysis
- Collaborated directly with business units
- Assisted in data warehouse development from DB2 to SQL 2005
- Conferred with persons originating, handling, processing, or receiving reports/interfaces to identify problems and to gather suggestions for improvements
- Recommended establishment of new or modified reporting/interface methods and procedures to improve report/interface content and completeness of information
Environment: MS Office, MS Access, VBA, VB, SSAS, Cognos Series 7 Tools, SQL, MDX, SSRS, T-SQL, DB2
Confidential - Washington, DC
Maximo System Analyst
Responsibilities:
- Lead Consultant on the upgrade installation and implementation from Maximo 4.01 to 5.1 for 350+ users that included upgrade and migration of data on both Oracle and Maximo
- Configured and customized Maximo solution to meet business objectives and define strategic asset management objectives
- Created tables, stored procedures, triggers, and packages for both SQL and Oracle databases
- Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams
- Provided leadership and direction to project team by understanding business processes, documented business processes, gathered requirements, identified potential usability issues, managed scope, and ensured that an appropriate level of application quality was maintained at all times
- Managed the accomplishments of unit assignments through planning and controlling staff activities
- Performed all System Admin duties; Security Definition Management, configurations and User Role Definitions
- Developed Maximo Upgrade Project Plan and timelines
- Wrote training documentation for training classes in Maximo, Crystal Reports, and Building Maintenance in one-on-one settings and classroom environment
- Led the data collection and cleansing effort for upgrade; Installed and configured Syclo Mobile App and hardware to work with Maximo
- Reengineered existing system and documented entire system architecture in order to begin the upgrade process
- Developed and wrote BRD deliverable
- Documented the entire system hardware and software platforms that Maximo was built upon
- Wrote technical documentation for maintenance of system
- Designed all custom and adhoc reports utilizing Crystal Reports 9.0, MS Access, Actuate Reporting and SQR for PMO Pentagon; JSP development
- Communicated in written and verbal format with both administrative and management level users; Lead JAD/JAR sessions
- Documented, designed, & analyzed business processes was the lead technical person on the project whose duties and responsibilities included system design and analysis, database design, coordination of all development and maintenance programming, and also acted as the user/software developer liaison
- Developed stored procedures, triggers, and queries to retrieve data
- Created automated scripts and jobs
- Created database objects such as tables, stored procedures, functions, packages, triggers, indexes and views; Data Integration (internal & external)
Environment: Maximo 4.01, 5.1, Oracle, T-SQL, Crystal Reports, MS Office, MS Project, MS Access, Actuate Reporting, SQR, JSP, Toad