Developer Oracle

Tulika Agarwal

647-***-**** • ***************@*****.*** • https://ca.linkedin.com/in/tulika09 • Toronto

Summary:

5+ years of Systems Analysis experience with clients in North America

Experience with ETL (Extract, Transform and Load), Informatica Developer and PowerCenter Express

Strong experience solving complex business and technical problems using PL/SQL programming

Complete understanding of the Software Development Lifecycle methodology

Oracle Apps experience: Analysis, Design, Development, Implementation and Support of ERP applications

Expertise in SQL, PLSQL programming, Oracle Application Framework (OAF), E-Business Suite(EBS), APEX

Strong experience in Oracle Finance and Supply chain modules like OM, PO, INV, GL, AP, AR, FA

Skilled in requirement gathering, analysis, preparation and maintenance of work documents

Strong focus on systems development ensuring systems are robust yet scalable

Excellent presentation with strong written and oral communication skills

Eager to learn new technologies and tools to solve the business problem

Working knowledge of Data warehousing, Database Administration activities like performance tuning

Experience:

Systems Analyst (Xerox Corporation) Dec’ 2014 – Till date

Designed, developed and deployed solutions using Oracle database, PL/SQL and Oracle APEX

Implemented enhancement requests/change requests from business users

Executed and maintained the ETL data migration using Informatica Developer

Proven analytical skills and systematic problem solving in Informatica PowerCenter

Primary focus on core Oracle modules like OM, INV, PO, GL, AR, AP, IB

Addressed and resolved critical business issues from a technical standpoint

Created and maintained technical documents for ready reference

Provided maintenance and support for any application related issues (24/7 on call support)

Managed a team of 3 members; also participated in hiring activities of Xerox Corporation

Software Developer (Infosys Consulting) Nov’ 2011 – Dec’ 2014

Developer on an Enhancement/Maintenance Project for Arrow Electronics (North America operations)

Deep understanding of SQL, database design, data warehousing and data modelling methodologies

Provided technical (Oracle PL/SQL) support to business users on an enterprise solution project

Integrated customizations with Oracle Apps – Created scripts to deploy customizations into production

Created, modified and deployed complex Oracle Forms/Reports/Workflows

Worked closely with functional team members to develop technical design documents

Prioritized objectives and contributed to project planning and status reporting

Involved in the continuous enhancements and fixing of production problems

Developed UNIX shell scripts to automate repetitive database processes

Handled change requests (CRs) and prioritized development based on business need

Monitored and managed end user requests and reported incidents through CA ticketing system

Technical Consultant (Hi-Jinks Solutions) June’ 2010 – Nov’ 2011

Involved in SDLC – Planning, Analysis, Design, Development, Testing, Implementation and Support

Responsible for developing Packages, Tables, Views and Materialized Views for Oracle EBS application

Analyzed specifications provided by Functional analysts to create Technical documents

Identified potential threats, tracked and escalated them accordingly

Resolved production issues by coordination with technical SME’s for troubleshooting and investigation

Worked with existing systems to track and manage requirements and issues

Actively involved in system testing; ensured system has the latest code for testing

Technical Skills:

Programming Skills

SQL, PL/SQL, C, C++ and Java, Unix, Object Oriented Programming, Shell scripting

Tools

Oracle E-Business Suite (11i, R12), Reports Builder, MKS Integrity Client, Putty, FileZilla, FTP Client, Slamdunk Web Tool, HP Quality Center, CA Service Desk Manager, Oracle JDeveloper, SQL Loader, Workflow Builder, Oracle Forms 6i/10g, Oracle Application Express (APEX), MKS PTC Integrity, Informatica Developer, PowerCentre Express 9.5.1, IBM Rational Team Concert (IBM RTC), Curam

Database Scripting

SQL queries, Query Tuning & Optimization

Databases Tools

SQL Tools, Oracle Raptor, SQL Plus & Toad

Working Platforms

MS DOS, Windows XP & Windows 7, Unix

Reports

XML Publisher, MS-Excel, Oracle Reports

Change Management

RCS Version Control Tool, MKS Integrity source code control platform

Proficiency:

Ability to prioritize and execute tasks in a high-pressure environment

Self-starting Individual – eager to learn new concepts, ideas, tools and technologies

Inclination to work in a collaborative team-oriented environment

Effectively mentor and transfer knowledge to client resources/team members

Flexibility to work outside normal office hours to support business (24/7 support) and travelling

Education:

Bachelor of Technology (Electronics and Communication Engineering)

Certifications & Awards:

Certified Advanced PL/SQL Developer (Infosys Consulting)

OCP (Oracle Certified Professional) Candidate

Rising Star Award (Xerox Corporation)

SPOT Award (Infosys Consulting)

Volunteering Experience:

Member of MakeAWish Foundation – An NGO for children with terminal illness

Coordinator at Toastmasters – Nonprofit organization developing public speaking and leadership skills

Contact this candidate