System Analyst/sql Developer Resume
Ny New, YorK
SUMMARY:
- More than 8 years of experience as a computer technician, a system analyst, database programmer and a software developer. I have a strong background in user and support documentation.
- Experience in major programming languages, operating systems, hardware, software, web design and programming.
TECHNICAL SKILLS:
Programming Languages:: C#, C/C++/.NET Framework, VB, MS Access and Excel VBA and Java
PC Software: Microsoft Office suite (Word, Excel, Access and PowerPoint)Graphics: Photoshop, Illustrator
Database Management and Statistical Systems: MS Access, MS SQL, MySQL, Crystal ReportsAnd Oracle
Web Development: XHTML, DHTML, Java Server Pages, Macromedia Dreamweaver MX and Fireworks, Net Object Fusion 8. and Microsoft Front Page
Operating Systems: Linux, UNIX, Windows NT 4.0, Windows 2000 and server, Windows XP, (testing Windows 2003 Server) and Novell
PROFESSIONAL EXPERIENCE:
Confidential - NY, New York
System Analyst/SQL developer
Responsibilities:
- Work closely with the Enterprise Systems Architect, Database and SharePoint Support and Network Supportgroup as 3rd party development consultants - Investigate and resolve application functionality related issues and provide first level support and assist in troubleshooting software application issues.
- Provides assistance and advice to business users in the effective use of applications and information technology.
- Write technical procedures and documentation for the applications including operations, user guide, etc.
Skills and Tools include: MS SQL - SQL programming ; SQL scripting, stored procedures and functions, Sharepoint support.
Confidential - Boston, MA
Software Engineer/UI Dand SQL Developer
Responsibilities:
- Design and develop applications - developed a replacement application, to replace an off-the-shelf application; analyzing project requirements, attend design meetings
- Platform MS Access 2010
- MS Access (VBA) - Developed User Interface.
- MS SQL Server 2008- database (creating tables, stored procedures and functions).
SSRS - MS SQL server - Reporting services - Designing and creating reports
Confidential - Guildford, CT
Software Engineer/Sql Developer
Responsibilities:
- Design and develop applications - involved in the development of the company’s member portal 5.0; collect and analyses project requirements. Attend/schedule design meetings. Platforms; VS 2012 C# and Microsoft SQL 2012.
- VS 2013 - C# - involved in;
- Creating and supporting Excel AddIn client to consume a Service for data capture
- Creating and supporting WCF Service to be consumed by Excel AddIn for the purpose of collecting data from Excel templatesSupporting the client web portal - (MVC) use of angular, jQuery and CSS
- MS SQL 2012 - involved in;
- Creating databases, schemas, tables, user defined tables, T-SQL queries, functions and stored procedures
- Creating and supporting SSIS Packages for ETL to data warehouse and creating cubes and SSRS reports
- Database optimization - adding indexes, SQL query tuning to increase query performance. Identifying performance bottlenecks by using SQL profiler and SQL Query Analyzer. We also use DBCC commands (esp. DBCC SHRINKFILE) to optimize log files.
- Disaster Recover - create backups and recovery plan.
Confidential - Windsor, CT
Project Integrator
Responsibilities:
- Read, analyze and interpret project specifications and designs. Attend/schedule design and other (progressive) meetings for the purpose of developing an ALCMS (Airfield Lighting Control and Monitoring System) as specified by the customer.
- Design and develop supporting databases for our main backbone software DCCMS (Distributed Computer Control System)
- Responsible for creating System Test Procedure (STP) ; System testing and Factory Acceptance Test: The system goes through several tests during development, mainly database and graphics. Before commissioning the project, the system goes into rigorous tests. Testing the graphics accuracy, system response to commands, the system reporting mechanism and response to the visibility levels as specified by the customer. This also includes hardware testing.
- Being a focal point in front of the field engineers, supporting them during commission of projects. Make sure all issues in the punch-list have been taken care of, fix issues as they come and direct others to responsible personnel and always follow-up until completion. Simulate and verify that the issue has been fixed before sending a patch to the field engineers.
- Responsible for the making sure that the accompanying documentations is completed and approved for submission to the customer.
- Commissioning and commission support: Sometimes am required to the commissioning; this involves installing of the product and the client’s users. Most times I support the field engineers who do the commissioning.
Confidential - Glastonbury, CT
Senior Software Developer
Responsibilities:
- Design, develop and implement the Aftermarket Invoice Management System, at International Aero Engines (IAE) in East Hartford.
- Involved in the designing and development of a Work-scope Management tool. Provide support to users.
- Responsible for the design or architecture documentation, describing the construction environment and principles used in developing the tools/systems. Documentation of the development code, algorithms, interfaces, and APIs. And the production of manuals for the end-users.
- Designing and implementing SQL data auditing mechanism to validate the input data before analysis. Responsible for backups and mitigations processes.
- Involved in the production of ad hoc report requests.
- ETL - Data extractions from various sources and load it into Excel, Access or SQL database. This involves designing and development of automation tools and VBA (MS Excel and MS Access) programming
Confidential - Oakdale CT
Senior Technician, Asset Administration and Data Base Management
Responsibilities:
- Designed, developed and implemented an inventory tracking system for asset management, data storage and analysis.
- Provide first-level asset tracking/hardware support compliance and auditing for support to various vendors
- Track, report hardware receipt, delivery and placement status, maintain and deploy local spare pool pulled from order overages, coordinate with offsite storage facility personnel to ship stored equipment, update the Service Center, a workflow tracking tool.
- Train technicians on use of new programs and equipment\devices.
Confidential - New London CT
Systems Analyst, Facility Management
Responsibilities:
- Designed and implemented a Service Call Management tool, that increased efficiency in call management and task scheduling.
- Evaluated and/or recommended purchases of computers, network hardware, peripheral equipment, and software; provided technical support regarding use of computers and networks to satisfy business needs.
- Designed and implemented an imaging system for ghosting classroom computers, which proved to be time efficient and cost effective.
- Designed Confidential of New London’s website that made it possible for online registration, course scheduling and .
- Constantly checked data entered into system by online users to ensure consistency.
Confidential
Computer Technician
Responsibilities:
- Installed, configured and upgraded operating systems and software.
- Installed, assembled and configured computers, monitors, network infrastructure and peripherals such as printers, scanners and related hardware; pulled cables and rewired or directed the rewiring of cables as required for new installations and office reconfiguration.
- Performed troubleshooting problems with computer systems, including troubleshooting hardware and software, e-mail, network and peripheral equipment problems; made repairs and corrections where required.
- Assisted with the planning, design, research and acquisition of new or upgraded hardware and software systems; maintaining current knowledge of hardware, software and network technology and recommended modifications as necessary
Confidential - Willimantic, CT
Research Assistant
Responsibilities:
- Checked, verified and edited data coding to ensure compatibility with data entry system and procedure requirements; interacted with department representatives to resolve routine data coding problems.
- Entered data into a computer database and/or spreadsheet application for subsequent analysis. Retrieved information in prescribed format, utilizing various analytical and statistical software packages, to assist with routine data analysis and interpretation.
- Created, maintained and made purges to specified data files and logs as required; made individual and/or mass corrections, modifications, and/or updates to data files as appropriate.
- Designed and implemented the department website on which extracted information was released and published according to specified criteria and in strict compliance with established policies, procedures and/or regulations.
- Assisted in the writing, editing and production of research reports.
Confidential - Fairfield, New Jersey
PC/LAN Analyst
Responsibilities:
- Local Area Network Administration, e-mail system maintenance and PC-user support
- Performed system maintenance, by working with Server Engineers to ensure reliable 24/7 operation.
- Installed, configured and maintained personal computers, Novell networks, UNIX workstation, file servers, Ethernet networks, cabling, and other related equipment, devices, and systems; added or upgraded and configured modems, disk drives, printers and related equipment.
- Performed installation and upgrades; maintained site licenses
- Was involved in planning and implementation of network security, including building firewalls, applying cryptography to network applications, managing host security, file permissions and file system integrity, and adding and deleting users.
- Performed troubleshooting network, systems and applications to identify and correct malfunctions and other operation difficulties.
