SUMMARY

• Experience:Hands - on Business analyst with 8+ years of Experience in the field of Business Analysis by working in multiple projects in Retail, Banking, Marketing DomainManagement:Business Process Analysis, Thought Leadership, Builds and Leverage Relationships, Conflict Management, Communicates Effectively, Facilitating Meetings, Identifying/Mitigating Risks, Issue resolution, Data security, Builds Diverse Talent by Training/Mentoring team members.
• Methodology & Principles:Comprehensive knowledge of Software Development Life Cycle (SDLC) methodologies likeWaterfall & Agile, SCRUM, SCRUM-Waterfall Hybrid
• Requirements-Gathering Techniques: Brain-storming, Document-Analysis, Focus groups, Interviewing, Observation(Job-shadowing), Prototyping, JAD sessions, Surveys/Questions, Impact analysis for Change request management in Waterfall projects
• Project Documents:Business Requirement document, Functional requirements document, Software requirement Specification.
• RACI Matrix:Detailed understanding of RACI Matrix (Responsible, Accountable, Consulted and Informed) preparation and Requirement Traceability Matrix(RTM) throughout the SDLC process.
• Analysis/Methods: Gap Analysis, Impact Analysis, Cost/Benefit Analysis,SWOT Analysis, Risk Analysis, Feasibility study.
• UML Diagrams:Activity, Use Case and Sequence diagrams. Having experience in creating Mock-up screens to visualize Graphical User-Interface.
• Data Warehouse and SQL:
• Proficient of Data warehousing concepts like Entity relationships, Dimensional Modeling, Data modeling, Data migration, Data profiling, Data governance, Master data management (MDM), Schemas, Data mart, Operational Data Store, Data Vault. Used SQL queries to perform DML (Data manipulation language ) operation to insert, update and delete the data for data analysis.Seasoned in Business Intelligence reporting and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
• Testing Experience:Insights of knowledge in Software testing lifecycle, Various types of Testing including Functional, Non-Functional, System Testing, Integration testing, Regression testing, User-Acceptance testing, Load and performance testing.
• Web services:Comprehensive understanding of Web-Service components like WSDL, SOAP/REST, using XML and JSON with internet protocol suites such as HTTPS under n-Tier architecture and SOA with Ajax, Client-Side Validation with JavaScript.
• Project Competencies: Experienced in working with SME’s from various business areas to identify (key performance indicators) KPI’s and (service level agreements) SLA’s for the Website Performance, Customer Acquisition, Lead Conversion, Customer Retention, Search Engine Optimization, CLA (call to action), CLV (customer lifetime value) and fulfillment.Assisted Project Managersin preparingProject plans, the project schedules, milestone tracking, Work breakdown structure (WBS),
• Personal Traits: High-Integrity, Optimistic and Inspiring, Customer-Focused, Results-Driven, Personal-Commitment to Excellence and Self-Development, Commitment to best-practices, Creative and Strategic Thinker, Self-Motivated, Thrives under Pressure.
• Other Skills:Ability to work under tight deadlines and multi-tasking to meet business objectives, scheduling meetings, negotiating and coordinating with Software Developers, Solution Architects and QA Team.

TECHNICAL SKILLS

Modelling tools: Rational Rose7.6, Balsamiq 3.5.14,MSVisio 2013, Mock-up screens 4.32

Reporting tools: Tableau 10.1, Power BI 2.51.4885.543 , SSRS 4.5.1, IBM Cognos 11.0.5, Qlikview 11.2

Operating Systems: Windows XP/Vista/ 7/8/10

Web Languages: HTML5, CSS3, Java Script, JQueryUI

Testing tools: JIIRA 6.4.14, Rally 2014.2, HP ALM 11.0 and QC, Load runner 12.53, Selenium 3.5

Version Control tools: Bitbucket 4.8, GitHub 2.13, Team Foundation Server 2015

Big data: Hadoop, HDFS,Flume, Ambari, Sqoop, Spark, Zeppelin, Hive, Storm, Pig, YARN

Requirements tools: Rally 2014.2, Version one, JIIRA 6.4.14

Databases: My SQL 5.7, DB2, Microsoft Access 2013

ETL tools: Informatica 9.6.0, IBM Data stage 11.3.0, SSISand SSRS 2016

Communication Tools: Outlook 2013, Audio and Web Conferencing

Management skills: Organizing ability, Problem solving, Planning and Decision making, Strategic thinking

PROFESSIONAL EXPERIENCE

Confidential, MIAMI, FL

Senior Business Analyst

Responsibilities:

• Gathered Technical & Functional client requirementsusing Brainstorming, Document-Analysis, Survey/Questionnaires and Focus Groups.
• In addition, interviewed business clients to analyze their business requirements and recommended design technological improvements to their business processes and operational procedures.
• Managed those collected requirements through clear and precise documentation usingBusiness Requirement Document (BRD), Functional Requirement Document (FRD)and helped transforming them into a complete SoftwareRequirement Specification (SRS).Using SRS, Development team could understand the requirements in an effective manner.
• Identified Actors &workflows andprepared UML diagramsto define actors, and their interactions to achieve functionality.Designed Data Flow Diagrams (DFDs), Entity Relationship Diagrams (ERDs) and web-page mock ups using modeling tool
• Developed Process Mapping of Current and Future Business Processes involved in ERP systems.
• Coordinated application and process-specific training activities to educate technical and non-technical users of the solutions to configure and support.
• Assisted by providing support for ERP systems integration and functionality.
• Supported end user requests, developed reports, dashboards and workflows and customized ERP platforms as needed to improve business processes.
• Designed, implemented, and lead integrations between various ERP systems and in-house applications
• Assisted in creation of Test Cases, Test Scenarios and Test Plans.
• Facilitated testing of the system duringRegression Testingand madesure the existing functionalities arenot affected.
• Developed basic SQL queries for QA data validation and testing
• Performed middleware web service analysis, data mapping, including examination of WSDL, XML and APIs.
• Reported weekly, monthly Project Status and Metrics updates to senior Leadership teams for the modules involved.
• Participated in System Integration testing and User Acceptance testing with the business users to ensure a high-quality delivery.
• Used Tableau, opened exchange of ideas, faster decision making and increased environment of accountability.

ENVIRONMENT: Waterfall, Hortonworks data platform, Oracle E Business suite, Google cloud platform, MS Visio, Microsoft Office(MS Word, MS Excel, MS PowerPoint), Mockups,UML,HTML 5, CSS3,Tableau 10.1, JIIRA, HDFS, YARN, Flume, Sqoop, Zeppelin, Ambari, Trifacta, SSIS & SSRS.

Confidential, COLOMBUS, OH

Senior Business Analyst

Responsibilities:

• Participated in JAD sessions with Subject Matter Experts (SME), Stakeholders and DevelopmentTeam to gather business and technical requirements.
• Involved extensively in feasibility analysis, cost benefit analysis, andrisk analysis for the project with the project manager to opt for Integrated ERP-CRM system.
• Assisted in developing mockupsusing Mockup screensfortherespective system modules.
• ConductedGap Analysis of the AS-IS and TO-BE processes to bridge the gap between current and desired system andvalidated the process involved.
• Proactively documented and identified opportunities for change/improvement in business processes from data analysis and working with the business users, to drive those changes as new and existing ERP, Reporting and Business Intelligence Systems are introduced to Customers.
• Gathered requirements for the existing systems and defined new business processes and relationships between processes and system flows. Performed Impact analysis for the change request from clients.
• Developed and promoted good business relationships with domestic and international stakeholders along with managing and prioritizing work to be done and coordinating activities with internal and external customers and IT colleagues/subordinates to ensure successful project implementation and meet expected service levels
• Responsible for keeping IT Senior Management aware of JIRA software development issues and potential problems, and meeting with system developers to resolves ticketing assignment conflicts
• Prepared Risk Analysis Reports from Access, SQL.
• Performed data mapping, data modeling, data aggregation, and validation logic between current and target model
• Interfaced with business as well as developers on initiates to add and improve ERP functionality which included data integrity, business process automation and best practice standardization.
• Run and managed pilots for ERP mobile device upgrades and addressed validation of softwares whenever required.
• Performed extensive data analysis using MS Excel and IBM Cognos to find correlation between various variables involved and validate d it.
• Interacted with customers, troubleshooting issues, solving of software related deficiencies.
• Tested the new system to confirm the migration of the policies from the old system were processing properly
• Written complex SQL queries to retrieve data from Database server.
• Understood the context in which middleware web services are used within the business applications and match business requirements to the sources of data within systems.
• Actively involved in creating Test Strategies and helped with creating Test Scenarios, Test Environment and Test cases.Conducted User Acceptance Test(UAT)or End to end system testing
• Used Tableau to visualize the data about the visitors' behavior, and performed trend analysisfor the same.
• Created training documents and trained end users, post Go-Live support.

ENVIRONMENT: Waterfall, Hortonworks dataplatform, HDFS, Java, J2EE, MS Visio, Microsoft Office Mockups UI, UML, HTML 5, CSS3, Tableau 10.1, YARN, Oozie, Spark, Load runner.

Confidential, ADA,MI

Business Analyst

Responsibilities:

• Prepared the documentation required for the waterfall phase such as BRD (business requirement document). Created use case diagrams and Sequence diagrams for the required modules.
• Broke down the BRD into user stories by conducting workshops with the team and defined the acceptance criteria for the user stories and created the product backlog on issue tracking tool D
• Designed application prototypes, screen mock upsand the wireframes for visual representations of the front-end webpage.
• Used JIRA daily to create, manage and update the product backlog and sprint backlogs.
• Constantly updated the priority of the product backlog as per the product owner requirements.
• Worked closely with the SME’s to understand the regulations and compliances involved in the domain.
• Studied the AS-IS process and the TO-BE process and understood the GAPS in the business process.
• Used SQL queries to validate the application and for manipulating the data using CRUD operations
• Worked on documenting the request and response XML formats for the WSDL and worked on documenting the UDDI requirements for providing web services to third party consumers.
• Experienced using AWS services (e.g., Redshift, RDS, EMR, Elastic bean stock)
• Worked with the development team to make sure that they understood the user requirements and that the system developed met those requirements. Prepared Traceability matrix for the requirements involved.
• Worked with QA team to design and develop Test PlanandTest Casesto perform User Acceptance Testing (UAT), Functional Testing and Regression Testingfor the respective modules.
• Involved in implementation by assisting in the preparation of training module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.
• Using Tableau,Customers got the opportunity to participate in a virtual reality experience which demonstrated Tableau dashboards within a retail store environment.
• Monitored ongoing projects, attend management and monitoring meetings, elaborate progress reports on projects and propose action when needed.

ENVIRONMENT: SCRUM-Waterfall Hybrid, Omni channel solution,AWS RDS, AWS S3 buckets,AWS IAM, AWS Elastic beanstock, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau 10.1,MS VisioHP ALMQC,Mock-Up Screens,UML.

Confidential, WARREN,NJ

Business System Analyst

Responsibilities:

• Interacted as a liaison between Users and the different teams involved in the application development for better understanding of the business and IT processes.
• Gathered business requirements through interviews, surveys and observing from account managers and conducted controlled brain-storming sessions with project focus groups and documented them in the Business Requirement Document.
• Gathered the Requirements, Developed Process Model and detailed Business Policies and modified the business requirement document. Prepared the Prototype and mockup screens.
• Created the User Interface manual for the web users based on the GUI functionality and the user accessibility decided by the business and the stakeholders, while being adhered to the compliance.
• Blueprinted technical and operational training manuals and led Power Point/Visio presentations for the development of financial and technical applications for the departmental user base and for audit purpose
• Assisted in increasing the Data Integrity by Data Normalization and adding Validation and Verification .
• Increased process efficiencies and reduced development cycle time across department by spearheading the implementation of the full lifecycle software development methodology.
• Performed manual tested related to the graphical user interface, functionality testing, security testing, and testing related to data sources.
• Managed and coordinated the QA team to create the test approach and determine test needs, test environment, test data, resources and limitations.
• Responsibilities included regularly updating the Test Plan and uploading on Confluence for sharing with the team and management.
• Facilitated the QA Test process by assigning test cases to the QA test plan in various builds, assigned test cases to the QA testers, and established contact with the testers.
• Maintained constant communication with the testers by assisting the Project Manager in conducting Daily Bug Review meetings during and after the QA Test process.
• Created, assigned, and maintained tickets in JIRA for bugs and defects.
• Participated in Data Validation process in QAT by developing spreadsheets with data from the reports in QA.
• Using Power BI, we transformed big data into insightful visualizations and made the data available to the customers.

ENVIRONMENT: Waterfall, Customer Intelligence & Insights open source platform with in built operational analytics and dashboards, Microsoft Office (MS Word, MS Excel, MS PowerPoint, MS Visio), UML, Tableau 10.1, JQueryUI, Bugzilla

Confidential

Business System Analyst

Responsibilities:

• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and documented them in a format that can be reviewed and understood by both business people and technical people.
• Interacted with the software development team and executive team to liaison the business requirements to ensure that the application under development confines to the business requirement.
• Designed the wireframes for visual representations of the front end webpage
• Performed data analysis for the existing data warehouse.
• Experienced in Cloudera system and its components HDFS, YARN and Sqoop.
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Assisted in creating Data warehousing requirements document.
• Resolved and managed requirements churn during the sprint
• Developed data warehouse reporting requirements and created data mapping documents
• Acted as Product owner, prioritizing and slicing the Product backlog needed for the sprint.
• Implemented Spark jobs using Scala and Spark SQL to speedup Hive batch jobs.
• Worked with source experts for optimizing the Data Warehouse for customer loyalty.
• Assisted in deployment of Optimizing Data warehouse system
• Performed continuous evaluation to improve system capabilities and business processes within the organization.
• Created the workflows to automate the data loads using Sqoop into HDFS ( Massive Event Log Data ) in batch mode
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
• Creating the SLA documents and Run books to help the Hadoop Admins for Operations and Maintenance.
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs

ENVIRONMENT: SCRUM, Pentaho EDO,Cloudera Enterprise 4, CDH 4.5, Cloudera Manager 4.8, Cloudera Impala 1.2.3, Apache Hive, Apache Pig, HP ALM QC, MS Office Suite (MS Excel, MS word, MS power point and MS Visio).

Confidential

Quality Analyst

Responsibilities:

• Performed Smoke Testing, Functional testing, and System integration testing, Regressiontesting, Database testing, and black box testing at various Phases of the development and test cycles.
• I involved in developing the Test Plan based on Functional Specification and Technical Specification of the application.
• Developed and executed test cases.
• Developed Sequence diagramto present the workflow in a visual form for a better understanding of the system.
• Conducted Data Driven Tests as per the User requirements.
• Developed Requirements Traceability Matrix to map the test cases with the Requirements.
• Good familiarity and understanding of Defect Lifecycle process with respect to the application.
• Performed Sanity Testing to check for the initial application stability.
• Conducted software and application training to the users and new members in the team by preparing user and technical manual and assist them with any technical or non-technical issues.
• Performed validation and testing for secure message service by first testing the system on computer and then on mobile phones.
• Created QA Test plans, Test Cases for Functional, Integration Testing.
• Performed Manual testing, Compatibility testing and Regression testing and updated the regression tests.
• Extensively used HP Quality Center to create Test Plans, Executions, Defects, and Reports.
• Ensured quality of system performance, company standards, and procedures.
• Developed User Accepting Testing (UAT) plans and test cases based on the business requirements.
• Extensively used MS-Excel for creating QA reports.

ENVIRONMENT: Waterfall,Rational Rose, MS excel, DB2, ASP.NET, JQueryUI, Java script., CSS3, HTML5, Windows,XML.

Confidential

Quality Analyst

Responsibilities:

• Analyzed the Functional Requirements and Design Specifications documents to ensure that the system met all the technical and business requirements of the applications.
• Manually generated and implemented templates for Test plan, Test Cases and performed Manual Testing on the entire application.
• Actively participated in the early phases of projects to ensure that inputs into testing process can be translated into a test plan and test cases.
• Developed detailed Test Cases based on analysis of the business requirements and communication with business.
• Verified the data for testing by executing the SQL statements
• Involved in Functional, Regression, Integrationand System testing of the application and understood the Software testing life Cycle (STLC) throughout the project.
• Reported and analyzed the defects tracked during execution and logged them by severity.
• Defined and tracked quality assurance test metrics and reported on outcomes.
• Coordinated close interaction between Quality Assurance and Development teams to understand solution requirements and performed test analysis.
• Created and updated PowerPoint presentations, graphs, and flowcharts that have been presented in various meetings and ceremonies within the organization.
• Coordinated testing timeline and dependencies for the production release.
• Conducted and managed usability and browser compatibility test for the respective application.
• Documented, implemented, monitored and enforced all testing processes and procedures established as standards defined by company and industry.
• Communicated and escalated project quality issues and quality deficiencies to upper management via verbal presentation, status reports and metric reports.

ENVIRONMENT: Waterfall, HP ALM QC, MS Office Suite, Java, J2EE, Notepad++, TFS,DB2, HTML5, CSS3, Tableau 10.1, XML, Windows