Informatica And Bi Developer Resume
Redwood City, CA
SUMMARY:
- 11+ years of IT experience in Data warehousing (ETL Informatica and OBIEE/OBIA).
- Gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse, Data Marts and BI and Transactional applications.
- Experience in ETL - Informatica 9.1.1/8.x/7.x, OBIEE 11G, OBIEE 10.1.x which includes Oracle BI/Siebel Intelligent Dashboards, Oracle BI/Siebel Answers, Oracle BI/Siebel Delivers and Oracle BI/Siebel iBots, Oracle BI Publisher, Reporting-OBIEE platform, Scheduling- DAC, interacting with multiple data sources like Oracle 9i, 10g, SQL Server and various other miscellaneous sources.
- Proficient in Informatica Designer Components Source Analyzer, Warehouse Designer Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor and also experienced in DWH Daily load monitoring and Production DWH issues in ETL and Reporting.
- Worked in Siebel Marketing Analytics Starting from Siebel & Analytics integration, Creation of RPD target levels, setting up cache tables for the customized target levels, creation of Segments, Creation of Campaign Load files formats and triggering the campaigns from Siebel. Also have experience in supporting the Siebel Marketing production Application for Campaign planning and Management.
- Expertise in configuring Interactive Dashboards with drill-down and drill-across capabilities using Dashboard Prompts, Aggregate Navigation, Time series functions, Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization. Configured & published Delivers / iBots to deliver content based on schedule, automated iBots queries to obtain daily & weekly transactions by Emails.
- Proficient in Installation, configuration, upgradation and administration of OBIEE,OBIA, Informatica and DAC.
- Extensive experience in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake schemas.
- Broad understanding of multiple technologies - These include DBMS, ETL, Reporting, OLAP, Teradata, performance tuning for high-end hardware and storage (HP, Sun, data warehouse appliances), OS (Solaris, HP-UX, Windows, Linux).
- Expertise in installing and configuring OBIA HR Analytics, Financial Analytics, Supply Chain & Order management Analytics and Procurement & Spend Analytics pointing to source systems like Oracle EBS.
- Worked in configuration and development of OBIA Sales, Service and Marketing (Campaign Management) modules pointing to Siebel CRM source system.
- Experienced in working with DAC design and development including customizing execution plan, subject areas, tables groups and task definitions.
- Has advanced Oracle BI experience such as implementing SA System subject area, event polling, Usage Tracking, Time Series for forecasting, Aggregate Navigation and performance tuning.
- Experience in developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL. Experienced in basic and advanced Oracle SQL functions (RANK over, partition by, etc.)
- Functional knowledge experience in multiple industry domains. Profound Knowledge of SDLC and Software Testing Life Cycle. Participated in Integration, Regression, Performance and System testing.
- Experience in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / Denormalization strategies.
- Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, StoredProcedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
- Involved in Implementing Slowly Changing Dimensions, Star Join Schema modeling, Snowflake Modeling, FACT tables, Dimension tables, denormalization.
- Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.
- Expertise in UNIX shell scripting, FTP, MFTP and file management in various UNIX environments.
- Experience using Oracle 11g/10g/9i, Oracle Report Writer, SQL, PL/SQL, SQL*Plus, SQL*Loader, IBM DB2, SQL Server,Teradata V2R5/V2R4, Windows 95/98/2000/XP, Win NT 4.0 and Sun Solaris.
- Strong experience in Informatica administration and was involved in maintaining Informatica Repository and Server processes, performing code migration from DEV to TEST/ PROD, backup and restoring of Informatica Repository and upgrades.
- Knowledge in ODI (ETL), Business Objects, Cognos Report Net (Reporting Tools).
- Experience in designing BI publisher data model, building templates and running Jobs by bursting method for generating Invoices.
TECHNICAL SKILLS:
ETL Tools: Informatica Power Center 9.5.1, 9.1.1/8.6.1/8.1.1/7.1.2 , ODI 11G
Scheduling Tool: DAC 7.9.6.3
Data Modeling, Data Architecture: Erwin 4.5/4.0,Logical Modeling, Physical Modeling, Dimensional Data Modeling(Star Schema Modeling, Snow Flake Schema Modeling, FACT and Dimensions Tables)
BI & Reporting: OBIEE 11G/10G/Siebel Analytics 7.8.5,OBIA, BI Publisher 11G, Business Object 5.1, Cognos Report Net
Databases: Oracle11g/10g/9i, PL/SQL, SQL Server, Transact SQL, ANSI SQL, Sql*Loader, IBM DB2, Teradata
Operating System: Windows XP/2000/98/vista/7, Unix-AIX, HP-UX,Linux
Programming: SQL, PL/SQL, UNIX Shell Scripting
PROFESSIONAL EXPERIENCE:
Confidential, Redwood City, CA
Informatica and BI Developer
Responsibilities:
- Gathering the business requirements, gap analysis and identifying the solutions for new report requirements from Finance and Sales Business groups.
- Design the new star and snow flake models and implement them in Informatica and OBIEE
- Develop ETL mappings from different source systems like ERP 11i,R12, Siebel,UCM and sales force etc.
- Good Understanding of source system functionality, structures for ERP 11i,R12,Siebel,SV and Sales force sources
- Developed transactional custom Reports and Dashboards for Finance group
- Developed mappings to load Fact and Dimension tables, SCD Type I and SCD Type II dimensions and Incremental loading and unit tested the mappings.
- Closely worked with BSA’s for new enhancement requests and identifying the solutions for critical report logic requirements
- Worked with BI Architects to design and finalize the solutions and implemented the solutions in ETL and OBIEE.
- Worked on Control M production ETL loads monitoring and resolving the failures/errors.
- Involved in performance tuning of long running ETL jobs/Reports and provided solutions for the performance improvement.
- Closely worked with all business users across AMER/EMEA/APAC regions and resolved the incidents raised for critical reports.
- Worked in several key BI projects and involved in the estimates for the projects.
- Closely worked with ERP source teams for understanding the functionality of the business and implementing them in BI.
- Developed the new Subject Areas for business to create adhoc reports on need basis.
- Unit testing and regression testing for ETL and OBIEE codes developed and getting the business sign off.
- Involved in Informatica/OBIEE deployments, Installations and configurations
Environment: OBIEE 11.1.1.7.x, Informatica 9.5.1, Oracle 11g, SQL,PL/SQL,Control-M,Toad 12, Linux
Confidential, Bensenville, IL
OBIEE & Informatica Technical Analyst
Responsibilities:
- Interacted with Subject Matter Experts and Functional Analysts for reporting requirements analysis and to define business and functional specifications.
- Monitored and documented change requests in requirements and ensured modified requirements are met during BI development.
- Worked in all phases of the Software Development Life Cycle from gathering requirements Phase till implementing the code into production environment.
- Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.
- Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
- Used OBIEE Web Catalog to set up groups, access privileges and query privileges.
- Created dimension hierarchies, aggregation criteria and multiple logical sources in the BMM layer.
- Implemented security by creating roles and web groups, and defined Object Level and Data Level Security.
- Developed templates and reports in Oracle BI Publisher in rtf format.
- Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
- Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
- Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
- Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
- Implemented security based on LDAP Authentication.
- Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
- Created various templates, reports, and prompts in BI Publisher.
- Provided guidance and support to end users during the implementation and in production.
- Documenting the business requirements by creating the Interface Design Documents and converting them into ETL Technical specifications.
- Reviewing the requirements and working with data architect/modeler for design changes.
- Attending the code reviews developed by the other team members and making the appropriate suggestions to match the business requirements.
- Generated sample data based on the data model design and loaded the data into the database using UNIX shell scripts, which was used both for data analysis and also unit testing purposes.
- Used informatica as the ETL for extracting data from the flat files on UNIX platform and transforming the data according to the target database and perform loading.
- Created mappings using various transformations like source qualifier transformation, expression transformation, aggregator transformation, filter, lookup transformation, sorter transformation, joiner transformation, and Update strategy.
- Developed UNIX shell scripts as part of the ETL process to automate the process of loading, archiving data and maintaining the logs for the jobs on UNIX server.
Environment: OBIEE 11.1.1.6.x, Informatica 9.1.1, BI Publisher 10.1.3.4, Oracle 11g, SQL, Toad 12, Linux
Confidential, Kentucky
ETL Informatica Developer
Responsibilities:
- Analyzed business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
- Created detailed Technical specifications for Data Warehouse and ETL processes.
- Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet, and Transformation Developer.
- Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
- Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.
- Developed mappings to load Fact and Dimension tables, SCD Type I and SCD Type II dimensions and Incremental loading and unit tested the mappings.
- Written PL/SQL scripts in mappings like purging transactional data, metadata procedure.
- Worked in the Performance Tuning of SQL, ETL and other processes to optimize session performance.
- Worked extensively with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
- Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
- Data quality checking and interacting with the business analysts.
- Created shell script for archiving files and trigger files.
- Responsible for Unit Testing and helped with User Acceptance Testing.
- Scheduled Informatica jobs and implementing dependencies if necessary.
- Managed post-production issues and delivered all assignments/projects within specified time lines.
- Tuned Informatica mappings to improve the execution time by applying suitable Partitioning mechanisms and tuning individual transformations inside the mapping.
Environment: Informatica 9.1.0, Oracle 11g, PL/SQL, SQL Server, DB2, Teradata 14, $Universe, Clear Case, ERWin, Business Objects Info view, Windows, UNIX
Confidential, Kentucky
OBIEE Developer
Responsibilities:
- Implementation of OBI Financial Analytics for GL, AP and AR modules, Procurement and HR Analytics.
- Involved in Installations, configurations of Informatica, OBIEE and DAC across multiple environments in Linux.
- Meetings with different business teams to get the business requirements for modules like HR, Finance and Procurement.
- Development of customization requests in RPD and development of mappings in Informatica and adding the tasks to DAC.
- Prepared the test Cases for executed the test cases for ETL full and Incremental loads and Dashboards and Reports for all modules.
- Creation of new Dashboards and reports based on business requirements.
- Deployments of Informatica, DAC, OBIEE across DEV, CIT and PRD environments.
- Testing of DAC full load and incremental loads.
- Worked on user access management for different business groups based on their levels.
- Knowledge on ERP (Oracle apps) OLTP application.
Environment: Informatica 8.1.1SP4, OBIEE 10.1.3.4, Oracle 10g, DAC 7.9.5, Windows, UNIX.
Confidential, Jacksonville, FL
OBIEE Developer
Responsibilities:
- Merged new RPD, dashboard and Answers requests with existing OBIEE content and Upgraded RPD, Catalog from 10.1.3.4.1 to 11.1.1.3 and 11.1.1.3 to 11.1.1.5.
- Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
- Worked on improving the dashboard performance, readability, and security.
- Extensively involved in customizing federal related data in different views on a dashboard.
- Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
- Establish OBIEE 10g to 11g upgrade strategy and documented step by step upgrade process.
- Coordinated the OBIEE RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
- Worked on OBIEE Security implementation to provide data level security according to the user role.
- Worked on applying patches to OBIEE 11g environment after upgrading from OBIEE 10g by working with oracle after identifying the bugs.
- Implemented BI Publisher Bursting for scheduling the reports to deliver based on user role with security.
- Worked on implementing automatic cache purging after monthly data load completion by using Event pooling table.
- Extensively worked on all phases starting Requirement gathering, RPD development, security implementation, Report development and Report delivery by using Schedulers.
- Installed and configured Oracle BI Apps (OBIEE, DAC and Informatica) and extracted the pre-built BI solutions from HR Analytics repository from Oracle ERP sources and Oracle BI Apps.
- Support system and regression testing by communicating with functional teams and coordinating with technical team in prioritizing and resolving defects on time.
- Established environment strategy for configuration, development, testing and migration.
- Customized ETL mapping (SDE and SIL) for Oracle extended tables and columns required for report generation.
- Successfully implemented OBIEE 11g HR Analytics with Oracle apps ERP source system, Financial Analytics, Supply Chain & Order Management and Procurement and Spend Analytics.
- Additional activities included Implemented data level security, captured business requirements, status reporting and issue management.
- Extensively involved in developing the ETL process for loading data from MS-SQL source system to OLAP database as per the client requirement to use data for custom dashboard development.
- Configured and Extended the BI Apps Metadata repository contains of physical, business model layers with aggregates & dimensions, presentation layers with catalogs & folders using Oracle BI Administration tool
- Responsible for development of custom ETL mappings using different types of transformations created and monitored using Workflow manager and workflow monitor based on user requirement.
- Created KT transition plan for all deliverables also for production support prior to go-live.
- Suggested the system requirements for installing OBIEE environments as part of upgrading the OBIEE 10g to OBIEE 11g.
Environment: OBIEE 11.1.1.x/ 10.1.3.4/10.1.3.3. x,Informatica 9.1.1, BI Publisher 10.1.3.4, Oracle 10g & 11g, SQL, Toad 9.7, Windows XP
Confidential, CA
Informatica & OBIEE Support, Development &Upgrade
Responsibilities:
- Involved in design and development of RPD for OBIA and new mappings/workflow in Informatica in order to resolve production issues raised by business users.
- Involved in all business and technical meetings to understand and resolve the business critical issues.
- Executed CR's as part of defect fixing for the issues raised by Business teams.
- Prepared the test Cases for the developed mappings and Reports.
- Involved in Production Builds for Informatica, DAC and RPD across multiple environments.
- Involved in Installations, configurations of Informatica, OBIA and DAC.
- Maintenance of all the Production, development and test environments.
- Monitoring and scheduling the daily, weekly loads and monthly loads and distribution of status to all stake holders.
- Knowledge on siebel OLTP application and debugging the OBIA issues to siebel application to find the root cause of the issues.
- Upgraded Warehouse (OLAP) Schema from 7.8.4 to 7.9.5, Upgraded Informatica from v7.1.2 to v8.1.1., Upgraded OBIEE Platform from v7.8.5 to v10.1.3.4, Involved in DAC upgrade from v7.8.4 to v7.9.5
- Created manually all existing tasks in DAC 7.9.5 from DAC 7.8.5 and Imported all tables, columns and indices in DAC.
- Resolved all informatica and DAC related upgrade issues.
- Executed daily mock loads to resolve upgrade issues first in windows and finally in Linux and executed mock test cycles for schema upgrade in windows and Linux.
- Developed ETL mappings and Reports for the new development requests.
- Involved in execution of full and incremental loads and tuning of the mappings for the performance bottlenecks.
- Prepared the test Cases for executed the test cases for ETL full and Incremental loads and Dashboards and Reports for all modules.
- Involved in Requirement gathering, RPD development, security implementation, Report development and Report delivery by using Schedulers.
- Worked to achieve the agreed SLA for ETL loads and tickets raised by business for design and data issues.
Environment: OBIEE 10.1.3.4, Application server 7.9.5, DAC 7.9.5, Informatica 8.1.1 SP4, Oracle 10 G, Informatica 7.1.2, 6.1, Siebel Analytics 7.8.5, DAC 7.8.5, Sysadmiral tool, Linux, Windows NT