About Me
Create Crystal Report Version (10), (11), (2008). Design Production/Development Report for (SIT,UAT,SAT) Create Dashboard Oracle Report (Crystal Report Version 11) for Dashboard server. Business Objects Enterprise (BO) Monitor, Maintain, User Rights,...t Version 11) for Dashboard server. Business Objects Enterprise (BO) Monitor, Maintain, User Rights, View/Design, Generate Central Management Console (CMC) Monitor, Maintain, User Rights, View/Design, Generate Business Object (BO) Monitor, Maintain, User Rights, View/Design, Schedule, Generate. Installation troubleshooting/tuning TOMCAT, CMS in Business Objects server Develop Visual Studio SSIS Project. Testing SSIS Project by SQL DB Server. Oracle Query Design Web-Base Report, schedule and generates Transfer Oracle/SQL Report via FTP path to Tradeport Server VPN Online PSS Production Support, troubleshoot in machine/system Lighthouse (LH) project reports schedule and transfer to FTP server path. Migration system/object and reports to Production/Testing servers Monitor Bank Batch Files from IMEX-Mainframe. Run Batch In SQL server (DB Server) for (SIT,UAT,SAT) ISIS Business Objects OpenSSH files convert and transfer to user path. Support for SIT, UAT, SAT, Production. Develop & Implement New Projects rollout. BMC Remedy Incident Ticket, Accept and Resolve issue user/client raised. Engage with ATOS BI, Wintel, TCC2 team includes scheduling, coordination, testing and production planning. DR Drill and Backup & Maintenance DB Application Software knowledge Business Objects Enterprise XI (TradePort) and (Dashboard) Oracle Report Design SQL Server 2005 Integration Services (SSIS) Microsoft SQL Server 2005 Business Intelligence / Development Studio Crystal Management Console Microsoft Visual Studio 2005 / Microsoft SQL Server 2005 BMC Software Remedy SDMS Web Client server Crystal Reports version 10, 11, 2008 Oracle Developer 11G RESPONSIBILITIES: Design Crystal Report version (10 & 2008) by using SQL command and query by used View and Master Table for Wholesale Banking Trade and Financial Report for global bank user or client base on their requirements. Generate Crystal Report daily, monthly, yearly basis. Creating Crystal Report version (11) Dashboard Oracle Report and schedule/Design in Dashboard TradePort server. Monitoring daily workflow, IMEX batch files from Mainframe. Monitoring Daily workflow for Mainframe bank batch files. Batch job complete automatically and will create IMP_OK event create and Reports generates in BO server. Error in batch will be detect and amend, resolve the error with 0 defect delivered to user/client due operating Business. Administrator rights of Business Object (BO) of Central Management Console (CMC). Create DB ID for bank user to access in database production server for connects via ODBC with specific country database for creating or design crystal report. Create user ID and Password in Business Object (BO) of Central Management Console (CMC) for access into BO for designer viewer to schedule and download the report. Re-set and enable ID and Password if there any DB server or BO server ID and Password locked, disable, blocked by Administrator. User raised service request Ticketing System (Remedy) via ITSC assign to PSS group for any requirements and issue will login and immediately have to resolve by VNC or provide solution for application, create new report base on user request. VNC and troubleshoot user/client server or machine by used IP address and identify and resolve network incidents for users/clients. Manage Development/production/implementation of IMEX systems for clients/users of bank. Transfer Mainframe files via using ISIS application by Business Objects OpenSSH application. Transfer Oracle/SQL Query Crystal Report via FTP path to bank user. Support IMEX_RG System products for daily, weekly, monthly, yearly for banking user business operations. Monitoring for IMEX-RG system for Client Management System, Trade and Finance Reporting application. Maintaining and guide internal IMEX system user and external bank user on system functionality Engage with bank user, business analyst and development team for enhancement and development. Configure and Support to meet SLA, AIG, ASRM, KPI, KL Series, Implementation Plan, HUSA, ITSC defined for system maintained and development. System functionality trouble-shooting in user or client system. IMEX-RG report analysis support and data configuration for ODBC. Support and participate in (SIT-Systems Integration Testing), (SAT), (UAT- User Acceptance Test) new releases enhancement, implementation, testing and production. Accomplish Project: Completed projects (SSIS) for delivered 1 month ahead of schedule kin production. Project Name: SSIS Client: SellHeavyMach.com, Boston, USA Duration: Oct 2008 to Feb 2015 Role: Team lead Team size: 3 Software and Platform: NT, SQL Server, IIS, FrontPage, Visual Interdev, Rational Rose Other Skillset used: VC++/COM, ASP, SQL, UML
Show More