SUMMARY

• 8+ years of IT experience, involved in complete SDLC including analysis, design, development, testing, implementation & maintenance of application software
• Proficient working in Oracle 11g/10g/9i/8i databases using SQL & PL/SQL (Stored Procedures, Functions, Packages and Triggers)
• Experience in Designing and Development of OLAP and OLTP applications and experience in building Interface/conversion/data migration in client/server OLAP environment.
• Strong Data Warehousing, Data Marts, Data Analysis, Data Organization, Metadata and Data Modeling experience in RDBMS databases
• Attending project meetings and work with teams, Project managers, team members / associates, business analysts, statisticians, and internal customers/ end users, working with multiple tasks.
• Experience in understanding different business process, functionality requirements, and data requirements in relation to process and come up with scenarios to validate the flow.
• Designing, Developing, implementation of the Data marts, Data Structures, Stored Procedures, Functions, Data warehouse tables, views, Materialized Views, Indexes at Database level using PL/SQL and Oracle.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Thorough understanding of Normalization and De - normalization concepts and hands on experience in designing Normalized Databases and De-normalized Databases for transactional systems and analytical systems
• Document data flow diagrams, Process flow, Business Impact and technical designs for reference and maintenance
• In-depth Knowledge of Schema Objects (Tables, Global Temporary Tables, Views, Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database links) and Bulk collects/Inserts, CURSORS/ REF CURSORS, Analytical functions, Dynamic SQL, Exception Handling, XML Type.
• Extract, Transform and Load legacy data into Data warehouse and develop analytical SQL queries to generate reports using data in Data warehouse and Data marts
• Expert in Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning.
• Experience in Migrating Code to different Environments from SQL Plus interface and develop BAT files to automate code migration
• Good experience in Data Warehousing this includes data analysis, data manipulation, and programming, testing, implementation and report generation
• Knowledge of Job scheduling tools to create, modify, troubleshoot jobs, schedule and automate daily/weekly/monthly/quarterly jobs
• Good experience in both dimensional and relational modeling concepts like star-schema, snow flake schema.
• Good Knowledge and little bit hands on experience on JAVA (AWT, SWING and JDBC).
• Hands on experience in using UNIX and Shell commands to create jobs, automate processes, moving processes to background and monitoring processes.
• Experience in Data mining and analyzing data to identify the Fact and Dimension tables.
• Very good working knowledge in ERWIN, TOAD.
• Experience in providing production support and provide critical and normal patches for technical and business related bugs
• Active team player with commitment to work to meet deadline, strong communication, good analytical and time management skills

TECHNICAL SKILLS

Programming Languages: PL/SQL, C++, Java

Markup Languages: HTML, XML

Databases: Oracle 11g/10g/9i, SQL Server, ACCESS

Data Modeling Tools: ERWIN, ER Studio, SQL Developer Data Modeler

IDE(Integrated development environment): SQL*PLUS, SQL worksheet, iSQL*PLUS, TOAD, PLSQL Developer, SQL Developer, SQL Navigator, Visual Studio

Source Control Software: Visual Source Safe, Clear Case, CVS, TFS

Other Tools: INFORMATICA, XML spy, Microsoft office suite, Microsoft Visio

Operating Systems: UNIX (Solaris/HP-UX), Linux, Windows Server 2000/2003

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

PL/SQL Developer

Responsibilities:

• Analyze System Requirements to create high level and detail design documents with the assistance of requirements team and Architects.
• Have a good understanding of analytical functions with an ability to convert the business requirements to technical understanding, instantiate, iterate, and terminate the code logic to meet the user needs.
• Worked closely and supported members of teams such as Architecture, Change management, Database Management, Technical operations, System Test, UAT, Requirements and Business teams during entire life cycle of the project.
• Develop highly complex applications using Oracle 11g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Involved in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL
• Extensively worked on Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables
• Expertise in designing, developing Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project
• Analysis of business requirements, preparation of source-target mapping documents, develop data load components using ETL procedures, conduct unit testing and code walkthroughs to ensure there are no missing elements, and perform integration testing
• As a key PL/SQL developer, identify and define required analytics to design, develop financial routines, and assist various work streams in identifying, and resolving data irregularities, and establish management reporting processes and requisite supporting technology
• Designed logical and physical data models, Reverse engineering, Complete compare for Oracle and SQL server objects usingErwin.
• Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).
• Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non Clustered), Stored Procedures and Functions in Transact-SQL.
• Develop new processes using PRO*C, PL-SQL and Unix Shell Script as per business needs.
• Handled code defects, enhancements and release management using tools like Rational Clear case and Rational Clear quest
• Performed performance tuning for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor the database processes and performance.
• Involved in creating reports using Universe, Stored Procedures and Excel files as Data Sources.
• Extensively worked on Data Warehousing Design Methodology, Data Warehouse Concepts.
• Interacted with customers regularly in order to generate the reports required and to resolve the existing issues.
• Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.
• Scheduled various reports on Daily, Weekly, Monthly and Yearly basis.
• Extensively used Calculations, Variables, and Drill Down for creating Crystal Reports. Involved in Business Objects Production Support resolving the tickets, Trouble shooting and developing End user Notes.
• Used existing processes and procedures for application deployment and provided 24x7 production support as Primary

Environment: Oracle 11g, SQL Server 2008 R2, PL/SQL, Transact-SQL, Clear case, Clear quest, Rapid SQL, PLSQL Developer 7, ERWIN 9.5, Pro*C, Linux, Windows 7, Informatics, Business Objects XIR3.1, Crystal Reports 2011

Confidential, Scottsdale, AZ

PL/SQL Developer/Reports Developer

Responsibilities:

• Analyzed and reviewed Business Requirement and Functional Requirement documentation. Converted User Requirements into formal Technical specification and Interfacing with clients.
• Design and development of the Client Automated Take on module
• Involved in full development cycle ofPlanning, Analysis, Design, Development, Testingand Implementation.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Tuned Report performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Used BULK COLLECT and External Tables for improving performance on the Enterprise Data Warehouse.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign key constraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.

Environment: Oracle 11g, J2EE, Web Logic, JSP, EJB, SQL * Plus, Pro*c, TOAD, SQL*Loader, import/export, Business Objects XIR2, Crystal reports 2008, UNIX (SunOS 5.10), Informatics, Windows XP professional

Confidential, Madison, WI

PL/SQL Developer

Responsibilities:

• Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Developed AdvancePL/SQL packages, procedures, triggers, functions, Indexesand Collectionsto implement business logic usingSQL Navigator.
• Generated server side PL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Involved in creatingUNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to makeDatabaseFaster and easier to maintain.
• Experience inDatabase Application Development, Query Optimization, Performance Tuning andDBAsolutions and implementation experience incomplete System Development Life Cycle.
• Extracted data from the XMLfile and loaded it into thedatabase.
• Designed and developedOracle forms & reportsgenerating up to 60 reports.
• Performed modifications on existingforms as per change request and maintained it.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL
• PL/SQLCollections and usedBULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance.
• Involved in the continuous enhancements and fixing of production problems.
• Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL.
• DevelopedUNIX Shell scriptsto automate repetitivedatabase processes.

Environment: Oracle 10g, PL/SQL, SQL*LOADER, HTML, TOAD, XML, HP-UNIX shell scripting.

Confidential, Iselin NJ

PL/SQL Developer/Data Analyst

Responsibilities:

• Involved in data analysis and returned a report with charts, descriptive statistics, Cross Tabulations, Tests and conclusions.
• Optimizing the complex queries for data retrieval from huge databases.
• Root cause analysis of data discrepancies between different business system looking at Business rules, data model and provide the analysis to development/bug fix team.
• Involved in data Correction and validation process by using data utilities to fix the mismatches between different shared business operating systems.
• Worked on mapping and modeling of the data.
• Checking and validating data in the Mapping document running the queries.
• Modified the existing mapping template to a more clear and easy to understand template.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.
• Identified the source and target tables. Developed mapping document using MS excel
• Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers.
• Created custom functions, stored procedures, packages, database triggers to retrieve the data from data base.
• Developed ER diagrams/ Dimensional diagrams for business requirements using ERWIN.
• Responsibilities include design, development, testing, (UNIX Shell Scripts), de-normalization for reporting purpose, data security issues, development of ETL Process, development of ETL extract process, testing of data for the developed modules.
• Written complex SQL statements using joins, sub queries, and correlated sub queries.
• Involved in the data analysis and data discrepancy reduction for the source and target schemas
• Involved in Performance Tuning of the application using Explain Plan, Hints and TKPROF
• Involved in optimization process through creation of partition tables, views, indexes etc. Also tuned and optimized SQL statements.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Reverse engineering existing Informatics workflows, sessions and mappings, document process logic for future reference
• Built process to write CSV files to load in third party applications and Parse CSV files using EXTERNAL TABLES and load them.
• Developed/customized several reports using Reports 9i to meet the client requirements and necessities

Environment: Oracle 10g/9i, SQL*PLUS, TOAD, PL/SQL, Pro*C, Forms 9i, Reports 9i, UNIX, ERWIN, HTML, XML, INFORMATICA, Java

Confidential

PL/SQL Developer

Responsibilities:

• User Requirements gathering by interacting with the stakeholders and other management personnel to get a better understanding of the business process.
• Developed ER diagrams/ Dimensional diagrams for business requirements using ERWIN.
• Involved in the data analysis and data discrepancy reduction for the source and target schemas.
• Created database triggers to flip flags and perform several business validations.
• Involved in development of the SQL Scripts, Stored Procedures, Functions, Database Triggers and Packages using SQL and PL/SQL as per the change documents requirements to in corporate the changes.
• Used advanced Oracle concepts such as REF CURSORS, BULK INSERTS and BULK COLLECTS to improve performance.
• Created various database objects like tables, views, sequences, functions, and indexes
• Written complex SQL statements using joins, sub queries, and correlated sub queries.
• Made enhancements with the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Extensively worked on SQL, created joins between huge tables and materialized views to map the columns from multiple tables.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Scheduled the jobs using corn tab in UNIX.

Environment: Oracle 9i, SQL*PLUS, PL/SQL, SQL navigator, SQL*LOADER, Forms 9i, Reports 9i.