We provide IT Staff Augmentation Services!

Etl Developer Resume Profile

UsA

PROFESSIONAL SUMMARY

  • Over 7 years of experience in IT Industry, experienced in designing, development and implementation of OBIEE.
  • Exposure in managing OBIEE projects.
  • Exposure in building repository, creating and managing Dashboards, Answers.
  • Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
  • Experienced in designing and developing Data Modeling and Analysis using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool.
  • Experienced in writing, testing and implementation of Stored Procedures and Packages at database level using PL/SQL.
  • Experienced in building repositories using star schema, developing Subject Areas, and applying security group, access / query privileges at object and data level in Administration Tool.
  • Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables using OBI.
  • Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
  • Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.
  • Capable to execute large OBIEE projects
  • Experience in data warehouse administration console DAC to configure, monitor and schedule ETL routines
  • Expert ability to trouble shoots and prioritizes issues.
  • Sound knowledge of data warehouse concepts.
  • Work experience in Informatica that includes creating mappings to transform data.
  • Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS

  • OBIEE Infrastructure : OBIEE 11
  • RDBMS : Oracle 11g, MS Access
  • ETL Tools : Knowledge in Informatica Power Center7.0, SQL Loader, DAC
  • Platform : DOS, MS Windows 9x/NT/XP, UNIX
  • Reporting Tools : Business Objects architecture designing reports , Crystal Reports XI, BRIO, OBIEE
  • CRM Tools : Epiphany
  • Interfacing Tools : Putty, Microsoft Terminal services
  • Scripting Language : Unix

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Project Description:

Confidential management and NetApp executive team had a need to measure, analyze, and manage the effectiveness of their learning programs and investments through key performance indicators. They wanted analysis and reports that can help managers and executives analyze, understand, and act on the overall training business. They needed to understand the effectiveness of learning content, content vendors, e-learning programs, and resources.

  • Field Tech Readiness
  • El Dorado Training Track
  • BI dashboards and reports provides a single, scalable aggregation source for reporting that will support data growth in size and complexity. Minimize the risk of unreliable data outputs, both internal and external, by negating the need to manually combine data from different sources.
  • Integration of the Partner Database and NetAppU systems to provide a comprehensive view of partner and contact training information to allow the field to analyze the competency of the partner community.
  • The TESO group currently does not have the ability to measure and track employee readiness for the different solution area technologies pertaining to their organization. They have asked NetAppU to assist them in defining, designing, and delivering a multitude of training programs which will include course curriculums and activities for the different roles and their respective levels in the TESO organization.
  • In addition to the curriculums, NetAppU will design and deliver BI dashboard reporting capabilities which will enable TESO organization to track the readiness for their employees in each role and each level across different solution areas

Responsibilities:

  • Enhance training data quality and ability to analyze data
  • Improve visibility into training data from a centralized system
  • Provide more efficient reporting functionality on all NetApp partner programs for compliance and overall partner and contact training competency
  • Proactively manage partner and contact overall competency
  • Improves fields ability to manage, report, analyze and evaluate a partners competency and compliance
  • Enhances the data quality by integrating two data sets
  • Provides better visibility into partner and contact comprehensive training and compliance data
  • Improves reporting operational efficiency
  • Analysis of sources systems and business models.
  • Design of ETL process to load new PLP training data from source web service to staging area and then to data mart.
  • Design and development of Business Models for Partner and Contact Compliance.
  • Responsible for Dimensional Modeling.
  • Designing of Dimensions and Facts.
  • Designing data models Star Schemas, Snowflake Schemas.
  • Integration of BI application with the Web Application to provide Seamless integration to partner and contact dashboards from PDB to NetAppU.
  • Designing the security models in OBIEE RPD and Catalog Manager.
  • Designing and developing different Analytical reports and Interactive Dashboards in Oracle BI EE 10.1.3.
  • to measure and track employee readiness for the different solution area
  • to track the readiness for their employees in each role
  • to track the readiness for their employees in each level
  • Developing oracle PL/SQL procedures and packages for incremental load of data into DW.
  • Responsible for Dimensional Modeling.
  • Designing of Dimensions and Facts.
  • Developing oracle PL/SQL procedures and packages for calculating compliance status.
  • Designing data models Star Schemas, Snowflake Schemas.
  • Designing the security models in OBIEE RPD and Catalog Manager.
  • Designing and developing different Analytical reports and Interactive Dashboards in Oracle BI EE 10.1.3.

Environment: Oracle 11g, PL/SQL, OBIEE 11.1

Confidential

ETL Developer

Project Description:

Confidential is an established market leader for companies in the insurance, collision repair, medical claims, workers compensation, and auto glass replacement industries. They wanted to make some dashboards and wanted to maintain data mart with current data with refresh of every 15 minutes

Responsibilities:

  • Done following things for the module 'Operational dashboards'
  • To maintain datamart with latest data.
  • Responsible for managing database
  • Responsible for implementing data warehouse
  • Responsible for managing different stages of DW
  • Responsible for managing data mart.
  • Loaded Source tables in to database Stage through PL/SQL
  • Data is moved from stage to ODS through PL/SQL
  • Finally data is moved from ODS to data mart through PL/SQL
  • These Procedures are called via SSIS jobs.
  • The specified data is used for creating Dashboards
  • Performance tuning as the above job is called in every 15 minutes of interval.
  • Unit Test case preparation.
  • to create and schedule some jobs in DAC

Environment: Oracle 10g, PL/SQL, Microsoft SSIS, DAC

Confidential

OBIEE Developer

Project Description:

Confidential is the leading solution provider for mobile operators. They were maintaining their data in excel files and wanted to make database and datamarts. Then they utilized that data to make some dashboards.

Responsibilities:

  • Dashboard Development
  • The specified data is used for Analytical Report Development
  • Finally data is moved from stage2 to datamart
  • Data is moved from stage1 to stage2 through procedures
  • Loaded Excel files in to database Stage1 through SQL Loader
  • Created stored procedures
  • Created indexes for performances
  • Created different keys to link data
  • Created new tables to accommodate data
  • Responsible for creating new database
  • Unit Test case preparation.

Environment: Oracle BI EE 10.0.3 Answers, Dashboards , Oracle10g, SQL Loader

Confidential

OBIEE Developer

Project Description:

Confidential is an established market leader for companies in the insurance. They wanted to move to OBIEE environment and preview some dashboards for auto claims.

Responsibilities:

  • Done following things for the modules Auto Claim
  • Analytical Report Development.
  • Analyse database
  • Analyse data
  • RPD development
  • Imported table to physical layer
  • Handled joins in tables
  • Managed star schema.
  • Created business layer
  • Created presentation layer.
  • Made subject area auto claim
  • Hide the tables/ columns that were not required for user.
  • Dashboard Development
  • Unit Test case preparation.

Environment: Oracle BI EE 10.0.3 Answers, Dashboards , Oracle10g

Confidential

OBIEE Developer

Project Description:

Confidential ITG to provide Analytics and Dashboards for Confidential Steels departments and to the Confidential. ZI-BIRS will provide Financial Dashboard to COO of ConfidentialIndustrial to define company strategies.

Responsibilities:

  • Done following things for the modules HR and sales force
  • Analytical Report Development.
  • Analyse database
  • Analyse data
  • RPD development
  • Imported table to physical layer
  • Handled joins in tables
  • Managed star schema.
  • Created business layer
  • Created presentation layer.
  • Made subject area auto claim
  • Hide the tables/ columns that were not required for user.
  • Dashboard Development
  • Unit Test case preparation.

Environment: Oracle BI EE 10.0.3 Answers, Dashboards , Oracle10g

Confidential

Database Developer

Project Description:

Confidential

  • Data is an asset for any organization and tracking of data becomes a critical aspect when it comes to financial figures and other critical application data. Any change to data is tracked using audit trail.
  • Identify all the tables that have to be audited
  • We get data in plain text files and this data has to be stored in target tables. This process is done in two stages.

Responsibilities

  • In first stage this file data is moved to first stage tables using SQL Server BI studio,
  • Create master table TL operations to store transaction/operations such as ADD , UPDATE , DELETE
  • Create master table TL BusinessEntity to store all business entities such as dealer, address
  • Create an application wide AuditHistory table
  • Create separate audit table for each one with same schema plus an addition column OperationType
  • Analyse constatints on tables
  • Analyse joins between tables
  • Analyse existing data
  • Analyse existing database
  • from these tables data is moved to final target tables using Stored procedures by applying business logics

Environment: Windows XP, SQL Server 2005, SQL Server BI tool

Database and Report Developer

Project Description:

Confidential is a major public computer and its accessories manufacturing company. HP CKRM Customer Knowledge Relationship Management : Customer Knowledge and Relationship Management Confidential is the worldwide CRM data warehouse initiative of the Imaging and Printing Group IPG at HP. This CRM data warehouse, known as CKMDW, serves as the repository of customer related data for a 3600 view of customer profile information, product registration information, sales transaction information and click-through data from campaigns. CKMDW maintains current and historical data with the objective of providing customer business intelligence and knowledge management services to HP management and partners. In short the project is about data warehousing and data mining for IPG-IT division.

Responsibilities

  • Create a new fact table for HIC Customers.
  • Created a universe
  • A field Special Program Flag. This Flag data item is used to distinguish a HUT customer from a HIC customer.
  • Use Derived tables and indexes, Linking universes, Secure, test and manage Universe aggregate awareness
  • Resolve SQL traps using functions with objects, create and use hierarchies, Design
  • Universe Designing, Universe structure, identifying associated classes/objects, resolves loops and context, effective use of list of values,
  • Work of BO architecture and report designing
  • Created a View for new fact table for HIC Customer.
  • Created a Unix Script that calls SQL script to load data into fact table and provide some business logic to fact table
  • Created a SQL script to load data into fact table.
  • Created Classes/Objects.
  • Created new set of BO reports.
  • Existing tables of CKMDB changed to accommodate extra fields of CKMAP
  • Extra table, sequences of CKMAP added to CKMDB
  • Existing mapping of informatica changed
  • Some new informatica mappings added
  • Unix script of mart refresh changed
  • Merge two data marts to encapsulate business requirements of AP Mart consolidation to World Wide CKMDB Mart. It will be used as a base for the detailed analysis of the various applications involved
  • Epiphany changes : Dimension, Facts, Extraction Jobs, Presentation layer
  • To create Listpulls for creating specified files and/or reports of information from our CKM database based on criteria submitted by client. This information could be used for campaigns, counts and/or summary reports. Quality control QC is done on all incoming listpulls request and the resulting outgoing output files.
  • The Dashboard is intended to provide a comprehensive picture of the state of customer and / or product registrations. It caters to both the executive and analytical requirements and is based on the study carried out by the IT team with respect to the same. Basically dashboard provides a web-based intuitive interface to the users and is based on the datamarts

Environment: HP-UX11.0, Windows XP, Oracle, Epiphany, BO, WebI, Informatica

Hire Now