SIFKAT MEHDI

BBA, MBA, MS, CSM, APRM, APRA

LinkedIn: https://www.linkedin.com/in/sifkat-mehdi-7b24b0174/

Phone: (614)-636--7399 E-mail: adcg6w@r.postjobfree.com Columbus, OH 43220

Professional Summary

A proficient IT consultant with 9 years of experience in process analytics, application development, data transformation, system implementation and project portfolio management.

Good understanding of Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile (SCRUM, RAD, RUP) and Spiral.

Expert of conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME's to obtain domain level information.

Hands on experience of creating and transforming business requirements into BRD, functional specifications, use cases, business models, data models, UML diagrams (class, activity, sequence, and sequence diagrams).

In-depth understanding Gap analysis for AS-IS and TO-BE business processes.

Excellent skills in Performance Management to support strategic planning, goal setting, establish accountability and enhance decision making.

Clear comprehension of Business Process Re-engineering and Reverse engineering.

Expert of Impact analysis (Feasibility analysis, cost/benefit analysis, Risk analysis) for Organization Change Management and Configuration Management.

Key player of requirement gathering using interviews, meetings, document analysis, requirements workshops, surveys, business process descriptions, business analysis, task and workflow analysis, brainstorming, focus group discussion and prototyping.

Liaison among cross functional teams to establish the technical vision and analyze tradeoffs between usability and performance needs.

Proficient in Business planning, resource, monitoring, scheduling and budgeting and project portfolio management.

Hands on experience of creating and executing test scripts, test plans and test scenarios (both manual and automated testing).

Profound knowledge and skill to perform UAT testing to validate system from the user’s perspective.

Extensive experience with data analysis including data modeling (tools: Erwin, SQL Data modeler), data mapping, data management and data validation.

Strong analytical, process-oriented, problem-solving/issues-resolution skills along with excellent communication skills.

Develop and document Proof of Concept (POC) with key functionalities to ensure successful implementation of new process or technologies and to provide general idea what the final system would look like.

Technical writing and user manuals with illustrations, design, implementing new process & technology.

Expert of user Story, use Cases, business model, algorithms and various diagrams such as class, collaboration, activity, state-chart and sequence diagrams.

Strong leadership skill to lead any team towards the project goal and achieve project milestone.

A knowledgeable resource who is capable of implementing industry best practices and processes to keep pace with the changing world.

Technical Skills

Databases: MS SQL Server 2012/2008R2/2008/2005/2000/7, MS Access

Languages: SQL, HTML5, CSS3, Java, Java Script, jQuery, Angular JS, XML, AWS (Amazon Web Services), .net, COBOL.

Business Intelligence: MS SQL Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Service (SSRS), SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Crystal Reports 8.5

Modeling: ERWIN, MS Visio

Operating Systems: Windows Server- 2008/2003/NT/XP/2000, Windows vista. Windows7, iOS

Development Tools: MS Visual Studio 2005/2008/2010/2012, MS SQL Management Studio

Project Methodologies: Waterfall, Agile, Spiral, SDLC, and UML

UML Diagram Tools: Microsoft Visio, Rational Rose

Prototyping Tools: Dreamweaver, Mockup Screens, Balsamic

Defect Management: HP Quality Center, Bugzilla, JIRA

Testing Tools: WinRunner, Test director

Wireframing: Azure, Mockup Screen, Mockup Builder

Education

Master of Information System Engineering and Management

Campbellsville University, KY 2017

Master of Business Administration (MBA)

California State University, East Bay 2013

Bachelor of Business Administration (BBA)

NSU, 2009

Certification

Certified Project Manager (APRM)

(International Organization for Project Management)

Certified (Business) Requirement Analyst (APRA)

(International Organization for Project Management)

Certified Scrum Master (CSM)

(International Scrum Institute)

Professional Experience

Business Analyst, June 2018-Dec 2019

Honda, Marysville, OH

The project was to conduct process improvements for existing systems, help cross functional team with interface design documents, develop standards and achieve overall organization efficiency.

Responsibilities:

Analyzes business partner's operations to understand their strengths and weaknesses to determine opportunities to automate processes and functions

Help the team with Scope identification, Business planning, execution and monitoring of deliverables revolving around organization change management.

Assists in the business process redesign and documentation as needed for new technology

Create BRD, translates high level business requirements into functional specifications for the IT organization and manages changes to such specifications

Negotiates agreements and commitments by facilitating communication between business unit(s) and IT from initial requirements to final implementation

Plan and execute stakeholder management, Impact analysis (Feasibility, risk and cost analysis) for any change request.

Create functional document for ETL job and dashboard reports published on a .net framework.

Provide support in tuning SQL statements, procedures, triggers and optimizing code

Apply Lean Six Sigma methodology to provide process/quality improvement by focusing on eliminating waste and reducing errors.

Create holistic dashboards from multiple data sources using Tableau, to support current initiatives

Implement Oracle EBS to help users manage global businesses, improve decision making, reduce costs and increase corporate performance

Use on-demand multi-tenant cloud integration platform like Dell Boomi for data integration, pull data from multiple sources and mov it to AWS Redshift.

Develop Requirement Traceability Matrix (RTM) for various documents and find out the gap to improve business procedure.

Help data migration team to move raw data from varies sources to AWS/Redshift.

Create communication plan to make sure smooth flow of information and train new users once the new changes are implemented.

Work with business partners with one business function to align technology solutions with business strategies

Work closely with the business and Global teams to design EDI centered solutions, gather requirements, and see implementations through to completion.

Define the business process, gather requirements and actively help the team implement ServiceNow.

Facilitate change management from the business side to help implement and carryout new processes.

Assists Project Manager responsibilities in preparing and facilitating the project plan for smaller projects

Conducts feasibility studies to assess cost/benefit, efficiency and technical viability of solutions to business problems

Experience working with cross functional teams to gather requirements and coach less experienced staff

Environment: Confluence, JIRA, HP QC, MS, ServiceNow, SAP, Oracle Cloud, Visio, MS Project, Outlook, Red Hat middleware

PM/BA, November2017-May 2018

McGraw-Hill Education, Columbus, OH

McGraw-Hill Education is an American learning science company and one of the "big three" educational publishers that provides customized educational content, software, and services for pre-K through postgraduate education. The project is to build an internal system to support business units with asset and contract management.

Responsibilities:

Lead requirement gathering session and support an agile software development team.

Create deliverables for building a multitenant, large-scale web application (SaaS) with responsive designs.

Support the business and technical team with a wide range of documents that include but not limited to GAP analysis, Impact analysis, Requirement Traceability Matrix (RTM), BRD, FRD, Process flows, UML diagrams, Wireframing, use cases, test cases and test scripts.

Elicit business requirements through interviews, workshops and/or existing systems documentation or procedures

Write epics, user stories, defining specific, concise acceptance criteria, and groom stories into multiple smaller stories based upon logical separation points.

Proactively validates conflicting or unclear inputs from business teams and technical teams

Work in an entrepreneurial environment – become a self-starter, wearing a few hats, successfully deal with ambiguity and complexity in the project.

Use regression analysis to understand to help the team with strategic decision making on sales and marketing.

Use data integration tools like Dell Boomi and Alteryx for data migration to central data lake, create reports using curated data from the data lake.

Code, test, modify, debug, document, and implement PL/SQL programs

Work with IT and business users to resolve support and technical questions, contribute to coordination and planning of Business Objects and Tableau related activities

Create reports using salesforce to help strategic decision and track market trend.

Use big data to better understand customers and their behaviors and preferences, create reports for strategic decision making.

Implemented JDE Warehouse Management System (WMS) for inventory and supply chain management

Act as a SME for organization change management (OCM) and guide the team to analyze and implement new changes, establish OCM best practices and monitor progress.

Efficiently use agile development tools – Jira, Confluence to support project portfolio management.

Exercise project management skills that includes approval process and management engagement in processes.

Help project portfolio management and coordinate with cross functional team using tools like Lotus Notes.

Environment: JIRA, Confluence, Einstein Analytics, ServiceNow, Oracle Cloud, HP QC, MS Visio, MS Project, Outlook, AWS Redshift, JAVA, SQL Server, Salesforce, MS Excel

Lead Business Analyst, November 2016 to October 2017

Wolters Kluwer, New York, NY

Project was to conduct processes improvements to comply with federal governance and minimize risk. Creating GAP analysis and take corrective action accordingly to incorporate regulation/business roles at the enterprise level.

Responsibilities:

Partner with product managers, development, sales, training, professional services and technical support teams to ensure market needs are properly reflected in the technology product road map and that product specifications meet customer technology requirements.

Define functional requirements and process workflows, and drive development and QA efforts needed to successfully support legislative updates and client-driven functional and technology enhancements.

Analyzing data integration and electronic data interchange (EDI) requirements and perform logical mapping that includes field-to-field mapping, formatting rules, validation rules, and transformation rules.

Coordinate release planning in support of these updates, prioritizing changes and participating in design reviews to ensure that developed solutions meet client needs prior to the legislation effective date.

Drive cross-functional process improvement efforts by translating and simplifying requirements in collaboration with stakeholders using six sigma methodology.

Develop Features, Epic and user stories and groom those stories to make sure it has all the necessary details for development, develop acceptance criteria for each user story and estimate those for upcoming sprints.

Facilitate product design and Software implementations, document scalable implementation processes.

Coordinate the change request process and use JIRA and Confluence to track the changes.

Work in collaboration with development to help to define where new technology can be leveraged for our products.

Use data analytics approach (regression) to help the business understand relationships between data points to predicting sales, understanding inventory levels and supply and demand.

Creating Requirement Traceability Matrix (RTM) to link business and functional requirements to test scripts and test plans to validate the system.

Helping the compliance team to put policies procedures in place, know the risk areas and establish an enterprise wide Compliance program using Archer to meet federal governance standards.

Work with the legal team to incorporate new changes in financial regulations to be legally compliant, minimize risk of operation and ensure fair and equal access to financial services.

Act as the technical product expert resource for sales, client support and other departments.

Partner with the business team and lead the planning, execution and management of OCM plans for the project.

Refining metrics and standard reports to better serve the needs of executives seeking decision support

Conducting market research with Big Data to track external trends relative to specific products, geographies and demographic segments

Travel to client site to participant in the technology re-platforming initiative.

Evaluate and prioritize requests for product changes/enhancements and the impact on the project schedule and budget in MS Project

Support internal processes, procedures and activities relating to client installations and updates of software products.

Participate in design reviews to ensure what is being developed meets the meets the clients’ needs prior to the legislation’s effective date.

Collaborate with professional services to support, BBE and Dashboard workflow and reporting to ensure successful adoption in major software implementations.

Manage the center and ensure timely updates to report known technical issues and application releases.

Environment: Microsoft Visual Studio, Lotus Notes, MS Excel, ServiceNow, Einstein Analytics, MS Project, MS Word, PL/SQL, Microsoft Visio, Salesforce, CRA Wiz, HMDA Wiz, TFS, Outlook.

Lead Business Analyst/Project Coordinator Aug 2015-Oct 2016

NY State Insurance Fund, Albany, NY

The project covers development and integration enhancements for the modernized NYSIF Billing and Collections System to complete core billing functionality, as well as integrate new business process for premium audit department.

Responsibilities:

Follow NYSIF’s standards and tools, supporting, but not limited to, project management methodology, Requirements Methodology, SDLC (software development life cycle), Enterprise Architecture standards and the IT governance process.

Requirements Management and Communication: Requirements analysis activities; Communicating project requirements, requested changes and testing needs to all stakeholders; Acting as a liaison to management and advisor to developers, business users, and testers.

Use Java content management software like Apache Roller to support the creation and modification of digital content.

Create Epic and user stories, populate those stories with appropriate functional and nonfunctional information and mockups and review those with offshore development teams.

Help the project team automate their Risk and Compliance program using RSA Archer.

Conducting Requirements Elicitation: Defining customer's business needs and ensuring they are properly interpreted and translated into application and operational requirements; Conducting requirements elicitation sessions or JAD sessions to elicit requirements; validating stated requirements expressed by a stakeholder matches their understanding of the problem and their needs.

Creating and executing test scripts and test plan to validate the system.

Coordinate with the audit team with documentation and newly developed business process.

Create and update Traceability Matrix to reduce margin of error and facilitate government compliance.

Coordinated the change request process and use JIRA and Confluence to track the changes.

Project Portfolio Management (PPM): Project schedules and budgets, including task management and coordination; project change control and organizational change management.

Documenting Requirements: Creating textual requirements, use cases and business / workflow diagrams to support design solutions; Prioritizing requirements to ensure design, testing, and implementation efforts focus on the most critical requirements; Organizing requirements by creating sets of views that are comprehensive, complete, consistent, and understood from all stakeholder perspectives.

Perform GAP analysis and recommend the industry best practices to fill up the gap between current and future state of the project.

Facilitating daily Scrum session to provide valuable input in the Sprint planning and product backlog Item (PBI).

Use TFS for source code management (either with Team Foundation Version Control or Git), reporting, requirements management, project management, automated builds and testing.

Experience designing and developing dashboards and reporting metrics using business intelligence software like Tableau and Cognos.

Dealing with processes, governance, policies, standards and tools as part of MDM to consistently define and manage the critical data of the organization.

Using different BPM technique (UML diagram, data flow diagram, role activity diagram, Gantt chart, and object-oriented technique) to describe and communicate the current or intended future state of a business process.

Verifying and Validating Documents: Obtaining and maintaining consensus among stakeholders to verify requirements specifications and models meet the necessary standard of quality to allow them to be used to effectively guide further work; Validating that all requirements support the delivery of value to the business, fulfill its goals and objectives, and stakeholder needs.

Hands on experience with Metadata to assists in resource discovery by allowing resources to be found by relevant criteria, identifying resources, bringing similar resources together, distinguishing dissimilar resources, and giving location information.

Involvement in effective collection, maintenance and reporting of data as part of the Master Data Management (MDM) to manage the integrity, quality and accuracy of the organization data.

Use ERP tools like Oracle 11i and R12 for business intelligence and customer relationship management.

Tracking anomalies and outliers within financial and transactional data that might signal fraudulent activity using Big Data.

Environment: Microsoft Visual Studio, MS Excel, MS Project, MS Word, PL/SQL, Microsoft Visio, Clear Quest, Advent APX, Blueprint, Innotas, HP quality center, Oracle Financial (EBS), IVR, HL7, XML, EDI, .Net, Business Object, TFS (Team Foundation Server), Azure, Balsamic mockups, Informatica

Lead Business Analyst, October 2014 to July 2015

NY Department of Labor, Albany, NY

The purpose of this project is to conduct a Business process reengineering and create detailed technical process flows of the interfaces, extracting business rules from the COBOL codes, creating reports and analysis documents and presenting those deliverables in the peer review session with the legacy developers to ensure quality.

Responsibilities:

Create project charter to provide a preliminary delineation of roles and responsibilities, outline the project objectives, identify the main stakeholders and define the authority of the project manager.

Interact with cross-functional teams (subject matter experts, developers, architects and database) and staff to ensure requirements are thoroughly and accurately documented and to design and document recommendations for improved business processes that enable the organization to achieve its goals.

Review and analyze data for reverse-engineering of the legacy software systems as well as write queries, perform data analysis, validation, and mapping.

Work as a liaison among stakeholders to elicit, analyze, communicate and validate the requirements for changes to current business processes, policies and information systems.

Using EBS 11i for planning and executing enterprise resources and business intelligence.

Evaluate and implement SaaS (Cloud bases solutions) to serve as a single point of reference and streamline business process.

Keep track of project deliverables and coordinate changes across the board by creating Requirement Traceability Matrix (RTM).

Prepare communication plan to identify the key stakeholders and means of communication to foster organization change management process.

Use Qlikview and Cognos to turn business data into strategic decision-making resource, foster Business Intelligence and BPM.

Develop user stories and groom those with the technical and business stakeholders, actively participate in sprint planning, sprint retrospective and application release.

Create functional specification like use cases, process flows, system spec document for the Interactive Voice Response system (IVR).

Developed scope documents, financial projections, budgeting and analysis for the project using IBM Cognos10

Coordinate use cases, process flows and other industry standard business requirements documentation with cross-functional teams for seamless system design.

Perform GAP analysis to definite the key success and risk factors associated with the change management approach and ways to overcome those.

Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.

Extensively involved in MDM to help the organization with strategic decision making and process improvements. (streamline data sharing among personnel and departments)

Use file net for Integration with Microsoft SharePoint and Microsoft Office to help increase productivity and serve as a repository for all the stakeholders.

Involvement in COTS solution implementation by eliciting requirements, conducting feasibility and risk analysis, creating UML diagrams and use cases to illustrate how the solution will interact with the existing systems.

Experience in Object Oriented Analysis and Design (OOAD), Business Process Management (BPM) and BPMN for demonstrating business processes.

Provide a status report to project manager in the format specified, including issues and risks.

Use Java content management software like Apache Roller to support the creation and modification of digital content.

Extensively use TFS for defect management, version control, test case management and reporting.

Environment:

Microsoft Visual Studio, MS Excel, MS Word, MS Project, TFS, PL/SQL, Microsoft Visio, Clear Quest, Test Plans & UML, Business Objects, PeopleSoft Time, primavera, UNIX, IVR, ERP Tools, HP Quality Center, BI Tools (Qlikview, Informatics), XML, EDI, .Net.

Data Analyst, Jan 2014 -Sep 2014

Office of Superintendent of Public Instruction, Olympia, WA

The focus of the project is to collect student data from different sources and create ETL package to populate the fact and dimension tables in the database, create chats and drill though reports using SSRS and deploy those reports to the web app. The project also includes process improvement for Cyber Security.

Responsibilities:

Follow scrum methodology to keep track of the project assignments and accomplishments.

Hands on experience with Teradata for Data Warehouse Management (DWM) which includes but not limited to Dimensional Data model, Star schema, Snowflake schema, slowly changing dimension, normalization and demoralization, conceptual data model, physical data model, logical data model using tools like Erwin and ER/Studio (data modeling tools).

Conduct JAD sessions, gathered business requirements, analyze and prioritize requirements using Rational Requisite Pro.

Develop and tune T-SQL, PL/SQL Complex Queries, Stored Procedures, UDF'S, triggers, views, Indexed views and error handling using Try-Catch blocks

Create business rules, FRD and mapping documents for the SSIS packages.

Creating SSIS package (parent & child package) using different control and data flow tasks, to populate the fact and dimension tables in the database using Informatics.

Create complex stored procedure using joins, functions, CTE, input and output parameters for each level of drill through reports and charts.

Develop SSRS reports (Pivot Table, Pivot Charts, Graphs) for the web app using expressions, functions, stored procedure.

Use Cognos Business Intelligence and Project Management tools for strategic decision making, producing and delivering enterprise reports, scorecards, dashboards, ad-hoc analysis, and OLAP analysis

Use SAP ERP tools for data storage and information management with established workflow across different departments and functions.

Transform operations with best-in-class capabilities for portfolio (PPM) and project management and maintenance using OPPM.

Develop data table landing page and report viewer page to deploy the charts and drill though reports and make the web app user friendly by providing drop down and other functionalities.

Use Identity Access Management (IAM) to initiate, capture, record and manage user identities and their related access permissions in an automated fashion.

Wring test scripts and conduct manual testing for all the SSIS packages and SSRS reports to ensure the highest quality.

Worked in a team and effectively contributed towards the goal of the projects by providing valuable inputs.

Environment: SQL Server 2012/2008R2, Server Integration Services 2012, SQL server Reporting Service 2012/2008R2, MS Visual Studio, MS Excel, T-SQL, ERWIN 7.2, C#, MVC, Microsoft Visio, Erwin, ER/Studio, Clear Quest, Test director, Test Plans & UML, Business Object, TFS, IVR, Teradata, MDM,

Business Analyst, Feb 2011 to December 2013

Bank of New York Mellon, Somerset, NJ

BNY Mellon is a global investments company dedicated to help its financial asset management. The project includes process improvement and change management across multiple business units. (Capital market, Regulatory Reporting, Credit Risk, Market Risk, Business Intelligence).

Responsibilities:

Work closely with Financial Advisors, as well as SMEs in Capital Markets, Mutual Funds, Advisory, Risk, Compliance, Legal, Operations and Technology.

Conducted JAD (Joint Application Development) sessions, gathered business requirements, analyzed and prioritized requirements using Rational Requisite Pro

Be active in steering committees of key regulatory projects to understand risk and plan accordingly for future potential work streams.

Identify and validated high potential business opportunities for stakeholders and developed customized business strategies that are aligned with regulatory governance.

Work closely with the production team to ensure the accurate submission of EBS (Electronic Blue Sheet) that includes the name of the security, its price, the date of the transaction, the size of the transaction and the parties involved.

Develop KYC standard and policies, tools & techniques according to the guideline of OCC (Office of the Comptroller of the Currency) to provide a secure risk free environment for business.

Create Business Process Models (BPM) which include the modeling of all activities of a business from the conceptual to procedural level.

Support portfolio management which includes choosing right financial product, market research, risk and compliance and portfolio optimization.

Hands on experience of wealth management/Asset management trading systems and financial products such as Equity, FX, Options, Fixed Income and Mutual Funds

Manage day-to-day project & business deliverables which includes but are not limited to development & documentation of work effort estimates, Policies & procedures, Business processes changes, Functional system enhancements, Testing requirements.

Work with Regulatory compliance team for designing & building compliant solutions, Developing training & communications

SME support on key CCAR projects pertaining to interpret and validate system and business logic.

Monitor end-to-end data flow and functioning logic of proprietary Market Risk Management tool

Effectively design root-cause analysis for exposure movements to ensure minimum turnaround time.

Define test strategies and associated test scripts for the verification and validation of business requirements and associated functionality

Environment: Rational Rose, Rational Requisite Pro, Clear Quest, Clear Case, SAP, Nice Actimize AM suite, Software Development Life Cycle (RUP), SOA, UML, MS Project, MS-Visio (UI Mockups), MS SharePoint, IBM Cognos10, Advent APX, Manhattan.

Contact this candidate