Ramesh Kumar Gururajan

Charlotte, NC 919-***-****

ad3h82@r.postjobfree.com

https://github.com/ramkguru97

www.linkedin.com/in/ramesh-gururajan-b349b524

Data Management Professional

17+ years of success driving transformation of challenging business initiatives into sustainable, yet innovative, technology solutions.

Results-oriented IT professional with acute business acumen and expertise creating and executing vision for building data warehouse, data management, and data engineering solutions for major clients from strategic concept development to final solution. Expertise in enterprise architecture, data governance, and risk management. Equally capable of building and leading high-performing technical teams or working independently to enhance organizational performance. Engaging businessperson; able to forge solid relationships with key internal and external stakeholders and foster collaborative partnerships across multiple operations.

Areas of Expertise

Strategic Planning

Data Migration

Vendor Management

Enterprise Architecture

Data Warehousing

Team Building & Leadership

Software Development

Master Data Management

Stakeholder Engagement

Business Analysis

Project Management

Database Design

Data Governance

Agile Methodology/Scaled Agile Framework (SAFe)

Professional Experience

Bank of America, Charlotte, NC

Vice President (VP); Data Warehouse/Data Governance Feature Lead, Nov 2021 – Present

Oversee major data quality control initiative for new program, delivering technology expertise to Platform Support Team in Wholesale Credit Authoritative Data Source (WCADS), supporting Global Banking Technology (ADS) with data management and quality metrics.

Spearheaded successful proof of concept team's selection, testing, and certification of data quality tool (Collibra) for bank procurement.

Collaborate with cross-functional teams to identify, define and document data governance requirements and objectives.

Implemented successfully data governance framework for two initiatives of Global Banking Analytic Zone (GBAZ Platform) to improve the risk assessment on data assets and mitigate the identified risks.

Skills/Tools: Hive SQL(HQL), Hue, Cloudera Data Platform, Project Management, Data Governance and Data Management, Project Delivery, Horizon/JIRA, Confluence, Bitbucket, Collibra DQ Tool for Data Governance & Data Lineage, Toad for Datapoint, Informatica Power Center 10.5, Scaled Agile Framework (SAFe)

Bank of America, Charlotte, NC

Vice President (VP); Data Warehouse Application Manager, Aug 2011 – Oct 2021

Architected and designed solutions for data warehouse (Master Data Hub—MDH Patented Authoritative Data Store (Patent Link)) driven by Metadata (Master Data Management of Enterprise Data) and subsequent "big bang" migration from DB2 platform to Cloudera Data platform. Managed technical team, setting and enforcing technology standards, outlining project strategies, allocating resources, and conducting performance reviews. Championed best practices for data extraction, transformation, and modeling, identifying and documenting gaps and recommending new process design strategies.

Earned Aon Silver Star for demonstrating effective team leadership.

Established and led implementation of best practices for data modeling, extraction, transformation, and loading [ETL] for MDH.

Spearheaded creation of effective configuration management system (CMS) for IT provisioning, leading DevOps team in delivery of data model and metadata from various System of Resources.

Oversaw first ever implementation within Bank of America with a big-bang migration of MDH DB2 DW to MDH Cloudera Data Platform and successfully standing up a new Data Warehouse.

Partnered with Data Governance team to develop data management standards, data infrastructure, methodologies, life cycle management, data stewardship, policies, and procedures based on industry-leading best practices

Conducted data quality assessments, analysis and audits, identifying and resolving data issues (Key business elements-KBE of Enterprise Bank Infrastructure data) and inconsistencies in partnership with various stakeholders and finalizing data governance framework, securities, effective data flows and processes.

Skills/Tools: SQL, DB2 Store Procedure, User Defined function, Toad for Db2, Toad for Datapoint, Hive, Impala, Cloudera Data Platform (Apphost, Bank of America Internal cloud), Confluence, Jira, GitHub, Bitbucket version tool, Python, Composite, Presto (Trino), MuleSoft Anypoint

Rose International, (Bank of America Account), Charlotte, NC

Senior Data Engineer, May 2010 – May 2011

Designed and delivered data warehouse (ETL) solution. Maintained data integrity of Bank of America account, correcting errors and preventing data duplication and degradation issues. Led reverse engineering of existing processes for ECRIS Wholesale Risk Technology platform (informatica and Teradata). Prepared weekly status reports, including project updates, to inform senior stakeholders. Maintained application access.

Designed and developed proof of concept identifying target state solutions for user sign-off.

Skills/Tools: SQL/SQL Assistant/Teradata BteQ Scripts/ Technical documentation/TALEND/Informatica 8/ IBM-Netezza.

Accenture, (Duke Energy Account), Charlotte, NC

Application Lead, Feb 2008 – Apr 2010

Managed Customer Billing Information Systems (CBIS) application for Duke Energy account, guiding and mentoring development and quality assurance teams. Created transformation logic and designed complex mappings; directed software development process for multiple requirements of CBIS application. Developed and implemented.

Delivered three sprints for data warehouse replication project from Oracle to SQL.

Skills/Tools: SQL/Technical documentation/Informatica 8.6(Informatica Designer, Workflow Manager, Repository Manager, and workflow monitor) /IBM DB2 Cobol/Toad for DB2.

Accenture (Consulting Vanguard Account), Charlotte, NC

Technical Project Lead, Dec 2006 – Jan 2008

Led and completed conversion project (IBM Cobol to IBM DataStage), despite absence of client partner, spending extra hours developing proficiency on client platform to successfully deliver solution.

Built and mentored 10-member team on multiple projects in fast-paced Agile environment (Conversion from DB2 to DataStage and enhancements of Customer Reformatted Module).

Earned accolades and commendable reviews, resulting in subsequent promotion to senior management.

Skills/Tools: SQL/Technical documentation/IBM DataStage /IBM DB2 Cobol/Toad for DB2.

Selected Additional Experience

Senior System Analyst, Accenture (Bank of America Account), Charlotte, NC

Skills/Tools: Db2, SQL, Cobol, Toad for DB2, Teradata SQL Assistant, JCL, Endeavor

Senior Data Analyst, Emergys (IBM Account), Durham, NC

• Developed and implemented a new Data Model (Star and Snowflake Schema)/ Created and enhanced LLL Datastore.

• Administered and maintained DB2 UDB Database, executed DBA Activities (Monitoring DB to support a never-down platform, conducted DR activity as planned)

Skills/Tools: DB2 UDB DBA, SQL, Toad for DB2, Queryman, Perl Scripting, Store Procedure.

Education

Master of Business Administration (GPA: 3.88/4.00)

University of North Carolina at Charlotte, Charlotte, NC; Data Science: https://github.com/ramkguru97

Master of Engineering (GPA: 4.0/4.0)

PSG College of Technology, India

Bachelor of Engineering (GPA: 3.9/4.0 – University Bronze Medalist)

Bharathiar University, India

ITIL® Foundation Certification

Skills

DATA MANAGEMENT

Governance

Business Intelligence

Version Control

Architecture

Data Warehousing

Quality Control

DATA TECHNOLOGY

Informatica

Cloudera Data Platform

Toad by Quest

Apache Hive & Impala

Python, Perl Scripting, COBOL, Db2, HQL, JCL, C/C++, Db2 SQL

Teradata and Oracle.

Hive, Impala

Jupyter Notebook

DOCUMENTATION & REPORTS

Technical Guides & Release Notes

Database Design & Data Modeling

Technical Diagramming

User Stories to Program Epics

Data Lineage

Design Specification (FSD/BRD/TSD)

SQL Server Reporting

DevOps (CI/CD)

Agile and Waterfall Methodologies

COMMUNICATION

Team Building & Mentoring

Vendor & Stakeholder Relations

Executive Presentations

Negotiation & Conflict Resolution

User Training & Support

Contact this candidate