Candidates About

 

Siva Anjameti
SAP BW	F  Over 11 years of experience in administration and development of Business Analytics solutions using Data Warehousing and Reporting tools and techniques. F  Expert level skills in tools such as SAP BW, BODS and HANA used for Extraction, Transformation and Loading of data from numerous sources. F  Completed 5 End to End cycle SAP BW/BOBJ project implementations using ASAP methodologies. F  Built BEx reports and workbooks in BW using Query Designer and Analyzer.
BO Admin	F  Administered the business objects enterprise clustered servers and implemented changes to Scale-Out and Scale-Up the environment to optimize performance. F  Configured different types of authentication for BO environment such as Enterprise, SAP and Windows AD with seamless Single Sign On (SSO). F  Performed end to end administration including Planning, Sizing, Installation, Integration, Maintenance and Production Support to ensure high availability of BO 4.1 environment. F  Executed upgrades from BO XI 3.x to BI 4.x, as an administrator and developer. F  Implemented the use of troubleshooting techniques and tools available in the Business Objects enterprise such as Auditing, Logging, Monitoring, CMC, WebiAdmin and BI Platform Support.
BOBJ	F  Demonstrated the effectiveness and suitability of tools such as SAP Business Objects, Tableau and Power BI for Reports, Dashboards, Analysis Applications and Data discovery. F  Utilized the tools such as Universe Design Tool (UDT), Information Design Tool (IDT), WebI , Xcelcius, Dashboard and Crystal Reports to build insightful and interactive reports. F  Worked with relational databases such as Oracle, IBM DB2, SQL Server, Microsoft Access and OLAP data sources such as, SAP BW, HANA, and Microsoft SQL Server Analysis Services. F  Exercised advanced design techniques in building WebI, Crystal Reports and Dashboards. F  Formulated effective techniques to troubleshoot the report performance issues to identify the bottlenecks in connectivity, memory allocation, server configuration and report design. F  Designed analysis applications and dashboards using SAP Business Objects Design Studio and interactive charts and story boards using SAP Lumira.
Tableau	F  Installed Tableau Server and configured authentication and processes resource allocation. F  Defined and maintained sites, users, roles, extract schedules and subscriptions. F  Developed tableau worksheets, dashboards and intuitive story boards connected to CSV, relational databases and OLAP datasources via live connection or data extracts. F  Authored formulas with LOD expressions, calculations, Sets, Aliases and custom Hierarchies.
MS BI	F  Process Automation using SSIS utilizing the different components of Control Flow and Data Flow F  Deploy the Project in SQL Server and schedule jobs in SQL Server agent F  Configure Event handlers for error handling and to automate the notifications using SMTP tasks F  Designed Dashboards using Power BI connecting to SQL Server and SSAS cubes

HANA, BODS

F  Integrated enterprise data sources with HANA and BW with data flows in Business Objects Data Services (BODS), utilized Data Cleanse transforms and schedule the jobs to replicate data. F  Established and supported Data Provisioning techniques in HANA such as SAP Landscape Transformation (SLT), SAP BODS 4.0/4.1 and Direct Extractor Connection (DXC). F  Devised Schemas, Packages, Information models, Analytic Privileges and CE Functions. F  Built HANA attribute views, analytical views and calculation views and presented this data in advanced visualizations in Webi, Analysis, SAP Lumira and Design Studio.

Personal

F  Planning -Ensure to get a clear understanding of duties and contributions to the project to deliver the promised deliverables on time and without compromising the quality. F  Team Player - Always up for any help with a problem faced by a team mate and don't hesitate to seek help if got tied up, a different perspective always helps.  F  Quick Learner - Learn and exercise the use of new tools to evaluate benefits.

 

ASPIRATIONS

Excel in the emerging Business Intelligence and Big Data Analytics products working in multitude of business domains. Engage in every opportunity with full energy to work in diverse technologies and roles to ensure continuous learning in my IT career

 

Education

Bachelor of Technology in Mechanical Engineering from Sri Venkateswara University

 

PROFESSIONAL EXPERIENCE

 

 

Client: UCLA Health, CA                                  Mar 2016 – current (1 Year 6 Months)

Role: Business Intelligence Administrator

Environment:  BI 4.1 SP4, BI 4.2 SP3 (Central Management Console, Upgrade Management Tool, Promotion Management, Information Design Tool, Crystal Reports 2013, Web Intelligence), InfoBurst, InfoSol 360, Windows Server 2008 R2, SQL Server 2008, Oracle 11g, 12c (EPIC Clarity ETL), Power BI, Service Now, Tableau 9.1, 9.3, BODS 4.2, SQL Server Data tools for Visual Studio 2012, SQL server 2012, SSAS, SSRS

Responsibilities:

· Business Objects administration for day to day operations and maintenance

§ Monitored the BOBJ system, suggested and implement process improvements for high availability

§ Created alerts in BO monitoring to get notified via email based on change in server metrics

§ Creating a plan to upgrade the from 4.1 SP4 to 4.2 SP3

§ Administration of the BODS 4.2: Access, maintain Repositories and schedule ETL jobs

· Leveraged 360Eyes and 360View to simplify auditing and content management of BO landscape

§ Monitored and scheduled the execution of the 360Eyes jobs to extract CMS metadata

§ Used 360View to generate ad-hoc reports to review the content and version mismatches

· Created and maintained InfoBurst objects for report mass distribution

§ Created bursts and schedules to distribute report content based on dynamic parameters

§ Maintained the parameters in the Database tables to accommodate recipient and parameter changes

· Tableau implementation to enable Self Service analytics for different departments

§ Setup the Tableau server and configured Windows AD authentication

§ Tableau user and server administration, provisioning the permissions based on the AD Groups

§ Create batch scripts and schedule them to automate the daily and weekly tasks related to backups

§ Built Auditing dashboards for content and user permissions review in Tableau

· Introduced Power BI to the users of Crystal and Web Intelligence reports with sample use cases

§ Implemented dashboards and scorecards with power pivot for management converting analysis reports

§ Published reports and dashboards designed in Power BI utilizing Power BI services and shared it across through Microsoft Office 365

· Developed SSIS Packages and SSAS cubes to enable process automation and reporting performance

§ Automated manual file handling processes using SQL Server Integration Services and PowerShell Script

§ Created SSAS cubes on SQL Server Database tables and scheduled the refresh

 

Client: Owens Corning, OH                  Apr 2015– Feb 2016 (10 Months)

Role: SAP BI Lead/Administrator

 

Environment:  Windows Server 2008 R2, SAP BW 7.0, Project Management (JIRA), Tableau 9.1 (Tableau Sever administration; Tableau Desktop; Data Source, User and Site management), BO XI 3.1 SP4 (AIX server administration, InfoView, Central Management Console, Web Intelligence Rich Client), BI 4.1 SP5 Patch 4 (SAP Design Studio 1.5 Patch 0, Analysis for OLAP, Analysis for Office 1.4 SP11, SP12, SAP Lumira 1.28 - Server for BI integration, Central Management Console, Upgrade Management Tool, Promotion Management, Information Design Tool, Web Intelligence, WebiAdmin Tool), Power BI, Oracle 10g, SQL Server 2008, Microsoft Access 2007

Responsibilities:

· UNX Universe, and Web Intelligence report development for SQL Server 2008, MS Access 2007 data sources

· Use of JIRA for estimating, tracking, reporting on the agile project implementation

· Administration of Business Objects environment

§ Created watches, alerts on the server performance metrics to get notification on possible events of failure

§ Configured auditing database and created Webi reports to monitor the content usage and User activity

§ Configured BO Mobile by updating the MobileBIService and MOBIServer .war files, Categories in CMC

· Designed workbooks using Analysis for Office and trained BEx consumers to leverage advance features

§ Created workbooks by inserting BEx queries and BW InfoProviders.

§ Leveraged the different components available such as Crosstab, Charts and filters

§ Worked with an IP consultant to showcase use of Analysis for Office to enter Planning data on input enabled BEx queries.

· Created an Analysis application using Design Studio to showcase the user experience that can be achieved

§ Installed the BIP Server add-on for Design Studio and configured the APS to host the service

§ Created an analysis application with MTD and YTD Sales for Business Director review.

§ Used Geo Maps to show the trends of revenue distribution and Profit margins across the global market

§ Presented the capabilities of the Design Studio and identified an use case for building the dashboard.

§ Provided multiple analysis paths and selections with views at different granularity

§ Utilized the different methods and properties of the components to allow easy to use interactive features.

§ Published the dashboard to BO repository and provided access to the user through BI Launchpad

§ Demonstrated interoperability feature between Analysis for Office workbooks and Design Studio

· Dashboard development using Design Studio, Tableau and Lumira for evaluation and comparison

§ Installed the Lumira, Server for BI platform in the Business Objects server

§ Created visualizations and story boards using SAP Lumira Desktop and published to the BO repository

§ Installed the Tableau Server and configured local authentication.

§ Showcased the Tableau features and brainstormed the suitable use cases for implementation

§ Connected the Tableau to data sources such as SAP BW using MDX connection, SQL Server and CSV

§ Created dashboards and story boards to demonstrate the ease of creation and effective use of Tableau.

§ Presented a comparison of the tools in terms of ease of use, capabilities, content distribution options, data acquisition and performance with high volumes of data.

· Created dashboards using Microsoft Power BI to showcase the capabilities and user interactivity features

§ Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts

§ Utilized Power BI desktop to design dashboards and scorecards for actionable data insight.

§ Deployed reports and dashboards on the reports server; scheduled deployments with subscriptions.

· Business Objects upgrade from 3.1 to 4.1 SP5

§ Reviewed the current Business Objects environment XI 3.1 setup

§ Prepared the plan for the upgrade to the 4.1 SP5 documenting the timelines and process of execution

§ Worked with BI COE team to review the usage patterns of the system and reporting applications in use

§ Performed the sizing and install the 4.1 SP5 platform on the Windows 2008 R2 server

§ Configured Windows AD authentication and Single Sign On using Kerberos option

§ Implemented the best practices for upgrade process and server configuration and management

§ Created additional APS to distribute the services and memory based on the usage expected

§ Moved content with Upgrade Management Tool leveraging live to live and BIAR to live options

§ Security setup on the Folders, Universes and Connections in 4.1 system is replicated based on 3.1 system

§ Established schedules and monitored them in the new 4.1 system

§ Analyzed the system performance using different admin tools such as CMC, Webi Admin tool and logs

§ Configured the servers and server parameters to reflect the suitable timeout and memory requirements

 

Client: EPSON America Inc, CA                       Nov 2012 – Mar 2015 (2 Years 4 Months)

Role: SAP BI HANA Consultant

 

Environment:  BI 4.1 SP2 (SAP Design Studio, CMC, Promotion Management, Live Office 4.1, Analysis for OLAP, Lumira, Dashboards, Crystal reports for Enterprise), Oracle 11g, SAP HANA 1.0 SPS06, SAP BO XI 3.1 SP5, Upgrade Management tool, Import Wizard, SQL developer, SAP ECC (SD, PTP, OTC, SVM, FI), Crystal Reports 2010

 

Responsibilities:

· HANA sidecar implementation for improving efficiency for specific reports using ECC tables as source

· Analyzed the reporting requirements and designed BW data models for OTC and PTP modules.

· Business Objects Universe and reports development to consume the HANA information models

· BO administration for scaling and improving the environment for Latin America (LATAM) implementation

· Administered BO upgrade from XI 3.1 to 4.1 SP2 Patch 0

· Replaced BEx Universes with BICS and migrated .UNV to .UNX Universes

· .UNV Universe and Webi Reports development for Catalina Ink Shot Billing data in Oracle

· Designed OLAP Universes for BEx queries and created Crystal and Webi Reports

 

Client: Cigna Corporation, CT              Aug 2006 – Oct 2012 (6 Years 2 Months)

Role: Analyst Programmer

 

Environment:  Oracle 11g, IBM DB2, SAP BW 7.0 and SAP BO 4.0, CMC, Life Cycle Manager, BO XI 3.1, Dashboards, Crystal Reports 2008, Xcelcius, SAP SRM, SAP CRM

 

Responsibilities:

· Administered Business objects environments and performed upgrade from XI 3.1 to BO 4.0

· Worked with Business users to gather requirements and create specification documents

· BW Data modeling

· Loaded data to BW and monitored the process chains

· Created BEx queries

· Tested the Data models and reports

· Designed the universes for Relational DBs (Oracle and IBM DB2) using Information Design Tool (IDT)

· Created reports for using Operation data as well as data from the business warehouse

· Built OLAP universes for BEx queries and created reports

· Scheduled reports for automated delivery based on the desired frequency and destinations

· Led the Offshore and Onsite teams of size 8 and 2 for BW modeling and report development.

 

 

TATA Consultancy Services Ltd.                      May 2006 – Aug 2006 (4 Months)

Role: Trainee

Environment:  SAP ECC, BW, IBM DB2

Responsibilities:

· Attended training on the ERP solutions by SAP and different products available for enterprise data management needs

· Gained knowledge of the BW solution by SAP and completed exercises on BW modeling, Querying tools

· Completed sample projects in standard Project life cycle using SAP BW for Data warehousing and reporting