SUMMARY:

• Detail oriented highly motivated Sql server database developer with around 8 years of experience in database design, application development, data analysis using SQL and PL/SQL programming. An effective communicator who can easily interface with end - users, technical teams, and professionals at all levels with hands-on experience.
• Strong diversified experience in analysis, design, development, testing and implementation as PL/SQL Developer.
• Extensive experience in utilizing PL/SQL procedures, functions, packages, triggers, and cursors alongside being involved in data extraction, transformation and loading operations on SQL using SQL Loader
• Strong working knowledge in database objects like creating tables, views, indexes, sequences, primary key, foreign key constraints.
• Experience in restructuring tables, denormalize tables and building Materialized views.
• Used SQL Loader and wrote control file scripts to load data from flat files to SQL tables.
• Good knowledge in other Relational and Normalized databases such as MS SQL Server, SQL.
• Adept Knowledge in writing UNIX shell scripts, scheduling cron jobs, DBMS JOB and good understanding of ANSI standard C.
• Good experience in Data Modeling, Relational Database concepts and Entity relation diagrams (ERD).
• Experience with software development life cycle (SDLC) process performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing.
• Practical understanding of the Data modeling(Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Proven previous experience providing 24/7 production support and involved in implementation of coding standards and database change requests.

TECHNICAL SKILLS:

Database: SQL Server 2012, MS Access (2000, XP)

Scripting: UNIX Shell Scripting

Languages: Java, Java Scripts, SQL * Plus, SQL Scripts, PL/SQL, HTML, JSP

Data migration: DTS, SSIS, BCP, SQL Loader, Import/Export Wizard

Operating Systems: Windows 7, Windows Vista, XP, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, The Woodlands, PA

PL/SQL Developer/Data Analyst

Responsibilities:

• Coordinated and presented deliverable to business teams and development teams where primary responsibilities included system analysis, coding, testing, debugging and deploying.
• Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day modified business rules into the current system.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business need.
• Handled Errors and Transaction Processing in the Procedures.
• Written Complex SQL statements using joins, sub queries, inline views.
• Supported the Sales Desktop team in helping them identify the front end related fields that will affect due to the change in backend.
• Helped the QA team with queries, data for their testing.
• Proactively involved in writing efficient queries for better performance.
• Tuning the existent queries for better performance.
• Used a lot of ref cursors and created global temporary tables.
• Created tables, views, synonyms, indexes, sequences as well as custom packages tailored to business requirements.
• Created Indexes to improved performance.
• Co-ordinated with other teams with any production related issues.
• Depending on the need changed/modified/cancelled the Autosys jobs.

Environment: PL/SQL Developer, UNIX AIX 5.2, Windows 2000XP/NT

Confidential, Houston, TX

PL/SQL Developer/Data Analyst

Responsibilities:

• Primary responsibilities included system analysis, coding, testing, debugging, deploying and documentation.
• Ensure application design and code meets user interface standards (Forms and reports).
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Developed database objects including Tables, Clusters, Cursors, Indexes, Views, Sequences, Packages, Synonyms, Triggers and Procedures to troubleshoot any database problems.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed SQL scripts to extract data the various lookup and delta tables and Spool to a flat file.
• Instrumental in developing PL/SQL procedures and rolling-out new improvements required for data load.
• Wrote stored procedures, Functions, Packages etc. besides working on creation of Sequences for automatic generation of Billing Statements.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub Queries and inline views)
• Written many database triggers for automatic updating the tables.
• Created indexes on tables and Optimizing Stored procedure queries.
• Worked on SQL Tuning and Query Optimization Techniques for complex SQL Statements.
• Assisted DBA to implement backup and recovery techniques and Query level Optimization
• Development and Testing of advanced SQL and PL/SQL based code in support of Reports.
• Worked extensively on Shell scripting.
• Worked in the direct interaction with the end users and implemented reviews of the application.
• 24/7 production support, and reporting to manager on weekly basis.

Environment: Windows NT/2000/XP, PL/SQL, PL/SQL Developer 7.1.5, SQL*Loader, UNIX

Confidential, Houston, TX

PL/SQL Developer

Responsibilities:

• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views for remote instances.
• Produced SQL reports, data extraction and data loading scripts for various schemas.
• Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
• Developed a new package with tuned queries to improve the performance and reduce the time taken for the refresh.
• Modified UNIX Shell scripts to Import and Export data and user schema.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Used SQL Loader for migrating flat file data into target
• Written shell scripts and executed them as cron jobs on UNIX Involved in comprehensive testing of the system to check it satisfies the Functional Specifications.
• Wrote technical specification requirements and provided production Support.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.

Environment: WIN 2008 Server, UNIX, PL/SQL, SQL, MS VISIO Professional.

Confidential, Dallas, TX

PL/SQL Developer

Responsibilities:

• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Developed new hire report, Seasonal Hire Report, wages and tax info reports and modified the existing SQL reports.
• Extensively worked on Database objects (Tables, Views, and Indexes etc) and stored procedures (PLSQL).
• Created Stored Procedures for Batch Processing, and also involved in moving large data using Bulk Insert/for all Methods.
• Performed tuning of the system by eliminating redundant joins, creating indexes, removing redundant code.
• Data warehousing ETL (Extraction Transformation Loading) is done between two databases.
• Prepared test case for the GUI screens and tested the application.
• Involved in designing and development of several web pages using visual studio, HTML, CSS, XSLT / XML and JavaScript.

Environment: Windows NT, UNIX Shell scripts, SQL server 2012, HTML, CSS,XSLT/XML

Confidential, Houston, TX

Programmer Analyst

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created and Modified PL/SQL Triggers, Procedures, Functions and packages.
• Developed SQL scripts to create database objects like Tables, Views and Sequences.
• Used SQL*Loader to load bulk data from various flat files and legacy systems.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Used For all and Bulk collect to fetch large volumes of data from table.
• Developed Complex SQL Coding, Triggers for building Reports using Form, form letter and mailing label report styles.
• Developed Complex Triggers in reports before/after for validation of user input.
• Performed Unit Testing and supported Integration Testing and End User Testing.
• Extensively worked on production issues with effective defect management.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Implemented Application Infrastructure policies, Procedures and Standards, and ensured their continual compliance.

Environment: Visual Basic, SQL, PL/SQL, Windows NT, WIN 2003 and UNIX

Confidential, Sugar Land, TX

Programmer Analysts

Responsibilities:

• Design & Development.
• Creating and Modifying Decision handler for workflow process.
• Implementing Database logic using Helper classes.
• Design Documents Preparation.
• Involved in client meeting to gather the requirements.
• Involved in Unit integration, bug fixing, Code reviews.

Environment:: HTML, CSS, AJAX, JDK1.5, JSP, JQuery, Java,J2EE, Red Hat Linux