SUMMARY

• Over 15 years of professional experience in the field of Software System Design, Development, deployment, Project Management Practices and BI solutions architecture.
• Involved in implementing full life cycle of BI Projects which includes Data warehouse/ETL, Data Modeling, design, development and in BI solutions architecture using Industry leading BI Tools for Modeling/ETL/Reporting/Administration BO 4i, SAP BOXI R2/R3 InfoView, WebI, Crystal Reports, CMC, Import wizard etc. , SAP BI 4.0/4.1 BI Launchpad, UDT, IDT , BI Data Services, CMS, CMC, MTM etc. , databases Oracle, MSSQL Server and Hana .
• Strong experience in BI Analytical applications like BMC Analytics, Decision support systems, Data discovery, exploration tools,Dashboards SAP BI Explorer, Dashboards, Mobile BI, RoamBI and knowledge in using visual analytics Tableau8.1,QlikView,Lumira, GoodData , ETL tools Informatica, Pentaho and experience with DB programming in PL/SQL.
• Responsible for providing technical leadership, architecture, Designing and Implementing Critical Business Solutions, Working closely with Directors, Senior Managers and Performed technical and advisory functions in the development of SAP business objects architecture and creating Product road-maps, helping them in BI initiatives/programs and making respective strategic decisions.
• Extensive business/functional, technical experience and project implementations in domains IT/HighTech, Sales, Finance, Pharmaceutical, Retail, Insurance and ITIL in Software, Banking, Healthcare, Oil/Gas Industries etc., other spheres of my responsibility include Customer Engineering.

TECHNICAL SKILLS

BI/DWH Tools/Technologies:

• SAP Business Objects 4i, 6.5,XI R2/R3 ,BI 4.0/4.1,Designer
• Universe Design Tool, Information Design Tool , WebI/BI Launch Pad, Crystal Reports, CR XI, Xcelsius 4.5, BI 4.0 Explorer, Lumira, BOE/BI Administration, BI40/4.1 Data Services, BO SDK/WebI SDK, Admin SDK , Hana Design Studio, RoamBI Mobile BI applications and Dashboards , Informatica 6.1/9.5.1, Pentaho 4.1, Tableau 8.1 Desktop, Server , QlikView

Databases:

Oracle 8i-12G ,

MSSQL Server 2005/2008,MySQL5.1,Sybase9.0.2.Hana1.0

Web Technologies:

J2ee Java technologies, Cold Fusion, Java Script and HTML 6.0,SoapUI, Web Services

Operating Systems:

Windows-98/NT/2000/2003/2008/2012,

UNIX Sun Solaris/AIX/Linux

Programming Languages:

C, C , Java, SQL , Pro C, PL/SQL, SQL Script Hana

Frame Works:

Structured Systems Analysis and Design, Star Schema /Dimensional Modeling for DW Processes, ETL Design, and Strategy and Architecture OLAP design for Data Marts.

PROFESSIONAL EXPERIENCE:

Confidenital

Role: BI Lead Designer/Developer

Environment: Tableau8.1 Server, Desktop and Administrator , Oracle 11g, Informatica 9.5.1, SAP Business Objects 3.1/4i Windows 2008 and Unix , Salesforce, SharePoint

Description:

• metrics/KPI etc., to various teams across the Company.
• analyzing charts by different dimensions and multiple views of information at run time, various
• Analytics and different visualizations features, Capabilities like Quick Ad-hoc Analysis on huge data and
• The Business goal of Tableau BI solution is to provide BI dashboards with Advanced
• Involved in gathering BI requirements, analysis of business needs.
• Responsible for designing and developing tableau dashboards with advanced visualizations and features for Sales Service Bookings, Product Margin, Pipeline, Discount trends, Attainment by Sales team etc. , Operations related to processes - Inventory, Shipment, Procurement etc. , GSS Service Summary, Technology Volume, FTF,TTR and Engineering teams
• Migration of SAP DeskI and WebI reports with additional tableau features, delivering project documents like functional and deployment documents and integration with Share point and Salesforce.
• Involved in setting up basic security through Tableau Administration and managing extracts.

Confidenital

Role: BI Lead Designer/Developer

Environment:

• identify gaps and build the next generation BI solution in IT Service Offerings portfolio.
• Description: The core business objective was analysis of Cisco Prime Service Catalog CPSC ecosystem,
• Cisco Prime Service Catalog 10.0.0R2 and Cognos 10.2.1 BI Server, Framework Manager, Query Studio, Report Studio , MSSQL Server 2008 Server, Oracle 11g, Tableau8.1 Server and Desktop ,Windows 2008 Server
• Responsible for the entire deliverable, leading, managing the team.
• End to end system analysis of the entire system and propose recommendations with respect to ITIL/BSM Methodologies/BI/DWH Best Practices.
• Enhance ETL procedures, the existing packages and existing reports and designed new reports.
• Requirement gathering and analysis and designing of BI Dashboard using Tableau8.1 that include various workbooks on Customer profiling, High light insights for lowering cost , Revenue growth factors, Data center capacity planning Base line Revised capacity planning , monitor actual consumption, Project Impact Costs for SLA violations, forecasting, trending etc.

Confidenital

Role: Solution Architect and BI Technical Lead

Environment:

BOE XI R2/R3, BI4.0/4.1 UDT, IDT,BI Launchpad,Multi-tenant Management Tool, BI Explorer, Dashboards,CMC, Lumira , BO Data Services 4.0, Windows 2003/2008 Advanced Server/AIX/Linux/Solaris, Oracle 8i-11g, SQL Server 2000/2005/2008, BMC Remedy Action Request System 7.x-8.x, ProactiveNet 8.0, Sybase Adaptive server and ASA Client 9.0.2, RoamBI 3.1.2, Pentaho 4.1, Tableau 5.1

Description:

• The primary objective of the BMC Decision Insight system DIS 1.0 is to deliver a Consistent and Single Source BI Solution across all BMC Product port-folio Service Desk, Service assurance and Service Automation
• BMC Analytics 7.6.01/04/06, 8i for BSM solution provides out of the box, Industry best practice reports, point-and-click analysis and advanced reporting for BMC Remedy suite Service Desk, Asset Management, CMDB, Change management, SRM, SLM, Drift, and Release management and BMC ProactiveNet Analytics.
• Architected Service Oriented Architecture SOA for implementing BI solutions for On-Premise and On-Demand customers.
• Designed and developed BO Universes UDT and IDT and best practice analytical and interactive Web-Intelligence reports out-of-the-box for BMC Remedy Suite 7.x/8.x and ProactiveNet 8.0.
• Performed the customer engineering activities to various BMC Analytics customers in providing BI Solutions and architecture based on landscapes and use cases, performed advisory functions in adopting and customization of BMC Analytics and working closely with On Demand team.
• Design, development of SQL ETL procedures.
• Working with Product and Executive Steering Committee, Stakeholders as part of Business Analysis and making critical technical decisions.

Confidenital

Role: Solution Architect and BI Technical Lead

Environment:

BOE XI R2, WebI, MySQL 5.1, Linux 4.1, Windows 2003 Advanced Server

Description:

• The major business objectives of this BI initiative is to provide the internal and external users access to the transactional data using both canned and ad hoc WebI reports in BusinessObjects.
• Responsible for BI Tool evaluation, design, development, and testing of ad-hoc reports using BOE XI R2, development of ETL procedures and CRON jobs.

Confidenital

Role: BI Consultant

Environment:

Crystal Xcelsius 4.5, BOXI R2,CRXI, WebI, Adobe Flash Server, MS Excel 2003

Description:

• group and CRXI for CSM group .
• Xcelsius. The purpose of the Brio to BOXI migration project is specifically off of Brio to a BOXI R2 for CIT
• The project is to design and develop rich and an interactive business dashboard in Crystal
• Responsible for developing a dashboard using different visualization components, drilldown capabilities, row-level security and extensively used excel functions, formulas that have occurred behind the scenes to provide the data visualization in the dashboard. Designed and developed high performance reports with Analytics and migration of existing Brio reports into WebI XI and CRXI.

Confidenital

Role: BI Consultant

Environment:

BO XI R2, Oracle 9i, Informatica 7i, Windows 2003 Advanced Server, Sun Solaris.

Description:

• enterprise product portfolio.
• implementing the processes and applications that will enable the integrated revenue cycle for Symantec's
• The OASIS oracle applications for integrated storage with security program is about
• Responsible Leading the BO team at client-side and Design, Development, Testing of BO Universes and Reports in BOXI R2, BO 6.5 system migration to BOXI R2.

Confidenital

Role: Architect and Project Lead

Environment:

• BO 5.1.8, WebI SDK 2.7.4, Oracle 9i, Java 1.3.1, Web Sphere 5.2, AIX, Win2K Description: The objective of this project is to optimize Business Objects Repository for high-performance using WebI SDK.
• Solution Architect and Performed lead activities and developed Java/JSP components on the Business Objects implementation system to resolve the technical problems and to optimize the BO repository for high performance.

Confidenital

Role: BI Consultant

Environment:

BOXI, CR XI, Oracle 9i, Informatica 6.2, Win2003 Server, SunOS 5.8 Solaris 8

Description:

• The current effort is re-designing the reporting database AUM Assets Under Management and coming with a new data warehouse and reporting solution to meet demands of AUM services clients to analyze assets in various categories and line of business.
• Designing and Developing DWH, ETL pertaining to as of Reporting, Adhoc Capability, Audit Capability.

Confidenital

Role: BI Consultant

Environment:

BO 5.1.6, WebI 2.7.2, BCA, WebI SDK, Java 1.4.2, JSP, Unix, Windows, Oracle 8i, Toad 7.5.3, Jakarta-tomcat-3.2.4, HTML, Java Script

Description:

• The web-based Business Objects A2Q Global Dashboard manager which will provide, Cisco business users with an intuitive graphical console of metrics/KPIs, for monitoring and analyzing progress towards defined organizational goals.
• Customization of WebI environment, developed reports for indicating Trends based on historical data, different kind of deals and their status at various levels and distribution to the business field users.

Confidenital

Role: BI Consultant and Project lead from off-shore

Environment:

Informatica 6.1, PowerAnalyzer,Win2K Server, Siebel7.5.3, Oracle 8.1.7/9i

Description:

• database, which would provide business analytics for BI Consumers, Sales Executives, various departmental heads and administrators.
• The project Seibel Adaptor General is to develop the adapter for Siebel CRM
• Lead the project from off-shore and assist the on-site team and client with any ad-hoc activities and overall responsible for ETL using Informatica and to generate reports on top of DWH using Power Analyzer.

Confidenital

Role: BI Consultant and Project lead from off-shore

Environment:

BO 6.0, WebI 6.0, MS SQL Server 2K, Windows 2K Server and IIS.

Description:

• The main objective is to migration of existing Cognos and MicroStrategy reports to BO 6.5.
• Lead Developer ensuring the smooth deliveries, communication and coordination and migration of existing Cognos and MicroStrategy reports to BO 6.5

Confidenital

Role: QA Lead

Environment:

B.O. 6.0, Wind2K Server, MSSQL 2000, IIS, Iplanet LDAP server, Apache Tomcat.

Description:

• This application is a Web based Tool for Systems Administrators to Synchronize Business Objects B.O 6.0 User repository and LDAP. And the Universe management tool is a utility for comparing, updating and migrating BO universes.
• As a QA lead, leading QA team and also testing to ensure correctness, performance, ease of use and security for the application and Preparing the Test Strategy, Test plan and also Test cases.

Confidenital

Role: BO Developer

Environment:

BO 5.1, Broadcast Agent, SQL Server 7.0, Oracle 7i, Microsoft Data Transfer Services DTS

Description:

• The goal of this project was to generate reports for the forecast, plan, Trends and Summary Trends.
• Design and development of new reports based on user requirements. BO administration and Scheduling reports using Business Objects 5.1 system

Confidenital

Role: ETL/DB Developer

Environment:

Windows 2000, Sybase Adaptive Server Anywhere, MS SQL Server 2000, Power Builder

Description:

• The primary objective was to convert Customer's back office, front office data into Sybase for PEAK Property management applications run on Sybase Server.
• As a developer, Writing/updating the SQL scripts and processes of conversions through DBI SQL. Testing to ensure the correctness of the data conversion.

Confidenital

Role: Java/JSP Developer

Environment:

JSP, Java, JDBC, Servlets, Java Beans, Oracle, WinNT, HTML and JavaScript

Description:

• The objective of Web based HRMS and TMS applications are to manage Employee details Personal Details, Resumes, Salary Details, Employee Reports and Timesheets etc. efficiently.
• As a Programmer, Designed and developed the screens with all GUI features, Unit and system testing of the applications.

Confidenital

Role: Java/JSP Developer

Environment:

Cold Fusion 4.5.1, Sybase, HTML, Java Script, Windows 2000

Description:

• The web based Peak Property management system offers property management solutions.
• Designed and development, Testing of web based application for managing the Tenants, Tenants applications, Owners, Transactions modules and to integrate with other modules of the system.

Confidenital

Role: Java/JSP Developer

Environment:

C/C , Unix, Windows 98

Description:

• The Due to the rate of expansion and opening of new branches, CSI solutions required a flexible system to calculate taxes on different items and also upgrade the existing systems to C and development of Embedded systems.
• Responsible for Coding and design and development of various reports on pending purchases, sales orders and customer outstanding balance using Pro C, Oracle.
• Used several Object Oriented features and Involved in developing query handling and report generating capabilities in the application.