SUMMARY

• Oracle Professional with 5+ years of experience in Analysis, Design, Development, testing, Production Support, Implementation and maintenance of various software applications in Client/Server & Web applications using Oracle databases 11g/10g/9i/8i.
• Demonstrated expertise in SDLC on various phases dat includes Requirements Analysis, Software Specifications, and High/Low Level Design, Testing and Deployment.
• Experience in RDBMS development including coding using SQL*Plus, Oracle SQL Developer, SQL*Loader, TOAD, SQL* Loader and good understanding of Oracle data dictionary.
• Expertise in working with Oracle 7, 8i, 9i, 10g, 11g, PL/SQL developer, Experience in the development of SQL Queries, Stored Procedures, Functions, Cursors, Triggers and Packages.
• Experience in development of database objects like tables, indexes, Materialized Views, Procedures and synonyms.
• Extensively involved in developing programs to import data from legacy system into oracle database using SQL*Loader.
• Experience in Query Optimization, Debugging, Tuning and improvising performance of the database, using the Oracle tools like Oracle Hints, TKPROF and Explain Plan etc.
• Performance Tuning of database by creating and usage of indexes and gathering table and index statistics.
• Experience in advanced PL/SQL constructs like Oracle supplied Packages, Nested tables, Varrays, Records, Types, Dynamic SQL.
• Expertise in SQL and PL/SQL programming, in developing complex code units, Database Triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views).
• Experience in creating Forms and Reports using Oracle tools like Oracle Forms (10g/6i/5.0/4.5) and Oracle Reports (10g/6i/3.0/2.5).
• Exposure to Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Extensive experience with Informatica power center and its components like Repository Manager, Designer, Workflow Manager and Workflow Monitor, Reusable Transformations, Power Exchange, Mapplets etc.
• Experience in Data warehousing, Data Architecture & Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center 9.0/8.6.0/8.1.1/7. x/6.x/5.x.
• Expertise in Shell Scripting, setting the cron tab jobs for automating production task and Autosys batch job processing in UNIX.
• Experience in writing Explicit Cursors and Handling Exceptions while developing the applications.
• Excellent analytical, problem solving, communication and interpersonal skills to manage and interact with individuals at all levels.
• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and written communication skills.
• Ability to learn new technologies at rapid speed.

TECHNICAL SKILLS

Oracle Tools: PL/SQL, Forms Builder, Reports Builder, UTL FILE, SQL*LOADER, SQL Trace, Export, Import, Oracle Query Builder, SQL Navigator, SQL *Plus, Erwin, TOAD, VI Editor, Win Runner, VM ware.

Languages: SQL, PL/SQL, C, HTML, XML, UNIX

Operating Systems: UNIX, Windows 2000/2003/XP/ 98/95/Vista/07, LINUX.

RDBMS: Oracle 11g/10g/9i/8i and SQL Server.

GUI: Developer/2000 Forms 9i/6i/5.0/4.5,Reports 9i/6i/3.0/2.5, VB.

Testing Tool: Win Runner, QTP, Load Runner.

Version control tools: Subversion, Clear Case, TortoiseSVN

Protocols: HTTP, TCP/IP, FTP.

Office Tools: MS Word, Excel, Power Point, Visio, UML, Erwin, MS Project.

Reporting Tools: OBIEE 11.1.1.6,BI Publisher, Crystal Reports, Oracle Reports & Excel Reports.

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x/5.x (Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager).

Job Scheduling: Informatica Scheduler, Control M

PROFESSIONAL EXPERIENCE

Confidential, Conway, AR

Sr.Oracle developer

Responsibilities:

• Coordinated with the team to study and gatheird system requirements.
• Participated in daily AGILE SCRUM meetings with the Project Manager and the Business Users.
• Involved in designed the necessary table structures and table relations.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, Procedures and Packages.
• Ensure conformance to code standards and documentation requirements.
• Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.
• Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
• Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures.
• Developed Triggers to enforce complex business rules and to audit changes to data.
• Created database links to connect remote database.
• Create temporary table in a Stored Procedures.
• Tuned SQL statements and Procedures using Explain Plan and TKPROF.

Environment: SQL, PL/SQL, Oracle 10g/11g, SQL Plus, Oracle SQL Developer 4.1.2, TOAD oracle 12.5,Putty, Fuse, Core FTP, Winscp, UNIX, Ultra edit, MS - Office.

Confidential

ETL Developer (Informatica)

Responsibilities:

• Worked closely with the end users in writing the functional specifications based on the business needs. Analyzed the source data coming from Oracle. Coordinated with Data Warehouse team in developing Relational Model.
• Created FTP connections, database connections (ODBC) for the sources and targets.
• Designed and developed mapping using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Worked on Star Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Scheduled the sessions to extract, transform and load data into warehouse database as per business requirements.
• Developed Fast Export scripts to send data files to other teams.
• Interacted with Teradata DBA team for creation of primary and secondary indexes on data warehouse tables.
• Developed Procedures and Functions in PL/SQL.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Created Unit Test Plans and involved in Primary Unit Testing of Mappings.

Environment: Informatica Power center 8.6/9.0.1,Workflow Manager, Workflow Monitor, Erwin, TOAD, PL/SQL, Flat files, Oracle 10gi, Teradata.

Confidential

ETL Developer (Informatica)

Responsibilities:

• Requirement gathering and Business Analysis.
• Played a key role in designing the application dat would migrate the existing data into Annuity warehouse effectively by using Informatica Power Center.
• Data modeling and design of for data warehouse and data marts in star schema methodology with conformed and granular dimensions and FACT tables.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created and managed the local repositories and permissions using Repository Manager in Oracle Database and Created users and groups and assigned privileges using Repository Manager.
• Involved in the creation of Fact Tables and Cubes (Dimensions and Measures).
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations.
• Moving mapping and sessions from development to production environment.
• Created Schema objects like Indexes, Views, and Sequences.
• Created Tasks, Workflows and Worklets using Workflow Manager. Monitoring of Workflows and Worklets using Workflow Monitor.
• Tuned mappings for improving performance.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and, sequence buffer length.
• Automated load run on Informatica sessions through UNIX Corn, PL/SQL scripts and implemented pre and post-session scripts, also automated load failures with successful notification through email
• Involved in Working with Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.

Environment: Informatica Power center 8.6/9.0.1, SQL Server 2000(Query Analyzer, DTS, TSQL), Oracle 11g, 10g, PL/SQL, SQL, TOAD, Business Objects 6.5, Perl script, Sun Solaris 2.

Confidential, Topeka, KS

Sr.ETL/PLSQL developer

Responsibilities:

• Creation and development of Oracle PL/SQL packages, stored procedures, functions, anonymous blocks, views and used them for report design
• Developed and tuned the complete complex reporting architecture and data flow involving up to 20 variable inputs right from scratch under tight deadlines
• Performed complex scripting and querying in both the development, testing as well as the production environment.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, and IIF functions in Expression Transformation
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Extensively worked with joiner functions like normal join, full outer join, master outer join, and detail outer join in the joiner transformation
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject the items based on the requirement
• Wrote stored Procedures/Functions/Packages in various schemas as per business requirements and was involved with the tuning, Performance, Optimization of queries and standardization of the code.
• Developed PL/SQL Packages, Procedures, Functions for validating the Invoices and Payment information from legacy systems.
• Developed the Request sets dat are scheduled to submit concurrent programs in a desired sequence as per the functional document.
• PL, SQL, SQL Development and Tuning Skills, Process Automation using Shell Scripting
• Version Control code repository to maintain version of the code, used SVN tortoise.

Environment: s: Informatica Power Center 8.6.1/8.5, Informatica Power Exchange, Data Explorer, Data Quality, PL/SQL, Oracle 10g,SQL Server, Sybase, Cobol, Teradata, Flat Files, UNIX Shell Scripting, Windows XP, CA Autosys.

Confidential, Nashville, TN

Sr.Oracle developer

Responsibilities:

• Duties also include developing application deployment strategies, troubleshooting and upgrade strategies.
• Design and development of database schemas, object relation mapping, oracle forms and reports, database performance tuning.
• Worked as a developer for the team of 5, which was involved in Forms and Reports.
• Customization of forms depending on the present day requirements and new kind of premiums and many sql/unix scripts as part of the application.
• Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for month-end batch processing.
• Automating routine tasks using UNIX Shell Scripting and Oracle DBMS JOBS.
• Automated data fetch using Core FTP and UNIX shell script
• Create UNIX shell script to retrieve the flat file from the Core FTP site using shell script.
• Involved in uploading and downloading of the flat files from UNIX server using Core FTP.
• Rewritten PL/SQL procedures, Functions, Packages and triggers.
• Extracted the data from different sources like COBOL Files, Flat files (delimited & fixed width) and Oracle.
• Wrote stored Procedures/Functions/Packages in various schemas as per business requirements and was involved with the tuning, Performance, Optimization of queries and standardization of the code.
• Wrote several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Extensively used UTL FILE to read and write files dat are located on the server.
• Generated UNIX Shell scripts to automate jobs and loading process for staging, transformation and loading of the data into base tables.
• DBMS utilities were used to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL FILE to read and write from database to generate a data file, DBMS SQL to write Dynamic SQL etc.
• Heavily involved in tuning of queries using tools like Explain Plan, Trace and TK- Prof and concepts like Parallelism, partitioning, hints etc.,
• Experience with Oracle 11g new features such as Pivot and Unpivot operators and analytic functions.
• Worked closely with QA and UAT teams in testing the developed program units and reports and successfully moving them to Production.

Environment: SQL, PL/SQL, Oracle 10g/11g, SQL Pus 11.2.0.1.0 , Oracle SQL Developer 3.2.20, TOAD oracle 12.1,Putty, Core FTP LE, Oracle Forms 11.1.2, Oracle reports 11.1.2, UNIX, COBOL, VSS 8.0, Oracle data modeler, TAS copy, (Microsoft Visual SourceSafe), MS-Office