Summary

• Several years of experience in the Information Technology field, with comprehensive hands-on expertise in Data Warehouse Architecture, ETL Data Migration / Conversion Analyst, Database Application Development, Database Analysis, BI Analyst, Database Support, Business Analyst, Reporting processes/procedures and/or Quality Assurance QA testing. Ability to apply technical skills both tactical and strategic for business resolution.
• For over fifteen years, my career focus has been centered on Business Intelligence and Data Warehouse system design, development and deployment. The application of extensive experience across multiple DBMS' and platforms has provided a strong aptitude for multidimensional database design coupled with robust operational architectures.
• Assignments frequently included complex projects involving multiple locations / departments, multi-vendor hardware / software platforms and multi-protocol environments, often requiring my expertise to resolve complex projects. I am a creative thinker that has a proven track record to think outside of the box and have the ability to resolve any issue that was thought to be impractical.
• Confidential, active passport, clean driving record, have acquired sensitive clearance for government contracts.

Technical Skills

Database Platforms:

• SQL Server 2000/2005/2008 Oracle 8.05 / 9i / 10g / 11g Visual FoxPro
• NCR Teradata V2R5 MS Access MS Visual Studio

Languages:

Transact-SQL, PL/SQLSQL Scripting, VB, Basic Knowledge of UNIX Shell Scripting, Bash Java Scripts

Operating Systems:

AS/400, Windows 95/98/NT/2000/2003/XP, Vista, DOS, Citrix, Linux and UNIX

DW/ BI /Case Tools:

• Integration Services SSIS, SQL Server Analyzer Enterprise Manager - EM, MySQL 5.1, BIMS, BIDS, Visual Studio 2005
• Oracle PL/SQL Developer v7.0, TOAD v9.1, SQL Navigator v4.3, SQL Plus 8, Siebel Analytics OBIEE , MS Access, MS Query, Erwin r7, Power Designer, Visio, Crystal Reports, Brio and DCU.
• Teradata Utilities BTEQ, Queryman, MultiLoad, FastLoad, FastExport, Tpump, Arc/Restore

ETL Tools:

• Informatica v9.1, v8.6.1, v7.1.2, SQL Server Integration Services SSIS and DTS, Pentaho Kettle , Data Junction v7.0, v7.5, DJCosmos v8.0 and Connx
• Other Software: WinSCP, Putty, MS Office Excel, Word, Access, PowerPoint and FrontPage , MS Project, SharePoint, Monarch, TestDirector 8.0 and many other analytical tools.

Professional Skills

• Highly skilled SQL Programmer Analyst with over 15 years of experience ETL and SQL development, design, analyzing and administering numerous Relational Databases RDBMS within Oracle, SQL Server, Teradata, MS Access and various other environments.
• Exceptional working knowledge of multiple applications and operating environments with solid understanding of data warehousing star and snowflake and data mart design, implementation, data migration/conversions and management concepts development and production .
• IT expertise in the areas of Financial Servicing Industry, Medical and Telecommunications, such as Auto, Credit/Debit Card, Banking, Cellular, Landlines, Cable Media, Sales, Transportation and government CDC .
• Extensive experience creating database schemas, table definitions, views, stored procedures, and functions UDF .
• Multitudinous experience across all stages of Software Development Life Cycle SDLC including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Ability to work on multiple projects with multiple stakeholders on Agile and/or Waterfall SDLC methodology and convey Analytical findings accordingly both written and verbal.
• Extensive work experience in ETL analysis, designing, developing, testing and implementing ETL process in Informatica v7 /v8/v9.1 and Pentaho Kettle including performance tuning and ETL process streamlining.
• Ability to design and develop ETL mappings and workflows from data models and design sessions.
• Exceptional technical skills including advance SQL scripting development PL/SQL, T-SQL, C, VB, Gupta utilizing applications such as TOAD, MySQL, SQL Navigator, DTS and SSIS Processes and many more.
• Ability to extract various types of data EBCDIC, ASCII, XML, unstructured datasets and other data types data from numerous, heterogeneous OLAP and/or legacy data sources then transform into the targeted structure using SQL Scripts and various ETL tools.
• Ability to write and comprehend complex embedded queries and sub-queries including stores procedures, functions, triggers, packages, hints, hash functions, test scripts and sub-queries.
• Highly proficient in analyzing requirements for Reporting and Application Design purposes.
• Experience translating business requirements and user expectations into detailed specification documents employing Unified Modeling Language UML including Use Cases, Sequence, State and Activity diagrams and Data mappings.
• Extensive experience writing business requirements with the ability to gather and translate functional and/or technical business requirements into an application and/or a physical process.
• Extensive experience in conducting Joint Application Development JAD sessions with end-users, Subject Matter Experts SME's , Development and QA teams.
• Data Modeling Physical and Logical ability to create staging, star and snowflake schema models, 3NF.
• Ability to validate the integrity of data relationships, mappings and table definitions.
• Creative thinker ability to think outside of the box to resolve complex issues
• Excellent analytical and communication skills
• Please contact me to discuss your opportunity and obtain a full version of my resume.

Keywords: Oracle, SQL Server, Pentaho Kettle, Spoon , Unix, XML, Informatica, DataJunction Cosmos, ETL Developer, SQL Developer, Report Developer, Data Mining, Programmer, Architect, Star, Snowflake, 3rd Normal Form 3NF , Modeling.