Data Sql

Venkata Arjun Kumar Sigadam

*************@*****.*** +1-678-***-****

Summary:

• 8+ years of experience in various phases of Software Development life cycle, including Designing,

Development, Testing and Production Support using Oracle SQL, PL/SQL UNIX.

• Expertise Oracle, SQL, PL/SQL, Oracle Forms, Oracle Reports.

• Expertise MSSQL, SSIS, SSMA Migration of data from large databases and developed scripts like

packages, functions and DB design based on requirement for front end and back end.

• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load

large volume of data.

• Extensive experience in Application development using Oracle Forms and Reports.

• Experienced in performance tuning using SQL Trace TKPROF and Explain Plan.

• Developed various Unix Shell Scripts to manipulate data files, set up environment variables, custom FTP

utility, file archiving.

• Extensive work experience on Oracle 11g/10g/9i/8i, SQL server databases on UNIX, Linux and Windows

enterprise platforms.

• Extensive work experience on MSSQL 2008, 2012 and SSIS package along with SSMA for migration of

Data

• Proficient in translating business requirements into logical data models, creating modularized enterprise

applications.

• Experience in interacting with users, analyzing client business processes, documenting business

requirements, performing design analysis and developing technical design specifications.

• Strong experience with Unix Shell Scripting (KORN, Bash), Perl Scripting.

• Providing assistance in logical/physical data modeling using ERWIN.

• Performance tuning using Explain Plan, SQL Trace, TK Prof oracle utilities and creating relevant system

and users documentation.

• Worked on Production Support, receiving production calls, troubleshooting the application and resolving

bugs.

• Good knowledge in Core Java and Java Springs with JDBC.

• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with

individuals at all levels.

• Ability to work in teams and independently with minimal supervision to meet deadlines.

• Experience in Dataware housing Management.

• Strong understanding of object oriented JavaScript .

• Good knowledge in XML, HTML and CSS.

• Excellent communication and interpersonal skills with the ability to manage responsibilities individually or

as part of a team.

• Demonstrated high learning ability with regard to new skills such as programming languages and

application tools/software.

• Strong troubleshooting and Organizational skill, independent, self managing and teamwork.

• Excellent communication, inter personal and business analytical skills, and ability to learn new concepts in

a fast paced environment.

Education:

Bachelors in Electronics JNTU

Venkata Arjun Kumar Sigadam

Technical Skills:

Databases Oracle 8, 8i, 9i,10g,11g, 12c, DB2, MS ACCESS, MSSQL server 2008,

MSSQL server 2010

IDE SQL Developer, SQL Plus, SQL Navigator, TOAD, ERWIN, MSSQL, SSIS,

SSMA, Java Springs with JDBC template.

Operating Systems Win 7, XP/NT, Windows 2000, Red Hat Linux 7, Sun Solaris 7.

GUI Oracles forms and reports 6i, 9i, 10g, 4.0. form and reports,SSIS, SSMA.

Reporting Tools Oracle Reports 10g /9i/6i

Professional Experience:

Cisco Systems, Lawrenceville, GA Apr 2013 Till Date

Project Name: PIMS (Power Key Enablement Integration Management System)/APEG

Oracle Developer

Responsibilities:

• Created materialized views on remote source database and automated scheduler of refreshing of

materialized view on source side.

• Created Database Objects like Tables and Views as per Client Requirements in Oracle PL/SQL.

• Created Stored Procedures, Functions, and Triggers to maintain various business rules in Oracle PL/SQL.

• Worked with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of

data.

• Database Design in Oracle based on the customer Requirement.

• Developing Automated scripts for migration part both in Oracle and MSSQL

• Created the DB Links pointing to the remote database to access the source materialized views.

• Created or Modified the Sequel Script (.sql file) to point to the current source.

• Extracted data from the source views by writing the procedures to load the data into staging tables.

• Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.

• Created the tables and sequences for the experimental data load capture.

• Loaded the Contracts, Products, Customers & Sales data into the created tables using SQL Loader script.

• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.

• Created various Database triggers using PL/SQL.

• Involved in Performance Tuning.

• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from

staging tables to the target schema.

• Enhanced it with creating exceptions for error handling.

2

Venkata Arjun Kumar Sigadam

• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect &

Minus set operators.

• Database security by authenticating users, using logon triggers.

• Created indexes on tables and optimized procedure queries.

• Scheduling the Jobs using Quartz scheduler

• Responsible for Unit, System and UAT testing the data and provided the test evidence reports.

• Involved in UAT testing, Bugs fixing and the code was sent to Production.

• Have good knowledge in Java Springs with JDBC and developed Maven Projects.

• Large Data Migration (including Binary data) from Oracle to MSSQL using SSMA and Linked server.

• Large Data Migration (including Binary data) from MSSQL to MSSQL using SSIS and Linked server.

• Database Design in MSSQL based on the customer Requirement.

Environment: Oracle 11g/10g, SQL*Plus, TOAD, Quartz, UNIX, MS Office, MSSQL 2008, MSSQL 2010, SSIS,

Java Springs with JDBC.

Arrow Electronics Inc, CO Mar 2012 Apr 2013

Arrow Warehouse Management Project

Oracle Developer

Responsibilities:

• Created Database Objects like Tables and Views as per Client Requirements.

• Created Stored Procedures, Functions, and Triggers to maintain various business rules.

• Actively Participated in different phases of SDLC. Extensively worked towards optimizing the Queries to

enhance the performance. Analyzed Indexes on regular basis.

• Involved in the optimization of Oracle queries.

• Managing Tables, Indexes, Constraints, Views, Sequences, and stored program units.

• Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance.

Implemented Triggers based on the business rules.

• Created SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area

Tables. Analyzed the existing Stored Procedures, Functions, Triggers and Cursors on performance issues.

Used various forms of control structures including CASE, DECODE, IF THEN ELSE, FOR loops, WHILE

loops while developing procedures.

• Worked with Dynamic Queries (SQL). Served as a technical expert in developing database designs for Data

Warehouse. Created users privileges and managed user roles and grants. Worked on DBMS_SCHEDULER

to automate jobs. Made use of DB LINKS for accessing data across different databases. Stored data in the

audit log tables using the old and new column attributes. Loading data into Database using SQL*

LOADER. Used the Oracle Import/Export utilities for taking backup of a particular partition data.

• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.

Environment: Oracle 11g/10g, Oracle Forms and reports 10g, Sun Solaris 10, Erwin, SQL*Plus, TOAD, Quality

Center, Relational Clear Case.

Emerson Technologies, MO Sept 10 – Feb 12

Oracle PL/SQL Developer

Responsibilities:

Venkata Arjun Kumar Sigadam

• Worked with various functional experts to implement their functional knowledge into working procedures.

• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle10g as

back end.

• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader,

SQL* Plus and PL/SQL.

• Created various SQL and PL/SQL scripts for verification of the required functionalities.

• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error

Handling.

• Worked on optimizing existing procedures and functions using PL/SQL.

• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.

• Created various Database triggers using PL/SQL.

• Involved in Performance Tuning.

• Have converted old data from Flat files to Oracle database Using SQL * Loader

• Developed screens and reports using Oracle Forms 10g/Reports 10g.

• Designed and developed user interfaces for customers using Oracle 9i/10g Forms Builder.

• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins

• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.

Environment: SQL, PL/SQL, Unix Shell Scripting, Perl, Oracle 10g, Toad, SQL*Plus, SQL*Loader, MS Office,

Windows XP, Oracle Reports 10g, Oracle Forms 10g.

Infosys, India Jan 2008 Jul 2010

Oracle PL/SQL Developer

Responsibilities:

• Creating database objects like tables, synonyms, sequences and views.

• Created, edited procedures and functions to suite the improved business requirements.

• Created records and nested tables in the procedures for handling of data.

• Used SQL Loader to load data into the database coming from Knipper and FICO.

• Used export/ import and expdp/impdp database utilities for data transfer.

• Coded complex SQL queries to retrieve data from the database depending on the need.

• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.

• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors.

• Creating and working with GTT (Global Temporary Table).

• Made use of Sub query Factoring (WITH clause) to make complex SQL statements simple and make them

more efficient.

• Using set operators in PL/SQL like Union, Union all, Intersect and minus.

• Worked DBMS_UTILITY.FORMAT_CALL_STACKandDBMS_UTILITY.FORMAT_ERROR_STACK

• Performed exception handling for the procedures created.

• Written and edited shell scripts to automate the execution of the procedures and report the results through

e mail.

• Experience in resolving anomalies in the production database.

• Created indexes for faster retrieval and improved query performance.

• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database

performance.

4

Venkata Arjun Kumar Sigadam

• Wrote Perl scripts for generating ad hoc reports.

• Support for the development, test and the production databases.

• Used SQL plus and TOAD to develop database applications.

• Documentation of the technical work done.

Environment: Oracle 9i, 11g (SQL, PL/SQL), Oracle Developer Suite 10g, oracle forms 9i/11g, oracle reports

9i/11g, TOAD 9.0, Erwin 4.0, UNIX.

MEDWIN Group Hospitals, India (Health Care) Apr 2006 – Dec 2007

Database Developer

Description:

MEDWIN Group is a healthcare system group maintaining and providing hospital services. Project primarily

involved maintaining server databases and testing of various procedures employed during daily jobs and procedural

runs. Also patient record collection by both importing and exporting data from the databases was handled. Creating

new and efficient methods for reporting using front end forms. Pharmacy inventory and transactional details were

recorded in the databases and maintained.

Responsibilities:

• Generated Patient reports and their medical history.

• Involved in writing Database PL/SQL Procedures, Functions, Packages and Database

Triggers using Oracle for TOAD.

• Involved in creation of Tables using storage parameters and clusters.

• Worked with SQL*Loader to extract and loading the data from flat files, oracle.

• Created PL/SQL VIEWS to provide specific access to different roles.

• Coded many generic routines (as functions), which could be called from other procedures.

• Developed Used Interfaces using Oracle Forms 6i and Master Detail forms.

• Extensive use of SQL Server queries to perform transaction testing.

• Worked with the developers using Test Director to fix the defects.

• Worked on Oracle triggers and Event Handling.

Environment: Oracle 10g, TOAD, SQL*Loader, Oracle Developer (Forms & Reports 10g), SQL, PL/SQL, C, Java,

SQL*loader and Windows XP.

Contact this candidate