PROFESSIONAL SUMMARY:

• Experience as an SAP Business Objects/ Tableau Developer in a prestigious company and exploit my skills in Data modeling, reporting, Visualization and Business Intelligence skills in meeting company's goals and Objectives. Installed and Configured SAP Business Objects XI 3.1/4.1 on Windows 2003/2008/2012 Environments. Developed migration plans and implementation of SAP Business Objects Universes and Reports on Windows 2003/2008/2012 and Linux servers. Implement tableau dashboard with different data sources are SAP BW.
• Created over 200 BI Reports utilizing tools such as Web Intelligence (in BOBJ 4.x, BOBJ XIR3, BOBJ XIR2), Crystal Reports 2008/4.1, and Tableau Desktop 2020 .
• Developed highly complex reports for the Federal Government and Fortune 500 corporations; utilizing Business Objects 4.x, XIR3.1, XIR2, 6.x, Crystal Reports 2008, Crystal Reports XI, and Tableau (Worksheets); as well as BOBJ Analysis for OLAP and Excel
• Develop data visualization dashboards utilizing SAP Lumira. Performed Data Analysis in MS SQL Server 2008 and SAP BW 3.5 and 7.3; created documentation highlighting GAP analysis; also performed Integration and Unit test in SAP BW; developed and tested multiple BEx queries.
• Performed migration of system and reports for Fortune 500 companies; and, for the Federal Government between Windows 2003 and Windows 2008 with SAP Business Objects XIR3.1 and 4.1.
• Setup security for User accessing .Net interface in SAP Business Objects XI 4.1. Completed setup for Administrative Office of US Courts of 94 Dynamic Data Connections. Also, setup users and groups security ps, using the Central Management Console in Business Objects XIR3.

TECHNICAL SKILLS:

Business Intelligence Technologies: Business Objects 4.2, 4.1, XIR3, XIR2, 6.x, 5.x Suite (Desktop and Enterprise Server products suite), Tableau 2020, Crystal Reports XI, 10.0, 9.0, Web Intelligence (2.x, 6.x, XI), COGNOS 10

RDBMS & Data Warehouse Technologies: MS SQL Server 2008, Oracle 9i and 10g, Sybase, Sybase IQ, Informix, SQL Server, Teradata, MS Access, Peoplesoft.

Applications: Change Gear, ServiceNow, TOAD, MS Office, Erwin, MS Project

Operating Systems: Windows XP/2003/2000/NT/XP/9.x, Macintosh, Citrix

Languages: PL/SQL, HTML

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Objects Administrator/Developer

Responsibilities:

• Administer patch updates and configure/troubleshoot issues within SAP Business Objects 4.3 environment
• Develop SAP Business Objects Web Intelligence reports based on JIRA ticket(s)
• Additionally, develop Crystal Reports based on provided report requirements

Confidential

Reports Developer III / Tableau Developer

Responsibilities:

• Extensively worked on SAP Business Objects Administration widely using Central Management Console (CMC).
• Created Users and Groups and setting the right privileges on them using Central Management Console (CMC) and CMS.
• Scheduling of Reports in CMC on Daily, Monthly, Weekly and calendar basis.
• Worked with Upgrade Migration Tool to migrate/upgrade the BO versions from Lower to higher.
• Experience in Installation, Configuration and administration of Tableau Server in a multi - server and multitier environment.
• Worked with errors like Fix report alignments, calculation errors and context errors.
• Strong experience as Business Objects Administrator including installation, configuration of BO tools in windows and Linux operating systems, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.
• Develop multi-dimensional Business Objects reports related to multiple divisions within the organization
• Additionally, develop Tableau worksheets for analysis and define certain organizational contracts (internal and external)
• Also, work with DataGrip utilizing Amazon Redshift to execute SQL statements to produce data for execution within Business Objects/Tableau reports
• Utilizing Excel pivot tables and data calculations to present report outputs from Business Objects
• Worked with the Director of Financial Insights and the Data Management organization, to automate the company's legacy report builds (both in BOBJ and Excel).
• Produce SQL-driven reports for customers that meet operational reporting requirements using SAP Business Objects.
• Work with several teams within the company including Data Management, Product, Transportation, Operations, and Finance.
• Provide analysis and well written documentation for the final requirements of a report.

Confidential

Sr. Business Objects Engineer

Responsibilities:

• Developed and created SAP Business Objects Web Intelligence Reports based on complex client requirements.
• Identifying objects within the IDT (Information Design Tool) within Business Objects 4.2 environment
• Also, identifying the corresponding field and table with the associated within IBM Maximo
• Continuously develop SAP Lumira data visualization projects.
• Developed Web Reports in SAP Business Objects Xcelsius to measure the performance.
• Developed Web Intelligence reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Expertise in resolving joins path problems like Loops and Traps in the Universes using Aliases, Contexts, and Aggregate Awareness in Business Objects Designer.
• Extensive Experience in using Business Objects functionalities.
• Used tools such as Tableau, SQL Server, SAP systems, Excel to locate the data points and develop meaningful reports to analyze business performance.
• Use technologies such as Tableau 2021.1/2020.3 , SAP, SQL Server, and report different KPIs required for business.

Confidential

Sr. Business Objects Engineer

Responsibilities:

• In the United States, the Congress passes tax laws and requires taxpayers to comply.
• The taxpayer’s role is to understand and meet his or her tax obligations.
• The IRS role is to help the large majority of compliant taxpayers with the tax law, while ensuring that the minority who are unwilling to comply pay their fair share.
• Installed and Configured SAP Business Objects XI 3.1/4.1 on Windows 2003/2008/2012 Environments Developed migration plans and implementation of SAP Business Objects Universes and Reports on Windows 2003/2008/2012 and Linux servers. Created over 200 BI Reports utilizing tools such as Web Intelligence (in BOBJ 4.x, BOBJ XIR3, BOBJ XIR2), Crystal Reports 2008/4.1, and Tableau Desktop 2020 .
• The IRS is organized to carry out the responsibilities of the secretary of the Treasury under section 7801 of the Internal Revenue Code. The secretary has full authority to administer and enforce the internal revenue laws and has the power to create an agency to enforce these laws. The IRS was created based on this legislative grant.
• Section 7803 of the Internal Revenue Code provides for the appointment of a commissioner of Internal Revenue to administer and supervise the execution and application of the internal revenue laws. The Automated Insolvency System (AIS) is the IRS's primary tool for tracking legal requirements for dealing with taxpayers under bankruptcy protection as well as ensuring that the government's interest is protected when these taxpayers have tax obligations. AIS is a comprehensive control and processing support application for processing bankruptcy and other insolvency work. It provides case inventory, status control, proofs of claim, and exchange of information with the United States Courts' Case Management/Electronic Case Filing (CM-ECF) system.
• As one of the lead Business Objects developers on the AIS system, my development responsibilities included the following:
• Identifying objects within the IDT (Information Design Tool) within Business Objects 4.2 environment along, with identifying the corresponding field and table with the associated Oracle 11g database;
• Translating the existing legacy Business Objects reports (and fields) to the current Business Objects 4.2 environment.
• Developed 7 reports to correspond with the new BOBJ environment.
• Provided guidance and architecture guidelines, as well as descriptions for setting up their and Test environment.
• Installed and Configured SAP Business Objects XI 3.1/4.1 on Windows 2003/2008/2012 Environments
• Developed migration plans and implementation of SAP Business Objects Universes and Reports on Windows 2003/2008/2012 .
• Created over 200 BI Reports utilizing tools such as Web Intelligence (in BOBJ 4.x, XIR3, XIR2) and Crystal Reports 2008/4.1.
• Developed and created SAP Business Objects Web Intelligence Reports based on complex client requirements.
• Identifying objects within the IDT (Information Design Tool) within Business Objects 4.2 environment
• Also, identifying the corresponding field and table with the associated within IBM Maximo
• Continuously develop SAP Lumira data visualization projects.
• Implementation of SAP Business Objects Universes and Reports on Windows 2003/2008/2012

Confidential

ITIL Analyst/Cognos Administrator

Responsibilities:

• Primary point of triage for all incoming Service Requests and Incident Requests
• Assigning them to the correct team for a resolution to the submitted issue
• Including creating Requests For Change, where new requirements or modifications Confidential the scope of the Service or Incident Request were identified
• In addition, created a step by step process for correcting any Vulnerability identified by the Security group to resolve via team server updates, upgrades, or reboot.
• Assisted with migration of Cognos Reports and Packages for migration within the existing environments (DEV/ST/ATC/PROD)
• This included executing pre-existing SQL scripts, as well as, using the Cognos Migration Tool to move the requested Cognos Reports and Packages to their designated folders.
• Developed over 23 complex SAP Business Objects XIR3 Web Intelligence (Webi) reports
• Utilized Universe Designer to convert created BEx queries for use with Webi reports
• Analyzed User requirements for development of BEx queries and WEBI reports
• Created multiple BEx’s to utilize with Webi reports

Confidential

Senior Application Engineer

Responsibilities:

• Provided experience with all architectural aspects of enterprise applications, most specifically multi-tier web applications
• Involved in design, implementation of SAP BI BO 4.1 Suite and upgrade to 4.2.
• Developed virtualization strategies to include application development within the commercial cloud environment
• Worked as a member of a cross-functional team consisting of business leads, system engineers and Information Assurance engineers
• Managed and coordinated individual workloads while simultaneously supporting multiple migration efforts.
• Provided a strong background in DoD/Army computing environments and application security requirements
• Established familiarity with Microsoft Project/Project Server/SharePoint 2010, Agile processes, and Scrum methodology
• Possess the analytical ability to examine application architectures and make technical assessments to identify appropriate target hosting environments
• Developed utilization assessment and capacity planning, identity management, and authorization strategies
• Familiarity with Microsoft and Linux operating environments
• Strong coordination, organization, teaming and communication abilities
• Ability to work under pressure and compressed time constraints
• Conducted trend analysis of the current system/application population and evaluate demands for additional migration services
• Working experience with MS Visio, MS PowerPoint for diagramming & presentation development
• Strong oral and written communication skills

Confidential

Sr. Business Objects Engineer

Responsibilities:

• Developed and created SAP Crystal Reports based complex client requirements.
• Installed and setup SAP Business Objects XIR 3.1 on Windows 2003 and Windows 2008
• Configured security setup for Universe, SAP Business Objects Web Intelligence reports.
• Developed documentation detailing migration of SAP Business Objects XIR2 to 3.1 SAP Business Objects 4.1 on Windows 2003 and Windows 2008 environments.
• Performed analysis on existing SAP Business Objects environment on Windows 2003 environment
• Installed and setup SAP Business Objects XIR 3.1 on Windows 2003 and Windows 2008
• Configured security setup for Universe, SAP Business Objects Web Intelligence reports.
• Gathered Client requirements for SAP Business Objects Web Intelligence reports and security configuration
• Developed documentation detailing installation of SAP Business Objects XIR 3.1/4.1 on Windows 2003 and Windows 2008
• Continue to develop SAP Business Objects Web Intelligence reports and Analysis for OLAP documents.

Confidential

SAP Business Objects Developer/Administrator

Responsibilities:

• Performed analysis on existing SAP Business Objects environment on Windows 2003 environment
• Installed and setup SAP Business Objects XIR 3.1 on Windows 2003 and Windows 2008
• Configured security setup for Universe, SAP Business Objects Web Intelligence reports.
• Gathered Client requirements for SAP Business Objects Web Intelligence reports and security configuration
• Developed documentation detailing installation of SAP Business Objects XIR 3.1/4.1 on Windows 2003 and Windows 2008
• Continue to develop SAP Business Objects Web Intelligence reports and Analysis for OLAP documents.
• Troubleshot and resolved issues with installation of Tomcat and JAVA with SAP Business Objects XIR 3.1 and 4.1.

Confidential - Houston, TX

SAP Business Objects Developer / Analyst

Responsibilities:

• Performed analysis on existing SAP BW 3.5 data objects and tables to determine feasibility with data conversion from Legacy Confidential to new merger business of OneSubsea
• Created Integration and Unit test scripts to verify feasibility analysis of Data Objects/Fields in BW 3.5
• Additionally tested and verified existing Business Objects 4.0 Webi reports for compatibility with new OneSubsea data objects
• Created documentation on executing and troubleshooting Business Objects reports
• Also created BOBJ report test scripts verifying data object compatibility with OneSubsea data

Confidential

SAP Business Objects Report Developer/Architect

Responsibilities:

• Developed over 50 Webi Reports utilizing Launchpad and Webi Rich Client tools in BOBJ
• Additionally developed over 25 BOBJ Analysis for OLAP and Analysis for Excel reports
• Analyzed BW tables for the correct data mappings to fields utilized by BOBJ reports
• Also developed and modified BEx queries based on analyzed User requirements for BOBJ reports
• Trained End Users on development of Webi reports and Analysis for OLAP documents
• Helped create UPerform scripts for Super and End User documents
• Also created Test Scripts for Webi reports

Confidential

SAP Business Objects Report / (BEx) Developer

Responsibilities:

• Developed over 23 complex SAP Business Objects XIR3 Web Intelligence (Webi) reports
• Utilized Universe Designer to convert created BEx queries for use with Webi reports
• Analyzed User requirements for development of BEx queries and WEBI reports
• Created multiple BEx’s to utilize with Webi reports

Confidential

Sr. Business Objects Developer

Responsibilities:

• Developed over 8 complex canned Business Objects XIR3 Web Intelligence reports using Infoview.
• In addition developed over 15 ad hoc Business Objects XIR3 Web Intelligence reports.
• Utilized merge dimensions and combined query tools to refine and maximize report queries.
• Created several new filters and objects using SQL in Business Objects Universe Designer.
• Administered Business Objects servers and services;
• Monitored and utilized the CMC to control services and User accounts.
• Created new user accounts and set parameters for accounts in the Central Management Console (CMC).
• Research existing requirement documents against available data to develop reports using MS SQL Server 2008.
• Provide feedback to Business Analysis team on recommended modifications to requirements to meet criteria for Administration Office of US Courts.
• Created and updated Metadata for over 1200 Universe Objects, Filters, and Folders.

Confidential - IL

Business Objects Report Developer

Responsibilities:

• Developed complex Business Objects XIR3 Web Intelligence reports using Infoview or Web Intelligence Rich Client.
• Researched existing requirement documents against available data to develop reports using TOAD (based on Oracle 10g database).
• Provided feedback to Business Analysis team on recommended modifications to requirements to meet criteria for TSA.
• Assisted Universe developers with SQL changes required to meet reporting and TSA requirements.

Confidential

Engineer II

Responsibilities:

• Requirements Gathering and Business Analysis - Interviewed users to collect Requirements, Analyzed them and transformed them into Technical specifications. Generated various reports as per the client's requirements.
• Migrated Universes and documents between environments (BO 6.5 and BOXIR2).
• Developed over 23 complex SAP Business Objects XIR3 Web Intelligence (Webi) reports
• Utilized Universe Designer to convert created BEx queries for use with Webi reports
• Analyzed User requirements for development of BEx queries and WEBI reports
• Created multiple BEx’s to utilize with Webi reports
• Documented the Universe design and Reports development.
• Trained the users in ad-hoc report development.
• Developed complex Business Objects XIR2 Web Intelligence reports.
• Updated and maintained existing Business Objects XI and Business Objects 6.5 Universes.
• Also developed new Business Objects XIR2 Universes, involving Contexts and Derived tables.
• Provided production support for existing Business Objects 6.5 and Business Objects XI reports; as well as existing MS Office documents;
• In addition, provided consulting services such as LOE and development for requested Business Object XI Web Intelligence reports and Universes.
• Developed Level of Effort (LOE) for each request in regards to Business Objects reports/MS Office documents (MS Word, MS Excel, etc.)
• Additionally developed Adobe PDF forms, using Adobe Live Cycle Designer, as per client requests.

Confidential

Business Intelligence Consultant

Responsibilities:

• This project involved the Amtrak Engineering division’s conversion to Primavera Enterprise Reporting Database and Business Objects Enterprise.
• As a part of this project I was involved in creating highly complex Crystal Reports. These Crystal Reports were designed to highlight existing financial data regarding ongoing projects within the division.
• Created the report specifications based on user requirements and client feedback. Also these reports were built using a Universe created from Business Objects Designer.
• In total created four reports within the allotted eight week time period, and the following is a list of tasks as well as responsibilities performed by me on this project.
• Created Crystal Reports using Universe connection to obtain necessary report fields.
• Also created report specifications for Reconciliation PM, Reconciliation Proj ID, SpendPlan PM, and SpendPlan Proj ID.
• Gathered client information regarding creating the above mentioned report specifications.
• Modified Crystal Reports, based on client feedback, for drill down configuration for reports.
• Also modified Crystal Reports to reflect requested aesthetics of the reports.
• In addition was in the process of mapping existing database fields to the conversion to Primavera Enterprise Reporting Database (ERD).
• Performed query searches via TOAD v8.6.1
• Performed migration of system and reports for Fortune 500 companies; and, for the Federal Government between Windows 2003 and Windows 2008 with SAP Business Objects XIR3.1 and 4.1.
• Security Integration: Setup security for User accessing .Net interface in SAP Business Objects XI 4.1. Completed setup for Administrative Office of US Courts of 94 Dynamic Data Connections.

Confidential

Dassault Systemes Crystal Reports Developer

Responsibilities:

• This project required building financial reports, using the Accounts Receivable module, to edit and populate two reports. Both reports involved getting detailed financial information, dealing with the DSAC arm of Dassault Systemes, for their General Ledger and STC reports. The infrastructure system for reporting was built using Crystal Reports Designer via Businessviews.
• Created 2 Crystal Reports using Businessviews to obtain necessary fields.
• Performed query searches via TOAD
• Obtained TNS entries to obtain the required data for the reports
• In addition queried the Peoplesoft database, regarding fields required to complete the data for the reports
• Also obtained or consulted in creating Businessviews necessary to complete the reports.

Confidential

Business Objects Consultant

Responsibilities:

• This project required building reports tracking “Clients” also known as Criminals during various stages of the trial and pre-trial process within the U.S. court system.
• Constructed 3 dynamic Crystal Reports.
• Also converted existing Universe to Business views for Crystal Reports reporting purposes.
• Crystal Reports created involved multiple embedded sub-reports (more than 15 sub-reports in one case).
• Created 15 Web Intelligence reports in BO XIr2
• Setup Universe Overloads to enable Dynamic Data Connections for Users in all 94 districts.
• Established security on Central Management Console for different districts and role based groups.
• Worked on developing security criteria at all levels
• Created 94 Dynamic Data Connections
• Migrated Development environment from Windows to Linux.
• Continued work with importing (using Import Wizard tool) current development environment on a Windows based server to the Linux server
• Also assisted with creating helpdesk case (for Business Objects) for Crystal Reports Dynamic Data Connection error
• Managed the report deliverables and the project timeline

Confidential - IL

Business Objects Report Developer

Responsibilities:

• Gathered the functional specifications for the financial reports needed for the business
• Gathered the technical specifications needed for Business Objects Reporting as well as Universe creation
• Created the mappings to go from the Report specifications to Universe design
• Designed the Business Objects Universe to enable reporting
• Created a multi-faceted Crystal Reports using created Business views to show a carrier’s “Bill of Lading”
• In addition the “Bill of Lading” Crystal Report involved inserted complex sub-reports (created via said Business views) and formatted report to resemble a “Bill of Lading”
• Created the Motor Carrier Compliance Application Universe for Web Intelligence reports
• Created Web Intelligence reports by Section/Breaks and Calculating measures at different levels.
• Updated the prompt at the Universe level instead of hard coding the List of Values (LOV)
• Helped Functional Analysts in validating Web Intelligence report formatting
• Designed summary tables for MTD, YTD, QTD aggregations on Web Intelligence reports.
• Linked drill reports to provide seamless integration of expedited, non-expedited, TTC, and Non-TTC comparisons.
• Developed complex Web Intelligence report to resemble a Bill of Lading form, and still provided the data viewing capabilities not necessarily a Web Intelligence strong suite.
• Managed the report deliverables and the project timeline

Confidential

Business Objects / Crystal Reports Migration Expert

Responsibilities:

• This project required building financial reporting for the accounting and finance department. The current mainframe system finance reports needed to be built using Business Objects XI Web Intelligence reporting tool. The mainframe system data was moved from Crystal Reports 9, Business Objects 6.x, and Business Objects Data Integrator was used to build the data mart for Business Objects reporting. The reports were built in Business Objects XIr2 needed to be validated against the mainframe system Business Objects 6.x reports and the Crystal Reports 9 reports. Report Migration tool was used to migrate these mainframe reports and also for initial validation of the Business Objects report.
• Gathered the functional specifications for the financial reports needed for the business
• Gathered the technical specifications needed for Business Objects Reporting
• Designed the Business Objects Universe to enable reporting
• Created Universes, Webi reports, User groups, and assigned privileges at different Security levels using XI Administration Console (CMC).
• Created Web Intelligence financial reports by Section/Breaks and Calculating measures at different levels.
• Updated the prompt at the Universe level instead of hard coding the List of Values (LOV)
• Helped Analysts in validating financial reporting
• Designed summary tables for MTD, YTD, QTD aggregations on Webi reports.
• Linked financial reports to provide seamless integration of Year-over-Year, Month-over-Month, and Quarter-over-Quarter comparisons.
• Developed advanced financial reports such as Balance Sheets, Outstanding AP, AR Aging Report etc.,
• Developed Business Objects reports with multiple currency conversions to enable global deployment of the reports

Confidential

Business Objects Reporting Consultant

Responsibilities:

• This project required building an executive level and a regional sales level reports. The executive level reports contained rows of data comprising of the key performance indicators.
• BI requirements gathered based on the business needs
• Designed the executive and regional sales level reports
• Developed Webi and Crystal Reports; provided methods to drill through to reports from dashboards
• Provided feedback to business users on report’s design and recommended changes to make reports intuitive, flexible with increased performance
• Assessed possibilities to transform the canned reports into dashboards using application foundation
• Moved the Web Intelligence objects and dashboard from development environment to QA environment and to Production environment for final deployment.
• Developed three level information dashboard metrics and analytics from top-level dashboard view to the final drill down reports
• Created dimension slicing and securing the dimension slices to restrict access based on regions

Confidential

Customer Service Specialist II

Responsibilities:

• Assisted customer with inbound calls regarding their bank products.
• Sold additional bank products or services to existing and new customers.
• Trained fellow employees on sale techniques.

Confidential

Mortgage Counselor

Responsibilities:

• Assisted customer with finding the right mortgage product to meet their financial needs.

Confidential

Insurance Salesperson

Responsibilities:

• Provided additional insurance coverage to existing Confidential customers on bank products.
• Provided upgraded insurance on products bought through Confidential with partner retailers.