We provide IT Staff Augmentation Services!

Business Data Analyst Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • 6+ years of experience in supporting business solution software and analyzing business operations. Aiming to utilize strong prioritization skills and multiple stakeholder management skills to achieve the business needs. Ambitious, adaptable and analytical individual with demonstrated ability in delivering the right product as a cross - functional lead.
  • Holds IT experience in RDBMS & Data warehousing, experience in building, testing, implementation and support of enterprise data warehouse. Business/Data Analyst with experience in all phases of the Project Development Life Cycle: Planning, Analysis, Requirements Management, Reporting, Testing and implementation of projects.
  • Generated reports using Complex Postgre SQL (PL-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the Stored Procedures, User-defined Functions and Views. Tuning the performance of Stored Procedures and large TPL-SQL Queries.

TECHNICAL SKILLS

Project Methodologies: Agile, Hybrid Agile, SCRUM,Waterfall, RUP, Gherkin, UAT

Tools: ServiceNow, Autosys Job Runner, Artiva AutomationPaymentus, Splunk, Postman, Paxata Data Preparation, Microsoft Office (Word, Excel, Outlook, PowerPoint, Visio), JIRA, Aha, Google Cloud Platform (GCP), Data Discovery, Looker, Cucumber, Lucidchart, SoapUI.

Programming Languages: SQL, R, Python

Databases: PL/SQL Developer, Hadoop HIVE, BigData,Oracle 9i/8i, SQL Server, Oracle, DB2

Operating Systems: Windows Vista/7, windows XP,Unix, Macintosh, Linux.

Requirement Management Tools: JIRA, Confluence, SHAREPOINT, Rational Requisite Pro, Rational Clear Case, Rational Clear Quest.

PROFESSIONAL EXPERIENCE

Confidential

Business Data Analyst

Responsibilities:

  • Worked as a Lead BA from initiation to implementation contributing to planning, organizing, designing and prioritizing the features for the project. Displayed BA skills by collaborating with multiple stakeholders to help consolidate various forms owned by different teams. Gathered inputs and wrote requirements to better user experience. Perform advanced data analysis to provide ad-hoc data queries in response to critical business needs using PL-SQL Oracle database.
  • Checked the data flow through the frontend to backend and used SQL queries to extract the data from the database.Performed Gap Analysis, by evaluating the key differences between the As-Is and the To-Be system and identifying the key requirements for system reengineering.
  • Developed and maintained automated regression test cases in Cucumber using Gherkin language. Involved in test planning, test execution plan Documentation including creating test scenarios and test cases design for the projects.
  • Experience in using PL/SQL for developing stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
  • Performed various types of testing, such as functional, regression, user acceptance testing with Gherkin method. Participated in Defect triage meetings to ensure invalid defects are addressed. Involved in Black box testing and manual testing methodologies using SoapUI.
  • Coordinated and managed testing projects at every step of the quality cycle from test planning through execution to defect management. Worked with Developers to resolve the issues.
  • Monitored all phases of the testing process, communicating project information, test schedules and their execution. Conducted Functionality and Regression testing during the various phases of the development and ensured the entry exit criteria tracking the test cases to the requirement specifications document using Postman, SPLUNK, Autosys Job software.
  • Collaborated with developers to test and cross- verify solutions with business requirements. Documented at multiple levels of Software Development Life Cycle (SDLC), right from requirement documents to functional solutions including training guides and user manuals to streamline processes.
  • Document results of data analysis and develop integration functionality supporting front, middle, and back-office teams on the product enhancements, data reconciliation, and performance measurement of OFSLL.
  • Support Application Developers and product managers on ServiceNow which is a SaaS for service management, operations management and, project/agile management. Engaged matrix partner teams (Technology, Training, Reporting Product, Quality, Legal, Regulatory, etc.) to effectively deliver on each project and closely collaborated as a BA in a cross-functional scrum teams by writing user stories, determining acceptance criteria, on ServiceNow.
  • Designed and recommended business and operations solutions and process improvement through analysis of regulatory requirements and implementation of proposed designs using agile methodologies.
  • Assisted in designing and developing robust solutions to meet client requirements for functionality, scalability and performance of OFSLL and the other products which integrate with it such as Artiva, Paymentus and, Dealer Financials.

Confidential, Bentonville, AR

Business Data Analyst

Responsibilities:

  • Performed data validations to ensure the data quality standards are met on Hadoop, Hive, Data Discovery, and Looker which integrated Google cloud platform (GCP) & ON-Prem Druid. Served as the technical expert on appropriate data sources and tools to optimize activity.
  • Wrote user stories & defined requirements for design and engineering teams on JIRA and Confluence. Participated in sprint planning meetings and ongoing refinement of the product backlog.
  • Assisted with developing, communicating and implementing a technology future state and the roadmaps for Business and Tech teams.
  • Steered in-house projects by performing feature analysis and optimizing the product by adding valuable features and justified technology process improvements of GCP.
  • Created weekly, bi-weekly, monthly and quarterly reports from database using SAS, SQL and Macros with accurate values. Developed Software Requirement Specification (SRS) document using Visio and MS Office.
  • Developed internal algorithms, condition-action tables and decision trees and tables that in corporate Flight Deck data.
  • Developing and executing SQL queries against data warehouses to support data mapping (GCP) and ad-hoc analysis. Established and maintained traceability matrix until business requirements were signed off.
  • Expertise in handling various forms of Data like Master Data, Meta data, Source Data with the ability to provide Data analytics using various tools (Access, Excel, Reporting tools, etc.) and overall working experience in providing qualitative & quantitative assessment of data.
  • Managed Change control, ensuring any needed change requests were documented appropriately, routed through proper channels, and given necessary approvals. Assisted the QA team with test case creation and maintained a dual defect tracking mechanism (JIRA and defect log) to track the status/completion of defects.
  • Supported product implementation and deployment by engaging with Engineering and Project Management teams during implementation for Flight Deck and EPM/PBCS. Clarifying customer requirements, removing roadblocks, constantly communicating, and gaining alignment around feature & product strategy.
  • Maintained a master item list ensuring business users are aware of changes in item portfolio and monitored item performance into reporting, delivering findings to the business users.

Confidential, Columbus,OH

Business Process Consultant

Responsibilities:

  • An internal business product and process consultant responsible for communicating to customers, management and external sources. Solved complex interaction problems with simplistic approaches, illustrating your solution with user flows, wireframes, and visual mockups on VISIO.
  • Conducted analysis of complex business and user needs, definition of business requirements and recommended appropriate solutions and business strategies. Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.
  • Worked on SQL queries on Oracle DB for reports / data validation. Expertise in MS SQL Server, SQL stored procedures, cursors, views, indexes, and query optimization.
  • Participated in Agile process - planned iterations, created tasks, assigned tasks to quality assurance team based on the priorities and estimated capabilities of quality assurance team for every iteration.
  • Coordinated with developers, conducted JAD with Actuarial SMEs, Developers, Project Managers and Data Analysts to discuss business requirements, test planning, and defect tracking sessions and cloud Plaform.
  • Worked on the continuous improvement of QA Process by reviewing and evaluating existing practices with standard testing guidelines.
  • Gathered Business Requirements, Analysis, Design, Development, Testing, Implementations Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence tools.
  • Transfer Excel audit reports to a more automated solution. Used established pivots as the basis for creating parameterized reports and data-driven subscriptions. Developed Requirements Traceability Matrix (RTM) totrack requirements against test cases during the QA Phase using HP ALM.

Confidential

Business Data Analyst

Responsibilities:

  • Developed a data lakewith data from horizontal and vertical applications across the organization.Responsible to extract and test the data from databases to help reduce the overall auditing costs.
  • Developed a POC(proof of concept) product and gained expertise in extracting, transforming data in Paxata. Importing from database with connectors and developing a tool agnostic data lake to accommodate external and internal auditing requests.
  • Expertise in Data analysis and mapping for different Insurance admin systems like Cyberlife (Fixed Life), Vantage, ALS, Legacy Apps like Provident Suite. The admin systems hold different product suites for Life (Whole Life, Variable Universal Life, and Universal Life) and Annuity.
  • Extensively used SQL to analyze data in the SQL server DB. Involved in creating Stored Procedures, DB, DB tables. Created BRD, Business Rules, Design docs, Technical Specs, and Test Plans.
  • Managed and updated Steering Committees around all deliverables and progress made across projects. Automate the analysis and reporting of ERM to the appropriate audience for consumption.
  • Created a robust reporting process that is reliable, controlled and repeatable which produces a complete set of approved counterparties.
  • Created various Tabs, Workflows, Reports, triggers and validation rules for the application generating security tokens, validation Rule, upgrade the Data lake and the connections between the Legacy Systems.
  • Tested the communication protocol to ensure that it met the defined SLA. Performed Backend Testing-using SQL queries, generating reports to ensure data integrity and validate business rules.
  • Performed and documented root-cause analysis of data quality issues and recommend changes. Performed Data Analysis, Data Integrity and Data validation tests by writing SQL queries and responsible for downstream impact to the data warehouse.

Confidential

Transaction Risk Analyst

Responsibilities:

  • Functioned as the primary liaison between the business user, project sponsor, operations team, and the technical team throughout the project life cycle.
  • Performed task decomposition, delegated tasks and monitored project milestones using MS Project and prepared GANTT charts. Maintained and updated the MS Access and SQL Server Databases by running backups and tuning queries.
  • Identified, analyzed, and interpreted trends or patterns in complex data sets. Maintained database using MS SQL Server relational database. Worked with large databases consisting of multiple terabytes of data.
  • Used MS SharePoint & SQL to fetch the data needed for analyzing and avoid dependency. Interact with business groups & provide quality first-tier security assessment, including data gathering, policy analysis, & risk evaluation across Confidential 's global enterprise environment.
  • Worked in a big data environment, which includes data design, database architecture, and metadata repository creation.
  • Researched and evaluated facts surrounding buyer and seller transactions. Communicated with customers & peers following the investigation process.
  • Experience working in risk assessment, security-based audits, & participated in providing operational support using automated trouble ticketing.Responsible for auditing investigator actions, analyzing and reporting on QA data and trends. Identify process deviations with respect to investigator actions by conducting audits.
  • Monitored customer transactions, analyzed data, and provided data complex reports generation with macro utility to improve efficiency enforced in offices in different locations includingNorth America, Great Britain, Canada, and India.

We'd love your feedback!