Anitha Battu Jaya
Marietta,GA
Summary
Having over 18 years of progressive experience in the IT industry, I possess deep expertise in developing Data Warehouse applications as an ETL Developer, Lead, SME, and System Analyst Lead. I have led cross-functional teams, managed project delivery, and driven data engineering initiatives to successful completion. With over 5 years of extensive experience in relational data modeling, data analysis, and analytics (using SQL, Tableau Dashboards, AWS Athena), I have provided strategic insights and solutions tailored to business needs.
I am highly proficient in relational data modeling (using Erwin) and have 12+ years of specialized experience working with Ab Initio (GDE, CO>OP, EME, M-hub, Express>IT), overseeing the design, development, and optimization of complex data workflows in high-volume environments. My managerial responsibilities include guiding, mentoring, and training team members, as well as reviewing and ensuring the quality of analysis, code, and deliverables.
Throughout my career, I have demonstrated strong leadership by managing end-to-end project delivery, coordinating efforts across teams, conducting performance tuning, and handling scheduling for large-scale data warehousing projects such as Basel-II. I have successfully built client confidence by providing high-volume data processing solutions and receiving multiple appreciations from clients.
My expertise extends to designing generic graphs, implementing ETL processes with Ab Initio's parallelism techniques, and implementing complex schemas like Snowflake and Star-Schema. I possess excellent analytical, interpersonal, and communication skills, capable of understanding business requirements, developing analysis documents, and translating them into practical technical solutions. My domain experience covers Global Wealth Management and Private Banking, with additional credentials including Oracle OCA certification and hands-on experience with SQL, PL/SQL, and POC development.
Overview
19
19
years of professional experience
Work History
Senior Technology Analyst
SouthWest Airlines
05.2023 - Current
- Gather, document, and analyze business requirements from Business Users. If required conduct workshops, and brainstorming sessions to understand the needs of the business and translate them into clear and concise requirements.
- Understand data from various sources, including databases, spreadsheets, APIs, and external sources and ensure data quality, integrity, and accuracy through data cleaning and preprocessing techniques.
- Provided technical and functional recommendations based on project requirements.
- Supported technology design, testing and execution by providing research-based product and process knowledge.
- Studied business functions and evaluated requirements to establish operational objectives.
- Define & build the data transmission mechanism for receiving and sending data into/from the Data Warehouse.
- Prepare business requirements documents (BRDs), functional requirements documents (FRDs), use cases, process flows, and user stories to communicate requirements effectively to development teams.
- Gathering the Critical data elements from Current state BO reports, Altryex Flows and Tableau Dashboards. And conduct meetings with Business Users for CDE elements identification.
- Perform gap analysis between the current state data and future state data.
- Created Logical and Physical Data Models for the Future State Data.
- Preparing the Source to Target mapping document.
- Understanding the Future state Avro payloads streaming on Kafka Streams. And Identifying the right source data for processing.
- Analyzing and debugging any issues reported by Business Users in current state data and reporting the root causes to Business users. Preparing the Impact analysis document and providing the effort estimation.
- Provide support to Migrate the Ab-Initio graphs migration from On-Prem to AWS.
Lead Systems Analyst
Blue Cross Blue Shield Association, BCBSA
08.2018 - 03.2023
- Lead and manage multiple high complexity projects simultaneously, ensuring alignment with business objectives and value delivery.
- Partnered with Technology Managers and Directors to support enterprise strategic plans, driving analysis and recommendations.
- Fostered collaboration across development and application teams to break down work into manageable components.
- Directed project testing and acceptance, effectively managing project risks and issues.
- Collaborated with cross-functional teams to visualize full scope of work and plan dependencies.
- Gathering the requirement from business and documenting the requirements in functional specification document.
- Analyzing the CCTI impact for the business requests.
- Analyzing the CCTI impact through MDH Data Lineage.
- Preparing the Impact analysis document and providing the effort estimation.
- Preparing the Data Exchange Documents, where-in it contains the external systems interfacing details.
- Preparing the Source to Target mapping document.
- Created Logical and Physical Data Models for the FEDVIP Project and as part of maintenance projects, adding the new columns to existing data model.
- As part of production support issue, creating the Production Issue Resolution (PIR) Document.
- All the documents prepared by SA – walkthrough to the Business, Development team and testing team.
- As a Senior SA, reviewing the documents prepared by other SA and coordinating with business to get the approvals.
- Implementing the Data Quality Rules for the elements used in Business Reports.
Data Governance Lead
HSBC
02.2018 - 07.2018
- Building the System Flow diagrams for identified systems.
- Contacting Identified systems SMEs to get the Lineage details.
- Identify and define current 'As-Is' processes for CDE Elements.
- Work with cross-functional teams including subject matter experts from various departments across the organization.
- Critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and be able to distinguish CDE elements originating systems.
- Performing the Manual mapping after having the discussion with System SMEs.
- Conducting walkthrough with SMEs and getting the Sign-offs for build System flows and Lineage.
- Conducting the walkthrough with Head of Line of Business to get the Signoff for Lineage built.
- Once receiving all the signoffs, loading the Lineage details into M-Hub portal.
Data Governance Analyst, Data Stewardship
Synchrony Financials
08.2017 - 01.2018
- Acts as a liaison between Onsite and offshore for all project activities.
- Assigning the rules to the team members in MHUB.
- Guiding the team to write the app-confs and validate those.
- Reviewing the rule app-confs created the by team.
- Validating the logic written in app-conf by performing the data profiling against the production data.
- Creating the tag and save file for the production deployment.
- Creation of autosys jobs as per the synchrony guide lines.
- Provided the suggestion to improve the jobs performance.
Ab Initio Technical Lead, SME
Fedex
02.2016 - 06.2017
- Understanding the Business Requirements and Preparing the HLD as per the Business requirement.
- Preparing the source to target mapping sheets.
- Developing generic graphs for loading the data from source to ODS.
- Acts as a liaison between Onsite and offshore for all project activities.
- Guiding the team to understand business requirement and helping them during their development.
- Driving the documentation review and code review meeting with client.
- Providing support during UAT and Post production.
Ab Initio Technical Lead
IBM
10.2014 - 02.2016
- Understanding the Business Requirements and Preparing the HLD as per the Business requirement.
- Designing the common process for Daily Reports Automation.
- Developing generic graphs for Automation Process.
- Review the code developed by team.
- Providing the Guidance to the team when stuck in development.
- Providing the Support for Deployment process.
Ab Initio Lead
Citigroup Private Bank
01.2014 - 04.2014
- Preparing Technical Design documents.
- Preparing the Mapping Sheets.
- Understanding the existing Procedures to get the actual flow.
- Designing the Generic graphs to load the data from Source to Staging Area.
- Preparing UT, IUT and SIT test cases.
Ab Initio Senior Developer
Citigroup Private Bank
01.2013 - 12.2013
- Involved in Requirement analysis, Client/business walkthrough, Impact analysis, Functional design, Technical Design.
- Involved in developing the code as per the requirements and technical specifications related to project.
- Providing support to system integration testing and user acceptance testing.
- To understand the High level design document thoroughly.
- Preparing the detail design documents for the requirements.
- Unit test plan, unit test cases and results preparation.
- Allocating the work to trainees and mentoring them.
- Updating the status report to the client in weekly call.
- Preparing UT, IUT and SIT test cases.
- Enhanced the existing systems as per the client requirement like Concentration Process Change.
- Given UAT and Production Support.
Ab Initio Lead
Citigroup Private Bank
12.2011 - 12.2012
- Involved in Requirement analysis, Client/business walkthrough, Impact analysis, Functional design, Technical Design.
- Involved in developing the code as per the requirements and technical specifications related to project.
- Providing support to system integration testing and user acceptance testing.
- To understand the High level design document thoroughly.
- Preparing the detail design documents for the requirements.
- Unit test plan, unit test cases and results preparation.
- Allocating the work to trainees and mentoring them.
- Updating the status report to the client in weekly call.
- Designed Generic graphs for file existence, record count check and Staging loading.
- Helping the team members in their development.
- Reviewing the graphs developed by team members.
Ab Initio Lead
Citigroup Private Bank
01.2011 - 11.2011
- Handled database design for Interface module and ELV module.
- Prepared Design document for Interface Module.
- Designed generic graphs for feed loading.
- Guiding and Helping the team in their development.
- Developing Core logic of ELV from Oracle packages to AbInitio Graphs.
Ab Initio Senior Developer
Citigroup Private Bank
12.2009 - 12.2010
- Developed POC to migrate the existing batch processing from PL/SQL to Ab Initio.
- Understanding the existing business logic from PL/SQL Code.
- Preparing Design Documents for Batch process using Ab Initio as a tool.
- RTMM and CP-EU dashboard gap analysis.
- RTMM Data model analysis.
AbInitio Senior Developer
Citi group, Private Bank (CPB)
08.2006 - 12.2009
- Design and development of ETL process using Ab Initio as a tool.
- Define & build the data transmission mechanism for receiving and sending data into/from the repository.
- Establish process to consolidate data received from different external systems into the repository.
- Data verification and validation processes.
- Created Ab Initio graphs to build business logic to extract data from different external systems, validate, transform and load data to Oracle.
- Developed UNIX shell scripts for executing the graphs/jobs.
- Scheduled the jobs using Autosys scheduler.
Ab Initio Developer
AIB
08.2008 - 10.2008
- Understanding Given Business Requirements from Functional Specifications.
- Developing Ab Initio graphs as per Technical Design Document and AICC (Ab Initio Competency Centre) Development Standards.
- Unit Testing of Developed Graphs, and Unit Test Documentation.
Education
Bachelor of Technology - Computer Science Engineering
Jawaharlal Nehru Technology University (JNTU)
Hyderabad12.2006
Skills
- UNIX
- LINUX
- Windows
- C
- C
- Java
- Shell scripting
- Python
- SQL
- PL/SQL
- Ab Initio
- AWS Glue
- AUTOSYS
- Tivoli
- Dollar U
- Control-M
- Oracle
- DB2
- Teradata
- AWS Redshift
- Technical reporting
- System processes
- Performance tracking
- Project management
- Software development
- DBMS
- System integration
- Data integrity
- IT best practices
- IT risk management
- Operations improvement
- Data collection
- Technical solutions
- End-user consultation
- Business process workflow
- Troubleshooting and diagnosis
- Enterprise architecture
- Agile methodology
- Collibra DGC
- Athena
- SQL developer
- Teradata SQL assistant
- DBeaver
Timeline
Senior Technology Analyst
SouthWest Airlines
05.2023 - Current
Lead Systems Analyst
Blue Cross Blue Shield Association, BCBSA
08.2018 - 03.2023
Data Governance Lead
HSBC
02.2018 - 07.2018
Data Governance Analyst, Data Stewardship
Synchrony Financials
08.2017 - 01.2018
Ab Initio Technical Lead, SME
Fedex
02.2016 - 06.2017
Ab Initio Technical Lead
IBM
10.2014 - 02.2016
Ab Initio Lead
Citigroup Private Bank
01.2014 - 04.2014
Ab Initio Senior Developer
Citigroup Private Bank
01.2013 - 12.2013
Ab Initio Lead
Citigroup Private Bank
12.2011 - 12.2012
Ab Initio Lead
Citigroup Private Bank
01.2011 - 11.2011
Ab Initio Senior Developer
Citigroup Private Bank
12.2009 - 12.2010
Ab Initio Developer
AIB
08.2008 - 10.2008
AbInitio Senior Developer
Citi group, Private Bank (CPB)
08.2006 - 12.2009
Bachelor of Technology - Computer Science Engineering
Jawaharlal Nehru Technology University (JNTU)
Similar Profiles
Jenna PriceJenna Price
Flight Attendant at SkyWest Airlines/Southwest AirlinesFlight Attendant at SkyWest Airlines/Southwest Airlines
Margaret SaveMargaret Save
Freight Agent at Southwest AirlinesFreight Agent at Southwest Airlines
Antwan BranchAntwan Branch
Flight Attendant at Southwest AirlinesFlight Attendant at Southwest Airlines
Pedro HernandezPedro Hernandez
Administration Supervisors at SouthWest AirlinesAdministration Supervisors at SouthWest Airlines
Kelvin NguyenKelvin Nguyen
JR Data Analyst at MaxAir MechanicalJR Data Analyst at MaxAir Mechanical