SUMMARY

• Business Intelligence Consultant with over 7+ years of experiences in various technologies underlining SAP Business Intelligence.
• Worked in top financial and health care industries with vast knowledge of business models and data flow.
• Hands on experience with development of multiple reports in BI Launch Pad, Web Intelligence, Desktop Intelligence, Rich Client and Xcelsius.
• Administered Business Objects XIR 4.1 and XIR 3.1 environments.
• Proficiency in SQL language utilized for development of reports and universes.
• Strong knowledge of Data Modeling Concepts, Star Schema, Snowflake schemas, Multi star schemas, Extended star schemas and etc.
• Working closely with End Users and Business System Analysts in understanding their requirements and gathering business level information to be utilized to create universes, reports for ad - hoc and canned reporting usage.
• Developed Universes using Business Objects Universe Design Tool (UDT) and Information Design Tool (IDT).
• Universe Methodology involving the creation of underlying database structure, resolving the loops, creating classes & objects, conditions & joins and finally testing the integrity of the Universe.
• Worked closely in creating test cases, performing UAT and testing reports and universes to ensure quality delivery.
• Assisted in creating ETL Jobs for Informatica Power Center tool to capture ideal data for reporting and archiving purposes.
• Worked on multiple database systems including Oracle, Teradata, and MS SQL Server.
• Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.
• Good analytical and documentation skills with ability to communicate at all levels.
• Proactive person with good teamwork and collaboration capabilities, with strong interpersonal skills to ensure maximum performance and maintaining a good work environment.

TECHNICAL SKILLS

Reporting Tools: SAP BO 5.1, 6.5, XIR 2.1, 3.1, 4.1, Infoview/Launch Pad, Xcelsius 2008, Webi Thin Client, Webi Rich Client and Deski

Database Systems: SQL Server 2000/2005/2008 , Oracle 9i/10g/11g, MS Access

Languages: SQL, PL/SQL, T-SQL.

ETL Tools: Informatica Power Center.

Other Tools: HP QC, Remedy, Lotus Notes, and MS-Office Package.

SDLC Methodologies: RUP, Waterfall, Agile (Scrum, RAD, X-programing), Spiral

Operating Systems: Windows XP/7/8.1/10, Windows Server 2003/2005/2008.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object universes and reports.
• Analyzed database structure and data flow with DBA.
• Created aliases, contexts and short cuts joins by resolving loops, cardinalities and integrity checks of the universe.
• Managed User level securities across all three environments, Development, QA (Quality Assurance) and Production.
• Managed Folder structures for Report level and Universe Level within Business Objects.
• Managed multiple access levels on all environments.
• Worked with LCM (life cycle manager) and Import wizard for migration of content between environments.
• Utilized Import wizard for taking weekly BIAR backups for all Reports and Universes.
• Worked extensively to ensure proper scheduling times for all reports, including but not limited to reports sent to user inbox, and emails.
• Worked with Publication for Webi Reports.
• Exposure to multi data sources using Information Design Tool.
• Developed several UTD/IDT from scratch and maintained existing UDT/IDT.
• Managed Application level access, Connections and Events for Production server.
• Involved in troubleshooting for developers in case of report level / SQL code level issues.
• Leveraged multiple teams to co-ordinate efforts ensuring maximum uptime.
• Involved in Data-Analysis, Data-Digging for resolving / answering data level issues to the end-clients.
• Used multiple Operator like IN, ForAll, ForEach etc in Webi 3.1/4.1.
• Involved in Testing SAP BI 4.1 Upgrade, testing client end tools, including Launch Pad, IDT, Designer and Xcelsius 2011.

Environment: Business Objects XIR 3.1, 4.1 with Infoview, Oracle 11g, Teradata 12, IBM DB2, MS-SQL Server, MS-Office 2010, Windows 7.

Confidential, NY

Software Engineering Analyst/Business Objects Developer

Responsibilities:

• Involved in multiple sessions with Business Users to understand and capture Business Level requirements for reporting needs.
• Collaborated with Business Analyst, Data Modelers, DBAs to ensure data flow and match requirements for reporting needs.
• Define Joins and Cardinalities base of database structure.
• Created Classes, Objects, Filters, @Functions and Derive tables.
• Define Contexts and Aliases to solve loops.
• Used SQL for Universe objects modification, Condition, Sorting, and Calculation.
• Created multiple Webi reports, Deski reports and Dashboard reports for graphical presentation.
• Created Webi Reports using Formatting, Report/Query Filter, Sections, Breaks, Ranking, Formula, Prompts, Drill Down analysis, Input Controls, Variables, Charts, Merge Dimensions and Alerts.
• Coordinated L1, L2 and L3 support team members.
• Analyzed user requirements. Find solutions to technical issues; extend technical assistance.
• Improved support process and procedures.
• Optimized and enhanced some of the existing reports to reduce processing time.
• Developed reports using filters, prompts, sorts, groups, subtotals, free hand SQL and multiple data providers.
• Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects
• Set up Aggregate Awareness to enhance the performance of SQL transactions.
• Tuned the reports for better performance using SQL.
• Conducted Business Objects and Web Intelligence training session to train the users.
• Worked closely with BI Architects to in corporate server level changes.
• Elaborated Service Level Agreements among support team leaders.

Environment: Business Objects XIR3.1, Oracle 9i, Teradata 11, IBM DB2, MS-Windows XP, Remedy MS-Office 2007.

Confidential, NY

Business Objects Developer

Responsibilities:

• Used Web Intelligence to Create Reports.
• Created Master/Detail Reports for Reconciliation reports.
• Created reports using @Functions, (@prompt, @aggregate, @where).
• Created different variable and formulae to show different subtotals.
• Created Report Formatting elements like break, table level filters.
• Created ad-hoc reports using Business objects functionalities like Master-detail & formulas, slice & dice, drill down, @functions etc.
• Created Detail Webi reports using Hyperlinks.
• Created reports using different formulae and variable to match those with that of SQL scripts.
• Allocation of rights to different module access to users.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Involved in Functional Acceptance testing (FAT) and User Acceptance testing (UAT) Created Test cases, reviewed and maintained test scripts, analyzing bugs, worked with development team and ETL team members in fixing defects and validating the solutions.
• Analyzed data to see whether Data matches to user Expectations.
• End user Training and system Documentation.
• Made changes to the universe in the production database to create effective reports.
• Created Universe, Classes, Objects and measures.
• Checked the Loops and Chasam/Fan Traps in Universe.
• Made Alias tables in Universe.
• Responsible for summarizing performance trends and highlighting problem areas.
• Tested the data fetched in BO’s against the open SQL results.
• Formatted the reports as per the user requirements.

Environment: Business Objects XIR 2.1, 3.1, Oracle 10g, HPSM, Outlook 2007, MS-Windows XP, HP-QC.