Summary:

Over fifteen years experience in development and implementation of data warehouse and Internet database applications. Accomplished Data warehouse Consultant with experience in all phases of software development, including OBIEE Answers, ETL Informatica workflows and DAC tasks for Oracle BI Applications. Thorough knowledge of Data Warehousing principles, Data modeling, Object Oriented design and Distributed Computing. Good working knowledge of various Oracle Application Products. Techno functional experience in implementing and supporting both R12 and 11i Oracle Applications. Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support. Strong communication, problem solving, organizational, project management and client interfacing skills. Expertise with Oracle's Business Intelligence product, having been involved in the development of the module from its inception at Oracle. Strong programming skills in JAVA, C, PL/SQL and Shell scripts. Accomplished various implementations in this field as a Data Warehouse and Business Intelligence consultant.

Technical Skills:

• Good Project Management skills and ability to manage multiple projects efficiently in a timely manner.
• Worked with various kinds of Software Development process models like CMMI, Waterfall and Agile.
• Clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in creating complex data models for OLAP and enterprise data warehouse systems using various tools like
• ERWIN, SQL Data Modeler, UML, Informatica Designer and Oracle Designer.
• Proficient in Install, configuration and customization of Siebel Analytics/OBIEE, Informatica and DAC on all platforms.
• Proficient using Oracle 10g Business Intelligence tools like Discoverer, Jasper, Warehouse Builder and Siebel Analytics.
• Proficient using Oracle JDeveloper, ODI, BI Publisher and Oracle BI Applications OBIA .
• Good Functional Understanding of Oracle E-Business Suite applications like HRMS, Order Management,
• Inventory, Financials, Procurement, Service Contracts, Customers Online, Sales Online and Support Services.
• Experience working on all RICE items Reports, Interfaces, Conversions, and Extensions for Applications.
• Familiar with Oracle Database Administration and design, OA Framework, OBIEE, Informatica and Oracle Portal.
• Good working knowledge of PeopleSoft HCM, MicroStrategy, Weblogic Server administration and Business Objects.
• Proficient in programming with JAVA, C, PL/SQL, JSP, JDBC, AJAX, Servlets, RMI, Perl, EJB, XML.
• Good understanding of Big Data, Apache Hadoop, Endeca Discovery.
• Proficient using Vmware platforms and UNIX tools like Shell, Awk, gdb, Tcl, gcc, CVS, Subversion, PVCS, RCS.

Work Experience:

Senior Manager/ Data Architect

Worked as an architect involved in providing Analytical solutions across Oracle E-Business Suite for various customers. Work Involved setting up Business intelligence modules as per Oracle best practices for different vendors. Was responsible for Dimensional modeling, ETL Process design, Data cleansing, Star and Snowflake schema design and defining facts and dimensions. Also worked as a project manager managing multiple projects for Oracle applications. Worked on prioritizing multiple tasks across projects and breaking them down to simpler tasks to effectively manage various projects in a timely manner. Categorized and grouped tasks based on resource availability and time constraints. Involved in managing multiple projects and an offshore development team in India for development and support issues. Used project management tools like MS Projects to effectively document and maintain project progress. Work involved all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support. Was involved with setup, upgrade, customization and development of reports using various Oracle BI tools like Discoverer, DBI, Fusion Intelligence, OBIEE, Analytics and BI Publisher, Oracle BI Applications for all modules of the E-Business Suite. Performed administration tasks related to the development of Intelligence Dashboard pages and creating users and managing user security in OBIEE. Was also involved in interfaces, conversions and customization of Oracle ERP systems. Provided functional training, knowledge transfer and production support for Oracle Applications, ETL best practices and reporting.

Project Lead

Confidential

Worked as a Project Lead in the Manufacturing/Supply Chain/Contracts Business Intelligence group responsible for the development of Daily Business Intelligence module DBI for Oracle E-Business Suite Applications. The work involved, providing Corporate Dashboards and Intelligence reporting for a suite of Oracle products like Service Contracts, Support, Service and Interaction center. Worked in the design and development of Daily Business Intelligence module, for Oracle Contracts, Service, Manufacturing and Procurement modules releases 5.x, 6.x and 7.x . Development was done using OA/PMV Framework in Java and PL/SQL using Oracle 9i database features. Worked on designing Base Summary Collection Programs ETL and created new time nested Materialized Views on top of base summaries to aggregate the data and build multi-dimensional cubes. Created the front end metadata layer needed for the key performance Intelligence Dashboards. Work also involved, working closely with Functional Business Users for CRM Service, Contracts and Interaction center. Worked in, creating workbooks for Sales forecasting using Discoverer 4i. Created custom seeded folders for Service Contracts module in Discoverer. The discoverer reports were published on an Oracle Portal and rendered as portlets. The work included fixing bugs, applying and testing patches on test, development environments and supporting Oracle production instance for 11.5.10. Was also involved in generating prototypes for 11.5.x release of the product.

MRTU Consultant

Confidential

Worked on various projects for settlements during the MRTU upgrade phase at PGE. Was involved in making modifications to existing reporting requirements due to the upgrade. The process involved supporting both the old and modified versions simultaneously. Redesigned back end PL/SQL packages to change business logic and work with new time packages for daylight savings time. Also created Enterprise Java Beans EJBs to run daily batch jobs on the server to load and populate data into the database and sent email alert notifications as needed. Worked with new xml file formats imported from ISO to extract and load the charge data into Oracle. Also worked on new report requirements during this phase. Used Weblogic workshop to design front end jsp pages and controller objects for reporting. Designed Ajax web components for access validation and dynamic lookups on the front end jsps. Was involved with functional product testing using Mercury Quality center and also supporting and fixing client facing issues.

Software Engineer

Confidential

Worked with the Data operations group, in providing web based data warehousing and data mining solutions for various internal teams. The development was done in Java jdk1.2 , Tcl using Apache Web Server on Solaris 2.6 platform. Wrote a generic consolidator in Java to extract data from different file formats and consolidate the relevant data into an Oracle 8i Database. Work included, debugging issues and provide enhancements for the front end Tk application interface. Was also involved in database administration of the database. In addition to the development role, helped build the data warehousing services of the company and trained and mentored internal staff on data warehousing. Tasks included conducting requirement analysis the design and development of a dimensional data model star schema the creation of a database in Oracle8i the development of ETL processes PL/SQL Packages the creation of several multidimensional cubes the development of a web reporting application client training and documentations.

Network and Database

Confidential

Maintained a Novell NetWare 3.12 LAN network. Work involved updating various databases like Paradox and Ace file, running on the system, and to generate monthly reports for other departments.

Jr. Software Engineer

Confidential

Installed, configured and tested new software on various platforms like SunSparc Solaris 2.51, and Windows NT, for RAID subsystems and SCSI controllers. Analyzed test suit results and worked in conjunction with other team members to remedy bugs encountered during testing.

Overall Projects Overview:

• Involved in developing Oracle Business Intelligence components as part of Oracle E-business suite
• implementations. The work involved setting up Business intelligence modules as per Oracle best practices for different
• vendors. Work also involved set up of Business Intelligence dashboards for all Oracle Application modules using Oracle
• BI applications. Also was involved in setting up Fusion Intelligence, BI Publisher, DBI, OBIEE, BI apps and Seibel
• Analytics implementations. Worked on developing Balanced Scorecard reports for key performance indicators
• Confidential Worked as a Data warehouse Expert to design new Business Intelligence dashboards for Retirement Readiness, Defined Contribution and Benefits. Reviewed all business requirements and created a custom data model for the data warehouse. Created star schemas and modeled facts and dimensions for Retirement KPIs like Savings Rate, Participation, Asset Allocation, Interaction, Guidance and Withdrawals. OBIEE 11g was used as the front end tool to define the dashboards and provide complex analytics. Informatica was used as the ETL tool to load the Oracle Data warehouse. Also was involved in performance tuning of the reports using Oracle Exadata and Oracle Exalytics engine. Work also involved training the Business users on building custom analytics and security.
• Confidential Worked as a Project Lead in implementing an Oracle Enterprise Data warehouse sourcing from various application systems. Worked in customization of Oracle BI Applications OBIA for Service, Procurement and Finance modules from Oracle EBS 11i. Was also involved in architecting and design of the data model for Customer and Channel intelligence. Data was sourced from various applications like Sales force, Point of Sale, CCI, PRM and Oracle EBS systems. The BI Analytics also provided Master Customer Management MCM Customer data hub consolidation from various sources. Existing Oracle Informatica ETL mappings and workflows were customized to pull in additional business requirements. Managed a team of three people onsite and ten Offshore resources for the design development and QA activities. OBIEE RPD metadata changes were done in the physical, BMM and presentation layers to bring in other application facts and dimensions into the BI Repository. Also upgraded the client repository from 10.1.2.x to 10.1.3.4 as part of the OBIEE upgrade project.
• Confidential Responsible for managing the Oracle HR data warehouse based on Peoplesoft 8/9.x application. Built and re-designed a custom HR BI star schema data model from the ground up. Was involved in performance tuning of the OBIEE dashboards, and design of new Workforce Profile dashboards. Implemented Oracle BI Apps 7.9.6 based on Peoplesoft HCM data source and adapters. Was responsible to successfully lead an oracle project to upgrade OBIEE 10.x to OBIEE 11.x version. Created new custom dimensions and facts based on Business requirements for enhanced dashboards and reports. Built complex reports in answers and BI Publisher. Managed all Rpd changes and user security as an OBIEE administrator. Made performance improvements by designing aggregate MVs and summarizations as needed. Developed custom ETL and ELT load scripts in SQL and PL/SQL to load the data into the warehouse. The AppWorx scheduler was used to schedule the additional load scripts.
• Confidential Work as a data warehouse architect involved in implementing Oracle BI tools for a consolidated enterprise wide BI solution. Was involved in setup of Oracle BI applications for Financials, HR, Supply Chain, Projects and Service modules. Created customized Informatica workflows and mappings based on customer requirement. Also created and scheduled new tasks in the data warehouse console DAC based on the custom ETL extracts. Implemented and setup OBIEE Financial Analytics, Service Analytics, Projects Analytics and Supply Chain Analytics on multiple environments. Created BI Publisher reports for Sales and Order management. Was also involved in providing custom Sales Opportunities Dashboard using Salesforce data. Worked on modifying the seeded repository file to incorporate the customizations. Created new dimensions and facts in the data warehouse to pull in additional data from the Oracle EBS instance. Performed additional tasks to setup up Daily Business Intelligence for CRM Service and Contracts modules. Was also involved in creating few operational reports using Jasper and BI Publisher.
• Confidential Worked as a Sr Consultant to implement OBIEE and Daily Business Intelligence DBI dashboards for Oracle E-Business Suite R12. Work included integrating Oracle OBIEE with the Oracle E-Business Suite for Fusion Intelligence out of the box Financial dashboards. Was involved in the setup of Oracle DAC client programs and Informatica Power center needed for Oracle BI Applications. Helped in scoping out the project from design to implementation and production deployment. Developed an interface to pull in Customer category and class codes into Oracle ERP. Was also involved in writing an interface to define customer cost center security for Oracle financials. Work also involved writing conversions for Customer and Financial data. GL, AP, and AR
• Confidential Worked as a Sr BI Architect to implement Business Intelligence dashboards for Oracle E-Business Suite R12. Work included integrating Oracle OBIEE with the Oracle E-Business Suite single sign on for Fusion Intelligence out of the box dashboards. Was involved in building new reports in OBIEE using Marketing Ad campaign data combined with Oracle EBS data. Big Data and Hadoop Technologies were used to load the Ad campaign data into the data warehouse. Also created Dashboards for Revenue, Receivables, Sales and Opportunity subject areas. Created the Physical layer for mapping Transactional views in EBS. Worked on fixing issues in the Business model layer and presentation layers as well. Was also involved in the user and security administration of OBIEE to business users.
• Confidential Worked as a Sr Business Intelligence Consultant for an Oracle 11i implementation of Daily Business Intelligence dashboards for Financials, and Procurement. Work involved validating and fixing financial account hierarchies needed for DBI. Some customization of DBI reports was also performed to meet client needs. Fixed some Oracle reports as per requirements based on account changes. Also provided knowledge transfer and user training for Oracle BI applications for 11.5.10 and assisted in formulating business requirements and mapping source data to logical and physical designs in OBIEE. Created an ETL layer for additional requirements.
• Confidential Worked as a Business Intelligence Consultant to implement Daily Business Intelligence dashboards for Financials, Supply Chain OM , Projects, Procurement and Manufacturing. Work involved setups for DBI reports and customizations. Also involved in creating XML Publisher reports for Sales Order Acknowledgments. Worked to setup BIS Discoverer 4i seeded content on AIX system. Created the end user layer and imported seeded Oracle BIS content into the Discoverer End user Layer. Was also involved in creating custom Business areas and folders based on specific business needs for existing reporting architecture. Redesigned existing reporting strategy with new Oracle 11i functionality using Discoverer. Created programs for reporting and extraction for OM. Rewrote existing load programs and PL/SQL procedures for populating data warehouse tables. Was also involved in the administration of BIS Discoverer and DBI content to all business users.
• Tecumseh Company, Confidential - Involved in implementing Business Intelligence reporting 11.5.10 Oracle E-Business Applications Suite. Work included setting up standard up Daily Business Intelligence DBI 7.2 dashboards for Financials, Procurement, Planning and Supply Chain. Also involved in setting up BIS Discoverer and enabling Web Discoverer 4i reports for these modules. Defined custom Balanced scorecard measures using Oracle Balanced Scorecard tools. Also demonstrated XML Publisher reports using standard templates. Created a metal position report in Oracle ASCP. This report provide details like Product Number, description, Actual Inventory, WIP job demand, planned order, Planned Supply and Projected Available Balance of Metal. Also was involved in Conversion of Item, BOM data using Item and BOM Open Interface. Was involved with the transition of Production support activities to their offshore team.
• Mercury, Confidential Worked as a data warehouse architect to re-design the existing reporting strategy for Mercury after Oracle 11i Applications upgrade. Work included understanding the current data warehousing needs and providing a better and more efficient solution for data mining and reporting based on the E-Business Suite 11.5.10 applications. Was involved in the re-design of the extraction layers etl . Also worked in implementing Confidential for executive reporting for Financials, HR, Purchasing, Projects, Sales, Supply Chain and Inventory modules of the ERP 11i suite. Also worked as a functional consultant for helping in setup of Service Contracts. Worked in re-architecting the existing business areas based on Business Objects and Discoverer and merged them into Oracles seeded EUL. Used Business Objects dashboard Manager to create new BO reports. Provided a web-based single sign-on model using DBI, BIS and web discoverer, to meet all reporting needs.
• Confidential - Involved in implementing Business Intelligence reporting 11.5.10 Oracle E-Business Applications Suite. Work included setting up Daily Business Intelligence DBI pages and reports, across all Oracle Application modules like Financials, Manufacturing, Supply Chain, Purchasing, Inventory, Projects, Service Contracts, PLM and Service. Worked in setting up dimensional hierarchies needed for financial reporting. Was responsible for setting up Organization hierarchies for Operating Units, and also CRM Resources and sales group hierarchy needed for Service contracts. Provided functional knowledge transfer for CRM resource manager setup and sales group hierarchies Created customized DBI reports and Discoverer reports as per Customer requirements. Also developed balanced scorecard reports for a few key performance indicators.
• Oracle Corporation - Design and development of Oracle Daily Business Intelligence components under the Manufacturing-Supply Chain/Contracts suite of products, within the E-Business Suite of Oracle Applications. The Work involved:
• Worked in the design and development of Daily Business Intelligence DBI product, to develop portlets and reports for Contracts Intelligence, Service Intelligence, Purchasing Intelligence and Order Management products, as part of
• the Oracle Applications DBI phase. Worked with the DBI team for three successful Software development
• Lifecycles of the product. This involved using OA framework and PMV / PMF tools. Wrote PL/SQL
• Procedures using Business Intelligence PMV framework to render portlet content. Created Key performance
• indicators and balance scorecards as part of the Business Intelligence reports.
• Re-architecture of Base Summary Collection Programs ETL and summary fact tables needed for Contracts and
• Supply Chain Intelligence. Wrote Oracle standard pl/sql packages for concurrent programs to extract data from
• OLTP tables into summary tables. Used Oracle Designer as data modeling tool for designing the Database Objects
• involved. Also worked in the design of new Materialized Views needed for summarizing the data. Led an offshore
• team of developers from Oracle India Development Center, for the release of DBI for Contracts intelligence.
• Created layered time nested Materialized Views on top of the Base summary fact tables to aggregate data across
• different Oracle Dimensions. Was involved in the performance tuning of the MVs to incorporate Query Rewrite
• and fast refreshable features. Built front end queries and PL/SQL packages to query the relevant MVs based on
• Dashboards parameters selected. Also worked on developing the front end metadata layer AK/JRAD components
• needed for rendering the data content on the Corporate Intelligence Management Dashboard. Used DBI designer to
• build Corporate Overview pages with specific content portlets by Module.
• Working in all areas of the product development cycle for 11.5.x and DBI release of Contracts
• Intelligence. The work involved writing JSPs for the UI, using CRM Java Technology Stack to
• render the content on Oracle Portal. Created custom business intelligence portlets for ERP applications using
• Oracle Portal. Setup and configured Oracle portal on development and test environments. Also wrote Java
• Concurrent programs as part of the Concurrent Manager Request Set. Used PL/SQL procedures as well for loading
• data into the Summary Tables.
• Wrote custom JSPs using JTF framework to render reports as html content. Development was done using Oracle
• JDeveloper on Oracle 9.x platform. This was part of Contracts Intelligence product for 11.5.9 and 10 releases of the
• E-Business Suite. Also wrote JSPs as part of CRM DBC Daily Business Close Project. Also wrote custom
• parsing scripts in java for query search and replacement routines.
• Wrote automated scripts for generating daily intelligence reports from oracle internal production
• environment. Developed the back end ETL layer using Oracle Warehouse Builder and ERWIN. Also involved in
• fixing bugs, applying and testing patches as part of 11.5.x product release, on test and development environments.
• Confidential - Worked on various projects including Settlements, nMarket, RTSM and Meter Data, during
• the MRTU release phase at PGE.
• Modified existing database objects and tables affected by the new mrtu changes. Was involved in making
• modifications to existing reporting requirements for Settlements due to the upgrade. Rewrote complex queries to
• extract data from the new system. The process involved supporting old and new versions simultaneously.
• Involved with redesigning back end PL/SQL packages to change business logic and work with new time packages
• for daylight savings time. Also created Enterprise Java Beans EJBs to run daily batch jobs on the server to load
• and populate data into the database and sent alert notifications as needed.
• Worked with BEA Weblogic workshop and tools to design new reporting requirements for Meter data Charge
• codes related to the mrtu project. This involved extracting xml file structures, loading data into Oracle and writing
• front end jsp reports and controllers using weblogic to access the data. Created automated test plans using Mercury
• Quality Center to perform and run product unit tests throughout the test cycle. Gathered test results and created
• defects for issues encountered during tests.
• To develop software tools for Confidential . The Project involved parsing the raw tester data from Semiconductor fabs and, storing and extracting relevant data for analysis in the data warehouse. Work involved:
• Worked on gathering requirements and the design and development of a dimensional data model star schema for
• reporting. The development of the ETL process was done in PL/SQL. Multidimensional cubes were created to
• aggregate and summarize the data based on custom dimensions. Also was involved in the development of the web
• reporting application and client training and documentations.
• Involved with Database Administration of the Oracle 8i Database. Developed automated backup and
• archiving scripts for the Database. Also worked on schema design and development. Used Oracle
• Expert as well, for Performance Tuning of the database. Also Used the Oracle Enterprise Manager
• to schedule jobs and events in the Database.
• Implementing an Active Object Concurrent pattern in Java.
• Developed a distributed web based client server application, having data in multiple databases running on remote
• servers. Java RMI and JDBC were used to access and retrieve information concurrently from the remote databases on
• Oracle 8i and mySQL in a 3-tier architecture. The front end was designed using Java applets on apache web server. Also
• built a concurrent multi-threaded application for searching and indexing web pages using Java programming language
• and concurrent pattern APIs on the server side.