We provide IT Staff Augmentation Services!

Obiee Architect Resume

Richmond, VA

OBJECTIVE:

Project Management position with focus on Team Leadership with Business care.

SUMMARY:

  • IT professional with 12+ years of experience in the Information Technology with Strong knowledge of Business Intelligence and Data warehousing.
  • Organized and goal oriented, project management and strong business satisfaction focus.
  • Skilled in building excellent rapport with client and team members. Able to see big picture, delegate effectively and motivate team.
  • Analytical problem solver, data collector to streamline the operations and improve productivity.
  • Strong in prioritizing tasks & workload in order of importance and delivery deadlines.
  • Contribute to written proposals and RFP preparation.
  • Active participation in scoping and executing client Proofs of Concept (POCs)
  • Strong experience in Business Intelligence using OBIEE 11g, 10g and Siebel Analytics.
  • Expertise in ETL tool Informatica Power Center 9.0.1, 8.1.1/7.1.4/7.1.2/6.1.2
  • Expertise in designing star schema and snowflake schema and data warehouse design principles using Kimball.
  • Expert in developing metadata repository and strong experience in working with OBI answers, OBI dashboards and OBI Delivers & Publisher.
  • Over 6+ years of experience in ETL development including data sourcing, data transformation, data mapping, Data Archiving and data loading using Informatica
  • Working Knowledge on OWB including predefined and custom transformations, performance tuning, auditing etc..
  • Extensive experience in Oracle 11/10g and MS SQL server environments.
  • Expertise in logical and physical data modeling, forward engineering and reverse engineering using Erwin data modeler
  • Expertise in SQL and PL/SQL coding through various procedures, functions and packages to implement the business logic
  • Expert in understanding business requirements and translate them to technical design specifications
  • Expert in Unix Shell/Perl scripting.
  • Excellent communication, self - motivated, positive attitude, ability to manage team and ability to work independently or co-operatively in a team
  • Willing to learn new concepts and methodologies
  • Possesses excellent interpersonal and communication skills
  • Working knowledge of Agile methodology.

TECHNICAL SKILLS:

Operating Systems: Windows NT, XP, 2000, UNIX (Sun Solaris), Linux

Languages: C, Pro* C, C++, SQL, PL-SQL, JAVA

Databases: Oracle 10g/9i/8i and Ms-SQL Server 2000

RDBMS: Oracle, Sybase, MS-Access, and SQL Server 2000

ETL Tools: Informatica 9.0.1, 8.1.1, 7.1.2

Business Intelligence: Oracle Business Intelligence 11g / 10.3.4.1

CRM: Siebel CRM, EIM

Scripting Languages: VB Script, Java Script, Shell Scripts and Perl

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

OBIEE Architect

Responsibilities:

  • Responsible for Deliverables for all the OBI projects, IR-FR reporting / BAU Activities.
  • Ensuring architectural alignment of the designs and development.
  • Responsible for full application lifecycle, including requirements management, architecture, coding, testing, tracking, and release management.
  • Liasoning between multiple team for layout a plan and implement the plan.
  • Support incident management, change management, and problem management processes
  • Design and Review of OBIEE Repository/ Dashboard / Data warehouse.
  • Impact Analysis and LOE for Changes in the Reports/ETL or any new OBI Project.
  • Demo the capabilities of OBI to different divisions and get more business to the IT Team.
  • Upgrade of OBIEE from 10.1.3.4.1 to 11g
  • Manage development team(Mentor the Team) and get Development done from offshore
  • Manage multiple development instances and provide solutions.
  • Manage the ticket queue
  • Create the Operations slides/Usage metrics every week for functional owner of the application.

Environment: OBIEE 11g, Informatica Power Center 9.0.1, Oracle 11g, Toad, HPSM, HP ALM

Confidential, Shelton CT

OBIEE Tech Lead

Responsibilities:

  • Design, Review and Documentation of OBIEE Repository/ Dashboard
  • Impact Analysis and LOE for Changes in the Reports/ETL
  • Managed creation of Linux scripts to automate admin activities
  • Responsible for Oracle SR’s
  • Upgrade of OBIEE from 10.1.3.2.1 to 10.1.3.4.1
  • Upgrade of site minder / Apache
  • Managing OBIEE Admin tasks like moving codes, managing servers etc.
  • Managing team and get Development done from offshore
  • Managing multiple DB instance and FE instance
  • Manage the ticket queue and Instance calendar
  • Create the Operations slides/Usage metrics every week for functional owner of the application.

Environment: OBIEE 10.1.3.2.1 , Informatica Power Center 8, Oracle 9i v2, Toad 8.5.3,SSH for Unix, Linux red Hat X86 64

Confidential, IL

Lead Siebel analytics/OBIEE consultant

Responsibilities:

  • Installation and configuration of Siebel Analytics 7.8.5 and applications 7.8.4
  • Installation and Configuration of Informatica 7.1.2 and DAC
  • Design, Development and Configuration of Marketing analytics repository.
  • Configured Target level, qualified list items and List catalogs.
  • Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data warehouse from the Siebel Database.
  • Worked on EIM to import data for Siebel DB from the other legacy system
  • Involved in development of batch and Configuration files which are used for Running EIM Process for loading the data to base tables periodically in batch mode.
  • Configured Analytics Repository to populate new custom fields/OOTB fields per client’s reqt.
  • Created Dashboard/Reports using OOTB / Custom fields per BRD
  • Design, Development and Documentation of the Analytics RPD and webcat
  • Design, Development & unit testing for new 1: N as well M:M requirements.
  • Configured Primary Position based security in the Repository.
  • Developed Role-Based Dashboards for Managers and Business Heads to review the. Revenues, Opportunities and Accounts
  • Developed new mappings and WF and finally build the custom DAC execution Plan.
  • Extensively worked on the analytics repository.
  • Created some complex reports using Dynamic Repository variables.
  • Created Dashboard prompts for year, Sales Stage and Line of Business.

Environment: Siebel Analytics 7.8.5, EIM, Informatica Power Center 7.1.2, Oracle 10g v2, Toad 8.5.3,SSH for Unix (AIX)

Confidential, CA

Lead Siebel analytics consultant

Responsibilities:

  • Generated reports extracting data from database using Informatica.
  • Developed Role-Based Dashboards for Managers and Business Heads to review the. Revenues, Trend analysis, quote turn around.
  • Created Dashboard prompts for year, Currency, Products.
  • Extensively worked on the analytics repository.
  • Created joins and dimensions in BMM layer.
  • Added some new fields for new attributes for the requirement into OLAP.
  • Worked on EIM to import data for Siebel DB from the other legacy system
  • Developed batch and Configuration files for Running EIM Process for loading the data to base tables from interface tables periodically in batch mode. Used Import, Export, Delete and Merge
  • Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data warehouse from the Siebel Database.
  • Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, and re-usable transformations.
  • Snowflake Schema was mainly used with Quote, Customer, Product, and Time as basic dimensions. Data from operational tables were converted to few Dimensional tables, one fact table.
  • Implemented complex logic using some transformations such as Expression, Filter, Aggregate, Lookup, Update Strategy, Router and Rank transformation.
  • Developed Documentation for all the routines (Mappings, Sessions and Workflows) and wrote the Test scripts.
  • Extensively working on the production support.
  • Worked on lot of license transfer issues.
  • Created new reports/Dashboards on Oracle BIEE after upgrade.

Environment: Siebel Analytics 7.7.14, Siebel EIM, Informatica Power Mart 6.2.1, Oracle 10g v2, Toad 8.5.1.

Confidential, Madison, WI

Siebel Data Warehouse ETL/ Analytics Developer

Responsibilities:

  • Analyzed Business requirements for the reporting needs.
  • Developed the repository - physical, logical and presentations layers.
  • Generated Reports such as product based YTD and MTD Profit and revenues.
  • Created and published iBots to obtain weekly Sales report for sales managers.
  • Developed Role-Based Dashboards for Managers and Business Heads to review the Forecasts vs. Revenues.
  • With Security settings in Siebel Analytics Admin Tool, created users, groups’ access privileges and query privileges.
  • Created Variables in repository according to the requirements.
  • Generated reports extracting data from database and flat file combining two different sources.
  • Worked on EIM to import data for Siebel DB from the other legacy system
  • Developed batch and Configuration files which are used for Running EIM Process for loading the data to base tables periodically in batch mode.
  • Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Mart from the various source systems.
  • Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, and re-usable transformations.
  • Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables
  • Snowflake Schema was mainly used with Geography, Customer, Product, and Time as basic dimensions. Data from operational tables were converted to few Dimensional tables, one fact table and three aggregate tables.
  • Worked with Repository Manager for managing of repositories, creation of users, creation of user groups and folders.
  • Implemented complex logic using some transformations such as Expression, Filter, Router, Look-up, etc.
  • Created different source definitions to extract data from flat files and relational tables for Power Mart.
  • Used Aggregate, Expression, Lookup, Update Strategy and Router and Rank transformation.
  • Extensively created stored procedures, SQL scripts.
  • Developed Documentation for all the routines (Mappings, Sessions and Workflows).

Environment: Siebel Analytics 7.7, Siebel EIM, Informatica Power Mart 6.2.1, SQL Server 2000, Erwin, and Windows 2000 Advanced Server.

Confidential, Springfield, MA

Siebel Data Warehouse and Analytics Developer

Responsibilities:

  • Primary responsibilities include requirement gathering, designing the ETL functional and technical specifications and developing the Transaction database.
  • Developed the database comprising of three facts and integrated the three facts using conformed dimensions and aggregate tables.
  • Developed Logical and Physical data models using Erwin.
  • Primary responsibility also included support and maintenance of data in the transaction database on a daily basis (daily incremental loads) to support the Siebel analytics reporting.
  • Developed the staging tables to provide a snapshot of our daily loads.
  • Used Star schema design to build the data mart/data warehouse.
  • Used ERWIN 4.0 as the data-modeling tool.
  • Created and managed User privileges using the repository manager.
  • Developed the error processing strategy to handle the errors in the daily incremental transactions.
  • Worked on Informatica - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
  • Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.
  • Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
  • Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
  • Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules, security, and test cases in the process of building the transaction data mart.
  • Developed a Batch file to archive the bad files. All the batch files that are developed reside on the machine where Informatica server was installed.
  • Assisted in creating custom reporting solutions using Siebel Analytics
  • Assisted in the Design and development of the Reporting System using Siebel analytics
  • Worked on reports like Account shipment growth by quarter, Average order selling price by product line.

Environment: Erwin 4.0/3.5.x, Informatica Power Center 7.1/6.1, MS SQL Server 2000, SQL Query Analyzer, PL/SQL, Siebel Analytics 7.7, Excel and Windows NT

Confidential, Charlotte, NC

Data warehouse/ Siebel Analytics Developer

Responsibilities:

  • Worked with Business Users, Discussed and Identified requirements for adding new columns to the warehouse tables.
  • Created Informatica mappings to pull in the newly added columns to the Siebel Relationship Management Warehouse (SRMW).
  • Performed the Incremental ETL process to populate the Data Mart.
  • Performance tuning of the Customized ETL Mappings and Sessions.
  • Modified the Physical Layer of the Analytics repository to reflect the changes in the SRMW pertaining to the newly added columns.
  • Built the Logic in the BMM layer to make proper connections and created new logical columns based on the newly added physical columns.
  • Exposed the columns in the Presentation layer in the proper Presentation catalogue.
  • Responsible for creating additional Users and maintaining Visibility Privileges using Analytics Administration on Repository side as well as front end to display reports based on the business user for that particular area.
  • Worked on customizing the Activity and Revenue fact groups by adding new columns to the fact and dimension tables in SRMW.
  • Developed Role-Based Dashboards for Executives, Account Managers and Account Supervisors.
  • Created reports on budgets and forecasts.
  • Created reports for analyzing the renewed contracts by month and geography.
  • Generated reports for analyzing the revenue generated by various consultants in different departments.

Environment: s: Siebel Analytics 7.5.1, Informatica 6.2.1, Oracle 9i/8i, SQL Server 2000, Windows XP Professional.

Confidential, Texas

Programmer / Analyst

Responsibilities:

  • Analysis and design for the Archiving and Rebuilding History Data.
  • Created Pro* C programs for Archiving and Re-building the data.
  • Created various shell scripts for creating tables, Indexes and stored procedures.
  • Wrote C/ C++ programs and perl scripts for conversion of the text files.
  • Wrote various shell scripts for log & error files as well as monitoring processes.
  • Testing of codes and scripts on test box
  • Wrote test plans and documentation.

Environment: C, C++, Pro* C, UNIX, Perl, Sybase Adaptive Server 12.0 and Windows NT.

Confidential, Arizona

Application Developer

Responsibilities:

  • Developed screens for data entry and approval screen using DHTML.
  • Provided necessary data validation checks against data entry.
  • Involved in coding such as stored procedures in SQL server.
  • Created various Servers, Record set and Command objects.
  • Retrieved/Updated the database using ODBC.

Environment: Visual InterDev 6.0, SQL Server 7.0 and Windows 98.

Hire Now