Amjad Pathan 215-395-6424
Pathana2011@gmail.com
Local To TX
SUMMARY OF EXPERTISE:
- Business Analyst with over 7 years industry experience in business data modelling, software requirement analysis, process modelling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML
- Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
- Strong knowledge of Financial Industry including Investment Management, Retail Industry including Logistics and Healthcare industry including HIPAA with emphasis on Business Requirements and Functional Requirements.
- Configured and administered JIRA 5.0 tracking for – issues, tasks, features, and of course, bugs; customized JIRA fields per project, sprint and phase release
- Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
- Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.
- Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability & Verification Matrix (RTVM) and testing documents.
- Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
- Proficient in using UML in behavioural, structural and architectural modelling – in creating Use Case, State, Activity, Class and Sequence diagrams using Rational Rose.
- Used Microsoft Visio for Business Process Modelling and Data flow diagrams.
- Used ER w in 4.0 to capture data by creating Entity-Relationship and Use Case diagrams.
- Worked with Rational Suite of tools to create requirements documents (Rational Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
- Created Confluence 4.0 Issue links for complete traceability from the requirements and specs created in Confluence to the issues tracked in JIRA 5.0.
- Experience in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis.
- Successful as a team player to work in conjunction with other DBA’s, testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects especially with Test Director/ HP Quality Center.
- Expertise in Analysis of Problem Severity, Defect tracking and reporting system.
- Strong communication, problem solving, organizational, interpersonal, and presentation skills.
TECHNICAL SKILLS:
Business Tools: Rational Suite(Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MSProject, MS Access, MS Office Suite, Visual Paradigm, Doors Erwin Data Modeller4x, Business Object (Crystal Reports)
Business Skills: BusinessDefinition Requirements, Business Process Analysis, Gap Analysis, Use Case Modelling& Analysis, Business Environment and Market Research Analysis.
Methodologies: RUP, OOAD, UML & Business/DataModeling
Testing Tools: Win Runner, LoadRunner, Test Director, Quick Test Pro, PR Tracker, HP Quality Center, JIRA
Operating Systems: WindowsXP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux
Databases: Oracle8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, DB2
PROFESSIONAL ACCOMPLISHMENTS:
Client: UniversityFederal Credit Union, Austin, TX January 2012 – Present
Sr. Business Analyst/JIRA Administrator
Project Scope: Implementationof Pivotal CRM at UFCU.
Responsibilities:
· Created Business Use Cases for testingthe user friendliness of the application
· Created CRM Dry Run Plan, MockConversion Plan and Go-Live Plan
· Performed Business Processre-engineering by creating swim lanes after each sprint and made improvementsor enhancements to the Business Process flow
· Configured and administered JIRAtracking for – issues, tasks, features, and of course, bugs; customized JIRAfields per project, sprint and phase release
· Setup and configured a JIRA Greenhopper(AGILE/SCRUM) project with full metric tracking
· Loaded the JIRA project with one releasehaving four sprints and filled up the task board using requirements as asource.
· Export JIRA Issues to Excel for reviewat Steering Committee
· JIRA maintenance for sprint, project andphase release of Issue Types
· Wrote Test Cases and performed UserAcceptance Testing (UAT) and reported bugs using JIRA Bug tracking system
· Customized issue types, fields, andworkflows to match existing workflowsand quickly adapt to changes as processes evolve.
· Administered JIRA for team planning, applicationdeployment and to capture and organize issues, work through action items, andstay up-to-date with team activity.
· Setup and configured JIRA GreenHopper tosimplify planning and reporting when using Scrum; manage Agile backlog and plansprints; visualize process and optimize flow using principles of AgileDevelopment.
· Wrote system and functional Test Plansand Test Cases for each Sprint
· Coordinatedvarious kinds of User Acceptance Testing (UAT) including regression testing,system testing, integration testing, functional testing, alpha & betatesting.
· Created drill down from the high levelsummary metrics to the supporting detail in the current report format
· Performed data mapping from applicationto production
· Linked specs developed in Confluence toactionable JIRA issues and Insert JIRA issues in Confluence pages to generatereports that display key details – issue type, summary, and status.
· Configured Confluence Auto convert forproducing reports of issues, backlogs, and tasks
· Created Confluence Issue links forcomplete traceability from the requirements and specs created in Confluence tothe issues tracked in JIRA.
· Analyzed the existing InvestmentManagement Research process and ensured business rules were being applied inthe new application.
· Created Use cases, activity report,logical components and deployment views to extract business process flows andworkflows involved in the project. Carried out defect tracking using Jira.
· Involved in interactions with Subject MatterExpert, Project Manager, Developers, and the end-users in more than one JADsessions. MS Project proved useful in coordinating activities with projectmanager and various other teams
· Managing and Maintaining Scope ofProject and adding business process enhancement requirements to the BusinessRequirements Document
· Managing changes to scope andrequirements of the project at each Sprint release.
· Modeled the information and then came upwith the requirements prioritization. Eliminated false requirements byscreening out multiple versions of user input. Final prioritization was basedon both, product and process requirements.
· Provided clear and concise documentationregarding requirements management plans, functional requirements, supplementalrequirements
· Performed GAP analysis for the modules in production,conducted feasibility study and performed impact analysis for proposedenhancements.
· Used JIRA for defect management.
· Used Snaggit for capturing data andinterface requirements.
Environment:Windows XP/2000, Oracle, PL/SQL, MS-Project, MS-Office Suite, MS Visio,Rational Requisite Pro, UML, JIRA, Adobe Pro9, Snaggit, HP Quality Center
Client: WilliamBlair & Company, Chicago, IL April 2010 – December 2011
Sr. Business & Quality AssuranceAnalyst/ JIRA Administrator
Project Scope: WilliamBlair & Company, L.L.C. is a Chicago based investment firm offeringinvestment banking, asset management, equity research, institutional andprivate brokerage, and private capital to individual, institutional, andissuing clients. Since 1935, we have been committed to helping clients achievetheir financial objectives. As an independent, employee owned firm, ourphilosophy is to serve our clients' interests first and foremost. We place ahigh value on the enduring nature of our client relationships, the quality ofour products and services, and the continuity and integrity of our people.William Blair & Company has offices in Chicago, Boston, London, New York,San Francisco, Shanghai, Tokyo and Zurich. A brand new cutting edge researchsystem is being deployed on the Investment Management side of the business forInvestment Management Analyst, Associates, Trader’s, PM’s, DOR’s and Admin’s.This was a fast paced agile project with daily Scrum meetings.
Responsibilities:
· Created Business Use Cases for testingthe user friendliness of the application
· Performed Business Processre-engineering by creating swim lanes after each sprint and made improvementsor enhancements to the Business Process flow
· Wrote Test Cases and performed UserAcceptance Testing (UAT) and reported bugs using JIRA Bug tracking system
· Configured and administered JIRAtracking for – issues, tasks, features, and of course, bugs; customized JIRAfields per project, sprint and phase release
· Setup and configured a JIRA Greenhopper(AGILE/SCRUM) project with full metric tracking
· Loaded the JIRA project with one releasehaving four sprints and filled up the task board using requirements as asource.
· Export JIRA Issues to Excel for reviewat Steering Committee
· JIRA maintenance for sprint, project andphase release of Issue Types
· Coordinatedvarious kinds of User Acceptance Testing (UAT) including regression testing,system testing, integration testing, functional testing, alpha & betatesting.
· Created drill down from the high levelsummary metrics to the supporting detail in the current report format
· Performed data mapping from applicationto production
· Customized issue types, fields, andworkflows to match existing workflowsand quickly adapt to changes as processes evolve.
· Administered JIRA for team planning,application deployment and to capture and organize issues, work through actionitems, and stay up-to-date with team activity.
· Setup and configured JIRA GreenHopper tosimplify planning and reporting when using Scrum; manage Agile backlog and plansprints; visualize process and optimize flow using principles of AgileDevelopment.
· Performed and analyzed data requirementsand data validation. This was part of testing data and involved writing SQLQueries.
· Analyzed the existing InvestmentManagement Research process and ensured business rules were being applied inthe new application.
· Created Use cases, activity report,logical components and deployment views to extract business process flows andworkflows involved in the project. Carried out defect tracking using Jira.
· Involved in interactions with SubjectMatter Expert, Project Manager, Developers, and the end-users in more than oneJAD sessions. MS Project proved useful in coordinating activities with projectmanager and various other teams
· Managing and Maintaining Scope ofProject and adding business process enhancement requirements to the BusinessRequirements Document
· Managing changes to scope andrequirements of the project at each Sprint release.
· Linked specs developed in Confluence toactionable JIRA issues and Insert JIRA issues in Confluence pages to generatereports that display key details – issue type, summary, and status.
· Configured Confluence Auto convert forproducing reports of issues, backlogs, and tasks
· Created Confluence Issue links forcomplete traceability from the requirements and specs created in Confluence tothe issues tracked in JIRA.
· Modeled the information and then came upwith the requirements prioritization. Eliminated false requirements byscreening out multiple versions of user input. Final prioritization was basedon both, product and process requirements.
· Provided clear and concise documentationregarding requirements management plans, functional requirements, supplementalrequirements
· Performed GAP analysis for the modules in production,conducted feasibility study and performed impact analysis for proposedenhancements.
· Used JIRA for defect management.
· Used Snaggit for capturing data andinterface requirements.
Environment:Windows XP/2000, Oracle, PL/SQL, MS-Project, MS-Office Suite, MS Visio,Rational Requisite Pro, UML, JIRA, Adobe Pro9, Snaggit, HP Quality Center
Client: Kohl’sCorporate, Menomonee Falls, WI Aug2008 – Feb 2010
Sr. Business Analyst
Project Scope: Kohl'sCorporation, (Kohl's) operates family-oriented, specialty department stores inthe United States. Kohl's Corporation is a Fortune500 company. In 2010 Kohl's Corporation was ranked number 135 on the Fortune500 list, making it the 135th largest company in the United States when judgedby revenue. Kohl’s logistic department’s project scope was to replace theexisting Transportation Management System and Yard Management System.
Responsibilities:
- Gather detailed business and technical requirements and participate in the definitions of business rules, In-Scope and Out-of-Scope business requirements.
- Created Business Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
- Facilitated Joint Application Development sessions and facilitated stakeholder meetings to identify business process and requirements; exhaustive management of project requirements using CaliberRM.
- Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in more than one JAD sessions. MS Project proved useful in coordinating activities with project manager and various other teams
- Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Analyzed the given source Dimensions and target Fact table structures to develop Surrogate Key tables referencing required dimensions.
- Created Hash tables referencing the Surrogate Key tables for quicker and more efficient lookup to Dimensions.
- Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs. Ensured that critical requirements are not missed.
- Modeled the information and then came up with the requirements prioritization. Eliminated false requirements by screening out multiple versions of user input. Final prioritization was based on both, product and process requirements.
- Established basic project lifecycles, milestones, and standardized processes for Product Management Tool.
- Provided clear and concise documentation regarding requirements management plans, functional requirements, supplemental requirements
- Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
- Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
- Facilitated JAR/JAD sessions with business and developers to reach consensus on requirements.
- Exposed to Agile methodology and daily Scrum meetings.
- Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
- Used Microsoft Visio for Business Process Modeling and Data flow diagrams.
Environment:
MS Word, Excel, PowerPoint, Visio, Access, MS SQL Server 7.0,HTML, XML, UNIX, Windows NT, Caliber RM, HP Quality Center, Lotus Notes
Client: BlueCross Blue Shield of Florida, Jacksonville, FL Nov 2006 – June2008
Sr. Business Systems Analyst
Project Scope: Blue Cross andBlue Shield of Florida is not only the state's largest and oldest healthinsurance provider, but also Florida's most popular health insurance forindividuals and families. The company has just about every type of Floridahealth insurance including the new revolutionary new Miami Dade Blue Cross BlueShield plan. Underwriting Tool Box enhancements and Rx Tool Enhancementswere done as part of the Health Care Reform. Project was the Individual under65 Portfolio Strategy to assist the Individual Medical Underwriting Department.
Responsibilities:
- Gathered and documented requirements for the Underwriting Tool Box Enhancements and Rx Tool Enhancements.
- Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
- Involved in interactions with Subject Matter Expert, Project Manager, Developers, and the end-users in more than one JAD sessions. MS Project proved useful in coordinating activities with project manager and various other teams
- Modeled the information and then came up with the requirements prioritization. Eliminated false requirements by screening out multiple versions of user input. Final prioritization was based on both, product and process requirements.
- Established basic project lifecycles, milestones, and standardized processes for Plan View program management system.
- Provided clear and concise documentation regarding requirements management plans, functional requirements, supplemental requirements
- Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
- Involved with Health Care Change Request tasks to existing Individual Rating and Proposal System.
- Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
- Worked with Rational Suite of tools to create requirements documents (Rational Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
- Facilitated JAR/JAD sessions with business and developers to reach consensus on requirements.
- Wrote Test Cases and performed User Acceptance Testing (UAT), documented the in detail defects using the Defect Tracking report.
- Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
- Created macros for preparing test cases in Excel for validating process of P&L tool, order management, Allocation Strategies and Modeling.
- Built reports and report models using SSRS to enable end user report builder usage.
Integrated Report Services (SSRS) into user application with URL and Report Viewer.
Created various reports such as ad-hoc reports, drill-down, drill-through, and parameterized reports using Reporting Services (SSRS) for internal teams.
- Involved in generating various reports using the SQL Server Reporting Services (SSRS).
- Used Test Case distribution and development reports to track the progress of test case planning, implementation and execution results.
- Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
- Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
- Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and also monitored these revisions.
- Involved in compatibility testing with other software programs, hardware, Operating systems and network environments.
Environment:
MS Word, Excel, PowerPoint, Visio, Access, MS SQL Server 7.0,HTML, XML, UNIX, Windows NT, SharePoint 2007, Req Pro, HP Quality Center
Client: Harvest Bank, Little Rock, AR Oct 2005 – Sep2006
Designation: Sr. Business Systems Analyst
ProjectScope: Worked as a Business Analyst and wasinvolved in implementing a centralized web-based application infrastructure tosave time, provide online data access, reengineer the credit card process inorder to expand the company’s business. It was a 24-hour online access to credit card holders, where customers canlogin and view the account information (Current and Previous Account history),can make online payments, change their contact information (Such as ContactAddress, Phone Number, Email Address ifavailable), and can contact customer service representatives for questions.
Responsibilities:
- Interacted as a liaison between Users and the different teams (including Deposit/Withdrawal, Customer Service, and Loan) involved in the application development for better understanding of the business and IT processes.
- Responsible for analysis and functional specifications of “As-Is” and “To-Be” business model to conduct GAP analysis in comparison to the proposed system to enhance the functionality of the application.
· Gathered business requirements throughinterviews, surveys and observing from account managers and conductedcontrolled brain-storming sessions with project focus groups and documentedthem in the Business requirement Document.
· Planned and defined system requirementsto Use Cases, Use Case Scenarios and Use Case Narratives using the UMLmethodologies. Created Use Case Diagrams, Activity Diagrams, and SequenceDiagrams using MS Visio.
- Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan-closed, borrowers-info, mortgage-payments etc, and their mapping to the standard analysis mechanism to enable maximum reuse.
· Identify different types ofusers (brokers, borrowers and loan officers) and analyze several importanthuman engineering factors and guidelines and incorporated them into a design ofa user interface using MS Visio
- Managed and coordinated the QA team to create the test approach and determine test needs, test environment, test data, resources and limitations.
- Performed manual and automated tested related to the graphical user interface, functionality testing, security testing, and testing related to data sources.
- Helped to develop test strategies, test cases, test plans, defect reports, Traceability Matrices and test environments and managed the testing process, bug reporting and analysis of test results.
- Tracked the progress of system testing, and provided a daily status report to the Test Manager.
- Used Test Director to house all test documentation and report/track all issues and defects.
Environment:
RationalSuite (Rational Rose, Requisite Pro), RationalUnified Process (RUP), Windows 2000, UML, MS-Project, MS-Office Suite, MS Visio,WinRunner, Test Director
Client: WalgreensHealth Initiatives (Walgreens Co.), Deerfield, IL Jan 2005 – Aug 2005
Designation: Sr. Business Systems Analyst
Project Scope: Walgreens Health Initiatives (WHI) Corporate officelocated in Deerfield, IL, part of the 100-year-old Walgreen Co. offers PharmacyBenefits Management, mail service pharmacy, specialty pharmacy, and, in selectareas, home care services. WHI programs are tailored to the needs of theircorporate clients, which include health plans, employer groups, union groups,government entities, third-party administrators, and coalitions. Project is allabout to make some enhancements to core Billing and Payments module in PBMSystem (Pharmacy Benefits Management System).
Responsibilities:
· Defined a complete set of metrics reportrequirements including a framework that will meet the needs of regional andnational business leaders
· Provided analytical data to enablemanagement to make informed decisions to drive continuous revenue cycleimprovements by realizing gains in operational efficiency, cost savings andmember experience
· Wrote Test Casesand performed User Acceptance Testing (UAT), documented the in detail defectsusing the Defect Tracking report.
· Coordinated various kinds of User Acceptance Testing(UAT) including regression testing, system testing, integration testing,functional testing, alpha & beta testing.
· Created drill down from the high levelsummary metrics to the supporting detail in the current report format
· Process and dataflow models for STD (Short Term Disability), LTD (Long Term) and FMLA claimsprocesses as well as interfaces to Human Resources.
· Performed workflowanalysis toward automated disability claims process. Detailed comparison of twocompeting proposals, including HR interfaces. Facilitated requirementsdefinition for new system.
· Completed thedocumentation of Claims Scenario’s for the source system
· Analyzed theexisting claims process and specific business rule logic will be applied in theACP model.
· Identified performance indicators thatprovide reliable daily trend information as a primary input towards the monthlyexecutive dashboard report
· Drafted the existing and known requestedlist of metrics to the Revenue Cycleprocess context map
· Analyzed and drafted a functional andtechnical features list for each vendor, thus identifying the best to send outa RFP Worked closely with the Enterprise Data Warehouse team and BusinessIntelligence Architecture team to understand repository objects that supportthe system requirement and process.
· Created a prototype presentation inVisio for the SCAL region, thus showing a pictorial representation on the variousdrill downs from the report to the metrics to the database.
· Identified and drafted the calculationsused for various regions, using their source SQL’s for standardization purpose.
· Created Usecases, activity report, logical components and deployment views to extractbusiness process flows and workflows involved in the project. Carried outdefect tracking using Clear Quest
· Involved ininteractions with Subject Matter Expert, Project Manager, Developers, and theend-users in more than one JAD sessions. MS Project proved useful incoordinating activities with project manager and various other teams
· Modelled theinformation and then came up with the requirements prioritization. Eliminatedfalse requirements by screening out multiple versions of user input. Finalprioritization was based on both, product and process requirements.
· Establishedbasic project lifecycles, milestones, and standardized processes for PlanViewprogram management system.
· Provided clearand concise documentation regarding requirements management plans, functionalrequirements, supplemental requirements
· Performed GAP analysis for themodules in production, conducted feasibility study and performed impactanalysis for proposed enhancements.
· Used Rationalclear quest for defect management.
Environment: Windows XP/2000, Oracle, PL/SQL, MS-Project, MS-Office Suite, MS Visio,Rational Requisite Pro, UML, Clear Case, Clear Quest, MS Visual Source Safe