Software Engineer Data

Thomas Galella

**** ******* ******, *******, ** *1793* Home 516-***-**** * *************@*****.***

Professional Summary

Motivated Information Technology professional with expertise in the development and support of a variety of systems within the Financial

and Investment Industries. Solid experience using the Microsoft Business Intelligence suite of products in observation of business rules to

effectively meet end user needs and accurately warehouse data. Skilled in creating tables, stored procedures, views and functions via MS

SQL. Extensive knowledge in creating drill down reports, parameterized reports, linked reports and sub reports via Microsoft Reporting

Services (SSRS). Proficient use of Extract Transform and Load (ETL) tools via Microsoft Data Transformation Services (DTS).

Technical Skills

Development Tools

MS SQL Server Management Studio 2005/2008, MS SQL Server Reporting Services (SSRS), MS SQL Data Transformation Services

(DTS)

Vendor Software

SalesForce.com (CRM), SalesLogix (CRM), Interaction(CRM), SS&C Pacer (Accounting), Advent APX (accounting and performance),

SS&C Sylvan (Performance), Bloomberg Trading Platform (trading), Bloomberg Gateway (Market Data), Advent Moxy (trading)

Databases: MS SQL Server 2005 /2008, Operational Data Store (ODS)

Experience

RVM Incorporated, New York, New York Aug 2013–

Present

Database Developer\DBA

Developed backend process for new in house e-discovery software to export document files effectively, ensuring the integrity of

•

the data to be loaded into upstream system.

Optimized current functions and procedures via more efficient coding methods, elimination of dynamic sql when possible and

•

applying proper indexing.

Monitor and troubleshoot database issues by identifying blocking and slow and expensive processes. Solved often by

•

defragging, re-indexing and shrinking logs.

Support of demanding and large user population processing multi-terabytes of data per project 24-7.

•

Allianz Global Investors Capital, New York, New York May 2005

– July 2013

Senior Software Engineer

Developed month end processes via Transact-SQL stored procedures, views and user defined functions to deliver Institutional

•

Fund characteristics, market values and cash flows to US Corporate Center.

Designed numerous Data Transformation Packages (DTS) to transform data from multiple sources during various systems

•

conversions over the years.

Monitored nightly market data extracts into data warehouse from Bloomberg Gateway application.

•

Implemented and monitored multiple data feed processes to FTP end of day trade information to custodial banks and vendors

•

via Data Transformation Packages (DTS).

Implemented and monitored nightly feeds from the accounting, CRM and product master systems to warehouse data in the

•

Operational Data Store (ODS).

Developed SQL stored procedures and wrappers to vendor procedures to extract and deliver monthly performance figures to the

•

home office in Germany.

Experience (continued)

Alliance Bernstein, Secaucus, New Jersey Jan 2000 – May 2005

Software Engineer (Aug 2004 – May 2005)

Supported and customized FundStation, a client/server application used to collect mutual fund pricing data, calculate

•

performance figures and distribute reports.

Developed reports according to user specifications via Crystal Reports against a Sybase database.

•

Oversaw nightly processing to ensure inbound files are received in a timely manner, processed properly and outbound files

•

are delivered according to the SLA (Service Level Agreement) for domestic and offshore funds.

Senior Mainframe Software Developer (Jan 2000 – Aug 2004)

Built, enhanced, and modified brokerage statement processing systems by effectively designing programs, jobs and stored

•

procedures to meet client specifications and deadlines.

Communicated effectively with data suppliers, printing companies and outside clients to review project progress and

•

validate customer requirements.

Resolved program Abends and production issues in a timely manner while on support of month end brokerage statement

•

and daily Global Access Card processing.

Coordinated and prioritized multiple projects to meet client deadlines. Built, implemented, and monitored various user

•

reports for internal Cash Management group.

Andersen Consulting, New York, New York May 1998 – Jan

2000

Programmer/Analyst (Long term consulting project at J.P. Morgan)

Developed test environments to ensure a smooth conversion to the new Euro currency for Legacy General Ledger system.

•

Designed testing schedules via Control-M according to user specifications.

•

Coded, tested and debugged Cobol programs used in EMU parallel testing.

•

Analyzed and documented results of tests to ensure proper conversion from participating European currencies to the new

•

Euro currency.

Communicated testing results to production team, as well as domestic and overseas user population.

•

National Discount Brokers, New York, New York Aug 1995 – May 1998

User System Support/QA (June 1997– May 1998)

Communicated as a liaison between Trading, Trade Support, and Technology departments to minimize trading

•

discrepancies

Updated securities database to reflect initial public offerings, new option listings, symbol changes and deletions.

•

Researched and resolved orders rejected by newly developed trading and order entry system.

•

Trading Representative (Aug 1995 – June 1997)

Processed stock and option trades for active day traders.

•

Evaluated accounts to ensure compliance with margin requirements, client cash availability and Securities industry

•

regulations

Education

Baruch College, New York, New York

Mainframe Computer Programming Certificate

St. John’s University, Jamaica, New York

Bachelor of Science, Business Management

Licenses

Series 7 (expired) and 63 (expired)

Contact this candidate