SUMMARY

• A smart, results - driven IT professional with over 6 years of experience in product design, development and support looking to utilize expertise gained with global clients and meet organizational goals.
• Committed to working proactively with dedication, using natural leadership qualities to gain competitive advantage.

TECHNICAL SKILLS

Framework / Methodologies: SDLC, Agile, DevOps, ITIL- Incident, Problem, Change, Release

Domain: Banking, Regulatory Reporting, Health Care and Life Sciences, Fuel and Energy, Construction, Supply Chain Management (SCM)

Programming: SQL, PL/SQL, Java, Unix, JavaScript, Object Oriented Programming, Visual Basic, C, C++, XML, HTML

Tools: Oracle E-Business Suite (11G), Oracle Reports Builder 10g/11g, Oracle Forms Builder 10g/11g, Oracle JDeveloper 11g, Eclipse, SQL*Loader, SAP HANA studio “Revision”, Confluence, JIRA, ServiceNow, Tortoise SVN, HP-QC, HP-ALM

Database Scripting: SQL queries, Query Tuning & Optimization

Databases Tools: SQL, SQL Plus, PLSQL Developer, SQL Developer, Oracle Raptor, RDBMS, Toad

Platforms: Windows, Unix

Reports: Oracle Reports 11g, Microsoft Excel

PROFESSIONAL EXPERIENCE

ERP Forms Developer

Confidential

Tools: Oracle 11g Forms Builder/ Oracle 11g Reports Builder, PLSQL Developer, JIRA / Confluence, SQL, PLSQL, ERPC

Responsibilities:

• Worked collaboratively with various stakeholders within the organization to review, analyze business requirements prior to the design, development and deployment of application
• Designed, Developed, Tested and Implemented programs within the Oracle RDBMS including user interfaces and data source integration
• Developed Complex database objects likeStored Procedures, Functions, Packages, Views and Triggers using SQL and PL/SQL
• Expertise inDynamic SQL, Collections and Exception handling
• Good knowledge of key Oracle performance related features such asQuery Optimizer, Execution PlansandIndexes
• Redesigned database tables as per new business needs to improve performance
• Experience in working with 184+ clients across the globe. Identified potential risks/application issues. Created and managed JIRA tickets for tracking them. Also documented code logic in Confluence
• Maintained the consistency of the new code changes throughout various environments Alpha, Beta, Pre-Prod, Prod
• Interacted with client services and Implementations team to train, support implementations
• Handled production incidents-bug fixes, enhancements and performance tuning (Proactive / Continual Improvement)
• Developed / Created various custom invoice/progress billing reports, forms as required
• Helped in migrating 6i forms to 11g. Tested and validated the migrated forms to work in new environment
• Created payroll reports and corrected any alignment issues so the cheques get printed correctly. Added vacation pay used and remaining balance, fringe benefits, sick days and other payroll related items to the report as per client needs.

DevOps Engineer

Confidential

Tools: ITRS, PLSQL Developer, HP-QC, JIRA, ServiceNow

Responsibilities:

• Developed domain expertise in Citi’s regulatory reporting systems and obligations
• Incident management and issue analysis - Co-ordinated resolution of regulatory issues spanning multiple systems and asset classes
• Proficient in writing complex SQL queries using Oracle tools like TOAD and PL/SQL Developer. Rich experience in working with database objects like views, stored procedures, triggers, packages, cursors etc
• Actively participated in building real time monitoring of servers/application using ITRS (Infrastructure monitoring tool). Helped with designing ITRS dashboard which provides user friendly interface for monitoring.
• Expertise in working with JIRA for issue tracking.
• Prepared reports, audits and aided PowerPoint presentations for meetings with VRO, asset class owners and business users.
• Created and managed change tickets. Also reviewed and approved change tickets dat were assigned to the team
• Helped in analyzing and clearing out around 250 regulatory issues within a short period of time.
• Assisted in performing large volumes of withdrawals/backloading of data.
• Performed impact analysis and lead comminution with senior business and technology partners
• Managed timely escalation of technology related incidents to Legal, Compliance and external regulatory bodies
• Assisted in the co-ordination of Data Quality programs to resolve issues and improve the accuracy of our Regulatory Reporting
• Assist with the enhancement of applications through Problem Management and coordination of a stability book of work.
• Provided on call support on weekends to assist with server backups, upgrades, releases etc
• Managed onboarding of new platforms and regulatory requirements

Mobila Developer/ Oracle Developer

Confidential

Tools: Oracle 11g Forms Builder/ Oracle 11g Reports Builder, PLSQL Developer, TOAD, Oracle Raptor, HP-QC, HP-ALM, Tortoise SVN, PLSQL, Unix

Responsibilities:

• Provided on-site consulting services to a Suncor Energy (Mississauga, ON), a Canadian integrated energy company and upstream product supplier of Petro-Canada
• Helped in smooth transitioning of old Bulloch forms to Retalix version. Provided input on functional requirements, product designs, schedules and potential issues
• Developed AdvancePL/SQL packages, procedures, triggers, functions, IndexesandCollectionsto implement business logic
• Experience in optimizing existing PLSQL queries to improve code quality
• Assisted in data migration between databases while transitioning from Mobila to Retalix version
• Completed the detailed technical designs (TTD) and code development activities for the Mobila workstream
• Designed and Developed Oracle 11g forms in network and file download module, card transaction module, financial institution module, loyalty points and credits module etc.
• Worked on associated maintenance modules so dat the user can view and manage historical data
• Involved in troubleshooting and modifying databases according to business needs
• Manipulated offline transactional data in order to fetch desired result
• Compiled the developed Oracle 11g forms in Unix environment to load and run the forms in the web server
• Handled the Version control using Tortoise SVN software to Check in and check out files for development and testing purposes
• Documented and fixed application issues/bugs raised in ALM (Application Lifecycle Management) software
• Created and executedsoftware test plans, cases and scripts

Senior Software Engineer

Confidential

Tools: SAP HANA Studio, Excel IBP, JIRA, PLSQL Developer

Responsibilities:

• Responsible for creating/updating database objects (PLSQL stored procedures, functions, tables, packages, triggers and views)
• Provided resolution to business-critical incidents including but not limited to break fix, inconsistent database, post installation Script errors, bug fixes, visibility filters, user roles and data retrieval issues
• Planning point data analysis - Analyze keyfigure data at different planning levels and time series. Provide solution on efficient maintenance of database with respect to size and operating values
• Debug stored procedures and functions using debugger in SAP HANA studio “Revision”
• Performed pre-implementation and post-implementation change reviews on upgrades, patches and bug Fixes. Test (login, version check, user management screen and charts), Validate (activate time profile, planning area without errors and load template in excel and simulate changes) and document change results
• Performed database backup and SAP Snapshots (current state of data area) specific to key figures
• Hands on Experience in working with Excel IBP Add-in to generate planning views, manage master data and scenarios, simulate and save data, copy keyfigure data from one version to another, define alerts and design templates.
• Created and Updated SAP Notes (Support document dat contain coding corrections) and SAP Knowledge Base Articles (Incident specific documents)

Software Engineer

Confidential

Tools: Oracle 11g Forms Builder/ Oracle 11g Reports Builder, JIRA, PLSQL Developer, JDeveloper, Eclipse, ADF, JAVA, Unix

Responsibilities:

• Key responsibility was to Analyze and comprehend project requirements and decipher it into specifications and programming deliverables
• Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors and Dynamic SQL
• Replicated and fixed issues. Work on major enhancements of the project. Also work on retrofitting issues from one project release to another
• Responsible for code migration of existing application from one release to another
• Created and Updated data models, entity relationship diagrams, and plans
• Proficient in redesigning database table structure to optimize performance
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and exception handling methods
• Used for all and bulk collect to fetch large volumes of data in PL/SQL objects
• Involved in formulating general methodologies, naming conventions and coding standards for the SQL code
• Developed and tested Oracle reports in Oracle Reports developer 11g. Worked on 25+ reports
• Experience in designing and developing both web layout and paper layout Oracle reports in various styles based on user requirements
• Worked on master detail Oracle reports using tabular and group above reports
• Created alerts, LOVs, pop-up menu in Oracle forms as part of the requirement
• Experience in working with Eclipse, JDeveloper and JSP
• Involved in building Proof of Concept (POC) for external online label approval functionality
• Created ADF libraries for ADF skinning, Template, login and other modules and deploy them as shared libraries
• Designed layouts for templates, pages and page fragments
• Involved in capturing client machine details for journaling to comply CFR part 11 for security by using Oracle PSP, Applets and Servlets