Profileimage by VenkataRamanaRangaRaju Alluri BI Analyst from krakow

Venkata Ramana Ranga Raju Alluri


Last update: 29.01.2019

BI Analyst

Hourly-/Daily rates: show
Languages: German (Elementary) | English (Full Professional)




Informatica PowerCenter, Informatica Data Quality, Oracle Business Intelligence Enterprise Edition, Microsoft Business Intelligence, SSIS, SSAS, SSRS, tableau, Qlikview, SQL Server, Oracle, Teradata, Vertica, PL / SQL

Project history

Title: BI Analyst
Company: Adriot People PVT.LTD.
Duration: Apr 2017 to Till Date
Roles & Responsibilities:
  • Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Worked with DBAs to design and implement Conceptual data model, Physical Data Model, SSIS mappings and workflows to meet business requirements.
  • Responsible for creating ETL mapping documents to define data flow from source system to target database.
  • Worked with Source system Subject Matter Expert SME to ensure that the extracts are properly mapped.
  • Worked on the backend SSAS cube development which was the source data for the tableau.
  • Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling.
  • Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
  • Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
  • Created sheet selector to accommodate multiple chart types like Panel charts, Bullet charts and Stack bars etc. In a single dashboard by using parameters.
  • Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes..
  • Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
  • Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Google Big-query later.
  • Used Sql Queries at the custom Sql level to pull the data in tableau desktop and validated the results in Tableau by running Sql queries in Sql developer and Google Big-Query.
  • Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
  • Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
  • Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created tableau functional design document.

Title: Informatica Developer
Company: Hewlett-Packard (M) Sdn. Bhd.
Payroll: LaurelSoft ISolutions Sdn. Bhd.
Duration: Mar 2015 to Aug 2016
Roles & Responsibilities:
  • As a developer in this team initiated the process of Data profiling by profiling different formats of data from different sources
  • Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
  • And started analyzing its dimensions to find its actual structure and the rules which are implemented as part of Standardization.
  • Validation, Standardization and cleansing of data will be done in the process of implementing the business rules.
  • Match and Merge rules will be implemented in Informatica MDM to find the duplicates and to analyze the golden record.
  • Extensively worked on Informatica IDE/IDQ.
  • Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
  • Have Knowledge on Informatica MDM concepts and implementation of De-duplication process.
  • Created Reports and Dashboards using Tableau.
  • Migrated the code into QA (Testing) and supported QA team and UAT (User).
  • Conducted code reviews developed by my team mates before moving the code into QA.
  • Provided support to develop the entire warehouse architecture and plan the ETL process.
  • Modified existing mappings for enhancements of new business requirements.
  • Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities and Involved in production support.

Title: Software Engineer
Company: Texas Instruments Sdn. Bhd.
Payroll: Sri Soft Solutions Sdn. Bhd.
Duration: Feb 2013 to Jan 2015
Roles & Responsibilities:
  • Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
  • Coordinate with the front-end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
  • Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.
  • Continuous working with the data profiling, as the data received from many source systems and manual files with many data issues. Performed data cleansing on all the file and implemented the validations over the files.
  • Partitioned tables and indexes for better performance of application
  • Subject matter expert for OBIEE expertise in Oracle BI server, Oracle BI Answers, BI interactive Dashboards and Oracle BI Publisher.
  • Experience in providing end to end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD),Interactive Dashboards, OBIEE Answers, Security implementation, Analytics Metadata objects, Web Catalog Objects(Dashboards, Pages, Folders, Reports).
  • Used HPQC Quality management tool for issue logging and Defect Tracking.

Title:   Software Engineer
Company: Kentech Solutions Pvt. Ltd.
Duration: Jul 2009 to Dec 2012
Roles & Responsibilities:
  • Developed PL/SQL packages, procedure/functions, triggers, tables, collections, Sequences, views and indexes.
  • Involved in enhancement developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
  • Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views etc.
  • Partitioned tables and indexes for better performance of application.
  • Identify and tracked the slowly changing dimension tables, heterogeneous Sources and determine the hierarchies in the dimensions.
  • Understanding the Business requirements and Configuration of repository at all the three layers including Physical, Business Model and Mapping Layer, and Presentation Layer.
  • Imported metadata in to the Physical layer, applied Business rules in the Business Modeling and Mapping layer.
  • Configured Joins in Physical and BMM Layers.
  • Configured Dimensional Hierarchies in the Business Model and Mapping Layer.
  • Configured Logical Table Sources by defining the physical sources and content in the BMM Layer.
  • Calculation measures in the business model using Time series.
  • Extensively used Oracle Answers in building various reports. 
  • Designed and Developed new subject areas/ Customizations and front end reports.
  • Developed Reports with different Views (Pivot Table, Chart, Column Selector) using Oracle Presentation Services and Interacted with users, developed and maintained Reports and Dashboard.

Local Availability

Only available for the countries Germany, Austria und Switzerland
Yes, Willing to Travel
Profileimage by VenkataRamanaRangaRaju Alluri BI Analyst from krakow BI Analyst