OBIEE, Datawarehousing, ETL
Resume:
NEVIL POZHOLIPARAMBIL
Tucson, AZ 85719
*****@*****.*******.***
Business Intelligence (OBIEE) – MBA/MIS Graduate – High Technology
SUMMARY:
Four years of progressive experience working as a senior software engineer, onsite coordinator and technical lead for maintenance projects in storage domain. Self motivated individual with strong technical/functional knowledge supported by one year live project experience in Business Intelligence (OBIEE). Seeking to build a career as an OBIEE Consultant.
EDUCATION:
THE UNIVERSITY OF ARIZONA, Eller College of Management
Dual Degree MIS/MBA, Dec 2009, Tucson, AZ
• Graduate Teaching Assistant for the Mosaic (Business Intelligence) project in the University Technical Services Department.
• Designed/Developed a RDBMS in Oracle (PL/SQL) for JTED’s course scheduling, registration and attendance operations.
• Performed an Information Security Assessment (TVA analysis) for the Eller IT Department.
• Executed field project to recommended strategies to improve brand awareness, customer satisfaction and market position for CS Odessa (Ukrainian software firm). Marketing report helped acquire new reseller and increased sales by 20%.
• Interned with Emerson Network Power managing infrastructure projects for transitions from Motorola to Emerson network.
• Developed a “movie remake” web site using mash-up API’S and data mining concepts to make accurate recommendations.
MAHATMA GANDHI COLL. OF ENG. & TECHNOLOGY, University of Mumbai
Bachelor of Engineering (Computer Science), June 2002, New Mumbai, Maharashtra, India
EXPERIENCE:
THE UNIVERSITY OF ARIZONA, MOSAIC BUSINESS INTELLIGENCE INITIATIVE, Tucson
Business Intelligence Analyst (2009 - present)
Designed/Implemented BI solution for Kuali Financial System’s Capital Assets/Purchasing modules. Tasks performed includes
• Gathered user requirements by conducting interviews, identifying reports/KPIs, creating strategy maps/warehouse bus matrix.
• Performed dimensional modeling for OLAP data warehouse. Identified transaction fact grains by studying ERDs of OLTP RDBMS. Designed multi star schema to resolve issue of multiple grains in same schema. Designed slowly changing dimensions (Type1, Type2, Hybrid). Prototyped product in PL/SQL to users for early feedback. Prepared lineage design specs for ETL.
• Designed ETL jobs to perform incremental load (with error handling) using IBM Datastage 8.0 parallel jobs. Created workaround for Datastage’s defective handling of Type1 SCD. Monitored jobs, added indexes to improve performance.
• Managed repository daily using OBIEE 10.1.3 Admin Tool. Created dimension hierarchies (Org, Account, Time) to support drill-down/aggregation. Created user based views in presentation layer catalog folders by assigning group permissions. Worked with session/repository variables. Always ensured no global consistency errors/warnings. Implemented Security with External tables.
• Created first repository prototype by joining ~50 transactional tables in the physical layer to simulate star schema in the logical layer. Created second prototype using PL/SQL simulated dimensional model (added SID logic) to seek refined user feedback.
• Monitored performance by creating OBIEE’s Usage data model/subject area. Improved performance by using aggregate navigation, indexes and materialized views.
• Designed approximately 75 reports with drilldown, pivot, bar charts, view/column selectors, guided navigation, direct database requests in Answers each with varying levels of complexity. Configured dashboards for different groups of users according to security level (high, medium, low). Created iBots to generate alerts and delivered it to target users.
Received excellent feedback from Users, Accounting Manager and Director of Business Intelligence. Currently system is also being used for reconciliation purposes.
PATNI COMPUTERS SYSTEMS (NYSE PTI, India’s #6 IT Services Provider), Mumbai, Maharashtra, India
Technical Lead/Senior Software Engineer (2006 - 2007)
• Reverse Engineered (created design documents) for Toshiba MRI systems, 20KLOC DICOM module, without a working system. Technical lead of a four member team. Recipient of “Dream Team Award” and of Customer Satisfaction Survey rating of 5/5.
• Maintained for LSI Logic., EFI Boot Service Driver software and flash utility tools, for LSI 1068/1078 SAS adapters on Itanium servers. Resolved critical defects within 24 hour turnaround period thus allowing LSI for a two week early release of their driver.
Onsite Coordinator/Software Engineer (2004 - 2006)
• Sole point-of-contact of a 50-member Patni (Offshore) and a 20-member Hitachi Storage (Client) team. Clarified daily issues between the two teams (proposal/ budget/schedule discussions, status/review meets, defect/requirement analysis). Project designated as “VVIP”, completed before schedule (70KLOC development in 8 months), generated revenue worth $800,000.
• Onsite coordinator for Hitachi Storage GUI project. Responsibilities included client communication, defect analysis and onsite testing. Hitachi Quality Assurance reported no defects (first in history of client relationship).
• Personally generated revenue worth $135,000 for Patni Computers Systems Ltd., during the 18 month duration in Japan.
Programmer/Software Engineer (2003 — 2004)
• Developed a Test Tool for Hitachi Storage, in Perl/Shell-Script to automate the execution of 300 IT PCLs by synchronizing multiple 32 /64-bit servers in a SAN environment. This reduced the Testing Effort from by 90% to 0.75 Person Days per IT cycle.
• Maintained pseudo SCSI device driver for Hitachi Storage, on various Linux distributions. Resolved defects, automated test-cases on a 24/7 basis. Recipient of “Letter of Appreciation Award” and 2 Team awards.
TATA CONSULTANCY SERVICES (India’s #1 IT Services Provider), Mumbai, Maharashtra, India
Project Trainee (2001-2002)
• Developed an Audit Trail system on Oracle (PL/SQL) for payroll modules. Led a team of two. Project was successfully deployed. Received a Letter of Appreciation from Senior Consultant, TCS.
TECHNICAL SKILLS:
• Concepts: Business Intelligence/Data Modeling, Data Warehousing, Data Base Design, Data Mining
• Programming/Platforms: PL/SQL (Oracle 10g), Shell /Perl Scripting for Linux based systems, C, Java
• Applications: OBIEE 10.1.3, Data warehouse 8.0 (parallel jobs), SQL Developer, Informatica, EPM
CERTIFICATIONS:
• JLPT Level 3 and JETRO Level 4 certified Japanese Language Professional
• CNSS Certified Entry Level Risk Analyst, 2008
===================================================================================================================
Detailed Listing of work in OBIEE/Datawarehouse Development
Role: Business Intelligence Analyst/Developer at University of Arizona
Responsibilities:
User Requirement
• Actively involved with Business team to gather user requirements.
• Conducted interviews,Identified reports,Identified KPIs
• Created strategy maps / balanced scorecard
• Used data warehouse bus matrix
• Created process flow excel to ensure every process was covered
Dimensional Modeling
• Identified granularity level of the data required to be available for analysis.
• This was achieved by studying the ERD’s of the underlying RDBMS (Transactional System)
• The application software was studied too since the fields appearing there must be present in the facts/dimensions.This study also provided useful insights into calculated or derived facts
• Worked with Data warehouse architect to design - Facts & Dimensions for Repository
• Finalized on a multi star schema since there was an issue of multiple grains in the same schema and it also kept the schema modular.Snow flaking was avoided due to performance issues except in one place (while creating the ORG dimension)
• Decided to use Transaction fact grain for CAMS and Purchasing
• CAMS model was identified as all Type1 SCD (slowly changing dimension) since end users were not interested in maintaining historic information. Purchasing module was hybrid.
• Kimball’s model was used. Studied Kimball’s “Data warehouse Toolkit” book and reviewed/justified my design against the concepts learnt.
• Prototyped product to users
• The model was prototyped in stored procedures PL/SQL and repository/reports were built off it so that users could preview the BI solution and also easily perform conformance testing between their legacy systems and the latest application.
• Prepared Detail Design Document for Dimensional Model in the form of Lineage Spreadsheets (basically ETL specifications)
• This recorded everything from source table, source column, target table, target column, presentation layer name, lookup logic between source and target, SCD type identification, BK/UK/SID identification, Transformation logic for derived fields
ETL
• Developed simple & complex ETL jobs using Data Stage 8.0 to load Dimension & Fact tables as per STAR schema techniques
• Designed logic to create jobs using latest Data stage 8.0 parallel jobs technology (incremental load) and sequencer
• Identified flaw with Data stage approach to handling Type 1 SCD jobs (it does not handle type 1 that has type 2 fields linked to it and which also are dependent on keys other than original BKs) and created workaround
• Monitored jobs and added indexes to make them run faster in both development and test environments
• Created and maintained jobs, shared containers, and job sequences.
• Implemented Error Handling.
• Trained in Informatica to broaden my skill set.
Repository
• Configured and managed the Oracle BI Repository using OBIEE Administration Tool on a day to day basis
• Created connection pools, physical tables, schema folders in the physical layer of the repository.
• Defined Primary key-Foreign key relationships, complex joins between dimension tables and Fact tables in the physical layer.
• Configured Logical Layer – Create Logical tables/dimensions, columns, Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns
• Created Dimension Hierarchies (Period, Account, Organization and more) in Business layer for Drill down functionality and Level based measures.
-Suggested workaround to handle ragged hierarchies
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Used session and repository variables and initialization blocks in the repository.
• Extensive experience debugging and validating the repository integrity with global consistency check feature (goal was to always ensure 0 errors and warnings).
• Created Metadata using Admin Tool.
• Implemented Security by creating roles & web groups, checks with External tables
• Created two Prototypes to gather user feedback and to satisfy their urgent requirements
-Initial prototype was created through a logical layer star schema by joining the physical tables (approximately 50 transactional tables) in the physical layer. This helped simulate a pseudo star schema in the logical layer but without SCD handling or SID logic.
-The second prototype used the PL/SQL simulated dimensional model to more accurately represent the final product
• Performance improvement
-Create Usage Subject Area (including data model) to track performance of queries
-Resolved performance Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Avid follower of Rittman’s Blog and IT toolbox.
Reports
• Design approximately a 75 reports with Drilldown, Pivot, Bar charts, Pie charts in Answers each with varying levels of complexity
• Configured intelligent Dashboards for different groups of users according to security level (high, medium, low).
• Added new users and assigned them to appropriate groups for visibility to reports and dashboards.
• Maintained Effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created iBots to generate alerts and delivered it to targets users.
• Developed ad-hoc reports using direct database requests if needed
Database
• Good database experience using Oracle 10g, SQL, Stored Procedures PL/SQL, SQL Developer & ODBC interfaces to Oracle Explain Plan, Ref Cursors, Constraints, Triggers, Indexes-B-tree-Index, Bitmap Index, Views, Database Links, Export/Import Utilities
• Have resolved many defects visible on reports by debugging through OBIEE repository and all the way down to OLTP/OLAP database. This required strong knowledge of SQL.
UNIX
• Posses two and half years of working on various flavors of Linux (Redhat, AS, ES, Suse, Miracle). Extremely proficient with Unix commands, Shell and Perl Scripting. Have developed automated test tools which saved the organization a lot of testing time.
Contact this candidate