KAMRAN KHAN (MBA)

USA Citizen

Buffalo Grove- IL

ad4i0u@r.postjobfree.com

847-***-****

https://www.linkedin.com/in/kamran-khan-860a1a1bb/

Summary

PROFESSIONAL PROFILE

# Ready to work and authorized to work for any employer in USA/Remote/Hybrid or onsite within 20 Miles Radius of zip 60089

●7 + years of experience in Business System Analyst/Product Owner and software development life cycle, including analysis, design, development, testing and implementation of software applications in Health Care domain, Retail and Financial Domain as Business system Analyst/Data Analyzing/Data Profiling.

●Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro-Strategy Data Warehouse Data Modeling and Design.

●Hands on Training Power BI, Advance Excel using Macros and Tableau

●Worked and extracted data from various database sources like Oracle, SQL Server, DB2, and Big Data.

●Strong experience of payments processors such as Credit Card processor First Data

●Expertise in eliciting, analyzing, documenting, validating and managing business/system requirements across the lifecycle of the project.

●Hands-On experience in authoring various requirements artifacts such as epics, user stories, use cases, UML diagrams, Functional Requirements Document (FRD), Requirements Traceability Matrix (RTM), business rules document, mockups etc.

●Strong subject matter expertise in Retail, Banking, Credit Cards, Stocks, Bonds, Derivatives, Risk Analysis, Mortgage Loan Origination, Processing and Loan Servicing, and healthcare.

●Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.

●Worked and extracted data from various database sources like Oracle, SQL Server, No SQL, DB2, Tableau and Tera data/Big Data.

●Excellent knowledge of business areas such as Benefit Enrollment and Maintenance, Claims processing, Billing and Providers, and various EDI transactions, code sets and EDI Implementation guides in Health-care industry.

●Knowledge in ALM (Agile Lifecycle Management) tool Formerly known as Version one is a requirement management tool used in agile to write User stories and Epics

●Exposure to creation of Business Requirement Documents (BRDs), Functional Specification Documents (FSDs), Use Case Documents, Acceptance Criteria Documents (ACDs), Business Rules Spreadsheets (BRS) and Requirements Traceability Matrix (RTMs).

●Experienced in all phases of the Software Development Life Cycle (SDLC) Waterfall methodology, Agile methodology (Scrum), Rapid Application Development (RAD) including Requirement Planning and Management, Requirements Elicitation and Requirements Analysis.

●Experienced in conduct interviews, brain storming sessions, group interviews, prototyping, focus group sessions and JAD sessions in order to gather requirements.

●Experience with various Facets modules such as Provider, Subscriber/Member, Claims, Plan/ Product.

●Document data management principles e.g. Data Dictionary, Data Types, Rules and Logic.

●Strong Experience in using different requirement management and testing tools including Confluence, JIRA, Azure DevOps.

●Experience in conducting Gap Analysis, Risk Analysis and documentation of Use Cases and User Stories.

●Excellent knowledge of the “AS-IS” and “TO-BE” business processes and experience in converting these requirements into technical specifications.

●Experienced on User Acceptance Testing (UAT), SWOT analysis, Risk Analysis and mitigation plan and ROI analysis

●Proficient in creating UML diagrams, Context, Use Case, Sequence and Activity diagrams using MS Visio.

●Advanced proficiency in Microsoft, particularly Word, Excel, PowerPoint, and MS Project and expertise in Analyzing and Summarization of data using Excel.

●Strong experience in Application Design (Prototyping, Screen Mock-ups), wireframes and UI design.

●Proficient in evaluating SQL queries for data extraction, manipulation, analysis, and validation.

●Experience in Analyzing statistical reports on the company's web traffic using MS Excel and generated business reports, visualizations using Tableau.

●Interacted extensively with customers and UI designers to determine ways to improve the UI feel and the user experiences. Documented the gathered business requirements into detailed Business Requirement Documents.

●Experience in maintaining the Requirement Traceability Matrix (RTM) table to track all the requirements in BRD.

●Good knowledge of identifying various test scenarios. Holds strong ability to handle multiple tasks and prioritize.

●Knowledge on System testing while performed on the entire system in the context of a Functional Requirement Specification (FRS) and System Requirement Specification (SRS).

●Strong understanding in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project follow the Business Requirements.

●Hands on experience in User Acceptance Testing (UAT) to ensure all the User Requirements were met by the application.

●NASAA Cyber Security training

●North American Securities Administration Association

COMPUTER SKILLS

SDLC Methodologies: Agile-Scrum, Waterfall, Water-Scrum Fall, Kanban

Business Skills: Project Management, Requirements Elicitation, Stakeholder Management, Strategic Planning, Business Process Mapping, Conflict Management, Scheduling, Risk Management, Impact Analysis, Liaising

Business Modelling tools: MS Visio, Balsamiq Mock-ups, Lucid Chart

Project Management Tools: JIRA, MS Project, MS SharePoint, Confluence, JAMA, Azure DevOps

BI and Reporting Tools: Tableau, MS Office Suite (Excel, Word, PowerPoint), Power BI

Databases and ETL Tools: Informatics Power Center, MS Access, Oracle, My SQL

Languages: SQL

Professional Experience

PROFESSIONAL EXPERIENCE

The Office of the Illinois Secretary of State

Illinois Securities Department Chicago IL Oct 16 2023- Present

Enforcement Auditor 1

●Execute and regulates the offer and sale of securities pursuant to the Illinois Securities Law of 1953

●Analyze client Income and Balance statement

●Work on Audit Board Nemo pre-exam fill the information from web CRD FINRA

●Conduct onsite client interview

●Capture data of investor

●Cyber security protection and PII information

●Prepares reports of review or examination findings and recommends departmental action based on these findings.

●North American Securities Association(NASA) & Financial Industry Regulatory Authority series 65 Investment adviser representative (IARS)

● State and federal securities act, rules and regulation with interest of PII and good ethics

●Protect client information in Central Registration Depository (CRD)

●Conducts investigations of fraudulent activities by interviewing victims, witnesses and investigative subjects; develops and analyzes information; prepares thorough and accurate written reports; makes recommendations for administrative or judicial action in cases.

●Conducts investigations of fraudulent activities by interviewing victims, witnesses and investigative subjects; develops and analyzes information; prepares thorough and accurate written reports; makes recommendations for administrative or judicial action in cases.

●

Business Analyst/Data Analyst

Comcast TCS--(Layoff) Philadelphia, PA June 2021-Oct 22 2022

Responsibilities:

●Providing technical analytics to support the Comcast Data Engineering team and Architecture

●Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).

●Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Involved in creating workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.

●Involved in Designing Document Flow Diagrams (DFD's), Entity Relationship Diagrams (ERD's), and web page mockups using modelling tools.

●Collaborated with User Experience (UX) Team for Software User Testing.

●Created Wiki page for Client.

●Worked on DATA Profiling and analytics

●Document data management principles e.g. Data Dictionary, Data Types, Rules and Logic.

●Worked on Data profiling using DAX Portal with data bricks to compare column from SQL Server

●Create SSIS package using Visual studio to Create XML file

●Prepared the complete data mapping for all migrated jobs using SSIS(Sql server Integration Service)

●Facilitated team activities, story mapping, prioritization, defined minimum viable product (MVP), estimation, road mapping, product brainstorming and business model canvas.

●Conducted Joint Application Design (JAD) sessions with the end users/business and technical teams.

●Advanced Microsoft Excel (macros, nested if statements and other complex functions, advanced pivot table skills, VLOOKUP,HLOOKUP,XLOOKUP, Freeze Pane and Column, Graphs, Charts, Conditional Statement etc.)

●Evaluates data collected and identify and interpret trends or any duplicates and Perform Data Cleaning

●Prepares graphs, spreadsheets, reports, and PowerPoint presentations as required.

●Based on findings, prepares, and communicates results and recommendations to various levels of senior management

●Conducted Sprint-Grooming, Daily-standups, and Sprint-Planning, Sprint Review, Retrospective meetings and Scrum-of- Scrum meetings.

●Migrate data requirements from MLX to DX Data Lake AWS S3 Bucket

●Advanced Microsoft Excel (VLOOKUP, Macros recording, Charts, Graphs, Freeze Column, Formulas, Column Length, advanced pivot table skills, etc.)

●Worked with the ETL team to document the transformation rules for Data migration from OLTP to Warehouse environment for reporting purposes.

●Acquainted with parameterized sales performance reports, done the reports every month and distributed them to respective departments/clients using Tableau.

●Create User stories, sprints, maintain backlogs and Facilitate Release Planning, Sprint Planning, Backlog Grooming, and Retrospective meeting Using teams and Jira

●Write and submit JIRA stories & Well versed with JIRA dashboard

●Create Visualization chart using Power BI and upload to Tableau Dashboard

●Gathered requirements and developed Process Model towards understanding the stakeholder's business priorities to effectively identify business problems, assess proposed solutions, and represent the needs of stakeholders.

●Requirements analysis and document them according to corporate standards and procedures and prioritize them for assigned areas.

●Facilitated Joint Application Development (JAD) sessions, as well as conducted interviews with appropriate business/technical stakeholders.

●Worked with development/technical team members to ensure that the defined business requirements are met.

●Worked in Agile methodology of system development. Backlog creation, Backlog grooming, Story sizing, Sprint planning, Daily stand-up, Sprint reviews and Retrospective sessions in the above projects.

●Identified and conducted stakeholder analysis to gather Business Requirements, interact with stakeholders, gather requirements and assign priorities to each of them.

Business Analyst/PO Full Stack Java Logistic Domain Application

FedEx Pittsburgh, PA Nov 2019 –May 2021

Responsibilities:

●Create Product Roadmap, Product scope, User Stories, prioritize user stories for development and manage the product backlog for maintaining business value or ROI in Rally.

●Maintained and kept track of stakeholder's requests for enhancements and changes using Azure/AWS/DevOps.

●Data Analysis in Teradata and AWS Cloud Platform (AWS) with Big Query.

●Maintain As-is / To-be swim diagrams, impact analysis, Functional Specification Documents (FSD),Business Requirement Documents (BRD), Business Process Flows, develop data transformation and Data Mapping documents for each project going into the Enterprise Release.

●Attend team scrum ceremonies like planning, grooming, daily standup, review and retrospective. Lead planning sessions with the team to share the product vision, discuss product features and break these down into fully understood user stories complete with acceptance criteria.

●Define the minimum viable product (MVP) after rigorous discussions with the stakeholders.

●Rewrite old legacy System using Spring boot with Micro Services

●Use DB weaver database management system to connect to IBM DB2 with Redis Server

●Use Spring boot to create trigger events base on scan of packages

●Worked as a product owner to define business requirements and groom the product backlog.

●As Product Owner in splitting large user stories (Features, Epics) into smaller user stories using different techniques.

●Met regularly with Business and internal stakeholders to understand the company's plans for the products.

●Created product plans and user stories based on business and customer requirements for three different financial reporting products.

●Coordinated and managed development work with an offshore team.

●Conducted business process diagram, as part of gap analysis, to understand the ‘Current State’. Derived system level requirements from business requirements.

●Designed and developed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams and web page mock-ups using Microsoft Visio and Balsamiq tools.

●Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery

●Backlog creation, Backlog grooming, Story sizing, Sprint planning, Daily stand-up, Sprint reviews and Retrospective sessions in the above projects.

●Assisted project managers on several project management artifacts.

●Use Jira to Update my daily task and progress

●Using Velocity for Sprint Planning, using Scrum, Scrum ban methodologies to meet the Deliverable. Assist in overseeing project close-out

●Develop the detailed business requirements based on the High-Level requirements and information gathered from multiple business partners.

●Conducted and participated in walkthroughs of requirements and Use cases with business and IT team members.

●Designed Use case Diagrams, Workflow diagrams, Activity diagrams for most of Use Cases identified using UML/Visio.

●Highly involved in Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the change in the proposed system.

●Played major role to create the Business Requirement Documentation (BRDs), using MS Word and MS Visio that provided appropriate scope of work for technical team to develop prototype and overall system.

●Identified the schema to persist the mapping of new system to existing system codes.

●Reviewed test cases and test plan for UAT testing.

Business Analyst/ Data Analyst-Clinical Data research Veeva Systems

Syneos Health, Morrisville, NC 01/2018– 10/2019

Responsibilities:

●Clinical Trial with GRM application using Sales force and People Soft conversation FTE to HRS

●Provide accurate and timely information and escalates when there are issues

●Possess expert level functional knowledge of assigned application technology

●Demonstrate new functionality to clinical users seeking inputs on future direction

●Deliver functional specifications, design documents, clinical process workflow and related documentation for new development projects and/or enhancement and modification requests to be used by Clinical Systems Analyst.

●Experience with Veeva Vault EDC, Coder, CDB, and Study Start up, eTMF, CTMS, Payments, Site Connect.

●Use Veeva Vault clinical suit to update system documentation

●experience in clinical operations, site monitoring, study startup, TMF operations, and/or trial management

●Serving as a super-user for the CTMS and eTMF system and working with clinical operation leadership to establish workflows for document processing

●Utilize the Clinical Trial Management System (CTMS) to ensure that study files are current, accurate and complete.

●Assist project teams with trail progress by updating Clinical Trial Management System

●Proven track record leading process transformation programs, including influencing business leaders

●Experience in process management tools such as Microsoft Visio or Lucid chart

●Using Velocity for Sprint Planning, using Scrum, Scrum ban methodologies to meet the Deliverable. Risks and issues are proactively identified and managed.

●Assist Business Development in the application building process for new and existing Healthcare functionalities, including presentations and proposals

●Enhance good relationships with clients, designers, consultants and internal Wolters Kluwer clients

●Tracking the User Stories and Defects and ensuring that they are being worked based on priority.

●Use goBalto cloud base technology to collect cloud solution for clinical trial planning, data collection, trial execution and safety management and goBalto adds the leading industry cloud solution that significantly reduces clinical trial startup time.

●Elicited requirements from the SMEs and stakeholders to get clarifications on the business requirements to help System Testers to get a better grip on the project.

●Conducted numerous Joint Application Design (JAD) sessions and performed Gap analysis with the help of Business Workflow models and Workflow diagrams to analyze AS-IS and TO-BE scenarios.

●Performed risk analysis of the requirements to identify the key business risks areas for the project and prioritized the application development and testing.

● Assisted QA team with the understanding of requirements and bug issues.

Business Analyst with Java –Federal Insurance BCBS

High Mark HMHS Blue Cross Blue Shield – Camp Hill, PA - January 2016 to Dec2017

Responsibilities:

●Elicited and documented the requirements for automating new reports into Tableau for advanced Visualization and data analysis.

●Designed the visual diagrams using BPMN 2.0 for process improvements, Training, Process/Workflow Clarifications, Regulatory compliance & internal audit.

●Prepared and deployed off-shore/on-site resources accurately with timely manner.

●Supervised the project results, Business goals, relevant documents and reports for identifying the root cause, recommendations and track progress on corrective actions.

●Initiated Brain-storming and Focus group sessions with off-shore/on-site resources on process/procedure improvements for fulfilled accuracy.

●Organized daily status and standup meetings with the resources and client on report status& issues/risks updates, and checked for exactness.

●Gathered requirements specifications while analyzing business process and prepared BRD, FRD, Use-cases and conducted UAT.

●Coordinated activities with internal teams and clients (LOB’s); implemented processes into production environment.

●Managed multiple PMO projects and increased the team efficiency and productivity within a month.

●Exceled leadership and management skills. Maintained a strong relationship with the client.

●Use of various modules of Spring framework like Spring IOC, Spring AOP, Spring MVC, Spring Batch, Spring ORM,Transaction Management, Spring Security

●Implementing the persistence logic using JDBC, JPA, Spring JDBC, Hibernate framework..

●Design Batch process using Mainframe technologies to capture the updates from up-streams through nightly batch. Execute conversion using Mainframe technologies.

●Update and create new Linux/Unix files to migrate and start Java Multithread code and create batch file Mainframe JCL in the server manual and scheduler

Business Analyst/ Workday/ Sales Force

Abbott Laboratories, Abbott Park, IL Nov 2014 to Dec 2015

Responsibilities:

●Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.

●Assisted in building a Business Analysis Process Model using Rational Rose and Visio.

●Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).

●Part of a development team responsible for automated deployment of the Workday stack.

●Proficient in using Microsoft Excel and/or Access; experience working with large data files from multiple sources; using V-lookup and other functions, creating complex formulas and macros, pivot tables and reports

●Used Microsoft Visio to create flow charts.

●Review new/existing jobs as needed and determine the level using Hay Group Job Profile method of evaluation.

●Monitor the integrity of human resources information system (HRIS) data through regular audits, troubleshooting irregularities, as well as working and partnering with the HRIS team to research, correct discrepancies, and ensure compliance

●Prepared Ad Hoc reporting using excel

●Converted data from SAP HCM to workday.

●Used workday and Sales Force to solve issues.

International Bank of Chicago, IL Jan 14 – Sep 14

Business Analyst

Responsibilities:

●Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.

●Participated in understanding existing Sovereign's ACH processing system, daily PEP payment processing and analysis of PEP reports, payment distribution, daily reconciliation and balancing.

●Familiar with NACHA, EDI 820 and BAI file processing and their file formats. Also familiar FED ACH file processing for ACH returns, exception handling and NOC processing timelines.

●Prepared functional requirement documentation for ACH account analysis AA -pricing and billing, customer statements and customer communication functionalities.

●Worked with Payment system to receive payment module.

●Worked insurance module and mortgage with BRD and FRD for application

●Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.

●Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.

EDUCATIONAL QUALIFICATIONS

Aurora University May 2013 Aurora, IL

MBA in Human Resource Management System

Northeastern IL University Dec 2010 Chicago, IL

Bachelor of Science: Accounting & Marketing

`KEY SKILLS/Software Training only Hands ON

Business Analyst/PO

Product Owner

Product Manager

Prompt Engineering

Artificial intelligence

Python (Training)

Data Profiling

Data Analyst

Data Modeling

V-lookUp,Xlookup,Hlookup Macros

Pivot Tables

Cyber Security (Training)

Power BI (Training)

Tableau(Training)

SQL/ETL

Java with Micro Services Spring boot

Aws Solution (Training)

Azure Data engineering(training)

Scrum Master

Program Manager

Project Management

Contact this candidate