ANUSHA

Email: ac7mru@r.postjobfree.com

Phone# 903-***-****

Professional Summary:

Having 8plus years of experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi tired applications and Data warehouse environments using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL. Good experience of Performance Analysis and SQL query tuning using Query Optimizer, Indexes, Hints, Explain Plan.

•Expertise in SQL and PL/SQL programming and strong Knowledge on Oracle Architecture and Database design.

•Working on Oracle database servers 8i, 9i, 10g and11g.

•Strong working experience in use of SDLC methodologies like gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data.

•Expertise in using tools such as TOAD, SQL developer, PL/SQL developer.

•Solid experience in Banking, Retail management system, HealthCare and financial management system.

•Created Technical documentation of different lifecycle deliverables and user manuals.

•Extensively worked with various SQL scripts for relational databases.

•Expertise in all phases of the Software Development Life Cycle. Worked 24*7 to provide production support while the Project is in Production.

•Experience with Partitioning of Tables like Range and List Partitioning.

•Experience in the usage of Autosys scheduler in order to schedule jobs/packages, workflows and sessions.

•Experience in working with Data Warehouse Management System.

•Good knowledge on DBA issues like Storage, Space and Security issues.

•Good Knowledge on Oracle Application Stack.

•Experience in using several built-in database packages such as DBMS_JOB, DBMS_OUTPUT, UTL_FILE, and DBMS_SQL to name a few.

•Good knowledge on JDA concepts and Modules.

•Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Collect, Creation of global temporary tables and table partitioning.

•Good knowledge in front end development using oracle forms/reports6i/9i/10g.

•Extensively worked with third party database tools like TOAD & PL/SQL Developer.

•Experience in writing Technical design documents and developing unit test documents.

•Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.

•Expertise in loading data from legacy systems using SQL*Loader.

•Experience in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.

•Ability to learn and support new systems and applications.

•Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.

•Providing daily, weekly and monthly status reports to managers.

•Exposure to Tableau to build Dashboards and to generate Reports.

•Great Team player with Strong interpersonal, communication and documentation skills and ability to collaborate well with others in the team and also with Business Users.

TECHNICAL SKILLS

ETL Tools

Informatica Power Center 9.1/8.x/7.x, Informatica Designer, Workflow Manager, Autosys, Star Schema, Snowflake Schema, OLTP, OLAP

Web Technology

HTML

Languages

PL/SQL, SQL, C, Java, UNIX Shell Scripting, VB6

Database

Oracle 8i/9i/10g/11g, My SQL, SQL server, Teradata, Oracle Reports and Forms 11g, Oracle APEX

Operating Systems

Windows 7/98/XP, UNIX

Tools

PL/SQL Developer, TOAD, SQL Loader, SQL *PLUS, MS Visual Studio, Informatica Power Center

EDUCATION

Bachelors in Computer Science, JNT University,India.

PROJECTS

CARNIVAL, MIAMI, FL APRIL 2016 – PRESENT

DATABASE AND OPERATIONS ANALYST

Project: GLOBAL CASINO OPERATIONS

Responsibilities:

Coordinated with the business users to better understand the requirements of Brands (CCL, CAU, PCL, HAL, COS) coming from various ships and documented the needs of Users.

Visited the Ships to check the errors in Casino Machines and used it for testing.

Involved in logical modeling and physical modeling of application.

Loaded the data into database tables using SQL*loader from text and excel files.

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Created TABLES, INDEXES, SEQUENCES.

Created database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Worked on SQL queries to query and analyze the data.

Used Database links to get the data from Brands Data Warehouse.

Created Views and Materialized Views for Tableau developers to develop Tableau reports.

Worked on Complex queries to tune the performance of it.

Worked on Hints to optimize the queries.

Created and modified Materialized Views to refresh ON DEMAND.

Used Oracle Job scheduler for automating the daily jobs in UAT and Production environment.

Used Analytical functions like LAG, LEAD, FIRST_VALUE, and LAST_VALUE.

Worked on Tableau reporting to build reports, charts for the Carnival Ships.

Worked on Tuning of the SQL queries taking long time to process the request, checked Explain Plans and added Hints to reduce the response time.

Worked on PIVOT and UNPIVOT functions to Organize data from Rows to Columns and vice- versa.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.

Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Used SQL Loader to load the data from very huge files.

Created jobs using Oracle Scheduler and resolved the issues caused by Scheduler.

Involved in the continuous enhancements of Ships requirements and also fixing any production issues.

Used Merge Statement for Merging DML data with history data.

Used External Tables to Load huge Data Files.

Created Test cases for Unit Test, System Test and Integration Test to check the data quality.

Used Hyperion to extract the queries and to export the data.

Worked on Visual Basic for building reports on Anti-Money Laundering.

Gave Technical Training Sessions in UNIX and Oracle PL/SQL to fellow team members.

Worked on Tableau reporting dashboards to check Users requirement.

Created views and provided the data for users by using them.

Participated in weekly status meetings to update the status of work.

Worked with DBA in case of any issues with Tablespaces and supporting the team in case of assistance.

Worked on Business Intelligence Development Studio (BIDS) graphical user interface (GUI) to design SSIS packages for data management applications.

Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.

Tested the data in UAT and supported the team while the project is in Production.

Environment: Oracle 11g, SQL Developer, PLSQL, SQL*LOADER, PL/SQL Developer tool, Oracle Job Scheduler, Tableau Reporting, Business Intelligence Development Studio (BIDS), Windows 7.

CREDIT SUISSE, RALEIGH, NC July 2015 – March 2016

PRODUCTION SUPPORT/DATA ANALYST

Project: GMAS

Responsibilities:

Supported L2, L3 teams for any Production issues in a Database.

Coordinated with the business users to better understand the requirements and document their expectations, handling the current process, modifying and created the jobs to the updated requirements, handle the load process to data mart and eventually data warehouse.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Created External Tables, Joins, Indexes and sequences.

Experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.

Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.

Designed and developed various custom packages triggers and forms.

Used Autosys job scheduler for automating the daily regular run of DW cycle in UAT environments.

Created SQL*plus reports as per client's various needs, and developed business objects.

Worked on Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.

Formulated SQL queries, functions and processes as per customization requirement for APEX.

Supported APEX applications and conducted performance tuning for PLSQL.

Extensively worked in performance tuning of programs, ETL procedures and processes. Also used debugger to troubleshoot logical errors.

Contributed with database designs and assisted in increasing response time for APEX reports.

Reviewed peer codes and documented proof of concepts and database schemas.

Developed Procedures for efficient error handling process by capturing errors into user managed tables.

Supported QA activities, test plans and performance enhancement techniques.

Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues

Environment: Oracle 11g/10g, SQL, PLSQL, UNIX, SQL*LOADER, PL/SQL Developer tool, Windows 7.

WELLS FARGO, CHARLOTTE, NC July 2014 – February 2015

Oracle PL/SQL Developer

Project: BUSINESS DIRECT SERVICES ORGINATIONS DATAMART

BUSINESS DIRECT SERVICES supports process, technology, and information security services across the Business Direct organization and product family. BDS follows enterprise SDLC (Software Development Life Cycle) guidelines for Architecture. BDS is to collect all the Originations data which is being used by different wells Fargo departments and build a Data mart. This Includes Documenting, Designing and Developing DataMart.

Responsibilities:

Involved in gathering requirements from Business Users, used to have meetings with them.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Created User Schemas, TABLES, INDEXES, SEQUENCES, and VIEWS.

Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator,Normalizer and joiner.

Created ETL Procedures for more than 300+ tables and views on top of these tables.

Tuned performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.

Used Informatica Power Center to create and build mappings for getting the data from Flat files and other database tables.

Involved in configuring and working Team Foundation Server (TFS) to provide the source code management and project management in agile technologies.

Used Scrambled and Unscrambled functions to Encrypt and Decrypt the sensitive data.

Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.

Analyzing the code written by different developers to understand the transformation applied on columns to document them.

Tested the data in UAT and supported the team while the project is in Production.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, SQL, PLSQL, UNIX, AUTOSYS, SQL*LOADER, Toad, PL/SQL Developer tool, Flat Files, Windows 7.

WELLS FARGO, MINNEAPOLIS, MN APRIL 2014 – June 2014

Oracle PL/SQL Developer

Description

Wells Fargo Technology Banking offers a wide range of financial services to a variety of specialty industry groups. With offices located in major technology centers providing local relationship management and decision making, Wells Fargo helps to achieve strategic business objectives.

Responsibilities

•Involved in gathering user requirements and reporting requirements for a better understanding of the business process.

•Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

•Created Indexes on the columns to tune the performance.

•Extensively worked with Oracle Reports, also created new Reports as per User Requirement.

•Interacted with Customers who use Reports in case if they seek any help.

•Made modifications to existing Oracle Reports as per the requirement.

•Analyzed data, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.

•Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.

•Coded, tested and troubleshot software applications.

•Conducted unit testing and maintained data extractions and object models.

•Tested the Forms, debugged and fixed the Forms after the testing.

•Worked on Oracle Forms and Reports as per document provided by user.

•Programed in UNIX shell scripts to provide a user interface to Oracle forms and reports.

•Created Reports in PDF, XML and Excel format as per the Requirement provided by the User.

•Worked with Paper Parameter form, Paper Layout's on Oracle Reports.

•Involved in doing Unit Testing for the Packages created.

Environment -Oracle 11g,Oracle Reports and Forms 11g, SQL, PL/SQL, SQL Navigator, Windows XP/7, Service Now.

WELLCARE, TAMPA, FL February 2013 - March 2014

Oracle PL/SQL Developer

Description

Well Care Health Plans, Inc. provides managed care services targeted to government-sponsored health care programs, focusing on Medicaid and Medicare.

Responsibilities

•Gathered user requirements and reporting requirements for a better understanding of the business process and the current reporting system.

•Interacted with Business users to check regarding requirement issues.

•Created Tables, Indexes, Views, Triggers.

•Worked on Stored Packages, Procedures, Functions and Triggers using SQL and PL/SQL.

•Coordinated with DBAs to make the daily loads run much faster by tuning different aspects of the load jobs.

•Developed Packages in PL/SQL Developer tool and Toad.

•Provided production support for multiple projects.

•Worked on Hints to improve the performance of a query.

•Worked for ICD 10 Project to differentiate between ICD 9 and ICD 10, as per the requirements provided by Business.

•Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator,Normalizer and joiner.

•Worked on building mappings using ETL to load the data from other database tables.

•Worked on Router, Joiner, Lookup transformations.

•Created some oracle objects for OLAP.

•Formulated oracle process, data retrieval methods and SQL code blocks.

•Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

•Involved in projects related to Data Integration and Data Migration.

•Involved in doing Unit Testing for the development which I have done.

•Involved in configuring and working Team Foundation Server (TFS) to provide the source code management and project management in agile technologies.

•Experience in the usage of Autosys scheduler in order to run Packages and Informatica sessions.

•Used Function-based Indexes in PL/SQL Packages in order to increase the performance of Package.

•Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

•Supported QA people while testing the Data provided by our team.

Environment – TOAD, PL/SQL Developer,Windows XP/7, UNIX, Oracle 11g, Informatica Power Center 9.1.

Virtusa, Hyderabad, India February 2011 - Dec 2012

Data Analyst

Description

Virtusa is one of the Company providing Projects to different Clients including Healthcare, Financial domain.

Responsibilities

•Interacted with Business users and Business System Analyst to understand reporting requirements and prepared Functional Requirement document.

•Experience in working with Technical specification document after getting approvals of BRD's from Business users.

•Analyzed the data files to better know the business.

•Creating Tables, Indexes, Views.

•Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

•Developed database objects like Stored Procedures, Functions, and Packages using PL/SQL.

•Worked along with the DBA to resolve performance and tuning issues.

•Experience in the usage of Autosys scheduler in order to schedule workflows and sessions.

•Used different partitioning options for better performance.

•Involved in doing Unit Testing, Integration Testing and System Testing.

•Assist in QA and UAT testing and also involved in Production support.

Environment -Oracle 10g,Windows XP, SQL Loader, SQL * Plus, MS Visual Studio, TFS.

Contact this candidate