Sanjoy Bose

Project Lead Avocet 2006 Upgrade.
Working as BI Solutions Architect to implement & integrate a DataWarehouse and Financials BI reporting using Businessobjects.
Support / Maintain / Bug Fixing / Enhancements - Financials & SCM BO Universes design & reporting in BO v6.5 and BOXI.
Successfully facilitate production data calculations within the legacy of Field Data Capture Systems framework when FieldView2004 did not support back allocation.
Successfully facilitate transition of Field Data Capture applications and legacy data as per the new policies and plans of the new management in the new environment.
Undertake design, development, integration and implementation of the Enhancements/Modifications of the existing Field Data Capture Systems to best fit in the post transition environment of Dubai Petroleum. Maintenance of existing Systems and applications in Field Data Capture.
Propose new technologies and solutions to best fit the new requirements of the business.
Implementation support of the Financials & SCM Datawarehouse and BI reporting using Oracle and BOXI

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.
Integrate systems, ensuring data / processes are readily available, efficient and effectively to end-users.
Identify training needs of the employees, develop and implement trainings focused to enhance productivity and liaise with global business units & external suppliers.
Conducted on-site systems review to identify root causes to the problems or system deficiencies and determine appropriate remedial action. Obtain approval for proposed actions outside standard remedial procedures.
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.
Facilitate handover of legacy production management data to the new business owners.
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.

Streamline data capture from off-shore to import into the Fieldview database
Maintain third party codes, fire-fighting program bugs, test integration with the other FDC application components and implementation into the live system
Implementation support
Modify and enhance in-house applications to allow new data entities to the existing data capture
User training to avoid midnight calls
Lead the FieldView2000 upgrade project
Enhance reports using Crystal Reports
Improve and expedite department-wise adhoc reporting needs using business intelligence tools
Strategies backup & recovery management for archive database

Feasibility study, interviewing end-users, information gathering & document.
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.
System Analysis and Database design.
Liaise with customers, presentations of prototypes.
Communication with team members, identify and mitigation.
Unit Test and System Check-out.
Implementation plan in coordination with the customer base.
Coordinate and Support Post Implementation Issues.

Key Accomplishments

Design, develop and implement various Payroll & PIS Systems (Module in ERP, BF Enterprise) for clients in India.
Analysis, design, develop & implement the Sales & Distribution System (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