PROFESSIONAL SUMMARY:

• Eleven years of overall IT experience in a variety of industries and environments including seven years of experience as a Data Warehouse Architect specializing in Business Intelligence development.
• Extensive experience in multiple industries including healthcare, finance, telecom, insurance, and retail.
• An accomplished project and people manager experienced in management of on - shore and off-shore teams up to twenty-five members including hiring, mentoring, and reviewing performance.
• Creative problem solver with advanced analytical, planning, and scheduling skills with a focus on timely delivery. Innovative thinking while researching solutions to tackle business and technical problems.
• Proven hands-on experience with development best practices including project plan development, requirement analysis, defect resolution and deployment of completed code.
• Oracle Certified SQL Expert & Oracle Business Intelligence (OBIEE) Certified Administrator.
• Excellent analytical, communication, project management and team-building skills coupled with a passion for customer satisfaction.

TECHNICAL SKILLS:

Business Intelligence: OBIEE 11.1.1.7/10.1.3.4, BI Publisher, Siebel Analytics 7.8, Business Objects

Database: Oracle 11g/10g/9i, Teradata 10, Sybase, Oracle SQL Server 2005/2000

Development Tools: SQL Developer, Toad, SQL *Plus, Oracle JDeveloper

Oracle Fusion Middleware: Oracle WebCenter 11.1.1.7 Spaces/Portal, Oracle Enterprise Manager, WebLogic

CRM Tools: Siebel Converge 6, Siebel 7.7 enterprise

Change & Defect Management: Win CVS, Visual source safe, HP Quality Center 10, Rational Quality Manager

Languages: C, C++, Java, Perl, AUTOIT scripting, Unix Shell Scripting

Web Technology: Oracle APEX, HTML, XML, Java Script, PHP

Operating Systems: Microsoft Windows, Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential

Technical Architect

Responsibilities:

• Research Oracle Business Intelligence Publisher and develop report bursting solution. Train developers to configure and implement BI Publisher and oversee developed code. Create documentation for BI Publisher standards, best practices and common errors to avoid.
• Research and develop WebCenter Spaces to host OBIEE reports. Setup connection to integrate OBIEE and Web Center. Develop Java code to allow ETL process to upload xml files onto Spaces using REST API. Implement custom page templates with Javascript for visual effects.
• Research Oracle APEX as a no-cost alternative for internal website development. Implement an existing portal website using APEX.
• OBIEE Administrator
• Maintain and supervise teh enterprise BI server on different environments including VM/Dev/QA/Prod. Setup and monitor usage tracking and take necessary steps for performance improvement. Perform periodic upgrades and patches to fusion middleware and relevant development tools. Responsible for updating and maintaining custom OBIEE skins, cascading stylesheets, images and Javascripts after each upgrade cycle.
• Perform technical code review for developers. Merge reviewed repository and catalog with Master Repository and perform teh migration and deployment. Update repository seeds for future development cycles.
• Implement OBIEE content and data level security. Create and manage users, roles and groups and assign permissions using WebLogic Enterprise Manager and Console.
• Web Center Moderator
• Develop and deploy WebCenter Spaces and sites to host various OBIEE dashboards.
• OBIEE Developer
• Develop current Oracle Discoverer portal reports in OBIEE 11g.
• Participate in functional design workshops to establish requirements and deliverables.
• Collaborate with data modelers and ETL developers to design and implement table structure changes and load strategy.
• Involved in teh development of PL/SQL scripts for pre & post session processes to automate daily loads.
• Construct end-to-end BI model from metadata repositories to reports. Develop OBIEE metadata repository by designing teh physical, business and presentation layers. Develop OBIEE Dashboards with reports and prompts based on designed repository.
• Perform thorough unit testing on developed reports. Present technical workshops to promote knowledge-sharing with teh team.

Confidential

Architect

Responsibilities:

• Project Leader for Data Warehouse and OBIEE Projects with American Express
• Directed teh overall process of teh migration of Sybase DW to Teradata DW from conception through deployment
• Involved in requirement analysis, database design, coding, testing, implementation and maintenance of Teradata DW during teh complete migration process
• Communicate with teh clients and business analysts and set realistic expectations towards project completion
• Develop and design Extraction Transformation and loading of data from source systems into staging by applying various transformation rules
• Design teh OBIEE metadata repository, configure teh data model, Develop current Oracle Discoverer portal reports in OBIEE 11g, web catalog objects and report dashboards
• Coordinate with testing team for test data setup during system testing, defect analysis, defect resolution and code review
• Resource and task allocation and mentoring of teh team
• Experience in writing stored procedures (PL/SQL) and triggers using Oracle.
• Conduct periodic review meetings to monitor progress of project and budget, as well as ensuring timely completion of teh project and satisfaction of teh client

Confidential

Sr. DW and BI Lead

Responsibilities:

• Lead and Onsite/Offshore coordinator for multiple DW and BI projects with teh health insurance company WellPoint
• Managed local and offshore QA resources in teh testing of Business Intelligence applications, such as Business Objects and Data Warehouse projects involving Teradata and Unix
• Vetted information from clients on business specifications document, functional requirements document, technical specifications document, and business scenarios
• Developed test plans, test strategy and test evaluation summaries and presented teh test package to clients
• Extensive experience in front-end report testing and doing back-end database level manual testing
• Developed SQL and PL/SQL in Unix shell scripts
• Adept in creating and executing test cases while employing quality-assurance methodologies
• Conducted daily status calls with business owners, developers and testers to measure project progress

Confidential

Sr. CRM and OBIEE Administrator

Responsibilities:

• Lead Siebel Analytics and Siebel CRM Administrator involved in migration project for AT&T Wireless
• Responsible for installation, configuration, administration and deployment of Siebel CRM and OBIEE in Siebel environments including Dev/QA/Prod
• Configured Siebel Application SSO using Windows NT Domain Autantication
• Integrated Oracle BI with Siebel CRM for seamless interaction of analytics and CRM

Confidential

Administrator

Responsibilities:

• Developer for three health care products: Pharmacy Order Management System, Medical Order Management System and Electronic Medical Administration Record
• Responsible for site-specific customi zation of teh product for hospitals by gathering requirements, creating design documents, developing and delivering teh final product
• Worked on website customization for hospitals using Java scripts, AutoIT and PL/SQL scripts

Confidential

Programmer

Responsibilities:

• Developer for Kitchen Cabinet Design division
• Bundled and deployed catalogs and change requests to stores; evaluated and rectified deployment and rollout issues
• Member of Development Team to create a Catalog Automation Tool in Java

Confidential

Analyst

Responsibilities:

• Team lead for deploying new versions of Siebel CRM
• Administrator for an internal web server portal for British Telecom
• Maintained Siebel servers and Oracle database servers