SUMMARY:

• Information Technology Professional with 10 years of experience in Application development and Production support using Oracle SQL, PL/SQL and Crystal reports.
• Good Experience in Software Development Life Cycle (SDLC) including analysis, logical design, Resource Planning, code development, testing, implanting and maintenance.
• Subject Matter Expert in Oracle PL/SQL, Crystal Reports.
• Strong Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Expert in backend programming using PL/SQL and SQL.
• Strong Experience writing interfaces, triggers, stored procedures and PL/SQL packages to provide database access and manipulate functionality.
• Expert in Creating PL/SQL procedures, packages, functions, database triggers and other database objects like Lob’s to generate back-end and front-end reports.
• Experience in Application Development using Crystal Reports and Discoverer.
• Expert in Oracle Application Server 10g administration and installation.
• Extensive experience in design and modeling database-using Designer/2000, Erwin.
• Extensive experience in Relational Data Base Management Systems (RDBMS).
• Strong experience in Oracle Workflows.
• Extensive experience on Designer-2000.
• Basic DBA activities like creating of databases, users and table spaces and Logical export and Import. SQL loader, DB links, Materialized view creation, index creation and fine-tune queries.
• Experience in Oracle Financial like AR, AP module.
• Experience in Preparing of Checklists, identification of Test Cases, preparing Test Plans according to IEEE standards.
• Knowledge in PRO*C.
• Experience in SQR and Hyperion Reporting.
• Through understanding in data warehousing concepts.
• Designed and developed various applications using oracle products/tools for process of automations software into database server using UNIX shell scripts, Perl shell scripts PL/SQL packages, procedures and database triggers based on client/server and multi-tier technologies.
• Experience in using SQL *Loader and External Tables for Export/Import of data.
• Experience using TOAD, SQL Navigator under UNIX and Windows NT/2000/XP/Vista, Sun Solaris operating systems.
• Minimal experience and vast knowledge on Eagle pace data model.
• Experience in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
• Knowledge in DBA activities like creating of databases, users and table spaces, partitions, Indexes, constraints and permissions.
• Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE etc.
• Extensive use of TOAD for extracting scripts from the dictionary.
• Knowledge in Aster Data.
• Extensively worked on Onsite-Offshore models. Participated in Requirements gathering onsite and transferred the knowledge to offshore.
• Use of Sequences to automate number generation.
• Knowledge of Partitioned Tables & Indexes, creating Object types, LOBs.
• Database design, E-R diagrams, Logical, Physical layout design using Erwin.
• Schedule jobs via oracle jobs.
• Use of LOVs, RG, Alerts, Object groups and other important features of Oracle Forms.
• Knowledge in rapid sql, ER studio.
• Knowledge in structured programming languages like VBS, SAS.
• Strong experience in working with multiple projects in high pressure environment.
• Excellent verbal and written communication and presentation skills and Strong interpersonal skills, ability to interact with people at all levels.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL,T-SQL C, C++, Cognos, JAVA, Pro*C, HTML,.net XML.
Databases: Oracle 6i/8i/9i/10g, SQL Server 2000, MS Access, RDBMS.
Utilities: TOAD, SQL Navigator, SQL* PLUS, SQL*Loader.
Operating Systems: Windows 95/98, Windows 2000/XP/ NT, UNIX, Sun Solaris, AIX
Tools: MS-Office 2000, MS-Excel, Outlook, IIS6.0, Visio, Designer 2000, Erwin, Crystal reports XI, ORACLE APEX.
GUI\'s: Developer2000, Portal.
Casetools:Designer2000
Data Modelling:Erwin 4.0/3.5,Eagle Pace, Snow flake.

Certifications: TS: Microsoft® SQL Server™ 2005 - Implementation and
Maintenance.
Brain Bench Oracle Pl/SQL developer Advanced level Certification (Oracle 10g)

PROFESSIONAL EXPERIENCE:

Confidential,CA Jul 2012 – Till Date
Project Lead
Wells Fargo & Company is a diversified financial services company providing banking, insurance, investments, mortgage, and consumer and commercial finance through more than 9,000 stores and 12,198 ATMs and the Internet (wellsfargo.com) across North America and internationally.
Headquartered in San Francisco, but decentralized so every local Wells Fargo store is a headquarters for satisfying all the customers’ financial needs and helping them succeed financially. One in three households in America does business with Wells Fargo. Wells Fargo has $1.3 trillion in assets and more than 270,000 team members across 80+ businesses.
Responsibilities:

• Contributed my efforts in preparing the Business Requirements Document along with the business analyst and various other teams involved in this project.
• Analyzed the business requirements document and wrote the Functional System design document (FSD) and gathered sign off on the same.
• Wrote the System Interface Agreement Inbound and outbound document and acquired sign off on the same.
• Wrote the complete Project Plan according to the business requirements and given timeline and acquired sign off on the same.
• Contributed in the setup of Network Data Mover (NDM) from source server to destination server.
• Wrote an NDM script which copies the files from production to back up server when the files are received.
• Worked on the existing Oracle framework tables to make changes according to the business requirements.
• Created database objects like tables, views, procedures, packages using Oracle Utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Created Autosys jobs for the automation of this process.
• Built physical data structures like tables, views, constraints & Indexes.
• Documented design specifications and architecture using Microsoft Visio, Microsoft outlook, Microsoft Excel.
• Experience in data extraction from heterogeneous sources using Informatica power center.
• Did performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions for optimal query performance.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans
• Involved in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
• Worked on SQL *Loader and External Tables for Export/Import of data.
• Wrote cursors and control structures using PL/SQL.
• Worked on UNIX environment and wrote UNIX and PERL shell scripts as per the requirement.
• Ensured conformance to code standards and documentation requirements.
• Monitored indexes and analyzed their status for performance tuning and query optimization.

Environment: PL/SQL, SQL, SQL LOADER, Toad, Oracle database 10g, Oracle Application Server 10g; Oracle portal 10.1.2, Unix and Windows OS, Informatica version 3.

Confidential,CA Apr 2012 – Jul 2012
Senior PL/SQL Developer

Autodesk, Inc., is a leader in 3D design, engineering and entertainment software. Customers across the manufacturing, architecture, building, construction, and media and entertainment industries—including the last 16 Academy Award winners for Best Visual Effects—use Autodesk software to design, visualize, and simulate their ideas before they\'re ever built or created. From blockbuster visual effects and buildings that create their own energy to electric cars and the batteries that power them, the work of our 3D software customers is everywhere.

Responsibilities:

• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Data Quality Monitoring:
• Extensively did Quality test plans and reviewed the Quality System Test Plan & Test cases.
• Involved in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
• Extensively used INDEXES AND OPTIMIZER HINTS for better performance of queries.
• Involved in creating database objects like tables, views, materialized views procedures, functions and packages using Oracle Utilities like PL/SQL, SQL* Plus and Handled Exceptions
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Used Dynamic SQL for creating tables with partitions dynamically and for inserting data into the tables.
• Used DBMS job scheduler to schedule PL/SQL packages and procedures.
• Involved in Code Reviews and preparing unit test cases.
• Wrote cursors and control structures using PL/SQL.

Environment: PL/SQL, SQL, TIBCO, Oracle database 11g, Unix and Windows.

Confidential,MI Aug 2011 – Mar 2012 Date
Senior PL/SQL Developer

Aspen Marketing Services is a leading global marketing services agency with offices and resources throughout the world. A division of Epsilon, Aspen builds long-term relationships with clients, many of which are in the Fortune 100. Clients benefit from Aspen’s comprehensive portfolio of in-house marketing capabilities, including direct marketing, digital marketing, experiential and event marketing, online and offline word of mouth, Hispanic marketing and advanced analytics.
Responsibilities:

• Created database objects like tables, views, procedures, packages using Oracle Utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Designed and developed crystal reports as per the clients requirement in Oracle 10g.
• Designed Oracle workflows for automation of business processes.
• Built physical data structures like tables, views, constraints & Indexes.
• Documented design specifications and architecture using Microsoft Visio, Microsoft outlook, Microsoft Excel.
• Configured crystal reports with internet information services (ISS).
• Involved in Complex table joins as per the requirement.
• Involved in Code Reviews and preparing unit test cases.
• Did performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions for optimal query performance.
• Exclusively developed Oracle Reports like crystal reports with extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors, REF Cursors and loops.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans
• Prepared Function Requirement Documents and documented the process events and best practices.
• Involved in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
• Worked on SQL *Loader and External Tables for Export/Import of data.
• Carried out extensive data validation with client’s data specialist validating complex SQL queries.
• Wrote cursors and control structures using PL/SQL.
• Exclusively worked on UNIX environment and rewrote complex UNIX shell scripts as per the requirement.
• Ran Cron jobs for loading database tables from Flat Files using SQL*Loader and also to schedule PL/SQL stored procedures.
• Ran batch jobs for National Change of Address Standardization (NCOA) process.
• Wrote batch files to convert the flat files from Microsoft Excel to CSV comma delimited format.
• Used DBMS job scheduler to schedule PL/SQL packages and procedures.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Developed complex reports ,dashboard reports and annual chart reports as per user requirement and sales managers
• Developed Reports using crystal reports XI to displayed sales margins for daily, weekly, monthly, and quarterly totals along with detailed inventory information.

Environment: PL/SQL, SQL, SQL LOADER, Oracle database 10g; Crystal Reports 11.5, Oracle portal 10.1.2, Unix and Windows.

Confidential,NY Jan 2009 – Aug 2011
Senior PL/SQL Developer

The Depository Trust & Clearing Corporation is the largest financial services post-trade infrastructure in the world, with operating facilities in multiple locations in the U.S. and overseas. DTCC is the holding company for six subsidiary businesses -- a depository and five clearing corporations -- as well as the global joint venture with Thomson Financial (called Omgeo). Through its subsidiaries, DTCC provides clearance, settlement and information services for virtually all equity, corporate debt, municipal debt, government securities, mortgage-backed securities
Responsibilities:

• Provided 24X7 support for Oracle Developer activities for North American countries by working with offshore and on shore teams.
• Installed and configured Oracle 10g right from the scratch by working closely with DBA and configured to various tools as per the requirement.
• Created database objects like tables, views, procedures, packages using Oracle Utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Designed and developed crystal reports as per the clients requirement in Oracle 6i, 9i and 10g.
• Implemented RDBMS concepts in Data modeling.
• Corrected & modified existing application according to user requirements.
• Supported Oracle Financials module team.
• Used Oracle Financial Module to improve productivity by accessing multiple data sources at the same time.
• Did high level Coding and GUI Standards, Implementing java classes in PL/SQL procedures.
• Designed Oracle workflows for automation of business processes.
• Implemented Designer2000 exclusively for SDLC process and Dataflow Diagrams.
• Built physical data structures like tables, views, constraints & Indexes.
• Implemented sync sort for the backup purpose of large volumes of data.
• Worked on Proc Pre complier to recognize the SQL statements embedded in program.
• Involved in migration of DB from 7i to 10g.
• Involved in ETL Transformations using OWB tool.
• Documented design specifications and architecture using Microsoft Visio, Microsoft outlook, Microsoft Excel.
• Configured crystal reports with internet information services (ISS).
• Experience in data extraction from heterogeneous sources using Informatica power center.
• Did performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions for optimal query performance.
• Did high level coding using T-SQL for complex joins.
• Exclusively developed crystal reports with extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors, REF Cursors and loops.
• Preparation of Checklists, identification of Test Cases, preparing Test Plans
• Involved in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
• Involved in Database Designing with ERWIN as design tool.
• Worked on SQL *Loader and External Tables for Export/Import of data.
• Carried out extensive data validation with client’s data specialist validating complex SQL queries.
• Worked exclusively with visual SourceSafe VSS 2005 for source control system.
• Wrote cursors and control structures using PL/SQL.
• Built Triggers to log the information about users and the operations they perform in their session. Developed procedures to load data from staging tables to target tables.
• Worked on UNIX environment and wrote UNIX and PERL shell scripts as per the requirement.
• Ensured conformance to code standards and documentation requirements.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Developed complex reports ,dashboard reports and annual chart reports as per user requirement and sales managers
• Developed Reports using crystal reports XI to displayed sales margins for daily, weekly, monthly, and quarterly totals along with detailed inventory information.

Environment: PL/SQL, SQL, Pro*C,SQL LOADER, Toad,java,Oracle APEX,T-sql Oracle database 10g; Crystal Reports X, Oracle Application Server 10g; Oracle portal 10.1.2, Oracle Discoverer, Oracle Applications: Purchasing and WMS modules, Sun Solaris OS, Linux and Windows.

Confidential,CA
Sr. Oracle Developer Feb\'07 – Jan’09

Description: Panasonic is one of the world\'s leading producers of electronic and electric products for consumer, business and industrial use. The company is a leader in the development of DVD technologies and played a major role in establishing DVD as a fast-growing medium for consumer entertainment content.

Responsibilities:

• Provided 24X7 support for various Oracle Developer related issues in Development, Staging and Production environment.
• Maintained SLA of 99% and resolved the high priority issues with in time related to Oracle.
• Worked on the project from scratch on feasibility, analysis, development, testing and implementation.
• Installed and configured Oracle 10g DB and its components successfully by working closely with DBA in DEV and PROD and migrated the old 7i environment to 10g.
• Installed and configured Oracle Portal for development, testing and production instance.
• Created virtual library for source code and converted different types of source code format as per the requirement.
• Extensively used Application Express a tool to build web-based applications.
• Setup and administration of Oracle portal users and groups.
• Analyzed, designed, optimized and tuned PL/SQL Procedures, Oracle Stored Procedures and used SQL*Loader to load the Historical data into the data warehouse
• Worked on crystal reports and provided the reports on time to the client as per the requirement.
• Worked on Proc Precompiled to recognize the SQL statements embedded in program.
• Implemented RDBMS concepts in Data modeling.
• Documented design specifications and architecture using Microsoft Visio, outlook, express.
• Designed various packages to send automatic email from database to alert users about the status of orders.
• Developed Reports using crystal reports to displayed sales margins for daily, weekly, monthly, and quarterly totals along with detailed inventory information.
• Integrated Oracle Discoverer port let provider to Oracle Portal.
• Publishing Discoverer port lets in Oracle AS Portal
• Designed templates, pages and custom login page for users.
• Worked on setting up application level access privileges to users in Oracle AS Portal.
• Worked on UNIX environment and also on Windows environment exclusively.

Environment: PL/SQL, SQL, Pro*C,SQL LOADER, Toad, Oracle database 10g; Oracle Application Server 10g; Oracle portal 10.1.2, Oracle Discoverer, Oracle Applications: Purchasing and WMS modules, Sun Solaris OS, Linux and Windows.

Confidential,IL Aug\'05 – Feb’07
Sr. Oracle Developer

Description: Worked as an Oracle PLSQL Developer for banking data warehouse. The System involved multiple sources and platforms including Oracle, MS-SQL and flat files. In first Phase, through a formal prioritization method, identified key analytical subject areas and documented the requirements. In the second phase, development and testing of the data warehouse had been done.

Responsibilities:

• Acted as a SME of Oracle 9i exclusively and resolved complex issues by providing support to other developers.
• Worked in a high pressure environment with deadlines and was able to deliver the reports successfully on time.
• Installed and configured the Oracle 9i DB by working with DBA team and migrated the environment from 6i to 9i.
• Resolved complex issues when migrating and deploying the environment.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Used SQL*Loader to load the Historical data into the data warehouse.
• Wrote cursors and control structures using PL/SQL.
• Worked exclusively with visual SourceSafe VSS(5.0) for source control system.
• Created virtual library for source code and converted different types of source code format as per the requirement
• Built Triggers to log the information about users and the operations they perform in their session. Developed procedures to load data from staging tables to target tables.
• Documented design specifications and architecture using Microsoft visio.
• Involved in Code Reviews and preparing unit test cases
• Extensively worked on performance tuning of the load process using Explain Plan.
• Worked in design and documentation of data warehouse dimensional upgrades.
• Involved in preparing documents, fixing bugs, and improving the performance by working with development and testing team.
• Developed many UNIX shell scripts as per the requirement.
• Performed testing of various packages, functions and procedures to check the functionality and to develop Test cases.
• Responsible for performing code reviews.
• Developed user documentation for all the application modules.

Environment: Oracle 6i/9i, SQL, PL/SQL, UNIX Shell Scripts, C/C++, HP-Unix 10.0, TOAD, Oracle Discoverer, Erwin 4.0, WinNT.