Ramesh D.

Ramesh D.

Project Manager

Hyderabad , India

Experience: 13 Years

Ramesh

Hyderabad , India

Project Manager

36000 USD / Year

  • Immediate: Available

13 Years

Now you can Instantly Chat with Ramesh!

About Me

12 Years of IT experience with 4 Years as Project Manager Good technical exposure in the areas of Business Intelligence tools such as SAP BO/BI & Qlikview & Qlik Sence. Worked as Qlik sence administrator to manage, monitoring & trouble shooting the i...

Show More

Portfolio Projects

Description

  • Development & admin of business reports using the Tableau reporting tool
  • Worked on Installation and user access and data monitoring and development of reports.
  • Worked on deep diving of data and connections, understanding of metadata and sharing data source connections.
  • Developed the reports to assess the sales, product planning, area wise sales, vendor reports,

Logistics planning, Product performance, sales executive reports etc…

  • Created various charts such as bar, line, pie, side by side, stacked etc.. for the better data visualization.
  • Added different calculation fields to the report for the better data showcase in the reports.
  • Worked on data blending to created relation with multiple data sources and to extract the required data.
  • Worked on Dashboards to insert the different worksheets and showcased multi dimensional view to the client.
  • Worked on mapping data like standard map view, dealing with mapping errors, using filters on mapping etc.
  • Worked on Ecommerce development for the customer’s products.

Show More Show Less

Description

Technical Manager Role in maintenance and development of Business Intelligence reports. Develop, design and test BI Reports and Dashboards based on user requirements. Work with the customer to gather specifications for data and report requirements. Effectively translate end user reporting requirements into functional design documents. Development of operational reports and dashboards with focus on business data insights. Maintain and support Qlikview environment. Worked as Qlik sence administrator to manage, monitoring & trouble shooting the issues. Technically supported in the area of SAP and Non sap application Qlikview. Involved in project planning, transition, capacity planning, costing, maintenance & continuous improvements. BO Report developments and user discussions. Lead off-shore in Reporting Design and Development, post production support for SAP applications. Lead multiple ad hoc project requests from clients and completed them successfully. Provided estimates to the project work and lead the discussions with the client team on the project Worked as innovation lead and collected the ideas across the teams in the project. Worked continuous improvements across the teams as part of the value add services to the clients. Collected the processes to automate and to reduce the man efforts in routine processes Involved in resource recruitment to the project and for the company Lead the Incident management, Change Management, Problem Management across the applications. Lead the status calls with the clients in the areas of project maintenance and development activities. Involved in escalation handling across the applications in the project.

Show More Show Less

Description

Project: Triumph International (Apparel & Fashion)

Role:Software Engineer Associate Manager

Environment:Tableau, SAP BI/BO, SQL, MS BI

Project Duration: March 2016 to May 2018

Team Size:25 Members

Show More Show Less

Description

  • Offshore lead in managing the Business Intelligence tools such as Tableau, SAP BI/BO
  • Managing the SOWs in the areas of Tableau and SAP BI/BO
  • Business Intelligence application maintenance and development
  • Exposure in SAP HANA studio.
  • Involved in BO Admin activities in maintaining the user access & publications.
  • Involved in BO migration project from BO 3.1 to BI 4.1.
  • Testing and validating reports against Oracle db & Bex queries.
  • Managing the BW team and ensuring the targets are met well within scheduled time.
  • Client facing role in having various discussions and status calls related to the project.

Show More Show Less

Description

Lead off-shore in Reporting Design and Development, post production support for Business intelligence Reports

Show More Show Less

Description

  • Requirement Gathering in order to develop BO Universe & Webi reports.
  • Prepared Technical Specs based on Business requirement.
  • Prepared SMTDs related to various Functionalities
  • Guided team members in order to provide on time deliverables
  • Created BO Universes using BOXI 3.1 version with the different functionality such as Defining parameters, LoV, Hierarchies, linking Universe etc.
  • Developed Webi reports and provided functionality such as filters, Ranking, Drill, Formatting etc.

  • Working on report migration from DEV => UAT => Production using Import Wizard.
  • Upgraded new patches onto BO in order to fix the existing bugs and got succeeded.
  • Worked on Domain Migration (Created new Domain/Group) in CMC.
  • Interacted with vendor (SAP) on different issues and gathered required information.
  • Resolving the user issues pertaining to enterprise reporting such as access problem, report not working etc.
  • Working on enhancement activities relating to existing webi reports & Universes
  • Coordinating with DBA team to avoid the issues from reporting side.
  • Monitoring the BO services & scheduled report jobs,
  • Guided the team to resolve the issues within the time frame
  • Monitoring the team activities & conducting knowledge sharing sessions

Show More Show Less

Description

Requirement Gathering in order to develop BO Universe & Webi reports. Prepared Technical Specs based on Business requirement. Prepared SMTDs related to various Functionalities Guided team members in order to provide on time deliverables Created BO Universes using BOXI 3.1 version with the different functionality such as Defining parameters, LoV, Hierarchies, linking Universe etc. Developed Webi reports and provided functionality such as filters, Ranking, Drill, Formatting etc. Working on report migration from DEV => UAT => Production using Import Wizard. Upgraded new patches onto BO in order to fix the existing bugs and got succeeded. Worked on Domain Migration (Created new Domain/Group) in CMC. Interacted with vendor (SAP) on different issues and gathered required information. Resolving the user issues pertaining to enterprise reporting such as access problem, report not working etc. Working on enhancement activities relating to existing webi reports & Universes Coordinating with DBA team to avoid the issues from reporting side. Monitoring the BO services & scheduled report jobs, Guided the team to resolve the issues within the time frame Monitoring the team activities & conducting knowledge sharing sessions

Show More Show Less

Description

Interact with Business Users and Financial Analysts to analyze the business process and gather the requirements. Requirement analysis and Preparing the requirement documents using the standard template Coordination with business and technical teams. Responsible for universe designing and hierarchy building for data analysis. Define cardinalities, check integrity, and resolve loops by creating aliases and contexts to remove the cyclic dependencies. Develop the Enrollment, pharmacy and utilization reports according to the business requirements and unit test the reports. Create complex reports including multiple queries, formulae and calculations. Manage the reports and universes on multiple environments as required. Create different types of reports, like Master/Detail, Vertical table, Cross Tab and Chart, (for trend analysis). Use of filters, conditions, calculations, Drill down, etc. Train the Business users. Improve the performance of the reporting systems including suggesting the indexes. Provide the administrative support of the known issues. Support on existing report and universe design issues.

Show More Show Less

Description

Understanding the requirements and feasibility. Creating the Universe with required classes and objects, modifications and maintenance of Universes. Resolve the loops using Aliases and Contexts. Check the integrity of the universes and export the universe to the repository for making available to users. Created reports from Business Object Universe, as main data providers and using functionality like @functions for user response. Create complex reports including multiple queries, formulae and calculations. Manage the reports and universes on multiple environments as required. Creating complex reports using graphs, pie charts and multiple data providers on daily, weekly, monthly and quarterly basis. Used drill Up/Down operations done for different aspects of client business. Documentation of unit test cases.

Show More Show Less