KN

EXPERIENCE

Confidential

Freight Database Developer

• Design, develop, and implement data warehouse load ETL-Extract, Transform, and Load processes and procedures for an enterprise data warehouse solution.
• Strong database background with skills in working with a variety of database formats, web formats, and RDBMS modeling and design
• Strong technical experience working with and understanding data stored in various database environments including, Oracle, DB2, and PostgreSQL , data analysis, and reporting.
• Strong SQL query, SQL DML, and relational database design.
• Designing interactive map using CartoDB
• Interact with business and GIS users to understand reporting requirements and needs.
• Adept at queries and report writing
• Present complex information in an understandable and compelling manner
• Programming skills for application development in C
• Maintaining quality client relationships, committing to excellence and state-of-the-art practices

Confidential

Application Administrator

• Advance level of knowledge of SQL programming concepts and database technologies, application/systems administration functions, and application development methodologies
• Established and implemented data security procedures and standards within the applications and ensure that they are followed
• Accountable for the availability, reliability, and serviceability of the supported applications
• Design Executive Dashboards in BMC ServiceDesk for the executive managements.
• Experience delivering solutions utilizing the entire Microsoft BI stack SSAS, SSIS, SSRS
• Experience working in a data warehouse environment and understanding of dimensional data modeling concepts
• Coordinate planning, requirements gathering, designing, developing, testing, documentation, and implementation of projects within the applications
• Partnered with Business Analysts and Business Systems Analysts to understand the business processes and determine requirements of supported tools when new project requests or changes to existing projects are submitted
• Interfaced with IT developers, architects, vendors and other technical resources to understand and support application modification and configuration requirements
• Practiced continuous process improvement fundamentals to ensure applications meet business requirements
• Worked with the Training/Communication units to ensure adequate training documentation is created for application users
• Designed and developed application enhancements

Confidential

Senior Information Technologist Business Consultant

• Performed information security policy, procedure, and protocol design, development and maintenance, including policies that affect employees.
• Worked with the Inspector General to facilitate investigations involving information technology.
• Performed information security incident response activities, including discovering and analyzing forensic evidence, and maintaining evidence integrity through proper handling and collection methods.
• Designed, developed and monitored access controls, and assesses their effectiveness and risks in some of our web applications.
• Code database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
• Monitored authentication and authorizations standards controls and implementations, and assesses their effectiveness and risks.
• Performed risk management duties, including pre-deployment auditing and approval of in-house and external-source software, auditing and approval of proposed software and systems changes, and periodic assessment and penetration testing of post-deployment in-house and vendor-supplied software and systems.
• Performed disaster recovery planning and analysis duties.
• Performed security awareness education and training duties, including creating educational materials and media, and evaluating training effectiveness.
• Used Microsoft CRM to design our security inventory model that provides improved data integrity and privacy, and also supports efficient data access for other security officer in different locations of the state, teamwork, and collaboration.
• Used SharePoint 2010 for our risk assessment forms.

Confidential

Environmental Database Manager

• Duties included all aspects of Oracle database administration including performance tuning, Oracle installation and Oracle upgrade, database maintenance, and database recovery.
• Designed, developed, and tuned a Web-based Oracle9i database for our sampling intranet application that is scalable and capable of servicing 1,000 concurrent end-users.
• Extensive experience in relational database administration, design, development and implementation using PL/SQL and other Oracle tools and utilities.
• Member of the Oracle Form and Report in-house built application called ADM Automated Database Management re-engineering team.
• Officially the top source for any ADM problem
• Loading of Status and Trend lab data into OGWIS database using TOAD, SQL Developer, and SQL loader
• Loading site, sample, field, and lab data into the Oracle Database using quest TOAD
• Incorporation of the status monitoring network's random site information and associated reconnaissance information into the database.
• Insurance of foreign keys and constraints to ensure data quality and integrity.
• Worked closely with the samplers to provide ad-hoc reporting.
• Created Database View for users in sub regional offices
• Rewrote existing PLSQL procedures/packages bodies on OGWIS to accommodate sample, field, and lab data as they changes.
• Ensured smooth data flow from OGWIS to the Florida STORET database.
• Interaction of the OGWIS intranet application with the Oracle Database

Confidential

Computer Programmer Analyst II

• Controlled access permissions and privileges, trained users, meet users' access requirements, and resolved their problems.
• Ensured that storage, archiving, backup, and recovery procedures were functioning correctly for the Training Database.
• Maintained in-house Oracle PL/SQL stored procedures for the Training Database
• Planned, developed, and maintained all training tracking done through the Training and Development unit.
• Developed Human Resources Intranet website using VB.Net and C .Net
• Maintained the Human Resources Intranet class ASP website using VB.Net and C .Net
• Provided technical assistance and tuning to the statewide users of a Web-based Oracle9i database backend for the application administered by the Training and Development unit.

Confidential

Web Analyst

• Web design and maintenance, graphic design and manipulation, database design, data entry, and system/network operations.
• Monitored and maintained the daily production of a website.
• Implemented HTML modifications on current pages and assisted with the flow of information for the website production group
• Acted as a liaison between the creative content team and the IT technical team, and developed the technical specifications for the site.
• Troubleshoots tests and oversee the launch of new products, identified challenges, recommended, and implemented solutions.

Confidential

Computer Operator I

• Responded to telephone calls, emails and personnel requests, within determined response time, for technical support.
• Tracked, monitored and followed through issues to ensure timely, courteous, professional, and accurate resolution.
• Loaded equipment with required input and output materials such as tapes, disks, forms etc.
• Started and monitored runs, made adjustments to correct operational problems
• Observed control panels for malfunctions, errors in operation messages
• Maintained operations records such as machine performance and production records.