Business Analyst Power Bi

Cynthia Morales

Dickinson, TX ***** 281-***-****

*********@*****.*** www.linkedin.com/in/cynthia-morales-387752342/

Business Analyst

Analyzing Data and Processes and Turning into Actionable Business Recommendations

High analytical skill set to interpret and analyze extensive data collected. Develop insightful reports, dashboards, and visualizations to support data-driven decision making. Identify patterns, correlations, and trends and provide leadership with actionable insights for short- and long-term strategic planning. Proactively detect and address potential inefficiencies, bottlenecks, and risks, ensuring sustainable and continuous organizational growth.

Data Visualization Tools: Power BI

Software Development Methodologies (Agile, Scrum)

Communication & Time-Management

Technical Skills

Languages: VB.NET, VB, VBA, SQL, PL / SQL, HTML, DHTML, COM, DCOM, ActiveX

Platforms: Windows 98 / NT / 200x / XP

Web Tech: ASP.NET, VBScript, Visual InterDev, SharePoint

Databases: MS SQL Server 7.0 / 6.5 / 200x, MS Access 200x / 97

Data Access: ODBC, ADO, DAO, OLEDB, JSON

Packages: Microsoft Office Suite (Excel, Word, PowerPoint), Microsoft Enterprise Project Management, MS Analysis Services / Reporting Services / Integration Services

Software: Cognos - Impromptu, Transformer, Powerplay, and Impromptu Web Reports; IBM TM1

Professional Experience

ASHLAND INC., Texas City, TX

Business Analyst, Business Intelligence Team 2001 - 2024

Provided solutions to complex business problems by modifying existing products, identifying 3rd-party products or developing products based on Ashland’s standardized tools list. Architected MS SQL Server Fusion DB created test plans for audit purposes; updated, edited, and created specifications.

Functioned as Scrum Master, ensuring continuous improvement and timely projects / task / assignments.

Managed staff of 5 associates, ensuring productivity.

Managed systems, including:

oMicrosoft Power BI: Provided ad-hoc and predefined reporting to various teams of the organization.

oIBM Planning Analytics, TM1, & Powerplay: Maintained, administered, and troubleshot issues for users. Provided reports for analytical and budgeting / forecasting needs.

oSales Planning & Budgeting Tool (SPBT): Developed, enhanced, maintained, and administered application for Finance and Sales Teams. Provided estimation of future year’s sales and budget.

oScorecard: Provided “Customer Scorecard” performance data on an as needed basis to all users. Calculated overall Performance Score by combining various metrics from existing data sources (Shipping Performance Report, Customer Complaint System, and the ISP DB Gateway).

oMS EPM: Aligned tasks / assignments and people with business priorities to effectively manage work from ad-hoc to complex projects.

oCognos Finance: Provided technical support for application that consolidated multiple diverse ledgers with thousands of operating units and accounts into a common chart-of-accounts structure.

Developed automated and web reports using several reporting tools, including MS Excel automated spreadsheet, MS Reporting Services, MS Power BI, and Cognos Powerplay Reports for users throughout the organization.

PRUDENTIAL ASSET MANAGEMENT COMPANY, Florham Park, NJ

Business Analyst, Annuity Information Management

Produced duration analysis to investment portfolio managers for asset / liability risk management purposes. Generated various reports by analyzing data from Annuity Information Management Systems (AIMS). Created SAS reports for special projects.

Calculated related risk of death benefit embedded in variable annuities by monitoring market performance and risk exposure.

Education

Bachelor of Science (BS), Finance, W. Paul Stillman School of Business,

Seton Hall University, South Orange, NJ

Coursework in Electrical Engineering, Stevens Institute of Technology, Hoboken, NJ

Contact this candidate