Core responsibilities
- Build and maintain solutions in Java, React, Angular, Python
- Design scalable, secure architectures and data models
- Write unit tests and ensure code quality before QA handoff
- Investigate bugs, performance issues, security vulnerabilities
- Generate and maintain clear technical documentation
- Keep current on new technologies, including AI
Where AI saves you the most time
- Figma design → working Angular/React code (hours → minutes)
- Generating realistic test data from requirements and ER diagrams
- Querying Oracle and Snowflake in plain English via MCP
- Auto-generating unit tests and reducing technical debt
- Code reviews, refactoring, and security vulnerability detection
- Creating architecture diagrams and API documentation
Key AI tools for this role
- GitHub Copilot — primary code generation and review tool
- Figma MCP — convert designs to frontend code
- Oracle MCP — natural language database exploration
- Snowflake MCP — semantic model-based data querying
- Lucid MCP — auto-generate architecture diagrams
- Cursor — deep analysis of large codebases
Model selection guidance
- Claude Sonnet 4.5 — best for frontend code generation from Figma
- Gemini 3 Pro — complex reasoning and multi-step analysis
- Check GitHub Copilot model comparison docs for up-to-date guidance
- Switch models mid-session if output quality drops
- Use prompt files to maintain consistency across models
.prompt.md files inside .github/prompts/ in your VSCode workspace. Click any template to expand it.
figma-to-angular.prompt.md
# figma-to-angular.prompt.md --- title: Figma to Angular Code Generation description: Converts an attached Figma PNG into a working Angular 20+ single-page application. --- # Role You are a senior front-end Angular developer. # Task Convert the attached Figma PNG UI into an Angular [version 20+] single page application. # Scope Include: Core functional requirements from the UI, component structure matching the design, basic data binding and event handling. Exclude: Security / access control, navigation beyond the provided design, backend API integration (stub with mock data). # Output Generate code files in the development/angular-implementation/ directory: - app.component.ts | app.component.html | app.component.scss - Any child components needed # Standards Use Angular 20+ standalone component pattern. TypeScript strict mode. Keep implementation minimal and clean.
generate-test-data.prompt.md
# generate-test-data.prompt.md --- title: Test Data Generation description: Generates realistic test datasets from requirements docs with correct data relationships. --- # Role You are a data engineer generating test data for a Salesforce CRM and Oracle database environment. # Task — using the provided requirements document: 1. Identify all data entities and their relationships 2. Generate test records covering: happy path, edge cases, boundary conditions, null/empty values, referential integrity 3. Output as SQL INSERT statements (Oracle syntax) unless otherwise specified # Rules Use realistic-looking but fictional data — no real PII. Respect all foreign key and referential integrity relationships. Flag any gaps in requirements that affect data generation. Include a brief data dictionary explaining each entity and key field.
code-review.prompt.md
# code-review.prompt.md --- title: "Code Review & Security Analysis" description: "Systematic review covering quality, security vulnerabilities, and standards compliance." --- # Role You are a senior software engineer and security-conscious code reviewer. # Review Dimensions 1. **Security Vulnerabilities** — input validation, injection risks, insecure data handling, auth issues 2. **Code Quality** — readability, naming conventions, complexity, simplification opportunities 3. **Performance** — inefficient queries, N+1 patterns, unnecessary loops 4. **Technical Debt** — hardcoded values, missing error handling, lack of unit tests 5. **Suggested Fixes** — for each issue, provide the corrected code snippet # Output Format — per issue Severity: Critical | High | Medium | Low File: [filename] | Line: [number] Issue: [description] Fix: [code suggestion]
GitHub Copilot
Code & Content AI
Your primary daily tool for code generation, unit tests, code review, refactoring, and documentation. Works in VSCode across all languages — Java, Python, Angular, React.
When to use
All day, every day — for any coding or documentation task.
Figma MCP
Design-to-Code
Connect Figma to VSCode and convert UI designs directly into Angular, React, or HTML code. Also lets you explore and understand existing Figma applications.
When to use
When a new UI design arrives and you need to generate frontend code.
Oracle MCP
Database Intelligence
Explore Oracle schemas, query tables, and validate test data in plain English through Copilot Chat. No SQL syntax required.
When to use
Any time you need to explore or query the Oracle test database.
Snowflake MCP
Data Warehouse AI
Query the Snowflake data warehouse using natural language once a semantic model has been configured. Business-friendly querying without knowing the schema.
When to use
When analyzing or reporting on data in Snowflake.
Lucid MCP
Diagramming
Auto-generate integration sequence diagrams, data model diagrams, and architecture charts from code or technical specs through Copilot.
When to use
During design phase or creating technical documentation.
Cursor
Codebase Analysis
Deep analysis, navigation, and refactoring of large and complex codebases. Use when Copilot struggles with legacy systems or very large repositories.
When to use
Legacy systems or large codebases that need deep analysis.
Getting set up — 6 steps
Request GitHub Copilot Access
Submit a request through the Cisco AppStore. Install VSCode 1.109+ from the AppStore.
Install Copilot Extensions
In VSCode marketplace, install GitHub Copilot and GitHub Copilot Chat. Authenticate with your GitHub account.
Set Up Your MCP Tools
CTRL+SHIFT+P → "mcp" → open mcp.json. Add configurations for Figma MCP, Oracle MCP, and Snowflake MCP. Authenticate each service.
Create Your Prompt File Library
Create .github/prompts/ in your workspace. Copy the three SE prompt templates from the Prompt Templates tab to get started immediately.
Connect Oracle on Cisco VPN
Install the Oracle SQL Developer VSCode extension. Connect to Cisco VPN. Contact [email protected] for test Oracle instance details.
Try the Figma-to-Angular Use Case First
Drag a design PNG into Copilot Chat and run the prompt template. This is the highest-impact use case to demonstrate value quickly to your team.
Prompting best practices
Assign a Senior Role
"You are a senior Angular developer" produces far better code than an unframed prompt.
Define Scope Explicitly
Tell Copilot what to include AND exclude. Scope creep in AI output is real — be precise.
Iterate in the Same Session
Follow up: "Keep the same structure but add error handling." Don't restart and lose context.
Keep Context Files Open
Have relevant project files open in VSCode — Copilot uses open tabs for better output.
Pick the Right Model
Claude Sonnet 4.5 for UI code. Gemini 3 Pro for complex reasoning. Switch if quality drops.
Always Write Unit Tests
Use Copilot to generate tests for everything it builds. Don't promote code to QA without passing unit tests.
Why this matters
Step-by-step guide
Tools required