SUMMARY

• A hands - on database developer wif solid experience in database application development and enterprise integration.
• Expert in relational and dimensional database modeling and implementation, database application development, data warehousing, business intelligence, ETL processing, systems integration, replication techniques, development of software through all stages of product life cycle.
• Technical Leadership in enforcing database best practices, design and security standards across multiple teams inside the department, onshore and offshore.
• Excellent communication skills, comfortable interacting wif technical and non-technical audiences.

TECHNICAL EXPERTISE

Languages: Transact-SQL, SQL, Oracle PL/SQL, XML, HTML, C#, VB.NET, VBA, Visual C/C++, UNIX Shell Scripting.

Database Servers: MS SQL Server, Oracle, Sybase SQL, MySQL, MongoDB.

Software: MS SSIS, MS SSAS, MS SQL Replication, Oracle Streams AQ, Oracle Coherence, Oracle Change Notification, Oracle XML, Oracle Gloden Gate, SQL*Loader, Cognos BI, Informatica ETL.

Tools: SQL Server Management Studio, MS Visual Studio, MS Business Intelligence Developer Studio, SQL Server Data Tools, SQL Server Profiler, Database Engine Tuning Adviser, Erwin, Visio, Eclipse, Oracle SQL Developer, Oracle Enterprise Manager, Oracle SQL*Plus, Sybase SQL Advantage, PL/SQL Developer, Toad for Data Analysts and Oracle, Embarcadero DB PowerStudio.

Version Control Systems: CVS, Clear Case, TFS.

Operating Systems: MS Windows, Mac OS, various Linux/UNIX distributions.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Database Developer/Architect

Responsibilities:

• Was responsible for requirement analysis, design of original logical and physical models, support and evolution of existing data models, products research and evaluation, implementation, testing, deployment into production and maintenance of multiple database solutions.
• Worked wif the end users to ensure application compliance wif business rules, help achieve higher productivity and to lower support costs.
• Worked wif onshore and offshore team leads to defined logical and physical models for each application, coded data access layers, designed application security and versioning solution.
• Designed, implemented and maintained several MS SQL server and Oracle database systems: database tables, views, T-SQL and PL/SQL stored procedures and functions, triggers, PL/SQL packages, indexes, sequences, etc.
• Executed SQL Server and Oracle performance tuning and optimization, resolving deadlock issues, etc., by setting database parameters, using optimizer hints, analyzing execution plans, distribution statistics and trace results analysis.
• Executed day to day operational support for ad-hoc reports, non-standard back end updates and investigations of production data issues.
• Participated in design of Client Master Data system: single source of Client data used across multiple Bank of America systems and applications.
• Designed and executed multiple database upgrades from MS SQL Server 2000 - 2005, 2005 - 2008 and Oracle 9i - 10G, 10G - 11G databases.
• Designed Oracle Coherence layer and supported database objects for data caching.
• Designed and developed all the prerequisites and supporting objects necessary to allow moving database from single instance based to a globally distributed solution using Oracle Gloden Gate replication and Oracle Coherence.
• Was responsible for architecture and development of Data Exchange Services providing real-time data synchronization between SQL Server and Oracle databases by using .NET C# Windows Services, SQL Server transactional push replication, PL/SQL triggers, T-SQL stored procedures and PL/SQL packages.
• Designed and developed ETL solutions by using SSIS packages, T-SQL stored procedures, PL/SQL packages, SQL*Loader, batch files, Autosys scheduler and Oracle Jobs for data movement between source and target databases wifin the Sales and Research universe.
• Designed complex database solutions for the new application platform, migrated data and business logic from MS SQL server into Oracle database.
• Implemented asynchronous integration between major business systems using Oracle Advanced Queuing and Oracle notification services.
• Developed and designed Web services to allow using custom aggregate functions in Research Analyst MS Excel models. Developed MS SSIS ETL solutions to extract, transform and load data from Research Data Warehouse and Research Database into SSAS Cubes. Created MDX queries to return cube’s data to be consumed by web services executed from wifin Excel add-in.
• Designed and developed ETL process to extract, transform and load data from BofA legacy system into the common Bank of America/Merrill Lynch post-merger system.
• Led the design and implementation of Research data warehouse. Worked wif the business analysts and business users to shape requirements and define data warehouse structure (star schema, data sources, ETL processes, data marts, and analytics). Evaluated and selected ETL and BI software. Implemented data source integration based on Informatica ETL to process large daily data volumes efficiently from a variety of sources. Designed and configured Cognos BI integration processes and workflows.
• Events Management is a mission critical Client facing enterprise application for multiple lines of businesses to plan, manage and track global Conferences / Investor Events, supporting the following line of business: Research, Equities, Debt, Prime Brokerage, Global Treasury Services, Global Commercial and Corporate Banking.
• Roadshow is an application used by corporate access, research and sales to create and edit roadshows for their clients, schedule meetings, manage travel logistics, and other aspects of the conferencing system.
• GEMS/GMLC Integration Project involved merging legacy Bank of America and Merrill Lynch Conference Scheduling websites.
• Survey Feedback System is an application designed to obtain post conference feedback from conference Investor attendees.
• Catalyst is a conversion and distribution engine, Bank of America’s next generation research publication platform which reliably and efficiently disseminates research publications to a multitude of internal and external destinations while assuring compliance wif various SEC rules and regulations.
• IQ Aggregates project: an MS Excel add-in for Research users providing custom aggregate functions.
• Bank of America/Merrill Lynch merger Legal Day 1 and 2 Integration.
• Research data warehouse: compilation of research data from a variety of sources.

Sr. Software Developer

Confidential

Responsibilities:

• Designed and maintained custom ETL system to interface wif internal and external data vendors, such as Bloomberg, Factset, FirstCall, Thomson Reuters, etc.
• Developed Research Authoring Tool wif MS Word, Excel and VBA.
• Designed Outlook forms for Research Document workflow and approvals.
• Designed and developed a process for converting Research documents in industry standard RIXML format into Formatting Objects (FO) protocol for later transformation into vendor requested formats. Used XSL and Antenna Formatter.
• Designed and developed Research Oracle database schema and supporting objects.

Confidential, San Francisco, CA

Application Consultant

Responsibilities:

• Participated in managing, writing and configuring database schema according business analysis and conceptual design.
• Created tables, views, stored procedures, defined constrains required to underpin a security earnings database.
• Participated in the development of Analyst Client Desktop using MS Word, VBA and MSDE as cache database. System is designed to provide users wif a variety of tools for viewing historical data, entering prognosis into the database and creating ER Documents.
• Enhanced the Feed/Flow application written in Visual C++6 dat resolves streaming data loads for Market Data vendors.
• Developed wif Visual Basic 6.0 Administrative Utilities application for managing company’s coverage, analysts and security identification information.
• Maintained a workflow and document management system in Documentum DocBase and Sybase databases.
• Developed and enhanced DocBasic procedures wif calls to Documentum API and Sybase stored procedures to address changing business needs and new requirements.
• Created triggers to ensure integrity in de-normalized schemas for optimizing data reporting.
• Developed reports wif Microsoft Access using pass-through queries and linked tables to Sybase via ODBC.
• Equity Research Management System (ERMS) for Bank of America Securities, London Branch, for Oracle 8i and MSDE database platforms.
• Maintenance and customization development of ERMS for Morgan Stanley Dean Witter, for Sybase SQL Server 11 and Documentum DocBase database platforms.