Vaishnavi Reddy Dornala

• Produced monthly reports using advanced Excel spreadsheet functions.
• Used statistical methods to analyze data and generate useful business reports.
• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
• Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
• Conducted ad-hoc analysis to address urgent business questions, facilitating rapid response to market changes.
• Enhanced data accuracy by automating data cleansing processes, significantly reducing manual errors.
• Generated ad-hoc reports to evaluate specific business requirements.

Project: KYC - North America & Mexico, GCB

Client: CITIBANK

CITIKYC project will enable a single shared KYC record for the customers and link

related accounts to maintain a comprehensive understanding of clients and accounts

throughout the bank and across lines of business. Global consumer banking: is a conversion of existing NAM Retail data.GCB Migration project goal is to

convert KYC NAM Retail customers data from CIN level to CCID level and also

update all related tables as part of this conversion.

• Worked in NAM Retail on new requirements & enhancements to the existing application.
• Reporting application run & defect details to clients on a daily basis.
• Retrieved and combined data from multiple tables using JOIN operations to create comprehensive datasets for analysis.
• Implemented SQL queries to filter and segment data based on specific criteria to generate actionable insights.
• Performed data cleaning and preprocessing tasks to remove duplicates, handle missing values, and ensure data quality for accurate analysis.
• Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
• Implemented data validation rules in Excel to ensure data accuracy and consistency in input fields in reports.
• Have experience in JIRA Software used for application development & defects tracking: Logging work & updating comments in the respective JIRA Story.
• Documented the application analysis details/test results with evidence captures.
• Implementing review comments and coordinating with onshore on assigned tasks.
• Maintaining application standards while meeting the requirements.
• Providing assistance to new members on project model/core structure/testing standards.
• Coordinating status calls in the absence of a supervisor.
• Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
• Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
• Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
• Wrote and optimized in-application SQL statements.

Project: CMLDWH,PSCS-Oil & Gas Conversion.

Client: Synchrony

Commercial data warehouse deals with business credit cards and has over 10 sources and 60+ interfaces in it.

• Worked in conversion projects for various data warehouses, which deal with both consumer and commercial card data.
• Worked on development, testing, and production fix-related projects.
• Worked on various ad hoc and history fix activities, such as one-time data load, file check, server or password updates, and history data fixes.
• Constructed ETL code using the Ab Initio GDE, which involved reading EBCIDIC, flat files, and applying transformations on them to load to the target tables.
• Worked on the automation of the ETL jobs using Autosys.
• Prepared design walk-through/test cases for various applications.
• Had interactions with clients for requirement gatherings, progress updates, and agile specific calls such as scrum, retrospectives, etc.
• Experience in handling generic graphs.
• Exposure to SQL and Shell Scripting.
• Test Environments Support – Using ALM (Application Lifecycle Management) for defect tracking and capturing resolution for issues.
• Implementation, post-production support, and ticket resolution within the warranty period.
• Grooming juniors or new joiners with KT Plan.
• Implement data integration solutions to consolidate information from multiple banking systems and sources, ensuring data consistency and accuracy.
• Identifying and resolving data quality issues, including data inconsistencies and missing values.
• Proficient in preparing DDL statements to create, modify, and manage database objects, including tables, views, indexes, and constraints.
• Maintained comprehensive documentation for all DDL statements and synonyms, facilitating knowledge transfer and onboarding of new team members.
• Collaborated with developers and database administrators to ensure DDL changes aligned with the application's requirements and performance goals.
• Created views specifically tailored for reporting purposes, providing a user-friendly interface for business analysts and stakeholders.
• Implemented synonyms with appropriate access controls for key reporting tables, streamlining report development, and enhancing end-user experience.
• Implemented a rollback strategy for DDL changes, ensuring the ability to revert to a stable state in case of unexpected issues.
• Data about metadata: Provided clear documentation on data sources, data mapping, and data transformation steps in Excel reports.