PROFESSIONAL SUMMARY:

• Experience in Application Development using Oracle SQL, PL/SQL.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Excellent conceptual knowledge of Oracle11g, PL/SQL and SQL.
• Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, Packages, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
• Expertise in loading data from legacy systems using SQL*Loader.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
• Good in creating users and maintaining their roles and responsibilities.
• Experience in the full System Development Life Cycle (SDLC) with understanding of a variety of technologies and platforms such as web, client/server, entity - relationship diagrams (ERDs), relational database concepts and object-oriented programming.
• Strong interpersonal skills, ability to interact with people Confidential all levels. Good communication and presentation skills.

TECHNICAL SKILLS:

Databases and Tools: Oracle 11g, TOAD, SQL*PLUS, SQL*Loader

Application Tools: XML publisher, ALM, HPQC, Agile

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

Languages: SQL, PL/SQL, JAVA, C, C++

WORK EXPERIENCE:

Confidential

Oracle Developer

Responsibilities:

• Worked with the Business analysts and the Oracle Developer for requirements gathering, business analysis, testing metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE .

Environment: Oracle 10/11g,Oracle, PL/SQL, TOAD, SQL Developer, PUTTY, WINSCP,Shell scripting (Bourne and Korn), XML, SQL*loader, Stored Procedures/Triggers, Windows NT.

Confidential, Richmond, VA

Sr. Oracle PL/SQL Developer/DBA

Responsibilities:

• Worked on Data migration project where data from oracle legacy database is migrated to Salesforce.
• Creating PL/SQL Scripts to stage required data from several tables into a denormalized staging area.
• Responsible for creating adhoc PL/SQL Extract scripts that stage data from the source tables into staging tables to be exposed as views as required for Salesforce tables.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Involved in the continuous enhancements and fixing of production issues.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Handled errors using Exception Handling for the ease of debugging and displaying the error messages in the application.
• Performance tuning of complex queries and tuning procedures by analysing the run time statistics generated by using utilities like Explain Plan, SQL Trace, TKPROF and AWR reports.
• Worked on DBMS SCHEDULER to execute the stored procedures in repeat interval to calculate the business logic for the data.
• Working on the ETL side of the process to load data into database from different servers.
• Worked on SQL*Loader to load data from flat files created from extract sql that extracts data from SQL Server 2000 and creates flat files using shell scripts.
• Experienced and skilled Agile Developer with a strong record of excellent teamwork and successful coding project management. Specializes in problem identification and proposal of alternative solutions.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Responsible for creating views that act as source for Informatica Cloud Mappings which are mapped to Salesforce Cloud
• Responsible for scripts that reconcile data from source to target.
• Responsible for creating documentation for data migration

Environment: Oracle 10g/11g, Oracle Enterprise Manager, SQL*Loader, SQL*Plus, PL/SQL Developer, UNIX Shell Scripting, Toad for Oracle

Confidential, Washington, DC

Sr. Data Analyst/Oracle Database Developer

Responsibilities:

• Conducted requirement gathering as part of re-engineering project
• Created Dataflow, procedure/package analysis for detailed information of source to target balance flow.
• Responsible for reconciliation of balances on Operation Data Store (ODS) and matched the balances which has not been worked before.
• Created source to target reconciliation of Profit and loss statements for each line items
• Worked on detailed analysis of Data flow of various applications as part of business requirements for future Re-Engineering projects.
• Worked on Fees Reconciliation from source to ODS which reconciles trial balances to ODS ledger
• Worked on complex procedures/packages and views using metadata to load source data to ODS.
• Worked on Exchange rate procedure which loads daily into ODS.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Worked on analyzing current formulas which were responsible for incorrect balances on line items and created detailed analysis for reengineering project and worked closely with Business to fix the existing formulas.
• Worked closely with business in workshops to analyze the existing balance rules used via ODS and improvisation/setup of new Balance rule configuration in ODS.
• Worked closely with DBA’s to get the script migrations using Remedy Management System in timely manner and migrated code to different instances in specified SLA.
• Raised remedy tickets as required and worked with team to get the project deployed in production successfully

Environment: Oracle 11g, SQL*Loader, SQL*Plus, Toad for Oracle, Microsoft SharePoint.

Confidential, Dallas, TX

Sr. Oracle Developer

Responsibilities:

• Conducted customer interviews and other data gathering tasks.
• Documented current system operations, functions, and system flow.
• Worked on Data migration project called Project UNO, that integrated data from Washington Mutual and EMC ( Heloc Loans) to chase after Merger with Chase.
• Involved in cleaning up data from both WAMU and EMC. Removing unused loans and standardize loan according to chase.
• Identify reports that are dependent on these loans and recode to add old loans number along with new loan numbers.
• Developed data reconciliation scripts that check data counts between two systems.
• Worked under Mortgage loan modification project and developed several stored procedures that run daily to load report tables.
• Responsible for successful run of daily jobs that trigger these procedures and make sure reports are refreshed before the users run reports.
• Worked with other teams to convert old stored procedures that were run manually to be rewritten and be automated which would help identify if any tables aren’ Confidential loaded.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, triggers, C, Pro*C, Shell scripts.
• Developed shell scripts to kick off back end PL/SQL, SQL, Pro*C programs.
• Developed some PL/SQL scripts, which will change the server data across all the components in the system.
• Developed triggers and PL/SQL procedures for automation of jobs scheduling
• Analyzing performance of database objects and suggesting DBA for Indexes, schema gathering, partitioning, explain Plan, TK PROF.
• Used SQL* Loader to upload the bulk data from formatted text files into Oracle tables.
• Implemented PL/SQL to perform application security and batch job scheduling

Environment: Oracle 11g, Java, Autosys, UNIX Shell Scripting, SQL*Loader, SQL*Plus, Toad, Data Modeler, Forms 11g.

Confidential, Charlotte, NC

Sr. Data Analyst/Oracle Database Developer

Responsibilities:

• Creating and managing table, Indexes, table spaces, db links and privileges.
• Involved in the logical design of the COMPASS Datamart.
• Parsing and loading XML files conforming to XSD into Oracle 10g using SQL*Loader and DOM Parser.
• Loading flat files coming from Up-stream systems into Oracle using SQL*Loader.
• Speaking to Business Users to gather requirements and creation of Design Documents. Acting as Point of Contact for Metro Area Network Database.
• Developed Procedures for Morphing Sensitive Customer Details.
• Developed Packages and procedures for Extraction, Transformation and Loading processes.
• Improved the performance of ETL process by fine tuning queries, creating appropriate indexes and using temp tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors
• Produced SQL reports to address the fallouts between pre and post migrated data.
• Created Dashboard reports for Higher Management.

Environment: Oracle 9i/10g, MS SQL Server 2005, Teradata V2R5 XML, DOM Parser, Windows NT/2000/XP, UNIX (Solaris), Weblogic 9.x, Pro*C, Autosys, SQL*Plus, PL/SQL, SQL*Loader, PVCS, PL/SQL Developer, Toad.

Confidential, Oklahoma City, OK

Sr. Data Analyst /Oracle Database / DW Developer

Responsibilities:

• Creating and managing table, Indexes, table spaces, triggers, db links and privileges.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Produced SQL reports, data extraction and data loading scripts for various schemas.
• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
• Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
• Involved in code reviews and Production Support and Carried the pager on roaster basis.
• Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration.
• Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
• Created Ad-hoc reports as needed and carry out report projects as required
• Analyzed the existing method for data repository refresh and then developed a new package with tuned queries to improve the performance and reduce the time taken for the refresh.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Developed complex reports based on an Oracle views using running totals, sub totals, grand totals and conditional formatting.
• Involved in uploading and porting of reports into the web based Real-time Query servers.
• Wrote PL/SQL procedures to generate DDL scripts that created database objects dynamically based on user inputs.
• Written shell scripts for FTP the data file and look-up for executing the SQL*Loader
• Developed and scheduling Autosys jobs using UNIX scripts (Creating .jil file).
• Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization.
• Generated and maintained Keys, Constraints and Relationships between the tables for OLTP, Test, Development, PV and Archive instances.
• Optimized critical queries to eliminate Full Table scans, reduce Disk I/O and Sorts.

Environment: Oracle 9i, Windows NT/2000/XP, UNIX (Solaris), Apache, Tomcat, C, HTML, Pro*C, SQL*Plus, PL/SQL, SQL*Loader, PVCS, Toad.