SUMMARY

• Possess Strong analytical knowledge of BI, Data warehousing and Business Objects XI 4.1, SAP Lumira 1.27, QlikView 11.2 and Tableau 10.1/10.0/9.0
• Possess 12 years of experience in the field of Information technology across all aspects of the SDLC
• Experience with the ability to create, sustain and manage customer relationships
• Business know - how of Banking, Finance and Risk Treasury Markets, Retail Market, Comm. & Media Domain
• Team Leading experience with task assignment and management.

PROFESSIONAL EXPERIENCE

Confidential

Associate Manager

Technology Stack: SAP Business Objects 4.1, Lumira 1.27, Tableau 9.0, QlikView 11.2, DWH, Project Management

Responsibilities:

• Responsible for end-to-end SAP BOBJ, Lumira, QlikView and Tableau Report/Dashboards RFP support, Estimations, POC and POVs
• Provide technical SME support on SAP Business Objects 4.1, Lumira 1.27, QlikView 11.2 and Tableau 9.0
• Responsible to design and develop the QlikView 11.2 dashboard estimations with client functional manuals
• Responsible to provide dashboard prototype with business specification sand client expectations and demo those POCs
• Provide POVs for the client business requirements for the created POCs
• Handled client meet and responsible to provide solutions to their questionnaires, requirement know-how, feasibility details etc.
• Responsible to walk through the dashboard RFPs, POCs to the business users
• Provide business trainings, arrange Knowledge transitions to different projects on AP BO XI 4.1, SAP Lumira, Tableau, QlikView and QlikSense
• Act as a SME lead to business client to understand their requirement, best possible solution options, performance practices etc.
• Support projects on resourcing (FTE) based out of the efforts calculated
• Kept eye on technological up grade/new features for asset creation and act as a mentor to encourage team members to participate in value and people development

Confidential

Team Lead

Technology Stack: SAP BO XI 4.1 (WebI Reporting& Dashboard 4.1), Tableau 8.0, Oracle-PL/SQL, DWH, Project Management

Responsibilities:

• Responsible for end-to-end BOBJ, Tableau report/dashboards estimations, Dev, Migration, Perform Tuning and mentoring the team.
• Provide technical SME support on SAP BO XI 4.0 (Architect)
• Responsible to design and develop the Tableau 8.0 dashboard with their script Implementation
• Act as an onshore coordinator to setup client and offshore on delivery expectations.
• Responsible for phase release call and walk through to business users.
• Handle Weekly status and Change phase calls with Business users.
• Lead "BRS Service C2S Support" model and tracks Issues, SLAs and User Escalations. Decide Issue Priorities.

Confidential

Team Lead

Tools: Tableau 8.0 ( Dashboard)

Responsibilities:

• Requirement gathering, Analysis and Design from the client.
• Provided SME support: Dashboard estimations, Team KT session.
• Tableau environment setup and its usage know-how.
• Confidential is a British multinational pharmaceutical, biologics, vaccines and consumer healthcare company headquartered in Brentford, London. It is the world's fourth-largest pharmaceutical company after Pfizer, Novartis and Sanofi, measured by 2009 prescription drug sales. The company was established in 2000 by the merger of Glaxo Wellcome plc and SmithKline Beecham plc
• Dashboard estimations, Requirement gathering, Analysis and Design.
• Work on dashboard Technical feasible solution.
• Coding, assisting team in technical issues and demo to the Client.
• QlikView dashboard development across desktop/laptop with iPad resolution.
• Responsible for end-to-end BOBJ & Tableau dashboard Dev., Migration, Perform. Tuning and mentoring the team.
• Provide technical SME support on SAP BO XI 4.0 (Architect), provides estimates
• Responsible to design and develop the QlikView 11.2 dashboards.
• Data analysis & modeling., conceptualizing, designing and development of tableau reports and Dashboard.
• Worked on POC which involves Dashboard creation using advance graphs using heat map. Symbol map, scatter maps, bullet charts & word cloud for conveying information regarding resource utilization and budgets planning matrix
• Has worked on performance tuning of dashboard using TDE, incremental extracts, parameters and calculation
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Handle Daily status update with Onshore team

Confidential

Team Lead

Responsibilities:

• Lead a team from India on Business Objects working from offshore.
• Creation of Technical Documents through active coordination with Client team.
• Creation of Physical/logical Data Model for Business Objects Universe creation and Informatica, as per the TD/FD created.
• Responsibilities to design and build of Universes, Classes and Objects.
• Responsibilities to create reports logic synchronized with universe.
• Responsible for data matching for the reports with the Magma BI MIS.
• Responsible to review and unit test the Universe.
• Responsible to specify the report format using Infoview.
• Responsible to generate BIAR file using Import Wizard.
• Responsible to implement row level and role based security in the universe and CMC respectively.
• Early Warning Reporting Module is being developed to generate Exception Reports for the Credit Department to track the facilities and their utilization. This allows the department to take remedial actions early to minimize non­payments. Applications constituted of Java as a front end, Oracle as a database and reporting with BO XI R2.
• Responsible to design and build of Universes, Classes and Objects.
• Responsible to created Universes by retrieving the data from various data sources, defining the connections necessary.
• Responsible to create Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Responsible to develop complex universes by using advanced features in Business Objects like Aggregate Aware, hyper linking and prompts.
• Created User Prompts, Conditions and Filters to improve the report generation
• Create database views for Web Intelligence Reports on both India and Hong Kong universes like PAN Portfolio Report, Watch List and CCR Memo etc.
• Responsible for developing universe for India & Hong Kong.
• Keep and monitor the universe design to reduce response time.
• Responsible for exporting & importing universes, creating the reports in WebI using Infoview as per client requirements.

Confidential

Responsibilities:

• Responsible to review and unit test the Universe.
• Responsible to specify the report format using Infoview.
• Responsible to generate BIAR file using Import Wizard.
• Handling BO Administration for Servers, Users (Rights) using Central Management Console. Handled Clustering of the servers.
• Responsible for Migration from Trestel Source system to Intellect Source system for CIBRT application
• Responsible for Autosys modifications to support Trestel and Intellect Source system
• Responsible for data migration in the database with handoffs file, XML & format files
• Responsible to Create Hermes Package for database stored procedure, table & views
• Responsible to develop universe, exporting & importing universes, creating the reports in WebI using Infoview as per client requirements
• Responsible for preparing requirement/ technical specification for project using NIKU-Clarity.
• Coding, preparing a unit test plan with test cases and testing the code in the development and quality servers.
• Code analysis & review with SQL query in TOAD