Data Specialist / Reporting Resume
5.00/5 (Submit Your Rating)
Brooklyn, NY
SUMMARY:
- 15+ years of experience in data conversions, data migration and development
- Ability to quickly learn about client business and technology
- Initiative to conceive projects, and dedication to see them to completion
- Expertise in streamlining and improving procedures
- Strong rapport with clients, as primary technical contact for questions and requests
TECHNICAL SKILLS:
Software: Visual Fox Pro, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS), .NET Framework
Servers: SQL Server, Windows Server
Languages: SQL, Visual FoxPro, COBOL
Operating Systems: Windows 7 and XP, AS400
WORK EXPERIENCE:
Data Specialist / Reporting
Confidential, Brooklyn, NY
Responsibilities:
- Fundraising and management software for schools and non - profits
Programmer / Data Specialist
Confidential, Brooklyn, NY
Responsibilities:
- Fundraising and management software for schools and non-profits
- Proposed and implemented a robust suite of data integrity checks (SQL and VFP) for use before and after data conversions.
- Scripts are used across hundreds of projects, discovering 50-200 errors per project
- Early error detection reduces debugging time by an average of 10 days per conversion
- Optimizing and upgrading scripts as new use cases are discovered
- Designed and implemented an in-house help desk system
- Tracks all communication between support and developers, including customer calls, tech support incidents, client modifications and upgrades
- Used by employees in every department to service over 300 clients
- Has handled over 200,000 calls to date
- Enhances communication between management, developers, clients and support
- Developed custom data entry screens and reports to client specifications
- Proceduralizing the conversion of data into proprietary company system
- Migrating data from a wide variety of DBMSs and file types including FoxPro, SQL Server, Pervasive, Microsoft Access, CSV and Excel files
- Researching numerous current and legacy client systems to facilitate conversions.
- Immediately applying research and analysis to quickly and accurately convert data
- Interviewing clients to gain knowledge of business procedures
- Automating migration of client data from legacy FoxPro system to SQL Server based system
- Building a library of scripts, functions and utilities to aid in the conversion and migration procedures
- Developed a process to synchronize legacy FoxPro application, SDP and our SQL Server based 360 Solutions Suite for clients that were partially converted to our new system
- Managing up to 20 client projects per week
- Supporting and advising level-1 support technicians
- Collaborating with clients to define and refine requirements
Programmer
Confidential, Flushing, NY
Responsibilities:
- Maintained the billing and accounts receivable system written in COBOL
