Name: Madhuri Reddy

Email ID: acdpti@r.postjobfree.com

Cell: 516-***-**** (M)

Summary

• 5 years of experience in design, development, implementation, testing and documentation of business applications using (RDBMS) Oracle technologies.

Proficiency in Oracle PL/SQL (Oracle 11g/10g/9i/8i) and Forms/Reports (Oracle

Forms 10g/9i/6i)

• Expert in Client-Server application environment using (RDBMS) Oracle 11g/10g/9i/8i.

• Designed and developed business models and applications to meet specific requirements in the areas of performance, compliance, data warehousing, and manageability.

• Enhanced database performance and availability by compressing data onto low cost storage partitions.

• Tuned the performance of the applications using the workload capture and replay feature of the Oracle Real Application Testing and SQL performance analyzer by testing changes against real-life workloads.

• Used Oracle Data Miner to mine Oracle database to find valuable hidden information, patterns, and new insights about data.

• Designed database models to provide fast, reliable and scalable business applications.

• Successfully implemented requirement gathering, Gap Analysis, designing business blueprint, configuration, testing pre go-live, post go-live, and production support.

• Strong experience in Project management, database and System Administration, legacy to client server system integration, Data conversions and interfaces.

Expertise in Oracle Development Tools and Performance Tuning

• Proficient in writing PL/SQL scripts for the database objects like tables, views, cursors, procedures, functions, packages, database triggers, indexes, sequences and flashbacks.

• Designed and generated forms for data validation and processing in Oracle Forms 10g/9i/6i and also in generating reports in Oracle Reports 9i/10g.

• Expertise in migrating forms from 6i to 9i.

• Expertise in using advanced features of Oracle for PL/SQL programming like Varrays, Dynamic SQL, Query Optimizer, Nested Loops, External Tables, Nested Tables, LOBS.

• Improved performance of the queries and procedures using Hints.

• Experience working with Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB), Application Express (Apex 3.3), RAC, RMAN, DBLinks and also creating materialized views.

• Efficient in writing scripts using Autosys, Dbms_Jobs, Dbms_Profiler, Dbms_Stats, Dbms_Scheduler packages.

• Proficient in using Utl_File and other Oracle supplied packages like Dbms_Application_Info, Dbms_ddl, Dbms_Debug, Dbms_Odci, Dbms_Pipe, Dbmd_Profiler, Dbms_Random, Dbms_Reputil, Utl_Smtp and Utl_Tcp etc.

• Expertise in using PL/SQL Wrappers to protect the PL/SQL procedures or packages.

• Used PVCS, CVS, Subversion and Clear Case for revision control.

• Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency.

• Experience in developing multi-tiered systems using Html, Xml.

• Strong experience in Oracle development tools like SQL Developer, PL/SQL Developer, and using TOAD in secure database.

• Extensive knowledge in data migration using SQL* Loader.

• Experience in working with data transfer utilities like Data Pump, Export/Import.

• Experience in application and database fine-tuning using Explain Plan and TKProf.

• Experience in Relational and Dimensional Data Modeling, Physical and Logical Data modeling using tools like Oracle Designer, Microsoft Visio, and ERWIN.

• Improved the business processes and designs with the help of Normalization.

• Used Analyze, Indexes, and SQL Optimizer for fine-tuning the SQL and PL/SQL queries.

• Transferred data using SSH, FTP (File Transfer Protocol), SFTP (Smart FTP), Humming Bird, and having back-ups of the data using SCP (Secured Copy).

Experience in UNIX and Shell Scripting

• Used VI Editor and Cronjobs in UNIX environment for scheduling routine tasks.

• Expertise in creation, maintenance and modification of Shell scripts.

Expertise in BI, Testing and ETL Tools

• Experience in Building/Modifying reports using Business Objects and Oracle Reports.

• Knowledge in concepts of ETL and Oracle Warehouse Builder.

• Used ETL tools to extract the source data and load it into the target after applying the required transformation.

• Testing skills include performing regression, integration testing as well as development, execution.

Certifications

• Oracle PLSQL Developer Certified Associate (OCA).

• Microsoft Certified Professional in SQL Server 2005.

• Microsoft Certified Professional in .NET, Web Applications and Share Point.

• Brain bench certified in SQL (ANSI) and PLSQL Fundamentals.

• Brain bench certified in RDBMS concepts.

Technical Skills

Languages SQL, PL/SQL, Shell Programming, C/C++.

Databases Oracle 8.0, 8i, 9i, 10g, 11g, SQL Server, Sybase, Teradata, MS Access.

Tools ERWIN, Microsoft Visio, TOAD, SQL Navigator, Oracle SQL Developer,

PL/SQL Developer, Autosys, Crystal Reports, Oracle Forms 10g /9i /6i,

Oracle Reports 10g /9i /6i.

DB Utilities SQL Loader, Export / Import, Data pump, RMAN, TKPROF, Statspack.

Operating Systems SCO UNIX, Red hat LINUX, Sun Solaris, Windows, HP-UX.

Web Technologies HTML, XML, .NET.

Professional Experience

Client JP Morgan Chase, Garden City, NY

Duration July 2009 – Till Date

Environment Oracle (9i, 10g, 11g), UNIX, PL/SQL, TOAD 9.7,

Oracle Data Integration Suite, Informatica 8.5, Autosys.

Role Senior ORACLE PL/SQL Developer

Description:

JPMorgan Chase is the leader in investment banking, financial services for consumers, small business, commercial banking, financial transaction processing, asset management and private equity. I worked in Chase Auto Finance(CAF) division and was responsible for database development for CAF’s Dealer Credit Assist Tool using Oracle Retail Data Model. I developed the application from the scratch and used few advanced features in oracle 11g like Real Application Testing, OLAP, and Data Mining for a reliable and efficient design.

Responsibilities/ Deliverables:

• Implemented Oracle Data Model with Oracle OLAP and Oracle Data Mining models (Oracle 11g) to transform financial data into insightful, actionable information and implemented specific business requirements of Chase Auto Finance.

• Implemented Oracle Real Applications Clusters to provide the foundation of Very Large Multi-dimensional Databases (VLDM) which can provide large number of concurrent users with continuous access to information by lowering IT Costs and Complexity.

• Created OLAP cube materialized views to dramatically improve the performance of complex analytic queries accessing multi-dimensional data.

• Used Utl_Mail package to send a status email after the completion of the recon reports of the weekly and monthly nightly builds.

• Implemented Audit and Error Logging for the front-end applications of the dealer credit assist application, to help with production issues and better error handling.

• Expertise in using Oracle partitioning methods including interval, reference, list, and range in addition to composite partitions such as range-list.

• Improved the productivity of projects involving data transfer and and/or transformation like migration, installation of packages, construction of secured databases for the Internet, installation of datawarehouse and datamarts, and synchronization of heterogeneous applications using Oracle Data Integrator (ODI).

• Analyzed and improved the potential performance of the SQL Statements using Explain Plan and Tkprof.

• Expertise in Oracle Data Integration Suite (Oracle Data Integrator (ODI) and (OWB) Oracle Warehouse Builder) to Extract Load and Transform (E-LT) for high performance and faster responsiveness.

• Expertise in writing Autosys JILs and shell scripts for automation of batch jobs.

• Performed revision control of source code and handled branching, labeling, and versioning of directories using Subversion and IBM Rational ClearCase.

• Used ETL and OBIEE to effectively integrate heterogeneous data sources and converting raw data into useful information.

• Used DATAPUMP to export and import data between different databases.

• Responsible for efficient database build, testing and deployment of the application Dealer Credit Assist successfully for Chase Retail Lending.

Accomplishments:

• Enhanced the database performance and manageability by using new features of oracle like Oracle Warehouse Builder, and Oracle Data Mining.

• Used Oracle Spreadsheet Add-In feature of the Data Mining for Predictive Analytics to mine Oracle Database using Predict and Explain analytics features.

• Implemented Audit Logging for the dealer track application for efficient error handling.

• Reduced the query response time and enhanced database application retrieval speeds from minutes to seconds by efficient data modeling and fine-tuning of the queries.

Client Bank of America, Newark, DE

Duration Oct 2008 – June 2009

Environment Oracle (9i, 10g, 11g), Windows XP, UNIX, PL/SQL, TOAD 9.6,

Apex 3.3, Informatica 8.5, SQR, JDBC, Oracle Forms (9i, 10g)

and Reports (9i, 10g).

Role ORACLE PL/ SQL Developer

Description:

BOA is one of the leading financial services firm with one of the largest client franchises in the world. I worked in the Credit Card Services division and developed the efficient and innovative financial applications in various applications for modules like General Ledger, expense, Purchasing, iProcurement, Procure to Pay, Projects, and Discoverer etc.

Responsibilities/ Deliverables:

• Created the Application Design Document.

• Wrote stored procedures, functions, sequences, indexes, triggers.

• Expertise in using power center with Oracle Warehouse Builder.

• Created procedures for validating the already generated URL ticket number.

• Used the sys_guid () function to randomly generate a child ticket number and sys_context () function to obtain the session information.

• Used dbms_application_info package to record names of executing modules each time a user enters that module.

• Used JAVA APIs such as JDBC to provide connectivity between the Java and the oracle database and also used Ant to package up all of the components of the software into a deployable package.

• Performed analysis, design and development of the CAS Analytic Data Mart.

• Created Materialized View for extracting the data from remote database.

• Used the Oracle Active Data Guard to increase performance by enabling the use of fast incremental backups when offloading backups to a standby database, thus providing high availability and disaster protection against planned or unplanned outages at the production site.

• Used Oracle Data Integrator (ODI) to improve inter-application dialog by having interfaces executed asynchronously.

• Used PVCS for revision control of files.

• Performed data extraction and wrote data back to Oracle MDM applications with Data Watch and Repair option of Oracle Warehouse builder.

• Expertise in developing DCL scripts in banking applications and developing user interfaces using Oracle Forms 10g.

• Migrated forms from one server to another using the version control tool VSS (Microsoft Visual Source Safe).

• Created UNIX scripts in VI Editor for all the database objects and migrated those using RCS.

• Expertise in migrating from Oracle10g to 11g.

• Used Autosys for automated job scheduling and also to run export scripts.

• Used XML for Web Applications to automate Banking, Mortgage etc.

• Extensively used Cursors for manipulating the large amount of data and reducing the coding and error margin.

• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.

• Made use of DB LINKS for accessing data across different databases.

• Expertise in advanced features of Oracle 11g such as Application Express (Apex) to develop and deploy banking applications.

• Used SSH to exchange data between two networked devices and for loading data.

• Developed Oracle banking applications with VBA and .NET Framework 3.0.

• Tuned SQL Statements using EXPLAIN PLAN, SQL-TRACE and TKPROF.

• Involved with the QA team in performing Load Testing and Performance Testing.

Accomplishments:

• Developed the payment analysis application and Paper layout Oracle report for generating the overpayments of the students using the database tables and views.

• Profiled files, tables, and ERP systems without moving the data first using Oracle Warehouse builder and Informatica.

• Enhanced the performance of the procedures by creating suitable global and local indexes.

Customer Intel Corporation, Portland, OR

Duration Nov 2007 – Sep 2008

Environment Oracle 11g/10g, SQL Server 2005, Windows XP, SQR, SQL*Plus

, TOAD 9.1, Oracle Forms9i and Reports9i, HTML,

Oracle Financials 11i, Erwin 4.0

Role Oracle PLSQL & Forms Developer

Description:

Intel's leading-edge products are designed to deliver a great computing experience. I worked with Intel’s product development team and deeply engaged to help enhance the database productivity and application response time of a whole new wave of amazing multi-core applications. I worked on database and data warehouse support of the Accounts Payable, Budgeting, and Purchasing for the multi-core processor team.

Responsibilities/Deliverables:

• Proficient in writing SQL scripts, control files, PL/SQL functions, procedures and packages for customer interface.

• Created PL/SQL procedures, nested tables, external tables, LOBs, Varrays and Triggers necessary for validation of transaction records into interface tables.

• Used the crontab in UNIX, VI Editor and scheduler in Windows for automatic Tasks (Analyzing tables, Loading tables, Import/Export).

• Used Pragma Autonomous_transaction to avoid mutating problem in database triggers for Ecommerce Applications.

• Used Structured Query Reporter (SQR) for generating reports from Oracle 11g.

• Used the graphical user interface for designing ETL mappings using Informatica.

• Performed data profiling using Oracle Warehouse Builder for modules including Inventory, Property Manager and Order Management.

• Used Informatica tool to fetch data from source, transform and load it into the target databases.

• Used Java based build tool like Ant to configure the build, validate the source code and deploy the software to some standard location for distribution.

• Integrated non-Oracle source data into Oracle Financials through the Oracle APIs, interface tables, and direct table insertion.

• Knowledge of PL/SQL, Oracle RDBMS, UNIX, shell scripting.

• Developed a Windows Forms MDI application using Spring Framework 3.0 in Java.

• Worked with PVCS for version control and concurrency control.

• Used File Transfer Protocol (FTP) tool to transfer files from one server to other.

• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.

• Implemented Oracle Data Integrator and architected the ODI interface.

• Worked with Flashbacks to recover the data from recycle bin as well as to view the data as it was originally before committing any changes.

• Used Informatica for ETL (extract, transform and load), relational and dimensional modeling, data quality, data auditing, and full lifecycle management of data and metadata.

• Performed Workflow Automation and tracked bugs using Rational ClearQuest.

• Used the Explain Plan. Skilled at task performance evaluation and methods. Able to create and test different methods to achieve best possible speed.

• Involved in the design of database and developed E-R diagrams using Erwin.

• Developed UNIX shell scripts in VI Editor with embedded SQL*Loader, Expdp / Impdp calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application on Citrix Platform.

• Worked in creating Instead of Triggers for modifying the views that cannot be modified directly using the Update, Insert, Delete statements.

• Enforced constraints in order to make sure data validations.

• Identified SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS_PROFILER), explain plan, auto trace, TKPROF and tuned them to suit SLA.

• Worked with Autosys for Job Scheduling and job automation.

• Designed and generated Oracle Reports 9i with different options like Tabular, Group above, Group Left.

• Performed transformation and data loading using Informatica.

• Developed Forms as per the client requirements using Oracle Forms 9i.

Accomplishments:

• Developed user interactive high-end applications in environments requiring direct customer interaction during specifications, design and development and product implementation phases.

• Enhanced the performance of database and Later again involved in further Tuning, Performance, of queries and standardization of the code by using HINTS apart from the partitioning which is considered when no other performance tuning technique works.

Customer Sonata Software, India

Duration Feb 2005 – Jun 2006

Environment ORACLE 9i, PL/SQL, IIS 6.0 web Server, Forms 6i, Seagate

Perl, SQL Server, Apache Tomcat 4.1, COBOL, Java 4.

Role Internship as Oracle PLSQL Developer

Description:

Sonata Software is a global management consulting, technology services and outsourcing company. Combining unparalleled experience, comprehensive capabilities across all industries and business functions, and extensive research on the world’s most successful companies, Sonata Software collaborates with clients to help them become high-performance businesses and governments.

Responsibilities/Deliverables

• Analyzed requirements, designed, developed, deployed and documented software components.

• Worked in Web development using HTML, Spring Framework, JavaScript, IIS web server and other Web technologies.

• Designed logical and physical data models of database using Erwin.

• Developed code using PL/SQL packages and procedures.

• Used SQL*Loader to load flat files and created log tables containing data with discrepancies.

• Generated reports using crystal reports as per business requirement.

• Developed Forms as per the requirements using Forms 9i

• Conducted QA reviews, published and Reviewed code to the Production servers.

• Assisted in content migration activities as necessary.

• Optimized job performance by tuning of the SQL using various Oracle tools including EXPLAIN PLAN, SQL TRACE/TKPROF and the PL/SQL application code.

• Used VBA, VC++ to develop libraries and CLR code and leverage an existing extended stored procedure.

• Used to test the code developed by the java developers using Tomcat server.

• Worked on tables in various databases using Database links.

Accomplishments:

• Worked closely with other software engineers, QA and Support groups as well as Retail Business and Operations groups to develop top quality products that solve actual business and technology problems.

• Analyzed Server performance and handled issues to enhance the performance of Web servers.

Education:

Master of Science from University of Tennessee, Knoxville.

Major: Computer Science Engineering

Bachelor of Science from Osmania University, India.

Major: Computer Science Engineering

Contact this candidate