Summary:

• More than 14 years overall IT experience in complete Software Development Life Cycle SDLC in Client/ Server, Database, Oracle Data Warehouse and Business Intelligence applications in Windows and Unix environments from initiation through design, development, deployment, post go-live and support.
• 7 plus years of experience on implementing OBIEE 10.1.3.x/11g / Siebel Analytics 7.x in OBIEE/Siebel Administration Tool, OBIEE/Siebel Answers, OBIEE/Siebel Intelligent Dashboards and OBIEE/Siebel Delivers, iBots with OBIEE/Siebel Analytics stand-alone/integrated Applications.
• Highly proficient in Design, Development, Implementation, Administration and Support of Oracle Business Intelligence Applications 7.9.x, Informatica, OBIEE, DAC, Oracle BAW and Prebuilt reports.
• Extensive experience in OBIEE 10.1.3.x/11g, Oracle BI Applications 7.9.x, which include building and configuring Repository, creating and managing OBIEE Intelligent Dashboards, OBIEE Answers, OBIEE Delivers, and OBIEE iBots.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in installation, configuration, troubleshooting, performance tuning and administration of Oracle BI EE 10.1.3.x/11g.
• Sound knowledge of Database architecture for OLTP and OLAP applications, Data Analysis, ETL, Reporting processes in developing Data marts and Enterprise Data Warehouse.
• Extensive Experience in Data Warehouse Administration Console DAC Importing Subject Areas, Creating Execution plans, registering the informatica Work flows, Metadata management, Scheduling.
• Extensive Experience in OWB 9i/10g developer and Administrator
• Exposure to Insurance, Banking, Financial, Healthcare, Industrial sectors and business with regard to Data warehouse development.
• Experience in Data Modeling using Erwin.
• Worked on Financial Analytics, Supply Chain and Order Management Analytics , Sales Analytics and Human Resources Analytics.
• Extensive experience in Designing and developing Star Schema, Snow flake Schema.
• Extensive experience in Performance tuning , identifying bottlenecks and resolving to improve performance at Database level Materialized views, Indexes- and Informatica- mappings , sessions level, OBIEE-reporting level, rpd level, Cache, management, IBots.
• Expertise in installation, upgrades, configuration and maintenance of Tableau Software 6.x/7.x/7.8/8.1/8.1.7/8.2.
• Strong experience in Installation and configuration of Informatica Power Center 8.x/7.x and creating Mappings, Mapplets, Sessions and Workflows.
• Troubleshooting production issues and gave post production support for couple of projects.
• Good experience in UNIX and writing shell scripts.
• Excellent Interpersonal communication, documentation skills and experience coordinating with project Managers, Business Analysts, Architects, DBA's and Developers.
• Excellent Management skills, solid analytical and dynamic troubleshooting skills, Multi tasking, Posses good communication skills, Quick learner and adapts to new environments easily.

Technical Skills:

• Reporting Tools: OBIEE 10.1.3.x.x/11g.x, Tableau 6.x/7.x/7.8/8.1.7/8.2, Siebel Analytics 7.x and Business Objects 6.5/5.1.
• ETL Tools: OWB 9i/10g, Informatica Power Center 8.6/7.1/6.2/5.1, DataStage 7.5.2/8.0.1 Server and Parallel.
• Business Intelligence: Oracle Business Intelligence Application 7.9.x
• RDBMS: Oracle11/10g, 9/8i, IBM DB2 UDB 8.1/7.0, MS SQL Server 2003/2000, Access7.0/2000.
• Tools: Toad, Quest Central for DB2, SQL Loader, SQL Developer, Erwin.
• Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C
• Operating Systems: UNIX AIX 5.1 , Windows NT, Windows 95/98/00/xp, Linux, Solaris.
• Scheduling tools: DAC Data Warehouse Administration Console .
• Internet Technologies: HTML, XML, ASP, ASP.net, JSP, VBScript and JavaScript.

Professional Experience:

Confidential

Tableau Lead

Responsibilities:

• Actively participated in clarification meeting with the Clients.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Created customized Calculations, Conditions and Filter Local, Global , Parameters, Groups and sets for various analytical reports and dashboards.
• Primary point of contact for Production Support issue resolution.
• Providing infrastructure sizing, including hardware and software requirements.
• Plan, design and execute performance tests of the platform.
• Analyze, troubleshoot and tuned product performance and deployment issues when required, during implementations and post go-live.
• Tableau Administration and support.

Environment: Tableau Desktop, Server v8.2, MSAccess, Excel, SQL, PL/SQL, SQL Server Visual Studio Management, Windows Server 2008 R2.

Confidential

Tableau Lead/Architect

Responsibilities:

• Continuous process improvement.
• Primary point of contact for Production Support issue resolution.
• Defined and guided the definition of technical architecture to meet business requirements in infrastructure and applications products implementations.
• Providing infrastructure sizing, including hardware and software requirements.
• Plan, design and execute performance tests of the platform.
• Analyze, troubleshoot and tuned product performance and deployment issues when required, during implementations and post go-live.
• Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
• Defined and assisted with best practices during implementation and integration of Tableau Platform.
• Actively involved in gathering requirements from end users, involved in modifying various technical functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created customized Calculations, Conditions and Filter Local, Global , Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Created Table of Contents TOC , a common navigation page which had all the links to various reports.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Actively participated in clarification meeting with the Clients.
• Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite Offshore coordination to ensure the completeness of Deliverables.
• Tableau installations/Upgrades, configuration and administration.
• Capacity planning and configuration changes.
• Developing Tableau Dashboards and views.
• Developed AD Sync and Backup Scripts for improved automation.
• Installing and configuring SSL certificates.
• Installing and configuring SAP GUI.
• Setting up the HA environment.
• Taking the backup of postgressql tables using the extracts.

Environment: Tableau Desktop, Server v7.8/8.1.7/8.2, Teradata, Teradata SQL Assistant, SQL, PL/SQL, SQL Server Visual Studio Management, Windows Server 2008 R2.

Confidential

OBIEE Lead Architect

Responsibilities:

• Continuous process improvement.
• Assist to ensure adherence to regression and load testing processes to be followed by application development teams.
• Process to keep track of changes made to configurations in OBIEE production environment.
• Assist to implement the required control and governance processes for greater availability stability of OBIEE production environment.
• Enhancements to existing Unix / Perl scripts for improved automation and monitoring.
• Coordination with Customer teams for issue resolution / root cause analysis on Web sphere environment issues, Unix environment issues and SAN, NFS, IWA, Clear trust, LDAP security environment issues, etc.
• Identify and clean up the unused iBOT in production environment.
• Identify opportunities for cleanup of RPD objects in consultation with GBI team.
• Oracle SR support pertaining to OBIEE product related issues.
• OBIEE web catalog migration to Test, Pilot Production environments.
• Assisting in RPD audits.
• Support Load testing and Performance improvement.
• Monitoring OBIEE environments CPU utilization, memory utilization, concurrent usage and web sphere threads.
• OBIEE software installation and maintenance.
• Tableau software installation and maintenance.
• Capacity planning and configuration changes.
• Performance improvement.
• Developed AD Sync and Backup Scripts for improved automation.
• Installing and configuring SSL certificates.
• Installing and configuring SAP GUI.
• Setting up the HA environment.
• Taking the backup of postgressql tables using the extracts.
• Pager Support.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Worked on drill through reports by creating HTML references.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Oracle Business Intelligence 10.1.3.4.1/11g, Tableau Desktop/Server 7.x/7.8, OBI Publisher, BI Office, Oracle 11g, Visual Studio 2005, SQL Developer 1.1.3., Windows XP/ NT, UNIX, AIX5.x/7.x, Shell scripting , Team FordgeTortoiseSVN, Remedy 7.0.

Confidential

Sr. OBIEE Developer/Architect Nov 09 Apr 12

Responsibilities:

• Designed/Implemented BI solution for Kuali Financial System's General Ledger Modules.
• Gathered user requirements by conducting interviews, identifying ISW reports and created SR's and CR's from the gathered requirements.
• Handled multiple projects both Kuali Financial System's and Student Administration System.
• Managed repository daily using OBIEE 10.1.3.4 Admin Tool. Created dimension hierarchies to support drill-down/aggregation. Created user based views in presentation layer catalog folders by assigning group permissions. Worked with session/repository variables. Always ensured no global consistency errors/warnings. Implemented Security with External tables.
• Worked on Financial Analytics, Supply Chain and Order Management Analytics and customized SDE and SIL mappings for different Source containers like Oracle R12 and People soft 8.9.
• Worked on Core Modules like GL, AP, AR.
• Monitored performance by creating OBIEE's Usage data model/subject area. Improved performance by using aggregate navigation, indexes and materialized views.
• Created Metadata Dictionary for each subject areas created.
• Migrating RPD and Catalog changes from DEV to SUP and PROD.
• Designed approximately 100 reports with drilldown, pivot, bar charts, view/column selectors, guided navigation, direct database requests in Answers each with varying levels of complexity. Configured dashboards for different groups of users according to security level high, medium, low . Created iBots to generate alerts and delivered it to target users.
• Received excellent feedback from Users, Accounting Manager and Director of Business Intelligence. Currently system is also being used for reconciliation purposes.
• Created new Repositorys/Subject areas and merged the same with different environments which are Demonstration, Development, Test, Support and Production using Subversion.
• Restarting the BI Servers with RPD changes, Running Cache Scripts and Catalog Merging on Dev and Sup environments on Linux.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Extensively worked on Answers, Dashboards and Security for users. Worked on creating complex reports.
• Created Dashboards and Reports based on Location using MapViewer.
• Passed parameters between Mapviewer and a Dashboard Prompt to change the maps as we change the prompt option.
• Created various Static and Dynamic variables for different report and Security requirements.
• Worked on Single Sign On security for users based on LDAP Authentication type in Production and also other Authentication types External table authentication and Database in other environments.
• Creating new measures as well as modifying the existing measures at RPD levels.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository. Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Configured Delivers- iBots to alert the Marketing team about business changes based on the requirement.
• Involved in Logical and Physical Database design and Star Schema design, Snow flake Schema, Fact tables and Transaction tables.
• Created Staging jobs using Datastage.
• Worked on Data Extraction Transformations, Loading, Conversions and Analysis.
• Involved in the continuous enhancements and fixing of production problems and solving Jira Tickets.

Environment: Oracle Business Intelligence 10.1.3.4, OBI Publisher, BI Office, DataStage 7.5.2/8.0.1 Server and Parallel, Oracle BI Apps 7.9.6v, Oracle 11g, SQL Developer 1.1.3., Erwin 4.1, Windows XP/ NT, UNIX, Linux, Shell scripting , JIRA, TortoiseSVN 1.6.1/1.6.7.

Confidential

Sr. OBIEE /Informatica Consultant/Architect

Responsibilities:

• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Worked on Supply Chain and Order Management Analytics, Sales Analytics, Marketing Analytics and customized SDE and SIL mappings for different Source containers like Oracle R12, Siebel 6.3.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Identified the Facts and Dimensions based on the design specification.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Extensively worked on Answers, Dashboards and Security for users. Worked on creating complex reports.
• Created various Static and Dynamic variables for different report and Security requirements.
• Worked on Single Sign On security for users based on LDAP Authentication type in Production and also other Authentication types External table authentication and Database in other environments.
• Migrated Analytics RPD and Webcat from one environment to another.
• Expertise in Setting Up Multiuser Development Environment MUDE Using Oracle BI Administration Tool.
• Creating new measures as well as modifying the existing measures at RPD levels.
• Created Dashboards and Reports based on Location using MapViewer.
• Created Prompts in OBIEE to change as we navigate in a Map.
• Imported the Physical Meta Data from Various Data marts into the Physical Layer by defining the connection pool settings.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked on the Time Series Wizard and implemented time comparison measures.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Configured Delivers- iBots to alert the Marketing team about business changes based on the requirement.
• Interacted with Business Analysts and client representatives in doing research and solving client specific data issues.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Modified the customer and product hierarchies by assigning custom attributes to various levels in the hierarchy tree structure.
• Involved in Logical and Physical Database design and Star Schema design, Snow flake Schema, Fact tables and Transaction tables.
• Used Informatica Workflow Manager to Maintain Tasks Sessions, Email Notifications and Scheduling using Task Developer, Workflow Manager, Worklet Designer.
• Extensively designed the mappings using the Source Qualifier, Filter, Joiner, Lookup, Update Strategy, Normalizer, Aggregator, Union transformations.
• Defining a suitable architecture for data integration from multiple, disparate data sources including legacy systems, relational databases, flat files, message queues, spreadsheets, etc.
• Worked on Data Extraction Transformations, Loading, Conversions and Analysis.
• Involved in the continuous enhancements and fixing of production problems.

Environment: Oracle Business Intelligence 10.1.3.4, OBI Publisher, OWB10g, Oracle BI Apps 7.9.5v, Oracle 10g/9i, SQL Server 2005, Erwin 4.1, TOAD, Windows XP/ NT, UNIX, Shell scripting and QC 9.0.