Data Developer

Annapurna S

Oracle PL SQL Developer

******.***********@*****.***/201-***-****

PROFESSIONAL SUMMARY:-

•Having 7+ years of experience as Oracle PL SQL programmer and Informatica Developer.

•Experience in all phases of SDLC including Requirement Analysis, Application Design, Development of Multitier Applications, Testing, Implementation and Maintenance.

• Experience in database programming in SQL, PL/SQL and Advanced PL/SQL using Oracle 8i/9i/10g databases.

•Proficient in SQL, PL/SQL stored procedures, packages and triggers.

•Expertise on designing and implementing Oracle Alerts and Lookups.

•Expertise in working with Oracle Apex reporting tool.

•Experience in working high-transacted OLTP systems.

•Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP).

•Expertise in performance tuning, fine tuning SQL queries for improved performance.

• Knowledge and experience in Software Development and Software Quality Assurance.

•Review project components for adherence to standards (Project plans, requirements documents, design documents, test plans and other work products as the parts of the SDLC).

• Experience in development, testing, production support and maintenance projects.

•Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.

•Experience in working in AGILE environment, and ability to work in pressurized environment with tight deadlines.

•Experience in core java concepts.

•Experience in creating Informatica Mappings, Sessions and Workflows using Informatica 8.6.1/9.1/9.5

•Experience in Control-M job scheduling tool, and exposure to UNIX and Perl.

•Experience in using source code analysis tools, automated build process and unit testing.

•Good verbal and written communication abilities.

•Experience in problem solving and able to think “outside the box”

•Experience in Production Operations and Configuration Management

•Excellent communication, problem solving and interpersonal skills

•Quick learner, work under pressure to meet deadlines and excellent team player

TECHNICAL SKILLS:-

Programming Languages: - SQL, PL/SQL, Java, HTML, UNIX Shell scripting.

Tools/Utilities: - SQL*Loader, SQL*Plus, SQL Developer, Putty, Toad.

Office Tools: - Microsoft Word, Excel, Outlook, Access, PowerPoint

Operating Systems: - Windows 95/98/NT/XP/Vista/7, 8, 10 UNIX

Databases: - Oracle 11g/10g/9i, Database Enterprise Edition, Oracle 10g/9i Application Server

Professional Experience:-

Client: CVS Pharmacy, Tampa, FL Sep2015- till date

Role: Oracle PL/SQL Developer

Project: LEP End to End Changes

LEP End to End Changes project is based on the enrollment in to the particular plan that crossed certain age. It contains all the maintenance of the members like change in the plan and calculating the late enrollment penalty.

Roles and Responsibilities:

•Involved in gathering requirements and created design documents and mapping documents.

•Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.

•Migrating data from legacy systems into Facets database (Oracle) and into Data warehouse.

•Writing PL/SQL code to integrate data from multiple source systems into Data Warehouse and Facets.

•Writing PL/SQL code. (Stored procedures, functions, triggers, packages, batch jobs, etc.).

•Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.

•Performing SQL and PL/SQL tuning using Explain Plan, Execution plan, SQL Trace utility, TKProf & DBMS_PROFILER.

•Writing Korn shell scripts.

•Carrying out code review of other developers.

•Maintaining different versions of codes using SVN.

•Using SQL*Loader, BCP (bulk loader), Informatica Power center to load data from external files.

•Using DBMS_JOBS, DBMS_SCHEDULER to automate jobs.

•Writing Batch jobs, daily jobs, one time jobs and queues.

•Using Oracle Reports for reporting.

Environment: Oracle 10g, 11g, TOAD, PL/SQL, UNIX, java, Control-M.

Client: JP Morgan, Cincinnati, OH Aug 2013-Sep2015

Role: Oracle PL/SQL Developer

Project: IRS Reporting

IRS Reporting project emphasizes on maintaining a database of record of a merchant’s business information and his Tax records, in a credit card processing company. It includes generating yearly 1099Ks (which has the amount of yearly transactions) per merchant, per tax record and notifying the merchants. It also includes, with holding of merchant funds if the Tax and Business information is not validated by IRS.

Roles and Responsibilities:

•Contributed from design to implementation and maintenance phase of the application in AGILE environment/methodology

•Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.

•Create packages with override functions that could be utilized by other systems that interface with this application

•Analyze data using complex SQL queries, across various databases

•Create Materialized Views that refreshes data from other databases, via DB Links

•Assist Quality Assurance team with any functional and regression testing efforts

•Provided assistance and support to programming team members as required.

•Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

•Designed Physical and Logical Data model and Data flow diagrams.

•Worked on various tables to create Indexes to improve query performance. Involved in writing several Queries and Procedures.

•Worked with several tools to access and perform several operations on database. Experience in Generating Reports.

•Used joins, indexes effectively in where clauses for Query optimization.

•Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

•Co-ordinate with multiple application development teams, since the application interfaces with multiple systems

•Create huge volumes of test data to test heavy data loads across multiple systems / databases

•Analyze and study to understand the business of each system I was interacting with, by analyzing the data sets in each system

Environment: Oracle 10g, 11g, TOAD, PL/SQL, UNIX, Informatica 8.x/9.x, UNIX Linux, Windows, java, Control-M.

Client: American Family Insurance, Madison WI Feb 2012- Aug 2013

Role: Oracle PL/SQL & Informatica Developer

Project: Address Validation and Tax Calculation on Orders

Address Validation and Tax Calculation on Orders process, goes through Postal address validation and tax calculation on orders of the customer.

Responsibilities:

•Analyze data by creating simple SQL queries and identify fact and dimension tables.

•Design mapping using various transformations such as Source Qualifier, Expression, Joiner, Sorter, Union, etc.

•Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

•Designed Physical and Logical Data model and Data flow diagrams.

•Utilize Web Service Transformations, and configure web service WSDLs in the Connections of Workflow Manager

•Manually run scripts in development to validate, DB link, jobs correctly load tables through SQL*Loader

•Create Sessions and Workflows using Workflow Manager, and associate mappings, sessions and workflows

•Create parameter file as a text file, defining various parameters within, and save the file in a specific directory on the Informatica

•Utilize templates to create Perl scripts that is used to schedule the workflows as per business requirement

•Use Control-M job scheduling tool to execute the workflow

•Create Unit test documents and process flow documents using Business Requirements and Design flows

•Co-ordinate with data architects team, to import required source and target tables from specific database schemas

•Create test data, that can be used in Unit testing most effectively

•Perform load testing, with huge amounts of data to validate the performance of mapping

Environment: Oracle 10g, 11g, TOAD, PL/SQL, UNIX, Informatica 8.x/9.x, Web Services, Control-M.

Client: Merchant Link, Tampa, FL Nov 2011- Feb 2012

Role: Oracle PL/SQL Developer

Project: Card Authorization, Settlement Reporting

Card Authorization and Settlement Reporting system is maintained for Credit, Debit, and Gift card transaction processing from both Authorization and Settlement perspective. The gift card Authorization and Settlement data is replicated from a mainframe system into Oracle tables. The data from Oracle is used to provide daily, weekly and monthly reports to merchants.

Responsibilities:

Going through the requirements. Developing Flat File Reports for Transaction, Card, Merchant Activity and Merchant Money settlement Reporting Using PL/SQL and Informatica.

Loading Incremental Data to Fact and Dimension Tables.

Built the PL/SQL (Procedures, Functions, Triggers, and Packages) and Informatica Processes to summarize the Data to populate summary tables which will be used for generating reports with Performance Improvement.

Analyze, develop, tune, test, debug and document processes using technologies SQL, PL/SQL, Informatica, UNIX, and Control-M.

Tuned the application with functional Indices, Temp tables, right partitioning, data in sequence storage and avoid nulls, converting views into snap shots/tables, daily analyzing tables, with clause, window functions and avoiding full table scans, hints and explain plan and monitoring database.

Environment: Oracle 10g, 11g, TOAD, SQL Developer, PL/SQL, UNIX, Informatica 8.x/9.x, UNIX Linux, Windows, SVN, Control-M.

Client: S&P Capital, Hyderabad India Feb 2010- Sep 2011

Role: Oracle PL/SQL Developer

Responsibilities:

Work on multiple projects and multiple database instances at the same time.

Directly work with business stakeholders to receive and process data per existing processes.

Create and edit stored procedures and functions to address new business requirements.

Design, modify and update database tables, setting up indexes, data constraints, database views, and referential integrity.

Write SQL codes to modify business rules to validate and load on database.

Create and maintain scripts with SQL loader to perform data loads for multiple DB instances.

Write PL/SQL procedures, packages, materialized views and develop other database scripts like tables, synonyms, sequences, triggers.

Handle tables, index and partitioning and Involved in data cleaning, merging and conversion

Used agile development methodology for application development and design.

Involved in day to day meeting with development team in agile environment updating with further steps and providing feedback on current issues.

Environment: Oracle 10g, 11g, TOAD, SQL Developer, PL/SQL, UNIX, Informatica 8.x/9.x, UNIX Linux, Windows, SVN, Control-M.

Client: Airtel, Noida India Jan 2008- Feb 2010

Role: Oracle PL/SQL Developer

Responsibilities:

Used SQL Loader to Load data into the custom tables.

Extensive use of PL/SQL Programming like Procedures, Functions, Triggers and Packages and used Dynamic SQL in Stored Procedures.

Developed code using Generics APIs to avoid run time exceptions.

Involved in fine tuning SQL Queries by properly using indexes and hints.

Environment: PL/SQL Developer, Toad, Oracle 9i, SQL, PL/SQL, HTML, UNIX, Windows 2000.

Education :-

Bachelor of Engineering in Computer science from Hyderabad, India

PROFESSIONAL SUMMARY:-

PROFESSIONAL SUMMARY:-

PROFESSIONAL SUMMARY:-

PROFESSIONAL SUMMAR

Contact this candidate