Project Data
Resume:
Suresh Reddy Medapati Mobile:
Email:
DWH and BI consultant, ************.**********@*****.***
Address:
Mahadevapura,
Eunoia Technologies. Bangalore, 560048
An DWBI Consultant with experience in implementation of Data warehousing, ETL
applications and implementation of Business Intelligence tools including report
generation and dashboard development. I hold strong technical proficiency across
programming languages and database platforms as part of my undergraduate programme
in Computer Sciences.
PROFESSIONAL TRAINING
Oracle Certified Associate Certified by Oracle on various RDBMS concepts as well as
programming/Query languages PL/SQL. Proficient at Query
PL/SQL Developer building using SQL.
Informatica, Talend Proficient in installing, configuring and implementing
ETL Tool the tool across multiple platforms based upon client
requirement.
Microstrategy, OBI Proficient in installing, configuring and implementing
BI Tool the solution including building reports, documents and
dashboards.
PROFESSIONAL EXPERIENCE (Jun 2012 -
Present)
Profile Description:- Technical Consultant for Data
Technical Consultant, Warehousing and Business Intelligence For Eunoia
Eunoia Technologies Technologies.
Roles & Responsibilities :
Designed Extraction process from Heterogeneous systems using Change Data Capture.
Have worked on design and development of Reports, Documents in MicroStrategy.
Performed Dimensional Data modeling and created Star Schema and Snow Flakes
Schema data model to meet the OLAP needs.
Skilled in implementing Data Warehousing and Business Intelligence solutions.
Worked on data warehousing projects and delivered high quality solutions
TECHNICAL PROFICIENCY
OLAP/Reporting MicroStrategy 9.2.1/9.3
ETL Tools Informatica PowerCenter 8.6.1,Talend
Programming Languages C, C++, Java
Databases MySQL, Oracle 9i/10g, MS Access 2003/2007
Operating Systems Windows XP/ Server 2008, UNIX/LINUX
Web Technologies JavaScript, html/xml, Jsp
PROJECTS & CLIENT ASSIGNMENTS
Project - 1: BRS Golf Enterprise Data Warehouse System
Designed and developed an Enterprise Data Warehouse that is loaded on a daily basis
from heterogeneous data sources using Informatica as an ETL tool. Business users use
this information for their decision-making using Reporting Tools.
Client Golfeurope
Role Design and Development of DWH.
Duration July 2012 to Oct 2012
environment Informatica, ETL
Functional Domain Retail / Entertainment
Responsibilities -
Transform the raw data received from tables and flat file formats into the data
warehouse using Informatica.
Prepared Mapping document & mappings for all OLTP tables.
Responsible for monitoring of the process through regular ETL load status check.
Project - 2: BRS Golf Business Intelligence System
Designed developed and implemented Business Intelligence solution and reports,
dashboards for easy analysis of data to facilitate the client in taking better and
expedited business decisions.
Client GolfEurope
Role Design and Development of BI System
Duration Oct 2012 to Nov 2012
environment MicroStrategy, BI
Functional Domain Retail / Entertainment
Responsibilities -
Active part of the team to understand and conceptualize the requirements for the
product.
Designed and developed reports, documents and dashboards for Business users.
Designed the project using Microstrategy Architecture.
Project - 3: iResume
Designed Microstrategy documents and dashboards which projects employee profile that
provides chances of getting hired in this competent world.
Client DataRulz (Product)
Role Design and Development of BI System
Duration Nov 2012 to Feb 2013
environment MicroStrategy, BI
Functional Domain Education / Employment
Responsibilities -
Involved in data modeling for logical and physical data model.
Created Facts, Attributes and Metrics in Microstrategy suite.
Post production support and troubleshooting after Post production.
Project - 4: EunoiaCRM
It is a CRM system, where different businesses can keep track of their sales,product
listing,customer database etc. Analytics are provided in the form of reports.
Client Eunoia Technologies Private Limited
Role Development of Reporting structure
Duration Feb 2013 to Till Date
environment MicroStrategy, BI
Functional Domain Retail
Responsibilities -
Responsible to come up with different reporting structures and implement them.
Responsible for designing documentation guide for End user.
EDUCATION:
Year Degree Institute/School % / CGPA
Jul 2009 - May Bachelor of Jawaharlal Nehru Tech 72%
2012 Technology, University
Computer Science Kakinada
June 2006 - May Diploma, State Board of Technology & 70 %
2009 Computer Science Training
Andhra Pradesh
Contact this candidate