Bi & Data Analyst Resume
4.00/5 (Submit Your Rating)
SUMMARY
- Experienced Business Intelligence (BI) analyst who consistently delivers aligned solutions to meet enterprise objectives.
- 9+ years in matrix environments for user requirements gathering, business analysis and collaborative development with a passion for key information deployment to all levels of the team, unit or organization.
- Successful agent for improved access to and understanding of analytics to support operational and strategic decision - making.
- Keen insights on visualizing trends and quantifying forecast parameters, regardless of industry.
AREAS OF EXPERTISE
- S AS 9.0 Certified Professional
- Business process analysis
- Scorecard/ KPI development
- Project/Program management
- Quantitative and qualitative data analytic methods
- MS Visual C# + Cosmos
- Tableau Desktop (8.1)
- MS Office + PowerBI +SharePoint
- Data modeling/Visualization
- Relational database architecture
- Reporting requirements consulting
- Web analytics
- SQL +OLAP reporting
- SAS 9.0(11g)
- IBM Cognos TMI
PROFESSIONAL EXPERIENCE
Confidential
BI & Data Analyst
Responsibilities:
- Develop and maintain management reporting of KPI and Dashboard; trace variance & trends across channel, medium and markets and conduct deep-dive analysis to find root reasons of key metrics change.
- Conduct Data mining on big data platform or OLAP databases; translate business requests into data pull queries and provide Ad-hoc support for data-driven decision making process.
- Collaborate with cross-functional teams to streamline reporting and data sourcing for maximum efficiency; Perform all quality checks on data for each report before delivering to owners.
- Support ROB review process and annual business planning process with data models, assumptions, and analysis (e.g. Business plan, Metric definition, Scorecard target model, etc.).
Sr. Business/Financial Analyst
Confidential - Hartford, CT
Responsibilities:
- Led the design and delivery of business intelligence and reporting solutions for stakeholders, and conduct actionable business insights to improve products performance.
- Built robust models to support senior managers’ decision-making on budgeting, forecasting process and pricing strategy; delivered accurate and impactful analysis based on solid understanding of data sources and business needs. (my cost predictive model helped marketing team win the $34M contract of Seven/Eleven in 2010)
- Partner with the Accounting/HR department to develop and improve forecasting processes to more closely align with actual spending behaviors
- Acted as a liaison between IT Department, CEO, and marketing Department; provided business intelligence support with insightful recommendation. (Duties include: wat-if scenario analysis, workflow optimization, project management, modeling, performance scorecard analysis, etc.).
Project Manager/Business Analyst
Confidential
Responsibilities:
- Collaborated with cross-functional teams for collecting business requirements of the BI requests/changes; conducted process or data analyses for ensuring data accuracy and providing a more business value added BI.
- Presided database design of projects such as Advanced Loan system, customer information system and online banking system; duties included conceptual database design, database documentation preparation, data storage and database management
- Cooperated with IT department to optimize queries in on-line banking system which can provide timely and relevant responses to routine and ad-hoc report and analytical requests. (Improved queries efficiency by 17%).
- Developed a new cash management project to help important clients ( Confidential and Confidential ) to improve operations through cash concentrations, cost & inventory monitoring, accurate account reconcilements, balance reporting etc.(Increased deposit by $820M).
