We provide IT Staff Augmentation Services!

Business Intelligence Resume

Minnesota, MN

Professional Summary:

  • Around 4.5 years of IT experience in designing and developing Business Intelligence solutions.
  • Having good understanding of core Business Intelligence (BI)/data warehousing concepts.
  • Good understanding of data models like ER Model and Dimensional Data Model.
  • Full life cycle development experience includinganalysis, design, development, support & maintenance.
  • Involved in requirements study and analysis of the system.
  • Sound experience on Business Objects Products (Designer, Info View, Web Intelligence, Desk Intelligence) and its deployment.
  • Exposure to Crystal Reports, QAAWS, Adobe Flex, Xcelsius, Informatica and Teradata.
  • Expertise with Business Objects XI R3, XI R2.
  • Involved in identification of facts, measures, dimensions and hierarchies for OLAP models.
  • Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Data warehousing, and Business Intelligence applications.
  • Well versed with Data warehousing methodologies and concepts (Dimensional Modeling, Normalization).
  • Experience in the documentation of system and business requirements and specifications, step-by step technical and user manuals, design and development of test-case scenarios and root-cause analysis, developing test plans, conducting user acceptance testing, training, and implementing new processes and technology
  • Performed the Migration from Business objects from Oracle 9i to Teradata 13.
  • Having work experience in Onsite-Offshore model.
  • Possess Excellent Interpersonal skills. Technically sound, Result-Oriented with strong Problem Solving skills. Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision.
  • Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
  • Having experience in Retail and Media/Advertisement Industries.
  • SAP certified training in Crystal Reports 2008.

Technical Skills:

BI Tools

Business Objects XIR2/XI3.1, QAAWS, Xcelsius

ETL Tools

Informatica 8.6, Teradata

Language

Adobe Flex 3.0, Action Script

Database

Teradata, Oracle 9i

Company: Confidential, (Dec 2009 - Present)
Client: Confidential, Minnesota, MN
Project: Tax

Responsibilities:

  • Involved in interacting with business users, gathering and analyzing source data for enterprise data warehouse schemas.
  • Interacted with end users regularly in order to gather the requirements.
  • Designed aggregated tables on the most frequently queried data for Monthly & Yearly based reports.
  • Created hierarchies for drilldown paths.
  • Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
  • Created lots of joins and contexts in the universe.
  • Created Reports using combined Queries, Slice and Dice, Drill Down, Cross tab and Master Detail Reports.
  • Created Universes and complex reports against huge Teradata database.
  • Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
  • Created alerts, filters and inserted Breaks in designing reports.
  • Developed Web Intelligence reports for Sales and Sub-Sales reports for Daily, Weekly, MTD and YTD.
  • Proficient in full life cycle design and development of Business Objects reporting Applications.
  • Conducted training sessions to educate users about using the Business Objects tools and also about the user management.
  • Presentation of the advanced features of Business Objects to end-users to enable them to develop queries and reports easily.
  • Manually scheduled the recurring reports.

Company: Confidential, (Dec 2009 - Present)
Client: Confidential, Minnesota, MN
Project: Demand Planning Management

Responsibilities:

  • Involved in Full project life cycle (requirement gathering to implementation phase).
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Designed and developed Business objects universe and designed many complex prompts as per the business need.
  • Managed a team of 3-4 members.
  • Prepared the following - Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.
  • Used Business Objects XIR3/XIR2 to build universe and reports.
  • Developed various Charts, Graphs and drill down reports.
  • Generated Custom variables, groups and formulas in Business Objects.
  • Created Aliases to resolve the loops in the universe.
  • Created complex Webi reports by using For Each and For All function.
  • Worked on User/System report documentation, user training and testing developed reports for final deployment.
  • Worked on creating groups, conditions, filters ranking in reports
  • Created a Dashboard using Xcelsius 2008 for Business analysis.
  • Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and Traps (Chasm and Fan) and Checked the Integrity of the Universes.
  • Created Reports using universe and written the complex queries including Sub Queries, Unions, Intersect and Aliases
  • Extensively used open doc's to call child reports from parents reports.
  • Trained user community in basic and advanced Business Objects reporting skill.
  • Prepared user documentation for hands on training of end user community
  • Involved in peer review, deployment of best practices in Universe and Report design.
  • Conducted the UAT and prepared the test document and created the error log document.
  • Designed Business Objects Peer Review and UAT documents.

Company: Confidential, (Dec 2009 - Present)
Client: Confidential, Minnesota, MN
Project: Matrix Performance Management

Responsibilities:

  • Involved in gathering Business requirements and translating them in functional requirements.
  • Good understanding of Products in XIR2/3.1 including Business Objects Full Client, Web Intelligence, Designer, Infoview.
  • Managed a team of 3-4 members.
  • Developed Hierarchies in the universe for the business users to Drill down reports by Region, Department, and Vendor etc.
  • 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.
  • Exported the Universes to the Repository for making resources available to the end users.
  • Extensively worked with Ranks, Alerts, Filters, Variables and Calculations while designing reports.
  • Enabled business users to create Adhoc reports.
  • Created reports by using Crystal Reports XI R2.
  • Created different types of reports such as Master/Detail and Cross tab.
  • Developed ad hoc and complex WEBI reports for Web intelligence users using Web Intelligence
  • Involved in full project life cycle implementation (requirement gathering to production phase)
  • Prepared the following - business/technical writing of requirements, design templates, development standards document and detailed design documents.
  • Extensively created Business Objects reports like matrix reports, tables, Pareto charts and pie charts.
  • Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc
  • Extensively used Designer to design various universes for different business groups.
  • Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.

Company: Confidential, (Nov 2007 - Dec 2009)
Client: Confidential
Project: NBCU Sales Reporting

Responsibilities:

  • Worked on full life cycle of the project including requirements gathering, effort estimate, Technical documentation, Impact analysis, development, UAT, Production deployment and Postproduction support.
  • Created ETL Workflows by using Informatica to load data into the tables.
  • Also created Teradata Fast Load mad Multi Load utility to load data into tables.
  • Created complex universes and resolved loops by creating contexts and aliases
  • Implemented core and the linked universes concept.
  • Developed custom hierarchies in the universe for the business users to implement skip drilling functionality in the reports.
  • Worked on improving performance of reports with aggregate awareness function.
  • Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
  • Prompts were used in the reports as well as at the Universe level to create interactive reports for the users.
  • Developed ad hoc and complex WEBI reports for Web intelligence users using Web Intelligence.
  • Reported data for the Current year, Last year and plotted a Bar graph to help the users to compare the performance of the Business Unit for the last fiscal year with that of the current fiscal year.
  • Extensively worked with Ranks, Alerts, Filters, Variables and Calculations while designing reports.
  • Created different types of reports such as Master/Detail and Cross tab.
  • Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc

Company: Confidential, (Nov 2007 - Dec 2009)
Client: Confidential
Project: NBCU Sales Portal

Responsibilities:

  • Involved in Full project life cycle (SDLC).
  • Used Business Objects XIR2 to build universe and reports.
  • Created user interactive Dashboards by using QAAWS, Adobe Flex 3.0 and Action Script.
  • Designed the Universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes
  • Designed and developed BOBJ reports using multiple Queries with the combination of chart and tables
  • Created Ad hoc Reports using BOBJ End-User module
  • Created different types of reports such as Master/Detail, Cross Tab and Chart.
  • Developed various full client and thin client reports using Business Objects and WebI
  • Worked on Universe Designer, Web Intelligence (WebI), Desktop Intelligence (DeskI
  • Developed Complex Reports using multiple data providers, Union, Intersection, minus and Master/Detail, Cross tab, Charts
  • Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
  • Creating Adhoc Reports using End User module in Business Objects
  • Imposed Joins, Filters and Alerter to restrict the data and highlight the required data.
  • Provided training and technical assistance/support to end users on using various functionalities of Business Objects
  • Creating the Universe and report check list templates, which are used as check points before moving the migrated objects into QA and Production environments

Company: Confidential, (Nov 2007 - Dec 2009)
Client: Confidential
Project: NBCU Out of Home (OOH)

Responsibilities:

  • Involved in Full project life cycle (SDLC).
  • Used Business Objects XIR2 to build universe and reports.
  • Migrated all the universes and the reports from Oracle 9i to Teradata database.
  • Extensively used Designer to design various universes for different business groups. Created complex reports using cascading prompts, decode objects etc.
  • Developed various Charts, Graphs and drill down reports
  • Generated Custom variables, groups and formulas in Business Objects.
  • Scheduled the weekly, monthly, quarterly reports using business objects.
  • Maintained best practices during report and universes creation.
  • Developed Ad-hoc reports to meet specific requirements.
  • Scheduled Reports for the End users, Business users and Customers.
  • Worked extensively with (@functions (@select, @prompt, @where) in designer and created optional prompts.
  • Created WEBI Reports with multiple variables at report level to meet complex business requirements.
  • Worked extensively with the major functionality of BO like breaks, sections, Group values, Sorts, List of values, Pre-defined conditions, Calculations and Ranking.
  • Met the complex business requirements by creating multiple data providers in the report.

Education: B.E (Electronics and Communication Engineering)
Employment Eligibility Status: H1B

Hire Now