Resume ofAMARJIT SINGH
Resume ofAMARJIT SINGH
SUMMARY OF QUALIFICATIONS:
- OverTENyears’ 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 performancetuning.
- 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 infoproviders such as Infoobjects, 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 BWdatasources 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 rulescreation, 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 BWend-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 Infoproviders & BEx queries to simulate/validate resultsachieved from Design Studio reports. Architected the Re-org of BW objects to maintain standards.
- Created Info objects, DSO’s, and Cubes & Multiproviders 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 KPIreport requirements.Managed, Configured and Performed Transports between multiple BW environments.
- Used RealTechTransport Manager to perform transports.Maintained Ztables in BW to load Masterdata.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 BExqueryclean-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, BenefitsPayroll 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 Architecturedocuments for the BW implementations with the naming standards.
- Recently implemented Bookings, BacklogBilling 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 BEXWEB Intelligencereports.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 Datasources from HR. Defined BEx queries as per the report requirement.Defined best practices on BW and BOdataservices 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 DeltaFull Datasources. 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 ‘11TransAlta
SAP BI/BW/BO ConsultantCalgary
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 CubesMultiproviders as per the data model. Defined several transformations as per the need.
- Assisted in configuringBOData Integrator as a Sourcesystem 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 KPIreport 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 RealTech 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 Managermulti-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 Infoqueriesleveraging businessrules 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. Trainingend 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.5Cognos 8.3/8.4 (Report Studio, Query Studio), Windows NT.
Jan ‘09 - Feb ‘10Clear Blue (IBM)
Senior BW/BI LeadParsippany 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 source2LIS_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 sensitivedata 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).