SUMMARY

• Overall, 7 years of experience in various capacities as a Business Objects Developer.
• Possess excellent problem solving, organizational, and communication skills.
• Expert in understanding clients’ needs and requirements through interacting with data analysts and end - users.
• Proficient in design and develop processes utilizing best standards.
• Have excellent presenting capabilities, confidence when presenting technology to customers or to a group of analysts.
• 3 years’ experience in Tableau and Qlikview Dashboards in latest Design and Presentation.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate teh data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
• SAP BI/BOBJ Consultant with 7 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 me.e. SAP BI/BOBJ XI 3.1, BOBJ 4.1, Web Intelligence/ BI launch pad.
• Over 5 years of Experience in Designing, Administration, Analysis, Management in teh Business Intelligence Data warehousing, Client Server Technologies, Web-based Applications and Databases and Experience in industries such as Retail, 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. me have been involved in functional solutions dat 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 teh application based on solution design, performed gap analysis and designed workaround solutions.
• Refined planning and organizational skills dat 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 teh 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

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

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++, SQL, JAVA SDK, ASP.Net, TSQL, PL / SQL, HTML5, Python

IDE & Packages: SQL Navigator, Visual Studio 2010/2008, Eclipse, share point, MS Office, Excel & Visio

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, Wisconsin

SAP Business Objects Developer

Responsibilities:

• Gathering Requirements, Drafting specifications, Design, Development, User Acceptance Testing, and Production Roll Over.
• Developed Qlikview Load Scripts for distribution across multiple data sources.
• Designed and maintained Qlikview applications.
• Managed all new and some existing projects.
• Maintained user guides for Qlikview applications.
• Provided ongoing Qlikview implementation and support.
• Outlined new features of Qlikview for clients.
• 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 teh BO Reports, Folders and Universes.
• Created different categories to simplify it to teh users to locate teh reports.
• Maintained and applied patches to Development, UAT and Production Servers to keep them in sync.
• Created complex universe level objects and measures using teh 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 teh end users and stores teh output in their inboxes.
• Extensively involved in creating Parameters and Record Selection Formulas to allow teh users to filter teh 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 stake holders, gathering requirements and managing teh 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 teh test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Created Test Scripts, Test hierarchy to represent teh features and functionality dat need to be test in teh application.
• Analyzed user and business requirements attended periodic meetings for changes in teh application requirements and documents.
• Performed Parallel Testing or Production Testing, which ensures dat teh new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in teh User Acceptance Warranty Testing. Involved in doing security and negative testing of teh application.

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.

Confidential, Indianapolis, IN

SAP Business Objects Consultant

Responsibilities:

• Used SAP Business Objects to build universe and reports.
• Developed universe for teh 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 teh Tableau platform to create business intelligence visualizations
• Developed and maintained QlikView Load Scripts across multiple data sources.
• Designed, created, and maintained QlikView applications.
• Identified data sources and prepared data for Qlikview applications.
• Managed existing and new projects.
• Linked reports in Business Objects Developed complex reports. Prepared teh following - Business/Technical Requirements, Design Templates, Development Standards document 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 teh enterprise reports.
• Developed various Charts, Graphs and drill down reports
• Extensively used Toad to verify if teh data pulled by teh report is correct compared to teh database data and also to verify if teh joins used in designing teh 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 teh 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 teh 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
• Assist with sales demonstrations for software prospects

Environment: SAP BI/BO Enterprise me 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

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 teh security levels to teh users in universe module like row level and object level security.
• Designed and developed teh Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of teh tables and structures of teh 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 teh BW BEx queries and OLAP Universes on top of teh BEx Queries and then generated reports in Web Intelligence
• Worked closely with teh 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 teh 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 centre level.

Environment: SAP BI/BO Enterprise me 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, OH

SAP BI Consultant

Responsibilities:

• Analyzed teh existing database and designed teh Universes using Business Objects Designer Module.
• Problem resolution and status updating to teh Onsite co-coordinator
• Involved in teh installation of Business Objects suite, creating teh Repository, creating Users, User Groups and assigned privileges to teh users using Supervisor.
• Developed teh stored procedures to increase teh system performance.
• Involved in re-designing or customizing teh existing Views and Stored Procedures to suit teh reporting needs.
• Designed and developed universe for report generation.
• Resolved teh loops, traps, cardinalities, contexts and checked teh Integrity of teh Universes.
• Exported teh universe to teh Repository to make resources available to teh 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 teh select statement of another object, @Variable- to restrict teh 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 teh 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 teh end of service.
• Walking them through teh process of putting on teh heart monitor, explaining teh device and its care throughout teh patient’s service.
• Focus on providing proactive support to ensure dat teh patient receives teh ultimate glod standard experience throughout teh 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 halp desk support and technical training on hardware/software to end users.
• Documented problems/resolutions, and provided overall assistance in daily administration.

Environment: BusinessObjects 6.5.1(Designer, Web Intelligence, Info View, Broadcast Agent), Oracle 9i, PL/SQL, DB2, Crystal Xcelsius Pro v4.5, SQL Server 2000, Windows NT/XP Professional.