Bi Technical Lead Resume
5.00/5 (Submit Your Rating)
San Francisco, CA
EXECUTIVE SUMMARY:
- Expertise in SAP BW different versions (3.x, 7.x) in various Implementation,Enhancements and Technical Support projects.
- Worked on ABAP routines (Start, End and Expert routine) in modeling of BW data flows.
- Experience in BOBJ tools (WEBI, BO Explorer) and Tableau.
- Actively partcipated in all phases of project, which requires in Requirement Gathering, Fit - gap Analysis, Design and development, Testing, Troubleshooting and Performance Tuning.
- Managed cross geographical team and supported on resolving critical issues.
- Actively involved in Global data load Monitoring (acoross regions) using Process Chains and external scheduler (control- M).
- Prepare various status reports (Weekly, Monthly) and share with key users and stake holders.
- Involved in contineous improvement plan for the existing BW systems.
- Experince in BW audit and compliance.
- Expertise in HANA modeling Experience in creating Attribute views, analytical views and calculation views.
- Experince in HANA backend components like,composite providers, open ODS views, Advanced DSO.
- Experience in various ECC/BW upgrade projects (ECC EHP upgrade, Bex, BW 3.x to 7.x, BW on Hana)
- Good experiences in Data Wrehousing and ETL processes.
- Strong experience in SAP BW technical and functional knowledge in the area of Finance, Sales & Dstribution, Material Management,CRM, Supply Chain Mgt and Production Planning.
- Excellent as a team member, work independently and ability to adopt new technologies and environments.
- Managed hiring process by interviewing candidates for open positions in the project.
- Experience in estimation of Time lines, Resource allocation for SAP BI projects.
PROFESSIONAL EXPERIENCE:
Confidential, San Francisco, CA
BI Technical Lead
Responsibilities:
- Responsible for generating requirements from business and Functional consultant and performed gap analysis.
- Prepared high level and technical documents, participate in joint technical design session to get the design approval.
- Provided detailed estimates for design and development activities.
- Handled weekly CAB calls and successfully moved approved CR’s to production.
- Involved in Process/Quality audit compliances in the project.
- Developed ECC Extractors, DSO’s and Open Hubs to extract data from ECC to BW system.
- Co-ordinated with BODS team to develop batch jobs which is extracting flat files to external systems.
- Sending out various status reports to key users and stake holders.
- Co-ordinate with offshore team and deliver the solutions on time.
- Preparation of the SOP’s (Standard Operating Procedures/Manuals) for the newly developed interfaces and reports.
Confidential, Neenah, WI
NA BW Technical Lead
Responsibilities:
- Responsible for generating requirements from business and Functional consultant and performed gap analysis.
- Worked on the change order, enhancement requests as per the business requirement.
- Managed all the Incidents/Requests/Change orders raised by the business users as per the SLA standards.
- Implemented and developed various scenarios in SAP BW and Enterprise HANA system related to modeling (Creating Attribute views, Analytical views and Calculation View), Data provisioning (Thru SAP SLT method).
- Transfer data from different source systems to HANA using SLT and SAP Data Services tools.
- Responsible for 24*7 Production support and enhancement tasks.
- Supervising and guiding the team for resolution of open issues.
- Involved in Process/Quality audit compliances in the project.
- Leading EHP upgrade projects and Involved in BW-Hana migration strategy.
- Responsible for periodically review the process and address any issues or risks and coordinate with the project team to resolve the issues.
- Performance optimization of existing BW objects in terms of data load performance.
- Performed many systems outages without any failure.
- Sending out various status reports to key users and stake holders.
- Involved in mentoring and guiding both client development team and off shore team for successful delivery of work.
- Preparation of the SOP’s (Standard Operating Procedures/Manuals) for the newly developed interfaces and reports.
Confidential, Bolingbrook, Illinois
Sr. BW/Hana Consultant
Responsibilities:
- Interacted with the business and functional team to gather business requirements and created functional and technical specification.
- Performed GAP analysis and designed data flow model on SAP BW 7.3 Hana System and Business Objects 4.1.
- Designed various reports in the area of Sales, Inventory and Purchasing.
- Created HANA-optimized Data Store Object and Info Cube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes
- Developed BW data models, inbound workflows to load from BODS to BW, Created process chains and prepared AID document.
- Developed some of the reports like Demand and Newness, SKU Outlier and Trend reports.
- Managed team, coordinate with various project teams and assign tasks to offshore team and ensure successful completion of the project.
- Prepared various status reports and present to the client stake holders and project management team.
- Performed Unit test, review of deliverables and assist business team during UAT.
Confidential, New Jersey
Sr, BW Consultant
Responsibilities:
- Interacted with the business users to gather requirements and created high level specification.
- Performed Fit and GAP analysis documentation based on requirements, created design spec.
- Designed various reports in the area of Order to Cash (O2C), D2S (Demand to Supply) and S2P (Source to Pay)
- Developed various reports like ‘Customer Punctuality, ‘First Time Order’ and ‘Open Order’ Reports in the area of O2C and D2S,
- Developed end to end data model for ‘Inventory projection’ Report’.
- Coordinated with offshore team for smooth delivery of the objects.
- Created data flow design and reports for BW and APO systems.
- Developed various process chains to automate the load process between APO and BW.
- Developed ABAP programs using start, end and field level routines to satisfy the business logic.
- Experience in Building and enhancing BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.
- Worked on Query Design including Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions, and Variables. Involved in modifying various queries.
- Performed Unit testing and assist business users during UAT.
- Monitored the projects and proactively identified potential issues and worked on contingency plans.
- Managed handover process to support team by conducting Knowledge transfer process.
Confidential
BI/BW Lead
Responsibilities:
- Involved in managing offshore team based out in India.
- Understand requirements, drive preparation of specifications.
- Define Project road map, project stages to successfully manage the project in Liaison with stake holders and higher management.
- Lead analysis of the existing source system and technical environment.
- Monitoring and guiding team members in technical development of their respective deliverables on day to day basis.
- Work on to resolve any conflicts in the team and come up with solution approach for problems found.
- Provide project status reports and dashboards with progress, efforts and deviations to PMO’s and stake holders.
- Conduct effort estimation and resourcing estimation of the project based on the approved budget.
- Design and Enhance the GBI BW objects for Chengdu, Pacific and Germany source system integration.
- Develop testing strategy and implementation plan.
- Responsible for setting individual goals and do the performance evaluation of the associates supervised by me at the end of the year.
- Manage for approving leaves, expenses, and time sheets for the associates reporting to me.
Confidential
Senior SAP BI/BOBJ Consultant
Responsibilities:
- Lead workshop to gather and consolidate reporting requirement.
- I was technical lead for design and implementation of SAP BW for the module Order to Cash, Plant Maintenance and SRM.
- As the onsite BI team lead, involve in coordinates with offshore team for technical delivery.
- Assign work to the offshore team and perform review and quality check before delivery.
- Responsible for configuration of Business Contents across work streams in the SAP modules
- (PP, PM, QM, SD, SRM).
- Define Project Guidelines and develop detailed Project Plan for successfully execution the project.
- Worked with functional consultant for requirement gathering and mapping the source data (R3/non-R3) to target in BI.
- Defect analysis and resolution of the BOBJ and BI issues during the UAT/Production phases.
- Preparation of business data flows and does functional and technical feasibility analysis.
- Configuration of BI System by identifying/Creating the Info Objects, Info Sources, Info Cubes, DSOs, DTPs and other Business Contents and customized objects.
- Development of data model to satisfy the various functional requirements by implementing queries and cubes using business content. Purchasing data, Demand Planning, SNP data, Sales Overview and Vendor Evaluation.
- Worked with the users for defining the reporting needs and helped design/develop flexible queries and reports using BEX reporting features like variables, exception and conditions. Created SAP BI reports which include Plan/Actual revenue comparison.
- Process chain maintenance, and job maintenance and rectifying load errors if any.
- Sending out various status reports to key users and stake holders of client.
- Addressed Ticket resolution and needs of end users.
- Knowledge Transfer for new enhancements and functional requirements.
- Preparation of the SOPs (Standard Operating Procedures/Manuals) for the newly developed interfaces.
- Involve in preparation of handover document, manuals and end users .
- Responsible for hiring and firing of the team members based on their performance and conduct.
Confidential
Software Engineer
Responsibilities:
- Understanding of the High-level functional document and prepared the technical document.
- Developed mappings/sessions using Informatica power center for data loading.
- Developed mapping to load the data in slowly changing dimensions.
- Involved in Test case preparation and unit testing and assist users during UAT.
- Prepared Design and Production support documentation.
- Top Innovator at Cognizant
- Top Performer of the Month at Cognizant
- Received Client Apprecitaion in IBM.
- ed “ of s” in Wipro.
