Senior Manager
Silicon Valley Bank
Total years of experience :26 years, 11 Months
Spearheading Enterprise BI Reporting, Analytics and Support, Maintenance & optimization for Enterprise Data Warehouse (EDW) Enterprise Business Intelligence (EBI) functions, catering to ~ 1, 500 users across the organization
Driving multi-location team of over 40 team members, with end-to-end responsibility for managing Enterprise Data Integration and Reporting services, with annual operational budget of over USD 5 million
Implemented Enterprise Business Intelligence organization from scratch to manage key verticals within the bank - Payments and Risk, Finance and Accounting, Private Equity and Global Operations
Implementing process framework, standards and metrics to evaluate vendor deliverables in areas of SDLC process - Development, Production Support, BCP. Established process to manage the gaps and conflicts that arise in multi-vendor environment
Working closely with business stakeholders, senior management, business users and vendor resources to define process, approach and strategy for enterprise application integration, data and analytics systems. Some of major successes include major application upgrades, complex enterprise solutions, major data centre migration project
Defined and implemented consistent communication framework to monitor production service slippage, performance across various business verticals in multi-vendor environment
Leading a multimillion dollar data migration project for the largest Auto finance in North America. As a Data Migration Lead responsible for working with multiple vendor technical teams, business teams and leadership in the overall development and implementation strategy. This includes setting converged platform environment and roadmap, help to decide on methodology, and provide subject matter expertise on all facets of the project
Migrating 5 million customer agreement, with asset value of $90 billion from legacy mainframe environment to best-of- the-breed asset financing platform.
Managing the business requirement discussions, Data mapping sessions, cross-functional meetings, technology meetings for the project
Implement and manage Data Cleansing strategy in the legacy mainframe environment
Implement and manage data governance framework supported by data quality framework for the program
Identify project issues & risks and develop mitigation plans. Escalate issues and risks as appropriate
Build out and manage the project plan including detailed tasks, hours, resources and dependencies
Identify issues that would require a Project Change Request
Prepare project status reports and technical documents
Coordinate with technical resources for Change Management and Request For Change (RFC) processes
Coordinate project team meetings including meeting logistics, agenda and meeting minutes preparation
Manage weekly and monthly project reporting and project presentations to various levels within the organization
Deep experience in auto and Mortgage financing
Manage onshore/offshore resources
Leading Business Intelligence team to support $ 6.2 billion State / Municipal Bond program for Los Angeles County College district (Build-LACCD). Work closely with senior program managers and business users to define implementation approach to deploy Program Management Information System (PMIS) and downstream data reporting systems.
Revamping current Oracle based BI system to meet the new strategic goals defined by the Program Management Office (PMO).
Provide solution roadmap to implement Proliance for 2, 000+ projects, to migrate legacy data from various legacy systems into Proliance applications, to integrate Proliance to both District’s G/l (SAP) and PMO G/l (Costpoint).
Define Data Warehouse star schema to support management, regulatory and operational reporting to measure Bond Performance, Project Schedule and Earned Value at the project level.
Define SharePoint Framework to deploy management and operational dashboards.
Design and deploy Mobile BI solution (iOS and Android) to support management reporting.
As a member of the management team, lead the enterprise Business Intelligence team that supports more than 1, 000 users across various business units that constitutes both retail and mortgage bank. Managed a yearly budget of close to $ 1 million that includes both Capital Expenditure and Maintenance projects Worked closely with senior management and business users in defining the process, approach and strategy for data and reporting systems in alignment with the business / corporate strategy. Implemented industry best practices that reduced overall cost of ownership of enterprise data and reporting infrastructure. Key implementation includes master data solution and enterprise customer view. Defined a roadmap to implement Data Governance for Servicing Data Warehouse. Developed and maintained key relationship with vendors supporting the environment including BI tools and technologies.
As a manager within Accenture Information Management Services (AIMS) team, played an important role in delivering critical projects for Accenture clients. Co-lead delivery for global reporting system for a leading insurance company based out of Chicago. In addition to responsibility as the overall technical manager, also assumed shared responsibility for the overall delivery of the project. Responsibilities include: - Driving the day to day work plan and execution schedule for the overall project - Ensuring that all pieces of the program interoperated together for the delivery of information to the end users - Defining the Enterprise Warehouses refresh strategy and schedule - Managing overall project risk - Negotiating program scope change with client counterparts - Driving the definition of the overall solution - Defining ramp-down plan and transition of skills/responsibility to client resources - Delivering detailed daily and summary weekly status updates to Sr. Program leadership
As a Technical Manager, provided technical leadership to clients in Insurance, Travel and Hospitality and Financial Services Industry. Following are the project summary and key responsibilities undertaken - Lead the technical team to design and architect the Core Data roadmap (6 years) to support the corporate strategy. Core Data encompass all data related initiatives including Customer Data Integration, Data Mining, Enterprise Reporting and Master Data Management. - Estimated ROI for all core data initiatives by gathering total cost of ownership for existing and to-be process processes and tangible business benefits - Provided guidance and support to create vendor evaluation package including Proof-of-concept for evaluating vendors in CDI, Enterprise Reporting and Data Mining tools space. - Primary responsibilities include designing appropriate architectural approaches, selecting suitable tools and technologies for following tracks - BI Reporting, Data Mining, Customer Data Integration (CDI), Enterprise Service Bus and Master Data Management (MDM) to support corporate and business strategy. - Designed RFI and RFP questionnaire for various core data initiatives - Enterprise Reporting, Data Mining, CDI and MDM - Work plan and resource leveling for all the initiatives in the first year of the roadmap based on Rational Unified Process (RUP) methodology - Collaborated with client executives and technical staff to align various architectural approaches around enterprise data warehouse (Inmon Vs Kimball), data migration, data integration and CDI/MDM (Traditional Vs Contemporary) - Worked with senior managers of the client team on the vendor evaluation through RFI process and vendor presentation for all the tracks mentioned above.
Technical Manager - Data Warehouse & Business Intelligence Indymac Bank - Primary responsibilities include managing Data Warehouse and Business Intelligence team, troubleshooting production issues, validating the architecture of various systems in development, performance tuning existing application in production - Manage the delivery of capex projects ( $1 million) through onsite-offshore delivery model. - Maintain Cognos 8.1.x reporting infrastructure for more than 2, 000 enterprise users. The implementation was also tested for various delivery including PDAs and was tested for 100 concurrent users through Mercury Testing Center. The server architecture was load balanced to handle request users from all over the North America - Strategic and technical approach to migrate Crystal and Cognos 7.x reports to Cognos 8 platform - Cognos migration approach for version 7.x Impromptu and PowerPlay reports - Initiate and take ownership of Data Architecture including Dimensional modeling - Interact with business on day-to-day basis in terms of managing the expectations for various projects, selling DW&BI concepts. Project Lead / Architect John Deere - Primary responsibilities include architecting end-to-end data warehouse implementation for serialized product tracking (industrial equipments), SOX data marts and reporting. Responsibilities include Data Architecture, Dimensional Modeling, BO Universe Design validation - Performance tune Business Objects reporting application, IBM DB2 7.x database (on z/OS) - Identified and implemented design changes to existing Informatica ETL mapping for improving performance. - Manage the delivery of all development projects through onsite-offshore delivery model. - Performance tune Business Objects 6.5 enterprise-wide infrastructure - Interact with business on day-to-day basis in collecting business requirements, validating the delivery and managing project tasks and activities. Data Warehouse Architect The Toro Company - Short-term consulting effort, to basically provide an architectural approach to migrate existing Crystal reporting infrastructure to Business Objects platform. - Define approach for redesigning existing data architecture to meet the needs of snapshot requirement for the business - Database technology include Oracle 9i with reporting on Crystal and Business Objects Project Lead / BI Performance Architect Union Bank of California - Performance tuning Oracle 9i database (10 yr history) through partitioning, indexing and aggregation to meet report performance requirements - Other responsibilities include performance tuning 40+ Business Objects reports to meet the performance requirement of less than 60 seconds from anywhere within the corporate network infrastructure. Remote users access the reports through Citrix server, the recommendation also include improving the Citrix web farm architecture and its communication with Business Objects and Oracle Data Warehouse servers - Also lead the performance team that was in charge of Informatica ETL mapping tuning along with reports. - Technologies include Oracle 9.0.2, Business Objects 6.5 and Informatica PowerCenter 6.0 Data Warehouse Consultant Liberty Mutual - Short-term assignment to create a roadmap to consolidate the entire reporting requirement on Brio and Hyperion platform - Reports were spread across various reporting tool including Microsoft Excel. Project Lead / Data Warehouse Architect CNH Global - Primary responsibilities include end-to-end implementation of Internal Reporting System using Oracle Express and OFA. - Designing inter-entity balancing rules, SGA allocation methodology and allocation of other assets to key dimensions - The reporting implementation would extract data from multiple GL system from all the global divisions and consolidate in single database. - Apply various dimensions and provide the report in multiple currencies to be used across various divisions throughout the world
At Tata Consulting, played multiple roles including Senior Systems Engineer, Business Analyst and Project Lead. Following are the project summary and responsibilities in various assignments OLAP Consultant / Web Designer Client: Givaudan, Switzerland - Project involved creation of Ingredient Manufacturing System that will monitor the effectiveness of various chemical mixture and composition in fragrance manufacturing - Deployed the BI reporting solution through web browser. Involved in extraction of data from the sources to the warehouse tables using Ardent Datastage and the transformation being carried out by PL/SQL routines - Developed reports in Cognos Impromptu Web Reporter with associated prompts developed using PowerPrompt. - Application for writing into database was developed using HTML and JavaScript (front end) and Servlets (back end). Security or Authentication of user is done through Light-weight Directory Access Protocol (LDAP) of Netscape Suite Servers. Business Logic of the application was placed in Websphere AS. - My responsibility in the project was to be part of the DW modeling & design team. Also created web application to write manual data into the database directly Developed reports on Cognos Impromptu deployed on web using IWR. The canned reports were accessed through browser ‘ad hoc’ by using Cognos PowerPrompts. SAS Developer Client: HR Division/Tata Consulting - Project involved the development of a Data mart for the Corporate HR Division to analyze the over-all performance of the Employees. - Raw data present in Oracle Database was transformed and loaded into the SAS System. Data was classified into modules like Employee’s Personal Profile, Promotions, Appraisals, Loans, Qualifications and the like. - Data Extraction, Cleaning and Transformation were carried out on the data and stored in one single flat file. The final measures were Performance Rewards and Appraisals. - A front-end application was developed using SAS / AF (Application Frame). The Analysis was carried out by SAS / INSIGHT. - An Automatic Data Loading System was developed to facilitate a user-friendly population of data into the SAS System. SAS Developer Client: FoodWorld (Grocery Chain) - Project objective is to identify the loyal customers for the supermarket located in different geographic locations - Market basket analysis were designed and applied on the available samples - Identifying sample data, selecting the best sampling technique to represent the whole population of customers were key activities in the project - Statistical analysis were used include clustering, decision trees, linear and logistic regression, and neural networks
- As MIS engineer for the smelting division was completely responsible for executive reporting on the manufacturing process.
- Developed reporting software applications in FoxPro for DOS operating systems. Also, worked on converting one application to Visual FoxPro 3.0.
- Responsible for delivering the daily, weekly and monthly reports to the senior management
- Additional responsibility includes generating extensive statistical parameters on potlines, applying statistical tools to the generated data. The above roles were part of the information model designed for the smelter division
- Member of team that was responsible for 'Change Management' when MALCO went for computerization and modernization
- Undergone intensive training in all operations of process manufacturing.