SUMMARY

• 8 years of IT experience in full Software Development Life Cycle (SDLC) specializing in the areas of business requirement analysis, design and implementation of Oracle PL/SQL/Apex.
• Also have strong technical, logical, people managing and multi - tasking skills.
• Self-motivated to produce results.
• 8 years of total experience in IT.
• 7 Pl/Sql Programming for application development and back-end development using Stored Procedure, Cursor, Functions and Triggers and Dynamic SQL using PL/SQL with advanced PL/SQL techniques such as REF Cursor, Collections and Bulk Operations.
• 6 years’ experience in Oracle Apex for web application, work-flow applications and interactive reports.
• Worked in Manufacturing Domain.
• 1 Years of experience in Business Objects xi R3 Webi and Universe designer.
• 0.7 years of experience in Macromedia Flash 8, Java, XML.
• Good exposure on UNIX, Shell Scripting, Batch Programs.
• Fair exposure on different segments of the data warehousing life-cycle that includes business requirements gathering & analyzing, data modeling ETL and business reporting.
• Expertise on Toad and Appworx.
• Involved in Oracle Administration work, Upgrades.
• Experience with Databases Oracle (9i, 11g).
• Involved in DB upgrade from 9i to 11g.
• Experience in UNIX, SQL and Appworx.
• Strong exposure to Clear Case, Clear Quest and Jira.
• Expertise in Data Modeling, PL/SQL AND Visio.
• Proven expertise of dealing with people across diverse teams comprising of various skill sets.
• Good Team Management skills with experience in handling teams with 8+ members having worked in both offshore and Onsite locations.
• Interaction with clients & business as part of Onsite Coordinator Role.
• Involved in Query Optimization, Improving Performance of the queries, Re-designing the query flow.
• Involved in Project Estimates, creating Statement of Work.
• Proficient with the Software Development Cycle and have developed the Design Documents, Requirement Traceability Matrix, etc.
• Excellent commitment, dedication and planning towards goal oriented tasks and problem-solving skills with good interpersonal and communication skills.
• Excellent communication and interpersonal skills, quick learner, self-motivated, ability to work individually and as well as in a team environment with good team spirit.

TECHNICAL SKILLS

Reporting: Apex, Business Objects, Crystal Report

Dashboard Tools: Xcelsius(Trained)

Databases: Oracle 9i, 11g, MySql

Tools: Toad for Oracle, SQL Developer, BO Web-I, Desk-I, Universe Developers

Operating Systems: Windows XP, 7

Others: Unix Shell Scripting

Office Application: MS-Vision, PPT, Excel, Word, Project 2003, 2010 and 2013

Testing Tools: Junit, Load runner

PROFESSIONAL EXPERIENCE

Confidential, Plano-TX

Sr.PL/SQL Developer

Responsibilities:

• Working as a developer and Onsite coordinator.
• Responsible for assigning and explaining tickets to India team.
• Working on tickets to add new database changes as requested.
• Writing pl/sql procedure/packages/functions to put the processed data into final tables.
• Monitoring jobs and recovering if it gets abended.
• Involved in production support by efficiently debugging the production issues.
• Created Views, Dynamic SQLs.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Involved in Extraction and loading of data in between the schemas using oracle Export and Import utilities.
• Created scripts to load the data into staging tables from other database using DB links.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Created reusable procedure code to gather incremental stats of tables after data gets loaded.
• Created reusable procedure to handle work table creation and populate partitioned tables using exchange partition for partitioned tables.
• Responsible for maintaining data-replication process using shareplex.

Environment: Oracle Pl/Sql 11g, Unix, Toad 10.6, Windows 7, Putty, Control-M, Shareplex

Confidential, Richardson-TX

Responsibilities:

• Working as a developer and Onsite coordinator.
• Responsible for gathering requirements and send it across to team.
• Responsible for creating requirement document and test documents.
• Responsible for documenting application changes for transitioning it to support.
• Writing pl/sql procedure/packages/functions to put the processed data into final tables.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Creating unix jobs to run the loaders procedures.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Responsible for testing the application thoroughly with new changes.
• Responsible for keeping track of project using project planner.

Environment: Oracle Pl/Sql 11g, JAVA-Struts, Unix, Toad 10.6, Windows-7, MS-Office word, Excel, PPT, Project Planner.

Confidential, Melville, NY

Responsibilities:

• Added Confidential authorization schema removing the custom authorization schema previously used.
• Created DB jobs for auto email notification to managers of workflow, project and applications whenever there is any update.
• Added additional role based security features using Ajax call.
• Used JavaScript to call application level program.
• Added URL encryption to protect it from tampering.
• Updated security of the application with JavaScript, Ajax call to procedure.
• Working as a developer and Onsite co-ordinator.
• Responsible for testing the application thoroughly with new changes.
• Responsible for creating requirement documents and test cases.
• Responsible for transitioning it to support.
• Responsible for updating Project Planner to keep track of the project.
• Worked on Bulk Collection and Pl/sql table for getting optimal performance.
• Created Views, Dynamic SQLs, V-arrays.

Environment: Oracle Apex 4.2, Oracle 11g, JavaScript, CSS 3.0, HTML 5, Toad 10.6, Windows-7, MS-Office word, Excel, PPT.

Confidential, Melville, NY

Responsibilities:

• Designed database for this application and created er diagram using visio.
• Responsible for writing packages, procedures and functions needed for this application.
• Created the application with latest Confidential UX framework and Hashing technology to encrypt user data.
• Added user level security structure using Ajax for client side.
• Used css3 and html5 for using the UX framework and creating a custom theme.
• Developed the application from scratch along with the user, as per their requirement.
• Responsible for adding the entire role related security.
• Was the only resource working on this application and completed the whole project within a month going through all the phases.
• Responsible for unit testing.
• Co-ordinated with client for this application.
• Responsible for creating application documents.
• Responsible for transitioning it to support team.

Environment: Oracle Apex 4.2, Oracle 11g, JavaScript, CSS 3.0, HTML 5, Toad 10.6, Windows-7, MS-Office word, Excel, PPT.

Confidential, Melville, NY

Responsibilities:

• Designed database for this application and created er diagram using visio.
• Responsible for writing packages, procedures and functions needed for this application.
• Created the application as per user requirement.
• Created project, application and work-flow report pages with forms.
• Added custom authorization scheme for the application.
• My responsibility was to gather requirements.
• Responsible for custom authorization scheme.
• Worked as a senior developer.
• Responsible for testing the application thoroughly.
• Writing pl/sql procedure/packages/functions to put the processed data into final tables.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Co-ordinated with client for this application.
• Responsible for creating application documents.
• Responsible for transitioning it to support team.

Environment: Oracle Apex 4.2, Oracle 11g, JavaScript, CSS, HTML, Toad 10.6, Windows-7, MS-Office word, Excel, PPT.

Confidential, Melville, NY

Responsibilities:

• Worked with DB team for upgrading database from oracle 9i to 11g.
• Did Impact testing for DB up-gradation
• Wrote procedures for automating pricing of parts, by taking quote details, tax details, shipping details from other clusters of Confidential database through DB link.
• Created MV for getting data through DB link and use it for pricing calculation.
• Wrote function to notify pricing related managers through email, when there is a change in pricing or new pricing is done for a part.
• My responsibility was to lead the project.
• Responsible for testing the impact of DB up-gradation.
• Responsible for writing the procedures to automate the pricing processes.
• Responsible for creating new batch jobs to update related managers regarding pricing changes by automated emails.
• Responsible for through testing of application and impacts due to new changes.
• Responsible for Infant care support and post production support.

Environment: JAVA Struts 1, Oracle 9i pl/sql, Oracle 11g pl/sql, UNIX, Appworx, Windows-7, MS-Office word, Excel, PPT.

Confidential, Melville, NY

Responsibilities:

• Used bootstrap framework 2.3.2 to create responsive design prototype.
• Used bootstrap framework 3 to create a responsive design sample page to be used as template for all the web-based applications.
• Worked with design team to have different size of logo, header text, footer text search bar and tabs for different device length.
• As per framework divided all the devices into four structure, Large (≥1200px), Medium (≥992px), Small (≥768px) and Extra Small (<768px).
• My responsibility was to design and add responsive features using twitter bootstrap.
• Responsible for header, footer and table body design.
• Responsible for testing the design for all devices, i.e. mobile, tablets and desktops.
• Learnt bootstrap 2.3.2 and 3.
• Did knowledge transfer for this application.

Environment: Html 5, css3, Twitter Bootstrap, JQuery, Windows-7, MS-Office word, Excel, PPT.

Confidential, Melville, NY

Responsibilities:

• Identified a new primary key and added it to the supplier table of this application.
• Identified all the impacted tables, screens and packages. Made changes to all tables and packages.
• Implemented latest UX framework.
• I took responsibility of leading the team in the second week of build phase, as team lead left the project.
• Responsible for making changes in the database, packages, procedures.
• Responsible for creating UNIX scripts for Appworx job to automate finance related process.
• Responsible for doing unit testing of DB changes and backend jobs.
• Writing pl/sql procedure/packages/functions to put the processed data into final tables.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Co-ordinated with client for this application.
• Responsible for creating application documents.
• Responsible for transitioning it to support team.

Environment: JAVA Struts 1, Oracle 9i pl/sql, UNIX and Appworx, Windows-7, MS-Office word, Excel, PPT.

Confidential, Melville, NY

Responsibilities:

• Created new CSS files to change header and footer section to in corporate new changes as per new UX guidelines.
• Responsible for writing procedures, which were called by ajax functions and another application named WISC where application for new project are processed, so that all the data will be automatically updated.
• Added Ajax call to check if one record is being edited or not using JavaScript, for client side validation. This helped to lock a file while one person is updating a record.
• Added timeout/extend session feature using JavaScript, to help a user while editing a record and reminding them to session expire timings.
• Added role based security feature using Ajax call through JavaScript. Introduced a new table structure and an application level function to check type of user and provide privilege according to the role the user is mapped. Before this feature is added every end user now has access to application with role based information.
• Added a new feature to split a project into smaller engagements.
• Created a dashboard having all details of a project with graphical representation.
• Responsible for addition of dashboard features and adding additional security features using JavaScript and Ajax calls of procedures.
• Responsible making UI changes using css and html.
• Responsible for unit testing.

Environment: Oracle Apex 4.2, Oracle 11g, JavaScript, CSS 3.0, HTML 5, Toad 10.6, Windows-7, MS-Office word, Excel, PPT.

Confidential

Responsibilities:

• Created simple and dashboard reports using web-i, crystal reports, Apex and xcelsius.
• Created universe using universe designer.
• Worked on testing and resolving loops, chasm trap and fan trap issues while designing universe.
• We used star schema for designing our universes.
• Responsible for modification and testing of universes in business objects.
• Responsible for developing reports using crystal report.
• Responsible for developing reports using Web-I.
• Got training for migrating data from different databases to MySQL using SSIS technology.
• Responsible For Writing Functional Specification.
• SPOC of Web-I reporting team, 2 team member works under me.
• Responsible for modifying and developing universes.
• Responsible for testing universes and reports in UAT environment.

Environment: Business Object XI (Designer, Web-I and Desk-I), Crystal report, Oracle Apex 3.1, USD 6.0.

Confidential

Responsibilities:

• Worked on Designing DB structure for the application and using VISIO created ER diagram.
• Worked on procedures, functions and packages, used for fetching data, updating DB tables and sending mails.
• Worked on DB job scheduling for automation emails on birthday's and anniversaries.
• Responsible for coding for database connectivity and retrieve of data.
• Writing pl/sql procedure/packages/functions to put the processed data into final tables.
• Created various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Responsible For Writing Functional Specification.
• Responsible For Unit Testing.
• Responsible for transitioning it to support and creating support document.

Environment: Eclipse, Visual Source Safe, Oracle 9i pl/sql, Toad, Jboss, Struts, Hibernate.