Venkata Pochamareddy

JPMorgan Chase & Co is a global financial service holding company and the largest U.S Bank by assets. The company provides services including consumer banking, investment banking, commercial banking, and asset management for individuals, corporations, institutions, and governments globally.

• Work with business stakeholders to gather requirements and manage project scope
• Responsible for leading three critical projects in Commercial Banking LOB
• Implemented entire Sigma Computing BI platform that includes Design, Develop, architecture, configure, governance, security (SSO, OAuth, Data level restrictions), data connections and administration
• Work with business teams to develop and implement data-driven dashboards and visualizations
• Collaborate with cross-functional teams to implement BI solutions that meet business needs
• Analyze large datasets to identify trends and improve business insights
• Evaluate data flows, models, and architecture to identify opportunities for improvement
• Interact with end-users and become a subject matter expert in data visualization
• Partner with business and IT to understand and streamline data and reporting processes
• Build various data connections from Sigma to Snowflake and Redshift
• Responsible to migrate dashboards from legacy BI products to Sigma Computing
• Built several dashboards to monitor operations of several applications under commercial banking
• Enabled writeback capabilities on Sigma to Snowflake
• Combine data from multiple data sources for comprehensive analytics and insights
• Optimized large datasets to handle volumes efficiently for quick analysis
• Support adherence to governance processes and ensure data quality controls
• Collaborate with several IT teams to integrate systems and improve data flow processes
• Work closely with business and technical teams to put governance process for Sigma Computing and other BI and Data platforms
• Setup security and data connections for Sigma, Qlik Sense and Tableau
• Configured SAML federation on Sigma for authentication and authorization
• Implemented data level masking & restrictions on Snowflake using native roles, policies and tags
• Responsible for setting up security architecture for various BI and Data platforms
• Responsible for data controls, audit and adhere JPMC regulations
• Work closely with team to build CICD pipelines for various applications
• Work on Performance metrics and capacity planning for multiple applications
• Environment: Sigma Computing, Snowflake, Redshift, Hadoop, QlikSense, Immuta, AtSclae, Oracle DB 19.10.x, Tableau 2021.1, Maria DB, PostgreSQL, JIRA, Jules, GAIA internal Cloud, Windows Servers 2019, GITHUB, STASH
• Led cross-functional teams for the successful completion of major projects, resulting in increased efficiency and client satisfaction.
• Cultivated strong relationships with key stakeholders, including customers, vendors, regulators, and community leaders to promote collaboration and long-term success.
• Demonstrated proficient leadership skills to motivate employees and build competent teams.
• Established and maintained strong relationships with customers, vendors and strategic partners.
• Collaborated with senior management to develop strategic initiatives and long term goals.
• Managed financial planning and budgeting processes, ensuring fiscal responsibility and maximizing return on investments.
• Established a culture of continuous improvement, fostering innovation and driving sustainable growth across the organization.

• The company initiated key Strategic project to bring Finance, Operational, Sourcing and Headcount metrics in a single platform for the management to predict, plan and act
• Developed comprehensive documentation to facilitate knowledge sharing among team members and support long-term maintenance efforts.
• Interact with business representatives to define Business and Functional Specifications
• Optimized resource allocation by effectively prioritizing tasks based on business needs and project timelines.
• Built strong relationships with stakeholders, ensuring clear communication channels for project updates and progress reports.
• Collaborated with product managers to define technical requirements and develop innovative solutions for complex problems.
• Enhanced application performance by identifying bottlenecks and optimizing code.
• Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.
• Enhanced security posture by conducting regular code reviews and integrating security best practices.
• Enhanced collaboration between development and operations teams, promoting DevOps culture.
• Participate in the user requirement gathering and determine level of effort
• Implemented Qlik Sense, Tableau, OBIEE and FR reporting applications for various business groups
• Developed critical financial reports such as Income Statement, Balance Sheet, Cash flow statements which are used by Executives to make business decisions
• Partnered with user interface designers, web developers to build Java portal which is one stop solution for multiple reporting tools
• Integrated QlikSense, Tableau and OBIEE Dashboards into one portal so users have one place to access all dashboards from various tools/data sources, security provisioning, governance, audit, usage tracking & support
• Responsible for UI /UX customizations on Qlik Sense and OBIEE reporting tools to meet Verizon custom theme standards
• Enabled Dashboards on smart devices (iPad & iPhone)
• Lead 6 people team (3 onshore and 3 offshore) to support various business groups using 4 reporting tools
• Implemented Section Access (row level, column level and cell level) security for users and groups based on the individual and group responsibilities
• Develop dimensional hierarchies based on the business requirements
• Configure data connections on Qlik Sense to various data sources (Hadoop using Kerberos/Knox, HANA, Teradata, Anaplan using REST connectors, Oracle, Hyperion Essbase, SQL server, IBM DB2 etc..)
• Configured SSO on Qlik Sense using SAML Authentication
• Responsible for Qlik sense architecture and implementation of clustered environment on DEV, UAT, PROD and DR
• Created multiple Virtual Proxies, custom properties to load balance Apps between multiple RIM nodes
• Responsible for migrating Qlik Sense and OBIEE Dev environments to AWS Cloud and automations
• Perform stress test on Qlik Applications using Scalability tools (App evaluator and Analyzer) in UAT to avoid performance issues in Production
• Work on complex end user applications using Hyperion Fusion r11 Enterprise Performance Management (EPM) software including Essbase, Administration Services, Integration Services, Planning and Financial Reporting
• Use Analytics Scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages
• Migrated OBIEE application to AWS Cloud and automated it
• Reduced environment setup time from 3 weeks to 60 mins
• Responsible for POC’s like Oracle Apps, Oracle BDD, Informatica IDL, Hadoop Cluster, Narrative Science, Nprinting etc
• Adopted Dev-OPS and Agile methodology using JIRA on daily basis
• Complete code builds and unit test to validate design including documentation deliverables
• Work with Production support team to ensure issues are resolve immediately on Production
• Verizon Communications Inc., (NASDAQ:VZ), is the largest U.S wireless company and largest wireless data provider
• The company initiated key Strategic project to bring Finance, Operational, Sourcing and Headcount metrics in a single platform for the management to predict, plan and act
• Environment: QlikSense 3.2/Feb’2018, OBIEE 12c/11g, Hyperion Finance Reporting, Tableau 10.3, Oracle DB 12c/11g, Hadoop, ODI, HANA, Teradata, Anaplan, Oracle, Hyperion Essbase, SQL server, IBM DB2, Oracle Apps, UNIX , EPM, Essbase, JIRA, JENKINS, GITHUB, STASH

• Identify and document functional and derived requirements and map them to customer requirements
• Implement Enterprise Performance Management in OBIEE and Oracle EPM Suite
• Create OBIEE Repository (.rpd) which involves Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks and cache management
• Implement OBIEE delivers/Proactive agents (iBots) and configure Interactive dashboards to alert the Business/Field users as per the requirements
• Work on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page
• Configure analytics repository with logical dimensional modeling using star schema
• Use OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository
• Create complex reports by using set operations and direct database request
• Work on security for users and groups based on the individual and group responsibilities
• Develop dimensional hierarchies based on the business requirement of an attribute
• Develop security matrix for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type
• Use Analytics Scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages
• Monitor code migrations between DEV/SIT/UAT and Production environments
• Use version control tool for migrations and auditing
• Complete code builds and unit test to validate design including documentation deliverables
• Work with Production support team to ensure issues are resolved immediately on Production
• Environment: OBIEE 11g, 10.1.3.4, Oracle 11g, ODI, Oracle R12, UNIX, EPM and Essbase

• Conducted meetings with business representatives for gathering Reports / Dashboards requirements
• Complete functional and technical design deliverables
• Performed Data Warehouse analysis and identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins
• Designed and developed Analytics Metadata Repository using Oracle BI by importing the required objects into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies), Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services
• Extensively worked with BI server log files to resolve the issues
• Developed many Accounting and Collection Time Series objects for comparing the Billings, Collections and Adjustments between the different time frames
• Implemented comprehensive security functionality by creating users & web groups, setting up LDAP authentication and associating catalog objects and Web modules with the created users and groups
• Configured iBots to deliver content based on schedule, automated iBot queries to obtain daily and weekly reports
• Configured Informatica connections source DB connection and target DB connection in DAC
• Configured new customized mappings and work flows in DAC for new customized subject area
• Configured DAC to run nightly data loads on daily basis
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database
• Captured the business requirements, worked on gap analysis, and prepared the gap analysis document
• Developed many incremental ETL using Informatica mappings
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics

• Interacted with functional & technical leads, SME’s, marketing, finance, and other business groups to identify, analyze, and document business requirements
• Worked extensively with BMM (Business model and mapping) layer to develop various business models
• Worked on Siebel Admin Tool to configure the business model based on the end user requirements
• Created various aggregate tables to improve query performance
• Exposed Business Models in the Presentation Layer for querying
• Used the security settings in Siebel Analytics Administration Tool to set up Groups, Access Privileges, and Query Privileges
• Managed security for groups in Siebel Answers
• Created Dashboard prompts and criteria prompts for better understanding of the trends and projections
• Created iBots using Siebel delivers to alert the corporate users regarding the Payments
• Design ‘ad hoc’ reports for business users by way of Business Object Universes using the various Data Marts with in the new overall data warehouse project
• Designed and implemented custom business intelligence solutions (Reports) using CRM 4.0 & GP
• Designed and developed many SmartWorks Dashboards/Reports that are Dynamic & Interactive with intuitive drilldowns, drill-across & flash-based drillable charts (bar-charts, pie-charts, radars, and bubble-charts), Capabilities split reports for summary & details information, and local & global filters and cache monitor using GP
• Implemented comprehensive security functionality by creating users & web groups, setting up LDAP authentication and associating catalog objects and Web modules with the created users and groups
• Performed the Security management for users, groups and web-groups using the various authentication systems
• Enhance performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations
• Environment: Siebel Analytics 7.5.2, Siebel sales, Informatica 6.1, Oracle 8i, SQL, TOAD, UNIX and Microsoft Dynamics GP

• Gathered high-level business requirements by interacting with business analysts and end users, mapping the same into logical dimensional model in the repository
• Imported Physical tables and defined relations between Physical tables at the Physical Layer
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer
• Identified and created aggregate tables to improve query performance
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures
• Created OLAP requests with drill-down and drill-across capabilities
• Developed reports using different Analytics Views (Pivot Table, Chart, and View Selector)
• Customized Reports look and Feel using Column Formatting, Conditional formatting
• Created and customized reports using drill-across and drilling-down capabilities
• Created Interactive Dashboards, Answers and Administering Oracle BI Apps Applications
• Developed Dynamic / Interactive Dashboards and pages by creating Dashboard Prompts
• Used Ibots/Siebel Delivers to cache the most frequently used reports to improve response times
• Implemented Object level security as well as Data level security, identifying the groups and their permissions and privileges as per business needs
• Environment: OBIEE 10.1.3.4.1, Oracle BI Apps 7.9.6, Oracle 9i, Windows 2003