SUMMARY:

• IT Professional with more than 20 years of North American experience in BI, EAM, Supply Chain and Database Programming with Utility, Consulting, Manufacturing and Financial Institutions.
• Wide experience with Maximo EAM in Asset, Supply Chain and Work Mgmt Modules.
• Extensive Experience with Maximo Data Migration/Conversion and Reporting.
• Experienced in requirement gathering, design, development, testing and implementation of Maximo data warehouse (EDW) and enhancements in Waterfall/Agile software development environments.
• Strong ETL & OLAP experience, coupled with hands - on expertise with various ETL tools, such as Confidential DataStage,MS SSIS and BI/OLAP tool like Cognos, Actuate and BIRT.
• Experience in providing leadership and mentoring ETL and report developers and data analysts on Data Lineage strategy and implementation. Actively participated in architecture governance activities related to BI and analytics.
• Superior SQL,PL/SQL skills and ability to write and interpret complex PL/SQL statements and also mentor developers on SQL optimization and ETL debugging and performance tuning.
• Leading technical teams in software development and implementation projects involving Data Warehousing, Data Integration and Data Migration activities.
• Collaborating with business, functional and technical teams to capture customer requirements correctly into functional specifications and driving the implementation of solution through completion.
• A good team player with excellent communication skills, cooperative and knowledgeable provider of strategic technical leadership. Always open to learn and implement new ideas.

TECHNICAL SKILLS:

DB Language: SQL, PL/SQL, T-SQL and Access

BI/Analytics: Access, Crystal, Actuate and Cognos, BIRT, SSRS, SSAS

ETL: DataStage, SSIS

OS: Unix/Linux and Windows

ERP: Maximo, Avantis, Fourth Shift, SAP and PeopleSoft, JD Edward

App Server: BEA WebLogic, Confidential Websphere

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Technical Consultant

Responsibilities:

• Lead & Assist Data Conversion/Migration from Legacy Systems (Asset Suite) into Maximo.
• Maximo Data Sync up and Loading with built-in and External Utilities (MIF and PL/SQL Script).
• Meeting Clients and gather requirements to Create and Maintain Conversion Functional & Technical Design.
• Develop/Modify Automation Scripts as required by Business to enhance the Application Functionality.
• Manage and Guide Onshore and Off-shore Technical Team as required.
• Defect Resolution and Remediation.

Confidential, Charlotte, NC

Technical Consultant

Responsibilities:

• Meeting with client and Gathering requirements for Design and Development of Functional and Technical Design.
• Configuration and Enhancement of Functioality using Aplication Designer and Automation Scripting.
• Lead & Assist Data Conversion/Migration from Legacy Systems (CASCADE, WMIS) into Maximo.
• Data Sync Loading with Maximo built-in and External Utilities (MIF and PL/SQL Script).
• Performed data validation, data profiling and data cleansing activities to ensure high quality data conversion/migration into the Live System.
• Capturing Delta during Cutover and Migrating them to Live System.
• Post go-live day to day Support and Troubleshooting.

Confidential, Richardson, TX

Technical Consultant

Responsibilities:

• Requirements Gathering and Modifying functionalities to Application Packages
• Functional Design and Technical Design Documentation
• Develop PL/SQL Packages/Procedures/Triggers in Oracle Database
• Unit Testing and Regression Testing
• Implementation and post Implementation Support

Confidential

Technical Consultant

Responsibilities:

• Configuration, Integration, Support and Maintenance of Confidential Maximo v5/v6/v7
• Lead & Assist BI and Data Conversion/Migration Projects for Maximo using MIF, PL/SQL and T-SQL scripts.
• Extract, Transform and Load Maximo Data using DataStage and SSIS.
• Defining Keys, Attributes and Entities for Maximo Data Warehouse. Design, Develop and tune DataStage Jobs for Maximo Data Warehouse.
• Source to Target Mapping and Applying Business Rules for ETL Development (DataStage).
• Maximo Configuration and Package Migration.
• Perform data validation, data profiling, data auditing and data cleansing activities to ensure high quality Cognos report deliveries·
• Report development with BIRT, Actuate, Crystal and Cognos.
• Database programming with PL/SQL (Pkg, procedure, functions etc.) and T-SQL for Data Migration.
• Performance Tuning & Optimization of PL/SQL & T-SQL codes in Application database.
• Day to Day Support and Troubleshooting.
• Space Allocation and Database sizing as required.

Confidential, Dallas, TX

Technical Consultant

Responsibilities:

• Implementation, Configuration, Integration, Support and Maintenance of Confidential Maximo.
• Defining Keys, Attributes and Entities for Data Warehouse.
• Data Mapping and data modeling for Data Warehouse.
• MEA Integration and Configuration for Near Real-time Maximo Data Warehouse.
• Data Mapping and Conversion/Migration from Legacy System (EMAPC, PASSPORT) into Maximo 6.x and Maximo Data Warehouse.
• Report Rationalization and Consolidation from Legacy Systems into Maximo.
• Design and development of ETL jobs, ensuring quality and compatibility of the code, review of technical documents, coding and job designed.
• Source to Target Mapping and Applying Business Rules for ETL Development.
• Meeting with client and Gathering requirements.
• Data modelling and SQL development with performance tuning for BI Reporting.
• Development, Unit test, user test and QA, and Deployment of Applications/PL/SQL Code and BI reports.

Confidential

Sr. Infrastructure Engineer

Responsibilities:

• Requirements Gathering and Developing reports with Actuate 7.x
• Data Modelling, PL/SQL Programming for Actuate Report.
• Test and Deploy Actuate (7.x and 8.x) Reports in Unix Env.
• Capacity Planning, Specification for BI Shared Environment Infrastructure in Unix OS for Different Clients.
• Architect and Design BI Infrastructure (Actuate and Cognos) as required by Client.
• Installation, Configuration and Maintenance of Actuate Cluster iServer (7.x, 8.x) and Cognos Cluster Servers in Unix Environment.
• Implementation of Java based RSSE with LDAP Server in Actuate 8.x iServer.
• Built Small Application to Upload/Download reports from iServer using Actuate IDAPI.
• Development and Enhancement of existing eSpreadsheet Reports.
• Resolved Memory Leak Issue with eSpreadsheet Engine.

Confidential

Technical Consultant

Responsibilities:

• Implementation, Production Support and Maintenance of Confidential Maximo v4/v5
• Conference Call / Meeting with client, Requirements Gathering, Laying out Mock-up for maximo 5.x Reports.
• Installation, Implementation and Configuration of Maximo 5.x and Actuate 7.x iServer in WebLogic and Oracle Environment.
• Data Mapping, Data Modelling for Maximo 5.x reports with Actuate 7.x.
• Writing Specification and Laying out Report mock up.
• Data Analysis and Web Reporting for Maximo EAM with Actuate.
• Development, Unit test, user test and QA, and Deployment of Actuate reports.
• Train employees with Actuate 7.x to develop reports for Maximo 5.x

Confidential

System Integrator

Responsibilities:

• Development and modification of Gas Measurement System using PL/SQL and Unix Script.
• Requirements Gathering, Analysis, Design and Development of Desktop and Web Applications with VB, Access and Oracle PL/SQL.
• Data Analysis, modelling and Ad-hoc Web Reporting with Actuate, Crystal and PL/SQL.
• Creating fixed length flat file from Oracle and bulk loading into another database.
• Project Management/Lead for Small/Medium groups.
• Performance tuning, modification and maintenance of Oracle DB objects.
• Automated some business processes and Integrated with the Main System.
• Weekly meeting with Business clients to analyze and document business Issues, problems, requirements and make recommendations to technical system solutions.
• Provided Training and excellent Presentations to team members and business clients.
• Effectively provided overall support for 7x24 Business Critical Applications and maintained the Service Level Agreement (SLA).
• Installation and Configuration of Avantis in Windows and Oracle Env.
• Develop and modify interface between EAM (Avantis) and ERP (PeopleSoft) using VB, PL/SQL and Access.
• Coordinate Bulk Loading of data to Oracle DB and Data Synchronization between Avantis and PeopleSoft Financial on a monthly basis using VB, PL/SQL, Access and Crystal.
• Creating support documentation for future reference.

Confidential, Dallas, Texas

QA & Implementation Consultant

Responsibilities:

• Configure and Customize Fourth Shift Manufacturing Software (FSMSS) System.
• Implemented the Quality Manual leading to ISO 9002 certification.
• Maintain and support Fourth Shift Manufacturing Software (FSMSS) System.
• Project Management and Technical Lead for small group.
• Desktop support, trouble shooting and configuration of Novell Netware environment.