An articulate, goal-oriented, self-disciplined qualified IT Systems Professional having experience in managing Small and Medium Teams for an Enterprise environment and expertise acquired in the areas of database designing, implementation, administration, managing diverse IT Projects and IT Operations, Having knowledge of designing and implementing desktop, web-based, mobile applications and oracle E-business suit R12.
Skills, Knowledge & Experience Summary
● Oracle E-business Suite R12
● Oracle Form Personalization , Customization and Integration
● OAF Personalization and Customization
● Oracle Workflows
● API's
● Integrations
● Oracle Development Suite ( 6i, 10g, 11g )
● Oracle BI Publisher / XML Publisher
● Oracle, MySql, MS Sql Server, NoSQL (Mongo) Databases
● PL/SQL, T-SQL
● ETL
● PHP, Codignator
● Java
● Bootstrap, Java-script, J-query, Ajax
● Technical Documentation
Control and coordinate the activities to develop and implement software.
Management and technical support of team members. Audit of existing
custom applications and Gap analysis.
Upgrading the custom applications from 11g to Oracle ADF.
Implement multi-biometric (Face, Fingerprint, Card) attendance system.
Support & reporting of Oracle E-business suite in Financials, Supply chain and
Order Management.
Analysis and structural design of applications. Database development and
monitoring.
Performance tuning of reports.
Manage Datacenters, Implement backup and disaster recovery plans.
Apply security rules on servers and ensured server security.
Oracle Web-logic and PHP Xampp server configuration. Xampp server linking
with Oracle and its trouble shooting.
HMVC Implementation.
Implement real time attendance from remote locations.
Design API and integrate with Mezaan bank for auto challan posting.
Implement School and college systems in more than 80 schools and 20
colleges.
Code complex stored procedures, functions, packages, triggers to achieve
business requirement.
Developed ERP system which includes UMS, Setups, Financials Multi Org,
Supply Chain, E-shop, HRMS, Ticket System, Canteen, Sales, Royalty &
Licensing, CTS, Schools, Colleges systems in Oracle Suit 11g and PHP with
framework codeignator.
Guide and give the plan for new implementation.
Managing IT team. Responsible for the day to day IT Operations.
Interaction with higher management to keep the software according to
changing environment, policies and procedures.
I also performed duty as analyst and deals with the SDLC and get requirements
from department, design flow charts and necessary paper work then guide
team members for development.
Oracle EBS
Support of Supply chain and Financials modules
Oracle Forms Customization, Personalization & integration with R12.1.3
BI/XML Publisher Reports and Oracle Reports development
Web Based (OAF) Personalization, Data Loader
In House Developed Software
Development of customized Inward/Outward Gate Pass Monitoring, Lab, Export and Inventory Item Coding Systems in Oracle Forms & reports (10g)
Deployment of customized applications on Application Server
Oracle Email Alerts Procedures
Interfacing with Oracle EBS using DB-Link
Responsible for coding and maintaining PL/SQL package, procedure, and function
Creating database triggers according to business need
Developing and maintaining Oracle forms according to User needs
Gap analysis, Perform initial design reviews and recommend improvements
Web Development
Development of Management Dashboards based on different standard(EBS R12) and customized applications
Development of Online Leave Process, Daily Financial Highlights and Production processes review
Dashboard approval Notifications & Alerts
Development of auto SMS Alerts via registering Cron Jobs
Assist Team Lead in deployment, monitoring, maintenance, development, upgrade and support of all IT applications
Provide day to day technical support to staff
Analysis and discuss business requirements with end user
Work with business team to get brief data about requirement and translate requirements into technical specifications
Worked on various modules at technical level like dispensary, financials, supply chain, Production, HR, Vehicle in Oracle Forms & reports (6i)
Coding SQL, PL/SQL, stored procedures, functions, triggers and packages