Seasoned Data Analyst with over 4 years of experience in Python, SQL, ETL pipeline development, and data automation. Strong foundation of 12 years in IT spanning finance, operations, and application support. Skilled in backend scripting using Perl, proficient in reporting with Tableau and Excel. Adept at streamlining workflows through Git and shell scripting. Actively utilising advanced language models like ChatGPT and Claude for efficient engineering tasks, code generation, and data cleansing. Eager to tackle challenging roles in data engineering and solutions architecture within product/GCC environments.
• Developed and optimized Python scripts for reporting, ETL processes, and data manipulation.
• Leveraged Chat GPT and Claude to auto-generate Perl/SQL code modules, reducing scripting time by 30%.
• Built prompt templates and workflows for data cleaning, report automation, and QA; standardized prompt usage across the team.
• Designed and maintained 10+ automated ETL pipelines using Perl and Oracle, driving faster turnaround for monthly and quarterly reporting.
• Rebuilt legacy reports into modular Perl scripts with dynamic parameters, reducing code redundancy and maintenance effort.
• Developed and managed Excel/CSV outputs consumed by senior management across departments.
• Created and maintained over 30+ automated reporting solutions across daily, weekly, monthly, quarterly, and ad-hoc use cases.
• Implemented JSON-based intermediate storage for YTD/MTD/QTD performance calculations.
• Built internal Perl-based upload tools to insert external datasets into Oracle tables.
• Optimized SQL queries and materialized views for high-volume datasets.
• Supported data model enhancements, handling schema revisions and dependency tracking.
• Initiated version control (Git) integration for internal analytics scripts.
• Acted as a bridge between business users and tech teams for ad-hoc report customization.
• Partnered with business to align KPIs with system logic, streamlining compliance reports.
Languages & Tools: Python SQL Perl Oracle Shell Scripting Git
ETL & Data Engineering: ETL Pipelines Data Modeling Data Cleaning JSON Workflows
Analytics & BI: Tableau Excel (Advanced) R Data Mining
AI & Prompt Engineering: Chat GPT Claude Prompt design & optimization LLM-driven code generation Prompt library creation
Marketing & Tracking: Google Analytics Web Analytics