Systems Analyst

JSM Consulting Inc
  • Albany, NY
  • Instant Apply
14 days ago

Job Description



84 months experience with internal and external stakeholder communications and outreach, including the development of presentations and other materials that promote the rethinking of core business processes and envisioning of a reengineered environment.
84 months of experience as a Lead Systems Analyst or Systems Architect directing the end-to-end technical analysis, design, and optimization of complex enterprise systems. Proven expertise utilizing advanced systems modeling methodologies—including Unified Modeling Language (UML), Data Flow Diagrams (DFDs), and entity-relationship modeling—to conduct comprehensive As-Is/To-Be system state evaluations, perform technical gap analyses, and architect scalable, high-performance system workflows and technical specifications.
84 months experience working on Business Requirements Project, as lead Analyst, which involved the application of strategies to gather and document business process requirements of new applications, with logical and physical data modeling, including data normalization (up to 3NF) to transform flat-file or legacy structures into enterprise relational database schemas (e.g., SQL Server, Oracle).
60Months of experience reverse-engineering legacy databases (specifically MS Access), including analyzing existing tables, relationships, queries, forms, macros, and VBA modules to identify structural anomalies, and writing complex SQL queries (including multi-table joins, subqueries, and analytical functions) to perform data validation, data profiling, and backend troubleshooting.
60 Months of experience acting as a technical liaison between business stakeholders, software vendors, and application developers to translate business requirements into highly technical system design artifacts, including Entity-Relationship Diagrams (ERDs), Data Flow Diagrams (DFDs), and detailed data mapping/ETL specifications.
48 Months of experience analyzing, designing, or supporting systems integrated with enterprise Document Management Systems (such as IBM FileNet) or enterprise relational databases (such as Oracle).
36 months experience as a developer developing and implementing multi-tier .Net Framework and .Net Core web applications using C# code leveraging ASP.Net patterns: Web Forms and Model-View-Controller (MVC); and designing and implementing system integration points, web services, or APIs to facilitate data exchange.
Masters Degree in a computer or technology related field

Numbers & Facts

LocationAlbany, NY

Skills

  • Analysis Skillsunmatched
  • Application Programming Interface (API)unmatched
  • Architectural Analysisunmatched
  • Business Processesunmatched
  • Data Mappingunmatched
  • Data Modelingunmatched
  • Data Profilingunmatched
  • Data Qualityunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Database Technologyunmatched
  • Document Managementunmatched
  • Entity Relationship Diagram (ERD)unmatched
  • Gap Analysisunmatched
  • IBM Product Familyunmatched
  • Identify Issuesunmatched
  • Internet Applicationunmatched
  • Microsoft .NETunmatched
  • Microsoft ASP.NET (Active Server Page)unmatched
  • Microsoft Access Databaseunmatched
  • Microsoft C# (C Sharp)unmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Visual Basic for Applications (VBA)unmatched
  • Model View Controllerunmatched
  • Oracleunmatched
  • Oracle Databaseunmatched
  • Reengineeringunmatched
  • Relational Databases (RDBMS)unmatched
  • Requirements Managementunmatched
  • Reverse Engineeringunmatched
  • SQL (Structured Query Language)unmatched
  • Software Developmentunmatched
  • System Architectureunmatched
  • System Integration (SI)unmatched
  • Systems Analysisunmatched
  • Technical Analysisunmatched
  • Technical/Engineering Designunmatched
  • Unified Modeling Language (UML)unmatched
  • Web Formsunmatched
  • Web Servicesunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder