SUMMARY

• Highly motivated, detail oriented Business Intelligence individual with around8 years of successful experience in enterprise business intelligence, requirements gathering, designing, and implementing software solutions to support strategic business objectives.
• An effective communicator with keen problem - solving skills who can easily interface with end-users, technical teams, and professionals at all levels with hands-on experience in Finance, Healthcare, and Medical modules.
• Have 7+ years of proven experience in implementing Siebel Analytics/OBIEE and OBIA 7.9.5.x & 7.9.6.x from end-to-end covering full implementation lifecycle of Siebel Analytics 7, OBIEE 10g & 11g, OBIA 7.9.5.x & 7.9.6.x and now the latest version OBIA 11.1.1.8.Fully involved in development, Bug Fixing & Fine Tuning of Oracle BI Applications (OBIA) v 7.9.6.3, 7.9.6.2, 7.9.6.1.
• Hands-on experience with OBIEE 10g & 11g installation and configurationwith Oracle Data Integrator 11g on both Windows64, Linux64 including implementation of version control and disaster recovery process.
• Strong understanding of Oracle Business Intelligence Enterprise Edition (Siebel Analytics), Oracle BI Publisher, Oracle BI DAC, Informatica Power Center, and Database environments.
• Experience in Oracle 11i/10g, SQL Server 2000, TOAD 7.6, SQL *LOADER, SQL *PLUS, Stored Procedures with strong exposure to creeating Procedures, Functions, Triggers and other database objects using SQL.
• Experience serving as a business/technical liason along side focusing on different areas like Frontend Support (Oncall - Tier 2 & 3), Deployment, Release Management and, Project Management.
• Proficient in Siebel Server Administration Tool, Siebel Answers, Siebel Dashboards, Siebel iBots and Siebel Delivers.
• Proven experience in developing reports using OBIEE, Siebel Analytics 7.8.5/7.8.2 , Crystal Reports Designer 10/XI included with SQL expressions and basic syntax formulae.
• Expertise in configuring Metadata objects (Subject area, Table, Logical Columns) and Web Catalog objects(Dashboards, Pages, Folders, Reports)
• Solid hands on experience in customizinginteractive dashboards with drill down capabilities using global and local filters, and Siebel Security(Group, Access/Query, Privileges).
• Demonstrated experience to implement Time series for forecasting, Aggregate Navigation, and use of Aliases
• Worked extensively on Informatica Designer (Source Analyzer, Warehouse Designer, Transformation Developer and Mapping Designer) Workflow Manager/Monitor and Repository Manager.
• Empirical knowledge of all system development life cycle phases and all facets of projects from initial feasibility analysis and conceptual design through implementation, training, and enhancement.
• Motivated, energetic team player with demonstrated proficiency for learning new tools and business environments.

TECHNICAL SKILLS

BI Tools: OBIEE/OBIA11g/10g, Siebel Analytics Standalone/Integrated Version 7.8.5/7.5.3 , Siebel Data warehouse Application Console (DAC), Siebel Analytics Server (SAS), Siebel Analytic Web (SAW), Scheduler

ETL Tools: Informatica Power Center 7.1/6.2/6.1, SQL Loader, DTS

Database: Oracle 11g/10g/9i, SQL Server 2000/2005, Teradata 12.00.02, TOAD, SQL Assistant

Languages: C, SQL Scripts, UNIX Shell Scripts, SQL *Plus

Operating Systems: UNIX, Windows NT

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Oracle BI Consultant

Responsibilities:

• Responsible for conducting interviews with Confidential stakeholders to gather requirements and analyze the requirements to assist in upgrading the system that processes the loan applications.
• Performed Gap Analysis to check the compatibility of the existing reporting system infrastructure with the new business requirements.
• Worked with Oracle to put together implementation plan for installing OBIEE 11g on IBM WebSphere as opposed to hosting it on OOTB Weblogicmiddleware.
• Presented OBIEE security options closely collaborating with an offshore technical lead to implement POC for implementation of Custom Servlet Authentication on WebSphere based 11g instance.
• Managed and coordinated work with onshore/offshore team and successful in reducing 80% ofapplication defects backlog in three months.
• Closely worked with DBA’s/stake holders and established clear release processes and practices that helped in achieving business unit’s service level agreements.
• Experience in using ODICONSOLE, BIACM - Functional Setup Manager and ODI Studio.
• Built Repository using 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model mapping (create Logical tables and data source mapping) and Presentation Layer (creating presentation tables) by using OBIEE Administration tool.
• Customized and developed RPD (Physical, BMM and Presentation Layer), configured metadata objects and Web Catalog Objects and also created Drill down Hierarchies and implemented business logic for facts and dimensions.
• Worked on Presentation layer to organize different subject areas according to user requirements.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Tables, Charts, Column Selector, and Tabular with global & local Filters) using OBIEE presentation services.
• Provided developer/enduser training illustrating OBIEE 11g new features for RPD/Catalog, architectural differences which were thoroughly appreciated by Confidential technical & management teams.
• Was extensively involved in all project documentations by acting as a liaison between the different corporate departments
• Developed ODI Interfaces according to the design documents and mapping specifications.
• Design star and snowflake schemas by using ERSTUDIO.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes and generated Schema in the Database
• Developed ODI transformation logic and designed various Complex Interfaces Used various transformations such as Joiner, Union, Lookup,Filter, Expression, Aggregator etc
• Implemented and developed the migration plan for moving the repository and web catalog from DEV to UAT and PROD.

Environment: OBIEE 11.1.1.7, ODI 11.1.1.7, OBIA 11.1.1.8, Oracle 11g, Red hatHEL 6.0and Windows 2008 Server R2.

Confidential, NJ

OBIEE Consultant

Responsibilities:

• Involved in daily SCRUM meetings by actively reporting project BLOCKERS.
• Built Repository using 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model mapping (create Logical tables and data source mapping) and Presentation Layer (creating presentation tables) by using OBIEE Administration tool.
• Customized and developed RPD (Physical, BMM and Presentation Layer), configured metadata objects and Web Catalog Objects and also created Drill down Hierarchies and implemented business logic for facts and dimensions.
• Worked on Presentation layer to organize different subject areas according to user requirements.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Tables, Charts, Column Selector, and Tabular with global & local Filters) using OBIEE presentation services.
• Used ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Performed data manipulations using various Informatica transformations like Joiner, Expression, Lookup, Aggregate, Filter, and Update Strategy.
• Creation of new workflows and sessions in Informatica workflow Manager to in corporate the new mappings into the Full and Incremental loads.
• Worked closely with business Users, ETL Developers and Database Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Converted and rewritten existing reports from Actuate reports and Brio SQR 6.X.X into OBIEE reports.
• Developed packages by using ODI interfaces, procedures, variables alongside working on all three layers of the OBIEE repository to facilitate end user reporting.
• Created interfaces, Procedures, Packages and generated scenarios using ODI Designer with multiple transformations like Joiner, Union, Lookup, Filter, etc.
• Created the Load plans and specified exception behaviour and exception steps to the load plan scenarios
• Designed and developed the purge process for purging operator logs using oracle data integrator tools in the package
• Worked on Oracle Data Integrator topology manger administrative tasks.
• Created model folder, sub folders reversed the technologies to get the table structures.
• Created project folder and imported, exported the knowledge modules in different environments

Environment: Environment:OBIEE 11.1.1.6, Oracle Data Integrator (ODI) 11.1.5.0, Oracle 10g, UNIX, and Windows 2008 Server R2.

Confidential, MN

OBIEE/OBIA Lead Consultant

Responsibilities:

• Deployed OBIEE 11g platform for Financial Analytics& Project Analytics.
• Served as a Lead OBIEE/OBIA Administrator to install and configure Oracle Business Intelligence Applications on the new development, test, and production environments at the same time implementing multi tier architecture for failover and load balancing on test and production servers.
• Specific tasks include work on Repository Creation Utility (RCU), installing and configuring OBIEE 11G (Enterprise\Software-Only), OBIA 7.9.6.3 Financial & Project Analytics, Informatica Power Center 9.0.1, and DAC 10.3.4.1.
• Installed window services for OBIEE 11G AdminServer, Managed server to automate the services and have them run in the background.
• Populated Oracle Business Analytics Warehouse (OBAW) tables and configured DAC server repository connection using the serverSetupPrompt scripts, DAC system properties.
• Configured Oracle BI repository connections, repository variables, dynamic data source names besides validation all connection for DAC\Informatica\DW end-end.
• Installed and configured Informatica Power Center components and pmcmd and pmrep commands to help enable the communication between DAC and Informatica.
• Worked on ETL/DAC to implement and deploy out of the box OBIA Financial Analytics application including customization of the pre-built process jobs to meet business requirements.
• Performed post installtion tasks that include creation of Repository Services, Integration Services and setting up domain before running a full load ETL.

Environment: OBIEE 11.1.1.5, Informatica 9.0.1, BI Apps 7.9.6.3, DAC 10.3.4.1, SQL Server 2008 R2, People Soft 8.9, and Windows Server 2008

Confidential, MN

Oracle BILead Consultant

Responsibilities:

• Provided Production Support during the implementation of Initial Loads during various phases and On Call support for daily issues.
• Responsible for tier 2 and tier 3 support of OBIEE applications utilizing Confidential ’s GRS problem resolution system.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Modified logical tables, logical columns and created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created new Time series measures using AGO and To Date functions for forecasting..
• Formatted columns used in generating the requests and used various filtering options as and when needed.
• Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in many different ways.
• Customized prompts appropriately to avoid excessive data showing up in Reports and Graphs.
• Modified the UI reports for the look and feel of the reports and performed Assembly and Unit testing on various Subject areas.
• Configured Intelligence dashboards by adding embedded content such as links/images, HTML objects and folders.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Successfully implemented OBIEE delivers/Created Proactive agents (iBots) and configured Interactive dashboards to alert the Business/Field users as per the requirements.
• Involved in testing/validating and debugging the applications using SQL scripts and appropriate log files.

Environment: OBIEE 10.1.3.4, Oracle 10g, Siebel Analytics 7.8.5, Siebel eMedical, Informatica 6.2.2, WIN 2003 Server, UNIX, PL/SQL, SQL, MS VISIO Professional.

Confidential, NY

OBIEE Consultant

Responsibilities:

• Sourced requirement documents and produced functional specifications besides ceating high-level and detailed design documentation.
• Developed Ad-hoc reporting subject area and ChildStat dashboard incorporating Monthly Unit Case Load, Case Load Dispersion and Case Load by Worker reports using OBIEE 11g.
• Performed architecture and design reviews for metadata development based on the business needs as well as acted as a module / area SME.
• Designed dashboard page with a report selector prompt prompting user to select a view like Borough Summary, Zone Summary, etc by leveraging guided navigation functionality.
• Created dimensional hierarchies, case load measures besides using newly introduced 11g variable prompt.
• Implemented POC and successfully developed a dashboard with pivoted charts as desired by customer.
• Configured History tables in OBIEE RPD usng fragmentation content and session variables leveraging case-stage physical data model.
• Designed constrained dashabord prompts with presentation variables such that selected criteria can be captured and called using the same presentation variables in narrative view.
• Developed many Reports / dashboards with different Analytics Views (Drill-Down, Pivot Tables, Charts, Column Selector, and Tabular with global & local Filters) using OBIEE presentation services
• Sucessfully developed Last 7 Days Summary report showing SPARK LINE charts and Monthly Trending reports in OBIEE.
• Also worked on color gauge reports on a different dashboard that helped the users to easily analyze the reports.
• Provided a dashboard page with Objects names and definitions to help business users understand reporting terminology more clearly.
• Worked closely with end users to assist in user adaptability by providing several end user interactive training sessions.

Environment: OBIEE 11.1.1.6, Oracle Data Integrator (ODI) 11.1.5.0, Oracle 10g, UNIX, and Windows 2008 Server R2.

Confidential, IL

OBIEE Consultant

Responsibilities:

• Configured OBIEE Scheduler for implementing delivers for external suppliers simulating Vendor data using data level security.
• Involved in the requirements gathering sessions working closely with Business analysts, stake holders from Confidential ’s Parts business and MILITARY business groups.
• Worked on various reports like Purchase Order (PO) by Supplier, Open PO, PO Promotions, Supplier Metrics, and Forecast Summary exemption reports based on transactional legacy data.
• Created and designed MILITARY reports using federal and defense data.
• Implemented fragementation in OBIEE for reporting against multiple sources like Informix - Oracle, Oracle - Excel, and Oracle - Teradata combinations.
• Worked on POC for 9 Supplier implementation using session variables with row wise inititalization to filter the 9 pilot vendors for OBIEE reports.
• Developed repository, configured metadata objects (Subject Areas, LTS and LTSS) and Web Catalog Objects (Dashboards, Pages, Folders, Reports)
• Successfully implemented Ad-hoc reporting in OBIEE for reporting against 3rd Normal Form physical data model.
• Created Objects and prepared reports like financial reports, standard and adhoc reports, and universes.

Environment: OBIEE 10.1.3.4, BOXI, Informix, Teradata 12.00.02, Oracle 10g, UNIX, and Windows 2003.

Confidential

Data Warehouse Developer

Responsibilities:

• As an application datawarehouse developer involved in creating tables, views, indexes, roles, granting access to users.
• Migrated data from MS-Access databases to Oracle database using SQL *Loader.
• Designed, developed, tested and implemented packaged stored procedures, functions and triggers using PL/SQL.
• Written Ad-Hoc queries in Oracle to support marketing and sales department.
• Develop reports and publish them in DEV/UAT Crystal Enterprise environment for business users to test the reports against the UAT database environment.
• Extensively used Publishing Wizard, Crystal Management Console to publish reports to Crystal Enterprise.
• Developed reports against Stored Procedures, Views, Joins as well as Base Tables in Oracle.
• Designed complicated reports involving multiple unlinked/linked Sub reports, Cross Tabs, Groups, Parameters, Formulae, Summaries, and Running Totals.
• Responsible to overlook the work by 2 other junior Crystal Reports developers and authenticate their work and advice if needed.
• Involved in training other developers and standardizing the Data Direct 4.1/4.2 ODBC connection to Oracle Database.
• Responsible to ensure that scheduled reports gets emailed and stored on Un-Managed disk as per the recurring instances in Crystal Enterprise.
• Assisted Enterprise Team in publishing/importing the reports and instances from Crystal Enterprise.

Environment: Crystal Enterprise 9.0, Crystal Reports, SQL, PL/SQL, Windows NT, Oracle 8i, Oracle Forms/Reports 6i.