SUMMARY:

• To work for an Organization which thinks forward & taking steps to adapt to the new Digital World & Grow their Businesses.
• Match International Standards in Functional & Technical Excellence and Quality.
• Seek further challenges and opportunities as a Data Analyst.
• Work with Industry Specific Solution Module to accumulate the Domain knowledge.
• 7+ Years of Industry experience in Financial Services - Cards/Payments & Insurance domain.
• Experience in working with multiple vendors and playing different roles from Developer to Team Lead & Onsite Coordinator.
• Experience in working on Business Intelligence & Data Warehousing Applications.
• Played various roles across the SDLC lifecycle of SAP Business Objects reporting solutions for leading financial services corporations best known for their capital solutions and credit cards businesses.
• Experience in Enterprise Reporting, Data Analysis.
• Proficient in analyzing and translating business requirements into technical specifications and design.
• Good team player, responsible and never back out on taking additional responsibilities or ownership at the need of the hour. Excellent interpersonal, communication and presentation skills along with time management.

DOMAIN & TECHNICAL EXPERTISE:

Domain: Cards, Payments, Insurance, Property and Casualty Insurance, Insurance- Claims & Policy Administration

Business Intelligence: Reporting, Data Warehousing

Tools: SAP Business Objects XI R3.1suite, SAP BOBI 4.2, Tableau, MicroStrategy, TOAD, Informatica

Business Objects Suite Tools: IDT, UDT, WEBI, DESKI, Crystal Reports, Designer, Report Conversion Tool, Report Migration Tool

Languages: SQL, PL/SQL, Java, Python

Operating System: UNIX, Windows

Databases: ORACLE 11g & 12c, Microsoft SQL Server 2008 R2

TOTAL WORK EXPERIENCE:

Confidential

Responsibilities:

• Closely working with the Business Analysts to create new BusinessObjects reports that provide insight into the business on different levels - Transaction Summary, Proposed Business Plan, Decline Analysis, Disputes, Authorizations, Pre-Authorizations for a large base of clients along with the maintenance of existing reports.
• Creation of Enterprise Reporting Solutions consisting of standard and ad-hoc reports as per the user requirement in Business Objects or by directly querying into the data warehouse using SQL.
• Participation in creation of dimensional data models for the data warehouse.
• Managing several different initiatives which require new and updated reporting with an emphasis on excellent customer service.
• Working with the quality analysts in checking and delivering reports for the data correctness and complying with various process standards.
• Manage and track Business Objects license usage, provide input for long-term licensing plans and license cost optimization resulting in quantitative savings for the client in annual BO license renewals.
• Report migrations using Import Wizard between DEV/UAT/PROD environments.
• Resolve SQL performance-related issues by tuning queries/optimization of reports.
• Design and manage security architecture, creation of users and user groups.
• Report Scheduling based on events/calendars and delivery to Users through various channels - SFT, BO Inbox, Email, Shared Drive. Creation of - Packages, Calendars, Events & Servers in CMC and releasing BO licenses.
• Raising and resolving issues through the SAP Support Portal. Trouble-shooting and bug fixing.
• Generation of License Keys through the SAP Support Portal, upgrade to the higher version of Service Pack, reinstallation of Business Objects and Client Tools.
• Resolving User Issues, Requirement elicitation, Business Impact Analysis, Incident & Change Management Capacity Management and Knowledge Management activities.
• Maintenance of SAP BusinessObjects environments/servers including Installation, configuration, patching, upgrades, monitoring, backups and managing.
• BO Tool Administration.
• User Manuals/Training Documents Creation on various SAP BO tools to educate/train Business Users.
• Data Visualization using Tableau.

Confidential

Responsibilities:

• Participated in conversion of DESKI reports to WEBI using Report Conversion Tool.
• Testing of converted reports for data integrity and granularity.
• Creating non-convertible reports from scratch in WEBI.
• Migration of converted reports from one environment to another using report migration tool.
• Maintaining a track of the converted reports in metrics.

Confidential

Responsibilities:

• Designing of Risk data mart dimensional model for risk department’s processes.
• Building the Risk Data Mart Universes for the risk reporting team under all the phases of SDLC.
• Mapping of data fields and creation of objects as per the requirement.
• Creation of WEBI template reports for the risk department and ad-hoc request reports.
• Worked on a Business Value Articulation project to add value to the client by performance tuning and architectural changes of the existing structure.
• Designed and implemented a new architecture for the flow of BO reports with the focus on data integrity.
• The project resulted in a total of $33K savings for the client.

Confidential

Responsibilities:

• An initiative taken on BO License Optimization which helped the client a cost avoidance of $12.5K.
• Coordinated with Server Admin Team to build Windows 2008 Server from scratch.
• BO, Oracle Client & Java Installations on new server.
• Configuration of CMS Database.
• Migration of all BO contents using Import Wizard Tool along with various Windows Tasks supporting various BO functionalities.
• Configured Tomcat for Confidential secure connection.
• Timely completion and deliverables helped client to avoid a penalty of 0.6 MN USD.

Confidential

Responsibilities:

• Parallel Installation Approach was followed to avoid procuring new servers resulting in Cost Saving.
• Generation of BO 4.2 License Key on SAP Support Portal.
• BusinessObjects 4.2 SP3 platform Installation on existing machines.
• Migrated the BO content (BIAR File) from existing deployment to new deployment in DEV using Upgradation Management Tool.
• Promoted/Imported the BO Content from new deployment in DEV to new deployment in QA and then in Production using Promotion Management.
• Configuration of CMS Database (Oracle 12c 64 Bit) and migrated Connections/Servers.
• Installation of BO 4.2 SP3 Client (32 Bit) and Oracle 10g (32 Bit) on Citrix Server and publishing BO Client Applications.
• Configured Tomcat for Confidential secure connection.

Confidential

Responsibilities:

• The project intended to add 10 additional currencies onto the US Market which opened wide Business opportunities. Multi-Currency is the option to conduct end-to-end payment process in a currency other than domestic’s currency.
• Relevant BO Universes and Reports modified to achieve this.
• SAP BusinessObjects Report Migration to MSTR Using Free-Form SQL Feature keeping data source as Oracle.
• Converted Multiple Complex SQL Queries of BO Reports into a Single Query for MSTR Free-Form SQL reporting.