Veera Chandra Sekhar Nandipati
Chennai
Summary
15 + years of IT professional with expertise in Analysis, Design, Development, Implementation, Testing, RCA (root cause analysis), issue resolution, Scheduling, and Automation of jobs for Data warehouse applications. Solid experience in BI technologies in developing strategies for large-scale ETL applications using Ab Initio product suite working with some of the largest Banking and Financial organizations in the world. Experience with Hadoop Framework to build Hadoop Cluster using components SPARK Framework, HIVE and SQOOP. Familiar with importing and exporting data between HDFS and Relational Database Management systems using Sqoop. Experience in ingesting the data from non EAP (Enterprise Analytics Platform) sources like Oracle RDBMS to HIVE tables in HDFS and reading the data from HIVE, apply enrichment rules using PYSpark Framework tool and load data to HIVE and Oracle tables to provision data for downstream users. Expertise in working with Data Analysts and data modelers to translate business rules/requirements into conceptual, physical and logical dimensional models. Proficient in the Integration of various data sources into target enterprise databases like Oracle, MS SQL Server, and Flat Files into the staging area, ODS, Data Warehouse and Data Mart. Involved in designing Ab Initio graphs and developing Batch graphs, Linked Sub-graphs, and wrapper scripts with various Ab Initio components. Experience in developing generic graphs in Ab Initio and further familiarity with various PDL Meta programming functions. Worked on Conduct>It plans, experience in Express>It and Ab Initio Operational Console/Control Center tools to schedule Ab initio jobs. Develop scripts to automate the execution of ETL using shell scripts under UNIX environment.
Performance-driven Vice President with [Number] years of experience aligning systems with business requirements, policies, and regulatory requirements. Passionate about applying excellent organization and communication skills to manage and lead teams. Results-oriented individual well-versed in interfacing and consulting on business processes to drive results based on sound overall business judgment.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Vice President (Apps Dev Tech Lead analyst)
Citicorp Services India Private Limited (Citi)
11.2019 - Current
- Ruby serves as a dynamic technology system based platform for forecasting Citigroup, Inc’s(“Citi”) balance sheet, Net interest Revenue and Net Interest margin, calculating Interest Rate Risk Metrics, and enabling the calculation of NIR and IRR scenarios for Citi.
- The Common Data Acquisition (CDA2.0) subsystem of the Ruby platform extracts data from a range of sources, transforms the data and stages the data to then support Ruby’s core modeling and forecasting functions.
- Leading the core PySpark Technology team of 20 members from offshore with providing solutions related to the complex data queries from downstream business users.
- Involved in creating a Framework in PySpark environment to read and apply the business enrichment rules dynamically through oracle tables loaded by GUI.
- Involved in creating the Data Integrity Framework tool using PySpark to raise exceptions and create reject records reports by reading and applying Data Quality rules dynamically from Oracle tables loaded through frontend UI platform.
- Identified the design flaws in the current system and provided solutions to handle the performance bottle-necks in handing the huge volume of inbound data coming from various source systems.
- Conducting knowledge sharing sessions (both functional and technical design process over view) to the new team members of Vendor teams to help them in understanding the process.
- Interacting with the downstream business users on daily basis to understand their business needs and proving the solutions to them through the technology driven system.
- Project: Ruby CDA2.0 Team Size:20
- Client: Citigroup, USA
Senior ETL Developer
ITIDATA
02.2015 - 11.2019
- Net Interest Revenue project, this effort would leverage firm wide balance sheet from PEARL data mart which will be enriched within Common Data Acquisition (CDA) Framework with the mandatory attributes required for each products for NIR Forecasting.
- Designed and developed code for various products like Pearl, Deposits, Loans, Securities, TP tickets, and feathering process for all the products.
- Familiar with end to end process of the project and involved in every aspect to support business requirements and data consumption around CCAR risk reporting.
- Created generic applications (appconfigs) in Ab Initio ACE (Application Configuration environment).
- Built re-usable transformation rules using Ab-Initio BRE (Business Rules Environment) to help business analysts validate and plug the generated transformations in the graphs.
- Create and schedule of Ab initio jobs through Ab initio Control center.
- Achieved performance improvement by redesigning and developing the generic graphs.
- Involved in code deployment from lower environment to higher environment through CITI release management process, RLM by creating the change requests.
- Involved in Unit/integration testing and resolved issues raised during SIT/UAT phase.
- Project: Ruby-Net Interest Revenue(NIR),Team Size:6
- Client: Citigroup, USA
ETL Designer/ETL Developer
CTS (Cognizant Technologies India Limited)
03.2014 - 01.2015
- TDE aims to identify and resolve known potential and known existing frauds. It identifies risk and contacts the customer by optimizing contact strategies and enables system to facilitate quick contact. It improves POS decisions by preventing additional fraud losses.
- Achieved performance improvement by redesigning and developing the generic graphs.
- Created Ab initio Graph and Plan for ETL tasks.
- Created Generic/Reusable graphs to automate the loading process into oracle database.
- Used HP quality Center for defect management and worked by fixing the code for the closure of defects raised by SIT team.
- Designed the detailed data level mapping in an existing process as per requirement and business rules.
- Developed re-usable generic / dynamic Ab Initio graphs and psedts for the quality check of the source data.
- Expertise in unit testing, system testing using of sample data, generate data, manipulate date and verify the functional, data quality, performance of graphs.
- Project: EDW Migration Team Size:5
- Client: JPMCU,USA
ETL Developer
Infosys Ltd
01.2011 - 03.2014
- The objective of the project was to Standardize Data Quality checks to be performed on the data received from various source systems mainly of Policy, Customer, producer and Claims data. The data will be loaded to the ODS (Operational Data Store) after doing the Quality checks and then loaded to the CSA (Confirmed Storage Area) after implementing the Business logics and CDC’s.
- Requirement Analysis
- Developed Informatics mappings.
- Written UNIX scripts
- Responsible for creating project artifacts as per QA process.
- Client : AMFAM(American Family , Insurance ),USA
- Project: Business Analytics 07(BA07), Team Size: 4
ETL Developer ,Ab Initio
Syntel Limited
12.2007 - 10.2010
- The ADW is an initiative to replicate the mainframe EDW ETL system with newer technology, which is more scalable, manageable and cost effective. The current mainframe process is broadly classified as legacy site (extract process running on nine CPUs) and central site (data from the legacy is transformed and loaded to EDW-DB2 database). For the most part, the ADW systems will be replicating the mainframe central site process. This effort was a step towards retiring the DB2 Enterprise Data Warehouse (EDW) in favor of the newly constructed Oracle based Allcorp Data Warehouse (ADW).
- Involved in requirement Analysis with business users.
- Developed Ab Initio Graphs as per the requirements.
- Involved in creating the high and low level design documents with the help of BRD provided by business users.
- Implementation of checklists while promoting the code to testing and production environments.
- Client : Allstate Insurance., Chicago, USA
- Project: ADW (Allcorp Data Warehousing), Team Size:4
Education
Master of Sciences -
Bhopal University
Bhopal, Madhya Pradesh, India01.2004
Bachelor of Sciences - Computer Science
Nagarjuna University
India01.2002
Skills
Team leadership
Strategic planning
Coaching and mentoring
Decision-making
Process improvement
Results-driven
Negotiation and persuasion
Risk management
Training and mentoring
Data analysis
Certification
Microsoft Certified Azure Developer Associate completed in May 2022.
Timeline
Vice President (Apps Dev Tech Lead analyst)
Citicorp Services India Private Limited (Citi)
11.2019 - Current
Senior ETL Developer
ITIDATA
02.2015 - 11.2019
ETL Designer/ETL Developer
CTS (Cognizant Technologies India Limited)
03.2014 - 01.2015
ETL Developer
Infosys Ltd
01.2011 - 03.2014
ETL Developer ,Ab Initio
Syntel Limited
12.2007 - 10.2010
Bachelor of Sciences - Computer Science
Nagarjuna University
Master of Sciences -
Bhopal University