Ramesh Reddy

Over 16 years experience on Business /Data Analysis,/Business Intelligence and ETL Applications

• Eight Years Experience developing Tableau Workbooks , Dashboards ,Scorecards , created data extracts for optimized loads, Installation of Server in Cluster configuration ,Tuned Server and

Dashboard Performances.

• Ten Years Experience with SAP Business Objects-Created SAP Business Objects Repositories,

Designed Universes, Developed WebI reports with multiple Data Providers, free hand SQL,

Combined Queries ;Used functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Break ;

• Expert in writing SQL queries, QA Testing, UAT Testing, Data Quality and Integrity testing, Data

Profiling, Data warehousing ,Dimensional modeling (Star Schema, Snow flake) and Databases

Teradata, Oracle 8i/9i, SQL Server 2000,Used Teradata SQL Assistant, MS management Studio,

TOAD .

General Motors, Atlanta, GA June 2020 –Present

SAP Business Objects and Tableau Developer

• Worked on Customer Care and After sales (CCA) project. CCA makes sure that the parts for services and repairs for every GM vehicle sold in North America are available when they are needed.
• Responsible for writing Business Requirements Document (BRD), Use Case Specifications,

Functional Specifications Document (FRD).

• Performed Gap analysis by identifying existing system, documenting the enhancements to meet the end state requirements.
• Conducted information-gathering session with subject matter experts and stakeholders, in order to acquire and analyze the business requirements. Documented requirements in the prescribed format and entered data in various data analysis applications while mapping the business process for the recipients
• Develop Business Objects reports and dashboard solutions for a wide variety of business intelligence projects
• Responsible for documenting modifications of pre-existing development new development for peer reference and knowledge transfer

•

Build charts, tables, and other data visualizations to help business users gain insights from their data.

•

Identify issues and optimize the performance of reports and queries to ensure fast and accurate data retrieval.

•

Used IDT-Information Design Tool-Extracted the tables from database,Built a data foundation from extracted tables and joins, Created metadata objects from data foundation layer and these objects are managed in Business layer, Published Universe which includes Business layer, Data Foundation and a Universe connection to database

•

Used Business Objects Calculation contexts, drill downs, hierarchies, advances functions, predefined conditions, prompts

•

Tuned Universes, created Contexts and Aliases for resolving Loops, Fan Traps, Chasm Traps, and checked the Integrity of the Business Objects Universes

•

Ensure universes are optimized, secure, and provide accurate and reliable data to reports.

•

Implement row-level security, user access controls, and other security measures to ensure only authorized users can access sensitive data.

•

Ensure reports are functioning correctly and the data is accurate by conducting thorough testing.

•

Cross-check the data returned by reports against source systems to ensure consistency.

•

Deploy and manage the distribution of reports to end-users.

Bachelors in Engineering