Project System

MANVEER SINGH PABLA

** ******* **, *******-***-Ormeaux, Quebec

Email: abqdxa@r.postjobfree.com Ph. No. - 514-***-**** 416-***-****

Summary

Skilled System Analyst with more than 6.5 years total experience in Information Technology, of which 3.5 years as Business System Analyst is in Banking and Financial Services Industry (BFSI).Intensively worked in Core Banking System- Implementation, Production Support, New Change Request, Operational processes.Extensively involved in System Analysis, Client-Server Software Architecture, Application Design, Development and Implementation of database systems.Understanding of various interfaces of Core Banking System like Base24, Card Management System, Middle Ware and other banking systemsGathered business requirements by conducting detailed interviews with business users, stakeholders and Subject Matter Experts (SMEs).Experience in management of requirements throughout the Software Development Life Cycle (SDLC).Co-ordinate with user and development teams to organize and manage daily operational activities and provided functional support to Banking Operations Assist in testing, deploying and validating the Service pack in production.Good communication and interpersonal skills. Effective team leader with good knowledge of task distribution among available resources.Ability to work as a team player and as an individual, Self-motivated, quick learner.Extensive skills experienced in RDBMS on PL/SQL Packages, Functions, Procedures & Triggers to implement the business logic.Experience in reporting through business objects, crystal reports, SSRS, SQL*plus from ODSA and data warehouse

Professional Experience

Client: Capital-G Bank

Sigma Global Solutions Mar 11 – Sep12

Project: Core Banking Maintenance

Title: System AnalystCoordination with business and vendor for Customization of the system for specific products/services.Vendor communication for all kind of system requirement, implementation and issue resolution.Co-ordination with business users for requirement gathering.Involved in Core banking, CRM, Treasury and e-banking applications support activitiesChange management activities as per latest industry practice.Gather requirements and involved in the Data mapping activity to generate Financial and Historical reports using SSRS.Core member in the project team to resolve Retail and corporate banking issues.Raised bugs on issues, which are not functioning as per the requirement and then co-ordination of patch installation and testing, to ensure existing functionalityInvolved in the UAT Testing of the software during fixesCo-ordinate with banking support and operational teams to resolve an issue in daily operationsTrack down all issues, solutions and changes done on the live-time system.Co-ordination of interfacing of various existing systems to Finacle.

Client: Emirates National Bank of Dubai, Dubai

Esquire Solutions LLC Jun 08 – Sep 10

Project: Core Banking Project ImplementationEmirates Bank International and National Bank of Dubai were among top banks in UAE before their merger to create the largest bank of the country, which is named EmiratesNBD. At the same time, the core banking system of the two banks was migrated to new state of art core banking system Finacle. This mammoth project was carried out in two phases, first from legacy EBI's core banking system Equation to Finacle and then from legacy NBD's core banking system BANCS to Finacle.

Title: Business System AnalystDeeply involved in the implementation with various task relating to development and testing of technical and functional aspects.Business team and Vendor coordination for Customization of the system for ENBD specific products/services.Worked with senior Business Analysts to determined user/business/functional requirements. Created use case documents; business process models, use case diagrams, activity diagrams.Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues.Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).Involve in the system design and operation procedural documentsCo-ordination with business users for the requirement gathering.Change management activities as per latest industry practice.Reporting for the reconciliation purposesCo-ordinate to schedule the financial jobs and operations activity like EOD, BOD, statement generation, central bank transfer, etc.Prepared rollout strategy and efficiently planned the go-live activities to align with larger project dates and deliverables.Co-ordinate with Vendor to resolve the post-live opened issues.Provided support to trained the users after go-live.

Client: Pearson Education Technologies Chandler

Esolutionz Canada Aug06 - May 08

Pearson Success Maker EnterpriseThis project is based on E-Learning Application developed by Pearson Education system Project development and testing environment deployment on internet via Web logic clustering, using web service like apache, has physical load balancer, has an oracle database, which is on Solaris environment. This project functionality is to registration of the student and teacher and courses for the student as per the standard.

Title: Sr. DeveloperInvolved in developing SQL *Loader scripts for data loading.Developed PL/SQL Packages, Functions, Procedures, and Triggers to implement the Business Logic.Discussion with customer to understand the requirement and analysis.Involved in the optimization of Oracle queries/scripts which resulted in substantial performance improvement for the conversion processes using Oracle Hints, Explain plans and Trace sessions.Debug the PL/SQL Procedures, functions code with the help of Oracle Packages and third party tools.Worked with DBA team to rebuilding the index to increase the performance.Extensive on PL/SQL Tables, records and collections as per the business requirement.Involved in Technical Documentation, Unit test, Integration test and writing test plan.Used Shell Scripting to automate and schedule job.Written PL/SQL programming for reports, Bug fixes.Involved in capacity planning and enhancements.Coordinated with UNIX group for space reclamation on Server by reorganizing the tablespaces.Worked on Change Management tools like Clear Case and Remedy for controlling, Tracking and monitoring Production environment changes.Meet the client and understand the requirement and timeline for the each module.Worked on reporting with the help Visual Basic.Worked with DBA team on index monitoring and rebuilding.Worked on Setting Integrity Constraints.Involved in code reviews of other team members.Creating workflows and Workflow Process.

Client: ICICI BANK

3i-Infotech Ltd. Jun 05 - Jan 06

Web Bounce Management System (WBMS)Web bounce system is designed for tracking bounce cheques details against the bank statement. Various MIS are getting generated through this application as an input to other applications like Finnone and RECON. For e.g. the bounce cheques details are downloaded from Web bounce system and uploaded to Finnone to mark cheque return in individual retail Loan accounts to levy the charges.

Title: DeveloperCreated Stored Procedures, Packages, Functions, database Triggers for the Retirement info module and for reconciliation. Developed SQL queries to fetch complex data from different tables in remote databases using

Joins, database links and Bulk collects. Also wrote complex code for error handlingDeveloped, implemented and unit tested Invoice Order Interface. This involved importing data from the legacy system into staging tables using SQL Loader, validating the data using PL/SQL procedure.Support multiple applications simultaneously.Co-ordinate with DBA for Installation of Oracle software on different platform.Co-ordinate with UAT team and different platform teams to resolve issue.Supported production environment on 7*24 bases for Extraction, Loading Developed database triggers required for the Integrity constraints.Participated in application planning, design activities by interacting and collecting requirements from the end users.Assisting team members in troubleshooting.

BKP-Consultants Mumbai Jun 04 – Jan 05

NAT (Network Analysis Tool)NAT is product of BKP-Consultants that is based on GSM and CDMA technologies. NAT is Network Analysis Tool that works on the OMCs of the MSC for the telecom vendors. Like Tata, Tele Services and Hutch, NAT is used by the telecom vendors for generating various reports that helps for the network analysis and managerial decisions.

Title: Developer Monitoring database using Oracle Enterprise Manager or TOAD (Tables paces, Data files, Jobs, Users, sessions, Processes).Creation of database schema, Roles, Table spaces, Rollback Segments with DBA team.Developed complex queries for reports.Gathering business requirements from client.Involved in Efficient Configuration of Access Policies through Roles and Privileges.Involved in capacity planning and enhancements.Coordinated with UNIX group for space reclamation on Server by reorganizing the tablespaces.Managing Partitioned tables and Indexes for efficient and robust access of database objects.Wrote automated scripts for tracking and validating invalid objects in Database.Coordinated with business consumers of data to formulate Backup Schedules.Worked on Change Management tools like Clear Case and Remedy for controlling, Tracking and monitoring Production environment changes.

Technical Skills

Languages

PL/SQL, SQL, Java

Databases

Oracle 9i/10g, SQL Server, MS Access

GUI / Tools/Utilities

MS Office, Visio, SQL* Loader, TOAD 8.0/7.1, PL/SQL Developer, OEM (Oracle Enterprise Manager), EXPORT/IMPORT, Data Pump, SQL* PLUS, Business Objects, Procedure Builder, SSRS, Control M

Operating Systems

Unix/Linux,Windows

Scripting

Unix Shell Scripting.

EducationBachelor in Computer Science from MIT (Mandsaur Institute of Technology), Mandsaur, INDIA.

Certification Emirates NBD Core Banking Implementation.

Reference: Available upon request.

Contact this candidate