Summary
Overview
Work History
Education
Skills
Timeline
Generic

Aishwarya Narra

Spring Hill,KS

Summary

Results-driven data professional with strong foundation in data analysis and business intelligence. Known for transforming complex datasets into strategic business solutions while maintaining rigorous standards. Consistently fosters team collaboration and adapts seamlessly to dynamic project requirements, leveraging skills in SQL and Python to drive impactful outcomes.

Experienced with statistical analysis, data modeling, and visualization techniques critical for data-driven decision-making. Utilizes advanced SQL and Python skills to identify trends and optimize business processes. Knowledge of key industry tools and methodologies ensures comprehensive data analysis and actionable insights.

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

14
14
years of professional experience

Work History

Senior Data Analyst / Developer

First Citizens Bank
NC
11.2024 - Current
  • Worked as a Data Analyst and SQL Developer, supporting business and enterprise data needs through end-to-end data analysis and development.
  • Collaborated closely with business users and stakeholders to gather, understand, and document data requirements, ensuring alignment with end-user expectations.
  • Translated functional and reporting requirements into technical designs and SQL solutions, delivering accurate and reliable datasets.
  • Developed, enhanced, and maintained complex SQL queries and data logic within Netezza and DB2 environments.
  • Performed code modifications, debugging, and optimization to support data accuracy, performance, and scalability.
  • Conducted thorough unit testing and validation across development and test environments prior to production deployment.
  • Utilized Azure DevOps as the primary code repository for version control, code check-ins, and deployment tracking, ensuring adherence to development standards.
  • Supported ETL and data processing workflows using IBM DataStage, contributing to structured and efficient data movement.
  • Scheduled, monitored, and managed batch jobs using Control-M (Ctrl-M) to ensure timely and consistent data loads into production systems.
  • Provided ongoing production support, including job monitoring, issue resolution, and data troubleshooting to maintain system stability.
  • Partnered with cross-functional teams to ensure data integrity, quality, and timely delivery for reporting and analytical use cases.
  • Designed and implemented SQL-based data solutions in Netezza and DB2 to meet enterprise reporting needs.
  • Acted as a liaison between business users and technical teams by collecting and refining data requirements.
  • Managed end-to-end data delivery, including development, testing, deployment, and production support.
  • Automated and scheduled data loads using Control-M, ensuring timely and consistent production refreshes.
  • Performed impact analysis and enhancements on existing SQL code to improve data accuracy and performance.
  • First Citizens Bank acquires personal, business, commercial and wealth clients. They offer an array of general banking services, commercial banking, leasing and other financial services.
  • Databases: Netezza, IBM DB2
  • SQL Development: Advanced SQL querying, joins, subqueries, performance tuning
  • ETL Tools: IBM DataStage
  • Job Scheduling: Control-M (Ctrl-M)
  • Version Control & CI/CD: Azure DevOps (code check-ins, versioning, deployments)
  • Environments: Development, Test/UAT, Production
  • Operating Systems: Linux/Unix
  • Data Domains: Enterprise relational data management, reporting and analytics support

Senior Data Analyst

Capital One
Mc Lean, VA
09.2019 - 05.2024
  • As a Data Analyst, my responsibilities include to Extract, Transform, Integrate, Analyze and export the data to cloud while making any necessary modifications.
  • Designed and developed data loading strategies, transformation for business to analyze the datasets.
  • Processed flat files in various file formats and stored them as in various partition models in HDFS.
  • Responsible in performing sort, join, aggregations, filter, and other transformations on the datasets using Spark.
  • Experience in extracting appropriate features from data sets to handle bad, null, partial records using Spark SQL.
  • Collected data using Spark Streaming from AWS S3 bucket in near-real-time and performs necessary Transformations and Aggregations to build d the data model and persists the data in HDFS
  • Experienced in working with spark eco system using Spark SQL and Scala queries on different formats like Text file, CSV file.
  • Design and modify Python Scripts for manipulating the data reading from various Teradata and convert them as one CSV Files.
  • Developing data applications with Python in Windows and Teradata environments and writing SQL queries in Teradata and Redshift for data analysis
  • Working in Postgres SQL to extract and analyze TIR and HR data
  • Using Gitbash for tunneling to Jupyter notebook and connecting to EC2 server
  • Working with Postman application to push huge amount of data through APIs in Nebula
  • Working with registering and updating datasets in Nebula through API’s (moving data to the cloud), using AROW to automate, schedule and validate DDE jobs
  • Performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata. Also, perform data validation, data verification and identifying data mismatch and implement security measure to protect data against unauthorized disclosure or damage.
  • Analyzing of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
  • Responsible for schedule tracking to meet delivery deadlines and documenting all the information gathered during the incident for future reference by all the team members.
  • Plan, coordinate, design and implement security measure to protect database against unauthorized disclosure or damage. Implement and enforce database security policy, and disaster mitigation/recovery strategy.
  • Developed reports using the Teradata OLAP advanced techniques like rank, rank () Over and row number etc. Designing the database, creating Tables, Stored Procedures, Views, Function, and Triggers & Automated test cases to safeguard against regression.
  • Coordinate with other teams for issue resolution and clarification. Responsible for technical assist the team members in database framework design and implementation and monitor project related risk. Work closely with development, deployment and environment teams.
  • Capital One Financial Corporation is a bank holding company specializing in credit cards, auto loans, banking, and savings accounts. There are three divisions such as credit cards, consumer banking and commercial banking. Capturing, analyzing and transforming the sensitive data of the customer and validating the data post encryption.
  • Environment: Python, Spark, SQL, Snowflake, Nebula, SQL Assistant 12.0/13.11, Teradata 15, PostgreSQL, Tableau, MySQL Workbench, Windows, UNIX

Principal Data Analyst

DTV(AT&T)
Dallas, TX
04.2022 - 07.2022
  • Developing and implementing data gathering, analysis, and reporting capabilities.
  • Collaborating with service managers and the design and engineering and tools teams to collect and process relevant metrics to support service level management and process improvement activities.
  • Creating detailed user stories and acceptance criteria. Responsible for performing the progression of User stories in JIRA in alignment with the project execution phases.
  • Preparing periodic reports to communicate outcomes of analytic activities.
  • Performing analytics on discrepancies and issues and performing root cause analysis.
  • Identified people, process, and technology opportunities for efficiency and cost reductions.
  • Analyzed complex reports as revealed by the data to assist in predicting trends, conduct quality assessments, review discrepancies, assessing risks, benefits and consideration of alternatives.
  • Gather, process, and analyze data into information and information into knowledge to support operations and business decisions. Used Teradata to analyze the data.
  • Use enterprise monitoring and reporting tools to identify trends and opportunities for improvements in IT service processes and workflow.
  • High expertise in software tools including JIRA, Confluence, Share Point, MS Tools, Visio and Lucidchart.
  • Determined task dependencies, identified milestones and monitored critical paths using Gant Charts, Resource Plans.
  • Interacted with the client to establish, maintain, and modernize clear business-based targets for service levels and to ensure that delivery of services is properly assessed, monitored, and managed against these targets.
  • Interacted with other service providers to ensure that operational level agreements are in place to ensure end-to-end service delivery in accordance with the service level targets. Also met the reporting level targets by co-ordinating with different teams.

Data Analyst II

Capital One
Richmond, VA
08.2018 - 09.2019
  • Performed data cleaning and data wrangling in Python using pandas and NumPy
  • Cleaning and transforming massive data into useful and insightful to specific teams.
  • Create interactive dashboards and reports for teams within the organization.
  • Working with business users to gather requirements and transform them into reports and dashboards using Tableau.
  • Maintaining and updating Tableau dashboards of various teams in the organization.
  • Creating data sources to be easily interpreted from raw data for teams to use.
  • Involved in defining the source to target data mappings, business rules, business and data definitions
  • Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
  • Running reports against databases to ensure data integrity and familiarity with data protection.
  • Adept in developing SQL scripts to validate the databases tables and reports data for backend database testing
  • Collaborated with Business Analysts, Data Stewards and Business Customers to identify data usage patterns and to formulate business names, definitions and data quality rules for data elements
  • Enable effective decision making by retrieving and analyzing data from multiple sources into a digestible and actionable format to the senior businesspeople to influence the strategic direction of the application / product
  • Troubleshooting data issues, validating result sets, and recommending/implementing process improvements by leveraging the insights from the analysis made.
  • Created common reusable objects for the ETL team and overlook coding standards.
  • Used ETL to extract files for the external vendors and coordinated that effort.
  • Involved in requirement gathering and performed ETL Process.
  • Analyze and come up with impacted components and estimations for any new enhancements
  • Analyze the incident trend and pain areas and come up with improvements ideas & stabilization activities
  • Involve in meetings with business & various teams to collect the data flow & reporting requirements
  • Coordinate with other teams for issue resolution and clarification. Responsible for technical assist the team members in database framework design and implementation and monitor project related risk. Work closely with development, deployment and environment teams.
  • Environment: Python, Spark, SQL, Snowflake, Nebula, SQL Assistant 12.0/13.11, Teradata 15, Redshift, PostgreSQL, Tableau, MySQL Workbench, Windows, Databricks.

Data Analyst

Commerce Bank
Kansas City, KS
12.2017 - 07.2018
  • Interacted with Business Analysts to understand data requirements to ensure high quality data is provided to the customers.
  • Worked on numerous ad-hoc data pulls for business analysis and monitoring.
  • Worked in Agile environment and involved in daily stand ups and scrum meetings
  • Used Hive to partition and bucket data.
  • Creation of mapping documents that include tables, files– from source to target.
  • Gathered database mapping requirements and created mapping documentation using Erwin.
  • Extracted data of customers who are eligible for person-to-person payments using Zelle application.
  • Extensively Worked with highly unstructured and semi structured data.
  • Operationalized business intelligence solutions and conducted advanced analytics to identify opportunities and strengths to meet business goals.
  • Created and maintained data visualizations that educated, informed and engaged business partners on key metrics and performance measures.
  • Collaborated with enterprise data warehouse, data governance, and business teams on data quality issues, as well as architecture or structure of data repositories.
  • Worked with cross-functional teams to structure problems, identify appropriate data sources, extract data and develop integrated information delivery solutions.
  • Occasionally created Triggers and Stored Procedures to reduce user access to the database.
  • Generated weekly, biweekly and monthly reports to measure the performance for each line of business.
  • Performed in depth analysis on data and prepared ad-hoc reports in MS Excel and SQL scripts.
  • Created multi-set tables and volatile tables using existing tables and collected statistics on table to improve the performance.
  • Developed UNIX shell scripts to run batch jobs and communicate logs to the users.
  • Generated graphs using MS Excel Pivot tables and creating presentations using Power Point.
  • Used OLAP functions like sum, count, csum, etc.
  • Developed reports using the Teradata OLAP advanced techniques like rank, rank () Over and row number etc.
  • Designing the database, creating Tables, Stored Procedures, Views, Function, and Triggers & Automated test cases to safeguard against regression.
  • Environment: SQL Assistant 15, Teradata 15, PostgreSQL, Python, Agile, AWS, UNIX Shell Scripts, AWS, MS Windows, Windows XP, MS Excel, MS Power Point.

Data Analyst/ SQL Developer

Target Corporation
Minneapolis, MN
09.2017 - 11.2017
  • CRISP (Content ratings, Reviews, in stock search, Search and Pricing) Project works on retail and ecomm datasets and business constructs going through the value chain to deal with the offline optimized sales. Salesforce platform to integrate Pricing, Content Analytics, Distribution across different data domains and attributes of significance to achieve desired analytics/output.
  • Worked with business analysts, senior project managers, and programmers to gather business requirements and specifications.
  • Experience working with physical and logical data modelling.
  • Involved in Retrieve data from Database and developing reports based on the business requirements.
  • Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
  • Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like MS Access, Excel and SQL Server.
  • Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
  • Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Extensively used VLOOKUP & Index function throughout the project.
  • Implemented conditional formatting in Excel and created validation.
  • Worked with end users to gain an understanding of information and core data concepts behind their business.
  • Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
  • Identify & record defects with required information for issue to be reproduced by development team.
  • Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
  • Performed Verification, Validation and Transformations on the Input data (Text files) before loading into target database.
  • Designed and developed weekly, monthly reports by using MS Excel Techniques (Charts, Graphs, Pivot tables) and Power point presentations.
  • Designed stunning visualization dashboards using tableau desktop and publishing dashboards on tableau server and desktop reader.
  • Designed and developed dashboard in Excel. Imported data into excel from flat files
  • Used VBA for excel to automate the data entry forms to help standardize data.
  • Responsible for analyzing business requirements and developing Reports using PowerPoint, Excel to provide data analysis solutions to business clients.
  • Discussed with the Business groups to understand requirements. Translate requirements to agile stories.
  • Environment: Teradata, SQL Assistant, AWS, MS Office Server, MS Excel, Agile, Tableau, Windows and Putty

Data Analyst

Tech Mahindra
Bangalore, India
05.2014 - 03.2017
  • Implemented a centralized data base that collects and organizes and stores data from different operational systems to provide a single source of integrated and historical data for the purpose of end user reporting, analysis and decision support and to improve the client services by preventing errors, providing real-time data and updating records as transactions are completed for Billing and Payment purposes.
  • Met with Customers to determine User requirements and Business Goals.
  • Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
  • Developed macros to drop tables, delete, recreate, refresh tables.
  • Gathered and translated business requirements, worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
  • Dealt with conflicting scenarios when the requirements and the reverse engineering communicated different cleansing rules.
  • Created a conceptual design based on the interaction with the functional and technical team.
  • Analyzed the existing data model and incorporated new additions for the advancement data into the data model identifying the cardinality of the new tables to the existing tables and ensure proper referential integrity of the system
  • Analyzed and created various adhoc Reports for users based on User Requirements.
  • Created both list and drill down reports identifying the data hierarchy
  • Generated reports using pivot tables in MS Excel
  • Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements
  • Developed macros to Automize daily / Weekly / Monthly reports.
  • Developed macros to filter & format trading and execution data and move to new workbook.
  • Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
  • Worked on user systems with Excel Add-in and trained users on Excel client usage
  • Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
  • Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
  • Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
  • Worked in collaboration with various areas of the organization, identified additional stakeholder Requirements, and Documented requirements in a Software Requirements Specification document.
  • Created use cases, activity diagrams and state diagrams using Rational Rose
  • Environment: SQL, Excel, Tableau Desktop 7 & 8.0, Tableau Server UNIX Shell Scripting, Putty, MS SQL Server, Windows XP, UNIX.

Data Analyst

Infosys ltd
Bangalore, India
06.2012 - 04.2014
  • The scope of project was to migrate set up configuration from one instance to another and base line it to performance instance, so that performance testing can be carried on newly migrated instance by performance testing team.
  • Extensively involved in every phase of the SDLC process starting from Inception to Transition
  • Interviewed Business Users to gather reporting / data requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
  • Worked on data governance and security practices of data tools associated with big data.
  • Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work.
  • Wrote complex SQL to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
  • Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
  • Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
  • Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, Analysis and Reporting System
  • Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
  • Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
  • Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents
  • Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
  • Analyze the Business Object reports/extracts and submit to the Risk manager after the proper validation.
  • Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules
  • Environment: Sql server, DB2, Sql server Management studio, PL/SQL, MS Excel, JIRA, Windows 7, Microsoft Office

Education

Bachelor’s - Computer Science

JNTU
India
06-2012

Skills

  • BI/Visualization Tools: Tableau, Splunk, MS Excel
  • Programming: Python, SQL
  • Cloud Computing Tools: Amazon WBS
  • Databases: RDBMS, Snowflake, MySQL, Teradata, PostgreSQL DB
  • Platforms: Windows, UNIX, Linux
  • Methodologies: Agile, Waterfall
  • Data warehousing
  • Business intelligence
  • ETL processes
  • Data quality assurance

Timeline

Senior Data Analyst / Developer

First Citizens Bank
11.2024 - Current

Principal Data Analyst

DTV(AT&T)
04.2022 - 07.2022

Senior Data Analyst

Capital One
09.2019 - 05.2024

Data Analyst II

Capital One
08.2018 - 09.2019

Data Analyst

Commerce Bank
12.2017 - 07.2018

Data Analyst/ SQL Developer

Target Corporation
09.2017 - 11.2017

Data Analyst

Tech Mahindra
05.2014 - 03.2017

Data Analyst

Infosys ltd
06.2012 - 04.2014

Bachelor’s - Computer Science

JNTU
Aishwarya Narra