Soni Das

Experience

• 

  KPIT

  Apr 2007 - Sept 2010

  Senior Software Engineer

   Understanding the client’s Business requirements and pre-built Webi reports. Created Universe level tables and objects, formulae’s and used it the Webi reports. Created row level and object level restrictions. Created Webi reports & sub-reports with formulas, open document URLs, different types of prompts in the document. Exporting the documents (report data) to different formats like CSV, PDF for reference by the clients in the future. Save the report in different formats like csv, excel pdf to compare data in prebuilt reports and see if newly added data (for new island) is getting reflected in the report. Developed Crystal reports based on different types of connectivity like POJO (Plain old Java Objects)& JDBC/JNDI. Developed Crystal reports based on Open Document and URL reporting & formulae’s. Exported reports and saving to different formats like CSV, Excel, and PDF & also scheduling them for creating different instances of the reports at different times.. Developed custom Web Intelligence reports using URL reporting and various types of prompts. Scheduling the Webi reports to different formats to run at different times. Created row level and Object level restrictions in the Universe Created users, groups, categories, folders (for the client) through Business Objects CMC (Central Management Console). Managed rights and access permissions through CMC.Create Crystal reports, Webi and Deski documents using different BO SDK, execute them using the respective report viewers and created their instances.Create Crystal reports based on JDBC/JNDI and ODBC connectivity and invoke them through BO SDK’s using JSP web application. Show less

• 

  Zensar Technologies

  Sept 2010 - Feb 2014

  Software Engineer

   Did analysis on Business requirements and interacted with the client to build Xcelsius dashboards. Involved in creating 4-5 Xcelsius dashboards as per client’s requirement based on different graphs, formulae’s. Dashboards were created to find out the distribution of CISCO products in different regions of the world for particular financial years and quarters. Analyzing around 30-35 Webi reports migrated from BOXI R2 to BO XI 3.1 for data issues, connectivity and formula errors. Corrected the data issues, formula errors in those Webi reports in case required. Compared the data in the reports built in BOXI R2 with reports migrated to BOXI3.1 by saving the reports to PDF and CSV format. Modified few Universes like changing the data connection, given permission to users for accessing the reports based on tables in the Universe.  Converted 2 Deski reports created in BOXIR2 to Webi reports using BO XI3.1. Tested all the Webi reports and submitted to the Quality team for testing. Did analysis on pre-built 5-6 Webi reports using Infoview for errors (if any). Did analysis on the Webi report queries by using Toad (Oracle Database version 10) and corrected the queries in case required. Worked at Universe level to check for the data issues in the report and made necessary changes (like changing the Universe connection name, Security rights). Tested around 40 Webi and 5-6 Xcelsius reports for getting correct data and no errors in the documents Show less

• 

  Tata Consultancy Services

  Mar 2014 - Sept 2022

  Tech Lead

   Get the understanding from client for the development of new Webi reports to be created for users. Done migration from BO XI 3.1 to SAP BI 4.1 Modified few Universes like changing the data connection, given permission to users for accessing the reports based on tables in the Universe.  Converted 2 Deski reports created in BOXIR2 to Webi reports using BO XI3.1. Test all the Webi reports and submit to the Quality team for testing. Build Universes and Webi reports that serve user’s needs. Used Tableau and created interactive dashboards for users. Schedule the reports as per the user’s needs. Migration of Universes and reports from one environment to other. Testing of the Universe reports and Tableau Dashboard in QA/UAT Environment and then deploy them in Production. Have worked in BO IDT and developed Universe which has the ability to connect to multiple data source Used Sybase and DB2 databases for multi-data source connectivity. Show less

• 

  Marsh McLennan

  Sept 2022 - now

  As a dedicated Project Manager, I orchestrated the seamless migration from BusinessObjects (BO) XI 3.1 to SAP BI 4.1, optimizing Universes, and ensuring precise user permissions. Proficient in BusinessObjects Information Design Tool (BO IDT), I developed versatile Universes connecting to multiple data sources.My technical prowess extended to crafting dynamic Web Intelligence (Webi) reports and interactive Tableau dashboards, enhancing user experiences. I implemented sophisticated scheduling configurations and conducted meticulous testing, guaranteeing the accuracy and reliability of complex calculations.Adept at navigating diverse databases, including Sybase and DB2, I ensured multi-data source connectivity. My commitment to technical excellence facilitated the successful deployment of robust BI solutions, reflecting my hands-on approach to project management in the Business Intelligence realm. Show less

  • Project Manager

    Apr 2023 - now

  • Technical Lead

    Sept 2022 - Mar 2023