Sr. Business Intelligence Analyst Resume
Roles:
- Sr. Business Intelligence Analyst/Lead
- Business Intelligence Analyst
Tools:
- Business Objects XI R2/R3
- Crystal Reports XI R2
- Xcelsius 2008
- Query As A Web Service
- Webi
- Informatica 8.6.1
- Toad
- Query man
- Microsoft Visio
- Maestro
Industry Application:
Retail
Media and Advertisement
Education:
- Bachelor’s Degree: Bachelor of Engineering
Experience Summary
- Having 4.5 years of experience in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
- Experienced in development and design of reports and dashboards for supporting the business analysis in a corporate wide reporting using Business Objects XI R2/R3, Crystal Reports 2008, Adobe Flex 3 and Xcelsius 2008.
- Strong proficiency in the full life cycle ofBusiness solution development with outstanding capabilities in analysis, problem definition and requirements gathering.
- Database experience in Oracle 9i/10g, Teradata (Fastload, Multi load utilities).
- Hands on experience in ETL tools like Informatica 8.6.1 (Designer, Workflow Manager, Workflow Monitor).
- Complete implementation of the SDLC life cycle in the projects.
- Proficient in full life cycle design and development of Business Objects reporting Applications.
- Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models.
- Experience in training developers and advising technical groups on reporting best practices.
- Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
- Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
- SAP Certified Training in Crystal Reports 2008.
Skills Inventory
Project Lead:
- Project Scoping
- Effort estimation
- Project Coordination – Planning, Execution and Closing
Analysis/Design:
- Business analysis / Requirements Determination
- High Level Design (HLD)
- Low Level Design (LLD)
Development/Test/Deployment:
- Development
- Code Review
- Unit Testing
- UAT Co-ordination with Business Users
- Deployment and Post-Production Support
Sr. Business Intelligence Analyst/Lead
Employer - Confidential, Dec 2009 - Till Date
Client – Confidential
Project - Tax
Environments: Business Objects XI 3.1(Universe, Web Intelligence), Teradata
The scope of this project is to create the new business objects universe and the reports for the Best Buy Tax business users to provide them more insight into the tax details for their auditing purpose.
- Involved in interacting with business users for requirements.
- Responsible for translating the Business requirements into technical specifications.
- Analyzed data flow and business requirements to create High Level Design document.
- Made use of the aggregated tables on the most frequently queried data for Monthly and Yearly based reports.
- Worked extensively with @functions (@aggregate aware (Aggregate Navigation), @select, @prompt, @where) in the creation of dimensions, measures and conditions in the universe.
- Used Database Delegation property for the objects that involves ratios or averages.
- Created hierarchies in the universe for drilling down the data from highest granularity to lowest granularity.
- Created Reports using combined Queries, Slice and Dice, Drill Down, Cross tab and Master Detail Reports.
- Made use of alerts, filters and Breaks in the reports.
- Co-ordinated with the Business users for the UAT testing.
- Created the Universe and report check list templates, which are used as check points before migrating the objects to QA and Production environments.
- Worked on very tight deadlines and aggressively for the completion of the Project.
Sr. Business Intelligence Analyst/Lead
Employer - Confidential, Dec 2009 - Till Date
Client – Confidential
Project – Demand Planning Management
Environments: Business Objects XI 3.1(Universe, Web Intelligence), Teradata, Informatica
This Project is to create the reports for the Demand Planning and the Forecasting business users which helps them to look at the quality of their forecasting up to 25 weeks in the future. And also it helps the business users to ensure the accuracy of the forecasting which in turn helps the business to manage their inventory effectively.
- Involved in Full project life cycle (from requirements gathering to implementation phase).
- Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlined the proposed solution.
- Responsible for translating the Business requirements into technical specifications.
- Analyzed data flow and business requirements to create High Level Design document.
- Designed and developed Business objects universe and designed many complex reports as per the business need.
- Created the Informatica mapping and workflow to load the data from the external source to the Enterprise Data Warehouse.
- Created Aliases to resolve the loops in the universe.
- Created complex Webi reports by using For Each and For All function.
- Extensively used open doc function to implement the functionality of linking of reports.
- Created Reports using universe and written the complex queries including Sub Queries.
- Used Designer features such as Hierarchies, Prompts, Derived Tables and Analytic functions like Ranking, Reporting Aggregate, Aggregate Awareness and Object Incompatibilities.
- Implemented skip drilling functionality in the reports.
- Used Bridge Table concept to break the N:N relationship between the tables in the universe.
- Involved in code review and the deployment of the Universes and Reports.
- Trained user community in basic and advanced Business Objects reporting skill.
- Prepared user documentation for hands on training of end user community.
Sr. Business Intelligence Analyst/Lead
Employer - Confidential, Dec 2009 - Till Date
Client – Confidential
Project – Matrix Performance Management
Environments: Business Objects XI R2/R3 (Universe, Web Intelligence), Crystal Reports XI R2, Xcelsius, Teradata
This project involved creation of the WebI and Crystal Reports which helps the business users to monitor the performance of the overall business. Also the enhancements provided greater visibility to the areas that require attention of the Best Buy business to increase the profitability. Increased functionality made interaction with the reports easier and more efficient allowing users more time to react to the information presented.
- Involved in interacting with business users for requirements gathering and analyzing source data for enterprise reporting.
- Responsible for translating the Business requirements into technical specifications.
- Analyzed data flow and business requirements to create High Level Design and Low Level Design document.
- Reported data for the Current year, Last year and Plotted a Bar graph to help the users compare the performance of the Business Unit for the last fiscal year with that of the current fiscal year
- Created Multiple Universes and resolved loops by creating Contexts and Aliases, and also resolved Chasm traps and Fan trap problems.
- Involved in Adding of new Objects to the existing Universe as per end users request.
- Prompts were used in reports as well as at the Universe level to create interactive reports for the users.
- Enabled business users to create Adhoc reports.
- Implemented Linked universes concept by creating Master universe and the derived universes.
- Created Parameterized reports in the Crystal Reports XI R2.
- Created the Crystal Reports by writing the SQL Command and from the universe.
- Used Highlight expert and Group Expert in the Crystal Reports.
- Created Linked and Unlinked subreports from the main report by using Crystal Reports XI R2.
- Created the Teradata Fast Load and the Multiload scripts to load the data from the Source to Staging and from staging to Base tables.
- Involved in Post-Production fixes and maintenance of the Xcelsius Dashboard.
Sr. Business Intelligence Analyst/Lead
Employer - Confidential, Dec 2009 - Till Date
Client – Confidential
Project – Service Bench
Environments: Teradata, Informatica, UNIX, Maestro
Service Bench is the leading provider of web-based service management solutions to help customers deliver best-in-class service with effective, efficient, and accurate exchange of information between channel partners in every transaction. The idea of the project is to bring the data for the Service Order GL, Claim GL & Claim audit from the Service Bench to the Enterprise Data Warehouse and to make it available for reporting.
- Responsible for translating the Business requirements into technical specifications.
- Analyzed data flow and business requirements to create High Level Design and Low Level Design document.
- Created the Fast Load Scripts to load the data from the source to the Staging table.
- Created Bteq Scripts to load the data from the Staging table to the fact table.
- Created the Informatica mapping for the Data Quality Assurance in order to match the data with the source and to find out the missing records from the Source to the Fact table.
- Modified the UNIX shell scripting to combine all the source files into a single file.
BI Analyst
Employer – Confidential, Nov 2007 – Dec 2009
Client – Confidential
Project – NBCU Sales
Environments: Business Objects XI R2 (Universe, Web Intelligence), Adobe Flex, Action Script, Oracle
The scope of this project is to create number of dashboards and the reports to help the business users to monitor the performance of their overall sales that deals with all the applications that the NBC Universal is running on. This helped the business users to compare the Last Year Sales with the Current Year Sales and helped them to plan the budget for the future.
- Involved in Full project life cycle (SDLC).
- Prompts were used in the reports as well as at the Universe level to create interactive reports for the users.
- Created the reports by using multiple data provider and merge dimension concept has been implemented.
- Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
- Created customized List of Values (LOV’s).
- Created Alerters to highlight a specific field in the report.
- Created and tested classes and objects to organize the universe.
- Used the Powerful business objects functionalities like @functions in the universe and formulas like user response and drillfilters in the report.
- Exported the universes to the Repository to make resources available to the users.
- Developed Web Intelligence reports for Sales and Sub-Sales reports for Daily, Weekly, MTD and YTD.
- Setup Multi-Page Reports, Margins, Headers & Footers and provided users with Open Document Functionality features.
- Embedded the logo in all the reports by accessing the image from the Business Objects Server.
- Published and Scheduled the business objects reports weekly to the business users.
- Created user interactive Dashboards by using Adobe Flex 3.0 and Action Script.
- Query As A Web Service has been used to pass the data from the Universe to Adobe Flex by generating the Xml.
BI Analyst
Employer – Confidential, Nov 2007 – Dec 2009
Client – Confidential
Project – Oracle to Teradata Migration
Environments: Business Objects XI R2 (Universe, Web Intelligence, Desk Intelligence), Oracle, Teradata
This project involved migration of all the universes and the reports from Oracle 9i to Teradata in order to improve the performance of the reports.
- Involved in Full project life cycle (SDLC).
- Migrated all the universes and the reports from Oracle 9i to Teradata.
- Converted all the oracle functions and the logic that has been used in the universes and the reports to have equivalent Teradata function and the logic.
- This improved the performance of the reports which was having run time of 40 minutes earlier to have run time of 7 minutes in Teradata.
- Tested all the universes and the reports across all the environments (Dev, QA and Prod) and co-ordinated with the Admin team to deploy all the universes and the reports in QA and Prod.