Data Manager

Jeevan Vootukuru

Senior Data Warehouse / BI Architect / Technology Delivery Manager

908-***-****, adi52s@r.postjobfree.com

Summary:

●Over 20+ years of extensive IT experience in design, development, testing, maintenance and documentation of Enterprise Data Warehouse and BI applications using various technologies with diverse set of client’s analyzing complex business requirements and mapping them to the system specifications.

●An expert level data architect with extensive database system analysis, design, and implementation experience.

●Extensive experience in requirements gathering and business rules analysis, conceptual/logical/physical database, model validation/business rules traceability analysis.

●Been an integral part of every phase (analysis, design, testing, implementation) of database projects using every common type of data store – transactional (OLTP), ODS, data warehouse (Kimball/Inmon), and Data Mart (OLAP).

●Hands on database system construction experience to include stored procedure construction and testing, extraction/transformation/loading (ETL) design and implementation, report development, database system troubleshooting and performance tuning, database configuration and administration.

●Focus on bridging the “business-technology gap” that seems to appear in many organizations by simultaneously acting as a liaison between the two “worlds”, demonstrating/facilitating more formalized business functionality requests, building trust, focusing on delivering business value as quickly as possible, and developing/mentoring technical teams such that they are more aware of business needs and, often, the more advanced analysis/design/development techniques needed to meet those needs.

● Expertise in building Data-lakes and creating infrastructure for ad hoc data analysis inHDFS/S3 with Hive/Hbase and Presto serving engine

●Experience in migration of On-prem ETL jobs to AWS Cloud, using Apache Spark,EMR, S3, Athena and other cloud tools

●Strong skills on project planning and management, monitoring, control and team building, strong leadership qualities. Ensure the appropriate metrics, resource planning and program management methodologies are applied to drive success

●Drive the usage of SDLC, Agile, and other key measures to significantly improve project delivery.

●Providing operational management overview and drive productivity improvement initiatives.

●Proven ability in leading complex data loads and huge volumes of data (TB to PB in Teradata, Oracle Exadata,Vertica, DynamoDB and Netezza)

●Experience in data-analysis using Python, Jupyter, PySpark with moderate visualization

●Proven ability in Designing, Optimal Performance and Scheduling of Report Packages in a Reporting Environment . Migration of Reports from Legacy Platforms and also migration between Reporting Tech stacks

●Professional in creating prototypes (Static & dynamic UI with HTML 4), Mock-up wireframes, POC’s (Proof of concept – Third Party Software’s/Technology packages) and story boarding for risk minimization.

Education & Certifications:

●B.E in Computer Science (1993 – 1997)- Sathyabama Engineering College, Chennai, India

●HDSE – Higher Diploma in Software Engineering – Aptech, Chennai, India

●Underwent Six Sigma Training with Igate Global Solutions

Professional Experience:

CLS Bank, New Jersey April 2019 – till date

Technology Consultant

•Description: Working as a Solution Architect part of Data Engineering team supporting various Post settlement regulatory Reporting and Analytical analysis of the CLS Products

•Participated in Model Design and solutions for various projects in current InfoHub DW implementations in SQL Server and ETL frameworks in SSIS

•Mapping of the source system flows(~12 systems) in the current state InfoHub DW

•Build a Future state architectural roadmap for Infohub DW migration to AWS platform and technical stack selection for mapping the various components needed for the orchestration of the DW

•Piloted the selection of RDS Databases(Aurora MySql/PostgreSql) and DynamoDB for CLS’s User authentication application

•Piloted the selection of Replication Tool stack(IBM IIDR/AWS DMS/HVR) for ODS platform from the core DB2 application databases used

•Piloted a ETL framework for setting up a Data Lake using AWS Data Lake Formation for all the source systems data landing in Cloud

•Worked with the JIRA team to implement customized SDLC workflow for each tasks performed by the team members

•Built a CI/CD pipeline in Bitbucket source code versioning and auto-deployment migration process for various objects (SSIS Packages/Scripts/DDL/DML)

•Templatized a Portfolio Dashboard of all Projects status executed by the InfoHub Team and presented to the senior management on the progress made by the team

•Overviewed and adhered the GDPR compliance within the team governance responsibilities

QBE Insurance, New York Oct 2018 – March 2019

Technology Consultant

Description: Worked as Application Development Lead managing a three month pilot to come up with a migration strategy from On Prem Application Architecture to Microsoft Azure Cloud Platform

•Produced the technology stack across different stages in buildout of the new cloud platform in Azure defining the criteria with Pro’s/Con’s

•Build a multi-year roadmap/Execution Strategy of QBE Data Insights ( all source systems) and impact analysis to the current transformation projects which are currently in flight

•Managed the Forecast/Actuals of the resources in the QBE internal platforms

•Pilot using IBM Truven Anayltical Dataset to the Cloud using Big Data Platform as a Apache HBase Data Store (Spun out of HDInsight Azure Platform) with Scala Scripting and Spark Sql from Databricks

•Build Analytical Reports/Dashboard using the power of Spark SQL from Databricks Notebooks using Scala/Python Scripting language

•Use Azure Data Factory to schedule the Databricks notebooks

BNY Mellon, New York Jan 2017 – Sep 2018

Vice President

•Description: Worked as Application Development Manager (ADM) part of the Regulatory Reporting Technology Team. Built . Reg Tech team supported the overall delivery of the Reg reports submitted globally using Wolters Kluwer Financial and AxiomSL application Suite.

Responsibilities:

●Involved in the technical design discussions to develop the application in the team environment.

●Single point of contact for Business & Business Analysts, as far as the queries related to the requirements and designs.

●Logical and Physical Modeling using Canonical Models to fit the needs of the requirements

●Implemented the end to end ETL / BI Design Standardization across different teams

●Rollout of Vertica Analytical Data Store for Transactional data from ~250 Application Source Systems and Processed data (US BASEL III Results, US Call Reports, EMEA Liquidity Reporting etc)

●Implemented Standardization of Verica data loads according to Volumes (MB to Terabytes) of Data.

●Setup Best Practices of usage of Vertica and Pentaho ETL tools

●Managed the AxiomSL Vendor Relationship and executed 1M SOW which comprised of initial setup of Servers and Rollout of the CCAR 14A/14Q & 14M Reg Reports

●Build Canned Reports/Dashboards using AngularJS & Rest API’s.

●Rollout of Self-Service Reporting capabilities using Open source JasperSoft Reporting toolset for Operational Reporting Needs

●Provide effort & cost estimations for the requirements and build the project plan (including the resource wise timeframe for prototype development, unit testing, UAT, performance testing)

●Managed a 4 Member Onshore and 6 Offshore development team comprised of ETL, UI and BA’s

●Built a Data Governance framework for the Regulatory data working with business representatives using Collibra for Domain/Data Lineage and used Informatica IDQ for monitoring the Data Quality.

Sirius XM Satellite Radio Inc,New York July 2015 - Dec 2016

Consultant – BI Architect

Description: Working as a BI Architect supporting the Reporting and Data Integration needs of Marketing and Finance Functions.

Responsibilities:

●Involved in the technical design discussions and design/develop the Data Marts/Operational Data Stores in the team environment.

●Logical and Physical Modeling of the Data Marts/Operational Data Stores to fit the needs of the requirements

●Rollout of Vendor Scorecard/Dashboard of all the Sirius XM Call Centers (Inbound, Outbound & Care )

●Prototyping of the Software AG’s OneData Application to implement the Reference Data implementation for Reporting/Marketing team needs.

●Rollout of Vertica Analytical Data Store/Lake for Customer 360 Reporting . Data Ingestion Framework to source all data from different EDW/ODS (Teradata/Informatica)

●Designed hybrid data lake on S3 and on-prem HDFS for access to inter-team and other departments seamlessly

●Designed/Developed a state of art ETL-Lib using Python, so that team can easily compose pipeline to perform several ETL activities, without having to burn themselves with building several shell scripts and managing for AWS Components

●Python ETT-Lib provides the capability and power Shell Scripts & HDFS actions, so that team can reuse lot of common activities

●Migrated existing analytical workloads from Vertica and Teradata to, On-prem Cloudera cluster for BI Workloads, using Hive and HDFS and to AWS using S3 and Athena.

●Built lean and sustainable ETL pipeline using Apache Spark, and Hive to enable cloud native support and reduce dependency on Informatica server

JP Morgan Chase, Hyderabad - India June 2014 – May 2015

Vice President

•Description: Worked as Application Development Manager (ADM) part of the Info Management (IM) team performing different roles ranging from Data Architect, Technology Delivery Manager for the DW / Reporting teams within the CCB- Mortgage Banking Line of Business technology teams. Evaluated the financial data quality, processing framework, data sourcing, governance structures, data variables mapping, and data validation reports for CCAR/DFAST reporting from Mortgage Banking applications to the Risk Application teams

Responsibilities:

●Involved in the technical design discussions to develop the application in the team environment.

●Single point of contact for Business & Business Analysts, as far as the queries related to the requirements and designs.

●Logical and Physical Modeling extending the IBM BDW Model to fit the needs of the requirements

●Coordinated the data mapping, cleansing rules and data migration capabilities in support of Customer MDM initiatives.

●Implemented the end to end ETL Design Standardization across different teams

●Implemented Standardization of Teradata (TPT Streams) according to Volumes (MB to Terabytes) of Data.

●Setup Best Practices of usage of Teradata and Informatica using PDO’s

●Provide effort & cost estimations for the requirements and build the project plan (including the resource wise timeframe for prototype development, unit testing, UAT, performance testing)

●Offshore Co-ordination of the Development Work

●Application Development Management of the ~40 FTE ETL/Reporting FTE Team plus 45 member Vendor Resources

Bank of America, Chennai - India May 2011 – April 2014

Assistant Vice President

Description: Worked as part of the Global Wholesale Banking Technology Line of Business performing different roles ranging from Data Architect, Technology Delivery Manager and People Manager for the DW/BI Reporting teams within the Sales and Performance Tools and the EMEA Globalization of Reporting Team of the Organization.

Worked as part of Internal Audit team in the Scoping, Planning, Fieldwork, Design Effectiveness (DEA), Operational Effectiveness (OET), Reporting, Issues Management, of Regulatory initiatives related to CCAR, Dodd Frank and BASEL

Responsibilities:

●Logical and Physical Modeling Data Modeling of the Data Mart

●End to End Solution Architecting /ETL Designer

●Single point of contact for Business & Business Analysts, as far as the queries related to the requirements and designs are concerned.

●Coordinated the data mapping, cleansing and data migration capabilities in support of Customer MDM initiatives.

●Provide effort & cost estimations for the requirements and build the project plan (including the resource wise timeframe for prototype development, unit testing, UAT, performance testing) in MPP

●Headed Architecture/Design Review Panels across different projects

●Offshore Co-ordination of the Development Work

●Managed and Executed RFP’s working with Vendor groups to setup a team from bottom-up

●Managed 24/7 Application Support team supporting 35 BI/DW Application/Outbound teams

●Application Development Management of the 18 ETL/Reporting FTE Team plus 45 member Vendor Resources

Virtusa Corporation, Chennai - India Oct 2010- Apr 2011

Senior Architect - Technical Delivery Assurance – DW BI Practice

Description: Worked as part of the DW – BI Practice and contributed as Technical Delivery Assurance Head for the Practice.

Responsibilities:

●Delivery management – Process, Quality & track CDI ( Customer Delight Index)

●Headed Review Panels ( Data Modeling, Design and Code) across projects

●Setup Technical Domain Based training curriculums for the entire Practice

●Pre- Sales support

Bank of America/Merrill Lynch – SGA Consulting Group,New Jersey

ETL Designer/Architect Nov 2009 to Sep 2010

Description: Worked as part of the Compliance Data Warehouse Team. Worked on a Project to get Market Data (~250 Exchanges) into the DW which in turn would be used by the Actimize Modeling team to raise alerts and checks on the BOA’s orders and executions done in the Proprietary Trading Systems. Source for the Market data is to use BLOOMBERG API service to get all the related information.

Responsibilities:

●Logical and Physical Modeling Data Modeling of the Data Mart

●End to End Solution Architecting /ETL Designer

●Offshore Co-ordination of the Development Work

●Performance Tuning of Informatica Mapping

Fortress Investments LLC – Private Equity, New York Dec 2008 – Oct 2009

BI Data Architect

Description: Involved in setting up a Business Intelligence platform for the Private Equity group of the company. Investran GL was the main source for reporting within the PE group. Integrate a DW around the Investran GL and non-database sources such as Projections data/ Market Data Systems (Bloomberg) etc. to be integrated for Reporting

Responsibilities:

●Building Infrastructure for the Reporting Platform

●Design and Develop ETL’s / Reports & Dashboards

●Extensively designed the ETL’s using SSIS for the integration of the different data sources

●Extensively designed the Business Objects XI & SSRS 2005 Reporting Platforms

●Integrated Report Delivery with Microsoft Share Point Document Management as well

●Created Processes and Escalation Procedures around the DW Operations

Lehman Brothers – IMD Client Reporting, New Jersey Nov 2007 – Sep 2008

Senior ETL Consultant – Open Systems

Description:

RDS DW is one of the Subsystem of Wealth Management Reporting initiative within IMD.The goal for the WMR Initiative is to attain core competence in client reporting for IMD High Net Worth Individuals (HNWI). Data Warehouse also maintains the all the Reference Data for the whole of IMD Client Reporting and as well maintains a central Reporting Data Store(RDS) for all the Alternate Investments which include Private Equities, Hedge Funds etc.

MSCI Barra is a leading provider of investment decision support tools to investment institutions worldwide. MSCI Barra products include indices and portfolio risk and performance analytics for use in managing equity, fixed income and multi-asset class portfolios. Quant Team in IMD was interested in maintaining the DB models of their 2 Products: Barra Integrated Equity Model and Single Country Equity Models. Analysis of individual assets from 56 equity markets and 46 fixed income markets to uncover the factors that contribute to their risk are supplied as feeds which come in at various hours in a day.

Responsibilities

●Involved in Re-architecturing the current ETL’s and performance tuning the current processes

●Extensively designed the ETL’s using Informatica for the integration of the different data sources

●Created Processes and Escalation Procedures around the DW Operations

●Involved in Performance Tuning the Models by adding respective Indexes etc.

●Involved in Architecturing the process and prepared the relevant Technical Specs for the entire Project implementation.

●Co-ordinated the effort of putting in WSDL’s for the Outbound process and providing it as a Web Service using Informatica 8.1.0 Webservices Hub.

American Stock Exchange, New York Nov 2006 – Oct 2007

ETL Designer/Architect

Description: AMEX DW is part of the Regulation Technology team of AMEX. Data Warehouse maintains the Equities/Options Post Trade information. All FINRA Reports (formerly known as NASD) where facilitated out of the Warehouse. Other kinds of outbound reports right from billing, Merged Order Logs, REGNMS reporting, Booths, Specialists & Market Maker Reports are generated out of the Data Warehouse. Datawarehouse plays a very critical role in the AMEX organization.

Responsibilities:

●Data Modeling /Architecting the DW/Data Marts

●Change Control/ Production Support Management

●Production Migration of Informatica and Oracle Objects

●Created Processes and Escalation Procedures around the DW Operations

●Admin to the Informatica Repository and maintenance of Informatica product

●Offshore Co-ordination of the Development Work

●Supported Daily Operations(Production Support) with the team of 12 people

●Performance Tuning

Merrill Lynch – Investment Banking Technology, New York July 2005 – Nov 2006

AVP - ETL Designer/Architect

Description: Data Warehouse maintains and integrates many Investment Banking Applications right from Banker’s Calling Activity to Clients, Student Recruiting Calling Activity, Revenue Bookings from Deals, Expenses from Deals, Monthly Head Count tracking of IBK Employees, Cost Center Related Expenses, Dealogic Market Data related to all DCM,ECM,Loans and M&A Deals and many other Inverstment Banking systems. Banker/Client Dashboards and Detailed level Reporting was built around the DW using Cognos BI capability and ASP.net platforms respectively.

Responsibilities

●Actively participated with Business for the initial design phases.

●Built Advanced Logical and physical DM around Star Schema models from the requirements.

●Maintained the Models in Erwin 4.1.4 Data Modeler /Model Manager

●Co-ordinated and lead the ETL development Team with the help of Offshore/Onshore teams

●Extensively used Informatica for the integration of the different data sources

●Upgraded Informatica 6.x to 7.x version

●Admin to the Informatica Product within the group

●Created Processes and Escalation Procedures around the DW Operations

●Supported Daily Operations(Production Support) with the team of 5 people

GE NBC Universal – Igate Global Solutions, New York June 1999 – Jul 2005

Project Leader / Onshore Co-ordinator

Description: Worked in multiple projects as a ETL(Informatica)/BI (Business Objects) Project Leader / System Analyst from iGate Global Solutions, involved in the designing, coding and maintenance of DW systems in Corporate Applications covering HRW, Music Rights Clearance System, Reporting of Capital Planning & Fixed Assets and Query Payroll System of GE-NBC Universal, New York City, NY.

Pentafour Communications Ltd, Chennai - India Nov 1997 – May 1999

Systems Analyst

Description: As a Systems Analyst for Pentafour Communications Ltd., involved in the Design, Coding, and Database Maintenance of Enterprisewide Resource Planning (ERP) for TVS SUZUKI LTD., TAMIL NADU. The project is concerned with the computerization of Inventory, Finance, Marketing and Operations systems of the whole organization.

Responsible for Module leader of the Marketing system, Involved in design of various functional units, design of the User Interface using Visual Basic 5.0

Contact this candidate