Renuka Nalluru - Senior Data Governance Analyst, U.S Bank

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Network Power<100 people

Roles

🧨66%

Consulting

🔥33%

Startup Founder

💸33%

Marketing

Geos

🇮🇳33%

India

🇺🇸33%

United States

Work Background

U.S. BankData Engineer

Jul. 2023Charlotte, North Carolina, United StatesProject 3: ORM Data Analytics – California Privacy Rights Act(CPRA) · Gather requirements from stakeholders, conduct reviews to discuss the scope and resource allocation for the required timelines. · Create the sample questionnaire template and meet with the business resources to gather all the CPRA related customer information for the rolling 12 months. · Worked on creating data rule definitions and the required data rules for the identified Key business elements for the data assets. · Created mapping documents with detailed source to target transformation logic, Source data column information and target data column information. · Connect to the source database and execute the code to match the questionnaire or the analysis document. · Worked on performing code alignment reviews, creating GIT LAB Wiki pages. · Designed the Kanban boards and followed the Sprint methodology to track all the requirements for the resources accordingly. · Utilized Apache Spark and Scala to process and analyze large-scale datasets, improving data processing efficiency by 20%. · Conducted data cleaning, transformation, and validation to ensure data quality and accuracy for downstream analysis. · Developed and maintained complex Spark applications to extract insights from structured and unstructured data sources. · Collaborated with cross-functional teams to understand business requirements and translate them into actionable data analyses. · Implemented performance tuning strategies, optimizing Spark jobs for improved processing times and resource utilization. · Worked in a Linux environment, using shell scripting to automate routine data processing tasks and job scheduling.

U.S. BankSenior Business Analyst

Mar. 2023 - Jul. 2023Charlotte, North Carolina, United StatesProject 2: Union Bank Conversion Risk Compliance – Senior Business Analyst · Gather requirements from Union Bank Business Line team, conduct reviews to discuss the scope and resource allocation for the required timelines. · Work with junior business analysts and allocate the needed stories based on the timeline, sign off the essential work performed. · Create the Vault workspace connection in Info Analyzer for data quality checks. · Work on creating data rule definitions and the required data rules for the identified Key business elements for the data assets. · Validate the test results for the performed validations. · Work on signoff from PM for the required Vault intake from Union bank data. · Worked on the validation between restored DB counts vs Control file counts from IT environment in SSMS. · Performed complex SQL queries in SSMS to validate between both the entities. · Worked on creating PowerBI dashboards for reporting service. · Extracted, transformed, and loaded data from various sources into the data warehouse using Microsoft SQL Server Integration Services (SSIS). · Developed ad-hoc queries and stored procedures to fulfill data requests from business stakeholders. · Collaborated with the data modeling team to design and implement efficient data structures for reporting and analysis purposes.

U.S. BankSenior Data Governance Reporting Analyst

Mar. 2021 - Mar. 2023Project 1: MAD Data Sprawl Remediation Initiative – Senior Data Governance Reporting Analyst · Worked with subject matter experts (SME) to understand the SOR details and how the data entities are defined. · Worked with EAA/BL users to determine the MAD entity approvals on the requirements document for various SORs · Analyzed the data that is already present in Marketing Analytics Datamart (MAD) to export the same data entities to a new DataMart. · Worked on querying complex SQL queries as part of data validation for the mappings by referring to the sample datasets from IT and PROD environments from TOAD Data Modeling Tool. · Gather requirements from client business team and help Business Analyst and data modelers in creating a Business Requirement Document and designing the data models respectively. · Implemented Data Governance using Excel and Collibra. · Performed an end to end Data Lineage assessment and documentation for select CDEs. · Collibra workflow development and configuration based on MS Data Governance Approach and requirements. · Analyzed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance. · Update the business requirement documents in the Customer 360 portal so that it can be accessible for the entire team. · Worked on SnowSQL and Snowpipe · Converted Talend goblets to support the snowflake functionality. Created Snowpipe for continuous data load. · Created data sharing between two snowflake accounts. · Created internal and external stage and transformed data during load. Redesigned the Views in snowflake to increase the performance.

Blue Cross and Blue Shield of Kansas CityData Modeler

Jan. 2020 - Feb. 2021Kansas City, Missouri, United States· Worked on defects, enhancements of preexisting SSIS ETL jobs · Acted as a Scrum Master and Lead developer whenever needed for the team · Built basic power BI reports on User activity by using Azure data bricks as a source · Used Alteryx to built basic debugging pipelines · Loading data from different sources, data visualization, data quality checking, using descriptive statistics and graphs like bar charts, histograms, pie charts. · Analyzed various jobs and source files using IBM DataStage Designer and performed various complex SQL queries and made changes as per the business requirement. · Worked with Codes and Data Mapping Application in performing the mapping changes and the transformation rule changes. · Worked with Data Architects in pushing in and verifying the models into Codes and Data Mapping Application in MS Access and worked with ETL Developers in forwarding the analysis and updating with the development work needed according to the business requirement. · Worked extensively using ETL Tools like Alteryx, PowerBI, Excel to connect the data exploration platform of data assets where data can be accessed, blended and cleaned from any source. · Served as cross-functional liaison for product direction, bug fixes, and enhancements using Visual Studio Team Foundation Server (TFS). · Analyzing the source data to know the quality of data by using Talend Data Quality. · Broad design, development and testing experience with Talend Integration Suite and knowledge in Performance Tuning of mappings. · Developed jobs in Talend Enterprise edition from stage to source, intermediate, conversion and target. · Involved in writing SQL Queries and used joins to access data from Oracle, and MySQL. · Developed a standard ETL framework to enable the reusability of similar logic across the board involved in System