Database Developer
Accion Labs [Client: Amway]
مجموع سنوات الخبرة :13 years, 7 أشهر
+ Development & Maintenance for SQL & DB2 Stored Procedures for integrating new applications with the legacy systems.
+ Requirement Gathering.
+ Performance Tuning.
+ Working with XML Payloads.
+ Co-ordinate with middleware (Inubit) to provide the Validated Data and further Downstream applications.
+ Development & Maintenance of BISM (Tabular Model), SSIS Packages.
+ Requirement gathering from the business and providing the optimal solution.
• Development & Maintenance for SSIS Packages / SSRS Reports / MS-SQL Stored Procedures.
• Job Monitoring via Control-M.
• Baan Administration:
- User Management: Create / Delete / Modify Users on Test & Production Environments.
- Data Refresh from Production Server to Test Server which includes transfer of huge oracle database files.
- Solution Management \[PMC\]: Installation of Solutions on Test & Production Environment
• Automation of File Transfers for Data Migration via SFTP between UNIX Environments with logging.
• Data Correction for Clients on Production Environment using Exchange Schemes.
• Generation of Data Reports using SQL Queries.
• Baan:
- Developer and Maintenance for Infor LN FP3, FP6, FP10 formerly known as BaanERP.
- Worked on Infor Tools:
- Sessions, Scripts, Reports, Tables, File IO, Import/Export Tables \[Sequential Dumps\], Solutions Management \[PMC\], Patches.
- Designed PDF conversion from Infor reports for Customer Portal.
- Maintenance of Data Extraction for BI.
• SSRS:
- Integrating Infor with SSRS to print Reports that do not fit the Standard Infor Reports.
- Designed Reports in SSRS and integrated it with Infor LN.
- Developed Stored Procedures in Oracle, MS-SQL and DB2 for SSRS.
• VB.NET:
- Utility to migrate the Data Dumps from Baan 5c to Baan LN.
• Developed a Utility to create the XML file of the Chat history and mail to the Administrator.
• Developed functionality to integrate the Chat Tool with ASP.NET clients via php-ODBC driver.
• Installation of APE (Ajax Push Engine) Server on a cloud.
62.00 %
76.72 %
65.46 %