SUMMARY:

BI Lead and Consultant with Over Sixteen years of IT experience in developing end to end Data Warehouse systems as an Architect, Data Modeler, BI Administration, ETL Developer, Business Object and Tableau Developer

BI and Solution Architect supporting all the phases of Data warehouse Data Modeling, ETL and Reporting

More than 13 years of Business Objects experience and 5 years of Informatica experience.

Architected and Modeled Business Objects, HANA and Tableau Environment.

Tableau Developer and Administrator, Experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various version of Tableau 9.2.

BO Administrator and Project Lead for the Infrastructure Support project. Installation, Configuration of BI Environments, Data Migration, Support, SSO, Enhancement and Performance Tuning projects.

Architected and Modeled HANA and Integrated with BODS and SAP BO, Created Attribute, Analytical and Calculation views.

Experience and Hands on in OLAP/OLTP Reporting using different Business Intelligence tools like Business Objects, OBIEE, Cognos, Report net, Crystal Reports XI .

Expertise covering end to end business analysis for Clients, Gathering Requirements and working with Business.

Experience and Hands-on in Data Analytics using Dash board Visualization tools Tableau, Xcelsius, SAP Lumira.

Hands on Experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various version of Tableu 8 and 8.1.

Experience and Hands-on in ETL tools like Informatica, BODS, SSIS and OWB

Experience in Data Quality, Profiling, Cleansing, and Metadata Management using Information Steward.

Experience with BIG DATA, Hadoop, HIVE, Data Science with R

TECHNICAL SKILLS:

ETL

Informatica, BODS, SSIS, Datastage, OWB

OLAP/Reporting/Dashboard

SAP Business Objects, Tableau9.2(Tableau Desktop, Tableau Server and Tableau Reader),OBIEE, Crystal Reports, Cognos,SAP Lumira, Xcelsius

Tools

BMC Remedy, Quality Center, Cherwell, M.S. Project, Clarity, Clear case, Version One, SharePoint, and Service Now

Database

HANA, Oracle, SQL Server,DB2,Teradata

OS

UNIX, Windows

Softwares

PLSQL, BIG DATA, Hadoop, HIVE, Data Science with R

CERTIFICATION:

ITIL V3 Foundation Certified

Scrum Fundamental Certified

Scrum Master Certified

Banking Journal Certification – Accenture

White Papers on Best Practices on Business Objects and Configuration- Accenture

PMP Principles (Strong Knowledge)

EXPERIENCE:

Bank of the West (BNP Paribas)…Informatica / Report developer

May 2015 – Current

Description: Bank of the West is creating an Enterprise Data Ware House which will be used across the Bank of the West, First Hawaiian Bank and CIB for the Regulatory Reporting at international Holding company level.

Responsibilities:

Senior Developer for ETL and Reporting team.

Developed and Maintained using Business Objects WebI and crystal reports for RBG group

Developed Multiple Mapping to Load data into the EDW

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.

Administered user, user groups, and scheduled instances for reports in Tableau.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Deftly designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.

Created incremental refreshes for data sources on Tableau server.

Creating calculated fields, groups, sets and hierarchies etc.

Creating data blending in case of merging two different datasets.

QBE NA…Business Objects /Tableau Lead developer

Oct 2014 – Apr2015

Description: QBE provides insurance services mainly to Australia, America, Europe and Asia Pacific region .In NA region, QBE provides insurance for various types of Hazard like Flood, thunderstorm etc., It provides both General insurance and the lender placed insurance The Data stored in Mainframe about Hazard is extracted using SSIS jobs and are loaded into business oriented datamarts and used for information delivery. Our team handles all data platform (data Modelling /database design, data profiling, data scrubbing) and information delivery (support of BOE, design and implementation of BOE security, Universe development, Crystal and Web-I report development) support and activities.

Responsibilities:

Lead Developer for Business Objects and Tableau Application for both Development and Production Support team

BOE Administrator for all BOE environment across the QBE NA

Architected and Modelled the SAP Business Objects environment with multiple clusters.

Modeling HANA tables, Creating Attribute, Analytic and Calculation Views in HANA

Designed and migrated (UNV to UNX) Universes using Information Design Tool (IDT) and developed Web Intelligence.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Experience in migrating client’s reports from excel(static) based solution to an interactive service.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.

Installed Tableau Server 9.2 in Dev, QA, UAT and Prod environments.

Administered user, user groups, and scheduled instances for reports in Tableau.

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Deftly designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.

Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, AdHoc, business views along with user acceptance test and data accuracy test.

Created incremental refreshes for data sources on Tableau server.

Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.

Involved in license management SLA's with Tableau support.

Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dash board actions and Table calculations.

Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository

Shell(Accenture)…HANA/Business Objects/Tableau Lead Developer

Aug2013 – Jan 2014

Responsibilities:

Lead Developer and Architect Business Objects and HANA team

Architected and Modeled the HANA environment to integrate with BODS and Business Objects

Installing and Configuring HANA and Integrating SAP ECC system with BODS to load data into the HANA Database

Modelling the data model in SAP HANA Studio

Create Reports using WebI from HANA DB and Dash boards in the SAP HANA Studio

Architect UI Interface to Download and Upload files into the HANA tables.

Working on different perspectives (Admin, Modelling and Development)

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.

Nordea(Accenture)…Business Objects

Stockholm Sweden

Jul 2011 – Oct 2013

Description: Nordea is a financial services group in the Nordic and Baltic region. Nordea offers online banking and insurance as well as information to investors

Treasury is one of the major part of any bank, Part of Treasury I was leading two applications Liquidity Premium Engine.

Responsibilities:

Lead Developer for both the Development and Production Support team.

Created Reports using Business Objects WebI and Admin supporting the existing BOE environment

Installing, configuring and administering the Business Objects 4.1 SP1/4.0 SP6 environments and configuring Development, Test and Production cluster environments.

Configured and integrated LDAP Authentication, mapping extended user attributes in the LDAP Directory to Business Objects and applying security using extended user attributes on Business Objects Universes and Reports (.unx).

Design, develop and maintenance of Business Objects Universe’s using Information Design Tool to drive Static and ad-hoc reports.

Extensively used BO Life Cycle Management to migrate reports across different environment (ie Dev, test and prod).

Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.

Worked extensively on distribution, maintenance and optimization of universes for SAP Business Objects and Web Intelligence deployments.

CARGILL(Accenture) Business Objects Lead Developer

Nov 2010 – July 2011

Description: Cargill Is a retail company which produces food items and is spread all over the world, We as a part of Common Application team support the project by monitoring the Incidents through Remedy tool and assign the then to appropriate teams and also work on Installing, Configuring the environments w.r.t to

Business Objects XIR3,BODS, Line of Business, Middleware application. Cargill has implemented SAP and we Common Apps team support all the Non SAP Applications associated with the SAP systems

Responsibilities:

Lead Developer for both Development and Production Support teams

Sr Developer Lead for Business Objects reports

Sr Developer Lead for Business Objects Data Services

Integration of SAP system with BOE and creating reports using the Bex queries

Installation and Configuration of BOE,BODI and Information Steward environment

Created Reports using the Bex queries

Configured and integrated LDAP Authentication, mapping extended user attributes in the LDAP Directory to Business Objects and applying security using extended user attributes on Business Objects Universes and Reports (.unx).

Design, develop and maintenance of Business Objects Universe’s using Information Design Tool to drive Static and ad-hoc reports.

Extensively used BO Life Cycle Management to migrate reports across different environment (ie Dev, test and prod).

Obtained and analyzed User’s Information and Security levels in BO 6.5 and implemented new Security in SAP BO 4.0.

Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.

Worked extensively on distribution, maintenance and optimization of universes for SAP Business Objects and Web Intelligence deployments.

Admin for No SAP environments supporting( BOE, BODS, Web services, Middleware and many miscellaneous applications)

Edison Mission Market Trading(Accenture)…Informatica / Business Objects Lead developer

Oct 2009 – Nov 2010

Responsibilities:

Team Lead for team of 6 resources for Application Development

Sr Lead Developer for Informatica Data Loading

Sr Lead Developer for Business Objects reports

Installed and tested the BI4.0 application on sandbox before moving to live systems and resolved issues accordingly.

Extensively used BO Life Cycle Management to migrate reports across different environment (ie Dev, test and prod).

Obtained and analyzed User’s Information and Security levels in BO 6.5 and implemented new Security in SAP BO 4.0.

Created/Administered users/user groups/Security in Supervisor/CMC.

Created Profiles in CMC to support to report bursting feature.

Designed and migrated (UNV to UNX) Universes using Information Design Tool (IDT) and developed Web Intelligence and Crystal reports in BI 4.0 Launch Pad.

Performed the User Training Sessions with Lab sessions on the Data marts, Universes and Reports in respective to the users Business Area.

Installed configured the BI4.0 in clustered environment and done sizing according to SAP standards.

Expert in creating web intelligence documents using level input controls, merged dimensions, data tracking, open doc and complex filters (query and report level).

Developed complex universes by using advanced features like aggregate aware, Derived SQL, LOVs and hierarchies.

Developed and implemented Universes by defining joins, cardinality between tables, creating prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.

Worked extensively on distribution, maintenance and optimization of universes for SAP Business Objects and Web Intelligence deployments.

AT&T (Accenture)…Business Objects / SSIS Lead Developer

Sep 2008 – Oct 2009

Description: ATT is one of the Leading Telecom companies in USA, We were leading three major applications IDW Loading, IDW Reporting and Miscellaneous

1.IDW Loading - SSIS

2.IDW Reporting -Unix, SAS, BO XIR3, DB2, Teradata

3.Leading Miscellaneous application for ATT

Responsibilities:

Sr Lead Developer for Business Objects reports and ETL using SSIS

Created Mulitple Business Objects Reports

Lead Developer to load data into SQL Server using SAS scripts.

Environment: SAS (Scripting), Business Objects 6.5, BOXI Oracle 8i, SQL Server, Teradata, and UNIX

MHRA

London UK(Accenture)…Business Objects Lead Developer

Aug 2007 – Sep 2008

Description: MEDICINES AND HEALTHCARE PRODUCTS REGULATORY AGENCIES (MHRA) is a Regulatory System in UK . This is Government organization which gives license to any type of

The project was performed at the client site from Onsite in UK (London) as most of the work involved more of interaction to understand the client requirement and develop reports for them

Responsibilities:

Sr Lead Developer on Business Objects

Creating of Reports in Business objects (Desktop and Web Intelligence) using universe as a Data source and oracle and lotus notes as databases

Creating Universe Classes and Objects, Filters, Prompts and Derived tables

Assigning security to Groups,Folders, Reports

Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.

Responsible for analyzing, designing, implementing and maintaining complex components of Reporting / Business Intelligence information systems (business objects) that support critical business operations

Worked on creating dashboard for multiple reports into a consolidated report for the complete analyzing the customers overall performances in a graphical representations using Desktop Intelligence Reports

Testing of Reports,creating test cases Tracking Defects using Mercury Quality Center

Creating Detail Design Document, Documents for Application, Integration and Unit Testing

Involved Application, Integration and Unit Testing, Helping with client to perform the UAT

Daily interactions with client.

BELLSOUTH(Accenture)…Business Objects / Crystal Reports Developer

Jul 2006 – Aug 2007

Description: BellSouth Corporation is a Fortune 100 communications Services Company headquartered in Atlanta, GA, serving more than 45-million customers in the United States and 14 other countries, Bellsouth is now merged with AT&T. We were responsible for all application management ranging from maintenance to development serving all major business areas including: Billing, Wholesale Customer Operations, Network, Shared Services (Enterprise applications), eStore, Technology Enablement and Delivery Excellence.

BBOT is a tool for Bellsouth which handles Reports for Billing and Ordering. We have used BOXI environment to create this tool but generated the reports using Crystal XI R2 . So the reports use universe as a data source. We schedule the reports for the client on their requirement in different formats.

Responsibilities:

Sr Developer creating reports in Business Objects and Crystal XI R2

Creating Universe Classes and Objects, Filters, Prompts and Derived tables

Creating and Handling Groups, Users and Folders in CMC. Scheduling Reports in CMC and Info view in different formats

Assigning security to Groups,Folders, Reports

Importing from one environment to other (Migration of whole environment)

Testing of Reports,creating test cases Tracking Defects using Mercury Quality Center

Creating Detail Design Document, Documents for Application, Integration and Unit Testing

Involved Application, Integration and Unit Testing

Daily interactions with client.

BNPP Paribas(Saama Technologies)…Business Objects developer

Jan2006 – July2006

Description: Created through the acquisition of the highly respected Greater China equity team of the Peregrine group in 1998, BNP Paribas Peregrine is one of the leading investment banks in the region. The innovative combination of specialized Asian talent, backed by BNP Paribas’ financial strength and global network, provides clients with an integrated range of investment banking services, in-depth knowledge and access to the Asia capital markets.

Responsibilities:

Installation and configuration of Business Objects in Windows 2000 Server (BO Client, Supervisor, Designer, Info view, Web Intelligence, BO Broad casting Agent, WebI SDK)

Worked in the applications Report Publishing System and Report Conversion system

Desktop and WebI report Development

Daily Interactions with Client and gathering requirements

Datamatics Ltd …Business Objects Developer

Apr 2004 – Jan 2006

Client: Astra Zeneca…

Description: AstraZeneca is a major international healthcare business engaged in the research, development, manufacture and marketing of prescription pharmaceuticals and the supply of healthcare services. Astra Zeneca has implemented Oracle Apps in all there Depots and now are using Business Objects to create Reports. The Project was carried out at the Clients Place in the Bangalore Depot. We have started with two modules of Oracle Apps ie Order Management and Accounts Receivables.

Responsibilities:

Installation and configuration of Business Objects in Windows 2003 Server (BO Client, Supervisor, Designer, Info view, Web Intelligence, BO Broad casting Agent, BO Broad casting Publisher)

Tweaking and Deployment of the Rapid Deployment Templates (RDT’s) which come free for the Oracle Apps which are not compatible with the latest version of Oracle Apps 9.5.9 by creating synonyms etc

Configuration of IIS server and other BO files for better performance

Creating of users and giving them privileges and giving them access rights to their reports w.r.t their Profiles using Supervisor

Creating Objects, there aliases, prompts, joins and putting them into contexts using Designer

Creating Reports in Business Objects Client and publishing it to view in the Web using info view

Publishing of reports to their personal mail ids using publisher I different formats

Daily interaction with the users, taking their requirements and adding them to the reports

Client: MANUGISTIC (Datamatics Ltd)… Senior Cognos Developer

Description: RMS (Revenue Management System) is being developed for CBC, Toronto and Montreal by Manugistics. Manugistics leads other software companies in providing supply chain and pricing solutions to Consumer Goods companies. Reports to be developed using Report Net. RMS needs to support English and French languages, as it will be used by Radio-Canada, Montreal as well.

Responsibilities:

Using Framework Manager for creating Metadata layer

Using Cognos IA, Various types of simple reports like Simple List, Grouped List, Drill Down Report, Grouped Cross Tab are created for better analysis.

Power Cubes for SHP & GHP were created using Power Play Transformer

Reports were published using Power Play for Windows, as per the requirement of Top Management

Analyzing the Requirements.

Analyzing the models and packages using the Framework Manager

Using Report Net Report studio to develop advanced reports.

Attending client conference calls on daily basis Leading both AM and AD with a team size of 9 members

Working on Estimation, Staffing and Project planning

Involved in creation of Functional, Technical Design Document

Client: SPECK SYSTEMS LTD … GIS / Database Developer

June 1999 – March 2004

Description: GIS and Database Developer

Responsibilities:

GIS and Photogrammetry Engineer

Programming in Arc Info

Creation of reusable and automated tools

Developer for Arc Database in ArcInfo

EDUCATION: Bachelor of Engineering from Osmania University (INDIA) – 1995-1999

Contact this candidate