APARNA KALARIKKAL, M.S.

331-***-**** ad1guo@r.postjobfree.com Carol Stream, IL

Storage Technology Developer System Engineer Data Warehousing Cloud Migration PROFESSIONAL PROFILE

SQL and ETL Developer for data warehousing projects: data migration, storage performance architecture, design, deployment, performance analysis, and debugging. In retail and healthcare environments, builds customized technical solutions and optimizes current infrastructure, architectural design, and next-generation storage products to meet performance requirements. Engaging, collaborative style; clear communicator. Adaptable to diverse team environments, work cultures, and initiatives. AREAS OF EXPERTISE

Data Warehousing: Data Conversion/Migration, Analytics, Integration Data Repositories Database Development Data Marts Conceptual Data Models Extraction Transformation & Loading (ETL) Processes Cybersecurity Stored Procedures IT DevOps: User Access Management User Acceptance Testing (UAT) Modeling HTML & XML QA Testing Cloud Computing Machine Learning Project Management Proof of Concept (PoC) Technical Tools: Operating Systems; Windows, Linux, Unix Programming Languages; C, C++, Java, R, Python Markup Languages; HTML, XML Relational Databases ; Teradata, Oracle, SQL Server, MYSQL, Netezza Cloud Data Warehouses; Snowflake, BigQuery Cloud Platforms; Amazon Web Services (AWS), Google Cloud Platform ETL Tools; Informatica PowerCenter, DBT Scheduling; TWS Maestro Project Tracking; JIRA Version Control; GitHub Data Science/ML Processor; Watson Studios Linux Tools; Shell Scrips, Cron, AWK, SED, Mail, SFTP, Join, GPG Microsoft Office Suite; Excel, Word, PowerPoint PROFESSIONAL EXPERIENCE

INFOSYS LTD. THIRUVANANTHAPURAM, KERALA, INDIA 2018 to 2023 Technology Analyst: Data Modeler, GCP Developer 2022 to 2023 Client: Metro AG: Teradata to BigQuery cloud data migration project. Analyzed legacy ETL processes (DBT) to reconfigure for cloud migration. Created and monitored objects (BigQuery); placed objects in GitHub repositories for version control. Assisted head developer with CI/CD setup for Dev/QA environments (GitHub). Created .yml workflows for CI/CD. Supported MicroStrategy team members with back-end support to enable front-end sales report development; component of a major two month proof of concept (PoC).

User and group access administrator to team and sub-team members (BigQuery, GitHub, JIRA). Senior System Engineer: ETL & Snowflake Developer 2019 to 2020 Client: REI: Netezza to Snowflake cloud data migration project. Worked with source data from AWS S3 flat files in external stages; included formats such as CSV, JSON, and XML.

Created Snowflake tables and views from STT mapping documents. Coded and tested Python scripts to automate ETL load into Snowflake DW. Supported QA team on test cases and bug fixes. Identified, analyzed, and resolved infrastructure vulnerabilities and application deployment issues.

Monitored application and infrastructure performance with metrics e.g. CPU and memory usage, response time, error rates, server and application instances, request rates, and availability. System Engineer: ETL Informatica & Teradata Developer 6/2018 to 5/2019 and 6/2020 to 11/2020 Client: CVS Pharmacy Health: Collaborated with business analysts to understand/define requirements. Executed models using business logic parameters. Developed mappings, workflows, and tasks (Informatica PowerCenter – Developer, Workflow Manager, Repository).

Pulled data from source systems; cleansed, transformed, and loaded data into Teradata DW (Informatica ETL). Loaded data to target tables (BTEQ, Fast Load, Multi Load, TPT).

Automated and scheduled Informatica workflows and BTEQs (Unix scripts). Managed and monitored ETL jobs (TWS Maestro). EDUCATION – CERTIFICATIONS – PROFESSIONAL DEVELOPMENT Master of Science (MS), Computer Science & Engineering Mar Baselios College of Engineering & Technology Trivandrum, India 8.28 GPA Bachelor Science (BS), Computer Science & Engineering Marian Engineering College Trivandrum, India 8.02 GPA IBM Practitioner Certifications: Cybersecurity Data Science Enterprise Design Thinking Infosys Global Agile Developer Certification IBM Training: Introduction to Cloud