SUMMARY

• More than 9 years experience with proven ability in the area of Client/Server and Distributed Multi - tier Application Development, Database Design, Data processing, Data Warehouse and Production Support mainly with Oracle technology on different platforms.
• Rock-Solid expert level experience on PL/SQL that includes Cursors, Ref-cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Calling Appropriate Interface tables and API’s.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
• Wrote complex batch process in PL/SQL for huge data.
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
• Handled large scale Multi-terabyte databases.
• Skillful problem solver with excellent analytical skills.
• Experience in Data flow Diagram, ER Diagrams using Oracle Designer.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
• Experienced in all phases of the system development life cycle (SDLC) and Best Practices (Oracle CDM) and Development methodologies/Guidelines.
• Accomplished in working with users/upper-level management in translating their business needs into logical systems designs, as well as working in a technical capacity to implement the designs.
• Has knowledge on Sql Server.

TECHNICAL SKILLS

Languages: SQL, PL/SQL,SQL Plus, C, Java, JSP, PHP 4.0,ASP.NET 2.0

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2000, MySQL

Other Tools: TOADS, SQL Developer, SQL Navigator, SQL Loader, Oracle EXP, Oracle IMP, QTP, ODBC, Test cases, Test scripts

Other Application: MS Office, Fuse, AdTempus, Control-M

Operating Systems: HP Unix True 64, Unix, IBM AIX, Solaris, Linux, Windows.

Version Control: PVCS., Subversion

Methodology/Best Practice: Oracle CDM Advantage 2.0

Change Control: PVCS Tracker

Case Tools: Oracle Designer

PROFESSIONAL EXPERIENCE

Confidential, Providence, Rhode Island

Oracle PL/SQL

Responsibilities:

• Created Custom Packages, Stored Procedures, Function and SQL Scripts to load data into Data warehouse from different sources clean and transform data to provide quality information, and manage corporate metadata.
• Created/updated Oracle procedures to transfer data from legacy source to staging area and from staging area to data warehouse and to data marts.
• Prepared/updated shell scripts for ETL to run in batch.
• Tested and took measures for maximum performance utilizing optimization hints, processors, storages and query optimization.
• Wrote Oracle procedures for Data transform, data profiling and cleansing.
• Created Complex SQL script, Dynamic SQL, Analytical function, Bulk Collect.
• Done Heavy SQL tuning for performance improvement.
• Monitored the pharmacy data warehouse scheduled jobs and provided support.
• Develop Data Conversion/Interface with the use of SQL*Loader and converted data.
• Writing Unix Shell Scripts to load the data as per the Business functionalities.
• Support the implementation of the project and address any post implementation defects.
• Environment: Oracle Database 10g R2, Erwin, TOAD, Sun Solaris/UNIX.
• Oracle 11g SQL, Oracle Database 11g PL/SQL, Visio, UNIX, PL/SQL developer

Confidential, Richmond, VA

Applications Developer

Responsibilities:

• Provide high quality technology solutions that address business needs by developing applications within mature technology environments.
• Utilize mature (3rd or 4th Generation) programming methodologies and languages and platforms (Oracle, PL/SQL, SQL loader, UNIX Korn Shell scripting, Toad, Excel Automation, Windows and Java) and adhere to coding standards, procedures and techniques while contributing to the technical code documentation.
• Modified existing PL/SQL modules by using Bulk Collect, Pl/SQL tables, varrays and other collection types to improve the performance of the system
• Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution.
• Participate in design reviews and provide input to the design recommendations.
• In corporate security requirements into design, provide input to information data flow, and understand and comply to Project Life Cycle Methodology in all planning steps. Adhere to IT Control Policies throughout design, development and testing, and in corporate.
• Corporate Architectural Standards into application design specifications.
• Document detailed application specifications, translate technical requirements into programmed application modules and develop.
• Enhance software application modules.
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications.
• Identify application code-related issues. Review and provide feedback to the final user documentation

Environment: Oracle 11g SQL, Oracle Database 11g PL/SQL, TOAD 8.5, Tortoise SVN (Subversion), ECM(Enterprise Change Management), ITSM, Visio, UNIX, PL/SQL developer 8.5, Eclipse, Java, Control-M.

Confidential, West Des Moines, IA

Oracle PL/SQL Developer

Responsibilities:

• Project: CORE-ODS ETL Data Development:
• The Operational Data Store (ODS) is used to acquire, prepare and deliver data that is generated within the CORE on-line applications. This data is delivered to various downstream systems including operational, reporting and analytical ones.
• The delivery of data to the WFHM Loan Information System (LIS) is the primary data delivery point along with various other sources which use this data. We used to send values to various applications through tags which were based on
• Developed and maintained the ETL framework with homegrown packages in Oracle PL/SQL utilizing alongside ETL tool, Datastage to tune around ~10 to 20 million rows.
• Tasks
• Analyzed complex data structures to generate useful business insights.
• Responsible for the analysis, design, development, also maintenance and support of software applications in UAT and Production.
• Designed and developed a pivot applications while performing aggregations over a finite set of values (i.e. days of week/ months of year) using Oracle PL/SQL procedures, packages, triggers, inline views.
• Involved in developing meta-data engine to extract data from disparate sources of data.
• Also responsible for the development of key infrastructure and/or architectural components and processes.
• Performed the following activities: requirements definition, design, development, testing and implementation.
• Used to gather requirements from data analysts and data architects and performed technical analysis to reach a viable solution for the tags to be send downstream only after they get business approved.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.
• Prepared code for data conversion scripts and data model patches and coordinated with DBAs for their execution and validation.
• Created packages and procedures to perform ETL processes like data loading, transformation, extraction, validation and reporting.
• Utilized inbuilt UTL FILE packages to create flat files and used the feature SQL loader to load tables for downstream users.
• Modified existing PL/SQL modules by using Bulk Collect, Pl/SQL tables, varrays and other collection types to improve the performance of the system.
• Supported Teamwork’s developers and created views and stored procedures to aid with their reporting needs.
• Created custom reports such as LIS Reject, Missed Closing Reasons, Loan Tag History etc using Report Builder.
• Worked on Performance tuning of the PL/SQL modules, packages etc. using Explain Plan and SQL Trace.
• Also performed DBA tasks like monitoring batch processes using oracle enterprise manager; identifying performance bottlenecks, creating indexes and grant privileges to users.
• Used unit testing and user acceptance testing and provided support to QA and other downstream systems.
• Wrote technical documents giving an outline of job flows and the process involved.
• Worked with various tools like CDTS (Clear Quest), JIRA, Tortoise SVN etc for defect tracking and version management.
• Gained necessary input/approval of requirements and design and participated in code reviews ensuring applications meet requirements and are error free.
• Worked on periodic maintenance releases of applications, including enhancements and defects.
• Looked for ways to incrementally improve the architecture of legacy systems.
• Managed workload to deliver quality deliverables that meet requirements and timelines.
• Assisted Manager in tracking progress, prioritizing work, developing time estimates and work plans and assisting less experienced team members. Environment: Oracle 11g SQL, Oracle Database 11g PL/SQL, TOAD 8.5, Tortoise SVN (Subversion), Lombardi Teamworks 6(Mapping Repository), Sybase Power Designer (Data Mapping), UNIX, PL/SQL developer 8.5.

Confidential, Conway, AR

PL/SQL Solutions Developer

Responsibilities:

• Migrated data from legacy systems - wrote PL/SQL codes i.e. Procedures, Functions, Packages & Triggers to extract, transform and load the data.
• Worked to create SQL (used complex SQL queries with the help of - joins, inner/ outer/ left inner, union, union all etc.). Used to support developers with complex SQL queries and query tuning.
• Worked in both RETAIL and FINANCIAL domain.
• Worked as single back end developer - was always able to meet timelines, deadlines and coordinate with Java developers and program and quality analysts.
• Performed as a key team player in one of the financial project named CCS (Coupon control system) Mainframe Migration Project. Participated in client meetings, was part of requirements gathering, did some design, design source to target documents, whole build from design and requirements, also was part of Testing and production support.
• Provide input to business solutions for clients and has the ability to understand the functional aspects quickly and get them done.
• Ability to quickly understand existing data model, legacy data migration scripts, batch interface scripts that were helpful to deliver for my work.
• Worked with product developers to assist in enhancement of product deliverables.
• Used to interact easily with the team and technically documented stuff that were helpful to produce documentation to validate system performance.
• Participated in design and analysis of Confidential systems and/or products. Create data mapping, had good understand of use cases.
• Identified data or processing issues and immediately provide appropriate notification for resolution.
• Collaborated with a multi-disciplinary team to design, build and test software to meet client needs.
• Followed a software development methodology.
• Used design best practices to create optimized SQL scripts, store procedures, shell scripts.
• Unit tested and debugged developed software.
• Has experience with processes where data came in and triggered data through a series of steps for batch processing.
• Wrote lot of batch processes using sql, pl/sql scripts for input files from inbound folders called through Unix shell scripts, for inbound processing and the load various Oracle tables.
• Was part of various Maintainance projects in Data Warehouse and Data mart.
• Part of conversion team to convert large terabytes of data from old system of a dedicated server to the other.
• Wrote various UNIX korn shell scripts to parse files and do other processing. Used inbuilt functions like grep, find, awk, sed etc.

Environment: Oracle 11g, PL/SQL Developer 8.0, PVCS, SQL Loader utility, Crontab automation, Linux etc.

Confidential, Houston, TX

PL/SQL Developer

Responsibilities:

• Performed as a key team player in Client/Server and Distributed Multi-tier Application Development, Data modeling: Conceptual, Logical and Physical design for both Relational and Dimensional schema also simulation and analysis.
• Worked on problem solving the evaluation of specifications for complex business requirements and maintaining new processes, developed and prepared solutions.
• Extensively worked with testing (test cases, test scripts), mainly Manual Testing which are also known to be test cases.
• Performed with data modeling, TOAD, code versioning and other SDLC tools.
• Wrote high performance queries/PL/SQL codes using Collections, Bulk Collects, Materialized Views (MV), Objects, Nested Tables, REF Cursors, and Indexing etc.
• Created nightly batch jobs, one time jobs and queues.
• Performed SQL tuning, Optimized SQL and tuning existing codes with the help of Explain plan, Trace utility & TKProf.
• Used features like cut, sed for UNIX shell scripting.
• Did Data modeling and have understanding of the physical data model concepts.
• Have SDLC Experience, Analysis, Requirement Gathering and experience in technical design documentation and work related to interacting directly with end clients, the QA team and the developers to enhance product deliverables.
• Engaged in production release preparation and post go live support for different systems.
• Documented all PL/SQL code, packages, procedures, functions and triggers to trace the system performance.
• Resolve daily support tickets including detailed data analysis and bug fixes to meet client requirements and provide apt solutions.
• Maintained different version of software (version control) using Confidential

Environment: Oracle 10g, Oracle Database 9i PL/SQL, TOAD 8.5, Confidential, AIX/UNIX.

Confidential, Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

• Designed and modified Database tables, keys, indexes, packages, functions and procedures etc.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Utilized data profiling, rules for data analyzing and cleansing.
• Created and deployed mappings, process flows to transfer data from legacy sources to staging area and from staging area to data warehouse using Oracle Warehouse Builder.
• Support Data warehouse, ETL Process.
• Developed Database Triggers for the integrity and security purpose.
• Used Oracle Job Scheduling and Maintain Batch jobs.
• Improved query performances by query optimization - tracing the query explain plan and Used TKPROF SQL scripts to monitor the performance.

Environment: Oracle Database 9i, TOAD, UNIX

Confidential

Oracle Programmer

Responsibilities:

• Creation of Database tables, keys, indexes, packages, functions and procedures etc.
• Improved query performances by query optimization - tracing the query explain plan and Used TKPROF SQL scripts to monitor the performance.
• Responsible for the analysis, design, development, also maintenance and support of software applications in UAT and Production.

Environment: Oracle Database 9i, TOAD, UNIX