System Specialist Resume
4.00/5 (Submit Your Rating)
New York, NY
SUMMARY:
- 7+ years of professional experience in project management, business systems analysis/testing, planning and facilitating requirements gathering workshops, and documenting and presenting findings.
- 2+ years of experience in developing interactive data visualization using Tableau and Microstrategy.
- Good knowledge of Data warehousing, ETL process and OLAP technology.
- Good knowledge of relational database systems like SQL Server and Oracle 12c.
- Expertise in SDLC methodologies - Waterfall and Agile SCRUM.
- Excellent analysis, listening, oral and written communication skills with a results-oriented attitude.
- Domain knowledge of retail and utility industries with an aptitude to learn new domains.
TECHNICAL SKILLS:
Programming Languages: SQL, HTML and CSS.
Tools: MS office, Visio, SharePoint, Project, Photoshop, Snagit, JIRA, HP ALM, Tableau, Microstrategy.
WORK/ PROJECT EXPERIENCE:
Confidential, New York, NY
System Specialist
Responsibilities:- Consulting with Gas business clients and developing interactive Tableau visualization and dashboards using Tableau Desktop.
- IT business intelligence analyst for the implementation of the CGI ARM 2 software for Gas Work and Asset Management (GWAM) enterprise solution. GWAM is a multiyear project with a budget of $110 million. Created inventory of existing reports and data sources. Gathering detailed business reporting requirements for the GWAM system implementation.
- Supporting the GWAM data conversion team by analyzing the gas assets data in various systems using SQL.
Confidential, Memphis, TN
Systems Analyst
Responsibilities:- Created interactive Tableau worksheets and dashboards using variety of charts such Bar Charts, Line Charts, Gantt Charts, Scatter Plot and Box and Whisker Plot. Published them on the Tableau server.
- Implemented sorting, formatting, Quick/Context/Cascading filters, and created calculated fields, groups, sets and parameters in the Tableau dashboards.
- Lead the Business Requirement’s elicitation meetings/workshops/interviews with business users and technical teams for all my projects.
- Served as Admin for the Tableau site for managing access and security permissions.
- Created report mock up and reviewed with the business users to receive feedback.
- Prepared Test cases and test plans and successfully executed them to ensure all the requirements are met.
- Provided Ad-Hoc SQL data queries and report as needed along with on-going analytical support.
- Used skills and knowledge to analyze business problems, offer solutions and define project requirements.
- Performed Fit/Gap analysis for the project and prepared analysis documentation.
- Worked closely with Release Management and QA teams to facilitate UAT with the Business.
- Supported AutoZone’s Store Operations (POS systems), Marketing, and E-Commerce projects by acting as the liaison between the Business and IT for system enhancements projects. Prepared Business Requirements documentation including: Business Initiation, Scope, Data Flow Context diagrams, Use Cases, UML diagrams (wireframes, swim lanes, user stories, prototypes, UI/UX), Business Rules, Functional and Non-Functional Requirements, Requirements Traceability Matrix (RTM) and Entity Relationship Diagrams.
- Mentored new AutoZone’s BA’s, conducted Peer reviews and assisted in the development of AutoZone’s SDLC processes and documentations.
- Developed a web-based application for software release management system utilizing PHP, HTML, JavaScript and CSS.
Confidential, Maitland, FL
GIS Analyst/Community Planner
Responsibilities:- Managed and prepared a wide variety of land use planning and design studies at different geographic levels from multi-thousand acres neighborhood revitalization plans to design improvements along individual streetscapes.
- Developed 30 years population projections for municipalities using shift-share and historical trend projection methods. Analyzed past population trends and documented the findings.
- Prepared maps and conducted spatial analysis using GIS software for various planning projects.
- Conducted interviews, workshops and focused groups sessions with stakeholders. Established vision statements, and goals, objectives and policies for sustainable growth.
- Prepared presentation materials such as charts, storyboards and PowerPoint presentations to communicate recommendations to clients and stakeholders.
- Coordinated project management efforts including scheduling (using Gantt charts), quality control, fees man-hour budgeting, team coordination, task management, and client communication.
