Jyothirmayee Thota

Results-oriented Operations Lead specific to Cisco's subscriptions and installed products fact tables. Served as onshore support for CAFE' (Customer Assets Data Foundation) team, which involved incident management and debugging, continuous monitoring of BODS and ControlM jobs, data population and feed management, temporary fixes and support.

• First responders: When a job throws an error, we are the first responders. We will dig through the code to find the root cause before escalating to the core dev team.
• Threads and workload management: Cisco uses Control-M, which is batch scheduling. We manage the "workflow" of data, restarting failed jobs, managing dependencies, and ensuring the "nightly run" finishes before the business opens in the morning.
• Identifying code issues in scripted calculation views (Hana Studio): Debugging massive scripted views often involves tracing logic through execution plans, rather than just reading lines of code. Break the complex view into smaller SQL Script Table Functions, allowing us to test and debug isolated blocks of logic more easily than a single 1,000+ line view.
• Temporary Data Fixes: If a feed fails or a bug corrupts a database record, I have written scripts to manually "patch" or "inject" data, so downstream systems can keep running while a permanent code fix is developed.
• Monthly/Quarterly Feeds: These are high-stakes reporting cycles (often for finance or regulatory compliance). Our team ensures that massive amounts of data are processed and delivered to stakeholders, or third parties, on a strict deadline.
• Liaising with the Offshore Team: I am the primary point of contact for teams in different time zones (IST, PST, and EST). This involves setting clear expectations, managing handovers, and careful monitoring of jobs that are running in different time zones.
• Incident/escalation management: CAFE's operations team works on incidents raised by different end users, and issues range from data manipulation, code debugging, and platform support. I own and publish the dashboard where bottlenecks are identified before they become red items.
• Support during Outage & Downtime: My team provides support to platform teams when there is a scheduled outage or downtime. Ensured all critical processes (such as data backups or batch jobs) are successfully completed or paused before the downtime begins. Conducted Quality Assurance (QA) and manual testing once systems are back online to verify that everything is running optimally.
• Root Cause & Planning: For every new issue, I have been involved in the post-mortem. Instead of just fixing a symptom, I have helped to create a 'Standard Operating Procedure' (SOP) to ensure the same mistake doesn't happen twice.

• Engaged with NEDD program, involved in designing mapplets that effectively mask PHI and PII data.
• Created adaptable mapplets suitable for diverse data processing streams.
• Participated in analysis phase by executing profiles to reveal source data for effective masking.
• Migrated production data into safe rooms and gold copies to facilitate secure masking activities.
• Provisioned necessary tables/files within lower environments to ensure accurate masking of PHI or PII columns.
• Monitored FTP sites using file watch events during extensive file masking efforts.
• Engineered workflows with multiple session types, incorporating variable assignments between sessions.
• Achieved organization-wide implementation of key masking techniques for consistent date, numeric, and string data types.

• Established staging area for hourly data loading from OLTP source systems into data warehouse.
• Executed data cleansing processes, including space removal and record identification, using ETL datetime column.
• Utilized Informatica TDM for efficient table loading into Oracle database.
• Developed and maintained staging areas for multiple data sources, ensuring data integrity during transfers.
• Applied performance tuning techniques, such as session partitioning and network packet size adjustments, to enhance throughput.
• Documented technical specifications and project deliverables for clarity and compliance in AEP projects.
• Leveraged PowerExchange CDC to synchronize target tables with source data effectively.
• Employed CA Workstation ESP scheduling tool to manage job scheduling and dependencies based on business needs.

• Executed data masking project for CVS Health, addressing company-wide requirements for sensitive data protection.
• Developed ETL solutions and mapplets for diverse databases and flat files based on application team requests.
• Collaborated extensively with Oracle, Teradata, Microsoft SQL, and flat files to establish permanent masking codes.
• Implemented step-by-step ETL processes for data masking across 350 Oracle tables, ensuring validation and re-indexing.
• Designed a partitioning mechanism for processing large Teradata tables containing over 3 billion records.
• Created email notifications within Informatica session scripts for immediate issue resolution.
• Utilized Informatica PowerCenter session parameters and mapping variables to enable flexible workflow executions.
• Automated loading processes by developing and modifying Unix shell scripts, scheduling tasks with pmcmd.

• Optimized Informatica workflows by executing complex performance tuning techniques to accelerate execution time.
• Applied effective partitioning mechanisms and transformation tuning to enhance mapping efficiency.
• Acquired expertise in optimizing complex SQL queries within RDBMS environments like Netezza and DB2.
• Designed and implemented high-quality ETL solutions to bolster execution speed.
• Evaluated business logic and Informatica objects, proposing solutions to elevate performance without disrupting data integrity.
• Adhered to client coding standards, conducting code reviews to ensure compliance.
• Developed ETL procedures and improved query performance through database view creation.
• Conducted unit, functional, and performance testing on ETL objects.

• Gathered business requirements and analyzed health insurance data to identify data warehouse dependencies and capacities.
• Designed, developed, and supported all data warehouse projects with a focus on performance.
• Created SCD Type-I and Type-II mappings in Informatica to efficiently load data from various sources.
• Developed Informatica transformations for loading transactional data into enterprise data warehouse.
• Evaluated Informatica PowerCenter and PowerExchange for Oracle CDC architecture suitability.
• Established email notifications through Informatica session scripts and email tasks for operational alerts.
• Collaborated with business analysts, QA, and database administrators to ensure project alignment.
• Documented complete project lifecycle including technical design documents and unit test results.

• Involved in gathering business requirements and created functional/technical specifications used for further development of the warehouse.
• Analyzed existing system and developed business documentation on changes required.
• Created and adjusted Data Model and SQL scripts through create and alter tables.
• Extensively worked on Informatica Source Analyzer, Target designer, Transformation developer, Mapplet designer and Mapping Designer.
• Developed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Responsible for validation of output files from production mainframe environment.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation type for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions.
• Worked on Teradata Store procedures and functions to confirm the data and load it on the table.
• Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.
• Used SQL Assistant to query Teradata tables, wrote BTEQ scripts to run complex queries on the Teradata database.
• Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
• Extensively involved in testing the system from end to end to ensure data quality.
• Responsible for documenting business, functional and technical details gathered during analysis, design, development and testing phases.
• Bank of America is a huge banking application, which deals with several areas of retail banking. It has several modules named Savings, Current, Deposits, Loans, ATM and foreign exchange transactions.

• Utilized Informatica Client tools extensively to develop mappings and transformations.
• Created and configured reusable mapplets for efficient mapping processes.
• Designed comprehensive data models using ERwin 3.5, integrating with Oracle databases.
• Conducted analysis of converted data to determine quality baselines for warehouse metrics.
• Executed data manipulations with basic functions and various Informatica transformations.
• Developed detailed reports and universes using Business Objects for enhanced business insights.
• Oversaw development of a data mart focused on biological data for reporting needs.
• Leveraged debugging techniques to ensure accurate data flow within mappings.