We provide IT Staff Augmentation Services!

Senior Business Analyst/ Data Analyst Resume

Nashville, TN

PROFESSIONAL SUMMARY:

  • A seasoned Senior Business Analyst with 8+ years of industry experience in Business Development Process and System & Data analysis with solid understanding of Business Requirement gathering, Business Process Flows, Business Process Modeling, Case Tools, and Business Analysis.
  • Expertise in Software Development Life Cycle (SDLC) methodologies like Waterfall, Scrum - Waterfall Hybrid, Agile (Scrum, Test Driven Development, Kanban) in domains like Banking and Insurance.
  • Extensive experience in data analysis, data manipulation, database statistics, metrics, documentation and developing and deploying reports from databases.
  • Excellent Knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Certified Scrum Master with experience in leading and facilitating up to 3 Scrum Teams simultaneously, extensive experience providing direction, coaching, leadership to the teams.
  • Created Business Requirements documents (BRD), Use-Case Specifications and System Requirements Specifications (SRS) accompanied by active participation in discovery sessions, interviews, document-reviews with customers.
  • Conducted GAP, Impact, SWOT, Cost benefit analysis, Root cause, Interface Analysis, Feasibility study, ROI Analysis, Impact analysis, Risk Analysis, and As-Is and To-Be business analysis.
  • Elicited requirements using techniques like Interviews, Brainstorming, Focus Group, Document Analysis, JAD sessions, Survey/Questionnaires and documented Business Requirements Documents (BRD), System Requirements Specifications (SRS), and Functional Specification Document (FSD).
  • Strong experience in tracing requirements throughout development life cycle by creating Requirement Traceability Matrix (RTM) using MS Excel & tools like JIRA and HPALM .Handled Change Requests by taking upon the role of Change Owner, Interacted with Change representatives, CCAB to review Impact Analysis and documented Change Request Form.
  • Working knowledge experience in Data services, Data Analysis, Data ETL using SQL queries tools and applications.
  • Certified Scrum Master dealt with scrum ceremonies like Product backlog grooming, Sprint planning meeting, Daily scrum, Sprint review, Sprint retrospective meetings.
  • Excellent in analyzing and cresting Use-cases, various UML diagrams like Use case diagram, Activity diagram, E-R diagrams, Data flow diagram (DFD’s) using MS-Visio, Balsamiq, mock-ups.
  • Experienced in creating Test Plan, Test Scripts, Test Scenarios, Test cases, Requirement Traceability Matrix (RTM), User acceptance Testing (UAT), and familiar with software testing and Regression testing
  • Extensive knowledge in Data Warehousing architecture, implementation approaches, schemas and dimensional modeling, Seasoned in Creating Data Models, such as Conceptual model and Logical model.
  • Performed ETL using Informatica to load the data into the data warehouse from disparate sources, designing and deploying various reports through Tableau, and IBM Cognos.
  • Decent exposure with Administration, configuration, Implementation, and Data Loading process, Application Integration in Salesforce CRM, SOQL and SOSL querying and Application development with Apex and visual force.
  • Extensive knowledge in various reporting objects like Facts , Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau . Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
  • Experience in writing SQL queries and working with databases like (MS Access, MYSQL Server, Oracle, and SQL).
  • Good Knowledge of various management system tools like MS Project, MS Visio and MS Office .
  • Implemented SharePoint for team collaboration and Document Management.
  • Excelled in guiding the work of technical teams. Articulated project goals and scope, translated business needs into technical terms. Monitor and improve the Agile Framework utilization and performance with agile teams using Agility Health with each scrum team results.
  • Convey project progress and goals to stakeholders to monitor easily using the tool Agile Craft.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum Hybrid, Extreme Programming (XP), Spiral, SAFE, Kanban, Scrum-ban, Rational Unified Process (RUP).

Requirement Management Tools: JIRA, Rally, TFS, Version ONE, MS Project, Rational Requisite Pro, HP QC, HP ALM

Reporting Tools: IBM Cognos BI, Micro Strategy, Business Objects, Tableau, SQL Server Reporting Service, Microsoft Power BI, Spotfire.

Graphical & Modeling Tools: MS Visio, Balsamic, Rational Rose, UML, Mockup Screens.

Databases: MS Access, MYSQL, Microsoft SQL (T-SQL), Oracle 9i & 10g (PL/SQL), Mongo DB.

ETL/ CRM Tools: SQL Server Integration Services, Oracle Warehouse Builder, IBM Cognos Data Manager, Informatica Power Center, Oracle Data Integrator, Salesforce.

Testing Tools: HP QTP, LoadRunner, Bugzilla, Selenium, SOAP UI, Oracle Application Testing Suite (OATS)

Microsoft Tools: MS Office Tools (Word, PowerPoint, Excel) MS Access, MS SharePoint, Outlook 365

Languages: SQL, PL/SQL, T-SQL, HTML, XML, C, C++, JAVA. .NET, R PROGRAAMING

Operating Systems: Windows XP, 7, 8, 10, Linux, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Senior Business Analyst/ Data Analyst

Roles& Responsibilities:

  • Participated in project management, design, requirements definition, specification, budgeting, control, and restructuring of organizations
  • Prepared Use Case Models based on Business Requirement documentation ( BRD ) gathered through interaction with users. Studied existing business application and processes, collected end user requirements and suggested the improvised Business Process Model .
  • Design and create ad hoc mutual fund performance reporting for both fund administration and fund accounting.
  • Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
  • Gap Analysis of client requirements generated Workflow Process , flow charts and relevant artifacts.
  • Defined and documented the Vision and Scope of the project. Conducted one on one interviews with high level management team and participated in the JAD session with the SME’s.
  • Designed Use Cases using UML and managed the entire Functional requirements life cycle using RUP . Utilized corporation developed Agile SDLC methodology.
  • Consistently tracked the project status and reported it to all the stake holders involved.
  • Negotiate with functional managers and/or organizational management to obtain adequate resources with appropriate skills to staff the project team.
  • Conducted Joint Requirements Planning (JRP) and JAD (Joint Application development) Sessions as a Facilitator to gather requirements from the group.
  • Involved in Business Process Management ( BPM ) activities like Process Design, Process Monitoring and Process Execution. Worked as a liaison between the business and technical side to convey the business needs to the system architects.
  • Used BPMN to denote business processes using MS Visio
  • Evaluating and modeling BPMN process requirements and breaking down complex process maps into user stories and acceptance criteria.
  • Created and maintained the product backlog in Rally and TFS (Team foundation server).
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Documented Business Requirements, Functional specifications, Requirements traceability matrix to ensure effective analysis for solution development (AGILE/SCRUM model).
  • Provided Informatica Information Data Quality (IDQ) technical support to business unit liaisons
  • Managed transition of physical Data Center to Salesforce Cloud, drastically lowering infrastructure costs while greatly increasing flexibility.
  • Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
  • Managed the development of a Business Intelligence (BI) data mart and reporting system within the corporate Oracle data warehouse.
  • Worked with SQL queries using MS Access for data manipulations and also worked on exporting data using Teradata.

Environment: Microsoft Office Suite, Crystal Reports, Microsoft Visio, OBIEE, Documentum, Windows, Oracle, SQL, SQL Server, Sybase, EVPN, RUP, VBScript, Dreamweaver, SharePoint, EURC, Unix, Adobe Photoshop, Caliber RM MIS-IP, C#. NET, ASP.NET, Business Objects, TestDirector, LoadRunner.

Confidential, New York City, New York

Sr. Business Systems Analyst/ Data Analyst

Roles& Responsibilities:

  • Facilitated requirement workshops, one-on-one interview sessions, group’s sessions, joint application development sessions (JAD) and prototyping sessions to come up with business and technical requirements.
  • Understood and verified all aspects of Customer Identification process (CIP), with emphasis on know your customer (KYC) and Bank Secrecy Act (BSA).
  • Ensured compliance with various compliance regulations such as Bank Secrecy Act, FINCEN, USA Patriot act.
  • Prepared Business Requirement Document (BRD) based on gathered requirements and developed solutions defining KPI’s and various models in Visio.
  • Assisted in building a business analysis process model using MS Visio and reviewing of client risk scoring, client identification and KYC documentation oversight/management requirements for AML monitoring.
  • Performed gap analysis, impact analysis, SWOT analysis, cost analysis and cash flow analysis.
  • Involved in all the sprint ceremonies such as daily stand-up calls, requirements gathering meetings, sprint planning sessions, story grooming sessions, mid-sprint reviews and sprint retrospective meetings.
  • Instrumental in implementing good acceptance criteria for user stories in Product Backlog with Product Owner and ensured the User Stories were created based on INVEST criteria.
  • Involved in developing Screen Mock-ups using Pencil Project to describe the interface Requirements.
  • Created RACI matrix to identify all relevant stakeholders in the project.
  • Used JIRA for user story management, issue tracking and requirement traceability.
  • Involved in project management, developing project plans, setting project schedules and milestones, scheduling tasks and activities using MS Project.
  • Used open source HDP to migrate to Hadoop ecosystem for both real time and batch processing.
  • Performed data migration to Hadoop Ecosystems using Apache Sqoop to offload the structured data or data from relational database into HDFS and Apache Flume to ingest unstructured or streaming data into HDFS.
  • Guided team to use Apache Kafka a fault tolerant publish subscribe messaging system was used over traditional message brokers like JMS and AMQP due to its higher throughput, reliability and replication.
  • Implemented API connection between Kafka and Sqoop/Flume using Sql Context and Kafka streaming API.
  • Used Spark which contains the ML library for machine learning and graphX for graph processing. Supervised machine learning was used, and which updated the ML models using a feedback loop and hence helped in reducing the number of false positives.
  • Worked on integrating NoSQL DB HBase with HDFS for real-time read/write access to those large datasets and batch data. Used HBase Mapper API for moving data from Spark to Hbase.
  • Collaborated with technical team in Implementing Apache Hive data warehouse software project on top of Hadoop to give an SQL like interface to query data stored in various databases and file systems that integrate with Hadoop.
  • Gathered requirements for Client-Side Validation, and Server-Side Validation. Responsible for technical writing using XML for API development.
  • Involved in software integration testing and web services API testing using SOAP UI. Worked with QA team in creating a test suit, test cases, test file and test definition.
  • Responsible for writing feature file in cucumber for various scenarios in Gherkin format. Selenium driver was integrated with cucumber, created Step definition file and Maven Project.
  • Developed Reports/interactive dashboards with dashboards with different analytics views (Drill-Down/ Dynamic, Pivot Table, charts, Tabular with filters) based on user requirements in Tableau.
  • Integrated the third-party services for CDD and EDD and real-time checks on on-boarding people and company integrated our application server with the comply Advantage’s REST API.

Environment: Jira v6.4, MS Visio, Eclipse IDE, Pencil Project, HDFS, Java, Apache Hadoop, Hortonworks Data Platform, Apache Spark v 1.5.2, Apache Sqoop v 1.4.6, Apache Flume v 1.5.2, Kafka 0.10, HBase v 1.1.2, Hive v 1.2.1, Atlas, Tableau v 9.0, HDFS, XML, API, Cucumber, Selenium, Jenkins, HTML5, CSS3, JavaScript, AJAX, SOAP UI, JSP.

Confidential, Boston, MA

Senior Business Analyst/ Scrum Master

Roles& Responsibilities:

  • Participated in project management, design, requirements definition, specification, budgeting, control, and restructuring of organizations
  • Prepared Use Case Models based on Business Requirement documentation ( BRD ) gathered through interaction with users. Studied existing business application and processes, collected end user requirements and suggested the improvised Business Process Model .
  • Utilized corporation developed Agile SDLC methodology . Assigned tasks among development team monitored and tracked progress of project following agile methodology.
  • Gap Analysis of client requirements generated Workflow Process , flow charts and relevant artifacts.
  • Defined and documented the Vision and Scope of the project. Conducted one on one interviews with high level management team and participated in the JAD session with the SME’s.
  • Responsible for establishing and maintaining positive business relationships with IT managers and clients, and ensuring that business objectives and priorities are aligned.
  • Consolidated the analysis of multiple business lines after the COTS evaluation .
  • Worked on billing system a cash management module and enhanced the encrypting standards that are required for the application.
  • Involved in Business Process Management ( BPM ) activities like Process Design, Process Monitoring and Process Execution. Worked as a liaison between the business and technical side to convey the business needs to the system architects.
  • Proficient in business process modelling ( BPM ), documentation , and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
  • Designed Use Cases using UML and managed the entire Functional requirements life cycle using RUP . Utilized corporation developed Agile SDLC methodology.
  • Used Scrum Work Pro and Microsoft Office software to perform required job functions
  • Conducting Requirement Analysis , Use Case Design, Designing Test Plans and developed database schemas based on the logical models. Conducted the final user-acceptance testing ( UAT ) and usability testing
  • Involved in review and Gap Analysis of Functional Requirement documents ( FRDs ) and the creation of technical documents and related test case documents
  • Provided the management with Test metrics, Reports, and Schedules as necessary using MS Project and participated in the design walkthroughs and meetings
  • Conducting requirement gathering sessions, gathering business requirements and translating into system requirements, building project plans, designing using Rational Rose/UML, relational database design and handle all release changes.

Environment: Agile, Windows Vista, Microsoft Project, MS Access, Business Objects, MS Visio, SQL, MS Excel, Oracle, Java, Rational Suite, MS Visio, MS PowerPoint

Confidential

Business Analyst

Roles & Responsibilities

  • Gathered requirements on the online brokerage platform from stakeholders by facilitating JAD sessions and extensive meetings with SMEs. Conducted Gap Analysis and created AS-IS and To-Be Process Flows documentation.
  • Conducted data mapping & data indexing for retrieval of information from existing account systems & outlined security measures for accessibility and transmission of information using standard templates in MS Excel. Created Requirements Traceability Matrix (RTM) to track requirements and test cases using Rational Requisite Pro.
  • Assisted and worked with Project manager in creating and assigned task through Work Breakdown Structure (WBS).
  • Interacted with the customers and internal stakeholders in defining project scope boundaries and gather user requirements and their expectations from the system to create BRD, FRD and SRS.
  • Created business and functional requirement documents and prepared Use Cases models, Sequence Diagrams and Activity Diagrams using tools such as Rational Rose and MS Visio.
  • Worked with the QA team for designing Test Plan and wrote Test Cases for the User Acceptance Testing (UAT) and assisting the Automation Testers in System Testing, Integration and Regression Testing.
  • Developed plans for verification and validation of requirements at all levels so that developed software successfully fulfilled user expectations and business needs.
  • Worked closely with Project Manager for any change request and helped to do Impact Analysis.
  • Worked with Quality Assurance (QA) testing team in preparing the test cases, test plan and procedures for system testing
  • Used HPQC for allotting tasks, issue tracking and requirement traceability. Documented the cause analysis and final resolution to the issues. Designed and Implemented SQL queries for QA testing and reporting data validation.

Environment: Waterfall, MS Visio, MS Office Suite, MS Access, SQL version, Rational Rose, HP Quality Center, MS Project, MS Visio, MS Office (MS Excel, MS Word, MS PowerPoint).

Confidential

Business Analyst

Roles & Responsibilities

  • Facilitated meeting and arranged JAD sessions with business users for requirement gathering.
  • Performed requirements analysis, formulate and define systems scope and objectives through user needs and an understanding of business systems and industry requirements.
  • Developed documentation for various stages of the Software Development Life Cycle (SDLC), including Functional Designs and Test Cases. Provided functional support and guidance to application changes.
  • Served as a liaison between business team and the project team by assisting the business in identifying, understanding and documenting their business needs and requirements.
  • Created AS-IS and TO-BE business process flow diagrams, integrate process flow diagrams to show end-to-end business model including swim lanes for the elicited business requirements.
  • Responsible for preparing Software Requirement Specifications (SRS) and Functional Requirement Specifications and performing Gap Analysis to check the system compatibility with the new requirements.
  • Created use cases and designed use case diagrams class, sequence diagrams and activity diagrams.
  • Used SharePoint for content management and document management. Assisted in gathering requirements for the GUI (Graphical User Interface) Screens and designing mockup screens using Balsamiq.
  • Added and configured various transformations like lookup, derived column, data conversion, aggregate, conditional split, merge, row count, union, select and join pertaining to data.

Environment: SQL Server 2008, SQL Server Integration Service (SSIS), SQL Server Reporting Services, Waterfall, MS Office, MS Sharepoint, MS Excel, MS Access, UML, Balsamiq

Confidential

SQL Developer

Roles & Responsibilities

  • Participated in creating Database Objects such as tables, views, stored procedures, indexes and triggers.
  • Designed database tables to store the data coming from different applications and determining what data is returned or received from the applications. Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Performed Data Modeling using Erwin and created Entity-Relationship diagrams for the new databases.
  • Defined primary keys and foreign keys for tables and used constraints in order to maintain data integrity.
  • Created Drill-down, Drill-through, linked, lists, templates and sub reports. Created, modified and maintained client tables for deposits, payments, loans and mortgages.
  • Used SQL queries like Select and Join to retrieve data from SQL server and Oracle Databases.
  • Proficiency in creating simple tabular and matrix reports using SSRS. Involved in design/developing, managing and deploying reports in MS SQL Server environment using SSRS.
  • Worked closely with the Database Administrator in creating the database and maintaining the database components and participated in designing how the data should be organized and how data should be displayed.
  • Written stored procedures and triggers to implement business rules. Created documentation as required.

Environment: SQL Server 2008, SQL Server Reporting Services (SSRS), Oracle DB, Visio, Erwin, MS-Word, Excel

Hire Now