Nick Collins
Applications Analyst at Tucker Ellis LLP- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
The Excel Bootcamp: Zero to Mastery
Zero To MasteryJan, 2023- Nov, 2024 -
Excel Charts & Graphs
Maven AnalyticsApr, 2022- Nov, 2024 -
Excel Formulas & Functions
Maven AnalyticsApr, 2022- Nov, 2024 -
Thinking Like an Analyst
Maven AnalyticsMar, 2022- Nov, 2024 -
Microsoft Power BI Desktop for Business Intelligence
UdemyJan, 2022- Nov, 2024
Experience
-
Tucker Ellis LLP
-
United States
-
Law Practice
-
300 - 400 Employee
-
Applications Analyst
-
Apr 2014 - Present
-
-
-
AML RightSource
-
United States
-
Financial Services
-
700 & Above Employee
-
Director of Technology Services
-
Oct 2013 - Apr 2014
-
-
-
Thompson Hine LLP
-
United States
-
Law Practice
-
700 & Above Employee
-
Financial Systems Analyst
-
Mar 2013 - Jun 2013
Managed User Security in the Thomson Reuters Elite system. Responsible for generating reports utilizing SQL that informs all departments of data cleanup, billing, invoicing, client & matter budgeting and records purposes. Created and administered the execution of SQL reports that evaluated the daily, monthly, and yearly budget data. Managed User Security in the Thomson Reuters Elite system. Responsible for generating reports utilizing SQL that informs all departments of data cleanup, billing, invoicing, client & matter budgeting and records purposes. Created and administered the execution of SQL reports that evaluated the daily, monthly, and yearly budget data.
-
-
-
AML RightSource
-
United States
-
Financial Services
-
700 & Above Employee
-
IT Manager
-
Dec 2008 - Mar 2013
Maintain a secure network containing bank data for BSA/AML compliance analytic work. Maintain a secure FTP server environment that receives daily data file uploads from bank industry clients to be imported into BSA/AML analytic software (Prime Compliance Suite and/or Verafin). In addition, I make sure these daily uploads are pushed into separate SQL Server 2005 database instances without error. Assure daily database backup scheme as well as weekly offsite rotation of network backups for data integrity. Support a Thin Client, VMware Network that connects to an offsite data center via a secure VPN Tunnel. Generated high level SQL scripts for reporting, analytical and data conversion purposes via T-SQL, stored procedures and SSIS.
-
-
-
Accellis
-
United States
-
Information Technology & Services
-
1 - 100 Employee
-
Network Consultant
-
Oct 2006 - Dec 2008
Worked with numerous clients to design, implement and maintain Microsoft Windows networks that best fit their needs. Created, scheduled and ran numerous SQL jobs for daily, monthly and yearly reporting. Worked with numerous clients to design, implement and maintain Microsoft Windows networks that best fit their needs. Created, scheduled and ran numerous SQL jobs for daily, monthly and yearly reporting.
-
-
-
-
Network Consultant
-
Nov 2004 - Oct 2006
Designed and maintained small business networks in Microsoft Windows Server environments. Migrated client specific software applications from Server NT 4.0 to Server 2003 environments. Designed and maintained small business networks in Microsoft Windows Server environments. Migrated client specific software applications from Server NT 4.0 to Server 2003 environments.
-
-
-
-
1 Tech Support
-
Mar 2004 - Nov 2004
Provided first level technical support for Point of Sale systems within remote retail stores. Repaired SQL database errors within the Point of Sale systems that caused productivity outages, leveraging remote access options to lower the total cost of downtime for the customer. Provided first level technical support for Point of Sale systems within remote retail stores. Repaired SQL database errors within the Point of Sale systems that caused productivity outages, leveraging remote access options to lower the total cost of downtime for the customer.
-
-
-
-
IT Consultant
-
Mar 2002 - Mar 2002
Assisted client with problems in their DNS and DHCP setups within their computer network. Assisted client with problems in their DNS and DHCP setups within their computer network.
-
-
Education
-
ITT Technical Institute
Associate of Applied Science, Software Application Programming -
North Olmsted High School
Degree, General Studies -
ITT Technical Institute
Associate of Applied Science, Computer Networking Sciences