PROFESSIONAL SUMMARY:

• Have 8+ years of experience as a System Analyst, Oracle PL/SQL developer with design, development, testing of business applications, d Confidential analysis on OLTP, OLAP, Enterprise, web based, Client/Server architectures.
• Deep understanding of Software Development Life Cycle (SDLC) and implemented various models like Waterfall model, Agile model.
• Experience in using Oracle Import/Export utilities, Oracle SQL* Loader, SQL Developer, SQL*Plus, TOAD, PL/SQL Developer, ETL Process and D Confidential Migration.
• Expertise in creating stored procedures, functions, packages, Triggers, collections and bulk collections using PL/SQL.
• Assisted DBA in performing various DDL works like Creation of Schemas, tables, Indexes, Materialized Views, and Partitioning tables.
• Involved, supported in designing ER diagrams, Logical and Physical D Confidential Models, Use Case/Class/Sequence diagrams using tools like MS Visio, Power Designer and ERWIN.
• Experience in implementation, customization and migration of Oracle 10g, 6i Forms, Reports, Workflow, Conversion and Interface.
• Proficient in Technical and Business Writing (Business Requirement Documents, Technical Functionality Documents), Business Process Flow, Process Diagram, Business Process Modeling, Business Analysis and Testing in various methodologies.
• Interacted with Clients, Project Managers to gather the Business Requirements and developed the technical specification document.
• Experience with d Confidential management standards and understanding of D Confidential Governance framework and processes.
• Have knowledge in D Confidential Mining, D Confidential, D Confidential mapping, ETL, and reporting process.
• Good experience in performing a Tester role when required - Created Test plans, Test scripts, test cases using Hp ALM. Experience in Smoke test, Functional testing, regression testing. Interacted with the Business and Management to get approvals on the testing process and provided the test results.
• Involved in Unit testing with the Business and walk through the functionality of the new changes.
• Experience in creating packages in COGNOS framework manager and reports using COGNOS report studio
• Build reports using Tableau software and publish reports to Tableau Server.
• Good knowledge on Control-M, Maestro to monitor the batch jobs and involved in on call production Support
• Experience in writing UNIX shell scripts and control scripts to schedule batch jobs, load d Confidential using sql plus, have experience using cronjobs.
• Maintained version controls using Clear case, SVN Tortoise tools

TECHNICAL SKILLS

D Confidential bases: Oracle 9i/10g/11g, Oracle 10g, 6i Forms and Reports

Oracle Software: TOAD, SQL*PLUS, SQL Developer, Oracle 9i/10g/11g, Forms, Reports, SQL*Loader

Other Software’s: MS Visio, MS Project, MS Office

Scripting: HTML, XML, Shell Scripting

Languages: SQL, PL/SQL, Java, C, C++, Pro *C

Other Tools: COGNOS, Tableau, HP ALM, Win SCP, Eclipse, Putty, Clear Case, Tortoise SVN, Control-M

Operating systems: Windows XP/NT/98, Unix

Methodologies: SDLC, Agile, Iterative and incremental, Adhoc, Kanban

PROFESSIONAL EXPERIENCE:

Confidential

Analyst/Oracle Developer

Responsibilities:

• As a member of ROM Support Team, I was responsible for maintaining oracle d Confidential base
• Successfully manipulated Stored Procedures, Functions, Triggers and Packages using
• Daily d Confidential load monitoring and wrote queries/programs using collections, bulk binds, ref
• Implemented Exception handling, Autonomous Transactions, Pragma Exception Init, Locks,
• Created complex spreadsheets in MSExcelusing advanced formulas (V-lookups, IF statements; pivot tables; macros).
• Create and Monitor jobs in Control-M
• Intermediate level of experience in writing UNIX shell scripts
• Worked on D Confidential Analysis and provided reports on the trades, sales, enrollments
• Providing system analysis, design, development, implementation and prod support of
• Writing programs, ad hoc queries, and reports as required to provideproduction support
• Elevating code into the development, test, and production environments on schedule;
• Designed and created prototypes of reporting tools for d Confidential validation and verification initiatives using macros in MS Excel.
• Learning client business functions and technology needs; learning Client tools, technologies,
• Learning and complying with IT policies and procedures, especially those for quality andproductivity standards that enable the team to meet established milestones; learning and complying with all Information Security policies and procedures.
• Participating in special projects and performing other duties as assigned and worked in Kanban

Environment: Oracle 11g, SQL, PL/SQL, SQL*PLUS, TOAD, SQL Developer, C, Pro*C, SQL*Loader, UNIX, Tortoise SVN, Slick Edit, Control-M, Putty, MS Office, HP ALM, Confidential Lotus Notes, Kanban

Confidential, New York

Pl/Sql Developer

Responsibilities:

• As a developer responsible for analysis, requirements gathering, documentation of functional/technical specifications, development, testing, and production support.
• Depending on the functionality, created different d Confidential base objects like Tables, Constraints, Procedures, Functions and Packages.
• Involved in the design, development, debugging, testing, documentation, maintenance and supporting the Privacy application.
• Writing high quality and well documented code according to standards.
• Resolved many of the existing and new bugs in the whole application and added new functionalities to the application.
• Developed complex SQL queries using Joins, nested queries, Set operators, in line Views, Analytical functions, Regular expression, in built Packages, Functions and clauses.
• Involved in the d Confidential migration to publish the Accounts in Operations processing platform systems.
• Developed customized application using Oracle Forms and Reports
• Created inbound, outbound interfaces and Conversions for core modules of oracle Application
• Created Indexes on Tables, columns to minimize query time and for better performance.
• Preparing documentation for requirements, design, install and Unit testing.
• Analyzed and rectified bugs reported during System Testing and User Acceptance Testing and postproduction support.

Environment: SQL, PL/SQL, Oracle 11g, SQL* plus, TOAD, Windows 2007, MS Office, UNIX, Putty, HP ALM/Quality Center, Cognos

Confidential, New Jersey

Pl/Sql Developer

Responsibilities:

• As an Oracle developer responsible for analysis, requirements gathering, d Confidential mapping, development and testing.
• Created several d Confidential base objects like Tables, Views, Triggers, Packages, Procedures and functions.
• Used complex SQL queries to accomplish the functionality of the project.
• Extensively used Materialized views and DB links for remote instances to retrieve d Confidential from other d Confidential bases.
• Developed the PL/SQL applications using advanced features like Native dynamic SQL (NDS), Bulk collect and INDEX BY TABLES.
• Modified and debugged several SQL queries and PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and HINTS.
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and for better performance.
• Created Shell script to load d Confidential from the flat files into d Confidential base tables.
• Created and enhanced various reports using SSRS.
• Designed and developed SSIS packages. Created SQL Reports using SQL Server 2008/2005
• Performed unit testing and regression testing of the application.

Environment: s: Server 2008, SSIS, SSRS, PL/SQL, Oracle 11g/10g, SQL* plus, TOAD, Windows 2007, Windows server 2003, MS Office, UNIX Shell Scripting, Linux, and Solaris.

Confidential

Pl/Sql Developer

Responsibilities:

• Developed complex applications usingPL/SQL,OracleForms and Reports to suit business needs
• Responsible for creating stored procedures, packages, functions and triggers.
• GeneratedPL/SQLpackages with dynamic SQL queries as per the requirements.
• Successfully created various D Confidential base Objects such as tables,views, materialized views, Indexes, sequences.
• Performed D Confidential base Application Level Tuning and Coordinated directly with the end users to understand the Business Requirements and convert them into functional and technical specifications.
• Proved to be a responsible resource to handle performance tuning of SQL queries andPL/SQLstored procedures using Indexes and optimizing hints.
• Drew ER - diagram and workflow chart - UML for documentation.
• Created templates and generated Oracle reports for Business

Environment: Oracle 10g, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, Oracle SQL Developer, SQL*Plus, SQL*Loader, TOAD.