Data Support
Resume:
Murali
******.******@*****.***
SAP BI Consultant with 8+ years of experience with strong focus towards the implementation of Reporting solutions in SAP Technology Platform. Areas of expertise include technical and functional aspects of BI system, Systems Integration based on both SAP and Non-SAP systems. Strong and intensive application architecture, design and development experience with SAP and Java technologies.
Experienced in Utility, Financial Services, Retailing, Manufacturing, Energy, Technology, Oil and gas Industries.
Developed oral and written communication skills, with demonstrated ability to interface with all levels and across organizational presentations to both technical and non – technical personnel.
Having very good technical skills, functional knowledge of SAP ECC application areas like SD, MM, FICO, SCM, APO and planning tools: BPS, IP.
Work closely with Business to gather BI/Reporting requirements.
Involved in 3 full cycle implementations, which includes Requirement gathering, Gap analysis, Blue printing, Development, Testing, Reporting, Go-Live and Post Go-Live support.
Good experience in end User Trainings.
Extensive experience in designing complex data models and enhancing SAP delivered data models
Designed and developed Infoproviders, Reports, Workbooks, Variables, Calculated / Restricted Key Figures, Structures.
Worked in query optimization, Data load time improvements and Debugging.
Performance Tuning – Evaluated statistical Performances and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates and partitioning.
Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
Expertise in gathering, analyzing, and documenting business requirements, functional requirements, and data specifications for Business Objects Universe and reports.
Designed and Linked Universe for query, reporting and analysis using the Designer Module.
Proven success in performing all reporting features, OLTP Extraction from R/3 into BI/BW using different extraction structures.
Configured and implemented BW reporting using BEx analyzer/ browser.
Performed Data Load management, Process Chain changes, Data source Enhancements, OLTP extraction data, Loading (Full /Delta upload) Monitoring and Data Mart.
Proven people skills including: mentoring, Coaching, and Performance Management.
Professional Experience:
Client: People’s United Bank, CT Duration: Jan ‘14 – Till Date
Responsibilities:
Working on migration of BI 7.3 to BI 7.4 HANA.
Modeling HANA views for BW 7.4 master data and transaction data.
Performed Data Modeling and developed Analytical Views for the transactional data, Attribute Views for the master data.
Knowledge on SAP BODS connectivity’s, extractions and loading in to HANA Database and BODS core functionalities like Jobs creation, data transfer methodologies and Repository managements.
Lead whole implementation of CRM Quotations, Opportunities, Activities, and Complaints.
Redesigned COPA model.
Redesign new model based on sales, Deliveries and Billing for existing reports having capability of HANA optimized.
Designed and developed Multicubes as per the business requirements, tested and reconciled the report data with the data sources.
Implemented APO – SNP Inventory, Production and Capacity reconciliation.
Worked on the different areas like APO DP, Order to Cash, Budget to Reporting, SRM, Procure to
pay areas based on the functional specifications.
Enhanced CRM Quotations, Opportunities, COPA, SD data sources.
Created generic data sources for COPA and Master Data Objects.
Developed program to calculate Inventory Revel value and Variance, and developed program to validate and copy previous months’ file data into current month.
Implemented BW BPC related cubes & DSO.
Worked on migrated related issues regarding workbooks, web templates and routines.
Converted update rules into Transformations and modified Routines.
Involved in migration 3.5 data sources inti BI 7.0.
Worked on migration of BI 7.0 to BI 7.3.
Client: Trowe, MD Duration: June ‘11 to Nov ’13
Responsibilities:
Worked on establishing Relational Database connectivity between HANA and Business Objects systems to make use of Views and universe.
Involved in gathering user requirements and data modeling using Extended Star Schema concepts.
Extensively worked on Trigger based and ETL replication methodologies.
Created several views (Attribute, Analytical & Calculation Views)
Implemented hierarchies to support drill down reports.
Worked on stored procedures to create calculation views.
Hands on experience on SQL scripting for creating Tables, Views, Procedures, and for data Modification.
Created HANA modelling scenarios and activities such as adding a system, creating schemas and content.
Models, Attributes, Measures and Hierarchies.
Proficient in SQL Debugging and Error Handling.
Created users assigned roles and privileges to the users.
SAP HANA data provisioning and using SAP LT Replication Server (SLT).
Created Hierarchies, worked on product hierarchy in MM module.
Generated MS excel reports through HANA MDx provider.
Created HANA modelling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
Client: University of Chicago, IL Duration: May ‘09 to Apr ’11
Responsibilities:
Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-Live and Post Go-Live support.
Extensively worked on SAP ECC as a source system for generating reports using BEx Query designer.
Report development on manufacturing modules like MM, PM, QM and integration experience with FICO.
Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries per Business Requirements.
Worked extensively on Data Modelling design like creating InfoObjects, InfoCubes, DSO, MultiProviders, InfoSources, InfoSets, Time Dependent master data and ETL activities like Extraction from Source System, Transformation rules, Data Transfer Process (DTP), Open Hub Services etc.
Activation of the Business Content for Plant Maintenance (PM), Purchasing (MM), Quality maintenance (QM), CO-PA and customizing them as per the client requirement.
Created many complex and customized reports for specific business requirements and involved in new features of SAP BI security like Analysis Authorization.
Analyzed and translated the client’s Business Requirements and Functional Specifications into technical specifications, data flow diagrams and data models.
Cooperated with the client’s process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
Build and enhanced BI objects that include InfoObjects, DataSources, Transformation, DTP, DSO, InfoCubes, MultiProviders, InfoSets and Open Hub.
Enhanced CO-PA and FI Cubes with additional necessary missing fields.
Worked on generic extractors to meet the reporting requirement.
Extracted data from the LO Cockpit from source system.
Maintained process chains to automate the schedule the data loads.
Integrated BO with SAP ECC and SAP BI 7.0 to build Universe.
Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
Hierarchies are implemented to support drill down reports.
Customized Queries using navigational attributes and filters in BEx analyzer and used customer exits as per client requirements.
Several Complex’s-cross tab reports and sub-reports are published using Crystal reports and Business Objects Reporter.
Designed report templates with BEx Analyzer and Web Analyzer using Key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.
XCelsius dashboards are created on top of crystal reports and live office.
Created HANA modelling scenarios and activities such as adding system, creating schemas and content models, attributes and measures, hierarchies.
Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views, Graphical and SQL script based).
Involved in working with content models, attributes and measures, hierarchies.
Monitoring and troubleshooting data loads.
Worked on RDS to implement ETL Replication and using rapid Marts for SAP road map.
Client: Fulcrum-GT Duration: Sept ‘08 – Apr ’09
Responsibilities:
Assist in the evaluation and development of tools, technology, processes and services to solve business and technical challenges.
Ability to work effectively in a complex matrix environment with virtual teams of high-level professionals.
Define, Develop and report weekly statics to support Service level agreements.
Managed resources globally of a team size of five.
Providing support on various queries related to PS module, providing solutions to clients in basic PS, setting, Work breakdown structure, Network, Internal Activity, External Activity, sub- Networks and Milestones.
Worked on the different areas like APO DP, Order to cash, Budget to Reporting, SRM, procure to pay areas based on the functional specifications.
Worked on the function modules and exits for data extraction and data source enhancements.
Used BADI’s and debugged the code extensively for fixing the errors and its modification. Worked on start routines and end routines for applying business logic, transformation mappings and update rules.
Worked on FI New GL extraction, reconciled GL delta and the P & L report with the source for the accuracy and tracing of net earnings.
Coordinating between the offshore and onsite workload issues and taking care of the issues and concerns of the client.
Working closely with users for day to day upcoming issues with the newly introduced products in demand planning area and its concerned development for its requirements in CRM area.
Responsible for implementing the new developments and the changes based on the estimate and working closely with the functional for its design and further developments.
Improved the system performance and worked closely with basis assisting them in applying the patch upgrade. Worked on the BIA(accelerator) for rollups and re - indexing of the data targets.
Working closely with the basis to resolving the issues in production and preformed testing at multiple levels for issues in production.
Client: State of Ohio, Ohio Duration: Feb ‘07 – July ’08
Responsibilities:
Worked in performance tuning of queries, built aggregates, indexes, performed rollup and compression of InfoCubes.
Designed and developed queries as per the business requirements, and tested various queries, reconciled the report data with the data sources.
Worked in upgrading the DSO’s and InfoCubes from BW 3.5 to BI 7.
Worked with transformations, Data Modelling, DataSources and routines updated the 3.x transfer rules to BI 7 transformations.
Worked closely with business users for gathering and analyzing requirements and developed technical specifications, coordinated with developers for the new developments.
Involved in various business operations and helped the organization to achieve cost – effective production with increased quality.
Involved in documenting the business process by identifying the requirements and involved in finding the system requirements.
Coordinated with business users functional and offshore team for the new developments, and trained end users.
Involved in user – training of SAP related to Business Process and was responsible for implementing the same. Also, took an active part in data modelling and business modelling.
Worked on the function modules and exits for data extraction and data source enhancements.
Worked on start routines and end routines for applying business logic transformation mappings and update rules.
Contact this candidate