AJ Pathan ***********@*****.***
Coit Rd, Dallas, TX
Business Analyst/ Business Systems Analyst/Quality Assurance Analyst 215-***-****
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.
• Wrote test scripts for User Acceptance Testing (UAT).
• 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).
• Well versed in project management tool (MS Project) for status reporting, planning and resource allocation.
• 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, MS Project, MS
Access, MS Office Suite, Visual Paradigm, Doors Erwin Data Modeller 4x, Business
Object (Crystal Reports)
Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case
Modelling & Analysis, Business Environment and Market Research Analysis.
Methodologies: RUP, OOAD, UML & Business/Data Modeling
Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker, HP Quality
Center, JIRA
Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux
Databases: Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, DB2
PROFESSIONAL ACCOMPLISHMENTS:
Client: University Federal Credit Union, Austin, TX January 2012 – Present
Sr. Business Analyst
Project Scope: Implementation of Pivotal CRM at UFCU.
Responsibilities:
• Created Business Use Cases for testing the user friendliness of the application
• Created CRM Dry Run Plan, Mock Conversion Plan and Go-Live Plan
• Performed Business Process re-engineering by creating swim lanes after each sprint and made improvements
or enhancements to the Business Process flow
• Wrote Test Cases and performed User Acceptance Testing (UAT) and reported bugs using JIRA Bug tracking
system
• Wrote Test Plans and Test Cases for each Sprint
• 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 level summary metrics to the supporting detail in the current report format
• Performed data mapping from application to production
• Analyzed the existing Investment Management Research process and ensured business rules were being
applied in the new application.
• 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 Jira.
• 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
• Managing and Maintaining Scope of Project and adding business process enhancement requirements to the
Business Requirements Document
• Managing changes to scope and requirements of the project at each Sprint release.
• 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.
• 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.
• Used JIRA for defect management.
• Used Snaggit for capturing data and interface 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: William Blair & Company, Chicago, IL April 2010 – December 2011
Sr. Business & Quality Assurance Analyst
Project Scope: William Blair & Company, L.L.C. is a Chicago based investment firm offering investment banking,
asset management, equity research, institutional and private brokerage, and private capital to individual, institutional,
and issuing clients. Since 1935, we have been committed to helping clients achieve their financial objectives. As an
independent, employee owned firm, our philosophy is to serve our clients' interests first and foremost. We place a high
value on the enduring nature of our client relationships, the quality of our 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 research system is being deployed on the Investment
Management side of the business for Investment 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 testing the user friendliness of the application
• Performed Business Process re-engineering by creating swim lanes after each sprint and made improvements
or enhancements to the Business Process flow
• Wrote Test Cases and performed User Acceptance Testing (UAT) and reported bugs using JIRA Bug tracking
system
• Wrote Test Plans and Test Cases for each Sprint
• 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 level summary metrics to the supporting detail in the current report format
• Performed data mapping from application to production
• Performed and analyzed data requirements and data validation. This was part of testing data and involved
writing SQL Queries.
• Analyzed the existing Investment Management Research process and ensured business rules were being
applied in the new application.
• 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 Jira.
• 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
• Managing and Maintaining Scope of Project and adding business process enhancement requirements to the
Business Requirements Document
• Managing changes to scope and requirements of the project at each Sprint release.
• 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.
• 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.
• Used JIRA for defect management.
• Used Snaggit for capturing data and interface 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’s Corporate, Menomonee Falls, WI Aug 2008 – Feb 2010
Sr. Business Analyst
Project Scope: Kohl's Corporation, (Kohl's) operates family-oriented, specialty department stores in the United States.
Kohl's Corporation is a Fortune 500 company. In 2010 Kohl's Corporation was ranked number 135 on the Fortune 500
list, making it the 135th largest company in the United States when judged by revenue. Kohl’s logistic department’s
project scope was to replace the existing 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: Blue Cross Blue Shield of Florida, Jacksonville, FL Nov 2006 – June 2008
Sr. Business Systems Analyst
Project Scope: Blue Cross and Blue Shield of Florida is not only the state's largest and oldest health insurance
provider, but also Florida's most popular health insurance for individuals and families. The company has just about
every type of Florida health insurance including the new revolutionary new Miami Dade Blue Cross Blue Shield
plan. Underwriting Tool Box enhancements and Rx Tool Enhancements were done as part of the Health Care Reform.
Project was the Individual under 65 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 – Sep 2006
Designation: Sr. Business Systems Analyst
Project Scope: Worked as a Business Analyst and was involved in implementing a centralized web-based application
infrastructure to save time, provide online data access, reengineer the credit card process in order to expand the
company’s business. It was a 24-hour online access to credit card holders, where customers can login and view the
account information (Current and Previous Account history), can make online payments, change their contact
information (Such as Contact Address, Phone Number, Email Address if available), 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 through interviews, surveys and observing from account managers and
conducted controlled brain-storming sessions with project focus groups and documented them in the Business
requirement Document.
• Planned and defined system requirements to Use Cases, Use Case Scenarios and Use Case Narratives using
the UML methodologies. Created Use Case Diagrams, Activity Diagrams, and Sequence Diagrams 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 of users (brokers, borrowers and loan officers) and analyze several important human
engineering factors and guidelines and incorporated them into a design of a 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:
Rational Suite (Rational Rose, Requisite Pro), Rational Unified Process (RUP), Windows 2000, UML, MS-Project,
MS-Office Suite, MS Visio, WinRunner, Test Director
Client: Walgreens Health Initiatives (Walgreens Co.), Deerfield, IL Jan 2005 – Aug 2005
Designation: Sr. Business Systems Analyst
Project Scope: Walgreens Health Initiatives (WHI) Corporate office located in Deerfield, IL, part of the 100-year-old
Walgreen Co. offers Pharmacy Benefits Management, mail service pharmacy, specialty pharmacy, and, in select areas,
home care services. WHI programs are tailored to the needs of their corporate clients, which include health plans,
employer groups, union groups, government entities, third-party administrators, and coalitions. Project is all about to
make some enhancements to core Billing and Payments module in PBM System (Pharmacy Benefits Management
System).
Responsibilities:
• Defined a complete set of metrics report requirements including a framework that will meet the needs of
regional and national business leaders
• Provided analytical data to enable management to make informed decisions to drive continuous revenue cycle
improvements by realizing gains in operational efficiency, cost savings and member experience
• Wrote Test Cases and performed User Acceptance Testing (UAT), documented the in detail defects using 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 level summary metrics to the supporting detail in the current report format
• Process and data flow models for STD (Short Term Disability), LTD (Long Term) and FMLA claims
processes as well as interfaces to Human Resources.
• Performed workflow analysis toward automated disability claims process. Detailed comparison of two
competing proposals, including HR interfaces. Facilitated requirements definition for new system.
• Completed the documentation of Claims Scenario’s for the source system
• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Identified performance indicators that provide reliable daily trend information as a primary input towards the
monthly executive dashboard report
• Drafted the existing and known requested list of metrics to the Revenue Cycle process context map
• Analyzed and drafted a functional and technical features list for each vendor, thus identifying the best to send
out a RFP Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team
to understand repository objects that support the system requirement and process.
• Created a prototype presentation in Visio for the SCAL region, thus showing a pictorial representation on the
various drill downs from the report to the metrics to the database.
• Identified and drafted the calculations used for various regions, using their source SQL’s for standardization
purpose.
• 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
Modelled 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 PlanView 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.
Used Rational clear 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