Suresh Y.

Suresh Y.

Expert in data modelling, ETL and business intelligence with strong SQL, Hive and Python knowledge

Hyderabad , India

Experience: 11 Years

Suresh

Hyderabad , India

Expert in data modelling, ETL and business intelligence with strong SQL, Hive and Python knowledge

51428.5 USD / Year

  • Immediate: Available

11 Years

Now you can Instantly Chat with Suresh!

About Me

Expert in Business Requirement Analysis, Data Analysis, Relational & Dimensional data modeling, Project management, Application design, ETL design, BI report/Dashboard design, development  and  implementation

...

Show More

Portfolio Projects

Description

Spend Diagnostics provides budget, financial overview and detailed analysis of a program, project and department. This project includes KPIs, trends and projected activity reports.

Show More Show Less

Description

The SWDPMH metric (SoftWare Defects Per Million Hours) provides a normalized metric that is the rate at which software defects are encountered per million hours of product usage by customers. Each software defect (CDET/BugSR entry), linked to a SR used in calculating the SWDPMH metric, counts as a defect encounter regardless of the severity or state of that defect

Show More Show Less

Description

Sales Leaderboard project provides sales agents details like agent Job Category, Department, Manager ID, goal sheet ID, attainments, Quarterly sales, Monthly Sales etc., These reports are currently available to Finance and Operations users only. Implemented new access strategy models in 10g and 11g versions and also involved in code deployments

Show More Show Less

Description

CCMP certification is intended to prepare managers for success within the Dynamic Network Organization (DNO). CCMP Community allows the manager to explore, enroll and earn certifications. CCMP Reporting is used to analyze Participants enrollment to various programs and their Statuses. As a part of initial phase, CMMP data elements would be made available in the CCMP subject area. Report definition are captured to ensure all the data elements are available to build the reports in the adhoc interface by report administers

Show More Show Less

Description

Learning and Development Solution group (LDSG) project is a migration of reports from Business objects to OBIEE technology. Only the most and medium viewed reports are migrated. Have done the gap analysis for the missing elements in the global warehouse

Show More Show Less

Description

HRIT Sales Dashboard is OBIEE Application consists of Multiple Dashboards that monitors key performance indicators in real time, enabling sales managers to act immediately to improve performance. The Project involves maintenance and development of sales dashboards designed using OBIEE and ETL designed using PL/SQL and Informatica

Show More Show Less

Description

e-Learning is basically the use of Internet technologies to deliver a broad array of solutions that enhance knowledge and performance. Internet enabled learning – encompasses training, education, information, communication, knowledge management and performance management. The Reports provides the data of Instructor Led Training (ILT), Web Bases Training (WBT), Enrollments, Learners, Training Evaluation System (TES), Cisco-on-line-Testing (COLT) and Registration Information Enterprise Systems etc

Show More Show Less

Description

This application is mainly used for creating various reports used for Business Analysis. It has reports like Item wise Closing Stock, Retailer Wise Item Wise Sales Volume, Sales volume reports of all the commodities sold at various regions

Show More Show Less

Description

GSK Bridge is a web application for nonforum users. Only GSK users can access this site (www.gsk-bridge.in). This facilitates the organization to track their sales volume weekly and monthly. Currently, GSK uses SIFY’s PORTAL (A reporting tool) to draw customized reports essential for managerial decision making. The project intends to arrive at a solution that will consolidate data coming from various sources and push into central database

Show More Show Less

Description

The website has both static and dynamic sections. For the dynamic section a customized CMS is provided which would facilitate NHT’s administrator to update the contents. Objective of the website would be to provide extensive information about the company with a strong focus on its product range, dealer and service network. The website would also provide an extensive and complete list of product line with all the technical specifications. The website (www.newhollandindia.co.in/nhi/) facilitates active communication between the company and prospective / existing customers

Show More Show Less

Description

To establish a strong presence of RWA (Residents Welfare Associations) on one of the most powerful and fastest growing medium of Interactivity and Commerce, the Internet. The website would primarily be a window for interactions between various RWAs across the country, this website would be a social platform on which the RWAs can voice their opinion and reach out the public in general. This website would highlight and promote the concept of community living and citizen journalism (www.residentwelfare.com, www.rwanews.com

Show More Show Less

Description

Seasons is an E-Commerce application, which maintains the flowers Information and Customers Information. Using this application the customers can place the orders via Internet. Online ordering is attractive because it eliminates the use of the telephone to facilitate the order. The florist provides the service to the customer, based on his/her order (www.seasons.net.in)

Show More Show Less

Description

WorkTracker is project management plan where the organization can improve productivity. Get projects done more quickly and intelligently. It allows managing an unlimited number of projects within an organization. WorkTracker is designed for businesses. Moreover it offers a high level of flexibility when managing users, who have different access rights depending on the project. For example, each project manager can organize his/her projects defining assigned users, task groups, task types, statuses, and priorities. The following sections describe the various activities that would be done along With the various modules of the application.

  • Multiple Project Management
  • Task Management
  • Project Statistics and Reporting
  • Employee Timesheet Tracking and Approvals
  • Security and Access Rights
  • Event Calendar
  • Message Center
  • Document Management
  • Discussion Forum

Show More Show Less

Description

HCM Advanced Analytics and Intelligence (HAANI)is an ERP implementation solution for the HR related information. The objective of this project is to provide an up to date data of an employee to the management. Designed and implemented ELT process using ODI to load the data in ADW using XML schema as a source from ADW worker extract. The end user reports includes the data related to new hires, rehires, assignments, terminations, global transfers and job information

Show More Show Less

Description

Global Technology Infrastructure (GTI)is the technology infrastructure organization for the firm, delivering a wide range of products and services. The objective of GTI is to balance both business alignment and the centralized delivery of core products and services across then firm. GTI is designed to address the unique infrastructure needs of specific lines of business and the demand to leverage economies of scale across the firm

Show More Show Less

Description

Built operational reports to monitor GL transactions and overall Pearson performance on a periodic basis. These reports are utilized by the sales organization, order management groups, receivables accounting teams, Financial Reporting team and Financial Control teams

Show More Show Less

Description

Product Quality and Compliance (PQC) provides a consolidated, easy to use reporting framework for consistency and accuracy in reporting and metrics to enable driving key business decisions across the organization. PQC contains dashboards catering to the reporting needs of the Engineering, Manufacturing and Quality communities.

Show More Show Less