SUMMARY

• Business Intelligence and Analytics leader with demonstrated track record of envisioning and building innovative solutions in Data Visualization, Business intelligence and Analytics
• Over 12.7 years of experience delivering enterprise wide analytical and planning applications with both strategic and operational in nature. Drive Vision, Strategy, Technology and Roadmaps for Business Intelligence
• SAP Business Objects technology specialist strategically design, development, implementation, Installation, Upgrade, administration & configuration, migration and support including integration with databases and data warehouses, report and dashboard development
• Having 5 years Tableau experience with proficiency in design and development of Executive and Operational Dashboards as well as ad - hoc analysis, and experience in modeling and querying relational databases and Installation, deployment, clustering environment and security management in Tableau Server and Tableau Desktop/Reader
• Cloud environment set up and configuration for SAP BO, Tableau and SQL Server on Microsoft Azure and AWS (Amazon Web Services)
• Deep subject matter expertise in the design and development of Business Intelligence Solutions
• Business Analytics to support dashboard and reporting solutions for internal and external clients
• Working with Tableau, Tibco Spotfire, MS Power BI and other trending BI tools to assist in pre-sales activity
• End to end execution of number of Datawarehousing and business intelligence projects by selecting, blueprinting, gathering requirements, designing, and rolling out BI solutions to end users and to ensure BI availability through support functions and in-depth testing
• Managing and leading the project team, Developing and maintaining a detailed project plan, Recruiting project staff and consultants and Managing project deliverables in line with the project plan and working groups engaged in project work
• Demonstrated experience with industry leading BI tools such as SAP Business Objects, Crystal Reports, Tableau, SAP BI, QlikView and SpagoBI Suite
• Development of prototypes, Proof Of Concepts, perform tool evaluation and assessment
• Experience in Financial services, Banking, Health Care, Marketing & Product manufacturing
• Good knowledge on ETL and BI tools like Informatica, SAP BODS and SAP BI
• Experience in creating BI reports on Top of HANA DB and BEx reporting SAP BI
• Experience on creating Dashboards and Good conceptual knowledge of Tableau, QlikView and SpagoBI (Meta, Studio and Server)
• Expertisein sizing the BI Landscape with commanding knowledge on Web Servers (Tomcat/IIS/Web Sphere/Apache)
• Experience in SAP BODS like Installation of DS server (XI 3.2, XI 4.0) across platforms (Windows and Unix), IPS, Data Services Designer, Repository creation with different databases (Oracle, MySQL) and Registration of repositories (Local, Central and profiler)
• CMS configuration in Data Services using DS Management Console, Creation and configuration of Job Servers. Registration of Data Services in SAP systems RFC destination, User security management, Scheduling and execution of jobs
• An enthusiastic and project-oriented team player with solid communication, presentation, Analytical skills and the ability to develop creative solutions for challenging client needs
• Experienced in managing cross functional teams across different geographical locations. Highly proficient communicator, effective at managing relationships between strategic leadership, third party vendors and clients. Educate and train users/team, build teams across different geographical locations and nurture talent

TECHNICAL SKILLS

Business Intelligence: Business Objects Enterprise XI 4.x, 3.x, XI-R2 and 6.5, UDT, IDT, Web Intelligence, Desktop Intelligence, CMC, Import Wizard, Dashboard Design, LiveOffice, RCT, WRC, Mobile BI,UMT, Explorer, Lumira, Design Studio, QlikView, SpagoBI, MSBI, PowerBI, and Tableau 8.x, 9.x and 10.x

ETL Tools: Informatica, SAP BODS 4.0

DBMS: Oracle, MS SQL Server2012/2008, MySQL, MS-Access

GUI Tools: Crystal Reports 2013/2011/2008 , Toad, Microsoft Visual Studio

SAP: SAP BW BEx Query Designer, WAD, Analyzer

OS/Environment: Windows 2003/2008/2012/ XP, VM, Red-Hat Linux & Cloud Azure

Application Server: Tomcat, Web sphere 6, IIS and Web logic

PROFESSIONAL EXPERIENCE

Confidential, Newark (NJ)

Tableau Architect/ BI Manager

Environment: Tableau Desktop/Server 9.2/10.x, SAS, Teradata, Big Data Hadoop Hive, Oracle, Flatfiles, Windows 2008/2012 VM

Responsibilities:

• Provide the technical connection between project managers and developers by clearly communicating business functional issues to various levels of clients and Analytics staff
• Provides managers, directors, and stakeholders with routine progress updates. Maintains confidentiality of all sensitive business information at all times. Works with Analytics Business owners/partners and IT to implement system changes
• Expertise in Tableau administration activities like Installation, configuration, integration, upgrades, load balancing, capacity planning, troubleshooting, security implementation, user & group management, migration/promotion of content, and on-going maintenance
• Produce technical architectures, develop system requirements, identify resources, and estimate timelines for project completion
• Experience building and deploying Tableau dashboards for multiple teams in the Healthcare organization. Understanding of visual design principles; graphic design, layout, and color. Communicate abstract concepts verbally and visually
• Design, develop, and implement strategy for Tableau best practices and governance
• Leads efforts to analyze data sources to ensure data integrity, completeness, timeliness and accuracy. Implements identified efficiencies. Maintains working knowledge of reporting tools and establishes best practices within industry standards
• Manages and coordinates updates to Tableau licensure and adherence to license requirements. Administers user, user groups, and scheduled instances for reports
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Parameters, Calculated fields, Sets, Groups, etc.., in Tableau
• Developed various data connections from Horton works Hadoop/Hive, SAS Datasets, Teradata, Excel to Tableau Desktop for report and dashboard development
• Created action filters, scorecards using stack bars, bar graphs, scattered plots, geographical maps, Grantt charts using show me functionality, parameters and calculated sets for preparing dashboards and workbooks/sheets in Tableau

Confidential, Chicago (IL)

BI Architect

Environment: SAP BO XI 4.x, Crystal Reports, Tableau, SAP BW 7.x, BEx designer, WAD, QlikView, Dashboards, Lumira, Design Studio, Oracle, SQL SERVER, Windows, Linux

Responsibilities:

• Strategically design, implement, and support BI software and systems, including integration with databases and data warehouses, and report, dashboard development
• Expertise in Business Objects administration activities like Installation, configuration, integration, upgrades, load balancing, capacity planning, troubleshooting, security implementation, user & group management, migration/promotion of content, and on-going maintenance on various BI applications
• Examine and evaluate reporting requirements for various business units across the organization. Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for BO Universes and Reports
• Design and Development of Universes (UDT, IDT) and maintenance, enhancements to existing and creating Web Intelligence reports having multiple data providers and multiple universes
• Overall delivery Management, customer interfacing & Managing Stakeholder expectation
• Leading business requirements gathering & translation process to arrive at final dashboard & report structures. Solution architecting & delivery for data design, visualization and data integration
• Develop and Maintain Crystal Reports for Internal Report related needs as directed by management. Repair and Update existing reports as needed due to reported bugs or development changes. Evaluate each Report request, verifying whether the request may already be answered in another report, and estimating time for completion
• Dashboards development using Xcelsius/Dashboards and Design Studio applications
• Development of reports for SAP BW sources on SAP BO Analysis for OLAP, Office
• Design, development of BEx queries, Multi Providers, Analyzer and WAD reports
• Creation of visualizations, stories and cloud server using SAP Lumira
• Design, development and implementation of SAP HANA (Data Provision, Model and Reporting) in Business Objects. Experience in SAP HANA data modeling using views (Attribute, Analytical and Calculation) and data provisioning using replication server (SLT) from SAP ECC and SAP BODS
• Knowledge of HANA Administration, security user management, roles and privileges
• Security implementation, user/group management, BO servers maintenance, and authentication configuration (Enterprise, SAP, LDAP and Windows AD)
• Installation and configuration ofTableauServer, Worker and Desktop. Creation and maintenance of Tableau users, user groups, roles, assigning security on projects/sites and automation of Repository Backup and Mail notifications
• Creation of reports & dashboards in Tableau for OLTP & OLAP sources
• Published Workbooks by creating user filters so that only appropriate teams can view it
• Performance Optimization of dashboards and reports
• Preparation Test Case document, BRD and Technical design documents
• Acted as go-to person for the team for technical concerns and trained end users on Adhoc reporting techniques
• Tracking the project progress and working towards meeting the project specific deadlines consistently

Confidential

SAP BOBJ Specialist

Environment: SAP BO XI 4.0, SAP BODS 4.0, SAP BW 7.3, MySQL, Oracle9i, SQL SERVER, Mobile BI, Lumira

Responsibilities:

• Migrated of 3.1 reports to 4.0 using Upgrade Management Tool (UMT)
• Created of universe (Unx) on IDT using Relational connection with JCO connection
• Created of WebI reports using BEx OLAP connection (BICS connection)
• Created reports and dashboards for mobile devices like iPad, iPhone and Android
• Merged of Non-SAP and SAP objects at report level
• SSO authentication set up for SAP and LDAP
• Installed of SAP BODS server XI 4.0 (Unix), IPS, and Data Services Designer
• Repository created with different databases Oracle and My SQL
• Registration of repositories (Local, Central and profiler)
• CMS configuration in Data Services using DS Management Console
• Creation and configuration of Job Servers and Registration of Data Services in SAP systems, RFC destination
• User security management, Scheduling and execution of jobs
• Migrated of projects between local and central repositories
• Created Data stores for Oracle and SAP BW as source and SAP BW as target
• Created Flat File Format load the data into PSA
• Loaded the data in SAP BW from Oracle DB and Flat File

Confidential

SAP BOBJ Lead Consultant

Environment: SAP BO XI 4.0, SAP BW 7.3, SQL SERVER 2008, MSBI OLAP Cubes

Responsibilities:

• Installations of SAP BO XI 4.0 server and client tools
• Configurations for SAP BW and MS SQL Server
• Installation & configuration of BO Explorer, Dash Boards designer, CR 2011
• BO servers configurations, SSO authentication set up for SAP
• Data Federation set up for OLAP systems (SAP & Microsoft)
• Designed Universes (.Unv & .Unx) format
• Developed Web Intelligence reports & dashboards for HR, Sales, Finance OLAP cubes
• Information spaces developed and explorations created for SAP cubes based on .Unx
• Extensively worked on IDT (Information Design Tool) to design Universes for OLAP cubes (SAP & MS SQL), DF and Business Layers.
• Installation of HANA Studio HANA server
• Configuration of BO and BODS with HANA server
• BO Explorer configurations and exploration of HANA data
• ECC data movement to HANA tables using Data Services
• Connecting to an SAP HANA view/cubes and visualization of data using SAP Visual Intelligence (wide palette of graphical visuals)
• HANA server configurations and user rights management
• Deployment of war files on BOE server to host mobile applications
• Adding reports to mobile category to access them on mobile
• Installation of SAP BI app on IPAD, IPhone and Android devices
• Configuration of BOE server connections on the mobile devices

Confidential, Chicago (IL)

SAP BOBJ Consultant

Environment: Business Objects 3.1, BO Data Services 3.2, SQL Server 2008, Universe, WebI

Responsibilities:

• Participated in project planning sessions with project managers to analyze business requirements and outline the proposed solution.
• Installed all Business Objects Components:
• SAP BO Enterprise 3.1 SP3, Data Federator, BO Explorer, LiveOffice, Xcelsius 2008, Crystal Reports 2008 and SAP Integration Kit for SAP Solutions
• Group/ User Creation, Importing Users & Roles from SAP BI system and Assigned rights: User, Group and Folder & Application level
• Worked as Universe Designer, WebI & Crystal Reports, Xcelsius Dashboards developer
• SAP Data Services Installation, Configuration, Migration, repository and users creation
• SQL Server Installation, creation of databases and logins

Confidential

BOBJ Consultant

Environment: Business Objects, Informatica, Oracle 9i, SQL Server, J2EE, Windows 2000

Responsibilities:

• Requirement gathering, Impact Analysis for Reporting Stream
• Creating Thin Client (Web-I) & Thick Client (Desk-I) Reports according to the Client
• Modified all the existing Reports as per the major change took in the current system
• Extensively used Calculations, Sorting, Rank, and Drill and Formatting, changing displays and prompts while creating Business Objects Reports
• Macros have been written in order to mail and save the reports in specific shared folder to the Client through the Broadcast Agent
• Generated reports for Balance Sheet, Trial balance, General ledger, Income Statement, Capital Call, Chart of Accounts, Funds, Investors, Sponsors, Investment detail reports
• Design & implement schedule for various report categories like Interim, Final,Month end
• Involved in Unit Testing, Integration Testing
• Involved in Report Design Documentation and Universe Design Documentation
• Created Business Objects environments (repository) for testing
• Business Objects server administration & maintenance
• Repository moving/backup activities

Confidential, Mountain View (CA)

Universe Designer, Web Intelligence reports, Crystal Reports developer

Environment: BO XI-3.x, SAPBW (BEx query designer, Analyzer), Live Office, Crystal Reports

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
• Build the new Universes as per the user requirements by identifying the required Infocubes, Multiproviders from SAP BW by defining the universe connections
• Generated Reports using the universes as the main Data Provider and also using the personal data files provided by the users
• Created master BEx queries for orders and revenue and universes on top
• Created complex reports, Final week reports, YTD, Quarterly and Yearly reports
• Refreshing universe structure for adding of characteristics, key figures in BEx query and adding changed objects into query panel and doing changes to reports
• Provided security access management by creating users/groups, Folders and universes to make the data secure
• Created master queries for Orders, Revenue, Expenses, Remix and IBase with allow external access for OLAP enabled
• Created Universes by defining connections and retrieving data from SAP BW Infocubes.
• Extensively used calculations, Variables, Breaks, Sections, Filters and Prompts for creating Business Objects Reports
• Monitored and solved issues encountered in Universes and reports while migration to QA and tested before moving to production
• Used multiple data providers to get the exact data in reports by using merged dimensions and validated reports data with backend (SAP BW) data for all quarters
• Worked on reports using BEx Query, analyzer and Web Application Designer
• Created Exceptions, Variables, Structures, Restricted Key figures, and Calculated Key figures, Formulas in BEx, Queries, Filters, Free Characteristics, and Navigational attributes. Web templates, charts

Confidential

Business Objects Consultant

Environment: Business Objects 6.5/ XI-R2, RCT, Import Wizard and Oracle 9i, Windows 2003

Responsibilities:

• Creation of Multiple Universes based on requirement analysis
• Created different types of reports like tabular, master detail cross tab and Charts
• Installed Business Objects XIR2 Server with supported software and Service Packs
• Convert FC to WebI documents, Creating fresh WebI documents for Non-converted documents and modifying the partly converted
• Imported all Universe, documents, folders, users and groups from earlier version
• Recreated all problematic reports, Redefined all access privileges for all user accounts in CMC
• Monitoring the Production server to check the status of scheduled reports