Business Intelligence Engineer Resume
SUMMARY
- 8+ years of total experience in Information Technology Industry with expertise in Design, Development, Business Intelligence, Business Objects, Crystal Reports, Tableau and Data Warehouse applications.
- Extensive experience in Business Intelligence solutions using SAP Business Objects 4.1/4.2/4.0/XI R3/ R2/ 6.5/ 6.0/ 5.X (Designer, CMC, Web Intelligence, Desktop Intelligence, Import Wizard, Crystal Reports XI, Crystal Xcelsius, Live office).
- Extensive experience Designing and Developing Crystal Reports using Crystal Reports 8.5/9.0/10/11/16/ XI.
- Designed and developed Work books and interactive Tableau Dashboards to provide detailed and enhanced visualization of data using key features available as per the requirement of the users.
- Experience with Universe design, Web Intelligence, Desktop Intelligence, creating ad - hoc reports and archiving reports along with performing User acceptance testing and Data accuracy test.
- Experience in Installation and Configuration, creation of repositories and security domain with user groups and security implementation.
- Experience using Crystal Reports, Performance Manager, Crystal Xcelsius, Live Office, QaaWS and Web Service .
- Good experience in Data Warehousing technologies using Business Objects DataServices, Informatica Power Center 6.2/7.1/8.6/9.5 , IBM Infoshere/Ascential (Datastage 8.0.1, 7.5) Star Schema modeling, Snowflake Schema modeling.
- Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading
- Good Knowledge of Data warehouses and Business Data marts with Star Schemas and Snowflake Schemas.
- Thorough knowledge of different RDBMS like Oracle, SQL Server, DB2 and Sybase.
- Experience in eliciting client requirements through survey, facilitation of meetings directly with users.
- Good knowledge in writing Business requirement documents, Functional requirements, Use case documents and Software requirement documents.
- Extensive experience in tuning SQL queries and ETL processes.
- An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
TECHNICAL SKILLS
Languages: SQL, PL/SQL, C, HTML, DHTML, Java, JavaScript, VB.Net
Databases: Oracle 8i/9i/10g/11g/12c, SQL Server 2012/2008/2005/2000 , Sybase, IBM Informix, MS Access
Tools: SAP Business Objects 4.2/4.1/ 4.0/ XIR3/R 2/6.5/6.0/5.1 (Designer, WebI, DeskI, CMC, Dashboard Manager, Crystal Reports 8.5/9.0/10/11/16/ XI, InfoView, Launch Pad, Crystal Xcelsius, Live Office, Import Wizard), DB Visualizer, SSRS, Tableau Desktop 7.0/8.0/10.2/10.3.
ETL: Ab Initio, Informatica, Data services, Datastage, SSIS
Modelling Tools: ERWIN model mart
DW Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Design
Documentation Tools: MS WORD, MS EXCEL, MS POWERPOINT, MS ACCESS
PROFESSIONAL EXPERIENCE
Confidential
Business Intelligence Engineer
Responsibilities:
- Attended Project Startup meetings with customers and gathered requirements through documentation.
- Data Analysis for the IBM Cognos Reports to identify the source tables, data definitions and business rules.
- Worked on mapping and design documents for Universes and Web Intelligence Reports.
- Development and maintenance of clinical and financial universes using Information Design Tool.
- Transitioned IBM Cognos Reports and Dashboards to SAP Business Objects webi and Crystal Reports.
- Prepared Unit Test Cases and System Test Cases for both Universes and Reports and documented the test scripts.
- Reengineer the BI Solution and facilitate the implementation of the solution into production.
- Provided customer training for the new report solutions.
- BI Developer Production support for the finance universe and web intelligence reports.
- Provided development progress via meetings and weekly status report to the team.
Environment: SAP Business Objects 4.2,Information Design Tool, SAP Crystal Reports, SQL Server Management Studio 2014, IBM Cognos Analytics - 11.1 R2, PL/SQL Developer 12.0, Team Foundation Server
Confidential
ERP Support Specialist
Responsibilities:
- Communicated with business users to help identify requirements and to develop the best solutions.
- Responsible for handling tickets and SAP Business One Application Support to the end users.
- Modified reports and custom forms utilizing SAP Crystal Reports and SQL 2016.
- Developed ad-hoc reports based on Stored Procedures and complex multi-sub reports for Sales, Inventory, Production modules in SAP Business One.
- Created multi-purpose reports such as the shipping layouts, for the Sales Team based on the Inventory and Sales.
- Developed highly formatted reports like pixel-perfect invoices, with complex formulas, cross-tabs, sub-reports, and summary information.
- Unit testing the reports by creating transaction in SAP Business One and previewing them.
- Set authorizations and created printing sequences for the SAP Crystal reports.
- Create User Queries for Purchasing and Sales in SAP Business One.
- Developed various charts and graphs like bar chart, Column chart (side by side, stacked), and pie -chart using the SAP Business Objects Dashboard.
- Created the SAP BI Reporting Catalog for end users and management.
- Participate in the weekly SAP B1 core meetings to be able to contribute, to enhance the reporting for the SAP Business One application and provide updates.
Environment: SAP Business One 9.3, SQL Server 2016, T-SQL, SAP Crystal Reports 2016, SAP BusinessObjects Dashboard 4.2, Microsoft Teams, Cayzu portal, SharePoint.
Confidential, Wayzata, MN
Business Intelligence Analyst
Responsibilities:
- Actively partnered with stakeholders to solve problems through data and application of SAP Business Objects 4.2.
- Designed and developed complex Web Intelligence reports with multiple data providers, sub-queries, calculation contexts and multiple layers of drill downs, based on SAP HANA and Bex Queries.
- Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis.
- Created Technical Specification documents for the existing reports of SAP Business Warehouse (SAP BW).
- Involved in Data quality testing, assisting with user acceptance testing as well as assist team in delivering complex adhoc analysis.
- Participated in scrum meetings and coordinated with Business Analysts to understand the business needs and implement the same into a functional design.
- Performed execution of test plan for SAP Implementation.
- Provide status updates regarding the project on a weekly basis to the project implementation lead and the team.
Environment: SAP Business Objects 4.2, SAP BW, HANA, Microfocus ALM Octane, Microsoft Visual Studio.
Confidential, Minneapolis, MN
Sr. Crystal Reports/Tableau Developer
Responsibilities:
- Gather specifications from customers to understand requirements, analyze data and provide valid report designs.
- Developed crystal reports based on views and Command Object. Modified existing reports based on user requirement and export the reports in multiple formats (Excel, PDF, .RPT etc.)
- Created Prompts, Formula fields, conditionally suppressed sections, Clean and Consistent designs in Crystal Reports.
- Published the Reports into the folders in Central Management Console (CMC) and scheduled the reports to run monthly, quarterly, weekly, daily or based on the calendar in CMC.
- Created Cross Tab reports and dashboards with combination of charts, to help users analyze and understand the data and by navigating, through the reports for detail analysis.
- Created Parameters, Actions, Hierarchies, and filters for detail visualization to meet end user needs.
- Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
- Worked on Assigned tickets and resolved the issues within the given time.
- Work with Users to define and clarify dashboard goals, objectives and requirement.
- Defined best practices for Tableau report development.
- Extensive data validation and testing reports using SQL.
- Converted Crystal and Tableau reports from Dev to Prod.
- Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
Environment: Business Objects 3.1, 4.2, Infoview, Launch Pad, Central Management Console, Crystal reports 2008/2016, Tableau 10.2/10.3, Oracle 11, Rapid SQL, Visual Studio Team Foundation Server 2015, MS One Note.