Больше информации по резюме будет доступно после регистрации
ЗарегистрироватьсяCandidate
Male, 38 years, born on 14 January 1987
Moscow, I want to relocate (Austria, Germany, Denmark, Canada, Netherlands, New Zealand, Norway, Russia, USA, Singapore, Finland, Czech Republic, Switzerland, Sweden), not prepared for business trips
SAP BI/BO
75 000 ₽ in hand
Specializations:
- BI analyst, data analyst
- Analyst
Employment: full time
Work schedule: full day
Work experience 15 years 4 months
August 2010 — currently
14 years 8 months
TATA Consultancy Services Limited
India, www.tcs.com
SAP BI Consultant
• Over 3.3 years experience in Information Technology of which the past 2.7 years is in SAP BI/BW & BO Version 3.5 and 7.0
• 8 Months of experience in Java and scripting technology.
• Actively involved in One End to End Implementations, one Up gradation, One Support & Configuration of SAP projects.
• Excellent Team Handling Experience which I came across as a team lead of 4 associates in only 2.5 years of experience.
• Adopted technologies which are more demand in market for development object like SAP HANA,SAP BO .
• Appreciation from client for on time delivery.
• Session on Technical parts for the team member.
• Training the fresher’s.
• Worked on many process improvement and value added activities
• Handle outage and product launch activities.
Technical Summery:
• Expertise in understanding and gathering Business rules, Business Requirements and End User cases and also client Business Process.
• Extensive experience in implementation and configuration of SAP FI/CO modules- GL, AP, AR, Customer Master, Vendor Master, House Banks, Fixed Assets, Controlling Area, Cost element & groups, Internal Order, Cost Center Accounting (CO-CCA), Cost center Profit center Accounting(CO-PCA) and Profitability Analysis(CO-PA) and SEM as source systems for BI/BW. Also, have good knowledge in SD and MM.
• Extensive experience in technical integration and development across various SAP modules, integration and Middleware development, unit/system testing of business processes, performing data loads, preparing deployment plans, cutover tasks in staging, QA and production systems.
• Proficient in designing of Custom Info Cubes, DSO’s, multi providers as per Business Requirement.
• Involved in Managing of Info cube, which involves Info Cube Content, Performance issues like Indexes, Statistics, BIA, Compression of Info Cube and Rolling up the data to the Aggregates.
• Creation of Generic Extraction using Table/Views and info set queries.
• Extensively worked on extracting data from CRM and SAP R/3 using LO Extractors from modules like SD and MM.
• Developed the ABAP Code in Start routines, Update rules, and Custom Extractors as per the business logic.
• Strong working experience as a SAP BW/BI Techno Functional Consultant with a broad knowledge including system landscape & architecture, security & authorizations.
• Worked business intelligence integrated planning.
• Activation, enhancements & Installation of Business Content for SRM, SD, FICO, MM, PP, PM, (HCM)HR, and QM
• Carried out Transport to staging and production environments, data transfer using Open Hub Services (OHB)/Info Spokes.
• Involved in the production support, Scheduling Start Process and Process Chains of Events, Data source Enhancement, Remote Cubes, MultiCubes, Data Mart and Open Hub Services, fixing errors and daily ETL Data load (Full/Delta up-load) Monitoring of the BW jobs and designed Process chains for Daily, Weekly, Bi-Monthly and Monthly data loads.
• Expertise in Report Generation as per user requirements using BEx/WAD/Business Objects such that the execution time is evenly distributed through out the report by using free characteristics, Restricted key figures, Calculated key figures, Variables, formula variables, Exceptions and Conditions.
• Good knowledge of Star Schema, Snowflake modeling, Fact, Dimensions Tables, Data Purging, ETL(Extract, Transform and Load)Processes, Data Mining, Data Audits and other Data Warehousing concepts.
• Developed flexible queries using filters, navigational attributes, variables, Cell Editor in Bex analyzer to facilitate data analysis in a drill down or summarized way to give detail level of information
• Expertise in BW Performance Tuning: Performed tuning measures of Queries by maintaining Aggregates, Roll up, Compression, partition, Process chains, indexing of info cubes and use of statistics for the same. Also, used variety of techniques to boost the performance of BEx Query
•
• Designed Queries and Workbooks using BEx Query Designer using filters, conditions, exceptions, structure, variables, calculated key figures, restricted key figures and navigational attributes as per business requirements.
• Expertise in designing of Process Chains, Meta Chains as per Business Requirement.
• Expertise in Production Support issues and handling tickets
Project Experience Summary:
Project Adobe Enterprises MS – SAP off
Customer Adobe Systems Inc.
Role Team Member
Description Production Support and enhancement.
Skills SAP-BI Version 3.5 & 7.0 ,
Achievements • Maintenance & Support of the existing SAP BI implementation.
• Monitoring the Process chain and Daily, weekly, and Monthly Data Loads using RSPC, RSPCM and RSMO.
• 24/7 production database on call support.
• Actively Involved in Rectification of Load Failure errors in Master Data and Transaction data loads.
• Created Process Chains and Scheduled as per the requirements.
• Involved in creation of Generic Data Sources as per the Business requirements using Views/tables and Info set query
• Creation of Info packages and DTPs for schedule the data load process with Full and Delta update mode.
• Evaluated Project wise aggregates for every 3 months and deactivated unnecessary aggregates and created new ones.
• Worked on query related performance issues.
• Involved in editing the error records in the ERROR stack and uploaded these records by using error DTP.
• Created Analysis Process Designer (APD) .
• Rectification of Job failures because of Source system errors, Short Dumps, Duplicate records, Attribute change run failure, ODS activation problem, Rollup Step Failures, Invalid character and Lock Issues.
• Managed and monitored several data loads, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Fixing different kinds of load failures independently and prepared root cause analysis
• to submit to client.
• Creation of reports based on CRM and finance super user requirements with BEX Query Designer by using Free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, Structure, formula, drill down, conditions and Exceptions
• Actively involved in sending reports to users by using bex broadcasting.
• As part of Quality management standards to deliver the objects in quality performed unit testing and recorded the test results in unit test case documents .
• Checking the system performance and database size through DB02 and cleansing the PSA Data Accordingly.
• Worked on COPA realignment and some special loads.
• Worked on sending the data to third party tool VIA OHS(open hub destination).
• Worked on process improvement related activities like changes in routine ,functional module to make more faster data loading.
• Worked on query performance improvement by well designed and efficient query.
Project Hi Tech-Rel Tax Intelligence
Customer KPMG
Role Team Member
Description Development project of Transfer price reporting using SAP-BI.
Skills SAP-BI, SAP-BO
Achievements • Very good functional knowledge about this project as I worked on this project from scrap level to 1st version release.
• Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed reporting specifications.
• Thorough understanding of the Functional specifications and outstanding issues related to specifications.
• Frequent meeting with the functional team to resolve the outstanding issues and regular updating of functional specifications.
• Responsible for developing High level Data flow and revising the Gap Analysis.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert knowledge of data warehousing concepts.
• Developed basic cubes for Cost Plus and Resale Minus Approach .
• Extensively involved in setting up of procedures for extracting data from SAP R/3 by using generic extraction.
• Created extractors to extract CO-PA data for the relevant Operating Concerns from SAP-R/3 into SAP BW and created corresponding Infosources, ODS Objects and Infocube in BW.
• Extensive knowledge in FICO- Finance & Controlling (General Ledger, AR and AP).
• Designed and developed process chains (RSPC) for master data loads and transactional data loads with the help of info packages. And these process chains are scheduled for periodically.
• Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.
• Created reporting authorizations and user profile maintenance.
• Daily coordinate with the onsite team to give/take handovers.
• Daily involved in production data loading and monitoring.
• Created a Process Chain, which deletes the PSA Data based on the Retention Periods.
• Used both initializations with delta update and Full update methods depending on the business requirement
• Developed queries on Different Infocube Using Bex Analyzer
• Created several Calculated Key figures, Restricted Key Figures, structures, variables to enhance the reporting features. Implemented conditions and restrictions in the reports based on the requirements. Used Hierarchies in the reporting to provide drill down features. Designed and developed reports with filters and free characteristics. Designed and provided RRI reporting.
• Involved in developing Xcelsius Reports designer to develop formatted reports and web reports.
• Involved in developing Xcelsius Reports designer to develop formatted reports and web reports.
• Involved in transporting the BW objects from development system to QA for unit testing and integration testing.
• Data extraction from different extraction modules like LO,FI-CO. Data source enhancement for the project and created generic DataSources
• Worked extensively on BEx Analyzer. Used Navigational Attributes, Filters, Exceptions, Condition, Variables, Hierarchies etc
• Worked on BI Integrated Planning to runtime input.
• Used Information broadcasting in some special scenario like, to inform client about their expired transfer price.
• Created customer exit variables.
• Hands on experience on WAD, Xcelsius, Web Intelligence.
November 2009 — June 2010
8 months
Interface Software Solutions
India, www.inss.co.in/
Jave Developer
Project WODC Project
Customer Western Orissa development corporation.
Role Team Member
Description Development Project
Skills J2EE, Oracle 10g
Achievements That was the web enabled project having all the necessary information district project finance system. In that project in every district some Govt. projects were implemented through the particular agency .The project was implemented in constituency that was a part of district. In every project there was a project head and some amount was released against that project. The total project is divided into separate phases and after the completion of each phase an enquiry was done by govt. against the work done. After the completion of the project a certificate will issued against that project.
Technologies used:
Client Side
Java Sever Pages, JavaScript, AJAX
Server Side
Struts
Web server: Tomcat 5.0
Operating system: Microsoft Windows XP sp2
Database: Oracle 10g
About me
SAP BI / BW
As an expat I understand the complexity of the registration of all documents to obtain a work permit, so I'm ready to prepare them by myself.
Higher education
2010
KIIT University
Master in Computer Application, Masters
2006
Ranchi University
Physics, Bachelor
Languages
Citizenship, travel time to work
Citizenship: India
Permission to work: India
Desired travel time to work: Doesn't matter