We provide IT Staff Augmentation Services!

Senior Etl Developer (bi/etl) Resume

San Diego, CA

SUMMARY

  • Thirteen years of professional experience in design and development of Data warehouses and in building Business Intelligence solutions.
  • Expertise in Business Intelligence tools like Business Objects/Crystal Reports and in Data Visualization tools like Tableau.
  • Experienced in understanding User’s business requirements and converting them into Technical requirements for both BI and ETL.
  • Expertise in working wif Informatica client tools - Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.
  • Experienced in Informatica MDM where data cleansing, De-duping and Address correction were performed.
  • Implemented complex business rules in Informatica Power Center and also implemented Slowly changing dimensions.
  • Expertise on Informatica Mappings, Mapplets, Sessions, Workflows and Work lets for data loads.
  • Seek out ways to utilize Salesforce.com to improve processes and productivity, and make recommendations to support an organization scaling at a rapid pace.
  • To Provide recommendations on how to improve teh Salesforce operational platform.
  • Work wif Application Architects and Tech Leads to design integrations between Salesforce.com and other systems across teh enterprise.
  • Design, code, and support solutions to meet business needs in Salesforce, including configurations, customizations and integrations.
  • Strong working noledge of Salesforce.com platform out-of-teh-box functionality and configuration.
  • Complete noledge of Business Objects architecture and its administration.
  • Expertise in Business Objects enterprise Products (Universe Designer, Information Design Tool, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM) and its deployment Extensively worked on Business Objects Designer in developing Universes.
  • Extensively used various features like Joins, Alias and Contexts in Universe Designer to resolve various join path problems like traps (Chasm, Fan) and Loops.
  • Applied security features of Business Objects like Row Level & Object Level security in teh universe so as to make teh sensitive data secure.
  • Extensively used advanced reporting functionalities such as Master Detailed, Drill Down, Drill through, Filters, Conditions, Slice & Dice, Prompts, Ranking, Sections, Graphs, Alerts, Charts, Grouping, Sorting and Breaks.
  • Hands-on experience in developing Analytical Dashboards using Xcelsius wif QaaWS.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts.
  • Developed Trend Lines, Statistics, and Log Axes and Used Groups, hierarchies, Sets to create detail level summary reports and Dashboards using KPI’s.
  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand teh data on teh fly wif teh usage of quick filters for on demand needed information.
  • Involved in Design and implementation of Datamarts and Data warehouse.
  • Expertise in Data Analysis, Data Mining and Data Validation.
  • Proficient in MS Excel. Created reports wif Pivot tables and Charts in MS Excel.
  • Experience in Relational and Dimensional Modeling techniques like Star, Snowflake Schema using ERWIN 4.5/4.0.
  • Excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS

BI: Business Objects 4.0/3.1/XI R2/6.5 (Universe Design Tool, Information Design Tool, Web Intelligence, Desktop Intelligence, Xcelsius, Information Steward, Promotion Manager, Central Management Console, Version Manager), Crystal Reports, Tableau 9.0.

ETL: Informatica Power Center 9.x/8.x, Repository Manger, Power Center Designer, Workflow Manager, Workflow Monitor, Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ)

Analytical Tools: Xcelsius, MS Excel

CRM: Salesforce.com

Database Languages: SQL, PL/SQL, T-SQL

Databases: Oracle 11g, 10g, 9i, 8i/SQL Server 2000, SQL Server 2005/Teradata V2R5 /MS Access

Other Languages: UNIX, Shell Scripting, XML, HTML, Python

Operating Systems: Windows NT/2000/XP, Windows Server 2008, Unix, Linux

Other Tools/Languages: Erwin 4.0/4.5, Toad, SQL Navigator, JavaScript, MS Office

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior ETL Developer (BI/ETL)

Responsibilities:

  • Work wif architects and business users on early project vision, and architecture blueprint. Review design roadmap for impacted systems, and look for opportunities to move systems toward long-term vision as part of project.
  • Serve as an expert resource on matters of data design to business and IT staff in different phases of project development, implementation and support.
  • Responsible for successful Design, Development and Delivery of projects involving ETL, Database and Business Intelligence.
  • Understand potential impacts of proposed solutions on other systems, processes or projects. Articulate and document designs, considering tradeoffs, costs, and benefits.
  • Collaborate wif architecture group on design decisions, standards, methodologies, and execution.
  • Development Experience in scripting language (e.g. Python, SQL).

Confidential, Teaneck, TX

Senior Associate (BI/ETL)

Responsibilities:

  • Responsible for designing and developing of mappings, mapplets, sessions and work flows for load teh data from source to target database using Informatica Power Center and tuned mappings for improving performance.
  • Interacted wif customer to gather teh Requirements and business logics for design and development.
  • Created and reviewed Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Lookups, Store Procedure transformation and created PL/SQL Stored Procedures, functions, Filters, Sequence, Router, Union and Update Strategy adhering to teh coding standards.
  • Actively participated in teh data modeling and in teh implementation of Data Vault Methodology, and in identifying Hub, Link and Satellite tables.
  • Involved in dimensional modeling and created snowflake/star data models for enterprise data warehouse.
  • Writing complex SQL query to use in teh Informatica ETL and to avoid using Informatica Lookup transformation to optimize performance of teh ETL mappings when teh data volume is high.
  • Seek out ways to utilize Salesforce.com to improve processes and productivity, and make recommendations to support an organization scaling at a rapid pace.
  • To Provide recommendations on how to improve teh Salesforce operational platform.
  • Work wif Application Architects and Tech Leads to design integrations between Salesforce.com and other systems across teh enterprise.
  • Design, code, and support solutions to meet business needs in Salesforce, including configurations, customizations and integrations.
  • Strong working noledge of Salesforce.com platform out-of-teh-box functionality and configuration.
  • Created adhoc reports to users in Tableau by connecting various data sources.
  • Handled Tableau admin activities granting access, managing extracts and Installations.
  • Generated Dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
  • Generated tableau dashboards for sales wif forecast and reference lines.
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.

Confidential, Fremont, CA

Programmer Analyst

Responsibilities:

  • Requirements Gathering and Data Analysis.
  • Designed & Implemented security architecture in Business Objects.
  • Designed Universes for Financial Billing system and Order processing.
  • Created Objects and prepared Reports for Accounts Receivable, Accounts Payable, Order management and Sales.
  • Provided user support/training to create Business Objects Reports and Assisted in trouble shooting user reporting issues.
  • Prepared month-end reports for General Ledger, Net Investment, Interest, Fees and Incomes.
  • Implemented Aggregate Awareness and tested teh aggregate awareness to ensure teh queries are pulling teh correct level of aggregation.
  • Implemented Security Features of Business Objects like row level, object level and report level to make teh data secure.
  • Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
  • Responsible for designing and developing of mappings, mapplets, sessions and work flows for load teh data from source to target database using Informatica Power Center and tuned mappings for improving performance.
  • Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
  • Design, development and support of teh Oracle Data Warehouse and multiple Data Marts.
  • Tuned mappings and SQL queries for better performance and efficiency.
  • Managed and compiled documentation for all ETL processes.
  • Extensively developed Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server TSQL and Oracle PL/SQL.
  • Identifying teh Key Performance Indicators and developed Dashboard reports for teh Key Performance Indicators for teh top management.
  • Administered user, user groups and scheduled instances for reports in Tableau.
  • Assisted teh business users in creating/modifying worksheets and data visualization dashboards.
  • Created report schedules, data connections, projects, groups in Tableau server. Created incremental refreshes for data sources on Tableau server.
  • Maintained and Installed Tableau Server in different environments.
  • Performed Tableau type conversion functions when connected to relational data sources and validating teh query results/reports before publishing to Tableau Server.
  • Generated tableau dashboards wif combination charts for clear understanding.
  • Involved in report tuning, caching, specifying query governing thresholds, and report optimizations.

Confidential, Houston, TX

Programmer Analyst

Responsibilities:

  • Participated in teh complete BI development lifecycle: Analysis, Design, Build, Test and Deploy reports.
  • Designed various complex Universes and resolved several join path problems like Loops, Fan traps and Chasm traps.
  • Made use of teh aggregate tables in teh Universes for faster historical data retrieval.
  • Created Reports using User Prompts, Sub-reports, Cross-tabs, Complex formulae, Variables, Conditions, Filters, Rank and Alerts to improve teh readability of teh report. Extensively used Calculations, Variables, and User Objects in teh creation of reports.
  • Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
  • Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
  • Created Web Intelligencereports wif multiple data providers and synchronized teh data using Merge Dimensions.
  • Carried out Administration tasks like maintaining teh Servers; Creating/maintaining teh Users/User Groups/Folders and rights; Setting up teh access levels; Maintenance of Various Versions of Universes/Reports using Version management; Moving teh Reports/Universes across Dev, QA and Prod environments using Promotion Management.
  • Suggested Indexes to DBAs on Database tables and created teh DB-Links pointing to teh remote databases to access teh source materialized views.
  • Involved in teh design of teh Data Warehouse and made suggestions based on teh reporting requirements.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
  • Developed mappings to load into staging tables and then to Dimensions and Facts
  • Designed/ customized data models for Data warehouse supporting data from multiple sources in real time.
  • Resolved Inconsistent and Duplicate Data to Support Strategic Goals wif Multidomain MDM.
  • To write teh wrapper scripts and SQL scripts in ETL Loading process.
  • Utilized Informatica tasks such as: Session, Command, Timer, Email, Event-Raise and Event-Wait.
  • Created database objects such astables, views, synonyms, indexes and materialized views.
  • Createdviewsbased on multiple tables and performed data changes usingInstead of triggersfor teh underlying tables.
  • Created PL/SQL Procedures, Functions, Triggers and Packagesto meet teh business needs.
  • Worked wifCollectionsand improved teh performance of multi-row queries by usingBulk Collect and Bulk binds.
  • TunedSQL statements usingExplain plan, TKPROFfor maximum efficiency and performance.
  • Performed teh uploading and downloading flat files fromUNIX serverusing FTP.
  • Avoidedmutating table errorsusing teh new functionality in Oracle 11g i.e.,Compound triggers.
  • Gathering and analyzing teh reporting requirements by meeting teh End Users.
  • Creating and Modifying teh New/Existing Crystal Reports involving Parameter prompts, Sub-reports, Crosstabs, alerts, charts, grouping, sorting to meet teh requirements of teh HR dept.
  • Created Reports in Excel using Pivot Tables for quickly summarize large amounts of data in an interactive way.
  • Used Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas in Excel Reports.
  • Data validation of certain complicated reports. Installed and used Toad to validate teh results.
  • Documented teh reports that were created, teh purpose and specification of teh reports. Outlined teh entire work on paper

Hire Now