Business Intelligence & Data Analyst Resume
2.00/5 (Submit Your Rating)
San Antonio, TexaS
PROFESSIONAL SUMMARY:
- Business Intelligence and Data Consultant with 7 years 3 months of diversified experience in Data visualization, Reporting and Data warehousing in Banking and Insurance sector.
- Collaborate with business and enterprise strategic teams for designing and development of visually engaging infographic BI solutions using SAP Business Objects and Tableau to drive more insights on business operations.
- Extensive utilization of Data Blend across multiple data sources to extract maximum business insights.
- Design complex dashboard with minimal calculated field by utilizing level of detail (LoD) expressions.
- Extensive experience in delivering projects in agile methodology.
- Perform deep dive analysis on complex data sets to project business operations on ad - hoc basis for Senior Executives and Business Stakeholder.
- Expert understanding of Data Warehousing Design Methodology , Data Warehouse Concepts and exposure to Database design/architecture including OLAP - Online Analytical Processing.
- Implemented cohort view for deriving better business insights on customer attrition rate using Tableau.
- Lead the design and developmental efforts of multiple BI that conveys data driven actionable insights.
- Perform deep dive data analysis to derive insights and spearhead the development team to deliver BI Solutions.
- Fine tune reporting queries for better optimization of database resource.
- Leverage technology capabilities and standards while working with IT system owners to identify appropriate data sources and define required data transformation logic.
- Exposure to BI Dimensional Data modelling- Star Schema modelling and Snowflake modelling that supports individual business needs.
- Designed and developed complex SAP BO Universe and WebI Reports based on technical specification.
- Prepared technical documents and mapping documents for reporting requirements.
- Foresee the business problems that will arise as part of Datamart changes and provide suitable recommendations that address the issue without any delay in business operation
- Worked on automation reporting on daily executions covering business critical flows across all LOBs, channels and automation tools.
- Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements.
- Executed large scale Business Objects 3.0 to 4.0 migration project and Architecture -involved in all aspects of the migration including user and object migration, dependencies, maintenance and Technical support.
- Validation of Tableau dashboards and features from 10.4 to 10.5 version.
TECHNICAL EXPERTISE:
- SAP BI/BO Tableau 10.5.1 Agile Methodology
- Project Management RDBMS Robust BI Solutions
- Resource Management Performance Tuning Data Mining
- Technical Acumen SQL Project Lifecycle
PROFESSIONAL EXPERIENCE:
Confidential, San Antonio, Texas
Business Intelligence & Data Analyst
Responsibilities:
- Managed Property and Casualty IT framework to have centralized dashboard for project teams for Financials, Workforce and Incident details.
- Universe design and development (BO Universe Designer UDT and IDT), manage and develop Interactive web based reports (Web Intelligence), Dashboards (Xcelsius).
- Enabling real-time analytics to deliver new business processes and automated an agile framework for teams.
- Design and develop info-graphic BI solutions to convey business stories that captivates the stakeholders and executives.
- Develop BI solutions that are cost effective, sustainable and meets business requirement with minimal supervision.
- Develop complex KPI metrics using level of detail (LOD) expressions for minimal maintenance.
- Detailed documentation of Tableau BI solutions for transitioning to internal IT team
- Developed cohort analytical view of customer traffic pattern to USAA, which turned out to be a key factor in business decisions allowing the senior executives to find areas of improvement.
- Co-ordination of tasks and activities between Onsite and Offshore IT Team.
- Use industry standard analytical approaches and technologies to transform data into actionable business insights.
Confidential, San Antonio, Texas
Business Intelligence & Data Analyst
Responsibilities:
- Collaborate with business stakeholders and experience owners to understand business data and pain areas
- Coordinate with various business and data teams at enterprise level for building a centralized data store, which aids the Sr. Decision Science Analyst to deep dive and provide broader insights.
- Design and development of Tableau dashboard covering metrics from various sources.
- Utilization of incremental data extracts in Tableau server for best optimization of tableau data engine for processing large volume of customer data.
- Analyse existing tableau dashboards and provide recommendations and areas to improve the performance for faster access of dashboards to the business partners.
- Transition of Tableau Dashboards to enterprise IT team for post-production maintenance
- Proactively mine data and identify data irregularities caused by various teams due to sudden implementation of new strategy and propose suitable action plan for addressing the issue
Confidential, San Antonio, Texas
Business Intelligence Analyst - IT Reporting
Responsibilities:
- Understand and document the business for IT reporting applications.
- Worked extensively in developing and implementing report solutions on Business Objects 4.1, Web Intelligence and Business Objects Information Design Tool.
- Involved in the full project lifecycle covering planning, requirement gathering, design, implementation, testing, documentation, delivery, maintenance and Support.
- Experience in designing universe and migrating them to different environments using CMC
- Created context and utilized aggregate awareness for resolving loops and improving query performance.
- Extensively used Outline feature of SAP BOBJ 4.1 to apply advanced breaking concepts
- Work with various teams such as testing team, Release Management team, and teams from other applications to support their activities during integration phase.
- Monitor and proactively resolve, follow-up or escalate on all pending issues in the Business Analysis queue.
- Coordinated and performed other Project activities as required for software deployment, support projects, and quality assurance as required.
Confidential, Armonk, NY
Business Intelligence Analyst
Responsibilities:
- Understand and document the business for “BULK” application.
- Co-ordination of tasks and activities between offshore and Client.
- Requirement gathering from business users and follow up discussion meeting to address the business pain areas.
- Analyze the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.
- Analyzed the existing OLTP system and designed and managed universes based on the Business Requirements.
- Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
- Prepared project plan, design documents, functional requirement, and Quality Assurance test case.
- Modified universes, classes, objects, Prompts, Predefined conditions, by retrieving the data from data sources and defining the necessary connections.
- Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
- End to end application migration post rigorous system testing and user acceptance testing.
Confidential, Armonk, NY
Business Intelligence Developer
Responsibilities:
- Understand and document the business for Life and Health reporting applications.
- Co-ordination of tasks and activities between offshore and onsite IT Team.
- Data mapping from Application to BO Objects.
- Business Objects Web Intelligence reports and universe development.
- Business Objects Webi and Universe specification creation.
- Business Objects Reports and Universe maintenance.
- Application changes impact analysis on Reporting.
- Data analysis of applications data mart.
- Regression testing of applications while the database changes happens.
- Supervised the Business Objects reports and universes across environments using CMC.
- IT Testing for BO Reports and universe.
- User Incidents' support.
- Root cause analysis for the UAT and Production defects and impact analysis for new requirements.