Romit Singhai

  • Pune Maharashtra

BO Developer with 2.5 years of experience

Summary

  • 2 years of experience in Business Objects, SQL-PL/SQL , Informatica and UNIX.
  • Having experience in Business Objects Suite (XI 3.1 ,4.0), Universe Designer ,Web Intelligence.
  • Trained in Data Warehousing.
  • Strong knowledge of Business Objects Universe Designer and Webi Reporting.
  • Also have the good knowledge of SQL-PL/SQL.
  • Have a sound knowledge in UNIX.
  • Having experience in creating Informatica mappings and workflow.
  • Have worked in all phases of Software Development Life Cycle.
  • Good communication skills & Problem Solving skills.

Work History

Work History
Mar 2013 - Apr 2015

BO Developer

Cognizant Technology Solutions

Project: JPMC IB OSKAR (Onboarding Sponsorship KYC Analysis & Reporting)

Roles And Responsibilities:

  • Analyzing the report requirements.
  • Interacted with Business Users, Business owners to know their Business requirements in modifying Universes and Reports accordingly.
  • Interaction with clients on Daily basis for discussion and analysis.
  • Have analyzed various universe features like Joins , Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
  • Created user Prompts, Conditions and Filters and used Alerters to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
  • Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically.
  • Developed various reports in business intelligence using business objects.
  • Involved in development of various BO universes using business object designer.
  • Working on change requests on old reports based on the client requirement.
  • Migration of reports among different environments.
  • Design and Development of Informatica mappings and workflows.
  • Gathering requirements from clients and make them documented.
  • Done documentation for project like release notes, post release checks and deployment documents.
  • Done deployment of code into SIT and UAT.
  • Done performance tuning for the Universe Designer objects.
  • Done Unit Testing, SIT Testing and data validation.

Education

Education
May 2008 - May 2012

Bachelor of Engineering(CSE)

Oriental institute of science and technology , Bhopal

Completed with 74.66%

Apr 2006 - Apr 2007

Intermediate(10+2)

Aklank public school , Kota

Completed with 70%

Apr 2004 - Apr 2005

High School

Kendriya Vidyalaya , Shahdol

Completed with 72.4%

Skills

Skills

Reporting Tools

2+ Year experience in SAP Business Objects XI 3.1, Business Objects 4.1.

Databases & Tools

Oracle, SQL Server, Toad, Oracle SQL Developer.

Programming Languages

SQL,PL/SQL.

ETL Tools

Informatica PowerCenter 8.6.1, 9.5.

Scripting Languages

Unix.

MS - OFFICE 2007

Excellent Knowledge of MS word and Excel.

Awards And Achievements

  • Awarded as ‘Feature in Cap’ for making an impact to customer and business.
  • Awarded as ‘Rising Star’.from Cognizant.