Senior Systems Engineer Data Analyst Resume
5.00/5 (Submit Your Rating)
SUMMARY:
- 3.5 years of IT experience as a Data Analyst skilled in interpreting and analyzing data in a fast - paced environment with certifications in SQL and Base SAS programming
- Experienced in SQL queries to manipulate data for data loads and extracts from various databases for data analysis
- Experienced in analysis of data sets using SAS 9.4 and data visualization using Tableau
- Exposure to the data warehouse applications and data modelling concepts with a sound understanding of relational databases and ETL processes
- Advanced proficiency of Excel to generate spreadsheets functionality like pivot tables,V-lookup and VBA scripting
- Prepared detailed technical documents and reports while managing complex data analysis responsibilities
- Strong analytical, problem solving and statistical analysis skills with efficiency in oral and written communication
- Attention to detail & ability to work in a pressurized time sensitive environment
TECHNICAL SKILLS:
Languages: Advanced SQL, PL/SQL, C, C++,JAVA, Unix
Databases: Oracle 11g, SQL Server, MySQL, Teradata
MS Office: Excel, Word, PowerPoint, Outlook, Access, Visio, MS Project
Software: Eclipse IDE, SQL Developer, Tableau, SAS Base, SAS Enterprise Miner, Pentaho Kettle
PROFESSIONAL EXPERIENCE:
Confidential
Senior Systems Engineer Data Analyst
Responsibilities:
- Manipulated, cleansed & processed data using Excel, Access and SQL for client activities
- Analyzed raw data, drawing conclusions & developing recommendations for the client
- SQL programming, including stored procedures, functions, triggers, and other related DML operations
- Performed daily data queries using SQL and prepared reports on a weekly, monthly and a quarterly basis
- Involved in the collecting, parsing, managing, analyzing and visualizing very large structured data sets using Tableau
- Defined data requirements and gathered and validated shipment information, applying judgment and statistical tests to extract patterns and trends in the shipment behavior
- Performed quantitative and qualitative analysis of Retail and Medicare data, relating constants and variables, conflicting objectives and their numerical parameters
- Analyzed functional requirements and translated them into ETL mapping documents
- Interpreted data, analyzed results using SAS and used statistical techniques for providing ongoing reports
- Analyzed data analysis requests obtained from management to conceptualize and define operational problems and define data modeling requirements, validation of content and problem solving parameters
- Developed, published and maintained periodic reports and dashboards for key design and process metrics
- Used and shaped large amounts of data to analyze trends and quickly understand business impact
- Conducted training seminars, user acceptance sessions, and presented business value recommendations
- Communicated with internal teams and external partners to coordinate reporting and decision-making