Candidates About

 

Arunkumar Venkat Tummalapalli

Objective

Seeking a challenging position of SAP Business Intelligence Administrator/ Architect

Summary

·         17+ years of experience in designing, developing, deploying, configuring, maintaining and Administering SAP Business Intelligence, SAP Data Services environments 4.2, 4.1, 4.0, 3.1, XI R2, R1, 6.5, 5.0 Web Intelligence, Crystal Reports, and Crystal Enterprise

·         12+ years of experience in leading teams, projects, solution design, project coordination and delegation and achieving results in a timely fashion

·         4+ years of experience using SAP Lumira, Predictive analysis, Lumira Server, Design Studio, Tableau, Dashboard builder

·         6 months of experience working with SAP Lumira Discovery, SAP Lumira Designer

·         Very strong experience in providing end to end enterprise wide reporting solutions for data marts, data warehouse, relational databases and other applications

·         Excellent People-facing, presentation, management, leadership skills and ability to formulate a clear vision and strategy for the organization 

·         Self-motivated with ability to multi task, perform under pressure in a fast-paced environment, prioritize work

·         Strong sense of ownership and willingness to take responsibility/accountability, creative thinker, team motivator with good negotiation and organizational skills

·         Excellent problem-solving skill and ability to adapt to shifting priorities and align activities and priorities to meet organizational goals

·         4 years of experience maintaining, configuring, patching, developing content, setting security and administering SAP HANA database

·         Proficient in installation, configuration, administration, tuning, backup and maintenance of Business Objects/ SAP BI Enterprise servers, HANA, SQL Server, Oracle and Access databases

·         Participated in all phases of the application development life cycle including analysis, architecture, design, prototyping, development, testing, performance tuning and deployment

·         Very strong business analysis and analytical skills with ability to understand business logic and requirements to develop detailed technical design documents and POC models

·         Proficient in training business users and developing project documentation, training material and product guides

     

Professional Experience

 

May 2015 – till date

Principal SAP Business Intelligence Administrator/ Architect, Xifin, San Diego, CA 

·         Aligned staff per skill set and experience to support the project work, monitored staff performance by rewarding positive behaviors and addressed negative behaviors accordingly.

·         Supervised work of others, including planning, assigning, scheduling and reviewing work, ensured quality, and Maximized efficiency of assigned project team members through strong leadership, organizational and motivational skills. Mediated and resolved project team conflicts.

·         Utilized creativity and resourcefulness in identifying and implementing team-building techniques.

·         Installed and configured SAP Lumira server, Lumira Desktop, Predictive analytics

·         Upgraded/ applied Lumira 2.x patches to BIP, migrated SAP Lumira Lums to Lumx files.

·         Utilized SAP Lumira Discovery, SAP Lumira Design Studio, built SAP Lumira Storyboard and Data Visualizations, utilized data from Universes, Hana, Excel data sources, uploaded to BIP, shared with business users, set security.

·         Created hierarchies, measures, enhanced with illustrations, worked with multiple data sets.

·         Massaged data, blended data, added charts, filtered data in visualizations, stories.

·         Utilized geomaps, conditionally formatted. Published documents to Lumira server, HANA.

·         Worked with Business Users, upgraded, enhanced and modified data Visualizations and distributed via Enterprise.

·         Performed Environment analysis of SAP BI, DS Servers for enterprise wide Reporting, ETL, and fixed issues, suggested, implemented best practices, augmented team, helped reporting, data mining teams meet their deadlines

·         Analyzed existing SAP landscape, BI content, performed BI system sizing, hardware sizing, worked with Network operations, hardware vendors, application owners, content owners, Business users and prepared Business Intelligence upgrade plan as a SAP Business Objects Administrator

·         Hands on experience as a Primary Business Objects Administrator in upgrading SAP BI from Version 4.0 to 4.1, 4.1 to 4.2 version, Installed, Configured and setup Business Intelligence Servers, setup security groups, migrated content between environments, suggested and introduced Process improvement best practices

·         Utilized Promotion management tool, life cycle manager, migrated Crystal reports, Webi Intelligence documents, Universes, Connections and other BI content, ATL files and VM tools and migrated content

·         Performed weekly code deployment, utilized multitenancy and deployed BI content to multiple customers located geographically in different cities with very complicated security requirements

·         Configured BI, DI cluster, load balanced systems, setup probes and monitored system performance

·         Utilized monitoring tools and setup alerts and probes and watched for system critical events

·         Setup and configured SAP Business Intelligence SSO for users to auto logon

·         Designed and developed application level and profile level security for BI content, setup and configured open doc, integrated BI into company portal

·         Designed, defined and implemented SAP BI mobile, SAP Business Objects Explorer Mobile,

Setup document retention policy and restrictions

·         Version controlled BI, DI content, database code, also utilized central repository, star team for managing code

·         Performed system backups, maintained system health, performed regular system health checks

·         Planned, implemented, installed and upgraded SAP Data Services version 4.1 to 4.2

·         Deployed application and web tier components, configured application server, troubleshoot system issues, worked with SAP support, users, DBA’s and other teams

·         Customized BI Launch Pad web page, set default user landing pages branded BI content

·         Monitored BI scheduled report jobs, data extracts, fine-tuned processes, troubleshoot BI and DS Servers issues

·         Supported Business Intelligence and Data Services Servers, provided support to users located geographically in different countries and continents

·         Managed and monitored Data Services environment, setup server groups, configured Job Servers, setup batch jobs, configured repositories, setup security

·         Monitored system for errors, collected trace files and performed root cause analysis

·         Designed, build and setup SAP HANA databases, security, users, built analytic, attribute, calculation views

·         Fine-tuned SAP HANA landscape, performed system maintenance, backed up systems, planned and applied Service pack stack 08 upgraded HANA databases

·         Performed regular system auditing, looked for anomalies, usage, load, maintained licensing and compliance

·         Performed project management activities, managed key aspects of project, implemented the projects and delivered BI/ DS solutions in a timely manner

·         Worked with various team members across different departments both internal and external customers, partnered effectively with the business departmental leads

·         Provided expert guidance on Business Intelligence (BI) technologies and helped junior team members

·         Lead data governance strategy and ensured policy adherence, developed scalable and maintainable BI applications to meet business objectives.

·         Addressed customer queries and issues in a timely manner, worked effectively with virtual teams both off-shore and onshore, listened to and communicated effectively with business leaders, end users and technical teams.

·         Developed reporting and analytics business team capabilities, strategy and roadmap. Motivated team members, resolved issues.

·         Facilitated meeting with various teams for defining reporting and analytics business requirements, Worked towards a companywide acceptable Business Intelligence release strategy.

·         Performed root cause analysis work, troubleshoot issues, applied fixes and work around, helped stabilize BO environments

·         Developed complicated universes, fixed existing universes, utilized Information design tool and Universe Design tool, rich client, built Web Intelligence reports, Lumira stories, Explorer Info spaces.

·         Worked with members from multiple teams, DBA’s, UI developers, data modelers, participated in design review meetings and worked on troubleshooting data mart issues

·         Provided production support, created Adhoc reports, Conducted WebEx sessions with the business teams, discussed and trained users.

 

Environment: SAP Business Intelligence 4.2, 4.1, Universe Designer, Information Designer, Webi, Sap Explorer, Web Intelligence Rich Client, BI Launchpad, SAP Data Services 4.2/ 4.1, Crystal Reports 2013, SAP Information Steward, SAP HANA 1.0 SPS08, SAP Lumira Server, SAP Lumira Desktop 1.25, SAP Lumira 2.0, SAP Lumira Discovery, SAP Lumira Designer, SAP Lumira Design Studio, SAP Predictive Analytics, Python 3.6, Tableau 8.2, SQL Server 2012, T-SQL, Oracle 12c/ 11g, PL/ SQL, Splunk, Sales Force, Star Team                        

 

Jan 2015 – May 2015

Principal SAP Business Intelligence Lead Administrator/ Consultant,

Arbonne International, Irvine, CA 

·         Performed Environment analysis of SAP BI, DS Servers for enterprise wide Reporting, ETL, and fixed issues, suggested, implemented best practices, augmented team, helped reporting, data mining teams meet their deadlines

·         Created Project plan, resource plan, managed key aspects of project, implemented the project and successfully delivered Business Intelligence solutions in a timely manner

·         Worked with various team members across different departments both internal and external customers, partnered effectively with the business departmental leads

·         Provided expert guidance on Business Intelligence (BI) technologies and helped junior team members

·         Lead data governance strategy and ensured policy adherence, developed scalable and maintainable BI applications to meet business objectives.

·         Addressed customer queries and issues in a timely manner, worked effectively with virtual teams both off-shore and on, listened to and communicated effectively with business leaders, end users and technical teams.

·         Developed reporting and analytics business team capabilities, strategy and roadmap. Motivated team members, resolved issues.

·         Facilitated meeting with various teams for defining reporting and analytics business requirements, Worked towards a companywide acceptable Business Intelligence release strategy.

·         Drove the adoption of new business intelligence technologies and best practices within the team, conducted info and tool introduction sessions for new business users

·         Performed root cause analysis work, troubleshoot show stopper issues, suggested fixes and work around, helped stabilize BO environments

·         Installed, Configured and setup Business Intelligence Servers, setup security groups, migrated content between environments, suggested and introduced Process improvement best practices as a SAP Business Objects Administrator

·         Supported Business Intelligence and Data Services Servers, provided support to users located geographically in different countries

·         Monitored BI scheduled report jobs, data extracts, fine-tuned processes, troubleshoot BI and DS Servers issues

·         Developed complicated universes, fixed existing universes, built reports, storyboards with charts using SAP Lumira.

·         Coordinated with DBA, application developers, data modelers, participated in design review meetings and worked on troubleshooting data mart issues

·         Provided production support, created Adhoc reports, Conducted WebEx sessions with the business teams, discussed and trained users.

·         Built visualizations using SAP Lumira, Installed and configured SAP BI mobile. Setup and distributed BI content over mobile phones, iPad/ tablet devices.

 

Environment: SAP Business Intelligence 4.1, Universe Designer, Information Designer, Webi, Sap Explorer, Web Intelligence Rich Client, BI Launchpad, SAP Data Services 4.2/ 4.1, Crystal Reports 2013, SAP Information Steward, SAP Lumira Desktop 1.21, Business Objects Design Studio, SAP Predictive Analytics Tableau 8.2, SQL Server 2012/ 2008/ 2005, T-SQL, Oracle 11g, PL/ SQL                        

 

 

Apr 2011 – Dec 2014

Principal SAP BI Administrator/ Lead, Memorial Health Services, Fountain Valley, CA 

·         Designed, Analyzed and provided SAP BI landscape for enterprise wide Reporting, ETL, IMDB’s, statistical, data mining and decision science teams

·         Created Project plan, resource plan, managed key aspects of project, implemented the project and successfully delivered Business Intelligence solutions in a timely manner

·         Worked with various team members across different departments both internal and external customers, partnered effectively with the business departmental leads

·         Provided expert guidance on Business Intelligence (BI) skills and technologies

·         Lead data governance strategy and ensured policy adherence, developed scalable and maintainable BI applications to meet business objectives.

·         Addressed customer queries and issues in a timely manner, worked effectively with virtual teams both off-shore and on, listened to and communicated effectively with business leaders, end users and technical teams.

·         Developed reporting and analytics business team capabilities, strategy and roadmap. Motivated team members, resolved issues.

·         Facilitated meeting with various teams for defining reporting and analytics business requirements, Worked towards a companywide acceptable Business Intelligence technical architecture.

·         Drove the adoption of new business intelligence technologies and best practices within the team, conducted info and tool introduction sessions for new business users

·         Brought entire Memorial Health System, its associated clinics and other Pharmaceutical teams under one shared services BI Umbrella

·         Implemented process, planning and improvement methodologies, Report/content coding, migration and documentation standards

·         Implemented BI best practices, interacted with operational and technology management teams regarding security, reporting elements and integrity of source and data systems and repositories

·         Lead team of direct reports and pushed for excellence, insight, and improvements

·         Drove reporting and dashboard deliverables, new change requests and projects, followed agile methodology, communicated issues and project progress to management and customers.

·         Documented project status, provided accurate and timely reports of current and projected progress of all project tasks

·         Communicated effectively, built rapport with all project stakeholders and team members and instilled confidence in business users by consistently delivering high quality solutions and effective management

·         Show cased SAP suite of tools, conducted demo and training sessions, researched specific department needs, suggested and implemented applicable SAP tools

·         Performed Hardware sizing, worked with network team, hardware vendors and other team members

·         Analyzed, Planned, Performed, managed Business Objects Upgrade projects 3.1 to 4.0, 4.0 to 4.1 as a SAP Business Objects Administrator

·         Installed, Configured, setup SAP BI platform, tools such as Crystal Reports, Web Intelligence, Explorer, SAP Mobile, Live Office, Dashboards

·         Implemented SAP HANA IMDB. Configured SAP HANA database, applied patches, setup security

·         Performed HANA administration activities setup catalogs, packages, backups. Developed Analytic, Attribute and calculation views, utilized LCM

·         Installed, configured, setup Data visualization and predictive tools such as SAP Lumira Server, SAP Lumira Desktop, SAP Predictive Analytics

·         Developed and show cased Lumira stories to higher level management, built visualizations using Tableau.

·         Installed and configured and maintained SAP Information Steward, Metadata Management, Data Insight and other EIM suite of tools

·         Installed, configured and maintained SAP Data Services/ ETL tools. Setup security, repositories, managed and scheduled batch jobs, maintained Data Insight rules and Data quality jobs

·         Lead the team in defining enterprise wide KPI reports and provided inputs to upper level management

·         Served as a sub matter expert for BI core technologies by providing consulting services to other teams on request, audited work done by vendors and contractors, raised issues, got them fixed, organized peer review sessions. Established and enforced best practices and guidelines

·         Analyzed existing reporting artifacts and removed redundancy and promoted sharing of information across customer groups, decommissioned old legacy reporting systems and built efficient SAP BI content, Web intelligence, Crystal reports, Lumira Stories

·         Built Storyboards, built measures, charts, added data from multiple sources, geomaps using SAP Lumira, Business Objects Design Studio.

·         Collaborated with other developers, Architects, Data Modelers and DBA’s to optimize the data model for BO reporting tools

·         Participated in UAT conference status calls, answered user questions. Conducted user training sessions, developed training manuals. Fixed reporting defects raised by users

·         Conducted Universe review sessions, gathered user feedback, modified Universe to make it more user friendly, added commonly used filters as Universe predefined conditions.

·         Proactively monitored all BI environments for capacity and performance related issues and took necessary steps for their resolution and ensured application SLA’s are successfully met

·         Administered SAP BI environments, HANA servers, maintained security settings, added users, folders, applied latest service packs and hot fixes.

·         Migrated reports, universes, repository objects, folders, inboxes, users and settings from one environment utilized Import wizard, LCM, Promotion Management. Created repeatable backup jobs

·         Used Publishing wizard to upload Crystal reports in Bulk. Scheduled reports on BOE, maintained cascading prompts using Business Views Manager

·         Closely worked with Network Operations team regarding VM space issues, network, priority and hardware issues

·         Identified server, tool issues, worked with SAP technical support, participated in long Net viewer sessions, set server and tool trace files and worked towards resolution

Environment: SAP Business Intelligence 4.1, 4.0, 3.1, Universe Designer, Information Designer, Webi, Sap Explorer, Web Intelligence Rich Client, BI Launchpad, SAP Data Services 4.0, 3.1 Crystal Reports 2013, 2011, 2008, SAP Information Steward, SAP HANA 1.0 SPS07, SAP Lumira Server, SAP Lumira Desktop 1.19, SAP Predictive Analytics, Business Objects Design Studio, Tableau 8.2, SQL Server 2012/ 2008/ 2005, T-SQL, Oracle 11g, PL/ SQL                        

 

Oct 07 – Mar 2011

Sr. Business Objects Architect/ Lead, Insurance Company of West, San Diego, CA 

·         Collected requirements from both business users as well as non-business users communicated from developer to CEO, developed report template documents. Discussed details with SME’s, data modelers and developed requirements, technical design, table mapping and project scope documents

·         Lead team meetings, produced periodic status reports and updated plans, identified need for meetings of key project participants, facilitated team communication, participated in conflict resolution by building consensus

·         Worked with cross-functional teams to gather requirements, prioritized projects and made sure they aligned with overall business needs and IT goals

·         Worked closely with business units and provided direction, addressed business system challenges and suggested alternative solutions.

·         Took ownership of understanding the customer’s information needs from the Business and worked in all areas to develop innovative ways to deliver solutions

·         Ensured accuracy of delivered reports and conformity to SLA, analyzed data questions and issues as they arise, Worked with Business and Technology teams and proposed solutions and provided strategic direction

·         Worked with Business Teams and Technology teams and prioritized on-going BI demands

·         Lead the team in defining enterprise wide KPI reports and provided inputs to Chief of Actuary and other Directors in preparing their project roadmaps. Provided weekly project status reports, conducted JAD sessions

·         Provided guidance, leadership and support in design, development and deployment of complex reporting and data architectures for Enterprise data marts, data integration and aggregate table designs for reporting applications. Handled one off Adhoc reporting requests   

·         Implemented data quality programs, raised upstream source systems changes, user entry issues and legacy application data issues in data governance group meetings and minimized impact to downstream data marts and reporting systems. Made corresponding ETL code changes, Updated Universe metadata and participated in data obfuscation project

·         Developed Business Objects Universes, supported, updated and modified existing Universes. Set database limits and thresholds in the Universe, added hierarchies, utilized aggregate aware, created contexts

·         Developed Complex Business Objects web intelligence reports with BO Infoview, created Webi reports with multiple queries and multiple tab’s, utilized custom SQL where required

·         Optimized report execution time, developed complex queries, stored procedures for report generation using SQL server 2005, 2008 databases.

·         Developed metrics, analytics, dashboards, alerts, used dashboard manager, scheduler.

·         Performed Root Cause Analysis, found defects, logged defects, assigned them to developers and regularly monitored their status until they are retested and fixed

·         Developed Complex Crystal Reports XI using stored procedures, commands, sub reports, prompts, cascading prompts and uploaded to BOE. Used Crystal Xcelsius for charting

·         Demonstrated success in multi-team, multi-stakeholder, complex project environments. Used Crystal reports SDK and BOE and invoked reports from other web applications such as Java, ColdFusion with Crystal report viewers embedded into those applications presented detailed design documents to Architecture review board for approval

·         Added metadata to Universe objects, consulted with subject matter experts, data stewards for input and clarification

·         Designed aggregate tables, reporting tables based on data marts for building complex actuarial trending reports and triangles used for rate modeling, loaded data using SAP Data Services

·         Maintained Data Integrator code, made updates to Job’s and data flows as needed, monitored daily and monthly data loads, utilized management console and UC4 scheduler

·         Monitored all BI environments for performance and took necessary steps for their resolution and ensured application SLA’s are successfully met

·<span style="font:7pt 'Times New Roman