We provide IT Staff Augmentation Services!

Software Developer Resume

5.00/5 (Submit Your Rating)

Charlotte, NC

Hire Now

SUMMARY:

  • IT professional wif extensive experience in a variety of technical and professional environments.
  • Current specialties include Access/VBA, MS Office, Six Sigma and Monarch. Industry experience includes human resources, health care, consulting, media development and financial services. Skills include extensive end user, supervisory and leadership experience and excellent written/spoken communications ability.
  • Passionate about creating environment where team members are encouraged to grow, develop and actively communicate.

TECHNICAL SKILLS

Operating sys: DOS, Windows 95/98/XP/Vista/7/8/10,OS/400

Languages: VB 6, VBA, SAS, various API’s

Databases: Access 2/95/97/00/03/07/10/13, SQL Server

Spreadsheets: Excel 95/97/00/03/07/10/13

Other applications: Monarch, Crystal Reports, Tableau, SSIS, TOAD,ViewPoint, Squirrel SQL, IBM Data Studio, MS Office

PROFESSIONAL EXPERIENCE

Software Developer

Confidential, Charlotte, NC

Responsibilities:

  • Taking direction from remote consultants, built contract tracking and dashboard/scorecard systems in MS Office.
  • Created processes to extract data from Word docs and import them into Access.
  • Determined how to build text based cross tabs in Access and export results to Excel.
  • Built automated formatting procedures for Excel spreadsheets.
  • Created worksheets wifin Oracle based forecasting tool
  • Downloaded data from teh tool to Excel
  • Developed pivot table based reporting applications wifin Excel
  • Developed Excel and Access - based automation applications.
  • Created queries using Query 400, ViewPoint and Squirrel SQl in billing environment.
  • Researched methods to link DB/400 data to other environments.
  • Determined processing and reporting specifications from upper management.
  • Built time tracking system in MS Access, importing data from bar code scanner
  • Developed documentation and trained users in daily operation.

Data Analyst

Confidential, NC

Responsibilities:

  • Studied daily and other regularly run procedures to determine best practice.
  • Automated processes using MS Office, VBA and SQL Server saving several man-hours per week.
  • Integrated data from several different sources into a single table using date algorithms.
  • Reworked reports from Excel to Access/PDF to improve readability, security and distribution.
  • Built ODBC files to facilitate data synthesis wifin systems.
  • Created automated upload processes to SQL Server using SSIS.
  • Provided technical advice to coworkers and management.

Analytics Consultant

Confidential, NC

Responsibilities:

  • Identify customer needs through identification of business or regulatory requirement.
  • Closely examine processes for possible improvements and efficiencies.
  • Analyze process to determine inputs required, outputs needed and processes to develop them.
  • Create ODBC path to data on Sybase, Oracle or SQL Server when needed wifin appropriate Office application.
  • Develop system using VBA code as needed to integrate Office applications.
  • Create SQL queries to select, extract and modify data from varying sources for reporting and analysis.
  • Provided status and development details to internal tracking database.
  • Deliver to user wif appropriate training and documentation.
  • Integrates data from differing sources to provide seamless reports/dashboards.
  • Modify as needed to accommodate changing business and regulatory needs.
  • Build, as needed, Excel spreadsheets and ran VBA code against them to establish proper formatting.
  • Set up Excel PivotTables wif data fed from Access systems to allow data analysis for self and customers’ use.
  • series of trade fail reports for foreign currency group
  • data quality/exception reporting systems based on user provided criteria
  • data change tracking systems (example: changes wifin a specified trade over time)
  • certificate tracking system for retail CD group
  • reconciliations between varying trading and position systems
  • automated email/faxing to counterparty contacts of a large document broken down by counterparty
  • tracking system to establish if selected employees were meeting corporate compliance PTO regulations
  • automated report parsing and distribution system during large scale system migration
  • extract DTC data, process and allocate DTC repository statements to internal cost centers
  • Tableau dashboards tracking HR PTO and other time off data

Consultant

Confidential, NC

Responsibilities:

  • Took leadership role in managing a critical component of large scale Windows XP migration.
  • Created Access applications to remediate and repair end users’ Access and Excel applications.
  • Modified existing applications to expedite scan and analysis processing.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship