SUMMARY

• Around 9 years of experience in IT industry mainly in Design, development, implementation, testing and documentation of business applications using Oracle technologies.
• Expert in Client - Server application development using Oracle 11g/10g/9i, PL/SQL.
• 6+ years of experience using Teradata SQL Assistant, Teradata Administrator and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and TPUMP on UNIX/Windows environments.
• Experience in Dynamic SQL, Records, Arrays and Exception Handling.
• Hands on experience on writing SQL queries, PL/SQL procedures, Functions, Cursors, Triggers in Oracle and SQL server, also involved in database testing.
• Experience in Performance tuning of SQL queries using Explain plan and SQL*Trace utilities and applying appropriate Hints, Indexes and Oracle Partitions
• Oracle certified associate OCA (Developer).
• Informatica Power Center DI 9x Dev Specialist certified.
• Experienced in creating complex mappings using various transformations, and developing strategiesFor Extraction, Transformation and Loading (ETL) mechanism.
• Expertise in developing strategies for Extraction, Transformation and Loading (ETL) mechanismsUsing Informatica Power Center 9.x/8.x/7.x.
• Excellent experience in Informatica Designer to create complex mappings using differentTransformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner,
• Update Strategy, Expressions and Aggregator transformations to pipeline data to the target.
• Experienced in Teradata performance tuning.
• Performed data validation by Unit Testing, Integration and User Acceptance Testing.
• Hands on Experience in Design Data models using Erwin 4.5/4.0/3.5.
• Experienced in using SQL tools like TOAD, SQL Developer and SQL Navigator, Teradata Sql assistant.
• Good knowledge on reporting tools like OBIEE.
• Good Experience in Windows 95/98/2000/XP/NT, UNIX, Shell etc.
• Extensive experience in UNIX shell scripting, automating routine server using CRON, CA-WA.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica 9x/8x

Languages: SQL, PL/SQL

Database: Oracle 11g/10g/9i, Teradata 14,Netezza

Operating Systems: Windows 98/2000/XP/NT, MS DOS and Sun Solaris UNIX

Web Technologies: HTML

Tools: SQL*LOADER, SQL Navigator, SQL*Plus, TOAD, Oracle Forms 9i, Oracle Reports 9i

Scripting Language: Unix, PERL

Application Utilities: BTEQ, Multi load, Fast Load, Fast export, TPUMP,TPT

Data Modeling: ERWIN 4.x/3.x, Ralph-Kimball Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical and Logical Modeling, Dimension Data Modeling, Fact Tables, Dimension Tables, Normalization, De-normalization

PROFESSIONAL EXPERIENCE

Confidential, Wisconsin

ETL Developer

Responsibilities:

• Designed the ETL processes using Informatica to load data from Cobol VSAM, Oracle, Flat Files, and Excel files to staging database and from staging to the target Oracle Warehouse database.
• Work with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping & Mapplets Designer and Transformation Designer.
• Create complex mappings, Mapplets and workflow to meet the business/project needs ensured they are reusable transformation to avoid duplications.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Document ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings. Responsible for Data quality analysis to determine cleansing requirements.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions for Data Loads.
• Wrote Queries, Procedures and functions that are used as part of different application modules.
• Involved in User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit andSystem test
• Created tables, access views and update views in the development database for unit and systemTest.
• Performing the Root cause analysis for the issue related to the SQL queries.
• Providing accurate solutions by fixing and replicating the whole tables set into test environment.
• Implementing the necessary SQL code changes proactively obtaining all the client approvals for the modified queries.
• Monitoring scheduled jobs that run as per client specification.
• Checking error codes in the logs and re executing the scripts with necessary corrections.
• Hands on Experience for UAT/production deployments using Anthill.
• Hands on Experience on Scheduling jobs using CA-WA.

Environment: Teradata 14.0, Teradata SQL Assistant, Informatica, UNIX, CA-WA, Anthill.

Confidential, New York City, New York

ETL Developer

Responsibilities:

• Created the mappings using transformations such as the Source Qualifier, Aggregator, Expression, Look up, Filter, Router, Normalizer and Update Strategy
• Created and configured Worklets, workflows, and sessions to transport the data to targetWarehouse using Informatica Workflow manager.
• Mapplets and Reusable transformations were used to prevent redundancy of transformation usage and maintainability.
• Extracting, Applying transformations and loading the data from Flat files and building up theWarehouse.
• Checking error codes in the logs and re executing the scripts with necessary corrections.
• Developing UNIX scripts for the automation purpose.
• Played a key role in the development to create the tables and populated the data.
• Analysis and Review of the PR (Problem record) document provided by client.
• Analysis of the SQL Queries in the PR.
• Performing the Root cause analysis for the issue related to the SQL queries.
• Providing accurate solutions by fixing and replicating the whole tables set into test environment.
• Implementing the necessary SQL code changes proactively obtaining all the client approvals for the modified queries.
• Created Bteq scripts as per the requirement.
• Created fast load and multi load scripts and tested in test environment and move the code to
• Extensively used Fast export to export the data and Multi load to import the data
• Preparing the Implementation documents after the successful execution and validation.
• Performing Code Review as per client’s coding standards.
• Preparing the quality documents for all the phases of SDLC.
• Peer Review and Unit Testing.
• Gathering and implementing the requirements as given by the client.
• Proactively involved in the team discussions and client meetings.
• Validation for data extraction and acquisition to the warehouse.
• Prepared sql queries which are required for validation.
• Detected and corrected bugs, managed open, closed and reopened defects using defect tracking system JIRA.

Environment: Environment: Teradata, Oracle 10G, Informatica, Teradata SQL Assistant, JIRA, UNIX .

Confidential

Oracle Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions).
• Written many Stored Procedures, Functions and Packages.
• Written many database triggers for automatic updating the tables.
• Responsible for creating a report using Oracle 9i and testing/debugging the issue related with Forms and Reports application.
• Used TOAD developer tool for faster application design and developments.
• Data migration from Flat Files have been uploaded into Staging Tables using SQL* Loader.
• Identification of the database objects required for supporting the business requirements like tables, views, indexes, stored procedures, functions, database triggers, and synonyms.
• Utilized dynamic record groups to populate the LOVs and List item at runtime for data retrieval and data entry.
• Worked with performance and tuning issues. Creating tables and loaded the database on the views. Used index logic to obtain the good performance.
• Written Shell Scripts for automation of some daily tasks.
• Analyzing and resolving issues (ZRMS).

Environment: Oracle 10g, SQL*Loader, Toad, UNIX, Oracle forms 9i, Oracle Report 9i