SUMMARY

• Over Twelve years of experience working with major industries such as Financial/Capital Market, commercial banking, Retail business and Pharmaceuticals.
• Expert in SAP Business Objects Enterprise Suite 4.2/4.1/4.0/XI 3.1/ 3.0/R2/6.5
• Architected the technology/systems, and lead the implementation of BI related projects.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8/9.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Experienced in End - User Interaction Incident/Problem/Release Management Project Life cycle.
• Proficient in Installation and Deployment of Business Objects to Business Objects XI R2/3.1/ BI 4.1/BI 4.2.
• Outstanding experience in Central Management Console (CMC) and CCM(Central Configuration Manager) in BO XI R2/3.1/BI4 /BI4.1/BI 4.2.
• Strong Data Warehousing ETL experience of using Informatics 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools -Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ER win and ER-Studio.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Expertise in Installing Desktop and Enterprise Server Products of Business Objects in Single and Distributed Environments on Windows.
• Proficiently developed use-cases and project documentation (user guides, standard report instructions, demos)
• Highly proficient at requirements gathering and testing planning/scenario creation/test case creation - Strong analytica /problem-solving skills, with the ability to quickly gain alignment on proposed solutions.
• Basic Knowledge of AWS (Amazon Web Service) Cloud and HTFS Software.
• Expert in working with all the modules of SAP Business Objects BI4.1/ BI4 /XI R3/R2/6.5CMC,CMS, BI
• Launch pad, Web Intelligence Rich Client, Information Design Tool, Universe Design Tool and Performance Tuning.
• Highly proficient at creating Business Object universes using Business Objects Designer (UDT)/ Information Design Tool(IDT)Modules.
• Expertise in security setup among groups, categories, users and successfully implemented windows authentication, single sign on among single and multiple Domains.

TECHNICAL SKILLS

Languages/Tools: Tableau 10/9, Business Objects Suite 5.x/6.x/XIR2/XI3.1/BI4.0/BI4.1/BI 4.2, BW Query DesignerDashboard Designer, Lumira, BO Analysis, Central Management Console, Central Configuration Manager, InfoView, BI Launchpad / OLAP Intelligence, Designer, Dashboard Manager, Scorecards, Live Office, Import Wizard, UMT, PMT, Report Conversion Tool and Services, QlikView 11, Oracle Business Intelligence, Informatica, ACBS (Advanced Commercial Banking System) REMS (Real Estate Management System), NetApp, EMC. Hyperion/Brio 6x/8x/9.

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2000/2005/2012 , MS Access 2003/2000, DB2, stored procedures, SQL*Plus.

SQL Utilities: Toad, SQL, SQL*PLUS

Operating Systems: Windows NT/2000/XP/ 2003/2008/2012 Server/UNIX

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ

Sr. Business Objects Lead Developer/Administrator

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications forbusinessobjectuniverses and reports
• Involved in creation of High level design document for new requirements.
• Analyzed requirement changes for enhancements and included them in existing HLD
• Designed and documented Universe and Report Requirements Definition, Security strategies, and Report Distribution strategies
• Created relational and Relational connections using Information design tool.
• Implemented universes using IDT.
• Created connections, data foundation andbusinesslayer in universe.
• Created Joins like equal-join, theta-join, outer joins, short cut join, set join cardinalities in data foundation layer of universe.
• Got exposed to SAP BW BEx Queries as data sources to Web Intelligence
• Created WEBI reports utilizing all the features on Web Intelligence like Optional Prompts, Functions, filters, Input controls, Sections, Breaks, Ranking, drill, scope of analysis, merge dimensions, calculation contexts, force merge, combined queries, hyper linking and using report level variables.
• Publish, distribute and schedule Web Intelligence reports using BI Launch Pad.
• Used publication feature in WEBI to publish multiple reports to dynamic users.
• Migrated the content from SAP BO3.1 to SAP BO 4.1.
• Resolved the issues occurred during migration
• Status reporting and estimation of Efforts and publishingtime lines for each Change Request.
• Implement development activities for universes and perform unit testing before moving the code for QA testing.
• Planning and monitoring of Change Requests and owning the delivery of Change Requests until deployment Tableau Forecast Reporting
• Development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created Forecast Worksheets, Dashboards and Story for Management presentations.
• Designed and deployed Graphic and Analytical visualizations Parameters and Interactive and Quick
• Filters.
• End to end experience in designing and deploying data visualizations using Tableau.
• Worked closely with business power users to create reports/dashboards using Tableau desktop.
• Used Page Shelf Functionality to create analytical Visualizations and Analytics.
• Created Trend line and Forecasting functionality from Analytics for decision making.
• Created Box Plot/ Gantt Charts to present best analytics for decision making.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles

Confidential

Sr. Business Objects Developer/Administrator

Responsibilities:

• Coordinating with business teams and IT teams in requirement collection, analysis and documentation. My team included 5 on-site developers and 4 off-shore developers. Interacting with Data Modeling team, in design and analysis of data base schemas and performance tuning and resolving issues.
• Involved in documentation for the mapping, technical specifications, data validations and Test cases
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary Connections.
• Involved in migration and deployment of the universes and reports across multiple domains
• Creating standard full client reports and Webi reports.
• Documented BI launch pad guide for users to explore new features.
• Converted Desktop Intelligence reports to SAP BI4 Interactive Analysis Reports. experience in creating interactive & executive dashboards using Xcelsius Enterprise 2008/4.5/3.x
• Worked on creating Static and Dynamic Dashboards using Xcelsius
• Created Dashboard by usingTableauclient designer
• Designed Business Objects Universes and designed security for the Business groups.
• Designed functional and Technical Business object security model using Business structure.
• LOV’s, aggregate awareness, Implementation of aliases, contexts, resolved loops and traps.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point.
• Wrote hundreds of stored procedures and function on numerous SQL server to use in SSIS package and Power BI.
• CreatedCrystal Reports,TableauandPredictive Analysis reports, as peruser requirements.
• Performance Tuning and Optimization for Reports, Universes and Queries Qlik Sense and QlikView
• Created Users, Streams, Security Roles and Report Scheduling in QlikView and Qlik Sense QMS
• Used NPrinting and Macros on QlikView.
• Consuming SAP HANA views on IDT to deliver business layer using web intelligence and have proven experience with reporting specially handling complex scenarios using joins and SQL.
• Performance monitoring and tuning of the environments to ensure smooth operation Identify and resolve. Major performance issues and to drive best practices and maintain constant uptime.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Used Data Integrator and Platform Transforms extensively.
• Utilized data blending activities for Tableau functionalities.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Confidential

Sr. Business Objects Developer/Administrator

Responsibilities:

• Scheduled Daily Status call and stand-up meeting to update the project status/deliverables and interacting with architect people to get a better understanding of the data flow.
• Installed and configured Business Objects XI 3.1 on Windows platform.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.
• Developing SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Hands-on experience with SQL scripts like stored procedures and HANA working functionalities.
• Implementation experience and knowledge of SAP HANA reporting for different functional area Finance.
• Conversed .UNV universes to .UNX universes.
• Maintaining and Troubleshooting of Business Objects Enterprise Objects Enterprise Servers and clustering.
• Configured the Data services to connect to the SAP R/3, BI and CRM.
• Migrated all current XI R2 prod business applications to BO XI 3.1 on DEV box, testing in progress.
• Maintaining current Business Objects Enterprise XI 3.1 Development/ Test and Production environments.

Confidential

SAP Business Objects Developer/Administrator

Responsibilities:

• Designed and validated universe from multiple data sources with SAP BI4 Information design tool.
• Created Dashboards using SAP BI4 Dashboard Design tool.
• Created complex formatted Web reports using Web Intelligence and dashboards using Xcelsius.
• Worked on creating Static and Dynamic Dashboards using Xcelsius Enterprise 2008/4.5/3.x
• Involved in migration and deployment of the universes and reports across multiple domains
• Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to every component.
• Creating standard full client reports and Webi reports.
• Migrated content from BOE 3.1 to SAP BI4 with Upgrade SAP Business Objects SAPBI4 LCM Tool.
• Visual Difference used to compare and validate the reports after migration.
• Installed SAP BI4 on Windows 2008 server.
• Configured the Data services to connect to the SAP R/3, BI and CRM.
• Maintenance of Dashboard Builder and Performance Management tool.
• Worked with both SAP authentication, Windows and Authentications.
• Reports were distributed with Reports bursting and personalized Profile techniques.

Confidential

Business Objects Developer/Administrator

Responsibilities:

• Created and Maintained Users, User Profiles and Repository.
• Created Web Intelligence and Business Objects reports for sales management team for analysis.
• Reports were used on weekly basis for analyze the market trend.
• Call Average reports were created and analyzed the impact of the Call average Vs Sales.
• Analysis reports are used for the Focus of the products and analyze the market dynamics.
• Administered rebates, since large pharmaceutical companies pay rebates for having their drugs on formulary (aka preferred drug list), assisted in managing the negotiations and billing of the rebates.
• Provided technical leadership, and created documents how the migration should be implemented keeping in consideration the future design modifications.
• Held weekly status review meetings with the upper management.
• Met all the key milestones and deliverables on time to the management.
• Deployed customized Dashboards using the Dashboard Manager XI.

Confidential

Business Objects Developer/Administrator

Responsibilities:

• Involved in import, export of metadata to facilitate data exchange between different tools (openness). Designed and established a metadata-reporting environment.
• Created Complex, General Ledger, Account Receive (AR) and Account Payable (AP) Reports.
• Created Dashboards with Cyclic display expressions in QlikView.
• Created OLEDB, ODBC connections to retrieve data from Oracle and SQL server databases to build QlikView
• Maintaining and Troubleshooting of Business Objects Enterprise Objects Enterprise Servers and clustering.
• Setting up and Configuring Business Objects Servers like job servers and FRS.
• Creating, maintaining and modifying the business critical reports using the Desktop Intelligence
• Generating the Standards and templates for the reports, interfaces and the universes.
• Migrated all current XI R2 prod business applications to BO XI R2 on DEV box, testing in progress. Expertise in deploying/elevating applications to UAT and Production.
• Expertise in taking cold and hot backups of business objects repository and content as well.
• Successfully tested the DR in remote place.

Confidential

Business Objects Administrator

Responsibilities:

• Successful Implementation of the new Business Reporting System.
• Led a migration from Business Objects 6.5.1 to Business Objects XI R2 for the Confidential .
• Held weekly status review meetings with the upper management.
• Held meetings with the users of all applications to define and implement the new security model for BO XI R2 using CMC.
• Implanted the Row Level Security for the users in the Designer module of BO XI.
• Migrated the security domain (users, groups and profiles) to XI R2 infrastructure.
• Migrated universes and all related documents from BO 6.5.1 to XI R2 file system using migration wizard.
• Configured all the scheduling jobs through XI R2 framework.
• Performed the security mapping and Windows AD integration.
• Collaborated with the client's Windows administrators, database administrators, and a line-of-business manager for business requirements.