We provide IT Staff Augmentation Services!

Sr. Business Analyst/data Analyst Resume

3.00/5 (Submit Your Rating)

New, JerseY

SUMMARY

  • Experienced Business Analyst/Data Analyst/Product owner/Domain consultant/Scrum Master with strong understanding of IIBA, ITIL, and PMI principles
  • Expertise in Requirement Gathering, Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms with in - depth knowledge on report design, data analysis, ETL solutions using ODI and reporting tools.
  • Extensive experience in IT consulting, Quality Assurance, ITIL Implementation, IT Operations & Service Management and proven experience in project planning and executing projects, and managing project resources and taking ownership on timely delivery of products in every sprint.
  • Knowledgeable about Software Development Life Cycle (SDLC) for the projects using Agile, RUP, Lean, Waterfall, and Scrum methodology.
  • Solid understanding of agile (scrum) project management and lean concepts to apply in real time projects. Team-oriented mindset with acute problem solving and leadership skills. Strong ability to develop and implement innovative and creative ideas.
  • Strong experience in functional and technical testing for applications based on JAVA, Web services, OBIEE and Tableau.
  • Expert in Advanced Excel and its features like Pivot Tables, Charts, Functions, Scenarios, Excel/VBA and MS Access. Implemented, developed, and supported various applications.
  • Proven experience using test management and defect tracking systems such as Jira, QC and QTP.
  • Proven experience in performing Data Retrieval, Data validation/Mining, Data integrity, Data Quality checking, metadata before delivering data to operations, Business, Financial analyst.
  • Expertise in preparing different types of documents, such as, User Requirements Document, Business Required Documents, Test Case Scenarios & Test Plan documents.
  • Master MS-Visio user to document business process flows enabling visualized business requirements analysis and improvement (AS-IS, TO-BE, Business Flowchart, Data Flow Diagram).
  • Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
  • Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.

TECHNICAL SKILLS

BI Tools: Tableau 10.X/9.X/8.X ( Desktop, Server, Reader),OBIEE 10G/11G/12C

ETL Tools: ODI 11G, ODI 12C, Informatica

Front End Tools: Microsoft Project, Microsoft Office, MS Visio

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

RDBMS: Teradata, Oracle, SQL Server, MS Access.

Scripting Languages: SQL, HTML, R Programming, PL/SQL, SAS, Python, XML, JAVA

Operating systems: Windows 7/XP, Windows Server 2012/2008, UNIX/Linux.

Methodologies: Agile, Water fall

Project Management Tools: JIRA, Rally

Testing Tools: Quality Center, QTP, ALM, HP - ALM, Selenium, DevOps

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Sr. Business Analyst/Data Analyst

Responsibilities:

  • Worked for Network Analytics and Reporting (NAR) Team supporting analytics and reporting requirements from different domains of the business. Helped various teams in data integrity and data management, and accordingly defined and controlled reporting of Key Performance Indicators.
  • Extensively involved in requirement analysis, design, implementations, upgrades, enhancements and customizations of different modules of ITSM suite.
  • Worked with different teams (Engineering, Customer Reps and IT) within Confidential to gather the information on business flow, data and data source of Customers, OLT and ONT device metrics, and build analytics out of the consolidated data to minimize FIOS Dispatches that minimize expenses and increase efficiency.
  • Worked with ITSM tool implementation team to ensure that the proposed processes can be orchestrated by the ITSM tool effectively & efficiently.
  • Participated in process designing sessions and documented ITIL process flows for various modules like Incident, Change, Configuration, Problem and Service Catalog.
  • Conducted effective JAD sessions, interviews and surveys with the clients, project stakeholders, users, SME’s, development and testing team to better understand the requirements, functionalities and Scope of the product and accordingly created user stories on JIRA and assigned to the sprints based on the priority.
  • Involved in end to end functional and technical testing. Phases of testing like Smoke, Functional, User interface, System testing, Regression and Performance testing in various builds of the application.
  • Conducted Use-Case reviews and identified Gaps, leading to enhancements in the same.
  • Coordinated with respective team members to resolve any issues or defects. Retested the fixed defects assigned to me and closed after the review.
  • Worked with ETL team on design, development, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation.
  • Gather and report on data from various systems to facilitate and/or validate testing and production results.
  • Work with user groups to provide training, resolve questions, and understand user needs throughout testing and production cycles.
  • Configured and deployed SharePointintranet solution for corporate documents, client management, issue management and task management.
  • Created templates for Control Plan, Change Request strategy, Change Request Form, Project Charter, and Process Control Log to be used for internalbusinesspractices.
  • Explain business intelligence technology to the Operations team and match the reporting needs to the OBIEE tool
  • Identified the key facts and dimensions necessary to support the business requirements to develop the logical dimensional models.
  • Configured OBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
  • Created User stories using JIRA after having sessions with the SME’S and then discuss those requirements with the IT team.
  • Used and developed SQL queries to acquire or modify data from SQL database and access database.
  • Documentation of various deliverables content (Use stories, Business Requirement Document, Project Status Update Report etc.).
  • Conducted daily scrum stand up, sprint planning, product backlog, sprint review and spring retrospective meetings.
  • Worked on design and development of ODI mappings, workflows to load data into staging area, data warehouse and data marts in SQL Server and Oracle.
  • Performance Tuning of Dashboards/Reports and made required changes to repository (Aggregate Navigation).
  • Worked with Product Owner to Prioritize user stories based on the requirements gathered from business, validated those user stories and translated those to development team.

Confidential, Austin, Texas

Sr. Contract Business Analyst

Responsibilities:

  • Participated in the discovery sessions with client and vendors to create the design and mapping documents and submit the same for sign off.
  • Tabulated and assessed current and potential change management issues.
  • Defined best practices for Tableau report development. Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Developed and maintained key performance metrics on the procurement team. These metrics include aging requisitions, aging invoices, buyer spends, supplier spends, contract spends vs non- contract spends, etc.
  • Created Interfaces to load data from Oracle tables, Flat files, CSV files and xml files into Dimensions and Fact Tables
  • Designed, Debugged and optimized the OBIEE/Siebel Analytics RPD / Dashboards / Workflows.
  • Developed custom reports/Ad-hoc queries using Oracle BI Answers and Filters.
  • Acquired data model experience in star schema design, fact and dimensional tables.
  • Responsible for documenting ODI Installation and Configuration process, Design and Technical documentation for the developed ETL processes.
  • Created Custom Hierarchies to meet the Business requirement in Tableau.
  • Configured Captiva processes to handle fax and scan documents.
  • Designed and developed interactive Tableau/ OBIEE dashboards and reports that portray business intelligence
  • Designed, debugged and optimized theOBIEERPD / Dashboards / Reports.
  • Troubleshooting, resolving and escalating Data related issues and validating Data to improve Data quality.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
  • Developed effective and interactive Dashboards using Parameters and Actions.
  • Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
  • Collaborated with support and development teams to create and author "Production Readiness" process and documentation decreasing implementation issues / errors, reducing application and system downtime, and increasing resolution capability.
  • Created budgeting dashboard in Tableau to track departmental budgets. Created new tables to reformat and pivot the data for better visualizations.
  • Designed and developed shell scripts as part of the ETL process, automate the process of loading, pulling the Data.
  • Used SQL queries at the custom SQL level to pull the data in Tableau desktop and validated the results in Tableau by running SQL queries in Teradata SQL Assistant
  • Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases) and modelled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
  • Reviewed requirements, technical specifications, test plans, test summary and testing deliverables provided by the Testing team.
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes, performed performance tuning of the dashboard and created Tableau functional design document.
  • Involved in publishing of various kinds of live, interactive data visualizations dashboards, reports and workbooks fromTableauDesktop.

Confidential

Business Analyst

Responsibilities:

  • Worked with the various department managers/supervisors as well individual contributors in the department who oversee process and transactions in order to obtain a firm understanding of roles, responsibilities, transaction flows, approval points, etc.
  • Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
  • Provided customer feedback analysis, operational monitoring, and troubleshooting and error resolution to prevent inaccuracies, reduce process latency and drive process excellence.
  • Provided performance reporting and analysis along with auditing all the financial reports to senior management.
  • Demonstrated the role of a liaison and participated in defining technology solutions to solve complex, multidisciplinary business problems with long-term implications.
  • Recommended technology solutions to improve business decision-making with a focus on the core systems, technology strategies and standards.
  • Facilitated group meetings such as workshops and JAD sessions to work with end-users to define and execute test scenarios and ensure appropriate end user training.
  • Created mid to complex Reports (Oracle data sources) with one or more of the following features to support statistical and operational business needs, Grouping, Sorting, Drill-down Dynamic Parameter prompts, Sub reports or Crosstab summaries
  • Developed Drill down Reports, Linked Reports, sub reports and Parameterized Reports
  • Created formulas and/or used statistical or financial functions for reports as needed.
  • Used SQL stored procedures, created alias data tables as required in improving report performance.
  • Developed financial analysis reports and presentations by applying acquired financial principles.
  • Supported the accounting department during monthly closings.
  • Facilitated month-end close processes, invoicing and account reconciliations.
  • Created monthly PowerPoint presentations illustrating business performance and goals.

Confidential

Associate Analyst

Responsibilities:

  • Completed internship with the organization to help launch a new product in the market.
  • Demonstrated the core features and benefits to the potential clients in the target market.
  • Involved in creation and reviewing of Functional Specifications and created a Functional Requirement Document.
  • Met with client groups to determine requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures and create a Business requirement Document.

We'd love your feedback!