MAHBUBUL HUQ

** **** ****, **** *********, NJ ***16

Home phone: 732-***-****; Cell: 908-***-****

iyfcvi@r.postjobfree.com

PROFESSIONAL SUMMARY:

• Have a Master’s Degree in Information Technology Management with over 12 years of expertise as a Senior Programmer Analyst utilizing the DB2, MODEL 204, ORACLE, VSAM data bases. Have 4+ years of Business Analyst background with efficiency in performing requirements gathering, preparing Business, Functional, and Technical Requirement documents and in completing systems analysis. Involved in the development of many business processes from inception to completion adhering to SDLC. Have experience with Waterfall and Agile SDLC methodologies like SCRUM, and familiarity with RUP and XP (Extreme Programming). Prepared USE CASE, Sequence, and Activity Diagrams using IBM Rational Rose. Have Very good experience in Data Base conversion. As a Sr. programmer Analyst, participated in processing ACH, EFT, and Credit and Debit card transactions. Knowledge of various modules of accounting software.

• Proficient in designing, coding, testing, debugging and implementing online and batch Systems using MODEL 204 User language and other technologies like COBOL, DB2, VSAM, and CICS. Supported, maintained, and enhanced the existing COBOL/DB2, DYL 280, and MODEL 204 programs. Worked on development and maintenance of various applications to meet business requirements. Designed screens, analyzed requirements and proposed files. And applied knowledge of data structures, data modeling to assist in the design of complex systems integrating various programs, files and data structures.

• Highly skilled in assisting for new functionality development, and in knowledge transfer of systems and business programming and business logic to all levels of development teams. Prepared Traceability Matrix, prepared and created significant Use Cases, wrote test cases, performed debugging and actively worked with the QA analysts to make sure that all the functionalities were working as was required by the users and all is within quality control.

• Participated in the analysis, design, development, testing and implementation of multiple systems and assess performance and recommend efficiency measures. Executes excellent communication skills both written and verbal, with the end users that can facilitate the understanding of the approach taken by the users and to be taken by IT. Has good ability to build and analyze workflows and identify opportunities for improvement within the project life cycle. Has ability to work under pressure and minimal supervision, detail oriented, and at ease in working in a team environment.

• Heavily participated in migrating data from Legacy data bases (MODEL 204, DB2) to oracle and Sybase data bases. These projects included information gathering, writing BRD and FRD, discuss with Data Modelers about data requirement help QA analyst preparing test cases using Use Case diagrams.

TECHNICAL SKILLS:

Databases: DB2, ORACLE, MODEL 204, VSAM, and Flat File

Languages: MODEL 204, SQL (DB2), COBOL, SQL PLUS, PL SQL, DYL 280, and COMMAND LEVEL CICS, UNIX Shell Script

Software: SPUFI, QMF, JCL, TSO/ISPF, IBM UTILITIES, MQ, Ice Tool, File Aid, SAR, Expeditor, Sync Sort, Changeman, IBM Debugger, Microsoft Office, and Visio, Informatica, UML, IBM Rational Rose. Good knowledge of COGNOS reporting tool and IBM Rational Suite.

Platforms: IBM OS 3090, MS Windows, MS Access, UNIX

PROFESSIONAL EXPERIENCE:

Wells Fargo

Business Analyst

June 2011 to August 2011

Responsibilities and Accomplishments:

• Participate in Wells Fargo’s project, which will replace the old Wachovia’s IVR (Interactive Voice response) system with new and enhanced Wells Fargo IVR system.

• Waterfall SDLC methodology was used for this project development.

• Perform requirement gathering, prepare Business Requirement Document and Project Definition Document (PDD) and complete systems analysis.

• Write APIs (Application Programming Interface) and corresponding Use Cases. These APIs and Use Cases will be used by the developers in order to understand the flow of information from the client to middleware to database and information that will be returned to the client.

• Co-coordinated between team members and the user group.

• Interview SMEs in order to properly understand the business rules, which will in turn be helpful for the developers in developing the application.

• Work as Project sizing Coordinator and help the system manager in managing the time invested by the resources in developing the application.

Employment Gap

December 2010 to June 2011

• Continued studies while actively looking for opportunities.

UBS Financial, Weehawken, NJ

Senior Business Analyst / Senior Programmer Analyst

August 1996 to December 2010

Senior Business Analyst (March 2006 to December 2010)

Responsibilities and Accomplishments:

• Used Waterfall methodology and Agile SDLC methodologies like SCRUM, RAD in building users’ required systems.

• Performed requirement gathering, prepared Business Requirement Document and Functional Requirement Document and complete systems analysis.

• Worked as senior Business Analyst in the project that built a Data Mart (DM) to be used to market and promote UBS Credit cards. This project was built using Informatica technology. SCRUM SDLC methodology was followed in building this Data Mart.

• Worked as a Business Analyst in the project which built data reconciliation system between UBS and First Data (FDR). This system would identify any information inconsistency between UBS and its credit card transaction processing company FDR. Waterfall SDLC methodology was used to build this system

• Worked as Business Analyst for the project at UBS, which built an Enterprise Data warehouse for various reporting, data mining.

• Worked as business analyst in data base conversion project where data was converted from DB2 to ORACLE. This project required data analysis, data mapping, and data transformation. During the period through both the old and new

• Participated in conversion of main client data base from MODEL 204 to DB2. Project involved data analysis and profiling in order to eliminate any unnecessary and unusable data before it was converted to the new system. Process also required data to be mapped from the old to the new system.

• Prepared dataflow diagrams using Visio.

• Strived to make business processes more efficient by modifying and improving those.

• Prepared Statement(s) of Requirements (SoR) in order clarify the goals and objectives of the project(s). Also in the SOR would be included a clear picture of the functionalities of the system that the users have asked to modify or build. It also would contain the list of deliverables with time lines, cost drivers and cost estimates.

• Worked as Sr. Business Analyst for the migration project that moved data from legacy systems like DB2 and MODEL 204 to Oracle.

• Participated in data base and application conversion at UBS whenever UBS would acquire a new company or had a contract to service client data base belonging to smaller brokerage firms.

• Interviewed SMEs for proper understanding of the Business Requirement.

• Co-coordinated between team members and the user group.

• Prepare and maintain documentation to show that proper adherence was given to all financial regulation and all applications compiled with applicable regulations.

• Ran JAD sessions in order to remove obstacles that stood between the developers and the users and to resolve requirements and design issues.

• Prepared Requirement Traceability Matrix, Functional Traceability Matrix, prepared Use Cases.

• Prepared and Test Cases and Test Scripts.

• Performed manual Black Box and White Box Testing.

• Participates in the testing process, ensuring that the application satisfies all user requirements.

• Developed USE CASES that were to be used by the developers and QA analysts. These USE CASES also would help prepare Test Cases. Used Rational Requisite Pro to rack and modify requirements, test cases etc.

• Used SQL Plus to write query in order to profile and cleans data. Also used SQL Plus to compare source and resultant data in order to justify that data transformation was done properly in EDW building projects.

• Conducted UAT (User Acceptance Test).

• Wrote and ran UNIX shell script using KORN SHELL.

• Worked continually to improve the quality and efficiency of business systems. Aided system mangers in managing projects.

• Ensured that proper system change documentation was done and maintained.

• Did Requirement gathering and co-ordinated SCRUM session for EDW project for Credit/Debit card customer data base, which would help market various incentive programs. This Data Warehouse was built using Informatica ETL tool. Helped Informatica developers with proper explanation of the requirement.

• Analyzed, profiled and scrubbed source data for EDW project.

• Co-ordinated the meetings between developers and data modelers.

ETL Developer (January 2005 to February 2006)

Responsibilities and Accomplishments:

• Responsibilities include designing the documents which is based on the Business Requirement specifications.

• Done extensive testing and wrote queries in SQL to ensure the loading of the data.

• Perform unit testing at various levels of the ETL.

• Used SYBASE Power Designer for ETL function in building Credit and Debit card usage Data

Mart.

• Debug the sessions by utilizing the logs of the sessions.

• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.

Senior Programmer Analyst (July 1996 to January 2005)

Responsibilities and Accomplishments:

• Created Functional and Technical Specifications from Business Requirement Document.

• Designed, coded, tested, debugged and implemented online and batch Systems using MODEL 204 User language and other technologies like COBOL, DB2, VSAM, and CICS.

• Participated in developing ACH, EFT, Credit card, and Debit card processing applications.

• Supported, maintained and enhanced the existing MODEL 204 programs.

• Guided and managed the development work of junior programmers with focus on cost effective yet efficient system development.

• Participated in Disaster Recovery system at remote data storage and processing facilities. Production support on periodic basis.

• Designed screens and developed online application using MODEL204.

• Designed screens (User Interface) and developed online application using CICDS and DB2 database.

• Contributed in building Cash Management Bridge system using COBOL and DB2, and VSAM.

• Participated in designing and building the new Credit and Debit card Transaction system for UBS Wealth Management using COBOL, DB2, and MODEL 204.

• Co-managed Electronic Fund Transfer (EFT) and Bill Pay system built using MODEL 204, DB2, and COBOL.

• Built UBS’s Client Statement House-holding system using MODEL 204 database and user language. At later date, lead the re-writing of whole House-holding system using COBOL, DB2, VSAM, File Manager and flat files.

• Participated in writing the batch part of web based Client Account Information system using COBOL, BD2, and Stored Procedures.

• Designed screen and Built online customer information reconciliation system in order to remedy the discrepancies in customer data between UBS and its Credit/Debit card processing vendor (FDR). This required data to be fed to FDR system multiple times a day.

• Had been involved in development of many business processes from planning to implementation adhering to SDLC (and UBS’s in-house ADP).

• Participated in Disaster Recovery system at remote data storage and processing facilities.

New York State Government Department of Housing, Albany, NY

Programmer / Analyst / Rent Examiner

April 1993 to June 1996

Programmer/ Analyst

Responsibilities and Accomplishments:

• Worked on development and maintenance of various M204 Applications.

• Designed and coded MODEL 204 programs. Also tested and implemented procedures.

• Coded, tested and implemented the online Edit, Review and Verification Subsystems for ongoing Housing Projects.

• Wrote COBOL programs to read and update VSAM and flat files.

• Participated in enhancement and maintenance of the Report Distributing Subsystems (RDS)

TRAINING:

Completed a course on Java, C, HTML and Perl

EDUCATION:

• Master’s Degree in MIS in Information Technology Management, Stevens Institute of Technology, Hoboken, NJ.

• Master’s Degree Geological Sciences with concentration on Geophysics and Field Mapping, Dhaka University, Dhaka, Bangladesh.

• Bachelor’s Degree in Geological Sciences with Physics and Mathematics as minor, Dhaka University, Dhaka, Bangladesh.

Contact this candidate