System Analyst Resume

PROFESSIONAL SUMMARY:

Over 3+ years’ work experience with highly analytical with a documented record in software development life cycle (SDLC) methodologies across diverse industries. Strong experience in IT Industry in developing and analyzing under SAS using SQL and PL/SQL. Proven ability to develop valuable solutions with different software development methodologies such as Smart BPM, Agile Scrum and Waterfall.

TECHNICAL SKILLS:

Database: SAS/SQL, SQL Server, SAS/Enterprise Guide

Language: SQL, C, Java, SAS, Hadoop, Python, Embedded C.

Project Methodologies: Rational Unified Process (RUP), Agile, Waterfall, Spiral

Database & Servers: Oracle, Salesforce, Mamp, Apache Tomcat.CA Agile Central(Rally),Confluence, SharePoint, Requisite Pro, HP Quality Centre, Remedy & ServiceNow

Software/Applications: MS Office Suite (Word, Excel, PowerPoint), MS Project, OneNote, MS VisioSnag IT, Illustrator, MS Outlook 10/16, Google Apps, and Office 365

PROFESSIONAL EXPERIENCE:

System Analyst

Confidential

Responsibilities:

Worked with Business Partners, Business Analysts, and the management team by planning and executing automated regression and test case scenarios.
Conducted unit testing and integrated testing by identifying root cause with T - SQL staments before deployment to the production server.
Used SAS to query and extract data from a variety of databases (Greenplum, DB2, SQL Server) and to prepare health data analysis.
Designed Tableau dashboard by creating action filters and calculated health survey data set
Extensive experience with PL/SQL. Implemented software tests Using SQL statements for data validation and reporting by evaluating results.
Experienced in debugging an application using PEGA Tracer Tool, Clipboard, performance testing using PAL Tool by documenting and executing test cases and scenarios.
Conducted unit testing and integrated testing by identifying root cause with T-SQL statements before deployment to the production server.
Integrate Jira and Salesforce by creating leads, Opportunities and converting them to Jira user stories and integrated JIRA with Confluence.

Data Analyst

Confidential

Responsibilities:

Participated in business requirements meeting and data mapping sessions to understand the project.
Build customized interactive reports, trends based on business requirements and scheduling using Tableau server.
Experience in SAS programming for auditing data, developing data, performing data validation QA and improve efficiency of SAS program
Worked on installations, migrations and upgrades of Atlassian applications like JIRA, Confluence using MySQL as databases.
Created and updated application for internal operations by using C+, SQL Server 2008 and 2005
Implemented data filing system decreasing reporting- retrieving time by 30% by using pivot tables.
Extensive experience in using SAS Enterprise Guide in developing stored process and performing statistical analysis.
Worked with the design team and business partners in developing mockup screens for the applications and prototyping of the user interface.
Lead the team issues once a week. Used Teradata SQL Assistant and ran SQL queries in Oracle database
Integrated custom code data into the Salesforce application.

Assistant Project Engineer

Confidential

Responsibilities:

Create project timelines using Microsoft Project software. Also, provide preliminary project spending estimates and project status to stakeholders applying JIRA tools.
Identify, assess and solve complex business problems for area of responsibility, by analyzing the new as well as the existing requirements and performing impact analysis to identify bottlenecks up front to get an accurate estimation of the work effort required.
Decreased packaging process time by 25% by setting up dedicated stations by planning, executing to ensure production schedules are met also managing project risks
Act as a liaison between users of the software and the production support teams to address questions/issues, by performing root cause analysis and formulating a solution.
Support SIT and UAT testing by clarifying and tracking defects until they are resolved and closed.
Analyze and manage production cases on a day to day basis to provide key metrics and system performance analysis reports.

Project Analyst (Intern)

Confidential

Responsibilities:

Compiled Meeting minutes and daily status reports.
Coordinated statistical data analysis, design and information flow.
Worked with senior Business Analyst to understand the Business analysis process.
Interacted with Business Users and gathered report specifications as well as business process to deliver better robust reporting solutions on day to day basis.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship