Sql Data

SUHASHINI KARIMILA VENKATASWAMY Email: ***********@*****.***

Ph: 201-***-****

SUMMARY:

• Software Professional around 3 years of extensive experience in Oracle PL/SQL, SQL*Plus, SQL*Loader, JAVA/J2EE, JSPs, import/export functionalities under UNIX, Shell Scripting, PERL, and Oracle Web Forms 6i.

• Experience with the Software Development Life Cycle (SDLC) Process - performing detailed analysis, collecting requirements, documenting requirements, coding and unit testing, integration and system testing.

• Experience in Maintenance and Production Support like Incident management and Ticket resolution within the SLAs using Open Pursuit.

• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures, functions, and triggers.

• Extensive experience in Performance Tuning using various techniques like Indexes, Hints, Partitioning, Data Analysis, Optimization, Tuning queries and Normalization techniques.

• Has knowledge and understanding of underlying database architecture and concepts.

• Experienced in interacting with system users in understanding business requirements and project use cases for development of project.

• Proficient in setting up Materialized Views/Snapshots for data replication across databases.

• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.

• Experience in writing Shell Scripts to load the data in to the backend tables.

• Proficient working experience in SQL, PL/SQL (Procedures, Functions, Packages, Objects, Triggers), Views, Relational Databases and MS Access.

• Have programming skills and development experience in Java 1.4/1.5, J2EE, Servlets, and JSPs.

• Writing PL/SQL procedures functions and interacts with database using JDBC.

• Involved in developing Java wrapper classes to execute PL/SQL functions and Procedures.

• Involved in Migrating Database from text files to Oracle databases Using SQL * Loaders.

• Excellent analytical and problem solving skills and can work independently.

• Strong communication and interpersonal skills, with demonstrated team dynamics.

TECHNICAL SKILL:

Operating

Systems M MS Windows 2000/NT/XP/NT & VISTA and UNIX.

Languages S SQL, PL/SQL, C, HTML, JAVA and Java Script

Databases O Oracle 9i/10g/11g and MS-Access.

Reporting Tools Oracle Forms (6i/9i/10g), Reports 6i.

Tools S SQL *PLUS, SQL developer, MS Visio, TOAD 9.0/9.6, Clear case,VSS and Open Pursuit.

ETL Tool S SQL*LOADER and IMPORT/EXPORT

EDUCATION:

Completed Bachelor of Information Technology from St. Joseph’s College of Engineering and Technology, Chennai.

PROFESSIONAL EXPERIENCE:

Company –Sapient Technologies

Client :Automotive Fleet Management. Sep 2011-Till Date

Java/Oracle PL/SQL Developer and Data Analyst

ARI fleet management is a web based system designed for managing the Client vehicles. ARI uses this application to serve their Customers and to manage the Customer’s Vehicle. The system allows to add vehicles and their information like VIN #, odometer, brand, year of make etc. Based on the vehicle information collected, ARI offers repairs and periodical maintenance for the vehicles at best offer rates. The system also stores best vendors and their details to generate purchase order invoice for the repairs offered by vendors.

Responsibilities:

.

• Involved in every phase of Software Development Life Cycle.

• Working extensively on writing SQL Queries using JOINS, Analytical Functions, and Sub Queries and also on DML, DDL statements.

• Created PL/SQL Packages, Stored procedures, Functions and Triggers for Backend modules.

• Used standard packages Utilities like UTL_FILE, DBMS_JOBS, PL/SQL Collections, also used BULK COLLECT to load the bulk data.

• Also worked extensively on Implicit, Explicit Cursors.

• Created Tables, Indexes and tuned queries for better optimization.

• Created materialized views which are used to refresh the data frequently when more data is being loaded into the data base and hitting the data base frequently.

• Performed Unit testing for various PL/SQL objects..

• Build Data validation and Data quality scripts using PL/SQL.

• Involved in the Data mapping, Data conversion and Data loading from the external system.

• Involved in profiling the data from various Line of Business to understand the source data better.

• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.

• Has experience with Explain plan and Used various optimizer hints like FIRST ROWS, ALL ROWS etc.

• Worked on Data cleanup activities, using PL/SQL.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, TOAD, SQL*Loader, Windows NT/2000/XP,.Net 4.0

Company: Infosys Technologies Limited

Client : Elsevier Publications Ltd, Reed Elsevier group, UK Jun 2009 –May 2011

System Engineer

SIS (Sales Information System) helps to maintain all the details of Customers, Journals, authors, prices and sales information. Based on these information, system allows customer to purchase or subscribe journals also allows authors to post their Journals. The system involves in generating reports monthly and annually for Business Analysis

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements.

• Involved in Developing Design Documents and User Manual documents.

• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.

• Created PL/SQL packages, procedures, cursors and exception handling.

• Encapsulated PL/SQL procedures and functions in packages to organize application.

• Handled large databases and created Ad-Hoc SQL queries for data manipulation and data fixes.

• Loading data from flat files into to database tables using SQL*Loader.

• Extensively worked on Explain plans and various hints for Performance tuning.

• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and maintained logs for the results.

• Involved in the Data mapping, Data conversion and Data loading from the external system.

• For Optimization Process actively involved in creating views, materialized views and creating indexes etc.

• Personalized standard reports and forms according to business requirements, using Oracle Forms and Reports 6i.

• Attended Design meetings, code review and test review meeting before checking code into CVS.

• Attended status meetings and technical meeting with Developers from various other application and DBA to discuss bottlenecks in the systems and potential.

• Involved in different phase of testing like User Acceptance Testing, Unit testing.

• Interacted with Business users and developed reports in excel using TOAD.

• Used standard packages DBMS_JOBS to schedule jobs which are processed as batch.

• Procedures are triggered by UNIX shell script to process the staging data and do the required process.

• Incorporated the Sql*Loader scripts into the UNIX shell script to read the data from the decrypted file and load the data into staging tables.

• Maintaining a Java webservice component which interacts with PL/SQL procedures.

• Coding for client side interactions of web pages developed in JSP and HTML.

• Created server side code to implement JDBC connectivity to Oracle

• Has involved in creating data element mappings between two distinct models.

• Experience in Production support to solve real time data issues.

• Involved in writing Test cases and performing data validation and process testing for application moving into production.

Environment: Oracle 11g, Oracle Forms 6i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX and MS Windows NT/2000/XP.

Certifications:

Sun Certified JAVA Programmer 5.0. (SCJP)

Contact this candidate