We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

San Ramon, CaliforniA

SUMMARY:

  • 7 Years and 8 months of professional IT experience as a Data Modeler and Data Warehouse Developer with an extensive experience on SAP Business Objects, Informatica, Tableau, Xcelsius and Erwin.
  • Certified as SAP Business Objects Associate Web Intelligence XI 3.x.
  • Technically worked on end-to-end Data warehousing projects and in various roles and phases including requirements gathering, providing effort estimates, analyzing the data and creating data models and developing the logic to build data warehouse using ETL and generating the business reports and dashboards for business decision making for leading clients like Confidential , Confidential , Confidential , Apple Computers.
  • Extensively worked on SAP Business Objects 5.1, 6.5, XI R2/ XI 3.1 and SAP BO 4.0 (Business Objects (BOBJ) Product Suite including Web Intelligence reporting, Universe Designer, Desktop Intelligence, Administrator) for 5Years and ETL Tool Informatica for 4Years and Database Tools such as SQL Server 2005 and 2008, Oracle and Teradata 13, Dashboards Tableau and Data Modeling tool - Erwin.
  • Worked on development of complex reports and dashboards and upgrading the client web intelligence reports from BO 5.1/6.5/XI R2 to BO XI 3.1 version. Also, designed universes and worked with loops, contexts, row level restrictions.
  • Worked on loading the data from various sources to targets and also, implementing the SCD logic using Informatica tool.
  • Good understanding in Dimensional Data Modeling Technique, E-R modeling, Multidimensional Database Schemas like Star schema (Fact Tables, Dimension Tables), and handling SCD’s and the data warehousing concepts.
  • Experience in writing Stored Procedures, Packages and Analytical Queries.
  • Responsible in writing and reviewing technical and functional design documents in the projects.
  • Good communication and presentation skills.
  • Worked on various domains like Insurance, Retail, Manufacturing and Banking.
  • Can work independently and also with the team.

Professional Summary:

Technical Summary:

ETL Tool: Informatica Power Center 8.1, 8.6, 9.1,9.5.1

Reporting Tools: Business Objects 5.1, 6.5, BO XIR2, BO XI3.1, SAP BO 4.0

Dashboards: Tableau, Xcelsius

RDBMS: SQLServer2005, SQL Server 2008, Teradata 13, Oracle 11g

Schedulers: ASG Zena 2.1

Project Profile:

Confidential, San Ramon, California, US

Role: Senior ETL Developer

Project Description:

The project involves in providing the best ETL architecture for long term framework and foundation that can be maintained and grown as the business requirements change and expand. There are six key areas that have been considered during the architecture design process that that will ensure a high-quality sustainable ETL Architecture.

Responsibilities:

  • Creating Mapplets in IDQ for doing the edit checks on the credit card data entered through various sources.
  • Designing the mappings in Informatica Power center to load the daily edit check results to the summary and detail tables.
  • Creating the workflows and sessions and implementing decision tasks to load data to edit check results.
  • Creating the Batch Jobs through parameter files.
  • Unit testing of the logic and writing SQL scripts to validate the data.
  • Documentation of the ETL architecture.

Environment: Informatica Power Center 9.5.1. Informatica IDQ, Oracle 11g.

Confidential, Sturtevant, US

Role: Senior Informatica / SAP BO Developer, Data Modeler.

Project Description:

The project involves in supporting the organization’s data warehouse and to capture all the real-time transactions. Order and Purchase data from multiple retailers such as Walmart in different formats like Flat files, XMLs, relational databases with be extracted and loaded to relational tables which are available for end user’s reporting. The data issues will raised by the users and all the requests are tracked by remedy tool. We also support the reporting issues which helps in analyzing their business.

Responsibilities:

  • Interacted with Business Analysts to get the functional requirements.
  • Interacted with end users and find out the reporting needs.
  • Created logical, physical and dimensional data models( data warehouse data modelling).
  • Generated reports from data model and reviewed the data model with functional and technical team.
  • Supported daily real time ETL jobs which run to load Data Capture from JDE tables.
  • Fixing the ETL issues and data issues raised by the users.
  • Performed code changes to include new product lines in all the modules of the project with respect to the database and ETL changes.
  • Fixed the issues with Business objects WebI and DeskI reports raised by the users.
  • Involved in the upgrade of Business Objects version from 5.1/6.5 to SAP BO 3.1 and providing user training on the new version.

Environment: Informatica Power Center 9.1. Erwin, Business Objects 5.1, 6.5, SAP BO 3.1, SQL Server 2005, Oracle 10g.

Confidential, US

Role: Senior SAP BO Developer

Project Description:

The project involves mainly in preventing the fraudulent on repairs and replaces of iPhone and iPads on particular depots and service providers before they actually take the impaired products based on the whole serial number and product serial number. For achieving it, we developed reports and dashboards which help the customer to do fraudulent check with that area service providers and depots.

Responsibilities:

  • Analyzing the functional requirements for developing the reports and impact of the change on other reports.
  • Documentation of the functional requirements.
  • Modifying the existing universe according to the new requirements and performing the Integrity checks.
  • Implemented Contexts, Aggregate aware in the universes to increase the performance.
  • Created new Standard, static reports within the WebI Business Objects Tool.
  • Created customized reports with Crosstab Reports and graphical representation of Line and Bar Charts as per end user requirement.
  • Used Hyperlinks, Alerts, Filters, Breaks, Sorts, Ranks and Conditional Formatting in the reports as per the requirement.
  • Performed Unit Testing at report level, based on the Business Requirement documents.
  • Designed Report templates for standard model reports.
  • Designed and created new dashboards and published those using Xcelsius and Tableau.

Environment: SAP Business Objects 3.1, Xcelsius, Tableau, Teradata 13.

Confidential

Role: Senior SAP BO Developer

Project Description:

Confidential is one of the world's largest utilities, focused on delivering energy safely, efficiently, reliably and responsibly. Confidential (LSE: NG; NYSE:NGG) is an international electricity and gas company and one of the largest investor-owned energy companies in the world. Confidential plays a vital role in providing energy to millions of customers across Great Britain and the Northeast US in an efficient, reliable and safe manner.

The project involves in creating Universes on top of BEx Queries and developing complex reports based on these universes.

Responsibilities:

  • Developed the universe based on the underlying BEx Query.
  • Designed the reports in BI Launch Pad based on the universe developed.
  • Customized reports with Crosstab Reports and graphical representation of Line and Bar Charts as per end user requirement.
  • Used Hyperlinks, Alerts, Filters, Breaks, Sorts, Ranks and Conditional Formatting in the reports as per the requirement.
  • Performed Unit Testing at report level, based on the Business Requirement documents.
  • Involved in documenting the changes to the universe and reports functionality.
  • Designed Report templates for standard model reports.
  • Responsible for reviews and preparing review check lists.

Environment: SAP Business Objects 4.0, SAP BW BEX Queries.

Confidential

Role: Senior SAP BO Developer

Project Description:

Confidential is one of the leading oil and Gas Companies in US/ UK. The objective of this project is to provide enhanced reporting for the CMS (Compliance Management System) application, increasing the effectiveness of those who need to report on managing compliance. The principle function of the reporting module was to provide both standard reporting capabilities without impacting the production database. Also, users would be able to create and run their own ad-hoc reports by selecting the “data elements”, or “objects” from within the Business Objects universe, as well as applying their own desired filters, using those same objects.

Responsibilities:

  • Provided primary support for all the requests raised by users with respect to standard and adhoc reports.
  • Handled and solved multiple service and incident tickets on data issues and tool issues raised by users.
  • Analyzed new report requirements from the business and prepared design documents for the new enhancements.
  • Modified existing universe according to the new requirements and performing the Integrity checks.
  • Implemented Contexts, Aggregate aware in the universes to increase the performance.
  • Created customized reports with Crosstab Reports and graphical representation of Line and Bar Charts as per end user requirement.
  • Used Hyperlinks, Alerts, Filters, Breaks, Sorts, Ranks and Conditional Formatting in the reports as per the requirement.
  • Defined User Accounts, groups & set up administrator privileges.
  • Migrated Objects from development to test and production environments using tools like publishing wizard & Import wizard for migration of reports, universes with BIAR files.
  • Extensively worked on creating multiple data providers for building reports.
  • Tuned SQL & universes for trouble shooting of reports for data accuracy.
  • Designed Report templates for standard reports.
  • Estimated the Efforts for Future enhancement.

Environment: SAP Business Objects XI R2, 3.1, Microsoft SQL Server 2005/2008

Confidential

Role: ETL Developer

Project Description:

Confidential was founded on 1st May 2005, and is an integral part of the restructured gas distribution market in Britain. By delivering transportation transactional services on behalf of all the major gas Network transportation companies, Confidential provides one consistent service point for the gas Shipper companies. It also Facilitates and manages change for key industry stakeholders. The initial role of Confidential is to continue to provide essential services and systems on a common basis to network gas transporters. These services include the key roles of transportation invoice production, supply point administration services, data processing and, in relation to the NTS, managing the financial consequences of energy imbalances.

Responsibilities:

  • Design and Development.
  • Developing Interfaces, Packages, Scenarios and Variables to run the mappings.
  • Unit Testing, Comparison of Test Results and Preparation of Unit Test Reports.
  • Preparing SQL queries for development team.

Environment: Oracle Data Integrator, Oracle 11g.

Confidential, US

Role: ETL Developer

Project Description:

Selective is the 54th largest property and casualty (P&C) company in the U.S. The main objective of the project is to maintain the Data warehouse that was developed, which includes enhancements and development of new applications to enrich and keep in sync with the features of the Data warehouse, Data marts and reports with respect to its source systems. The main objective of this module is to extract the data from 9 source systems and the load data to the target tables of Data warehouse. Using ETL Process, it is ensured that the data is extracted from XML files and loaded them into the warehouse and then it is integrated as per the Business Data Model which could generate the Single Policy View. Basically it is a maintenance project of an Insurance company named Confidential (US) where we do Analysis, Design, Coding, Testing and also support for the production. So we will be providing end to end solutions and support.

Responsibilities:

  • Developing Informatica mappings, sessions, workflows and batches to run the mappings.
  • Review of Analysis and Technical Specification Document and mappings.
  • Design and Development of Interfaces using Power center.
  • Responsible for preparing Quality Documents.
  • Unit Testing, Comparison of Test Results and Preparation of Unit Test Reports.
  • Providing Support for production schedules.
  • Designing of One Shot files which are used to fix the production data using Sql Queries.
  • Production migration and providing stabilization production support.
  • Performance tunning in developing Informatica mappings, sessions.

Environment: Informatica 8.6.1, Microsoft SQL Server 2005.

Hire Now