CAREER SUMMARY: SAP America Certified Business Warehouse Applications Consultant since 1999 BW 1.2B to 7.3, BI 3.1 4.1 and BWA 7.0 7.2 . SAP America Certified HANA 1.0 Application Designer. PMP Trained.

• As a full-service technology and SAP BI BW Solutions Professional, Mahmoud Soliman is currently a SAP BW, BI, HANA solution architect and technical lead for International and Global project. Mr. Soliman has over twenty years of management and technical consulting experience, the past fifteen of which has been focused on SAP Enterprise Resource Planning ERP , BW, BI, SAP HANA, Data Integration solutions. His vast experience over the course of his career has included working hands on doing development work, configuration, business analysis, blue printing, writing functional and technical specifications, testing, training, and post go-live support.
• Confidentialleverages his extensive hands on SAP HANA 1.0, SAP Lumira 1.0, SAP BW 7.3, SAP BI 4.0, and SAP ECC 6.0 knowledge, program management skills, ETL solution architecture, Database design and system skills as well as his expertise across the full range of logistics financial processes to act as the lead architect one of the largest SAP Netweaver based service oriented architecture solutions in the Defense/Public Sector with US ARMY.
• Confidential worked as a SME SAP HANA 1.0, Principal BI / BW Technical Advisor Data Architect for a number of key leading companies in variety of industry diverse clients assisting them in defining SAP EDW Enterprise Data Warehouse strategy, SAP strategic processes and ETL technology transformations along with database and system landscape design. Having been involved in several major implementations of SAP HANA SAP BW/BI solutions across several industries, Mr. Soliman brings high level of knowledge, hands-on experience, and professionalism to any SAP ERP and Enterprise Data Warehousing arena.

Specialties:

• SAP BI BW Technical and Solution Architecture, SAP HANA Technical and Data modular, ERP Project Management, SAP Master Data Management Solutions, Enterprise Financial Logistic Solutions, and Database and System Landscape Design. Working with Global implementation projects requiring multi-country collaboration following standard industry ASAP Methodology
• Ability to quickly understand business functional requirements and turn it into conceptual Logical data models, team up with Business, Functional, and Technical co-workers, and work under limited supervision in a fast-paced environment required. Defined and Provided Technical View's and System View's for DODAF.
• Extensive hands-on experience on SAP HANA 1.0, SAP LUMIRA 1.0 , BI Dashboard, BI WEBi, BI Analyzer, BI Crystal Report, BI Explorer, BI Design Studio 1.0, BW 7.3, BW BEX, BW Workbench, BW Admin Cockpit, SAP BWA 7.2, SAP Portals, SAP Solution Manager 7.1, SAP BI Data Services, SAP Master Data Management, SAP Master Data Governance, Early Watch, Wily Introscope tool, HP Quick Test Professional, HP Load Runner tool, BMC Remedy tool, and BMC Control-M Enterprise Manager.
• Enterprise Data Warehouse Solution Architect with wide-ranging hands-on experience good functional knowledge in the following SAP business process area FI-GL, FI-SPL, FI-AP, FI-AR, FI-AA, FI COPA, FI PCA, FM, MM-PUR, PS, SD, SRM-EBP, CO, PCA, IS-Retail, IS-OIL modules
• A strategic thinker noted for outstanding leadership, Excellent mentoring, analytical problem solving and team building skills that used to handle client in difficult circumstances multi culture team environment. Good grasp of dispute resolution, negotiation techniques, and other positive interpersonal skills.

WORK EXPERIENCE:

Confidential

Sr. Manager - Management Consulting

• Led and completed evaluation and research of Data Conversion Governance tools in collaboration with R D team, presented recommendation POC, and gained alignment for funding budget of 3.5 M for Global Automotive client
• Quickly learned client's EDW needs and provided global design proposals for data conversion, interfaces, analytics with SAP Non-SAP data, resulting in a new assignment to another project budget of 1.5 M for SAP HANA as Data Mart.
• Facilitate evaluation of functional requirements, close gaps, Technical requirements, recommend POC/Pilot, review results, identify risks, provide solutions, set expectations, identify deliverables, and create detailed project plan.
• Participated and facilitated Internal Leadership development program for our firm employees
• Acts as a Subject Matter Expert SME to support our firm sales org to meet and/or exceed their objectives on Solutions
• Demonstrated ability to clearly form and communicate SAP HANA BI ideas and thoughts for wide audiences including both technical and business level audiences.
• Established and supported KPMG Center of Excellence COE for SAP HANA BI team
• Participated in setting up and managing KPMG internal SAP HANA Training materials and environment
• Designed and implemented Functional Technical Solution for Loan Accounting Initiative for leader financial company

Confidential

HANA Technical Architecture

• Multi-tasking and supporting Procurement Self Services Team with their SAP HANA P2P Solution. Designing and developing multi BI reports using WebI and BI Explorer on HANA to enhance Lockheed Martin Buyer's Performance capability. Empowering LM Leadership and Power users with P2P Summary Real Time Reporting from ECC to HANA by leveraging real time SLT replication. Contributed in designing, modeling, implementation, and support of SAP HANA P2P solution. Strong background in multiple database technologies Oracle Sybase to design data models and analytical apps
• Quickly understand business functional requirements and turn it into conceptual Logical data models in HANA
• Identify functional gaps and develop functional/Technical solutions for each based on good understanding of ECC business processes and knowing the underlying functional tables and their BW Data Sources.
• Design SAP HANA data modeling using Attribute View, Analytic View, Calculation View, Procedures, and Triggers.
• Define, design, implement, monitor of SAP SLT replication schemas in SAP HANA from SAP ECC P2P FI modules.
• Created multi BI Webi, BI Explorer, and Crystal Reports based on universes on HANA. Diagnose, analyze, and give recommendation on data loading performance improvements using various reading and portioning techniques within HANA DB. Training end-users on SAP LUMIRA BI Explorer reports. Developing reports and documents for end-users on SAP LUMIRA BI Explorer based on HANA views universe 4.0

Confidential

• Primarily responsibility is the rollout of technical and functional aspects of the SAP BW on HANA solution. Participated Remotely and on-site in the integrated planning, design, implementation and support of SAP HANA based solutions including SAP LT Replication Server, SAP ECC, SAP Data Services, SAP BW, and SAP Business Objects in large and complex environments.
• Strong background in multiple database technologies Oracle Sybase to design data models and analytical apps.
• Experience with SAP ECC functional tables, BW Data Sources, BW extractors, and their data models.
• Designed SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Experience with SAP HANA programming including SQL Script, and CE-Script.
• Definition, design, and implementation of SAP SLT replication schemas in SAP HANA.
• Proven experience with reporting including handling complex scenarios using joins, Union and SQL Script.
• Implementation experience and knowledge of SAP BW reporting for different functional areas such as FI, FM, SD, MM.
• Experience handling integration between multiple systems for reporting using BW Bex, BI WebI, and BI Crystal Reports.
• Ability to administer, monitors, troubleshoots, analyze, and resolve HANA BW technical problems.
• Redesign and deploy some BW 7.3 InfoCubes and DSO's to take full advantage of HANA capabilities and new future.
• Diagnosed and recommended query and data loading performance improvements using

Confidential

Architect and Technical Manager

• Primary duty is to lead the effort to standup a BI Enterprise Strategy and Architecture to support Army Federated Financial and Logistics Reports from multi ERP Legacy sources systems such as PM GFEBS, PM GCSS-Army, PM LMP, CEFMS, and multiple DOD Agency systems. Provide technical/functional verification and analysis to ensure that our System Integrator Accenture development plans and deliveries are in line with PM GFEBS AESIP Integrated Master Scheduling and SDLC milestone for all BI and BW reporting capability. Scoped, Planed and managed the day-to-day operations of a BI BW implementation and release team. Formally review and approve program deliverables and worked products and recommend acceptance or revision based on government Power users and functional leads requirements.
• Worked with multi DOD Agency, trading partners, and end-users to understand/analyze their business requirements and provide direction and consultation on how to integrate into GFEBS AESIP enterprise data warehouse solution using BW BI MDM, Open Hub, and Web Services
• Participated in the Design and Development of functional and technical design specifications, global mapping data dictionary, cross multi data models for FM, FI-GL, FI-SL, FI-AP, FI-AR, SD,PS, Payroll and MM SAP
• Prepared and Perform BI 3.1 and BW 7.0 technical training for PM AESIP PM GFEBS end-users
• Provided overall program guidance and recommendations for SAP applications and best practices relating to all BI development. Provided templates to encourage consistency across US Army Enterprise systems doc.
• Worked with Infrastructure Oracle DBAs, Unix Admin, and Basis team for landscape design, Backup, Archiving, and capacity planning related to BI BW environments.
• In depth knowledge of project management principles and full life cycle development with commitment to high quality work during the different stages of the project Blueprint, Design, Develop, Test, Going live support
• Diagnosed and recommended query and data loading performance improvements using aggregate and indexes. Also Used BWA 7.2 with BW 7.1 to improve our BI BW financial and Payroll reports.
• Participate and working on prototype for SAP HANA 1.0 to replace current SAP BWA solution
• Contributed and supported Integration strategy to upgrade Business Objects 3.1 to 4.0 Tool Suite and supported BW 7.1 upgrade to 7.3 across landscape.
• Assist BI team on preparation of how to select the right BI 4.0 tool to replace current BW BEX reports.

Confidential

Technical Team Lead

• Data Warehouse Architect: Served as the focal point for the collections, consolidation, review, and prioritization of the client's SAP-BI business requirements, converting them into BI 7.0 technical specifications, and packaging them as technical work for the BI 7.0 consultants. Managed permanent and contract resources in production support and development activities for AES, raising service tickets and monitoring ongoing project work.
• Provide technical leadership for the super-user community, acting as the gatekeeper for change requests from the business and super-user community. Served as the primary hands-on technical lead for BW SCM and FI/CO modules.
• Managed BW solution including assessed training needs and developing end-user training class material.
• Participated, executed an architecture quality review process for BW application, recommended many enhancements for BW data module, and loading strategies from various sources to improve performance.
• Developed and maintained process chain to load data into ODS, and Info cubes, Drop build indices, build DB statistics, roll up aggregates, run attribute change run process, and Open Hub in BW.
• Troubleshooting and solving data load technical issues, SAP OSS Note research, and monitoring resolving BW BI production system issue with the Help Desk.
• Provided direction and coordinated NetWeaver BI 7.0 software upgrades including patches SPS packages.
• Developed FI-AP FI-AP and SCM reports using Crystal Report 10 for super-user community.

Leading Satellite Broadband Confidential

• NetWeaver BI 2004s Solution Architect: Primary duties are to manage and assist customers with major conversion of their Finance applications from multi sources Oracle Warehouse, Hyperion-Essbase, PeopleSoft, Legacy system, ECC 6.0 into One Global Data Warehouse using NetWeaver BI 2004s.Lead the BW Architect and Design efforts for Hughes Network to support functional and technical design efforts, including data flow diagrams and multi-dimensional data models for FI-GL, FI AP, FI-AR, EC PCA modules.
• Demonstrated leadership skills and team player strengths with excellent problem-solving and analytical skills.
• In depth knowledge of project management principles and full life cycle development with commitment to high quality work during the different stages of the project Blueprint, Realization and Test .
• Complete knowledge of BW transports and hands-on diagnosis experience of transport issues/problems
• Diagnose and recommend query and data loading performance improvements using aggregate and indexes
• Communicate to SAP via OSS for problem solving and provide production support when necessary
• Implement and enhance standard BW business content. Design and develop data Sources generic, enhanced, and custom for extracting and staging data from SAP and non-SAP source systems to BW.
• Extensive Knowledge of BW Extractors from SAP R/3 4.6 and SAP ECC 6.0, as well as R/3 object dependencies, underlying tables and processes structures in functional modules. Ability to debug and fix extraction problems in BW.
• Deployed Financial reports on SAP Portal 6 using custom Web templates, IView's and Portal pages
• Developed and maintained process chain to load data into ODS Infocubes, build drop indices, build DB statistics, roll up aggregates, run attribute change run process, and open Hub in BW

Confidential

• Data Warehouse Architect: Responsible for designing the data architect solution for Retail Innovation System. Responsible as Data Architect to assess and evaluate the business requirements, design develop a data access solution using the SAP ECC 6.0 and SAP NetWeaver BI 2004s project.
• Prepare project related documentation Function Spec, Technical Spec, object designs, business rules, etc. during the different stages of the project Blueprint, Realization, and Test .
• Work with the other business team members to meet reporting requirements and developed custom queries.
• Implement and enhance standard BW business content for Merchandise and Assortment Planning. Design and develop data Sources generic, enhanced, custom for extracting and staging data from SAP and non-SAP source systems to BW.
• Document test plans and complete testing of solutions including unit, system, and integration testing
• Research OSS Notes and other outside services for solutions to problems and work with SAP Technical Services to apply OSS notes and required upgrades for SAP NetWeaver BI 7.0
• Extensive Knowledge of BW Extractors for Is-Retail from SAP R/3 4.6 and SAP ECC 6.0, as well as R/3 object dependencies, underlying tables and processes structures in functional modules. Ability to debug and fix extraction problems in BW. Working experience with Merchandise Management, POS, and Merchandise Assortment Planning.
• Strong analytical and problem solving skills. Ability to prioritize and delegate tasks appropriately
• Good grasp of dispute resolution, negotiation techniques, and other positive interpersonal skills
• Deployed Financial and Procurement reports on SAP Portal 6 using custom Web templates, IView's and Portal pages. Hands-on experience with ABAP coding to enhance/customize SAP ECC 6.0 Info sources

Confidential

Technical Team Lead

• Data Warehouse Architect: Responsible for leading and designing the data architect solution and identifying obtaining the data required to satisfy our DOI user's requirements. Assessed and evaluated the business requirements, design and develop a data access solution using IBM SAP methodology.
• Understanding and mapping the data that will be available in BW in business terms recognize the way end users want to analyze the data in BW reports and developing a plan to close any data gaps.
• Worked with functional and business analysts to translate functional design into BW technical specifications.
• Address other critical data design issues such as : Granularity of data and the potential for multiple levels of granularity, InfoCube partitioning , Need for aggregation, Ensuring overall integrity of all BW Models
• Establish connections to the BW sources, Activate the standard Business Content, Enable the standard InfoCubes and Queries, Enhance the InfoCubes and Queries as required, and Define authorization profiles and access for BW user's.

Confidential

Principal

• Data Warehouse Architect: Responsible for production support day-to-day operation of a 24X7 SAP-BW for the US DOD Department Of Defense . Assisting client going live in Jan 2006 with redesigned and remodeled their BW 3.5 Logistics Application. Participated and executed an architecture quality review process for BW application and recommended many enhancements for BW data mode and loading strategies for from various source systems.
• Developed and maintained process chain to Drop indices, load PSA, load ODS, activate ODS data, load data into Info cube, build indices, build DB statistics, build or roll up aggregates, and run attribute change run process in BW.
• Evaluating and enhance ABAP code performance in update rules End Start routine and data extractors.
• Troubleshooting and solving data load technical issues, OSS Note research, and application, creating or resolving BW production system tickets with the Help Desk.
• Developed, maintained, and monitored aggregates to tune query performance.
• Identify opportunities to place indices on ODS and tables to improve data extraction and query access.
• Analyze and correct production problems as they occur in the SAP BW system

Confidential

Data Warehouse Architect:

• Responsible for designing the data architect solution and identifying obtaining the data required to satisfy our user's requirements based on thorough understanding of the way the data will be used by end users to make business decisions. Coordinating and responsible as Data Architect to assess and evaluate the business requirements, and design develop a data access solution for the BW project.
• SAP Business Information Warehouse Team Lead: Supervised, coordinated, and assigned tasks to team members BW, Crystal Report 10, SEM-BPS, SRM-EBP and ABAP and reported status to high-level managements.
• Identifying the data in the source environment and mapping the data to the BW environment. Identifying data quality gaps and developing a plan to close data quality gaps
• Activated and enhanced standard business content data targets for FI-AP, FI-AR, FI-GL, FI-AA, and SAP/SEM modules to meet non-standard needs of the client
• Created Process Chains to load Master and Transaction data, Aggregate Maintenance, Change run, and Refresh Indexes for BW and SEM systems.
• Deployed Financial and Procurement reports on SAP Portal 6 using custom Web templates, IView's and Portal
• Administrative activities included data compression, Aggregate maintenance, and BW Statistics.
• Worked closely with conversion and Interface team to help them mapping AOL financial Procurements legacy systems into SAP - BW desired format modules.
• Possess a positive, can-do attitude and enjoy making a difference in the business through my contributions

Confidential

Sr. SAP BW Consultant.

• Data Warehouse Architect: Involved and worked with the BW Core Architect team to oversee the development of a detailed and global BW Data Warehouse architecture strategy for Exxon Mobil Corp for more than 100 countries around the Globe from different source systems SAP R/3, Oracle RDMS, and Legacy system .
• SAP Business Information Warehouse Team Lead: Responsible and Oversee the development and creation of the necessary BW objects InfoObjects, ODS, InfoCubes, InfoPackages, InfoSources, Datasources, Extractor, Transfer Rules, Update Rules to ensure that FI-AR, FI CO-PA and PCA data are extracted from R/3 and non R/3 systems into BW 3.0b.
• Performed the activation of BW 3.0B business contents that is necessary to support FI CO-PA and PCA data.
• Maintained and created generic extract structures and extended master data attributes from R/3 side and built/customized user defined InfoSources for master data and transaction data.
• Developed and created multi layers ODS that can be shared by different BW applications to obtain data from different source systems across multi geographical area for FI-AR, FI-AP,FI CO-PA and PCA data.
• Performed UIT and UAT testing and Used Transport Connector to perform Transports from Development to Test and Production BW systems. Trouble-Shoot any problems that arias during testing and solved most of user's issues that we have during this stage.
• Monitoring and scheduling InfoPackages to oversee and control the data loading process in BW using Autosys Scheduling tools.
• Created ad-hoc reports for upper management personnel using complex techniques, defined conditions, exceptions, filters, and publishing SAP/BW reporting to the Web using BW Web publishing wizard
• Involved in identifying various ways of speeding-up loading data into BW objects for large amounts of data such as parallel load, configure InfoPackages, making effective use of indexes and running DB statistics.

Confidential

Sr. SAP BW Consultant and Instructor

• Involved in the foundation work for upgrading the BW system from BW 2.0B to 3.0B.
• Evaluating BW 3.0B technical/functional features of BW 3.0B with a view to upgrading from BW 2.0 to BW 3.0.
• Conducted BW user training and technical sessions to transfer knowledge to users and new team members.

Confidential

• Responsible and Leading BW team within the DOJ to test and transport the current OLTP R/3 system and BW 2.0B development project from development system into consolidation then into production system starting with replicating Datasources metadata from OLTP system into each BW system and then the rest of the BW objects using the transport package and requests .
• Activated and enhanced standard business content data targets for MM-PUR and FI-AP modules. Supervise and perform the maintenance and repair of applications in accordance with technical and functional specifications.
• Oversee the creation, execution and documentation of tests necessary to ensure Sales application and technical environment meets performance requirements.
• Develop a high-performing, motivated work group by applying interpersonal communication and collaboration skills to achieve project goals and realize value. Help to identify client needs to support the sales effort.
• Installed and configured a new BW 3.0B server The new System includes MS SQL server 2000 running on Windows 2000 to replace the current BW 2.0B development system that resides in Washington DC HQ office
• BW Business Explorer and BEX Analyzer: Created and maintained ODS/InfoCube queries. Wrote complex queries, defined conditions, exceptions, filters, using BW BEX and BW Analyzer.

Confidential

PWC SAP BW Consultant: Participate in SAP's First Partner Ship FPS Program for BW 3.0B.Get a head start on understanding the quality of new 3.0 features and how these could be leveraged by our clients to develop a migration strategy, test case results, and develop lessons learned. Accomplished test areas Extracting metadata and data from another DBMS using DBConnect, Open Hub, Meta Data Exchange, Parallel execution of data load, ODS Enhancements, Multiple Data Source per file Source system, Toolbox/Formula builder in transfer and update rules.

GEORGIA PACIFIC Confidential

• Joined and worked with the BW-APO Architect team to oversee and supervises the development of a detailed BW. Developed architecture strategy for our client to use BW 2.1C standard info cubes to suit APO needs
• Data Warehouse Architect: Helping on all the phases starting from project preparation, realization, and designing, data modeling including logical physical data modeling, data flows between different systems like APO, SAP R/3 and Legacy Systems.
• SAP Business Information Warehouse 2.1C Team Lead: Responsible and leading all BW developments phases to use BW as a source of historical data for SAP - DP and a tool for reporting on accuracy of the demand planning process.
• A new installation of version BW 2.1C A new BW System and server reside in Montreal, Canada to replace the current BW 1.2B 2.0B system running in Atlanta. The activation of BW business contents that is necessary to support the needs of APO.
• Developing a reporting mechanism application for APO such as Forecast Accuracy of the demand planning process and enhance the current BW 2.0B reports in Atlanta, Georgia.

Confidential

• Had several rules in the SKU Management BW Project at Gillette to offer a systematic method regular and ad-hoc reports system for managing inventories and product portfolio profit, reduce their slow and non-moving inventory and analyze Gillette's forecasted product portfolio, which is based across geographies in USA, Canada and Germany offices.
• Data Warehouse Architect: Participated and worked with the BW Core Architect team to oversee and supervises the development of a detailed BW development architecture strategy for Gillette. Helping on all phases starting from project preparation, realization, and designing. Data modeling including logical physical data modeling, data flows between different systems like APO, SAP R/3 Legacy third Party Systems,
• SAP Business Information Warehouse 2.0B Team Lead: Responsible for Front-end and Back-end development and Overall project management, assignments of tasks and job to team members.
• Successfully worked closely with each BW team members to ensure consistent approaches and provide technical assistance that required ensuring successful completion of individual project tasks. Participated in the development of enterprise BW naming conventions and standards for Global Data Warehouse.
• Created multi layers ODS that can be shared by different BW applications to obtain data from dissimilar source systems across multi geographical area and create basic SKU Management InfoCubes FI-AP, FI-AR, SD and MM-PUR that will produce the regular and ad-hoc reports for Gillette upper management user.
• Maintained and scheduled InfoPackages and controlled the loading process using Autosys Scheduling tools.
• Conducted user training and technical sessions to transfer knowledge to supper users and new team members.
• SAP R/3 and ABAP/4 Workbench: Maintained and created generic extract structures and extended master data attributes from R/3 side and built/customized user defined InfoSources for master transaction data.
• Trouble-Shoot any problems that arias during transporting BW objects from development to test and production environment. Attained on the job project management and leader ship skills in addition to a thorough understanding of relational database structures, star schemas, and OLAP concepts.

Confidential

Confidential Sr. Consultant - Confidential

• SAP Business Information Warehouse 2.0B - R/3 4.6C: Joined SAP/BW Upgrade Team with primary duties are to upgrade and enhance SAP/BW Sales Distributions and Account Receivable modules from BW R. 1.2B to BW R. 2.0B, activating and enhancing the SAP/BW standard business contents.
• Bringing together the Sales and Distribution basic InfoCubes into one MultiCube and created single and multi layers ODS to summarize details data into Infocubes.
• Maintained and scheduled InfoPackages and controlled the loading process using the new monitor functions.
• SAP R/3 and ABAP/4 Workbench: Maintained and used the new data sources with their newly designed cockpit and delta functionality for SD, FI-AR, and FI-AP modules. Involved and assisted with the development and enhancement of BW extractor, creating appends structures, ABAP programs and function modules to customize SAP delivered Extract structures.
• Extended master data attributes from R/3 side and customized user defined InfoSources for master and transaction data.
• BW Business Explorer and BEX Analyzer: Created and maintained ODS/InfoCubes queries, RRI reports where one query analyze the data of an InfoCubes and then uses the RRI to drill down to the ODS to get more detailed information.
• Wrote complex queries, defined conditions, exceptions, filters, and publishing SAP/BW reporting to the Web using BW Web publishing wizard.
• Trouble-Shoot any problems that arias during SAP/BW upgrade and conversions and worked closely with other team members and users. Acquired on the job analytical and problem solving skills in addition to a thorough understanding of relational database structures, star schemas, and OLAP concepts.

Confidential

Business System Integration Department

• SAP Business Information Warehouse R.1.2B R/3 4.5C: I have acquired on-the-job training and customization experience as an implementer and developer through working with SAP Data Warehouse product from its selection to final configuration. I have gone through the entire scope of processes, TO-BE processes, mapping requirements and resolution of integration issues within SAP Data Warehouse. Went through parallel run cycle for six months and insured reconciliation of accounting results between SAP BW and Oracle Data Warehouse systems. Worked with Administrator Workbench to manage and create InfoCubes, InfoObjects, InfoSources, and Info Catalogs in BW. Used SAP Business Explorer Analyzer and Browser to create and manipulate reports in SAP Business Information Warehouse.
• ABAP/4 Workbench: Involved individually and in team environment to design and develop ABAP/4 programs, which runs every night by job scheduler in the background and extracts data from major financial tables to the UNIX server in a flat file ASCII format. Modified several ABAP/4 programs to retrieve the necessary metadata and data from the UNIX flat file using ABAP/4 SQL select and Oracle Native SQL.
• Oracle8 Server: Primary duties are Designing, Developing, Testing, and Documenting SAP/Oracle Open Data Warehouse Application within BSID department. This Oracle application assembles a channel by which we can read data and metadata from SAP Business Information Warehouse and use this information to create/Update and fill up the corresponding tables in Oracle Data Warehouse. Used Oracle Packages, Stored procedures, Functions, Triggers, and External Procedures to develop optimized structures for reporting and analysis data extraction and data staging in a pre-configured SAP and Oracle environment.

Confidential

Senior DBA Consultant - Confidential

Sybase SQL Server 11.3: Assisted customers with major conversion of their Finance applications, monitored all Sybase production SQL servers, trouble-shoot any problems that arise during the conversion, and work closely with other team members to evaluate SYBASE ADAPTIVE SERVER 11.5 performance. Responsible for developing and modifying stored procedures for a FI and HR applications.

Confidential

Responsibility including monitoring, solving problems, and trouble-shooting any problems that affect production, development, test Sybase servers that are replicated 24/7.Regular DBA duties as Modifying default SQL Server configuration as needed, creating a backup server schedule for the all productions databases, auditing, database connectivity issues, database build and restore, recovery plan and techniques, security and permissions, and creating replication server including. Reverse engineered Sybase SQL Server databases, designing databases for performance, enhanced business rules, create domains, and created conceptual and physical data modules using S-Designer

Confidential

Senior Consultant

• Responsible for designing and developing the system life cycle for the FBI's Uniform Crime Reporting System using Sybase system 4.9.2/ PowerBuilder 4.0 running on Sun Solaris platform at FBI Headquarters in Washington, DC.
• Designed conceptual and physical modules CDM, PDM Data Warehouse of the force security measures using ERWin.

Confidential

Senior Programmer/Analyst

Responsible for design and development of automated data validation tools and migration procedures for a large accounting data warehouse project using Oracle DB. Developed and implemented Purchasing and Order entry Systems to interface between existing legacy mainframe and a graphical client/server environment using PowerBuilder 5.0