SUMMARY

• 7 years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments.
• Experience in financial, retail and telecom domain.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Enforced data integrity using integrity constraint and database triggers.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Extensively used Cubes & Rollups for making cross tabular reports.
• Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Expertise in handling errors using Exceptions.
• Making structural changes to the database objects.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP)
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Experience in working high - transacted OLTP systems.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS

Backend: Oracle 11g/10g/9i Database Enterprise Edition, Oracle 10g/9i Application Server

Frontend: Oracle Developer Suite 10g/9i/2000, SQL * Loader, SQL * Plus, FORMS Builder 6i, REPORTS Builder 6i, XML,Oracle XE 10g/11g

Programming: ORACLE PL/SQL 10g/9i/8.0, UNIX K-Shell Scripting, C,C++, JAVA, J2EE, Servlets, Java Script, Visual Basic, COBOL

RDBMS: Oracle 9i/10g/11g, MS Access 2000/2002, MS-SQL Server 2005/2000/7.0/6.5

Third Party Tools: PL/SQL Developer, TOAD 8.6/7.5/7.0, Putty, Workflows, ERWin

Operating System: Windows 98/2000/XP/NT, UNIX (SunOS 5.7, Solaris 8, HP-UX), Redhat Linux 3.0/4.0

Others: XML, HTML, SVN, Microsoft Visual Source Safe (VSS), IBM Rational Clear Case and Clear Quest, Caliber, CVS, Eclipse, Quality Center, Dimensions

Backend: Oracle 11g/10g/9i Database Enterprise Edition, Oracle 10g/9i Application Server

PROFESSIONAL EXPERIENCE

Oracle pl/sql developer

Confidential, AL

Responsibilities:

• Complex analysis, design, and programming experience with the development of Client Server and/or web-enabled applications.
• Responsibilities include: requirement and data structure analysis, system design, development, testing, modification, impact analysis, and documentation.
• Development of Client Server and/or web-enabled applications that utilize Oracle database technologies, Visual Studio 2003/2005 and the design of relational databases.
• Merged data from one database to another database.
• Modified existing procedures according to new enhancements.
• Extensively used SQL to create Insert programs for loading data.
• Performed data partitioning.
• Used explain plan to increase performance of SQL statements.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Created indexes as a part of tuning.
• Desired Skills: Experience with Oracle, PL/SQL, Visual Studio, HTML, XML, Visual Basic

Tools: & Technologies: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, ERWIN, UNIX, BODI, Informatica Power Center 8.1.

Oracle pl/sql developer

Confidential, DE

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
• Testing, Quality assurance Documentation, Implementation and Project Planning.
• Wrote Package containing several Procedures and Functions in PL/SQL to validate before loading into Application database.
• Used ETL software to extract, transform and load needed data.
• Created ETL mechanism to transform the data from OLTP source to the newly created OLAP model.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges on OLTP server.
• Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views for the business application development.
• Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Wrote Materialized views and complicated queries using SQL.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Extensively used the advanced features of PL/SQL like collections, nested table, v-array& Dynamic SQL.
• Experience with merging data files coming from the customer into the existing data warehouse.
• Worked with Oracle Enterprise Manager, Net configuration assistant.
• Logical and Physical data modeling using ERWIN.
• Created the indexes and analyzed the table for better performance.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks
• Moved the tables to different table space and rebuild the indexes.
• Wrote both implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them.
• Developed Unix Shell Scripts and loading data into the Database using SQL* Loader.
• Copying of data from development to test and production by using utilities like Export/Import.
• Used Explain plan and TK PROF for Tuning the SQL statements by creating indexes. Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Experience with Pl/SQL Tuning using DBMS PROFILER.
• Extensive use of Optimizer Hints to tune the SQL Queries.
• Worked extensively on Exception handling to error handling and tracking.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Wrote the shell scripts and scheduled with using cronjob for the database backups and old archive log deletion.
• Also done the logical backup (database structure export only) of the development instances every day using shell script
• Extensive experience in working different FTP clients like Smart FTP, Cute FTP, SFTP using F-Secure
• Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Documented business rules, technical designs, test cases, and user guides.
• Involved in unit testing, integration testing, system testing.

Tools: & Technologies: Oracle 10g, 11g, Windows 2003, PL/SQL, SQL Navigator, SQL*Loader, Redhat 4.1, SQL*Loader, Ervin 4.14, Oracle Enterprise Manager.

Oracle pl/sql developer

Confidential, Chicago, IL

Responsibilities:

• Involved extensively in requirements gatheringand developing modules according to the customer’s specifications and drafting detailed documentation for the same.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc. in Staging and Destination schemas.
• Created ETL mechanism to transform the data from OLTP source to the newly created OLAP model.
• Developed a package with stored procedures, functions and database triggers for transferring the date from Source to warehouse.
• Created dynamic procedures to drop and create Index for the Staging environment to facilitate faster loading of data.
• Involved in Tuning SQL queries using Explain Plan and Tkprof utility to improve performance of the queries.
• Created the documentation for explaining all the process involved in the ETL mechanism.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL to test the model.
• Involved in the work of CCAR and Credit Risk.
• Involved in the database administration and creating objects such as database, users, and schema and table spaces.
• Involve in the work of FIX(financial information exchange), and handle business request in trade floor
• Involved in managing security, granting and revoking privileges on database objects.
• Performed regular backups on the database using RMAN utility.

Tools: & Technologies: Oracle 10g,11g, Oracle Data Modeler, Cognos, Oracle SQL Developer, Erwin, Sun Solaris, Windows 2000, MS Outlook 2007,MS Office 2007

Oracle developer

Confidential, SAN FRANCISCO, CA

Responsibilities:

• Wrote high-level specifications and detailed specifications.
• Wrote PL/SQL Database triggers to implement business rules.
• Used ETL software to extract, transform and load needed data.
• Gathered and analyzed business requirements from end users.
• Worked with applications specialists to understand the new data requirements.
• Collaborated with the DBA in creating tables required for the application.
• Used SQL*loader to load the data from the files provided by the interfacing applications.
• Performed staging, and cleansing on data per requirement.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
• Worked with DBA on logical and physical data models, and metadata repository.
• Trained analysts and developers in design tools and data modeling techniques.
• Extensively used SQL to create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Performed data partitioning.
• Used explain plan to increase performance of SQL statements.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Merged data from one database to another database.
• Created indexes as a part of tuning.
• Documented every phase like Technical specifications, source to target mappings, data models (using ERWIN), UAT (tests cases and results), and release notes.
• Used Informatica to extract data from different types of sources and load to oracle database.
• Knowledge of full life cycle implementation in building a Data Warehouse.
• DataExtraction Transformation and Loading (ETL) Using Informatica Power center
• Migrated enhancement from appropriate dev Area to Test Areas/prod Areas.
• Issued Grants to the business users for appropriate DM tables to design their Universes.
• Wrote UNIX shell scripts to load data.
• Interacted with production support team regarding production issues.
• Documented and transferred knowledge regarding the various projects.
• Attended meeting with business analyst to get new requirements for the application.

Tools: & Technologies: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, ERWIN, UNIX, BODI, Informatica Power Center 8.1.

DATA ANALYST/ETL/PL/SQL

Confidential, EVANSTON, IL

Responsibilities:

• Extract Data Requirements from process oriented Requirements Documents
• Created and thoroughly documented Logical and Physical Data Model in accord with Project Plan
• Conducted Data Model Presentations upon achieving project milestones
• Performed Business Analysis, Data Analysis and Dimensional Data Modeling
• Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
• Automated connection to and data retrieval from team site, exported risk report data in spreadsheet format, and automated data retrieval for continuing operations.
• Pulling out all the input fields and loading in to database.
• As per Business requirement pulling out input fields and exporting them to Excel and sending for business approval
• Experienced in data integration, metadata management, ETL, data modeling tool sets In addition to verifying that all Technical and Functional specifications were adhered to
• Also created scripts to automatically generate the SQL to authenticate the results of the
• ODS and Data Mart load processes.
• Developed Reports and Graphs to present the results to the management.
• Performed Data Driven Testing of the Application for different users/data sets
• Identified, tracked and resolved performance problems. Made recommendations on potential functional and technical improvements to planned or existing system components and applications.

Tools: & Technologies: Oracle 9i, SQL, PL/SQL, Business Objects XI R2, TOAD, ERwin, Windows XP, UNIX, PVCS.

Oracle pl/sql developer

Confidential, OH

Responsibilities:

• Gathering business requirements.
• 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.
• Gathered and analyzed requirements from business analyst.
• Created database objects like tables, synonyms, sequences, triggers, and views.
• Created, edited procedures and functions for improved business requirements.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
• Conducted impact analysis and designed structures to enhance performance.
• Involved in data cleaning, merging and conversion.
• Created Test Cases and Technical Design Documents.
• Used Jira and Tortoise SVN for defect creation/resolution and Code repository, respectively.
• Collaborated with Data Warehouse in impact analysis to crystal reports.
• Supported development and test databases.
• Used SQL Developer and TOAD to develop code.
• Scheduled and led progress meetings.

Tools: & Technologies: Oracle 9i, Toad 10.0, SQL Developer 2.1, PL/SQL, SQL, Windows XP.