SUMMARY:

• Over Six years of professional IT experience in Oracle Application Development, PL/SQL. Oracle Forms & Reports Agile PL/SQL SQL loader Client Relations ODI TOAD Excellent
• Communication Skills Performance tuning
• Certified Oracle Associate with over 6 + years of experience in the area of software development (SDLC), analysis, design, and testing.
• Strong work experience in implementing and handling databases in Oracle.
• Good Knowledge in Data warehousing concepts.
• Hands - on experience in Extraction, Transformation and Loading processes Using Data Stage 7.5, 8.5, 9.1.2 ETL tool.
• Extensive hands-on- experience in using ISD (Input and Output), Web Service client stages.
• Hands-on experience in developing and troubleshooting Data Stage jobs, fixing bugs and addressing production issues like data issues, performance tuning and enhancements.
• Good knowledge on datastage job execution flow.
• Excellent Communication, Analytical, Interpersonal, Presentation skills.
• Work with functional team to understand business requirements.
• Hands-on experiences on ETL configuration/deployment for centralize data collection.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation, and Maintenance.
• Good Understanding of Data Warehousing Concepts likes Star schemas and Snowflake Schemas.
• Excellent understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them.
• Experience with change management tools like the chameleon of Remedy and processes, including source code control, versioning, branching, defect tracking and release management.
• Involved in exhaustive optimization of PL/SQL blocks in both development and production environments
• Good experience in working with the interface between different systems and a good understanding of relational databases.
• Good understanding of DBMS STATS packages that affect execution plan.
• Very good at using Sql trace and understand TK PROF report.
• Expert in using ORACLE provided packages like DBMS PROFILER,DBMS SCHEDULER,DBMS ADVANCE REWRITE for better peroformance.
• Experience in creation of various Database objects like Tables, Procedures, View, Triggers, Indexes, Packages, and Types.
• Good knowledge in writing complex queries to read data from the database and Entity relation model.
• Worked on development of Packages, Procedure, and Functions.
• Worked on improving the performance of Procedures by using Collections, Records and Types
• Good at Unix commands for navigation in UNIX operating system and has knowledge of Shell scripts.
• Good knowledge and understanding of Oracle API s
• In-depth knowledge of applications codes registration procedures
• Ability to identify system impact for small and large scale initiatives
• Very good at trouble shoot issues in applications. Solved all kinds of Data, resources, privilege related and access control related issues.
• Excellent in backtracking issues to find out the actual issue and find a root cause.
• Worked extensively on loading data from OLAP to data marts.
• Have very good knowledge on ETL tool Data Stage Designer and Director
• Actively participated in code walkthroughs and code reviews
• Experience in working Agile Software Methodology which helps the businesses responds to unpredictability.
• The ability to adapt and learn new technologies and proficient in learning them quickly.
• Experience in supporting applications through development, testing, integration testing and production cut over phases.
• Well versed with scheduling and running SQL jobs, Queuing and running the ETL jobs and have the ability to write the complex joins to validate the data.
• Experienced with Offshore/onshore business models for development activities and involved in daily calls.
• Positive attitude and capable of working independently as well as in a team.
• Strong oral and written communication skills to maintain productive work relationships with management, clients, team members and other groups

TECHNICAL SKILLS:

Operating Systems: MS Windows, Linux, UNIX, and Mac.

Database Management Systems: Oracle10g, MS Access

Programming Languages: Oracle PL/SQL, Shell Script, Java/J2EE

Operating Systems: UNIX, Red hat Linux 6.2, Windows 08.

Web Development: HTML5, JSP 1.2, XML,JSP, Java

Database Editors: Toad 12.0, SQL Developer 2.1, SQL PLUS.

Troubleshooting/Logging tools: Splunk,T-Leaf, http watch, Sumo logic

Defect tracking tools: JIRA, Boarland star team, and Rally

Change control tools: Remedy Chameleon

Other Tools: MS Visio, MS Office Suite.

PROFESSIONAL EXPERIENCE:

Sr. PL/SQL developer

Confidential, Washington D.C

Responsibilities:

• Responsibilities include being the sole point of contact for clients, understanding business requirements and designing system.
• Requirements gathering from the client and designing application based on requirements.
• As a Developer, my roles and responsibilities are gathering and analyzing the business requirements for OMS project (Outage management Systems) in collaboration with Business analysts and end users.
• Actively Interacted with project managers & team members to discuss timely deliverables, project status & Documented technical specs from functional specs in reporting point of view.
• Independently Designed and developed subject areas in RPD.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates, Dynamic Column Naming)
• Define appropriate joins, calculations, dimensions and measures in the repository
• Preparing DCD (Database Change Document) based on the requirements from clients.
• Created standard procedures and customized procedures to implement business logic.
• Preparing the low level design document based on the given high level design and the data model.
• Developing the datastage code based on the low level design and the mapping rules document.
• Prepare the unit test case and execute it by taking necessary results snapshots.
• Moving the final code to the QA environment for functional testing.
• Fixing the defects raised (if any) in the QA environment.
• Transitioning application knowledge to production support team.
• Prepare the necessary project documentation for the support team.
• Interacting with client to understand the requirements and generating reports on different systems accordingly.
• Involved in writing PL/SQL Packages, Functions, Stored Procedures and Triggers.
• Developed Unix Shell Scripts and PL/SQL Procedures to extract and load data.
• Created Database triggers to maintain data integrities and referential integrities.
• Responsible for creating tables, views, primary keys, indexes, constraints, sequences, and synonyms.
• Involved in debugging and error handling.
• Created scripts for loading data from flat files into Oracle using PL/SQL & SQL*Loader.
• Worked on database design and development for new applications.
• Created Erwin data models for developed applications.
• Automated quarterly and fiscal year jobs by setting up Cron jobs in UNIX.
• Actively worked on production issues.

Environment: InfoSphere DataStage and Quality Stage 9.1.2, WinSCP, oracle 10g, Oracle 11g, SQL, PL/SQL, HTML, Flat files, Windows XP/Linux. Java, AIA, MS Visio and MS Office Suite

Sr.PL-SQL Developer

Confidential, Detroit, Michigan

Responsibilities:

• Perform analysis to improve the performance while reading and loading data to FACETS database.
• Extensively used SQL loader and data pump utilities of ORACLE to load data from various sources to ORACLE database .
• Was a part of a 10-member team which is a point of contact for all application developers to create and manage database objects.
• Created database objects and converted business logic into PL/SQL packages with much efficient performance.
• Resolved all kinds of performance issues with regards to data retrieving and data loading.
• Used ORACLE packages DBMS PROFILER, SQL TRACE, and TK PROF reports performing Package performance analysis.
• Good knowledge on Query tuning by analyzing query execution plan and understanding and tuning steps that take most of the time in query execution.
• Created various kinds of indexes were needed and all time made sure that all database objects are analyzed properly to maintain good performance.
• Resolved database locking issues with the knowledge of v$session and v$lock tables
• Modeling the data structure of the target warehouse to store the required information.
• Measuring the overall accuracy of the data by setting up data quality rules.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Developed PL/SQL packages for Customer tracking, a summary of a sales order, Shipment and invoice, Sales Order information by customer, order etc.
• Extensively used Integration Knowledge modules (IKM) to efficiently transformed data from staging area to the target tables by generating the optimized native SQL
• Designed and Created the Process flows, ER-Diagrams, High-Level architecture diagrams.
• Designed and developed complex Interfaces using oracle data integrator (ODI) that involved Slowly Changing Dimensions, Error handling, SCD types.
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team.
• Unit tested for all the possible test scenarios.
• Using ODI, Developed, maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances. Built transformations, configured servers and established connections to various sources and targets.m
• Designed, developed and modified materialized Views, Tables, Packages, Functions and Stored Procedures.
• To implement the Business Rules, created PLSQL database triggers.
• Performed Unit testing and System Integration Testing to Validate the Report

Environment: OBIEE 11.1.1.6.X, ODI 11g / 10.1.3.4, Flat files, Web Logic Server 10.3.3, SQL, PL/SQL, Toad, SQL Developer, Unix scripting Oracle 11g, Hyperion Essbase 11.1.2.1, Windows 7, Linux

PL/SQL Developer

Confidential

Responsibilities:

• Performance testing was performed using DBMS PROFILER, SQL TRACE and TKPROF reports.
• I have part of a testing team to provide testing scripts and write test scenarios to test the application.
• We have used DBMS RANDOM to load random data to test the current application.
• The application developed was tested functionally to check if it fits in the integration.
• Team has grown from 8 to 16 in one year with client base increased for Confidential application. Implementation and configuration teams increased its strength from 80 to 140. So, we have developed various tools using java and Oracle to load data into client’s data from source systems to Confidential system
• Trained associates technically and functionally to perform various daily activities which helped customers.
• E-time being a java based application, had experience in working with Java based applications.
• Confidential frontend was developed in JSP; any trouble shooting issues were involved java code to debug. Gained good knowledge on troubleshooting application related issues.
• Handled issues with servlets call and exception handling.
• Project roles also included Production Support on weekends on a rotational basis.
• Used Rally web application to manage defects and Documentation.
• Worked with Siebel CRM to actively work on various tickets raised.
• Set up meetings with business for status reports and also ad hoc meetings for production issues.
• Worked with testing team actively before production release.
• Responsible for requirements gathering from Clients, Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Handled DBA activities like Grant/Revoke privileges to database objects
• Involved in performance tuning and testing the performance of the application.
• Provide timely updates to management on coding, status and scheduling issues.
• Review and provide input on the business and design requirements to ensure quality products.
• Involved in Technical feasibility discussions, Peer reviews and in unit testing.

Environment: Oracle 10g, PL/SQL, UNIX, JAVA, SOAP 1.1,OEM 10g,SQL Plus, Oracle database administration Windows scheduler, putty, FTP File version 7.5, Oracle 11g, SQL, PL/SQL, Windows XP, Linux.

Confidential

Database Developer/Application support

Responsibilities:

• Trained and managed confidential’s technically and functionally to perform various Operational Activities.
• Worked on weekly and monthly jobs in UNIX Cron Jobs and Data Stage Jobs for various reporting and payments processes of Confidential .
• Advance SQL statements like Analytical functions were used for report generation and used Oracle schedulers to automate the reporting monthly.
• Technical and Functional documentation according to Global Standard Operating Procedures.
• Worked on various development issues in FDW application during Simplification project.
• Improved the performance of procedures in legacy applications by rewriting the logic with collections.
• Worked with testing team actively before production release.
• Production Support of various Applications.
• Followed Chameleon Change Management process for Implementation and Documentation.
• Performed basic DBA tasks as application DBA to create and maintain database requests.
• As part of project requirement, I have done my as an associate in Oracle Database Administration.
• Worked with different applications various upstream and various downstream applications with a good understanding of data models.
• Has good exposure to ER diagrams.
• Worked with Remedy tool to actively work on various tickets raised.
• Set up meetings with business for status reports and also ad hoc meetings for production issues.
• Set up Cron Jobs for month end and year end activities.
• Automated the weekly restart of insight manager service in OPAL application, saving costs to Confidential and Coordinate with the vendor (Liquent) during weekly meetings on OPAL application.

Environment: Oracle 10g, PL/SQL, UNIX, JAVA, SOAP1.1, OEM 10g, SQL Plus, Oracle database administration Windows scheduler, Putty, FTP File version 7.5.