Summary

• Several years of experience in the Information Technology field, with comprehensive hands-on expertise in Data Warehouse Architecture, SQL/ETL Development, Data Migration / Conversion Analyst, Application and Reporting Development, BI Analyst, DB Admin/Support. Ability to apply technical skills for business resolutions and the ability to switch easily between different projects with the flexibility to handle rapidly changing environments.
• For over fifteen years, my career focus has been centered on Business Intelligence and Data Warehouse system design, development and deployment utilizing both Bill Inmon and Ralph Kimball philosophies. The application of extensive experience across multiple RDBMS 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.

Technical Skills

• Database Platforms:
• SQL Server 2000/2005/2008/2012
• Oracle 8.05 / 9i / 10g / 11g
• Teradata v13
• MS Access
• MS Visual Studio
• Visual FoxPro
• Languages:
• Transact-SQL, PL/SQLSQL Scripting, VB, UNIX Shell Scripting, Bash and knowledge of Java Scripts
• Operating Systems:
• AS/400, Windows 95/98/NT/2000/2003/XP/7, Vista, DOS, Citrix, UNIX Sun Solaris and Linux
• DW/ BI /Case Tools:
• Integration Services SSIS, SSRS, SQL Server Analyzer Enterprise Manager - EM, MySQL 5.1, BIMS, BIDS, Visual Studio 2005/2008/2012
• Oracle PL/SQL Developer, TOAD v12.1, SQL Navigator, SQL Plus, Siebel Analytics OBIEE , MS Access, MS Query, Erwin r7, Power Designer, Visio, Crystal Reports, Brio and DCU.
• ETL Tools:
• Informatica v9.2, 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, Version Control svn Tortoise , Enterprise Scheduler Tivoli and many other analytical tools.
• Professional Skills
• Highly skilled SQL Developer with over 15 years of experience in ETL and SQL development, design, analyzing and administering numerous Relational Databases RDBMS within Oracle, SQL Server, Teradata and various other environments.
• Familiar with Bill Inmon and Ralph Kimball methodologies.
• 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 work experience in ETL Processes including development, gathering technical requirements, mapping, workflow development, process monitoring, performance tuning, testing and implementation/deployment of ETL processes in Informatica v7 /v8/v9.2 and Pentaho Kettle and Spoon including enterprise scheduling via Tivoli and windows scheduler.
• 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.
• 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 .
• 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 design and develop ETL mappings and workflows from data models and design sessions.
• Enterprise Scheduler Tivoli experience.
• 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.
• Exceptional technical skills including advance SQL scripting development PL/SQL, T-SQL, C, VB utilizing applications such as TOAD, MySQL, SQL Navigator, DTS and SSIS Processes and many more.
• 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.
• 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

Keywords: Oracle 10g / 11g, PL/SQL, SQL Server 2000/2005/2008/2012, T-SQL, Teradata v13, Unix, XML, Informatica, SSIS, SSRS, Pentaho Kettle, Spoon , DataJunction Cosmos, ETL Developer, SQL Developer, Teradata Assistant, Teradata Express, Report Developer, TOAD, ERwin, Data Mining, Programmer, Architect, ODW, ODI, ODS, OLTP, OLAP, Star, Snowflake, Enterprise Databases, 3rd Normal Form 3NF , Modeling.