Sap Bi Programmer (business Objects/crystal Reports/dashboards) Resume
Peoria Heights, IL
SUMMARY:
- Around 11+ years of professional experience as a Business Intelligence developer in designing and development of Data warehouse and SAP Business Objects, Crystal Reporting Applications.
- Having in SAP Certified Application Associate - SAP Business Objects Web Intelligence.
- Expertise in working with all the modules of SAP Business Objects like BOE, Launchpad, CMC, WebI, Live office, Designer, Xcelsius, Lumira, Dashboards, Tableau, DeskI and Crystal Reports.
- Experience in creating Business report which includes formatting optionsuch as Charting, Mapping, Grouping, Sorting,Alerting, Field highlighting, Drill-down, Drill through, Parameter prompts, Crystal Alert, Formula
- Experience in creating customized and complex reports using SAP Business Objects. Experience in creating different type of reports like Cross-tab, Conditional, Drill-down, Top N,Summary and Sub reports.
- Extensively involved in designing and developing the universe using designer to design various universes for different business groups.
- Designed,developedandimplemented solutionswithdata warehouse, ETL, data analysis, and BI reporting technologies.
- Having experience in dealing with various databases like SAP BW, Oracle, Teradata, SQL Server, MS Access, and Flat files, Optimizing, Debugging and testing SQL queries, views and Stored procedures.
- Experienced in Translating Business needs into end-user reports with Business Intelligence Tools like SAP Business Objects, Crystal reports and Crystal enterprise.
- Familiar with client tools of Business objects like designer, web intelligence rich client, import wizard etc.
- Expertise in BI 4.1, migration/administration/installation process, troubleshooting of the reports and BO Servers.
- Clear understanding of business procedures and ability to work as an individual and as a part of a team.
- Having experience with the role of Business analyst from gathering business requirements as well as Data analyst for data analysis/verification regarding any aspect of customer data.
- Developed new or modified programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
- Involved in research, diagnose, and resolve procedural and system problems associated with SAP Business Objects software applications, operating systems, and hardware.
- Installation and Up-gradation of Business Objects Service Packs/Critical Hot fixes/ Fix Packs.
- Extensively worked on CMC and Supervisor Module and involved in creating and managing Users/Groups.
- Extensively involved in Managing Servers, Repositories, Connections, and Assigning reports to Users, Importing/Exporting users.
- Experienced in Managing Servers, Repositories, Connections, Business Views and solving any Administration and Production issues that are escalated to the development team, to have minimal impact on delivery.
- Well acquainted working with cross functional Business and IT teams of business analysts, data analysts, data modelers, solution architects, DBA's developers and project managers during all SDLC phases with good soft skills and communications.
TECHNICAL SKILLS:
BI Reporting Versions: SAP Business Objects 4.2/4.1/4.0, BO XI R3/R2/6.5, Crystal Enterprise 4.0, Crystal Reports 2013/2008, XI/10 /9 / 8.5, SAS 9.0/9.1, SAS Management console 9.1, SAS Enterprise.
BI Tools: SAP Business Objects 4.1/4.0, BI Explorer, Web-Intelligence, Rich Client, Launchpad, Info-view, Analysis for OLAP, Analysis for Microsoft Office, Crystal Enterprise 4.0, BEx Analyzer, BEx Query Designer, Design studio, Dashboards/ Xcelsius, Tableau, Lumira, Qlikview, Crystal Reports 2013 (ver.14), 2008 (ver.12), XI (ver. 11)/10.0/9.0/8.5, Business Objects Developer Suite (Broadcast Agent, Supervisor, CMS, Designer, Info View), Business Object Universe designer, Information Design Tool, BO WEB XI.
B.O Admin Tools: Central Management console, Schedule Manager, Instance Manager, BO Server Manager.
B.O Migration Tools: Promotion Management, Life Cycle management, Import-wizard, Report conversion tool.
ETL Tools: Informatica, BO Data Integrator, BODS
Data Modeling: Erwin 3.5/4.0
Databases: HP Vertica, Oracle 9i/10g/11g, MS-Access, SQL Server 2000, 2005, 2008, DB2, Sybase, Teradata, SAP BW, SAP HANA, Big Data Hadoop
Rational Tools: Clear Case, Clear Quest, Requisite Pro
PROFESSIONAL EXPERIENCE:
Confidential,, Peoria Heights, IL
SAP BI Programmer (Business Objects/Crystal Reports/Dashboards)
Responsibilities:
- Design deliverable content to precisely reflect the engagement contract and client needs and strive to improvedeliverable quality through verification and validation of results.
- Responsible for creation of the Universe Structure modeled from relational databases and createclasses/objects/measures using existing data warehouse.
- Develop Reports with parameters, Sub-Reports, cross-tabs and charts based on views and Queries by usingCrystal Reports.
- Work on Business Object Universe, Business Objects Reports and repository extensively used, and new universewere designed and developed to support the user requirements.
- Work collaboratively with Business Analysts to design/create/modify critical Business Object’s Universes tosupport end-user reporting.
- Interacting with business analyst and users to identify reports requirements and transform it in to reportsspecification and develop reports.
- Leverage SAP best practices and methods. Write documentation to support the implementation of best practices.
- Involve in Repository management and migration across development, testing and production environments.
- Troubleshoot support tickets for operational issues.
- Develop and execute test cases and test plans for functional performance of the reports.
- Writing PL/SQL validation queries for cross testing the resulting data from the reports.
- Provide production support on defects or change requests of the reports. Analyzing issues/proposing betterreporting solutions to the users.
- Bridge between business users and the IT team and lead collaborations and discussions among cross-functionalteams for effective solution-building or issue-resolutions.
Environment: SAP Business Objects 4.2/4.1, Crystal Reports 2013 (V.14), BI Explorer, BI workspace, Information Designer tool, Universe Designer tool, BI Launchpad, Design Studio, Dashboard, Quote Tracker, Tableau, SQL Server, PL/SQL.
Confidential, Irving, TX
Sr. Business Objects Developer/Administrator
Responsibilities:
- The reports generated were helpful in cost analysis, to track business, and communicate to investment group and to analyze company’s performance.
- Worked on Business Object Universe, Business Objects Reports and Business Objects repository extensively used, and new universe were designed and developed to support the user requirements.
- Work collaboratively with report designers to design/create/modify critical Business Object’s Universes to support end-user reporting.
- Upgraded the BI platform from 4.1 SP6 to 4.2 SP3 version
- BO System usage monitoring, BO Security design and implementation, BO Central Management Console, BO Launchpad and configured the environments for both development and production.
- Demonstrate the capabilities of the Business Objects platform to groups of people. Clearly articulate the functionality and advantages of the platform.
- Interacted with business analyst and users to identify reports requirements and transform it in to reports specification and develop reports.
- Leverage SAP best practices and methods. Write documentation to support the implementation of best practices. Involved in Repository management and migration across development, testing and production environments.
- Participate in setting engagement objectives and scope; develop work plans for components of engagements, coordinate activities between work streams and identify changes in scope.
- Manage promotions of reports through the Development, Test and Production process upon getting sign off from the business users.
- Interact with customers and user communities to provide Business Objects reporting support.
- Creating reports scheduled for different file-based/ schedule-based events, distributed in email, PDF and HTML format.
- Prepare project plans identifying tasks to be performed, task owners, time lines, and milestones. Submit weekly status reports and attend project status meetings as required.
- Involved in architecting the Business Object Universe, Business Objects Reports and Business Objects repository extensively used and developed to support the user requirements. Created nested and conditional groups and formatting features in reports.
- Involved in managing security for the users, groups, folders, and published reports using CMC, in exporting and scheduling of reports at the appropriate level as required.
- Develop and execute test cases and test plans for functional performance of the reports.
Environment: SAP Business Objects 4.2/4.1/4.0, Web Intelligence rich client, Crystal Reports 2013, BI Explorer, BI workspace, Information Designer tool, Universe Designer tool, Information Design tool, BI Launchpad, Design Studio, Dashboard (Xcelsius), Oracle, PL/SQL, HP Vertica, Jira, Tableau.
Confidential, Irving, TX
Sr. Business Objects Developer/Administrator
Responsibilities:
- Involved in interacting with business users by them on using and generating Webi reports.
- Involved in migrating Universes and Reports from Dev to QA to Production.
- Created Users and Users Groups and managed user profiles as a role of BOBJ Admin.
- Upgrading the BI platform from 4.0 to BI 4.1 SP4 version and applying the patch depending on the release level.
- Collecting Requirements from the team, analyzing, documenting, building, exporting Universe to Repository.
- Generated reports with Universes created in Information Design tool as the data providers with various functionalities that displayed data to the requirement.
- Created complexJobs, Work Flows, Data Flows, and Scriptsusing variousTransforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
- Extensively usedData Services Management Consoleto schedule and execute jobs, manage repositories and perform metadata reporting.
- Created Local, Central and Profiler repositories and configured Local and Profiler repositories with Job server and Management console.
- Maintain, manage and support change control processes including integrated nature of the Business Objects Universe. Support migration, security, testing, and maintain required documentation of the Universes.
- Created Technical design documentation for universe and business objects reports specification after requirement gathering and analysis and coordinated with the data warehousing team consultants to ensure the thorough and accurate testing of the data.
- Assist in the design of databases and data warehouses to ensure interoperability with BI solutions.
- Interact with the business product owner to gather requirements and, based on findings, design functional specifications for BI front-end applications.
- Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.
- Develop new audit BO reports and perform usage analysis on the BI platform. Having advanced skills with Business Objects reporting/scheduling of the reports and exporting to FTP server, BI Inbox.
- Interface with functional leads to define data requirements and improvements to the data delivery process and thereby design analytics / reporting to meet the requirements.
- Reconcile and troubleshoot report/data issues. Daily monitoring of scheduled jobs/ troubleshoot in case of any failures.
- Opening incidents/tickets with SAP as required for getting proper resolution regarding troubleshooting of the BO servers and reporting issues.
- Provide production support on defects or change requests of the reports. Analyzing issues/proposing better reporting solutions to the users.
- Involved in the migrating of crystal reports 2008 to crystal reports 2011.
Environment: SAP Business Objects 4.1/4.0, Web Intelligence rich client, Analysis for OLAP, Analysis edition for Microsoft Office, Crystal Reports 2011/2008 (V.12), Information Designer tool, Universe Designer tool, BI Launchpad, Design Studio, Dashboard, (Xcelsius), Tableau, Lumira, Business View Manager, Oracle, PL/SQL, HP Quality Center.
Confidential, San Antonio, TX
Sr. Business Objects Report Developer
Responsibilities:
- Develop new reports and enhancing existing reports in Business Objects Web Intelligence environment.
- Develop and drive the implementation of Business Objects 4.0 best practices and standards.
- Develop and maintain universe scripts to be used for analysis on reports that are developed in-house.
- Translates functional requirements of the reports build into technical specifications document.
- Maintain existing universes and create new ones as needed and modifying the universe as per the report changes/requirement.
- Work with cross functional Universe Development and IT teams and develop WebI reports/documents
- Recommend and take lead on new ideas of implementation/developing of WebI reports involving responsibilities towards getting dashboard requirements, design, document, develop and test front end dashboards and reports.
- Worked in a team environment to deliver solid client solutions.
- Design processes to minimize data quality risks and proactively identify potential data issues.
- Support the on of Business Objects Power Users using Web Intelligence and other tools.
- Adhere to good systems agile development methodology.
Environment: SAP Business Objects 4.0, Web XI, Crystal Reports 2008 (V.12), Universe Designer tool, Web Intelligence Rich Client, Launchpad (Infoview), Business View Manager, Oracle, PL/SQL, Xcelsius, Test Link
Confidential, Frisco, TX
BI Developer III/ Business Analyst - (BOE Webi/Crystal Reports)
Responsibilities:
- Used Universes as source for the Business Objects/Crystal reporting and analysis.
- Gathered the Report Requirements from the users and created the Universes and Reports.
- Created report templates, developed Ad-hoc reports, complex reports (e.g. reports from multiple data sources, drill down capabilities by using Crystal Reports.
- Designed and Developed Technical User Documentation, User Manuals, and involved in the end users.
- Involved in the SDLC of various projects and did give inputs to the architects on how best to come up with a schema for optimal and fast reporting.
- Created complex objects and condition and resolving loops using context and alias.
- Extensively used designer to design various universes for different business groups.
- Created Objects, Predefined Conditions, Joins in the Universe.
- Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity of the Universe.
- Do unit testing of reports to confirm that they work as expected in Development environment, both in Crystal Reports and when published to Business Objects Enterprise XI R2 environment.
- Proficient in using SQL, stored procedure and understanding relational data structures/models/relationships.
Environment: SAP Business Objects XI R3.1, Web XI, Crystal Reports V.12/V.11, Business objects/Crystal Enterprise (Designer, Webi, Infoview), Business View Manager, Oracle 10g, SQL server 2008, SQL Server Management Studio, PL/SQL, Universe Design Tool, Xcelsius 2008, Visual Studio 2008, Client Homer/SDLC Application.
Confidential, Plano, TX
Business Objects/Crystal Report Developer
Responsibilities:
- Involved in creating Alerts so that notifications will be sent to user based upon a value range of a metric (KPI).
- Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, @Functions, etc.
- Generated complicated reports using sub reports, developed parameterized reports and created charts.
- Developed Reports with parameters, Sub-Reports, cross-tabs and charts based on Stored Procedures and Queries by using Crystal Reports.
- Involved in the dashboard development also performed including Data fromSAPBW through BexQueries, Datafrom Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.
- Responsible for creating new and modifications to existing queries using Query Designer as part of reportdevelopment. Created Metrics and Analytics that are used to build Dashboards and Goals.
- Worked on database connections, SQL joins, Loops, Materialized Views, Indexes, Aggregate Conditions, Parsingof objects and Written PL/SQL procedures and functions for processing business logic in the database.
- Coordinating and conducting business, systems requirements analysis meetings with business and technology partners, business analysts, data modelers, solution architects, DBA's and project managers.
- Prepare project related documentation (functional design, technical design, and test scripts) during different stages of a project.
Environment: SAP Business Objects 3.0, XI R3, Web XI, Crystal Reports XI (V.11), Business objects/Crystal Enterprise (Designer, Webi, Infoview), Oracle 9i/10g, SAP BW, BEx Analyzer, BEx Query Designer, SQL Loader, PL/SQL, Interactive Analysis, Universe Design Tool, Xcelsius 2008, QAAWS, Live Office.
Confidential, Plano, TX
BI Consultant (Crystal Reports)/ Data Analyst
Responsibilities:
- Involved in migration and deployment of the universes and reports across multiple repositories.
- Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
- Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets by using Set and Merge for generating Reports.
- Creating tables through SAS job to use the data to be presented in the report.
- Monitoring and Scheduling day to day SAS jobs through platform process manager, flow manager.
- Run and modifying the SAS job manually or if the SAS job fails or if any error occurs in the SAS coding.
- Created complex reports using multiple data providers, filter and breaks. Created complex variable and formula.
- User Creation and Security at diverse levels of Hierarchy in management.
- Checking out the Security rights and login id of the Dealer to view the report.
- Implement Data Level Security in Universe, Folder, Application wise
- Involved in Migration of Reports, Universes, User Groups, Users using Import wizard
- Involved in generating monthly reports like Operational performance report (OPR), compensation and commission report for the Dealer originations.
Environment: Business Objects XI R2/R3, Web XI, Crystal Reports XI (V.11), Oracle 10g, Crystal Report Enterprise
Confidential, Chantilly, VA
Business Objects Consultant
Responsibilities:
- Involved in migration of the report from Business Objects 6.5 to XI R2 environment.
- Provided support to the user's group and maintaining Universes and reports.
- Creating reports of kind, Slice and Dice, Drill Down, Combined Queries, Functions, Cross Tab, Master Details and wrote formulae for easy-to-use benefit information system by using Crystal Reports.
- Exporting and scheduling of reports using Crystal Enterprise and generated WEB Reports.
- Created complex Desktop Intelligence and Web Intelligence reports based on business needs
- Designed complex linked Universes for Ad hoc reports
- Involved in designing and creating business views with location based groups to filter user based on their LDAP group association.
- Developed highly complex Stored Procedures, Views and also helped in performance tuning using an explain plan for better performance.
Environment: Crystal Reports 10/XI (V.11), Business View Manager 11.5, Central Management Console, Import Wizard, BO-XI Query Builder, Desktop Intelligence, Web Intelligence, BO-XI Schedule Manager, Oracle 9i/10g, DB2, PL/SQL
Confidential
Crystal Reports Consultant
Responsibilities:
- Developed Reports with parameters, Sub-Reports, cross-tabs and charts based on Stored Procedures andQueries by using Crystal Reports 9.0.
- Analyzed and created Data Marts, Dimension and Fact Tables according to the Business Rules.
- Developed portfolio based reports for stocks, securities and investments.
- Designed and maintained logical and physical enterprise data warehouse schemas, developed and deployed newdata marts along with modifying existing marts to support additional business requirements.
- Generated reports by using Stored procedures and generated Parameterized, Drill down reports
- Created report templates, developed Ad-hoc reports, complex reports (e.g. reports from multiple data Queries,drill down capabilities by using Crystal Reports
Environment: Crystal Reports 11/10/9/8, Crystal Enterprise 9.0, VB.NET, Oracle 9i, SQL Server 2000, Erwin 3.5, SQL Loader, PL/SQL, and Windows 2000