Resume

Sign in

Sql Data

Location:
United States
Posted:
October 04, 2016

Contact this candidate

Lakshmi Kanthan Natesan

408-***-****

acwwl3@r.postjobfree.com

SUMMARY:

Over 7+ years of experience in Development of Client/Server applications using Oracle 11g/10g/9i/8i/7.x databases/Oracle application tools, OracleDeveloper 2000/6.0/6iand RDBMS concepts.

Expertise in design, development and deployment of end user screens and reports using Oracle tools, Oracle Forms 11g/10g/9i/6i/4.5, Reports 11g/10g/9i/6i/2.5.

Strong experience in SQL, SQL*PLUS, PL/SQL, back end programming using Packages, Functions, StoredProcedures, Exception handlers, Views, RefCursors, Record Types, UTL_FILE and other built in packages for Oracle 10g/9i/8i and also SQL queries/reports and scripts.

Strong experience in using CASE tools like TOAD, SQL Navigator.

Expertisein developing complex code units, Database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).

Good experience in working with Autonomous Transactions in PL/SQL.

Experience in working with SQL *Loader, external tables, import and export utilities, extracting and loading large volumes of data.

Experience in using SQL TRACE tools for Explain Plan, collection of statistics and creation of indexes for database access and indexing the required columns.

Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Analysis, System Analysis & Design, Coding, Unit Testing, Quality Assurance, Project Planning and Documentation.

Involved in the issue resolution and Root Cause Analysis.

Strong programming, debugging and problem solving skills and ability to translate user requirements into specific technical solutions by utilizing business insights.

Experience in database design, data analysis, data modeling, development, Query Optimization, SQL Tuning, and Trouble Shooting.

UNIX shell scripts for automating batch programs, DBMS_SCHEDULER and DBMS_JOB.

Experience in using Oracle supplied packages like DBMS_JOB to schedule PL/SQL procedures that needs to be performed at periodic intervals; DBMS_TRACE to stop and start the PL/SQL tracing, DBMS_SQL is dynamic SQL to access the database.

Experience in customizing standard reports as well as developing custom reports in Oracle Applications using Oracle Reports Builder.

Extensively worked on report attributes like Report Triggers, Program Units, Attached Libraries and Built-in Packages that involve complex PL/SQL codes.

Extensively worked on Format Triggers, Formula Columns, Summary Columns, Placeholder Columns and Ref Cursor Query for developing the reports and prepared complex Data Model and Data Layout in Oracle Reports 6i.

Broad experience working with Eclipse.

Designed UML Diagrams, E-R Diagrams using ERWIN and Designer 2000.

Extensive experience in DDL scripting and WinCVS client.

Good knowledge on PL/SQL Web Toolkit to generate web pages directly from an Oracle8i or Oracle9i database.

Experience in E-R modeling, understanding in developing Database Schemas.

Extensively involved in release of the complete integrated product in to production and in post-production support which is still on.

Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.

Strong skills in writing technical and functional documents defined by the business requirements

Education:

Bachelor of Engineering - Anna University, India

Technical Skills:

Languages

PL/SQL, SQL, Shell Programming, C, C++, Java

Databases

Oracle 11g, 10g, 9i. SQL Server Management Studio 2008-2014.

GUI/ Tools/Utilities

SQL*Loader, TOAD 11.0/8.0/7.5, PL/SQL Developer, DataPump (Import/Export), SQL* PLUS, ERWIN 3.5/4.0, SQL Navigator, MS VISIO,VI Editor, Oracle Wrap, FTP, SFTP, Explain Plan, TKPROF, Microsoft Excel, Microsoft PowerPoint

Operating Systems

Unix, Sun Solaris 2.x/7/8, HP-UX 10/11i, Windows 7/XP/ NT 4.0/ 2000

Technologies

HTML,XML and Informatica

Scripting

Unix Shell Scripting

Reporting Tool

Crystal Reports 9.0, Cognos Reports, Report 6i and 9i, Oracle Reports, Oracle Forms

Professional Experience:

Xerox, State Healthcare LLC, West Sacramento,CA Dec 2015- Till date

Oracle SQL Developer

Description: Xerox, State healthcare llc is the Fiscal intermediaries for CA-MMIS (California- Medicaid Management Information System). My role required both developing and admin knowledge for various application owned by CAMMIS. Its roles are to perform health program claims processing and management reporting functions for DHCS (California Department of Healthcare Services).

Responsibilities:

Completed Training certificate on “Safeguarding and Identifying PII(Personally Identifiable Information)”.

Identified duplicate data entries in database using Oracle PL/SQL queries which involved figuring out alphanumeric ranges.

Developed Oracle SQL queries to update procedure code as per various requirements requested by the Senior Analyst.

Setup Cron job- shell scripts to trigger mails to team lead and application analyst in developer environment of the server and provided procedure documents for deployment in SIT and PROD.

Working on Problem Statements which involves CAMMIS(California Medicaid Management Information System) TAR system server to fix the data integrity between Oracle database and data mart in order to retrieve the missing Business objects reports.

Created Database change tickets in UNIX server to update or completely delete TAR numbers as per request from client.

Created a report in reference with Treatment authorization request numbers for irregular pattern of processed and returned claims which involved life cycle data analysis on multiple reversals of claims.

Provided analysis on Table Sizes of various applications of Oracle databases for requesting DB refresh from PROD to SIT or DEV from.

Report OracleDatabase locks upon request by team lead.

Worked on AUDITSof Oracle Database which involved complex SQL joins queries to acquire data from various tables and schema.

Submitted report for Consults, to provide data from Oracle database to CA-MMIS(California Medicaid Management Information System).

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Involved in creation of Conceptual Modeling covering all the business requirements.

Worked with bulk collect to implement the performance of multi row queries.

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Developed data model, SQL Queries, SQL Query tuning process and Schemas Set up E-mail alert notification in SQL Server database using T-SQL script for manager and Mid-range analyst as per request from California DHCS(Department of Health Care and Services).

Setup Database Mail Profile in SQL Server Management Studio for operations team to get updates on specific tables once updated.

Turned logging for SSIS (SQL Server Integration Service) package OnError, OnPostExecution, OnTaskFailed using SQL Server Business Intelligence Development Studio.

Environment: Oracle 10g, SQL, PL/SQL, MS Access, UNIX Shell script, TOAD, UNIX, Windows XP/2000,SQL Server Management Studio ‘08,’14.

WellPoint/Anthem Inc, Chicago, IL June 2014- Nov 2015

Oracle PL/SQL Developer

Description: WellPoint, Inc. is the largest managed health care, for-profit company in the Blue Cross and Blue Shield Association. It was formed when WellPoint Health Networks, Inc. merged into Anthem, Inc., with the surviving Anthem adopting the name, WellPoint, Inc. and began trading its common stock under the WLP symbol on December 1, 2004.

Responsibilities:

Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination

Worked with Agile/Scrum team to deliver software projects and products.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Helped in maintaining the databases and also worked with production support team to solve tickets and debugging issues.Developed SQL scripts, packages and procedures for Business rules check to implement business rules.

Generated various analytical reports using MicrosoftAccess.

Migrated XML data to Targeted files using ETL tools in Data warehousing.

Developed Procedures for efficient error handling process by capturing errors into user managed tables.

Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.

Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Developed UNIX Shell scripts to automate table creation, execute procedures.

Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Used UTI_FILE PACKAGES for writing DBMS_OUTPUT messages to file.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, UNIX, Windows XP/2000

AT&T, Atlanta, GA Aug 2013 – June2014

Position: Oracle PL/SQL Developer

Description: AT&T Inc. is an American multinational telecommunications corporation. As an oracle developer I designed the database tables and modified old packages for future change in codes. Verified data retrieval from different applications in to database, If the data flow is not correct through the system used to debug the issues concerned. Performed escalations to other teams to which the error is related. Used Shell to find in which system the error is in and created fixes for them.

Responsibilities:

Involved in the continuous enhancements and fixing of production problems.

Resolved different kinds of tickets issued to us which involved in UNIX shell scripting, modifying database tables, hands on UI changes using HTML5.

Designed webpage for the team to access all the links from one place. Used HTML and CSS for design.

Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Developed PL/SQL triggers on master tables for automatic creation of primary key values.

Created scripts for new tables, views, queries for new enhancements in the application using TOAD/SQL developer.

Created indexes on the tables for faster retrieval of the data to enhanced at a base performance.

Upgraded Oracle 10g to 11g software in different environments for latest features and also 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.

Performance tuned the interfaces, queries through use of indexes, ranks, Oracle hints, exchange partitions etc.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

Provide technical support for database maintenance and disaster recovery.

Created tickets to other development teams for supporting applications.

Involved with users to understand the problem they have and train them with work around for similar issues.

Environment:Oracle 10g/11g, K-Shell, PL/SQL, SQL, SQL developer, SQL*Loader, TOAD, SoapUI, BMS Remedy

Aetna, Connecticut Jan 2011 – July2013

Sr. Oracle PL/SQL Developer

Description: Aetna offers a broad range of traditional and consumer-directed health insurance products and related services, including medical, pharmacy, dental, behavioral health, group life and disability plans, and medical management capabilities and health care management services for Medicaid plans

Responsibilities:

Involved in Developing and handling the PL/SQL Packages, Procedures, Functions and Database Triggers.

Developed stored procedures to extract the data from different sources and load it into data warehouse.

Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.

Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Maintaining daily batch cycle and providing 24-hour production support.

Supporting legacy systems with backups of all cases to/from parallel systems.

Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.

Utilized SQL*Loader to load flat files into database tables.

Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.

Worked with a team which Upgraded Oracle DB 8i to Oracle 10g.

Used Various Database administrative tools such as Oracle Enterprise Manager, Erwin, Toad DBA Tools, and Data Migration Tools.

Created Shell scripts to generate oracle reports and send to e-mail.

ER diagrams are developed using TOAD Data Modeler.

Used iExpense EBS to enhance standard Oracle flows for order to cash, procure to pay, inventory, credit card transactions and GL accounting processes for this rapidly growing specialty retailer that handles over 1,000 transactions per day. Implemented automatic bank reconciliation functionality in CM and auto lock box functionality in AR.

Which in turn helped in improved inflows and outflows, facilitating discounts from vendors for bulk purchases and early payment without tapping a short-term line of credit.

Involved in creating Cron jobs and Korn Shell scripts for running the daily loads.

Involved in creating and maintaining Partitioned Tables and Indexes for better performance of application

Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.

Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.

Involved in handling the changes in compiling scripts according to the database changes.

Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: Oracle 10g, Toad, SQL * Loader, Toad, PL/SQL Developer, SQL*PLUS, UNIX Shell Scripting, Oracle Reports, HTML, and XML, Informatica.

IMS Health, Chennai, India Sep 2009 – Dec 2010

Jr. Oracle Developer

Responsibilities:

Involved in Database Design and Analysis.

Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.

Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 10g.

Created Control Files and used SQL* Loader to upload bulk data into database from external files.

Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.

Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages

Involved in Code Standardization and Documentation.

Involved in Logical and Physical Database design. Identified the tables and relationship between tables.

Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.

Involved in database Performance Tuning and monitoring.

Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.

Developed complex triggers in reports before/after for validation of user input.

Coordinated between management, users and technical teams for Requirement Gathering

Environment: ORACLE 11g/10g, Reports 9i, PL/SQL, SQL Loader, SQL*plus.



Contact this candidate