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