Business Data Analyst Resume
3.00/5 (Submit Your Rating)
SUMMARY
- Proactive analyst with hands on experience in Data analytics, Business analysis, IT project management, Credit card payment processes & systems.
TECHNICAL SKILLS
Office Business Applications: MS Excel, MS Visio, JIRA, SharePoint, MS Project, MS Word, MS PowerPoint
Database Knowledge: SQL Server 2008, MYSQL
Software Tools: SQL server management studio, SAP Crystal Report, Tableau, IBM SPSS Modeler, Stat tools 6, IBM Bluemix, Google Analytics
PROFESSIONAL EXPERIENCE
Confidential
Business Data AnalystResponsibilities:
- Experienced in working with large financial clients in various project areas like technology enhancement, business cases, application migration, project management, data analysis and forecasting
- Consolidated & manipulated the transaction data to discover meaning full patterns, understand payment frequency & types, buffer calculations, global footprints etc.
- Performed data blending, data analysis and designed data templates to model current liquidity usage and identify scope of improvement in areas of operations, regulation, liquidity risk & management
- Handled PMO tasks and published data insights, tracked dependencies, managed expectations of key stakeholders and kept team accountable of outstanding action items
- Recommended immediate solutions and long term plan resulting in enhanced operational capability & high dollar value savings
Confidential
PMO Analyst
Responsibilities:
- Managed redesign of current research pdf report into digital format (HTML5) optimized for both web and mobile consumption; delivering content tracking capabilities across all platforms.
- Gathered user experience on various report templates from buy side and sell side stakeholders across US, EMEA and APAC
- Consolidated the requirements for the digital team to design wireframes and design directions
- Served as liaison between multiple stakeholders, internal to include, Business Consulting, IT, Design, Operations, Client Services and external parties such as vendors and third party service providers
- Collaborated with multiple teams globally to determine project scope and release schedules; track project status; identify blockers, risks and issues; facilitate meetings and develop project documentation & templates
Confidential
Business Analyst
Responsibilities:
- Developed a framework on joint assessment of Confidential ’s client issues related to operating model, governance, data and risk processes to provide strategic recommendations for improvement, design a program roadmap as well as recommend appropriate Confidential products & services for the desired future state
- Designed materials for client workshops to assess current client risk levels and provide future state recommendation based on the currently identified problem areas to mitigate and manage risk
- Structured internal benchmarks to observe clients standing against its peers the industry as well as understanding the framework’s maturity levels
Confidential
Business Analyst
Responsibilities:
- Worked on the migration of financial management application to a more robust and efficient system in SAP
- Reported to the Director of Portfolio Management and assisted in PMO activities and portfolio analysis
- Created requirement specification matrix by conducting stakeholder interviews and product analysis via workshops, questionnaires and/or other methods.
- Assisted client with gathering reports, interfaces, conversions, enhancements, forms & workflow (RICEFW) data documents provided by the vendor to ensure accuracy of the vendor RICEFW tracker and the documents available on SharePoint
- Collaborated with multiple business owners across the US, UK, EMEA & APAC for gathering requirements and coordinating publication, review and sign - off on major project management deliverables
- Performed data analysis to understand the gaps between the actual implemented functionality and the outstanding requirements
- Reviewed, updated and mapped all test cases to the original baseline
- Ensured project plans deliver as expected and maintained key project documentation on SharePoint
- Developed resource matrix to capture the resource details & time allocated for the project
- Responsible for consolidation of meetings and project documentation, timelines, organizational chart, workshop presentations and status reports
Confidential
Data Analyst Intern
Responsibilities:
- Experienced in managing, analyzing, synthesizing, transforming and reconciling large volumes of data to produce meaningful reports, dashboards, presentation and recommendations for clients as well as internal users
- Resolved the issues arising in the ETL process that enables the loading & extraction of data from client server’s on to Argus’ end to assure that all aspects of a project are in compliance with the business requirements
- Performed data analysis to find anomalies & ensure data integrity before consolidating the data for client reporting
- Validated the transaction data using SQL queries, analyzed the trends and studied the correlations to find insights of consumer transaction patterns, credit/debit spending and credibility
- Automated the existing data validation process so as expedite the further reporting & visualization process
- Collaborated with internal stakeholders to manage data logistics including data transfers, understanding data structures, business rules, etc. to enable project execution
- Presented reports to internal stakeholders and effectively communicated the steps taken to create the output/insights
- Worked on a client project in improvising their ad based marketing based on consumer transaction data patterns
- Involved in report generation, test execution and issue resolution using efficient SQL queries for teams & clients
- Documented the data process flow & created diagrams in MS-Visio for onboarding new clients and existing processes
