SUMMARY

• 8 plus years of experience in Information Technology Industry with 7 plus years of expertise in developing Business Intelligence and Data Warehouse applications.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
• Technical hands - on expertise using OLAP tool Business Objects 5.x/XI R2/R3/ BI 4.x (Universe Designer, Web Intelligence and Deski Reports, Info view and Supervisor)
• Expert in tuning the performance of SQL queries.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing models, documenting and rolling out the deliverable.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Knowledge in SAP SD, MM, FI process flows and & Experience working with SAP Technical Teams to support end user reporting
• Understands the ETL design concepts.
• Learning and working experience in SAP Lumira & HANA.
• Excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS

Reporting: SAP Business Objects XI R2/3.0/4.0 (Designer, UDT, IDT, Desktop Intelligence Web Intelligence), Crystal reports 8.5/9.0/10/XI R2, Xcelsius 2008.

Databases: Oracle 9i/10g/11g, MS SQL Server 2005/2008, Teradata, MS Access, HANA

Languages: Java, JSP, C, C++, SQL, PL/SQL, HTML, DHTML, XML.

Environment: MS Windows 2000/NT/98/XP/7/8, UNIX.

ERP: SAP

PROFESSIONAL EXPERIENCE

Confidential, IL

SAP Business Objects Developer

Responsibilities:

• Involved in business interactions to understand the functional requirements of the customers to build the reports using Business Objects to meet their goals.
• Worked with the Business analysts, end users, Data Modelers and the DBA for requirements gathering, business analysis, testing, and project coordination.
• Worked with Data Modeling team in meetings and helped in generating the schemas required for reporting.
• Involved in working with deployment teams & DBAs to deploy reports & smoke test in production environments along with final sign off from business.
• Built Technical specs for build to run transition of reports and also worked with run teams during critical times to support business.
• Working experience with HANA teams to understand the data models for respective universes
• Involved in designing universe and modifying existing universe based on new reporting requirements.
• Developed, Enhanced tested and maintained highly complex universes.
• Developed universes in SAP BI 4.0 using UDT and IDT.
• Created complex Webi reports using multiple data providers from multiple universe(s) and linked reports using open document.
• Involved in Business Objects upgrade project from 3.1 to 4.0.
• Used Derived tables in the universe whenever it is necessary
• Created multiple contexts and alias tables to solve the loops in Universe.
• Created universes for ad-hoc report needs by creating some pre-calculated objects and measures.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Created different reports containing charts showing revenue and operating income by different distribution centers.
• Created custom hierarchies to aid in Drill-down analysis of Web Intelligence documents and built cascading prompts.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report.
• Created Hyperlinks using OpenDoc from master reports to detail reports
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Unit tested on the universes and reports by running several queries against the Database to verify the results.
• Performed peer review of the reports by verifying the data in the database and by making sure the reports meet all the requirements given in the Functional Requirements Document.
• Scheduled Web Intelligence reports to run every day as per business request.
• Implemented the ETL process and business logic by using PL/SQL.
• Developed universe user documentation guide for the end users reference.
• Provided training for end users for generating their own report including complicated report.

Confidential, CA

SAP Business Objects Developer

Responsibilities:

• User requirements, translated Functional requirements into Technical Requirements.
• Developed Report Mock-up samples before User interaction to analyze the business requirements.
• Worked closely with Functional Architect, DBA and Analysts to get a clear understanding on therequirements.
• Working experience with BW teams and hands on working with SAP BW systems to validate mapping.
• Hands on experience in using BW standard extractors. E.g 2LIS 11 VAHDR, VAITM (Sales)…
• Learning experience with SAP debugging in BW system….
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Created, developed, maintained and tested the Universes.
• Created Web Intelligence Reports using all the BO functions like Drill Down, Prompts, Dimensions and Measure variables to show accurate Results.
• Developed Web Intelligence reports for Sales and Sub-Sales reports for Daily, Weekly, MTD and YTD.
• Maintained existing Web Intelligence, Desktop Intelligence and crystal reports.
• Applied security features of SAP Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Involved in creation of Filters, @prompts and setup Hierarchies for user Analysis.
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks.
• Unit tested the universe and reports by running several queries against the Database to verify the results.
• Exported the Universe to Repository for making available to Business Objects users and Web Intelligence users.
• Presentation of the advanced features of SAP Business Objects to end-users to enable them to develop queries and reports easily.
• Automated document Scheduling, Publishing and Distribution for Web Intelligence reports and Info View clients.

Confidential, MN

Business Objects Developer

Responsibilities:

• Extensively used Designer to design universes for different business groups.
• Created classes, aliases, simple reports using cascading prompts as per Functional specifications.
• Used joins concept by taking different tables from different data sources in the Universe.
• Used the formatting options like cross tab representation, sections, breaks, data sort options, font, colors.
• Developed various Tables, Graphs and drill down reports in webi.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, Filters, Sorts, Query prompt and Hyperlinks in Webi.
• Extensively created Business Objects reports like charts and tables.
• Implemented row and object level security in business objects universe Designer.
• Performed unit testing of the reports.
• Involved in extensive testing of universes and reports during version migration of business objects.
• Used slice and Dice, Drill Down, Drill Up, Prompt filters, Cascading list of values etc.
• Implemented Row & Object level security for different user groups as per the Functional Specifications.

Confidential

BI Developer Trainee

Responsibilities:

• Undergone the 3-month intensive Business Intelligence concepts, BO tool technical training course, Data Models.
• Experienced in creating universes, reports, crystal reports & dashboard and completed all exercises.
• Successfully completed the training course after completing all assignments and tests.
• Developed various Tables, Graphs and drill down reports in webi.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, Filters, Sorts, Query prompt and Hyperlinks in Webi.
• Extensively created Business Objects reports like charts and tables.
• Implemented row and object level security in business objects universe Designer.