SUMMARY:

• 9.3 years of total experience in IT, 9.3 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.
• 7 years’ experience in Oracle Apex for web application, work-flow applications and interactive reports.
• 7 years of experience with SDLC and 2 years with Agile.
• 5 years of experience in ETL with PlSql, informatica and SSIS package.
• 5 years of reporting experience using tools like BO, OBIEE reporting, Excel and Oracle APEX.
• Worked in Manufacturing Domain.
• Experience with OLTP and OLAP environments.
• 2.5 Years of experience in Business Objects XI R3 Webi and Universe designer.
• 1.5 years of experience with Erwin data modeler tool.
• Have working knowledge of IBM cognos.
• 2 years of experience in Sql server and SSIS packages for ETL.
• 1 years of experience in Macromedia Flash 8, Java, XML.
• Have working knowledge of Oracle Portal.
• 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, 12c).
• Involved in DB upgrade from 9i to 11g and 11g to 12c.
• Experience in UNIX, SQL server 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 skillsets.
• 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, Oracle Forms, reports Excel

Dashboard Tools: Xcelsius(Trained)

Databases: Oracle 9i, 11g, 12c, MySql, SQL Server 10/10.5

Tools: Toad for Oracle, SQL Developer, SQL loader, BO Web-I, Desk-I, Universe Developers, Informatica 9.6, Shareplex, CVS, GIT, OBIEE, Cognos, ERWIN

Operating Systems: Windows

Webservices: RESTFul

Content management: Oracle Portal

Scheduling tools: Appworx, Control-M, Redwood

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, Texas

Technology Analyst

Responsibilities:

• Working as an onsite coordinator.
• Works in agile method using Jira.
• Worked on RESTful webservice DIS using oracle APEX. This webservice gets list of 17CY us dealer list. Now working on adding affiliates TCI, TdPR and Servco.
• Responsible for file handling between Toyota affiliates/partners.
• Responsible for decrypting and encrypting files using gpg keys provided by affiliates.
• Responsible to get the files into DSS system to process them using informatica and then to put into Oracle telematics dw.
• All the data come inform of flat files/ xml files from affiliates/partners.
• Work on maintaining and enhancing ETL mappings as per requirement.
• Responsible for writing new mappings for app enhancements and rule changes for end customers by Toyota/Lexus dealers.
• Responsible for creating reporting queries for manual report from tables.
• Responsible for writing stories for sprints.
• Responsible for documentation for support transition.
• Responsible for providing transition of applications.

Environment: Informatica power center, Oracle 12c, JIRA, Toad.

Confidential, Fortworth, Texas

Technology Analyst

Responsibilities:

• Working as a developer and Onsite coordinator.
• Responsible for gathering requirements and explaining it to Indian team member.
• Working on writing plsql packages for different EDI transactions.
• Responsible for testing all our DB code in 12c.
• Worked in Exadata environment.
• Responsible to maintain PDBs specific to EDI.
• Responsible for client interaction and helping them with understanding our changes.
• Responsible for closely working with client SMEs to understand and develop.
• Responsible for maintaining code changes in GIT with our own EDI branch.
• Responsible to maintain agile scrum for EDI.

Environment: Agile, Oracle PlSql 12c, UNIX, JAVA, CONTROL-M, GIT, Sql developer, Eclipse, Mainframe, Confidential compare, Red-gate

Confidential, Plano, Texas

Technology Analyst

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.
• Responsible for testing all our DB code in 12c after upgrade.
• Worked in Exadata environment.
• Writing PL/SQL procedure/packages/functions to put the processed data into final tables.
• Maintaining, and modifying Apex applications.
• Monitoring jobs and recovering if it gets abondend.
• 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.
• For ETL, we are using Shareplex, informatica and oracle plsql.
• For informatica mappings most of the data come inform of flat files/ xml files and for some mysql application also.
• Work on maintaining and enhancing ETL mappings as per requirement.
• Responsible for writing new mappings for app enhancements and rule changes.
• Responsible for data modeling using ERWIN data modeler.
• Worked with DM team on data desigining.
• Apex is being used for small reporting applications.
• In Apex we have created Forms and reports.
• Reports included charts like bar, pie, interactive, Map charts.
• Created forms with dialogue pages.
• All the applications were SSO login enabled.
• Used Confidential UI framework for all apex applications which was based on HTML5, CSS 3 and javascript.
• 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.
• Used OBIEE for BI pupose.

Environment: Oracle PL/SQL 11g, Unix, Toad 10.6, Windows 7, Putty, Control-M, Shareplex, Apex 5.0, CSS, HTML, JQuery, Java Script

Confidential, Plano, Texas

Technology Analyst

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, New York

Technology Analyst

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, and V-arrays.

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

Confidential, Melville, New York

Technology Analyst

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, JQuery, JavaScript, CSS 3.0, HTML 5, Toad 10.6, Windows-7, MS-Office word, Excel, PPT.

Confidential

Sr Apex Developer

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, JQuery, JavaScript, CSS, HTML, Toad 10.6, Windows-7, MS-Office word, Excel, PPT.

Confidential

Team Lead/Developer

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

Technology Analyst

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: JAVA Struts 1, Oracle 9i PL/SQL, Oracle 11g PL/SQL, UNIX, Appworx, Windows-7, MS-Office word, Excel, PPT.

Confidential, New York

Technology Analyst

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, New York

Senior Software Engineer

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, JQuery, JavaScript, CSS 3.0, HTML 5, Toad 10.6, Windows-7, MS-Office word, Excel, PPT.

Confidential

Technical Executive Support

Responsibilities:

• Created simple and dashboard reports using web-i, crystal reports, 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.
• Worked in Informatica for ETL.
• Got for migrating data from different databases to Oracle 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, SSIS, Sql Server 10/10.5, Oracle Apex 3.1, USD 6.0.

Confidential

Software Engineer

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 birthdays 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.

Confidential

Developer

Responsibilities:

• Designed MP3 player layout using flash 8 and JAVA Applet.
• Used action script 2 for all button controls of mp3 player
• Used xml for creating and saving song playlist. XML file saves the path information of selected songs.
• The xml file is read and updated by file I/o function of java