Surveillance -actimize Programmer Resume
Washington, DC
TECHNICAL SKILLS:
Programming: - Actimize, MS Office, Excel and VBA (Advanced), .NET, SQL, MySQL, SSIS, SharePoint, Crystal Reports
Engineering: - Matlab, Mathematica, PSpice, Assembly language, C++, Map Info, IDAII, Bluerose, DBPlanner
PROFESSIONAL EXPERIENCE:
Confidential, Washington, DC
Surveillance -Actimize Programmer
Responsibilities:
- Responsible for development and maintenance of Surveillance models using the Actimize platform.
- Successfully analyzed and enhanced Actimize model, allowing for future custom changes and a 50% reduction in processing time.
Confidential, Columbia, MD
Data Analyst /VBA Developer
Responsibilities:
- Designed and implemented a windows forms solution for Confidential data testers
- Hammered out business requirements, workflows and logic with Ops team and end users
- Iteratively designed GUI interface to end user acceptance
- Successfully converted business logic into VB code
- Delivered the project 1 week ahead of 3 week schedule
Confidential, Rosslyn, VA
SQL/.NET Developer
Responsibilities:
- Designed and implemented FBR RMBS Risk Analytics system for portfolio managers and traders
- Integrated data sources using Bloomberg API, Loan Performance, Intex and Geographic Census data.
- Designed Winforms GUI layout and integrated 3rd party Flash and XML charting components.
- Created XML wrapper for datasets returned from SQL Queries.
- Developed and maintained all supporting SQL stored procedures and indexes.
- Converted Credit Defaults models from SAS to VB.NET
- Responsible monthly ETL processes for Intex and Loan Performance Databases using SSIS.
- Business Technical Services
- Responsible for managing Microsoft Sharepoint Portal for Investment Banking group.
- Responsible for ETL processes for Microsoft CRM in Development and UAT environments.
- Developed DTS using Scribe and other 3rd party Excel Addins in transitioning data from legacy systems
Confidential, Rockville, MD
Data Analyst /VBA Developer
Responsibilities:
- Responsible for developing new taxonomies for XBRL standard
- Responsible for Quality Assurance of EdgarPro XML API
- Developed VBA applications to display XML output from API calls to significantly reduce QA cycles and unearth underlying technical and logical faults in the XML API Web Service calls.
- Work with Operations team, DBA and Programmers in creation of new stored procedures and successful execution of new releases.
- Developed Proof of Concept VBA application to automatically match electronically filed amended SEC Section 16 documents to their original filings with a 90% accuracy rate.
- Developed a proof of concept automated system for parsing all Edgar Form 4 filings for data anomalies, and provide automatic edits where possible and necessary to reduce manual labor cost and intervention as well as to increase data integrity.
- Assisted in developing a new XBRL taxonomy for Moody’s to process international SEC filers.
- Currently working with DBA to assess root cause discrepancies on new data feed and the subsequent proposal of solutions
Confidential, Reston, VA
App Development -VBA Developer
Responsibilities:
- Responsible for supporting and developing Trading Decision Support Applications.
- Integrated web data from Briefing.com into Portfolio Management Support Tool.
- Debugged any technical and logical issues from current tool.
- Responsible for working alongside Fund Managers to implement trading ideas.
- Responsible for reducing System Development Lifecycle.
Confidential, Washington, D.C
Quality Assurance, Business Analyst
Responsibilities:
- Global Applications Team - Performed Quality Assurance and Stress testing on applications which improved test script performance by 50% improving throughput and reducing testing time
- Application development (Excel, VBA, .NET) - Managed information gathering, interviewing department points of contact. Managed the design of the user interface ensuring end-user expectations were met.
- Used VBA and Windows Forms control to create front end to the Configuration Management Database stored in Microsoft Access.
- Used TextBoxes, Labels, and Button controls to display database information on Windows Forms and enable navigation between forms.
- Used Databinding to ensure valid User Input and Arrays to structure data
- Used Server Explorer window to establish connection to the Access database.
- Worked along with Access developer to structure and prototype queries in Excel that was then developed in SQL. For example using V / HLOOKUP statements, Conditional IF, Then, Else, and VBA macros.
Confidential, Manhattan, New York
(Internship) Investment Banking Analyst
Responsibilities:
- Performed pro forma company analysis and created accretion dilution models for M&A pitches to prospective clients.
- Performed financial modeling and created Excel macros for scenario analysis.
- Worked alongside Associates and Managing Directors in developing Committee Memos, conducting client interviews and other procedures involved in the IPO process
- Compiled information for Public Information Books, and Pitch Books used in customer acquisition/business development
- Edited and distributed the Technology Weekly Update researching the latest news in technology from financing to merger and acquisitions using Bloomberg terminal.
Confidential, Rockledge, M.D
(Internship) Radio Frequency Engineering Intern
Responsibilities:
- Worked closely with RF engineers in developing networking optimization solutions in the roll out of 20 new cellular sites.
- Performed search scrubs, analyzed potential candidate sites, and worked with contractors on zoning issues concerning site acquisition.
- Troubleshooting Network problems using tools such as Neighbor List grooming and candidate analysis in Handoff failures, Propagation and Model tuning.
- Performed Drive Testing of the network and analyzed Drive Test data to ensure potential cellular site candidates met performance criteria.
- Maintained databases of cellular site statistics for the Washington, Baltimore and Virginia region. Reports from which helped to determine how effective network optimization improved call quality.