EXPERIENCE SUMMARY:

• I am an Industrious Business Intelligence Professional with over 9 years of experience in Information Technology with SAP Business Objects, Tableau, Splunk, Alteryx, Power BI. Love to explore new BI tools perform proof of concepts and present ideas for the benefit of the business.
• Experience in various implementations of Business Intelligence technologies, processes for use in the Retail, Health, Government, Automobile, Insurance sectors. I am technically proficient in Business Analytics products from major software vendors SAP, Tableau, Alteryx, SAS, Microsoft, Oracle, Splunk, AWS Cloud and GCP.
• Highly effective business communicator with strong consultative and interpersonal skills; proven ability to collaboratively work with cross - functional leadership to identify gaps and opportunities, define solutions candidates, gain consensus and iteratively drive change.
• Quick learner of business applications, addressing the ad hoc reporting needs of the customer and the ability to work as an individual or as a team member to accomplish project deliverables on time to meet deadlines and work under pressure with strong analytical and solution approach skills
• Extensive experience in implementing Smart Monitoring And Smart Healing (SMASH) Framework which includes Core Metrics, End User Experience, in-depth Analysis, IT Operational Analytics, Self-Healing Mechanics and KPIs.
• Deep functional and logical expertise to recommend architecture and integration solutions related to BI products and helps to find interesting patterns by analyzing the contents/systems within an environment
• Very strong process/finite automation and monitoring capability of several BI tools spread across multiple systems. Build many cost-effective utilities to reduce manual effort.
• Developed Self-Heal and Alerting utility with various logical patterns and parameters on BO/Alteryx/Tableau which results in the elimination of production outages using Powershell, BO SDK, Java, HTML, JScript and Machine Learning.
• Expertise in administration and supervised the Business Objects (SAP BI) environment by Monitoring/Managing Servers, Users, Reports, Publications, Schedules, Security and all major standard activities.
• Expertise in Tableau upgrades from 8.0/9.0 to 10.4 and managed more than 15,000 tableau Users and 70 Applications. Expert in managing tableau servers, backup, restore and licenses.
• Expertise in building, sizing, Performance tuning, clustering, complex security structure of Business Objects and Tableau
• Expertise in working with all modules of Business Objects like Designer, IDT, Web Intelligence, Desktop Intelligence, CMC, CMS, UMT, Import Wizard, Promotion Management, Query Builder, Dashboard 4.1, Lumira, Design Studio
• Extensive Knowledge of Business Object Upgrade from legacy versions (XIR3/3.1/) to Newer versions (4.1/4.2) which includes a large amount of content migration (User personal reports, public report, report conversion)
• Very Strong experience in troubleshooting real-time issues in BO and Tableau including several levels of connectivity like Siteminder/OKTA, F5 Load Balancer, SAP Portal, DB2, Teradata, Hadoop, SQL Server, Salesforce, SAP HANA and external Java/.Net portal integration.
• Expertise in developing complex Confidential from scratch, through IDT and UDT which supports multiple levels of hierarchies and performing analysis on them by designing interesting reports through WEBI, Dashboards, Crystal Reports, Xcelsius and migrating to different environments
• Brainstorming and creation of various BO Reports, Tableau Visualizations, and Dashboard/Stories.
• Expertise in Splunk Dashboard development which includes BO/Tableau/Hadoop server health, Windows Server Resource utilization, real-time service monitoring/alerting.
• Designing is my passion, in leisure time I love to design websites, graphics, UX patterns, stop motion graphics and many more things. Being creative helps me in better data visualization and representation for valuable analysis.

TECHNICAL SKILLS:

BI Tools: SAP Business Objects 4.2/4.1/4.0/3.1 , Crystal Reports, Universe Designer(UDT), Information Design Tool(IDT), Desktop Intelligence, Web intelligence Rich client, Crystal Reports 2008/2016, Import Wizard, Xcelsius Dashboard 2008, SAP BI, Dashboard Designer, SAP Data Services 4.1, Lumira, Design Studio, Tableau 9.x/10.x

BO Administration Tools: Central Management Console (CMC), BI launch pad (formerly Infoview), Central Configuration Manager (CCM), UMT, Promotion Management (Import Wizard), BI Cockpit

Data Analysis: SAP BusinessObjects, Tableau, SAS, Microsoft Power BI, Splunk, Alteryx

Data Engineering: MySQL, Oracle, SQL Server, MS ACCESS, PostgreSQL, DB2, SAP HANA, Hadoop, Teradata

Programming Languages: SQL, PL/SQL, JAVA, HTML5, CSS3, Powershell, Jscript.

Operating systems: Windows Server 2000/03/08/10/12/16 , Linux Suse.

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, OH

Data Engineer & Sr. Business Intelligence Consultant

Responsibilities:

• Managed large scale Business Objects/Tableau/Alteryx/power BI/SAS/Teradata environments which includes 300+ servers, 200,000+ Users (Internal/External), 500,000+ BO Reports, 8000+ Workbooks and 5000+ Schedules. Supported Various locations in Philippines, China, Canada, and USA.
• Supported various internal and external applications like OrderExpress, Acute Medical, Patient Recovery System, Inventory Management, Customer Intelligence, Nuclear Pharmacy, Spend Analytics, Procurement, Supplier Data Management, Quality and Regulatory, Supply Chain, Cordis, Parmed, Fuse, Sales and Marketing, Specialty Pharmaceutical Services (SPS), Clinical Operations, Cardinal Reporting Canada.
• Managed servers, Users, User and group security, access levels, scheduling of reports, instances, universe, connection and all major modules which help to run business objects system.
• Maintaining report and universe standard developed by application teams in development and Performed migration of objects like Webi reports, Crystal Reports and Confidential across all landscapes
• Worked on CMC, CCM, UDT, IDT, UMT and all other major BO BI modules.
• Troubleshooting various issues related to end-user workbooks/reports, universe, DB connectivity, BO/Tableau servers’ connectivity and other SAP BO/Tableau platform issues.
• Worked on SAP HANA, Dashboard and SAP Business Objects Explorer.
• Managed sync of all authentication standards with BO like LDAP, SAP, Enterprise and Window AD.
• Worked on Upgrade of 3.1 to 4.0, 4.0 to 4.1. 4.1 to 4.2 along with fix packs and worked on post-migration platform issues and business user’s queries.
• Developed tableau visualizations for Sales/Inventory applications and created BO Audit dashboards on Tableau.
• Worked on Tableau server upgrade from 8.0/9.0 to 10.x and handled DR process very well. Effectively worked on Tableau Sizing, Backup and Restore process.
• Closely worked with Tableau support on product issues reported by various business users and tableau server or desktop.
• Worked on tableau server tuning and performance management of workbooks and server.
• Configured and upgrade Alteryx Server and administered workflows/Users/DB Connections.
• Good knowledge of SAS Administration.
• Worked on AWS Cloud and Google Cloud Platform for Business Objects/Tableau compatibility.
• Worked on SAP DataService Administration including access, repository creation, Remote Function Call (RFC) connection and troubleshooting on Data Services issues.
• Developed Monitoring portal using HTML/CSS/JScript for Business Objects and Tableau to show real-time health of systems and usage. Provided Self Served capabilities to business users to download audit data from the same portal.
• Developed Self-Healing utility to monitor every single business objects services and servers in cluster. It is capable to heal/start any affected windows service (SIA, Tomcat, CMS) and CMC servers. Utility will detect CMS and Tomcat nodes in cluster automatically start monitoring it.
• Developed BICC BOT (on Skype) which takes care of repetitive task (like User creation, FAQs) and trigger health check/healing utilities if required. It engages admins in case of the approval process.
• Developed many monitoring dashboards on Splunk for Hadoop Job/Bundles, Tableau and BO server and CMC service monitoring.
• Developed real-time status dashboard on Splunk to display system resource utilization and user/job activities on TV.
• Developed PowerShell monitoring scripts for IGNIO (Digitate Tool) Orderflow Automation Tool.
• Developed knowledge base portal and Issue logs for an internal team which is needed to support large audience and landscapes. They can search, and act based on the use cases feed.
• Developed run books for all landscapes which includes complete information and architecture of every environment. This will help for a new member to refer and perform operations while troubleshooting anything.
• Enabled Microsoft Teams and SharePoint within the team to track tasks and conversation on troubleshooting/handover.
• Developed Service Now Boards to keep track of OLAs/SLAs/Incidents/Change Request and Personal Tasks.

Environment: SAP Business object 3.1, BO BI 4.0/4.1/4.2, SAP Data Service 4.1, Information Steward, Tableau 9.x/10.x, Crystal Reports 2008/10/13, Lumira, Design Studio, Alteryx, SAS, Teradata, Wily Interscope, SAS, Dashboard 4.1, Explorer 4.1, Splunk, Microsoft Power BI, Powershell, SAP HANA, Service Now

Sr. Business Intelligence Consultant

Confidential, Richmond, VA

Responsibilities:

• Installed and Configured Clustered Business Objects BOXI 3.1, BI4.0 Completed Suite on Windows/ Linux/Unix Servers.
• Installed/Configured Mobile in BOXI 3.1 and BI4.0
• Configured LDAP and SAP HANA SSO for Business Objects BI4.0
• Migrated Large number of universe, reports, Dashboards from BOXI3.1 and BI4.0 using UMT.
• Integrated Business Objects with SAP BW/BI with Portal Integration kit.
• Created Complex Access and security level as per business requirements.
• Create Probes to Monitor BI4 Services.
• Configured Adaptive Processing Service, Adaptive Job Services, DSL bridge Service etc.
• Extensively worked with Upgrade Management tool, promotion Management tools, version Management.
• Converted Deski reports to Webi Reports using Report Conversion Tool.
• Maintained Users and Groups Security by creating LDAP groups and attaching it the folders on the Enterprise.
• Tested and implemented SMTP email and FTP scheduling feature in Business Objects. Responsible to make sure Email, FTP, Business Objects Inbox and Unmanaged Disk options of scheduling are always up and running.
• Supported Business Objects Complete suite 24/7 and worked extensively.
• Designed universe based on Data Federator concept which connects data from multiple data sources.
• Created reports using SAP BI cubes and based on the Data Federator Universe according to the Business Requirements.
• Having significant knowledge working with SAP BW Info Cubes, Multi Cubes, and Info Objects.
• Involved in creation of Universe using BW cubes and created reports using the BW Universe.
• Created classes and objects and logically grouped them together and defined business names for the classes and objects
• Configured Voyager connections in CMC and developed voyager workspaces in Info view using cube as a data source.
• Creating data flow diagrams, functional specifications, technical specifications, security requirements and other related project management documents.
• Participated in project planning sessions with project managers, business analysts and team members to evaluate business requirements and outline the proposed solution
• Created Technical Specifications Documents based on requirements from stakeholders.
• Participated in developing the Relational Model (Logical & Physical) and in the documentation of technical methods of development as well as business related information regarding the design process.
• Created complex Webi/Crystal reports, Cross-Tab and Master-Detail reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerter's and other features.
• Extensively used Crystal Xcelsius for creating Dashboards, Scorecards, and reports.
• Imported/ Exported the Confidential from/to repository to make them accessible to end-users.
• Published POC on Information Steward and Data Federation in TCS Portal.

Environment: BOXI R3, SAP Business object 3.1, BO BI 4.0, InfoView, CMC, Web Intelligence, Crystal Reports 2008, Informatica powercenter 9.x, Oracle PL/SQL, UNIX Shell Script, Apworks, SQL Server 2008, Live Office, Data Federator, HP Ticketing Tool.

BO Developer

Confidential, Richmond, VA

Responsibilities:

• Understanding business requirement and design ERD.
• Use SQL query to create Tables, Triggers, Sequences and procedures.
• 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.
• Creating Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Confidential using BO 3.1
• Creating reports prototypes using Web Intelligence for user presentation.
• Extensively used Alerts and Filters in reports
• Resolved loops using contexts and aliases to remove the cyclic dependencies.
• Coordinated and resolved Data Quality issues for a smooth migration to production/maintenance of Reports to the different environment within the organization.
• Creating Informatica Mappings and Workflows to load data in Relational tables (In Development, Stage and production environment) by applying several transformations.
• Testing mappings and fixing the error by applying PRESQL or POSTSQL or formulas or transformations. E.g. update strategies, joiner, expressions, lookup, normalizer etc.
• Creating Universe by using same tables in universe designer (In Development and later migrate into stage and production environment)
• Testing universe and fixing all issues by apply proper joins, loop and context if required.
• Creating BO reports in Web Intelligence as per business requirement (In Development and later migrate into stage and production environment)
• Testing BO reports on regular basis and fixing issues like formatting, alignment, filters, sections, breaks, alerter and several formulas to meet up business requirement.

Environment: SAP Business object 3.1, InfoView, CMC, Web Intelligence, Crystal Reports 2008, Informatica powercenter 9.x, Oracle PL/SQL, UNIX Shell Script

Confidential

Web Developer and UX Designer

Responsibilities:

• Designed User Interface (UI) layout and assets for use in multiple GUIs
• Conduct user research and feedback which involves stockholders Interview, Analysis, Research, Paper sketches, Wireframe design, Mock-up design, Interactive prototype, Functional prototype, Development, Testing, End user feedback, Team coordination
• Brainstorming and create interactive mock-ups for better user experience
• Involved in design review sessions with project teams, acquiring consensus and getting approvals on user flows, wireframes, visual designs and documentation from internal and external stake holder
• Heuristic Evaluation and Low/High Fidelity Wireframe
• Data Gathering and Usability Testing
• Information Architecture Navigation flow, Site Map

Environment: PHP, XML, HTML5, CSS3, JavaScript, JQuery, Adobe Photoshop, UI/UX Design: Visual Design, Andriod App Design, Web App Design, TypoGraphy, Illustrations, Sketching, Prototyping