SUMMARY:

• Very deep and high quality experience of over 30 years in many aspects of IT development in diverse industries. This experience includes over 14 years in Mainframe and 16 years in SAP that includes 8 years in all phases of SAP BW and 6 years of Business objects (BO) as well as many functional areas of ECC.
• Had formal training from SAP America in the WEBI design, dasboards, Universe design, Lumira, Design Studio etc. and worked as a developer, architect and lead for many new sysytems. Designed fairly complex Business Objects universes from scratch.
• Led a major international upgrade from BO 3.1 to BI 4.1. The duties included working with the users so that all of their applications and reports were properly converted including converting Deski to Webi reports, installing and testing all of Business Objects tools etc.
• Connected Business Objects to a variety of data sources including BW BICS connection, Cognos, Teradata, Oracle etc.
• Trained users and super users in the Business Objects fundamentals and reporting including WEBI reporting and dashboards.
• In the latest assignment, worked as the Business Objects/BI lead developer for the Americas and Asia/Pacific (including Australia, Singapore, Indonesia etc.) for Confidential in Houston. Responsible for the development of many business objects systems from start to finish.
• Familiar with many reporting tools like Spotfire, Tableau etc.
• For BW:
• SAP certified in BW and have extensive experience in almost all areas of BW (FI/CO, SD, MM, PS, HCM, APO etc.) including data modeling, installing and enhancing business content, Integrated Planning, process chains, DTP’s, transformations. Performance tuning, heavy Info Cubes and Confidential /DSO design, data loads etc.
• Heavy Confidential /BI reporting including developing complex reports, Web reporting and SAP Portals
• Proficient in ABAP on both the ECC and BI side.
• For ECC:
• Seasoned functional knowledge of numerous SAP modules and tables including FI/CO, SD, MM etc. Involved in the analysis, design, programming and implementation for extremely large and complex systems for many prestigious organizations.
• For Mainframe:
• Have extensive experience in mainframe including programming languages like COBOL and PL1, use of JCL, databases like IMS, DB2, Adabas etc., online development like CICS etc.
• Other:
• Experience in multitude of Client Server Environments like SQL Server, Oracle, Access, Visual Basic, Power Builder, etc.
• Extremely successful in always producing high quality work, called upon to solve most complex problems and invariable produced the highest user satisfaction. Example, ExxonMobil hired me for 3 months, kept me for 16 years breaking their rules of not keeping the contractors for more than 4 years and judging me to be their best contractor ever.
• Had many consulting assignments specifically to design strategy to integrate multi - platform and multi-system systems and resolve the issues. These included Oracle, BW, Teradata systems internationally with different versions of BW, ECC etc.
• Very flexible and can work either alone or lead small, medium or large teams in both functional and technical areas. Very experienced in working with, and leading if necessary, diverse international teams.
• Because of quality reputation, chosen a member of the 12 member quality control team to improve quality at EDS, a 100,000+ employee company with direct access to the CEO.
• Excellent Communication and interpersonal skills. Highly team oriented and easy to get along with.

WORK EXPERIENCE:

Confidential, Houston, TX

Business Objects Lead

Responsibilities:

• Defining user requirements.
• Designing/developing universes, designing/developing reports.
• Designing security with the BO Admin staff.
• Building the reports in Web Intelligence, Dashboards, crystal reports, connecting these to diverse data sources including oracle, Cognos, SQL Server, Teradata, Data Warehousing, BW etc.
• Training users and super users in Business Objects start up and reporting including WEBI reports and dashboards.
• Testing in the development environment, migrating/testing in the acceptance environment and then migrating to production.
• Post production support, resolving/fixing user issues and the documentation. Used Remedy system for support.
• Teaching the users including the super users how to use the Business Objects, how to run/schedule reports, how to make changes to reports, how to build new reports/dashboards, MDM reporting etc.
• Worked with teams of onshore/offshore team of many countries to build very highly successful, high quality systems that were considered very challenging, under budget and on time in Business Objects 4.1 that included diverse data sources including BW and Teradata.
• Also worked on the effort to upgrade the worldwide Business objects to version BI 4.1 from BO 3.1 (and sometimes earlier versions of BO) with diverse software bases and platforms. This was a massive effort and involved - Installation, application testing, performance testing and resolution of issues with full suite of BI 4.1 products including the Web Intelligence, Dashboards, Crystal Reports, Information Design Tool, UDT, BICS connection for BW, HANA reporting, Design Studio, Analysis for OLAP, Lumira, security etc.

Confidential, Tyler, TX

Senior SAP BI Consultant

Responsibilities:

• Worked as a senior BI consultant in support of their sales and distribution systems as they went through a major implementation.
• Some key client consultants had quit. the implementation at a very short notice extremely well reducing key load times from 14 hours to 5 hours.
• More than 100 requests were implemented in production without a problem.
• Designed/developed the purging systems for DSO’s and InfoCubes that got excellent reviews by the client.

Confidential, Houston TX

BI/ECC Lead

Responsibilities:

• The client had gone through a major 5 tiered new allocations process for their complex global upstream business due to Confidential requirements.
• Developed innovative backend techniques and complex financial reports including using Confidential cell editor to trace all costs, their distribution and flow as those go through from the First Spend to Net Income phases.
• The reports were presented to the CFO and got extremely favorable reviews.
• Also developed innovative systems in ABAP to trace the costs all the way to the original cost centers for the multi-tiered allocations.

Confidential, Jacksonville, Florida

BI/ECC Lead

Responsibilities:

• Coordinated quality review of specifications, designing backend solutions including some complex scenarios, developing the backend and frontend reports, ABAP programming on BI as well as ECC side, resolving major technical and functional issues across many HR modules (PA, OM, BN, PT, PY etc.) working with delivered HR modules like 0PA C001, 0OM C01,
• 0PT C01, 0HRPOSITION, 0EMPLOYEE etc., establishing portal links and roles, data loads, establishing automated process chains, post implementation support etc.

Confidential, Houston, TX

BI Developer / Architect

Responsibilities:

• Installed many new business content extractors including the new general ledger.
• Solved some very complex, critical issues with FI extractors and developed very innovative, user friendly flat file load ABAP validations/transformations that won big acclaim.
• Translated user requirements into technical specifications and designed, developed DSO’s, transformations, InfoProviders, Virtual InfoProviders, complex web queries, process chains, modification of extractors and queries thru user exits for financial Budgets and Actuals data.
• The systems were developed in Houston, London, England, Malaysia and Philippines.

Confidential, Long Island, NY

BI Architect

Responsibilities:

• Developed business requirements and performed gap analysis for the client’s information requirements vs what was being delivered from the standard business content in the areas of FI/CO, SD, MM, PP, WM etc. Environment was BI 7.0.

Confidential, Chicago, IL

Senior BW Architect

Responsibilities:

• Led a team of experts in requirements gathering, blueprint of requirements design, technical design and development.
• This was one of a kind, heavily customized system which would track all of their projects worldwide, their actual and planned costs/revenues, perform allocations and produce reports at various levels.
• Built custom DSO’s, Info Cubes, Multiproviders, Info sets, Info Sources, Data Sources, transformations, Data Transfer Processes etc.

Confidential, Houston, TX

Senior BW Architect

Responsibilities:

• Worked as senior BW architect designing Global BW SEM/BPS Business blue prints for many different industries including Petroleum/Mining/Base Metals etc. spanning diverse countries for complex BW landscapes involving multiple R/3 instances for many systems including FI/CO and Project Systems..
• Involved extensively in international communication and travel for requirements definition, design reviews, approvals etc.
• Involved in analyzing the entire landscape, SAP early alert reports etc. for possible performance improvements and bringing the diverse R/3, BW landscapes to one global platform.
• Also involved in the day to day support/development for existing BW systems.
• Used DB2 Connect to connect to and transfer data from some legacy systems residing in DB2.

Confidential, San Francisco, CA

Senior BW Architect

Responsibilities:

• Was heavily involved in performance tuning for major reports looking at complete design from start to finish including backend design, aggregates, query runtime analysis etc.
• The reports were in the areas of Financial Management and Controlling.
• Compared actual and planning data from SEM/BPS, HR, Market Analysis as well as supported Professional Services.

Confidential, Detroit, MI

Senior BW Consultant

Responsibilities:

• Duties included researching and designing best strategies for integrating their systems.
• Designed innovative solutions that solved complex business problems and substantially improved performance.
• The BW work was highly customized with new Confidential ’s and InfoCubes as well as used the standard business content for FI GL, Special Ledger, Cost Accounting and Profitability Analysis including COPA that was enhanced according to customer requirements.
• Worked closely with the reporting team to make sure that the backend design met and exceeded all reporting requirements.
• Used UD connect to retrieve data from non-SAP systems in Oracle and SQL server sometimes using remote cubes to access data directly.

Confidential, Boston, MA

Senior BW Consultant

Responsibilities:

• Duties included creating transactional planning cubes. planning areas, designing planning templates, using planning functions, creating multiproviders to join actual and planning cubes, process chains to load data, run programs, utilities etc, creating and loading Confidential ’s, InfoCubes, transfer rules, update rules, master and generic data sources
• Created Confidential queries from multiproviders joining the actual and planning cubes,, workbooks etc.

Confidential, Dallas, TX

Senior BW Consultant

Responsibilities:

• Installed the business content, developed ABAP custom function module generic data sources in R/3 to extract data into BW, installed InfoCubes, Confidential ’s and created custom InfoCubes, transfer and update rules to load data from generic data source and designed Confidential and web reports to meet specific user requirements.
• Developed drill down reports for the consolidation system to balance to the source data at line item level.

Confidential, Phoenix, AZ

BW Technical Manager

Responsibilities:

• Duties included coming up with the architecture, detailed user requirements analysis, design of the processes, data modeling, resolving business and technical issues, coordination with personnel worldwide including programming, testing and implementation.
• Users requested significant changes to the business content InfoProviders that involved many ABAP user exits and functions, generic data sources etc.
• Many customized web reports were developed to suit extensive needs of the customer; some of the creative designs were much appreciated. Designed the data loading strategy for the master and transaction data.

Confidential, Houston TX

Senior BI consultant

Responsibilities:

• The environment was a mixture of BW and Oracle for data warehouse tables and BW Confidential and MicroStrategy for reporting. Informatica was being used as the ETL tool.
• The main applications were HR (Human Resources), FI/CO, Upstream business (drilling, exploration etc.).
• For MicroStrategy acted as an administrator.
• For BW, handled the maintenance of ECCS and HR projects including setting up process chains for loading data etc, debugging production problems including performance and HR queries, writing ABAP user exits to enhance SAP extractors as well as leading a broad strategy design to expand the use of BW as an integration tool throughout the company.

Confidential, Bristol, TN

Senior BW Consultant

Responsibilities:

• Duties included installation of the business content including InfoCubes, InfoObjects, Datasources, InfoSources, Queries etc. for the Sales and Delivery System.
• Installed SD, MM, IM and PS systems, modified the business content according to the user business and requirements.
• Other tasks included loading data from R/3 into BW, running, modified queries, wrote customer exit ABAP code for Confidential variables and validated the data against R/3. Published the queries to Web using the Web application designer and graphic tools.

Confidential, Houston, TX

Senior BW/ABAP consultant

Responsibilities:

• Primary responsibility of creating automated Controls between the R/3 and BW systems for their Business consolidation (ECCS), Assets Management (AM) and Materials Management (MM) systems.
• Wrote ABAP programs on R/3 to extract data from the R/3 tables, the corresponding data from BW InfoCubes tables using Remote Function Calls, compared and produced control reports with automated abends and emails for any out of balance situations.

Confidential, Buffalo, NY

Senior ERP consultant

Responsibilities:

• Studied the business content, recommended and installed proper InfoCubes, Confidential and queries.
• Heavily customized the business content with new fields and populating of many existing fields using SAP ABAP user exits.
• Designed Confidential queries with offset variables and wrote SAP ABAP user exits for Confidential variables.

Confidential, Fremont CA

Senior BW Consultant

Responsibilities:

• Duties included building large custom InfoCubes to convert their Sales Forecasting and Analysis system from SQL Server to SAP BW 3.0B using a third party tool, Ascential/DataStage, for data extraction.
• Some fields were populated from SAP R/3. Used extensive data modeling. Also assisted in the installation of CRM module.
• The highly interactive approach with the users and top management for the systems design received excellent reviews and user/management satisfaction.
• Designed Confidential query reports, designed transactional InfoCubes and planning templates for forecasting using SEM/BPS, wrote SAP ABAP exits for variables, transfer rules, update rules including start routines, trained users and helped to convert to Web reports.

Environment: SAP 4.6C, BW 3.0B, SEM 3.1B, SQL Server, UNIX