SUMMARY:

• Analyst professional with 10 years of experience in Data Analytics, RDBMS and Business Intelligence
• Performed data analysis using multiple data sources; using Excel, Oracle and SQL Server
• Trained on Software Development Lifecycle(SDLC) - Waterfall/Agile Methodologies, IT system analysis
• Responsible for defining, analyzing and documenting business and functional requirement-BRD,FRD
• Elicit business needs and translate those needs into requirements
• Documents and analyzed functional business requirement, creates specifications
• Coordinate ongoing user support for ad hoc questions, inquiries, and service requests.
• Reporting and data tools for supported business area use and for trend analysis.
• Prepared and maintained MS Excel data reports and related communications.
• Work with Application SMEs to document behavioral and passive data models using UML
• Proficient in Tableau 10.3 creating dashboards, graphs for data visualization
• Effectively engage and partner with cross-functional teams to create and deliver solution
• Sound communication skills, team/stakeholders meetings, MS power point presentation
• Professional in business process and data management helps better business decision making

IT/SOFTWARE TOOLS:

Process Management: SDLC-Waterfall, Agile/ Scrum, RUP, Six Sigma, Kaizen, Kanban, TQM

Operating System: Windows 7, 8. 0, 8. 1, 10 MAC OS X, Linux

Software tools: SharePoint, Excel, PowerPoint, MS Visio, Skype for Business, SQL, Tableau Desktop 10.1, JIRA, QlickView, Alteryx, G-Suite, Crystal Report, Service Now, IBM DB2,Lucid Chart

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Lead Business Data Analyst

Responsibilities:

• Elicits, documents IT requirements in SDLC-Waterfall/Agile project environment
• Drives data analytics related to healthcare, drives quantitative and qualitative data analysis
• Creates Relationships, actions, data blending, filters, parameters, fields in Tableau desktop
• Prepares functional and nonfunctional requirements for IT development integration projects
• Utilizes knowledge of Oracle SQL , checks and validates Data Quality in Oracle RDBMS
• Meets with internal and external clients to map out “As-Is” and “To-Be” process flows
• Utilizes Jira for project documentation, user stories, testing, status and release sign-off.
• Process IT helpdesk tickets and Change management using Service Now experience posting and reviewing with customers helpful documentation for SME,GAP, Root cause analysis
• Works in Office 365 cloud based SaaS software suites-SharePoint, Visio, Skype for business
• Utilizes skill on advanced MS Excel 2013/16 (VLOOKUP, pivot tables, dashboards, Macros)
• Reviews of test cases, perform UAT testing, utilizes Confluence for testing, assists Bug fixes
• Perform data analysis with Tableau BI/Alteryx designer 2018.1-creates real time dashboard
• Provide for IT personnel and application system users to improve skills and maintain appropriate knowledge

Confidential, Dallas, TX

Business Data Analyst

Responsibilities:

• Elicits, documents and validates of business requirements in Waterfall/Agile project environment
• Facilitated improved customer experience (CX) using cloud based Oracle CRM software solutions
• Supports Confidential mortgage division with release management, agile planning using JIRA
• Supports agile project product owner/scrum team in Kanban framework adoption
• Meets with internal and external clients to map out “As-Is” and “To-Be” process flows in order to create thorough business requirement documentation.
• Ensures Service Now tickets are being process timely (work with support personnel to define SLAs and monitor queues against the SLAs using CMDB files
• Created user stories, assists in managing product backlogs, works with Product owner/SMEs writes SQL queries, dashboards, KPI matrices graphs for data visualization/reporting
• Utilized Tableau BI 10.1/Alteryx designer -creates real time dashboard, data analytics
• Reviewed and analyzes a variety of forms, reports using Advanced MS Excel and MS SharePoint
• Documented business requirements from business users and subject matter experts SMEs
• Created Process flow chart and created customized presentations using Visio and PowerPoint
• Performs live connections, Bubble chart, drill down analysis using Tableau reporting
• Performs PMO coordination and works across the organizations/cross functional teams
• Perform QA Testing-UAT and Regression using HP ALM and Microsoft TFS requirements validation and traceability analysis, writes User stories in IBM Rally
• Advanced skill on MS Excel 2013/16 (VLOOKUP, Macros, Formulas, Tables, Graphs)

Confidential, Irving, TX

Business Analyst

Responsibilities:

• Interfacing with E-Commerce business stakeholders and product management where appropriate,
• Facilitates regular project meetings to ensure that all requirements are satisfied throughout the delivery process
• Supports functional and nonfunctional requirements for API and micro services development and/or integration projects.
• Supports with correct data analysis and necessary reports using MS Excel spreadsheets.
• Provide support for ad-hoc requests and small projects from Customer Experience team and Business Analytics to Auto finance department
• Keep up-to-date documentation of processes, data sources, tables and fields
• Gained knowledge on accounts payable and receivables,
• Prepared Business Requirement Document (BRD) functional specification document (FRD), Traceability matrix to ensure efficient software development
• Gained expertise in Use cases, user stories, story points, Epics, UML Diagrams
• Analyzes data using MS Excel, SQL for Alteryx/Tableau BI reports, data visualization
• Advanced skill on MS Excel-Pivot, VLOOKUP, Macros, Formulas, Tables, Graphs
• Creates, modifies and troubleshoots SQL Queries, stored procedures and jobs. uses JIRA/SharePoint for team communication and collaboration
• Perform QA testing, test scenarios, user stories and use cases, UML diagrams