SUMMARY:

• 10 + years using Oracle and 1 plus years of Teradata. Used Oracle Tools (Like TOAD, SQL Developer, SQL Navigator), Teradata Studio
• 1+ years using Microsoft SQL Server 2005
• 7+ years with ETL Development and Design using Informatica’s PowerCenter ETL tools.
• Experience with Informatica Power Center v9..5
• Very solid understanding of Enterprise Data Warehouse Architecture, Data Modeling, ETL design specifications and mappings. (Velocity, Inman and Kimball)
• Very strong understanding of ANSI SQL, Table Joins, RDBMS architecture, Query tuning
• Very strong knowledge of Data Modeling, Normalization, Dimensional Modeling, Star schema, Fact and Dimensions
• Excellent communication and facing skills with the business units, and IT groups in interactive design sessions to design the solution.
• Comfortable and confident to do white board sessions with business units and IT groups.
• Self - motivated and self-directed and require minimal supervision.
• Strong SQL skills and Data Analysis
• Excellent working habits, Project/Task Oriented/Deadline do what it takes to get the job done and meet timelines.
• Informatica Certified Developer - Power Center, Administration
• Microsoft Certified IT Professional - Business Intelligence and Data Base Administrator
• IBM Certified Solution Expert - Cognos Business Intelligence

TECHNICAL SKILLS:

• Software:
• ETL INFORMATICA v9.5 Power Center
• Repository Manager
• INFORMATICA Data Profiling (IDE)
• INFORMATICA Data Quality (IDQ)
• SAS
• SSRS
• SSIS
• SAP BW/BI 3.5
• TOAD 10.6
• SLQ DEVELOPER
• UC4 b Teradata Studio
• WORD
• EXCEL
• CRYSTAL REPORT
• BUSINESS OBJECT
• IBM CLEAR CASE AND CLEAR QUEST
• HP QUALITY CENTER 10.0 (MQC)
• ERSTUDIO
• ERWIN
• Languages
• SQL
• PL/SQL
• SQL-PLUS
• T-SQL
• SQR
• MICROFOCUS COBOL
• POWERBUILDER
• COBOl
• RPG
• CICS
• Databases
• Oracle (11G)
• Teradata
• DB2
• Sybass
• MS SQL Server 2005-2008
• MS Access
• IDMS
• IMS
• VSA
• Operating System
• Windows 7
• XP
• Windows 2000
• IBM AIX (RISC 6000)
• UNIX

PROFESSIONAL EXPERIENCE:

Production Support Team Member

Responsibilities:

• Provide production support for applications in Informatica, Teradata, Oracle, SQL Server.
• Going thru bank training, Knowledge Transfers, Application Access Request
• Downloading software like current version of Informatica, Teradata Studio, Toad for SQL Server, Unix

Confidential

Data Analyst /Informatica Power Center Developer

Responsibilities:

• Assist populating an integrated data warehouse with PPDM format (as needed), including data discovery in existing databases and applications, QA/QC, validation, and gap analysis. This will involve preparing data sets for IT to load into the data warehouse (MDW).
• Data support as needed for iOF workflow development. Mainly Informatica ETL Development and Teradata Table
• Creations, Object deployment from Dev to Test to Production
• Communicate with the business customers for needs and trusted sources/validation of potential MDW data feeds.
• Capacity requirements- 100% for the development phase of through to end Q4 2015. Post development would require 50% CI support.
• Assist in development of data mapping documents between source and target systems.
• Create official well list and facility list for ConocoPhillips owned, operated, and/or partnered wells, identifying best data source for each asset. Work with IT analysts and other MCBU teams to identify data sources for header data fields to be loaded into MDW, and assist in QA/QC efforts. Also assist in creating a facilities and equipment inventory, with an evergreen maintenance process.
• Create the official production values for each well/facility, identifying the best source of data for each type of data (hourly, daily, monthly, fluid type).
• Work with the Operated by Others team and IT to incorporate existing versions of competitor databases into MDW, via a sustainable process for maintenance and addition of other source data.
• Work with A&OI, L48 GSS, and iOF to create and assist in populating data tables required for dTools and risk assessments. Work with projects and facilities groups to create a work process to keep the database evergreen.
• Work with IT analysts and other relevant BU personnel to identify trusted sources for other data feeds to the MDW and to assist in preparation for future data needs, including chemical treatment databases and PACO.
• Provide data gathering and analysis support for workflow development.
• Provide a formal guidance document referencing data input requirements and architecture for sorting and analysis within multiple layers of information.

Confidential

Data Analyst /Informatica Power Center Developer

Responsibilities:

• Responsible in enterprise-level business intelligence and data warehousing including the architecture, design and deployment of scalable and highly available solutions in the Data W arehouse environment r elational / dimensional data models, schemas in the ERD.
• Gather Business Drivers / Requirements for the Enterprise Data Warehouse and translation into technical solutions.
• Develop and maintain Extract Transform Load(ETL) jobs for the Enterprise Data
• Responsible for maintenance of PL/SQL and Oracle databases (11g )troubleshooting and performance tuning skills.
• Responsible for maintenance and development of Oracle ERP Applications and underlying database tables.
• Collaborate with business owners to successfully implement and maintain an enterprise level business analytics and data warehousing solution
• Develop front-end, metadata and ETL specification to support business requirements for reporting across the organization
• Manage and ensure project delivery
• Responsible for the application maintenance of both Production and Non-Production environments
• Troubleshoot Production issues, identifying root causes and planning remediation.
• Develop reporting standards and best practices to ensure data standardization and consistency
• Perform data cleansing and data auditing as necessary to ensure data quality
• Define and develop physical and logical data models to support departmental and functional reporting needs
• Create, maintain, and manage documentation for all data warehouse and reporting development efforts. Help to create and implement a long term storage and business continuity strategy including backup & recovery and data storage and archiving.
• Follows instructions and performs other duties as may be assigned by supervisor.
• Assists other employees in accomplishing Huntsman Confidential goals.
• Participates in and completes Confidential -required training programs.
• Participates in Environmental, Health and Safety initiatives as set forth by the
• Work with business managers across the organization to define, plan and develop further BI / reporting capabilities .
• Develop and maintain a long-term roadmap for solutions
• Design, manage and implement major upgrades and expansions.
• Ability to work effectively on multiple priorities.
• Excellent team-player with superior interpersonal skills who can work closely with both technical development teams and business users.

Confidential

BI Test Lead

Responsibilities:

• Coordinates all aspects of test planning, scenario definition and execution
• Carries out procedures to ensure that ETL, DW, and BI systems and services meet organization standards and business requirements
• Develops and maintains test plans, test requirements documentation, test cases and test scripts
• Develops and maintains test data sets
• Verifies compliance to commitments contained in the test plans
• Works with project management and development teams to resolve issues
• Communicates concerns, issues and problems with data
• Leads testing and post-production verification efforts
• Executes test scripts and documents and publishes objective test evidence results
• Investigates and resolves test failures
• Utilized a De-Normalize and 3Normal Form(3NF) Oracle 10 database structures
• Utilized ERwin Data Modeling to create test data base
• Followed concepts of Kimball Best Practice of developing Data Warehouse.

Confidential

Data Analyst /Informatica Power Center Developer

Responsibilities:

• Create Logical Data Mapping (LDM) to analyze, define, design and develop Staging and cleansing Oracle Database using FACT and DIMS structure as the database models (i.e. relational and star schema). Create required data conversion process designs. and own data dictionaries
• Create LDM to analyze, define, design and size ORACLE data warehouse as target for ETL and will be used by Supplement Enhance Analytics Reporting System (SEARS).
• Creation and project implementation of logical data mappings and develop database sizing estimates.
• Create LDM’s to define and design different Database tables across Supplement Enhancement Analytics Reporting System (SEARS) with source data coming from Epsilon and Entegrate (SOLARC Right Angle-SRA) a SunGard Software, csv, flat files sources that will be used in ETL.
• Responsible for finding the solution to ETL exception log errors and warnings related to data from source and target ORACLE tables, source qualifier, transformation, and lookup tables from Epsilon and SRA, Pre and Post Mat Lab csv files for MVaR model which is being implemented throughout Confidential IST.
• Work with Data Architect regarding definitions of ORACLE table columns, attributes, primary keys, index, referential and integrity constraints.
• Work with Business Object developer to define the Universe of Oracle fields that will be use to develop different reports as required by SEARS primary users.
• Create data conversion scripts, stored procedures and complex SQL.
• Validate business/functional requirements against data model, scripts, SQL, etc. Create and conduct unit testing. Create a data quality strategy.
• Used Star Schema with multiple Fact and several Dimension.data base structures
• Assist Data Architect in creating data models utilizing ERwin
• Reconcile record counts total loaded to the target table and record counts from the ETL source tables. Work with Business Analyst in defining source and target tables to meet SEARS user data requirements.
• Work with Primary User Analyst regarding Market Risk Price Attributes curve SBU rollup changes in SOLARC and building the SQL to report all the curve mappings assignment changes.
• Responsible for creating test plans and test sets of all Change Request(CR) in preparation for migration using Mercury Quality Center,(MCQ), IBM Clear quest, and Remedy. Also
• Do test validation of all changes done in migration. Assist with data migration plans.
• Provide query optimization across the project. Liaison between Project team and Database Administrators
• Support User Acceptance testing (UAT)

Confidential

Data Analyst /Informatica Power Center Developer

Responsibilities:

• Develop a Normalized.data base structures with PK and FK
• Develop Test data models utilizing ERwin
• Create scripts to create, drop and alter data base tables for the DBA’s
• Help the DBA’s in the Conceptual, Logical and Physical Data Base design of the Integration Data Warehosue,
• Followed concepts of Kimball Best Practice of developing Data Warehouse.
• Create LDM’s to analyze, define, design and size Oracle data warehouse (16 tables) as target for the ETL and use by Data Integration for profiling and cleansing.
• Create LDM’s to analyze, define, design and develop Staging and cleansing Oracle Database using de-normalized structure as the database model
• Create LDM’s to define and design different Database tables across Lawson, csv, flat files sources that will be use in ETL
• Responsible for the ETL of Lawson Item Master database to INFORMATICA for data cleansing efficiency using the Informatica Power Center development tools. (Designer- mappings, transformations, source and target definitions. Workflow Manager - Create mapping sessions, Workflow to organize overall flow of data, workflow objects, schedule and physical database connections, Workflow Monitor - view running sessions, runtime statistics, history of past workflow runs, stop, abort, resume or restart jobs.)
• Profile (IDE) tables on columns that are selected for cleansing, analyzing patterns, frequency and percentage of occurrences. Add referential and source tables that will be use in IDE and IDQ
• Create different mapplets rules that will be use for cleansing (IDQ) utilizing different IDQ functions.
• Create IDQ mappings with mapplets for cleaning selected table columns of data.
• Work with DBA in defining and creating target and source Oracle tables that will be use in ETL, IDE, IDQ
• Coordinate with Business Unit users on setting up Business rules on columns selected for IDE and IDQ.
• Analyze the different Lawson Item Master Tables for data and referential integrities.
• Responsible for defining, designing and creating table that will store cleanse data to be posted back to Lawson Item master production database.
• Help assign task to different team members to focus on Confidential deliverables and expectations.
• Assist in developing documentation of different ETL mappings, data profiling and data quality mapping for Confidential Project.

Confidential, Houston, Texas

Financial Reporting Specialist

Responsibilities:

• Responsible for preparing data, reports, files, data base needed to do Month End and Calendar close. Prepare data mapping and migration from 3rd party tape to Servicing Valuation Model.
• Create data valuation file to 3rd Party for servicing valuations and reporting on Purchase
• Mortgage Servicing Rights (PMSR), Design, test, and automate new reports as required.
• Production maintenance of existing Access databases.
• Prepare monthly updates to Cognos Finance and reconcile data to Financials.
• Export data monthly from AS400 to Access database. Prepare monthly detailed job cost to general ledger reconciliation.
• Monitor Task Schedulers to verify job success. Create and reconcile monthly corporate advance reports.
• Update Risk Assessment Default Analytic Reporting System (RADAR) tables via
• Accounting Load (previous servicer advances, arrearage, Loan
• Servicing Accounting Management System (LSAMS) recoveries, and settlements
• Prepare and analyze the Non-Paid-In-Full Trailing Expenses report
• Prepare quarterly Foreclosure Reserve Analysis
• Design and automate other various reports as required

Confidential, Houston, Texas

Sr. Data Cleansing Analyst

Responsibilities:

• Identify the data quality problems from the AS400 legacy system like duplicate data with wrong city name, state, zip code using the US Post official addresses FTP to staging Oracle data base.
• Provided business analysts and data stewards with sample and reports on data that needs to be cleanse on the AS400 legacy system.
• Address data issues discovered during data analysis like wrong customer type, pickup dates, customers that was never billed because wrong address, wrong trash bins, pick up on bill address rather than physical trash pickup address.
• Set up meetings with Field resources to address data issues, concerns and deadlines to meet the SAP market area implementation.
• Based on business requirements fielded by Field resources and other project team members, develop additional data cleansing reports, queries or modify existing ones in Access.
• Interface with Field resources to resolve cleansing questions, testing reconciliation, quality and progress with data cleansing and issues concerning the project.
• Developed and Unit Test SQL procedures on existing Access Tables and generate reports given to the Field resources cleansing responsibilities.
• Create LDM to analyze, define, design and size Oracle data warehouse(26 tables) as target for the ETL and use by SAP for conversion mapping
• Create LDM to define and design Oracle Staging tables using de-normalized structure as the database model for SAP conversion and reports to be fielded to the different Market Directors for data cleansing
• Create LDM to define and design Database, csv, flat files as sources that will be use in ETL
• Developed and populate Access data base tables ODBC from Staging Oracle tables use in data cleansing for all Market and National Accounts Area.
• Convert all Access databases SQL to INFORMATICA for data cleansing efficiency using the Informatica Power Center development tools. (Designer- mappings, transformations, source and target definitions. Workflow Manager - Create mapping sessions, Workflow to organize overall flow of data, workflow objects, schedule and physical database connections, Workflow Monitor - view running sessions, runtime statistics, history of past workflow runs, stop, abort, resume or restart jobs.)
• Assist current data cleansing resources in writing reports, run queries used to cleanse all Market Areas and National Accounts.
• Develop, support and maintains current daily production Workflows assigned to data cleansing.
• Develops and maintain source and target Oracle table definitions in designing new Informatica maps.
• Provide directions and answers to the Business Unit concerns regarding data cleansing.
• Created progress summary report submitted to Data Cleansing manager regarding market area cleansing
• Provided Oracle table indexing to DBA needed to execute efficient SQL queries.
• Created an Excel spreadsheet to data map data cleansing Oracle table columns to the corresponding table columns in SAP.
• Attending meetings with SAP data mapping group to address new changes, requirements and progress on SAP development.

Confidential, Plano, Texas

Data Analyst/ETL Developer

Responsibilities:

• Map and consolidate multiple Oracle data schema to i2 Performance Manager Oracle instance. Analyze Oracle database schema as well as other Oracle Datamarts using SQL, PL/SQL, and database analysis tools.
• Responsible for design analysis, problem evaluation and evaluation of requirements, user business problems, systems flow, development and implementation of system recommendations to meet business and user requirements.
• Developed and Unit Test PL/SQL procedures extract programs from different Oracle Datamarts and i2 Performance Manager as a database source to be FTP’ed to the Mainframe for Focus Reporting programs.
• Informatica Power Center development tools. (Designer- mappings, transformations, source and target definitions. Workflow Manager - Create mapping sessions, Workflow to organize overall flow of data, workflow objects, schedule and physical database connections, Workflow Monitor - view running sessions, runtime statistics, history of past workflow runs, stop, abort, resume or restart jobs.)
• Develop integration job flow scripts and test cases. Review test results with Business Analyst and System Architect.
• Work with Business Analyst to resolve analysis questions or testing reconciliation.

Environment: Informatica 7.1 Power Center, i2 PEFORMANCE MANAGER, Oracle DATAMARTS, WORD, EXCEL, ACCESS, SQL, PL/SQL, Oracle, TOAD, Telnet, Exceed, Focus, and WINDOWS XP

Confidential

Computer Consultant

Responsibilities:

• Map multiple source data schema to Oracle schema. Consolidate data from Access database and other source databases into Oracle database. Analyze Access and Oracle database schema as well as other data sources using SQL and database analysis tools.
• Identify data duplication and errors by setting up referential constraints, primary and secondary keys on different data base tables.
• Performed production support function to identify and resolve client problems with regards to the different system applications.
• Developed PL/SQL procedures for data base update, query and reporting.
• Utilized back-office software to perform system analysis and made recommendations to streamline business operations and improve productivity among the users.

Confidential: Confidential

Sr. It Analyst P

Responsibilities:

• Performed production support function to identify and resolve daily billing data problems.
• Maintained PL/SQL procedures that runs daily, weekly and monthly scheduled in production.
• Utilized back-office software to manage Lodestar Billing Engine data, as well as Energy Commander System, an in-house web application that provides access to end-use customer's usage and demand interval data.
• Developed PL/SQL procedures for daily updates, data inquiry, reporting, data cleansing and administration.
• Have used Toad to execute PL/SQL procedures and SQL statements to look at Oracle data base for data corrections and table queries.

Environment: Oracle, PL/SQL, Lodestar, Store Procedures, Triggers, SQL Packages, Views, Toad, SQL/Plus, WINDOWS XP.

Confidential

Senior IT Analyst

Responsibilities:

• Developed Oracle, SQL Server 2000, and DB2 relational data base design used as a back end for a different WEB Application.
• Define, design, size and develop Oracle Marketing Information System (MIS) data warehouse (45 tables) to combine both residential and small business customers. This data warehouse is use as datamarts for other business unit and backend for intranet and internet web sites.
• Define, design and develop Marketing Information System (MIS) as a normalized Database model use as data repository
• Developed PL/SQL store procedures, triggers for data base updates, and views for query, and reports.
• Have used AIX to execute PL/SQL procedures and other table queries against Oracle data base exposed with database development support for interfaces to external sources using XML.
• Developed, implemented, documented, and maintained batch update programs for enterprise-size database applications.
• Identify the data quality problems from the Mainframe legacy system like data with misspelled, city name, state, zip code using the US Post official addresses on both CIS residential and BES small business customers.
• Provided mainframe application developers and Business units data owners with reports and sample data using MS Access database that needs to be cleanse on both CIS residential and BES small business customers.
• Address data issues discovered during data analysis like wrong move in and move out dates, credit ratings, deposit requirement flag, meter reading flag and meter type.
• Develop Excel spreadsheet to show progress summary of data cleansing development and set up meetings with CIS and BES customer data to discuss cleansing status, issues, concerns and schedule
• Analyze and help develop Oracle tables that will combine both legacy data in an oracle data warehouse.
• Maintain integrity, accuracy and access of customer’s data used in different Confidential intranet and internet web sites like 15 minutes interval, low and high peak usage, load profile, and rate code by validating and comparing data from Oracle data base against the legacy data.
• Assist Data Architect in creating data models utilizing ERwin

Environment: Microsoft Products (WORD, EXCEL, ACCESS), SQL/Plus, PowerBuilder, TOAD, Quest Reporter, Oracle, PL\SQL, Store Procedures, Triggers, Views, SQL Packages, Micro Focus COBOL, SQR, COBOL, AIX, WINDOWS 2000.

Confidential

Risk Management Data Analyst

Responsibilities:

• Work with Market trend and forecast Gas futures and contracts using Risk management tools develop in house by Chevron.
• Assist in developing a graph showing cost curve to the relationship between the cost of gas contract when gas production volume output is low and when level of production rises.
• Involves in extracting history data to support when to do a call option or put option at a specific amount on strike price during a specified period of time mainly on gas futures contract.
• Work in developing supporting information needed to be in Gas Futures Contract that Risk Management Group use as one of the tools to enhance Confidential revenues.
• Also involve in developing data chart, trends to formulate risk on hedge funds long and short positions on oil, gas futures contract investments using a variety of methods, notably short selling and derivatives.
• Performed development, maintenance and enhancement for Gaslink I & II, and TCI (HOTTAP), to provide ability for pipeline customers to nominate, trade, and schedule gas. Also worked on NSA that does allocation, contracts, and accounting.

Environment: Oracle 7.0, SQR, EASEL/2, SQLPLUS, OS/2, MSMail, MS-SCHEDULER, IBM TOKEN RINGS, TCP/IP, QUICK-C, MS-DOS, WORD,EXCEL, ACCESS, DOS-EDITOR, PL\SQL Procedures, POWERBUILDER, BLUEPRINT, SYBASE, UNIX, SQR, WINDOWS, SNAGIT, CCMAIL, BUSINESS OBJECTS TRAINING Project: Hotel Reservation, Credential Profile System, And Shipping Lines

Confidential

Reservation Data Analyst

Responsibilities:

• ANSWER* NET, a Hotel Reservation System designed for Sales and Marketing organizations of Hilton Hotels Corporation, ADS/O and MultiSoft, (a PC-base System) that provides online mapping, linking mainframe to a PC.
• Performed development and enhancement for Credential Profile System (CPS), to maintain information on all companies that have corporate accounts with Budget Rent A Car (BRAC). Also involved in conversion of CPS from IDMS Applications to DB2 interface with CONFIRM RES, an Airline Reservation System.
• Also developed DB2 program For Hilton Hotels Rate Memo utilizing IMS and MFS.

Environment: IDMS/ADSO/DC, Batch/DC, VSAM, DB2, SQL, TSO/ISPF, QMF, CMAIL, SUPER-CALC Enhancing and supporting

Confidential

Gas Nomination Analyst

Responsibilities:

• Analyzed, design tested, implemented, and documented systems development applicable to different Gas and Pipeline applications.
• Converted Gas Reserves System from Honeywell to IBM.
• Production and Systems Support of different Gas and Pipeline applications.

Environment: IDMS/ADSO, ADSG, OLM, DMLO, IDD, OLQ, Culprit, Batch TSO/ISPF, PROFS, MULTI SESSION, DB2 and COBOL.