EXPERIENCE:

Confidential, Fairfax, VA

Data Analyst/Administrator

Responsibilities:

• Works under minimal supervision
• Defines data migration needs (in ABIDES an Air Force Budget System)
• Identifies data relationships and details on missing relationship data, duplicate columns, and redundant data
• Uses data mining techniques to define data
• Uses UNIX Commands to collect data
• Uses EXCEL techniques and models to define data for data integrity and process analytics
• Explains and documents data mining techniques and results
• Provides information on data content, including any data standardization issues and ambiguities between older and more current data
• Interacts with the Subject Matter Expert (SME) community to clarify how SMEs would like to use data, types of reports, and workflows needed
• Interact with the senior level client and project managers on a regular basis
• Responsible for providing analysis and support for OBIEE load and performance testing.
• Responsible for installation,configuration and maintenance of the Oracle database and Oracle Integrator including documentation all custom settings and configurations .
• Provided a final solution that meets customer needs and expectation to successfully replace the old Oracle Warehouse Builder and Oracle Discoverer tools with OBIEE and ODI.
• Validate Reports transferred from old server to the OBIEE server.

Confidential, Washington, VA

Data Analyst

Responsibilities:

• Gathers user requirements for database changes, analyzes database requirements,
• Create specifications for the ETL team to load the data to the database, participates in functional design sessions, creates and executes test scripts for the load of the database, and aids in the escalation/resolution of data issues.
• Identifies data relationships and details on missing relationship data, duplicate columns, and redundant data
• Create Documentations of detail oriented processes and Reconciliation Reports, problems, resolutions
• Uses UNIX Commands to collect datastore in Ebinders on Share Drive and SharePoint
• Run queries in TOAD and BOXI to verify data to complete Reconciliation Reports.
• Uses EXCEL techniques and models to define data for data integrity and process analytics
• Use WebEx to shadow and reverse shadow team members to help complete report.
• Provides information on data content, including any data standardization issues and ambiguities between older and more current data
• Create Group mailboxes to communicate via email to particular projects.
• Create incident tickets in Remedy on Data Quality issues.
• Participate on the Procedure team to modify and updated
• Worked on the Business Process and Improvement team (automated Reconciliation reports)
• Interacts with the Subject Matter Expert (SME) community to clarify how SMEs would like to use data, types of reports, and workflows needed
• Interact with the senior level client and project managers on a regular basis

Confidential, Chantilly, VA

Data Analyst

Responsibilities:

• Compile data and maintain information in database and data warehouse
• Research, manipulate data (SQL) and transcribe data; run quality control reports
• Track unfinished reports, complete, print and distribute to appropriate parties
• Establish and maintain various filing and record management systems
• Conducted weekly backup audits of clients’ server environments
• Plans and lead major technology assignments to include scheduling the meeting and other arrangements
• Created group policy objects to deploy software to enterprise - sized networks
• Utilized Sonic Wall firewalls to manipulate network traffic
• Server patching and software updates
• Cisco Phones
• Managed Active Directory accounts
• Interface with multiple stakeholders and teams including development, business analysts
• Change management, configuration management, QA, client UAT testers, etc.
• Evaluates performance results and recommends major changes affecting short-term project success

Confidential, Washington, DC

OSI Data Analyst /Information Specialist

Responsibilities:

• Maintain a list of division purchased software, serving as a contract for those in their division when software is needed
• Software install request
• Troubleshoot all department IT hardware and software requests before creating help desk tickets
• Provide the CITL with a list of employees who are eligible for a PC refresh
• Research and evaluate data from support of the OSI database reports
• Respond to agency IT-related data calls (such as Microsoft license verification)
• Respond to
• Updated Shares permission tracker
• Admin support for ECMS (SharePoint) and permission tracker
• Desktop helpdesk support for customers with mapping to network printer, Transition from Operating system XP to Win7
• As the Information Specialist /IT Coordinator I communicated with the helpdesk with software and
• Hardware issues from the users and also with the users with software upgrades and update. I also was responsible for hardware refresh and replacements.
• Place and track service requests in HP Service Manager
• Implementation team updating the OSI database (access), function test, metric testing in both production and test environment. Customer requirements for changes and update.
• As IT Coordinator for the Office of Scientific Investigation, I was responsible for all electronic
• (litigation) data stay in compliance with Confidential Regulations. I was also in the Meningitis team for stored data.
• Update Manuals with new procedures
• Implement and testing (executing queries) new software programs
• Uses and supports database applications and analytical tools.

Confidential, Washington, DC

Business Support Technician

Responsibilities:

• Identify problematic areas and conduct research to determine the nest course of action to resolution of Government classified data
• Complete reports essential to financial directorate operations in a timely and organized fashion. (Financial Orders report, and the Revolving Fund Daily Report)
• Evaluate/problem solve common issues that deal with network support for the Department of Defense
• Resolve technical issues with workstations using remote connectivity via Microsoft Remote Assistance
• Adjust firewall settings of users to allow/block network traffic
• Maintain, update, and reset account and login information of employees via Microsoft Active Directory/Active Roles
• Perform manual data entry, using SQL command statements
• Closed an average of 30-50 tickets per day
• Used Cisco telephones with I3 Client
• Managed user accounts via Active Directory
• Provide weekly updates to the Budget manual website
• Create reports from Confidential agencies and departments using Teradata
• Installed antivirus and ran updateson user workstations

Confidential, Washington, DC

Data Analyst

Responsibilities:

• Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation (SQL).
• Wrote reports using Maximo 6, IFS and Cognos reporting system to extract data for analysis using filters based on the business data model
• Maximo was used to create service and work orders, create reports, ad hoc reports, preventive maintenance schedules and inventory
• Worked on complex information model, logical relationships, and the data structures that support different data models
• Acted as Team Lead for several projects which involved programs that interfaced with Oracle databases
• Designed system controls to ensure Sarbanes-Oxley compliance as well as responsible for regulatory compliance audits
• Administered a quality control auditing plan for Maximo a program's information system
• Created several data reporting processes from start to finish, which included the data mining, analysis and reporting piece
• Prepared and presented weekly reports for management to view the data teams weekly progress
• Implement new report processes and designs.
• Created spreadsheet reports, and graphs from statistical customer data to increase reporting speed and data quality
• Regularly interacted as liaison between the company and governmental agencies to help develop data reports to improve their overall business functions
• Mentor staff members and the customer on proper and effective use of Maximo and Cognos (automation) system.

Confidential, Washington, DC

Central Monitor Analyst

Responsibilities:

• Responsible for monitoring and operating system generated jobs for Sampling Management System (SMS)
• Processing and Daily Job Stream (ETL tool), for compliance with all process control standards.
• SFTP files from servers encrypt and decrypt.
• Provided IT production support to evaluate and resolve data problems within Oracle databases
• Investigated client problems with transmission, load and/or execution.
• Investigated and resolved errors and/or discrepancies to ensure integrity and accuracy of data, using Unix/Linux
• Writing SQL queries to access Oracle databases
• Assessed impact of problems, prioritized the urgency, executed short-term repairs, and coordinated long-term resolutions
• Performed end user Acceptance testing, implementation of small and large scale changes to Arbitron’s methodologywithin Production and Research test environment.
• Created production data reports for internal departments and maintained production procedure documentation.
• Managed multiple individual tasks/projects and met strict deadlines, to perform in a fast-paced, time critical environment, working both independently and as a part of a team.
• Lead and supervise projects with CATI Operators and Site Supervisors.
• Participated in Major Software upgrades (Project CATI-Central Server). Developed and approved documentation of all DJS/SMS procedures.
• Manually “ Confidential ” files from Linux over to UNIX (Perl shell script) when file changes are delayed.
• Train Cati Operator in creating, upload/download files.
• An essential part in the implementation/testing the new ETL (GUI) and the Central Server as the main