SUMMARY

• SAP BI/BOBJ Consultant with 5 years of experience in information technology, with knowledge in complete lifecycle of software products involving Analysis, Design, Development, Implementation, Testing and Support for various data warehousing applications including experience in using DSS/OLAP (Data Warehousing) tools i.e. SAP BI/BOBJ XI 3.1, BOBJ 4.0 - 4.2, Web Intelligence/ BI launch pad.
• 3 years’ experience in Tableau Dashboards in latest Design and Presentation.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• Over 5 years of Experience in Designing, Administration, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web-based Applications and Databases and Experience in industries such asRetail, Financial, Accounting, Distribution, Logistics, Inventory, Manufacturing, Marketing, Services, Networking and Engineering.
• Around 3 years of experience In SAP Business One Module
• ERP software experience with SAP Business One
• Worked with Clients to identify and resolve business problems, gaps, and implementation issues. I have been involved in functional solutions that includes, gap analysis, setups, test script and documentation
• Business requirements gathering, GAP Analysis, Test Plan Preparation, Unit testing, Functional Architecture, System Integration Testing, and UAT, proficient in implementation and setups.
• Configured the application based on solution design, performed gap analysis and designed workaround solutions.
• Refined planning and organizational skills that balance work, team support, and responsibilities in a timely and professional manner.
• Performance tuning, testing, migrating to production and post-production support.
• Knowledge in Native HANA hands-on development experience with PL/SQL. Creating SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views)
• Proven ability to work in cross-functional teams with high sense of ownership and strong customer focus.
• Strong knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, security management and production support in BI.
• Experience with Data Warehouse concepts, and methodologies, as well as strong knowledge with star schema and snowflake schema data models.
• Experienced using BEx Query Designer.
• Extensively worked on designing and developing complex universes with multiple fact tables and several hundreds of objects as per the universe design best practices.
• Universe development experience on Oracle 9i/10g/11g/12c and MS SQL Server 2008/2012/2014.
• Competent in handling all levels of data warehouse life cycle, including requirements gathering, analysis, preparing business specifications, designing technical specifications, and system requirement specifications.

TECHNICAL SKILLS

Reporting Tools: Business Objects 4.1/4.2, Tableau Desktop, and Server 9.0 - 10.3, Web Intelligence 3.x - 4.2, Crystal Report 2008,2011, Xcelsius 2008, Dashboard, BEX Query Designer, BEX Analyzer, Performance Management and Business View Manager, Tableau 10, SSRS

Web Servers: IIS 6.0/5.0, Apache Tomcat 5.0.27/4.1, Web Logic 8.0 and Web Sphere

ETL Tool: Business Objects Data Services 4.1, SSIS

Operating Systems: Windows 10/8.1/ 7/Vista/XP/2000/98, MS-DOS, UNIX, Solaris, Linux

Database: Oracle 12c/11g/10g/9i, MS SQL Server 2008, 2012,, DB2, Toad 8.5 graphical inter phase, SQL Developer

Languages: C++, C#, SQL, JAVA SDK, ASP.Net, TSQL, PL / SQL, HTML5, Python, JavaScripting

IDE & Packages: Brackets, Visual Studio 2017/2010/2008, Eclipse

Corporate Training: SAP Business Object 4.1 & SAP HANA 1.0 SPS04

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, Wisconsin

SAP Business Objects Developer

Responsibilities:

• Gathering Requirements, Drafting specifications, Design, Development, User Acceptance Testing, and Production Roll Over.
• Created dashboards for analyzing POS data using Tableau 8.0 on top of SAP HANA.
• Developed dashboards for POS use cases to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting, and cannibalization.
• Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps, and Symbol Maps, Pareto charts according to deliverable specifications.
• Extensively worked on different types of filters.
• Expert level capability in table calculations and applying complex, compound calculations to large, complex big data sets
• Used trend lines extensively for correlating different KPI's for new product launches.
• Created custom Function's Date range, Time functions, Logical functions in the reports.
• Scheduled extract refresh and subscriptions for weekly and monthly reports.
• Integrated Tableau dashboards into internal web portal using JavaScript API.
• Worked on administration tasks like adding workbook Permissions, Ownerships and User filters.
• Consistently attended meetings with the client subject matter experts to understand functional business requirements.
• Provided user trainings on the key dashboards
• Provided detailed documentation on the Analytical deliverables
• Used Industry standard design templets for POS use case analysis.
• Submitted all projects by or ahead of deadlines.
• Involved in Administration of Business Objects and building of Data Repository.
• Created new Business Objects Users and User Groups using Business Objects CMC Module.
• Maintained user security on the BO Reports, Folders and Universes.
• Created different categories to simplify it to the users to locate the reports.
• Maintained and applied patches to Development, UAT and Production Servers to keep them in sync.
• Created complex universe level objects and measures using the business rules provided.
• Created Complex Views to overcome loops and contexts.
• Derived Tables, Aggregate & Index Awareness were used in Universes.
• Created Web intelligence reports and deployed through BI Launch Pad and Customized Webi Front end.
• Various Business Object reporting functionalities were used such as Slice and Dice, Master/detail, User Response function and different formulas.
• Performed data validation and analyzed test results.
• Used scheduler to run recursive reports Daily, Weekly, monthly as requested by the end users and stores the output in their inboxes.
• Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the Data using Crystal XI.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Generate KPI for customer satisfaction survey results and disease management.
• Maintained Test log and Wrote test Evaluation, Summary Reports.
• Extensively involved in doing user acceptance testing (UAT).
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.

Environment: SAP BOBJ Enterprise XI 3.1 SP3/ SAP Business Objects Business Intelligence 4.0, BI Launch Pad (Info View), Web Intelligence, Crystal Reports 2008, Xcelsius 2008 SP3, QaaWS, Live Office, Import Wizard, Oracle 10g,SQL,PL/SQL. SAP Hana

Confidential, Indianapolis, IN

SAP Business Objects Consultant

Responsibilities:

• Used SAP Business Objects to build universe and reports.
• Developed universe for the Sales and Marketing Department to Analyze Sales and enable Marketing Team to make informed decisions.
• Consulted with business clients, creating Tableau dashboard reports, collaborating with developer teams, using data visualization tools, there were numerous 'As-Is' and 'To-Be' conditions.
• Involved in creating database objects such as tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Full project life cycle (requirement gathering to implementation phase).
• Consulting with business clients, creating Tableau dashboard reports, collaborating with developer teams, using data visualization tools, and using the Tableau platform to create business intelligence visualizations
• Managed existing and new projects.
• Linked reports in Business Objects Developed complex reports. Prepared the following - Business/Technical Requirements, Design Templates, Development Standards documents, and Detailed Design documents.
• Created user groups and managed access privileges using Business Objects CMC.
• Responsible for Business Objects repository and Web intelligence maintenance and tuning.
• Extensively used Designer to design various universes for different business groups. Created complex reports using cascading prompts, decode objects etc.
• Customized Business Objects web interface (intranet) to access the enterprise reports.
• Developed various Charts, Graphs and drill down reports
• Extensively used Toad to verify if the data pulled by the report is correct compared to the database data and also to verify if the joins used in designing the universe are correct.
• Generated Custom variables, groups and formulas in Business Objects.
• Generated Reports on different data sources such as Business Objects Universes, Stored Procedures etc
• Worked on User/System report documentation, user training, and testing developed reports for final deployment.
• Worked on creating groups, conditions, filters ranking in reports
• Scheduled the weekly, monthly, quarterly reports using business objects
• Worked on improving performance of reports with aggregate aware and using indexed columns in reports.
• Build a Dashboard using Xcelsius 2008 for Business analysis.
• Made use of flash variables to link Master detail dashboard.
• Created users and groups in CMC.
• Created folders and granted rights for the different user groups.
• Primary support for installation of SAP Business One software and add-on products on client servers and PC’s
• Primary support for report writing, software configurations, forms development and queries development
• Primary support for data transfers and integration deployments onsite at client locations

Environment: SAP BI/BO Enterprise I 4.1 SP2, BI Launch Pad, Web Intelligence, Design Studio 1.3, SAP Design Dashboard 4.1, BW 7.4, UDT-IDT SAP Business Objects 4.1/4.0/3.1/3.0/ XI R1/R2/6.5.1/6.1 Web Intelligence/ Launch pad/ Info view, Information Design tool, Universe Designer, Explorer, SAP Lumira, Crystal, Xcelsius 4.5/2008, Broadcast Agent, Auditor, Application Foundation 5.x, Live Office, QAAWS, BI 7.0, 7.3, BEX Query Analyzer, Tableau

Confidential, Cincinnati, OH

Business Objects Developer

Responsibilities:

• Gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes Webi, Tableau, and Crystal Reports.
• Involved in designing Universe and migrating existing Desktop Intelligence (Deski) Reports to Web Intelligence (Webi) report.
• Set up the security levels to the users in universe module like row level and object level security.
• Designed and developed the Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe.
• Architected and developed financial dashboards (Variance Price Exchange, Daily Sales, Profit and Loss) using best dashboard design practices.
• Created shell script to automate Business Objects Reports since Business Objects Enterprise warehouse is running on UNIX.
• Created the BW BEx queries and OLAP Universes on top of the BEx Queries and then generated reports in Web Intelligence
• Worked closely with the project leadership team to document schedules, resource requirements, business requirements, test strategy, and plans for data migration, Involved in migration of reports from BO 6.5 to BO XIR3, Migrated universes, reports and security domain from 6.5 to BO XIR3 Using Import Wizard, Resolved several issues with installation, designing, reporting and migration.
• Used BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Created dashboard reports on ROI, actual and plan cost analysis, profit analysis on operating concern level and profit center level.

Environment: SAP BI/BO Enterprise I 4.1 SP2, BI Launch Pad, Web Intelligence, Design Studio 1.3, SAP Design Dashboard 4.1, BW 7.4, UDT-IDT SAP Business Objects 4.1/4.0/3.1/3.0/ XI R1/R2/6.5.1/6.1 Web Intelligence/ Launch pad/ Info view, Information Design tool, Universe Designer, Explorer, SAP Lumira, Crystal, Xcelsius 4.5/2008, Broadcast Agent, Auditor, Application Foundation 5.x, Live Office, QAAWS, BI 7.0, 7.3, BEX Query Analyzer, Tableau.

Confidential, Deerfield, IL

SAP BI Consultant

Responsibilities:

• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Problem resolution and status updating to the Onsite co-coordinator
• Involved in the installation of Business Objects suite, creating the Repository, creating Users, User Groups and assigned privileges to the users using Supervisor.
• Developed the stored procedures to increase the system performance.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Designed and developed universe for report generation.
• Resolved the loops, traps, cardinalities, contexts and checked the Integrity of the Universes.
• Exported the universe to the Repository to make resources available to the users
• Created user defined objects including dimensions and measures for complex financial calculations.
• Used @Functions such as @Prompt to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports.
• Enhanced reports which included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Prepared user documentation for hands on training of end user community.

Confidential, Chicago, IL

Customer Service Call Center Associate

Responsibilities:

• An unwavering commitment to customer service, with the ability to build productive relationships, resolves complex issues, and wins customer loyalty.
• Strategic-relationship/partnership-building skills -- listen attentively, solve problems creatively, and use tact and diplomacy to find common ground and achieve win-win outcomes.
• Resolve issues related to patient heart monitor by remotely accessing their device.
• Setting up Baseline patient.
• Managing technical accuracy in receiving patient data through cell phone monitoring.
• Handle customer inquiries, complaints, and extension/service requests.
• Calm angry callers, repair trust, locate resources for problem resolution and design best-option solutions.
• Provide support to our patients from hook up through the end of service.
• Walking them through the process of putting on the heart monitor, explaining the device and its care throughout the patient’s service.
• Focus on providing proactive support to ensure that the patient receives the ultimate gold standard experience throughout the duration of their service.
• Extracting and exporting patient data to appropriate channels.
• Corrected mobile device transmission issues.
• Installations and upgrades.
• Effectively resolved technical and non-technical issues through effective communication.
• Provided computer help desk support and technical training on hardware/software to end users.
• Documented problems/resolutions, and provided overall assistance in daily administration.