SUMMARY

• Business System analyst and Certified Scrum Master with 8+ years of experience in Finance as well as Telecom Industries
• Worked closely with Project Manager, SME and other related staff to understand Business Process Flows, Case Tools, Business/Requirement Analysis, Quality Assurance, Content Management, Development, Database design and administration, Report Writing and finally Support and Installation.
• Practice in the Development of Client - Server, Web-Based Applications and in Data Warehousing projects.
• To take a challenging post for understanding business needs, assessing the impact of those changes, capturing, analyzing and documenting requirements and then supporting the communication and delivery of those requirements with relevant parties.
• Imaginative person capable of forming, maintaining positive and productive team environments and integrative thinking skills. Exceptional ability to learn and adapt to new industries and business processes quickly.
• Proficient in requirement gathering, performing appropriate analysis and business processes management with a strong knowledge of System Development Life Cycle (SDLC) using Waterfall, Agile methodologies.
• Extensive experience in creating As-Is and To-Be process models, conducting Gap Analysis to understand areas of improvement and analyzing the risks involved through SWOT, Value Stream Mapping, Feasibility Analysis and Impact Analysis, and eventually proposing an appropriate mitigation plan to overcome those risks.
• Experience in conducting Joint Application Requirement (JAR) sessions, with SMEs and stakeholders.
• Highly experienced in creating the requirements Artifacts, Business Requirement Document (BRD), System Requirements Specifications Document (SRS), Use-cases and appropriate use-case diagrams, Functional Requirements Document (FRD), Technical Requirements Document (TRD) and Change Requests Planning (CRP).
• Experience in creating Key performance indicators (KPI), Enterprise Risk Management, Business Continuity Planning (BCP), Change Management, and dealing with changes in an assertive manner or with due diligence.
• Proficient in creating mock-up screens, prototype and dynamic UI with HTML, MS Visio, Omnigraffle.
• Excellent knowledge in Microsoft systems like SQL Server, SSIS and Data Analytical tools like Informatica, Tableau, R studio, SQL queries. Created reports through SSRS and Crystal Reports like Canned reports and Ad-Hoc reports.
• Worked closely on Data Modelling activities and ETL processes for various Data warehousing projects.
• Comprehensive knowledge of Data Warehousing with implementation experience using Rational Rose.
• Efficient with Stored Procedures, Cursors, Views and Triggers in SQL, for various Data warehouse Projects.
• Highly expertized in tracing requirements throughout the development process and verifying adherence to Requirement Traceability Matrix (RTM). Extensively used tools such IBM Web Sphere, JIRA and Rally.
• Significant experience in reviewing Test Procedures and creating Test Cases, Test Scripts and Test plans for Manual as well as Automated Tests, to test several dependencies among the automated modules of the projects
• Extensive knowledge in data collection, analysis and evaluation, analytical problem solving, decision making and interpersonal skill with ability to interact and understand among different individuals at all levels of the project.
• Involved in scripting business logic in the web methods of Web Services and documenting the Web Service Level Agreement (WSLA) document through XML into the business engine rule of the application.
• Experience in using SharePoint to share, manage, import and export documents for future references of project.
• Excellent analytical, problem solving and communication skills, dedicated & self- motivated, proven leadership capabilities, time management and interpersonal skills, benefiting the organization as a whole.
• A consistent performer in implementing and upgrading audit friendly security strategies, addressing compliance issues and issue resolution during Integration Testing and go-live readiness phases.

TECHNICAL SKILLS

Tools: MS-Project, MSOffice, MS Visio, MS Office, SharePoint, JIRA, Version One, TFS (Team Foundation Server), BluePrint, OmniGraffle, IBM Doors, Balsamiq, Version One, Axure, Adobe CQ5, Omniture, Seibel CRM, AEM

RDBMS/DBMS: SQL server, DTS, SSIS, MySQL, Oracle 7.x/8.x/9.x, Oracle 10g

Rational tools: Rational Clear Quest, Rational Rose, Rational Clear Case, Rational Requisite Pro

Known Scripts/Languages: HTML, XML, PHP, JavaScript, C, C++, Java, VB, Dot net.

Application/Web servers/OS: Apache 2.0.52, WebLogic8.1.6, Windows 7,8,8.1, MAC OS.

QA Tools: Roadrunner, Win Runner, HP QTP/UFT, HP QC/ALM, Selenium.

BI/ETL Tools: Informatica, Microsoft - SSIS, IBM - Cognos, Oracle Data integrator, @RISK, Stat tools, Solver (Excel), R studio, Tableau.

Business Skills: Business Definition Requirements, Business Process Analysis & Research, Use Case Modeling, JAD/RAD Sessions, Requirements Gathering, Gap Analysis and Impact analysis, Finance, Banking, Mortgage.

Methodologies: Waterfall, UML, CMM, Six Sigma & Agile.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, Pennsylvania

Crystal Reports Business Analyst

Responsibilities:

• Provide support to the end-users in designing and troubleshooting problems with Business Intelligence deliverables and data extractions from an Oracle data warehouse to generate the Fringe data.
• Create data models for universes and data mapping documents from source to target system.
• Gather and analyze requirements and specifications for Fringe Data and Credit unions reports.
• Provide support to end-users in designing and modifying reports, depending upon the requirement of the data.
• Conduct meetings and training with team members while providing a broad range of subject matter expertise relating to the data conversion of all the Fringe Reports and Credit Union Report releases on weekly basis.
• Collaborated with higher level management to provide the proper training to understand and translate business requirements of the artifacts for use in a major ERP implementation.
• Trained the team members on designing as well as mapping the data from source to target in Crystal Reports
• Modify the existing reports by addingnew logicand deletingexisting logicas the line of Business changes periodically. Migrate reports from Dev to Production to send out the reports to appropriate credit unions
• Export reports in various formatslike MS Excel, PDF, MS Word, Text and CSV as per the required format
• Generate reports withparameters, sub reports, cross tabs, chartsusing Crystal Reports
• Scheduledthe report using Schedule Managerin Crystal Management Consoleto run on a periodic basis.
• Developed database connections, SQL joins, loops, views, aggregates on the fringe data of credit unions.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Responsible for creating theComplex Crystal ReportsOn demand, Ad Hoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, aging reports .

Environment: Agile methodology, Kanban, Lean, Microsoft Office Suite, Microsoft Visio, Microsoft Project, SQL, JAVA development, DB2 database

Confidential, New Brunswick, New Jersey

Sr. Business Systems Analyst

Responsibilities:

• Interacted with business owners to identify business system needs, evaluated solutions for business problems and proposed alternate methods to increase efficiency and provide feasible solution to the project.
• Accumulated customer requirements from various end through JAD session, interviews and translated them into system requirements, for the developers about the requirement specification with respect to the project.
• Extensively worked with Portfolio Managers of various teams for gathering, analyzing and organizing the Business, Functional and Nonfunctional Requirements and transformed into the BRD, FRD, SRD.
• Developed Use Case diagrams, Activity flow charts and Class / object diagrams, Sequence Diagrams using Rational Rose to help better explain the business process flow to various stakeholders of the project.
• Developed data flow diagrams, illustrating the flow of data from the legacy systems into the Application database tables, along with checkpoints for testing / verification for several modules.
• Recognized various web services with the help of UDDI and implemented a complete web orchestration, including both the internal as well as external web service to the organization and worked on associated SLA.
• Created Business rules within the business engine for client side validations, server side validations,
• Worked closely on Data Modelling and using various Linear models, Forecasting, Simulations for iterations, Regression for various variables and their relations with dimensional tables and fact tables within the project.
• Performed Data Analysis on generating Canned as well as Ad-Hoc reports and Data mapping activities for the reports using various tools like Informatica, Tableau and also some reporting tools like Crystal Reports.
• Reviewed defect reporting and resolution in MS Project Clear Quest to track project progress.
• Used HP Quick Control for Automation, Regression, and System Integration Testing for the project.
• Wrote and executed system test plans, test cases and test data for the web-based application.
• Engaged in system testing during User Acceptance Testing (UAT), for different business users and stakeholders.

Environment: Agile methodology, Kanban, Lean, Microsoft Office Suite, Microsoft Visio, Microsoft Project, SQL, JAVA development, DB2 database, AEM.

Confidential, Austin, TX

Scrum Master/Business Analyst

Responsibilities:

• Gathered Analyzed, validated, Managed and documented the stated Requirements by conducting one on one interviews and JRP sessions with the stakeholders for current as well as future references of the project.
• Conducted market analysis, Impact Analysis and feasibility studies & developed the project Initiation plan.
• Created functional requirement specification documents such as UML diagram, use case diagram, scenarios and activity flow diagrams to help better understand the business flow of the project.
• Integrated with stakeholders for verifying the requirements, managing change control process, updating existing documentation & Project Tracking with respect to user stories using project management tool JIRA.
• Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demonstration and other Scrum-related meetings, leading to enhancement of application development.
• Worked closely with the team to breakdown epics into clear and concise user stories and also the user tasks.
• Instructed core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the team and also the organization.
• Worked with the engineering managers to identify cross-team dependencies and manage inter-team tasks, eventually helping improve the overall efficiency of the entire team as well as the efficiency of the project.
• Assisted team with making appropriate commitments through story selection, sizing and task definition and participated proactively in developing and maintaining team standards, tools and best practices reducing development time by 12% keeping in mind the efficiency and scalability of the project.
• Used JIRA project management software for developing the sprint burn down and burn up charts, velocity charts throughout the sprints to track velocity as well as determine capacity of the development team and update the user stories and tasks that are completed in various sprints into the product backlog artifact.
• Created UAT/QA test plans,strongmanual, functional, system Integration and regression testing in an agile development environment for different business users and product owner within the organization.

Environment: Microsoft Office Suite, MS Visio, MS Project, Windows XP, Dreamweaver, SQL, PLSQL, XML, VB, ASP.Net, Crystal Reports, Adobe Photoshop, Mercury Test Director, Win Runner, Load Runner, AEM

Confidential, Orlando, FL

Sr. Business Analyst/Data Analyst

Responsibilities:

• Identifiedthe requirements from the stakeholder’s keeping in mind their need for the application and prepared the Business Requirements Document and Functional Specifications Document for the project.
• Organized and moderated Joint Application Development (JAD) sessions identified system business and effectively utilized Document Analysis technique to frame system use cases, wrote use case narratives and used MS Visio to prepare the Class Diagrams, Use Case diagrams, Activity diagrams.
• Scheduled Triage calls between the QA team and development team to address and fixed the bugs and errors in the code during the UAT meeting with the business stakeholders and other business users.
• Involved in designing and developing Data Marts from disparate data sources that support the Business Intelligence Data Warehouse pertaining to different databases within the project using ETL Informatica.
• Collaborate with business users of Digital Marketing teams, Vendors, and IT teams to introduce process to implement AEM/CQ5 for the IT/Digital Marketing teams.
• Performed Data mapping and logical data modeling also prepared ER diagrams for the system.
• Widely used SQL (Stored procedures, Triggers, Views, Cursor) to extract data from different sources.
• Conducted ETL testing process for data quality, data integrity, data transformations and data validations.
• Acted as a liaison between the developers and user staff and was instrumental in resolving conflicts between the user and technical teams and made sure that the technical team were clear with the requirements.
• Design and build data synching tools to store product information (from Siebel database) in AEM’s JCR.
• Designed and built front end components using Adobe Experience manager (AEM).

Environment: MS SQL Server 2012, SQL server Reporting Services 2012, SQL Integration Services 2012Microsoft Visual Studio 2010, SQL Server Management Studio 2010, MS Excel, T-SQL, AEM

Confidential

Business Financial Analyst

Responsibilities:

• Gathered requirements and prepared business requirement documents (BRD), System Requirement Specification (SRS) by interviewing Brokers, users and SME’s, stakeholders.
• Conducted GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system with respect to the enhancements in the new system being developed.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation in different iterations and phases of the Software Development Life Cycle.
• Transformed requirements into high-level and low-level use case diagrams, activity diagrams / state chart diagrams, class diagrams using MS Visio thus defining the data process models
• Developed High Level Business Flows using Microsoft Project Visio to understand the project.
• Used SQL scripts to pull the data and depending on that also verify the integrity of the database.
• Monitored client expectations and conducted user interviews to improve quality of the Application.

Environment: Agile methodology, Kanban, Lean, Microsoft Office Suite, Microsoft Visio, Microsoft Project, SQL, JAVA development, DB2 databases.

Confidential

Business Analyst

Responsibilities:

• Participated in gathering user requirements, developed functional and non-functional requirements.
• Developed use cases/diagrams, conceptual model, behavior diagrams (sequence, collaboration, state chart, Activity), using MS Visio in order to get a clear picture of the process.
• Responsible for working with the manager and other users and creating Work flow diagrams.
• Responsible for the delivery of Business Requirements Documents (BRD) within project timelines.
• Work with the Technical Analyst and development team to ensure that they understand.
• Extensively involved in coming up with test specifications, test cases and test manuals.
• Performed unit testing, functional testing, integration testing, stress testing, system integration testing and code inspection review to make sure the deliverables are match with business requirement.

Environment: Agile methodology, Kanban, Lean, Microsoft Office Suite, Microsoft Visio, Microsoft Project, SQL, JAVA development, DB2 database

Confidential

QA - Functional / Automation Tester

Responsibilities:

• Performed Quality Assurance activities for CRM tool on Seibel CRM framework.
• Created Complex Test Cases, Test Case Review and Defect Review.
• Tracked defects in JIRA found at various software release phases and develop negative test data as well as updating regression test suite to check the impact of new changes on the previous data.
• Planned and executed regression test suite and automated regression test scripts in HP QTP.
• Produce, maintain and communicate project status report and testing deliverables with teams.
• Handled Responsive website testing on different mobile devices and different OS/browsers.
• Handled content migration testing of the CRM tool and database.
• Handled integration and end-to-end testing for web application.

Environment: Agile methodology, Kanban, Lean, Microsoft Office Suite, Microsoft Visio, Microsoft Project, SQL, JAVA development, DB2 databases.