Senior Program Analyst Resume
EXPERIENCE SUMMARY:
- I have experience performing ad - hoc reports for insurance claim related data, school and student data and creating C# applications, websites or apps with SQL Server backend.
- I can also provide SharePoint help all the way from the site to the farm levels.
- I have over 10 years of experience in the I.T. sectors.
- I started my career off performing help desk roles utilizing active directory and various ticketing systems.
- The later part of my career has been geared towards development. I have gained experience creating reports with various reporting software, dashboards, databases, web services and custom websites and applications over the past 4 years.
- One of my recent projects was migrating a VB6 application to current .Net C# with upgraded Telerik controls.
- I help support the student information system eSchool Plus 4.0 by making various frontend and backend changes.
- I also handle various state reports for the Confidential, develop medical related reports (student immunization status, student chronic illness counts), create custom Cognos reports on demand for users and develop customer SharePoint solutions for the various departments within IPS.
- Created and implemented IPS’s first team foundation server for version control.
TECHNICAL SKILLS:
Network configuration
PC troubleshooting, repair and installation
Server Installation and configuration
VMWare Cluster configuration
Microsoft Windows
XP-Windows 10
Microsoft Windows Server
Mac OS
IOS
Android
Linux
Kali
BackTrack
Microsoft SharePoint
SharePoint Designer- Workflow development and site creation and design
Content database backup and recovery
Microsoft Office Suite
Microsoft Visual Studio- C#, VB.Net, ASP.Net, MVC, .Net Core
IIS Internet Information Services
WCF web services
Team Foundation Server
HTML 5 APIs
JavaScript
CSS3
Android Studio
Xamarin
Microsoft Visual Basic 6.0
Android Studio
Net Beans
Eclipse
SQL Server Suite (Management Studio, SSIS, SSRS)
Microsoft Access
IBM Cognos Suite
Tableau (Tableau Desktop, Tableau Server, Tableau Online)
Microsoft PowerBI
VMware Player
Virtual Box
MySQL
Oracle
SQL- T-SQL, PL-SQL
Atlassian Jira
Stash
Adobe Photoshop
ArcGIS
ESRI Map Tools
Fiddler4
GitHub
WordPress
WORK HISTORY:
Confidential
Senior Program Analyst
Responsibilities:
- Co-managing enrollment office team.
- Training and documentation creation
- Advise junior programmers
- Create district level reports and dashboards
- Created Classroom rosters used for attendance taking and reporting via Cognos
- Control data request from outside requesters of IPS data (Media, government, web)
- SharePoint Development (Sites, List, Surveys, Admin)
- Troubleshoot district wide enrollment issues
- User base 50,000 plus
System Analyst/ Developer
Confidential
Responsibilities:
- Maintain student information system eSchool Plus 4.0 frontend and SQL Server backend.
- Confidential state reporting for student, staff and school data.
- District medical reporting (immunizations, chronic illness, office visits)
- Cognos development with SQL objects and the framework.
- General ad-hoc reporting for end users via SQL Server.
- Query optimization and automation
- SharePoint development: custom list with workflows.
- BI development with performance tracking dashboards.
- Requirements gathering for various departments.
- Created IPS Team Foundation Server to implement version control.
- Created SQL Server jobs for report automation to end users.
- Knowledge transfer to less experienced analyst.
Confidential
Application Developer
Responsibilities:
- Created a WCF web service that provided authentication for Lawrence Township Public Schools student information system website.
- Migrated a timekeeping system ASP.net, VB.net from SQL Server 2008 to SQL Server 2014.
- Also migrated the visual studio solution to visual studio 2015.
- Created TFS (Team Foundation Server) site for source control and PM.
- Migrated VB6 Cop Setup application for the Indiana Hospital Association to C# using Telerik UI WinForms CSS templates and controls.
- Created project plan and helped with project management.
- Team Foundation Server and GitHub source control.
- Helped with sales as a technical adviser.
Confidential
Owner and Webmaster
Responsibilities:
- Developed website from the ground up.
- Project manager for Samsung Washer Recall Indiana
- Managed over 15 employees during 4 month span
Confidential
Owner and Webmaster
Responsibilities:
- Developed website from the ground up.
Confidential, Indianapolis, IN
Business Systems Consultant/Developer
Responsibilities:
- Report development ad-hoc and recurring.
- Medicaid claims and SNAP data analysis via Teradata.
- Cognos report development.
- Developed and administered custom SharePoint solutions on request.
- Participated in meetings and requirements gathering for projects and day to day business operations.
