Vinay Ramidi Email & Phone Number | I can build data warehousing system with the open source tools and without disturbing the existing applications. With this resolve existing reporting issues, decision making and future forecasting of the existing business. Build the end to end data warehouse system with the following approach: Creation of Reference Data Model, conducting workshops with Subject Mater Experts (SME), defining the concepts, building the relations between the concepts and design reference data model. System study, requirements gathering, analysis and scoping. Prepare the Source System MVs. Analyse the fixed format reports, dashboards and ad hoc reports. Creating the Bus Matrix , which will be useful for BI Team for their development. Create the dimensional modelling (Star Schema) by using the Kimball Dimensional Modelling Techniques. Create the reusable dimensions (Date Dimension and Age Dimension) to use any of projects. Create the ETL framework with which we can easily organize, add and enhance ETL transformations and Jobs. Create the source to target mapping document which includes transformation logics of each stage. Implement the ETL logics in transformation and jobs. Team can reuse these Jobs for remaining modules. Parameterise the variables throughout project. By implementing the aggregations and complex logics load the data into fact tables which can be easy for reporting. Supervising and guiding the ETL team and resolving the development issues. Create the ETL testing approach which includes; by using SQL Script applying all the source to target mapping logics which is similar like ETL developer Jobs then load the data in testing environment. Compare the developer’s loaded data with tester’s loaded data column by column with which we can deliver product with zero defects. Writing the stored procedures and developing the attractive reports with the BI Reporting tools. Creation of Materialized Views. SQL Query Tuning. Automate the process Scheduling Jobs in Linux server.

Vinay Ramidi

I can build data warehousing system with the open source tools and without disturbing the existing a...
Kuala Lumpur, Kuala Lumpur, Malaysia

*50 free lookup(s) per month.

No credit card required.

Vinay Ramidi’s Email vinay.ramidi@mimos.my

Vinay Ramidi’s Phone Numbers

Get VINAY’s Phone Number (For Free)

Social Media

Vinay Ramidi’s Location Kuala Lumpur, Kuala Lumpur, Malaysia

Vinay Ramidi’s Current Industry

Vinay Ramidi’s Prior Industry Hanodale Technologies | Ap Online

Not the Vinay Ramidi you were looking for?

Find accurate emails & phone numbers for over 700M professionals.

Work Experience

Mimos Berhad

Data Warehouse Architect

Present

Hanodale Technologies

Business Intelligence Consultant

2011-04-01 00:00:00 - 2013-03-01 00:00:00

Ap Online

Senior Software Engineer

2004-10-01 00:00:00 - 2011-03-01 00:00:00

Skills

No Skills Available

Languages

No Languages Available

FAQ About Vinay Ramidi

Vinay Ramidi is located at
Kuala Lumpur, Kuala Lumpur, Malaysia

Vinay Ramidi is a I can build data warehousing system with the open source tools and without disturbing the existing applications. With this resolve existing reporting issues, decision making and future forecasting of the existing business. Build the end to end data warehouse system with the following approach: Creation of Reference Data Model, conducting workshops with Subject Mater Experts (SME), defining the concepts, building the relations between the concepts and design reference data model. System study, requirements gathering, analysis and scoping. Prepare the Source System MVs. Analyse the fixed format reports, dashboards and ad hoc reports. Creating the Bus Matrix , which will be useful for BI Team for their development. Create the dimensional modelling (Star Schema) by using the Kimball Dimensional Modelling Techniques. Create the reusable dimensions (Date Dimension and Age Dimension) to use any of projects. Create the ETL framework with which we can easily organize, add and enhance ETL transformations and Jobs. Create the source to target mapping document which includes transformation logics of each stage. Implement the ETL logics in transformation and jobs. Team can reuse these Jobs for remaining modules. Parameterise the variables throughout project. By implementing the aggregations and complex logics load the data into fact tables which can be easy for reporting. Supervising and guiding the ETL team and resolving the development issues. Create the ETL testing approach which includes; by using SQL Script applying all the source to target mapping logics which is similar like ETL developer Jobs then load the data in testing environment. Compare the developer’s loaded data with tester’s loaded data column by column with which we can deliver product with zero defects. Writing the stored procedures and developing the attractive reports with the BI Reporting tools. Creation of Materialized Views. SQL Query Tuning. Automate the process Scheduling Jobs in Linux server.