Systems Analyst Resume

PROFESSIONAL EXPERIENCE:

Systems Analyst

Confidential

Versatile, resourceful, and high - performing Data/System analyst Professional/ 5 years of experience in the Information Technology field who has acquired a vast of knowledge in network administration and security, customer service, information assurance, installation, configuration, and troubleshooting of workstations, servers, and network connectivity and data analytics.

Areas of Strength

Active Directory HP Server Blades /ILO/VTC Exchange
Virtualization ACAS Windows 2012 R2 App-V
O365 Exchange Linux/PowerShell
MSQL
TOAD
Oracle
ER Studio

PROFESSIONAL EXPERIENCE:

Database and Systems analyst

Confidential

Perform Data analytics using TOAD, MSQL, and Oracle.
Member of incident report team for tracking, ticketing and fixing system malfunctions Use JIRA to open and track issues
Work in Agile/Scrum environment. resolve data issues
Create long complex SQL queries.
Support development/ETL work and Testing work.
Use Data models from ER studio to understand and read data with regards to relationship data model.

Lead Data Analyst

Confidential, Arlington VA

Conduct data mining, data modeling, statistical analysis, business intelligence gathering, trending and benchmarking
Data analytics supports decisions for high-priority, enterprise initiatives involving IT/product development, customer service improvement, organizational realignment and process reengineering.
Source to Target mapping.
Used SSIS tool for extracting, transferring and loading data.
Used Excel to import data from SQL and perform
Analyzed and assessed bad data, reported data issues in JIRA.
Used Excel to reconcile data and data counts.
Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports.
Extraction of test data from tables and loading of data into SQL tables.
Create Pivot tables and modify spreadsheets to achieve analytical goals.
Written several complex SQL queries for validating Reports.

Data Analyst

Confidential, Buffalo, NY

5 years of IT experience in Data Quality Assurance and Software Testing of various business applications in Client/Server environments, Web-based applications, Data Warehousing solutions, ETL and Business Intelligence solutions.
Experience in all phases of the Software Testing Life Cycle ( STLC ) and good exposure to Software Development Life Cycle ( SDLC )
Expertise in analysis, design and implementation of data warehousing/ BI solutions using Teradata, Oracle, Informatica, MicroStrategy, Tableau, Unix technologies.
Experienced in Manual and Automated testing techniques, such as Black box , GUI , Functional , Integration , System, Regression, Back end and User Acceptance Testing
Excellent analytical, communication, documentation and interpersonal skills
Ability to work with all levels of management, willingness to learn and implement new ideas quickly and to be a collaborative team player
Highly motivated resourceful team player that takes a positive approach to problem resolution Expert in industry standard software development methodologies and life-cycles
Ability and desire to work in a spirited, collaborative environment
Ability to identify and prioritize important tasks independently
Experience in developing using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 databases
Self-motivated, willing to learn new concepts, technologies, and ability to produce quickly
Extensive experience with object oriented analysis and design and developing use-case models.
Ability to meet deadlines and handle pressure coordinating multiple tasks.
Demonstrated strong interpersonal skills with the ability to work effectively with upper management and excellent leadership skills in motivating others.
Extensive experience in data analysis in SQL , MSQL , TOAD .
Proficient in MS SQL Server, Expert Knowledge of Reporting Services (SSRS), Integration Services (SSIS).
Skilled in VLOOKUP formula development.
Professional in MSQL, SQL, Oracle 10g, Oracle 9g, TOAD, Teradata, and MS Access.
Skilled in Pivot table generation and Pivot reporting .
Worked with SAS on exporting data using Teradata.
Created User Defined Functions in VBScript library files and used these functions in various test scripts using QuickTest Pro.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship