Anjana A

Leading a team of 4, responsible for main stream info delivery for a prominent BFSI firm headquartered in New York.

Working directly and actively with client team and involved in entire lifecycle of info delivery right from requirement analysis to post production support

Roles & Responsibilities

• Created effective ETL module by designing in Pentaho Data Integration PDI
• Designed SQL queries encapsulated in ETL jobs and transformation logics
• Managed end-to-end delivery process while investigating failures through root cause analysis
• Developed tailored modules in Denodo Design Studio to align with project specifications
• Managed job scheduling through Pentaho, ensuring smooth end-to-end flow
• Developed functional modules using PL/SQL and ensured reusability of code to maximise the productivity
• Involved in deploying codes to Production and providing necessary support after deployment
• Conducted testing on ETL and SQL modules before delivering them to Quality Assurance team
• Achieved timely delivery by collaborating with QA and Prod support

Worked as a software developer in the Healthcare & Insurance domain for clients located across US.

Mainly worked on ETL tools like Informatica and SQL queries for generating the day to day reports and building report box.

Roles & Responsibilities

• Understanding the concepts of data warehousing with ETL tools, Informatica
• Ask meaningful questions to get clarity on the business problems
• Responsible for team learning and knowledge sharing sessions
• Simplifying the business touch points to speed up the delivery without compromising the quality
• Identifying and eliminating the manual works by coming up with better automation tools to speed up the implementation of projects
• Coordinator between onsite and offshore team and active participation in daily status calls
• Analyzing the requirement and preparing the design document
• Performing the feasibility check of the report and providing solutions to the stakeholders
• Responsible for design and development of SQL modules based on the requirement from on-site stakeholders
• Performing unit testing of the SQL modules to ensure better productivity and code quality
• Creation of Technical Design documents, Collibra templates and UTR document
• Deploying the module in HRP Adhoc tool and generating the report
• Created and maintained daily and weekly status reports and shared the health of project with the stakeholders
• Worked on production issues and defect prevention