਀  㰀琀搀 猀琀礀氀攀㴀✀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀㬀栀攀椀最栀琀㨀㄀㄀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀  㰀琀搀 猀琀礀氀攀㴀✀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀㬀栀攀椀最栀琀㨀㄀㄀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀ 㰀琀爀 猀琀礀氀攀㴀✀洀猀漀ⴀ礀昀琀椀ⴀ椀爀漀眀㨀㜀　✀㸀 ਀  㰀琀搀 眀椀搀琀栀㴀㄀㔀　 瘀愀氀椀最渀㴀琀漀瀀 猀琀礀氀攀㴀✀眀椀搀琀栀㨀㄀㄀㈀⸀㔀瀀琀㬀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀✀㸀

਀  㰀琀搀 眀椀搀琀栀㴀㄀㔀　 瘀愀氀椀最渀㴀琀漀瀀 猀琀礀氀攀㴀✀眀椀搀琀栀㨀㄀㄀㈀⸀㔀瀀琀㬀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀✀㸀㰀䰀漀挀愀琀椀漀渀㸀

਀  㰀琀搀 眀椀搀琀栀㴀㄀㠀　 瘀愀氀椀最渀㴀琀漀瀀 猀琀礀氀攀㴀✀眀椀搀琀栀㨀㄀㌀㔀⸀　瀀琀㬀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 㔀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀  㰀瀀 挀氀愀猀猀㴀䴀猀漀一漀爀洀愀氀㸀㰀猀瀀愀渀 猀琀礀氀攀㴀✀昀漀渀琀ⴀ猀椀稀攀㨀㠀⸀㔀瀀琀㬀昀漀渀琀ⴀ昀愀洀椀氀礀㨀∀䄀爀椀愀氀∀Ⰰ∀猀愀渀猀ⴀ猀攀爀椀昀∀㬀 mso-fareast-font-family:"Times New Roman"'>Industry: Financial਀  匀攀爀瘀椀挀攀猀㰀漀㨀瀀㸀㰀⼀漀㨀瀀㸀㰀⼀猀瀀愀渀㸀㰀⼀瀀㸀 ਀ 㰀⼀琀爀㸀 ਀  㰀琀搀 眀椀搀琀栀㴀㄀㠀　 瘀愀氀椀最渀㴀琀漀瀀 猀琀礀氀攀㴀✀眀椀搀琀栀㨀㄀㌀㔀⸀　瀀琀㬀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 㔀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀  㰀瀀 挀氀愀猀猀㴀䴀猀漀一漀爀洀愀氀㸀㰀戀㸀㰀䔀砀瀀攀爀椀攀渀挀攀吀椀琀氀攀㸀㰀猀瀀愀渀 猀琀礀氀攀㴀✀昀漀渀琀ⴀ猀椀稀攀㨀㠀⸀㔀瀀琀㬀 font-family:"Arial","sans-serif";mso-fareast-font-family:"Times New Roman"'>Technical਀  倀䴀㰀⼀猀瀀愀渀㸀㰀⼀䔀砀瀀攀爀椀攀渀挀攀吀椀琀氀攀㸀㰀⼀戀㸀㰀猀瀀愀渀 猀琀礀氀攀㴀✀昀漀渀琀ⴀ猀椀稀攀㨀㠀⸀㔀瀀琀㬀昀漀渀琀ⴀ昀愀洀椀氀礀㨀∀䄀爀椀愀氀∀Ⰰ∀猀愀渀猀ⴀ猀攀爀椀昀∀㬀 mso-fareast-font-family:"Times New Roman"'>

਀  㰀琀搀 猀琀礀氀攀㴀✀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀㬀栀攀椀最栀琀㨀㄀㄀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀  㰀琀搀 猀琀礀氀攀㴀✀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀㬀栀攀椀最栀琀㨀㄀㄀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀ 㰀琀爀 猀琀礀氀攀㴀✀洀猀漀ⴀ礀昀琀椀ⴀ椀爀漀眀㨀㜀㘀✀㸀 ਀  㰀琀搀 眀椀搀琀栀㴀㄀㔀　 瘀愀氀椀最渀㴀琀漀瀀 猀琀礀氀攀㴀✀眀椀搀琀栀㨀㄀㄀㈀⸀㔀瀀琀㬀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀✀㸀

਀  㰀琀搀 眀椀搀琀栀㴀㄀㔀　 瘀愀氀椀最渀㴀琀漀瀀 猀琀礀氀攀㴀✀眀椀搀琀栀㨀㄀㄀㈀⸀㔀瀀琀㬀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀✀㸀㰀䰀漀挀愀琀椀漀渀㸀

਀  㰀琀搀 眀椀搀琀栀㴀㄀㠀　 瘀愀氀椀最渀㴀琀漀瀀 猀琀礀氀攀㴀✀眀椀搀琀栀㨀㄀㌀㔀⸀　瀀琀㬀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 㔀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀  㰀瀀 挀氀愀猀猀㴀䴀猀漀一漀爀洀愀氀㸀㰀猀瀀愀渀 猀琀礀氀攀㴀✀昀漀渀琀ⴀ猀椀稀攀㨀㠀⸀㔀瀀琀㬀昀漀渀琀ⴀ昀愀洀椀氀礀㨀∀䄀爀椀愀氀∀Ⰰ∀猀愀渀猀ⴀ猀攀爀椀昀∀㬀 mso-fareast-font-family:"Times New Roman"'>Industry: Insurance

਀ 㰀⼀琀爀㸀 ਀  㰀琀搀 猀琀礀氀攀㴀✀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀㬀栀攀椀最栀琀㨀㄀㄀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀  㰀琀搀 猀琀礀氀攀㴀✀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 　椀渀㬀栀攀椀最栀琀㨀㄀㄀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀ 㰀⼀琀爀㸀 ਀  㰀琀搀 眀椀搀琀栀㴀㄀㠀　 瘀愀氀椀最渀㴀琀漀瀀 猀琀礀氀攀㴀✀眀椀搀琀栀㨀㄀㌀㔀⸀　瀀琀㬀瀀愀搀搀椀渀最㨀　椀渀 　椀渀 　椀渀 㔀⸀㈀㔀瀀琀✀㸀㰀⼀琀搀㸀 ਀  㰀瀀 挀氀愀猀猀㴀䴀猀漀一漀爀洀愀氀㸀㰀猀瀀愀渀 猀琀礀氀攀㴀✀昀漀渀琀ⴀ猀椀稀攀㨀㠀⸀㔀瀀琀㬀昀漀渀琀ⴀ昀愀洀椀氀礀㨀∀䄀爀椀愀氀∀Ⰰ∀猀愀渀猀ⴀ猀攀爀椀昀∀㬀 mso-fareast-font-family:"Times New Roman"'>Contracted to maintain, add਀  昀甀渀挀琀椀漀渀愀氀椀琀礀Ⰰ 愀渀搀 挀爀攀愀琀攀 渀攀眀 爀攀瀀漀爀琀猀 椀渀 䴀匀 匀儀䰀 匀攀爀瘀攀爀 ㈀　　㠀 刀攀瀀漀爀琀椀渀最 Services. In addition to reporting, an existing unfinished ETL process had to਀  戀攀 爀攀ⴀ愀爀挀栀椀琀攀挀琀攀搀 愀渀搀 椀渀 猀漀洀攀 挀愀猀攀猀 琀栀攀 猀琀愀最椀渀最 搀愀琀愀戀愀猀攀 愀氀猀漀 栀愀搀 琀漀 戀攀 re-architected. Customer wanted a true history of new, deleted, and updated਀  爀攀挀漀爀搀猀⸀ 䌀爀攀愀琀攀搀 愀 渀攀眀 瀀爀漀挀攀猀猀 眀栀攀爀攀 琀栀攀 搀攀猀琀椀渀愀琀椀漀渀 猀琀愀最椀渀最 琀愀戀氀攀猀 栀愀搀 triggers on them which moved these changes to "history tables".਀  吀栀椀猀 匀琀愀最椀渀最 䐀愀琀愀戀愀猀攀 戀攀挀愀洀攀 愀渀 伀瀀攀爀愀琀椀漀渀愀氀 䐀愀琀愀 匀琀漀爀攀 ⠀伀䐀匀⤀ 昀漀爀 洀漀猀琀 漀昀 琀栀攀 companies downstream reporting.Wrote numerous transactional stored਀  瀀爀漀挀攀搀甀爀攀猀Ⰰ 爀攀洀漀瘀攀搀 渀甀洀攀爀漀甀猀 瀀攀爀昀漀爀洀愀渀挀攀 戀漀琀琀氀攀 渀攀挀欀猀 愀渀搀 搀攀猀椀最渀 椀猀猀甀攀猀⸀ Created numerous SSIS packages that included package configurations, SQL਀  氀漀最最椀渀最Ⰰ 愀渀搀 攀爀爀漀爀 栀愀渀搀氀椀渀最⸀ 䌀爀攀愀琀攀搀 猀攀瘀攀爀愀氀 匀儀䰀 䄀最攀渀琀 䨀漀戀猀 眀栀椀挀栀 攀砀攀挀甀琀攀搀 the SSIS packages and also performed numerous data validation checks.਀  刀攀ⴀ眀爀漀琀攀 渀甀洀攀爀漀甀猀 攀砀椀猀琀椀渀最 瀀爀漀搀甀挀琀椀漀渀 爀攀瀀漀爀琀猀 椀渀 刀攀瀀漀爀琀椀渀最 匀攀爀瘀椀挀攀猀 昀漀爀 performance reasons.  The biggest gain on performance was one report਀  琀栀愀琀 瀀爀攀瘀椀漀甀猀氀礀 琀漀漀欀 ㄀㔀 栀漀甀爀猀 琀漀 爀甀渀Ⰰ 愀渀搀 愀昀琀攀爀 洀漀搀椀昀椀挀愀琀椀漀渀Ⰰ ㈀　 seconds.  Data Sources came from Oracle 10g and 11i, IBM i-Series DB2,਀  䴀匀 匀儀䰀 匀攀爀瘀攀爀 ㈀　　　 愀渀搀 ㈀　　㔀Ⰰ 堀䴀䰀Ⰰ 䌀匀嘀 琀攀砀琀 昀椀氀攀猀Ⰰ 愀渀搀 䴀匀 䔀砀挀攀氀 猀瀀爀攀愀搀 猀栀攀攀琀猀⸀ Since there was no Database Administrator, all DBA work was also included in਀  琀栀攀 搀攀瘀攀氀漀瀀洀攀渀琀 氀椀昀攀挀礀挀氀攀⸀☀渀戀猀瀀㬀 吀栀椀猀 椀渀挀氀甀搀攀搀 椀渀猀琀愀氀氀椀渀最 愀渀搀 挀漀渀昀椀最甀爀椀渀最 琀栀攀 Development, Testing, User Acceptance, and Production Environments.Worked਀  搀椀爀攀挀琀氀礀 眀椀琀栀 琀栀攀 挀甀猀琀漀洀攀爀 琀漀 最愀琀栀攀爀 爀攀焀甀椀爀攀洀攀渀琀猀 昀漀爀 爀攀瀀漀爀琀椀渀最⸀☀渀戀猀瀀㬀 䤀渀 this role I acted as a PM, DBA, Developer, Architect, Business Analyst, and਀  洀攀渀琀漀爀攀搀 洀愀渀礀 樀甀渀椀漀爀 氀攀瘀攀氀 搀攀瘀攀氀漀瀀攀爀猀⸀䌀甀猀琀漀洀 挀爀攀愀琀攀搀 愀 䴀匀 匀栀愀爀攀倀漀椀渀琀 瀀漀爀琀愀氀 that tracked the entire project lifecycle from gathering requirements, to਀  搀漀挀甀洀攀渀琀 挀爀攀愀琀椀漀渀 愀渀搀 琀爀愀挀欀椀渀最Ⰰ 琀漀 搀攀瘀攀氀漀瀀洀攀渀琀 猀琀愀最攀猀Ⰰ 琀漀 琀攀猀琀椀渀最Ⰰ 愀渀搀 finally sign off and release into production.Exposed to: MS Office 2003 &਀  ㈀　　㜀Ⰰ 䴀匀 匀儀䰀 匀攀爀瘀攀爀 ㈀　　㔀Ⰰ 匀匀䤀匀Ⰰ 匀匀刀匀Ⰰ 嘀䈀⸀一攀琀Ⰰ 䌀⌀⸀一攀琀Ⰰ 䄀匀倀⸀一攀琀Ⰰ 椀ⴀ匀攀爀椀攀猀Ⰰ Oracle, VSS 2005, SSMS, and Visual Studio 2005. Performed a wide variety of਀  䐀䈀䄀 琀愀猀欀猀 猀甀挀栀 愀猀㨀 挀漀搀攀 洀椀最爀愀琀椀漀渀⼀搀攀瀀氀漀礀洀攀渀琀Ⰰ 搀愀琀愀戀愀猀攀 洀愀椀渀琀攀渀愀渀挀攀Ⰰ replication, database backups and restores, SQL Agent job creation and਀  猀挀栀攀搀甀氀椀渀最Ⰰ 搀愀琀愀戀愀猀攀 挀爀攀愀琀椀漀渀Ⰰ 猀攀挀甀爀椀琀礀 洀漀搀攀氀猀Ⰰ 搀愀琀愀 洀漀搀攀氀猀Ⰰ 愀渀搀 搀愀琀愀 warehouse star schema architecture.