Data Manager

Sanjoy Bose

Mobile : +91-704******* ~ E-Mail: ********@*****.*** ~ Skype ID: sanjoy.bose.in.skype

Seeking a Senior level employment as

Manager – Business Intelligence / Manager Data Solutions / Manager – MIS and reporting / IT Project Management with a multi- functional organization dealing in

DW-BI Software Solutions / Data Analytics Software Solutions / Big-Data Solutions

PROFESSIONAL SUMMARY

A result driven techno-functional professional with 20+ years of experience in Software Design and Development, Database Design & Administration (MSSQL Server, Oracle), DataWareHouse, ETL and Business Intelligence, Data Management, Data Analysis and Data Mining, Master Data Management(MDM), Data Cleansing and Data Quality, Data Governance, Integration of Systems, Enterprise Architecture, Process re-engineering, Integration of Data and Processes.

A versatile career of over 14+ years in IT Project Management, People Management, IT Program Management, Consultancy, Vendor Management, Coaching, Mentoring and Team engagement.

Currently working as Managing Partner, Mitasu Enterprises, Kolkata, taking care of their IT Infrastructure and Technology Solutions.

8+ years of experience in Oil & Gas Industry of Upstream Production & Operations Data Management, capturing of field data, managing Well Test data, Capacity / Production calculations, Downtime/Production Loss Analysis and Daily/MTD/YTD/MIS reporting. Experience in designing and implementing workflows and process flows to support Digital Oilfield Frameworks. Experienced of the business processes in the Upstream Oil and Gas Industry.

4+ years of extensive knowledge in the Hospitality – Sales & Revenue domain.

10+ years of experience in designing and development of MIS reports with Crystal Reports

Worked in SAP BusinessObjects / Business Intelligence Systems since Jun ‘2002 [8+ years]

Expert knowledge of T-SQL & PL/SQL, scripting custom functions and stored procedures, and Performance Tuning capabilities

Other business domain expertise are in Medical Health Insurance, Payroll & PIS Systems, Sales & Distribution Management, Materials Management (Supply Chain Management), Disaster Recovery & Business Continuity setup

Good knowledge of technologies: Relational databases, OO/UML methodology, PMI Methodology and Agile/SCRUM Project development methodologies

Lead vendor selection process (including RFPs and Pricing) and manage deliverables (including SOWs, change management, approval of deliverables)

Self-motivated, flexible, responsible, and always inclined in doing quality work

Plan, perform and manage projects with the ability to multi-task between several projects independently and changing priorities and schedules simultaneously

Done online trainings in Business Analytics and Hadoop from Manipal University, INDIA

IT SKILLS

Operating System Windows 10/8/7/NT

Source Control Tools Microsoft Visual Studio TFS

Databases Oracle 10g, SQL Server 2012

GUI Microsoft Visual Studio 10, VBA scripting

Language T-SQL, PL/SQL

Query / ETL Tools Microsoft SSIS/SSAS, SQL Enterprise Manager, SQL Analyzer, BCP, DTS Import / Export, SQL

Navigator, TOAD

OO Development Tools Cool:Plex / Obsydian

Data Modeling Tool Microsoft Visio, ERWin

Project Management Tools Microsoft Project Manager

Report Writer Crystal Reports 7.0/8.0/8.5, Microsoft SSRS, Microsoft Excel

DataWarehouse / BI Tools BusinessObjects 5.0 / 6.5 / SAP BOXI R2, Microsoft SSRS/ Microsoft BI Power-Pivot, Power-View

Application Software’s Micros Opera, FieldView2000 - 2004 / Avocet 2006, OFM - Oil Field Manager, EPS, DataWright – Financial Accounting System, MAXIMO – Supply Chain Management

CAREER HISTORY

Sep ’15 – Till date, working with Mitasu Enterprises as Managing Partner, Technology Solutions.

IT Infrastructure development, maintenance and support for a Heavy Electrical manufacturing company. Bearing in mind, self-reliance, maintainability in the long run, cost effectiveness and ease of use. Outsourcing being the primary focus. Computarisation of accounting was another key area of interest. Documentations, correspondences and e-tendering has been the other areas of contention. Mainly working with MS Excel and VBA scripting for automating day-to-day reporting, MS. Powerpoint for presentations and MS. Word for correspondences.

Working on packaging personalised services solutions for NRIs in mobiles.

Getting started with Renewable Energy Solutions.

May ’11 – Mar ‘15, working with Jumeirah Group as Manager, BI Solutions Development.

Lead the DW/BI development initiatives for 5* hotels.

Accountabilities:

Lead development, maintenance and support of Hotel Sales & Revenue Report Management Systems - Falcon in Microsoft .net technologies and SSRS. Manage development, maintenance and support of ETL’s for Sales & Revenue Data Report Portal – Falcon in Microsoft SSIS and SSAS, source from Opera PMS. Design workflow and process flows to improve data collection, integration with 3rd party data, and ensure data availability, 24X7. Develop adhoc reporting, KPI and dashboarding using T-SQL, MS Excel, VBA scripting, MS Powerpivot and MS Powerview. Designing and development of New Data archive layers / Data Marts / Cubes / ETL / BI Reporting solutions. Collaborate with IT, vendors and business stakeholders to design, develop, and implement technical solutions. Management of business requirements throughout the project life cycle. Collaborate internally within IT, business and vendors to manage scope and expectations.

Accomplishments:

Reduce downtimes for ETL’s and ensure data availability 24X7

Demonstrate maturity in designing and development of ETL’s, data transformations and faster loading for ensuring timely delivery of data and management reports, and, supply of adhoc data for other reporting needs. Ensure Single source of the truth.

Successful adoption of Agile / SCRUM Methodology development process to better manage the user expectation, transparency in the development process and the overall delivery management; Writing of user stories, backlog creation, and managing of sprints.

Data cleansing / De-duplication of data / Standardisation of data / Manage Structured and Un-structured Data Management / Master Data Management (MDM) was achieved and was ongoing. All round improvement in the data quality and enrichment of data.

Knowledge and Hospitality domain expertise in reporting by Market Segments, Marketing Channels, Digital Channels, Booking Pace, Lead Time Analysis, GSO Sales, Source Market Analysis, ADR calculations, RevPAR calculations, Paid Premium Occupancy, Budget Vs Actuals, Forecast Vs Actuals, Sales Targets Vs Actuals, Forecast Accuracy, etc.

Mar ’10 – May ’10 Represent iStore, US as Petroleum Engg. Data Manager

Employment contract with WorldWideWorker, Netherlands

Accountabilities:

Workflow Consultant for Well Test datatypes – PLT/PBU. Understanding of the RasGas - DMX Data Acceleration Project, and PETROTREK operational concepts. Understanding the fundamentals of Cloud computing concepts. Understanding the various sub surface well test datatypes of PLT/PBU/PVT/Open-hole/Cased-Hole data, its business processes. Interviewing Resv. Engg and Production Engg. users. Understanding and design of the Workflow and process flows for the log data. Design and development of the data transfer/refreshes mechanics from the data capture into the data repository. Design data quality control mechanisms in the data / of the various data sources. Design and develop reports for the internal users and shareholders.

Accomplishments:

Understanding of the data files such as the dlis files, and the .lis/.las/.pds files, etc. Hands-on experience with these various Sub Surface datatypes was a big addition.

Streamlining the data transfer mechanics from the data capture into the data repository.

Integration of dataflows of the production log interpretation report data from Service Provider’s and internal reports of RasGas.

Apr’07 – Sep ’09 with Petrofac Facilities Management, International Limited, Dubai Petroleum, Dubai, UAE as Senior Solutions Analyst

Accountabilities:

Project Lead Avocet 2006 Upgrade - The Upstream Production Data Management System. Work as Project Lead and Business Intelligence Solutions Architect in designing and development of an integrated BI reporting solution using SAP Businessobjects for the Legacy Upstream Production Data archive. Universe Modelling, Schema/Metadata Layer, Report Designing & Development, BICS Connectivity, Configuration and Administration. Management of development lifecycle from design through implementation and production support including technical design specifications, coding, testing, user training and deployment. Project Lead SAP BusinessObjects version upgrade projects from version 6.5 to BOXI R2 for the existing BI implementations. Project Lead parallel design, development, integration and implementation of enhancements and modifications of the existing Field Data Capture Systems to best fit with the post transition environment of Dubai Petroleum Estd. Maintenance of existing legacy Systems and applications in Field Data Capture as in Dubai Petroleum Company. Implementation support of the Financials & Supply Chain Management Datawarehouse and BI reporting using Oracle and BOXI. Support the integration of dataflows of production data between MATRIKON & i-DO systems.

Accomplishments:

Work with internal IT and Vendor to plan and implement tasks within the budgeted time and cost.

Act as SPOC for delivering production data within the organisation and the Government.

Successful coordination and mitigation of BI/DW system outages, refreshes, data recoveries and support packs.

Streamlining the data transfer / refreshes requirement in the data warehouse.

Implemented Avocet 2006 upgrade project within the budgeted time and money.

Developed production data calculations within the fringes of the legacy Field Data Capture Systems framework when FieldView2004 did not support back allocation.

Managed the transition of Field Data Capture applications and legacy data as per revised company policies and related production accounting procedures.

Dec’02 – Mar’07 with Dubai Petroleum Company (A ConocoPhilips Affiliate Co.), Dubai, UAE

as Project Lead, Field Data Capture

Accountabilities:

Project Lead FieldView2004 Upgrade. Responsible for Field Data Capture, analysis & reporting, systems modification & enhancements. Database Administration, and providing day-to-day technical system support, planning, developing and implementing strategies for ensuring the smooth running of the Data Center and the Archived Data Repository. Integrating systems, ensuring data / processes are readily available, efficient and effectively to end-users. Identifying training needs of the employees, developing and implementing trainings focused to enhance productivity and liaise with global business units & external suppliers. Conducting on-site systems review to identify root causes to the problems or system deficiencies and determine appropriate remedial action. Record and Maintain a database for incident logs for future references and creation of Knowledge Base. Project Lead - Build a Disaster Recovery & Businees Continuity site to handle catastrophic situations. Integrate Field Data Capture with LPO Systems. Maintenance & Support of Month - End and Year - End database processes. Maintenance & Support Month - End and Year – End reporting needs.

Accomplishments:

Efficiently deliver additional functions and processes to the existing Field Data Capture applications keeping in mind, the reusability of the existing codes.

Eliminate mathematical rounding issues while reporting production in cumulated volumes.

Reduce upgrade cycle time during FieldView2004 upgrade project compared with earlier instance.

Ensure Security and Business Continuity of the Field Data Capture Systems after the transition into the new environment.

Nov’99 – Nov’02 with Al Rostamani Info. Svcs, Dubai, UAE as Senior Consultant

Accountabilities:

Responsible for the implementation of Field Data Capture Systems for the client, providing day-to-day post implementation / technical support. Developing, modifying, enhancing and bug fixing of in-house & 3rd party application in Microsoft Visual Basic v6.0. Standard Report Development and enhancements using Crystal Reports v8.0. Co-ordination with offshore. Stabilise integrated dataflow from SCADA and Field Data Capture Systems. Manage data gathering in the Offshore historians. Managing data gathering in the Offshore historians. Implementation of Best Business Practices in Field Data Capture Systems for the client. Studying and understanding Business Processes and Operations. Interacting with Functional Heads from initial stage to successful implementation of Field Data Capture Systems. Reviewed feasibility, impact and benefits of various designs and provide recommendations for the best Designs.

Accomplishments:

Development, enhancements and implementation of Field Data Capture Systems as per Industry standards. Integrate systems between OFM and EPS, ensuring smooth flow of data / processes.

Introduction of BusinessObjects BI Tools for adhoc reporting in the production department.

Successfully lead the FieldView2000 upgrade project with Budget and time.

Feb’93 - Oct’99 with Binary Fusion International Pvt. Ltd., Calcutta, INDIA as Project Lead

Accountabilities:

Design, develop and implement various Payroll & PIS Systems (Module in ERP, BF Enterprise) for clients in India. Analysis, designing, development & implementation of the Sales & Distribution System (Module in ERP, BF Enterprise) for clients in India. Work as Sr. Consultant on a design and development of various modules for the Aircraft Operations, Supply and Maintenance System for Air Force and Air Defence Department, Abu Dhabi, UAE in Coolplex(formerly called Obsydian). Project Consultant in Designing & Development of a working prototype of Payroll & PIS System for General Information Authority, Abu Dhabi, UAE using Obsydian. Work as Project Manager for Medical Health Insurance System for a reputed Insurance Service provider in Calcutta, India. Feasibility study, interviewing end-users, information gathering & documentation. Cost estimation and preparation of the proposal in co-ordination with the Sales team. Preparation of the Technical Functional Requirement Specifications. Project planning and work breakdown structure. Project Management and control. Liaise with customers, presentations of prototypes. Communication with team members, identifying issues and mitigation. System Analysis and Database design. Unit Testing, Integration testing and System Check-out. Implementation plan and final deployment. Coordinate and Support Post Implementation Issues.

Accomplishments:

Successfully analyse, design, develop and implement various customised Payroll & PIS Systems (Module in ERP, BF Enterprise) for clients in India.

Equally successful in analysing, designing, development & implementation of Sales & Distribution Systems (Module in ERP, BF Enterprise) for clients in India.

Design and development various modules for the Aircraft Operations, Supply and Maintenance System for Air Force and Air Defence Department, Abu Dhabi, UAE in Obsydian.

Design & Development of a working prototype of Payroll & PIS System for General Information Authority, Abu Dhabi, UAE using Obsydian.

Design, develop and implement Medical Health Insurance System for a reputed Insurance and Service Provider in Calcutta, India

Provide strong project planning and delivery leadership

Delivery of projects within time, cost, scope and quality

Contributing to the development of methods and expansion of the knowledge base in the company

Multi-task and oversee the analysis, design, testing, implementation and documentation

QUALIFICATIONS

Bachelor of Commerce from Calcutta University in 1990

Honours Diploma in Systems Management from Aptech Computer Education, Calcutta in 1993

CERTIFICATIONS

Microsoft Certification in SQL Server Database Administration 6.5. Year -1998

Certification in ITIL Services Delivery Management. Year - 2006

TRAININGS ATTENDED

Online Certificate program in Big Data Analytics With Hadoop - Year 2015

Online Certificate program in Business Analytics - Year 2015

BI Designing and Development using Microsoft SSIS/SSRS/SSAS. Year - 2012

Designing & Reporting Course in Business Objects XI from MAP, Abu Dhabi, Year - 2007

PMP Project Management Executrain, Dubai, Year - 2006

Database Administration in Oracle 9i – Fundamentals I & II from Oracle M.E, Dubai, UAE, Year - 2005 / 2006

Developing VB.net application for windows and ADO. Net Programming from New Horizons, Dubai, UAE, Year - 2003

PERSONAL DETAILS

Date of Birth : 12th October 1969

Address(Home) : 43A, Haramohan Ghosh Lane. Vrindavan Apartment, Flat – 1.

Kolkata – 700085, INDIA.

Phone No: +917*********(Mobile) / +913*********(Landline)

Skype ID : sanjoy.bose.in.skype

Marital Status : Married

Dependants : 2

Passport No. : P0658962, valid until 31/07/2026

Driving License : GCC

Contact this candidate