[59225] in SAPr3-news
Excellent SAP BW BI consultant available
daemon@ATHENA.MIT.EDU (Anshita@dgntechnologies.com)
Fri Apr 13 12:45:57 2007
To: sapr3-news@mit.edu
Date: 13 Apr 2007 09:45:50 -0700
From: "Anshita@dgntechnologies.com" <ansh.jalan@gmail.com>
Message-ID: <1176482750.650600.84380@y5g2000hsa.googlegroups.com>
PRADEEP
SAP BI CONSULTANT
SUMMARY
=EF=82=A7 Total of 7+ years of experience in the IT Industry which includes=
4
+ years of experience in SAP
(SAP BI 7.0, SAP BW 3.5 / 3.1C / 3.0B, SAP R/3 AND ECC 6.0).
=EF=82=A7 Experienced in all phases of BW applications using ASAP methodolo=
gy.
=EF=82=A7 Proposed sound solutions to user requirements and exercise judgme=
nt
within generally defined practices and policies in selecting methods
for obtaining solutions.
=EF=82=A7 Technical and functional well augmented by excellent analytical,
problem solving, communication, and interpersonal skills,
with the ability to deliver innovative and profitable solutions within
timeframe and budgets.
CORE COMPETENCY
#
APPLICATION/SOFTWARE/SOLUTIONS
AREA OF EXPERTISE
EXPERIENCE
1
SAP BW 3.5, 3.1C, 3.0B
Business Warehouse:
=EF=82=A7 Modeling
=EF=82=A7 Business Content
=EF=82=A7 Extraction (SAP, Non SAP and Flat File)
=EF=82=A7 Performance Tuning
=EF=82=A7 BEx Analyzer
=EF=82=A7 BEx Query
=EF=82=A7 Web Application Designer (WAD)
=EF=82=A7 Web Interface
4 years
2
SAP NW 2004s
SAP BI 7.0
=EF=82=A7 Transformations
=EF=82=A7 DSO
=EF=82=A7 Information Broadcasting
=EF=82=A7 DTP
=EF=82=A7 Enhanced Monitoring
=EF=82=A7 Migration
1 year
3
ABAP
Transfer Rules , Update Rules
Conversion Routines, Start Routines
and User Exits
2 years
4
SAP R/3
Logistics (SD,MM,PP), FI (AR / AP), CO-PA and CRM
Order to Cash, Order Management
2 years
5
SAP Web Application Server
Basic Administration
2 years
TECHNICAL SKILLS
=EF=82=A7 Data warehouse Tools - SAP BW 3.5/3.1C/3.0B
=EF=82=A7 Reporting Tools - SAP BEx, Crystal Reports
=EF=82=A7 Databases - MS SQL server, MS-Access, DB2, Ora=
cle
8i
=EF=82=A7 Languages - ABAP/4, HTML, SQL, C, C++
=EF=82=A7 Operating Systems - Windows NT, Windows 2000
=EF=82=A7 DWH Concepts - OLAP, Data Mining, Multi-Dimensional D=
ata
Modeling
=EF=82=A7 Other tools - MS Office, Lotus Notes, Visio,
Rational Rose
PROFESSIONAL EXPERIENCE:
Ditan Corporation,
CA
Apr=E2=80=9906 =E2=80=93 Till date
SAP BW Consultant
Environment: SAP BW 3.5, SAP BI 7.0, ECC 6.0, ABAP, BEx, SD, MM, PP,
FI, CO and PLM
Responsibilities:
=EF=82=A7 Involved in Full-Life Cycle implementation of BW 3.5 using ASAP
Methodology.
=EF=82=A7 Worked with different user groups to gather business requirements
and transformed them into a data model using Extended Star Schema
model.
=EF=82=A7 Involved in Data Modeling, Data Extraction, Data Loading (Full/De=
lta
Upload), Scheduling, Monitoring.
=EF=82=A7 Modeling tasks included creation of Info Object, Info Cube, Info
Source, Hierarchy, Logical Information System, Multi Cube, ODS Object,
Process Chain, BEx Analyzer, BEx Query, Workbook & Web Report
Publishing.
=EF=82=A7 Analyzed business reporting requirements that satisfy with SAP
Business Content and installed the necessary objects for Business
Content Sales Cube.
=EF=82=A7 Extracted data from SD, MM and FI/CO modules of SAP R/3 and from
flat files into SAP BW system using Generic Business Content and LO
Extractors.
=EF=82=A7 Worked extensively with Sales Order, Billing, Delivery Schedule L=
ine
and Document Condition (HDR and ITM) objects
=EF=82=A7 Created APD's (Analysis Process Designer) to join billing document
HDR and ITM, delivery HDR and ITM and updated the data into
corresponding Direct Update DSO's.
=EF=82=A7 Maintained APD's joining VAHDR, VAITM, VASCL and VAKON to get
aggregated data at sales document level.
=EF=82=A7 Used Delta Update process for loading the data to BW from R/3 in
specific intervals.
=EF=82=A7 Created Multi Cube for analyzing the data between different modul=
es
and ODS to store document level data and restrict the duplicate data.
=EF=82=A7 Copied data from one cube to another cube using the Data Mart
interfaces.
=EF=82=A7 Worked extensively on BEx Query Designer to create Queries on ODS
Objects, Info Cubes, Multi Providers and published Web Reports.
=EF=82=A7 Created queries using variables restricted key figures, filters,
exceptions, conditions and free characteristics
=EF=82=A7 Worked with Report to Report Interface (RRI) to drill down from I=
nfo
Cube to ODS item and schedule line level information.
=EF=82=A7 Involved in optimizing the queries and created reports using BEx
Analyzer and Web Application Designer to develop Web Reports.
=EF=82=A7 Scheduled and automated data loads from R/3 to BW and optimized t=
he
load performance by adjusting the packet size, data selection and
number of Info Packages.
=EF=82=A7 Involved in performance enhancement features such as cube
partitioning, indexing, maintaining aggregates and compression.
Solo Cups, Illinois Aug=E2=80=9905 =E2=80=93 Mar=E2=80=9906
SAP BW Developer
Environment: SAP BW 3.5, SAP R/3 4.6b, FI, SD, MM.
Responsibilities:
=EF=82=A7 Performed analysis, design, development and implementation of
standard/customized Info Cubes and
ODS objects for FI, MM and SD modules.
=EF=82=A7 Involved in Data Modeling, defined dimensions and developed a
worksheet for fact table details in the
BW extended star schema.
=EF=82=A7 Worked extensively on LO Cockpit and COPA extractions
=EF=82=A7 Modified standard and created custom info sources, info Objects, =
ODS
and InfoCubes for SD and FI.
=EF=82=A7 Involved in workstreams like OTC (Order to Cash) and Order
Management and Involved in FI (AR / AP).
=EF=82=A7 Used job-scheduling tools to load data and Monitoring and
troubleshooting of process chains
=EF=82=A7 Assisted in performance tuning for loading data and improving the
query response time using aggregates, info cube partitioning and
indexing.
=EF=82=A7 Worked with PSA in Monitoring the Data Transfer from Source Syste=
ms
into BW.
=EF=82=A7 Expertise in Reports Generation-BEx Analyzer in building Queries =
and
saving in Workbooks (Excel Work Sheets), creation of Custom Queries
using Conditions, Exceptions, Variables & Structures and created
aggregates for frequently used queries.
=EF=82=A7 Created queries using variables restricted key figures, filters,
exceptions, conditions and free characteristics.
=EF=82=A7 Monthly & Weekly extractions were scheduled using Info Packages,
Setting Transfer rules, transfer routines, writing start routine and
update routines.
=EF=82=A7 Created a cube to provide reports on the Sales Backorders SD_C14 =
and
Sales overview SD_C03.
=EF=82=A7 Performed end user training sessions in reporting scenarios, and
documented the whole project.
AVENTIS PHARMA, New
Jersey
Oct=E2=80=9904 =E2=80=93 July=E2=80=9905
SAP BW Consultant
Environment: SAP BW 3.1C, SAP R/3 4.5b, FI/CO, SD, MM.
Responsibilities:
=EF=82=A7 Automation of master data and transactional data loads. Managing =
and
maintaining non-R/3 master data. Daily extracts and cube builds.
=EF=82=A7 Defined dimensions and developed a worksheet for fact table detai=
ls
in the BW extended star schema.
=EF=82=A7 SAP system performance tuning, hierarchy creation and maintenance=
in
BW.
=EF=82=A7 Worked on creating Info Cubes and ODS objects for different
applications that include Sales Revenue, Profitability, Cost Center
Accounting, Inventory, Customer Hierarchy, and Product Hierarchy.
=EF=82=A7 Tailored transfer structures, communication structures and update
Rules using ABAP and Formula Builder.
=EF=82=A7 Enhanced Master Data Sources for 0MATERIALand 0CUSTOMER
=EF=82=A7 Enhanced COPA extract structures and populated them using user
exits.
=EF=82=A7 Monthly & Weekly extractions are scheduled using Info Packages by
using after jobs & after events
=EF=82=A7 Created queries using variables restricted key figures, filters,
exceptions, conditions and free characteristics.
=EF=82=A7 Assisted in performance tuning for loading data and improving the
query response time using aggregates, infoCube partitioning and
indexing.
=EF=82=A7 Handled postproduction support Training and preparing manuals for
end users.
TVS MOTORS LTD,
INDIA
April=E2=80=9803 =E2=80=93 Aug=E2=80=9904
SAP BW Consultant
Environment: SAP BW 3.0B, SAP R/3 4.6C, MM, SD, PP.
Responsibilities:
=EF=82=A7 Info cube after replication and Updating of Data Source from sour=
ce
system and thereafter-created Transfer rules, Info packages and Update
rules.
=EF=82=A7 Uploaded master and transactional data from flat files and R/3.
=EF=82=A7 Extensively worked on LO cockpit including customizing & performi=
ng
necessary procedures like Setting up of V3 update, Deleting set up
tables, filling up of set up tables.
=EF=82=A7 Used ODS to stage the data before transferring the ODS contents to
the Info cube.
=EF=82=A7 Involved in creation of reports using BEX Analyzer such that the
execution time is evenly distributed through out the report by using
Free Characteristics, Restricted Key Figures, Calculated Key Figures,
Variables, and Structures Exceptions.
=EF=82=A7 Created info Packages and populated info Cubes with initialization
and delta loads at predefined scheduled time settings. Used full
update methods depending on the requirement.
=EF=82=A7 Created navigational attributes for certain characteristics for a
better drill down option during querying
=EF=82=A7 Monitoring of Info packages and analyzing the reasons for frequent
failures of Info packages.
=EF=82=A7 Maintaining Work History for all the tickets until it is closed d=
own
ABB
Ltd
July=E2=80=9902 =E2=80=93 Feb=E2=80=9903
Senior Programmer
Environment: Visual Basic 6.0, VB .NET, C, SQL, Crystal Reports,
Oracle 9i
Responsibilities:
=EF=82=A7 Designed and Developed Customer and case module with developing
ActiveX Exe for the common Search forms.
=EF=82=A7 Used Microsoft Visual SourceSafe for version control and change
management practices and procedures.
=EF=82=A7 Enhancements and bug fixes to layout manager, dictionary manager,
main application, experiments and protocol manager
=EF=82=A7 Responsible for understanding requirements & then analyzing the
system and designing it using normalization technique
=EF=82=A7 Design of all the screens and development of modules for Masters =
and
Transaction that included issues to contractors, customers, other
sites, scrap, receipts for the same.
=EF=82=A7 Design and coding the User Interface that involved windows sub
classing, extensive windows registry access, Third party controls
Lotte India Ltd
Mar =E2=80=9901 =E2=80=93 June =E2=80=9902
Application Developer
Environment: Visual Basic 5.0, ASP, MS FrontPage, Oracle 8i and
Windows NT 4.0
=EF=82=A7 Installing Oracle test databases and creating and tables under te=
st
schemas
=EF=82=A7 Assisted the senior programmers in building GUI and database
programming using VB and Oracle.
=EF=82=A7 Created numerous reports in Crystal Reports
=EF=82=A7 Maintenance of database and backup planning
=EF=82=A7 Review of code written by other team members to ensure that coding
standards are met
=EF=82=A7 Created user manual, Installation diskettes for software
distribution.
=EF=82=A7 Involved in variety of tests like UAT, Black Box, White Box, UNIT,
and System Test.
=EF=82=A7 Responsible for the data base design, Creation of forms for feedb=
ack
from various levels of sales force and analyzing it at the Managerial
level
