NANDHINI JOTHILINGAM
Mobile: +1-443-***-**** ********.***********@*****.***
Summary of Qualifications
Oracle PL/SQL Developer/Test Analyst with nine years of experience in Oracle 9i, 10G, 11G, 12C PL/SQL Programming, APEX, UNIX and Finacle Scripting. Expertise in performing various development tasks throughout the development life cycle right from analysis, design, development, testing, implementation to maintenance of applications. Transitioning to full-time position after a sabbatical to raise child and care for family.
Demonstrated success in end-to-end project delivery management including project planning, interacting with onsite teams, troubleshooting, managing project operational parameters, and people management.
Expertise in identifying all viable options and communicating the strategy, risks, issues and benefits of each to senior executives and stakeholders.
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of data with attention to detail and accuracy.
Strong Knowledge on Application Development using Software Development Life Cycle SDLC using various methodologies like Waterfall, Agile/Scrum.
Quick in adopting and learning new tools and technologies with excellent analytical, interpersonal and communication skills.
Solid work ethic that includes high motivation, proactive approach, and dependability.
Awarded as “STAR PERFORMER” consistently in WIPRO demonstrating hard work and contribution
Received recommendations in ORACLE from superiors for playing instrumental role in the ‘MERGES’ module
Areas of Expertise
Database: Oracle 9i, 10g, 11g, 12c
Languages: SQL, PL/SQL
Script: Finacle Scripting, UNIX Scripting
GUI: Visual Basic6.0
Tools: SQL Developer, SQL plus
Front End: Maha Report (MRT), Oracle Application Express (APEX)
Applications: MS Office
Operating System: Windows,UNIX
Experience
Allinov Research and Development private limited, India
Test Analyst, June 2017-Jan 2019
Skilled in requirement Analysis and Documentation, designing, developing and executing Test Plans and proven documentation skills.
Involved in understanding of user stories, functional design documents and prepared test strategy, test plan with overall test approach and effectively identified test scenarios.
Prepared the test data for positive and negative test scenarios as per the functional specification.
Identified, reported and tracked the defects through JIRA.
Coordinated with the development team for bug reports and fixes and tracked those tickets through JIRA.
Co-ordinated with the development team to ensure timely delivery of builds for new functionality and defect fixes.
Designed and executed SQL scripts to validate all defined criteria.
Prepared and documented Test Scenarios and Test Cases for the testing.
Provided regular status updates to project Manager on high priority issues and testing progress.
NANDHINI JOTHILINGAM
Page 2
Experience
SmartDCC, UK
Data Analyst, May 2016-May 2017
Responsible for collecting business data, analyzing information, and developing improvement and enhancement solutions based on the requirements. Used statistical techniques to analyze results from data to create ongoing reports.
Acquired data from data sources and implemented in databases.
Involved in analyzing of data using SQL.
Analyzed and interpreted patterns in complex data sets.
Performed data queries and prepared standardized reports.
Used advanced Excel functions to generate spreadsheets and pivot tables.
Developed comprehensive application documentations.
Mphasis an HP Company, India
Senior Software Developer, January 2011-April 2012
Extensively used SQL and PL/SQL for development of database modules according to project specifications. Involved in requirements, analysis, designing and developing database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers and Indexes. Developed, enhanced, modified and tested enhancements of existing application for new requirements using Oracle PL/SQL.
Utilized several tools and software technologies to ensure applications are fit for use and admissible for maintenance/upgrades.
Participate in code reviews and ensure solutions are aligned to pre-defined architectural specifications; identify/troubleshoot code-related issues; and review and provide feedback to final user documentation.
Proactively identified risks and proposed solutions to resolve.
Developed comprehensive application documentations.
Maintained quality, timeliness and accuracy of deliverables.
Handled a team of six and provided technical guidance on debugging and helping resolve technical issues.
Created Performance Feedback Forms for team and updated Project Manager about task accomplishment.
Coordinated and collaborated with onshore contacts.
Wipro Technologies, India
Senior Software Developer, May 2010-December 2010
Oversaw creation, modification, testing, performance tuning, and review of various database objects. Performed coding and testing of the modules to identify the flow of the system. Analyzed the User Requirements and translated into database requirements.
Handled a team of six and mentored team members to develop their technical skills.
Created documentations of the developed application modules for better future understanding.
Liaised with the onshore team on regular basis for Requirement clarifications and delivery issues.
Served as a Coordinator and sent Daily/Weekly status reports to Onsite and Offshore Managers.
Participated in architecture discussions, envision technical roadmap, and take responsibility of projects.
Reviewed work and assured adherence to industry best standards and practices.
NANDHINI JOTHILINGAM
Page 3
Experience
Oracle Technologies, India
Software Developer, April 2008-February 2010
Worked on frontend designing using APEX and backend PL/SQL scripts. Formulated SQL queries, functions and processes for APEX Modules.
Developed application that interfaced with Oracle databases and generated email notifications.
Contributed with database designs and worked on performance tuning in PL/SQL queries for APEX reports.
Developed APEX modules to automate the repeated and tedious Data Quality process, saving time and resources.
Generated and maintained documents of entire steps and processes for APEX Modules.
Provided APEX guidance and support to data librarians.
Modus Technologies, India
Software Developer, December 2005-March 2008
Created various standards of reports on UNIX platform using PL/SQL, MRT and Finacle scripting. Created PL/SQL packages for different reports as specified in the requirement specification, which involves Procedures, Cursors, data conversions and different levels of grouping.
Involved in tuning of existing PL/SQL packages and stored procedures.
Created and modified various MRT which is used as reporting tool for generating the report for the data fetched by the PL/SQL Packages.
Created COM file, the one which calls the package & MRT files to generate the report using shell scripting.
Prepared the Main Script used for generating the user input and to get the input from the end user by using Finacle scripting language.
Created validation scripts to check the data entered by the user by using Finacle scripting.
Prepared documentation for various reports.
Education
Anna University, India
Bachelor of Engineering in Computer Science, 2005