Data Engineer Business Intelligence

Narender Chintala

Data Engineer

Technical Architect Consultant 16 Years San Antonio, USA

On Work Visa in USA: H-1B

********.**@*****.*** 602-***-****

Career Highlights:

• Over 16+ years of experience in Data Warehousing, Business Intelligence and Data Modelling. This includes hand-on experience in dbt, Snowflake, Informactica 10.5, Oracle, PL/SQL Query Optimization, Teradata & Data Integration. Worked on windows& Unix OS.

• Exposure in domains Insurance, Banking & Manufacturing.

• Worked in Agile projects with experience in traditional data warehouse and Operational Data Stores (ODS) working as an Analyst, ETL Developer& BI/Information delivery developer.

• Exposure to data security and working with Teradata to mask PII/sensitive information.

• Worked through all phases of DW/BI life cycle including requirement gathering and analysis, design, development, testing, performance tuning, end user support & production support.

• Extensive experience in designing & programming for relational databases, includes- Teradata, Oracle, MS SQL Server & Snowflake.

• Developed/enhanced & maintained ETL processes using the Source to Target mapping documents and Technical Specifications Documents from the Design phase. Developed mappings, Scripts, packages to design & utilized performance tuning techniques to stream line the development process.

• Ability to understand, analyze and determine DWBI needs of an organization.

• Experience of working as individual contributor, Onsite Coordinator & Tech Lead with the team of 10-12 associates ensuring technical delivery.

• Experience working in all the phases of the Software Development Life Cycle & Agile.

• Flexibility to adapt to new technologies.

• Assisting team on providing design/technical solution on the requirements/issue. Achievements:

• On the Spot (Team) Award on 27-Oct-2023

• Service & Commitment Award on 12-Sep-2022

• Contextual Master Award on 27-Apr-2022

Work Experience:

Associate Consultant - TCS from Jan 2025 to till date.

Assistant Consultant - TCS from Sept ’18 to till Dec 2024.

IT Analyst - TCS from Sept ’12 to till Aug 2018.

Application Programmer - IBM from dec ‘06 to Aug ‘12.

Technical Solutions –Wipro from Mar ‘06 to Oct ’06. Technical Skills:

Area Tools

ETL Tools Informatica PowerCenter 7X/8X/9X/10X, Data Stage 7.5/8.1/8.5

BI & Reporting Tools SSAS Cube, Tableau

Analytics Frameworks Xcelsius 2008

Databases Technologies Snowflake, SQL Server 2008, Oracle, Teradata Job Scheduling Tool Autosys, Crontab & Control M

Version Control Tool Rational, GitHub

Scripting Language Shell script, Java Script & Python Operating Systems Unix

Educational Qualification:

• Bachelors in Computer Science from Osmania University, India in 2005 Detailed Professional Experience:

Experience at Tata Consultancy Services (TCS):

Project #1:

Client Name USAA (United Services Automobile Association) Project Title PnC Data Analytics- Conducting Operators, Target Performance, CWH Financials & Goal Keepers

Domain Insurance-Claims, Financials

Duration April2022 - Current

Location San Antonio, Texas,78240, USA

Project

Description

This engagement with in these teams is in the capacity of Data Engineer & Tech Lead working on multiple projects for dbt Migration. Here Data Integration with Financial, Policy & Loss using near real time batch processes and there by propagating data downstream to the data warehouse, data marts & other consumers.

Tools/technologies Informatica 10.5, Snowflake, dbt, Unix scripting, Cube, Control M & Data Stage Role Technical lead, Sr. Developer

Responsibilities 1. Engaged with internal and external stakeholders to gather business requirements, define expected outcomes, and assess current and future needs.

2. Conducted data analysis, identified gaps, and recommended solutions to meet evolving data requirements.

3. Estimated efforts for enhancements, change requests, and project rollouts, ensuring efficient resource allocation.

4. Validated data models, assessed ETL scope, and delivered design artifacts to guide the offshore team in developing high-quality data solutions.

5. Managed triage and defect resolution across multiple testing cycles to maintain system integrity.

6. Prepared production release artifacts and facilitated successful deployment of data and ETL components.

7. Analyzed upstream and downstream system impacts, providing mentorship in system design and development.

Project #2:

Client Name USAA (United Services Automobile Association) Project Title PnC Data Analytics- PC Data Financials, CWH Financials Domain Insurance- Financials

Duration February 2019 – March 2022

Location Hyderabad, Telangana, India

Project

Description

This engagement with in these teams is in the capacity of Data Engineer & Tech Lead working on multiple projects for dbt Migration. Here Data Integration with Financial, Policy & Loss using near real time batch processes and there by propagating data downstream to the data warehouse, data marts & other consumers.

Tools/technologies Informatica 10.5, Snowflake, dbt, Unix scripting, Cube, Control M & Data Stage Role Technical lead, Sr. Developer

Responsibilities 1. Gathering business requirements by connecting with Internal& External Stake holders, probing for the expecting output, identifying current & future needs for the consumers of the Application. 2. Analyzing data, identify gaps & recommending solutions to data requirements.

3. Providing effort estimates for enhancements, change requests & project roll outs.

4. Triaging & fixing defects during the various testing cycles of projects 5. Preparing production release artifacts, production implementation of data & ETL Components.

6. Analyzing impacts to the upstream, downstream applications and mentoring the team in system design, development & Supporting batch processing.

Project #3:

Client Name Citi Bank NA

Project Title GDGS, Genesis

Domain Banking

Duration November 2014 – January 2019

Location Hyderabad, Telangana, India

Project

Description

GDGS will deliver the metrics & KPI’s for measuring & reporting Digital Engagement Metrics across Transaction types, Channels etc, organized on an enterprise basis. GDGS will address the problems faced by GCMIO. By implementing this project, CITI expects to further the vision of Digital Engagement. This will help in eliminating several manual breaks involved in current reporting solutions and duplication of efforts and the costs for reporting across regions. GDGS will be implemented across APAC, EMEA, LATAM & NAM Regions.

Genesis is a central DWH built for providing an overview on the asset/liability positions for the wholesale and retail business of Citi at various levels across. This project is to upgrade TRL 4.3 in terms of adding new attributes and changing the existing attributes mapping to the country specific. Moving ECS- PLN data to PLN and generating O2 files from Genesis. Tools/technologies Teradata, Oracle, Unix scripting, & Data Stage Role Sr. Developer

Responsibilities 1. Conducted initial requirement analysis and assessed impact on the system.

2. Prepared and reviewed technical specifications and ETL design documents.

3. Developed DataStage Parallel Jobs and BTEQ scripts based on Low- Level Design Documents.

4. Collaborated with the testing team to identify and resolve defects. 5. Monitored system performance, troubleshooting and resolving issues. 6. Provided mentorship and knowledge sharing to junior team members.

7. Assisted in migrating ETL jobs and optimizing performance. 8. Engaged in daily client interactions to align ETL processes with business needs.

Project #4:

Client Name General Motors

Project Title GWM (Global Warranty Management), Go to Green Hardening Project, GSSM

(Global Sell Solutions Mgmt.)

Domain Manufacturing

Duration September 2012 – October 2014

Location Hyderabad, Telangana, India

Project

Description

GM is the leading cars provided in USA, having General Motors car showrooms and dealers across USA.GM is company of diverse brands, selling over 7.5 million vehicles in more than 120 countries worldwide. Global warranty management is the application which is a critical one handling the warranty parts information. It deals with the vehicle parts warranty claims raised by the dealers. GWM application allows GM to standardize the process of warranty management all over the Globe.

DCT (Data Center Transformation)

Tools/technologies Oracle, Unix scripting, Data Stage & Crontab Role Developer

Responsibilities 1. Requirement Analysis & Development- Analyzed and understood business requirements for data transformation and integration. 2. Designed and developed DataStage parallel and sequence jobs for efficient ETL processing.

3. Implemented business logic into transformations to ensure data accuracy.

4. Data Processing & Migration- Managed data loading techniques, transferring data between Data Mart and Flat Files using DataStage. 5. Migrated DataStage components to new servers, ensuring seamless data flow.

6. Implemented code changes in existing interfaces based on client requirements.

7. Testing & Deployment- Performed unit testing, system integration testing (SIT), and user acceptance testing (UAT) for quality assurance. 8. Deployed ETL code into the production environment and provided post-implementation support.

9. Automation & Security- Developed Unix shell scripts to automate ETL workflows and system processes.

10. Enhanced security parameters at both DataStage and UNIX levels to safeguard operations.

11. Collaboration & Documentation- Led daily client interactions, ensuring coordination and smooth project execution.

12. Maintained project-related documentation, detailing migration strategies and ETL processes.

Previous Companies’ Experience Detailed Summary - Experience at IBM: Project #1:

Client Name L & T Insurance, Bank of America Account, CPW Project Title L & T Insurance, Borneo, ADM, Car phone Warehouse & ABM Domain Insurance, Banking & Telecom

Duration December 2006 – August 2012

Location Hyderabad, Telangana, India

Project

Description

LTGICL, a subsidiary of Larsen & Toubro Ltd., entered the Indian general insurance market with a customer-focused approach. IBM, its strategic IT partner, is developing a comprehensive IT solution to support LTGICL’s business expansion. The project includes core policy administration, CRM, enterprise portal, and business intelligence systems. It also involves integration with micro-insurance, SAP, call center applications, and disaster recovery infrastructure. LTGICL aims to revolutionize the insurance industry through technology-driven innovation and efficiency. The Information & Analytics Foundation (IAF) project aims to modernize data warehousing, analytics, and data movement. It consolidates existing data warehouses and Data Marts using the IBM Banking Data Warehouse model. The initiative enhances analytical and metadata capabilities to improve enterprise-wide data insights.

Tools/technologies Oracle, DB2, Unix scripting, Data Stage & Autosys Role Developer

Responsibilities Business Analysis & Requirement Gathering

- Engaged with internal and external stakeholders to understand business requirements and future data needs.

- Conducted impact analysis, identifying gaps and recommending solutions. ETL Development & Data Management

- Led end-to-end development using DataStage 8.1, implementing complex PX stages like Lookup, Join, Merge, and Aggregate.

- Developed, reviewed, and executed ETL design documents, unit test cases, and peer validation processes.

- Managed production releases, ensuring smooth deployment of ETL components.

- Troubleshot and resolved failed jobs/tasks, restoring business operations as usual.

System Monitoring & Risk Management

- Monitored SOR and application load SLAs, reporting performance deviations to stakeholders.

- Analyzed and fixed application and network-related issues, collaborating with IBM GDCE and NW teams.

- Conducted PMR and GEO-PMR reviews, consolidating project data, metrics, staffing, and audit documentation.

Stakeholder Communication & Client Reporting

- Provided daily project updates, ensuring transparency between teams and management.

- Generated and validated weekly, monthly, and quarterly reports for client presentation.

- Participated in customer meetings and conference calls, reviewing performance and service quality.

Change Management & Infrastructure Support

- Facilitated weekly & monthly client calls, discussing project health, risks, and scope changes.

- Coordinated staffing, onboarding, and offboarding activities, fulfilling open positions within SLA time.

- Managed infrastructure needs, identifying expansion opportunities and resolving seat crunch issues.

Deployment & Team Leadership

- Led critical deployments, including Philips Medical, stabilizing operations and eliminating escalations.

- Supported training and mentorship, upskilling team members in process knowledge and issue resolution.

- Served as the first point of contact for project-related concerns, ensuring swift resolution.

…Narender Chintala

Contact this candidate