SUMMARY

• Over 8 years of Information Technology experience including data analysis, data design, data support, data mining and migration of Oracle RDBMS systems on various platforms i.e., UNIX/LINUX and WINDOWS Server platforms.
• Worked Over 6 years on different oracle database versions, which are Oracle 8i/9i/10g and 11g, SQL and PL/SQL, SQL Loader, Physical database design, Logical database design, Gap Analysis, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning & Optimization and Oracle Forms.
• Solid 6 years of experience on Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Strong experience on various programming techniques, BULK COLLECT with FOR ALL, User defined exceptions, MERGE, Global temporary tables.
• A study hold on performance tuning using AUTOTRACE, EXPLAIN PLAN, SQLTRACE/TKPROF using external Hints.
• Experience on working and designing Physical/Logical data models during initial phase of project blueprint.
• Extensive experience in ETL processes and data migration with data warehousing, mergers and acquisitions and integration from external suppliers.
• Hands on experience on various database utilities like SYS CONTEXT, LISTAGG, PIVOT, UNPIVOT, DBMS UTILITY, DBMS SCHEDULER.
• Worked on Star Schema and Kimball Theory and changing dimensions.
• Strong experience on full life cycles of software development including requirement gathering, blues print design, development, testing and support.
• Worked in different non Oracle database applications, MS Access, Tera data,R3, BO reporting tools, Microsoft reporting tools and Oracle reports.
• Proficiency on using various Oracle utility tools, Sql Plus, Sql Plus, TOAD, PL/SQL Developer, Sql Navigator, SqlLoader, Export/Import with data pump.
• Strong experience on XML manipulations using XMLTYPE/CLOB with XMLTABLE, XMLELEMENT, XMLFOREST, DBMS XMLSAVE, DBMS XMLGEN.
• Expertise in problem solving and diagnostic analytical skills and ability to communicate with different kind of individual Confidential all stages.
• Good in team leading skills including assigning and coordinating the work with offshore teams and on shore peers.

TECHNICAL SKILLS

Database systems: Oracle RDBMS 8i/ 9i/10g/11g, MS Access, Tera Data.

Programming Languages: SQL, PL/SQL, Unix Shell Script, HTML, Java Script, VB Script XML, Perl Scripting, Pro C.

Tools: & Utilities: TOAD 8x/9x/10x, SQL Plus, SQL Loader, ERWIN, Auto trace, Explain Plan, Microsoft reporting tools, AdHoc reporting tools, Execution Plan, SQLDeveloper,Autosys. PL/SQL Developer, MS Office, Putty, telnet, FTP.

Operating System: UNIX, LINUX, DOS, WINDOWS 7/XP/VISTA/2000/2003.

ERP: SAP R3 6.0.

Scripting: UNIX korn/bourne shell scripting, PERL Shell Scripting.

Version Control Tools: SVN, Adhoc versioning system

PROFESSIONAL EXPERIENCE

Confidential, New Jersey, NJ

Sr. Oracle Developer

Responsibilities:

• Worked on data export and import wizard to transfer data between different schemas in oracle using TOAD.
• Worked with various complex queries, sub queries and joins to check the validity of loaded and imported data.
• Worked on data transformation and retrieval from mainframes to oracle, using SQL loader and control files.
• Worked and developed many procedures and functions according the requirement, and developed brand new packages with cursors.
• Sound Knowledge in understanding already existed packages, and worked with them to create updated versions to solve the issues.
• Involved in creating stored procedures, functions, triggers and developed monthly and weekly reports.
• Good knowledge in database links, Worked on tables, various types of views like inline and materialized views in different databases by linking the databases.
• Worked with advanced PL/SQL concepts like collections, PL/SQL objects and records used them in building procedures and functions.
• Extensive knowledge in performance tuning the queries and development, built indexes as part of tuning and optimization.
• Worked with Export and Text IO packages and wrote many Stored Procedures in many Forms and Reports. Worked with UNIX shell scripts and PERL scripts to generate daily reports.
• Worked with dynamic SQL, developed many procedures and function with dynamic SQL.
• Worked in resolving the production issues. Developed lot of new scripts and changed few existing scripts to solve the issues.

Environment: Oracle 10g/11g, Reports 11g, Forms11g, Erwin, TOAD for MySQL, TOAD, Pro*C, Mainframes, Unix, Windows NT, Windows 2000, SQL Navigator, MS Outlook 98,MS Office 2010.

Confidential, Charlotte, North Carolina

Oracle Developer

Responsibilities:

• Work on multiple projects and multiple database instances Confidential the same time.
• Directly work with business stakeholders to receive and process data per existing processes.
• Create and edit stored procedures and functions to address new business requirements.
• Design, modify and update database tables, setting up indexes, data constraints, database views, and referential integrity.
• Write SQL codes to modify business rules to validate and load on database.
• Create and maintain scripts with SQL loader to perform data loads for multiple DB instances.
• Create CTL files and UNIX shell scripts to read, move and processed data files. Use multiple different ftp servers for file delivery and receipt.
• Perform data migration/replication between database instances.
• Write PL/SQL procedures, packages, materialized views and develop other database scripts like tables, synonyms, sequences, triggers,
• Handle tables, index and partitioning and Involved in data cleaning, merging and conversion
• Worked on agile and test driven environment, participated on daily scrum meeting, discuss and finalize road blocks.
• Use JIRA as the defect tracking system.
• Interacted with production support team regarding production issues.
• Familiar with both OLTP and Data Warehouse environments.
• Debug and optimize performance ofPL/SQLcode.
• Aggregate/window functions and commonly used OLAP functions and exception handling
• Maintain and Monitor Autosys job scheduler, Pearl watchers to monitor file loaded in FTP by line of business

Environment: Oracle 10g, 11g, Toad 9.0, PL/SQL, SQL, ERWIN, UNIX, BODI, Informatica Power Center 8.1, IBM Job Scheduler, SQL Developer, SQL *Loader.

Confidential, Manhattan, NY

Senior PL/SQL Developer

Responsibilities:

• Developed PL/SQL queries to obtain historical data.
• Developed BTEQ scripts to migrate huge volumes of data (in order of hundreds of millions) from Oracle to Teradata.
• Extensively used bulk Collects to code Procedures.
• Created PL/SQL packages, procedures and functions necessary for validations before loading records into interface tables.
• Used Exception Handling for validation of input and the ease of debugging.
• Created database objects like views, sequences, synonyms, database links required by the application.
• Managed queries, enhanced and supported service issues.
• Developed ETL objects (mappings, sessions and workflows) as per the business requirements
• Prepared Code Migration Document in order to deploy the code in testing and production environments.
• Coordinated with QA and Production support teams during code deployment in their respective environments.
• Involved in modeling, development of Metadata.
• Post Production Support for 2 months after code deployment in production environment.
• Coordinated daily activities with global team in a distributed environment.
• Maintained project document repository for ETL Objects, database objects, UNIX objects, mapping information, unit test cases, dollar audits, deployment plan, replic jobs etc.
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Worked with Excel Pivot tables.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Worked on profiling the data for understanding the data and mapping document.
• Developed Access databases and associated graphical user interfaces.
• Involved in extensive DATA validation using SQL queries and back - end testing
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Written several UNIX scripts for invoking data reconciliation.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
• Responsible for testing Business Reports developed by Business Objects XIR2
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL* Loader, UNIX, share point, SVN, Forms 6i, ETL, Informatica, Power Center 8.1, JIRA, Autosys.

Confidential, Evanston, IL

Data Analyst/ETL/PL/SQL

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.

Environment: Oracle 8i/9i, Toad 9.0, PL/SQL, SQL, ERWIN, UNIX, BODI, Informatica Power Center.

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Responsible for data analysis, business/systems analysis; ETL process documentation; user requirements/ functional specs; technical specifications;
• Identify issues, information and behaviors during the adoption of a proprietary information management system.
• Executed and scheduled tasks; batch processing, metadata management and data mapping.
• Worked with Development team to create necessary operational documents and transition daily support activities with Tier1 team
• Created ETL documents detailing the ETL (database navigation and data transformation) logic used by developers as coding specifications.
• Scrubbed data to accurately generate customer pull. Provide output files in various file format based on customer request.
• Tested several data migration application for security, data protection and data corruption during transfer
• Extensively done the data analysis using SQL, PL/SQL and many other queries based on the applications.
• Accelerate the rate of adoption of the system, improve the quality of the data being input and generated, and promote accountability amongst the staff and users.
• Identified, tracked and resolved performance problems.
• Made recommendations on potential functional and technical improvements to planned or existing system components and applications.
• Added new features for compliance with and maintenance of quality standards.

Environment: Erwin, ETL (Informatica), Oracle 8i,SQL *Loader, SQL Developer, Oracle, SQL Server 2005, T-SQL, VB 2003.