Project System
Resume:
Yawar Sherwani
**** ********* **, *******, **, N*G 3G7
*************@*****.**
SUMMARY
. Senior Business/System Analyst with over 20 years of experience in the
successfully managing requirements for large, complex technology projects
. A full range of experience in the component technologies using Unified
Modeling Language (UML), SDLC, SDM, JAD, Waterfall and iterative
development such as Agile, XP, Pair Programming and Future Driven
Development
. Highly proficient in creating documentation using Unified Modeling
Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams,
Class Diagrams and Sequence Diagrams
. Extensive experience in developing Use Cases, documentation of Test
Cases, conducting User Acceptance Testing (UAT) and expertise in
designing and developing Test Plans
. Expertise in detail Enterprise Development application analysis and
design, process mapping, process modeling, requirements gatherings
(Business Requirements Documents), data modeling, business rules, data
modeling, SQL, PL/SQL, business rules/CRUD Matrix procedures and testing
for 3-tier web application using Java,.Net technologies, client - server
architecture using Oracle, DB2, relational database design, J2EE,
Mainframe, and COBOL
. Have strong background in E-Commerce, SQL, SharePoint, Testing, and HP
Quality Center
. Have good experience working with on-site/off shore (Global Team Model),
and customer off the shelf software
. Highly motivated team player with excellent interpersonal, problem
solving, attention to detail, analytical, time and team management, and
self-organizing skills
TECHNICAL SKILLS
System Analysis and Design SLDC, ISLDC, UML, SDM, Waterfall, Structure
System Analysis, Soft Systems Methodology, Object
Oriented Analysis and Design (OOAD), JAD, and Agile,
XP, Pair Programming and Future Driven Development
Process and Data Modeling
Techniques: Data Flow Diagram (DFD), Business Integration Model(BIM),
People Model, Logical Data Model, Entity Relation
Diagram (ERD), Functional Decomposition, Organization
Model, Interaction Model, Workflow Model, Domain
Modeling, Flowchart/Process Model, Relational/input-
process-output, Event Model, Normalization, RDBMS,
UML, and Use Cases
Database: Oracle, SQL Server, SQL, PL/SQL, and DB/2, and MS Access
Workflow, Flowcharting, and Visio, SharePoint, WebEx, Power Point, RFF
Flow, Star UML, Excel,
MS Office Tools: Access, Word, Outlook, Lotus Notes, and Project
Web Development Tool: .Net using SQL Server, AJAX, ASP and C#, Java, J2EE,
XHTML, XML, CSS, JSP, and VB Script
Programming Languages: Java, C#, C, COBOL, FORTRAN and Pascal
Operating Systems: Windows and Linux, AIX, SCO UNIX
EDUCATION
. M Sc Management Sciences (Operational Research), Lancaster University ~
Lancaster, England:1996
o Majors in Management Information System, Management techniques
including Enterprise Resources Planning (ERP), supply chain management
and their applications in Business
. Internet Software Development (Java, J2EE, EJB, JSP, Oracle, SQL, PL/SQL,
XHTML, CSS, XML and XML technologies) - Post Graduate Diploma, Humber
College ~ Toronto, Ontario: 2002
. Associate's Certificate in IT Project Management, George Washington
University ~ Washington DC, USA: 2009
Professional affiliations
Member of Project Management Institute (PMI) ~ USA
Member of International Institute of Business Analysis (IIBA) ~ USA
Member of Canadian Information Processing Society ~ Canada
Member of Alumni Association of Management School, Lancaster University ~
England
PROFESSIONAL EXPERIENCE
Green Shield Canada ~ Windsor, ON Oct'11 - Dec'13
System Engineer / Sr. Business Analyst
Green Shield Canada is medical and dental insurance company. They deals
with Claims, Primary Care Physician, Health Care Spending Accounts,
Personal Sending Accounts, Provincials health care systems, Group Plans,
Individual Plans, etc.
Responsibilities:
. Developed User stories, Use Cases, Test Cases, Business Processes and
user Training Manual
. Developed Use Case Model, Activity and Class diagrams
. Developed current state/AS-IS State
. Developed future state/TO-BE State
. Developed Pre-Training Plan, and UAT Testing Plan
. Developed Business Case and Vision documents
. Developed Implementation, Conversation, and Training plans
. Conducted requirement gathering (JAD) sessions to determine business
processes list
. Conducted requirement gathering (JAD) sessions to determine the
applications list
. Developed logical database design
. Effectively communicate directly with both internal customers and
external vender
. Analyze and troubleshoot QA/Test system problems effectively
. Understand system architecture and the integration of system components
. Actively participated in all aspects of the application development
lifecycle
. Perform data analysis using Oracle SQL
. Actively participated in data modeling activities with developers and
database administrators
. Worked closely with developers to determine appropriate system design
changes/enhancements
. Worked closely with developers and the technical support team to deliver
system enhancements and resolve QA/Test support issues.
Environment: MS Office, MS Project, SharePoint, MS Visio, Oracle, TFS,
Waterfalls and Agile environments
Sun Life Financial ~ Waterloo, ON Feb' 11 - Jun' 11
Consultant
Sun Life Financial Inc. is an international financial services company
known primarily as a life insurance company, but also has a strong presence
in investment management Toronto, Canada, Sun Life and its partners provide
insurance, retirement and investment solutions for individuals and
businesses around the world including Canada, the United States, the United
Kingdom, Hong Kong, the Philippines, Japan, Indonesia, India, China and
Bermuda.
Responsibilities:
. Developed Project Charter
. Developed Work Breakdown Structure (WBS)
. Developed Project Plan
. Developed RICA chart
. Developed Resource Plan
. Developed current state/AS-IS State
. Developed future state/TO-BE State
. Developed Business Use Cases
. Performed Gap Analysis
. Conducted requirement gathering (JAD) sessions to determine business
processes list
. Conducted requirement gathering (JAD) sessions to determine the
applications list
. Mapped Business Processes to the Applications
Environment: MS Office, SharePoint, MS Project, MS Visio, and eBRP
On vacation - travelling from 12/2010 - 01/2011
Wal-Mart ~ Bentonville, AR Jul '10 - Nov'10
Team Lead / Sr. Business Analyst
Responsibilities:
Member of very large developing team for Annual Enrollment 2011 Program and
Year End and Year Begin 2011 for Wal-Mart's employees to implement the
Retirement Saving (401 K Matching Contribution, 401 K Profit Sharing,
Associates Stock Purchase Plan), Government Mandate for age 26 for Medical
Insurance and Dental Insurance (Blue Cross Blue Shield), Short term
disability Insurance (STD), Long Term disability Insurance (LTD), migration
of Pharmacy Claims (MEDCO) etc
. Created and executed requirements management plan(Mainframe, Java, and
.Net Development), - including timeline & effort estimates
. Facilitated JAD sessions for requirement gathering, requirement
confirmation, validating requirement gathered, and documentation of
functional and non-functional requirements by using ISDLC.
. Elicited analysis, and reporting requirements from business stakeholders
to understand and Documentation their objectives and solution criteria
. Developed AS-IS Documentation for 401 K Matching Contribution, 401 K
Profit Sharing, 401 K Stock Purchase, and Government Mandate for age 26
for Medical, Dental etc
. Developed future state/TO-BE Documentation using Use Case Modeling, Use
Cases, and System Integration Modeling using Visio.
. Developed Use Cases, Use Case Model, Activity and Class diagrams
. Developed GUI, Reports and Contribution File for Merrill Lynch - Bank of
America
. Documented the process of system integration of 401 K, Payroll, Human
Resources Data Ware House using IBM Data stage and Merrill Lynch - Bank
of America
. Performed SWOT analysis, Risk and Impact Analysis, GAP analysis of
requirements to determine missing functionalities.
. Developed Documentation of Understanding (DOU), Scope Documentation,
Business Requirement Documents (BRD) including Use Cases, Activity
diagrams, Main/Basic Flow, Alternate Flows using Visio.
. Planned and conducted requirements reviews with business
partners, design/development teams for mainframe, Java team, .Net team
for customer facing application, database teams (Oracle and DB2) and IT
managers
. Dealt with various queries and questions related to Mainframe, Java, and
database teams
. Developed logical database design using ERD and physical database design
based on logical database design including Data Dictionary for both DB2
and Oracle and CRUD Matrix for web-based application for customer facing
application
. Basic Administrator for the SharePoint portals for Annual Enrollment and
YE/YB projects
. Built relationships with source system support teams of 401 K and Payroll
to gain insights into data and processes that they manage
. Worked with offshore QA, Java and COBOL development teams to develop
Technical Design Documents
. Mentored other Business Analyst
Environment: Mainframe, COBOL, CICS, Java, .Net with AJAX, DB2 as HOST,
Data stage, TeraData, Oracle 11I, MS Project, Visio, SharePoint, HP Quality
Center, Outlook, and WebEx
Ford ~ Dearborn, MI Mar '10 - Jun '10
Sr. Business Analyst
Responsibilities:
Developed Global Digital Asset Management, internet based application for
creation, storage, retrieval, deletion, and archival of digital assets. It
was a large off-shelf project (COTS) started in the early 2009. I finalized
and finished requirements and documentation for the large project.
. Participated and facilitated Rapid sessions (JAD) for requirement
confirmation, validating requirement gathered, and documentation of
functional and non-functional requirements by using simplified Data Flow
Diagrams.
. Developed Business Owner View (BOV) using many different processes
modeling techniques based on Zackman Framework using Visio such as DFD,
ERD, and Business Process Modeling.
. Developed future state/TO-BE Documentation using Use Case Model, Use
Cases, System Boundary, System Integration Model using Visio and
Consolidated User Table/CRUD Matrix.
. Developed traceability matrix.
. Wrote Use Cases, Activity diagrams, Main/Basic Flow, Alternate Flows
using Visio.
. Wrote User Acceptance Test scenarios, functional Test Cases.
. Wrote system integration Use Cases and Test Cases.
. Dealt with various queries and questions related to Java, and Oracle
. Participated different meeting for facilitate completion of Application
Control Review (ACR), SOA, EAA, etc.
. Worked with offshore database and Java development team
. Provided input in the development of Project Chart.
. Prepared report for outstanding issues related users authentication.
Environment: Java environment using Oracle 11I, MS Project, Visio,
SharePoint, HP Quality Center, Outlook, WebEx, Java, XHTML, ASP, and JSP
ePrintOne Inc ~ Mississauga, Ontario: Apr '07 - Feb '10
Sr. Business & System Analyst / Project Manager
Responsibilities:
Developed the ERP System including Customer Relational Management (CRM),
Inventory Management, Retail Order Management, B2C, Payment (Credit Card
and Electronic Fund Transfer, Wholesale and Retail Invoices, and Account
Receivables'), Shipping, Product (Pricing for raw product, labor etc) and
Quotations for RIF, RFP, and RFQ, and Japanese Electronics Company, B2B
Application.
. Facilitated JAD, interview, and brainstorming sessions for requirements
gathering and documentation of functional and non-functional requirements
using USE Case, Context and DFD diagrams
. Modeled business processes such as AS-IS/Physical and TO-BE/Logical
Models
. Developed User stories, Use Cases, Use Case Model, Activity and Class
diagrams
. Developed Context and DFD diagrams and functional specifications for each
sub-system to enhance their functionality using Visio
. Wrote the technical specification using flowchart/process model, class,
activity diagrams etc
. Developed the documentation for new process and procedures for logical
system
. Researched, analyzed and documented clear and complete business
requirements/functional requirements
. Created and reviewed test strategy and test matrices during QA and UAT
cycle
. Handled the business change management issues regarding scope, schedule
etc
. Liaised with the business stakeholders, company heads, customer, end
users during all phases of development, and software developers, and
tester during the design and development stages
. Produced technical documentation, developer manuals and other related
manuals and User Interface Design documentations
. Wrote technical specifications by mapping from AS-IS/Physical to TO-
BE/Logical Models design
. Developed logical database design using ERD and physical database design
based on logical database design including Data Dictionary and CRUD
Matrix
. Created Views on multiple tables for business to run ad hoc query using
SQL
. Dealt with various queries and questions related to .Net and C#, and MS
SQL Server
. Developed Work Breakdown Structure for the development of web business
analysis, web project management, full system development life cycle
custom development, online ordering system, B2B application, for Japanese
electronics company
. Migrated Java based application to .Net Environment of an existing
application of B2C
. Supervised system integration of in-house web-base system and online
ordering system for Japanese electronics company as part of the ERP
system
. Worked with offshore HP QC and .NET development teams
. Managed back-up, recovery and disaster management
. Basic Administrator for the SharePoint portals for B2C and B2B
applications development
. Managed project process and budgets
Environment: .NET environment using SQL Server 2005, SOA, SharePoint, HP
Quality Center, WebEx, XHTML, ASP, JSP, SOA, AJAX, MS Project, Vision and
C#/Java
Memorial University of Newfoundland ~ St. John's, Newfoundland: Sep '04 -
Apr '07
Doctoral Student/ Teaching Assistant
Responsibilities:
. My research proposal was "Size and semantics: XML shortcomings for
semantics definitions in the Semantic Web"
. Worked as Teaching Assistant for Database concepts, VB, ASP, JSP, Access,
Excel, Power Point, Word, and Windows
Preparing for College: Aug '04
Ultersoft Solutions ~ Mississauga, Ontario: May '01 - Jul '04
Business Analyst / System Analyst
Responsibilities:
Performed the requirements planning and management using Sales & Inventory
Operations Planning (SIOP process model) which involves planning the
requirements development process of computer-based Truck-ordering and truck-
receiving using Web Services, sales using POS by using JavaPOS, order
forecasting, transfer-in, transfer-out, daily, weekly and end of month
stock taking, waste management etc.
. Facilitated JAD, interview, and brainstorming sessions to gather and
document functional and non-functional requirements using Use Case
Modeling, Activity, Context and DFD diagrams
. Developed Use Cases, Use Case Model, Activity and Class diagrams
. Modeled business processes such as AS-IS/Physical and TO-BE/Logical
Models
. Written technical specifications by mapping from AS-IS/Physical to TO-
BE/Logical Models design
. Developed logical database design using ERD and physical database design
based on the logical ERD design including Data Dictionary and CRUD Matrix
. Dealt with various queries and questions related to Java, and Oracle
. Created Test Case, and Test Case scenarios during UAT cycle
. Defined user dialogue, update processes, GUI, reports, and enquiry
processes using Visio
. Coordinated development teams including business stakeholders, customer,
end users local team and off shore teams
. Worked with JAVA and database offshore team
Environment: JAVA, J2EE, SOA, Lotus Notes, MS Project, Visio, Web Sphere,
XML, XSLT, JSP, HTML, SQL Server 2000 and JDBC
Moved to Canada: Apr '01
Pakistan Environment Program ~ IUCN: Nov '99 - Mar '01
Coordinator of Pakistan Environment Program (PEP)
Responsibilities:
This was a Capacity building program for public sector and environmental
NGOs in the Pakistan. The program was funded by Canadian International
Development Agency (CIDA). Performed the enterprise analysis for the
development of Environment Management Information System (EMIS) to
determine the needs of 14 different areas of the program
. Provided technical support end-to-end for the development with respect to
data and requirements gathering, data flows, database and workflow
. Facilitated and assisted JAD, interview, and brainstorming sessions for
requirement gathering and documentation of functional and non-functional
requirements using User stories, USE Case, Context and DFD diagrams using
Visio
. Supervised the BPR for the large and, medium, and small/NGO Funds
development projects including AS-IS State/Physical, TO-BE State/Logical
along with technical functional specifications, terms of reference
documents etc Use case and activity diagrams
. Created and reviewed test case, strategy and test matrices for UAT cycle
. Performed Gap/FIT analysis which resulted in the development new
procedures to update database system for CO2 Inventory of Pakistan
. Coordinated and implemented information system for CO2 inventory of
Pakistan
. Supervised NOG Funds Management System for small-scale environment
development project using Context and DFD Diagrams using Visio
. Coordinated to compile Pakistan National Response Strategy on Climate
Change, Resettlement Policy
. Met with PEP and Business Partners to review current business processes
and analysis requirements
. Prepared project reports, development schedules, and project budgets
. Supervised logical database design using ER Diagrams including Data
Dictionary and CRUD Matrix
. Created Views on multiple tables for business to run ad hoc query using
SQL
. Supervised user dialogue, update processes, GUI, reports, and enquiry
processes for large and medium Environment sector development project
. Supervised physical system including mapping from logical to physical
design for development of large and medium Environment sector development
project for client - server architecture
. Managed project process and budgets
Environment: Oracle 8i, MS Access, MS Office, MS Project and MS Visio
Housing Foundation - Government of Pakistan ~ Pakistan: Feb '91 - Nov '99
Business Analyst / System Analyst
Responsibilities:
This development involved Analysis and Design of the MIS covering all
aspects of management procedures and reports of its Application System for
allotment of Federal Government Houses Database System, Members Database
System, Employee Administrative System (Personnel and Payroll System), and
Accounting System, accounts / payments and refunds (integrated with IBM
Mainframe System using COBOL and CICS at the National Bank of Pakistan). We
used Feature Driven Development using Domain Modeling for the Housing
Foundation. Performed the enterprise analysis is requirement of the Housing
Foundation to be paper-less organization
. Facilitated JAD, interview, and brainstorming sessions to gather and
document functional and non-functional requirements using USE Case
Modeling, Context and DFD diagrams using Visio
. Modeled business processes such as AS-IS/Physical and TO-BE/Logical
Models
. Developed User stories, USE Case Modeling, Activity, ERD, flowchart and
DFD diagrams, and Decision tables as part of functional specifications
for each sub-system to enhance their functionality for the development in
the Mainframe using COBOL, COBOL-CICS and DB2
. Created and reviewed test strategy and test matrices during UAT cycle
. Performed Gap/Fit analysis which resulted in the development of new
Members MIS using RS/6000, Oracle, and Developer 2000
. Handled the conflicts, resolution and escalation issues of Housing
Foundation for Members database (Assembly Question and Newsletters) vs.
Accounting System vs. Employee Administrative System(Personnel and
Payroll System)
. Developed logical and physical database design using ER Diagrams
including Data Dictionary and CRUD Matrix
. Created Views on multiple tables for business to run ad hoc query using
SQL
. Developed user dialogue, update processes, GUI, reports, and enquiry
processes
. Developed logical system including mapping from physical to logical
design
. Implemented an Office System restructuring solution reducing the work
force from 104 to 62 resulting in a savings in the millions
. Developed an Employee Administrative System, utilizing the Waterfall
Model of SDLC that implemented Employee System: Personnel System, Leave
System, House Renting System, Transport System and Payroll and Retirement
Saving System: Salary Administration System, Advances System, Allowances
System, Deduction System an client - server architecture
. Prepared, managed and Implemented change management schedule from paper
environment to computer-base system
. Developed a Fixed Income Derivatives Investment System for its unused
funds to generate income using Water Falls of SDLC
. Led data and application migration activities from time to time from
Linux to SCO Unix and from SCO Unix to AIX
. Managed project process and budgets
Environment: Oracle 6.2 to 8i, COBOL Mainframe, CICS, DB2, MS Office, MS
Project, C, CGI, AIX, UNIX, Windows NT, CGI and MS Visio
Mak Computer Center ~ Pakistan: May '88 - Feb '89
Programmer
Responsibilities:
. Coded client - server architecture of the MAK Computer Centre to develop
customer relationship management (CRM)
. Developed including coding for Result, Fee, and Medical update systems
the Brain School
. Developed logical database design using ER Diagrams
Contact this candidate