Senior Technical Consultant
NBAD
Total des années d'expérience :20 years, 10 Mois
Responsible for:
• Developing a Data Migration and Data Integration solution for the credit application data from current systems to the new system adopted by the Bank
• Participating in the technical discussions with the vendor and propose solutions for data mapping and transformation challenges
• Facilitating Go Live activities and providing post Go Live production support
Main Accomplishments:
Algo Credit Manager (ACM) Project (A vendor solution by IBM):
A workflow system to manage the Credit Origination & Approvals, facility/limit activation & credit risk data analysis
• Created SSIS packages to successfully customize and migrate the credit application data including the counterparty details, facilities, limits, collaterals, assets, covenants and documents from Fact, Murex and LeaseFlex to ACM
• Analyzed the production issues and provided the best technical solutions in timely manner
Responsible for:
• Application Design including UI, Business layer, Data access layer, Security Authentication & Authorization
• Database Design including Tables, Views, Entity relationships, Functions, Store procedures and Indexes
• Application Testing including, Unit testing, System Integration testing, User Acceptance & Quality Assurance testing
• Leading, guiding and coaching the other developers in the team
• Participating in the design discussions and proposing technical solutions for the client’s requirements
• Providing technical input for vendor / solution selection as per business needs
• Document management, preparing technical documents for the design, implementation and deployment
• Project planning, creating project schedules and assigning tasks to the development team
• Managing implementation, maintaining application source code control and creating release packages for deployment to SIT, UAT and Production
• Facilitating Go Live and support activities with relevant teams
• Vendor & Business user management, providing application maintenance support
• Setting up and maintaining the Business Intelligence solutions, creating and deploying the report templates
• Issue management, identifying, Analyzing, fixing, logging and tracking application defects
• Change management, coordinating with the relevant teams for any software and/or hardware upgrades
• Business Continuity and Disaster Recovery Management, Participate/Lead the BCP and DR activities
Main Accomplishments:
PRDR Project (BMO In-house solution):
A reconciliation and dispute resolution system for margin calls as per DFA and EMIR regulation
• Led an application development team through a full SCRUM/Agile hybrid Software Development Life Cycle (SDLC) to convert the existing MS Access and Excel application to a .NET MVC4 web application with SQL server 2012 database, SSIS ETL and SSRS business intelligence solution and WCF Web Service for a real time data fetch requirement
• Created the application deployment guides and coordinated with the relevant teams for a complete UAT/QA testing and implementation to Production
DG Project (BMO In-house solution):
It is a documentation tracking system used for Capital Markets ISDA and REPO master agreement with counterparties
• Led an application development team through a full Prototype hybrid SDLC to convert the application from an existing ASP architecture to the newer ASP.NET MVC3 architecture integrating it with an existing Oracle database and Crystal 2008 BIS which was also migrated from Crystal 8.5
TLM Collateral Management (Algo Collateral, Sentry) Project (A vendor solution by SmartStream):
An event-driven solution to manage the activities associated with OTC Derivatives, Repo and Security Lending Margining
• Planning, coordination and implementation of the application servers upgrade from windows 2003 to windows 2008 and database servers from oracle10g to oracle11g
• Successfully done the work effort estimation, development, testing and implementation of various enhancements and upgrades to the application including data feed changes and report template changes
• Pro-actively logged, analyzed and resolved the production issues
SAMU Project (BMO In-house solution):
It is a solution for problem accounts management and reporting
• Developed the ASP.NET web forms, ADO.NET data sets and SSRS report templates, SSIS Packages for data migration
• Successfully Managed the GO Live activities and Setup the SSRS BI solution integrated with the SAMU
CPARS Project (BMO In-house solution):
A system to reconcile expected & actual cash accounts in commercial credit cash A/C & General Ledger (GL) Systems
• Planed, scheduled and successfully implemented the server virtualization in coordination with the enterprise infrastructure team
• Developed the ASP.NET web forms, ADO.NET data sets, web service proxy classes & Report templates
Managed the Site Office activities to successfully deliver 3 major industrial and commercial construction projects