PROFESSIONAL SUMMARY:

• Overall 14+ years of experience in development, analysis, design and testing of client server applications as BI Architect / BI Administrator on SAP BusinessObjects, Microsoft Sharepoint BI Administration, ETL Process & DWH solutions for major Clients like Confidential, FedEX, Confidential, Confidential & Toyota Motors.
• Extensively worked on SAP Business Objects,Microsoft BI Administration & Architecture Implemented Business Objects Security Model, Installed Servers in cluster environment, Integrated BO using SDK programming with JAVA/.NET application, Architected BO Server sizing, Capacity planning, Load Balancing as well as Failover of BO Services.
• Expertise in defining and delivering Enterprise Data Warehouse (EDW) and Business Intelligence (BI) solutions for top tier clients in Retail, Banking & Automobile Industry using Business Intelligence (BI) & ETL experience using tools like SAP Business Objects, Microsoft SSRS, SharePoint BI, Informatica, Oracle & Teradata
• Expertise in Business Objects Universe designing, generating complex Adhoc dashboard reports, business views and List of values along with User Acceptance Testing, data accuracy testing & optimization Performance of Reports by tuning Universe parameters at the report level & database level.
• Technical expertise on Web Tier: Apache/Tomcat Server 5.0, IIS, WebLogic and JBOSS.
• Implemented LDAP Integration,User Profile Management & Single Sign on(SSO) approach using Sharepoint BI & Business Objects Tools.
• Created various Custom Tools for Universe Comparison using Excel Macro, Crystal Report Comparison (VB), Inventory of BO Objects, WEBI SQL, Formula & Variable extract using Java.
• Played BI Solution Architect Role from Crystal Report conversion to Microsoft SSRS Reports and Sharepoint Portal Integration
• Assisted in pre - sales activities working with the business development team and Wrote offering proposals and assisted the sales managers.
• Participated in the project estimation and prepared work breakdown structure (WBS) of projects and played various roles as Software Developer, Technical Lead, and Data Architect and currently as BI Solution Architect.

TECHNICAL SKILLS:

BI Tools: SAP Business Objects XI R2, R3.1, 4.0, 4.1 & 4.2 Administration & Development, Web Intelligence, Universe Design, Crystal Reports XI, Live Office, Microsoft SharePoint BI - SSRS,Cognos Reporting and Jasper Reports.

Dashboards: Xcelsius

ETL Tools: Informatica 9.6, Microsoft SSIS

Database: Teradata 14.1, Oracle, IBM DB2 & Microsoft SQL Server

In Memory Database: SAP HANA1.2

Programming Languages: Java, C#, VB.NET / Visual Basic 6.0

Web Design: ASP 2.0, ASP.NET, JSP, VB Script, Java Script, HTML, XML

Web Server: Apache/Tomcat Server 5.0, IIS, JBOSS

Operating Systems: Windows 2008 R2, 2012 Server, Unix & Red Linux

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

SAP Business Objects 4.2 SP3 Upgrade Administrator / Project Management

Technology: Business Objects, SAP Crystal Reports, Oracle 11g, Teradata, MS SQL SharePoint 2016, SAP Dashboard

Responsibilities:

• Completed POC and technical feasibility on 4.2 SP3 Version
• Identified right Fix Pack (Patch 13 for SP3 4.2)
• Created SOW, Estimation, Resource Loading and project plan
• Installed, configured and Upgraded BusinessObjects version to 4.2SP3 from 4.0SP10 on all 32 nodes on both US & EU instance of DEV,TEST PROD
• LDAP authentication and Implemented Single-sign.
• Content Migration
• Involved in supporting the SDK users to build their application and web server layers, by building and deploying their web servers on the Web server to connect to the Application via the SDK.
• Row Level security in the universe to restrict dataset in dashboard & QaaWS Configurations
• Managed 10+ Onsite & Offshore Team members including Testing Team
• Organizing the BO content (Delete, Move & edit)
• Managing BOBJ Licenses.

Confidential, CA

SAP Business Objects 4.0 & DataFederator Administrator / Consultant

Software: Business Objects 4.0(Windows), SAP Dashboards, SAP Crystal Reports, Oracle 11g, Teradata

Responsibilities:

• Installed & Configured 12 Virtual Windows Machines as Cluster mode
• Maintaining 63 VM BOBJ Servers which DEV/TEST & PROD environment based out of 2 US Locations
• LDAP authentication and Implemented Single-sign.
• Involved in supporting the SDK users to build their application and web server layers, by building and deploying their web servers on the Web server to connect to the Application via the SDK.
• Implemented, and configured the various Business Objects application like Application Foundation (Performance Manager), Auditor, Publisher, and Data Integrator.
• Row Level security in the universe to restrict dataset in dashboard & QaaWS Configurations
• Performed Application Support & Webi / Universe enhancements
• Developed Automated Tools to maintain the Servers effectively
• Developed Dashboards & configured using IPAD for management reporting on Report usage metrics

Confidential, CA

Responsibilities:

• The newly designed .NET reporting solution deployed as new Website hosted in same LMS application server thus eliminated infrastructure cost.
• Overall this solution minimized Cognos Users as part support work and Cognos Server maintenance.

Confidential, CA

Software: Business Objects Java SDK, VB Macro, Informatica Teradata, Oracle 11g, Teradata & ASP.NET

Responsibilities:

• Desgined & developed a custom built portal to perform Impact analysis on the BOBJ (6000 + Reports), Informatica (1100+ Workflows & 300 Mappings) & Teradata Object search in short span of time which helps to estimate the amount of work to be done on new enhancements request given by business as well as to understand the Data model.
• Quick Turnaround FIX on both BOBJ & ETL Component Impact on Production support.
• To do new project estimation based on impacted list of reports & ETL objects.
• Huge manual effort reduction while performing End-to-End Impact Analysis (SAP Source to BI Reporting)
• To propose new design re-engineering solutions
• To Identify business Impact on BOBJ report data based on Job Failures
• To Identify predecessor / successor Informatica Jobs (Job Sequence)

Confidential, Dallas, TX

SAP BI Infrastructure Lead / Architect

Software: Business Objects, SAP Crystal Reports, Oracle 11g, Teradata, SharePoint 2010 Business Objects Migration 3.1(Windows) to SAP Business Objects 4.1 ( RedHat Linux)

Responsibilities:

• Installed & Configured 8 Virtual Linux Machines as Cluster mode
• LDAP and Windows Active Directory authentication using Single-sign on was implemented.
• Involved in supporting the SDK users to build their application and web server layers, by building and deploying their web servers on the Web server to connect to the Application via the SDK.
• Confidential In-Center Excellence (ICE) SAP Dashboard integration with Microsoft SharePoint which will consolidate key reporting metrics from Xcelsius dashboards and existing reports. The reports and the dashboards (with drilldown capabilities) will show current performance against a set of KPIs, which can then be further reviewed for action as needed.
• App Tier - Weblogic Configuration
• Security Model Implementation
• Trust Athentication, SSL Certificate configuration and Active Directory Integration
• Row Level security in the universe to restrict dataset in dashboard & QaaWS Configurations

Confidential, MN

Solution Architect & Sharepoint Infrastructure Lead

Software: SAP Crystal Reports, Teradata, SSRS, SQL Server, MDS, SharePoint 2013 Matrix Re-Platform (SAP Business Objects Crystal Reports to MSBI-SSRS Conversion)

Responsibilities:

• Worked on proof of concepts by exploring the features of SSRS reporting tool versus Crystal Reports.
• Analyzed and extracted the complete metadata of Crystal Reports like SQL, formulas, expression etc. by writing a custom .NET code using Crystal APIs.
• Analyzed the ETL logic and created data model for SSRS design.
• Participated in architectural decision in SharePoint portal design and integration approaches of SSRS in SharePoint Integrated Mode.
• Performed SharePoint LDAP Authentication configuration and best approaches of SharePoint customization using Client Object Model.
• Performed MDS - SharePoint integration using Business Data Connectivity Services.
• Maintained MSBI infrastructure in Production /QA/ Dev. Environments
• Integrated all systems with Active Directory, SunONE LDAP, IIS and Apache web servers along with SSO Approach

Confidential, MN

Infrastructure Administrator

Software: SAP BI 4.0 / Business Object XI R3.1 / Teradata / Oracle OS: Red Hat Linux 5.7 Business Object XI R3.1 to SAP BI 4.0 Migration

Responsibilities:

• Worked on Proof of Concepts for understanding the new features included in BI Launch Pad, Web Intelligence reporting, Explorer, Dashboard Designer.
• Worked on Architecture planning and estimates for server sizing.
• Prepared an exhaustive list of documents, reports, universes and users to be moved from XI 3.1 to BI 4.0.
• Prepared life cycle server (verified servers for ODBC DSN setup, verified .NET framework, verified drivers).
• Installed and configured Business Objects 4.0.
• Analyzed and worked on issues imposed during BI 4.0 installation and testing and coming up with work-around to resolve compatibility issues.
• Defined and configured Single Sign On security and maintained User account provisioning/de-provisioning, Enterprise Directory Services, Single Sign-On(SSO), Password Management, Role-Based access control & Strong Authentication
• Created new universes(unx) using Information Design Tool(IDT)

Confidential, MN

BI Solution Architect

Software: Microsoft BI - SSRS - SSIS, SQL Server, Teradata

Responsibilities:

• Confidential does not have an integrated dashboard to track employee Productivity, Accountability and Learning. The Dashboard will provide employee performance visibility to the employee, employee’s supervisor & senior management. An Employee Dashboard, Integrated within ETK, for BBY Retail Employees/Supervisors to track their/team performance & growth under three areas: Productivity, Accountability and Learning.
• Employee Dashboard project has been undertaken to track individual employee’s Productivity, Accountability and Learning. The dashboard has been envisioned in the form of a graphical presentation of the current status and historical trends of an employee’s key performance indicators (KPIs), to enable instantaneous and informed decisions to be made.

Confidential, MN

BI Solution Architect

Software: Business Object XI R3.1, Crystal Reports, Teradata

Responsibilities:

• The Confidential business has realigned its operating model to roll up to two major Business Groups: Connectivity Business Group ( Confidential ) and Home Business Group (HBG). This business model change will require updating all of the common EDW data structure hierarchies to reflect that change and allow applications to use the new hierarchy. Without this change, the business would not have visibility to metrics aggregated to those levels.

Confidential RichField - MN USA

BI Solution Architect

Software: Business Objects, Universe, WEBI

Like For Like Reporting (Enterprise Returns)

• The project EBI-RASC Like for Like Reporting is to enhance reporting/analytics around Like For Like transactions which happen at retail stores, from existing sales/returns/exchange information in EDW and pulling Like for Like exception information from Enterprise Return Application (ERA). Current business intelligence that supports and measures the impact of the Retail Like for Like (L4L) tool is driven heavily by manual processes; manual Structured Query Language (SQL) queries, and is not conducive for advanced analytics such as basket analysis or scoring optimization.

Confidential RichField - MN USA

BI Solution Architect

Software: Business Objects, Universe, WebI, Teradata

Universal Basket

• Universal Basket (UB) is being prepared for roll-out to all stores. Current reporting is primarily manual, performance measures are inconsistent and two applications and ESCAPE are not integrated into the overall solution. Replacement of current manual processes will improve reporting capabilities; development of new reports will provide improved performance measures which will impact both adoption and revenue enhancements.
• Part of the Universal Basket program is to enable “relationships” between “driver” SKUs and relationship SKUs that are derived by the Merchandising group. These relationships are measured in the Confidential model (Hardware, Accessories, Connectivity, Content and Services). Development of reporting capability to assist in measuring the effectiveness of the UB relationships, measurement of effectiveness of the overall program.

Confidential

Design & Architecture & Coding

Software: ASP.NET, Teradata, MS Access

Responsibilities:

• It is a search tool specially made for the Confidential EBI Team in order to meet their needs in terms of searching the Teradata Scripts, Tables, Related Views, Maestro Jobs, Informatica components, Business Objects Universe and reports and almost everything a Developer/Tester may need in order to fulfill his quests of knowledge.
• This tool has access controls.
• The user need to enter their credentials in order to get into the Portal which in turn provides Security Features and Encapsulation to the Scripts and other related features so that, other persons out of Confidential cannot access it. This tool will help developers and others to do impact analysis and effort estimation.

Confidential

Technical Lead - Design & Architecture & Coding

Software: Business Object XI R2, Teradata Matrix Performance Management

Responsibilities:

• Report Archival System is a web based report distribution solution that enables eBBS users to access end of day reports in a secured manner from any system across the enterprise. This solution provides end users the flexibility to export report in which ever format he require. This has proved to be a very effective solution to our original file transfer and distribution issues.
• After the EOD completion the reports will be generated in report server in ATOS. These reports will be transferred to two report distribution server implemented in Mumbai and Chennai over international WAN (IWAN) in .rpt format in compressed files. The total size of the file size is approximately 1GB per day. User can view the reports in their web browser (DHTML viewer) via report distribution application deployed in the two servers.

Confidential

Design, Architecture & Administration

Software: Crystal Enterprise 10, Business Objects XI - R2 on Linux 4.3, IBM DB2 V 8.0

Responsibilities:

• Restructured the basic architecture of Crystal Enterprise 10 which was running under IIS, Considering the severities, downtime and stability of crystal services the migration is suggested to latest version of Business Objects XI R2 on Red Hat Linux 4.3 having tomcat as web server.
• Developed online, scheduled reports / fax reports Java/JSP files using Business Objects SDK and provided administration for the following countries like Malaysia, Indonesia, Thailand, Taiwan, UAE, Oman, India, and Nigeria
• Managed the CE servers end to end. Installed and configured the CE servers for each and every country report servers.
• Created the page and cache servers according the no of CPUs and CMS.
• Published the report objects, scheduling as well as extracting. Automated tool for this and it has been awarded.
• Created and managed user groups as well as users in CE servers.
• Performed CMS Cluster using Remote DB2
• Configure Single sign on(SSO) functionality for opendoc to access reports and dashboards from third party applications.

Confidential

Design, Architecture & Administration

Software: Crystal Enterprise XI & IBM DB2

Responsibilities:

• This is a plug-in for Crystal Reports to process and display crystal reports. This component is plugged in to WAS 5.1 and is available as default from WAS 6. This plug-in provides a java reporting engine, which can enable the processing of crystal reports no matter in which operating system it is developed. This report technology provides the cost-effective reporting solution to the bank which neglects the need of dedicated report server and Crystal Enterprise software. This can be useful in those situations where-in the number of users is minimal This solution is successfully implemented in all African - Ebbs Countries (Nigeria, Zambia, Tanzania, Botswana, Ghana & Uganda )