PROFESSIONAL SUMMARY:

• Business Analyst professional with 5+years of experience in financial management, IT Agile project and SQL data analysis.
• Excellent command in verbal and written communication including PowerPoint presentation, perform requirement analysis sessions
• Experience in Business IT Systems, business process and project management.
• Trained on Software Development Lifecycle(SDLC) - Waterfall/Agile Methodologies, requirement gatherings techniques, Microsoft/Oracle SQL Data Analysis
• 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.
• Financial assets, portfolio and risk analysis
• Prepared and maintained MS Excel Database reports and related communications.
• Demonstrated facilitation skills that include workgroup leadership and/or problem resolution across multiple groups.
• Ability to manage multiple priorities, work independently and meet deadlines.
• Utilize computerized office software programs Microsoft Access, Excel , and Word, Microsoft Project) to facilitate weekly business performance reports.
• Recognize gaps between current situation and desired outcome AS is To be process and utilize appropriate resources to obtain information, document options, and deliver the appropriate recommendations
• Analyze data, drive to root cause issue, identify trends, problem solve, and provide key recommendations based on analysis
• Resolve complex business problems based in products and services, operational processes, or technical solutions
• Navigate matrixed organization to engage appropriate internal and external partners ensuring successful analysis, risk identification, option determination and tactical execution
• Manage issues, risks, project work and deliverables
• Effectively engage and partner with cross-functional teams to create and deliver solution

TECHNICAL SKILLS:

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

Requirement analysis: Use Case, SWOT analysis, BRD, FRD, Rally, IBM Rational

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

Software tools: SharePoint, MS Project, Excel, PowerPoint, MS Visio, Skype for Business, Oracle SQL, Tableau 9.1 Load Runner, JIRA

PROFESSIONAL EXPERIENCE:

Confidential -Dallas, TX

Enterprise Business Analyst

Responsibilities:

• Works with a cross-functional team in identifying and prioritizing short-term projects using a Lean Six Sigma approach that included kaizen events.
• In just five months, nine quick-fix projects were completed for a savings of $220,000
• Supports project and Portfolio Management Office ( PMO ) functions
• Assists in portfolio/project delivery through the full life cycle ( SDLC )
• Works with teams (including IT, Business, Marketing, and Capacity Planning)
• Gather/documents business requirements from business users and subject matter experts SMEs
• Creates MS PowerPoint and creating customized presentations that are clear and easily understood by the audience create reporting matrices, system update requirements/data validation
• Perform business process workflow design in conjunction with operations teams;
• Manage scope and requirements throughout the project lifecycle;
• A team player who works well with technical and non-technical resources;
• Lead requirements validation and traceability analysis, SharePoint collaboration
• Analyzes input and data using MS Excel, Visio and Oracle SQL applications
• Advanced skill on MS Excel 2013/16 (VLOOKUP, Macros, Formulas, Tables, Graphs)

Confidential -Dallas, TX

Financial Analyst

Responsibilities:

• Knowledge and implementation of the Software Development Life Cycle(SDLC)
• Eliciting, documenting, prioritizing business requirement using Rally software
• Prepared Business Requirement Document(BRD) functional specification document (FRD), Traceability matrix to ensure efficient software development
• Provide support for ad-hoc requests and small projects from Customer Experience team and Business Analytics Manager
• Gained expertise in Use cases, user stories, story points, UML Diagrams
• Analyzes input and data using MS Excel, Access and Oracle SQL applications
• Advanced skill on MS Excel VLOOKUP, Macros, Formulas, Tables, Graphs
• Reporting and data tools for supported Master Data Management(MDM)
• Financial assets, portfolio, risk and Financial Trend analysis
• Utilize computerized office software programs (Microsoft Visio, Excel and Project)
• Used SharePoint applications and provided the inputs/feedback to the project team, software product owners for design changes.
• Creates Excel Charts, PowerPoint slides, Tableau 9.1 BI tool for better data visualization and business analytics.

Confidential - North Texas

Business Data Analyst

Responsibilities:

• Import client data into MSSQL and/or MS Access databases for analysis.
• Gained knowledge on financial statements, cost-benefit analysis, Case development
• Performed requirement gathering session in analysis of data.
• Creates, modifies and troubleshoots SQL Queries, stored procedures and jobs.
• Converts, manipulates and scrubs large volumes of data in various formats, using T-SQL, MS Excel and/or Access.
• Perform testing, test scenarios, user stories and use cases, UML diagrams
• Proficient in relevant computer applications such as MS Excel, MS Access and SQL
• Strong communication skills - knowledge of grammar, spelling and punctuation
• Creates Excel Charts and PowerPoint presentation for better data visualization

Confidential, Irving-TX

Business Analyst

Responsibilities:

• Monitors and maintained current inventory levels; processed purchasing orders as required; tracked orders and investigated problems
• Create and maintain CX dashboards against key KPIs,
• Coordinate communications and activities involving cross-functional stakeholders to ensure data is received in a timely manner/
• Performed VBA functions tool used to create programs to be run in Excel. conversion of MS Access based reports to MSSQL Reporting
• Generation of monthly MS Excel reports, tables, graphs and charts.
• Tracking of AR/AP functions and invoicing miscellaneous accounting functions
• Performed data cleansing, VLOOKUP’s and normalization functions