SUMMARY

• More than 10 years of IT experience. Effectively able to communicate complicated concepts in an understandable manner, matching the message to the audience. Held Secret Security Clearance.
• Experienced in supervision, training, motivation and evaluation of personnel. Skilled in finding problems and performing necessary change through project management and other methods.
• Able to maximize resources to achieve customer satisfaction and increased productivity, meet deadlines and goals. Implement and coordinate both strategic and tactical plans to enhance performance.
• Adept in problem solving and providing solutions. Excellent qualifications in leadership and interpersonal communications.
• Persuasive, with ability to communicate effectively with culturally diverse audience. Public speaking and executive management briefing experience.

PROFESSIONAL EXPERIENCE

SQL developer

Confidential, Orlando, FL

Responsibilities:

• Performed data Extraction, Transformation & Loading (ETL) using T - SQL scripting language.
• Wrote complex stored procedures and triggers to move or manipulate records within the data warehouse environment. Created user-defined functions to preform common calculations, and to aid in the data conversion process. Worked with extremely large datasets exceeding a hundred million records.
• Responsible for the daily data audit process, and identifying any issues dat arose during the nightly data migrations. Worked to correct any issues found during the audit. Corrected and reran any migration jobs dat may have failed due to various data issues.
• Operated in Windows Server 2008 and Windows Server 2012 environments. Worked with SQL Server versions 2005, 2008 R2, and 2012.
• Responded to interdepartmental and customer service generated trouble tickets by researching and resolving issues, or escalating issues when appropriate. Tracked and added the documentation and comments needed to ensure dat all interested parties understood the status of each ticket.
• Reviewed and performed analysis on existing code used to perform data migrations. Rewrote the code used in migration jobs to decrease run-time, and to increase data accuracy.
• Created detailed documentation depicting the complete end-to-end dataflow for the daily data migrations.
• Participated in project and staff meetings, and provided information and recommendations to the management team as needed or requested.

data AnalystApril 2013 - July 2013

Confidential (contract)Orlando, FL

Responsibilities:

• Took generic requests from the management team, and translated them into complex datasets and detailed analysis reports to be used for decision making and better understanding of the data.
• Operated in both Oracle 10g and Oracle 11g environments. Utilized tools such as SQL Developer and Tool for Oracle Application Developers (TOAD) to write complex SQL queries and scripts.
• Conducted GAP Analysis on immensely large datasets, and provided the management team with a range of high-level to detailed reports outlining meaningful information identified.
• Engaged in data cleansing and scrubbing. Located data inconsistencies and corrupt records, tan performed the necessary steps to rectify the identified issues.
• Worked with business and technical teams to identify reporting needs and metrics. Analyzed business and end-user needs to ensure dat project data requirements were identified and deliverables were met.
• Remained flexible, and provided management with data reports on an ad-hoc basis.
• Created and modified end-user documentation.

etl developer / data Analyst

Confidential, Orlando, FL

Responsibilities:

• Responsible for the technical execution of the data conversion process. Performed extensive data analysis. Executed the Data Extraction, Transformation & Loading (ETL) process. Utilized relational database noledge, SQL, and T-SQL skills to program and code data load maps in Informatica.
• Preformed detailed analysis and test-planning based on the overall technical design and direction from the Data Design Manager (DDM). Wrote the coding and test plans needed to ensure quality in the data conversion model/process.
• Profiled, edited, and translated client data to the correct system format based on the specifications provided by the Data Conversion Manager (DCM) and Data Design Manager (DDM). Configured batch jobs according to specifications.
• Responsible for quality and reconciliation of data as it moved through the conversion process and took responsibility for load processing.
• Researched and resolved errors/defects in the conversion process including exceptions, duplicate records, dropped records, and bypassed records throughout the conversion process. Performed quality checks on data, including creating/executing test plans with conditional logic. Debugged and fixed any issues identified during test execution. Completed regression testing throughout the implementation process.
• Effectively prioritized, managed, tracked, and reported project statuses to the Lead System Analyst (LSA), Data Design Manager (DDM), Data Conversion Manager (DCM), and Project Manager (PM). Demonstrated keen attention to detail, and remained flexible and able to adapt to changing priorities and deadlines as needed.
• Worked in a team-oriented, collaborative environment, and work closely with international associates. Demonstrated strong interpersonal and communication skills. Participated in training sessions, presentations, and meetings. Coached other team members on test planning and logic.
• Maintained technical and informational documentation; including batch job comments, annotations in Informatica transformations, code versioning, processing guide, and edit reports according to company and conversion team standards. Documented testing results in the proper test plan template in accordance with team specifications.
• Profiled and provided analysis reports to data managers based on given specifications. Created ad-hoc reports for client data analysis based on specifications from data managers.
• Executed complete post-live date projects and data cleanup. Performed fully automated and small scale manual data cleansing. Reconciled counts through each stage of the data loading process. Utilized relevant problem-solving resources as needed. Escalated issues when appropriate.
• Looked for efficiency improvements in the data conversion model, and made recommendations. Displayed proven analytical and creative problem-solving abilities.

system configuration specialist/ Analyst

Confidential, FL

Responsibilities:

• Preformed system analysis on client facing systems. Programmed and configured client systems to meet analysis specifications.
• Documented configurations according to company standards. Involved in requirement gathering on new projects. Managed multiple projects simultaneously. Changed priorities and focus as needed.
• Communicated status of projects to Project Manager (PM) and Lead System Analysis (LSA).
• Served in a highly dynamic team environment and interacted closely with international associates.
• Worked between multiple teams to achieve common business objectives. Created test plans for the testing of client systems.
• Created and identified test data as needed. Set up and configured testing environments. Performed test executions as outlined in test plans. Documented testing results in accordance with company standards. Worked in multiple testing and production environments.
• Performed calculations for expected results. Identified and debugged system defects. Interacted with a massive IBM DB2 relation database in a mainframe environment.
• Researched and investigated system change orders and translated the findings into procedural analysis documents which thoroughly described the change requested and the systematic change needed.
• Wrote SQL queries against relational database to identify test data. Created SQL update statements to modify database tables. Wrote SQL code to create custom reports on an as needed basis. Worked on projects through the complete system development life style.
• Assisted in redesign analysis of commercial subscriber networks.
• Gained hands-on experience installing and configuring commercial Cisco network devices (3500 series switches, 3600 series routers).
• Performed the installation and configuration of commercial network devices from various vendors including CISCO, CALIX, Zhone, 8e6, IBM, and Dell.
• Configured and installed redundant internet filtering devices for Confidential 's Contemporary Resort. Preformed IP management and IP cleanup.