Data Analyst

Krzysztof KolusData Analyst

Phone: 908-***-****

: abop7y@r.postjobfree.com

Resumes ID: 49137

Location:,

Posted: 05.02.2012

Resume Details:

Krzysztof Kolus

Ph: 908-***-****

Mail:abop7y@r.postjobfree.com

Summary:

Five plus years of professional experience in data modeling and data analysis as a Proficient in gathering business requirements and handling requirements management.

Experienced in designing the Conceptual, Logical and Physical data modeling using ERwin and ER Studio Data modeling tools.

Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.

Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.

Good in Normalization / Demoralization techniques for effective and optimum performance in OLTP and OLAP environments.

Having good experience with Normalization (1NF, 2NF and 3NF) and Denormalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.

Well-versed in designing Star and Snowflake Database schemas pertaining to relational and dimensional data modeling.

Experienced in designing the data mart and creation of cubes.

Highly skilled in, designing the Mappings & Mapplets, configuring the Worklets, Connections and Scheduling the Workflows with Worklets and Sessions.

Worked on various transformations like Joiner, Expression, Lookup, Aggregate, Filter, Router, Update Strategy, Sequence Generator, Source Qualifier, Stored Procedure, etc.

Designed and developed ETL Mapping to load data from Sources like Oracle, SQL Server, Flat Files, XML Files to Targets like Oracle, SQL Server, XML Files.

A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Informatica.

Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.

Having experience in writing complex SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests. Also good in developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL.

Efficient in analyzing and documenting business and functional requirements along with Use Case Modeling and UML.

Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures.

Experienced in working with DDL/DML environment.

Having a good experience in working EDW/MDM environment.

Experienced in working with the DataStage Environment.

Well versed in conducting Gap analysis, Joint Application Design (JAD) session, User Acceptance Testing (UAT), Cost benefit analysis and ROI analysis.

A good familiarity and experience in the work environment consisting of Business analysts, Production/Support teams, Subject Matter Experts, Database Administrators and Database developers.

Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently

Education

BA in Economics

Technical Skills

Data Modeling : ERwin7.2, Logical Modeling, Physical Modeling, Dimensional

Modeling (Star Schema, Snow-Flake), ER Diagrams (Entities,

Attributes, Cardinality)

Languages : UNIX Shell Scripting, SQL, PL/SQL, XHTML, JavaScript, CSS

VB

Data Warehousing : Informatica Power Center 8.x/7.x

Databases : Oracle 11g/10g/9i, MS SQL Server, PL/SQL, MS Access

Professional Experience

SunTrust Bank, Atlanta, GAFeb 2011- Present

Data Analyst/Modeler

SunTrust Banks, Inc., with total assets of $170.7 billion on June 30, 2010, is one of the nation’s largest and strongest financial services holding companies. The bank needs to build data warehouses and the purpose of the implementation is to understand the trends, performance, customer analysis, to market additional products of the Bank, planning, budgeting and forecast the staffing needs and performance of the call center employees. Subject areas covered in the warehouse are Individual, Residential household groups accounts (Saving, Checking, Credit), Loan based accounts (House, Business, Individual and Personal) Insurance based accounts (House and Car), Deposit accounts and Call center data.

Roles and Responsibilities:

Conducting the meetings with business users to gather data warehouse requirements

Involved in Data Collection from different systems.

Conducted team meetings and Joint Application Design (JAD) session

Gathered requirements and created use case diagrams as part of requirements analysis.

Developed a Conceptual model using Erwin based on requirements analysis.

Developed normalized Logical and Physical database models to design OLTP system for education finance applications.

Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r8.0.

Modeled a database to store customer demographic and other data.

Produced functional decomposition diagrams and defined logical data model.

Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.

Implemented Referential Integrity using primary key and foreign key relationships.

Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.

Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems

Translated business concepts into XML vocabularies by designing XML Schemas with UML.

Exhaustively collected business and technical Metadata and maintained naming standards

Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.

Created physical data models using forward engineering

Identified the Facts and Dimensions.

Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.

Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.

Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Involved in Data Mapping.

Involved in Enterprise data warehousing (EDW) and Master data management (MDM).

Hands on experience in working with DDL/DML environment.

Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.

Participated in performance management and tuning for stored procedures, tables and database servers

Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)

Responsible in integrated the work tasks with relevant teams for smooth transition from testing to implementation phase.

Environment: Erwin r8.0, SQL Server 2000/2005, Informatica Power Center 8.6, Rational Rose, Windows XP, Oracle 11g/10g, Windows XP/NT/2000, IBM DB2, Teradata V2R12

ABN AMRO (N.A), Chicago, ILOct 2009 – Jan 2011

Data Modeler/Analyst

ABN AMRO Bank identifies a set of defaulting customers on pre-defined rules and generates data regarding them. In this system we collect data regarding them, calculate the present outstanding balance, the cost incurred by the bank till date on various fronts for each customer and help the higher management to take business decisions to partially or fully exempt the defaulter from repaying the amount with the help of summarized data. The data comes from Flat Files and is loaded into the Oracle 9i Data Warehouse.

Roles and Responsibilities:

Involved in the requirement definition and analysis support for Data warehouse efforts.

Documented and translated user requirements into system solutions; developed implementation plan and schedule.

Designed dimension and fact tables for Star Schema to develop the Data warehouse.

Extracted the data from SQL Server, Oracle, Files, and Access into Data warehouse.

Created dimensions and facts in physical data model using ERwin tool.

Used Informatica Designer to create complex mappings using different transformations to move data to a Data Warehouse

Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Look up, Aggregator, Stored Procedure, Update Strategy, Joiner, Filter.

Scheduling the sessions to extract, transform and load data into warehouse database on Business requirements.

Loaded the flat files data using Informatica to data warehouse

Created Global Repository, Groups, Users assigned privileges Using Repository manager.

Setting up Batches and sessions to schedule the loads at required frequency using PowerCenter server Manager.

Handled common data warehousing problems like tracking dimension change using SCD type2 mapping.

Used e-mail task for on success and on-failure notification.

Used decision task for running different tasks in the same workflow.

Assisted team member with their various Informatica needs.

Developed and maintained technical documentation regarding the extract, transformation and load process.

Responsible for the development of system test plans, test case creation, monitoring progress of specific testing activities against plan, and successfully completing testing activities within the requisite project timeframes.

Environment: Oracle 10g/9i, SQL Plus, PL/SQL, Informatica Power Center 8.1/8.6, Toad, Windows 2000, Erwin 7.2.

AAA Insurance, Livonia, MIJan 2009 – Oct 2009

Data Modeler/Data Analyst

AAA Insurance is one of the largest insurance and financial services companies in the world. They offer a full range of products and services for Life Insurance, mortgages, auto loans, student loans and banking services. They specialize in originating residential mortgage loans through retail, wholesale and telemarketing channels. They are a full-service mortgage company that originates, acquires, markets and services those loans. The task was to develop a relational database system for improving marketing strategies and report generation. The data models developed were analyzed and value added.

Roles and Responsibilities:

Involved in design and development of data warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.

Worked on Informatica Power Center tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Mapplets and Reusable Transformations.

Designed Mappings using Informatica Designer, which populated the Data into the Target Star Schema on Oracle Instance.

Extensively used Normalizer (for COBOL source files from S-390 Mainframe system), Router, Lookup, Aggregator, Expression and Update Strategy Transformations.

Involved in the migration from Informatica 6.2 to Informatica 7.1.2

Setup the data mart on Oracle database by running the SQL scripts from ERWIN designer.

Translation of Business processes into Informatica mappings for building Data marts.

Involved in the Migration process from Development, Test and Production Environments.

Report generation using Microsoft Excel spreadsheet.

Wrote stored procedures and triggers in Oracle for managing consistency and referential integrity across data mart.

Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.

Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.

Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.

Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Environment: Erwin, Informatica Power Center 8.5, Cognos, MS SQL Server, Oracle 8i, SQL, PL/SQL, TOAD, Shell Scripts

Amica Mutual Insurance, Lincoln RIJan 2008 – Jan 2009

Data Modeler/ETL Developer

Amica Mutual Insurance Company is an American mutual insurance company which sells automobile, homeowners, marine and personal umbrella liability insurance, founded in 1907. It currently employs 3,234 people in 40 offices across the United States, and is headquartered in Lincoln, Rhode Island. Amica is one of the few remaining large-scale mutual insurance firms that consistently rank highly in JD Power and other consumer satisfaction rankings. Amica was organized as a mutual company, meaning that the company is owned by policyholders rather than stockholders

Roles and Responsibilities:

Worked with business analyst to gather information on requirements.

Documented Technical & Business User Requirements during requirements gathering sessions.

Analyzed conceptual into logical data and had JAD sessions and also communicated data related issues and standards.

Involved in modeling business processes through UML diagrams.

Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.

Conducted model walkthroughs and validation sessions.

Worked alongside the database team to generate the best Physical Model from the Logical Model using Erwin.

Developed Cleansing and data migration rules for the Integration Architecture (OLTP, ODS, DW).

Developed data mapping documents between Legacy, Production, and User Interface Systems.

Environment: Erwin, Data Maker, Model Manager, SQL-Server, Teradata, Oracle, SSIS, Informatica Power Center7.1/8.1, Cognos, Windows XP, Sun Solaris, UNIX

Coastland Federal Credit Union, Houston, TXAug 2006– Dec 2007

ETL Developer/Data Analyst

Coastland Federal Credit Union is a not-for-profit financial institution that provides with excellent, personalized service. Unlike a bank, there are no stockholders, so any profit earned by Coastland FCU is returned to the members in the form of higher dividends paid on their accounts, lower interest rates, and enhanced services.

Founded in 1959, Coastland has grown to 5 branches in Louisiana and Texas. With over 8700 members and $100 million in assets, Coastland FCU stands ready to meet the needs of with unparalleled member services and personal attention. All deposits are federally insured by the National Credit Union Share Insurance Fund, which is regulated by the National Credit Union Administration.

Roles and Responsibilities:

Responsible for Business and Data Analysis with Requirement Gathering and Documentation.

Participated in building Data Warehouse which includes the Design of Data mart using Star Schema

Created Dimension Tables and Fact Tables based on the warehouse design

Prepared the mapping documents between two merging systems

Conducted review meetings with development, QA and data team to discuss business requirements.

Participated in System Test reviews, development design reviews and usability studies.

Performance testing and tuning, capacity planning, and database monitoring.

Develop full testing scope consisting data migration from legacy systems, loading, interfaces and application function areas

Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.

Experience in working with ERWIN for generating logical and physical models.

Extensively worked on creating schemas in Oracle and MS Access

Coordinated with System Analyst and Project Manager to setup the pre-validation and Validation environment to execute the scripts.

Performed testing on a data warehouse platform, including data integrity and data validation.

Used Agile methodology throughout SDLC, including planning and cost estimation through requirements, translating into data design and providing oversight in development and execution.

Integrated various sources in to the Staging area in Data warehouse to Integrating and Cleansing data.

Tuned SQL applications and added Indices as required for performance and involved in testing through test scripts and test plans.

Performed Unit testing and UAT testing for various reports created from the data marts.

Assisted & Collaborated in generation of a complete set of reports using Business Objects to target different user segments.

Discuss the issues and projects status in status call on weekly basis.

Environment: Informatica Power Center 7.0, Workflow Manager, Informatica Power Connect, Rational Rose, Visio, Workflow Monitor, ERWIN, Windows 2000, Oracle 9i, XML, DB2, Toad, UNIX, SQL LOADER, Microsoft Excel.

Contact this candidate