Anjana Nair Email & Phone Number

Amsterdam, Nh, Nl

Netherlands

Led the design and development of complex ETL processes using Informatica PowerCenter to extract, transform, and load data from various sources into the Snowflake and Oracle data warehouses.Architected and implemented Data Vault models to support scalable data warehousing solutions, ensuring data integrity, traceability, and accessibility for reporting and analytics.Utilized Oracle APEX for building interactive dashboards and reports, enhancing data visualization and user experience for business stakeholders.Conducted performance tuning of ETL processes and SQL queries to optimize data load times and improve system efficiency, resulting in a 30% reduction in processing time.Collaborated with cross-functional teams to gather requirements, design solutions, and deliver BI applications that meet business needs and drive data-driven decision making.Mentored and provided technical guidance to junior BI developers, fostering a culture of continuous learning and improvement.Documented ETL processes, data models, and best practices to ensure knowledge transfer and maintainability of BI solutions.Participated in agile ceremonies, such as sprint planning, daily standups, and retrospectives, to ensure effective project management and delivery Implemented data integration solutions using Informatica and Snowflake, ensuring seamless data flow between on-premises and cloud environments.Developed shell scripts for automating data processing tasks and improving operational efficiency.Engaged in data modeling activities, focusing on dimensional modeling techniques to facilitate effective data analysis.Assisted in the migration of legacy systems to modern data platforms, enhancing data accessibility and reporting capabilities.Conducted unit testing, system integration testing, and user acceptance testing to ensure the quality and reliability of BI solutions.

Amsterdam Area, Netherlands

Designing the ETL solution to ingest the raw source data into a Staging Area and the downstream Foundation layer which provides an Enterprise Data Store (in 3NF model) that specifically for access / reporting

Thiruvananthapuram, Kerala, India

* Align with Business to elicit requirements for initial design and change requests in future Implement ETL solution using Informatica PowerCenter 10.2 and Unix shells scripting* ETL code unit testing and do defect analysis and fix activities* Create Deployment Documents* Production support for the Informatica process, troubleshoot and debug any errors

Thiruvananthapuram Area, India

* Designed the ETL solution for integrating WiFree hotspots data for 11 countries from disparate sources into a single repository, geo-coding the addresses via Carto geo-coding service, identifying delta, uploading hotspots on to cloud platform and maintaining history of each hotspot using SCD Type 2 logic* Implemented ETL solution using Informatica PowerCenter 9.6 and Unix shell scripts Designed map front end and productionized it using Carto CSS* Worked closely with mobile application development team for integrating the map with the mobile applications for iOs and Android versions* Developed Power BI dashboard for Incident Management Resolution for Hotspot Finder* Created pipelines using Microsoft Azure platform for ingesting data from real-time on premise Oracle database to Azure Data Lake Store to create a cloud source database for Power BI dashboard

Core Adherence program is to identify patients who have received Patient Care Initiativesinterventions from client Pharmacy; at the time that patient is not a member of this pharmacy.RxDW (Prescription data warehouse) will identify these patients by matching the client Patient,Payer and Provider data to retail customers and provide the client reporting. The aim is to makethose Non PBM clients to PBM clients. (PBM-Pharmacy Benefits Manager)Role and Responsibilities: •On-call Production Support for Data warehousing and Business Intelligence jobs andapplications• Managing DWH Unix/Informatica ETL load Production issues and its recovery steps• Implementation of Bug fixes and Service Improvement Plans• Managing team in responding and resolving end user’s service requests within SLA• Major and minor enhancements around Whole and retail business chains for the Customer

India

Oracle RMS is a centralized system for managing and tracking inventory, an enterprise solutionthat integrates items, suppliers, and locations for the life cycle of the items. The project involvedcapturing item data events (like item addition/deletes/updates) from RMS and generatingcorresponding XML messages which were loaded into MQ queue for use by a platform called forDirect Pricing Engine)Roles and Responsibilities:• Worked closely with client for the entire project duration• Development and Unit Testing using Informatica PowerCenter and Toad for Oracle• Creation Detailed design documents• Participated in code and design reviews and also used check style tool for code qualityimprovements.

Netherlands

The objective of this project was to retrieve the Talkmobile Pay Monthly Upgrade salesinformation which included both automated eligibility checks and activations through the BOreportsRoles and Responsibilities:• Analyzed business requirements document and prepared estimates• Presented High Level Design (HLD) Workshop with client Solution Architect•Created HLD document and presented an HLD walkthrough with development team beforecode commencement• Development and Unit Testing using Informatica PowerCenter and Toad for Oracle• Creation Detailed design documents• Coordinated with multiple vendors from geographically distributed teams during codedeployment, testing and migration to Production environment

Thiruvananthapuram Area, India

* Analyzed business requirements document and prepared estimates* Presented High Level Design (HLD) Workshop with client Solution Architect* Created HLD document and presented an HLD walkthrough with development team before code commencement* Development and Unit Testing using Informatica PowerCenter and Toad for Oracle* Creation Detailed design documents* Coordinated with multiple vendors from geographically distributed teams during code deployment, testing and migration to Production environment

India

The objective of this project was to build ETL components for loading UNICA Campaign Martwhich will enable client business users to set up and execute effective marketing campaignsRoles and Responsibilities:• Creation Detailed design documents• Worked with a team of 5 to develop the ETL solution using Informatica that would enabletransition from Epiphany to Unica.• Created and tested Unix shell scripts transfer and to validate files between various hosts• Managed communication with third party teams to align the solution with businessrequirements.•Engaged in the different phases of internal and User acceptance testing of the developedsolution.• Was involved in the live rollout and warranty support phase