Bi Solution Architect/global Operation Manager Resume
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