SUMMARY

• Over 8 years of programming experience in Oracle PL/SQL.
• Expert in developing complex SQL queries/Views, PL/SQL Stored Procedures, Cursors, Triggers and Functions.
• Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Strong Data Base, Object Oriented Programming skills.
• IT professional with high technical, professional skills and rich experience in Complex Projects.
• Full cycle implementation and extensive experience in analysis, design, development, customization and implementation of Software solutions.
• Experience in developing n - tier applications using Microsoft technologies (VB. NET, ASP.NET, C#, Web Form, ADO.Net).
• Proficient in analyzing and translating business requirements to technical solutions.
• Knowledgeable in all phases of software development life cycle: Designing, Developing, Coding, Debugging, Testing, Implementation and Maintenance.
• Excellent communication, interpersonal skills, self-motivated, quick learner and team player.

TECHNICAL SKILLS

Languages: Oracle SQL, PL/SQL, VB. NET, ASP.NET, C#, C, C++, Java

RDBMS: Oracle 12c,11g, 10g, 9i

Scripting: VB Script, Shell, Perl, Java ScriptO/S: Windows, IBM AIX, HP UX, SGI IRIX and Linux

Design Approach: UML, DFD, ERD

PLM: Infor Optiva 12.14, 11.12 & 4.8

PROFESSIONAL EXPERIENCE

Confidential

Sr IT Consultant

Responsibilities:

• Understanding client’s requirement and translate them to new application features
• Followed Agile Methodology with daily Scrum meeting
• Gather implicit and explicit requirements in the Form of Epic/User Stories. Define the Acceptance Criteria. Assign stories to the Team.
• Extensively involved in analysis, design, development, customization and implementation of Software solutions.
• Harmonization and Implementation of Software Solutions.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to Production Environment.
• Developed complex SQL queries/Views, Triggers and Functions to automate tasks
• Coordinate with operational IT teams for VPN ad SSO implementation.
• Deployment of the application into AWS Environment.

Environment: .NET Framework, VB.Net, ASP.Net, ADO.Net, Crystal Report 2013, IIS 7.0, Infor CloudSuite for PLM (Ver 12.14), MS SQL Server 2016, PL/SQL, JIRA, Bit Bucket, SourceTree

Confidential

IT Consultant

Responsibilities:

• Work closely with client (with internal cross-functional teams) and the solutions management team to jointly develop client-specific detailed Requirement Definition, gap-analysis and use-cases.
• Prepare Functional Specification, Technical Specification documents.
• Jointly Develop sound solutions to address customer objectives.
• Develop the solution for collaboration.
• Developed Advance PL/SQL packages, procedures, triggers and functions to implement business logic
• Fine-tuned SQL queries/Views. Automate task using PL/SQL.
• Provided solutions to integrate with SAP, IPMS, Recipe Management System and Laboratory Information Management System.
• Designing and prototyping new systems for enhancing business processes, operations, and information process flow.
• Design and develop Crystal Reports to generate NFP (Nutritional Fact Panel) according to the new 2016 FDA guideline (Single / Multi Column) on Objects like LCM(Label Content Management) using various data sources.

Environment: .NET Framework, VB.Net, ASP.Net, ADO.Net, C#, Cyrstal Report 2008, IIS 7.0, Infor PLM Optiva (Ver 12.1), Oracle 12c, PL/SQL, IBM MQ Series, JIRA, Bit Bucket, SourceTree, Java, BMC Remedy, HP QC, PTC MKS.

Confidential

IT Consultant

Responsibilities:

• Analysis of business requirement, solution development and driving the managed services framework for application and integration.
• Act as a liaison between the business and offshore IT staff for service delivery.
• Creation of functional specification document, project work estimation, project scheduling and statement of work.
• Leading the technical team, defining development iterations for product development and delivery.
• Project tracking, creation of management review documents for status updates.
• Supporting the product deployment and support phase.
• Performed SQL and PL/SQL tuning

Environment: .NET Framework, VB.Net, ASP.Net, ADO.Net, C#, JavaScript, Angular JS, JQuery, JSON, XML, PL/SQL, Tortoise SVN .