Manager Microsoft Office

Daniel L. Chitiea

**** ******* **., ********, **. 30062 ~ 843-***-**** ~ **********@***.***

Information Technology & Business Management

Systems Design, Analysis / Business Administration

Talented, enthusiastic professional supported by educational achievement and hands-on technical experience in high-volume customer-centered environment.

Possess strong troubleshooting and analytical skills necessary to develop/deliver process improvements and seamless operations.

Respected for ability to remain focused during challenging assignments and commitment to achieving corporate and technology objectives.

Proven ability to clearly understand problems before defining and implementing positive solutions

Strong design skills and object oriented development methodologies.

Respected for strong work ethic, dedication and ability to grasp/manage new tasks.

EDUCATION

B.S./B.A. – Management Information Systems, 2005

University of North Carolina at Charlotte

US Navy Operations Specialist Technical Schools - 4 months (40 class hours per week).

SECURITY CLEARANCE: Secret (9/2008-present)

TECHNOLOGY

Programming: Visual Basic (VB).Net, C++, C#, SQL (Structured Query Language), Visual Basic (VB) 6.0, Expertise in GUI development, Winforms, Regular Expression, SSIS, SSRS, PL/SQL

Database: Oracle 9i – database administration, programming, SQL Server, and analysis. Programming, Relational Database Management Systems using Microsoft SQL Server 2000/2005/2008 R2

Other: WebLogic Server 7.0 for building and running enterprise applications and service. Java EE standards based. Control-M, MES, TOAD, JIRA

Office Software: Microsoft Office Suite, Excel, Access, SQL Developer, Siebel, CS Pro, SQL Enterprise Manager, Microsoft Visio, MS-Visual Source Safe, IIS

Environments: Oracle, Enterprise Manager, Microsoft Windows

EXPERIENCE

SEDC Inc. (Southeastern Data Cooperative) (1.2016 - )

Data Analyst –

A member-owned data processing cooperative providing consumer billing (CIS), accounting solutions, Engineering and Operations applications configured to meet our customer’s electric distribution needs.

Based on requirements, authored the programmer specifications for data conversion between dissimilar systems.

Manage and perform data conversion validation using self-created reports, SQL queries and programs.

Conduct detailed data analysis and rigorous testing to ensure the integrity of data during conversion, migration & loading processes.

Troubleshot any issues or problems identified and made recommendations to improve the conversion process to resolve/alleviate issues.

Provide support and communications to the external customers during the entire conversion process.

Support the application through data mining to make sure requirements were met.

Create ad hoc reports to make sure out comes matched customers current data reports from their system. This was used to confirm data transfer was correctly implemented.

All tasks were completed within an Oracle 11g Database environment.

Competency in the Microsoft Office application suite including MS Access and MS Excel.

Competency and knowledgeable with database technology (Oracle 11g).

AT&T Inc. (2.2014 - 1.2016)

Systems Analyst – Issue resolution in TACRFT application. (ATT Customer is always Right Feedback Tool)

TACRFT is a system wide application that monitors customer’s answers to survey questions, to help maintain the high level of customer support at ATT.

Used SQL Developer to resolve/update issues in stored procedure code.

Used RegEx (Regular Expression) to help determine customer’s responses to survey questions, which were sent to them via SMS (Short Message Service).

Developed SQL queries that solved/resolved user trouble tickets and reported problems.

Provide systems analysis and research for problem resolution.

Created and updated stored procedures, SSIS, and SSRS due to change request or better operating procedures.

Supported the application through data mining and excel to research issues and to resolve managers’ requests.

Created ad hoc reports and excel spread sheets per requests from internal customers.

Supported end-user requests for changes, upgrades, and issue reports in TACRFT.

Provided new scripts, SSIS, SSRS, SQL/database queries/change control modifications, and enhancements per customer requests. This required extensive testing in the development environment before migration to the production systems.

Progressive Consulting Technology Inc. (6.2012- 2.2014) (www.progressivex.com)

And

Northrop Grumman Corporation (8.2011-6.2012) (www.northropgrumman.com)

Warner Robins, GA

Systems Analyst – Issue resolution in CRMS application. (Contract Repair Management System)

The CRMS is the organization-wide parts procurement and supplier management process for the United States Air Force. It is one of the largest and most complex systems of its kind. Northrop holds the current support and development contract.

Supported end-user requests for changes, upgrades, and issue reports in CRMS.

Helped issue resolution of CRMS using the User Interface and SQL Developer.

Provided real-time operational and functionality data to CRMS developers.

Developed SQL queries with SQL Server that solved/resolved user trouble tickets and reported problems.

Maintained/optimized Oracle database tables for performance improvement and error resolution.

Used SQL Developer to resolve issues in the program code and updates to the application.

Used data mining and excel for ad hoc reports.

Created reports with SSRS.

Created scripts in PL/SQL to resolve issues in the database.

Dan Chitiea Inc. – Charleston, SC and Waynesville, NC (9.2009 to 8.2011)

Programmer/Developer

Providing various business and technology solutions to customers.

Designed and implemented a program using Microsoft VB.Net language and Access database which greatly assisted the client’s productivity in managing their customers and the clients bills (this program imports information from the Access database).

Designed programs using SQL Server, VB.Net and Winforms to help the client organize their schedule and payments by retrieving their customer’s information, and client’s bills from an Access database.

Created testing and performance summary reports clearly communicating to the client all testing results.

Prioritized defect resolution using an understanding of the business requirements and the needs of the client.

Programs developed consisted of multiple stages of the system life cycle, created reports to the client to help maintain the system (including schematics), and documentation for a user interface guide.

STG International, Inc. (http://www.stginternational.com) – Charleston, SC (9.2008 – 9.2009)

Senior Operations Analyst – U. S. State Department financial systems Operations Team

STG provides extensive IT contract services across industry and government sectors, worldwide. The complex financial systems for the U.S. Department of State include all departmental operating budgets and payroll services for all global departments and locations.

The Operations Team is responsible 24/7 for creating, managing, and maintaining all aspects of job flow, control and execution utilizing extensive server-based automated DOS scripts, batch job streams, and Oracle SQL queries for database management and controls. . The server farms are part of an extensive international Washington, D.C. centric network. All procedures and processes are ISO/9000 compliant and audited.

Specific responsibilities included the following:

Monitored all job streams and command files to ensure error-free operation. Errors and problem resolution was required in near real time to meet overnight processing scheduling requirements.

Provided new scripts, SQL/database queries/change control modifications, and enhancements per customer requests. This required extensive testing in the development environment before migration to the production systems.

Development included highly complex DOS scripts and SQL query usage.

Carried out new customer program/job requests to generate new/additional information reports or to update Oracle database tables.

Provided frequent coordination with international locations (primarily Bangkok) to ensure proper job stream execution and coordination.

Provided on-call, off-hours/weekend/remote support on a six week rotation. Support access via web-based Federal websites.

This was completed in Microsoft Windows, SQL Server, and Enterprise Manager Environment.

Lead, plan, organize and promote weekly meetings, activities and events.

Provide support to Federal Government clients.

Improvement of communications: Liaison to team, clients, contractors and other company personnel.

Direct and perform financial analyses and reporting. Adherence to Federal laws and standards.

ISO9001

AVX Corporation, a Division of Kyocera (http://www.avx.com) – Myrtle Beach, SC (9.2007 – 9.2008)

Programmer/Analyst for Manufacturing Plant Floor Integration Systems

AVX is a global corporation providing active and passive electronic components to major manufacturing companies worldwide. Systems include multi-level integrated systems from corporate mainframe to mid-level LAN-based distributed systems to machine process control systems and computers. All part of a multi-country highly distributed information system.

Within an Oracle 9i database, VB6, .Net, and Winforms programming environment, worked closely and provided Joint Application Development services with engineering and plant operations staff to design, program, implement and support systems in direct, real-time production operations using VB.Net programming and Winforms. Developed middleware to integrate systems with the corporate mainframe.

Resolved issues, created multiple tables and fields, and designed applications that connected and updated, inserted, and deleted in the Oracle 9i database environment.

Used SQL Server to data mine and to resolve issues.

Supported applications using SQL and .Net code to research and resolve issues.

Process operations included multiple metal plating (gold, nickel) lines, quality control, product assembly machines; included work/shop order information management and real-time reporting. Systems included direct interface/integration with production machine process control computers.

Provided daily (7-day) support of systems and automated job streams for local and foreign (Malaysia/El Salvador) operations. Included job stream change/modify/support to maintain database synchronization at all company locations.

This was completed in Microsoft Windows, Enterprise Manager, Visual Basic (VB) 6.0, and VB.Net, Winforms, and in a Manufacturing Execution Environment.

National Diagnostic Incorporated – Charlotte, NC (11.2006 to 9.2007)

Programmer/Analyst Providing Support Services for Mission-Critical Applications

National Diagnostic Incorporated is a leading provider of employee screening services for all industry sectors. NDI information systems are responsible for properly managing and communicating laboratory test results for customers via browser-based applications and using SQL databases. Testing results are confidentiality and accuracy are absolutely essential. Responsibilities and contributions include:

Provide systems analysis and research for problem resolution of incomplete laboratory test results and information.

Utilize SQL/2000 and SQL Enterprise Manager for problem investigation and determination.

Evaluate, test, and analyze system program coding (on the development systems) in Visual Basic 6.0 and VB.Net as part of problem resolution.

Updated and created Oracle 9i tables and fields per customer requests.

Resolved application issues by data mining and research of .Net code.

Changed table relationships to add new tables and keep the normalized to maintain relationship between new applications and the Oracle 9i database.

Monitored imported information to make sure it met data base requirements.

Used SQL/2000 to search for data that did not meet daily business requirements. This was done using standard queries or nested queries to find and fix any issues.

Some issues required using SQL Stored Procedures in the programming language to make sure that the problem would not occur in the future.

Continually updated the data base to make sure it met daily requirements, which made it easier to pull relevant information that senior managers required.

Updated senior managers on any changes that may be needed to the data base and/or any problems that may happen in the future.

Work with client laboratories and NDI management to develop and modify programming VB.Net and C# code and/or database procedures to accommodate lab testing or information process changes. These modifications were done using VB.Net and Winforms.

Communicate frequently, promptly, and clearly with upper management regarding system modifications, testing, and implementation status.

Communicate frequently with system users to make prompt changes in code to meet constant changes in the business environment.

This was completed in Microsoft Windows and VB.Net Environment.

Dan Chitiea Inc. – Charlotte, NC (5.2004 to 9.2007)

Programmer/Developer

Providing various business and technology solutions to customers.

Designed and implemented a program using Microsoft VB.Net language and Access database which greatly assisted the professor’s productivity in grading large quantities of examination scores (this program imports information from the Access database).

Created a website to help students arrange online group meetings, to buy and sell goods, and to communicate with a disk jockey (community portal). Created complete application documentation and a users’ guide for the administration and support of the system.

Designed a program using VB.Net and Winforms to help university students organize their class schedules by retrieving class information from an Access database.

Created testing and performance summary reports clearly communicating to management and clients all testing results.

Prioritized defect resolution using an understanding of the business requirements and the needs of the customer.

Mentored other analysts in the methodology and the software development life cycle.

Programs developed consisted of multiple stages of the system life cycle, reports for Administration to help maintain the system (including schematics), and documentation for a user interface guide.

UNITED STATES NAVY – Pearl Harbor, HI, Yokosuka, Japan (5.1995 to 5.1999)

Operations specialist for new Aegis-Class guided missle destroyer

Maintained secret security clearance

Widely traveled: Persian Gulf, Dubai, India, Australia, Fiji, Japan, China, Hawaii

Served as Air Intercept Controller for helicopters and fixed wing supersonic jet aircraft.

Maintained Combat Information Center (CIC) graphical displays of strategic and tactical information.

Operated sophisticated surveillance and altitude radars (Aegis), identification Friend or Foe (IFF) and associated equipment and systems.

Scope of responsibility was diverse and included managing digital navigation plotters, radio systems, command/control, normal and sound-powered telephone networks.

Supervised an eight-member team.

Contact this candidate