SUMMARY:

• SAP BW/BI/BO Solution Analyst having over 11 years in SAP Consulting, Design, development and implementation of various business applications.As part my assignments I have worked on Implementation, Global Implementation, Rollout, Upgrade, Support & enhancement projects.
• Extensively worked on business blue print, requirements analysis, architecture - designing, development, configuration, Functional Studies, Quality Reviews and Testing, End user .
• Worked in 4 end to end life cycle implementation of SAP BW/BI Projects.
• Expert level knowledge and working since 11 years in SAP BW/BI data warehousing applications (3.0B, 3.1C, 3.5,7.0, 7.3 versions)
• Strong experience in Extraction,Data Modeling, Reporting, and Performance tuning.
• Strong experience in Design, development, Deployment, testing, Support, End user and Documentation.
• Experience in building architecture for Complex business Solutions.
• Experience in creating Info Cubes, DSO objects, MultiProvider, Infoset, Info Objects, Transformations, Info Sources, Communication Structures, Transfer Structures, Transfer Rules, Update Rules.
• Expert level work experience in Installation of Business Content objects, Generic, LO and flat file extractors.
• Experience in Business Objects (BOBJ)Tools in various versions - BO XI 3.1, BOBJ 4.0, environment.
• Experience in installing BOBJ Integration Kit with SAP BI and defining Single Sign on with Business Objects 3.0.
• Experience in BOBJ in creating Universe, Web Intelligence reports, Dashboards.
• Defined security models with folder/row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
• Experience in BEx Reporting, BEx Browser, Report to Report Interface (RRI), WAD and Dashboards.
• Expert in Requirement gathering, Workshop preparations, Develop Project plans, Support plans, cut over plans, creating Functional Specs, Technical Specs and End User Manuals.
• Worked across business modules like Logistcis(SD, MM, PP, QM,PM), FICO, COPA and HR.Do possess business Knowledge in functional areas such as SD, MM and LE.
• Proposed and recommended reporting applications to reduce the cost to the organizations.
• Experienced in interaction with Business, Power users, to decide the High and Low Level Designs.
• Worked on Request for proposols as solution team and panel team in sharing estimation and presenting technically to the client.
• Knowledge in SAP HANA 1.0 SP7, create schema using SQL scripts, SLT extraction, Data provisioning concepts using SLT, DXC,Table import, Reporting on BO.
• Contributed in preparing standard BI/BOestimation template for SAP BI Analytics practice Cognizant.
• Conducted Knowledge sharing sessions for SAP analytics practice across South India
• Project Management and Team leadership experience.

PROFESSIONAL EXPERIENCE:

Confidential (East Hanover/NewJersey)

IT SPOC/Rollin Manager

Responsibilities:

• Worked with all levels of business users for 17 countries in ASPA region for Integrated Business Intelligence Consolidation of source systems and Rollin & security setup and development of interface reports.
• Worked on translating KPIs and business needs into technical terms them into Blueprint.
• Worked on defining the Metadata Import process and defining architecture for complex data model.
• Prepared detailed work breakdown structures and shared accountability for achieving project milestones.
• Created Schemas, managed Schema Mapping, Validated Information-models compared Object Versions.
• Designed robust and flexible data model using Info cubes, DSO, Multi-providers.
• Developed BI approach and strategy document
• Generation of Data sources in R/3, flat file sources, Transfer Master Data to Characteristics and Transaction data from R/3 systems to Info Cubes in BW.
• Designed info sets for Master Data reporting.
• Worked on the automation of data loads through Process chains.
• Conducted BI reporting (BEx, BO/WEBI) features workshop with business usersand developed reporting requirements framework.
• Worked on Peer review Analysis in harmonizing Bex queries to Master Bex queries,
• Worked with Functional team to identify the intersection areas across different modules for different countries in rollout aspects and aligned with business.
• Ensured integrity is maintained by taking a best practice approach to development and implementation of Production change to support additional capability.
• Mitigated risk factors through careful analysis of financial and statistical data. Anticipated and managed change effectively in evolving global business environments.
• Defined processes and tools best suited to each project. Proposed approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and WBS.
• Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
• Coordinated with Business users and vendors in bridging the existing security setup and enhance with additional new roles/profiles.
• Articulated project goals, scope and worked closely with Business executives, IT team, vendors, development team in operating the Rollin project and delivered successfully without any major tickets/incidents after live.
• Worked for Documentation review and approvals with business and update in Solution Manager.
• Completely owned the responsibility for all consolidation of source systems, security related deliveries, interface solution, status updates to business and to client periodically.
• Involved in all decision making and facilitated project delivery and deployment schedules.

Confidential (New York/New York)

BI Lead (Onsite)

Responsibilities:

• Worked in Functional Upgrade migrating the old 3.x flow to BI 7.0 flow for Finance stream and logistics stream.
• Maintained complete back up for all TR/UR routine before the migration process starts.
• Migrated Update rule and transfer rule in First Level data target.
• Migrated Data sources with “With Export” option for safe retrieval.
• Created relational aggregates for the info cubes.
• Created new Data Transfer Process (DTP), Verify the new Transformation (code check)
• Unit tested the new data flow by triggering info package and DTP
• Migration of Update rules and transfer rules in second Level data targets.
• Verify the new Transformation between first level and second level targets (code check)
• Estimated data volume for BW.
• Extracted data, initialized delta for uploading of transaction data from R/3 systems by V3 updates. For Phase 2 logistics modules.
• Deactivated the old flow by deleting the update rule. (transfer rule will be deleted when data source is migrated.
• Worked on modification of process chain with new flow. i.e. adding DTPs
• Prepared Pre-Upgrade, Post-Upgrade activities list from BI point of view
• Consolidated reports from Europe to Asia Pacific region to create a Global template.
• Was responsible for the complete Peer review of Unit testing, System testing, SDS documents.
• Created Webi Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Created BOBJ Webi reports using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, and Merge Dimensions.
• Developed proof of concept for accessing Webi Reports and Xcelsius dashboards from Mobile Devices
• Created Test Script and UAT scripts and validated the reports.
• Worked in Transports across landscapes related to Migration.
• Worked in aanalysis and harmonizing Bex queries to Master Bex queries, building Universes, Webi reports.
• Coordinated with Offshore and cascaded the right information to drive the project on schedule.
• Responsible for all BW related deliveries and status update to clients on regular intervals.
• Involved in planning support activities, monitoring chains, Defining SLA and preparation of User manual to Infrastructure team.
• Worked on issues and risks mitigation with client PMO team.

Confidential

Project Manager (Offshore)

Responsibilities:

• Lead the overall SAP BW/BoBJ engagement in onsite/offshore capacity.
• Manage client expectation and status reportingand identified new opportunities for growth - Mobility, interface, and business process consolidation.
• Worked on estimations, costing and profitability metrics and customer expectation.
• Mentored and coordinated offshore/onsite team on regular intervals to ensure delivery on schedule.
• Created RCA, Defect Prevention plan, project metrics, project management report periodically
• Worked with Onsite PM in finalizing the forecasted pipe line projects with business.
• Implemented HOV RHGB Project and handled After-Care support successfully.
• Managed resourcing part, audit, costing and handled team size of 19.
• Worked in Defining architecture for ProFire 4 and ProFIRE VIA projects.
• History Data movement from Initial year to Data mart layer and loading huge volumes with in data mart layer and reconciling the data with Current & History DSO's.
• Handled different projects deliverables ProFire 4,ProFIRE VIA, Man rap, HR reverse Engineering for Confidential Netherlands simultaneously.
• Worked on Defining Data flows from OS 390 system to SAP BI.
• Extensively took part in Change request in terms of technical estimations, managerial aspects.
• Designing new architecture for process improvement and followed best practices.
• Worked on data extraction from OS 390 system to BI system. Worked on debugging Selection validation, Master data check programs and defined the flow from OS 390 to SAP BI environment.
• Captured data from Webdynpro (Front end) and automated to flow to SAP BI DSOs
• Interacted with Onsite Contract Company and onsite coordinators on regular/adhoc basis in keeping the Project in Track.
• Involved in all the decision making meetings in resourcing, planning, Costing.
• Single point of contact for the RHGB project, ProFIRE-4, ProFIRE-VIA and all maintenance CRs.
• Maintained all project related documents with changes in versions in client share path.
• Responsible for all BW related deliveries and status update to onsite counterpart.

Confidential

SAP GBI Lead (Offshore)

Responsibilities:

• Coordinating for the regular support activities with onsite.
• Involved in solving high prioritized tickets regarding extraction and loads failures.
• Maintained and decreased incidents/tickets ratio gradually and managed project in steady state.
• Involved in 24x7 Production Support.
• Prepared casual and root cause analysis document for load failures and incidents
• Daily trouble shooting of Incidents, Implementing changes, requests and its estimations.
• Involved in submitting the Ticket Status (open/close) report.
• Maintained work history for all the Tickets until it is closed down.
• Maintained and Monitored periodic data loads and clean-up activities.
• Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multiproviders, Info Sources, Data Sources, and Info Packages.
• Designed new architecture for process improvement. Maintained document version for all changes and resolution.
• Worked on Knowledge Acquisition, Offshore Knowledge transition, Play back sessions.
• Worked on background Job Maintenance (Monitoring logs, Scheduling, Cancelling long running jobs.
• Checking and deleting old lock entries.
• Involved in Creation of process Chains, Coordination and communication with the onsite team.
• Involved in both the activities monitoring of back ground jobs and Production Support.
• Involved in maintaining documentation for all the Support Activities.
• Actively involved in rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Involved in gathering requirements for new query developments.
• Prepared the SLA document for production support for various activities.
• Created Test Script and UAT scripts and validated the reports.

Confidential

BI Lead

Responsibilities:

• Involved in requirement gathering, Blue printing, Architecture analysis, design, development, testing.
• Conducted Gap Analysis and gathered end user business requirement for all rollouts in the Global Implementation.
• Developed Business Blueprint, Defined architecture abstract layer and harmonization layer, Configuration Document and Technical Specifications.
• Prepared strategy documents like Performance tuning, Unit of measure, Multiple time zone, Transport strategy, Presentation Layer strategy, Data reconciliation strategy, Data load Monitoring strategy.
• Data modeled using BW Extended Star Schema as per the Business requirement. Created standard cubes and customized cubes and DSO’s according to the requirement.
• Created abstract layer and harmonization layer as per the best practice for Global implementation.
• Configured R/3 Extraction for the LO cockpit structures for purchasing & sales modules. Created generic data sources for R/3 custom tables as per client’s needs.
• Installed and activated business content objects such as Info Cubes, Data Store Objects, Queries, and Transformation.
• Installed and facilitated Enhancement pack- 3 for FI and CO module which brings new additional data sources like GL transaction figures, Plan line items, Product costing analysis, Cost Component split etc.
• Installed Integration Kit - server and client level for establishing BO environment with Basis team, Configured Single sign on with SAP BI and BO.
• Created Bex Master query, BO Universe and WebI reports
• Identified Roles and Authorization with security team in finalizing the security relevant information.
• Transported various objects across the system landscape.
• Performed Functional Unit testing and data reconciliation for PTP and FI reports, along with the functional consultant.
• Process Chains were created for Transaction Data, Master Data (Attribute, Text and Hierarchy) for different data flows across all modules.
• Handled all the transports related to BI Organized and Conducted various for EMEA leads.
• Responsible for all BI related deliveries and status update.

Confidential

BI Lead

Responsibilities:

• Involved in all phases of a Project life cycle including analysis analysis, design, development, testing, and deployment of solutions.
• Conducted Gap Analysis and gathered end user business requirement for all modules.
• Developed Business Blueprint, Configuration Document and Technical Specifications.
• Data modeled using BW Extended Star Schema as per the Business requirement. Created standard cubes and customized cubes and DSO’s according to the requirement.
• Evaluated existing data volume and data growth, based on the statistics developed data model.
• Worked on fine tuning the performance by creating aggregates based on BW statistics, volume of master data in ECC, created Info Cube partitions and data compression.
• Enhancement done in R/3 using user exit in CMOD component-include program and designed the corresponding info objects in BW.
• Installed and activated business content objects such as Info Cubes, Data Store Objects, Queries, and Transformation Rules etc for SD and LE modules.
• Worked on filling up of setup tables for LO extraction.
• Extracted data from ECC, initialized delta for uploading of transaction data from R/3 systems by V3 updates
• Worked on delta disabled FI and COPA data sources and modelled architecture in effective way to manage huge volume of data and relevant full load.
• Developed BEx Report, Workbooks and Web Based Queries for various modules.
• Designed Web templates and Dashboards for CEO level reporting.
• Identified Roles and Authorization for various queries.
• Transported various objects across the system landscape.
• Performed Unit test and data reconciliation for LE module, along with the functional consultant.
• Created end user and power user manuals, LLD’s, HLD’S and support documents.
• Worked on LE module and created on time delivery dashboards to customers using info views in enterprise portal.

Confidential (Newyork /Newyork)

SAP BW Consultant

Responsibilities:

• Performed design, development and implementation of customized Info Cubes and ODS Objects for SD Module.
• Created Info Objects, Info Sources, Info Packages, Info Cubes, and to load Transactional Data from SAP R/3 System into SAP BW System using Initial and Delta loads.
• Worked extensively on LO extractors. Loaded the data from R/3 to BW and used Initializations with delta update methods.
• Enhancement done in R/3 using user exit and designed the corresponding info objects in BW.
• Involved with performance tuning of Queries by maintaining aggregates, compression, partitioning of Info cubes.
• Uploaded Transaction data from R/3, Analyzed info cubes created and maintained aggregates to improve the performance.
• Used Delta update mechanism for uploading the data to BW from R/3 in specific intervals.
• Created process chains for various data flow objects for all the modules.
• Created end user manual and support document
• Analyzed the optimized way for performance tuning in data loading and reporting.
• Created Aggregates and line item dimension for Performance tuning.
• Generated reports for calculating Price Variance Analysis (G/L), Quarterly wise Comparison, Top 50 customers list based on PV-Analysis for which KPI is defined.
• Transported objects in sequence to ensure objects consistency across landscape.

Confidential (Burnsville /Minnesota)

Team Member

Responsibilities:

• Involved in different phases of a project Rollout life cycle including analysis, Enhancements, development, and post-production support/maintenance functions.
• Modified business requirement documents, Technical design documents..
• Installed and activated business content objects such as Info cubes, ODS, Queries, Transfer Rules and Update rules.
• Designed Standard and customized Info Cubes and ODS objects for SD and CRM modules.
• Involved in monitoring daily,monthly loads of master, transaction data using process chain.
• Extensively used BEx analyzer, Query designer to create queries with Variables, Filters and Conditions
• Created Multiprovider Queries based on the basic cubes query for better query administration and performance.
• Involved in transporting the objects across system landscape using standard and BEx transport.
• Involved in Remodeling the BW system.

Confidential (Austin/Texas)

Team Member

Responsibilities:

• Worked in 24x7 environment, fixing high priority and business critical issues,monitored and involved to provide optimize solution
• Understanding Inbound and Outbound Interfaces.
• Worked on Unix scripts which will capture BW data and sent to third party systems
• Data load Monitoring via Console. Batch Monitoring, Batch jobs (Process Chains)
• Worked on regular house-keeping Jobs,Analyzed Tickets, abends jobs.
• Modified business requirement documents, Technical design documents..
• Involved in monitoring daily,monthly loads of master, transaction and data using process chain.
• Worked on BEx analyzer, Query designer to create queries with Variables, Filters and Conditions, formulas, structures and cell restrictions.
• Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and source system.
• Solved problems encountered during the processes using OSS notes..

Confidential (Dallas /Texas)

Team Member

Responsibilities:

• Involves in solving high prioritized tickets regarding extraction and also loads failures.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Verify and validate the data in SAP R/3 and SAP BW after the data loads.
• Maintaining the work history for all the tickets until it closed down.
• Created an Interactive reports for displaying vendor information.