TECHNICAL SKILLS

Business Applications: EnCase, FTK, Hex Editor, MS Dynamics GP 10, SAGE, iMIS 15, Traverse 10.5, Informz, ExpoCad, MS Office Software

Development Tools: MS SQL Server 2000 - 2012, MySQL, Oracle SQL, SQL 2005/2008 Reporting Services, MS Business Intelligence 2005, Task Centre, Sencha Architect, Sencha Ext JS 4.2, XL Reporter, Visual Basic, Crystal Reports, VBScript, C#, MS Access, Cold Fusion

Project Management: eProjects, MS Projects, MS Visio, Excelerator Case Tools

Graphics Tools: Adobe Photoshop, Adobe Illustrator, Adobe Lightroom Operating Systems Windows 2003/2005/2008 Server, Linux, VMware, MAC OS X, Windows 10

PROFESSIONAL EXPERIENCE

Database Director & Senior Consultant

Confidential

Responsibilities:

• Supporting security and database operations on our SaaS, PaaS and laaS infrastructure and multiple clients that include Suburban Electronics.
• Produced reports based on OPM data from this and previous years on insurance particulars.
• Produced lookup tables, modified existing tables to 3 rd Normal form to get better results during searches, modified next years insurance plans, and extracted vital information from competitors plans and placed in various reports for CEO.

Database Specialist

Confidential

Responsibilities:

• Tasked with overseeing databases seized by an Agent including the examination and reconstruction of system reports. (SQL Server, MySQL, RX30, Oracle, etc.)
• Produced Reports using Excel with relevant data needed.
• Produced Training material and conducted hand-on class for examiners.
• On the committee for automotive forensics.
• Identify areas of improvements in the business process.

Confidential

Senior Manager Developer/Business Intelligence

Responsibilities:

• Interviewed staff and identified deficiencies in business units processes both systemic and human element. Resulting in business process modification recommendations, automation of labor intensive manual processes as well as streamlining user interfaces by utilizing tools like SSRS, Task Centre and iMIS's Customer Service Alert (CSA).
• Performed DBA duties on multiple SQL 2000/2003/2008 servers; which entailed installation of new SQL servers, maintenance, backup/recovery, design (database, queries, views, and functions for web­developer and vendors), add disk space to virtual servers and troubleshooting issues in logs.
• Analyzed and identified anomalies in accounting GL/AR/AP/IN transactions (GP/SAGE) saving the accountants weeks of paper research and analysis. Developed various custom reports to provide analysis where standard reports where lacking such as Trial Balance, Sales Tax report, and Invoices by vender/business units.
• D eveloped advanced IQAs, CSAs, Stored Procedures, queries and views for business units integrating data from multiple applications such as iMIS, MS Dynamic GP, and SAGE.
• Developed cross platform reports utilizing Crystal Report, SSRS, Access and Excel.
• Design and develop mobile app site used by vendor to create mobile app.
• Assisted in developing ASI member portal troubleshooting and maintained C# code.
• Served as Audio engineer to clients renting auditorium space.

Senior Systems Analyst

Confidential

Responsibilities:

• Streamlined the finance department's workflow process by developing MS Dynamics GP systems interface applications and reports, as well as modify business rules pertaining to inter-department and external entities financial transactions.
• Developed and maintained customized Budget reports using XL Reporter.
• Developed, deployed and maintained mission critical reports using SQL Report Services.
• Produced sophisticated spreadsheets that interact with Dynamics GP, Traverse, iMIS and AriettNet SQL tables.
• Performed all DBA duties for finance's Dynamics GP, Ariett and KwikTag servers.
• Customized Dynamics GP reports using native report writer.
• Developed and maintained SmartConnect (eConnect) modules.
• Produced Systems requirements, User's Manual, and documented system process for in-house clients.
• Provided weekly management status report and Gantt chart analysis using MS Projects.
• Delegated and managed consultants during implementation of GP.
• Designed, developed and maintained database schema, stored procedures views, and tables utilizing decision support object design.
• Performed duties of an A/R Accountant when needed (post A/R Transactions, cash flow report, bank reconciliation, etc.).
• Designed and developed user interface to SQL Server
• Developed and maintained enhancements modules to Traverse 10.5.
• Developed stored procedures, which enforced the business rules.
• Data analysis of lockbox transactions.
• Front-end system construction and maintenance using VB or Access.

Software Developer

Confidential

Responsibilities:

• Developed management, financial and membership systems following strict data centric development strategies for deployment within the client's enterprise data architecture.
• Maintained NetWare 4.11 LAN.
• Administered plant network which comprised of four Motorola Sonix servers, two LANtastic servers and 60 data-entry workstations in an around the clock production environment.
• Installed operating system patches and upgrades to servers, along with hardware and software maintenance.
• Trained system administrators, shift supervisors, and data entry clerks.
• Responsible for data entry production.
• Responsible for maintaining data integrity during the transference of the daily data entry queue (into the production Sybase database), process.

Project Manager/Senior Software Engineer

Confidential

Responsibilities:

• Using proven software engineering techniques, responsible for full lifecycle development of business systems applications from system analysis and design through installation and training. Scheduling and cost estimate were accomplished by using Function Point analysis and COCOMO cost model.
• Technical liaison to our NAVY and DOE clients.
• Hands-on manager which duties included: requirement identification, design, development, troubleshooting, maintenance, software documentation (Functional Descriptions, System Specifications, Sub-System Specifications, Database Specifications, User's Manuals, Test Plans and Test Analysis Documents all following both DOD STD 7935A and IEEE standards), testing and evaluation in accordance with Test Plan, installation and End-user training.
• Developed several multi-user xBase, Visual Basic/Access financial and inventory tracking systems as well as mission critical applications using structured design methodologies.
• Kept managers and clients informed with weekly/monthly status reports.
• Duties included administrating performance appraisals, salary appraisals, and staff acquisition for each project.
• Developed project schedules and task assignments for the development team.
• Responsible for I, V&V (Design Assurance) on NCCS's ADA system.
• Developed and maintained ADA code on SUN Sparc station in a multi-programmer environment.
• Performed annual performance appraisals.

Project Leader

Confidential

Responsibilities:

• Responsible for Financial tracking systems development using structured design methodologies through all life-cycle phases which included requirement identification, system design, development, troubleshooting, maintenance, software documentation (Functional Descriptions, System Specifications, Sub-System Specifications, Database Specifications, User's Manuals, Test Plans and Test Analysis Documents all following DOD STD), testing and evaluation in accordance with test plans, installation and training.
• Customer interaction for analysis purposes.
• Designed and produced various status reports.
• Performed annual performance Appraisals, and assisted in staffing acquisition and recruiting.
• Implemented Project schedules and assigned tasking.
• Developed Communication and Financial tracking systems.
• Worked with managers and users to analyze business rules in order to identify system requirements.