ARCHANA NAIR

Tools: SQL Developer, Oracle Cloud Infrastructure, APEX, SQL Loader

Languages: SQL, PL/SQL, Python

Script: Unix, Shell, Terraform

DevOps Tools: Git, Jenkins

Project Planning Tools: JIRA, Confluence

Value Navigator is a tool set that automates value deliverables to support account planning and opportunity progression and consolidates value selling in the sales process for the user.

• Lead the team to ensure timely and successful delivery of project deliverables.
• Implementation of Data Models aligned with project specifications and business needs.
• Design the Database and Develop the different Objects like Functions, Procedures, Packages etc.
• Maintain and support of an existing Oracle APEX Application which is used for Data manipulation.
• Generate Unit Test Cases and perform Unit Testing in the Development.
• Create Technical Design Documents including the architectural diagrams.
• Hands-on experience with deployments using CI/CD pipelines for streamlined and automated delivery.
• Enhanced application performance by optimizing business logic and fine-tuning database queries.
• Implemented Database analytics solutions for stakeholders for decision-making and strategic planning.
• Automated manual, labor-intensive tasks to accelerate the delivery of new product versions.
• Production support of a highly visible and critical application within Oracle Application Labs.
• Conduct thorough code reviews to ensure quality and identify improvement opportunities.
• Performed Database Administration tasks using Terraform, managed Data Migration, and ensured High availability and uptime of Databases.

Client: ANZ Wealth 16-Nov-2015 to 22-Dec-2017

Tools: SQL Developer, SVN, Control-M

Languages: SQL, PL/SQL, Cobol

Script: Unix, Shell

Gatekeeper is the application used by ANZ employees to manage their customers data effectively.

• Estimate the work in terms of Number of days and get the cost approved from customers.
• Create Database objects, such as Procedures and Functions, to meet business requirements.
• Generate ad hoc reports using SQL queries based on business requirements.
• Automate jobs using Control-M.
• Create Unit Test Documentation, Test Summary Reports, Implementation Plans etc.
• Functional and Technical Support to New Joiners in the team.

Client: ING Bank 06- Jun-2013 to 15- Nov-2015

Tools: SQL Developer, TIBCO, Power Designer

DevOps Tools: Git, Jenkins

Project Planning Tools: JIRA, Confluence

Payment Order Initiation (POI) is the platform allows customers to initiate payments directly from their ING bank account.

• Requirement gathering, Impact Analysis and providing the story points in the Sprint Planning meeting.
• Created different Database Objects to cater the requirement.
• Written Efficient SQL Queries to be used in the backend tool, TIBCO.
• Performed Unit Testing, Regression Testing, and Integration Testing.
• Managed Functional Design Documents, Technical Design Documents and Physical Data Model using Power Designer.
• Debugged and fixed the production issues.
• Demonstrated the working software during review meetings.
• Give KT to other team members and testers.