Debashis Mitra

BI Consultant at ETF Securities
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
UK
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Certification in Querying Microsoft SQL Server 2012
    Microsoft

Experience

  • ETF Securities by WisdomTree
    • United Kingdom
    • Investment Management
    • 1 - 100 Employee
    • BI Consultant
      • Oct 2015 - Present

      Design and Development of a Marketing Analytics Dashboard solution from the scratch; for the Marketing Department in MS-SQL Server. Where the idea is to present various analytical information at a Central Dashboard by gathering data from various sources such as Google Analytics, GoTo Webinar, RegOnLine, MS-CRM etc.; by using relevant proprietary/third party APIs in C# .Net.  Design and development of staging database using TSQL  Design and development of reporting database using TSQL  Design and development of ETL solution using SSIS  Design and development of various SSRS report.  Design and development of dimension model/OLAP cubes using SSAS; by applying Kimball methodologies of Dimensional Modeling, producing Star Schema.  Development of Stored Procedures, Views, using T-SQL and using within SSIS packages; for Extracting, Transformation and loading.  Performance monitoring and tuning of SQL queries resolving UAT/production bottle-necks.  Documenting both functional and technical design of various database/reports.  Managing/liaising expectation of various stake-holders, such as Marketing, Accounts department including project planning, presentation and delivery.

  • Cunningham Lindsey
    • Reading, Berkshire, United Kingdom
    • SQL Server BI/Business Objects Consultant
      • Sep 2014 - Sep 2015

      Developing MI Solution, using... SAP Business Objects, Universe Designer, Desktop / Web intelligence Reporting SQL Server BI Stack of Tools; SQL Server Stored Procedures, Views ETL solutions involving various data sources and destinations, Such as Informix, SQL Server, MS-Excel etc. Developing MI Solution, using... SAP Business Objects, Universe Designer, Desktop / Web intelligence Reporting SQL Server BI Stack of Tools; SQL Server Stored Procedures, Views ETL solutions involving various data sources and destinations, Such as Informix, SQL Server, MS-Excel etc.

  • Jupiter Fund Management plc
    • SQL / Business Objects Data Analyst
      • Jul 2014 - Aug 2014

      Database Design and Development BO universe Design and Development, BO Report design and development BO admin work using CMC Database Design and Development BO universe Design and Development, BO Report design and development BO admin work using CMC

  • Bravura Solutions
    • Australia
    • IT Services and IT Consulting
    • 700 & Above Employee
    • SQL Server Development DBA/Business Objects Development
      • Aug 2005 - Jun 2014

       Database Design and Development in Microsoft SQL 2000, 2005 & 2008-R2 platform, using various E-R modelling tools;  Involved in developing new enhancements and bug fixes in the database side of things, i.e. Stored Procedures, Views and Triggers using T-SQL.  Performance monitoring and tuning of SQL queries resolving UAT/production bottle-necks.  Installation and Migration various SQL Server databases for version upgrades, i.e., between SQL 2000 to 2005 to 2008 etc.  Documenting both functional and technical design of various database/universe/reports.  Design and Development of database objects/modules i.e. Stored Procedures, Views, Triggers using T-SQL.  Design and development of an Operational Data-Store (ODS) SQL Server data warehouse database for various Transfer Agency data and analysis reporting. Using the E-R modelling tool Visio 2003/DeZign-7 (later) and using Inmon’s (Top-Down) dimension modelling approach producing a Snow Flake Schema of Fact and Dimension tables.  In parallel working as a Business Objects Developer/Consultant and Data Warehouse architect by planning, designing developing SAP-BO (6.5 and XI ) environment as stated below:  BO Universe design using techniques of Dimensional Modelling, producing Star Schema (using Kimball Methodology).  Business Object report (full-client & Web-Intelligence) design, development.  Business Object server administration and maintenance  Installation Business Objects (6.5 & XI) Servers  Migration of existing objects from Business Objects Ver. 6.5 to XI-3.1 (SP5)  Design & Development of reports in Crystal Reports 9 and SSRS.  Design & Development of ETL (Extract, Transform, Loading) solution using SSIS, both Take-On & Take-Off.  Other regular development DBA activities:  Maintenance of databases  User/access management,  Performance monitoring and tuning of SQL queries resolving UAT/production bottle-necks.  Implementation of SQL best practices among the application developers

  • ITC Infotech
    • India
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Software Consultant
      • 1997 - 2000

      Client-Server Software Development, using Oracle Client-Server Software Development, using Oracle

Education

  • Indian Statistical Institute
    Diploma in Computer Application and Programming, Computer Software Engineering
    1990 - 1992

Community

You need to have a working account to view this content. Click here to join now