Project Manager Sql Server

Rehan

Sr. Business Analyst

Email: ***********@*****.***

Phone : 848-***-****

Summary

Possessing 8+ years of Information Systems Specialist experience delivering Business Solutions in various domains of IT sectors.

Profound experience as a Systems Business Analyst and Quality Software Assurance Specialist in the fields of Financial, E-commerce, Health Care and Benefit Services.

Significant knowledge of Business Analysis Methodologies and Project Implementations using Interactive Software Development Life Cycle (SDLC), Rational Unified Process (RUP), Waterfall and Agile Methodologies from inception through completion.

Significant experience on AGILE methodology.

Excellent understanding of large scale IT Infrastructures and ability to adapt the environment’s needs to deliver exceptional quality in the work..

Profound practice to recommend best methods of capturing Business Requirements and work with team in developing workflows using BPM tools.

Facilitate evenhanded sessions/meetings across individuals and cross-functional teams.

Expertise of Unified Modeling Language (UML) and Business Process Modeling Notation (BPMMN) in visualizing and documenting the artifacts such as Use Case, Activity, Class and Sequence Diagrams, Business Process and Automated Workflows using MS-Visio 2010.

Delivered project solutions along with the team as a Subject Matter Expert (SME) under a fast paced environment and satisfy the needs of the Business Partners of every application department.

Excellent expertise in enhancing co-ordination between different teams and promote the Functional Flow of the Business Process.

Perform Root Cause Analysis in identifying the issues faced by project in the Track Tool in coordination with the Testing Team.

Quantify and evaluate the gaps between the “As-Is” and “To-Be” Business Processes and act accordingly.

Understand Management’s necessities and develop quality documents for Presentational, Analysis, Reporting and Metrics purposes and keep teams updated all levels of Organization.

Work closely with Management in the delivering Project Deliverables, communicating with Business Areas to acquire project requirements, generating Product Authorizations, Approval Packages, Exceptions, Dependencies and other related tasks using MS-Project, SharePoint & Lotus Notes.

Communicated with Development Teams, Capacity Teams, Hardware Teams, and OS Teams & Testing Teams to ensure that all the phases of the project are implemented appropriately.

Hands on experience in Web based Application development projects

Develop reports based on the metrics of the Project Results and maintained versioning of all the documentation for more visibility of the progress of the project.

Profound decision making ability to facilitate team in the organization of different phases of the project and to ensure that everything is working as designed.

Experience in conducting Joint Application Development (JAD) sessions and capture Business Requirements from the partners, detailing the Meeting Minutes keeping the team updated about the latest requirements.

Experience in designing and developing reports on SSRS (SQL Server Reporting Services), SSAS (SQL Server Analytical Services) and OLAP (Creating cubes).

Excellent knowledge in ETL (Extract – Transform – Load) using SQL Server Integration Services 2005 /2008 (SSIS), DTS, Bulk Insert, and BCP.

Excellent multi-tasking skills and ability to work with teams across different time zones globally.

Good understanding and hands-on experience about Change Management Process involving Implementation of Changes, Interaction Requests, Raising Tickets, Assigning Problem Records using HP Service Manager.

Profound experience in working with Project Managers and Project Planners in identifying the any potential issues or gaps and provide a guidance and direction to handle such situations.

Excellent written and oral communication skills. Ability to handle sessions effectively between on-site and off-shore teams.

Quick learner in fast paced environments and easily adaptable to work with different teams to achieve productive business results.

Education:

Masters’ in Business Administration (USA)

Business Analysis

Business Requirement analysis, Business Rules, data flow diagram, flowcharts, business process model, gap analysis, BRD, FRD

Methodologies

RUP, UML, Agile, SDLC, Waterfall model, Use Cases, JAD, Scrum

Business Modeling/Work Flow Tools

MS-Visio, Business Process Modeling Notation, Unified Modeling Language (UML & UML 2), DIA, SharePoint, Lotus Notes, VISIO

Operating Systems

MAC-OSX, Windows 98/2000/2003 /XP/VISTA/7.0, Android OS, iOs, SQL Server Business Intelligence Development Studio (BID), SQL Server Analysis Services (SSAS) SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Databases

MS-ACCESS,

Web Technologies

HTML Technologies

Defect Tracing Tool

JIRA, Track

Experience:

McKinsey (State of NY) (Health Care Department) 2013 May – till date

Albany, NY

Sr. Systems Business Analyst

Responsibilities:

Gathered high level requirements by conducting stakeholder interviews and Focused Group Discussions and documented it.

Involved actively in AGILE methodology Implementation for all the phases of the project.

Work closely in association with Internal Teams and Business Partners in researching suitable technology platform to enhance Business Process.

Worked with Senior Managers, Stakeholders and Peers to roll out and sustain business processes.

Worked with Project Planners in work allocation and coordination activities (tools like Primavera & Clarizen), monitored and resolved all the project dependencies associated with different teams internal and external to the project.

Took initiatives to capture information during meetings and prepared Document of Understanding during different phases of the project.

Conducted Assessment Meetings, understood the Business Requirements and developed Business Process Descriptions and Workflow Analysis for the Development Team.

Gained control over the expectations of the Development Team, Testing Team and Deployment Team and work with management to show day-to-day project progress.

Collaborate with Technical Experts and Business Units to determine the best possible reporting mechanisms.

Worked with development team to advance the progress of development of Application development

Gathered raw information about the current artifacts and composed them into Graphical Presentation to have a Dash-Board results for the Management Team.

Helped business and technical people in prioritizing wish list and managing the small Change Requests

Defined system scope and objectives and prepared BRD(Business Requirement Document) and FSD(Functional Specification Document).

Designed/Edited/Formatted Process and Technical Documentation with the help of internal teams and maintained all the versions of the documents on SharePoint and Lotus Notes.

Be a liaison between Product Development, Technology, and Internal Business Units.

Decompose high level Business Requirements into an appropriate level of business rules and detailed User, Functional, and Non Functional requirements using alternative views such as flows, diagrams, models, and use cases when applicable

Work with development and business personnel to develop and execute plans to test and validate systems/applications and business requirements including developing User documentation, first draft of training materials, manual updates, and field communications.

Provided direction for work executions, information handling and guided the team in the aspects of Planning, Coordinating, Resolving Dependencies and Problem Solving.

Carefully maintained all the information between different teams and communicated with the project planners and implementation analysts and prepared an Implementation-Ready Environment.

Immediate focus on active Production Problems, perform a Corporate Navigation to identify the crucial personnel required to resolve the problem and conduct a Priority Meeting to address the issue within the fastest possible time.

Build a fantastic Professional Relationship with Team Members inside and outside the project to enhance the productivity of the work.

Analyze existing procedures and evaluate requested requirements to identify any system changes.

Environment: Microsoft Office (Excel Word, PowerPoint, Project), MS-Project, MS Visio 2010, SharePoint 2010, DIA, Primavera

American Family Insurance 2011 May – 2013 April

Madison, WI

Sr. Business Analyst

Served as the principal conduit for managing system requirements between the business and the software development team throughout the duration of a project.

Analyzed Background Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives.

Provided analysis, understanding and business perspectives on many financial and operational issues.

Used Rational Unified Process (RUP) for streamlining the team development activities.

Gathered Functional and Data Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.

Used Crystal Reports based on the SSRS and derived financial reports.

Created a Data Dictionary having the business definition of Data Mapping to map the Logical Data elements in Use Cases to Physical data elements (record source) for Data Analysis.

Researched and identified data sources, documented data handoffs and validated data quality at identified data sources.

Created UML diagrams including Activity Diagrams and Class Diagrams to graphically show the system flow and capabilities.

Utilized Rational Requisite Pro to create and manage requirements, including requirements traceability.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Deployed and processed SSAS Cubes weekly to update information by using SQL Server Agent.

Worked with DBA’S to review Migration Strategy and Migration Schedule.

Worked with my project team, Business Areas, Development and Quality assurance team to create the UAT Strategy and Planning.

Participated in brainstorming sessions to prioritize and distribute tasks to the UAT team for effective execution.

Participated in UAT execution and managed Defects, Issues and Risks.

Used effective Agile Methodology techniques to conduct weekly team meetings to ensure the development activities are streamlined.

Traced requirements to Test Cases and created Requirements Traceability Matrix (RTM) using Rational Test Manager.

Maintain, register all Risks and Issues and escalate them appropriately to the higher management.

Built a fantastic relationship with the Internal and External teams of the project and ensured that all the project tasks are accomplished under the dead-lines.

Actively participated and resolved several Issues by performing a proper corporate navigation.

Environment: Microsoft Office (Excel Word, PowerPoint, Project), MS-Project, SharePoint 2010, Lotus Notes, MS-Visio 2010, SQL Server 2008.

Statefarm Insurance 2010 Nov – 2011 Apr

Bloomington, IL

Systems Business Analyst/ Business Process Analyst

Responsibilities:

Coordinated with Project Manager in planning the phases of the entire project in accordance to Agile environment.

Conducted Requirement Walkthroughs with the stakeholders and IT developers and served as liaison between Business and Technology groups.

Gathered Business Requirements, interacted with the Stakeholders, Developers, Project Manager and facilitated JAD sessions to identify Business Processes.

Prepared User Requirements Document (URD), Business Requirements Document (BRD) and Functional Requirements Document (FRD).

Capture lead information necessary to analyze and evaluate the Business Processes.

Document the information related to the processes in scope and maintain a hierarchical structure in SharePoint.

Developed Use Cases and Use Case diagrams using MS Visio.

Worked closely with the Project Manager in handling the scope-creep and analyzing its effects.

Addressed meetings with Project Team and Client Team, which involved proposing technical solutions against Clientele’s business needs, developing the training methods and tracking the progress of the development.

Identified, measured and derived KPIs to help adopt new process enhancements.

Prepared Business Process Models that includes modeling of all the activities of the business from the conceptual to procedural level.

Involved in gap-analysis to understand the future enhancements and implementations in the existing system.

Acquired the business Sign-Off on the Business Requirements Document (BRD) and functional requirement document (FRD).

Worked in gathering Digital information, document them; perform validation per the design and security standards.

Actively conducted meetings with development team to discuss related issues.

Consolidated the Project Reports on a weekly basis, conducted status meetings and ensured all the accomplishments and pending activities are kept informed to the Management.

Environment: Microsoft Office (Excel Word, PowerPoint, Project), SharePoint 2010, MS Visio.

AIG Insurance 2009 March – 2010 Oct

New York

Systems Business Analyst

Responsibilities:

Actively interacted with the client and the sales team to gather client requirements regarding the Patient Electronic Medical Reports.

Analyzed Business Requirements, developing, tracking and enhancing them into functional requirements.

Collected and documented business processes as well as business rules.

Developed the Software Requirements Specifications (SRS) based on the Vendor interaction and User requirements.

Interacted with the third party vendors to collect details and quotes regarding the Vendor EMR.

Coordinated closely with the diagnostic lab and sales team for approvals.

Developed Use Cases for the main modules and describe the requirements to the developers.

Conducted JAD sessions with the entire team.

Worked closely with the development team to communicate client requirements.

Worked closely with the Project Manager in handling the scope creep and analyzing its effects.

Provided key input in working with users in defining project and system requirements.

Communicate any final adjustments required based on user feedback.

Held regular status meetings on behalf of the Project Manager and kept track of the status.

Created and maintained the Requirements Traceability Matrix to keep track of each requirement.

Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams, using MS VISIO.

Presented reports and analysis to help assist the management.

Environment: Microsoft Office (Excel Word, PowerPoint, Project), Rational Requisite Pro, MS Visio.

Metlife 2008 June –2009 Feb

New York,NY

Systems Business

Responsibilities:

Worked with Project Team to understand the scope of the Project and capture the Business Requirements.

Conducted interviews with various Business Users to collect requirement and Business Process Information and documented them.

Controlled procurement, sourcing, contract and resource management functions for high-risk projects.

Extensive use of Excel tables to run and analyze the result data set.

Acted as the primary liaison between the business areas and technical teams to attain methodical results via an effective means of communication and development activities.

Involved in daily scrum meetings and implemented Agile methodology through-out the project.

Created Business Requirements Document (BRD) and Functional Requirement Specifications (FRS) document.

Designed Use Cases, for the technical team to identify the key Business Processes.

Conducted meetings with development team to discuss Solution Designs, requirements clarifications.

Participated in the team meetings and reported weekly and monthly project status updates to Project Manager.

Environment: Microsoft Office (Excel Word, PowerPoint, Project), Rational Requisite Pro, MS Visio.

Bank of America, 2007 Jan –2008 May Charlotte, NC

Business Analyst

Responsibilities:

Represent a collection of diverse work efforts with significant business implications. Monitored performance for the success of ICP (Integrated Customer Platform), Sales Associated Management, Compensation, In Language and acknowledgment to support the use of E-signature and Voice electronic signature.

Facilitated interviews, surveys, brainstorming sessions, focus groups etc to clearly understand the requirements.

Hands on UML experience in using Enterprise Architect for creating use cases and activity diagrams with use of swim lanes to show different activities and interaction between the system processes.

Conducted usability studies to understand the AS-IS and TO-BE business processes.

Worked on MEGA Process BPMN version 2009, share point, SDAP tools. .

Developed Test Plans and executed Test Cases, compared with Expected Results, and coordinated the user acceptance testing with the business users and the QA team to verify implementation of new features and enhancements.

Worked closely with the Project Manager, business, development team and offshore team for the deliverables.

Scheduled meetings, took meeting minutes and participated in planning sessions

Assisted project managers to create project charters and define scope.

Prepared project plans and executed organization resource activities.

Tracked project timelines and resource utilization.

Placed resource requests to resource managers

Worked on primavera to allocate the resources for project mapping purpose. Tracking the resources hours providing charge codes for the assigned projects.

Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.

Worked on Resource Breakdown Structure (RBS), Work Breakdown Structure (WBS) and Gantt Chart for resource allocation and management. .

Authored the product backlog for the complete project, derived User Stories for individual iterations, assigned tasks and allocated appropriate resources for completion and acceptance of individual stories

Used SDLC (System Development Life Cycle) methodologies like the Agile and the waterfall.

Teamed up with both internal and external software development groups to provide functional requirements specifications in form of use cases, business process flows, and prototypes and management reporting requirements

Designed Business Flow Diagram

Environment: MS Project, MS Word, SharePoint, MS Excel, MS PowerPoint, MS Visio.

EDUCATION:

Bachelor's Degree in Information Technology, New Jersey Institute of Technology; Newark, New Jersey.

Contact this candidate