MFCJP00013191 - Programmer Analyst
Apply NowCompany: Core Resources
Location: Toronto, ON M4E 3Y1
Description:
Manulife John Hancock is looking to hire a programmer analyst who will focus on developing, supporting, and operating software solutions for TAI Reinsurance Systems Operations reporting and business process automation.
Responsibilities:
Develop and operate business metrics reporting applications: SQL Server 2014 (SQL Server, SSAS, SSIS), .NET 4.5.2, MS Access 2010
Develop and support business process automation web-applications using Visual Studio 2013 (.Net, C#, ASPX), MS Office Tools, and SQL Server.
Operate and support legacy applications developed using MS Access and MS Excel.
Follow application architecture standards and work to develop reusable components and templates.
Understand the needs of the stakeholders to tailor technical solutions driven by business metrics.
Identify and implement innovative ideas to improve upon current processes and enhance user experience.
Provide exceptional service to business partners.
Ensure the timely completion of scheduled daily, weekly and monthly reporting and other tasks as per SLAs.
Establish collaborative relationship across all teams to ensure effective communication and report execution.
Identify opportunities for report enhancement by Eliminating, Streamlining, Automating and Consolidation (ESAC).
Develop and maintain application support documents.
Provide backup support for other team members.
Accuracy and consistency of data is imperative.
Regular interaction with business users and management
Great attention to detail and time-management skills.
Support and participate in all activities related to complete life cycle of applications such as design, develop, test, de-bug operation, and client support.Requirements:
University Degree in Computer Science / Engineering or equivalent working experience.
Proven experience of as application development and support in DevOps environment (develop and operate applications in agile environment)
10+ years of Mainframe (TSO, Cobol, JCL, CICS) programming and support experiences,
3+ years of experience with Python, VBA, C# programming, MS Access, MS Excel, Strong technical skills for writing macros (Excel, Word, Access) to automate small business processes.
3+ years of experience with automation job scheduling (CAWLA).
5+ years of experience with MS SQL Server platform.
3+ years of experience of writing database stored procedures and creating logical and physical schema.
Proficient in writing complex SQL queries.
Experience in developing SQL Server Integration Services packages (SSIS).
Strong web development skills including Visual Studio 2013, C#. ASPX, HTML5, AJAX, CSS3, JavaScript and JQuery.
Excellent understanding of object oriented programming, software design and programming principles.
Well conversant with .Net Application Framework , Common Language Runtime, Managed Codes and Distributed Architectures.
Excellent knowledge of data warehousing and multi-dimensional data mart concepts.
Experience or knowledge on Reinsurance system application an asset.
Experience or knowledge of PowerBI an added advantage.
Capacity to handle tight deadlines and changing priorities
must be able to juggle multiple tasks.
Strong team player, who enjoy collaborative work environment.
Proactive and takes ownership of the work assigned.
Strong communications and interpersonal skills with the ability to build relationships and maintain professionalism.
Experience in interacting with business users and management on regular basis.
Responsibilities:
Develop and operate business metrics reporting applications: SQL Server 2014 (SQL Server, SSAS, SSIS), .NET 4.5.2, MS Access 2010
Develop and support business process automation web-applications using Visual Studio 2013 (.Net, C#, ASPX), MS Office Tools, and SQL Server.
Operate and support legacy applications developed using MS Access and MS Excel.
Follow application architecture standards and work to develop reusable components and templates.
Understand the needs of the stakeholders to tailor technical solutions driven by business metrics.
Identify and implement innovative ideas to improve upon current processes and enhance user experience.
Provide exceptional service to business partners.
Ensure the timely completion of scheduled daily, weekly and monthly reporting and other tasks as per SLAs.
Establish collaborative relationship across all teams to ensure effective communication and report execution.
Identify opportunities for report enhancement by Eliminating, Streamlining, Automating and Consolidation (ESAC).
Develop and maintain application support documents.
Provide backup support for other team members.
Accuracy and consistency of data is imperative.
Regular interaction with business users and management
Great attention to detail and time-management skills.
Support and participate in all activities related to complete life cycle of applications such as design, develop, test, de-bug operation, and client support.Requirements:
University Degree in Computer Science / Engineering or equivalent working experience.
Proven experience of as application development and support in DevOps environment (develop and operate applications in agile environment)
10+ years of Mainframe (TSO, Cobol, JCL, CICS) programming and support experiences,
3+ years of experience with Python, VBA, C# programming, MS Access, MS Excel, Strong technical skills for writing macros (Excel, Word, Access) to automate small business processes.
3+ years of experience with automation job scheduling (CAWLA).
5+ years of experience with MS SQL Server platform.
3+ years of experience of writing database stored procedures and creating logical and physical schema.
Proficient in writing complex SQL queries.
Experience in developing SQL Server Integration Services packages (SSIS).
Strong web development skills including Visual Studio 2013, C#. ASPX, HTML5, AJAX, CSS3, JavaScript and JQuery.
Excellent understanding of object oriented programming, software design and programming principles.
Well conversant with .Net Application Framework , Common Language Runtime, Managed Codes and Distributed Architectures.
Excellent knowledge of data warehousing and multi-dimensional data mart concepts.
Experience or knowledge on Reinsurance system application an asset.
Experience or knowledge of PowerBI an added advantage.
Capacity to handle tight deadlines and changing priorities
must be able to juggle multiple tasks.
Strong team player, who enjoy collaborative work environment.
Proactive and takes ownership of the work assigned.
Strong communications and interpersonal skills with the ability to build relationships and maintain professionalism.
Experience in interacting with business users and management on regular basis.