RAJANIRMALA THIYAGARAJAN

EMAIL: ac73rs@r.postjobfree.com

PHONE: 806-***-****

SUMMARY OF QUALIFICATIONS

10+ years of experience as an Oracle Developer/PL/SQL Developer using Oracle as the Database in OLTP applications and batch applications. Expert level skills in Oracle, SQL, PL/SQL, Triggers, Functions, Stored Procedures and Standard Packages.

Strong background working with clients, designers, and programmers to identify requirements, provide cost analysis, assist with creating user interfaces, and develop implementation timelines.

In-depth understanding of project lifecycle in Agile methodology, including all phases of system and software development

Good experience in Oracle Forms 6i/10g/11g.

Exposure to Oracle Reports 6/6i, 9i and 10g.

Experience with Packages, Stored Procedures, Functions, Cursors and Triggers to interface application with database system.

Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TOAD, SQL Navigator and UTL_FILE.

Experience in UNIX Shell scripting (Bourne Shell, CSH, KSH and Bash) and Perl scripting.

Experience in Performance Tuning of SQL queries and Performance Refinement of the Database design leading to significant improvement in system response time and efficiency.

Experience in Application Development, Data Modeling, Data Migration, Data Conversion and Interface.

Rich experience spanning multiple technologies, and involving all different phases of the SDLC including requirements gathering, development, implementation, testing and data migration in various domains in both Agile methodology and waterfall methodology.

Highly motivated and conscientious team player with problem-solving, trouble-shooting capabilities, software installations and documentation skills.

Excellent experience in technical documentation and providing training.

Superior communication, presentation, and interpersonal skills.

TECHNICAL SKILLS

Databases: Oracle 10g/9i/8i/7.x, MS Access, MS SQL Server 6.5/7.0/2000.

Tools: Oracle Forms 6i/10g/11g, Oracle Reports 2.5/3.0/6i/9i/10g, SQL LOADER, SQL Navigator, Rapid Sql, SQL*PLUS, PL/SQL Developer, TOAD, Service Now, JIRA, Microsoft PowerBI, Microsoft Projects, Microsoft Visio.

Languages: SQL, PL/SQL, C/C++.

Scripting Languages: Shell Scripts (SH, CSH, KSH and BASH), Perl scripting, VB Script.

Job Scheduling Tools: Autosys (R4, R11 versions), Control-M

Web Technologies: HTML, DHTML, XML, UML, PHP.

Operating Systems: UNIX/LINUX, Windows 7/XP/NT/2000/98/95, MS-DOS.

SCM Tools: Version Manager.

Code Review/Quality: Atlassian Crucible, Sonar.

EDUCATION

Bachelors of Engineering in Computer Science

Madras University, TamilNadu, India (2004)

PROFESSIONAL EXPERIENCE

Employer: Veritude LLC

Client: Fidelity Investments Inc.

Role: Systems Analyst

Period: July 2018 – Dec 2018

Fidelity Investments Inc., commonly referred to as Fidelity, is a multinational financial services corporation based in Boston, Massachusetts. It is the fourth largest asset manager with $2.4 trillion in assets under management as of December 2017. Fidelity Investments operates a brokerage firm, manages a large family of mutual funds, provides fund distribution and investment advice, retirement services, wealth management, securities execution and clearance, and life insurance.

Responsibilities:

Working with business and technology partners to define, interpret, and clarify scope of opportunities and issues in terms of business and system requirements and processes.

Meeting with business and technology partners to work through functional designs.

Working with Business partners to track and resolve issues and risks.

Communicating the project health, deliverables, and impacts to Manager.

Participated in story point sizing/effort estimation for new developments and enhancements.

Owning the analysis strategy, creation and management of documentation to support agile feature delivery and ongoing platform maintenance.

Collaborating with other team members to recommend and create comprehensive and cohesive solution approaches.

Liaised with clients and vendors to resolve day-to-day problems and make process changes.

Working on estimation of various cost for Agile quest implementation (Current Operating Cost vs Upgrade Cost vs Migration Cost to Agile quest Forum (SaaS platform)).

Working with vendor to set up the SFTP process to move reports from External vendor application to internal application.

Participated in design analysis and pre- and post-installation reviews.

Perform business and data analysis, testing, debugging, audits, disaster recovery, and problem resolution.

Created Oracle Pipelined Functions to convert a single row of data into multiple rows of Name Value Pairs.

Created Oracle Function to convert a RefCursor to HTML.

Created Oracle Function to accept any delimited string and convert that to a Table Collection Type.

Created Oracle Stored Procedures with Dynamic Sqls.

Created TYPE Objects and Collection Types in Oracle.

Created UPSERT Stored Procedures in Oracle using Bulk Processing Techniques and Global Temporary Tables.

Created Generic Stored Procedures to return a RefCursor for the value of any column/table/condition input by the user.

Created Oracle Trigger to create and queue events for further downstream processing based on DML operations on a Table.

Created Oracle PL/SQL Packages for Data Quality Reports (DQ Reports) and self-healing processes to rectify any errors or exceptions thrown by the DQ reports.

Created Oracle PL/SQL Packages to email DQ reports to Business.

Created navigational and transaction triggers.

Performance Tuned Oracle Procedures, Functions and Sqls using DBMS_XPLAN, Optimizer Hints, Host Arrays, Bind Variable Peeking, Database Partitioning, Index creation, STATS gathering, Explain Plans and Trace Sessions.

Created new UNIX profiles for the implementation of Autosys R11 version.

Developed PERL jobs to automate FTP process and monitor applications.

Modified C functions used inside the PERL Jobs.

Employer: Cognizant Technology Solutions

Client: The Hartford Financial Services Group, Inc, Simsbury, CT

Role: Oracle Database Developer

Period: April 2005 – March 2016

The Hartford Financial Services Group, Inc. (NYSE: HIG) is one of the largest insurance and investment companies based in the United States, with offices in the United States, Japan, the United Kingdom, Canada, Brazil and Ireland. The Hartford Group is a leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance - as well as investment products, annuities, mutual funds, and college savings plans. The Hartford Group serves millions of customers worldwide - including individuals, institutions, and businesses - through independent agents and brokers, financial institutions, and online.

Responsibilities:

Coordinated with the business users to collect requirements and worked on logical and physical data modelling for multiple Projects.

Prepared BRS (Business Requirement Specifications) document that gives the detailed information about the requirements of the project. Designed and developed conversions to sustain business rules and flow.

Prepared the Solution Design and Detail Design documents to have all the functionalities included also impact analysis on the upstream and downstream systems.

Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Developed Database Triggers, Stored Procedures using PL/SQL.

Developed PL/SQL Functions and Stored Procedures to provide APIs for the front end to manipulate the database efficiently.

Created Oracle Pipelined Functions to convert a single row of data into multiple rows of Name Value Pairs.

Performed Data gathering and System Analysis to develop new extracts and views.

Performance Tuned Oracle Procedures, Functions and Sqls using DBMS_XPLAN, Optimizer Hints, Host Arrays, Bind Variable Peeking, Database Partitioning, Index creation, STATS gathering, Explain Plans and Trace Sessions.

Worked on ETL tools to extract and load data from flat files to the database tables.

Loaded and unloaded data sets from or to Oracle Databases using several kinds of tools such as SQL*Loader, Toad and Oracle Import/Export Facility.

Customized forms to cater to the growing needs to incorporate additional requirements.

Developed interactive and user friendly forms and Dashboards

Customized Report to change its layout like changing size of the fields, adding some extra field into the display, addition of extra logic to address special business needs and changing the display of the report. Writing after parameters triggers for the Validation of the data.

Rendered Support and enhancements to Oracle Forms used by the Business users to manipulate data in the database and schedule/create specific reports.

Developed Perl scripts to connect to database and execute queries to return RefCursors.

Implemented Multi-Threading in Perl Scripts to gain performance in time.

Developed Perl Libraries to implement file polling process.

Developed Interactive ALERTs using Perl scripting.

Developed PERL jobs to automate FTP process and monitor applications.

Created and Modified PERL Libraries and Sub Functions to meet specific business needs.

Created Shell scripts for schedules which automatically run Jobs.

Created Shell scripts for file deployments, batch conversions and environment settings.

Modified C functions used inside the PERL Jobs.

Contact this candidate