We provide IT Staff Augmentation Services!

Business Intelligence Engineer Resume

SUMMARY

  • 8+ years of Extensive experience in Business Intelligence Tools using SAP Business Objects, Tableau, Qlikview, BIG DATA, SAP HANA, IoT (Internet Of Things).
  • Worked on end - to-end implementation on Data warehouse development management (Data warehousing and Business Intelligence) and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models for query and analysis requirements
  • Strong Analytical skills and ability to gather and understand Complex data and translate Business Knowledge to Technical Data/Visualizations and vice versa.
  • BI Tools and Dashboards migration e.g.: COGNOS to SAP BO and SAP BO to Tableau POC
  • POC of Migration from Oracle Star schema to SAP HANA
  • With Strong Knowledge in all phases of Agile Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting.
  • Experience includes project planning, estimation, budgeting, resource finalization and technology planning.
  • Work with Third party vendors for relationships, support and resolving issues.
  • Experience in creating Metrics and Analytics like Customer Analytics, Health care Analytics, Financial Planning Analytics etc. and also create diverse Dashboards for better decision purpose.
  • Experience in creating Dashboards, Metrics, Rules, Alerts and Goals using various BI technologies for user analysis based on user requirements.
  • Create best practices for Enterprise DW architectures and Dashboards.
  • Involved in training internal business users and external vendors on creating ad-hoc reports.
  • ETL/ELT tools like SAP BO Data Services/Integrator, Informatica, Pentaho: Created ETL Mappings, jobs, Workflows, Data flows, Single and Multiple Source Consolidation..
  • Experience in Integration of various data sources like SQL Server 2012/2008/2005/2000 , SAP ECC, Oracle 10g/9i, MS Access, DB2 UDB.
  • Proficient in working on development environment in different RDBMS (Oracle, SQL Server, DB2, etc.) and strong troubleshooting skills
  • Expertise in SQL, PL/SQL, My SQL, Stored Procedures, Functions, Cursors, Packages, Views, Indexes.
  • Hiring of Leads, Developers and also Mentor fellow team members and users

TECHNICAL SKILLS

ETL Tools: SAP Business Objects Data Services, Pentaho, Informatica

OLAP & Reporting Tools: Business Objects XI 4.x/3.1/3.0/R2/6.5 (Designer, CMC, Dashboard manager, Web Intelligence), Xcelsius 2008,Tableau, Cognos, Qlikview, Oracle Business Intelligence

Modeling: Star schema, Rapid Miner, Snow-Flaking, Normalization, Hadoop

Databases: SAP ERP, MSSQL Server 2012/2008/2005/2000 , Oracle 12c/11g/10g, SAP HANA, DB2 UDB, MS Access

Languages: COBOL, RPG, C, Perl, VB scripts

Web Technologies: HTML, XML

Others: MS Office(Excel, Access, Project, Word,PowerPoint), IMS, CICS, Flash

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Engineer

Responsibilities:

  • Partnered with business owners, project manager, dev manager to proactively understand ongoing projects (business and technical changes) and identify project impacts on BI
  • Build dashboards for full visibility into operational performance, track KPIs and strategic scorecards, and understand how your organization stacks up against industry benchmarks.
  • Analyzed business processes ensuring best practices were captured and implemented consistently.
  • SAP BO dashboards to Tableau Migration POC
  • Translate complex Business requirements to Technical requirements
  • Work with developers in architecting the solutions and provide sample models / Queries or POC solutions for faster development
  • Develop complex SQL queries
  • POC and Knowledge of Data science and Predictive Analytics using Rapid miner
  • Create and validate Linear and Logistic regression models
  • Define solutions & frameworks with BI or Data Visualization tools
  • Provide Mobile Dashboard Solutions for Executives and Sales Reps to empower them with the latest information available at their fingertips.
  • Provide advanced data discovery capabilities help business users identify and understand these relationships and leverage them for a strategic advantage.
  • Holistic dashboards to see trends at a high level with a real time view of selected metrics and simply drill down to uncover the underlying data for root cause analysis.
  • Provide Self Service BI to enable business users to access the specific data desired, quickly and easily with dependency on Data analysts or IT
  • Understand the metrics (Real-time or Batch updates) and provide appropriate Information Lifecycle management.
  • Incorporate additional data sources into the BI application which ensures a single basis of truth and eliminates data synchronization issues.
  • Establish governance process to align business objectives and department initiatives.

Confidential

Business Intelligence & Analytics Practice

Responsibilities:

  • Tasked to establish a complete solution and delivery organization manage the development and delivery of an Enterprise Data Warehouse and Business Intelligence Center of Excellence (COE)
  • Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.
  • Defined data requirements and report layouts for the business to review. Created testing plans and scripts based on requirements.
  • SAP HANA - Created Attribute Views, Analytic Views and Calculation Views to model data.
  • Connect to SAP HANA Modeling Views in SAP Lumira
  • Experience in leading centre of excellence / practice for Business Intelligence tools like SAP BO, Tableau, Pentaho Kettle, Cognos, HANA etc.
  • Hiring and Mentoring of Architects, Leads, members and users
  • Worked with the reporting developer to gathered, created and provided tests plan for 28 reports for four departments in three months.
  • Business Development, Pre-sales and Sales support to targeted Accounts in US/Europe.
  • Targeting SAP BI/BO customers to add more value to their existing system
  • Architecting BI & Dashboards Agile reporting solutions using leading BI tools - SAP Business Objects, Xcelsius, Pentaho, Tableau, Qlikview and Cognos Solutions
  • Contribute to marketing activities and development of new service offerings in BI, Analytics, Big Data and IoT (Internet Of Things).
  • Create best practices for Enterprise DW architectures, OLAP and Data Marts
  • Build Internal and Customer centric BI products - Like ETL testing framework, Sentiment analysis products
  • Define solutions & frameworks with BI or Data Visualization tools
  • Built team of successful developers, leads, and data /quality analysts for ETL, Data Warehouse, Big Data, Analytics, and Business Intelligence.
  • Work with other departments and/or peers to provide comprehensive BI solutions across the departments

Confidential, Dallas, TX

Senior Business Intelligence Architect

Responsibilities:

  • Gathered functional requirements from CEO, CIO, CFO and Senior Vice Presidents (Marketing/Sales/Production/Procurement/Accounting) for DWBI platform, Data Engineering, Reports and Dashboards
  • Design Data warehouse/Data Mart tables (Dimension and Fact). Data Modeling to build Scalable data models to accommodate future data growth
  • Identify Data Source tables from SAP and pull data to Extended Rapid Mart database tables.
  • Build ETL Mappings, Data flows and Workflows using BO Data Services ETL tool
  • Mentoring Team members and Users on creating Business Objects reports and help them in solving complex issues
  • Daily Monitoring of ETL jobs and Report Refresh Jobs and fix if any issues found
  • Create and Modify Business Objects Universes
  • Resolve various issues like Loops, Chasm and Fan Traps
  • Involved in building, Testing and Tuning Data warehouse Tables, Business Intelligence Reports
  • Created queries to extract data from database for multi-dimensional analysis using Slice & Dice, Master Detail and Drill up/down/by/through functionality.
  • Evaluation of New Software releases, service and fix packs
  • Created and Maintained 80+ Webi reports with Drill capabilities and Alerts
  • Spearheaded and Architected 10 Xcelsius dashboards using Live office
  • Used multi value components like line, bar charts, stacked column charts and combination charts, and single value components like gauge, slider and progress bars in the development of the Dashboards.
  • Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.
  • Used alerts to highlight critical data based on business conditions.
  • Created templates to support corporation style and color scheme.
  • Develop Consolidation Methodology for Single and Multiple Source Dimensions
  • End to End Testing of Data warehouse and BI.
  • Expertise in full Cycle of BI Implementation (From Data Source to Analytics)

Hire Now