Experience

Dealogic

• United Kingdom
• Financial Services
• 100 - 200 Employee

• Senior Systems Integration Analyst

  • Dec 2015 - Present

  • Develop complex data integration programs (SSIS). Integrations include: API to API, API to Feed File, Feed File to API and standard data transfers. • Meet with major banks/investors to determine needs and integration solutions. Solutions include scoping API/Data elements, throughput limitations, goal and current standings identification, project plan drafting, data investigation, resource recognition etc.) required to integrate company systems with clients' internal systems. • SQL Scripting, including functions, procedures, indexing, try/catch, performance tuning. • Develop integration solutions using industry leading CRM provider API methods. • Work with .NET, ASP.NET, XML, SOAP/REST and Sybase/Microsoft SQL Server using Visual Studio as the development tool. Establish and adhere to technical standards and guidelines in all forms of development, testing, and implementation. • Troubleshoot client production issues related to custom features and data feeds. • Engage all key stakeholders, contributors and business and technical resources to have same expectations and ensure business requirements are completely satisfied.



General Medical Services

• United States
• Facilities Services
• 1 - 100 Employee

• SQL Developer

  • Apr 2014 - Nov 2015

  SSIS Development - • Developed integration packages to transform nightly flat file exports from clients using combination of SQL programming and SSIS tools (e.g. lookup, fuzzy lookup, slowly changing dimension, derived column, etc.). • Programmed SSIS to record integration errors in separate tables for integration issue monitoring, reporting and resolution purposes. SSRS Development - • Developed customer subscribed reports with automated email and ftp delivery. • Developed internal process monitoring reports to alert team/company of critical SSIS success/fails. • Using integration error tables, created data driven reports automatically emailing alerts to both customers and team of data issues. • Responsible for creating all internal and customer reports (On demand, Ad-Hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc.). SQL Development - • Wrote complex Functions and Stored Procedures to create OOP design in SQL. • Performance tuned legacy SQL code to reduce time required for data analysis. • Responsible for all SQL data extraction and aggregation requests.



Macmillan

• United States
• Book and Periodical Publishing
• 700 & Above Employee

• SSRS/SQL & SharePoint Developer

  • Jan 2013 - Mar 2014

  SSRS Development - • Develop self-serve SSRS reports for all departments of the approximate 2,000 employee firm. Most reports requiring connecting multiple databases and database platforms (e.g. SQL various collations, MySQL…). • Produce SSRS reports that allow for run-time database switching, (i.e. same report can be ran on Staging, QA and Production/Live via parameterize choice, thus allowing for precision data comparison). • Maintain and re-design legacy Crystal Reports, ensuring perform to specification during database/application upgrades. SQL Development - • Develop all necessary SQL queries, views, stored procedures and functions. • Provide cross database SQL development via use of Linked Servers and Dynamic SQL. • In small time window, develop extraordinary knowledge of various database elements and determine best practices in connecting data. SharePoint Development - • Provide analysis to identify best methods of automating serial and parallel business processes. • Create and Publish SharePoint workflows to structure data submittal/collaboration/reporting. • Create various SharePoint sites to integrate SSRS reporting and collect necessary business data. • Design workflows to assist in data delivery (i.e. Package subscriptions). • Create various SharePoint web parts using Visual Studio 2010/2012.



MSCI Inc.

• United States
• Financial Services
• 700 & Above Employee

• Microsoft Office & SQL Developer

  • Jun 2011 - Dec 2011

  • Repaired/Re-Developed Excel Add-in Hedge Fund Usage/Billing Application using a combination of SQL and VSTO. • Improved performance of application by writing SQL stored procedures and replacing inefficient VBA data transactions with calls to SQL stored procedures. • Provided Data Analysis to determine ways to best combine hedge fund/securities data usage and client specific contract fee data. • Acted as liaison between various departments - Client Services, SQL Development, .Net Development, Database Admins and Executive Management to help each department better understand each other’s needs and how best to improve the overall accuracy and delivery of billable usage information. • Developed strong understanding of Client Contracts, Risk Management Database and the Business Logic of various internal companies, providing an ability to discover and repair areas of billing loss and cost over-runs • Assisted MIS/Finance Team in developing the schematic for scaling the Usage/Billing Application to the needs of the growing firm and the combining of internal businesses.



BBC Studios

• United Kingdom
• Broadcast Media Production and Distribution
• 700 & Above Employee

• Microsoft Office / SQL Developer & Report Writer

  • 2008 - May 2011

  Select Accomplishments Include: • Served as MS Office Developer using Access, Excel/VSTO & SQL. • Conducted Data Analysis and Needs Assessments to define application specifications and project schedules/timelines. • Re-Developed several stand-alone MS Access financial applications to MS Access/VBA with SQL backend. • Designed and developed employee bonus application to reduce manual input and provide automatic archiving of historical data, streamlining annual bonus process and providing output easily uploaded into SAP system. • Crafted reports with multiple sub-reports using Crystal Reports, MS Report Builder /SQL Reporting Services • Wrote SQL stored procedures to extract data from Ceridian payroll system.



OTC Markets Group

• United States
• Financial Services
• 1 - 100 Employee

• SQL Developer / Crystal Reports / Data Analyst

  • 2007 - 2008

  Select Accomplishments Include: • Functioned as developer for inter-dealer electronic quotation and trading system in the over-the-counter (OTC) securities market. • Enabled immediate access to financial reports, which previously took ten (10) days to generate. • Developed and seamlessly integrated accounting reports using data from multiple sources (SQL/Informix) into C#/Asp.Net accounting application. • Cultivated immediate understanding of database(s) table structure and accounting needs. • Wrote complex SQL stored procedures for report(s) data-sources as well as SQL DTS (data transformation services) packages and programmed automated SQL Jobs to transfer/convert data from Informix to SQL. • Wrote complex Crystal Reports (v. 9, v.XI and v. 2008) with multiple sub-reports to assist CFO and controller. • Recreated legacy PowerBuilder reports in Crystal Reports formats.



URS Corporation, An AECOM Company

• United States
• Civil Engineering
• 700 & Above Employee

• Senior Developer / Data Analyst

  • 2001 - 2007

  Managed a variety of projects for Fortune 500 engineering consulting company. Selected projects include: • Lead Developer, World Trade Center Downtown Restoration Project, New York, NY: Provided application development services to analyze cost data on multibillion-dollar redevelopment of NYC World Trade Center and Transportation Hub. Designed and implemented web-based timesheet application for in-house and remote users. Developed SQL Server/VB/ASP.net application to track and certify cost of time, materials, and equipment. • Senior Developer, Application Architect, The Port Authority of New York and New Jersey, Goethals Bridge Modernization Program, New York, NY: Delivered application development services on $1 billion bridge replacement program. Developed and implemented timesheet application to record man-hours on project to facilitate cost management. Utilized a SAP SDK to develop module to transfer time/cost data to SAP system seamlessly. Developed and implemented VB.net scheduling application to integrate engineering, design, and EIS schedules. Installed, configured and developed Microsoft SharePoint applications, including team document development workflows, creating collaborative environment for engineers, designers and cost management professionals.



York Hunter, Inc.

• New York, NY

• Systems and Program Development Manager

  • 1999 - 2001

  Select Accomplishments Include: • Developed cost control applications for privately held construction services company. • Crafted programs using VB and C++ to transfer data from legacy accounting system to SQL server. • Designed cost-reporting application combining VB, C++ and Crystal Reports to automate comparison of budget vs. cost data. Select Accomplishments Include: • Developed cost control applications for privately held construction services company. • Crafted programs using VB and C++ to transfer data from legacy accounting system to SQL server. • Designed cost-reporting application combining VB, C++ and Crystal Reports to automate comparison of budget vs. cost data.



Danskin

• Retail Apparel and Fashion
• 1 - 100 Employee

• Systems Administrator / Developer

  • 1997 - 1999

  Select Accomplishments Include: • Monitored and coordinated server and end-user computing for publicly traded company women’s activewear company. • Provided financial/sales reporting and data mining services using SQL server 6.5 with data pipeline to AS/400 database. • Developed secure Visual Basic/Crystal Reports GUI for custom reporting and querying of financial/sales data. Select Accomplishments Include: • Monitored and coordinated server and end-user computing for publicly traded company women’s activewear company. • Provided financial/sales reporting and data mining services using SQL server 6.5 with data pipeline to AS/400 database. • Developed secure Visual Basic/Crystal Reports GUI for custom reporting and querying of financial/sales data.