We provide IT Staff Augmentation Services!

Etl/data Warehouse Resume

Buffalo, NY

Seeking a challenging position in a reputable organization where I can utilize my Data Warehouse Quality Assurance, Data Analysis, ETL/BI Development ,Software Development skills and personal capabilities optimally and grow with the organization.

TECHNICAL SKILLS

  • Informatica Power Center 8.6.0, Informatica PowerExchange, Informatica Power Connect, Informatica Data Profiling, PowerCenter data analyzer, Oracle Warehouse Builder 10g, SQL Server Integration Services(SSIS) 2005, Oracle 10g Database, PL/SQL , ,SQL server 2005,Rational Robot, IBM DB2, Informix, Sybase, 2000,Cognos 8/Report Net, Business Objects,
  • Oracle SQL Developer 10g, IBM Tivoli, Toad for Oracle/DB2, Clear Quest Test Manager, QTP SQL*Loader, RMAN, OEM, Server Manager, MS Access 2005. WinSQL, MS Office Suite
  • Microsoft NT/2000/XP/, UNIX, Linux 4, Sun Solaris 8/7
SUMMARY OF QUALIFICATIONS
  • Data Warehousing Project Development
  • Problems Solving and Users Support
  • Data Analysis and Data Migration
  • Business Intelligence Project Development
  • Business and Financial Analysis
  • IT Project Management

OVER 10 YEARS EXPERIENCE IN IT, ETL & DATA WAREHOUSE SOFTWARE IMPLEMENTATIONS, BUSINESS ANALYSIS

WORK EXPERIENCE

ETL/DATA WAREHOUSE:

  • Evaluated existing systems, business processes and user requirements to analyze, design, recommend and implement system changes.
  • Performed Source and Target Definitions in Informatica Power Center 8.6.1 Designer.
  • Designed and developed Informatica Mappings for data load and data cleansing.
  • Extracted transformed data from various sources such as Flat files, MS SQL Server and transferred data to the target data warehouse Oracle 10g Database and Flat files.
  • Using Informatica Power Exchange to extract mainframe files, performed row test and sending to node, checking data map in mainframe to make sure the data map match.
  • Participated in consulting, software installations and configuration, new functionality and reports testing, users training and clients support.

BUSINESS ANALYSIS:

  • Participated in Business Analysis, Data Analysis and Modeling, Data Migration, Data Cleansing, Developed functional business requirements into technical requirements.
  • Developed Data mapping, functional design, quality assurance and documentation for ETL/Informatica 8.6.1 and Oracle 10g Data Warehousing.
  • Developed Data Mapping (Source to Target Mappings) documents for Informatica 8.6 ETL projects
  • Analysis of data requirements and development of logical data models.

EMPLOYMENT HISTORY

TEST SPECIALIST/ETL DEVELOPER

Confidential, Buffalo, NY Oct 2008 –June 2009
Responsibilities:

  • Work with Business Analyst and users to clarify requirements and translate the requirement into technical specifications.
  • Created new mappings and updating old mappings according to changes in Business logic
  • Performed major role in understanding the business requirements and designing, loading and extract the data into data warehouse of Facets, Pharmacy Claims, Med Claims, Members, and BHI,CRMS, OPA files
  • Used ETL (Informatica) to load data from source to ODS.
  • Using Informatica PowerCenter 8.6 Tools, Source Analyzer, Target designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
  • Designed and developed database packages, procedures, functions and triggers on Oracle 9i/10g databases.
  • Created Application Detailed Designs of modules in Oracle PL/SQL and Oracle Forms,
  • Prepared Component and Assembly Test Scripts and performed Component and Assembly tests to ensure that the modules are functioning according to design
  • Created reusable transformations and mapplets based on the business rules to ease the development.
  • Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status, UNIX job scripts for scheduling jobs in AutoSys.
  • Developing complex mappings in Informatica PowerCenter 8.6 to load the data from various sources like SQL Server, DB2, Flat files, into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier
  • Implemented performance tuning logic on Targets, Sources, mappings in Production environment, Sessions to provide maximum efficiency and performance.
  • Defined Target Load Order Plan for loading data into Target Tables
  • Prepared Unit Test, System Integration Test and UAT to check the data quality.
  • Performed ETL data and Mapping Validation in QA environment.
  • Created Materialized view for summary data to improve the query performance. Loading data in Production using Informatica,
  • Perfomed defect tracking and manament using Rational Clear Quest

Environment: Informatica Power Center 8.6, Cognos 8,IBM DB2, SQL Server 2005, Oracle10g Developer, Clear Quest Test Manager, QTP, Robot,WinRunner7.x, MS Access, Flat Files, WinSQL, Unix, TOAD, Erwin 4.1, Windows XP 2003

DATA WAREHOUSE TEST SPECIALIST- EDW-BI-PROJECT
Confidential, May 2006-Sep 2008

Role & Responsibilities:

  • Reviewed the Business and functional requirement documents (BRD) and identified test scenarios.
  • Performed Unit, Creating test cases, User Acceptance, End to End testing of different Subject Areas (Medical Claims, Master Medical Claims, Pharmacy Claims, Member and Customer, Involved in developing test plans and test cases based on high-level and detailed designs, extensively performed manual testing, requirements verification testing, and functional testing,
  • Designed and developed in-house ETL for Vendor specific pharmacy data load process. Developed 200 PL/SQL Stored procedures to optimize database load and validation process.
  • Developed and Participated in Test Case walkthroughs, inspection meetings, Interacted and worked with the Development and Data warehouse team to solve the problems encountered in test execution.
  • Participated in review meetings with Dev team to meet the testing targets, Participated in daily status meetings to report any bugs, issues and risks.
  • Creating and Executing SQL queries in SIT, QA1, QA2 and Production environments to getting $ amount Counts. Executing Informatica workflows and sessions job streams in IBM Tivoli,
  • Using Oracle SQL Developer to Analysis Data from Staging to EDW, Running queries in IDS/EDW to match the counts.
  • Creating and Executing UNIX scripts and running scripts for control file creating trigger files to start the workflows and job streams in UNIX,
  • Loaded 5 years Data into Production and monitoring workflows/sessions and Tivoli job streams 24/7. Working with ETL team for workflow/sessions troubleshooting issues, getting error info from sessions log files and helping ETL team to resolve the issue.
  • Using Informatica Power Exchange to extract mainframe files, performed row test and sending to node, checking data map in mainframe to make sure the data map match in Production Support environment.

Environment: Informatica Power Center 7.4/8.0, Oracle10g, Oracle SQL Developer, SQL, PL/SQL, UNIX, Clear Quest Test Manager Robot AQT IRRAD ULTRA EDIT Win Runner, TOAD for Oracle, Erwin 4.1, TSO, JCL, File Aid, Windows XP 2003

ORACLE DBA/ DATA ANALYST,
Confidential, Detroit, MI Jan 2002- March 2006
Role & Responsibilities:

  • Administration and development of large databases application in Oracle 8.
  • Creating and testing backup and recovery procedures. Performance tuning.
  • Application SQL statements performance tuning. Providing solutions and assistance to the Customers through the implementation and product maintenance call on support.
  • Monitoring and tuning memory at the Operating System Level and install patches and upgrade,
  • Created and documented scripts for Hot Backups and exports and imports.
  • Proactively managed disk space: reducing where possible, adding where necessary. Created scripts to detect tables close to maximum extents. De-fragmented production tablespaces.
  • Tuning the database for optimal performance and customizing Oracle initialization parameters.
  • Tuned shared pool memory by pinning the often used stored procedures, packages, work on Multi Server environment,
  • Optimized long running SQL statements with the help of explain plans.
  • Monitoring rollback segments for excessive wraps and waits and sizing rollback segment appropriately. Created a separate large rollback segment for large transactions.
  • Created bitmap indexes on dbm table. DBM table had columns that were queried against. They had low cardinality – a bitmap against them improved performance.
  • User Management - created users, profiles and associated roles, profiles to users to maintain system security and restrict resource consumption. Monitored users by auditing sessions. Audited at object level and collected usage statistics for the tables and created a report for management.

Environment: Oracle 7/8/8i/, SQL, PL/SQL, Flat file, MS SQL Server, RMAN, SQL*Loader, Ms Access Windows 2000

EDUCATION
  • Bachelor of Computer science (BCS)
  • Master of Computer science (MCS)
PROFESSIONAL TRAINING AND CERTIFICATES
  • Oracle8/8i Certified Database Administrator -DBA (Oracle Corp). USA
  • Successfully completed Informatica PowerCenter 7 developer Training ( Informatica Corp-NY-USA )
  • Oracle8 Database Administrator Certification (Brain bench)
  • One year diploma in Oracle Developer 2000 - (Engineering University Lahore, Pakistan

SPECIAL SKILLS

  • Able to easily learn and implement new ideas and technologies as well as provide professional support to other team members.
  • Details oriented person with excellent communication, interpersonal, analytical, problem solving skills.

Hire Now