Experience

• 

  Avery india limited

  Feb 2009 - May 2010

  Software developer

  Actively involved in requirements gathering phase and discussions about the manually calibrating the load cells.Involved in creating the reports as per requirement using crystal report.Created design view of each form and involved in coding for the automated process of detecting the load cells, controlling the temperature of Eurotherm Oven and setting the value back in EEPROM chip after each calibration of cell.Created tables, Stored Procedures, Packages, different Funcions at the backend using pl/sql.Did manual testing at the end of developer.Environment – VB.net (.net Framework 3.0), MS Access, Crystal Report, Pl/Sql. Show less

• 

  Auric

  Jun 2010 - Mar 2014

  Obiee developer

  Working on OBIEE and ODI for Reports development and configurationWorking as a team lead, gathering requirements from businessproviding estimations, project plans and guidelines and working closely with project mentors Designing ELT layer with help of ODI, RPD and Dashboards for finance module and Agents and Interfaces to load data from one environment to another.Generating the efficiencies during the project execution and implementationDeveloped reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management. Configured metadata objects (Subject Area, Table and Column) and Web Catalog Objects (Dashboard, Pages, Folders and Reports).Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.Designed reports for reporting results and Analytics and created the OBIEE Dashboard.Involved in Design and Data Modeling using Star schema, Logical & Physical Database Layout Design and used PL/SQL for making queries and development.Created ad-hoc reports, reports with parameter fields, complex reports running from stored procedure, sub reports on request from main report, reports from different databases and reports with complex calculations and Running totals report. Show less

• 

  Acs solutions

  Mar 2014 - Mar 2015

  Obiee developer

  Working on OBIEE and ODI for Reports development and configurationWorking as a team lead, gathering requirements from businessproviding estimations, project plans and guidelines and working closely with project mentors Designing ELT layer with help of ODI, RPD and Dashboards for payrolling module and used Agents and Interfaces to load data from one environment to another.Generating the efficiencies during the project execution and implementationDeveloped reports using BI Dashboard and Answers, views & charts, created filters to obtain weekly sales for each region & send alerts to upper management. Configured metadata objects (Subject Area, Table and Column) and Web Catalog Objects (Dashboard, Pages, Folders and Reports).Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.Designed reports for reporting results and Analytics and created the OBIEE Dashboard.Involved in Design and Data Modeling using Star schema, Logical & Physical Database Layout Design and used PL/SQL for making queries and development.Created ad-hoc reports, reports with parameter fields, complex reports running from stored procedure, sub reports on request from main report, reports from different databases and reports with complex calculations and Running totals report. Define different security measures for different groups and users. Show less

• 

  Genpact

  Mar 2015 - Sept 2016

  Obiee consultant

  Got the opportunity to go Onsite for a month for Requirement gathering with one of the US client.Currently working on BIG DATA prooject learning Hadoop, Hive, Sqoop befrore this working on OBIEE and Informatica for Reports development and configurationWorking as a Consultant, gathering requirements from businessproviding estimations, project plans and guidelines and working closely with project mentors Designing ETLlayer with help of Informatica, RPD and Dashboards for various Supply Chain module and used one to one mappings to load data from one environment to another.Re-Designed reports for reporting results and Analytics and created the OBIEE Dashboard.Involved in Re-Designing and Data Modeling using Star schema, Logical & Physical Database Layout Design and used PL/SQL for making queries and development.Created new ad-hoc reports, reports with parameter fields, complex reports running from stored procedure, sub reports on request from main report, reports from different databases and reports with complex calculations and Running totals report. Show less

• 

  Hcltech

  Sept 2016 - now

  • Associate Project Manager

    Jun 2022 - now

  • Technical Lead

    Sept 2016 - Mar 2023