We provide IT Staff Augmentation Services!

Sr. Tableau Bi Analyst Resume

New York, NY

SUMMARY:

  • Over 11 years of rich experience in Information Technology with complete Life Cycle Implementations in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence , Database Platforms , Operational databases , Enterprise Data Warehouses , data marts, Data Mining, Data Modeling, Transformation and Loading Methodologies, Reporting Tools, OLAP tools & environments with strong analytical skills of structured methodology for reporting / BI design, specification and development.
  • Strong planning & organizing with demonstrated ability to gather Business Requirements and prepared Business Requirements Document (BRD), System Requirements Specifications (SRS), System Design Specifications (SDS) and functional requirements by working with the client, IT staff and project managers. Also developed Requirements Traceability Matrix (RTM) in order to help the stakeholders to know the progress of the project, and also have successful track record in large - scale with two full life cycle global implementations.
  • Extensive experience in Tableau Enterprise Environment including Tableau Development as well as Administration involves technical support, troubleshooting, report design and monitoring of system usage & publishing and presenting dashboards on web and desktop platforms.
  • Expertise in doing the RCA (Root Cause Analysis) and resolving performance bottlenecks and enhance for optimization in the back end & front end.
  • Hands on Experience in Configuring and Administrating Tableau Server sites, projects, publishing and refreshing tableau extracts.
  • Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports & also experienced in taking back ups and restoration of Tableau repository.
  • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
  • Expertise in Business Intelligence tools predominantly on SAP Business Objects suite - working with 4.1/ 4.0/XI 3.1/3.0/XIR2/R1/6.x (BI Launch Pad 4.1/4.0 (Info View), Web Intelligence (Interactive Analysis 4.1/4.0), Universe Design Tool, Information Design Tool, Dashboard Design 4.1/4.0 (Xcelsius), Lumira, Analytics Design Studio, QaaWS, Live Office, Explorer, Widgets, Publications, Import Wizard, Desktop Intelligence & Crystal Reports) & SAP BO Mobile 4.3.0 handheld external services .
  • Expertise in modules of SAP BI Business Objects products of Central Configuration Manager (CCM), Central Management Server (CMS), Central Management Console (CMC), Promotion Management, Monitoring, Upgrade Management Tool (UMT), Life Cycle Manager (LCM) & Clustering tools.
  • Hands on experience in HANA modeling, experience in creating schemas, table definitions, creating Attribute views, analytical views and calculated views and also created Universe (IDT) against HANA Database.
  • Experience in using IBM Cognos BI 8 & 7 suites of tools includes Report Studio, Query Studio, Analysis Studio, Power Play, Impromptu Web Reports.
  • Knowledge in Data Warehouse applications, directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse using various ETL tools.
  • Good knowledge of Data Warehousing Models, Concepts, Data marts, RDBMS concepts, using Star Schema, Snowflake Schemas and Multi-Dimensional Models for faster & effective Querying.
  • Good exposure in working with Relational Databases SAP HANA, Hadoop, SQL Server, PL/SQL, Oracle, Sybase, Teradata, DB2 & other Databases.
  • Diversified experience in implementation of Business Objects with multiple domains encompasses in a wide range of Finance, Banking, Insurance, Oil & Gas, DOT, Entertainment, Investment Management, Automobile & Food sectors.
  • Willingness to work under stringent deadlines with strong analytical and problem-solving skills coupled with excellent written, verbal and Inter-personal Communication skills with ability to interact with end-users, managers and technical personnel.

TECHNICAL SKILLS:

OLAP/BI Tools: SAP BI 4.1/4.0, BO XIR3.1/XIR3, XIR2/6.x/5.x Suite (Enterprise Server products suite), CMC, CMS, Upgrade Management Tool, Monitoring, Clustering, Promotion Management, LCM, Information Design Tool (Data Foundation & Business Layer), Universe Design Tool (UDT), BI Launch Pad, Lumira, Analytics Design Studio, Analysis Office, Live Office, Web Intelligence Rich Client Interactive Analysis (Java & HTML), QaaWS, Dashboards (Xcelsius 2008), Publications, Import Wizard, Infoview, Business View Manager, Crystal Enterprise XIR2/10/9.0, BEx Suite, IBM Cognos 8.4

Visualization Tools: Tableau Desktop 10.4/10.2/9.3/8 .2/8.1/7 , Tableau Server 10.4/10.2/9.3/8

Security: Active Directory Server, Netegrity Site minder, Netscape LDAP Server.

Modeling: Erwin, Visio, Framework Manager 8.4.

SAP Modules: SAP ECC 6.0, BW 7.5/3.4, BI 7.0, ERP R/3 (4.7) FICO, SD & MM.

ETL Tools: Informatica Power Mart 9.2/8.5/4.6/4.1/5.1 , SAP BODS 4.2, 4.1, 3.0Abinitio1.15, Alteryx 11.5

Operating Systems: Windows 98, Windows2003 and Windows NT, XP, AIX, UNIX.

Databases: SAP BW 7.0/3.5, HANA 1.4, Oracle 11g, 10g, 8i/9i, SQL Server 2014/12/08/05 MS-Access, DB2 V6, Sybase IQ, Green Plum 4.0, Teradata V2, Siebel CRM 8.1/7.7, Hadoop 2.0

Languages: C, C++, HTML, XML, Java, JavaScript, Visual Basic, TOAD 10.0/ 9.6/9.0.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Tableau BI Analyst

Responsibilities:

  • Involved in Sprint Planning, Daily Scrums, Sprint Reviews and Retrospective Meetings & Interacted with Business Analysts, clients. Internal stakeholders and team members to analyze business requirements and outlines proposed solutions and plan milestones in the research, development, and implementation phases of the project lifecycle.
  • Involved to analyze the gaps (Gap Analysis) between Keystone and Symantec SAP ECC system to load the data through ETL and creating Views/Tables in the SQL Server for fine-tuned SQL Queries for maximum efficiency and performance based on the logic of Custom, Analytical, Transactional and Sales data for reporting purpose.
  • Worked with ETL & DB team for designing & process of work flows in Alteryx designer and consumed those queries in Tableau desktop through WDC by connecting to Alteryx server.
  • Involved in generating Data migrating trending reports using Tableau by identifying the dimensions, measures, measure values & level of details for Business Analytics & Top Executives to give an overview current Trends.
  • Identified new metrics and enhanced the existing KPI's, and used Custom SQL for complex data pulls and replicated those Custom SQL query joins onto Tableau to connect to various data sources.
  • Designed, developed and implemented BI solutions for Air Travel Ticketing, Credit Card, Hotel and Customer KPIs (Key Performance Indicators) for top level management & provided visualizations for Miscellaneous, Travelling expenses through Stack bars, bar graphs, scattered plots and Gantt charts.
  • Used Tableau Desktop to create key dashboards to help to translate raw data into visualizations for stakeholders and clients.
  • Created action filters, parameters and calculated fields, sets and dynamic parameter controls for preparing dashboards and worksheets in Tableau that allowed end users to understand the data.
  • Consolidated multiple Tableau workbooks into single work book for Tableau report central and Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
  • Scheduled extract refresh for weekly and monthly reports and worked on workbook Permissions, Ownerships and User filters.
  • Responsible in enhancing the existing Reports and pdf’s, creating reports using Tableau desktop.
  • Involved in administrating and managing Tableau servers, troubleshooting user issues with respect to user management, access rights, authorization, content publishing, extract failures and performance.
  • Improved Reports performance with strong analytical and troubleshooting skills for quick issues resolving in large-scale production environments located globally.
  • Using GIT process for final deployments on all environments and provided end user training on the navigation of Tableau dashboards to know the story of their data.
  • Participated in daily stand-ups with clients on daily design and development effort and Interacted with offshore technology teams in various locations on a regular basis for deliverables.

Skills Utilized: Tableau Server & Desktop 10.4, Hadoop Hive 1.2, UNIX 7.0, MS SQL Server 2014, PL/SQL, Java, J2EE, SAP ECC 6.0, SAP BW 7.5, SAP BODS 4.2/4.1, Alteryx 11.5

Confidential, New Jersey, NJ

Sr. BI Reporting Analyst

Responsibilities:

  • Work with the business users in gathering the project specifications by conducting user requirements gathering sessions and workshops.
  • Analyzing the requirements and technical specifications by partnering with Business Analysts to develop the reports that conform to the enterprise standards.
  • Involved in all Agile-Scrum meetings like standup meetings, Sprint planning and Sprint review and retrospective meetings.
  • Involved in Tableau server upgrade plan & in Utilized the JavaScript API to create a customized portal for the Vehicle management group.
  • Lead the technology solutions team and directly Interface with them about the development & progress and take effective decisions for better solutions.
  • Evaluated requests and coordinate with data and Tableau site owners to deliver optimal configurations and solutions that meet customer needs, security and product capabilities.
  • Design/lead/develop prototypes for business solutions (dimensional models, model builds) so that business users may visually understand and explore a new feature or functionality before implementation to expose design assumptions and drive ideation.
  • Ensured prototypes meet the organization standards to allow transfer to production.
  • Built dashboards with floating objects and capitalizing the various dashboard actions features like URL, images, web integrations.
  • Assisted product end users and site content administrators with site administration activities including configuration of data connections and sources, user access administration, site projects, workbooks and software functionality.
  • Involved in analyzing & reviewing business requirements, extract data from multiple data sources for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Exported SAP BO report output into excel and provided data visualizations in Tableau by using that excel sources for some User groups.
  • Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Involved in Custom Geo-Coding; by creating a .CSV file and assigning geographic roles to fields not recognized by tableau.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Responsible for creating and setting privileges on Users/User Groups.
  • Involved in gathering and analyzing business requirements from the client.
  • Worked on SAP BO 4.0, designed, developed and managed Universes in Information designing tool (IDT) which include creating data foundation, business layer based on ad-hoc requirement which caters several business units.
  • Being part of Ramp up for BO 4.0 and HANA 1.4, have worked extensively in testing the existing features as well as new features and implementing the same.
  • Designed and Implemented Confidential CORE UNIVERSE on SAP HANA to provide integrated ad-hoc solution via BO 4.0.
  • Worked with Universe designer to design, develop and implement universe for the Enterprise data warehouse.
  • Created BICS connections using IDT tool on different Info provides, Data targets and Bex Queries.
  • Created most of the reports based on Open Document, Summary row time period would display in the Details navigation.
  • Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create reports.
  • Generated Reports using the Universe(s) as the main Data provider and also using the personal data files provided by the users.
  • Implemented Security features of Business Objects like row level, object level and report level to make the data secure.
  • Created Monthly and Quarterly Breakdowns, Complaint handling Reports.
  • Designed dashboard Visualizations using Design Studio by connecting to a Live data source (an Analytical view using SAP HANA Studio) to generate dashboards based on KPI to measure the growth rate of business for Super Users.
  • Created Webi reports for operational and dashboards with Bex queries developed on BW 7.4 on HANA.
  • Created Complex Deski reports using Free-Hand SQL with multiple data providers as well as against Universe(s) combination.
  • Extensively used Variables, User security scripts in free-hand sql for Deski Reports also used calculation contexts, applying almost every available formatting feature, ranking, sorting, breaks, prompts, sub-queries, data tracking, Alerters, creating complex formulas, projecting charts, cross tab reports, drill down reports, Merging dimensions, various WEBI functions such as "User response", "NO filter", "Drill filter", "Force merge", "Prompt summary", "Running count" etc.
  • Has been part of Ramp up team for migrating content from SAP BO 4.0 to 4.1.

Skills Utilized: Tableau Server 10.2/9.1/8.3/7 , Tableau Desktop 10.2/9.1/8.3/7 , SAP Business Objects XI 4.1, 4.0 & 3.1, SAP HANA 1.4, HANA Information modeler, SAP BI 7.0,7.3, BEX Query Analyzer, UDT, IDT, BI Launch Pad, Web Intelligence, Infoview, Lumira 1.25, Design Studio 1.0, Desk Top Intelligence, Oracle 10g, Data Services, Informatica Power Center 9.2,, Hadoop Hive, UNIX, MS SQL Server 2014/12, PL/SQL, Java,J2EE.

Confidential, Baltimore, MD

Sr. Business Intelligence Developer

Responsibilities:

  • Designed and delivered seminar to introduce a team to Agile Work principles, practices and disciplines in an interactive fashion that assists in teambuilding and finding ways to apply Agile Work to existing problems.
  • Interacted with Business Analysts, Business Users and Managers in gathering business requirements for Reports.
  • Administered user, user groups, and scheduled instances for reports in Tableau server and documented upgrade plan from Tableau 6.x to Tableau 7.x.
  • Worked on Tableau Dashboards in Tableau 8.1 and 7.1, Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
  • Responsible for creating Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
  • Performed ad-hoc analysis that helps in understanding business and performance trends. Interpret the results and weave insightful stories to stakeholders
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Created report schedules on Tableau server & created incremental refreshes for data sources on Tableau server.
  • Implemented Row level security for the reports to be able to restrict data related to a particular retailer who logged in.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Written queries to retrieve data from Oracle database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
  • Wrote custom SQL’s using Oracle for some parts of the reports by getting data using queries and then implementing them in the reports.
  • Involved in Migration from current system BOXI R3 to BI 4.0 by using upgrade management tool on 2 phases and also converted some Universes from Unv to Unx.
  • Created scripts and provided screen shots for major tools like Live Office, BI Launch Pad, UMT, IDT, UDT, WEBI, Explorer, Mobile, Monitoring, Clustering tools functionality and also provided documentation in share point for user reference.
  • Created documentation on Promotion Management (previously LCM) and moved some Connection, Universes and Reports from the existing CMC sandbox to old CMC sand box.
  • Created test scripts based on BOE tools, client applications and also external devices.
  • Tested these test scripts on daily basis using Administration rights and put the valid tested scripts in share point portal for users’ reference.
  • Created an Information Design Tool from scratch, maintained and updated ‘Data Foundations’ & ‘Business Layer’ for the GDPM Application, based on Logical Model, linked other Database which has Employee & Department Names table’s information, by Data Foundation in Information Design Tool, by creating multisource Relations Connections, for the information using Business Objects XIR4.0.
  • Created joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
  • Created Custom and Cascading List of Values (LOVs) for better understanding of prompts by the end users.
  • Detected/resolved data Cardinalities and loops, checked integrity of ‘Data Foundation’s in ‘Information Design Tool’.
  • Based on User request, disabled LOVs for some columns & maintained Date format for some specific Time Change Objects.
  • Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
  • Used @functions (@select, @where, @prompt) to create predefined conditions and prompts to filter the data and for dynamic user selection.
  • Edited Joins, resolved the loops using aliases and contexts in the Data Foundation & Business Layer in Information Design Tool and exported to repository.
  • Created Dimension, Measure & Detail Objects that are needed for reporting following the business usability.
  • By using IDT, Created OLAP Universes on SAP data (info cubes/BEx queries) also involved in working with SAP BW 7.3 upgrade issues as well as discussed some issues in team meetings and resolved with the help of suggestions.
  • Aggregated most the objects which are related to measures in the universe.
  • Created most of the reports based on Open Document, Summary row time period would display in the Details navigation.
  • Created financial reports, which are displaying the results on revenues where all subsidy amounts are hyperlinked in the summary level, which are providing zone wise information in the Details reports.
  • Created Detail design documents for all the Reports, Data Foundations & Business Layer.
  • Created different types of reports such as Master/Detail, Cross Tab and Chart, use of Filters, Conditions and Calculations, setup alerts, ranking, graphs, and report level variables.
  • Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web Intelligence Rich Client (Interactive Analysis).
  • Created various SQL and PL/SQL scripts for verification of the required Functionalities.
  • Prepared and documented the technical documents, requirement specifications, design document, project planning, change history & also writing training materials helpful for end users and coordinating users in both onsite & offshore & gave 24/7 Production Support.

Skills Utilized: Tableau Server 8.1/ 7.0.1/6. x, Tableau Desktop 8.1/ 7.0.1/6. x, SAP BI 4.0, (Web Intelligence Rich Client, BI Launch Pad, Information Design Tool (Data Foundation & Business Layer), Business Objects XI 3.1, Universe Design Tool, Live Office, Promotion Management, Upgrade Management Tool, Mobile), SAP BW 3.5, HANA 1.0, BI7.0, ECC 6.0, BEx Analyzer, Lumira 1.17, Informatica Power Center 8.6, Windows 2003, Netezza, Oracle 11g, MS Office, SQL Server 2005, DB Visualizer.

Confidential, New York, NY

Sr. BI Reporting Developer

Responsibilities:

  • Created documents like Business Requirements Specification, Technical Requirements Specification, Universe Design Document and Report Maintenance Document.
  • Designed and developed complete universe by creating joins, contexts, aliases, hierarchies, classes and sub-classes.
  • Provided Business Objects Universe design changes to address performance, usability and data reliability issues.
  • Followed Best Practices throughout the project for complete life cycle in designing the Universe, Reports & Dashboard.
  • Worked with Project Manager, Business users and other developers in creating mock ups beginning from excel report designs till the complete design and development of the Web Intelligence reports about Departed Employee information on Sensitive & Non-Sensitive information.
  • Created complex reports by linking objects from different data providers and using Merge Dimension Option.
  • Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Used breaks for white spaces and sections for better navigability.
  • Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
  • Used different components like list box, list views, Bar charts, filters, Combo box, Pie charts and stacked column charts.
  • Extensively used Drill down capabilities and report linking from summary to detail reports.
  • Involved in Security setup of the Report folders and user groups restrictions with BO admin.
  • Unit tested Web Intelligence reports before pushing them to complete testing phase and wrote complete report specs.
  • Trained End Users about Business Objects SAP BI 4.0 about new features like BI Launch Pad how it improves user interface and additional options for interface customization.
  • Involved in Tableau server and documented upgrade plan from Tableau 6.0 to Tableau 6.1.
  • Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
  • Published the dashboard reports to Tableau Server for navigating the developed dashboards in web.
  • Involved in Scheduled the published dashboards from Tableau Server on weekly basis.
  • Produce complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
  • Created relationship between two different Data Source’s by using Data- blending.
  • Trained on 4.0 about Dashboard Design formerly Xcelsius about direct data binding of charts and selectors, universe connectivity components & new dashboard design objects.
  • Fixed issues found during testing and actively involved in meetings with business users for UAT approval.

Skills Utilized: SAP BI 4.0, Business Objects XI 3.1/XI R2, Web Intelligence, Rich Client, Xcelsius 2008, Central Management Console (CMC), Central Configuration Manager (CCM), Tableau Server 6.1/6.0, Tableau Desktop 6.1/6.0, Informatica Power Center 8.5, Oracle 11g, SQL plus, PL/SQL, Toad, SQL Developer, Unix Shell script, UNIX, Business View Manager, Microsoft Share point, Microsoft Excel, Microsoft Access.

Confidential, Orlando, FL

Sr. Business Objects Developer

Responsibilities:

  • Prepared the following Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
  • Created Functional Requirement Document (FRD) and technical specifications for universe and reports.
  • Involved with Development team for Migration of SAP Business Objects from XIR2 to XIR3 version and also involved in CMC to provide the User Security settings and Creating User groups in Rich Client 3.1.
  • Created 4 Universes (Activity, Account, Contact & Opportunity); resolved Loops & traps using Contexts & Aliases and Implemented Aggregate awareness.
  • Provided SD functional support for business users and resolved issues requiring system and procedural enhancements.
  • Configured Shipping Points, Shipping Conditions and Shipping Point Determination.
  • Defined cardinalities, Performed Check integrity, Resolved Loops by creating aliases and contexts to remove the cyclic dependencies.
  • Defined and created dimension objects, conditions, user and measure objects to capture complex formulae.
  • Created joins, cardinalities between tables applying contexts and alias tables.
  • Developing detailed technical specifications for application administration on a shared inter agency server environment; developing a solution for managing and maintaining BI metadata.
  • Designed, Developed and Maintained Universes for supporting Ad-hoc and canned reports.
  • Performed the migration of all the Content & Resources from Source to Destination repository using Import Wizard. Created Web Intelligence Reports (canned & Ad-hoc) that include functionality like Sections, breaks, Grouping, Sorting, Drill-down, Variables and Slice and Dice using Universes & SQL as Data Providers.
  • Scheduled & Publication Web Intelligence reports and Events in Infoview.
  • Involved with Business Users one to one session of all Reports and pointed to defects log for any formatting issues, data issues and any other changes or performances issues and validated Reports.
  • Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes. Trained the End users on the Ad Hoc reporting and on navigating the Business Objects tool.

Skills Utilized: SAP Business Objects XI 3.1 (Web Intelligence Rich Client, Infoview, Designer, Import Wizard), SAP R/3 4.7 SD & MM, Siebel CRM 8.1/7.7, Oracle 10g, SAP BODS 3.5, Toad9.6, AIX, XML 1.0, Windows 2000, MS Office.

Confidential, Tampa, Fl

Sr. Business Intelligence Analyst

Responsibilities:

  • Prepared the following Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
  • Designed and delivered seminar to introduce a team to Agile Work principles, practices and disciplines in an interactive fashion that assists in teambuilding and finding ways to apply Agile Work to existing problems.
  • Created user groups and managed access privileges, using SAP Business Objects CMC.
  • Worked on the Migration of Reports and Universe from 6.5 to XIR2.
  • Implemented best practices in report design and universe creation in XI 3.1.
  • Designed, Developed and Managed Universe in SAP Business Objects Designer for generating the Pay roll reports for Sales & Admn, Expense Reports & Marketing Reports, Missing Mapping Data for marketing group users & Expense Management.
  • Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
  • Created and maintained complex universes supporting multiple levels of hierarchies for drill down and drill access reports in XI 3.1.
  • Analyzed different data connectivities that can be used in connection to BOBJ Enterprise like QaaWS, Live Office, BI Web Services, BI Widgets and Business View Manager.
  • Developed Web Intelligence Documents through Web Intelligence Rich Client by using Universe as a source through local server.
  • Suggested different options to modify the dashboards which had performance issues and prepared a Gap analysis to explain the client on the standards.
  • Created Analytics and Dashboards using SAP BO Xcelsius to enable executives track progress and compare current and historical performance against established targets.
  • Implemented Row level security based on the data access to North America, EMEA, Latin America, Asia Pacific User group.
  • Involved in technical and business analysis aspects of BW data warehouse project development, creation of test plans and scenarios, testing, and implementation; including significant hands-on work.
  • Worked on Multi-source data integration in one report to provide a flexible, data warehouse neutral solution enabling easy access to SAP BW data.
  • Handled Embedded Functions like @ Aggregate Aware, @ Prompt, @ Select and @ Where in the Designer to handle User requests for report generators.
  • Involved in Bug fixing for the reports testing using Mercury Quality Centre.
  • Involved in Production Support 24/7 for Business Objects end users in both Onsite & offshore.
  • Conducted Training and Provided Training Materials to Business Users.
  • Stepped into some business as usual functions within the department due to an unexpected employee leave, to provide Cognos reports relating to expense report data to global Internal Citi compliance, financial and business customers. This also includes report design, test script creation, UAT and End user training for BAW Expansion department.
  • Interacted with Business Users, gathering documents understanding their Data Modeling and Developed Cognos Reports in Query Studio, Report Studio & Analysis Studios.
  • Developed Complex Reports, Chart Reports, List Reports & Cross-tab Reports using Report Studio. Used Manually Modified SQL in Report Studio to write complicated reports. Used subsets to write union, intersection and joins in Report Studio.
  • Created and maintained Cognos jobs for Latam, North America, EMEA, Asia and other Reporting Groups.
  • Created Cognos Library for Report Listing to users to run Reports easily, as per the Report schedules like Daily, Weekly & Monthly.
  • Writing procedure documents for both of the above job functions and developing a report library of over 300+ COGNOS reports to ensure cross-functional training of other department employees/contractors.
  • Involved in performance tuning of the reports with different ways of Threshold testing.
  • Provided Knowledge transfer, to Functional team & users in both onsite & off shore & done various other duties as are assigned.

Skills Utilized: SAP Business Objects XI 3.1, XIR2/6.5 (Web Intelligence Rich Client, Infoview, Designer), Cognos 8.4, Framework Manager 8.4, Green Plum 4.0, Oracle 10g, SAP R/3 FICO, SAP BW 3.5, BEx Query Designer, Teradata V2R5.1, Abinitio 1.15, People Soft 8.9, Xcelsius 2008, SQL Server 2008, Sybase IQ, AIX, XML 1.0, Windows 2003, MS Office.

Confidential, Austin, Tx

Sr. Business Objects Developer

Responsibilities:

  • Interacted with Business Users and Business owners in Gathering, Analyzing and Documenting Business requirements, Functional requirements and Data specifications to develop/modify Business Objects Universes and Reports.
  • Installation of SAP BO XIR3 SP2 Client and Configuration of the BO Enterprise on QA and PROD servers against firewall for the Universe Designer.
  • Used Report Conversion Tool to migrate Business Objects documents version 6.x to Web Intelligence documents.
  • Worked on with Migration of SAP Business Objects from XIR2 to XIR3 version.
  • Customized existing reports for presentations using Cross-Tab reports.
  • Developed Hierarchies for the users to Drill down reports by Region, Business unit, Plant, Suppliers and Profit Centers.
  • Created Multiple Universes and resolved loops by creating Contexts and Aliases and also resolved Chasm traps and Fan trap problems.
  • Involved in Adding of new Objects to the existing Universe as per end users request.
  • Prompts were used in reports as well as at the Universe level to create interactive reports for the users.
  • Extensively worked with Ranks, Alerts, Filters, Variables and Calculations while designing reports.
  • Provided object level and row level security for different users to maintain data availability.
  • Developed ad-hoc and complex WEBI reports for Web intelligence users using Web Intelligence.
  • Developed Confidential Reports for generating the Income statements for their Distributors.
  • Scheduled Reports for the End users, Business users and Customers using Broadcast Agent.
  • Involved in trained Business users on Technical and Functional.

Skills Utilized: SAP Business Objects XIR3, XIR2/6.5 (Web Intelligence, Desktop Intelligence, Infoview, Designer, CMC), Microsoft SQL Server 2008/05, Oracle 9i, Data Integrator XI 3.0, Unix, Toad9.0, Teradata V2R5, ERwin 4.0, Windows 2003

Confidential, New York, NY

Sr. Business Objects Consultant

Responsibilities:

  • Extensively worked with the end users to gather the reporting requirements.
  • Created complex technical documentation for the business requirements.
  • Created complex sales reports in SAP Business Objects including complex cross tab, summary reports.
  • Extensively used formulas, variables, prompts, Alerts based on Universes.
  • Created universes and resolved loops and Traps by table aliases and contexts.
  • Involved in Upgradation of reports from SAP Business Objects 6i to Business Objects XIR2.
  • Involved in supporting the UAT team during Upgrade of reports from SAP Business Objects 6i to Business Objects XIR2.
  • Created Confidential reports, Ad-hoc reports, Complex charts and Drill down Reports using Business Objects XIR2.
  • Created Ad-hoc reports using SAP Business Objects functionalities like Cross Tab, Master Detail and Formulas, Alerts, Slice and Dice, Drill Down @Functions.
  • Created interactive Dashboards and Business Presentations on Xcelsius by importing data from Excel sheets.
  • Test/Debug Business Objects Universe enhancements/modifications in Designer to include new objects, updated tables and joins.
  • Analyzed the underlying data in view of its table structure, relationships, joins and cardinality.
  • Actively participated in various team meetings & Involved in Unit testing and documentation and training for end-users.

Skills Utilized: SAP Business Objects XIR2, 6.5 (Supervisor, CMC, Import Wizard, Designer, Reporter, Web Intelligence, Broadcast Agent, Info view), Crystal Reports XIR2, Xcelsius v4.5, Data Stage 8.5, DB Artisan, Visual Basic 6.0, DB2, Oracle 9i, XML 1.0, UNIX, Win NT.

Hire Now