We provide IT Staff Augmentation Services!

Bi Solution Architect/global Operation Manager Resume

5.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Total IT Exp: 17 years, BI Architect/Manager 5 years.
  • 6 Years on in SAP/SAP BW. 2.6 Year Experience on SAP HANA
  • 10+ Years’ in Confidential warehousing (BO 5.x to SAP BI 4.2, Informatica with RDBMS and SAP/SAPBW/SAP HANA)
  • Working knowledge on latest BI tools - Tableau, BI 4.2 applications (Lumira, Design Studio etc.. connecting BW and HANA)
  • Developed Reporting application with BO Mobile and iPad
  • Exposure to deliver projects using AGILE Methodologies. Certified Scrum Master From Scrum Alliance.
  • Exposure to Project management, RFE Proposal, Estimation and SOW preparation,
  • Exposure to manage project delivery for Development, Enhancement and maintenance.
  • Proven ability to build strong relationships with clients and staff using negotiating talent, persuasion and demonstrated commitment.
  • Exceptional problem solving skills in complex highly integrated Confidential warehousing environments.
  • Exposure to simplify and streamline the business processes using technology transparent to the business.
  • Clients worked with: Honeywell, Confidential, Standard & Poor’s, Confidential and Confidential

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/XP/ Unix

Databases: Teradata/ Oracle 9i/SQL Server/ Sybase and SAP/SAP BI and Sap HANA

Agile Tools/CRM: Rally, Version One and Remedy CRM tools

Web Related: ASP.NET and ASP with java and VB Scripts

Tools: & Utilities: SAP BIBO 4.2, SAP Design Studio 1.6 & Lumira 2.0, Web I, SAP Hana Studio 1.2

Domain Knowledge: Health Care/ Retail/Finance/Manufacturing

PROFESSIONAL EXPERIENCE

Confidential

BI Solution Architect/Global Operation manager

Source: SAP BW 7/SAP HANA and SAP

DWH Tools: BEX, Web I, BO Explorer Xcelcius, BO Advanced Analysis, SAP Design Studio, BI Mobile, Sap Lumira and Tableau

OS/Hardware: Windows, LINUX

Responsibilities:

  • Architect/Program Manager SAP/Non SAP Analytic Application for Honeywell.
  • ROI Study (Investment vs Long Term Benefit), Identify the Improvements, Benefit/Risk Analysis and Planning/Requirement Design.
  • Project Estimation and SOW Milestones preparation and Responsible for Delivery of SAP/SAP BI and SAP HANA Reporting Solution.
  • Global Operation Manager for BI Analytics Application across the Globe.
  • Build, Enhance and support of Tableau, Web I and Explorer Reports for ACS/AERO and TS Applications.
  • Lumira, Design Studio Dashboard for Cost Center, OES profitability and One P&L Dashboards. Custom Web I report to enhance the ROI for US Vacation and Proto Production Reports
  • SAP BO Mobile Solution integrated with OneView Web portal
  • Responsible for setting up BI Confidential Administration/Development Environment
  • Delivery of Best Practices of in Business Intelligence System for Honeywell TS.
  • Demo/Training of Business Objects Capabilities with SAP/BI/HANA and non-SAP Sources.
  • Conduct Weekly Status meeting with Stake holders.
  • Train Confidential resources for BO reports using the SAP BI as Back end.
  • Conducting Interviews to select the best from the market.

Confidential

Project Manager

DWH Tools: Informatica 8.x & 9.x, ORACLE PL/SQL, Autosys, SAP BW

Languages: Unix Shell Script, Autosys

OS/Hardware: Intel Pentium 4/ Windows XP and Unix

Responsibilities:

  • Responsible for delivering the IE and Other Feeds ETL Migration project.
  • Work Allocation and Time estimates
  • Accountable for ETL design and architecture
  • Responsible to clarify the technical queries from Offshore to onsite
  • Project Plan shared with onsite with status on weekly basis
  • Weekly Status Meeting with Customer
  • Conducting the induction for new resource to the team
  • Resource management and periodically inform the resource pool to the account manager

Confidential

Team Lead

Source: Oracle 9i, 10G, SQL Server 2000, Files (Text, xls and XML)

DWH Tools: Informatica 8.x, BO XI R3, BO 6.5 and 6.1 (Full client and WebI Reports) ORACLE PL/SQL

Languages VBA macros: and Unix Shell Script, ASP with VB and Java Script

OS/Hardware: Intel Pentium 4/ Windows XP and Unix

Responsibilities:

  • Delivering EU Revenue Regulatory Compliance BO Apps for S&P EMEA Clients.
  • Delivered Covered bond Monitoring (CBM) BO Apps for S&P EMEA Clients.
  • Delivered Frequent Issuance Fee System (FIFS) MIS Applications (1 Oracle package, 1 Informatica Work flow, 1 Universe and 15 WebI Reports BOXI Reports) for UK.
  • Delivered FI RACE Application (Risk analysis tool based on BASEL II Standard)
  • Delivered CDO SROC Press release reports (1 Informatica Workflow, 1 Oracle package, 1 Universe and 6 Full client 6.5 Reports) for UK and US.
  • Delivered All Confidential XML Applications (2 Informatica Workflow and two 6.1 reports with enhancement on existing universe.
  • Delivered Migration of CDO SROC and Structured Finance application from BO 6.5 to BOXI R3.
  • Planning, Designing, Executing and delivering of production support by following Agile methodology.
  • Acted as Business Analyst by Interacting with Client’s delivery mangers and Business user’s team.
  • Monthly Steady State reports to Satyam account manager.

Confidential

Tech Lead

Database: Teradata, Sybase

Tools: Business Object 5.1.6, 6.5, T - SQL programming

O/S: Windows XP, NT, 2000 and Mainframe

Language: Excel VBA Programming, ASP, VB/Java Script, IIS ,

BO & WebI SDK Hardware: Intel Pentium 4

Responsibilities:

  • Gathered the BO SDK KT from Confidential UK. (It is the best achievement in my BO career) and got an award for the same.
  • Developed a team in offshore and transferred the KT.
  • Studied the flaws in the existing system and proposed a solutions
  • Prepared Estimation Various I4B projects (Self service checkout, I don’t Queue etc)
  • In “I don’t Queue “project I have used EXCEL VBA Macro
  • Co-ordinate the development team for a migration project called Year end convergence.
  • Participating conference calls with Confidential UK I4B team
  • Preparation of Project ABCDs. (Action, Benefits, Concern and Do Next)

Confidential

Team Member

Database: Oracle, SQL Server7.5

Tools: Business Object 5.1.6, Transact - SQL programming

O/S: Windows XP, NT and 2000

Language: Excel VBA Programming and

BO SDK Hardware: Intel Pentium 4

Responsibilities:

  • Support and Maintenance of BO Client reports, Web I reports, User administration and BCA Scheduling
  • Developed a BO VBA Macro to carried automated report bursting for scheduled reports
  • Interacting with UK/Europe/ASPAC Clients and EDS UK developers.
  • Preparation of BO reports enhancement estimation
  • Coding, testing and Implementations.

Confidential

Team Member

Database: SQL Server, Oracle and Sybase

Tools: Business Object 5.1.6, 6.5, Clarify

O/S: Windows XP, NT, 2000 and Mainframe

Language: Excel VBA Programming, ASP, VB/Java Script, IIS and BO SDK Hardware Intel Pentium 4

Responsibilities:

  • Got a VOC (Voice of Customer) as 5/5 for a Hungary project.
  • Studied a Metric Assessment calculation project developed by a Six Sigma Black belt developer and resolved a major Bug on that system.
  • Developing a Confidential mart for “Comverse reporting Application” used by Call center Quality team to create the Call quality assessment reports using Informatica as ETL tool and developing reports for quality agents for Confidential, India customers.
  • Developing Flex trial Customer management project for Hungary GE customer.
  • Developing iDAC application for Confidential Delhi Call center operation for JC Penny, US, It is an Integration of mainframe Confidential to SQL Server through a VB application. Reports have been taken from Business Objects

Confidential

Team Member

Languages: VB 6.0, VB.NET

Database: Oracle 8i, SQL Server 7.0, Sybase

Tools: Visual SourceSafe

O/s: Windows XP, NT, 2000

Hardware: Intel Pentium 3 and 4

Responsibilities:

  • Studied and understand the complexity of the product by walk through the VB code.
  • Performance tuning using Client side cache and resolved the Names space problem on VB projects.
  • Responsible for enhancement of Cancer registry module.
  • Responsible for managing Source code in VSS and Configuration and Schema change documents

We'd love your feedback!