Soni Das

Soni Das

Senior Software Engineer

Followers of Soni Das1000 followers
location of Soni DasPune, Maharashtra, India

Connect with Soni Das to Send Message

Connect

Connect with Soni Das to Send Message

Connect
  • Timeline

  • Skills

    Data warehousing
    Business object
    Crystal reports
    Business objects
    Pl/sql
    Business intelligence
    Sql
    Data modeling
    Oracle
    Microsoft sql server
    Informatica
    Sdlc
    Unix
    Etl
    Requirements analysis
    Databases
    Sap businessobjects
    Software development life cycle
    Java
    Software project management
    Business analysis
    Xml
    Solution architecture
    Web services
    Data migration
    Core java
    Javascript
    Sap bi
    Crystal xcelsius
    Bo web intelligence
    Information technology
  • About me

    "Technical Project Manager | SAP BO/BI Expert | Orchestrating Seamless Business Intelligence Transformations"

  • Education

    • Modern Education Society's Nowrosjee Wadia College Arts, Science, Pune 01

      2004 - 2007
      Bachelor of Science (BSc) Computer Science Distinction
    • Swami Vivekanand Subharti University (SVSU), Meerut

      2019 - 2021
      Master of Business Administration - MBA IT and Operations A+
    • Modern Education Society's Nowrosjee Wadia College Arts, Science, Pune 01

      2002 - 2004
      Higher Secondary First
    • Savitribai Phule Pune University

      2007 - 2010
      Master of Computer Applications (M.C.A.) Computer Science Distinction
  • 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
  • Licenses & Certifications

    • Project Management Professional (PMP)

      Project Management Institute
      Dec 2023
      View certificate certificate