SUMMARY:

• 8+ years of experience in designing, developing and implementing multiple applications through Oracle PL/SQL programming, UNIX Shell scripting.
• 1+ Years of experience working with Axiom SL Controller View Regulatory Reporting tool.
• Good experience in designing and developing regulatory reports using AXIOM objects i.e. Data Source, Data Model, Modify Model, Portfolio, Aggregation, Shorthand, Tabular Report, Freeform Report.
• Expertise in writing and tuning complex sub queries in SQL, PL/SQL stored procedures, functions, triggers, views, materialized views, constraints, indexes, packages, synonyms, sequences, Database links, Bulk collects/Inserts, cursors/ ref cursor, analytical functions, dynamic SQL, partitions and exception handling concepts.
• Expertise in working with large scale Databases and Data Warehouses.
• Extensive experience working in an agile development environment.
• Good experience in creating technical stories and assigning story points in a Sprint. Participated in daily scrum meetings as well as sprint planning & review meetings.
• Worked heavily with relationship database models, schemas & entity - relationship diagrams (ERMs) to create technical/system design documents.
• In-Depth Knowledge of Oracle Architecture, data dictionary, to understand Schema Objects, Schema Objects Relations, Schema Privileges, Roles and Restrictions.
• Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading processes using UNIX Shell scripting, Perl Scripting, Oracle Data pump and SQL Loader.
• Highly skilled in performance tuning using cost based optimization, analysing query plans using explain plans.
• Experience in parsing XML files through UNIX Shell scripting.
• Experience in developing Java web services.
• In-Depth knowledge of file transfers using FTP and SFTP protocols on both Windows and UNIX Operating Systems.
• Experience in requirements analysis, coding and testing various modules in a software development life cycle.
• Good Experience in Unit Testing, Integration Testing, Volumetric Testing, Performance Testing and application debugging.
• Strong problem-solving, organizing, communication and planning skills, with ability to work in team environment.
• Experience in providing production support and also client support to end users via web-ex meetings.
• Experience in handling machine critical and business critical applications.
• Created many Oracle advanced queues and good experience with publishing and consuming data through advanced queues.

TECHNICAL SKILLS:

Database: Oracle 12c/11g/10g/9i/8i, MySQL

Languages: SQL, PL/SQL, UNIX Shell Scripting, Java, Perl

Web Technologies: HTML 5, XML, JavaScript, CSS

IDE and Tools: NetBeans, Eclipse, Notepad ++, PL/SQL Developer, Load Runner, Soap UI, Toad, Load UI, Cygwin, WinSCP, Confluence

MVC Framework: Struts, Spring, Angular JS

Web/App Servers: Apache, Tomcat

Version Control: Tortoise SVN, GitHub, VSS, CVS

Build Automation Tools/ Servers: Maven, Jenkins, Continuum, Flyway

Reporting/Designing/ETL Tools: Axiom SL, Crystal reports, Microsoft Visio, Jitterbit

Operating Systems: Solaris, Windows

Project Tracking/ticketing: MKS, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Sr Oracle PL/SQL Developer

Responsibilities:

• Loading Risk and Finance information to Data warehouse through Informatica.
• Processing the information from stage tables and makes it ready for Data sources loading in Axiom.
• Create a sophisticated data model to support huge data (Billions of records) needed for regulatory reporting.
• Developed a strategic and easily configurable and maintainable archive mechanism to support Federal requirements.
• Partitioned the tables as needed and use partition exchange for data maintenance and improved performance.
• Design and Develop Reports using AXIOM objects i.e. Data Source, Data Model, Modify Model, Portfolio, Aggregation, Shorthand, Tabular Report, Freeform Report, Validations.
• AXIOM Release Management and production migration responsibility.
• Improving Database performance and tune SQL queries to generate regulatory reports as quickly as possible.
• Configuration of pre-processing and Axiom scheduled jobs in CA-7.

Environment: Oracle12c, Axiom SL 9.8.5, Regulatory Reporting, Data Warehouse, PL/SQL, TOAD, Shell Script, Agile, SQL*Loader, and UNIX (Sun Solaris 5.10), JIRA, SVN, Flyway.

Confidential, Rochester, NY

Sr Oracle PL/SQL Developer

Responsibilities:

• Designed scalable solutions to process the real time Xerox equipment data.
• Increased the performance and maintainability of the application.
• Processed complex global Duns and Bradstreet (D&B) information and publishing the data across multiple applications in Xerox.
• Participated in the business requirements meetings.
• Provided the Technical and business impact analysis to the near future enhancement requests from business.
• Prepared the high level and low level design documents for the application enhancements.
• Developed various complex stored procedures, packages, and triggers in PL/SQL.
• Responsible for performing code reviews.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object types and Triggers.
• Worked on logical and physical data modeling and created Materialized views.
• Created Complex Dynamic / Static / parameterized reports and Charts.
• Developed Shell scripts, Perl scripts and SQL control files to load data through SQL Loader & Oracle data pump.

Environment: - Oracle10g/11g, Data Warehouse, PL/SQL, TOAD, PL/SQL Developer, Shell Script, Perl, Agile, SQL*Loader, and UNIX (Sun Solaris 5.10), CSS, Windows 2000, Net Beans, JIRA, SVN, Jenkins, Struts, Java, Angular JS, Flyway.

Confidential, Lewisville, TX

Sr Oracle PL/SQL Developer

Responsibilities:

• Designed and Implemented permanent solutions to various recurring billing issues for the external customers.
• Redesigned a thorough backup and recovery strategy for critical production systems. This initiative involved the design and development of several UNIX shell scripts and Perl scripts used for both physical and logical backups.
• Identified manual processing deficiencies, and instituted automation techniques which reduced manual work and increased work flow efficiency.
• Upgraded application Java version from 1.5 to 1.7, and Oracle database version from 10g to 11g.
• Supported the retirement of applications which are no longer profitable to Xerox, which resulted in savings of nearly 0.5 Million Dollars of maintenance cost per year.
• Developed programs using rsync that keeps the primary server and disaster server always in sync.
• Wrote extensive SQL and PL, SQL Procedures, Functions, External tables.
• Tuned database SQL statements and procedures by monitoring Explain plans and system statistics, Inserted hints and rewrote code as required.
• Used JavaScript for client side validations in the JSP and HTML pages.

Environment: Oracle 11g/12c, Data Warehouse, Java 1.6/1.7, Tomcat, Net Beans, Eclipse, SVN, PL/SQL, TOAD, Shell Script, SQL*Loader, and Unix (Sun Solaris 5.10), Distributed Servers, Load Runner, Soap UI, Load UI, CVS,SVN, JIRA, Flyway.

Confidential, Rochester, NY

PL/SQL Developer

Responsibilities:

• Built XML-RPC and Restful web services in Java to access customer and equipment data with in MCKB.
• Implemented Oracle advanced queues that publish and process Xerox real time service contracts.
• Worked on data synchronization among multiple systems, with updates that occur in the MCKB source.
• Key member of the team that performed integration testing of more than fifty applications involved in Managed Print Services project.
• Implemented File Transfer Hub for the Marketing & Sales applications operated from Rochester, NY.

Environment: Oracle 10g,11g, SQL, PL/SQL, Microsoft Visio, Net Beans, Agile, SVN, VSS, Sun Solaris, PL/SQL Developer, XML, HTML, UNIX, TKPROF, TRACE, EXPLAIN PLAN, and Sql*Loader, Load Runner, Soap UI, Struts, Flyway, JIRA, MKS.

Confidential, Wilsonville, OR

PL/SQL Developer

Responsibilities:

• End to end design and implementation of the complete File Transfer Hub software.
• Parsing of the XML configuration files.
• All the technical components in the software are developed in a very organized way in such a way that any functional/feature enhancements can be done very quickly with minimal efforts.
• All the parameters needed to set up a new file transfer program are configurable.
• Developed a robust notification and logging mechanism, so that any failures will be handled by application support team very easily.
• Implemented file transfer verification mechanism using the file checksum.
• Implemented in-built the data security mechanism. Any process configured in this software is only visible to the responsible team.
• The application validates all the configurations prior to the execution of the tasks configured.
• The data clean up and maintenance is automatic through this application. No manual intervention is needed.
• Prepared end to end documentation to help install this software across various applications.

Environment: Oracle 10g,11g, SQL, PL/SQL, Microsoft Visio, Sun Solaris, PL/SQL Developer, XML, UNIX Shell Script, Perl Script, SVN.

Confidential, Rochester, NY

PL/SQL Developer

Responsibilities:

• Implemented the processes to streamline the communication between Xerox and GIS systems for successful acquisition of GIS Corporation.
• Designed the solution in such a way that GIS and Xerox sales channels do not conflict with each other.
• Fine Tuned several slow running database queries with Explain plan, SQL trace and Hints to improve the performance of the application.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Developed various procedures and functions in PL/SQL for doing the ETL.
• Developed a package containing several procedures and function using oracle concepts such as ref cursors and bulk collects are used to improve performance.

Environment: Oracle 10g,11g, SQL, PL/SQL, Microsoft Visio, Sun Solaris, PL/SQL Developer, XML, HTML, UNIX, TKPROF, TRACE, EXPLAIN PLAN, and Sql*Loader, Reports, SVN, MKS.

Confidential, Wilsonville, OR

PL/SQL Developer

Responsibilities:

• Processed campaign data gathered through various channels to identify potential leads.
• Assigned lead scores for the users and mapped resellers to contact the potential leads to convert them to the actual customers.
• Develop queries to fetch data from remote database using database links.
• Responsible for development, application testing at various stages of implementation, Version Control, Production Staging, implementation, planning and training.
• Develop scripts to automate jobs, schedule resource intensive jobs and log detailed results.
• Established SSH connection to Zyme servers through Xerox firewall.
• Generated reports from Oracle apps.
• Automated scheduled manual reports generated by application support team.

Environment: Oracle 9i, UNIX, SQL, PL/SQL Developer, Oracle apps, SQL*Loader, SQL*PLUS, Forms 6i, Reports 6i, SFTP.

Confidential

Web Developer

Responsibilities:

• Developed front-end application code for web application using Java script.
• Created MySQL database table structures required.
• Developed MySQL procedures and functions for business logic.
• Created Java classes to establish JDBC connection.

Environment: MySQL, HTML, XML, Java Script, SQL, Java.