RAMESH CHINTALAPATI

www.linkedin.com/in/rccsa

PROFESSIONAL SUMMARY

Sr. Business Intelligence Data Warehousing Consultant with expert skills in Design, Analysis, Architecture, Administration, Development of Business Intelligence applications in Business Objects, Tableau, MicroStrategy, on Windows and Linux platforms

Over 13 years of IT experience in application development and providing Reporting Solutions in transactional and data warehousing environments and around 2 years of experience with OTC workflow process including creating Revenue Management reports and OTC workflow metrics and dashboards

Seasoned SAP Business Objects Consultant with 9 plus years of experience in Designing, Developing and Implementing Reporting Systems, around 2 Years into MicroStrategy and 2 years of Tableau.

Well versed and experienced on various ETL activities including target to source mappings, data cleansing, transformation & Integration, and data modelling with help of tools like ERwin

1-year experience into Big Data Analytics including Hadoop (Cloudera, Hortonworks), Hive query language, Spark, Bit Bucket, & Python etc.

Proven expertise in different modules of SAP BO Products Suite that includes Business Objects / Desktop Intelligence reports, Designer, CMC, InfoView, WebIntelligence, SAP BI/BW, Bex /MDX queries, Xcelsius 4.5, Xcelsius 2008, QAAWS, Live Office

Right blend of business and technology expertise with leadership, interpersonal communication, analysis, design, implementation, and integration skills in providing enterprise-wide Business Intelligence solution

Expertise in migration, version control, developing and testing Business Objects products including server and desktop products

Excellent working knowledge and experience of Databases, Data Warehousing concepts and proficient in reporting

Expert in trouble shooting issues and Installation & Configuration of Business Objects Enterprise product Suite

TECHNICAL SUMMARY

Business Intelligence & Data warehousing tools

SAP Business Objects Enterprise, Tableau, MicroStrategy, MySql Workbench, Erwin 7.x

SAP BI Suite

Web Intelligence, Xcelsius 2008, 4.5, QAAWS, XML, LiveOffice, BI Services, Crystal Reports XIR2, Business Objects XI R2 integration with SAP BW/BEX Queries, Business Objects Designer, Xcelsius 4.5 / Xcelsius 2008, SAP BW, SAP ECC tables, UDT, IDT

ERP

SAP, Zuora, RevPro

Programming Languages

C, Python, HTML, DHTML, SQL, PL/SQL, HIVE Query Language (HQL), COBOL

Databases

Teradata, Oracle 10g/11g/12i/19.x, SQL Server 2000/2008/2012, DB2, MS-Access, MYSQL

Cloud

AWS, Tableau, MicroStrategy, Cloudera, Spark, Cloudera, Hortonworks

Web Application servers

IIS, Apache Tomcat Server

Operating Systems

Windows2003/2000/98/95/NT 4.0/XP/10, UNIX, LINUX REDHAT Release 6.2

Domains worked in

Entertainment, Consumer goods, Real Estate, Energy, Railroad &Public transportation, Manufacturing, Federal (USDA), Software & Hardware

CERTIFICATIONS

WISHLIST FOR YEAR 2020

· Tableau Desktop Specialist – Associates Certified

AWS Solution architect - Associates, Professional

· AWS Cloud Practitioner – Certified

AWS Data Analytics

· Zuora Administrator Certified

EDUCATION

Bachelor’s in computer science (1998 – 2001)

Master’s in Business Administration (2001 – 2003): Marketing management, Finance

PROFESSIONAL EXPERIENCE

Zuora – Boston, MA 05/18 – till date

Senior BI Lead

Zuora is an enterprise software company that designs SaaS applications and sells access to these applications, using a subscription business model, to client companies. Zuora’s applications are designed to automate billing, commerce, and finance operations. I am part of the Zuora Revenue team as a techno- functional analyst and a Datawarehouse developer responsible to architect, design, configure data solutions

Help implement OTC (Order To Cash) KPI metrics dashboards using Tableau 2018.x

Collect requirements for the revenue recognition of the company, document use cases and meet with the clients to confirm the finalized technical layouts and designs.

Involved in various business meetings to analyze and document the business requirements and impacts from Order Management, Credit Management, and Supply Chain Management

Created orders and subscriptions test data in Zuora central for testing the integration along with preparing custom templates

Documenting workflows, design documents, functional specifications as part of design process in an Agile environment

Actively participating in sprints and consistently be part of all stand up meetings and a thorough documentation procedure

Implementing 5 steps of Revenue recognition principle at the client place and wherever applicable, recommending best practices to the client, conducting workshops for Key decisions so that the business has all the required information to take the most effective decision to better their policies in regard to their systems, accounts, revenue recognition approaches etc

Worked with different groups to coordinate on various changes and analyzing dependencies and impact analysis

Designed, developed various reconciliation reports to balance the sales figures with the revenue and various other reports like Billing report, Booking report, Events and Revenue Summary reports, Accounting reports, revenue Waterfall reports etc.

Designed tableau dashboards for clients using features such as global filters, calculated fields, maps, area charts etc.

Publishing the dashboards on Tableau Server and Scheduled extract refresh for weekly and monthly reports.

Environment: Business Objects SAP BI, Tableau 2018.x, Oracle 12i, Zuora Central, Informatica, SQL Server 2012, Teradata, JIRA etc.

AT&T (Previously DIRECTV) El Segundo, CA 04/15 – 05/18

Senior BI Lead / Architect

DirecTV is an American direct broadcast satellite service provider and broadcaster based in El Segundo, California. As of July 2015, it is a subsidiary of AT&T. Worked with various BI tools such as Microstrategy, Business Objects and Tableau etc. including Hadoop, HIVE query language, Spark, Python etc. Developed various Order to Cash KPI metrics dashboards and detailed Revenue Management reports like Forecast Analysis, Revenue percentage and DSO (Days Sales Outstanding) reports

Lead a team under the Broadcast System Engineering department with a focus on delivering reporting solutions to users across the company using Business Objects, Microstrategy and Hive HQL.

Worked on various projects related to Video-On-Demand reporting, DIRECTVNOW, DFW project, Content management systems, Ticketing systems (Jira/Remedy), Spare level Management and delivered integrated reporting solutions

Also worked closely on the BDAR (Big Data Analytics and Reporting) team to capture the business needs and work on building BDAR aggregated tables on Hortonworks Hadoop clusters. Provided sources for Microstrategy cubes through the HQL scripts and worked on the end reports as well using documents, dashboards, reports in MicroStrategy

Used Erwin tool for building various engineering logical, conceptual, and physical dimensional models

Built hive / external tables on top of hdfs files that are Ingested from various sources such as Amazon S3 bucket, NiFi etc. for consumption in the front-end BI tools

Created crontab entries and documented the runbooks, used bitbucket to backup and version control the code

Involved in interacting with business users, requirement gathering sessions and providing LOEs and project plans

Worked on various Release Summary reports giving scheduled reports every week for the senior management of Broadcast Software Engineering department giving an overall health of the project statuses

Maintained & administered the Development, Staging & Production environments of Business Objects Cluster 4.1 SP4, Microstrategy 10.4

Defined the process of extracting, transforming, and loading the data into system, by defining the functional specifications and testing the programs.

Developed and maintained dashboards / reports and drive performance measurement

Created revenue management reports like Average Revenue per User (ARPU), Average Revenue per employee using SAP Business Objects on top of SAP BW BEx

Created Dashboards for OTC KPIs like Revenue Percentage, Individual Productivity, Calculation of DSO (Days Sales Outstanding)

Maintained the App servers and web servers on LINUX REDHAT O/S

Worked with SAP, Microstrategy to report and resolve product errors or find an alternative design approach in times of technical limitations and to troubleshoot in times of any issues with environment

Environment: SAP Business Objects 4.1 SP4, MicroStrategy, Tableau desktop 2018.xx, Information Design tool, Universe design Tool, Web Intelligence, Dashboard Design tool (Xcelsius tool from Business Objects 3.1), Teradata, Oracle 12i, Query As A Web Service (QAAWS), BICS connection, SQL Server 2012, MYSQL, DB2, JDBC, REMEDY, JIRA, MicroStrategy 10.4, Hive HQL, Cloudera, Hortonworks, Hadoop 2.0, Spark, Python, AWS S3 buckets

The Irvine Company - Irvine, CA 08/13 – 03/15

Senior SAP BW/BI Integration Consultant

The Irvine Company® is a diversified, privately held real-estate investment company and master-planner. Worked in various projects as part of the BI/DW team in handling source data and transforming it into meaningful reports and dashboards. Involved with various projects related to Retail, Office and Apartments divisions of the company including various OTC metrics dashboards and revenue management reports

Involved in the architecture and development of Executive dashboard, Office Key Results, Retail key results, Office Rental rates Analysis Dashboards built on top of BEx queries using BICS Connection

Worked closely with the top management to build most critical KPIs like Health Ratio, Cost Of Occupancy, Guideline rates, etc.

Created various Revenue Management reports like Monthly revenue, Revenue Analysis and Forecast reports

Support and execute data cleansing, migration, and conversion to ensure accuracy of enterprise master reports, transactional data reports

Worked closely with Business to come up with the architecture of "Lead to Lease" reporting solution that traces end to end how the potential customer is converted into an Opportunity and into an Executed Lease. As part of this, several stored procedures, views have been created that are used at the Universe level to build a dimensional model.

Designed Tableau designer to build Leasing dashboards for Apartments division

Designed SAP BW based Webi reports for the Apartments, Office, and retail divisions

Used Dashboard Design tool to design Dashboards in Business Objects 4.0 for the Office division

Worked with SAP to report and resolve product errors or find an alternative design approach in times of technical limitations

Worked closely with BASIS team to translate security requirements and create roles to enable judicious use of SSO Vs Fixed user access

Helped in testing User Security roles in Quality Environment before rolling out the BI solutions at backend level using RSECADMIN and at BOBJ level using Test IDs created with collaboration with the Business Objects administrator

Environment: SAP ERP, SAP BW, SAP ECC, SAP Business Objects 4.0 SP8, Information Design tool 4.0, Universe design Tool 4.0, Web Intelligence 4.0, Teradata, Dashboard Design tool 4.0 (Xcelsius tool from Business Objects 3.1), SAP BW Analyzer, Query As A Web Service (QAAWS), BICS connection, SQL Server 2008, SAP BW 7.0

Sempra Energy - Los Angeles, CA 08/12 – 07/13

Senior SAP BIDW Architect

Sempra Energy is a Fortune 500 energy services company, based in San Diego, Calif., that combines deep industry expertise with rigorous risk management to deliver superior shareholder returns. Involved with Productivity reporting Systems, Advanced Meter Projects which involve developing WebI reports along with Xcelsius Dashboards for the overall Advanced Meter KPIs and they are used to track the Meter Installations and retrofit changes per every warehouse all over the country.

Designed various Xcelsius dashboards for the Advanced Meter project, IT Dashboard etc.

Designed Universes using Information Design and Universe Design Tools (IDT / UDT) for PRS, System Health, Call center

Administration of Business Objects XIR2, SAP Business Objects 3.1, SAP Business Objects 4.0 environments and servers

Used Dashboard Design tool to design Dashboards in Business Objects 4.0 for the Advanced Meter KPI project.

Installed Special packs and Patches, tested the functionalities to make sure all existing functionalities are preserved

Supporting Developers by helping with software installations, Security management, Suggestions on best practices to design universes and reports overall and train users on Web intelligence

Used XML, BI Services, QAAWS data connectivity tools to design Dashboards

Used Information Design tool to create multi source universes in Business Objects 4.0 for Productivity Reporting Systems

Created wrappers to host the Dashboards for Advanced Meter KPI project

Created WebI Reports on top of BEX queries for Device Inspection projects

Converted overall 73 Business Objects XIR2, 3.1 universes, reports, personal documents to SAP Business Objects 4.0

Created audit reports for XIR2 and BOBJ 4.0 environments

Environment: SAP Business Objects 4.0 SP4, SAP Business Objects 3.1, Business Objects XIR2, Information Design tool 4.0, Web Intelligence 4.0, Dashboard Design tool 4.0 (Xcelsius tool from Business Objects 3.1), Query As A Web Service (QAAWS), Live Office, Teradata, CMC, SQL Server 2005, SAP BW 7.0, SAP ERP

USDA, DC 03/12 – 08/12

Senior Business Objects/ Xcelsius Developer

The United States Department of Agriculture (informally the Agriculture Department or USDA) is the United States federal executive department responsible for developing and executing U.S. federal government policy on farming, agriculture, and food. Involved with the Operational Reporting project of the Foreign Agricultural Services (FAS) FAS works to improve foreign market access for U.S. products

Designed various Xcelsius dashboards for the Foreign Agricultural Services (FAS) and OCFO (Office of Chief Financial Officer)

Involved heavily with requirement gathering and a complex analysis for building the Xcelsius dashboards and Web intelligence reports for the Operational Reporting

Involved in multiple working sessions with various users, managers to build prototypes for various dashboards for Financial Management, Budget Vs Actual Comparison, Human Capital Management etc.

Documented Design documents, Technical Specifications documents, Functional Specifications Documents etc.

Involved in the Financial Management Modernization Initiative (FMMI) and passed various tests for the access grants

Worked with customized components and embedded them into Xcelsius 2008 successfully by creatively bypassing technical limitations of Xcelsius limited out of the box components

Environment: SAP Business Objects 3.1, Designer, WebIntelligence, Xcelsius 2008 SP3, Query As A Web Service (QAAWS), Live Office, CMC, SQL Server 2005, SAP BW 7.0

Scotts Miracle – Gro, OH 10/11 – 03/12

BI Lead

The Scotts Miracle-Gro Company (NYSE: SMG) is the world's largest marketer of branded consumer lawn and garden products. The role assigned was a general Business Objects administration and as a team member in several projects that included SAP BW & Business Objects integrated reports along with designing and developing Xcelsius dashboards for the management.

Created Scotts Canada Garden WebIntelligence Reports using BW as a source

Designed, developed Dashboards using Business Objects Dashboard Design 4.0 and connectivity tools such as BICS

Handled overall Content Management and Security

Integrated the Web Intelligence reports onto the Dashboards using Opendoc functions

Defined Security roles and assigned users to custom groups defined for a better user rights administration and maintenance

Created Dashboard specific universes and created derived tables to cater to the dashboard requirements

Resolved various issues as an administrator which include, issues with Crystal reports and MS Access, SAP BW as a Database

Resolved scheduling issues with various reports, streamlined the scheduling to lower the processing burden on the servers

Worked closely with the SAP BW developers and administrators to streamline the rights conflict with the user rights in the Business Objects Environment and import the SAP defined roles into the Business Objects Environment

Raised tickets with SAP Support coordinated with them to get a closure on various technical issues and bugs and to understand some of the best practices pertaining to the issues

Environment: SAP Business Objects 4.0/3.1, Business Objects Administrator, BI Services, XML, WebIntelligence, Dashboard Design 4.0, BICS, SAP ERP, SAP BW

Amtrak, DC 02/09 – 10/11

Datawarehouse Analyst / Developer

Involved in the Customer Service Performance Metrics Information (“CSPMI”) project, built 2 universes, created reports and worked along with the Database developers to identify and resolve the performance issues since the CSPMI dashboards involved complex data pertaining to Customer complaints, Ridership and On-Time-Performance data sliced in various dimensions. Also was involved in multiple projects like creating, maintaining the Universes/Dashboards for Mechanical department, and proposing prototypes for the Chief Operating Officer dashboards.

Created CSPMI Universe from the Remedy tables along with the respective Web Intelligence reports

Created Monthly and Daily dashboards with each dashboard reporting up to 2 years of data monthly and daily level. The source data combines Customer Complaints, Ridership, and the On-Time Performance of the trains overall at route level, category wise and train level for different time dimension

Integrated the Web Intelligence reports onto the Dashboards using Opendoc functions

Merged various Web services into one big Web Service thus reducing the number of times the clicks invoke the web services.

Developed Acela Continuous Maintenance Dashboard and integrated various Crystal reports onto the dashboard

Developed various detail dashboards for Mechanical work floor project which would enable the dashboards to be displayed on the Mechanical workshop screen display as well as deliver a working model for interactive report churning for the management

Proposed various prototypes for the Chief Operating Officer

Analyzed the nature of the data and delivered 6 dashboards for the Safety department for Injury/Illness reports

Upgraded the Business Objects reports, dashboards, universes to the Business Objects 3.1 instance

Environment: SAP Business Objects XIR2, SAP Business Objects 3.1, Designer, WebIntelligence, Crystal Xcelsius 4.5, Xcelsius 2008 SP1/SP2/SP3, Query As A Web Service (QAAWS), Live Office, CMC, SQL Server 2005, SSIS

Apple Inc., CA 09/06 – 12/08

SAP BIDW analyst / Developer

The project was an amalgam of requirements from Japan, Singapore, and UK (taken as a part of the Regional Enhancements space). A common reporting solution, ‘Sell-Thru reporting’ had to be delivered and yet the regional requirements had to be met in full. The direct sales are anyways captured by SAP and then are channeled to the Global Sales Data from where it goes to the Business warehousing. The Indirect Sales are fed into the GDV from where it is channeled into the staging data mart and then into BW. Apple needs to integrate both the Direct and Indirect sales along with the information at various levels of the distribution channel.

Coordinated with the Business Owners to outline Business Requirements.

Liaised with the regional heads of Singapore, London, and Taiwan to seamlessly connect all the requirements and help complete the Business Requirement Document.

Acted as the lead developer for Sell-Thru reporting segment. Reports were reconstructed in Web Intelligence and Crystal Reports from SAP BW reports using BeX queries.

Created ad developed various data models for Regional enhancements division using Erwin tool

Scheduled documents to different users using CMC (Central management console)

Created Hierarchies to facilitate drill-down in the Desktop Intelligence reports

Concierge Project involved the study and analysis of the required data and pooling up different data from three different data warehouses for the sake of building up a common universe

Created pre-defined conditions and universe level prompts making it easy for business users to utilize these objects

Environment: Erwin, Business Objects XiR2, WebI Reports, Crystal Reports, InfoView, CMC, SAP NetWeaver BI/BW BEX Queries and Cubes, SQL Server, Apple Mac OS X, Windows XP/2003 Server, Oracle 10g.

Contact this candidate