We provide IT Staff Augmentation Services!

Sql Developer Resume

Hartford, CT

EXPERIENCE SUMMARY:

  • Around 7+ Years of Experience in teh field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g,11gR1 and 11gR2, SQL, PL/SQL dat includes Complete System Development Life Cycle from Analysis and Design to Implementation.
  • Experience in Finance, Retail, Telecom and Healthcare domains.
  • Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL and Oracle tools like Toad, SQL*Plus, SQL Developer.
  • Good noledge of Teradata RDBMS Architecture, Tools & Utilities, Strong SQL coding skills.
  • Proficient noledge in HTML and JavaScript.
  • Exposure to various concepts of Data warehouse like Design, Data Modeling, OLTP, ETL and Reporting.
  • Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
  • Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
  • Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
  • Around 4 Years of Experience in Perl Scripting & UNIX Shell scripting Perl/sh/awk.
  • Worked with Autosys for job scheduling and job automation.
  • Experience in using OLAP analytical power of Teradata by using OLAP functions such as Rank, Quantile, CSum, MSum, group by, grouping set etc. to generate detail reports for marketing purposes.
  • Designed and developed teh Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.
  • Strong Background in implementation of RDBMS and OOPS concepts.
  • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Excellent analytical and interpersonal skills, oral and written communication skills.
  • Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
  • Strong personal drive and ability to work individually and in team environments. Ability to learn new tools, concepts and environments. Ability to explain technical concepts and communicate with users and system administrators at all levels.

TECHNICAL SKILLS:

Operating Systems: Windows 98 / NT / 2000 / XP/7, UNIX.

Languages: SQL, PL/SQL, Java Script, UNIX Scripting, JAVA, CSS, C++, VB6.0.

Development Tools: PL/SQL Developer, SQL*Plus, TOAD, iSQL*Plus, SQL*Loader, SQL Developer 11g/10g/9i/6i/2000 Release 1 & 2, Reports 10g/9i/6i, Forms 6i/9i/10g, MS - Access 2000, SQL SERVER 2005/2008.

Reporting Tools: Crystal Reports, Oracle Reports.

ETL: Informatica, Teradata and Data Stage.

Others: XML, HTML, SVN, IBM Rational Clear case and Clear quest, Eclipse, Quality Center, Microsoft Visual Source Safe (VSS).

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

SQL Developer

Responsibilities:

  • Involved in understanding teh functional requirements, translation of technical documents, data dictionary mapping and data mapping.
  • Interacted with End Users and other project members to collect, analyze and document user requirements.
  • Wrote SQL queries using analytic functions.
  • Experience in preparing and deploying complex schema updates, data migration and scripts.
  • Comprehensive noledge of waterfall, agile and scrum methodologies. Worked in Scrum Environment.
  • Brief noledge of cleansing and loading of data to different databases. Related Experience in developing/managing large-scale databases.
  • Worked on creating Extracts (.csv files) based on end user requirements. Loaded new data into different databases.
  • Designed large number of reports using table filters, single value and multi value parameters and halped in troubleshooting teh reports.
  • Transfer of large volumes of data using Teradata Fast Load, MultiLoad and T-Pump.
  • Writing Teradata BTEQ scripts to implement teh business logic.
  • Helped Business Users by writing Complex efficient Teradata SQLs to get a detailed for Data Mining.
  • Improved performance of long running views and stored procedures.
  • Developed user defined functions, stored procedures and indexes.

Environment: Oracle 11g, TOAD 11.6, SQL Developer, TERADATA, MS EXCEL, SharePoint, UNIX Sun Solaris,WINDOWS NT Workstation.

Confidential, Charlotte, NC

Oracle PL/SQL Developer

Responsibilities:

  • Interacted with Business Analysts and Users in requirement gathering.
  • CreatedTechnical Designfor teh Back End PL/SQL based on Business Requirement Documents and teh Functional System Design.
  • Built complex queries using SQL and wrote stored procedures using PL/SQL.
  • Creation of database objects liketables, views, synonyms, materialized views,Stored procedures, packagesusing oracle tools likePL/SQL Developer & SQL* plus.
  • Coordinated with teh front end design team to provide them with teh necessary stored procedures and packages and teh necessary insight into teh data
  • Involved into updatingprocedures, functions, triggers,andpackagesbased on teh change request.
  • UsedRef cursorsandCollectionsfor accessing complex data resulted from joining of large number of tables.
  • Work with Java Developers in writing XML mappings, understand teh logic for XHTML script.
  • Involved in moving teh data from flat files to staging area tables usingSQL *Loader.
  • Extensively usedfor allandbulk collectto fetch large volumes of data from table.
  • Get all Design and CodingReviewed and Approvedby teh concerned authorities.
  • Provide support to Front End andfix defectsin various stages of Testing me.e.System Integration Testing, IST,ETandUAT.
  • PerformTechnical Validationon production Release day and send a Success/ failure report accordingly.
  • Worked closely with Production Support team to Troubleshoot and fix any production issues.
  • Coordinated with theWhole Development teamwith strength more than75members.
  • Multi Task4, 5 TARS (Projects) at a time in a release.
  • Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL) program asynchronously.
  • WroteSQL Loadercontrol file for flat file data load and scheduled them in UNIX to load every night in Production Environment.

Environment: Oracle 11g,PL/SQL, PL/SQL Developer, UNIX Sun Solaris 2.6,WINDOWS NT Workstation.

Confidential, New York, NY

Oracle PL/SQL Developer

Responsibilities

  • Analyze and Create teh functional & technical requirements and of teh project. Discuss with business users, BA's and UI Architects to finalize requirements and scope of teh project.
  • Design teh Database and ETL framework for teh new enhanced UI for SCT tool
  • Design and provide Database service call contracts to Java/UI team. Provide development, CUT, and SIT estimates to project services team.
  • Create new tables, views, materialized views, Packages, Stored Procedures and functions per teh requirements.
  • Create new Informatica Mappings as required.
  • Perform code review and make changes/improvements as required.
  • Optimize teh code to meet SLAs with UI. Used Hints like materialize, parallel, no parallel, etc., to improve teh performance.
  • Maintain SVN repository, deploy code base to SIT, QA, UAT, dry-run environments as requested.
  • Plan production deployment activities, ITSM processes, raise RFCs and coordinate with various teams like DBAs, Unix Admins, and Informatica Admins etc.
  • Ability to develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables.
  • Developed UNIX shell scripts with embedded SQL Loader and PLSQL statements to extract data from teh legacy application in teh form of flat files.
  • Ability to trouble shoot technical issues and problems, monitor progress against plan, and communicate status to Leads
  • Created tables, Correlated sub queries, Nested Queries, Views, Dynamic SQL for Business Application Development.
  • Developed back end interfaces using PL/SQL Packages, Stored Procedures, Collections.
  • Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc. Designed Database Triggers for audit and validation purpose.
  • Knowledge in Shell scripting to automate system administration jobs as per Business requirement and applying teh changes after creating a change control.

Confidential, Charlotte, NC

Oracle PL/SQL Developer

Responsibilities

  • Involved in teh CDW implementation of countries under Malaysia and India Markets.
  • Perform Unit test on teh developed code to ensure dat its bug free.
  • Handled Production issues and manage teh same in issue log.
  • Interacted with Business Analysts and Users in requirement gathering, built complex queriesUsing SQL and wrote stored procedures using PL/SQL.
  • Involved in teh database design for better understanding teh relations, associations and dependencies within teh database.
  • Designed Technical design document based on teh business requirements.
  • Worked on SQL*Loader to perform bulk data loads into database tables from external data files.
  • Designed and developed Oracle PL/SQL Procedures, Functions, and Database Triggers and involved in creating and updating Packages to meet business requirements.
  • Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with teh incoming data from other sources.
  • Created Materialized Views for extracting teh data from remote database.
  • Preparation of SQL wrapper scripts for all teh database processes and data quality checks using Unix Shell scripting.
  • Wrote complex SQL queries to extract data from various source tables of data warehouse.
  • Created various Function Based Indexes to significantly improve performance.
  • Created tables, Correlated sub queries, Nested Queries, Views for Business Application Development. Extensively involved in using HINTS to direct teh optimizer to choose an optimum query execution plan.
  • Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve teh performance and UTL FILE to read and write operating system text files.
  • Extensively used Bulk Collections to insert and update huge amount of data into target databases.
  • Worked on Exception handling, to trouble-shoot PL/SQL code and to display teh error messages in teh application.
  • Extensive usage of Oracle External Table Concept to extract Data from feed File sent to FTP feed file location.
  • Monitoring teh schedules and timely escalations to teh project management and client in case of any slippages.

Environment: TOAD 10.5, VI editor, MKS, FileZilla FTP tool, SQL loader, PL/SQL, Informatica.

Confidential, FL

Oracle PL/SQL Developer

Responsibilities

  • Used teh merge statements to select rows from one or more sources for update and insertion into one or more tables. Used PL/SQL Developer tool to do teh backend development.
  • Used PL/SQL collections (Nested Tables and Varray) in complex backend packages.
  • Coded UNIX shell scripts to call SQL scripts and to manipulate teh returned data.
  • Developed test plan documents for all back end database modules.
  • Extensively worked on Explain Plans and various hints for Performance tuning.
  • Wrote Database triggers for audit and to implement complex business logic.
  • Discussed and analyzed business functionality with teh client and teh developers.
  • Involved in teh database design for better understanding teh relations, associations and dependencies within teh data base.
  • Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
  • Involved in writing functional and technical documents.
  • Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms.
  • Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.
  • Wrote complex SQL queries to retrieve information from teh database depending on user requirement.
  • Created PL/SQL program units to implement DML, DDL statements using dynamic SQL.
  • Wrote control files and loaded teh data into oracle database with SQL*Loader.
  • Wrote complex oracle SQL using joins, sub queries and correlated sub queries.
  • Implemented Materialized View for extracting teh data from remote database.
  • Handled various Exceptions to trouble-shoot PL/SQL code.

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2, Toad 7.5.2.0, UNIX, Perl

Confidential, Phoenix, AZ

Oracle PL/SQL Developer

Responsibilities

  • Wrote stored PL/SQL Procedures for reports.
  • Developed PL/SQL scripts for data processing.
  • Optimized teh existing UNIX scripts to achieve better performance.
  • Created Indexes, Views, Tables and triggers and procedures to handle teh data processing.
  • Created scripts to trigger Nightly batch processes (NOPS).
  • Involved in Developing and Generating Reports.
  • Experience with Enterprise Guide in generating analytical reports.
  • Preparing Unit test scripts, setting up a test environment and unit testing teh code.
  • Tuning of teh SQL statements for application developers.
  • Writing validation packages using PL/SQL package.
  • Used PL/SQL to validate data and to populate billing tables.
  • Using UNIX Shell scripting .perl/.sh/awk.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2, Toad 7.5.2.0, UNIX.

Confidential, Stamford, CT

Oracle PL/SQL Developer

Responsibilities:

  • Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
  • Developing Stored Procedures, Functions and Triggers.
  • Development was done extensively on collections (Associative Arrays, Nested Tables)
  • Involved in uploading of teh data from flat files into Databases and validated teh data with PL/SQL procedures.
  • Maintaining daily batch cycle and providing 24 hour production support.
  • Preparation of teh Test Cases and involvement in Unit Testing and System Integration Testing.
  • Created SQL*Loader scripts to load data into temporary staging tables.
  • Developed automated scripts to schedule teh load of flat files on daily, weekly and monthly basis.
  • Interaction and coordination with various application teams for resolving issues, patch movements.
  • Performed SQL tuning using Explain Plan, Hints and indexes.
  • Partitioned tables and indexes for better performance of application.
  • Involved in importing teh production data to lower environments for testing purpose.
  • Involved in handling teh changes in compiling scripts according to teh database changes.

Environment: Oracle 10g, UNIX, MS visual studio 2005

Confidential

Oracle PL/SQL Developer

Responsibilities

  • Involved in SDLC gathering requirements from end users.
  • Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Involved in GUI designing using Oracle Developer 10g (Forms 10g and Report 10g).
  • Developed stored procedures and triggers to facilitate consistent data entry into teh database.
  • Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
  • Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
  • Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
  • Developed Database Triggers for audit and validation purpose.
  • Used pipelined functions for faster data accessibility.
  • Writing validation packages using PL/SQL package.
  • Used PL/SQL to validate data and to populate billing tables.
  • Using UNIX Shell scripting perl/sh/awk.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
  • Developed Installation scripts for all teh deliverables.
  • Performed functional testing for different Oracle Forms application functionalities.
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD.
  • Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Involved in developing screens and generating reports.

Environment: Oracle 9i, 10g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator.

Hire Now