Developer Oracle

ROSHNI ANNA MATHEW

863-***-**** ******.*******@*****.*** LinkedIn: https://www.linkedin.com/in/roshnimathew Experience Summary

Hands-on IT Lead/Engineer having 9 years and 10 months of experience in Banking/Telecom software development

Experienced in Oracle PL/SQL, Data Modeling, Database Performance Tuning, Data Warehouse, Informatica, UNIX Shell scripting

Core competencies include requirement analysis, design, development, testing, time management, prioritization, leadership, problem resolution, decision making and possess excellent interpersonal skills

Domain expertise in Oracle Mantas Behavior Detection Platform, Payments and Billing domain

Hands on experience in SDLC Development methodologies like Waterfall and Agile

Worked with design and development tools like Erwin, PL/SQL Developer, Toad, SQL PLUS, TBMS, Business Objects, Tableau

Team player with good analytical and problem solving capacity

Experience in management activities such as providing estimates, managing delivery dates, work assignment, leave plans and revenue forecast

Education

Anna University, Tamil Nadu, India

Bachelor of Electronics and Communication Engineering 2001-2005 Achievements

Received We Applaud award for the design of DDDIN preprocessor.

Member of the team which got GTac Excellence Award from Bank of Ireland Skills Profile

Functional Skills

Management

and Leadership

Skills

Ability to lead development/support teams

Ability to prepare Technical and Functional Specifications, to do High level & Low-level Designs.

Ability to interact with clients and business users for project execution. Ability to guide junior Engineers in completing their assignments. Technical Skills

Operating

System

Windows, UNIX

Tools

Informatica 9.1, ODI, Tableau 9.2, Business Object XI R3, PL/SQL Developer 7.1, Erwin, Toad for Oracle, SQL PLUS, SVN, Clearcase, TBMS, Ant 1.x, SQL Developer 4.x, Benthic, Jira, Git Stash, HP Quality Center, DBCA 2

Databases Oracle 9i, 10g, 11g

Products

Oracle Mantas from Oracle Financial Services, TBMS Billing Solution from SunTec Business Solutions

Languages Oracle PL/SQL, Unix Shell Scripting

Professional Experience

TechPillars Inc IT Consultant, Feb 2017 – Present

Project : CoA Global – Visual AutoLoader, Verizon Data Services

Database design, develop and implement tables, views, triggers, procedures and packages for Visual Autoloader application

Create Database maintenance scripts, clean up scripts, alert scripts and schedule through Crontab

Review, Optimize and Tune existing procedures and functions, monitor server processes to ensure better performance

Generate Autoloader Utilization reports using Tableau

Create Production deployment kits and support during production roll out

Data load from Production to UAT database

Perform UIT testing. Support for SIT and UAT testing Tools and Technologies

Oracle 11g, PL/SQL, SQL Loader, UNIX shell scripting, Tableau, Crontab, Benthic, SQL Developer, Jira, Git Stash

Oracle Financial Services Software Ltd Principal Consultant, Dec 2009 – Jan-2015 Project : CitiCMT, Citi Bank June-2014 – Jan-2015

Development and testing of Citi Customizations - CitiKYC, Segmentation, Alert Risk Scoring for Anti Money Laundering applications

Manual Testing and Defect Tracking

Support for Oracle Mantas Behavior detection platform and Citi customizations for NAM and LATAM regions

Interacted with Clients to accomplish the project requirements.

Assisted various teams for SIT, UAT and Production deployments and testing Tools and Technologies

Oracle 11g, PL/SQL, SQL Loader, Informatica 9.1, UNIX shell scripting, SQL Developer, HP Quality Center

Project : SEPA Payment Application, Bank Of Ireland Dec 2009– May 2014 3

Managed all phases of database development including Database design, development of views, triggers, scripts, schedules, procedures and packages for DDIN Preprocessor and Global Funds Check modules

Design and Develop Data warehouse and DataMart for SEPA Reporting using Informatica and PL/SQL scripts

Development of SEPA Reports using Business Objects

L2 Support for Account Settlement and Account Lookup modules

Review, optimize, and tune application to ensure better performance

Support for Technical and Business Go-Live

Create and Manage Technical Design Documents

Manage Release activities

Ensured customer satisfaction by focusing on quality and communicating with customers and management, and resolving critical database issues in a timely manner. Tools and Technologies

Oracle 11g, PL/SQL, Informatica 9.1, UNIX shell scripts, Business Object XI R3, Clearcase, SVN, Erwin, PL/SQL Developer

SunTec Business Solution Pvt Ltd Implementation Engineer Oct 2005 – Dec 2009 Project: TBMS Implementation, Bahrain Telecommunication Company Oct 2005 – Dec 2009

TBMS Product configuration in Customer care, Billing, Rating modules for major banking clients

Development of customization modules in PL/SQL

Onsite team member for TBMS Billing product Implementation

Interface/Reports Development and Maintenance

Post live Support

Tools and Technologies

Oracle 10g, PL/SQL, Shell Script, TBMS, Crystal Reports, SVN, Toad for Oracle, Ant Training and Seminars

Prepared Transition documents and presented to the customers and Production Support team during KT period.

Project presentation to clients

Participated in OTNYathra 2013 conducted by All India Oracle Users Group

Participated in Sangam 2013 conducted by All India Oracle Users Group

Completed Essential Diploma for Graduate Engineers (EDGE) Course from CMC Limited References:

Available Upon Request

Contact this candidate