We provide IT Staff Augmentation Services!

Etl Developer Resume

3.00 Rating

Charlotte, NC

Summary

  • Over 11years of progressive IT experienceinvolving a blend of client-server Technologies with focus on Data Warehousing solutions using OBIEE,OBIA, Siebel Analytics and Informatica.
  • OBIEE/OBIAConsultant with over 6 years experience in implementing Oracle Technologies especially with OBIEE, OBIA, Informatica and Siebel Datawarehouse.
  • Over 4years of experience in ETL tool Informatica PowerCenter, and intense development knowledge using Oracle 9i, Oracle 10g, Oracle 11g and SQL Server 2000.
  • Extensive experience in full life cycle Data Warehouse project design and development.
  • Interacted with the Business users, eBusiness team and Oracle Support to make critical decisions.
  • Expert in creation and customization of repository using OBIEE Administration Tool.
  • Experience with OBIEE Architecture, Administration, Data Modeling and Schema Design.
  • Working experience with imported physical tables and created required aliases, views and joins in
  • physical layer and applied Business rules, Calculations, Dimentional Hierarchies in BMM layer and
  • then created Presentation catalogs in presentation layer for both dashboard and Ad-hoc users.
  • Created OBIEE, OBIA Reports,Intelligence Dashboards, KPIs, iBots anddrilldowns.
  • Created reports which are used to analyze sales performance trends, forecast analysis,
  • comparative analysis in sales and marketing side and BI publisher reports for publishing
  • reports for university education and OBIA application reports for HR, Financial Analytics, Project Analytics, Spend, Procure and Order Management Analytics.
  • Expert in Repository and Dashboard performance tuning and experience in Repository and Webcat
  • migrations from one environment to other environments.
  • Worked on design documents and testing and schedule calls for code reviews and test case designs.
  • Extensively used Informatica Designer to create and manipulate source definitions,target definitions,mappings,mapplets,transformations and workflow manager tocreate sessions,workflows and worklets.Excellent working experience in Data Warehouse applications, directly responsible for theExtraction, Transformation & Loading of data from multiple sources into Data Warehouse.
  • Experience in performance tuning of Informatica workflows, mappings and sessions. Extensively
  • worked on Dimensional data modeling, Data migration, Data cleansing and Data Staging of
  • operational sources using ETL processes for data warehouse.
  • Experience in Configuring ETL Execution Plans in Data Warehouse AdministrationConsole(DAC).
  • Highly proficient in SQL, PL/SQL, Stored Procedures, Triggers, Unix Shell scripting.
  • Excellent Analytical, Communication and Team Working Skills.

Technical Expertise

CRM: Siebel 7.x, Siebel Installation, Siebel Architecture.
Languages: SQL, PL/SQL, C, C++, .NET, Java
Data Warehouse Tools: OBIEE 11.1.1.6, OBIEE 10.1.3.3, OBIEE 10.1.3.4, Siebel Analytics 7.8/7.7/7.5, Siebel DAC, and INFORMATICA 5.x/6.x/7.x/8.6
Web Tools: HTML, ASP, Java Script, VB Script, XML
Data Modeling Tools: Erwin 3.x/4.x
Databases: Teradata V2R6, Oracle 7.x/8.x/9i, SQL Server 2000,PeopleSoft9.0, Oracle EBS 12.1
Operating Systems: UNIX, Linux and Windows XP/vista/NT/2000/7

Professional Experience

Confidential, Charlotte,NC Jan ‘13 to Till date
Role: OBIEE/OBIA Lead

Responsibilities:

  • Working on customized Workforce HR Analytics, Learning Management, WorkforceFinancial Services and Non GL Systems.
  • Working on two different projects such as Wells fargo – Workforce Financial (GL) and Wells fargo – Learning Management projects.
  • Worked on OBIEE Metadata(RPD) Development, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
  • Imported new tables and columns from Data warehouse, created required aliases and views, created physical and logical Joins, created Dimensional Hierarchies and Level Based Measures, worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the business user requirements.
  • Worked on creating repository variables and session variables which are used across the RPD and created Adhoc subject areas for business users to create their own reports on Workforce Financial and Learning Center (management).
  • Once the metadata is consistent I worked on data dictionary (documentation) for the work which I did on the metadata configurations.
  • Created Wells fargo – Workforce Financial (GL) reports which are used to analyze Personnel Expense and Hours Paid, FTE and GL Headcount, Hires and Terminations and AU (Authorizing Unit) Change details of full time employee.
  • Created Wells Fargo – Learning Management dashboards such as Assigned Training Summary, Assigned Training Learner Details, Class Utilization, Course Actual Duration, Learner Program Summary and Program details and Learner Training Progress.
  • Working on production support for non GL workforce dashboards such as Compensation, Demographics, Movements and Non – Employee Workforce.
  • Working on enhancements of existing Wells Fargo – Workforce Analytics dashboards such as Promotions, Recruitment, Terminations and Performance Management.
  • Working on deployment proccess of RPD and webcatalog. Configured Application Specific roles for dashboard users and groups for security of Wells fargo – Workforce Financial (GL) and Wells fargo – Learning Management using Enterprise Manager.
  • Working with middle tier to provide deployment process documentation to provide code knowledge transfer sessions. Worked on providing knowledge transfer to the Business users and the Client site Maintanance employees.
  • Environment: OBIEE 11.1.1.6, Informatica 8.6, Oracle 11G, Advanced Query Tool V9,Peoplesoft 9.0, UNIX, Windows 7 and Windows Server 2008.

Confidential,Atlanta, GA Apr ‘12 to Dec ‘12
Role: OBIEE/OBIA, ETL Lead

Responsibilities:

  • Working on OBIEE customized Project Analytics, Spend, Procure and Financial Analytics Application’s prototype project.
  • Working as an onsite liaison for providing the reports specifications to the offshore team with report mockups provided by the bussiness users.
  • Worked on OBIEE Metadata(RPD) Development, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
  • Used different filter conditions both in the repository and in front end based on business rules provided by the business users and created customized promts on dashboard level.
  • Created OBIEE Project Analytics mockup reports which will be used to create OBIEE reports for analyze Budget details, Cost details, Revenue details, Profitability details and Funding and billing information.
  • Working on customizing AP, AR and GL modules of Financial Analytics reports which are used to analyze Financial metrics by quarter and by month, Revenue and Profit by sales group, Revenue and Profit by product, Cash flow analysis, Customer Analysis, Supplier Analysis, Trend Analysis, Product Analysis and Sales Group Analysis.
  • Working on Spend and Procurement Analytics reports which are used to analyzeSpending the cost information by category, supplier, organization and by item, Top 10 Manufactures by revenue and by profit, Top 10 Customers by revenue and by profit and Top 10 Suppliers by revenue and by profit.
  • Working with deployment group to provide deployment process documentation to provide code knowledge transfer sessions.
  • Worked on customizing and building SDE mappings for extracting data to staging areas and loading data using SIL mappings.
  • Worked on loading data into Customized Fact tables such as Revenue fact, COGS Fact, Sales Invoice Line Fact and Sales Rep Fact using new Informatica Mappings.
  • Created and customized Informatica Mappings to pull data from OLTP and Agilysys‘s own Operational Data Store.
  • Created Complex mappings using Lookup, Update Strategy, Aggregator, Joiner, Expression and Router transformations for populating target table in efficient manner.
  • Monitoring Oracle Data Warehouse Adminstration Console(DAC)jobs on daily and weekly basis and provide production support.

Environment: OBIEE 10.1.3.4, OBIA 7.9.6, Informatica 8.6, Oracle 10G, Oracle EBS12.1, UNIX and Windows 7.

Confidential,Charlotte, NC oct ‘11 toApr ‘12
Role: SrOBIEE, ETL Developer

Responsibilities:

  • Worked extensively on OBIEE customozed HR Analytics and Financial Analytics Applications .
  • Worked extensively on OBIEE Metadata(RPD) Development, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
  • Imported new tables and columns from the Data warehouse, created Physical and Logical Joins, created Dimensional Hierarchies and Level Based Measures, worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement, wrote Case SQL Statements to manipulate the data as per the business needs.
  • Built the Logic in the BMM layer to make proper connections and created new logical columns based on the newly added physical columns and business user requirements.
  • Created OBIEE HR analytics reports which are used to analyze On Boarding employee, Staffing details like Active Staff and LTD Staff, Employee Retention details, Demographics of the emloyee like Admin Council, Area Headcount report, Leaves and Retirement details of employee.
  • Created Financial Analytics reports which are used to analyze Trial Balance, Intercompany Balances, Journal Inquiries, Daily Cash Flows, Flow Analysis, Expense Analysis and Treasury Movement of Cash analysis.
  • Worked on performance tuning of the reports and metadata by following the best practices suggested by Oracle.
  • Involved in setting up the environments for MUD, Development, Unit Testing, System Testing and Production for the developers and testing teams.
  • Worked on loading data into Out of the box and Customized Fact tables such as Organization, Event, Employee demographics, Belief, Contact Permission and Syndicated Data Fact groups using out of the box and new Informatica Mappings.
  • Created and customized Informatica Mappings to pull data from OLTP and TIAA‘s own Operational Data Store.
  • Created Complex mappings using Lookup, Update Strategy, Aggregator, Joiner, Expression and Router transformations for populating target table in efficient manner.
  • Worked on scheduling tools such as Autosys and Gentran to schedule and monitor jobs for daily and weekly basis for TIAA-CREF specific various interfaces such as Identity Manager, Service Now, Clarity, Compliance, Employee Demographics, Kronos, Lenel, Resource Management, Secretary, Space Planning, Aveska, Taleo, Sunguard and Talent Center.

Environment: OBIEE 10.1.3.4, OBIA 7.9.6, Informatica 8.6, Oracle 11G,Peoplesoft 9.0, UNIX, Autosys, Gentran and Windows XP Professional.

Confidential, CT Feb ’10 TOSeptember ‘11
Sr OBIEE /BIP Developer

Responsibilities:

  • Worked as an onsite liaison for providing the Technical Design documentation to the offshore team with report mockups provided by the bussiness users.
  • Worked extensively on OBIEEMetadata(RPD) Development, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
  • Imported new tables and columns from the Data warehouse, created Physical and Logical Joins, worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement, wrote Case SQL Statements to manipulate the data as per the needs in the rpd.
  • Built the Logic in the BMM layer to make proper connections and created new logical columns based on the newly added physical columns.
  • On repository worked on creating users, groups and setting up the data and object level security as well.On Web cat worked on creating dashboard users and groups and setting up section level permissions.
  • Created OBIEE reports which are used to analyze the Client Resolutions, Award Setup and Maintenance, Sponsor, Subawardee,Weekly submissions, Current and pending support, Award protocol, awards and installments,proposal submission, PI status request,submission oppotunity trackingand portfolio reports.
  • Worked on creating the Oracle Business Intelligence Publisher reports.
  • Used both concatenated SQL and SQL query types in type option of data model.Define parameters that users wnat to pass to the query, and define lists of values for users to select parameter values.
  • Designed the RTF and PDF layout templates.Worked on creating the layout templates using microsoft officefor RTF templates and uploading the templates to the report editor and worked on Bursting options andtemplate configurations on BI Publisher.Worked on configuring the BI publisher reports into the OBIEE dashboards and scheduling the BI Publisher reports.
  • Worked on performance tuning of the reports and metadata by following the best practices suggested by Oracle.
  • Worked on RPD and webcat migrationsfrom Development environment to System Test environment and to Pre Production environment.
  • Involved in setting up the environments for Development,Unit Testing, System Testing and Production for the developers and testing teams.
  • Worked on enhancements of current system and production support.
  • Worked on providing knowledge transfer to the Business users and the Client site Maintanance employees.

Environment: OBIEE 10.1.3.4, Informatica8.6.1, Oracle 10G, TOAD, UNIX, XML Windows Vista Enterprise.

Confidential, Nutley, NJ Oct ’08 TO Feb ’10
Sr. OBIEE /ETL Developer/Analyst

Responsibilities:

  • Worked with business users to gather the requirements and worked on documenting the functional and technical specifications, developement,deployment and testing of the project.
  • Worked on data modeling using Erwin Data Modeler.
  • Created connection pools, imported new tables and columns from the Data warehouse and defined Physical joins in Physical layer and in Business Model Layer created Logical Joins, createdDimensional Hierarchies, Aggregates, Keys and Level Based measures, worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement, wrote Case SQL Statements to manipulate the data as per the needs in RPD.
  • Created ragged hierarchies for the organizational structure to enable the drill down feature.
  • Worked on creating repository and session variables such as static and dynamic along with initialization blocks in the rpd.
  • Worked on creating the Oracle Business Intelligence Publisher reports.Define the data model using Oracle BI Answers, SQL Queries, XML and Files data models.
  • Define the parameters that users wnat to pass to the query, and define lists of values for users to select parameter values.Designed the RTF and PDF layout templates.
  • Worked on creating the layout templates using microsoft office for RTF templates and uploading the templates to the report editor.Worked on template configurations on BI Publisher.
  • Configured the BI publisher reports into the OBIEE dashboards and scheduling BIP reports.
  • Worked on loading data into Out of the box and Customiized Fact tables such as Activity, Call Detail, Belief, Contact Permission, and Syndicated Data Fact groups using out of the box and new Informatica Mappings.
  • Created and customized Informatica Mappings to pull data from Siebel OLTP and Roche‘s own Operational Data Store(ODS).
  • Created Complex mappings using Lookup, Aggregator, Joiner, Expression and Router transformations for populating target table in efficient manner.
  • Created Mapplet and used them in different Mappings.
  • Performance tuning of the ETL Mappings and Sessions along with the Datawarehouse tables for faster retrieval of reports.
  • Worked on Siebel Data Warehouse Console(DAC) to create daily and weekly execution plans for loading data from multiple source systems to the warehouse.
  • Performed unit testing and system testing of all components of OBIEE Analytics and worked with business users and performed gap analysis.

Environment: OBIEE 10.1.3.4, Siebel Analytics 7.8.2, Informatica7.1, Oracle 10G/9i, HP-Unix, WindowsXP.

Confidential,New York, NY Feb 08 to Sep ’08
Role: OBIEE / ETL Developer

Responsibilities:

  • Worked extensively on OBIEE and Informatica Development, System Test and Production environments.
  • Involved in OBIEE and Informatica production support for FMBO project.Worked on failure jobs of daily, weekly and monthly runs.
  • Resolved data, flat file, deadlock related and SQL override issues in Informatica mappings.
  • Worked on Oracle to Teradata upgrade project and resolved Teradata and Oracle SQL syntax conflicts.Set all error table, log table properties for Teradata loaders like Fast load, TPUMP and Mload connections.
  • Worked on performance tuning of ETL Mappings and Sessions along with the Datawarehouse tables for faster retrieval of reports.
  • Involved in migration of mappings from Dev environment to System test and System test to Production environments.
  • Worked on OBIEE BMM layer to create new logical columns by applyiing functions like rank, sum based on the new requirements. Worked on presentation catalogues in presentation layer used for both ad-hoc and dashboard users.
  • Modified existing OBIEE reports with newly added columns which are used to analyze the Client Resolutions, Plan Setup and Maintenance, Insurance Executive, Marketing, Sales and Service reports, Institution Service-Detail and Monthly Performance, YTD Institution Call Summary.
  • Modified reports from Table view to Pivot table, Table to Chart view and added new Column and View selectors in the reports.
  • Worked on performance tuning of the reports and metadata by following the best practices suggested by Oracle.

Environment: OBIEE 10.1.3.3, Siebel Analytics 7.8.4., Informatica 7.1, Oracle 10G, Teradata V2 R5, TOAD, UNIX, XML Windows XP Professional.

Education
M.S. Computer Science

We'd love your feedback!