Resume of ETL Analyst/Developer

Title
ETL Analyst/Developer

Primary Skills
Informatica PowerCenter 8.1/7.1/6.5, ERStudio, Cognos DecisionStream, TOAD, SQL Navigator, SQL Server Enterprise Manager

Location
US-OR-Portland

Posted
Jun-03-08

Professional Summary

• Seven years of IT experience with a strong background in Data warehousing projects development and three years of ETL experience using Informatica ETL Tool.
• Solid hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Good knowledge in RDBMS concepts, data models, Star/Snow Flake Schemas.
• Proficient in data modeling, developing SQL and PL/SQL codes through various procedures/functions as well as UNIX Shell Scripting.
• Experience in defining and discussing detail business requirements and translate them into technical requirements.
• Able to work collaboratively, quickly acquire technical understanding and committed to achieving corporate goals.

Career Objectives:

To work as a team player in challenging projects and deploy best practices/standards of data warehouse technology and processes. To be involved in planning and delivering of application infrastructure to fully exploit the benefits of ETL tool as well as to provide technical solution/consultation to the business and management.

Technical Skills:

DWH Tools: Informatica PowerCenter 8.1/7.1/6.5, ERStudio, Quest DB2 Connect, Cognos DecisionStream, TOAD, SQL Navigator, SQL Server Enterprise Manager
RDBMS: Oracle 10g/9i/8i, MS-SQL Server 2000, DB2, MS Access
Operating Systems: Windows NT/XP/2000, UNIX
Languages: C++, PL/SQL, SQL

Project Experience:

Client: Land O' Lakes, Inc., Shoreview, MN
Duration: July '06 to till date
Environment: Informatica PowerCenter8.1, Oracle 10g, UNIX
Role: ETL Analyst/Developer Consultant

• Work with Business Analyst and users to clarify requirements and translate the requirement into technical specifications.
• Create dimensions/fact tables in data models using ERStudio. Forward engineer objects and Complete compare data models to keep objects in synch with the database. Coordinate with the DBA for migrations of new/updated objects.
• Use Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.
• Use Informatica Designer to create mappings using transformation such as Sorter, Router, Union, Joiner, Filters, Router, Normalizer, Expression and Aggregator to load data. Use Debugger to test and fix bugs in the mappings.
• Create workflows, worklets, email/command sessions and UNIX job scripts for scheduling jobs in AutoSys. Use SQL Navigator to do data validation/analysis.
• Use SQL and PL/SQL stored procedures to implement business logics in Oracle.

Client: Securian Financial Group, St. Paul, MN
Duration: July '05 to July '06
Environment: Informatica PowerCenter 7.1, Windows NT, SQL Server
Role: ETL Analyst/Developer Consultant

• Work closely with Sr. Systems Analysts to identify various databases where the information/data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology.
• Design and translate business requirements into technical design documentations.
• Use Informatica ETL tool to create complex mappings to load the data mart. Use SQL Server Enterprise Manager to validate data.
• Use various transformations like Sorter, Router, Union, Expression, Filter, Joiner, Normalizer, Mapplet, Aggragator, and Dynamic Lookups to transform data.
• Use Stored Procedures to drop/create indexes as well as disable/able constraints before/after loading the tables.

Organization: Thrivent Financials, Minneapolis, MN
Environment: Informatica PowerCenter6.5, SQL Server, DB2, UNIX, SQL
Duration: July '04 to July '05
Role: Data Acquisition Designer

• Work closely with Sr. Data Analysts, DB2 Applications owners to define required attributes and translate business requirements into technical specifications.
• Write mapping specifications (Source to Target) and update Data Dictionary and Metadata Repository with new elements required for development.
• Use Informatica 7.1/6.5 ETL to extract and transform data from various DB2 database to the data warehouse.
• Design and develop Mappings using various transformations such as Aggregator, Router, Mapplet, Normalizer, Filter, Sorter, and Union.
• Create, update and maintain ETL technical documentations and facilitate in migration efforts. Troubleshoot and resolve application issues.
• Work closely with Sr. Systems Analyst to develop standards as well as working with Jr. ETL developers to ensure the development of re-usable objects.

Organization: UnitedHealth Group, Minnetonka, MN
Environment: Oracle 9i, WindowsNT, SQL
Duration: July '03 to July '04
Role: Applications Developer II
• Work closely with various levels of individuals to coordinate and prioritize multiple projects. Estimate, schedule and track ETL projects throughout SDLC.
• Design, document, and translate business requirements into technical specifications.
• Use Cognos DecisionStream7.1 ETL tool to transform and migrate data from various Cognos OLAP and Hyperion Essbase cubes to the data warehouse and back into the cubes.
• Design, develop, and test JobStreams that are using functions, dimensions, measures, attributes, aggregates, merge to transform data.
• Create, update and maintain ETL technical documentations and lead the migration efforts. Troubleshoot and resolve application issues.
• Work as an Administrator for Cognos Analyst/Contributor and provide support for business users requests for cube changes as well as leading the upgrade projects for the module.
• Design job schedule, create job scripts for scheduling jobs in AutoSys.


Client: Heartland Realty Inc., Hinckley, MN
Duration: Oct '01 to July '03
Environment: WindowsNT, DreamWeaverMX, JavaScript, Adobe PhotoShop
Role: Web Developer

The system has a database which stored information about listing of properties in the NorthStar MLS Real Estate Listing Service. The project involves gathering customizable displays, exclusive listings, custom artwork and design to use in implementing the site.

• Design, develop, and test components of website for displaying information relating to Real Estate.
• Update and maintain company website. Troubleshoot and resolve application issues.

Organization: Digital River, Inc., Eden Prairie, MN
Technology: Oracle 8i, PL/SQL, SQL, UNIX, HTML, JavaScript
Duration: Oct '99 to Oct '01
Role: Software Engineer

• Work with Business Analysts to translate business requirements into technical specifications for new enhancements to existing websites.
• Code, test, and implement new enhancement using PL/SQL, SQL*Plus, and JavaScript.
• Maintenance of e-commerce shipping and product data to ensure the accuracy of data being consumed by the web sites.
• Identify, qualify and resolve client issues in a timely manner.

Education:

B.A. degree in Psychology and Computer Science
St. Olaf College, Northfield, MN

Java Web Applications Development Certification
University of Minnesota -- Continuing Education Program

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-OR-Portland »
View all resumes in US-OR »

View other ETL Analyst/Developer resumes, Programmer / Developer resumes