Business System Analyst
Resume:
Arshad Khan
*********@*******.***
Summary:
Over ten years of experience in the field of Information Systems as a Business Systems Analyst and Technical Analyst.
Experience with preparing benefit justifications and serving as the main liaison between the business users and technical team handling large, complex enterprise level projects strategic as well as technical.
Highly proficient in Rational Unified Process (RUP), Capability Maturity Model (CMM), UML, Software Development Life Cycle (SDLC), Agile (Scrum). Agile and CMMI processes bundled with Team Foundation Server.
Extensive experience in Writing Use Cases, scenarios, Business processes, work flow diagrams and process maps.
Experience in strategy development and process improvement, well versed in BPM guidelines and strategies.
Extensive experience in data profiling and trending of data patterns.
Extensive experience in formulating Business Case and following up with stakeholders to ensure viability, accuracy and profitability of business case throughout the project lifecycle.
Experience in writing scalable and high performance code.
Experience of communicating with all levels of stakeholders PM, SME’s identifying bottlenecks, scope creep, early identification of issues, mitigation strategies, prioritization of delivery of artifacts.
Strong ability in analyzing and specifying business, functional and technical requirements, and solid understanding of change request process.
Experience in leading teams during multiple phases of project.
Possess excellent analytical skills coupled with interpersonal and self-organizing skills. Ability to adapt to changing work environment to implement business and process solutions in an efficient manner.
Skill Set:
Tracking Tool
Key Requirement Table/ Requirement Traceability matrix, Clear Quest, Rational RequisitePro, TFS.
Languages
SQL, HTML, XML,C#
Databases
Oracle, DB2, MS-Access, Lotus Notes, SQL
MS–Office Suite
Excel, Visio, Outlook, PowerPoint, Share point
Operating Systems
UNIX, Windows, Linux
Tools
Business Objects, SPUFFI, Rational tool suite, Team Foundation server, Visual Studio, Share Point services, UNICA.
ETL Tool
Informatica, SQL server Analysis services, File Aid
Deloitte & Touche Sept 15 – Till Date
Senior Business Analyst
Involved in implementation of NOL module for Deloitte Tax Integrated Platform.
Involved in writing use cases, user stories, calculation flows and models
Involved in creating wireframes for Frontend development
Involved in backlog prioritization and user stories grooming
Conducted daily Scrum meetings with Offshore Development team
Involved in documenting dependencies, roadblocks for integration decisions for module into Portal
First level support for NOL module
Lead team of onshore and offshore BA’s
Jones Lang LaSalle March 15 – Sept 15
Senior Data Analyst
As part of Global Data Governance team involved in implementing standards for corporate wide implementation of Real State Data.
Created tools for data quality matrix using SQL Server
Involved in creating reports for Americas region
Involved in writing stored procedures for manipulating data
Involved in reviewing ETL process for all the regions using IDQ
Interacting with end users and facilitating meetings with data issues and fixing strategies
Involved in corporate wide presentation for Data governance implementation benefits and single source of truth concept
Interaction with Executives and other stakeholders regarding requirements elicitation and documentation of MDM implementation
Involved in documenting process improvements required for Data Governance
Point of contact for Data Governance related questions for Americas region
TCF Inventory Financing, Schaumburg IL Jan 14 – March 15
Senior Business Analyst
Involved in implementation of Data Warehouse for enterprise. Improvement to Customer Portal (CARE Portal). Revamp of Intellicredit and Intelliservice legacy applications to MVC architecture. First level support of Data warehouse support to internal and external customers. Implementation of TFS server Agile methodology implementation for software lifecycle.
Responsibilities:
Involved in writing use cases and mappings for data warehouse
Involved in writing reporting queries for customers using SQL server
Involved in creating mapping document, Data Flow diagram and ERD
Involved in writing test cases, scenarios and test suites using TFS
First level support of business reporting portal (CARE Portal)
Performed duties of Scrum Master.
Review of Data warehouse processes for adequate throughput and high availability of up to date information for customers.
Interaction with end users for any problems with reports and resolution proposals
Interaction with end users for any latency issues faced by users and proposed resolution
Volkswagen Credit Inc, LibertyVille IL June 13 – Jan 14
Senior Business Analyst
Involved in enterprise wide implementation of Automotive Finance application replacing several legacy applications at Volkswagen credit Inc. Leading team of BSA’s for data conversion for the whole project involving mapping, transformation and loading of relational databases and flat files to FA’s Main frame environment.
Responsibilities:
Involved in technical reviews of backend ETL, batch and application code written in C#, VB.Net
Involved in writing enterprise wide approach for data conversion.
Involved in creating BRD, FRD, Use cases, Process flow maps and Test suites
Involved in creating Tracibility Matrix for requirements management and test management
Lead team for reporting requirements and delivery.
Involved in extracting data from local data sources using Informatica and File Aid
Mapped over 2000 data elements from local data sources to target in AF.
Involved in creating tool for requirements management using Access.
Involved in GAP analysis regarding availability of data, infrastructure.
Involved in creating process maps.
Involved in writing SQL queries and creating Excel macros for transformation and validation of data elements.
Involved in financial portfolios data analysis.
AON Corporation, Chicago IL Aug 08 – June 13
Senior Software Engineer
(Team lead of Impact forecasting data conversion and reporting team)
Involved in reverse engineering legacy code for data mapping engine and eliciting and documenting requirements for changing the engines backend sources from flat files to database driven tables. Lead team for design, coding and testing phases of the project. Helped in code profiling for performance enhancements. Kept track of change management process. Interaction with business stakeholders from my team and other teams for clarifying business needs and issues faced by offshore development team. Formulized, documented and enhanced process of receiving portfolio data from customers.
Responsibilities
Responsible for eliciting and documenting functional and business requirements
Creation of process maps and gap analysis.
Heavily involved in design of database schema for data mapping engine.
Creation of use cases for end to end data conversion process.
Created and got approval of business units for business case.
Interaction with Business units for reporting, scope creep, identification of issues and mitigation policies.
SME for data conversion process and software.
Coded high efficiency multithreaded modules for data conversion engine.
Lead team for design, coding and testing.
Involved in code reviews and profiling.
Created physical schema of back end database.
Worked with security teams for AD driven roles based application security
Allstate Insurance, Northbrook IL Nov 07 – July 08
Sr. Business Analyst
Involved with projects with Internet Marketing team implementing interaction with customer through all channels of bind (Email, Exclusive Agents) based upon business rules regarding timing, life events and events related to policies issued by the company.
Responsibilities
Responsible for creating Use cases, functional and business requirements, process maps, campaign flow diagrams with time lines and identification of process bottlenecks
managed two other BA’s.
Interaction with developers, system analysts, data owners discussing the specifications provided by the business partners and changes in the process.
Interaction with Marketing Operation team for creating campaign management document.
Interaction with enterprise data management team for resolving data availability and latency issues.
Worked closely with PM for project status, risk and change management processes.
Generation of daily and monthly status reports.
Improvement to already in use templates for several documents, approval by management.
Lead test team for UAT and functional test.
Applied approved methodology changes to marketing department process for quick and efficient retrieval of older campaigns.
AON Corporation, Chicago IL April 07 – Nov 07
Systems Analyst
Involved in process improvement for Software development. Implemented Share point portal site using Team Foundation for the team. Involved in documenting processes, test strategy and production support for the product. Documentation and verification of Requirements. Involved in Data conversion for analyses using SQL server and access databases.
Responsibilities:
Owned component of the product (Data Converter), involved in code changes and updates.
Helped in enhancing already used processes according to unit requirements.
Wrote use cases according to the functional requirements.
Gathered requirements and developed design specifications for the earth quake model for Japan.
Reverse Engineered requirements for Data Converter.
Responsible for testing different scenarios for the product.
Implemented document repository for the team using Team Foundation Server document libraries.
Implemented Team foundation server for team collaboration, bug tracking, version control and Code profiling.
Implemented infrastructure for Team foundation server, template changes and Work Item changes.
Involved in software evaluation (Dev partner) for code profiling and performance issues.
Accenture LLC, Chicago IL Sep 05 – April 07
Analyst/Programmer
Involved in analysis, design, and testing of applications. This work begins by translating business and functional requirements into loosely coupled components. Responsible for requirements management including all activities such as gathering, analyzing, specifying, validating and tracking requirements.
Client: State Farm Insurance Companies, IL Oct 05 – April 07
Sr. Business Analyst
Project: ECRM-Household Marketing Phase 3
This project serves to expand and enhance the toolbox of on-line marketing tools deployed to the Agents Business System, beginning with the on-line propensity scores database. This effort is creating the ability for Agents & their staff to create more refined lists by providing additional search capabilities across a wider range of criteria.
Responsibilities
Responsible for creating Use case scenarios and writing use cases as per the specifications and requirements Analysis.
Responsible for gathering requirements and creating functional design specifications and design documents.
Interaction with developers, discussing the specifications provided by the business partners and changes and discrepancies in the application.
Business Software Solutions, Brunswick NJ Jan '04 – Aug '05
Business Analyst
Project: BSS Portal 1.0
Implemented web portal created for company’s intranet and external clients.
Responsibilities
Performed Requirements Gathering & Analysis by Actively soliciting, analyzing and negotiating client requirements, while leading the technical requirements analysis, driving the system design and construction.
Documenting work flows and results of business analysis and obtaining sign-off from client on specifications
Created and implemented user training of the updated system.
Involved in re-defining business process, documenting enhancements.
Responsible for creating Business flow diagrams and work flow diagrams in MS Visio.
Guided a team of automated testers to design, develop and implement automated test scripts using Win Runner.
Education
MS Computer Science
St.Joseph’s University, PA
BE Electronics Engineering
N.E.D University of Engineering & Technology, Karachi
Contact this candidate