OBJECTIVE

A Challenging position in the area of SAP BI as a lead Architect.

Citizenship status: U.S. Citizen.

EXPERIENCE SUMMARY
Ï Over 5+ years of strong experience in SAP BW environment in the modules of FI/CO,
MM, HR and SD.
Ï Worked on 3 Full Life cycle implementations and 2 Upgrade projects in different roles.
Ï In depth knowledge with BW configuration of BW data objects including Infoobjects,
Infosources, Queries, Web Reporting, PSA, Transfer/Update Rules, ODS, DSO’s, DTP’s
Info Providers, Multi providers.
Ï SAP BW Business Content Activation and BW Configuration.
Ï In depth knowledge and experience with BW Extractors from the R/3 system and
working knowledge of SAP structures and tables in version 4.6 environment as well as
ECC 6.0.
Ï Expert knowledge of BW data modeling and custom Data Warehouse data modeling.
Ï In depth Knowledge in Handling and performing Transports to BW.
Ï In depth Knowledge in Financial Operating and Planning reporting.
Ï ETL, Generic data extractor, application specific extractor: such as LO cockpit.
Ï BEx Analyzer, BEX Query Designer, Web Reports, Web Application
Designer, Business Objects, Crystal Reports.
Ï Knowledge of ASAP Methodology.

• Write optimized Data store object is used in BI7.0, to save data as efficiently as possible and as efficiently as possible without addition effort of generating sids and aggregation.
• Changed the structure of infocubes for characteristics and key figures using remodel feature of BI7.0.
• Used data transformation feature of BI7.0, and used the Data Transfer Process (DTP) to transform an input format into output format.
• Used DTP process extensively to support handling data records with errors.
• Archived the log and administration data requests to improve the performance of the load monitor using data archiving concept of BI7.0
• Used repairing and repeating process chains feature of BI7.0, to repair the processes that were terminated.
• Used Executing process chains synchronous feature of BI7.0, to schedule and execute the process in the dialog instead of in the background and debugged and simulated the process chain.

Ï Willing to relocate or to travel.

TECHNICAL SKILLS

ERP Tools: SAP BW3.5, BI7.0, Business Objects 6.0, Cognos, MM , FI/CO , SD, PP, Visual composer
OS Windows, WindowsNT, UNIX HP-UX, Sun Solaris, AIX
Languages C, C++, SQL, PL/SQL, T-SQL, Java, Visual Basic5.0, VB Script
Databases Oracle 8i, 9i, MS SQLServer7.0/2000, MSAccess, DB2.
Concepts Data Modeling, Normalization, Cluster, Replication

PROFESSIONAL EXPERIENCE

Confidential,August’05-March‘09
BI Lead Architect
Technical Environment BW3.5,/BI 7.0 SAP4.7,/ECC 6.0, Cognos, Visual Composer

• Responsible for providing design, develop and support to Enterprise Financial Warehouse systems (efw) and SIFT in EDS CFO department. In this system, the financial data comes Globally from three different regions (Americas, EMEA and Asia Pacific).
• SIFT system is Synchronized Integration Forecast tool is used to forecast the financial data and Business Objects is used to generate and use Reports by the users.
• Responsible for providing co-ordination with the project team and Business end users for designing the data models.
• Responsible for design and development of Customized Data sources, Info-objects, Infosources and Infocubes.
• Provide Data modeling, Data design and development for all ETL efforts needed for all R/3 as well as non-R/3 data extractors.
• Responsible for maintaining new Masterdata objects, Texts and Hierarchy changes in BI Global Landscape.
• Responsible for Troubleshooting and providing solutions for error resolutions in the area of Data Extraction(Generic Extractors, LO Cockpit), User Exits, Data Loading (Full/Delta upload), Scheduling, Monitoring Process Chains, and Multicubes.
• Responsible for identifying and developing testing scenarios for Patch Upgrades/ Upgrades as part of Production Support.
• Provide Performance Tuning activities weekly on certain BI objects including removal of PSA’s, Compression, Roll ups of Aggregates.
• Provide assistance in the area of collecting ,Transporting and Testing of all Queries, and Workbooks.
• Excellent knowledge of SAP BW Components like Info Cubes, Multi Cubes, Info Sources, Info Objects, ODS objects, Update Rules and Transfer Rules.
• Responsible for providing all Production support including Loading, Monitoring, Scheduling, correcting Regular Batch cycles in all the three regions
• Expertise in Business Content Services consisting of business rules, metadata, reference data, Data extraction, ODS and other data objects.
• Responsible for providing co-ordination with the project team and Business end users for designing the data models.
• Responsible for design and development of Customized Date sources, Info-objects, Infosources and Infocubes.
• Responsible for maintaining Company Codes, New Global accounts, Transferring Exchange Rates.
• Participated in several patch upgrades of BW and R/3 systems.
• Created several Financial variance queries for balance sheet and income statements.
• Performed Financial Accounting analysis of all accounts receivables data, accounts payable data, general ledger, financial statement items in detail.
• Performed analysis of the annual and period values from asset accounting.
• Performed Controlling analysis of full costs on cost centers (plan, target, actual), analysis of information on the origin of the costs (allocation partner such as material number, cost center), analysis of costs broken down into cost components or costs by activity type (fixed and variable costs), analysis of the period totals for the profit and loss accounts and balance sheet accounts from Profit Center Accounting(PCA), and key figures which were loaded from the affiliated source systems.
• Performed the analysis of all transactional data from sales orders, deliveries and billing documents/invoices.
• Performed the analysis of order fulfillment from R/3 such as Delivery delays per sold-to-party, service level order/item/quantity level, item fulfillment Cycle time.
• Performed the analysis of general figures for quotations including the number of quotations created, net and gross values of the quotations, and the number of quotations rejected.
• Performed the drilling down of key figures from sales to the leveloi of the characteristis: Sales Organization, Distribution channel, Division, Sold-to-Party,Bill-to-Party, Billing Document Number, Sales Group, Sales Employee, Sales District, Sales Office and performed the structure of receivable.
• Performed the Purchasing analysis of materials groups, vendors, and materials, Analysis of the purchasing activities of purchasing groups.
• Performed the Vendor evaluation analysis to compare the vendors with each other and also to check whether a certain vendor deliveries a material punctually and in the desired quantity.
• Performed the reporting using Cognos and analyzed the data for the corresponding KPIs.
• Performed the CRM analysis for customer interaction center, opportunities analysis, Sales order complaints analysis, and Service Quality analysis.
• Performed the inventory analysis to analyze stock data from SAP R/3 and to evaluate materials for which no movement has occurred, stock overview, slow moving items analysis.
• Created queries for HR module to analyze overview of wage type, an annual comparison of wage types, navigation to the employee level using various organizational criteria.
• Created queries to analyze the comparison of wage types from different personnel areas, analysis of quarterly overview of various USA-specific restricted wage types such as total gross amount.
• Created queries to compare the costs of overtime hours with the number of overtime hours, analysis of hours lost due to illness with the illness costs, analysis of calendar quarter overview of personnel expenses using amounts for G/L accounts.
• Created queries to compare the actual working time of employees with the planned working times of a quarter, analysis of ill-ness related absence times of employees with the planned working times of a quarter.
• Created a query to compare planned time, productive time, and overtime of a year with the values of the previous year.
• Created a query to display the training costs per full-time employee in relation to the average number of full-time employees.
• Identified the enhancements for 0Employee master data to include custom reporting filters like pay region, work region, salary.
• Activated the standard business content for Staffing (0PAOS_C01), headcount (0PAPA_CO2) infocubes to report on headcount reporting.
• Installed and enhanced 0HR_PA_0, 0HR_PA_PA_1, 0ORGUNIT (HIERARCHY).
• Performed the analysis on standard reports in Benefits, Personnel Administration, Time & Labor, Compenstation analysis.
• Used Visual composer to develop data models (Sales order, Purchase order, Account payable, Account Receivable models).
• Developed SAP Visual composer solutions for financial applications.
• Maintained some custom developed ABAP programs for cost center related extractions.
• Provided Knowledge Transfer and Mentoring to two BW consultants during development cycles.

Confidential, Jan’05-May ‘05
Lead BW Developer
Technical Environment BW3.0, SAP4.7.

• Participated in the Go Live and Post Go Live activities in the areas of FI/CO and MM.
• Performed extraction from multiple source systems including LO Cockpit and flat files.
• Uploaded Master and transaction data from flat files and SAP as the OLTP source.
• Managed and monitored several data loadings. Optimized the load performance by adjusting the packet sizes, Indexes and using process chains automation.
• Maintained aggregates for the cubes and indices to improve the performance.
• Responsible for creation and maintaining process chains for all Masterdata and Transaction data.
• Involved in creation of role based security and authorization for certain infocubes and infoobjects.
• Performed Analysis of production process transaction data related to the order header and item, period specific order/material quantity evaluations, status of manufacturing orders.
• Created queries using variables, restricted key figures, filters, exceptions, conditions, free characteristics and BEx features.
• Prepared training materials and conducted the End-user training programs to facilitate use reports from BW system in their daily analysis.

Confidential,Feb ’04 -Nov’04
BW Developer/Configurator/BEx Report Writer
Technical Environment: BW 3.0
Responsibilities:

• Translated Business requirements into dimensional data models by using Extended

Star Schema techniques.

• Design of Physical and Logical Data Modeling, Created BW objects (Infosources,

InfoObjects, ODS, Cubes, Infosets, MultiProvider,Transfer update rules and Process
chains)

• Responsible for building and maintaining the infoproviders, multiproviders in

purchasing area for purchasing data, purchasing groups, vendor evaluation from
the standard Business Content.

• Used LO Cockpit to extract data from SD.
• Created ODS objects to store data and update into various data targets.
• Used update rules and made enhancements to transaction data using formula

builder.

• Expertise in Report Generation- Worked extensively in BEX Analyzer in building Queries and saving in Workbooks(Excel worksheets) and created Custom Queries using Conditions, Exceptions, Variables, Calculated and restricted key figures, Structures and created aggregates for frequently used Queries and worked with Web Reporting tools.
• Developed queries by defining lines, columns, and free characteristics providing drill

downs, filters and other features like exceptions, and conditions.

• Reporting agent configuration and set query exceptions in the background and customized it for e-mail notifications and alert monitor.
• Created User Manuals and trained Business end users.

MCI
Confidential, Nov’ 98-Jan ‘04
BW Configurator,
Oracle and SQL Server Database Administrator
Technical Environment: BW3.0, SQL server 2000, Oracle 8i, Windows NT, UNIX AIX

SAP BW Experience

• Analysis of data requirements and translation of these requirements into tabular relational ODS objects, Master data or the star schema multidimensional infocubes.
• Responsible for designing Extended Star Schema Modeling for Material and Sales Data Warehouse.
• Responsible for BW Configuration and administration of BW Systems.
• Experience with Business Content as well as Creating Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains

Ï Design and create the InfoProviders such as InfoObjects, InfoCubes, ODS objects.
Ï Create the InfoSource, DataSource, Transfer Rules, Update Rules for BW’s data mapping.
Ï Design and create Generic R/3 data extractors to load data from R/3 to BW.
Ï Utilization of the new functionality such as Delta Extraction, Process Chain, Open
Hub Services. Web Application Designer, Transformation Library etc.

• Initial data loading and Delta update set for ODS and InfoCubes.
• Design and develop the OLAP queries and workbooks according to business requirements.
• Configured use of restricted key figures, variables, exceptions and calculated key figures in queries.
• Created aggregates to improve the query response based on Business requirements.
• Evaluation and Optimization of BW’s Performance and use aggregates, Parallel loading, Index creation etc.
• Analyzed ERM, MDM and translated it to BW design. Identified the Key Figures, Strong Entities and Attributes of the entities.
• Worked on Remote Cubes to support real time data.
• Responsible for defining transformation rules, aggregation rules, and prestaging requirements.
• Responsible for identifying data cleansing and validation requirements for all interface sources.
• Responsible for design and creation of InfoSource, DataSource, Transfer rules, Update rules for BW data mapping.

Ï Responsible for creating Functional Designs and Technical designs from Client needs in the area of BW including Data Definitions, Reporting Designs, Key Figures.

• Responsible for creation of Generic R/3 data extractors to load data from R/3 to BW.
• Responsible for creation of queries and workbooks according to business requirements.
• Analyse the report data requirements and map the data element to the corresponding query objects.
• Responsible for configuration of Info Packages for using Initialization and Update Delta method.
• Responsible for scheduling and monitoring of periodic Data Loads from SAP/R3 to BW and ODS Loading process.
• Set up procedure for extracting R/3 data using LO Cockpit.

Non-SAP Experience
Responsible for development and management of Oracle/sql server databases, application forms in Vantive8.2.1 for SKYTEL PAGERS Coverage Request, Trouble tickets, helpdesk, quality, Fields Service Admin, Asbuilt and Request forms. Vantive forms include Coverage request, RF Design to retrieve the coverage request and indicate any determination of a site survey to place antennas, transmitters, receivers, Site Survey, Engineer recommendation for survey, Comptrollers Approval, Lease retrieve the approved request for leasing and forward to construction, and Sales Coverage Request and web process and approval.
The databases are Oracle 8i, 9i.
Ï Installed and created database using SQL Server 7.0 & 2000.
Ï Configured SQLSERVER7.0 &2000
Ï Utilized SQL SERVER 2000, SQL Profiler, SQL Query Analyzer, DTS, BCP, and Erwin.
Ï Worked with development team to audit vantive front end application calls to SQL Server to create efficient queries, Indexes, Views and stored procedures.
Ï Managed client connectivity with SQLSERVER database.
Ï Scheduled complete and Transaction log backups on disks and tapes.
Ï Implemented SQL server Mail and alert configuration.
Ï Tuned SQL queries to increase the performance of the database.
Ï Performed and monitored database load testing.
Ï Performed backup and recover SQLSERVER database.
Ï Performed Replication of the databases and used Clustering Fail Over techniques.
Ï Monitored SQLServer Transaction Log.
Ï Responsible for server security, user logins, server roles, database access, and database roles.
Ï Assigning permissions, database permissions, object level permissions, and security functions to users.
Ï Configured and used SQL Server Agent to schedule jobs and to create alerts which will send an email to operators.
Ï Created Transact SQL scripts to enter a set of Transact SQL batches or load to a script from disk.
Ï Created stored procedures and triggers to enforce business logic.
Ï Migrated data from SQLServer to Oracle database and vice versa.
Ï Performed capacity planning for SQLSERVER database.
Ï Logical design and Physical design of the database using tools like ERWIN/ERSTUDIO.
Ï Designed tables with constraint keys, stored procedures, and triggers to store invoice information.
Ï Developed stored procedures, Functions, Packages, and Triggers.
Ï Managed instances, Data dictionary views, Control files, Redo-log files, Table spaces, Data files, storage structures, rollback segments, temporary segments and indexes.
Ï Configured the backup and recovery issues on server as CRON jobs.
Ï Performed disk space utilization (file movement, purging, placement)
Ï Performed SQL statement tuning.
Ï Installed and used Oracle Enterprise Manager.
Ï Developed UNIX shell scripts to monitor Oracle database instances.
Ï Loaded monthly updates using SQL LOADER. Written PL/SQL scripts.
Ï Documented and reviewed at all stages of SDLC to adhere quality standards.
Ï Performed Database tuning for better performance on server including SGA allocation, I/O distribution, Fragmentation, row chaining, Used UTLBSTAT and UTLESTAT.
Ï Performed configuration and tuning of database storage parameter for table spaces and related tables. Performed table and index partitioning.
Ï Optimized the SQL for maximum performance by using TKPROF and EXPLAIN PLAN.
Ï Performed Export/Import utilities for selective backup, transferred tables between Oracle instances and also for de-fragmentation.
Ï Used RMAN for the Backup and Recovery extensively by creating the appropriate catalog database.
Ï Troubleshoot the performance issues on a regular basis by using Performance Monitor, and Profiler.
Ï Interacted with developers and end users and trained them on the tuning perspective.
Ï Optimized the slow process queries using Performance and Tuning Techniques like creating Indexes.
Ï Supported the Development team and Application users. Wrote database triggers to enforce business rules.
Ï Enrolled users and maintained system security. Managed user privileges, roles, and profiles.
Ï Regular maintenance of Oracle database, which includes taking backups, startup and shutdown and regular administration of table spaces, users and tables.

EDUCATION

MS in Industrial Management