SUMMARY:

Excellent team player. Capable of working efficiently as an individual. High comfort level with data manipulation. Developer level coding skills; coupled with strong intellectual curiosity, problem solving skills, & attention to detail. Technically - minded, self - starter who can work well under pressure & balance competing priorities in fast-paced, dynamic work environment.

SKILLS:

• Programming: Write computer programs for various purposes
• Complex Problem Solving: Identify complex problems & review related information to develop & evaluate options & implement solutions
• Critical Thinking: Use logic & reasoning to identify strengths & weaknesses of alternative solutions, conclusions or approaches to problems
• Active Learner: Understand the implications of new information for both current & future problem-solving & decision-making
• Judgment & Decision Making: Consider the relative costs & benefit of potential actions & choose most appropriate
• Systems Analysis: Determine how system should work & how changes in conditions, operations, & the environment will affect outcome

SOFTWARE & CODING:

• VBScript / Primal Script
• VBA 6 / 7
• Excel Formatting
• VB.Net
• Excel Advanced Formulas & Functions
• Microsoft Office 00-16
• PowerPoint
• Excel Power User
• Visual Studio
• Semi-Automated Trading Systems
• Python 3 / PyCharm / SQLite
• Java / Eclipse
• Predictive Models
• SQL CRUD
• API’s, Batch Files, Scripting
• Stepwise Refinement
• R / RStudio
• Word / Access / Visio
• HTML / XML
• HP Unified Functional Testing
• Google: Docs / Sheets / Drive
• Dropbox / Box
• Skype for Business
• BaseCamp
• Agile / DevOps / Kaizen / Lean
• Windows NT /XP / Vista
• Windows 7 / 8
• Camtasia Studio 7 / 8
• Fiddler
• Data Recovery, Backup & Restoration
• Adobe Master Collection CS5
• Visual Force
• SolidWorks/AutoCAD
• Mastercam
• G Code / FANUC Controls

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

Data Security Analyst | IT Analyst

Responsibilities:

• Create user-interface for capturing manually entered data & ad-hoc reports
• Develop, maintain & support existing Excel VBA, VB, C#, & PowerShell applications
• Document process along with creating ad-hoc programs to automate manual tasks
• Performed extensive research with technologies (TROUX, SIEM, SERTS, AD & LDAP) & meetings with application owners resulting in an elimination of 20% of the old generic ids & identifying / transferring Owners for Active Directory groups

Confidential, Bloomfield, CT

Business Analysis Manager

Responsibilities:

• Develop, maintain & support existing Excel / Access VBA applications
• Document code along with creating business & technical documents for stakeholders
• Support project managers with their changing requirements & needs
• Execute unit test cases for the new enhancements
• Train employees on how to use the developed applications

Confidential, Windsor Locks, CT

Quantitative Analyst / Data Scientist

Responsibilities:

• Build report interfaces, data feeds, & develop features
• Decipher trends in complex data by applying modeling techniques
• Create user-interface for capturing manually entered data & ad-hoc reports
• Analyze time requirements, optimize code, & refine complex formulas: Reduce latency & memory usage
• Dynamic Advanced Filtering: Incorporated using UNION queries, for searching & reporting; included multiple fields (combo box, textbox, checkbox, listbox) as well as "wildcard" or partial entry fields - used to search description
• Automated & manual assessment of code: Stored procedures ( Archiving, data transformation )
• Gathered & collected information from various sources to provide a data pipeline
• Validate, manipulate, & perform exploratory data analysis on datasets
• Root cause assessment of recurring product quality issues
• Scripting Dictionary ( Script Runtime library / scrrun.dll )
• Automation: Configuration scripts, Infrastructure code
• Test & evaluate new software & methodologies

Confidential, Windsor Locks, CT

Data Analyst / Programmer

Responsibilities:

• Process improvements / code revisions yielded a reduction of generation time by 79%
• VBA Modules include complex Functions to loop thru form controls, VBA code working in conjunction with SQL Statements to manipulate data
• Design pivot table dashboard, front end Excel/user form based application which connects to a back end Access database using SQL & VBA for exporting & importing data

Confidential, Windsor Locks, CT

Data Analyst / Database Developer

Responsibilities:

• Convert Excel Spreadsheets Data Into Access Database Tables. Access Connectivity Engine ( ACE )
• Design & develop tables, relationships, & forms with data validation in MS Access
• Output using Access as well as Object Orientated Application Output to Excel via VBA

Confidential, Windsor Locks, CT

Programmer / Data Analyst

Responsibilities:

• Program web-scraping tools for data acquisition & data mining
• Automation of scripts: data transformation, file system manipulation, archiving & cleanup
• VBA, Windows ( API s ), Windows Script Host ( WSH ), FileSystemObject ( FSO ), ( ASP.NET, JavaScript, HTML, & XML ) VLOOKUP, INDEX, MATCH, DATE & TIME Functions, Evaluate Method, AutoFilter, Conditional Formatting, ListObjects ( Tables ), ChartObjects ( Charts )

Confidential, Windsor Locks, CT

Programmer / Analyst

Responsibilities:

• Create a reporting model using Excel to monitor transaction history & track profit & loss
• Automate web harvesting: Unattended web navigation, login, & data collection IE, Firefox, Opera

Confidential, Windsor Locks, CT

White Hat Hacker

Responsibilities:

• Active Directory, User Privileges, Access account lockouts & password resets
• Password recovery, data backup & migration, PST files, desktop, user settings & favorites
• Network & local printer additions: printer set-up, local printer set-up, default printer assignment, printer maintenance, paper jams, online status, cartridge replacement