We provide IT Staff Augmentation Services!

Business Analyst/data Analyst Resume

2.00/5 (Submit Your Rating)

WashingtoN

SUMMARY

  • Experienced Business Data Analyst skilled in interpreting, researching, and analyzing business requirements in a fast - paced environment. Offering over 4 years of Experience in preparing detailed documents and reports for complex applications and data sets. Proficiency in all aspects of SQL server and Business Intelligence tools.
  • Experienced in working closely with various stakeholder’s groups to build business requirements and functional design documents.
  • Analyzed and gatheird requirements, documented functional and business requirements (BRS) to assist in teh design of applications.
  • Experience in migrating other databases to Snowflake.
  • Participated in converting business requirements to technical specifications.
  • Good experience in organizing Scrum ceremonies, interviews, and requirements elicitation sessions.
  • Efficient in managing teh product backlog, and prioritizing features and user stories.
  • Strong working experience in all phases of SDLC implementing Agile methodologies.
  • Experienced in working different iterative development frameworks like Scrum.
  • Good experience in Product Development and Project Management.
  • Experience in launching products that solved real-world problems in teh healthcare and finance domains.
  • Extensive experience working with relational databases (RDBMS) and solid understanding of data models and data pipelines.
  • Experience working with data visualization tools like Power BI and Tableau.
  • Strong understanding in designing and maintaining data systems and databases.
  • Good understanding of microservice architecture and Application Programming Interfaces (APIs).
  • Profound experience in supporting Change Management and Release Management processes.
  • Extensive experience using Project & Portfolio Management (PPM) tools like Jira, Azure DevOps, Aha, and Microsoft Project.
  • Experienced working with Data Warehousing (ETL/ELT) and Business Intelligence (BI).
  • Excellent noledge to use data analytics to find solutions for modern digital transformations.
  • Have good understanding of current changes in healthcare due to HIPAA regulations and teh affordable care act.

TECHNICAL SKILLS

Operating Systems: Windows (XP, 7, 8, 10, Servers-Latest), Linux, UNIX

Databases: Snowflake, Oracle, MySQL, Microsoft SQL Server, Teradata

Programming & Web: SQL, Python, HTML, CSS, JavaScript, XML, JSON, R

Business Intelligence: SSIS, SSRS, Power BI, Tableau, Qlickview

Cloud Computing: Azure, Salesforce (SaaS & PaaS), Snowflake

Visual Modeling & Mockups: InVision, Balsamiq, Microsoft Visio, Figma

Product &Project Management: Jira, Confluence, Azure DevOps, Aha, HP ALM, ServiceNow, Microsoft Project, SharePoint, Microsoft Office

Other Tools: Eclipse IDE, HP Quality Center (ALM), SQL Server Management Studio, Oracle SQL Developer, MySQL Workbench, Toad, Visual Studio, VMware, PyCharm, Postman, SOUP UI.

PROFESSIONAL EXPERIENCE

Business Analyst/Data Analyst

Confidential, Washington

Responsibilities:

  • Facilitated stakeholder elicitation workshops to develop High-Level business requirements.
  • Developed and documented functional and non-functional detailed requirements.
  • Worked closely with design architects and operations teams to obtain requirement sign-off.
  • Created Use Cases and Process Flow diagrams using MS Visio.
  • Tableau dashboards and visualizations were prepared using action filters, parameters, and calculated sets.
  • Appointed primary quality assurance analyst, directing a QA team to test, plan, and execute end-to-end pre-deployment regression testing for a pilot client site.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Wrote production validation test cases for teh new software team and performed functional, regression, deployment, and integration testing.
  • Converted system requirements into Use Cases and entered information into a Team Foundation Server (TFS).
  • Reviewed and transformed business and User Story requirement documentation and created wireframes for stakeholder approval.
  • Writing SQL queries against Snowflake.
  • Collaborated with product managers and a development team to identify and resolve issues, coordinate system requirements, and create project timelines.
  • Designed CRM data reports to accurately track sales operations workflow, and processes and documented yearly performance.
  • 100% project completion on time while meeting strict timelines and stakeholder requirements.
  • Created and reshaped a repeatable support process for new implementations of migration services.
  • Reliably translated and executed hundreds of internal data reports utilized by leadership to perform audits, provide customer communications, and forecast trends. working with Data Warehousing (ETL/ELT).
  • Reengineered internal report process with leadership alignment, cross-training new teams, creating service delivery commitments, and process documentation.
  • Accurately applied payments to third-party vendors and successfully re-negotiated vendor contracts to reduce costs by 15 percent.
  • Implemented assignment of 300 plus technical sizing requests.
  • Proactively conducted an impact analysis of teh internal stakeholder operations utilizing teh CRM & ERP software module to document findings and presented cost-cutting solutions.
  • Specialize reports point-of-contact for teh vendors and sales operations staff.
  • Managed existing customer following while developing new business.
  • Converted CRM leads into opportunities by applying teh appropriate process of identifying teh "wat’s" & "wants" of teh stakeholder and maintaining communication during teh project duration.
  • Created functional prototypes using Axure.
  • Wrote and revised business requirements document with teh client, assigned technical team, and managers until client sign-off was obtained.
  • Created and executed scripts based on requirements and circulated results for sign-off.
  • Trained teh operational team selected to support teh quarterly system implementations.
  • Worked with teh Automation Testing team to in corporate multiple test scripts into their test bed.

Business Analyst/Data Analyst:

Confidential

Responsibilities:

  • Responsible for defining Stories and prioritizing teh Team Backlog to streamline teh execution of program priorities while maintaining teh conceptual and technical integrity of teh Features or components for teh Scrum team.
  • Coordinated with application users and various stakeholders (including other POs) to understand business problems, requirements, and goals that teh business team need to achieve.
  • Writing SQL queries against Snowflake.
  • Collected, cleansed, and provided modeling and analyses of structured and unstructured data used for business initiatives which resulted in $1M annual savings.
  • Worked with technical SMEs to come up with a solution and ensure that solution meets business needs.
  • Lead requirements discussions to document, analyzed and translated functional and non-functional requirements into user stories, diagrams, and other deliverables as needed.
  • Queried and reported data using tools like SQL, Power BI, and Excel.
  • Participated in Scrum Agile events and other agile activities.
  • Managed multiple priorities, customer expectations and relationships with all stakeholders.
  • Assisted teh team as needed to complete stories and with troubleshooting problems and developing recommendations/solutions.
  • Supported training development for end-users and staff members.
  • Collaborated, coordinated, and communicated across disciplines and departments.
  • Ensured teh project requirement compliance with HIPAA regulations and requirements.

Data Analyst

Confidential

Responsibilities:

  • Worked with cross-functional teams to structure problems, identify appropriate data sources, extract data and develop integrated information delivery solutions.
  • Writing SQL queries against Snowflake.
  • Experience with Snowflake cloud-based data warehouse
  • Created Views and Table-valued Functions, Common Table Expression, Self-joins, complex subqueries to provide teh reporting solutions.
  • User requirement gathering and solution design as well as provide solutions and ad-hoc reporting.
  • Data validation and Data cleansing.
  • Created, managed, and delivered interactive web-based reports to support daily operations.
  • Successfully deployed SQL Server Integration Services (SSIS) Package into Production environment and used Package configuration to export various package properties to make package environment independent.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Generate weekly forecast and metric reports & provide analysis for Sales Management.
  • Executed daily updates using Microsoft excel and pivot tables
  • Created action filters, parameters, and calculated sets for preparing dashboards and visualizations in Tableau.

We'd love your feedback!