We provide IT Staff Augmentation Services!

Bi /etl Developer Resume

4.00 Rating

Worcester, MA

PROFESSIONAL SUMMARY

  • Over 6 years of experience with Business Intelligence tools such as Tableau and OBIEE.
  • Extensively worked on Tableau 7.x/8.x (Desktop, Server, Mobile, and Public), Micro Strategy, Business Objects and SSRS.
  • Involved in Full Life Cycle Development of Reporting Projects, includes Requirements gathering/ analysis, Design, Development, Testing and Production rollover.
  • Extensive experience in Installation, configuration, upgrade (simple Configuration, 3 - server Cluster and 5-Server Cluster) and administration of Tableau Desktop/Server.
  • Very strong with Tableau Desktop for data visualization, Reporting and Analysis, Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
  • Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
  • Strong SQL background and developed Entity-Relationship diagrams, Star/Snow Flake Schema Designs.
  • Translated different business requirements into report visualization specifications design documents.
  • Expert in modeling Transactional Databases and Data Warehouse.
  • Worked with data source like Oracle, and SQL server.
  • Worked on Metadata management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
  • Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
  • Quick learner and good performer both in team and independent job environments
  • Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.
  • Experience in all aspects of project development life cycle in Data Warehousing.
  • Experience in development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate with ETL Solution using Informatica.
  • Power Center 9.5/9.1/8.6/8.1.0/7.1.2 ,, Power Exchange and Power mart.
  • Experience in planning, building and managing successful large scale Data Warehouse and decision support system implementations.
  • Experience in developing complex Mapplets, Worklets and re-usable Tasks.
  • Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Filter, Router, Aggregator, Expression, Joiner, Update Strategy and more.
  • Excellent hands on experience in the entire Life Cycle of Data warehouse/Business Intelligence, designing and developing ETL objects, performance tuning.
  • Experience in logical, Physical models and implementing them in Oracle along with elaborate documentation.

TECHNICAL SKILLS

Reporting Tools: Tableau 8.0/7.0,OBIEE 10.1.3x/11g (Oracle BI Interactive Dashboards, Oracle BI Administration Tool, Oracle BI Answers, Siebel Analytics, Oracle BI Delivers).SSIS,SSRS.

Data Warehousing ETL Tools: Informatica Power Center9.X,8.X,7.X

Databases: Oracle 11g/10g/9i, My SQL SQL Server, Teradata

Database Tools: TOAD, SQL Developer, SQL Plus

Languages: PL/SQL, SQL, Unix shell scripting, Java, C,PSP,C++.

Web Tools: HTML, DHTML, XML, JAVA SCRIPT

PROFESSIONAL EXPERIENCE

Confidential, Worcester, MA

BI /ETL Developer

Responsibilities:

  • Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
  • Involved in installation of Tableau desktop, Tableau server Application software.
  • Developed reports with features like drill down, slice and dice, master/detail for analysis of business.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked on Tableau Dashboards in Tableau 8.1. Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
  • Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
  • Worked on Migration of User Developed Applications/reports from Mainframe SAS to SAS EG in order to optimize the execution time, resources and to reduce the cost of process
  • Used Data Warehouse Architecture and Design - Star Schema, FACT and Dimensional Tables, Physical/Logical Data Modeling and data flow diagrams.
  • Managed Testing cycle in regards to reports and dashboard validation
  • Managed offshore resources.
  • Handling charge as an ETL Analyst with prime responsibilities of working on ODS and SDR applications.
  • Developed and implemented the coding of Informatica Mapping for ODS and SDR applications. Prepared technical specification documents.
  • Problem identification, root cause analysis and fixing the issues.
  • Fixed the invalid mappings and troubleshoot the technical problems of the database. Debug the sessions by utilizing the logs of the sessions.
  • Responsibilities include designing the documents, which is based on the requirement specifications.

Confidential, Atlanta, GA

Tableau Admin / ETL Developer

Responsibilities:

  • Gathered Business Requirements by interacting with Business Users, Project Manager and SMEs
  • Analyzed metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
  • Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
  • Created reporting standards and naming conventions document.
  • Provided 24/7-production support forTableauusers.
  • Created new mappings and updating old mappings according to changes in Business logic.
  • Used Informatica to populate the data mart from large flat files and relational databases.
  • Created complex transformations using Joiner, Update Strategy and Lookup, Expression etc.
  • Involved in the development of Informatica mappings between Source system and Warehouse.

Confidential, Old Tappan, NJ

Tableau Admin / ETL Developer

Responsibilities:

  • Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
  • Gathered Business Requirements by interacting with Business Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Published Dashboards to Tableau Server for business users to consume
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
  • Combined visualizations into Interactive Dashboards and publish them to the web.
  • Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
  • Created groups and users in Tableau server
  • Created several dashboards with various chart types such as stacked bar charts, scatter plots, heat maps, and text tables that demonstrated insightful trends over a period of time.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metricsCreated and assisted users in Tableau dashboard development
  • Responsible for extracting, transforming, and loading data from ODS, flat files and placing it into data warehouse.
  • Resolved various performance issues and analyzed the best process distribution for different projects.
  • Prepared Source to target mapping document.
  • Involved in design and coding of the mappings and in preparing detail documentation of the same.
  • Preparation and review of test cases.
  • Used different transformations like Expression, Joiner, Aggregator, Update Strategy, Lookup - Connected & Unconnected, Filter, Sorter, Source Qualifier etc.
  • Training and Mentoring Junior team members

Confidential, Chicago, IL

BI Developer

Responsibilities:

  • Interacted with the Business Users and Supervisors to get a better understanding of client business processes and to gather business requirements.
  • Analyzed the Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).
  • Enhanced previous ETLs with new features by exploring areas of improvements like data quality, data masking, slowly changingdimensions andperformance enhancements.
  • Implemented best practices for development in all the environments.
  • Created Physical Layer, Business Model and Mapping Layer and Presentation Layer in RPD using Oracle BI Administration Tool.
  • Migrated RPD and Catalog from Development to Test and to Production Environment.
  • Created Aggregated Tables to improve the Performance of the Reports.
  • Created Connection pools, import physical tables and define joins in the Physical Layer.
  • Created Tables, Views, Indexes, Stored Procedures, Triggers in databases.
  • Analyzed long running queries and tuned the complex queries to optimize application and system performance.
  • Understand the Business Requirements.
  • Analyzing the requirement gathered from Business Users
  • Designing the logics to be implemented Confidential the RPD level.
  • Created Reports, prompts and Filters using OBIEE.
  • Created dashboard pages and sections.
  • Created Reports with graphical representation such as Bar charts, pie charts
  • Created alerts for reports
  • Created Action Links, Prompted Links and Saved customizations.
  • Formatted the Reports as per the Client requirement.

We'd love your feedback!