Post Job Free

Resume

Sign in

Data Analyst Sql Server

Location:
Springfield, IL
Posted:
October 02, 2023

Contact this candidate

Resume:

Haritha Nadella

Contact: 252-***-****

Email: adz3qz@r.postjobfree.com

Versatile and solution-focused business analyst with extensive experience improving business and operational processes using natural analytical abilities. Meticulous and disciplined, with a natural talent for analyzing business processes and developing useful metrics and benchmarks for tracking.

PROFESSIONAL SUMMARY

Businesses/Data Analyst professional with 7 years of IT experience in cross-functional Agile/SCRUM teams, Business System Analysis, Business Process Improvement, Program Management, Project Development, Configuration, Implementation, Testing.

Experience in conducting GAP Analysis, SWOT Analysis, and Porter 5 Forces to ensure the compatibility of the existing system with the new business requirements.

Worked closely with project managers, SMEs, Architects, and staff to understand and brief the requirements (Functional/Non-Functional), needs, and constraints for new applications.

Excellent analytical skills for understanding and gathering requirements, business rules/processes, and the application's detailed design, including generating use case models, analysing diagrams, and Data Flow Diagrams.

Strong experience in Scrum/Agile methodology and proficiency in writing user stories of core business systems.

Involved in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.

Hands-on experience in working with Continuous Integration and Deployment (CI/CD).

Hold excellent presentation, communication, and documentation skills with good process management and interpersonal skills to gather requirements from cross-functional stakeholders (Developers, Designers, and Business staff) to bring out quality products.

Documentation in the form of Artifacts and Specs. Experienced in Scrum Practices like User Stories, Story Slicing, Backlog Grooming, Release Planning, Sprint Planning, Spring Review, and Sprint Retrospective.

Good working knowledge in a multi-tiered distributed environment, a good understanding of Software Development Lifecycle (SDLC)-Agile and Waterfall Methodologies.

Able to work with self-organizing and cross-functional teams. Experience of System Development Life cycle (SDLC) approaches like Waterfall methodology, Agile-Scrum, Waterfall-Scrum Hybrid and knowledge on other approaches like Extreme Programming, Spiral, Rational Unified Process, SAFE, Scrumban and Kanban.

Conducted Scrum Ceremonies like Product Backlog Grooming, Sprint Planning, Release Planning, Daily standups, Sprint Review meeting and Sprint retrospective meeting.

Broad involvement in the whole Software Development Life Cycle (SDLC) that included Requirement Elicitation, Gathering, Analysis, Design and Development, Testing and Deployment.

Strong experience in Scrum/Agile methodology and proficiency in writing user stories of core business systems. Involved in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.

Assisted product owner with the Definition of Done (DoD) and Definition of Ready (DoR) for backlog items.

Helped with the story mapping process in Agile after elicitation and documentation of requirements (user stories).

Facilitated Release Planning sessions for the product, assisted all the teams in writing business epics. Helped in the sizing and estimation and prioritization of epics by helping SMEs performing SWAG Analysis.

Assisted ART (Agile Release Train) and scrum teams in resolving dependencies and empowering the teams with the Pillars of Scrum such as increasing Transparency, Inspection and Adaptation and achieving goal to deliver the PSPI (Potentially Shippable Product Increment) at the end of every Iteration.

Experienced with issue creation and resolution using Atlassian JIRA. Facilitated the team and created Scrum artifacts like Product Backlog and helped define the User Acceptance Criteria, MVP (Minimum Viable Product) and MRF (Minimum releasable features) to assist with an overall release and feature plan for the products.

Documentation in the form of Artifacts and Specs. Experienced in Scrum Practices like User Stories, Story Slicing, Backlog Grooming, Release Planning, Sprint Planning, Spring Review, and Sprint Retrospective.

Well versed in project management tools like MS Project for Project planning, Project scheduling.

TECHNICAL SKILLS

Project Management Tools/Methodology

Unified Modeling Language (UML), MS Share Point, BPMN, JIRA, Agile-Scrum, Waterfall-Scrum, Waterfall, RUP, Extreme Programming, Kanban, SAFE.

Requirement Management

JIRA, MS Office, TFS, Confluence.

Reporting Tools-BI

Tableau, MS office Suite, SSRS, Microsoft Power BI

Designing Tools

Swagger

Office Tools

MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Project, MS Visio

Testing Tools

HP QC, HP ALM

ETL Tools

Informatica

Languages

HTML, XML, SQL

Database/ETL

MySQL, MS-Access, SQL Server

Defect Tracking tools

JIRA, HP ALM QC, Service Now, SalesforcePro

PROFESSIONAL EXPERIENCE

Sr. Business Analyst August 2022 – Present

Johnson & Johnson, Somerset, NJ.

Responsibilities:

Worked on understanding current processes in Automating Fingerprinting process for creating AS-IS and TO-BE workflows and use cases

Performed responsibilities of conducting the various type of testing like functional, regression, system, and integration

Involved in Joint Application Development sessions with SMEs and development teams and documented functional business requirements as product backlogs using JIRA

Gathered requirements and modeled the data warehouse and the underlying transactional database

Conducted Joint requirements sessions with Product Owners, SMEs and Dev leads to document the requirements, feasibility, effort estimation, user story prioritization, and triaging

Perform business analysis of eCommerce sales and operations to improve overall business performance

Customized Data model of Salesforce.com CRM using Workflows, Triggers, Validation Rules, Approval Processes, and process builder

Consulted with stakeholders to gather and document requirements for data governance projects, helping to establish agreed-upon data definitions and consistent data capture across the company.

Re-mediate issues on applications and make sure updates are done in ServiceNow. Troubleshoot and perform corrective action on the IT Service Management software HP Service Manager and ServiceNow.

Involved in the Installation of new custom Templates for Office365 configuration setup of sites, lists, and libraries

Conducted requirement gathering sessions with business users, discussed reporting and analysis needs, created data model, performed data validation, and developed dashboards measuring their KPIs

Translated business requirements and user expectations into detailed specifications employing Flow charts like system context diagrams, Functional decomposition diagrams, using MS Visio and MS PowerPoint. Involved in drafting Requests for proposals (RFP)

Collected, analyzed, and specified business and technical requirements. Understood business challenges and translates them into data models, processes, and technical solutions.

Oversaw the Data Governance (DG) Business Glossary and process leading to creation/changes of Glossary assets.

Involved in providing technical guidance to IT team, installing, and configuring D365, proficient with SQL Server, Data Migration Framework

Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.

Lead Business Intelligence reports development efforts by working closely with Micro strategy, Teradata, and ETL teams.

Worked on creating and providing support for Project Plan in MS Project and preparing Project Charter. Responsible for unit & integration of various system modules. Prepared unit & integration test scripts and executed them on various releases

Environment: MS SQL Server, Power BI, Microsoft Suite (Word, PowerPoint, Excel, Visio), Salesforce, Informatica, Data360, MDM Informatica.

Business Data Analyst November 2021 - July 2022

State Farm Insurance, Bloomington IL.

Responsibilities:

Developing SQL queries using window functions to generate reports to identify tier distribution of advisors and evaluate their mobility and engagement yearly.

Optimizing reporting process by developing SQL scripts in Snowflake Data Cloud and connecting Tableau for faster performance.

Utilizing complex query statements using SQL subqueries, correlated queries, case statements, and aggregate functions

Designing advanced Tableau Dashboards to analyze sales year over year, quarter on quarter trend.

Generating Reports using Microsoft Power BI to present supporting data for KPI goals for any new suppliers joined.

Collaborate with the Product Owner on project/roadmap planning, facilitated daily stand-up meetings, reviews, retrospectives, sprint and release planning, demos, and other Scrum-related meetings

Conducted many informal sessions to develop an architectural solution to confirm that the application meets the business requirements, resolved open issues, and handled change management requests.

Arranged sprint grooming, planning, daily scrum, sprint demo, and sprint retrospectives.

Organized and conducted Joint Requirements Planning sessions (JRP) as a facilitator to gather requirements from the Business User.

Facilitated Joint Application Development (JAD), Joint Application Management (JAM), and Rapid Application Development (RAD) sessions when needed.

Used agile methodology to Conduct Data Analysis to find missing data fields in the application and customize them and extensively used Rational Requisite Pro.

Conducted walk-through sessions for User Stories and Use Cases to discuss certain issues with stakeholders, architectures, and design & development teams and performed GAP Analysis.

Partner with clients/technical groups to perform quality reviews on business requirements to determine if the requirements fulfill the demands of the end users.

Perform extensive Data Analysis, Data Requirement Analysis, and Data Mapping and created Data Mapping Documents.

Analyzed Business Requirements and created Use Cases, Use Case Diagrams, Navigation Flow, Business Flow Diagrams, and Workflow Diagrams for applications and created Activity Diagrams / State Chart Diagrams using MS Visio.

Regularly interacted with the Testing team for executing the Test Plans, providing Test Data, creating Test Cases, resolving issues upon detection of bugs, and collecting the Test Metrics.

Managed product backlog within JIRA, and project information and artifacts using Confluence.

Defined validations to be built into the application in line with the functional requirements.

Assisted QA team with User Acceptance Testing, developing, and maintaining quality procedures ensuring that appropriate documentation is in place.

Environment: IBM Rational Suite (IBM Rational Requisite Pro, IBM Clear Case), Java, Test Director, Use Cases, GAP Analysis, Data Mapping, MS Visio, MS Word, MS Excel, SQL Server 2012, Splunk, JIRA, Confluence, SQL Management Server, Tableau, Advanced Excel

Jr. Business System Analyst April 2016 - October 2021

Tata Consultancy Services Ltd

Bangalore, India

Responsibilities:

Performed multifaceted roles in Oracle Transport Management implementation: FMCG client-data analysis using Excel pivot tables, V-lookup, functional consulting, scoping, and post-go-live support for 5+ releases.

Created business requirements documentation, user acceptance scenarios, test cases, and stories using Confluence, developed end-to-end flow diagrams using Lucid Chart for 3 projects, and create dashboards to track project workflows.

Created context and workflow models, information and business rule models, and Use Case and Object Models during the analysis using rational tools.

Gathered requirements using Use Case analysis and Developed system requirements from business requirements (BRD), Architect approach documents, Functional Specification Documentation (FSD) and communicated these to the stakeholders.

Designed ETL packages using SSIS to load data from SQL Server to OLAP and developed OLAP cubes using SSAS for ad-hoc Business Report analysis.

Conducted Business Requirements, Functional and Technical meetings with Business groups to perform Business Process Mapping, AS IS and TO BE analysis

Led and conducted JAD sessions for requirements gathering, analysis, and design of the system.

Collaborated on the creation of documents such as the Vision, business requirements (BR), and business systems design (BSD) documents.

Performed Data Analysis of existing data through SQL and MS Access and Data mapping, created class diagrams and ER diagrams, and used SQL queries to filter data.

Worked extensively with the QA team for designing Test plans and Test Cases for User Acceptance Testing.

Actively interacted with different business groups to perform a Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.

Helped the testing team document the system requirements and testing system development.

Developed timelines for the project, and managed timelines and resources to successful completion.

Gathered requirements, set up project timeline, engaged vendors and internal resources required to design, implement, test and deploy the application

Worked throughout the SDLC which included requirements, specifications, design, analysis, and testing utilizing RUP methodology.

Developed requirements specifications according to standard templates, using User Stories.

Used Rational Unified Process (RUP) methodology to perform Case modeling, Use Cases, Activity Diagrams, and Sequence Diagrams.

Designed and executed the Requirements Gathering sessions with the Business User team to collect the Business Requirements, Processes, and the Data Requirements.

Facilitated Brain Storming sessions to discuss and document new User Requirements. Also conducted meetings with the Users and Programmers to discuss solutions and develop scenarios.

Manages the day-to-day activities on multiple businesses sponsored IT projects of different work streams to deliver milestones on time, within budget, and within the scope and align resource’s responsibility with the project plan. Communicates with leadership on program strategy, direction, and changes.

Responsibilities also included analysis of testing the user interface and re-designing the system to ensure its functionalities to the client’s satisfaction.

Worked closely with project managers, SMEs, Architects, and staff to understand and brief the requirements (Functional/Non-Functional), needs, and constraints for new applications.

Excellent analytical skills for understanding and gathering requirements, business rules/processes, and the application's detailed design, including generating use case models, analyzing diagrams, and Data Flow Diagrams.

Thorough understanding of Business Intelligence (BI) and experience in creating interactive, analytical dashboards using Tableau and Power BI. Experienced in writing SQL queries to generate reports.

Hold excellent presentation, communication, and documentation skills with good process management and interpersonal skills to gather requirements from cross-functional stakeholders (Developers, Designers, and Business staff) to bring out quality products.

Environment: IBM Rational Suite (IBM Rational Requisite Pro, IBM Clear Case), MS Access, UML, Rational Rose, UAT, BRDs, Test Director, Use Cases, GAP Analysis, Data Mapping, MS Visio, MS Word

EDUCATION

Bachelor of Technology in Information Technology May 2016

Jawaharlal Nehru Technological University, Kakinada

(GPA: 8.38/10.0)



Contact this candidate