Rahul Bhattacharya

• Optimized business requirements and built system prototypes for efficient financial reporting with using Data Classification, Cluster Analysis, Forecasting, and Outliers Modeling.
• Implemented Predictive Data Analysis process using statistical functions and Machine Learning concepts to forecast systems usability and real-time accuracy using Tableau, ODI, PLSQL, PowerShell, Microsoft Power BI.
• Identified and implemented system improvements that resolved over 75% process issues and enabled transparency of business workflows and critical financial data quality controls.
• Discovered key metrics of financial systems usage by dimensional analysis of business data and application logs.
• Influenced and collaborated with business and technical teams to define better requirements for organizational processes and achieve higher productivity and accuracy standards.
• Engaged in C-level executive reporting and dashboard analysis for insightful business intelligence reporting.

Skills: Data Classification ⸱ Cluster Analysis ⸱ Strategic Forecasting ⸱ Outliers Model ⸱ Oracle Hyperion Data Relationship Management (DRM) ⸱ Unix ⸱ Tableau ⸱ SQL ⸱ Microsoft Excel ⸱ Oracle Data Integrator (ODI)

• Designed and implemented Oracle EPM and MDM (Master Data Management) application in DRM after assessing strategic implications of business intelligence data for Oracle GL and other Financial Accounting areas.
• Designed and developed data processing and reporting interfaces using Oracle Data Integrator (ODI), Unix, PLSQL, OBIEE to integrate financial accounting systems.
• Identify Process Improvement (PI) strategies prior to actual impact and brainstorming 90% potential alert mechanisms with business.
• Devised and implemented real-time data quality monitoring process to ensure quality controls of business data and maintain robust data integrity .
• Designed and implemented system enhancements after extensive requirement meetings and data mapping sessions with 30+ business stakeholders.
• Visualization and graphical representation of critical metrics and data in easily comprehensible and actionable format.

Skills: Data Governance • Hyperion Planning • Predictive Analytics • Forecasting • Oracle Hyperion Data Relationship Management (DRM) • SQL • Master Data Management • Data Governance • Data Integration

• Designed data warehouse and implemented large scale data processing components using Informatica PowerCenter, Unix, Windows Batch Scripting, OBIEE, PLSQL.
• Optimized performance of data intensive processes to achieve million dollars business savings by reducing 70% downtime.
• Developed innovative solutions to persistent problems by identifying business improvement areas and optimizing reporting and load designs.

Skills: Data Warehousing • Extract, Transform , Load (ETL) • SQL • OBIEE • Informatica PowerCenter • Data Analysis • Data Visualization • Unix • Application Configuration

• Designed and developed scalable parameterized interfaces using complex data load logics using Unix, Informatica PowerCenter, DAC and PLSQL.
• Implemented reporting dashboards using OBIEE and automated data quality monitoring and anomaly detection by Unix and PLSQL.
• Generalized and implemented coding standard after due diligence and study across all modules of the applications as part of system improvement.

Skills: Data Analytics • Data Warehousing • Extract, Transform, Load (ETL) • SQL • OBIEE • Unix • Informatica PowerCenter • Application Configuration

• Implemented Oracle Virtual Private Database to enable role based data security for 1000+ report users.
• Configured record level and field level access using access control roles as part of business security modelling in Oracle database.
• Influenced analysis of business data security and optimized access control roles and processes.

Skills: Database Management System (DBMS) • Oracle Database Administration • Information Security • PL/SQL • SQL • Oracle Database Configuration • Oracle Database Maintenance