Developer Sql

Abhijit Ankaraju ********.*******@*****.*** 573-***-****

Executive Summary

5+ years of database development experience on Design, Development and Implementation of projects using Oracle (SQL, PL/SQL).

3+ years of experience as Database developer working on Data warehousing environment with extensive experience in PL/SQL programming on Oracle.

Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.

Strong Exposure in writing Complex SQL’s, Functions, Stored Procedures, Packages, Sub queries, Normalization of database and creation of Oracle Objects (Tables, Materialized views, Triggers, Synonyms, anonymous blocks, Indexes and User Defined Data Types).

Extensive experience using SQL*Loader and SQL*PLUS.

Experience in Performance Tuning - analyzing query plans and query tuning using EXPLAIN PLAN and use hints as required. Resolved performance issues working closely with DBA's.

Experience in advanced PL/SQL concepts like Bulk Collect, Dynamic SQL, Collections and Exception Handling.

Extensively worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformations Developer, Mapplet and Mapping Designer.

Strong expertise using Informatica Power Center Client tools - Designer, Workflow manager/monitor and Server tools – Informatica Server.

Extensive work experience in Extraction, transformation and loading of data consisting of data sourcing, data transformation, mapping and loading of data from multiple source systems into Data Warehouse using Informatica Power Center.

Involved in Unit testing, System testing to check whether the data loads into target are accurate.

Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

Significant experience working with client(s)/user(s), technical teams for executing concurrent multi-technology projects.

Possess excellent oral / written communication and interpersonal skills.

Technologies

Database Environments : Oracle, SQL Server, MySQL

Database Tools : Toad, SQL plus, SQL developer, Informatica Powercenter

Programming Languages : C, SQL, PL SQL, UNIX Programming.

Software : MS Office, Matlab, MS Visio

Operating Systems : Microsoft Windows, UNIX and LINUX

Hardware Knowledge : Basic Hardware Maintenance and Troubleshooting.

Professional Experience

ZENITH INSURANCE, CA Aug’ 13 – Present

ETL/PL/SQL Developer

Zenith National Insurance Corp. is an indirect wholly-owned subsidiary of Fairfax Financial Holdings Limited primarily engaged nationally in the workers' compensation insurance business. They are committed to workplace safety and health, quality medical care, returning employees to work and managing claim costs.

Roles and Responsibilities

Designed data model to meet the business requirements, created tables, views, anonymous blocks, materialized views, stored procedures, packages and functions.

Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.

Created/Modified Informatica ETL, Data stage mappings in various stages folders like Staging area and production area for development and production environment that transfers data from SQL Server, Oracle Source systems to Oracle Target system.

Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.

Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.

Design the mapping to remove to duplicate source records.

Developed Mapplets using Mapplet designer.

Solid Expertise in using both Connected and Unconnected Lookup transformations.

Applied Slowly Changing Dimensions like Type 1 and 2 effectively to handle the delta Loads.

Initiative taken towards automation of ad-hoc processes as per Business requirement.

Experience in partitioning tables to improve performance and scalability.

Experience in developing analytical functions like Rank, Dense Rank, Row Number and Partition Over.

Tuned database SQL statements and procedures by examining explain plans, monitoring run times and system statistics. Applied database hints, fine-tuned indexes and rewrote code to improve performance.

Developed core PL/SQL Packages accounted for error handling and logging routines.

Helped prepare the mapping document which details out the mapping of source to the target data model with application of business rules.

Responsible for Unit level testing and Application testing.

Supported various environment data needs

Addressed the needed changes in database functionality responding to changing business requirements

Developed reports using queries as per client request as a part of production support

Environment: Informatica power center, Oracle SQL, PL/SQL, SQL plus, UNIX Shell Scripting, Toad and Windows.

VANTAGE ILM, CA Apr’12 – Jun’13

ETL/PL/SQL Developer

Vantage ILM is a software development company which develops software for automobile industries complete Loan Management systems for lenders. Its software platform provides origination, servicing, collections, recovery management, collateral management, accounting, analysis and reporting, and document management capabilities to process various types of loans and leases.

Roles and Responsibilities

Expertise in Designing and developing anonymous blocks, views, materialized view, stored procedures, functions, Ref & Traditional Cursors, and Dynamic SQL as part of Project/Application requirements.

Experienced in developing mappings, sessions and workflows in Informatica Power Center.

Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.

Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping

Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.

Extensively used Expression Transformation for data cleansing using functions LTRIM, RTRIM, ISNULL, ISDATE, TO_DATE in the staging area. Also used functions like Decode, Substr, Instr

Written PL/SQL Database triggers and Integrity Constraints to implement the logic required to meet the business rules in the application.

Created partitioned tables and partitioned indexes to improve the performance of the applications.

Coded packages and procedures to perform data loading, logging and error handling.

Optimized SQL statements and PL/SQL blocks by analyzing the execute plans of SQL queries for performance improvement.

Regular interaction with onsite team in terms of any issues and ensures the issues are solved on priority basis

Trouble shoot performance issues and bugs within packages, and reports using dbms_output, explain plan.

Conducted Unit Testing of developed mapping.

Attended daily and weekly triage issues calls.

Worked closely with Project team(s), and reported to management on different statuses.

Environment: Oracle SQL, PL/SQL, UNIX Shell Scripting, Informatica power center, ALM (QC) and Windows.

BEST BUY, MINNESOTA, MN May' 11 - Feb' 12

PL/SQL Developer

Best buy client of Accenture is an American multinational consumer electronics corporation. It operates in the United States, Mexico, Canada and China. Accenture helps in providing transaction tax service offering provides solution to its global tax responsibilities.

Roles and Responsibilities

Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.

Involved in developing materialized views, views, synonyms and db links to access data across schemas, indexed to gain performance.

Developed packages, stored procedures to extract the data from different sources and load it into data warehouse.

Extensively used Cursors, User-defined Object types and Tables in PL/SQL Programming.

Analyzing the data and Mapping the data requirements by developing Packages, Functions and Triggers.

Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.

Analyze SQL statements, reorganize database objects, partitioned tables and partitioned indexes to improve response of queries for better performance of application.

Creating Index’s, passing hints and analyze the table statistics.

Applying constraints and writing triggers to apply the business rules.

Involved in handling errors and transaction processing in the procedures.

Performed SQL tuning using Explain Plan and Hints.

Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.

Involved in handling the changes in compiling scripts according to the database changes.

Environment: Oracle, PL/SQL, Toad, UNIX Shell Scripting, Quality Center and Windows.

VIRTUSA, HYDERABAD Sep' 09 - Apr' 11

Jr. PL/SQL Developer

Virtusa Corporation is a global information technology (IT) services company providing IT consulting, technology and outsourcing services. It is the leading software vendors in Banking & Financial Services, Insurance, Telecommunications, Technology and Media, Information & Education industries.

Roles and Responsibilities

Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.

Developed SQL queries for data retrieval from various database objects including tables, sequences, triggers and views.

Created PL-SQL packages and procedures to perform data loading and error handling.

Used UTL_JOB to automate the PL/SQL procedures and packages.

Experience in converting data from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.

Created Materialized Views and partitioning tables for performance reasons.

Tuned Stored Procedures for faster execution and Developed database structures, according to the requirements

Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application

Involved in Unit Testing Procedures, Triggers and Functions.

Resolving the issues on priority basis.

Work closely with project teams and report it to management and different statuses.

Environment: Oracle, SQL, PL/SQL, Toad, SQL Developer, Quality Center and Windows.

Education: Bachelor of Technology, Electronics and Communication Engineering, India

Contact this candidate