SUMMARY

• 17+ years of experience in the information technology industry as a hands - on Data Warehouse Architect and Principal Technical Consultant with expertise in full development life cycle of Data Warehouse/ETL and Business Intelligence.
• Top level expert in business intelligence specially in OBIEE, BIP and Essbase
• Experience of managing offshore team of 4 years.
• Expertise in developing OBIEE repository with Physical, Logical and Presentation layers build reports/dashboards from the repository using OBIEE (Siebel) Answers and troubleshoot various technical issues and bugs.
• OBIIEE Administration, installation, upgrades, security management, and patch installation.
• Designed and developed ETL processes utilizing Oracle Data Integrator (ODI) to develop a consolidated Warehouse to support corporate wide reporting and analytical initiatives
• Developed various Dynamic and Interactive Dashboards/Reports with intuitive drilldowns, drill-across and drillable charts using Oracle Answers. Experienced in BI Publisher, MS Office Plug-in for rich reporting and Oracle BI Scheduler Configuration for Alerts / iBots.
• Expertise in Data Warehouse tools such as Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB), COGNOS and Discoverer etc.
• 8 years of OBIEE experience
• 3 years of Oracle Data Integrator (ODI) experience
• 8 Years of Oracle Warehouse Builder experience
• 8 Years of experience in working on Linux/Unix Platform
• 14 years of Oracle Development and administration experience.
• 10 years of experience in the design and implementation of medium to complex logical & physical data models. Created Atomic level DWH and Data Marts and 3NF Data models for a number of clients. Extensive experience with Data modeling tools such as Erwin, Designer and ER Studio etc.
• 4 years of Teradata experience
• 12 Year of PL/SQL experience
• 6 Year of reporting tool experience including Discoverer, Cognos, Crystal report, Application Express and OBIEE.

TECHNICAL SKILLS

Operating Systems: Solaris, Rack, Unix, Windows 2000, Windows XP, Windows NT 4.0, HP, Windows 95, and DOS.

Databases: Oracle 8i/9i/10Gr2/11G, SQL Server 2000, SQL Server 6.5 & 7, & 8i, MS-Access, Teradata, DB2 and Sybase.

Major Tools: OBIEE 10.1.3,4.1, Oracle Warehouse Builder 10G R2, Erwin, Designer, PL/SQL, Cognos ReportNet, Discoverer Desktop, Discoverer Viewer, MTS, UML, Erwin, Visio, MSXML, XML Authority, XML Instance, Crystal Report, IBM MQ Series.

Languages: Shell, Perl, Visual Basic, Net, Visual Basic (4, 5, 6), C#, Smalltalk, PowerBuilder, C, Java Script, VB Script.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. OBIEE/OWB Team Lead/Architect

Responsibilities:

• Confidential is one of the top universities in the world which needed to consolidate multiple data warehouse applications including Student, Financial, employee into one enterprise wide data warehouse to enable business user generate consolidated reports and perform analysis. As a technical team lead was responsible to integrate these applications, install and setup OBIEE, and ODI. Worked in all areas of DW development lifecycle including data modelling ETL, OBIEE Installation, RPD and Dashboard development, quality assurance, code promotion and production support. Consolidated all ETL process developed in OWB and created new process flows and interfaces using ODI.
• Installed ODI, created repositories, set up the ODI connection, Topology including physical architecture, logical architecture and context.
• Designed the ETL flow and interfaces to implement ETL and load SDW data warehouse.
• Performance tunes ETL refreshes, validated load and completed production stabilization phase.

Technologies: OBIEE 10.1g, 11.1.1.6g, ODI 11g, OWB 11.6g, Business Object, Oracle database, Platform Linux Red Hat.

Confidential, West Kingstown, RI

Sr. OBIEE Team Lead/Architect

Responsibilities:

• As a hands on team lead on a large project with three tracks was involved in upgrade of OBIEE from 10g to 11g, upgrade of Informatica 8x to 9x, migrating Cognos PowerPlay cubes to Essbase cubes, integrating them into OBIEE, incorporating new functional requirements into OBIEE, defining migration process, trouble shooting, patch installation, security management. I was also responsible of multiple teams both onshore and offshore with up to 12 resources. Main hand on activities involved architecting, designing and implementing OBIEE new project and their integration with Essbase.

Technologies: OBIEE 10.1g, 11.1.1.6g, Informatica 9x, Oracle database, Platform Linux Red Hat.

Confidential, Chicago, IL

Sr. OBIEE Team Lead/Architect

Responsibilities:

• My role included participation in project scoping, requirement analysis, estimation, architecture, design, implementation and Production support.
• Provided expertise on a number of OBIEE and BI projects in order to improve performance, stability and scalability by re architecting and re designing project components and processes.

Technologies: OBIEE 10.1g, 11.1.1.6g, Oracle database, Exadata, Platform: Linux Red Hat.

Confidential, Chicago, IL

Sr. OBIEE Team Lead/Architect

Responsibilities:

• Developed BI project roadmap, project scoping, and requirement gathering from business, estimation, architecture, design, implementation and deployment. Responsible for server administration, code migration, security implementation and management, OBIEE upgrade from 10g to 11g
• Worked on a number of Large projects for Confidential to analyze the performance of Flight operation, Baggage delivery, financial analysis of different product including ticket sale, loyalty program, baggage fee, Cargo, loyalty program etc.
• Created a number of Dashboard and complex reports including Summery, detail and chart base reports.
• Upgraded their environment from 10g to 11g and also installed Essbase and integrated it with OBIEE.
• Help Confidential build an OBIEE team, trained their resources in the OBIEE and Teradata, established BI best practices and was involved in complete development life cycle.
• Responsible for integration and consolidation of back end data and front end reporting of United and Continental airline.
• Developed Java program to remotely schedule and FTP BIP reports
• Used complex OBIEE techniques like Aggregate navigation, Level based measures, dynamic charts with selectable X and Confidential -Axis, external database security, integration with LDAP, integration of multiple data sources, Custom Java action button, Integration with external web sites etc.
• Implemented OBIEE performance layer
• Worked extensively on creating new reports in Hyperion Brio and also migrated a number of reports from Brio to OBIEE 11g.

Technologies: OBIEE 10.1g, 11.1.1.6g, Teradata, Hyperion Brio, Oracle database, Crystal Report and, Linux.

Confidential, Lisle, IL

Sr. OBIEE Team Lead/Developer

Responsibilities:

• Responsibilities in this project included setting up OBIEE environment, Data modeling, creating dashboard, complex reports using Answer and delivering reports to end user using OBIEE delivers.
• Integrated OBIEE with Essbase cube to produce reports and dashboard and integrate it with corporate security.
• Responsible for all OBIEE Physical layer, Business Layers and Presentation layers.
• OBIEE repository administration, code promotion and performance tuning.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.
• Created OBIEE Star Schema in RPD semantic layer based of 3NF data model to allow Ad Hoc reporting and creation of Standard reports.
• Developed ETL using Oracle Data Integrator (ODI) 11g.
• Goal of the project was to integrate a number of legacy and ERP source systems like Oracle EBS, Maximo, Demantra etc and created a unified data warehouse for OBIEE reporting.

Technologies:used included Oracle Database, Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.1 & 11.1.1.3.1 , DataStage, Teradata, ODI 11g, Oracle, SQL server, DB2 and Toad Data Modeler, Platform Linux etc.

Confidential, Chicago, IL

Sr. OBIEE Team Lead / Architect

Responsibilities:

• Completed project discovery phase to define key performance indicators, revenue categories and key area of analysis.
• Conducted interviews with project stakeholders, business users, analysts and subject matter experts and completed Business Requirement document.
• Created BI Program roadmap, implementation plan, data model including ER Diagram and Star schemas,
• Installed and configured complete suite of OBIEE 10.1.3.4 in test and development environment on windows platform.
• Created the new RPD and detail level drill downs to as per business requirements using Oracle Answers.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Worked on the different layers in the data model (Physical, Business and Presentation).
• Involved in gathering and analyzing requirements and documenting them for further implementation.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle. Goal of the project was to create an enterprise data warehouse consolidating information from source systems like AMS-CRM, Oracle Financials and other legacy systems and expose it to business and analytical users for monitoring performance, analysis and other reporting purposes through OBIEE dashboard containing reports and charts.
• Analyze business data requirements to produce relevant ETL architecture deliverables (source analysis, source to target maps, ETL flows)
• Develop source to target maps and identify transformation rules
• Create data integration blueprint and install, configure and tune ETL infrastructure to support the data warehouse solution using Oracle Data Integrator (ODI).
• Develop ETL flows and framework to support ETL development
• Development of ETL processes utilizing Oracle Data Integrator
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle. Goal of the project was to create an enterprise data

Technologies: used included Oracle Database, Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Data Integrator(ODI), Oracle, Teradata and Toad Data Modeler etc.

Confidential, San Ramon, CA

Sr. Data Warehouse Architect

Responsibilities:

• Designed and implemented a Data Warehouse for Confidential .
• Responsibilities included Architecture, Data Modeling of Star Schema, creating physical layer, business layer and presentation layer for OBIEE reporting.
• Lead project discovery phase, scoped out the project, gathered business requirement and implemented a BI program.
• Responsible for installation, integration and configuration of OBIEE components, performed BI Server administration and implemented security model as well.
• Created both Logical and Physical Data Model of a number of Data Marts for different Confidential departments with common Meta data repository. A number of fact tables and conformed dimensions of both type SCD1 and SCD2 were created and implemented.
• Designed and implemented Dashboard for the Operation Excellence and Reliability Indicators for Confidential .
• Created and integrated a number of BI Publisher PDF reports with dashboard.
• Designed and implemented ETL strategy including Process Flows and source to Target Mapping using designer, OWB and other Oracle technologies.
• Gathered the requirements developed by the business analysts, and created a formal design/development project plan. Played a senior role in implementation and monitoring of the Data Warehouse development.
• Performance tuning of Data Warehouse loading, refresh and report generation.
• Technologies used included Oracle Database, Oracle Application Express, Oracle Warehouse Builder, Discoverer, Toad Data Modeler and Access etc.
• Installed Oracle Data Integrator (ODI) and created Proof of Concept (POC) for their migration of OWB based ETL to ODI.

Confidential, Chicago, IL

Data Warehouse / OBIEE Architect

Responsibilities:

• Re-Architected and re-designed large existing data warehouse to improve performance from daily processing time of 12 to 18 hours to little over two hours.
• Responsible for scooping out project, gathering and defining requirement, and converting those requirements into Logical and Physical Data model and their approval. A number of Data Marts (Facts and slowly changing dimension of Type 1 and Type2) were created to support report for forecasting, marketing, budgeting, sale and customer tracking etc.
• Implemented BI Program using OBIEE including installation, configuration of OBIEE, physical layer, business layer and presentation layer. Also implemented two dashboards with a number of analytical reports and trend charts.
• Also created a new Scan Based Trading (SBT) Data warehouse from scratch and implemented successfully with great performance and to satisfaction of the client. OWB 10Gr2, OBIEE, Cognos ReportNet, Oracle 10gR2, Erwin were the tools used to achieve the goal.

Confidential, Duluth, GA

Data Warehouse Architect

Responsibilities:

• Redesigned existing Data and implement all aspects of Data Warehouse. Redesign effort included re modeling of existing Data Model for incorporating new requirements and performance gains.
• Oracle Warehouse Builder was the ETL tool, used Oracle Designer for data modeling.
• Used Discoverer and Cognos for the reporting tool. Project timeline was met and completed within budget and final date.
• Data was extracted from a number of different source system including Oracle Apps, SQL Server, Access, Excel Spreadsheet, Heterogeneous services for Legacy system, Flat files etc.

Confidential, Indianapolis, IN

Data Architect / Sr. ETL Architect

Responsibilities:

• Responsible for the architecture, design, Data modeling (Logical and Physical) for Enter prize data warehouse and all its Data Marts, security and implementation of DWH.
• Architected Designed and developed the ETL extraction and loading.
• Data extraction, its integrity and standardization were the main challenge met.
• Acted as main person to guide client in requirement development and gathering and their final approval.

Confidential, Atlanta, GA

Data Warehouse Architect / Sr. ETL Architect

Responsibilities:

• Began this project from conceptual stage and successfully launched it into production.
• Responsible for the architecture, design, security and implementation.
• Provided the architectural design and ETL (Oracle Warehouse Builder), completed this project on time and within budget.
• This project include extracting data from Source system, integrating it into Atomic level Data warehouse and loading them into a number of Data Marts for reporting.

Confidential, Boise, ID

Data Warehouse Architect / Sr. ETL Architect - Team lead

Responsibilities:

• Developed the Architecture, high-level design, Data Warehouse / ETL developed and completed the implementation. Implementation includes extracting data from source systems and populating different stages of Data warehouse using source to target mapping.

Confidential, Chicago, IL

Sr. Data Warehouse Developer / Data Modeler

Responsibilities:

• Designed Data Modeled, coded the testing and modified various stages of the Data Warehouse like Staging, Atomic level Data Warehouse based on Inmon DW concept, Data Marts and Cubes using Erwin.
• Designed and implemented ETL strategy including Process Flows and source to Target Mapping using designer, OWB and other Oracle technologies.
• Gathered the requirements developed by the business analysts, and created a formal design/development project plan. Played a senior role in implementation and monitoring of the Data Warehouse development specially ETL.

Confidential, Chicago, IL

Senior System Analyst Developer

Responsibilities:

• Used Rational Rose tools to develop use case scenarios. Technical architecture for the application included IBM Websphere, Domino server, DB2, WebMethods, Korn shell scripts and HTML macros.
• Developed a flexible application framework consisting of Web Logic, Oracle and WebMethods to provide a platform for any future e-commerce application development.

Confidential, Chicago, IL

Team Lead / Sr. Lead Developer

Responsibilities:

• Developed XOLIA Enterprise Network (XEN) using, Oracle, Visual Basic and ASP.
• Designed and coded Intranet/Internet web applications using HTML, ASP, JavaScript, VBScript, SQL server, web site management, monitoring and activity reporting, and advanced document management.

Confidential, Detroit, MI

Sr. System Analyst/ Oracle Developer

Responsibilities:

• Worked on enterprise data warehouse applications for knowledge based marketing campaigns, customer relationships.
• Responsible for requirements collection, software development, testing and deployment of software developed using PL/SQL, Visual Basic, Oracle and Access.

Confidential, New York, NY

Application DBA

Responsibilities:

• Responsibilities include creation of Logical and Physical data model, database creation, creation of PL/SQL base code and maintaining the database.

Confidential, St. Paul, MN

Project Manager/DB Architect

Responsibilities:

• Responsible for design and development of large multi million dollars application, with PowerBuilder 5.02 as a front-end GUI builder, ART as the expert system and rule-base engine.
• This application uses Oracle as the relational data base platform.