Sql Oracle
Resume:
Karthiyayini Thaththathreyan
************.*@***.***
An accomplished Oracle PL/SQL developer with 7+ Years of experience in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Has strong technical skillset in UNIX Shell Scripting, Oracle PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Materialized Views, SQL Loader and Performance tuning. Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. An effective person with proven abilities in leading teams and always a front initiator for providing effective solutions for the challenges.
Expertise Summary:
•Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
•Expertise in Client-Server application development using Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
•Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
•Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
•Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
•Developed materialized views for data replication in distributed environments.
•Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
•Partitioned large Tables using range partition technique.
•Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
•Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
•Worked extensively on Ref Cursor, External Tables and Collections.
•Expertise in Dynamic SQL, Collections and Exception handling.
•Experience in SQL performance tuning using Cost-Based Optimization (CBO).
•Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
•Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
•Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
•Used job scheduler and monitored the execution of the job for daily/weekly/monthly jobs
•Have working knowledge of ticketing tools like JIRA, Remedy, HP Quality Center
•Strong ability to troubleshoot any issues generated while building, deploying and in production support.
•Strong analytical, diagnostics, troubleshooting skills to consistently deliver productive technological solutions.
•Highly motivated to learn new Developments in Technology with strong analytical, problem solving skills and a flair for creativity.
•Ability to grasp latest technologies and to properly apply new tools to build applications.
•Good Interpersonal Skills, team-working attitude, takes initiatives and very proactive in solving problems and providing best solutions.
•Worked closely with Project Manager, Development, Testing & Production teams to align Project deliverables, dates & report issues/concerns.
•Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Technical Summary
Operating Systems :
Windows 2003 server/XP/7/8.1/10, Unix-Solaris/AIX
Language/Technology :
UNIX Shell Scripting, Perl, Oracle PL/SQL, Core Java
Database Servers :
Oracle 9i/10g/11g, MS SQL Server 2005, FoxPro
Development Tools :
Toad, SQL Developer, Service Now, Putty, Cisco FTP, HP Quality Center, Tivoli Workload Scheduler(TWS), CTRL-M
Reporting Tools :
Oracle Discoverer 2000
Version Control Systems :
MS Visual Source Safe (VSS), SVN (Sub-Version), CVS, Serena PVCS, GIT
Education/Certifications:
Bachelors in Electronics and Communications Engineering - 2009
Professional Experience:
Project Name: Single Billing Platform
Client Name: Change Healthcare, Nashville, TN
Role: Oracle PL/SQL Developer
Duration: Aug ’16 – Till now
Description: This client is a leading provider of revenue and payment cycle management and clinical information exchange solutions, connecting payers, providers and patients in the U.S. healthcare system. To have a seamless customer service and serve the big customer base, it should have a proper billing system which will be the single point of truth for client’s revenue and billing and customer invoicing. The main function of single billing Platform(SBP)is Transaction Loading and invoice calculation. There would be millions of transactions taking place in a month between Provider and Payer via client. Those transactions are loaded into SBP and these can happen either by Batch or Real Time System. Real Time system Transaction come to SBP through Feed files whereas in case of Batch it would be imported from Remote DB. Invoices are calculated for these transactions based on the prices that have been fixed for the transactions at the time of contract. After the invoice calculation is over, the invoice would be sent to Oracle AR as a feed file. From Oracle AR, it would be sent to a system which is used for printing and mailing details to customer.
Responsibilities:
•Responsible for migrating client System to Single Billing Platform (SBP) Application.
•Involved during the month end activities to generate invoice for customers.
•Collaborating with Technical Experts and Business units in gathering high-level business requirement and functional requirements using various requirement modelling and UML tools. Responsible for defining the application tiers, frameworks, components types and interfaces.
•Involved in tuning and performance enhancement in SBP. Coordinate with onsite/offshore team for issue resolution of technical/functional cases.
•Coordinated with the frontend design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
•Created and modified several UNIX shell Scripts per the changing needs of the project and client requirements.
•Worked on Fox pro to Oracle Migration where converted VB Scripts to Oracle Procedures/Packages
•Involved in the continuous enhancements and fixing of production problems.
•Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
•Developed PL/SQL triggers and master tables for automatic creation of primary keys.
•Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
•Created indexes on the tables for faster retrieval of the data to enhance database performance.
•Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
•Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE and AUTOTRACE.
•Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
•Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
•Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
•Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
•Partitioned the fact tables and materialized views to enhance the performance.
•Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
•Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Project Name: LifeCAD
Client Name: Voya Financial Services, Des Moines, IA
Role: Oracle PL/SQL Developer
Duration: Mar ’15 – July ‘16
Description: This client is a leading provider of retirement products and services in the U.S. serving more than 46,000 institutional clients and nearly 5 million individual retirement plan investors. It also has 2,300 financial advisors serving the retail market. Their Retirement business is focused on guiding Americans to greater retirement readiness through employer-sponsored savings plans and holistic retirement and income guidance. Annuities offers fixed, fixed-index and immediate annuities aimed at helping individuals save and protect their retirement savings, serving over 417,000 retail fixed annuity product customers.
Life CAD is an annuity administration system developed in four layers. The front end i.e. Life CAD client is developed in Power Builder Client version 8.0. It calls the middle tier functions written in C/C++. The Middle tier layer contains all the business logics. It connects with the database using the CORBA architecture developed in C++
In the backend Oracle 10g is used as the database. There is a web interface named Customer Portal developed in JAVA and connects with the database using OC4J which contains CORBA servlets. Apart from Life CAD client, GARWIN also makes calls to this JAVA based portal. There are batch jobs written in AIX shell scripts which run in batch cycles and send feedback to other systems. Oracle discoverer generates reports from the database and sends them to client. There is an Agent master database named PAIS and an agent commission database named AMS. Life CAD client connect with PAIS through PAIS servlet in the OC4J layer
Responsibilities:
Responsible for providing on call support for all Life CAD applications
Primary point of contact to client for all WID/release activities
Coordinating with the client and other lineups to gather requirement and follow-up on the dependent task
Responsible for managing deliverables provided by the offshore team
Taken care of all Release management activities
Tuned SQL queries using EXPLAIN PLAN, Hints for query optimization
Identifying bottlenecks in the existing modules and providing better ideas to overcome the issue to the client
Taken part in the trial migration of Oracle database from 11g to 12c and made required changes to the DB objects wherever necessary
Support all production support tickets and took needful action during US business hours
Primary SME/point of contact for GAPS project
Perform RCAs and 5-why analysis for incidents
Providing QA support at the time of bug fixing
Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
Manipulation of Shell Scripts, Bash Scripts & Perl Scripts during migration.
Used Shell Scripting for automating process and collecting reports for daily tasks.
Creation of branches in CVS and Subversion for parallel development process.
Merging release branches back to trunk after the production release and resolving of conflicts during merging in both CVS and Subversion.
Project Name: Tulsa Production support
Client Name: Direct Energy Operations Inc, Chennai(Offshore), India
Role: Oracle PL/SQL Developer /Analyst
Duration: Apr ’10 – Dec’14
Description: This client is one of North America’s largest integrated providers of electricity and natural gas in competitive markets. With over five million customer relationships, they provide customers with choice and support in managing their energy costs through a portfolio of innovative products and services. They operate in 20 states in the United States and 10 provinces in Canada through four lines of business.
Responsibilities:
Responsible for providing on call support for all Texas applications
Primary point of contact to client for all on call interactions/activities
Improved the modularity of each applications and maintained proper KEDB for future reference
Followed ITIL process in the support activities
Excellent Understanding of Software Development Life Cycle and involved in all phases of development projects.
Performed Script optimizations in PL/SQL
Performing simulation testing on the applications to predict application behavior under various loads
Understood Client Processes and met targets & deliver solutions in accordance with quality control standards and business practices/procedures
Developed a level of competency which helps to anticipate issues and solve them in advance
Imparted domain, Business and technical knowledge to the new entrants and lead 5 fellow team members at offshore
Predict impacts that could potentially affect the existing system due to proposed change(s), coding, and testing and implementation activities
Performed SCM role in the team and made sure all the software in compliance.
Responsible for Process & service audit of the team and ensured all the processes were in Cognizant compliance.
Wrote Shell Scripts for Data loading and DDL Scripts.
Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.
Performance tuning of Oracle Databases and User applications.
Improved the performance of the application by rewriting the SQL queries.
Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
Upgraded Oracle 9i to 10g software in different environments for latest features and tested databases.
Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
Worked on XML along with PL/SQL to develop and modify web forms.
Designed Data Modeling, Design Specifications and to analyze Dependencies.
Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
References
Selvakumar Kandasamy,
Manager – Projects,
Cognizant Technology solutions,
Phone: +1-812-***-****
Chandrakaanth Ramamurthy,
Customs Application Architect,
JP Morgan Chase Bank,
Phone: +1-520-***-****
Mail: **************@*****.***
Contact this candidate