SUMMARY

• Over 8 years of experience in Business Intelligence/DWH with skill set of Business Objects 4.x/3.x/R2/R1, Oracle 11g/10g/9i, SQL Server 2012/2008.
• Expertise in BI4.x/ BOXI 3.x/R2/R1 with experience in CMC, CCM, BI Launchpad/InfoView, Import Wizard/UMT, LCM, IDT/DF, UDT/Designer, Widgets, WebI Rich/Thin Client, DeskI, RCT, Publishing Wizard, QaaWS, BI Services, Live Office, Live XML.
• Expertise using Crystal Reports 4.x/ 2013/2011/2008/ XI, Crystal Dashboard Design 4.x/Xcelsius 2008.
• Created several universes using IDT/UDT with more than one database, Loops, Traps, Hierarchies, LOVs, Cascading LOVs, Context, Alias, @functions, Ansi 89 and 92, Star Schema, Snow flake relational, Olap universes consuming BEx, Linking derived universes to core universe for user to have one universe to query from.
• Strong skills using SQL, PL/SQL/T - SQL, RDBM, complex queries, joins, grouping, stored procedures, functions, triggers, sequence, cursor.
• Created several WebI canned and Adhoc reports using master/detail, drill down, hyperlink, alerts, ranking, sorting, sections, breaks, report/section/block level filters, crosstab, vertical, horizontal, forms, charts, variables, calculations, combined query, multiple queries, prompt, input controls, merged dimensions functionalities.
• Created several DeskI reports using universe, free hand sql, flat file, vb macros, linked objects, cross tab, charts.
• Created several Crystal reports using universe, dB, command, formatted reports, grouping, sorting, excel format, opendoc.
• Created several Dashboards and Scorecards using Dashboard Designer/Xcelsius 2008 using Live Office, QaaWS, BI Service, Live XML as a data source, KPIs, summery info provided drill down reports for detail.
• Created dashboards and Scorecards for VPs to support DSS using selectors, charts, single value, text, dynamic visibility, alerts.
• Expertise using CMC, users, groups, access level, folder, categories, instance, authentications, SSO, InfoView customizations.
• Involved in SSO configurations.
• Experience configuring authentications such as Enterprise, LDAP, Windows AD, SAP.
• Expertise using UMT/Import Wizard/LCM for migrations from DEV to QA and QA to PROD.
• Involved in upgrades from XI R2 to 3.x, 3.x to 4.x
• Expertise using RCT (Report Conversion Tool) to convert DeskI Reports to WebI as SAP is discontinuing DeskI in new version 4.x.
• Created BW connection using IDT.
• Expertise in SAP HANA 1.0 clear exposure of HANA db working with real time data, creating attribute views, analytical views, Derived attributes, Calculation views, CE functions, working knowledge with Modeler, Administration, SLT.
• Created complex SAP HANA data models (attribute/analytical/calculation views) e.g. data model that provides summarized insight information to management about production lines KPI, product ordering life cycle KPI.
• Created WEBI reports using BW back end by utilizing BICS connection.
• Created dashboard using BICS connection from BW as data source.
• Strong knowledge of methodologies like waterfall, agile.
• Implemented training strategies for Super Users, Report Consumers and BI Report Developers
• Strong knowledge in SLDC all phases e.g. requirement gathering, blue print, development, testing, migration, unit testing, regression testing, UAT, administrating, security management and production supports.

TECHNICAL SKILLS

BI Tools: BI BO 4.x ( BI Launchpad, WebI, Crystal Report Ent. Widgets, Explorer, IDT, UDT, QaaWS Designer, Live Office, BI Services, CMC, CCM, Wdeploy, RCT, LCM, UMT, Advance Analysis, BI workspace), Dashboard Designer 4.x/Xcelsius 2008, Crystal Report 4.x/ 2013/2011/2008/ XI, BO 3.1/3.0/R2/R1(All Tools)

Databases: BW 7.2, SAP HANA 1.0, Oracle 11g/10g/9i, MS SQL Server 2012/2008

Tech. Language: SQL, PL/SQL, T-SQL

Operating System: WIN 10/WIN 7/XP/2008/2003

Others: Toad, Office, Visio

PROFESSIONAL EXPERIENCE

Confidential, Madison WI

Business Objects Developer

Responsibilities:

• Worked with product owner/stack holders to address their data related issues.
• Majority of the works was production support with development reports and universes.
• Solved reporting issues as they come through Service Now portal in a production support
• Execute unit and/or parallel testing with support of business analysts and data analysts, as necessary
• Work with business analysts, data analysts and business intelligence developers to develop Business Objects reports based on defined business requirements
• Created/Modified WEBI reports for end users using WEBI Rich/Thin Client based on universes/free hand SQL etc.
• Create and update Derived tables in the universe to update report changes as they come through production support
• Moves report from Test Environment to production Environment through CMC.
• Update Universes as per user requirement, tested changes in the universe and move them to production through CMC.
• Assist business users with functional questions related to business intelligence and reporting tools and trained them in a Lab
• Use Netezza, SQL Developer and SQL server to write queries and pull out required data.

Environment: BO 4.2, SQL Server, Netezza, Oracle.

Confidential, Garland TX

Business Objects Developer

Responsibilities:

• Created WEBI reports involving complex queries, sub queries, Unions and Intersection.
• Used UDT/IDT to create Universes, joining the tables, creating prompts and queries and applied Contexts and Aliases to resolve loops.
• Involved in ETL Process using BODS.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Secured sensitive data by applying a security feature of object level security in the Universe and the report level security in the CMC.
• Heavily interacted with the Client users to gather the requirements of the KPI WebI report.
• Created various drillable WebI reports.
• Created ad-hoc reports with multi prompts to retrieve required data for the user and to minimize unnecessary load on the server.
• Created Reports with heavy conditional formatting and functions to meet user requirement.
• Customized the reports with custom functions and loops to leverage the user reporting needs.
• Created various group based publications and distributed reports to the users.
• Migrated Universe, reports, dashboard, user, groups etc from dev to qa, qa to prod using import wizard using best practices.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
• Interacted with the users to analyze the changes for improvement they need in existing reports and develop the reports to satisfy their needs and requirements.
• Created several dashboards using Crystal Xcelsius.
• Used Live Office, BI Services and QAAWS (Query ads a web service) to get the data from the database into the dashboards.
• Designed and Developed Xcelsius dashboards / analytics and exported to several formats
• In Xcelsius used single value, selector, mapped, chart, background, collaboration and text components, and dynamic visibilities.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius.
• Created/Modified Universes using IDT, data foundation, Business Layer.
• Created several reports using Webi, used new functionality like linking table/charts, hyperlinking, rules, fold/unfold etc.
• Created Webi reports consuming data from BICS from BW.
• Created Dashboards/scorecard using Dashboard, consuming unx data source straight to components, dynamic visibility, if logic, QaaWS, BIWS, BICS etc.
• Prepared user documentation for hands on training for end user community.
• Provided production support to end user, worked with sustaining team.

Environment: Win7, Oracle 11g, BO 4.1, Dashboard 4.1.

Confidential, Dearborn MI

Business Objects Developer

Responsibilities:

• Analyzed Business Requirement with BA.
• Analyzed database structure with DBA.
• Build multiple universes from scratching using ERD & SQL.
• 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.
• Developed several UTD from scratch and also maintained existing UDT.
• Developed several IDT from scratch and also maintained existing IDT.
• Exposure to multi data sources using IDT.
• Developed Best Practice for IDT.
• Written Index file which contains HTML and Java script.
• Worked with .js file which used for sending parameter between multiple dashboards.
• Enhance/modify existing reports by creating new Parameters, Formulas etc,
• Scheduled reports using Info View/Launch Pad to run at specific times in a day/week as desired by the Business Users.
• Scheduled reports to go to users directly and share drives.
• Create various complex reports using Crystal Reports.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc
• Migrated reports from version 10 to version 2008 of Crystal reports.
• Created multiple Webi Reports using Formatting, Report/Query Filter, Sections, Breaks, Ranking, Formulae, Prompts, Drill Down analysis, Input Controls, Variables, Charts, Merge Dimensions and Alerts.
• Created Sub-Query and Database Ranking at query level.
• Created Detail Webi reports using Hyperlinks.
• Prepared presentations and Training End Users on Webi 3.1/4.1.
• Used BEx connection Webi 4.1 to bring BEx query into report.
• Used multiple Operator like IN, ForAll, ForEach etc. in Webi 3.1/4.1.
• Publish WSDL block in Web Service Publisher in Webi 3.1/4.1.
• Created Standard Template for Webi Report and Dashboards.
• Developed Interactive/Dynamic dashboards with Xcelsius and provided production support.
• Organized/Maintained large and complex Excel spreadsheet mapping within the Xcelsius.
• Developed Dashboards with Drill Down capability, also created alerts to highlight specific targets based on the requirements.
• Used Query Browser to bring data in Dashboard.
• Created multiple data connections using QAAWS, XML, Flash variables, BI Services and Live Office to feed data into dynamic dashboards.
• Responsible for summarizing performance trends and highlighting problem areas
• Created OpenDoc with passing parameters and created flash variables to open Child Dashboard from Parent Dashboard.
• Extensively worked on Dynamic Visibility concept within Xcelsius and using flags from universe to control dynamic visibility through query logic.
• Work on existing reports to optimize and troubleshoot problems that occurred due to new business requirements
• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Go-live, and Hyper-Care.
• Upload/Maintain documents on SharePoint page for business units.
• Estimate tasks and time after analyzing the project using Rally and Excel.

Environment: XP/7, Business Objects 3.1/4.1, Oracle 11g, SAP Dashboards 3.1/4.1 SP2, Informatica 9.1, Agile, Rally