SUMMARY:

• 6+ years of experience primarily using SAP BI Business Objects Analytical tools 4.X, XI3.X, XIR2 and front end integrations with portals and back end (BW/ Hana), Oracle Databases systems with good knowledge in overall Systems/ application architectural landscape
• Facilitated successfully several end to end BI implementations and development (Universes, designing reports, kpi s, metrics) during all the phases Full development life cycle (SDLC) of the project life cycle and product life cycle using Agile, Scrum, Waterfall methodologies for BI developments and implemented ITIL best practices and has a good understanding of PMP Concepts and framework
• Business Analysis experience and Streamlined client reporting requirements interacting with client and stakeholders directly and created Business Requirement Specification Document, Design and functional documents delivering the functional and nonfunctional artifacts.
• Extensive experience in creating universes using Universe Designer - UDT, IDT Information Design tool for metadata, Personal data files, stored procedures, free hand SQL methods with expertise in creating simple, complex canned and ad-hoc Reports using Web Intelligence/ Desktop Intelligence/ Crystal Reports and created complex Visualizations, & Dashboards, Dashboard Design-Xcelsius, Design Studio, Tableau reports, Qlik, data discovery (Explorer, Lumira)
• Hands-on experience with installations, Deployment, Upgrade, Monitoring and Performance Tuning, Troubleshoot SAP BI BOBJ 3.1 / 4.1 and Hana with basis for systems and applications. Provided support for the installation and operation and Provide Impact analysis, root cause analysis on need basis
• Expertise in Business Objects Migration/implementation / deploying contents and configurations from one environment to another (i.e. Dev, QA, Test, UAT, Prod) used Import Wizard and SAP Life cycle manager LCM, Promotion management tool
• Experience in BI assessment, BI strategy, Big data visualizations, Service delivery, infrastructure, operations, and development teams and as a team member and working independently.
• Accountable for client relationships and served as the primary point of contact for BI delivery needs collaborating with leadership and provided initiative to ensure services, delivery, research and project expectations were met or exceeded
• Project lead, BI Architect, Project Manager experience in delivering end to end Reporting applications or BI solutions leading cross functional team with dedicated resources, off shore team and prioritized, scope, high level estimates and managed teams using HP PPM, etc.
• Familiriaty in developing reports and visualizations on the relational databases and Hadoop infrastructure SAP, MSBI, Tableau and Performed POC s for product tools
• Good understanding of BI Systems / frameworks, Data bases, Data warehousing, Web servers, load balancers and high availability systems, Object Oriented Programming OOP s concepts such as Java, Big data, Analytics, Map Reduce, HDFS, Web analytics Salesforce, cloud computing and troubleshooting experience
• A self-motivated and self-directed person with Excellent Communication, interpersonal skills and ability to work under Tight Schedules

TECHNICAL SKILLS:

BI Tools: SAP Business Objects Enterprise product suite (6.5, XI Release 2/3.X/4.X), Crystal reports, Qliksense, Tableau, MSBI (SSRS, SSIS, SSAS), Jasper reports, Microsoft Dynamic CRM, Power BI

DBMS: SQL Server, Oracle 11g/10.x/9.x/8.x, DB2, MYSQL, PL/SQL, T-SQL, SAP HANA, MS Access 2007

Web Tools: HTML, DHTML, CSS, Java Script, Servlets, JDBC, IIS(Internet Information Services), Apache/Tomcat/WebLogic/WebSphere, SAP Net viewer portal, and PHP, Java / .Net framework, Net Weaver Developer Studio, JSON

Tools: / Software/OS: Informatica/ SAP BW, BODS, ALM, JIRA, PPM, Power BI, Salesforce, ITM Software Remedy, Microsoft Office, Solaris, UNIX, Windows Server

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. BI BO Technology Lead Develpoer Analyst/Lead BI Admin/Architect

Responsibilities:

• Experience with visualization tools (Tableu, Qliksense, Design Studio, SAP Lumira, Dashboards etc.)
• Experience with Analytical tools(BOBJ Webi Web intelligence/ Launchpad, Crystal Reports), Analysis for Office to deliver workbooks, Analysis for OLAP.
• Aided and Performed BI product Evaluations, and estimating BI effort
• Responsible for delivering reports and visualizations end to end using AOF, Design Studio
• Performed POC, End to End implementations with SAP Business Objects and Tableau, Qliksense, Power BI to aid in Visualization requirements, needs
• Experience in the creation and defense of business cases for information delivery implementations, working in partnership with the business sponsors
• Experience gathering requirements, documentation and getting sign off. Performed quality, coordinated for User acceptance testing
• Developed and managed multiple information delivery projects and deliverables in parallel. A nticipate risks and issues, escalate to senior management and facilitate decision-making to balance business needs versus technical constraints
• Performed feasibility analysis, scopes projects, and works with the project management team to prioritizes deliverables, and negotiate on product functionalities.
• Elicit Business Requirements and Responsible for Developing and Implementing Webi and Crystal Reports and create technical anf functional specifciations documents for design and development. Coordinated and organize meetings. Created user manaual and training documents
• Understanding of current state business processes, identify enhancement opportunities, negotiate changes across business and technology teams, and deliver as-is and future state process documentation.
• Desigened & Developed several Webi Reports, Universes using IDT, UDT (relational and OLAP)and Visualizations against Multidata providers with Bex and Oracle data source, Univreses, and direct connections, Excel for various Business groups Finance,Sales, Procurement,etc
• Installed Qliksense on Sandbox, DEV and Prod environment and Primarily responsible for development of visualizations and administration and provided production support
• Knowledge of BODS, Informatica
• Lead and Performed upgrade from BOBJ 4.0 to 4.1 and 4.2, Infoburst Upgrade and Integration BO 4.X with Weblogic Portal
• Responsible and configured report bursting, scheduling, publications using Third part tool Infosol / Infoburst platform, Business Objects
• Desinged Security and led redesign security effort for users and user groups, Applied data level restrictions for report and universe objects for Oracle DWH and Bex queries. Managed BO/BW Authorizations and Setup Authentication using Windows AD, SAP SSO. Also used implemented third party tool 360 suite
• Responsible for BI content clean up, and Performing regular Business Objects repository maintenance and cleaning up orphaned content
• Created metrics, Configured auditing and created audit reports to track the Business Objects system usage metrics. Managed licenses, Proposed and implemented Auditing ploices for BI BO Reporting for compliance needs.
• Initiated, Proposed and led Implementation of DR Recovery services for BO Servers and collobarated & Implemented High availability landscape for BO cluster
• Responsible for Administration, configured, managed and monitored the SAP BusinessObjects Business Intelligence platform with BW/Hana, Crystal Server, Qlik Sense, Infosol across different environments consisting of 25 servers.
• Designed fully clustered & redundant BI4.0/BI4.1 systems, ensure high availability of BOE web applications by configuring DNS
• Troubleshoot and resolve the issues faced by end users and application teams - related to BO, webservers, Load balancer, DNS, Proxy and Network team, SSO using Siteminder etc
• Hands on experience with integration of Business Objects systems with SAP BW, HANA
• As BO SME, Planned and implemented BOBJ Landscape and collobrated with architects with COE team provided architectural and strategic direction for the use of Business Objects products suite. Architecture Assessment Analysis (Sizing Analysis), Scaling & performance tuning Business Objects environment according to SAP Best practices.
• Ensured technical and functional specifications were created & shared documentation with technical teams, COE, and for CIC
• Led the effort for Qliksense, Crystal, BI4.2 POC and trained and mentored team, users for new features and functionality. Also, helped established training program various users(both technical and non-technical language)
• Responsible for E2E implementation, development and administration activities for BI Technology Stack as part of Decision Support Systems
• Manage the Business Objects Queue in our ticketing system and respond to any user requests. This includes work on promoting objects to production, granting access to objects and the like.

Environment: BOBJ 4.X, Crystal Reports Server, Explorer, Design Studio, Lumira, MSBI(SSRS), BODS, IS, BI 7.X, HANA,BW on HANA, HANA Live, ECC, CRM, Supply Chain,SAP FIORI, 360 Suite, Salesforce, Oracle, Infinum, HPALM, SDM 12.X, Infosol Infoburst, APOS,BO Planning, Infinium, Power BI, Internet Information Services (IIS), WebLogic, Windows

Confidential, NYC, NY

Sr. BI BO Developer Analyst/Architect / Admin

Responsibilities:

• Responsible for eliciting needs / reporting requirements of stakeholders and Wrote business and specification documents and use cases, scenarios, unit, system, Business Process Maps/Flows- AS-IS (current) and TO-BE (future) and familiarity with Rational Requisite Pro tool in the enterprise reporting and visualizations landscape
• Created and supported Dashboard using visualization tools data discovery systems, Tableau (Desktop, Server), Design Studio, Xcelsius Dashboard Design for different data sources like Hana, Oracle DB using Live Office, Query as a Web services and XML as a source for non-technical users
• Particpated in BI architecture strategy and influenced decisions, performed assessments of BI and Visualization tools including SAP BI, Oracle BI, MSBI, Power BI
• Extensively worked on Analysis, technical Design, development of WEBI Reports with sub tabs, multiple variables at report level to meet complex business requirements for modernization, enhancement projects
• Experience in Analytics with BOBJ/ HANA reporting, data modelling and Big data Hadoop
• Provided support as a technical product lead/program manager and Managed multiple reporting applications to aid in Project Management/Applications service delivery tasks for both D & t and Confidential
• Implemented security matrix in CMC, created access levels for users and applied restrictions on contents. Implemented Row level restriction for manager’s profiles using designer
• Installed, Configured and coordinated implementation activates for BO 4.1 to build all the Environments as part of technology refresh team and collaborated for integrating reports/ interactive dashboards to external web applications aided in portal strategy
• Established best practices, approaches and planned roadmap and strategy for Business Objects and participated in contributing for data or content standards and templates for reporting systems to ensure synchronization across various applications
• Created and monitored monitor daily, weekly schedules, publications
• Collaborated to work with infrastructure personals, 3rd party vendors, SAP to aid in negotiating contracts to expedite in project delivery
• Administered and Supported environments for BI activities and Collaborated with Product and Project Management, Architecture, Testing, Quality Assurance, Operations, Client Services, and executive management to ensure the integration efforts meet release schedules, goals, and objectives for Design, Construction Implementation and Delivery of Reporting and Visualizations solutions
• Involved in production support and provided guidance, instructions to schedule and manage security, jobs, authentication (SSO, Windows AD, LDAP) and authorization in the CMC, WebLogic Portal, OIM for various applications and systems
• Analyze the business needs/ requirements of the projects, identify, evaluate, and recommended the appropriate business intelligence architecture, BI solutions to support the business requirements.
• Lead the Development of Complex Crystal Reports using Standard, Summary, and Cross Tabs and Grouping, conditional formatting, Sub reports, Parameters/Prompts, Formulas, Report Alerts, OLAP grids objects, Cross-Tab objects, OLE objects, Charts/Maps, Running Totals, Linking tables
• Defined and document operational control and security procedures, including those required for backup and recovery and provided 24 /7 Production support monitoring and starting servers, processes, connectivity issues, etc
• Responsible for maintaining all business documents and facilitated requirement gathering sessions using technique such as Facilitated Joint Application Development (JAD) / Joint Requirement Planning (JRP), performed gap analysis, workflow, process diagram and to derive requirements for existing systems enhancements
• Designed Several types of reports, dashboards and scorecards for graphical presentations/ visualizations using Crystal reports, Webi reports, Dashboard Design Xcelsius with Qaaws and Live Office
• Experience working on Designed, lead implementation of integration projects such as BO InfoView portlet integration with portal to deliver Various types of reports, standards screens, Portal UI screens, for enabling adhoc and self-service BI reporting solutions and analytics solutions
• Build Business Objects Universes (Semantic layer) and created multiple custom hierarchies for several groups to provide drill across functionality using derive tables, views, aggregate tables build in composite coming from multiple data sources for financial management systems
• Worked extensively with (@functions (@select, @prompt, @where@ aggregate aware for performance optimization) in designer, created optional prompts, also created objects using complex case functions.
• Addressed chasm trap and Fan Trap using Multi Parse SQL. Resolved Loops using Aliases and Context
• Created Error ETL log reports and has good understanding of ETL (Extract, Transform & Load) processes, tools and methodology
• Design and developed reports using SAP BW BEx Analyzer and Business Objects Analysis for Office
• Experience with ETL Tools familiar with PLSQL packages, procedures and functions as it relates to DML
• Building Information Steward IS scorecards and custom reports for Data Quality DQ reporting
• Profiling various information systems, capture source/target mappings and transformations based on project requirements
• Hands on experience with working on conversion projects Business Objects, MSBI, SSRS Analysis Services, Dashboard from legacy application to SAP, Tableau with data modeling, building queries, data warehouse, data marts, and cubes.
• Experience in reporting methodologies, scheduled delivery of reports, ad-hoc execution of reports, metadata, drill-downs/through, and HANA views and Composite model using BW cubes
• Developing and executing advanced data profiling, data validation scenarios in Information Steward IS
• Provided guidance, training, mentoring and conducted knowledge transfer / transitions to client on BO Info View Reports, Rich clients and Dash boarding tools

Environment: Business Objects XI R 3.1/ 4.1, SAP Lumira, OBIEE, Tableau, Solution Manager, SQL Server, Oracle, SAP Hana / BW, SAP ECC, Unix / Solaris, Golden gate, Share point, Rational Software Architecture, Erwin, SVN, HP Quality Center, Informatica, IAM / OIM, salesforce, Big data Hadoop

Confidential, NYC, NY

Lead Admin/Architect/Developer Analytics Principal

Responsibilities:

• Managed multiple reporting applications to aid in Project Management/Applications service delivery tasks for both D & t and Confidential
• Extensively involved in requirements gathering to document scope document, vision, requirements, BRD, Functional requirements documents, (FRD/ FRS/ FSD/ SRS), Non-functional Requirements/ Supplementary Specification, Use Cases, Business Rules, Glossary, Data Elements, Test Cases, Requirements Traceability Matrix (RTM), other BI solution documents such as standards, templates, etc
• Primary contact for all Incidents and Resolved tickets to support production environment using Remedy
• Lead and managed integration projects such as BO Infoview portlet integration with portal to deliver standards screens/ reporting UI including from project discovery to closing including defining scope, planning schedule,cost,etc
• Supported in creating action plans, proposals, presentations and provided timely status reports weekly, issues that had impact on reaching the milestones and changes in requirements necessary to the clients and getting sign off from them for the same
• Developed several dashboards using Xcelsius, Tableau for Risk management department, involved in POC and user training on Xcelsius, Dashboard Manager Design Studio, Tableau
• Created methodologies, for supporting technical BI vision, strategy and executable roadmap, facilitated for implementation of Strategy & Leadership for BI portfolio, piloted New products analyzed results and recommended solutions to senior management to overcome challenges and delivery of solutions
• As part of the core Enterprise architecture team and application development for BI Involvement delivered projects of high risk, high-visibility successfully and participated in Architecture meetings for Governance activities and was responsible for definition and execution of solution architecture for BI projects
• Ensured that the project solution architectures align with the enterprise BI target architecture positions and patterns Developed and maintained reference and target BI architectures
• Coordinated and Managed deployment strategy for reports and dashboards, performed several deployments using Import Wizard and managed releases in all environments and worked with change management coordinator and CCB to create guidelines for improvements for both partners Confidential and Confidential
• Worked with Data architecture teams for reporting requirements and design of OLTP and OLAP systems, Data marts, for Data warehousing needs for the modernization of the applications
• Installed / Migrated and configured Business Objects Enterprise XI 3.1 using Apache/Tomcat/ WebLogic and applying custom patches to environments
• Responsible for leading and performing the technology Installations and configurations/ Upgrades / Migrations for BI Environments with SAP BOBJ 3.1 to BO 4.0 and planning and implementation of BO 4.1 SP6 / Oracle/ WebLogic Upgrade, Upgrade management tool UDT, SAP BW / Hana
• Responsible for all the Business objects system administration tasks, Disaster recovery / Software updates, Integration of Bobj with Portal utilize the Business Objects SDK and Webi SDK with Web Services, Open document, etc.
• Published/ Scheduled reports using BO XI Scheduler, CMC, InfoView using Events, creating Calendars to Email, inboxes, ftp destinations
• Planned and scheduled Business Objects project and implementation activities working with project managers and estimate the effort to aid in decision making in a cross functional team. Managed all the PM activities approval of the project charter, proposals, project planning, to closing activities and focusing on initiative tracking, leading the team through projects
• Created business intelligence information and applications knowledge center using SharePoint and collaborating with architecture (Center of excellence) and applications development teams and Transitioned groups into over a short period by combining resources and providing-training
• Helped build manual test cases user test, system test, user acceptance test plans, scripts and automation scripts, integration test scenarios, QA project plan, coordinating test data setup, environment readiness, test execution and issue resolution for BI using ALM, defect management tools, etc.
• Worked with end users, technical team to understand and design reporting and analytics solutions with Web Intelligence, Crystal Reports and Administered the Universe(s), and worked with the ETL team to assist with the population of the reporting mart
• For the Modernization Project Designed, Created Management Summary, Historical Reports for different teams
• Delivered several reports using, Web Intelligence, Desktop Intelligence, Crystal Reports with sub tabs, graphs, pie-charts, multiple variables and multiple data providers, at report level to meet complex business requirements for modernization, data base migration, enhancement projects on daily, weekly, monthly and quarterly basis.
• Used combined queries, sub queries, merge dimensions, input control feature to create reports using Webi and Deski
• Liaised between technical teams, vendors, partners to ensure delivery of reporting solutions
• Developed Custom hierarchies to support drill down reports, used scope of analysis to define drilling scope
• Successfully implemented InfoView portlet for query and reporting purposes and Created universe and trained users using InfoView and Rich - Client
• Created Xcelsius dashboards and scoreboards. & Configured BO servers to support heavy data requirements of the client in Live Office and having more than 2000 rows of data using QAAWS
• Worked with Data architecture teams to deliver reporting requirements and design of OLTP and OLAP systems, Data marts, for Data warehousing needs, for the modernization of the applications using the tools Erwin, BODS, SAP BW, Informatica, Oracle Golden Gate.
• Collaborate with the Architecture team in creating and maintaining the operational and analytical data models at the conceptual, logical and physical levels. Involved in dimensional modeling Star Schema, Snow-Flake Schema customization for reporting data mart and transactional systems
• Created data flows and work flows, used query transforms to do the ETL jobs created in Data Services
• Ensure development and packaging of ETL routines, error handling, restart/ recovery procedures, and performance tuning based on best practices and Monitored Daily BODI ETL schedules.
• Collaborated with Architects, application developers to address product bugs and delivered major and minor enhancements worked with vendor support to provide custom solutions
• Performed Business Objects Administration/ Web clustering/ Portal Integration infrastructure design and implementation tasks, Disaster recovery/ new releases and Software updates, etc.
• Supported administrated for regular updates, troubleshooting, patches, sizing, licenses, created backup and recovery procedure for content to monitor, maintain and support BO environments and recommended best practices, policies, documentations and provided technical/project guidance to developers using InfoView BI Launchpad and portal
• Supported production support activities for the reporting tools and auditing for compliance, security reports and universes and Used Query builder for monitoring
• Responsible the execution of projects and manage the work done by external vendors.
• Responsible for creating backup and recovery procedure for content and environments and participated in Disaster Recovery (DR) activities
• Assisted and interviewed candidates to recruit or hire for Business Objects needs
• Training users and created User manuals, presentations, and Training Guides

Environment: Business Objects XI R3.1 / 4.1, Tableau, Solution Manager, Data stage, BPM, Hana / BW, SQL Server Oracle 9i/10g/11g, DB2, CA ESP Enterprise scheduler, Golden gate, Informatica, Erwin, SVN, IAM/OIM, Unix, Solaris/Linux, Windows

Confidential, NYC, NY

Business Objects lead Developer/Admin

Responsibilities:

• Provided on-site Business Objects XI universe and Web Intelligence (Webi) report development services.
• Regularly performed Server restarts, client and server installations, involved in system upgrades.
• Developed and tested various Business Objects Reports based on drill downs, charts and custom formulas to calculate the Percentages and Summaries based on the group levels and formatted reports, using functionalities i.e. alerted, sorting, and ranking
• Developed and delivered the appropriate documents to communicate business requirements and technical specifications document including, Business Requirements Document (BRD), Use Case Document (UCD), Gap Analysis, Data Mapping, Prototypes, and Report Templates and Requirements.
• Generated complex reports involving numerous prompts, open document functions and data through multiple data providers
• Worked and assisted as a change management coordinator for Bobj and worked with application leads and change control board
• Involved in report conversion extensively using Report conversion tool as well as Enhancements and manual conversion for legacy reports from DB2, Cobol, Congo’s Reports
• Responsible for the Business Intelligence deployment and Tracked project progress, scope, responsible for ongoing reporting of project status to senior Management in the support for Day to day operation of the applications and responsible for leading and insight and strategy or guidance to the dev team
• Ensured Development of Test Cases matching requirements coordinating with other business analysts.
• Converted P1 reports from desktop Intelligence to web intelligence using Report conversion tool and manual conversion method.
• Worked with the Portal team to integrate Info View into a BEA WebLogic Portlet
• Provided Production support of the reporting tool including auditing for compliance, developing security reports and universes and Used Query builder for monitoring system

Environment: Business Objects XI R2/3.X, WebLogic, CVS, SQL Server, Oracle, DB2, UNIX, Solaris, Windows

Confidential, Oakland, CA

Intern Part Time

Responsibilities:

• Creates detailed Business Requirement Document (BRD) and translate it into functional specifications.
• Develop business cases, use case, for application development efforts
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality.
• Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
• Oversee daily activities of the project SDLC process and coordinate activities of team members, ensuring that module goals are met within predetermined time frames.
• Maintaining a Project dashboard for senior management status reporting.
• Contributed in designing Data model for Data Warehouse using snowflake schema, star schema
• Created Audit and security reports in Webi and Deski on universes and good understanding BO Audit, BO Security, BO CMS server
• Provided training to users

Environment: Business Objects, SQL Server, Oracle, Windows, MS Office.