PROFILE SUMMARY:

• Overall 9 years of experience as Business Analyst
• Proficient in Business Requirement gathering, Business Process flow, Business Process Modeling (BPM), Process Redesign, Business Process Reengineering, Business Change Management, Documenting Enhancement Requests, Automatic and manual testing, etc. with a keen awareness of developers and end - users needs and able to dealt with user groups at all levels efficiently
• Extensive experience in leading and designing online marketing campaigns, consumer research, Search Engine marketing, search engine optimization, web analytics and Site Tagging.
• Extensive knowledge of project life cycle, project management processes, principals, knowledgeareas and various project management tools MS Project etc.
• Proficient in documenting System Requirement Specifications (SRS), Functional Requirement Specifications (FRS), Requirements Traceability Matrix (RTM)using Rational Requisite PRO and Software development plan
• Conducted Daily Scrum meeting, Planning Sessions, Backlog updates, User Stories updates, Continuous Integration, Continuous Testing
• Analysis and planning work on open strategy deliverable activities including:
• Experience in Collecting and analyzing on-line business data (marketing campaigns, site metrics and search engines).
• Excellent Experience in SDLC Methodologies like RUP, Agile/Scrum and waterfall
• Experience in functional and use case design ensuring no redundancy and acted as product Owner in Agile based development
• Strong experience in Application Design (Prototyping, Screen Mock-ups), wireframes, responsive design (RWD), browser compatible UI design
• Adapt at creating and transforming business requirements into functional requirements and designing business models using UML diagrams - Context, Use Case, Sequence, Activity diagrams using MS Visio and Rational Rose
• Act as mentor in analyzing requirements, prototypes/wireframes, and user interface (UI) diagramfrom junior Business Analysts
• Facilitate of JAD (Joint Application Design) sessions and coordinating extensive communication networks (interviews, written correspondence, reports, implementation requirements, project status reports, oral presentations, e-mails, etc.) to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts
• Well verse in project management tools likeMS-Project for status reporting and planning
• Work with UX, ISC and functional teams to determine help text standards
• Successful completion of projects using the software development principles of Rational Unified Process (RUP) using Rational Rose, Rational,Requisite Pro, Unified Modelling Language (UML)
• Strong presentation skills and ability to tailor presentations towards different functional areas of business
• Work with SQL queries for data manipulations, responsible for data mapping
• Helps resolve “blockers” by liaising with other Pod PMs during work planning and sprint execution efforts
• Experience with Data analysis and SQL queries with database integrations for large organizations
• Experience in conducting walkthrough sessions with developers and testers
• Experience in conducting GAP analysis, User Acceptance Testing (UAT)at all levels
• Expertise in various types of testing including unit, integration, functional, system and performance testing.
• Create Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and acceptance criteria are met
• Support Pod Manager with issue escalation to UWD Deputy Directors and Program Management Office as needed.

PROFESSIONAL EXPERIENCE: 

Confidential, New york, NY

Business Analyst, Business Process Analyst

Responsibilities:

• Assisted senior project manager and the project team with day to day project planning,scheduling, reporting and coordination tasks.
• Scheduled and facilitated weekly status report meeting for the Project Team and for key Stakeholders.
• Conducted Business Reviews, User Interviews, weekly/ Monthly meetings with Business Users, SME’s.
• Utilized Software Development Life Cycle (SDLC) to configure and develop process, standards procedures.
• AssistedProduct Owner in Agile - Scrum based project development and mentored Business Analysts.
• Continuous communication with end users, stake holders, project managers, SME’s, technical teams and quality analysts
• Prepared process flow/activity diagram for existing system using MS Visio and re-engineerthedesign based on business requirements
• Analyzed Requirements and created Business Requirements Document (BRD), Functional Requirements document (FSD) andUse Case Specifications using Requisite Pro
• Prepared system requirement specifications (SRS), system design document (SDS), traceability matrix (RTM),and testing strategy
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML and Business Process Modeling
• Provided recommendations for Process improvements and prepared functional requirements specifications for Configuration and program changes
• Incorporated User Stories in different release plans for the sprints in Scrum process
• Re-engineeredsystem workflows for off shore developmentas the development ran through onsite-offshore business model
• Involved in analyzing requirements, creating prototypes/wire frames and User Interface (UI) Diagram
• Gathered Business requirements for Integration points and mapped them with Functional requirements
• Designed new reports and also improvements to existing ones
• Coordinated lean events for process improvements
• Created AS-IS and TO-BE business process flow diagrams, Integrate process flow diagrams to show end-to-end business model and businessprocess mapping including swim lanes
• Guided development teams to break down large and complex user story into simplified versions for execution
• Used JIRA for tracking bugs and issues.
• Performed Data Analysis of existing data through SQL and MS Access
• Worked to create Data Mapping Documents and worked with business to write transformation rules through SQL
• Identified Test Harnesses, which assisted QA effortin reducing the redundancy of Automation Scripts and made them more reusable
• Experienced test-case scenarios and root-cause analysis, GAP analysis, developing test plans, test scripts using SQL, conducting System Integration testing (SIT), user acceptance testing (UAT), training, and implementing new processes and technology

Confidential, Champaign, IL

MS SQL Server Developer/SSAS/SSRS.

Responsibilities:

• Involved in gathering requirements from Business Users, Analysts by scheduling meeting at regular basis.
• Involved in business process Modeler reengineering, including gathering and documenting requirements, documenting workflows and developing functional specifications for the programmers
• Scheduled and facilitated weekly status report meeting for the Project Team and for key Stakeholders.
• Gathered Business Requirements Document (BRD), created FunctionalRequirements Document (FRD) and analyzed data/workflows, defined the scope, financial projections and cost/benefit analysis; progressed from Problem Statement to well-documented designs. Prepared user guidelines for easy access of the application.
• Conducted DataAnalysis to find missing data fields in the application and customize them and extensively used Rational Requisite Pro.
• Write test scripts for Software Applications developed using Agile and/or Waterfall methodology
• Execute test cases manually and/or using automation along with providing a test summary report on defects found in testing diligently, promptly and accurately.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Management, analysis and implementation of BPM solutions to achieve improved efficiency in processes for tax assessments and rentals of cell phone towers for over 12K sites.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Created detailed Use cases, BPMN flows, Functional Specifications, UML diagrams to remove ambiguity of the requirements communicated by clients or SMEs.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling.
• Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services (SSAS).
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Involved in DataExtraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
• Worked on design and development of Relational Database Management System (RDBMS) and reduce the redundancy by data normalization using My SQL Server/ Oracle.
• Extensively used Agile Methodology in the process of the project management based on SDLC.
• Used MS Word & Visio to document data flow of the AS IS process and TO BE process.
• Conducted JAD sessions to get SME’s input on how to implement the application for Group Disability Claims
• Created SQL Server Reports using SSRS 2012.Identified the data source and defined them to build the data source views.
• Involved in debugging Reports and deploying Reports.
• Scheduled the Reports to run automatically.
• Extract Transform Load (ETL) development using SQL Server 2008, SQL 2012 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages.
• Involved in migration from SQL Server 2008 to SQL Server 2012.

Confidential, New York, NY

BUSINESS ANALYST/BPM

Responsibilities:

• Create business requirements documentation (BRD), UML use cases, gap analysis, process models, mockups, test scenarios, concept diagrams and business activity diagrams.
• Performed tasks within the requirements life cycle - gather high-level requirements via interviews and JAD sessions and filter those requirements into functional and non-functional specifications.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Develop and establish IBM BPM/MQSeriesWorkflow Competency Center at PFG with services and SLAs, 24hr production pager support
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Created and updated Project Track Plan Slides via MS PowerPoint, MS Project, MS Excel, and MS Visio.
• SQL proficiency, including coding and debugging scripts to extract, transform and analyze data sets Experience with relational DBMS environments and ER diagramming. Experience with the Microsoft BI stack (SQL, Analysis Services, SSRS, SSIS, Excel Services, SharePoint) Experience with OLAP cubes, RDBMS, and multi-dimensional reporting applications preferred
• Facilitated collection of requirements from system users and preparation of business requirement documents using Rational Requisite Pro that provided appropriate scope of work for technical team to develop prototype and overall system.
• Utilized agile software developmentmethodology to manage and control software and product development.
• Used agile methodology to Conduct Data Analysis to find missing data fields in the application and customize them and extensively used Rational Requisite Pro.
• Daily involvement with the agile software development life cycle, documenting and working through systems issues as part of a business analysis team.
• Created Data Stage jobs to extract, transform and load data into various sources like relational databases, application systems, temp tables, flat files etc.
• Used SQL queries to gather information to conduct Data Analysis on the client profile data to find missing data fields in the database and customize them.
• Facilitated JAD sessions by formulating and defining systems scope and objectives through research and fact-finding combined with understanding of business systems, business requirements, and industry requirements.
• Documented current and future business processes, process flows, data flows, and created class, sequence, and activity diagrams.
• 3 + years of hands-on experience working on the Salesforce.com platform or will be considered for depth on other CRM software packages (Microsoft CRM, SAP CRM, I SalesLogix, Oracle On-Demand, or similar)
• Assisted project team in preparing Software Requirement Specifications (SRS), Software Design Documents (SDD), User Interface Design, designing of Application Architecture &Database Modeling.
• Developed and presented mockups for end users.
• Reviewed test strategy and test plans to ensure that test cases reflect user needs for the functional, user interface, performance, usability and security requirements.
• Followed a structured approach to organize requirements into logical groupings of essential business process Modeling, business rules, and information needs, and ensure that critical requirements are not missed.
• Coordinated work plan between the Project Team and business representatives using MS Project; scheduled and tracked progress for team members of project throughout completion.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT).

Confidential, NYM/Newyork

Business Analyst

Responsibilities:

• Assisted Project Manager in developing estimates for the project by identifying development & testing team tasks.
• Assisted in developing project schedule, project status reports and attended project progress meeting to report on project progress.
• Documented the process improvement measures in the Business Requirement Document (BRD) and performed requirement analysis to transform business requirements into Functional Specifications (FSD)Utilized agile software development methodology to manage and control software and product development.
• Gathered Business Requirements, analyzed data/workflows. Defined scope and progressed from Problem Statement to well-documented design
• Able to perform creation of complex metrics, Conditional and Level metrics and their use within a report context
• Created AS-IS and TO-BE business process flow diagrams, integrateprocess flow diagrams to show end-to-end business model and businessprocess mapping exercise including swim lanes
• Designed and developed project document templates based on Agile/Scrummethodology
• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification (URS). Understand and articulate business requirements from user interviews and then convert requirements into technical specifications
• Develop dashboards with panels, selectors and links.
• Strong understanding of Data modeling concepts
• Experience querying a Relational Database using SQL
• Assisted the development team with demos to the Product Owner and ensured that any changes requested in the demos were implemented
• Prepared User Stories for various business scenarios to meet the acceptance criteria
• Heldregular meetings in the form of JAD sessions with developers, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand
• Developed wireframes along with SME’s based on business needs and Worked with UI interface designers for visual designs and mockups
• Created acceptance criteria in every use case based on requirements, wireframes and design document
• Designed Use Case Diagrams and wrote their specifications in the Use Case Specification documents using Visio based on the Requirements gathered
• Followed the UML/Visio based methods to create: Use Cases and Activity Diagrams
• Manage client implementation projects of Microsoft Dynamics CRM
• Gather and document business requirements
• Perform deployments and quality assurance of our systems and products
• Configuration and customize our products and Microsoft Dynamics CRM, Actively participated in the process of data mapping of products and benefit systems and ensuring all data fields are functioning correctly
• Interacted with the developers to report and track bugs using JIRA.
• Performed Data Analysis of existing data through   SQL
• Involved in performing GAP Analysis by identifying existing technologies and documenting enhancements to meet end state requirements
• Participated in writing several test cases for UAT and regression testing