Data Project Manager

Ali Ishtiaq

***************@*****.***

Ph: 571-***-****

Summary:

Over 5+ years of Experience working with Airline and Telecommunication Domains.

Business Process Modeling (BPM), Use Case modeling using UML, Data Modeling, Project Management, Change Management, Software Training, Software Development methodologies, QA testing and Systems Testing, troubleshooting of client server and web-based systems.

Experience on Agile, Scaled Agile, Test Driven development and hybrid Software development methodology.

Experience in gathering reporting requirements from the business users for Business Intelligence, Mobile, Notification engine and Data Warehouse application.

Extensive experience in Microsoft Office including: Word, Excel, PowerPoint, Visio, Outlook, Access, and SharePoint

Strong experienced in creating requirement and technical documents including the, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM), Test driven development documents, Test tables, Defect Reports and Test Documents

Responsibilities carried out as Business Analyst, Systems Analyst, Project Lead and Product owner; on Business side as well as IT side.

Act as a Proxy of PO and worked directly with clients and IT teams.

Work directly with product owners, system engineers, program managers, developers and stakeholders to define features and technical and business user stories

Author requirements and user stories for product features working with stakeholders (both internal and external) ensuring stakeholders needs are met

Wear Multiple hats on assign projects to attain the goals of the project

Hands on experience in creating SQL Queries, Stored Procedures, Triggers, Views, Indexes in SQL Server with a strong understanding of data & analytics.

Conducted and participated in iteration zero and scaled agile Big Room Planning sessions with stakeholders and system users to collect the software requirement specifications and analyzed the feasibility of their needs by coordinating with the project manager and technical lead and came up with plan to execute them and come up with the feasible time frame.

Worked efficiently on multiple projects spanning over different releases at the same time

Proven track record in requirement gathering & analysis, data collection, analysis and evaluation in Information Systems issues, analytical problem solving and decision making, communication and inter-personal skills with ability to interact with individuals at all levels.

Transformed business requirements into functional specifications, focusing on workflow analysis and design, business process re-engineering, user interface - UI design, and process flow modeling.

Conducted and attend various JAD, BRP (Big room planning meetings for scaled agile) and iteration zero sessions with business users and separately with development, QA teams.

Applied and worked on all phase of project delivery methodologies of agile in AA (DPaCE, Develop, plan, create and End)

Conduct and attend the Scrum of the Scrum meetings to attain and be on track of the deliverables and deadlines

Technical Skills:

Analysis Tools, Techniques: Microsoft Office Suite, UML, Visio, Rational Requisite Pro, Data Analysis, Jira, CA Rally, SharePoint

Testing Tools: Quality Center, UAT, Manual Testing

Database: SQL Server, Oracle, MS-Access

Data Access Technologies: PL/SQL, Toad, Stored Procedures

Operating Systems: Windows, Advanced Server, UNIX

Professional Experience:

American Airlines, Dallas, TX

Sr. Business System Analyst

Jun 16 - Present

American Airlines is the world largest airline when measured by fleet size, revenue, scheduled passengers carried, scheduled passenger-kilometers flown, and number of destinations served and worked on their Customer Notification engine which provide communication to all the American Airlines Advantage members and customers flying on their 6700 flights on the daily basis.

Worked on Top IT projects in the company including GDPR (Global Data Privacy Regulations), Denied Boarding, Contact American selfService, iOS Wallet and Mobil Push which increase the number of notifications up to 20%

Responsibilities:

Providing single point of contact for assigned projects to business and IT

Identified processes for developing and documenting detailed business requirements. Data was collected from end-users, and analysts

Create Use cases, Use Case Diagram, Business flow diagram, Work and Navigation flow diagram using Unified modeling language (UML).

Implement the A/B Testing on Denied Boarding project to gather the stats of which notification provide better response rate and bring more return to the business.

Conduct and attend the Scrum of the Scrum meetings to attain and be on track of the deliverables and deadlines

Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.

Interacted with business for verifying business and user Requirements, managing Change Control Process, updating existing Documentation

Responsible for business process modeling, process mapping

Conducted and participated in Iteration zero and scaled agile Big room planning sessions with stakeholders and system users to collect the software requirement specifications (SRS) analyzed the feasibility of their needs by coordinating with the project manager and technical lead and came up with plan to execute them and come up with the feasible time frame

Worked on the Mobile Push notification implementation and iOS wallet projects and it increase the number of notifications increased by 20% which give more communication to our end customers.

Facilitated weekly platform meetings to ensure consistency/compliance and drive the incident resolutions.

Worked on the Ancillary Products of the AA on the notifications side.

Worked on data modelling and produced data mapping and data definition documentation

Brainstorm and worked with analytical team to provide the best possible data to solve business problems and make better decision for stakeholders.

Worked with Big data and data Wearhouse teams to come up with the plan and execute the single open email tracking system which helped the business to see and understand the number of Email open and number of customer call back

Understanding of the business process areas and working with the business and technical teams to define business needs

Work directly with product owners, system engineers, program managers, developers and stakeholders to define features and technical and business user stories

Track and submit the weekly status of Product features and make sure they are aligned within the scope of the stakeholder requirements and resolve the issues to meet the desire release dates.

Excellent MS excel and MS access skills.

Gathered requirements and modeled the Data Warehouse and the underlying transactional database.

Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, Data Modeling and Design

Worked on scaled agile BRP (big room planning) and came up with the plan and work items for the next release.

Act as primary communication channel between business areas, IT and Data Warehouse group. Provide support to Data Warehouse users to ensure that their needs/business requirements are being met

Applied and worked on all phase of project delivery methodologies of agile in AA (DPaCE, Develop, plan, create and End)

Environment: SDLC, SharePoint, MS Office, MS Project, SharePoint, MS Visio, Agile, Quality Center, UAT, SQL, SQL Server.

IT Excel LLC

Hawaiian Airlines, Honolulu, HI

Sr. Business Analyst

Jan 15 – May 16

Hawaiian Airlines carries an average 8 million customers a year and serves 20 domestic and international destinations in the Pacific region. This project implements Hawaiian Airlines first learning management system with regulatory and technical training requirement.

Responsibilities:

Providing single point of contact for assigned projects

Identified processes for developing and documenting detailed business requirements. Data was collected from end-users, and analysts

Create Use cases, Use Case Diagram, Business flow diagram, Work and Navigation flow diagram using Unified modeling language (UML).

Meeting with project teams regularly to review project deliverables and deadlines

Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.

Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation

Responsible for business process modeling, process mapping

Conducted and participated in JRP/JAD sessions with stakeholders and system users to collect the software requirement specifications (SRS) analyzed the feasibility of their needs by coordinating with the project manager and technical lead

Worked on data modelling and produced data mapping and data definition documentation

Formulated advanced SQL queries for Data extraction, manual reconciliation and analytical reports using MS Excel (Pivot tables and chart)

Analyzed data requirements, data accuracy and created specifications for the ETL team to load data into the target database and insisted them with source to target mappings and with the tables, columns and other database objects.

Excellent MS excel and MS access skills.

Involved in creating PNR records, passenger records, with unique reference number.

Gathered requirements and modeled the Data Warehouse and the underlying transactional database.

Followed the organization Data dictionary Standards in Data Collection, Data Conversions, and Data Acquisitions and performed Gap Analysis while transforming data from legacy systems to updated technologies using custom SQL scripting as well as ETL applications from Relational Solutions.

Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, Data Modeling and Design

Act as primary communication channel between business areas and Data Warehouse group. Provide support to Data Warehouse users to ensure that their needs/business requirements are being met

Create or providing input to project plans

Understanding of the business process areas and working with the business and technical teams to define business needs

Environment: SDLC, SharePoint, MS Office, MS Project, SharePoint, MS Visio, Agile, Quality Center, UAT, SQL, SQL Server.

IT Excel LLC

Verizon Business, Ashburn, VA

Business Analyst

Jun 13 – Dec 14

The project I was working for Exception Handling / Production Support Tool Project. I was member of a team working on Online Access Management Systems for consumer accounts. It provides customer with capability of various online self-service functions, like bill checking, minutes/usages checking, pay bill, update profile, add rate plan, change rate plan, equipment upgrade and etc. The system interacts with various other billing and customer care applications.

Responsibilities:

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.

Ensured financial statements are accurately stated via in-depth review/analysis of system generated revenue and expense activity reports.

Assist in translating business requirements into reporting and modeling.

Conducted feasibility study and GAP analysis before implementing a new feature or developing a new product

Data Analysis for ensuring data accuracy across multiple applications based on various reporting tools such as MS Excel, Business objects

Worked on data analysis, data profiling, data modeling, data mapping and testing for a given task

Worked in Agile Methodology Environment.

Performs research and analysis of business requirements in the creation of data specifications used in waterfall modeling

Performed Functional Requirement reviews and walkthroughs with the designers, developers and stakeholders

Sat with development team who working with SharePoint to design the User Interface development phase to ensure the design is according to user requirements

Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation

Developed models to project revenue and costs to support budget forecasting and strategy development. Prepared standard monthly reporting.

Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data

Involved in production support, analyzed issues and communicated with the development team

Worked on SQL Server, Query database to extract a set of data for the required condition to support analysis and manipulate using excel to arrive at a conclusion

Documented requirements associated with Change Requests

Create and implement Customer Service plans. Use MS Project to monitor and track progress.

Thoroughly studied the requirements for the process re-engineering

Environment: Microsoft Office Suite, Unix, SQL, SQL Server, Agile, SDLC, MS Project, UAT, Requirement Gathering, BRD, Etc.

Education:

MBA

Contact this candidate