Livecareer-Resume
Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA 94105
:
Professional Profile
Nearly 7 years of IT experience with 5 years of professional work experience in Data Warehouse/Data Mart design, System analysis, design, development, Database design, SQL, PL/SQL programming. *Extensive experience on Informatica PowerCenter 7.x/6.x/5.x with strong business understanding in power utility and insurance sectors. *Expertise in implementing complex Business rules by creating robust mappings, mapplets, and reusable transformations using Informatica Power Center and Power Mart. *Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets. *Experience in using the Informatica command line utility to schedule and control sessions and batches. *Extensive Knowledge in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center. *Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance *Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance *Worked on integrating data from heterogeneous sources like Oracle, flat files, DB2, COBOL and XML files. *Experience with pre-session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes. *Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions. *Knowledge of full life cycle development for building a Data Warehouse.
Qualifications
  • ETL Tools Informatica (Power Center 8.X/ 7.1.2/6.2/5.1), Data stage
  • Operating Systems Windows 2000/NT/98/95, Sun Solaris 2.x, HP-Unix, Red Hat Linux 7.2/7.3
  • RDBMS Oracle7/ 8i/9i /10g(SQL, PL/SQL, Stored Procedures, Functions), MS-Access 2002/2003, Teradata V2R4.1/V2R5, SQL Server 2000/7, DB2
  • Data Base Tools Toad, SQL Navigator 4.0, SQL Loader
  • Data Modeling Erwin
  • Reporting tools Business objects, Cognos, Cognos Report net, Crystal Reports, Tableau and SAP Business Objects
  • Languages PL/SQL
Education
San Francisco State University San Francisco, CA Expected in 2013 Bachelor of Arts : Business Administration - GPA :
Relevant Experience
Experience
Salient Crgt - ETL Developer
Lawrence, MA, 07/2017 - Current
  • Currently working on an HR project to capture the HR events related to members of the workforce.
  • The project is in the last phase of testing.
  • The project started off with hard coding and later the ETL process was performed by Informatica Power Center 6.2/7.X.
  • Analyzed the data from various sources such as Peoplesoft, AVR, etc..
  • to maintain consistency and performed validation.
  • Identified the facts and dimensions and designed the relevant dim and fact tables.
  • Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
  • Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
  • Created Complex Mappings which involved Slowly Changing Dimensions to implement Business Logic and capturing the deleted records in the source systems.
  • Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
  • Created PL/SQL packages and stored procedures to load data from various sources to staging area.
  • Worked with SQL.
  • Loader to load the data into the warehouse and flat files.
  • Created dynamic PL/SQL procedures to load data from staging area to the data marts.
  • Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
  • Monitored Workflows and Sessions using Workflow Monitor.
  • Performed Unit testing, Integration testing and System testing of Informatica mappings.
  • Worked with SQL.
  • Loader to load the data into the warehouse and flat files respectively.
  • Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
  • Precise Documentation was done for all mappings and workflows.
  • Used Debugger in troubleshooting the existing mappings.
  • Environment: Windows 2000, Oracle 10g/9i, SQL.
  • Loader, Informatica Power Center 8.X.
Abt Associates - ETL Developer
Fort Myers, FL, 12/2017 - 07/2017
  • Worked on an energy utility project to implement ETL solution using Informatica for maintaining the consumer's data.
  • Involved in identification of facts, measures, dimensions and hierarchies for OLAP models.
  • Analyzed Source System data.
  • Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformation designer.
  • Responsible for developing Source to Target Mappings.
  • Used most of the Transformations such as Source Qualifier, Aggregator, Lookups, Filters, Sequence generator, Expressions, Update Strategy, Router etc.
  • Used pre-defined workflow variables and created persistent workflow variables to reference values and record information in a workflow.
  • Used ETL to load data from Oracle, COBOL files to the Data Warehouse.
  • Worked with SQL.
  • Loader to load the data into the warehouse and flat files.
  • Created reusable Mapplets/transformations embedding business logic.
  • Created Stored Procedures to transform the Data and worked extensively on PL/SQL for various needs of the transformations while loading the data.
  • Configured sessions and batches using Informatica Power Center Work Flow Manager and monitored them in the Work Flow Monitor.
  • Involved in writing UNIX shells scripts and automate the sessions running processes using Crontab.
  • Used pmcmd, pmrep commands in UNIX shell scripts.
  • Performed Unit testing, Integration testing and System testing of Informatica mappings.
  • Tuned mappings, transformations and recommended tuning options of source/target database to DBA team for obtaining optimum performance.
  • Precise Documentation was done for all mappings, workflows.
  • Worked extensively with the major functionality of Business Objects, created the Universes with Default& Custom Hierarchies for multidimensional analysis and created reports with Multi-Level Scope of Analysis using Drill down, drill across, drill up, and slice and dice.
  • Involved in developing reports using Business Objects 5.1.
  • Generated the Business Objects Reports using the universe as the main Data provider and writing the complex queries including Sub queries, Unions, Intersect and Aliases.
  • Created User Objects including Dimensions, Details and Measures.
  • Reports were formatted to the users according to the user requirements using Business Objects features like Slice and Dice, Drill Down, and Formulae Environment: Sun Solaris, Windows 2000, Oracle 8i,COBOL, Informatica Power Center 6.2, Business Objects.
- Oracle/PL/SQL Developer
, , 05/2002 - 06/2006
  • Worked on a trading project for a client to develop an application to trade coal, gas and power.
  • Gathered user requirements and created the business requirements documents.
  • Documented the technical specification for the reports and tested the generated reports.
  • Created and managed Database.
  • Used the technical document to design tables.
  • Generated SQl and PL/SQL scripts to install, create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
  • Created Database triggers to maintain the database security.
  • Created stored procedures and functions to be called by the application.
  • Created Packages to be called by Visual Basic modules.
  • Created trading reports using Crystal Reports.
  • Optimized the SQL queries for improved performance.
  • Used SQL loader to import data from large flat files and Excel sheets to Oracle tables.
  • Prepared test plans for various modules.
  • Prepared user manual and technical support manuals.
  • Entered static data into the application.
  • Environment: Oracle 8i, SQL.
  • Loader, PL/SQL, Crystal Reports 7, Windows NT.
  • B.S.
  • Purchasing &Supplies/Logistics Management.
Abt Associates - ETL Developer
Canton, MI, 02/2001 - 11/2003
  • The organization organizes this consistent data storage for their global level, region level and functional level data analysis.
  • This data was used for creating a baseline for data marts.
  • With this centralized data infrastructure, the client could view its sales information more accurately.
  • Used ETL methodology for complete processing of Data Extraction, transformations and loading steps, in a corporate-wide-ETL Solution using Informatica.
  • Used several transformations like source qualifier, expression, lookup, aggregator, Joiner, sequence generator, router and update strategy transformations for complex mappings.
  • Used Debugger in troubleshooting the existing mappings.
  • Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
  • Developed stored procedures and functions in PL/SQL using TOAD.
  • Tuned Informatica mappings for better performance using different techniques to provide maximum efficiency and complete performance.
  • Developed Shell Scripts to run batch jobs.
  • Developed sessions using Server Manager for loading the data into target database.
  • Monitored Workflows and Sessions using Workflow Monitor.
  • Designed and developed catalogs that reflected business view of the data to enable other developers to design cubes and reports.
  • Modified power cubes and power play reports as per the requirement.
  • Developed several complex reports featuring multiple prompt selections, drill through and sub reports.
  • Precise Documentation was done for all mappings, workflows and reports.
  • Environment: Windows NT, Oracle 8i, DB2, PL/SQL, Informatica Power Center 5.1 Cognos Impromptu6.0, PowerPlay6.5, Transformer 6.5, SQL Server.
Bickford Senior Living -
City, , India 01/1 - 01/1
Affiliations
Skills
automate, Business Objects 5.1, Business Objects, catalogs, COBOL, Cognos Impromptu6.0, Cognos, Crystal Reports 7, Crystal Reports, Client, data analysis, Data Modeling, Data Warehouse, DBA, Data Base, Database, Data stage, Dimensions, Documentation, Erwin, ETL, features, functional, grants, HR, DB2, Informatica, Logic, Logistics Management, MS-Access, Excel, SQL Server 2000, Windows 2000, 98, NT, Windows NT, Navigator 4.0, OLAP, Operating Systems, Oracle7/ 8i, Oracle, Oracle 8i, PL/SQL, Peoplesoft, PowerPlay6.5, processes, coding, Purchasing, RDBMS, Red Hat Linux 7.2, Reporting, requirement, Router, sales, SAP, scripts, Shell Scripts, Sun Solaris, Sun Solaris 2.x, Sorter, specification, SQL, SQL Server, SQL* Loader, SQL*Loader, SQL Loader, Strategy, Tableau, tables, technical support, Teradata, TOAD, Transformer 6.5, troubleshooting, HP-Unix, UNIX shell scripts, UNIX shells, validation, view, Visual Basic, Workflow

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

62Fair

resume Strength

  • Length
  • Personalization
  • Target Job

Resume Overview

School Attended

    Job Titles Held:

    • ETL Developer
    • ETL Developer
    • Oracle/PL/SQL Developer
    • ETL Developer

    Degrees

      By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

      *As seen in: