Sql Dataanalyst Resume
4.00/5 (Submit Your Rating)
OhiO
TECHNICAL SKILLS
- VB.net
- V/S 2005
- SQL Server 2000/2014
- Visual Basic 6.0
- Analysis/Design
- UserHelp
- Computer setup
- SAP Business One
PROFESSIONAL EXPERIENCE
Confidential, Ohio
SQL DataAnalyst
Responsibilities:
- Modify SQL queries extracting data from InfiniteCampus
- Create new SQL queries for reporting from InfiniteCampus
Confidential
Full Stack WebDeveloper
Responsibilities:
- Internal windows applications supporting the production VB6 main processing system Internal/external S/A providing Client with Invoice detail files using Excel to report Internal S/A executable inspecting Client returned files for any changes or additions Created several functions to auto - email Excel reports to Clients from a DailyRoutineConsole using timers
- Created several functions, within the first bullet point, to auto-email reports which the Client would modify and then return for import
- SQL Server 2000 & 2014
- Application/User/System support and computer setup
Confidential
Application Developer
Responsibilities:
- Consulted with Confidential Inc) through RcCrafters
- Designed and programmed add-on screens for SAP Business One utilizing VB.Net, SQL Server and SAP Business One objects
- Designed and programmed custom SAP Business One/VB.net standalone executables
Confidential
Client Server Developer
Responsibilities:
- Reporting tool for Demand Management (VBAScript/Excel/SQL Server)
- Content Management tool for Direct Sales (Visual Basic/Oracle)
- IDE project reports for Engineering (Visual Basic/Excel/SQL Server)
- Econnect online ordering system for Direct Sales (JAVA Servlet/SQL Server)
- CallPlan tracking system support/modifications for Independent Retail (JAVA/SQL Server)
Programmer
Confidential
Responsibilities:
- Required skill sets included Visual Basic 6.0, SQL Server S/P’s and triggers with responsibilities including analysis, design, development, implementation, testing, and internal user training
- Inserted selections made by the Model Experts from the Calico software into a SQL Server database using the proprietary Calico language CAIT
- Transferred data across a gateway into the AS400 using triggered S/P’s
- Built ancillary Visual Basic programs providing additional functionality to the Calico software that included using Crystal Reports for data presentation.
- Developed means to have mobile users utilize the system disconnected from the network
- Provided on-going support for users and executed functional upgrades