SUMMARY:

• I am a highly motivated professional with 15 years of experience in the information technology and financial services industries.
• I am an expert in architecture, design, development, and administration of databases.
• I have extensive knowledge of the programming, implementation, and documentation of complex systems from my strong knowledge of the software development life cycle.
• I also have a very strong background developing and extending OLTP and OLAP database designs using principles of relational theory, normalization and dimensional modeling.
• I possess very strong analytical skills used to systematically resolve any issue.
• I am able to work under pressure to deliver high quality solutions, while working individually or collaboratively in a team environment, often as the team lead.
• My greatest strength is the ability to build, lead and maintain productive relationships with both business and technical resources.

TECHNICAL SKILLS:

Database Servers: Oracle Database Servers 8i, 9i, 10g, 11g with RAC, ASM and Oracle Partitioning, Oracle Business Intelligence EEMicrosoft SQL Server 6.5, 7.0, 2000, 2005, 2008, Sybase SQL Server 11.9 12.5

Modeling Tools: CA ERWIN R4.1 thru R8.2, Microsoft Visio

Programming Languages: P/L SQL, T - SQL, ANSI compliant SQL, Java, EJB, JSP, VB, VC++, ASP, Standard C/C++ with GNU and GCC Compilers for Unix, UNIX Shell Scripting and Perl

Development Environment Tools: Oracle SQL Developer, IBM Cognos Framework Manager, Datamanager, Unix VI, NetBeans, Eclipse

Operating Systems: All versions of MS Windows, Linux (SuSe, RedHat, Centos), SUN 5.X, AIX and HP UNIX

Source Code Control Tools: SVN, IBM Rational Clear Case with Rational ClearQuest, Microsoft Visual Source Safe

RELATED EXPERIENCE:

Confidential

Senior Database Architect, Administrator and Developer

Responsibilities:

• responsible for the architecture, design, development of complex financial business systems.
• Work with product owners and user groups to lead development teams to design and develop Data Marts to the Corporate Data warehouse for advanced Business Intelligence reporting capabilities.
• Design advanced ETL methods utilizing RDBMS tools with middle tier tools for optimal ETL across large datasets and environments.
• Provides technical leadership for authoring and designing PL/SQL and T/SQL database objects; provide guidance on adhering to normalization standards utilized by high volume, highly scalable custom applications.
• Designs and develops new systems and augments existing databases to accommodate enhancements and changing business requirements.
• Creates and documents plans for database growth, scalability, performance metrics and recovery planning.
• Develops and administers schedules for backups, optimizations and enhancements to existing systems and upgrades to new or existing platforms.
• Mentors and supports onsite development and support staffs, manage onshore and offshore database development and support efforts.

Confidential

Senior Database Administrator, Developer

Responsibilities:

• responsible for database development and administration of new features and functionality for existing products.
• Work with development staff, product owners and users to define, document, develop and support product releases and internal database needs.
• Provide performance improvements to internal and external applications via tuning of existing embedded and non-embedded SQL, alter and augment database objects including indexes, materialized views and RDBMS configuration tuning to improve system performance for scalability and load. provide solutions to improve existing reporting performance and functionality.
• Augment and improve loading of tax content data into RDBMS's. Worked closely with product owners and customers to identify and correct functional and performance issues. provide solutions to ensure tax content rules used by TWE were available to customers, this included support of internal applications, adding users, improving performance of internal MSSQL db used by tax attorneys and staff.

Confidential

Senior Database Developer/Administrator

Responsibilities:

• responsible for technical specifications documentation, design and development used in client server and web based applications and automation.
• Technical lead role and mentor for development staff for authoring and designing PL/SQL and T-SQL database triggers, procedures, functions and views and table schema design adhering to normalization standards utilized by high volume, highly scalable custom applications.
• Created requirements documentation, design, development and support existing and development of new financial applications for customers requiring custom software implementations.
• Performed database maintenance design and documentation used for the purpose of support for production systems accommodating to database growth, user scalability and failover/disaster recovery planning.
• Developed and administered backup schedules, optimizations and enhancements to existing systems and upgrades to new or existing platforms.

Confidential

Senior Database Developer

Responsibilities:

• responsible for development of scripts and migration of objects for data conversion from legacy systems.
• Utilized DTS and BCP. Lead author for T/SQL objects development for use in VB/ASP client server and web applications.
• Created requirements documentation, design, development and support financial applications for departments requiring custom software implementations.
• Responsible for lead position tasked with front end workflow UI design and middle and back end tiers objects for client server, web based applications and automation.
• Primary database schema Architect for custom applications and integrating into vendor products.
• Developed and administered backup schedules, optimizations and enhancements to existing systems and upgrades to new or existing platforms.
• Maintained database table growth and archived providing 24/7 support to production data warehouses.