SUMMARY:

• 11 years of total experience in IT.
• AWS certified solution architect.
• 10 years 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.
• 8 years of experience in Oracle Apex for web application, work-flow applications and interactive reports.
• 8 years of experience with SDLC
• 3 years with Agile scrum.
• 7 years of experience in ETL with informatica.
• 5 years of reporting experience using tools like BO, OBIEE reporting, Excel and Oracle APEX.
• 2.5 Years of experience in Business Objects XI R3 Webi and Universe designer.
• 2 years of experience in Sql server and SSIS packages for ETL.
• 1 years of experience in Macromedia Flash 8, Java, XML.
• 5 years of experience in UNIX scripting.
• 1 year of experience in AWS Cloud environment with Python and MongoDB.
• 5 years of experience in manufacturing domain.
• 2 years of experience in Telematics and IOT domain.
• Working knowledge of RESTful APIs.
• Experience with OLTP and OLAP environments.
• Working knowledge of Erwin data modeler tool.
• Working knowledge of IBM cognos.
• 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 tools like Toad, SQL developer, redwood and Appworx.
• Experience with Databases Oracle (9i, 11g, 12c).
• Involved in DB upgrade from 9i to 11g and 11g to 12c.
• Strong exposure to Clear Case, Clear Quest, GIT 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 architectural design for data flow between partner and affiliate system of Confidential North America through APIs and SFTP.
• 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 SKILL

Cloud: AWS Cloud

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

NoSql Database: MongoDB

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

Operating Systems: Windows

Webservices: RESTFul

Scheduling tools: Appworx, Control-M, Redwood

Scripting: Unix Shell Scripting, Python scripting

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

Testing Tools: Junit, Load runner

PROFESSIONAL EXPERIENCE:

Confidential, Plano, Texas

Software: AWS Cloud, Spring boot, Python, MongoDB, Oracle 12c, Informatica 9.6, JIRA, Unix, Putty, Redwood, GIT, Jenkins, Agile Scrum

Oracle PL/SQL Developer

Responsibilities:

• Defined process of bridging AWS to on-premise UNIX box without direct connect.
• Responsible for defining SSH key rotation process from SFTP system to AWS for security.
• Responsible for reading data from cloud databases using APIs through Informatica.
• Responsible for generating user data from DSS DB and posting it to S3 bucket using UNIX.

Environment: AWS Cloud, On-Premise UNIX server.

Confidential, Plano, Texas

Software: Oracle 12c, Informatica 9.6, JIRA, Unix, Putty, Redwood, Agile Scrum, Power BI

Oracle PL/SQL Developer

Responsibilities:

• Working as a developer in Oracle PlSql & Unix.
• Works in agile method using Jira.
• 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 writing packages, procedures and functions to manipulate data for reporting purpose and put them into final tables which will be used for creating reports.
• Responsible for creating interactive reports with Power BI for dealer enrollment application.
• Responsible for writing stories for sprints.
• Responsible for documentation for support transition.
• Responsible for providing transition of applications.
• Informatica is used for data transformation.
• Power BI is being used to develop reports and applications related to update and maintain subscription of services provided by Toyota and it’s partners.

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

Confidential, Fort worth, Texas

Software: Oracle PL/SQL 12c, Exadata, UNIX, JAVA, Agile, GIT, SQL Developer/loader, OLAP

Oracle PL/SQL Developer

Responsibilities:

• Working as a developer.
• 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 gathering requirements and explaining it to Indian team member.
• 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, beyond compare, Red-gate

Confidential, Plano, Texas

Software: Oracle PlSql 11g, 12c, Apex 5.0, UNIX, Python, Shareplex, GIT, TOAD, OLAP, Exadata, ERWIN, Control-M

Oracle PL/SQL Developer

Responsibilities:

• Working as a Oracle PlSqldeveloper and Onsite coordinator.
• Responsible for assigning and explaining tickets to India team.
• Working on tickets to add new database changes as requested.
• Responsible for using python scripts to process flat-files into oracle tables.
• 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.
• 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, 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.
• 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, Python 3.4

Confidential, Plano, Texas

Software: Oracle PlSql 11g, JAVA Struts, Unix, GIT, TOAD, OLAP, Control-M

Oracle PL/SQL Developer

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

Software: Oracle Apex 4.2, PL/SQL, TOAD, CVS, OLTP, Appworx

Oracle PL/SQL

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

Software: Oracle Apex 4.2, PlSql, TOAD, CVS, OLTP, Appworx, Oracle portal 11g

Sr Apex/PL/SQL 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 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

Software: Oracle Apex 4.2, PlSql, TOAD, CVS, OLTP, Appworx

Sr Apex/PL/SQL 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

Software: Oracle 9i/PL-SQL, Oracle 11g/PL-SQL, JAVA Struts 1, UNIX, Appworx, TOAD, CVS, OLTP

Oracle PL/SQL 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

Software: Oracle PlSql, Apex, Html 5, css3, Twitter Bootstrap, JQuery, TOAD, CVS, OLTP, Appworx

Oracle PL/SQL Developer

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

Software: Oracle 9i/PL-SQL, UNIX and Appworx, JAVA Struts 1, TOAD, CVS, OLTP

Oracle PL/SQL Developer

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

Software: Oracle Apex 4.2, PlSql, TOAD, CVS, OLTP, Appworx

Oracle APEX/PLSQL Developer

Responsibilities:

• 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

Software : Business Object XI (Designer, Web-I and Desk-I), Crystal report, Sql Server 10/10.5, Oracle Apex 3.1, USD 6.0, Informatica, CVS, Oracle Forms, reports, OLAP

DW Developer

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