Candidates About

CAREER OVERVIEW:

Senior Level Information Technology Experience in BIG DATA, Data Warehousing, Business Intelligence, OLTP Applications. Involved in complete Life Cycle (SDLC, Agile, and Waterfall) Development Model for the large size Data Warehouse in HADOOP, NETEZZA, ORACLE environments in the capacity of Enterprise Information, Solution and Application Lead/Architect. 

AREAS OF EXPERTISE:

v  Enterprise BIG DATA/HADOOP Architecture/Lead v  Extensive ETL and RDBMS Experience. v  Lead the major BIG DATA Projects. v  Production Support Experience. v  Strong collaborative and Coordinating skills v  Structured query language (SQL) expert v  Extensive understanding Financials Industry Data Domains and Instruments/Products Ø  Wholesale: Wholesale Loan, Traded Products(Derivatives), Business Credit Cards Ø  Retail: Home Loans, Credit Card, Auto Loans, Speciality Loans. Ø  Reference Data: Customer Domain, Product Domain, Industry Domain etc. v  Financial Industry Regulatory Reporting Ø  CCAR Ø  FRY 14 Ø  Risk Appetite Ø  CFO Reporting

v  Strong Data Modeling skills v  Strong analytical skills v  Strong Data Governance experience. v  Effective Presentation and Walk thru Skills v  Quicker Adoptability to new Technologies and Concepts v  Capacity and Scalability planning v  Excellent problem solving skills v  Programming and Design skills v  Product Evaluations.

EDUCATION:

 

·         MS: Computer Science

Western Michigan University

 

·         MBA: Masters of Business Administration

Jamnalal Bajaj Institute of Management (JBIM), Mumbai, India

 

·         BE: Bachelor of Engineering

Bangalore University       

 

ACCOMPLISHMENTS:

 

BIG DATA Architecture/Lead

 

§  Leading the effort on migration of all Risk Applications to BofA Enterprise HaaS (HADOOP as a Service) Hadoop Platform currently on HSP Hadoop, providing various strategies for Storage/Capacity Planning, Directory Configurations and Mappings, Security, Staggered Move, Tactical Sourcing

§  Lead participant/contributor in HaaS Infrastructure Resource Planning for Risk Applications in terms of Node Servers, HDFS, Containers, VCores, Memory, Encryption and Resource Pools.

 

§  Successfully lead the effort on the Directory Structure/Topology Design for Hadoop HDFS and Edge Node for a multi-tenant environment.

 

§  DATA MOVER Utility Framework: Provided the detail Framework Design for moving data between Hadoop environments/Clusters in Automated fashion starting from Request to Delivery of data to target environment, with required GIS Controls, Logs and Audits.

 

§  One of the Core contributors to Big Data Architectural Standards and Best Practices.

 

§  Conducted the Hadoop Eco System Tools and Concepts Evaluations involving extensive Testing, Validations and Defining/Executions Proof of Concepts.

 

§  Evaluated the Products for Computational and Write intensive CCAR Modeling use cases in terms of scalability, inter-activeness and the cost. Some of the NoSQL products evaluated were Cassandra, HDFS, HBase and Mongo DB.

 

BIG DATA Implementations

 

§  Leading the team of Developers/BA on end to end Planning, Design and Implementation of ETL on HADOOP Platform for Bank of America in the Enterprise Risk Technology Space, for Retail and Wholesale Data, using Map Reduce, HDFS, Hive, PIG, SQOOP and OOZIE.

 

§  Significant contributions across various streams of HSP-to-HaaS Risk app portfolio migration efforts, including capacity analysis and migration planning, target state DR proposal,  recommendations for various options of data integration (sourcing and provisioning) with Hadoop - as well as non-Hadoop – based apps.

 

§  Integration of Non-hadoop systems with Hadoop systems: Worked extensively to understand, analyze and devise the tactical and strategic integration use cases on HSP and HaaS, for tools such as SAS, R, Matlab and Other Data Exploration tools such as Toad, Hue etc, working along with Platform and Application Teams.

 

Financial Data Warehouse/Data Mart

 

§  At Wells Fargo lead the Data Architecture/Integration and development side efforts in mission critical FOMC/GL Integration Project for merger of legacy Wells Fargo and Wachovia systems, part of Wells Fargo Finance Data Mart/Data Warehouse.

 

§  Closely worked with BI team in developing and understanding Data Marts from database point of view for FACT and DIMENSION tables, STAR and SNOWFLAKE Dimensional data models. Followed the Netezza Best Practices in Design and Development.

 

DATA Modeling

§  Working extensively on Logical/Physical Data Modeling, Data Lineage, Data Flow Diagrams, Application Architecture Designs, developing Data Strategies, Data Tools Assessment and Selection, Information Security, Data Standards and Best Practices, for mission critical Applications.

 

MPP Systems

§  Lead the Design and Development of ETL and Reporting Projects on NETEZZA Mustang & TwinFin 12, 24, 36 Data Warehouse Appliance, Extensively used nzSQL for DDL, DMLs,  nzPLSQL for Stored Procedures, Performance Tuning techniques, for Risk Accounting View Application.

§  Worked extensively onto converting Adhoc SAS Based Process to Netezza based Automated Process, improving the SLA significantly with extensive mandated controls and audits in place.

§  Contributed to migration of EDW Oracle 10g Db to Netezza TwinFin 36 for better performance and reduce data latency.

 

OLTP/RELATIONAL Applications

§  At BofA, lead the Design and Implementation of EAA Quantitative Risk Technology Application for Quants to define and execute the Model execution in real time.

§  Design and Developed the Relational Data Model for Netezza and contributed extensively to the design of UI.

 

 

 

 

 

 

 

TECHNICAL SKILLS:

 

PLATFORMS/OS: o    Hadoop CDH 5.8 §  (HDFS/YARN/SPARK/MAP REDUCE) o    Red Hat Linux o    UNIX o    Oracle/Exadata 12 o    Netezza o    SQL Server o    Teradata	TOOLS/UTILITIES: o    Apache Spark o    Hive o    Pig o    Sqoop o    HUE o    Sentry o    Oozie o    Autosys r11 o    Power Designer o    ER Win o    TOAD o    Talend ETL o    PowerPoint o    Visio
LANGUAGES/SCRIPTS: o    C++ o    Java o    Spark o    SQL o    PL/SQL o    SAS o    UNIX Script	METHODOLOGIES: o    SDLC o    Agile o    Waterfall

TRAINING:

·         Hadoop Architecture and Development

·         Apache Spark with Scala.

 

WORK EXPERIENCE:

 

May 2011 to Current         BANK OF AMERICA, Enterprise Risk Technology, Charlotte

                                                Enterprise BIG DATA Architect

 

·         HADOOP Implementations: As a lead technical resource for Data Sourcing of ASPEN Project, designed and implemented BIG DATA/MPP ETL solutions on APACHE HADOOP CLUSTER (CDH)   using MapReduce, HDFS, SPARK, Hive, PIG, SQOOP and OOZIE, to achieve performance gains.

·         Designed/Developed  ETL process and standards using HADOOP Ecosystem - Sqoop, Hive, PIG and Oozie to benchmark high-volume data extracts from Teradata into Netezza for complex systems. Familiar with HADOOP Architecture, HBase, Flume, Zookeeper, Fair Scheduler, Impala, HUE.

·         HaaS Migration Efforts: Analyzed/Devised/Conducted/Documented the discussions on various aspects of HaaS migration of Risk Applications such HDFS and Edge Node Capacity Planning, initial efforts estimations, DR, Application Integrations etc.

·         Analyzed and devised various scenarios of Risk Applications Staggered Migration and detailed out tactical solutions for migrations and data sharing. HS2 vs. BDR vs. SFTP Options for tactical sourcing of upstream data.

·         HADOOP Enterprise Application and Solutions Architect Information Architect for Enterprise Risk Data Domain. Working extensively on Strategies/Certifications for Authorized Data Strategy (ADS) and Enterprise Data Management principles.

·         Successfully conducted PRC reviews and IA-centric EDM/ADS compliance checks and reviews for multiple releases.

·         Authorized Data Sourcing (ADS): As a being Risk Architecture I have been extensively involved in Identification, Evaluation and Certification of different System Of Records (SOR) being the ADS for uniformity and accuracy of the data across the bank. As part of the initiative the Applications were tracked for not being ADS Compliant and the Technical Debt was registered and resolved in timely manner.

·         Proof of Concepts: Lead the Proof of Concepts on HSP platform for Spark 1.5 which included Data Frames, Spark SQL, RDDs from start to finish, working with Platform Team and App teams. The Spark PoC was conducted for various business use cases such as Aggregations, DQC and CDC Processes. The detail PoC document was prepared with very clearly defined success criteria. The Spark PoC was successful in terms of its recommendation for adoption.

·         Specialized Processes: Provided Architecture Support and Design for Dynamic Filter generation for Wholesale data filtering, GL Recon Process for Finance Data View Application, Enhanced Common Reference Data Sourcing Process which resulted in 50% better performance on Hadoop hence meeting the SLAs handily.

·         Hadoop Reference Architecture: Worked on providing the outline and content for Hadoop reference Architecture project, contributing to different aspects of Risk Hadoop Reference Architecture including Data Processing, Security, Best Practices and Standards.

·         BIG DATA Application Development Lead for Risk Data prep ETL Processes for Home Loans, CARD, Auto and Wholesale Loans on Hadoop.

·         Working extensively on Logical/Physical Data Modeling (Relational and Dimensional) for Business User Reports for Accounting View of the Risk matrix.

 

Jan 2011 to May 2011      TIME WARNER CABLE INC. Charlotte

                                                Sr. Technical Analyst/Sr. Developer

 

·         Worked on NETEZZA TwinFin Data Warehouse Appliance with NPS version 5.x, 6.x. extensively used nzSQL for DDL, DMLs and nzPLSQL for Stored Procedures.  

·         Used nzLoad and External Tables to Transform and Load the data into Netezza DB. Used CLI for various commands.

 

Oct 2009 to Jan-2011      WELLS FARGO, Charlotte

                                                Sr. Data Architect/Sr. Consultant

 

·         Lead the Data Architecture/Integration and development side efforts in mission critical FOMC / GL Integration Project for merger of legacy Wells Fargo and Wachovia systems, part of Wells Fargo Finance Data Mart/Data Warehouse.

·         Extensively worked on table partitioning, data exchange/swap, parallelism, compression, direct path loading, index management, and table space management for handling large amount of data. Used TOAD IDE extensively to design, develop, debug, tuning and for monitoring sessions, space, locks, users, performance etc.

·         Supported ReconWeb Integrated Reporting (RIR) data warehousing application for historical data analysis and reporting.

·         Worked on Data Integration for Load Batch jobs, Online Data Validations and Interface processes using techniques such as snapshots, migrator process, exception capturing and tools such as SQL, PL/SQL packages, Functions, UNIX scripts and Autosys scripts.

·         Worked on Performance tuning of scripts, processes by applying various techniques at different levels such as index creation, using various hints, table/index analyze, SQL Techniques, Parallelism,

 

 

Mar 2003 to Oct 2009      TIME WARNER CABLE INC. Charlotte, NC

                                                Sr. Technical Analyst/Sr. Developer

 

·         Involved complete life cycle involving Planning, Requirement gathering, Development, Testing, Release and Maintenance of the medium and large size applications. Extensively involved in tuning the applications at Code and Database levels.

·         Worked on NETEZZA NPS Data Warehouse Appliance with software version 4.x, 5.x extensively used nzSQL for DDL, DMLs. The IDE tools used were CLI, WinSQL to for DDL, DML statements in large size (25TB) EDW for Billing System/Customer Data serving multiple Data Marts.

·         Working extensively on Oracle back-end as ODSWEB technical analyst/support using SQL (DML, DCL, DDL), SQL Functions, SQL*Plus scripting, PL/SQL Packages, Triggers, Constraints, SQL*Loader.

·         Extensively used Shell scripts in Bourne, K and C shells on UNIX platform.

·         MERGE INTO features etc.

·         I have also used table partitioning to enhance the performance, manageability and availability. Some of the types of partitioning used are RANGE, HASH, LIST partitioning.

 

Oct 2001 to Mar 2003     RAPIDIGM INC.

 

·         Gathering user requirements, business functions, developing project plan using MS Project and developing data model applying RDBMS concepts such as primary key, foreign key constraints and the Normal form rules to ensure the data integrity and consistency, carrying on data mapping and data conversion using SQL, SQL*Loader, PL/SQL, UNIX Shell, SQR, Triggers, DB Links, Synonyms and Stored Procedures and also worked on production schedules, roll-out efforts, troubleshooting.

·         Some of the challenges overcome are complex data mappings and converting large amount of data in short duration, by using techniques such as data splitting, incremental loading and  speeding the process by tuning the tables and SQLs for better performance.

·         Data conversion from legacy system to PeopleSoft using Import Manager, Data Mover, SQR and SQL, PL/SQL.

 

 

TESTIMONIALS:

·          "Rajan made significant contributions across various streams of HSP-to-HaaS Risk app portfolio migration efforts, including capacity analysis and migration planning, target state DR proposal, recommendations for various options of data integration (sourcing and provisioning) with Hadoop - as well as non-Hadoop – based apps. He actively participated in various PoC efforts on HSP & HaaS, analyzing and mapping cross-platform standards, as well as drafting Hadoop Reference Architecture. Thank you, Rajan! Keep up good work!"

·          Rajan Revankar had been an integral part of Aspen success in achieving Strategic goals of refactoring to ADS sources like PEAKS(decomm FUJI), BAC Mortgage Hub(decomm DWR), ALPIDE CARD(decomm PSUM Flash Files), and as well implementing the tactical WHLSL Reporting on Aspen as part of the FUJI Reporting decommission. He has been a valuable resource interacting with external applications/business users/Hadoop Shared Platform and implementing/driving e2e solutions.

·          Adapted well to Hadoop technology. Introduced standards , best practices and common processes like BATCH Control / Stat Log to the ALPIDE community and educating other partner teams like Andes , Mountain Trekkers , Ascension Team thru Tech SOS. Brought innovative ideas to process Mainframe copybooks thru XML which was also leveraged by Cloudera folks, and sesitive data handling thru meta data driven processing. Worked extensively coaching new hires , working long hours and shown commendable dedication and commitment towards successful implementation of DFS AUTO Loan project