Ramakrishna K

Ramakrishna K

Senior Technical Analytics Specialist
India
Telugu, English, Hindi
متاح الآن
Full-time Hybrid

نبذة عني

Results-driven and technically accomplished Oracle Analytics Specialist with over 12+ years of progressive, hands-on experience across data warehousing, business intelligence, and enterprise analytics platforms. Demonstr…

الخبرة

Senior Technical Application Specialist

Lloyds Banking · Hyderabad , Telangana , India
Jan 2025 - حتى الآن · 1 سنة 10 أشهر

<ul><li>Own and provide end-to-end technical leadership for Oracle FDI, ADW, OIC, OAC, OTBI,ODI,ERP and EPM platforms, ensuring platform stability, operational support, system currency, integration health, and alignment with Finance Platform objectives.</li></ul><p></p><ul><li>Lead complex technical initiatives and strategic projects, including Alternative Hierarchy Automation, User Access Management transformation, Oracle FDI modernisation, ADW upgrades, and Frequent Data Refresh (FDR V2) implementation activities.</li></ul><p></p><ul><li>Act as the primary application SME, providing expert guidance on application architecture, data flows, integrations, security design, troubleshooting, and technical decision-making across multiple Finance reporting platforms.</li></ul><p></p><ul><li>Drive Disaster Recovery (DR) readiness and resilience improvements, including ADW DR enablement, replication validation, recovery testing, production-to-DR synchronisation, DR deployments, and business continuity planning.</li></ul><p></p><ul><li>Design and implement secure access control solutions, including management of FDI User Access Management, AD Group governance, Management Unit Security, Cost Centre Security, Legal Entity Security, and role-based access controls.</li></ul><p></p><ul><li>Translate business requirements into technical solutions, producing solution designs, impact assessments, implementation plans, technical specifications, and governance controls that support business and regulatory objectives.</li></ul><p></p><ul><li>Lead production changes, releases, upgrades, and deployments, including implementation planning, CAB support, deployment execution, rollback planning, post-deployment validation, and operational sign-off activities.</li></ul><p></p><ul><li>Drive automation and simplification initiatives, delivering automated hierarchy integrations, data validation frameworks, reconciliation controls, and process improvements that reduce manual effort and improve operational efficiency.</li></ul><p></p><ul><li>Provide technical leadership during incidents and problem resolution, performing root cause analysis, coordinating Oracle Support engagements, managing service recovery activities, and ensuring platform reliability and performance.</li></ul><p></p><ul><li>Collaborate with business, engineering, infrastructure, Oracle, ACE, reporting and finance stakeholders, while mentoring colleagues, producing technical documentation, sharing knowledge, and continuously improving platform governance, resilience, and technical capabilities.</li></ul><p></p>

Senior Engineer – L2

Emerson · Pune , Maharashtra , India
Jun 2014 - Jan 2025 · 10 سنوات 7 أشهر

<p>Designed, developed, and maintained enterprise analytics solutions using OBIEE, OAS, OAC, and BI Publisher across Emerson Process Management worldwide business units.</p><p>Built and administered RPD (Repository) across Physical Layer, Business Model & Mapping (BMM) Layer, and Presentation Layer using OBIEE Administration Tool.</p><p>Developed Logical Star Schema and Snowflake data models in consultation with Data Modelers and Business Analysts.</p><p>Identified and defined Facts, Dimensions, Levels, and Hierarchies for dimensional modeling across multiple subject areas.</p><p>Created logical columns, dimensional hierarchies, calculated measures, and aggregate mappings in the BMM layer as per business requirements.</p><p>Developed and maintained ETL pipelines using Oracle Data Integrator (ODI) for data extraction, transformation, and loading into the data warehouse.</p><p>Designed and delivered interactive Dashboards and Reports with Drill-Down, Pivot Tables, Charts, Column Selectors, and Tabular views with global and local filters.</p><p>Created Action Links and Master Detail reports for cross-report navigation and guided analytics.</p><p>Developed BI Publisher reports with complex layouts and implemented writeback functionality.</p><p>Built Time Series reports for trending, comparative, and period-over-period sales and financial analysis.</p><p>Configured Analytics Agents to automate conditional delivery of reports and alerts to groups and selective recipients on daily and weekly schedules.</p><p>Performed performance tuning of dashboards and reports in collaboration with Business Analysts and DBAs.</p><p>Implemented end-to-end Data Warehouse solutions — including star schema design, fact and dimension table creation, and physical/logical data modeling.</p><p>Developed and maintained ETL workflows using ODI for multi-source data integration from Oracle ERP (Fusion & EBS) source systems.</p><p>Managed data extraction and transformation from Oracle Financials, Order Management, Manufacturing, and Inventory modules.</p><p>Created datasets and maintained data pipelines supporting Finance, Sales, Procurement, and Inventory analytics.</p>

المشاريع

Alternative Hierarchy Automation Solution (OIC, EPM, ADW & FDI)

Lloyds Bank
المدة : 02-Jul-2025 - 30-Apr-2026

<p>Designed and delivered an automated hierarchy management framework for Cost Centre Aggregation, Account Hierarchy, and IM Account Hierarchy data using Oracle Integration Cloud (OIC) to move hierarchy data from EPM into ADW and FDI. This replaced manual processes and improved governance across Finance reporting platforms.</p><p></p>

الشهادات

B.TECH EC

Jawaharlal Nehru Technological University, India · Hyderabad , Telangana , India · 2010

المهارات

Oracle Fusion Data Intelligence Fusion Analytics Warehouse Oracle Analytics Cloud OBIEE OTBI BI Publisher OAC Data Visualization OAS Oracle Cloud Infrastructure ETL Pipeline Design Oracle Data Integrator Informatica PowerCenter Oracle Integration Cloud Data Augmentation Autonomous Data Warehouse Oracle Fusion ERP Cloud Oracle E-Business Suite Oracle EPM Cloud EPBCS PCM Oracle EPCM PeopleSoft Workday Smart View Star Schema Design Snowflake Design Semantic Model Extensions RPD Fact Modelling Dimension Modelling Logical Data Modelling Physical Data Modelling SQL PL/SQL Python Toad SQL Developer JIRA Confluence ServiceNow Tableau Power BI Agile Waterfall KPI Validation Data Validation Frameworks Performance Tuning Object Level Security Data Level Security LDAP
الإبلاغ عن هذا الملف الشخصي؟