Resume of AMARJIT SINGH



Resume of AMARJIT SINGH

[pic]

SUMMARY OF QUALIFICATIONS:

• Over TEN years’ experience in IT industry with over SEVEN years of SAP Business Warehousing/Business Objects and ABAP 4.x experience. Proficient with planning, design implementation, troubleshooting and performance tuning support of SAP Business Information Warehouse Reporting and BOBJ Reporting.

• Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.

• BI Design - Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Info Packages using AWB. Proficient in Data modeling using MDM and BW extended star schema models.

• Experience in ETL i.e. Data Extraction, Data Transferring, Data Loading such as SAP BI and Informatica.

• Primarily focused on Front end reporting (Work books, Web templates, Dashboards) on SAP BW along with its integration with SAP Portal, KM and third party tools like Business Objects and Crystal reports.

• Experience in Integrating and Extracting data into Business Objects environment from the SAP BW database system. Created WEB Intelligence Reports, Formatting reports (BOBJ), as per user requirements.

• Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenario. Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.

• Experience in Hierarchies, Authorizations, BW Statistics, Archiving, Process chains and Open hub.

• BI Reporting - Experience in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, RRI, Reporting Agent and Broadcaster.

• Experienced in Cognos 8 tools (Query studio, Report studio, Analysis studio, Metric studio, Event studio), Impromptu/PowerPlay. Designed customized and formatted reports using Reportnet. Expertise in implementing BEx Reporting.

• Activating delta extractors for funds management, working with delta queues and analyzing impact of delta process on R/3 transactions. Enhancement of standard BW extractors in the areas of Accounts Receivable, Accounts Payable) to get the fund information from BSEG.

• Performance tuning of Queries (SAP BW BEX and Cognos) by maintaining Aggregates, Compression, partition, indexing of info cubes and use of statistics for the same. Developed reports using different performance variables such as filter and prompts for better report functionality and quicker response time.

• Strong experience in reporting with SAP BW info providers such as Info objects, Cubes, Queries. Expertise in reporting with Cognos 8 tools on different SAP R/3 functional areas combining data from different R/3 function modules (SD, FICO, MM) in BW.

• Implemented SAP BW core business rules (Security (roles), Calculated Key figures, Restricted Key figures, Query variables) in Cognos tools. Integrated Cognos Reporting with BW functional areas for detailed reporting.

• Configured Cognos Connection (portal) and performed Metadata modeling in Framework Manager. Created models and published packages with Framework Manager and combined data from SAP BW and Non SAP BW data sources for reporting. Exceptional ability to quickly master new concepts and technologies.

• Currently working in SAP BI 7.3 and knowledge of HANA modeling. Capable of working in a group as well as independently with excellent communication skills. Strong production support experience, good at trouble shooting with quick turnaround in fixing the issues.

BW Skills:

• BEx Worked Extensively in BEx Analyzer in building Queries, saving it in Workbooks (Excel work Sheets). BW Expertise in SAP BW components like Info Cubes, Multi providers, Info Source, Info Objects, Update Rules and Transfer Rules, Which Includes Data Modeling.

• Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, and Jump queries.

• Web Reporting Developed Web reports, Web items, customized Web templates using Web application designer (WAD) and query designer.

• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning.

• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.

• Experience in the technical and functional system upgrade from BW 3.1C to BI 7.0 (NW2004s). Business Area: FI-CO, SD, MM, PP.

• BI operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.

• ABAP - Reporting, User Exits, Customer modifications. Proven success in performing all reporting features, OLTP Extraction from SAP R/3 into BW using different extraction structures. Functional expertise in SD, MM and FI/CO. In-depth knowledge of reporting flow from R/3 to SAP BW.

Production Support:

• ABAP - Reporting, User Exits, Customer modifications. Specifications for Documented functional and technical production support and project enhancements.

• Worked with the project team and multiple end-users to resolve accounting issues and identify opportunities for business process improvements. Provided production support in BW reporting.

• Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities.

• Assisted in ongoing communication to SAP and BW end-users on business process and systems changes, and issues resolutions.

TECHNICAL SKILLS:

ERP: SAP R/3 ECC 5.0, 4.7/4.6c/4.5/4.0.

ETL Tools: SAP BW 7.3, Informatica 7.x, Datastage.

Reporting Tool: BOBJ WEB Intelligence, Cognos 8.x/7.x, TM 1 (Impromptu, PowerPlay), Business Objects XI 3.1(Web Intelligence, Xcelsius) BEx Reporting, Web Reporting & BW 3.5/3.x/2.x, , Crystal Report 7.X/8.X.

Data Modeling Tool: ERWIN, HANA Studio.

SAP Modules: HR, SD, MM and FI/CO.

Operating System: Windows 7, 2000, NT, 98, XP, MS-DOS, Sun Solaris.

GUI: Visual Basic, Developer 2000, and SAP GUI.

Programming Language: SAP ABAP/4, JAVA and Visual Basic.

Databases: Oracle 9i/8i, SQL Server and MS-Access.

Presentation Tools: MS-Office & MS-Project.

PROFESSIONAL EXPERIENCE:

Feb ‘14 - Present TransAlta

SAP BW/BO Consultant Houston, TX

The project involved implementation on SAP BW on HANA. Also there were requirements for building multiple BOBJ Executive Dashboards and Reports using the latest BOBJ tool (Design Studio).

Responsibilities:

• Architecting reporting requirements into technical design and development. Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports. Architected the Re-org of BW objects to maintain standards.

• Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the premigration of BW on HANA implementation. Optimized BW cubes for HANA purpose.

• Performed BW functionality, BEx functionality and BPS testing for post migration process of HANA. Interacted with the Finance Business Analysts on a daily basis for their KPI & report requirements. Managed, Configured and Performed Transports between multiple BW environments.

• Used RealTech Transport Manager to perform transports. Maintained Ztables in BW to load Master data. Performed BW Master and transaction data loads on required basis. Created and scheduled Process chain for daily Delta loads.

• Troubleshooting data and technical issues related to SAP BW. Managed Client BW environment to co-ordinate development, testing and transports to Production.

Environment: SAP BW 7.3, Design Studio 1.1&1.2, Business Objects 4.0 Web Intelligence, Xcelsius, Crystal Reports, Data Integrator, and Windows NT.

Sep ‘12 - Oct ‘13 UFA

Sr. SAP BI Consultant Calgary AB

The project at UFA is a production support and sustainment role primarily but also involved project for building data foundation for Tax reporting. This involves supporting the users for their data needs and new requirements.

Responsibilities:

• Supporting users for their reporting needs in the different business areas of UFA (Agri Business, Finance, and Petroleum). Enhanced master (Customer, Material) data extractors to meet the new report requirements.

• Reviewed existing BW standard documentation to add some recommendations. Architecting a solution for supporting a requirement for BW/BI.

• Designed simple to complex data flows as per the requirement using most of the BI objects (Infoobjects) and infoproviders (Multiprovider, Infocube, DSO etc.). Used ABAP for transforming some of the HR data to support report level calculations.

• Designed BEx queries for HR Headcount and Turnover reporting. Reviewing the existing HR reports and calculations to work on re-designing them. Created cubes and DSO’s objects for petroleum business. Performed a system wide BEx query clean-up.

• Created generic data source for custom requirement and enhanced data sources as required.

• Built a strong data foundation for finance reporting which involved integration of goods movement and billing conditions data. Defined rules in the logic provided to support tax reporting. Worked on fixing process chains issues while transporting them from one system to other.

• Solving MS-excel export issues from the BI portal. Monitored Process Chain on a Daily basis.

Environment: SAP BW 7.2, Windows XP, SQL Server 2005.

Aug ‘11 - Sep ‘12 Enerflex

SAP BI-BO Architect/Lead Calgary AB

The project is a First ever BW-BI implementation for their new SAP implementation. Data coming into SAP is coming from different legacy Datasources used by the Enerflex. It also includes the integration SAP BW and Business Objects toolset.

Responsibilities:

• Assessed business requirements and defined technical specification documents for Personnel Actions, Benefits & Payroll for Human Resources. Leading the BW Implementation and BOBJ (BI 4.) Reporting integration.

• Worked closely with the end users on a day-to-day basis for their reporting needs. Created Architecture documents for the BW implementations with the naming standards.

• Recently implemented Bookings, Backlog & Billing reporting using SAP and legacy data. This involved the integration of Sales, Billing, Profitability Analysis and Project Systems data integration.

• Implemented BW-HR reporting for HR users. Created report for Headcount, Payroll and Benefits BEX & WEB Intelligence reports. Activated BI content heavily for the first ever BW implementation for the company. Define configuration for the implementation.

• Created Universe and Web Intelligence reports using BEx queries. Defined best practices to use BEx queries in Business Objects. Helped Basis in setting up the BW landscape for transports management and configuration. Performing testing for BI 4.0 toolset.

• Involved in setting up special security for HR. Worked with security for defining different roles for developers and end-users. Monitored Process Chain on a Daily basis. Created generic data source/extractor for Profitability Analysis (ECC) data to combine R/3 data into BW.

• Architected the dataflow in Business Warehouse. Defined cubes and DSO’s using the standard Data sources from HR. Defined BEx queries as per the report requirement. Defined best practices on BW and BO data services integration. Data was transformed in both BW and BO Data Services.

• Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.

• Managed Client BW environment to co-ordinate development, testing and transports to Production.

Environment: SAP BW 7.1, Business Objects 4.0 Web Intelligence, Xcelsius, Data Services, Windows NT.

Jul ‘10 - Jul ‘11 TransAlta

SAP BI/BW/BO Consultant Calgary

The project includes requirement gathering and development of a strong data foundation for the Enterprise for different Business Areas. It also includes the integration SAP BW and Business Objects toolset.

Responsibilities:

• Implemented Technical design and Development for Production & Prices functional area. Created BEx queries to simulate/validate results achieved from Web Intelligence reports. Architected the Re-org of BW objects to maintain standards.

• Reconciled Inventory and purchasing data from BW to R/3 for existing Production reports. Created Infoobjects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need.

• Assisted in configuring BO Data Integrator as a Source system and also used it to send transformed data from Oracle to BW. Created generic extractor to combine R/3 data into BW. Enhanced the extractor for Inventory Management and Purchasing under SCM project.

• Interacted with the SCM Business Users on a daily basis for their KPI & report requirements. Defined best practices on BW and BO data services integration. Data was transformed in both BW and BO Data Services. Managed, Configured and Performed Transports between multiple BW environments.

• Used Real Tech Transport Manager to perform transports. Leveraging existing function modules (Time (UTC) conversion, Master Data lookup etc.) for various transformations.

• Designed technical implementation of Timezone implementation for reporting over different timezones (MST, PST, EST, and CST). Maintained Ztables in BW to load Master data. Performed BW Master and transaction data loads on required basis.

• Created and scheduled Process chain for daily Delta loads. Troubleshooting data and technical issues related to SAP BW. Managed Client BW environment to co-ordinate development, testing and transports to Production.

Environment: SAP BI 7, Business Objects Web Intelligence, Xcelsius, Crystal Reports, Data Integrator, and Windows NT.

Mar ‘10 - Jun ‘10 Munichre America

SAP BI-Cognos Manager/Lead Princeton, NJ

The project includes requirement gathering and development of set of Formatted and Adhoc Cognos reports from finance Multiproviders in SAP BW.

Responsibilities:

• Assessed project requirements defined by customer, including desired reports and performance expectations. Conducted interviews with clients to solidify the required business rules and fact-finding sessions with continued reviews throughout the project lifecycle.

• Created full functional requirements for the development team. Developed report specs according to customer requirements.

• Created BEx queries to simulate/validate results achieved from Cognos query. Per customer requirement, this approach was also used by the customer to gauge performance differences between Cognos and BEx.

• Created and maintained all Framework Manager multi-dimensional models and packages while applying security to the Framework Models and packages.

• Responsible for researching Cognos Software fixes patches and developing an implementation schedule for installation and maintenance issues or upgrades of Cognos software. Created and fine-tuned Infoqueries leveraging business rules in BW to minimize load on Cognos BI.

• Documented Best Practices and Reporting Governances for Cognos on SAP BW reporting for Nike. Analyzed BW environment to determine opportunities for fine-tuning and issued recommendations that were followed through by the customer’s BW team.

• Investigated and resolved issues, including workarounds, pertaining to report requirements that were not directly feasible using straightforward approach. Training end users in building Ad-hoc reports using Query Studio. Created and bursted reports to Emails and Web.

• Analyzed MDX to determine background query processing and interaction between Cognos and BW. Led team meetings, providing status and defining go-forward approach based on achievable results. Developed Dashboards for sales and accounting functions.

Environment: SAP BW 3.5 Cognos 8.3/8.4 (Report Studio, Query Studio), Windows NT.

Jan ‘09 - Feb ‘10 Clear Blue (IBM)

Senior BW/BI Lead Parsippany NJ

The project is divided into two phase where both Phase 1 & Phase 2 includes requirement gathering and development of set of Cognos reports from Sales Multiproviders in SAP BW.

Responsibilities:

• Assessed project requirements defined by customer, including desired reports and performance expectations. Involved in Business blue print and technical specification. Developed of Functional Specifications for standard cost reporting. Developed Technical Design Documents including GAP Analysis.

• Configured and activated Business content according to the requirement based on the Application areas. Extracted data from data source 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM to extract an opening stock balance, material movements and valuated revaluations in Financial Accounting.

• Created Multicube to all access reportable Objects on daily and monthly level. Configured, activated and enhanced Business content for base actual cost and project actual cost according to the requirement. Extracted data from BW to APO system and from Planning Area to Info cubes.

• Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenario. Provided production support in BW reporting. Generated reports using BEx Analyzer and Crystal Reports.

• Integrating and extracting data into SAP BW environment from the Business Objects (Data Integrator) system. Designed, Developed and maintained the Xcelsius dashboards in both Xcelsius 4.5 and 2008.

• Primarily focused on Front end reporting (Work books, Web templates, Dashboards) on SAP BW along with its integration with SAP Portal, KM and third party tools like Business Objects and Crystal reports.

• Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities.

• Multidimensional Data Model using Extended Star Schema designed and developed Info cubes, DSO, Info Source and Data Source. Used Open Hub for exporting data out of SAP BW into other formats. Created Start Routines, Transformation rules for DSO and Info Cubes.

• Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load problems.

• Analyzed OLAP performance using BW statistics. Improved query and load performance using Aggregates, Partitions, Indices, Packet Size, Data Selection, and Data Compression.

• Documented reporting approaches and governances. Created multiple complex Drill through reports in Cognos using BEx variables. Implemented SAP security to restrict sensitive data and query level access where Cognos Security for report level access to users.

• Used SAP BW Business Rules to improve report performance and functionality. Assisted fellow team members in solving their report issues.

Environment: SAP BW 7/3.5, SQL, Xcelsius, Crystal Reports (BOBJ).

Jul ‘08 - Dec ‘08 Nike

Senior BW Consultant Beaverton, OR

Nike is ranked as 163rd of the Fortune 500 companies. The project is related to Sales Ad hoc and formatted reporting using SAP and Cognos Reporting tools. It involved creation of multiple Ad hoc and formatted reports on SAP. Worked with the team of SAP BW professionals where integration of Cognos 8.3(SP 2) over SAP-BW.

Responsibilities:

• Involved in data model design for Enterprise data warehouse layer, Architected data mart layer and reporting layer. Assisted team in blueprinting POS requirements and design of future POS architecture.

• Investigated SAP's Retail Store product and estimated effort required to configure and develop the POS inbound and outbound IDOC interface. Created infocubes with headcount/personnel action/payment analysis based on different detail level of employee/action/wage.

• Created various Views and Stored procedures using PL/SQL for Crystal Reports.

• Created the reports using Crystal Reports functionalities like Add Queries (Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown lists etc. Created Start Routines, transformation routines for ODS and Info Cubes.

• Created Process chains for all Master data and transaction data loading from acquisition layer to data warehouse layer, and finally to Architected data mart layer. Optimize system by means of RRI, compression, aggregation, partitioning, line-item dimension.

• Transport the business object from developer environment to test and product environment. Created Planning Cubes, Planning Areas, Multiplanning Areas to plan on more than one planning areas. Created Planning Folders for User access. Worked with Global Planning functions.

• Developed report specs according to customer requirements. Documented Best Practices and Reporting Governances for Cognos on SAP BW reporting for Nike.

• Analyzed BW environment to determine opportunities for fine-tuning and issued recommendations that were followed through by the customer’s BW team. Investigated and resolved issues, including workarounds, pertaining to report requirements that were not directly feasible using straightforward approach.

• Training end users in building Ad-hoc reports using Query Studio. Created and bursted reports to Emails and Web. Analyzed MDX to determine background query processing and interaction between Cognos and BW. Led team meetings, providing status and defining go-forward approach based on achievable results.

Environment: SAP BW 7/3.5, SEM-BPS, Crystal Report, Cognos 8.3 SP 2(Report Studio, Query Studio), UNIX.

Oct ‘07 - Jun ‘08 Duke University

SAP BW Developer Durham, NC

This project includes order to cash, which includes order management, accounts receivable, inventory management, sales and marketing report.

Responsibilities:

• Worked with the business end users to gather requirements and created Business Requirement documents (BRD) for the reports to be built on the Multicube and dependent ODS’s. Activated various BW objects from standard business content.

• Gathered Business Requirements from SD module and Conducted Gap Analysis to install Business Content. Designed & Developed custom DataSource, InfoSource, Extractor, InfoCube and ODS to fulfill user requirements.

• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.

• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3. Enhancement of standard BW extractors in the areas of Accounts Receivable, Accounts Payable (0FI_AR_4 and 0FI_AP_4) to get the fund information from BSEG.

• Developed data loading strategies for master data, transactional data and delta uploads. Created Open Hub, process chains for data loading, delta uploading and periodical PSA deletion.

• Created Multiprovider on sales, delivery and billing cubes to assist reporting on sales, delivery and billing together.

• Worked on Creating Aggregates, open hub data integration, Compressions, Indexes, multiprovider and parallel setups for data loading to improve performance and utilize data effectively.

• Extensively worked on Query Designer and Web application designer to create Queries to perform sales, delivery and billing analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.

• Performed data design, data modeling, designed star schema and extended star schema models. Configured Cognos Connection (portal) Extensive Framework Manager modeling connecting BW data sources and Non BW data sources.

• Integrated BW Business Rules (Hierarchies, BEx variables, structures, RRI interfaces) with Cognos tools for enhanced and flexible reporting. Developed reports using Cognos 8 tools such as Metrics studio, Report Studio, Analysis studio.

• Used MDX capabilities for improving system efficiency. Traced the MDX/BAPI statements. Implemented multilevel security in Cognos leveraging BW security (Roles) features.

• Performed complex reporting using BW Infoproviders and Queries in Cognos 8. Created multilingual reports using Cognos Report Studio. Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.

• Implemented new Planning and Frontend functionalities using Netweaver 2004s. Enhanced Reporting, Data modelling capabilities with 2004s. Created several Process Chains to Automate the Process. Extracted data from R/3 and flat file.

• Transported the Objects across system landscapes. Defined several Start routines, Transfer routines and Update routines. Worked extensively on BW Statistics, Indexes, Data Marts, Error handling in subsequent processing, Transport connection, data cleansing in PSA.

• Worked on Infocube partitioning and setting customized Info Cube tablespaces. Monitored settings and customized programs for e-mail notification. Automatic deletion of Info Packages and dynamic selection criteria. Involved in complete life cycle of the project from conception to go-live.

Environment: SAP BW 7/3.5, 2004s, Cognos 8.2, Reportnet MR2 SEM & ECC 5.0, Oracle.

Jun ‘07 - Sep ‘07 BASF

SAP BW Developer Rockaway, NJ

The project is a consolidation of supply chain management in which a team of BW consultants and ABAP Developers created required Info Providers in SD and MM modules to track the number of products sold by region, date, number of parts supplied to DCs (Distribution Centers) by region, date, parts in inventory by region, date and designed and built number of front end reports in Cognos 8, Impromptu/Powerplay and BEx to provide decision support for higher level management.

Responsibilities:

• Gathered the requirements from End Users. Finalized all the reports that need to be developed in BI based on the existing reports in third party systems. Created no of conversion routines to fill the gaps like, routine to convert basic units of measure.

• Development of authorization plan based on user requirements and business requirements.

• Created Open Hub, Process Chains to automate the data load and data target administration. Worked with basis and system admin teams to define specifications for frequency and mode of data transfers and setup of batch jobs.

• Performed Logistics data Extraction using LO Cockpit. Extracted data for various Controlling–Cost Center Accounting, actual Line Items and commitment Line Items from R/3 to BI. Created CO-PA and Generic data sources.

• Schedule and performance monitor periodic data loads from SAP R/3 to BI.

• Working on complex Business Intelligence Reports using Cognos Report studio and Analysis Studio. Working on Cube data’s and developing many cross tab reports by using various MDX functions like Tuple, Children, Memberset and experienced in Query joining.

• Working on Management Reports for decision-making purpose. Creating many Cubes depends on the Reporting needs. Interacted with Business users and collected business information and their requirements for developing different type’s reports using Report Studio.

• Created Powerplay Models and Cubes using Transformer. Built Dimension Maps based on customer requirements for different cubes. Designed Multi Dimensional Cognos Power Play Cubes and reports. Configuring SAP GUI and Cognos Connection for reporting on Infoobjects, Infocubes and Queries.

• Reporting on Infocubes from different Functional areas of BW combining data from multiple datasources. Using the BW Business Rules such as Security (roles), Query variables, Calculated Key figures, Structures into Cognos 8.

• Using Cognos 8 tools (Query Studio, Report studio, Analysis Studio, Metric studio, Event studio) for enhanced, customized and formatted reporting as per the end user requirements.

• Implementing multiple security levels in Cognos. Created and published packages in Framework Manager from various sources in ReportNet. Generated different kind of reports in Report Studio; created templates and multilingual reports.

Environment: SAP BW 3.1, SAP R/3 4.7, Cognos 8.2/Impromptu, Powerplay 7, ReportNet MR 2, Windows NT, SQL Server.

Nov ‘05 - May ‘07 Sharelogic

SAP BW Developer Milford, CT

It is an In-house project for various Sharelogic Clients in the East Coast such as Birstol Myers Squibb, Chase. The Phase 1 of the project involved automation of Sales report scheduled by process chains.

Responsibilities:

• Gathered information from end user based on their needs. Development of BW objects (Info Objects, Info Cubes, Data Sources, Info Sources) and responsible for data loading (Master Data and Transaction Data).

• Uploaded Master and Transactional data from flat files and SAP as the OLTP source. Worked on exporting of BW objects (Object Transport) to quality assurance and then to the production environment.

• Created Process Chains for the data loads and to automate it and optimized the process chains by dividing processes chains into level1 and level2 process chains in order to optimize the scheduling and loads in BW.

• Responsible for customizing and activation the Business Content Objects and Loading the data into ODS Object and Info Cubes. Scheduled Extract Jobs, Grouping of extract Jobs, Monitoring of Transfer and Update rules for data Loads, Monitoring of Status display and Load Statistics for Update Process.

• Worked on enhancing business content as per the requirement. Created Aggregates to Improve query performance. Extensively worked on standard and custom defined LIS and LO extractors. Extensively worked on BEx Browser, BEx Analyzer and Info set queries.

• Created calculated key figures, restricted key figures, variables and exceptions. Organized business roles and functions and managed workbooks using BEx Browser.

Environment: SAP BW 3.1, ABAP 4.6C, Windows NT, Business Explorer.

EDUCATION:

Bachelors of Computer Applications, India.

-----------------------

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download