Microsoft Sql Developer Resume
Dunwoody, GA
SUMMARY:
- Flexible, versatile, solutions - oriented entrepreneur with over 20 years experience launching small to medium-sized business ventures.
- Rare combination of software design and programming, business information systems expertise, corporate financial accounting, and business workflow innovation backgrounds.
- 20+ years of database design, implementation, integration, maintenance, transforming, loading, reporting, and analysis experience in a variety of industries and settings
- Researcher-friendly data facilitator who works quickly to gather, clean, and transform relevant data to test hypotheses in a rapidly iterative fashion
- Ability to think “big picture” in data environment design to make data sets easy to maintain, keep them well-documented, and open availability to other research applications
- Always looking out for new data sets and applications that boost and/or stabilize the predictive power of theoretical models
- Critical thinker who loves the process of discovery
- Intermediate-level programmer who can quickly create working prototypes of applications for custom use or as part of a functional software specification for a team of developers
SOFTWARE/SKILLS:
Databases: Microsoft SQL Server (SSMS, SSIS, SSRS, advanced stored procedures, transactions, triggers, ETL), Microsoft Access, MySQL
Geographic Information Systems (GIS): Manifold GIS, Google Maps API (Geocoding), Mapquest API (Geocoding)
Microsoft Visio: flowcharts, database design, UML, system documentation diagrams
Microsoft Office: Advanced User (Word, Excel, Powerpoint, VBA)
Operating Systems: Windows, Android, Some Exposure to Linux
R Statistical Software Programming:
Programming: VBA, Winbatch, T-SQL, studied C# and Java, but given the pace of changes in the field, I have left most coding to staff developers
Accounting Software: Quickbooks, Sage MAS 90 & MAS 200, Navision
Graphic Design: GIMP, Inkscape
EXPERIENCE:
Confidential, Dunwoody, GA
Microsoft SQL DeveloperResponsibilities:
- Designed and built core banking system database for $100 million community bank in 2013, still in use today (G/L, A/R, A/P, Loan Origination & Management, Deposit Management). While building, created conversion scripts from their old core system in six months and successfully converted systems with no material errors over a weekend
- Built and maintained data environment from multiple data sources to support one of the top econometrician/statisticians in the financial industry, resulting in the successful automated approval of over 99% of $1.4 billion in auto and consumer loans with a model that substantially outperforms FICO in client’s market
- Audited and analyzed client data environments for data availability, practices, and changes to each over time, making collection and retention recommendations as needed
- Created web crawlers to extract data from public web sites without a bulk download option
- Created and queried spatial databases to facilitate market analysis (Manifold GIS/SQL Server)
- Specialize in creating functional rapid prototypes using MS Office
Confidential, Atlanta, GA
Microsoft SQL DeveloperResponsibilities:
- Built and populated national database of Confidential and Confidential bank and credit union data to benchmark and measure sales performance across Confidential ’s US market footprint in one month
Confidential, Atlanta, GA
Microsoft SQL DeveloperResponsibilities:
- Worked with campus professors and researchers to develop business plans for commercializing new technologies from Georgia Tech
Confidential, Norcross, GA
Microsoft SQL DeveloperResponsibilities:
- Created business pro formas for a rapidly growing company with CEO/CFO ($20 million annual revenue)
- Created accounting framework and initial operating procedures for new multifamily energy management division
- Researched, evaluated, and implemented optical character recognition (OCR) software and EDI solutions to automate over 60% of data entry processes
- Evaluated the cash control components of internally developed billing software and led teams between I.T., accounting, and managers to design new process and software enhancements
- Completed accounting system conversion and trained new 8-member accounting staff on usage and job costing procedures.
- Created all interfaces to accounting system from other systems
Confidential, Norcross, GA
Microsoft SQL DeveloperResponsibilities:
- Owner, founder of Document Imaging and MS Office Solutions company
- Project-based business with four part-time employees
Confidential, Norcross, GA
Microsoft SQL DeveloperResponsibilities:
- Accounting System Implementation for Software Manufacturing operation
- Barcoded Inventory Control System Implementation, Shipping System Integration/Automation
- Receivables and Payables Management