Megha Naran

• Overview: The Cisco workforce Data Domain focuses on managing and optimizing employee related data across the organization. It includes data on employee demographics, roles, skills, talent, management, time, absence, and many other details.

Key Responsibilities:

• The cisco Integration Hub acts as a centralized platform that enables seamless data exchange between various systems such as HR, Payroll among other
• Provided effective migration solutions from Teradata/Informatica to BQ/DBT.
• Prepared Functional Design Document and Business Requirements Document to clearly define project scope, business needs, and system specifications for key HR data.
• Managed entire process, including development, testing, and production deployment.
• Conducted unit testing to verify the functionality of individual components.
• Designed and executed test cases for unit and regression tests, identifying and resolving defects to maintain high-quality standards.
• Utilized dbt to automate and enhance verification of data integrity.
• Developed modular and maintainable SQL code to transform raw data into analytical datasets.
• Automated data quality checks using the dbt testing framework.
• Developed dbt macros to improve reusability across multiple dbt models.

• Overview: Partners and their SOW details are tracked and managed in the FieldGlass application. To enable a new VMS system called Beeline, ensured smooth transition and seamless integration for C-worker data.

Key Responsibilities:

• Evaluated current Teradata/Informatica code for optimization.
• Directed comprehensive lifecycle including development, thorough testing, and successful deployment.
• Executed thorough end-to-end testing to maintain application quality.
• Developed automated scripts for seamless file transfer. And implemented a process for efficient file archival.
• Ensured data integrity by comparing information across Teradata and Big Query.
• Ensured effective communication between all downstream applications and stakeholders.

• Overview : iACV is a sophisticated recurring revenue prediction tool designed to forecast recurring revenues for software and services based on multi-year contracts. It also calculates compensation, goaling, and product performance metrics.

Key Responsibilities:

• Lead a dynamic team of 12 members, overseeing L2 activities and ensuring seamless team performance.
• Collaborate closely with stakeholders to identify, prioritize, and resolve requirements, issues, and bug fixes.
• Conduct comprehensive unit and regression testing, ensuring high-quality production deployments.
• Demonstrate exceptional coordination skills, ensuring efficient team collaboration and task execution.
• Serve as a result-oriented leader, consistently delivering projects on time and within budgetary constraints.
• Monitor, maintain, troubleshoot, and perform administrative operations within the iACV application, ensuring system reliability.
• Conduct thorough data validation for key metrics to ensure accuracy and consistency.
• Proactively address and resolve P1 issues and post-production concerns in accordance with SLAs.

Overview:
Cisco's existing data warehouse is a robust 7-terabyte Oracle database that stores critical historical and operational data for various business measures, including Quotes, Service Contracts, Expenses, and more, enabling Cisco Systems, Inc. to efficiently manage and analyze vast amounts of business data.

Key Responsibilities

• Prepare detailed Source System Analysis (SSA) documents in alignment with Logical Data Models (LDM) to ensure accurate data mapping.
• Design and develop BTEQ scripts to efficiently load historical data into the system, ensuring data consistency.
• Collaborate on the design and development of a comprehensive ETL (Extract, Transform, Load) strategy to migrate incremental data from Oracle to Teradata, optimizing data flow and processing.
• Develop and implement Audit and Replic workflows to ensure data integrity and smooth synchronization across systems.
• Deploy development objects to the QA environment, ensuring all necessary approvals and proper testing protocols are followed.
• Maintain and manage key documentation, including design documents, business requirement documents, and production issue logs/statistics, and upload them to Cisco’s live link for streamlined sharing and maintenance.
• Strictly adhere to Cisco’s IT quality procedures, ensuring compliance with internal standards and best practices.
• Conduct rigorous testing of applications, including unit testing and pre-integration testing, to validate functionality and identify potential issues early.
• Perform comprehensive impact analysis of client specifications, evaluating potential effects on existing systems and workflows.
• Design and implement Semantic, Business, and Replic views, populating them from 3NF tables based on business requirements to support effective reporting and analysis.
• Optimize and tune SQL queries to achieve expected performance levels, ensuring fast and reliable data retrieval.

Overview:
The primary objective is to track and document all data movements and transformations occurring for yearly aggregates within the designated subject areas. The goal is to effectively record and communicate data related to these subject areas for use by both IT and business users.

Key Responsibilities:

• Conduct in-depth analysis of client-provided specifications to ensure a clear understanding of requirements.
• Prepare comprehensive Source System Analysis (SSA) documents in alignment with Logical Data Models (LDM).
• Develop BTEQ scripts to efficiently load historical data into the system.
• Contribute to the design and development of ETL (Extract, Transform, Load) strategies for seamless data migration from Oracle to Teradata, ensuring incremental data is loaded accurately.
• Design and implement robust Audit and Replic workflows to ensure data integrity and consistency.
• Oversee the deployment of development objects to the QA environment, ensuring all necessary approvals are in place.
• Maintain and update essential documentation, including design documents, Business Requirement documents, and Production issue logs/statistics, while ensuring they are easily accessible on Cisco’s live link for seamless sharing and maintenance.
• Ensure strict adherence to Cisco’s IT quality standards and procedures throughout the project lifecycle.
• Conduct thorough testing of applications, including unit testing and pre-integration testing, to ensure functional accuracy.
• Perform a detailed impact analysis based on the specifications provided by clients, assessing the potential effects on the overall system.
• Design and create Semantic, Business, and Replic views, populating them from 3NF tables according to business requirements.
• Optimize and tune SQL queries to ensure peak performance and meet performance expectations.

• Overview: The attach rate is one of the important measurements used in the Cisco Customer Advocacy (CA) organization for future planning and decision-making.

Key responsibilities :

• Involvement in Design/Implementation.
• Deploying the development objects to QA with all the necessary approvals
• Maintaining design documents, business requirement documents, and production issue logs/statistics, and uploading them to Cisco's live link for easy sharing and maintenance.
• Adherence to quality procedures, as per Cisco's IT standards.
• Prepare the test cases for the unit testing.
• Conducting an impact analysis of the specifications provided by the clients.
• Coding based on the specifications provided by the client and according to the checklist.
• Testing application (includes the unit testing and pre-integration testing).
• Tuning the queries to provide the expected performance.
• The Attach Rate is one of the important measurements used in the Cisco Customer Advocacy (CA) organization for future planning and decision-making.