SUMMARY:

• Over 8+ Years of IT experience in Product Development, Health Care and Banking sector.
• 8+ Years of extensive experience in Oracle SQL and Oracle PL/SQL with proficiency in Oracle 11g/9i and UNIX Shell Scripting.
• 4+ Years of ETL experience using Informatica PowerCenter Tools, i.e. Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Informatica Server and Repository Server manager.
• Good experience in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Practical understanding of the Data modeling (logical and physical) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good experience in Database normalization, Data analysis and management.
• Solid experience of PL/SQL Packages, Procedures, Functions, Triggers, Joins, Sub Queries, Correlated Sub Queries, Views, Cursors and Ref-Cursors, Constraints, Transactions, Tables, Views, Materialized Views, DB links and Indexes (B Tree, Bitmap and Function Based).
• Good knowledge on Nested Tables, Varrays, Records, Types, Bulk Collects and Bulk Variables.
• Experienced in Oracle Packages such as DBMS STAT, DBMS XPLAN, DBMS PROFILER, UTL SMTP and UTL FILE.
• Experience in Performance Tuning and Optimization using Hints, Indexes, Explain Plan, Trace Utility and TKPROF.
• Good knowledge of key Oracle Performance features such as Query Optimizer, Statistics, Access Paths Joins, Histograms and Execution Plans.
• Extensively worked with DBAs towards Performance Tuning and Access Control.
• Experienced in Partitions and Analytical Functions to improve the query performance and manageability.
• Extensive experience in Data Migration techniques using Oracle External Tables, SQL* Loader, Import/Export and Batch Processing.
• Experienced in Sessions, Workflows, Worklets, Mappings and Mapplets using transformations including Router, Aggregator, Lookup, Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union for Informatica development.
• Developed UNIX Shell Scripts to run the Informatica Workflows and controlling the ETL Flow.
• Strong understanding of Oracle’s Underlying Architecture.
• Experienced in OBIEE Metadata Repository Layers including Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Experienced in developing OBIEE Dimensional Hierarchies, Level Based Measures and adding multiple sources to business model objects.
• Experienced in designing customized interactive Dashboards in OBIEE using Drilldown, Guided Navigation, Prompts, Filters and Variables.
• Extensively worked on developing and modifying UNIX/LINUX Shell Scripts.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including Data Mapping, Unit Testing, Systems Integration and User Acceptance Testing.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Linux, MS-DOS

Databases: Oracle 11g/9i, SQL Server, MySQL, PostgreSQL, MS-Access

ETL Tools: Informatica Power Center 8.X/ 9.X (Designer, Workflow Manager, Workflow Monitor, Repository Manager and Informatica Server), Informatica Data Explorer, Informatica Data Quality.

OLAP Tools: OBIEE Administration, OBIEE 11.1.1.7/ 11.1.1.9

Languages: PL /SQL, SQL, Shell Scripting, HTML, XML, JSON, C, Groovy, Ruby

Scheduling Tools: Autosys, Crontab, BI Scheduler, Oracle BI Delivers- iBots

Engineering Module: Waterfall, Agile

Version Controls: Tortoise SVN, CVS

Other Tools: Oracle SQL developer, TOAD, SQL * Loader, SQL*Plus, PL/SQL Developer, Import/Export, FTP, HP-QC, JIRA, SaaSC, Orion

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle PL/SQL Developer

Technology Used: Oracle PL/SQL, LINUX, Shell Scripting, Oracle 11g, PL/SQL, SQL Developer, OBIEE, APEX, SaaSC, Toad

Responsibilities:

• Created and modified database objects like Tables, Views, Sequences, Synonyms, Indexes, Stored Procedures, Triggers, Functions and Packages.
• Used Bulk Collections for better performance by reducing context switching between Oracle SQL and Oracle PL/SQL Engines.
• Followed the Agile Methodologies.
• Practical understanding of the Data modeling (logical and physical) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Implemented Partitioning Strategies for very large tables and indexes using Range Partition, List Partition and Hash Partition.
• Extensively used the advanced features of oracle PL/SQL Records, Tables, Object Types and Dynamic SQL.
• Good experience in Database normalization, Data analysis and management.
• Extensively used Oracle Packages such as DBMS STAT, DBMS XPLAN, DBMS PROFILER, UTL SMTP and UTL FILE.
• Created the oracle PL/SQL Packages, Procedures, and Functions applying the business logic to update the database with funds transfer transactions and to load the file.
• Used Hints, Indexes, Explain Plan, Trace Utility and TKPROF for SQL Tuning.
• Extensively worked with DBAs towards Performance Tuning and Access Control.
• Developed metadata repository using OBIEE Administration Tool in Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Created new Logical Columns, Dimensional Hierarchy, Calculated Measures and Aggregate Mappings in the BMM layer as per the business requirements.
• Worked on Key Performance Indicators and analyzed the data to developed Logical Star Schema model by implementing Fact Tables, Dimension Tables and Hierarchies.
• Designed and developed various Interactive Dashboards and reports with Drilldowns, Guided Navigation, Filters and Prompts.
• Worked on SQL*Loader and Import/Export to load data from flat files obtained from various facilities every day.
• Created and modified LINUX shell Scripts according to the changing needs of the project.
• Used Exception Handling techniques extensively for the ease of debugging and displaying the error messages in the Application.
• Developed test cases and performed Unit Testing and Integration Testing of the Repositories.

Confidential, New York, NY

Oracle PL/SQL Developer

Technology Used: Oracle PL/SQL, UNIX, Shell Scripting, Oracle 11g, PL/SQL, Informatica, AutoSys, SQL plus, Putty, Toad

Responsibilities:

• Analyzed the requirements and framed the business logic for the ETL Processes .
• Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.
• Developed Database Triggers for audit and validation purpose.
• Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions (CUME DIST, RANK, LEAD, LAG, etc.).
• Performed SQL and PL/SQL tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Followed the Agile Methodologies.
• Good experience in Database normalization, Data analysis and management.
• Created the oracle PL/SQL Packages, Procedures, and Functions applying the business logic to update the database with funds transfer transactions and to load the file.
• Practical understanding of the Data modeling (logical and physical) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Extensively used Hints to direct the optimizer to choose an optimum query Execution Plan.
• Extensively used Bulk Collection in oracle PL/SQL Objects for improving the performance.
• Handled errors using Exception Handling extensively for debugging and maintainability.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Created Mappings using Designer, Extracted the data from the flat files and other RDBMS databases into staging area and loaded onto Data Warehouse.
• Developed the Informatica Mappings by using Aggregator, SQL Overrides by using Lookups, source filter by using Source Qualifiers and Data Flow Management into multiple targets using Router.
• Developed reusable Workflows, Worklets, Mappings and Mapplets using transformations including Router, Aggregator, Lookup, Filter, Expression, Sequence Generator, Update Strategy, Joiner and Union.
• Worked in resolving on-going maintenance issues and bug fixes, monitoring Informatica Sessions as well as performance tuning of mappings and sessions.
• Design and develop Informatica workflows , Identify and remove bottlenecks in order to improve the performance of workflows.
• Created and modified UNIX shell scripts to run the Informatica Workflows and controlling the ETL Flow.
• Prepared UNIX Shell Scripts and scheduled in AUTOSYS for automatic execution.
• Performed Unit Test and Integration Test to make sure the deliverable is match with business requirement.

Confidential

PL/ SQL Consultant

Technology Used: Oracle PL/SQL, Oracle 11g, PL/SQL, TOAD, Toad 9.0, SVN, Putty, FTP and Windows

Responsibilities:

• Gathered the Requirement from the business and prepared the program specification and design documents.
• Created database objects like Tables, Views, Sequences, Synonyms, Cursor, Ref Cursor and Triggers.
• Created the oracle PL/SQL Packages, Procedures, and Functions applying the business logic to update the database with funds transfer transactions and to load the file.
• Wrote complex SQL queries using Joins, Sub Queries and Correlated Sub Queries to retrieve data from the database.
• Practical understanding of the Data modeling (logical and physical) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object Types and Dynamic SQL.
• Followed the Agile Methodologies.
• Good experience in Database normalization, Data analysis and management.
• Used Bulk Collections and Bulk Variables for better performance and easy retrieval of data by reducing context switching between SQL and PL/SQL engines.
• Used Oracle External Tables, SQL* Loader, Import/Export to read Flat Files and apply business logic before saving these transactions.
• Worked with Oracle packages like UTL FILE to open, read and write files to OS directories.
• Optimized and Tuned PL/SQL subprograms to reduce the loading process in case of large files using Hints, Indexes, Explain Plan, Trace Utility and TKPROF.
• Modified several UNIX Shell Scripts according to the changing needs of the project.
• Created error log file for external system containing failed transactions.
• Documented all Oracle Reports, Packages, Procedures and Functions development specifications.
• Declaring, raising and handling user defined exceptions in handling unexpected situations during compilation and execution.
• Involved in preparing Test Plans, Unit Testing, System Integration Testing, implementation and maintenance.