Alex Gorman's Email

Developer @ Database , ETL Developer From January 2015 to Present (1 year) Senior Application Systems Analyst / Data Warehouse, BI Developer @ From March 2011 to January 2015 (3 years 11 months) Providence, Rhode Island AreaDatabase Developer, Analyst @ Implemented new and modified old SQL stored procedures used for reporting, ETL, data validation and data maintenance in investment management, property management, accounting and trading databases; provided database back-end support for accounting and asset management groups, Implemented SQL scripts for data migration, testing, system upgrades, and custom systems' improvements Developed new and modified and improved old reports using SSRS 2005, 2008; designed and implemented complex reports that included multiple data sources, dynamic parameters, custom code, charts, drill down, drill-through, matrices, complex calculations, conditions and groupings; generated queries and stored procedures that source the reports; collaborated with Accounting, Business Analyst and Data team members in identifying needs, purposes and requirements for reports; fully managed SSRS 2005 and 2008 servers including security, data sources and report subscription; upgraded SSRS 2005 server and all reports to 2008 version Developed new, modified and upgraded old ETL processes using SSIS 2005, 2008, DTS 2000 and SQL Performed database administration, user access, backup and restore; troubleshot database performance issues using SQL Server Profiler and SQL and Windows logs; installed and configured multiple SQL Server 2000, 2005 and 2008 environments; configured and maintained compliance monitoring using Idera SQLcompliance tools; worked with other team members in disaster recovery design and implementation, performed DR tests Designed cubes and dimensions including time dimensions using SSAS in the development stages for the new data warehouse that is populated from multiple databases including Yardi, IMIS, Debt System, PTS From June 2007 to March 2011 (3 years 10 months) Intern, Junior DBA @ From January 2007 to May 2007 (5 months) Intern, Database Developer / DBA @ Used Oracle Application Express to develop databases, database models and reports for the ongoing research and requirement gathering for new systems development Used SQL Server Management Studio to create ad-hoc queries and reports for segregating and analyzing patient health records; worked with DBA/manager in gathering requirements for new database that would be maintained on site and be populated from the off-site vendor location using third-party ETL solutions Used SQL Server Import & Export Wizard to migrate an MS Access databases to SQL Server. Researched and documented data models from old unsupported systems and worked with DBA in developing ETL solutions to export data to Oracle or SQL Server databases From January 2007 to May 2007 (5 months)

Bachelor of Science, Computer Science, Mathematics @ Rhode Island College From 2002 to 2007 Bachelor of Science, Computer Science @ Rhode Island College Alex Gorman is skilled in: Seniour Application Systems Analys - Lifespan Corporation, SQL, Microsoft SQL Server, Data Warehousing, SSRS, SSIS, SDLC, Databases, Database Administration, Access, Oracle, ETL, Business Intelligence, Requirements Analysis, Requirements Gathering