SUMMARY:

• Motivated, personable IT professional with comprehensive business/technical skill set and a successful 12+ years track record of software applications design, development, implementation and support.
• 7+ years of experience development & debugging of PL/SQL scripts that includes packages, procedures, functions, triggers, hints, ETL (data migration) and other DDL/DML/ TCL SQL Scripts.
• Delivered multiple performance tuning and health check projects in enterprise environment and have significant significant experience in large data sets, collections, DB links, handling database locks and Unix Shell Scripts.
• Worked with various version control tools (Git, ClearCase, SourceSafe), Release management build tools (Jenkins), Collaboration tools (sharepoint) and application management tools (JIRA, iCare, SDM, Remedy).
• Delivered multiple projects in Agile Development Environment and proficient in SCRUM/ Kanban.
• Worked as tier 1 support SPOC for Oracle eBusiness Suit and Oracle Siebel CRM; Managed service requests/ trouble tickets and ensure their timely resolution/fixes.
• Winning background serving and collaborate with multiple stakeholders (end user/clients managers/ project coordinators/ business analysts/ testing teams) to analyze business requests, system tickets/ defects; to provide effort estimation, make code changes, perform unit testing and implement the enhancements.
• Exceptional analytical, consulting, stakeholder management and oral & written communication skills to understand the business aspects and use computer systems to improve them.
• Multiple years of hands on experience in OLTP, OLAP and enterprise system/ application/ data integration by using different integration & access patterns
• Superb trouble - shooting, problem solving skills and development experience on various platforms including UNIX, Sun-Solaris, IBM-AIX and Windows.

TECHNICAL SKILLS:

• PLSQL, C/ C++, Pro*C, Java, Spring, J2EE, C#& VB.NET, Jenkins, JUnit
• ASP.NET, PHP, JavaScript, Ajax& JQuery
• Json, XML, Web Services
• Oracle Database, Oracle 6i/9i Forms, MS SQL Server, MySQL, Times Ten & Crystal reports
• Enterprise Architect, Visio, MS Project
• IDE (JDeveloper, Eclipse)
• Data Integration Tools (Datastage, Informatica)
• Oracle Siebel CRM, Oracle iCare, BMC Remedy, JIRABusiness Process Engineering
• System Analysis & Design
• Project & Product Management
• Performance Engineering
• Object Oriented Concepts & Methodologies
• Service Oriented Architecture (SOA)
• Enterprise Application Integration (EAI)
• Strategic & Operational Analysis
• Data Science
• Data Retrieval and Cleaning
• IoT Fundamentals

PROFESSIONAL EXPERIENCE:

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Analyze business requirements, evaluate various Applications that includes Product management, Order Management, Billing & Payments, Credit Control and Debt Collection, Task Management. Multiple projects delivered in Agile Development Environment and proficient in SCRUM/ Kanban.
• These are the back office applications which are developed using Java, Oracle Forms 9i and set of PLSQL packages/ functions/ procedures/ triggers and also integrated with customer service and self-care systems.
• Health check projects and delivered multiple performance tuning and in enterprise environment and have significant significant experience in large data sets, collections, DB links, handling database locks and Unix Shell Scripts, Oracle Database, Oracle 6i/9i Forms, MS SQL Server, MySQL, Times Ten & Crystal reports.
• Prepare technical specification documents with design and implementation detail.
• Do the necessary configurations, write PLSQL Triggers/Procedures/ Functions/ Packages and other PLSQL and Unix Shell Scripts for DML operations to enable the enhancements and new functionalities.
• Used SharePoint as collaboration tool and document repository, and JIRA as Application & Service Management Tool through out the application/ service management life cycle.
• Experience with various version control tools (Git, ClearCase, SourceSafe), Release management build tools (Jenkins), Collaboration tools (sharepoint) and application management tools (JIRA, iCare, SDM, Remedy).

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Contributed throughout project life cycle that includes business requirements analysis, system design & development, implementation & support, legacy information systems enhancements and support, business process improvement and System integration.
• Software development using various technologies and programming languages that includes Oracle Forms 9i, PLSQL, Shell Scripting and Java/J2EE.
• Built coding standards, conducted code review sessions, peer testing and provided technical mentoring to junior team members.
• Superb trouble-shooting, problem solving skills and development experience on various platforms including UNIX, Sun-Solaris, IBM-AIX and Windows.
• Worked as customer liaison to handle tickets for application enhancement and maintenance support, also performed impact analysis for the changes in the system. In addition to this, used various tools in below mentioned projects for continuous Integration/ Delivery, collaboration and application/ service management including Jenkins, JIRA, SDM and SharePoint.
• Dynamic SIM Allocation: This project was delivered for Airtel Africa to manage pre-provisioned SIM Cards, and my role was software design and development using Java, Oracle Forms 9i and PLSQL.
• Apogee CRM Service Workflow and Escalation Matrix: This project was delivered for Airtel Africa to facilitate high RPU customers through special workflows. My role was to design and development using Java, Oracle Forms 9i & PLSQL and also integrated its functionality with customer service management and BI.
• Credit Control and Debt Collection Management System: This was a reverse engineering project to transform Oracle Forms application into Java. My role was to analyze legacy Oracle Forms and PLSQL (Triggers/ Functions/ Procedures/ Packages) code, prepare design documents and contribute in new application development using Java and PLSQL.
• Application Planning and Demand Management (Ooredoo Kuwait): This was a customer support project and my responsibility was to handle maintenance and enhancement requests (for Oracle eBusiness Suit, Siebel CRM) using Remedy and JIRA as service management platforms.

Programmer Analyst

Confidential

Responsibilities:

• Closely worked with project managers and technical directors in resource planning & estimations and developing overall solution strategy and plan.
• Participated in requirements analysis, technical analysis, design, development, testing code/ unit testing, business testing and implementation and maintenance.
• Developed technical artifacts that includes system architecture/framework design, 3rd party integration, SRS, FRS, HLDs, LLDs, PoCs, data migration, Deployment Guides and other system related documentation.
• Programming using Java, Pro*C, Oracle Forms and PLSQL.
• TABS Customization Projects: design & developed new functionalities and modules using Oracle Forms 9i and PLSQL. The deliverables were Forms, PLSQL Packages/ Procedures/ Functions/ Triggers and other DDL/DML/TCL SQL Scripts. I also supported their implementation on several telecom sites.
• Telecom Business Suite: This was a set of different application that includes CRM, Product Catalog, Order Management, Collection & Billing, Resource management, Mediation, Provisioning and Task Management. As technical team lead, my role was to prepare the design documents (HLD/ LLD), support other team members, and contribute in development using Java, PLSQL.
• 2nd Line Support: My role was to handle trouble tickets raised by multiple customers running TABS application, do the code changes using Oracle Forms 9i and PLSQL to fix the technical issues in PLSQL Packages/Procedures/ Functions/ Triggers and Forms. I have also used Oracle iCare System to manage trouble tickets and service management platform.

Programmer Analyst

Confidential

Responsibilities:

• Designed and developed various web-based projects to meet the need of e-commerce & stock market business.
• Analyze and evaluate customer business requirements and produced proposed solutions.
• Solution development using VB.NET, ASP.NET, C#, XML and SQL Server.

Software Engineer

Confidential

Responsibilities:

• Designed and developed the software (web, desktop) according to business requirements for mass media communications and healthcare sector.
• Contributed in analysis and design phase and produced ERD, HLD and LLD.
• Deployed the software applications in UAT and Production environment.
• Installed, upgraded and maintained database/ application servers.
• Handled application service support requests.
• Documented installation guides, user manuals and standard operating procedures.
• Development of Software Applications using ASP, VB, ASP.NET, VB.NET, C# and MS SQL Server.

Software Engineer

Confidential

Responsibilities:

• Worked as an application developer & Analyst and completed several projects, few are: Financial Management System, Automobile spare parts retailer management system.
• Core responsibility was applications development using VB, ASP, SQL Server