Summary


Over 13 years of IT experience with Over 6 years of experience in SAP R/3, Implementations, Roll outs, Upgrades, Post go-live Support projects with 5 full life cycle implementations. Led many teams on a variety of successful R/3 implementations at fortune 100 companies. Hands-on experience on SAP modules MM, SD, IM/WM, PM and SAP CRM E-Commerce, Marketing, CIC, CTI and SAP R/3 ISA. Strong communicational, organizational and analytical skills. Considered a high energy leader with a reputation of integrity and quality and attention to detail. Highly motivated and has worked in team and adhered to the planned development time frame.



SAP ECC6.0, SD, MM, WM/IM and PM, FI/CO : Evaluated business requirements, interviews with business representatives.
Developed and evaluated solution alternative implications, pros and cons and assisted with final solution development or recommendation.
Strong experience in developing and evaluating SAP solution alternatives from business requirements and based on an existing SAP application to be enhanced.
Excellent knowledge of the SAP environment release 4.6B and higher ; general knowledge of all SAP modules.
Experience in SAP configuration, writing functional specifications, gathering customer requirements, SAP problem solving and trouble shooting.
Responsible for testing documents, end users and developers training, documentation, go-live and post production support.
Extensive SAP configuration experience in warehouse management WM module, storage unit management, batch management, placement-removal strategies, transfer order creation/processing, inventory management, SAP interface with external system, SAP console and RF applications.
FI, managed accounts payable, account receivable, general ledger and cash management.
CO, Handled profit and cost center accounting, profitability and costing analysis and asset management.
FI/CO, provided real time information for budget reporting, profit and loss calculations and capital expenditures.
Internet Sales R/3 ISA : Product catalogs, Web shops, Product proposals, Web catalog views, Target groups, Cross/UP selling, Sales Order processing
Understanding of SAP master data and organizational elements.
SAP CRM 5.0, 4.0, 3.1, 3.0 : Worked on the Marketing management Campaign Management and CIC modules of CRM, with core skills in Campaign management and Marketing.
Strong experience in CRM sub modules in Sales Enterprise Sales, Internet Sales, Mobile Sales, Marketing Campaign Management, Lead management Inbound/Outbound and Service Service Order handling, Complaints, CIC Customer Interaction Center.
Familiar with SAP implementation methodologies ASAP, ValueSAP and Solution Manager.
Good business knowledge and experience in Business process integration of SAP CRM module with SAP R/3 Modules SD and BW.
Master data and Basic functions : Organizational data setup, Business partners, Products, Partner/Output/Text/Date determination, Actions, Transaction types, Item categories, Copying control.
Enterprise Sales : Activity management, Opportunity management, Quotation and Order management, Contracts, Territory management
Internet Sales ISA : Product catalogs, Web shops, Product proposals, Web catalog views, Target groups, Cross/UP selling, Sales Order processing
Mobile Sales : Settings for Mobile client, Data Quotations, Orders integration with backend SAP CRM and R/3
Marketing : Lead management, Campaign Management, TPM, External list management, Master data creation, Marketing plans, Marketing plan elements, Customer segmentation, Campaign execution, Personalized mails, Campaign analysis
Interaction Center : Information help desk, Customer service and support
SAP CRM BW Integration
Strong conceptual knowledge of Middleware.
SAP BW
3.1, 2.1C : Sound knowledge of Data warehousing technologies, data design models - ER, MDM, Star Schema models, SAP BW data architecture and various OLAP and ETL tools.
Experience in working with user groups in gathering requirements and converting them to functional specifications
Experience in using Generic Data sources using Views in SAP R/3 and load them to BW.
Worked extensively on loading data to BW using flat files derived from various source systems
Experience in building SAP BW objects Info Cubes, ODS objects and Aggregates.
Experience in Advanced designing techniques using Aggregates, Multi-cubes, Line-item Dimensions, Indices, statistics, aggregate rollup, re-construction, Aggregates, Rollup, InfoCube Partition and Compression.
experience in implementing BW reporting using BEx query designer, Exception reporting, Analyzer, Browser, crystal reports
Involved in end-user training and documentation.
ACCENTURE
Accenture is a global management consulting, technology services and outsourcing company. Accenture is a Fortune Global 500 company with a strong global presence. Accenture's clients include 94 of the Fortune Global 100 and more than two-thirds of the Fortune Global 500


Employment

August, 2008 -  July, 2009

Barry Callebaut is the world s leading manufacturer of high-quality cocoa and chocolate from the cocoa bean to the finished product on the store shelf. The Zurich-based company is present in 26 countries, operates about 40 production facilities and employs more than 7000 people

Objectives of this project were to implement for identified business process domains improvements to business processes, business data, ERP systems, organization or people and the IT landscape to support NAFTA for future growth volume and EBIT
Merge the North America SAP and Corporate SAP environments Corporate SAP, covering Europe and Asia and harmonize master data principles across the regions to enable Barry Callebaut to act as a global player facing global customers and vendors

Responsibilities : Drive the design configuration and customization to meet the business process design and application requirements.
Use the business process requirements to drive out application requirements and metrics.
Assist in defining and reviewing requirements for the application.
Validate the design with the stakeholders to ensure that the design satisfies the requirements.

Work with Near-shore team to support their build activities, transitioning the designs to the programmers and ensure a clear and complete understanding of the designs.
Participate as necessary in application prototype to validate the configuration design and explore packaged software gap resolution options.

Conduct training for prototype participants.
Participate in transitioning the designs to the programmers and ensure a clear and complete understanding of the designs.

Ensure that other team members impacted by master data have the information they need to complete their work.
Complete all appropriate documentation required by the programmers, testers, Deployment team and Application Management team that will maintain the application.
Develop and document a scope clarity for Material Master
Develop and document a data clarity for Material Master
Assist in translating requirements into test conditions and expected results for product, performance and user acceptance testing.

Participate in quality management reviews as outlined in the Verification and Validation Overview, in particular reviews of the designs, prototypes and other requirements work products to ensure they fulfill the requirements.
Serve as a liaison to the business community for all material master

Terra Firma Consulting

Worked on many challenging SAP R/3, SAP ECC, SAP CRM and SAP BW projects. Also, worked as SAP instructor conducting training academies : Courses taught : R/3 Internet Sales CR-850 BW-310 and Warehouse Management SCM-630 at different client locations.

March, 2008 -  June, 2008

Panasonic is the brand name for Matsushita Electric Industrial Co., Ltd Under this brand Matsushita manufactures and sells the largest variety of consumer electronic products, all of which are marketed under their slogan Ideas for Life.

Environment : SAP ECC 6.0, Win XP Professional

Teamed up with IBM as part of ECC 6.0 upgrade, involved in analyzing and translating process changes in ECC 6.0 as part of the SAP upgrade. Prepared course material in specific areas, documented the changes and the processes, SAP transactions recordings in Infopak. Delivered training with hands-on to the end user groups in formal class room setup in following areas ;

Developed and end user training documentation for MM, SD, APO and FI/CO and FSCM Dispute Management/Collections Management, work instructions, courseware and exercises.

Created work instructions using RWD InfoPak
Created business process procedure documentation for MM, SD, APO, FI/CO and FSCM Dispute Management/Collections Management
Held following workshops for end users : FI, managing accounts payable, account receivable, general ledger and cash management.
CO, Handling profit and cost center accounting, profitability and costing analysis and asset management.
FI/CO, providing real time information for budget reporting, profit and loss calculations and capital expenditures.

Created demonstrations and exercises for use in hands on training
Created data load for SD, MM for use in instructor lead class

Delivered instructor led training to end users in Secaucus and Chicago for SD, MM, APO and FI/CO.

October, 2007 -  February, 2007
WM Consultant

Tire Kingdom is the largest independent tire and automotive services retailer in the United States, operating over 600 stores. TBC has chosen the Dallas facility for their second implementation.

Analysis of the gap between Carroll Lite WMS design and the required additional business process requirements for the new Tire Kingdom Dallas Warehouse.
Environment : SAP ECC 6.0, Win 2K3

Responsibilities : Translated business process requirements into configuration and master data requirements through the Gap Analysis addendum to the existing Carroll Lite WMS Blueprint document.
Prepared Business blue prints, functional requirements.

Adaptation for existing SAP Warehouse Management configuration as delivered for the Carroll Lite WMS project to incorporate additional WMS functionality required for the new warehouse

Extending existing and development of additional configuration to form the basis of the new baseline design of a high-volume DC, Configure all MM/IM processes necessary for Material Master data, material creation/extension, managing material stock, movement types, Bin to Bin Transfer. Create transfer requirement, transfer order, confirm/cancel transfer order, display stock requirement list, Interface to external systems and create posting change notice
Configuration of MM module for MPN functionality to enable material management by customer part no.
Modification of the existing system interfaces to incorporate transactional data of the new warehouse

Modification of and the creation of additional master data upload programs to create or extend material master data to the new warehouse
Modification of the existing inventory upload programs to upload inventory to the new warehouse
Unit Testing of the existing and extended configuration, master data settings and data conversion programs
Identification and the preparation of Integration Testing scenarios and test data sets that is representative of the business procedures at the new warehouse
Conducting iterative Integration Testing cycles of existing and new configuration and master data through the execution of simulated business procedures required to support all identified warehouse management processes in the new Tire Kingdom DC in Dallas, TX.

June, 2007 -  September, 2007
Functional WM Consultant

TBC Corporation is the nation's largest vertically integrated marketer of tires for the automotive replacement market. The Company's retail operations include Company-operated tire and automotive service centers under the different brands.
Environment : SAP ECC 6.0, Win 2K3, JD Edwards
Responsibilities :
Maximo Evaluation 3 weeks
Team member for evaluating IBM Maximo Asset Management to replace existing JD Edwards system ; following functionalities were considered ;
Plans inventory to meet maintenance demand, making the right parts available at the right location when needed
Manages vendor contracts with comprehensive support for purchase, lease, rental, warranty, rate, master, blanket and user-defined contracts

Adapts to changing business requirements and connects with other enterprise systems

Evaluation proposal included following guidelines : 1. Gap analysis
2. Technical environment with infrastructure planning
3. Implementation plan.
4. Maximo standard operating procedure/workflow design
5. Data collection and transfer methods
6. Integration with SAP MM/WM

SAP MM/WM
Interacted with the Business Leads and Users to understand the existing Business processes
Business Customization to map the client requirements and functional design documents.
Prepared Business blue prints, functional requirements.
Configure all MM/IM processes necessary for Material Master data, material creation/extension, managing material stock, movement types, Bin to Bin Transfer. Create transfer requirement, transfer order, confirm/cancel transfer order, display stock requirement list, Interface to external systems and create posting change notice
Configuration of MM module for MPN functionality to enable material management by customer part no.
Configure all processes necessary to allow full warehouse management capability : Inbound Receipt Process : Putaway
Outbound Shipping Process : Picking
Physical Inventory : Count, Recount
Internal Warehouse Processes : Bin-to-Bin Transfers, Physical Inventory
Warehouse Management Reporting
Bin Stock Lookup, Article Lookup, Open Transfer Orders
Maintain Warehouse Master Data : Create/Change Storage Bins
Maintain the master data as required to facilitate the above processes : Article Material Master, Customer Master, Vendor Master, Storage Types, Storage Bins

Configuration of SAP to support the additional required functionality : Optimized Putaway and Picking Strategy for all Storage Types
System Output for Business Processes : Putaway Ticket, Picking Ticket, Inventory document, Identified Warehouse Management Reports
Documentation
Business Processes Procedures and Reports
Testing Plan and Test Scripts

Training Plan and Training Scripts

April, 2007 -  May, 2007
PM Consultant

The Metropolitan District MDC is a non-profit municipal corporation chartered by the Connecticut General Assembly in 1929 to provide potable water and sewerage services on a regional basis.
Responsibilities : Document complete business processes interacting with the end users and prepare a complete list of functionality available in the module.
Worked on the list of transactions and business processes needed to be Unit tested in the upgraded module, Master Data Management ;
Technical Objects : Equipment Processing, Function Location Processing.

Environment : Work Center Processing, Object Measurement Point, Measurement Documents.

Equipment Task List, Functional Location Task List, General Maintenance Task List, List editing and modifying Technical Systems.
Maintenance Order Processing, Maintenance Order Creation, Order List, Operation List, Component List and GI Processing.
Maintenance Order Completion Confirmation, Individual Processing, Collective Processing.
Planned Maintenance Processing ;
Maintenance Plan Processing, List Editing, Scheduling Maintenance Plans, Schedule Overview and Maintenance Strategy Processing.
Maintenance Order Completion Confirmation, Individual Processing, Collective Processing.
Prepare detailed instructions for these transactions to perform Unit testing.
Prepare details with step by step instructions for end users to perform Integration testing.
Coordinate Integration testing with the end users, provide test data, record results and get the user sign off for the upgraded Module.

December, 2006 -  April, 2007
Project Lead

Forbo is World leader in linoleum flooring with approximately 60% of market share with Production and marketing of linoleum-made floor coverings and related products. Forbo has 3 warehouse Locations in US ; Hazleton PA, Dallas TX and Reno - NV.
The first implementation was done at Hazleton, PA location and subsequently at Dallas, TX and Reno, NV. Responsibilities included configuring SAP WM system, Telnet Server ; write functional specs and coordinating with the ABAP/SAP Script programmers for customer specific transactions for scanning operations.
Environment : SAP R/3 4.6B, Win 2K3, Telnet Server
The business processes in scope for this project were : Configuration of Organizational Structures and Material Master in IMG.
Necessary configuration for Inventory Management : Goods Receipts, Goods Issues, Stock Transfers, Physical Inventory, Availability Check, Movement Type Configuration and messages
Create and configure SAP WM system. Configure all transactions necessary, configuration of SAP Console, to allow full scanning in the warehouse.

Create and configure additional Storage Types SU and managed, create and make extensive usage of multiple storage sections in defining putaway strategy.

Configuration of SAP to support the additional required transactions on the scanners for all types of material movements.
Gather customer requirements, write functional specifications, SAP problem solving and trouble shooting for following scanning operations : Put away by handling storage unit
Pick by outbound delivery 915 staging area
Verify by outbound delivery 916 auto generate the BOL
Load by outbound delivery Goods Issue
Physical Inventory - Cycle count
Bin overview
Storage Unit information
Block Storage Unit for quality
Stock overview for material in the warehouse
Damage transaction
Pick by transfer order
Bin-to bin movement
SAP Script : Print labels for SU s for 2 different storage types, TO s and shipping
Reports : Bin Capacity, Productivity Report, Cycle count accuracy and Inventory report

September, 2006 -  November, 2006
Functional Lead

Fabri-Kal is the sixth largest thermo former in North America and serves the foodservice and consumer goods packaging markets manufacturing and selling stock products to foodservice operators and distributors and retailers.

SAP ISA
4.0 Rollout for Fabri-Kal Line of Products, with back end of R/3 4.6 C System. The scope included Internet Sales functionality with customer specific customizations, Catalog Management and Order on behalf functionality.
Environment : SAP R/3 4.6C, J2EE 6.40 TREX6.1, ISA 4.0, TREXR3, Win 2K3

Responsibilities : Worked as a functional team lead in development of Internet Sales Application ISA. Responsibilities included development of core functionalities of ISA, catalog replication and product catalog views.
Responsibilities : Interacted with the Business Leads and Users to understand the existing Business processes
Business Customization to map the client requirements and functional design documents.
Prepared Business blue prints, functional requirements.
Prepared and presented schematic designs and proposals to the Business and technical teams.
Configured Product Catalogs for multiple sales areas.
Configured XCM for the application and the shop Administrator, web shops for products.
Installed and configured TREX 6.1, created RFC connections on R/3 side for product catalog replication.
Deployed and configured the application TREXR3, XCM and the catalog management.
Deployed and configured SAP Cryptographic tool for SSL login to ISA Web Shops.

Prepared end-user training documentation and conducted end-user trainings.
Deployed order on behalf functionality for ISA Webshops.

February, 2006 -  July, 2006
Project Lead

LORD is launching its next generation of products in the global marketplace for 80 years. Innovations in performance-formulated products for coating, bonding and product assembly and performance-designed components and systems for controlling vibration, shock, motion and noise.

SAP ISA
4.0 New Rollout for Lord Line of Products, with back end of R/3 4.6 C System. The scope included Internet Sales functionality with customer specific customizations, Catalog Management and Incorporating Pricing enhancement in IPC to include special pricing replicated from R/3.
Environment : SAP R/3 4.6C, J2EE 6.40 TREX6.1, ISA 4.0, TREXR3, Win 2K3

Responsibilities : Worked as a functional team lead in the development of Internet Sales Application ISA. Responsibilities includes project management and development of core functionalities of ISA, catalog replication, IPC, product catalog views, etc
Responsibilities : Interacted with the Business Leads and Users to understand the existing Business processes
Business Customization to map the client requirements and functional design documents.
Prepared Business blue prints, functional requirements.
Prepared and presented schematic designs and proposals to the Business and technical teams.

Prepared weekly agenda s and coordinated work progress with the client side project manager.
Configured Product Catalogs for multiple sales areas.
Modified Z function modules to allocate customer specific products based upon their division and sales area.
Configured XCM for the application and the shop Administrator, web shops for products and sample catalogs
Installed and configured TREX 6.1, created RFC connections on R/3 side for product catalog replication.
Deployed and configured the application TREXR3, XCM and the catalog management.
Deployed and configured SAP Cryptographic tool for SSL login to ISA Web Shops.
Configured IPC 4.0, ran initial and delta loads for ISA pricing

Prepared end-user guides and conducted end-user trainings.
ISA developments and customizations for incorporating new Business requirements like minimum order value, minimum order quantity, ship_to etc.
Guided ABAP and Java development for enhancement of Material Availability display, shipping details to ISA

October, 2005 -  January, 2006
SAP CRM Consultant

DIRECTV is the nation's leading digital multi-channel TV service provider. Launched in 1994, DIRECTV has redefined the world of television entertainment. Using advanced technology to enable their viewer s services on TV, like digital video recording DVR, HDTV, interactive programming and more. DIRECTV is delivering the future of entertainment today.

Environment : SAP CRM 4.0, R/3 4.6C, BW, AIX, Oracle9i, Win 2K

Dealer Tracking System DTS :
A DIRECTV legacy system to manage the dealers all over the USA that was comprised of 14 different interfaces,. The system managed new dealerships assignment, current dealers in the system and their activities, commission reimbursements for multiple services like programming sold, hardware sold, inventory etc. System had facility to generate miscellaneous reports. This project was to migrate existing legacy system to SAP CRM and SAP R/3. Following major tasks were performed ;
Participated in AS-IS analysis meetings during blue printing phase of project
Reviewed existing DTS Interfaces - technical, business and functional information.
Understood and documented the existing application and components of different interfaces.
Worked with DIRECTV Project Manager to identify DTS Interfaces for Blueprint Workshops
Scheduled and conducted Blueprint Workshop for DTS Interfaces
Participated in analysis of existing DTS system and its data sources.
Document DTS Interfaces requirements in relation to SAP CRM and SAP R/3.
Studied and evaluated the clients business processes and gathered the clients requirements
Effected process mappings, high level design and configuration for CRM systems
Created business blueprint document for Marketing and Sales Lead Management, Actions
Documented and reported the use of implementation techniques and practices adopted

Mapped business partners, organization structure and product to CRM system

Addressed the CRM 4.0 compatibility issues with other SAP systems and modules

December, 2004 -  September, 2005
SAP CRM 4.0 Functional Lead

BASF is world s leading manufacturer of chemicals, plastics, colorants and pigments, dispersions, automotive and industrial coatings, agricultural products, fine chemicals, crude oil and natural gas. BASF offers intelligent solutions based on innovative products and tailor-made services, creates opportunities for success through trusted and reliable partnerships.

Environment : SAP CRM 4.0, R/3 4.6C, BW, AIX, Oracle9i, Win 2K

Responsibilities :
Worked as a project lead at BASF Rockaway, NJ to design and develop Solution Database SDB in R/3 4.6 and CRM. Solution database offers customer service organizations a cross application knowledge base component with highly flexible structure to acquire and preserve knowledge.
Solution Database and SAF : Configured Enterprise Intelligence in IMG : configuration, Validation categories, problems, solutions and Business Add-Ins areas.
Configured knowledge base, search engine and HTTP Destinations for SDB.
Configured, compilation, clustering and classification for solution database in SAF.
Helped basis team configuring TREX and JCo for Solution Database.
Defined settings and parameters for users for search options and managing the solutions and problems in knowledge search and Customer interaction center screens.
Configured and implemented enhancements to default in customer segmentation in CIC knowledge search screen as requested by the users.
Managed indexing full and delta and clustering of the SDB using BSP application.
Normalized problems and solutions for various business units, for entering into solution database.

Prepared training documents for knowledge search and problem/solution maintenance. Conducted company-wide training workshop to train users from different business units using CIC and SDB.
Participated in weekly update meetings as part of upgrade from CRM 3.0 to CRM 4.0.

April, 2004 -  October, 2004
3.1 Internet sales

NEC is the leading solutions provider for broadband networking and mobile Internet, focusing on 2 key domains : IT-Network integrated solutions and semiconductor solutions. NEC is at the cutting edge of research and development in its field for over a century.

Environment : SAP CRM 4.0, 3.1, R/3 4.6C, BW, Sun Solaris, Oracle9i, Win XP

Responsibilities :
CRM Marketing/Campaign Management :
Configured Campaign Types, Marketing Plan, Campaign Element, Attributes, Attribute Sets, Product Catalog, Segment Builder, Target Group, Profile Set, Mailing List, Campaign Types, Objectives

Defined general settings for Leads include Lead qualification levels, Lead groups, origins, Priorities, Workflow settings, communication channel settings, Questionnaire settings, Transaction types

Configured Outbound/inbound lead management, creation of Target group for lead generation, Leads for Target group, Lead campaign, Qualifying leads and transferring it to Sales

Worked with the segment builder to identify target groups in the campaign management process

Marketing calendar include Defining and assigning Search criteria, Assigning Graphic profile, Views

Campaign automation, Work flow settings and actions for Survey scenario
Internet Sales : Interacted with the Business Leads and Users to understand the existing Business processes
Configured Organizational set up, Business partners, Internet users, Products, Transaction types and Item categories, Copying control of Transaction types/Item categories
Provided end-user support on Internet Sales. Set up Product Catalogs, Web shops, Marketing Attributes- BP, BP- Internet User role management
Configured Sales order processing in CRM, creation of Request for Quotation, Quotations and replication of Orders to CRM, back end R/3 system

Product proposals : Created and assigned Attribute sets and Target groups for Cross/Up-Down selling/Best seller, Maintaining Top n products, Personalized and Web shop specific Web catalogs
Involved in integration of CRM system with R/3 4.6 C and BW 3.0 systems

May, 2003 -  January, 2004
SAP CRM Consultant

Medsite Rewards is recognized by physicians, meeting companies and pharmaceutical companies as the industry leader of outsourced fulfillment services. Medsite Rewards represents a smart and flexible way to create awareness, encourage activity and build goodwill among medical professionals in a manner that is compliant with existing guidelines.

Environment : SAP CRM3.0, SAP 4.5B, BW 2.1C, SD, HP UNIX, Oracle 8

Responsibilities : Setting up of Organizational structure with direct mapping to SAP R/3.
Setting up of Business Partner Roles and Partner Determination procedures.
Used the leading system and separate account group approach to set up number range for business partners.
Master data configuration and customization for customers, products and price.
Setting up of Marketing Planning and Campaign Management Procedures.

Marketing Lead Management - Lead generation and Qualification.
Business Partner Segmentation using Segment builder.
Overall responsible for middleware settings and establishing connectivity b/w CRM and R/3.
Product Allocation Planning using Allocation Rules, Formulas and Ranking.
Configuration for product proposals - Product Association rules and Top n product lists.
Set up Opportunity Management and order processing through mobile devices.
Configuration for sending personalized mails for product promotions.
Was involved in documentation effort. Crafted documentation templates and standards for instructor led and train the trainer sessions

July, 1999 -  December, 2002
Senior Programmer Analyst

Oracle 8.1.7.2 Marketing Data mart - Worked on the marketing Data mart project, created off of existing cable data and Operational Data Store. Jobs included creating, maintaining and running shell script, packages and procedures, SQL scripts to extract data from a large database over the network based upon the customer s criteria. Analyzed and worked out back end requirements for the Oracle storage and performance along with the production support DBAs.
E. piphany 5.0.6.1 Marketing Data mart - Web-based customer analytics, campaign management and fact-based personalization to provide all customer touch points and a single view of the customer. Working in a team of 4 provided solution that consisted of designing, developing and maintaining Epiphany application 4.0 thru 5.0.6.1 version enabling Strategic Marketing and planning group SMP to run campaigns and Reports. This mart had to use the data mart tables as external tables to stores data in its own metadata. The Epiphany metadata, functionality and front end was designed, developed and implemented as well. Also, worked on migration job to upgrade Epiphany to the released version in test, QA and then production environment. Worked intensively on the internal releases of the application to add functionality.
Query optimization and performance tuning for data extraction queries running on Very Large Database using indexing services, UTLSTAT reports, third party tools, Explain Plan and by monitoring Alert logs.
Created in house applications using Developer/2000 forms and reports with Oracle 7.3 and Oracle 8.5.1.2 in the back end, help desk support for these applications as well.

February, 1999 -  July, 1999

Worked intensively on a multi-million dollar project to re-engineer the business processes and application development for the Dealer Services Division of ADP. Data Warehouse to hold automotive industry vehicle repair and service information.
Used Oracle Designer/2000 to model the Data warehouse. Created entity relationship diagrams, Process flow models and Function hierarchy diagram. Worked on the CRUD analysis and generation preferences. Created the data dictionary and the Database. Generated Forms, Menus and Reports by using Modules directly or by using capture Design option. Customized PL/SQL procedures, packages, functions and triggers generated by the Designer. Worked on the Developer/2000 to customize generated forms, menus and reports to retrofit through the Designer/2000.
Installed and maintained Designer/2000 repository and administered the database during the ongoing process of this project.
Maintained and managed the database for Oracle Designer/2000 repository. Maintained and managed the database for Oracle Designer/2000 repository.

March, 1998 -  February, 1999
Oracle DBA

Responsible for maintaining Amex Data Warehouse, weekly loads on UNIX box Sun Solaris 2.6 OS for files received from 3 different vendors.
Responsible for Data Warehouse performance, tuning database, maintaining PL/SQL programs, back up and recovery.
Install Business Object on server and client machines, tested for 2 months and helped the management to make purchase decision.
Installed Oracle 8 enterprise edition on Windows NT 4.0 server, created new database, maintained parallel database to the Data Warehouse on Sun Solaris Server.
Convert existing database batch system to new Serve system for entire Data Warehouse for Amex Publishing.

January, 1995 -  February, 1998
DBA/System Analyst

Education

Skills


Business Intelligence : SAP CRM 3.1/4.0, SAP Solution Manager, SAP BW 3.1/3.0 ERP Expertese : SAP R/3 4.6b/4.6C/4.7 and ECC 6.0 Languages : ABAP/4, PL/SQL, SQL*PLUS, JAVA, C++, C, HTML, Shell Scripting DBMS : Oracle 8.1.7.2, 9i, Access, Sql Server/2000, mySQL Modeling : Oracle Designer/2000, Erwin Tools : Exceed, O.E.M., Oracle Performance Package, DBArtisan front end : Oracle Developer 2000 Platforms : Windows NT4.0, Windows 9x/2K/XP, UNIX, Sun Solaris 2.x Reports : BEx, Business Objects, COGNOS Impromptu, Power Play, E. piphany PROJECT JOB ROLES : SD/MM/FSCM Consultant Panasonic IBM : Process changes in ECC 6.0 upgrade for FSCM, MM and SD, Team size 5 TEAM LEAD Tire Kingdom Responsible for design, configuration and support SAP Warehouse Management system. Team size varied between 3 - 6 members. FUNCTIONAL LEAD Carroll Tire SAP WM Implantation TEAM MEMBER Metropolitan District Commission PM Module, upgrade from SAP 4.6c to ECC 6.0 TEAM LEAD Forbo Led the team to implement RF functionality. Team size 3 - 7 TEAM MEMBER Fabri-Kal Warehouse optimization project. TECHNICAL LEAD SouthCo NWDI/NWDS, TREX and R/3 ISA Configuration for SAP R/3 ISA B2B FUNCTIONAL LEAD Fabri-Kal Implement SAP R/3 ISA, TREX and IPC. TEAM MEMBER DirecTV SAP CRM Marketing functional consultant PROJECT LEAD Lord Corporation Implemented SAP R/3 ISA with TREX and IPC. Team size 2 - 7 FUNCTIONAL LEAD BASF Implement a component of SAP CRM Customer Interaction Center TEAM MEMBER Miscellaneous TFC s consulting project Senior. PROGRAMMER ANALYST Cablevision Oracle MDM Implementation PROGRAMMER ANALYST ADP Oracle Data Warehouse DBA American Express Oracle DBA


Miscellaneous

Database analysis and design for a commercial Internet based product. Used Oracle Designer 2000 for data modeling with Oracle as the backend.
Developed information accessing system using Oracle as the back end and Oracle Developer/2000 Forms 4.5 and Reports 2.5, Graphics 2.5 as the front end.
Ashok G. Singh Page 7