Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Farzana Ansari

ETL Engineer
Bengaluru

Summary

Data Engineer with 3+ years of experience in Life Sciences, specializing in Model N products. Expertise in Revenue Cycle Management, Master Data Management, and advanced data modeling. Proficient in Oracle PL/SQL, ETL, Python, and data warehousing, with a solid foundation in ITSM operations and business analysis.

Overview

4
4
years of professional experience
3
3
Certifications

Work History

ETL Developer

Accenture
Bengaluru
10.2021 - Current
  • Demonstrated expertise in Revenue Cycle Management, Master Data Management, and advanced data modeling techniques to streamline data processes.
  • Implemented ETL and data warehousing solutions with Informatica, streamlining data management processes.
  • Utilized strong background in ITSM operations and business analysis to streamline data processes and improve system performance.
  • Applied advanced skills in Oracle PL/SQL to support robust data warehousing initiatives, driving business insights.
  • Managed pharma contract administration processes, including chargeback, membership management, and rebates, utilizing Model N effectively.
  • Ensured SOX compliance and provided audit support for data submissions.
  • Developed and refined Oracle PL/SQL functions, procedures, packages, and triggers to support efficient database operations.
  • Developed interface logic utilizing Unix Shell Scripting and Python to enhance system functionality.
  • Led ITSM operations encompassing incident, problem, change, and release management, optimizing service delivery and maintaining system integrity.
  • Performed data validation and payment calculations to maintain integrity of revenue management processes and provide reliable source data for downstream systems.
  • Reviewed and interpreted business requirements to drive process enhancements while ensuring alignment with key business priorities.

Education

Bachelor of Technology - Computer Science

College of Engineering And Management, Punnapra
06.2024 -

Skills

Oracle PL/SQL skills

Informatica tool expertise

Unix shell scripting

API integration capabilities

SQL and Python programming

Revenue cycle management

Governance of master data

Analytical problem-solving skills

Communication effectiveness

Project collaboration planning

UI design knowledge

Power BI experience

IT service management operations

ETL methodologies

AWS cloud services

Certification

AWS Developer Associate: CloudFormation

Timeline

Bachelor of Technology - Computer Science

College of Engineering And Management, Punnapra
06.2024 -

ETL Developer

Accenture
10.2021 - Current
Farzana AnsariETL Engineer