SUMMARY:

• Confidential is a Senior Business Analyst with over 8years of experience in IT industry as a BusinessSystemsAnalyst, BusinessAnalyst, Automation Tester, QA Analyst and ScrumMaster.
• He has experience working in domains such as Property & CasualtyInsurance and Banking.
• He has extensive hands on experience with SDLC methodologies such as Scrum, Waterfall, Scrum - WaterfallHybrid.
• He has experience working with technologies likeJava, C#, SQL, PL/SQL, XML, JSON, REST and SOAP.
• Confidential has experience in using different techniques for requirement elicitation such asbrainstorming, JAD sessions, observations, job shadowing,one on one interviews, prototyping, and requirements &documentanalysis. He has experience with creating RequirementsTraceabilityMatrices, Requirements Management Plan, BRD, FRD, FSD and SRS.
• Confidential has expertise defining and documenting the business process flows using UML diagrams such as use cases, activity, sequence and dataflowdiagrams using MS Visio.
• He has experience with data warehouse requirement documents, data mapping documents (Source to Target mapping), ETLdocumentation, dataprofiling, iteration matrix and business matrix. Confidential has extensive experience working in Hadoopecosystems and familiar with concepts such as HDFS,Name nodes, Data Nodes, Map Reduce, YARN and libraries such as Hive, Pig, Spark, Impala, Sqoop, Flume, Storm, Oozie, Ambari, Mahout and Kafka.
• He has experience supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, and Performance Testing.
• Additionally, Confidential has experience dealing with different datasources and different formats ranging from Flat files, SQL Server, Oracle, MySQL, MS Access, Excel and VBA.

SKILLS:

SDLC Methodologies: Waterfall, Agile Scrum, Waterfall-Scrum Hybrid, SAFE, Kanban, XP

Modelling Tools: Erwin, MS Visio

Collaboration Tools: MS SharePoint, Confluence, GIT, Lotus Notes

ERP: SAP, Oracle PeopleSoft HCM, Salesforce CRM

Project Management: Microsoft Project, JIRA, HP ALM, Rally (CA Agile Central), MS Team Foundation Server

ETL tools: Informatica Power Center 8.x/9.x, SSIS, SAP BW, IBM DataStage

Testing Tools: HP ALM, Selenium, Load Runner, HP QTP, Cucumber

Databases: Microsoft SQL Server, MySQL, Oracle, Cassandra, HBase, MS-Access

Big Data: Hadoop, MapReduce, Hive, Apache Spark, Mahout, Sqoop, Kafka, Flume

Data Warehousing: ER Modeling, Dimension Modelling, Data Marts, OLTP, OLAP, Data Profiling, Data Mapping, Data Mining, Data Validation, Star schema, Snowflake Schema

Reporting Tools: Tableau, Power BI, SAS, SSRS, IBM Cognos, SAP BOBJ, MS office suite

Languages: C, C#, Java, Scala, TSQL, PL/SQL

Web Service: SOAP, REST, AJAX, XML, JSON, WSDL, WADL, XSD, DOM and SAX parsers

User Interface: HTML5.0, CSS, JavaScript, jQuery

Frameworks: Apache Hadoop, Apache Spark, Struts, Spring, Bootstrap, ASP.NET

Analytics Tools: SAS E-Miner, SSAS, Tableau, Google Analytics, PowerBI

Cloud Based Tools: Salesforce CRM, Amazon Web Services

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Business Systems Analyst

Responsibilities:

• Conducted multiple Interviews, Brainstorming, RequirementsWorkshop and JAD sessions with business owners, development teams, BI analysts, DB admins, Insurance analysts, and Subject matter experts to elicit requirements regarding scenarios, business rules, compliance & regulations, and reporting requirements.
• Involved in business process reengineering (BPR) by conducting Process modelling, SWOT analysis, Document analysis, and GAP analysis to analyze As-Is business process and the To-Be system.
• Created Business Requirement document (BRD) to in corporate high-level business requirements, and Software Requirements Specification (SRS) for functional, non-functional, Data, and GUI requirements
• Involved in creating wireframes, mock-up screens, Data flow diagrams, use case diagrams andsequence diagrams and Activity diagrams for To-Be system.
• Gathered requirements on the different frequencies of data ingest (Batch/streamedreal-time/part-time) to be loaded on the HBase usingFlume, Sqoop.
• Identified and defined Data sources and conducted Data profiling, Data cleansing, and Data Governance
• Performed root cause analysis to identify data quality problems, and historical trends.
• Responsible for creation of ER diagrams like Conceptual and Logical diagrams and Collaborated with database developer in developing physical diagram for Knowledge Center that stores Alerts
• Elicited and documented Risk Scenarios for Alerts and Risk factors for each Alert with the SMEs and Users
• Elicited requirements for Business rules such as Routing rules and Suppression rules for Alerts
• Assisted Product Owner in SlicingEpics in to user stories by using Vertical Slicing techniques.
• AssistedScrum Master in documentingworkshops, retrospective and other ceremonies’ notes in Confluence
• Acted as a liaison between Hadoop Administrator and Developer in setting up the nodes and clusters of Hadoop eco-system with the help of tools like Cloudera Manager and services like Zookeeper and YARN.
• Defined Business rules and transformation rules for transferring data from Data sources and on-premise database to Hadoop using tools like Apache Sqoop and Apache Flume.
• Collaborated with development team in developing business scenario simulation algorithms using Apache Storm, Apache HBase, and Zookeeper.
• Coordinated with the Hadoop administrator in node cluster operations using Zookeeper and systems architect in fine tuning applications, and systems for higher performance and throughput.
• Worked closely with UI team in developing the web application, XML documents and validated XML, HTML and Java Script. Assisted Web services team in designing REST services and configuring WADL.
• Checked the format, used XSD files to validate the XML for Well-formedness as well as validity.
• Involved in validation of HTTP requests and response of UI server, Web server by using stubs, also validated the Serialization and Parsing of XML documents and JSON documents at each tier.
• Made a Report Visualization checklist to ensure the Claims fraud detection in event of fraudulent claim.
• Assisted in configuringdash boards and reports in Power BI Visualization. Involved in creation of User Acceptance Test cases and plans, defect tracking using JIRA and validated reports and dashboards.

Environment: & Tools:Scrum, JIRA7.0, YARN2.0, Sqoop, Kafka, Apache Storm, MapReduce2.0, HDFS2.0, Hive, Pig, Redis, HBase, Apache Mahout, XML, XSD, JSON, Oracle 11g, HTML5, MS Project, MS Visio, UML2.2, SOA, REST, AJAX, Relational modeling, Dimensional modeling, Informatica Power center 9.5.x, SSAS, Tableau

Confidential, Brenham, TX

Sr. Business Systems Analyst

Responsibilities:

• Elicited requirements on Web Application, Dashboard, Business Logics, and types of Data and Reports from different Business Owners, Stakeholders and development teams by facilitating Interviews, Brainstorming, and JAD session
• Performed Document Analysis to know the As-Is system and created To-Be system by conducting GAP Analysis
• Created BRD, SRS, FRD, Non-Functional and Requirement document
• Created data flow diagram, use case diagram, sequence diagram, activity diagram, wireframe and mockup for a better visual understanding
• Analyzed the requirement, and discussed with the stakeholders, to identify the data sources
• Involved in modelling business scenario predictions like segmenting audiences based on their behavior, building customer profile, and providing simplified attribution insights
• Coordinated with and Acted as a liaison between Hadoop Administrator and Developer in commissioning of Clusters, Name Nodes and Data Nodes
• Worked along with developer on Apache Sqoop, Hive and Pig to define the business rules for transferring the data from Mongo DB, MySQL, Redshift, cloud storage like AWS & MS Azure, Mongo DB, and HBase
• Collaborated with development team in developing business scenario simulation algorithms using Apache Spark, Apache HBase, and automation of workflows using Apache Oozie
• Assisted Hadoop administrator by performing node cluster operations using Zookeeperin fine tuning applications, and systems for higher performance and throughput
• Used Test Driven Development (TDD) development technique for building the components
• Used Jenkins for automating the continuous integration of the components on a regular basis
• Made a Dashboard checklist to ensure that the dashboard has easy usability, navigation, content and design
• Assisted in configuring dash boards and reports using Tableau
• Involved in creation of User Acceptance Test cases and plans, defect tracking using Jira and validated reports and dashboards
• Facilitated Scrum ceremonies, and converted High level requirements like Epics in to user stories by using Vertical Slicing technique. Responsible for creation of user stories using INVEST criteria, tasks using SMART criteria and defined Acceptance criteria. Used various Estimation, planning and Retrospective techniques such as Moscow, Planning Poker and Happiness Histogram. Responsible for identifying Impediments, tracking, resolution and conflict management
• Involved in maintaining the information Radiators such as Scrum Task Board, Release Burndown Chart, Sprint Burndown Chart and impediment lists in JIRA.
• Performed team’s velocity and capacity calculations for sprint execution and for determining the releaseplanning.

Environment: and Tools: Scrum Hybrid, Tableau, MySQL database, Hadoop, Zookeeper, YARN, Apache Sqoop, Apache Spark, HBase, Mahout, Oozie, Mongo DB, MySQL, Redshift, Hive, Pig and Jira.

Confidential, Los Angeles, CA

Business Systems Analyst

Responsibilities:

• Elicited database and reporting requirements by facilitating JAD sessions, conducting interviews, and brainstorming with the business owners, stakeholders and development team
• Created artifacts like Business Requirement Document (BRD) and Functional Requirements Document (FRD) to document the requirements
• Involved in the process of performing Risk Analysis and creating Work Breakdown Structure (WBS) along with Project Manager
• Created data flow diagram and use case diagram, to assist everyone to understand the system who involved in the project
• Created logical and physical model for the system. Also, worked along with system architect to draw the Bus Matrix
• Identified and analyzed source database and cardinalities for creating conceptual and logical ER diagram
• Conducted data profiling after identifying the source data source using Informatica IDQ
• Created data mapping document after identifying facts and dimensions. Helped database developer in creating star dimension modelling and to create target database
• Helped in developing slowly changing, rapidly changing and conformed dimensions and fact tables, based on the business requirement
• Used Informatica in identifying business rules, and defining passive and active transformations like constant, look-up, data type conversion and data transformation
• Worked along with ETL developers using Informatica Workflow Manager, by assisting them in Extraction, Transformation, and Loading operations. Also, documented ETL document with the help of ETL developers and monitored ETL logs
• Assisted testing team and Responsible for creating and monitoring Requirements traceability matrix, testcases, test plans, defining User Acceptance criteria and tracking defects
• Assisted in developing OLAPcubes and Performed Rollup, Drilldown, Slice and Dice operations
• Responsible for creating dashboards and customized visualizations to present the reports as per business requirements that helped in strategic decisions and validated reports using PowerBI

Environment: & Tools:Scrum-Waterfall-Hybrid, UML diagrams, Visio, HP ALM, MySQL DB, SSRS, MS Office, Informatica IDQ, Informatica Workflow Manager and Power BI.

Confidential

Business Analyst/ QA Analyst

Responsibilities:

• Conducted multiple Interviews, Brainstorming, Requirements Workshop and JAD sessions with business owners, development teams, BI analysts, DB admins, Insurance analysts, and Subject matter experts to elicit requirements regarding scenarios, business rules, compliance & regulations, and reporting requirements.
• Involved in Process modelling, SWOT analysis, Document analysis, and GAP analysis to analyze As-Is business process and the To-Be system.
• Created Business Requirement document (BRD) to in corporate high-level business requirements, and Software Requirements Specification (SRS) for functional, non-functional, Data, and GUI requirements
• Involved in creating wireframes, mock-up screens, Data flow diagrams, use case diagrams, sequence diagrams and Activity diagrams for To-Be system, and Reporting UIs using MS Visio
• Actively involved in gathering and understanding the business requirements by working closely with developers to create and execute software test plan, test cases and test scripts to uncover, identify and document software problems and their causes in all phases of testing lifecycle.
• Ensured test coverage and that testing met with project goals and objectives.
• Involved in Smoke, Functional, System, E2E, Regression, UAT Test execution and management.
• Closely worked with QA manager to implement QA process (e.g. defect tracking, test case management, testing strategies etc).
• Supported the use of HP Quality Center for tracing RTM and test execution.
• Provided daily QA Status report that included RTM and defect reports.
• Provided leadership and coaching to testing team members.
• Identified and advocated opportunities for test system/process improvement.
• Involved in and provided input for final Defect analysis and Knowledge Base.
• Applied and assured adherence to Insurancestandards and policies.

Environment: & Tools:PEGA PRPC, Java, SQL,Waterfall, MS Visio, HP Quality Center, Excel, Functional Testing Environment: HP ALM (Quality Center), Selenium

Confidential

Selenium Automation Tester

Responsibilities:

• Conducted UI testing, Functional testing, Regression Testing and verified the results with expected results usingRequirement Traceability Matrix.
• Created automation test cases and test scripts using data driven framework and Page Factory model to test the web applications using Selenium Web Driver.
• Utilized Apache POI jar file to read data from the excel spread sheets and load them into required test cases.
• Served as coordinator for all testing activities during the project.
• Performed testing on Web Services such as soap and restfulservices using SOAPUI to check the communication between different services.
• Handled Selenium Synchronization problems using Explicit & Implicit waits during functional testing. Executed test cases relating to mouse events using Actions class in selenium to perform required mouse operations like click and hold, context click, move to element.
• Handled multiple iframes and framesets to switch between/navigate through frames and performed necessary actions on the web elements.
• Expertise in using the Extent Reports and loggers to track the flow of the test cases, time taken for execution, defect tracking, pass/fail percentages and information on tested environment.
• Analyzed bugs and involved in quality assurancereviews with the team to ensure bugs are reported and closed.
• Shared Daily Status Reports with all the team members, Team Leads, Managers and Clients.
• Wrote SQL Queries to connect to the database and retrieve data for a specified set of test requirements. Implemented JDBC connections in the automation framework to validate data in the database.
• Participated in test case review, defects review meetings and requirements walkthroughs.

Environment: & Tools:JAVA, Java Script, Waterfall, HTML, SoapUI, SQL, QTP, HP ALM (Quality Center), XML, Web Services

Confidential

Selenium Automation Tester

Responsibilities:

• Conducted UI testing, Functional testing, Regression Testing and verified the results with expected results usingRequirement Traceability Matrix.
• Created automation test cases and test scripts using Selenium Web Driver.
• Performed 3 levels of testing including Functional, Regression and UATesting in Testing and UAT environment.
• Performed testing on Web Services such as soap and restfulservices using SOAPUI to check the communication between different services.
• Handled Selenium Synchronization problems using Explicit & Implicit waits during functional testing. Executed test cases relating to mouse events using Actions class in selenium to perform required mouse operations like click and hold, context click, move to element.
• Handled multiple iframes and framesets to switch between/navigate through frames and performed necessary actions on the web elements.
• Expertise in using the Extent Reports and loggers to track the flow of the test cases, time taken for execution, defect tracking, pass/fail percentages and information on tested environment.
• Analyzed bugs and involved in quality assurancereviews with the team to ensure bugs are reported and closed.
• Shared Daily Status Reports with all the team members, Team Leads, Managers and Clients.

Environment: & Tools: JAVA, Java Script, Waterfall, Mainframe, HTML, SoapUI, SQL, Selenium, HP ALM (Quality Center), XML, Web Services