Vinay Mamidi
Data Scientist | LLM & GenAI Expert | AI ML Engineer | RAG Pipelines • LangChain • GPT-4 • Claude • Vertex AI | Building Scalable NLP & Chatbot Solutions | End to End AI Solutions | Open to contract opportunities
- Role
- Senior Oracle Consultant at Capital One
- Location
- Charlotte, NC, US
- LinkedIn followers
- 500 followers
About Vinay Mamidi
AI is no longer just about building models — it’s about solving real business problems at…
Experience
Senior Oracle Consultant
Jan 2024 — Present · McLean, VA, US
At Capital One, I worked as a Senior Oracle Consultant leading the design and enhancement of enterprise Business Intelligence solutions using OBIEE 11.1 and Oracle BI Publisher. My role primarily focused on building scalable and high-performance reporting systems to support financial, risk, and compliance analytics. I engineered complex OBIEE RPD models with advanced logical table source configurations and implemented federated queries to seamlessly integrate data from Oracle databases, flat files, and external APIs without additional staging. Additionally, I developed robust BI Publisher reports with advanced bursting logic to automate regulatory reporting processes. I also played a key role in implementing real-time data ingestion using Oracle CDC Streams and building efficient ETL pipelines using SAP BODS, ensuring timely and accurate data availability for business users.From a performance and optimization standpoint, I worked extensively on tuning SQL queries, creating materialized views, and implementing database partitioning strategies to significantly improve report execution time and system scalability. I collaborated closely with risk, compliance, and business stakeholders to deliver dashboards for fraud detection and financial reporting.Key Achievements- Improved OBIEE dashboard performance by 40% by optimizing RPD design, restructuring logical layers, and pushing transformations to the database- Reduced report execution time by 50% through advanced SQL tuning, materialized views, and indexing strategies- Enabled real-time analytics by implementing Oracle CDC Streams, reducing data latency for critical financial reporting- Automated regulatory reporting using BI Publisher bursting, eliminating manual effort and improving compliance accuracy- Enhanced system scalability and availability by implementing OBIEE clustering and load balancing across multiple nodes.
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.