Programmer Analyst Resume Profile, OH - Hire IT People

Experience Summary

Over 13 years experience in Information Technology with experience in large scale Data Warehouse Development, ETL, Business Intelligence, Data Modeling, Data Analysis and Integration
Experience in ETL, Informatica PowerCenter, Teradata, Oracle and IBM Banking Data Warehouse
Experience with Business Intelligence applications, OLAP, OLTP, Enterprise Data Warehousing Strategy and Architecture, ODS
Strong Data Warehousing Concepts
Extensive Data Migration and Conversion, Data Transformation ETL , Performance Tuning
Comprehensive knowledge and experience in Process Improvement, Normalization/de-normalization, Data Quality Analysis
Good working knowledge of Oracle database, including views, materialized views, packages and procedures, triggers, synonyms, indexes, joins, partitioning
Worked in Oracle Exadata environment and performance tuning, SQL query optimization
Working Experience in Teradata and MS SQL Server databases
Extensive experience in advanced Informatica concepts including transformation tuning, memory allocations, PDO, session partitioning
Experience in Banking Domain and knowledge of Retail, Commercial, Lending, Leasing, Deposits, Mortgages, Risk Management
Experience in Software Development Life-cycle and Application Development Maintenance methodology
Extensive business analysis, process analysis, interviewing end-users, gathering and refining requirements, developing and defining business rules
Experience in Large Scale projects that involves various teams and support groups
Significant testing experience, including designing test cases, UAT testing, DR Testing, and designing test data
Excellent analytical and interpersonal skills, oral and written Communication Skills, Presentation skills
Worked with large and diverse teams, team oriented and has excellent collaboration skills.

Technical Skills

ETL Tools: Informatica PowerCenter 7.x,/8.x/9.x, PowerExchange
Databases: Teradata 13/14, Oracle 10g/11g, Oracle Exadata, MS SQL Server, IBM-DB2,
Data Warehouse: Star and Snowflake Schema, Fact and Dimension Tables, Conceptual, Logical and
Physical Data Modeling, Dimensional Data Modeling, Relational Data Modeling,
Performance Tuning: DBMS STATS, DBMS XPLAN, SQL Trace, Explain Plan, Partitioning, Materialized Views, Snapshots, Hints. Informatica Partitioning, Query Optimization, PDO, Transformation tuning
Data Modeling: CA Erwin, Oracle Data Modeler
Database Tools: Toad, SQL Developer, Teradata Studio, SQL Plus, Oracle Utilities
Operating Systems: Sun Solaris 9, HP-UX, MS Windows Server, Red Hat Linux, IBM Mainframe
Scripting: UNIX shell, Perl, DOS Batch,
Programming: Oracle PL/SQL, C, C , Java
Other Tools: CA Workbench, Serena Changeman, Autosys, CA7, SQLPlus

Project Experience

Data Architect

Confidential

Capital Markets/Risk Management - Quantitative Risk Management QRM , Liquidity Coverage Ratio LCR , Risk Weighted Assets RWA
Environment: Informatica 9.5, Teradata 14.10, Oracle 11i, PL/SQL, MS SQL Server 2005/2008, Autosys, Unix, ERWIN, Toad, Teradata Studio, CA Workbench, Sun Solaris 9, MS SSIS, SQL Server Management Studio

ETL Architect

Confidential

Basel II - Enterprise Integration Platform Banking Data Warehouse BDW
Environment: Informatica 8.6.1, Oracle Exadata, Oracle 10g/11g, PL/SQL, Autosys, Unix, ERWIN, Toad, Oracle Utilities, PowerExchange 8.6

ETL Architect

Confidential

Oracle Financial Services Applications OFSA
Environment: Informatica 8.6.1, OFSA 4.5.1, Oracle 10g Database, PL/SQL, Autosys, Unix, ERWIN, Toad, Oracle Utilities, SQL Plus, MS Visio

Data Analyst, ETL Developer

Confidential

Cost Architecture
Environment: Informatica 8.6.1, Oracle 10g Database, Java, PL/SQL, Shell Scripting, Toad, Autosys, Serena ChangemanDS

Programmer Analyst

Confidential

Reconplus and Finance Reconciliation
Environment: Informatica 7.1, MS SQL Server 2000 Database, IIS, Perl scripting, MS Windows Server 2003

Programmer Analyst

Confidential

Environment: IBM S/390 Mainframes, COBOL, IBM-DB2 SQL, CICS, JCL, CA7, VSAM

We provide IT Staff Augmentation Services!

Programmer Analyst Resume Profile

OH

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship