About Me
- Over last SIX years as DB developer/Technical Manager (Total 14 years plus as Business
Application Developer) having Hands on experience in developing, Testing, maintaining and Enhancement of...
- Eight years as Client /Server (PowerBuilder and various DB as back end) developer.
- Responsible for development, support, maintenance and implementation of a complex project module
- Experience to perform all cycles of the development (analysis, design, coding and unit testing) projects
- Five Years, as ORACLE PL/SQL and MS SQL Server T-SQL developer/production Support.
- Knowledge of Data warehousing concepts (ETL/ CUBE/DIMENSION/ SCHEMA)
- Basic UNIX shell scripting
- Good expertise in software development in client/server technologies, Using Leading RDBMS and PowerBuilder (PFC based Framework), Developer/ 2000 and Oracle PL/SQL.
- Orchestrated complex systems and business rules.
- Demonstrated a deep understanding of PB/DB technology
- Provide technical expertise in identifying, evaluating, and developing effective procedures and systems requirements that meet business requirements.
- An innate ability to bring people together
- Exposer to Logistics Solutions & Supply Chain Management
- Experience in developing and implementing Enterprise resource Planning (ERP- Order Management, Material Management, HRMS, Supply chain Management, Inventory Management, Logistic Management) solutions.
- Knowledge of Oracle EBS-Purchasing process.
- Knowledge of SAP-SD(Trained) Module’s process/Flow
(Inquiry/Quotation/Order Acceptance/Delivery/ Billing/ Invoice doc etc).
- Worked for SEI CMM Level 5 Company in overseas and INDIA.
- Good domain knowledge of business processes in manufacturing Industries, SCM ,HRMS, US HealthCare(Patients, payers, providers ) Domain and General Retails. Energy & Utility (Upstream, Downstream), Asset Managements and Benefits Fund Managements
- Involved in the development of test cases and executing the test cases.
- Strong comprehension, analytical and problem-solving Programming skills
- Good in Data Analysis for decision making by the business.
- Extensive technical experience and strong programming knowledge in Oracle 12c using SQL Developer, PL/SQL Developer and Toad
- Experienced in writing back end interfaces using PL/SQL , Packages, Stored Procedures, Functions, Indexes, Views, Exceptions and Advanced Features Bulk Collect, Forall, CTE ,Merge, Materialized View etc.
- Expertise in use of Cursors, Ref cursors and Collections.
- Knowledge in Logical Database Backup and Recovery using Export/Import Utility
- Ability to understand Functional Requirements and Design Documents. Understand relationship across multiple applications
- Good experience with CRUD (Create, Read. Update & Delete) data cycles.
- Scheduling various automated JOB.
- Monitoring various JOBS
- Ability to work in Offshore/Onsite model and Offshore co-ordination skill
- Provided training on PowerBuilder V12.5
Data Migration Exposed:
- Requirement analysis with Client.
- Over last SIX years as DB developer/Technical Manager (Total 14 years plus as Business
-
Application Developer) having Hands on experience in developing, Testing, maintaining and Enhancement of the database application. Detailed understanding of Maintenance activities, QMS processes and Good knowledge of SDLC lifecycle (analysis, design, development, implementation, integration and testing) and Methodologies preferably Agile
- Eight years as Client /Server (PowerBuilder and various DB as back end) developer.
- Responsible for development, support, maintenance and implementation of a complex project module
- Experience to perform all cycles of the development (analysis, design, coding and unit testing) projects
- Five Years, as ORACLE PL/SQL and MS SQL Server T-SQL developer/production Support.
- Knowledge of Data warehousing concepts (ETL/ CUBE/DIMENSION/ SCHEMA)
- Basic UNIX shell scripting
- Good expertise in software development in client/server technologies, Using Leading RDBMS and PowerBuilder (PFC based Framework), Developer/ 2000 and Oracle PL/SQL.
- Orchestrated complex systems and business rules.
- Demonstrated a deep understanding of PB/DB technology
- Provide technical expertise in identifying, evaluating, and developing effective procedures and systems requirements that meet business requirements.
- An innate ability to bring people together
- Exposer to Logistics Solutions & Supply Chain Management
- Experience in developing and implementing Enterprise resource Planning (ERP- Order Management, Material Management, HRMS, Supply chain Management, Inventory Management, Logistic Management) solutions.
- Knowledge of Oracle EBS-Purchasing process.
- Knowledge of SAP-SD(Trained) Module’s process/Flow
-
(Inquiry/Quotation/Order Acceptance/Delivery/ Billing/ Invoice doc etc).
- Worked for SEI CMM Level 5 Company in overseas and INDIA.
- Good domain knowledge of business processes in manufacturing Industries, SCM ,HRMS, US HealthCare(Patients, payers, providers ) Domain and General Retails. Energy & Utility (Upstream, Downstream), Asset Managements and Benefits Fund Managements
- Involved in the development of test cases and executing the test cases.
- Strong comprehension, analytical and problem-solving Programming skills
- Good in Data Analysis for decision making by the business.
- Extensive technical experience and strong programming knowledge in Oracle 12c using SQL Developer, PL/SQL Developer and Toad
- Experienced in writing back end interfaces using PL/SQL , Packages, Stored Procedures, Functions, Indexes, Views, Exceptions and Advanced Features Bulk Collect, Forall, CTE ,Merge, Materialized View etc.
- Expertise in use of Cursors, Ref cursors and Collections.
- Knowledge in Logical Database Backup and Recovery using Export/Import Utility
- Ability to understand Functional Requirements and Design Documents. Understand relationship across multiple applications
- Good experience with CRUD (Create, Read. Update & Delete) data cycles.
- Scheduling various automated JOB.
- Monitoring various JOBS
- Ability to work in Offshore/Onsite model and Offshore co-ordination skill
- Provided training on PowerBuilder V12.5
-
Data Migration Exposed:
- Requirement analysis with Client.
- Analysis the source data from legacy system dump.
- Migration Process analysis and define the migration strategy.
- Analysis output table details and define the validation rule.
- Implementation of business logic.
- Generate script and output data.
- Analysis the source data from legacy system dump.
- Migration Process analysis and define the migration strategy.
- Analysis output table details and define the validation rule.
- Implementation of business logic.
- Generate script and output data.
Skills
Programming Language
Operating System
Others
Database
Development Tools
Software Engineering
Web Development
Portfolio Projects
Company
: Power Plan - ERP Product(OIL and GAS Midstream )
Description
- Systems environment : Windows 7, Power Builder V12.5, PFC,, Oracle11g (PL/SQL). UNIX, Toad.
- Synopsis:
- Enterprise System for Projects and Fixed Assets Modules include Budgeting, Funding Projects,Assets management (Fixed Assets and Capital Assets), Tax (Power Tax), work order Management, Depreciation. The System also has Datawarehouse like Charge Repository Module.
- This system also has inbound and outbound interface with ORACLE ERP, PEOPLESOFT HRMS and IBM Maximo Enterprise System.
Tools
Oracle 11g PL/SQLCompany
SIDF
Description
Project #3
- Industrial License DB Management System.
Add new License Record.
Amendment /Modify the License Record.
Purge License Record.
Enhance user Data entry experience.
Role:
· Programming & Development and Unit test
Tools:
· PowerBuilder 12.5, MS-SQL 2008
- Lomis Application(Banking Domain) -
Role:
· Programming & Development
Tools:
· PowerBuilder 12.5, MS-SQL 2008
Details:
· The Lomis applicstion is an in-house developed system for SIDF (Saudi Industrial development fund). SIDF is one of the reputed government bank in Saudi Arabia.
· Lomis application is help to maintain and keep track of industrial sector to see the growth of industrialization in Saudi Arabia.
· Application helps to maintain details about investors and their follow up fees.
· Help to find Progress in Number of Factories, Investment and Number of employees, industrial production, and industrial exports.
· Easy to generate relative report.
- Payroll System (HR Domain) –
Role:
· Programming & Development
Tools:
· PowerBuilder 12.5, MS-SQL 2008
Payroll System:
· It keeps and maintains record of all employees and their history.
· It’s easy for HR to operate and process salary.
· Flexible to maintain overtime salary, housing allowance, transportation allowance, increment etc.
· Linked with attendance system and calculate overtime and penalties
Show More Show LessSkills
SQL Oracle 11gTools
powerbuilderCompany
INFO CARE
Description
InfoCare serves as the pre-enrollment, annual fulfillment and reconciliation system for Government Programs’ Medicare Advantage Plans (Keystone 65, Personal Choice 65 and Amerihealth 65). Additionally, InfoCare supports the Medicare Discount Drug program for these plans and will also support Amerihealth 65 PA. An interface has been built with SMS (Systems Management Specialists), a vendor for CMS (Center for Medicaid and Medicare Services, formerly HCFA), to submit enrollment, plan change, and disenrollment transactions. Based upon the CMS response, letters are created for the members and where appropriate, the members are sent to MHS via EDI. Every year, the annual fulfillment sub-system is used to track and update benefit changes for groups and to notify benefit administrators and members of the changes to their benefits. Finally, Info Care is used to reconcile membership, status and demographic factors between CMS and our enrollment systems.
Show More Show LessSkills
Oracle 11g OracleTools
powerbuilderCompany
INfocare
Description
InfoCare serves as the pre-enrollment, annual fulfillment and reconciliation system for Government Programs’ Medicare Advantage Plans (Keystone 65, Personal Choice 65 and Amerihealth 65). Additionally, InfoCare supports the Medicare Discount Drug program for these plans and will also support Amerihealth 65 PA. An interface has been built with SMS (Systems Management Specialists), a vendor for CMS (Center for Medicaid and Medicare Services, formerly HCFA), to submit enrollment, plan change, and disenrollment transactions. Based upon the CMS response, letters are created for the members and where appropriate, the members are sent to MHS via EDI. Every year, the annual fulfillment sub-system is used to track and update benefit changes for groups and to notify benefit administrators and members of the changes to their benefits. Finally, Info Care is used to reconcile membership, status and demographic factors between CMS and our enrollment systems.
Show More Show LessSkills
Oracle 11g OracleTools
powerbuilder