Senior Systems Analyst
•Analyze incoming service requests for varying telecommunication products needed (internet packages, phone service packages, Ethernet circuit packages, etc.).•Complete company projects and represent department as Senior Analyst. Analyze needs of product and work with a large team of various disciplines to create, test, and release new products to commercial and residential markets.•Conduct internal audits of the production environment to ensure correct revenue. Report errors and work with team members to fix impacts to revenue.•Communicate extensively with requestors to verify accuracy of incoming tickets and products needed.•Utilize the internal Service & Equipment software to build the requested products for a nationwide area of supported locations accurately and efficiently.•Analyze, update, and solve issues within the production environment through the Remedy ticket system•Query and analyze large datasets using SQL (Razor software and Excel primarily).•Extensive use of Microsoft Excel and Word for data gathering and reporting.•Creation of macros to automate work within the IBM iSeries AS/400 system.•Moved to internal programming team to maintain and develop Windows forms (Visual Basic/SQL Server 2012)•Design, build, and test SSIS packages for daily reports. Deploy packages to production servers and competently work with separate Database team to safely organize scheduled jobs. •Daily use of Visual Studio and SQL Server Management Studio. Entry level but steadily increasing knowledge of Visual Basic and C# programming languages within a corporate environment.