Timothy Murphy Email & Phone Number

Chicago, Il, Us

Chicago, Illinois, United States

- Implemented a set of techniques or analytics applications to transform raw data into meaningful information using SQL Server - Involved in API monitoring and API Gateway development- Maintain the Implementation book of business from a data perspective by having successful go-live seasons - Took on new initiatives from IT to create a better custom service for our ongoing department - Helped create a successful transition onto the Amazon Web Services (AWS) platform - Maintained the ongoing ticket queue by implementing white glove service for both our clients and ongoing teams- Helped define the roadmap for our Product Management team for our proprietary Import and API tools - Led the data team and helped them grow, develop, and sustain engagement throughout the year - Pursue bswift growth opportunities that involve our proprietary software tools - Continued to define our process and best practices for data conversions and SQL development- Helped grow the Tier 1 Import Support team to a first go to service for both our clients and ongoing teams- Used the Agile method when allocating resources for all new implementations, ongoing needs, and other special projects - Able to communicate ideas in a both technical and user-friendly language

Chicago, Il

- Participated in discussions with client teams to define initial data conversion and ongoing solutions needs- Gave direction to the analyst team on coding data maps, define data import best practices, and be the overall gatekeeper of Tier 1 Import Support - Developed enhancements with the product team for bswift's proprietary tools used by the data team- Automated data processes using Microsoft SQL Server - Assisted ongoing teams with data issues, data needs, and overall data requests - Monitored data batch jobs and overall SQL server performance - Helped with resource and project planning for all new implementations, ongoing needs, and with other projects that might come up throughout the year

Chicago, Il

- Analyzed, defined, created, and tested processes to populate and maintain client data in the bswift system- Subject matter expert in bswift data needs including initial data conversion, ongoing data import processes, and automated audit processes using scripts to verify and maintain data integrity - Participated in discussions with clients to define initial data conversion needs as well as ongoing data import file specifications- Developed, tested, and maintained the data mapping and import processes required for accurate and efficient ongoing service delivery- Audited production data and modify when needed using SQL - Worked with the Director of Data Conversion to continuously refine and improve data import processes - Assisted ongoing service teams with data import needs as requested- Developed and code payroll files based off client requirements using SQL - Developed reports and interfaces using SQL and other tools for client payroll needs such as closed loop payroll - Triaged payroll tickets and modified existing SQL code to meet new client requirements- Wrote scripts, functions, and stored procedures to meet client payroll requirements

Chicago, Il

- Implemented client sites by participating in requirements sessions with clients, site building, site testing, and site release to the production environment- Addressed any requirement questions to the Implementation Manager and Leader and escalate any issues/risks when identified- Developed clear test plans for online client acceptance testing and end to end file processing- Branded client sites using CSS, HTML, and basic JavaScript- Import test demographic data and rates into bswift’s system using the proprietary Import tool - Analyzed and audited client data to verify accuracy between the client’s system and bswift- Assisted the Implementation Manager in debugging issues and implementing resolutions - Produced reports providing summary and analysis for audits using Excel- Wrote basic SQL queries using Microsoft SQL Server 2008 in-order to improve data retrieval efficiency- Performed a wide variety of tasks and projects in a team-oriented environment

Lincolnshire, Il

The Systems Analyst (SA) is responsible for the conversion of client requirements into analysis artifacts and the design of test plans. The SA delivers clear analysis, test plans, and standard operating procedures which accurately reflect the technical capacities of the system and address the requirements of the client. The SA is also responsible for coordinating and coaching other team members (i.e., Setup Analysts) on system configuration and test execution of the technology platform. This can include new client implementation, an extension of services for a client, or an enhancement of current services.- Implemented the Software Development Life Cycle principles and concepts- Delivered clear analysis, test plans, and standard operating procedures which accurately reflect the technical capacities of the system - Addressed the requirements a client through comprehensive analysis artifacts while leading weekly team meetings for team members in India- Responsible for coordinating and coaching other team members on system configuration and test execution of the technology platform - Helped with the extension and enhancement of current technology services for clients who are already live in the production database- Designed, updated, and delivered unit, integration, regression, and acceptance test plans- Assisted with the deployment and migration of new system updates into the production environment- Coached team members on defect management, debugging, reporting, and system specifications- Review configuration and test plan documentation and evaluate the results of test execution results- Coordinated the work, monitor task completion, and communicate team scheduling and status of Setup Configuration Specialists to the Lead System Analyst- Use SQL to query, update, and manage relational databases- Triage cross-client Personalized Communication Statement issues through the software Thunderhead and XML

The Setup Configuration Specialist is responsible for configuring and testing Aon Hewitt's proprietary Total Benefit Administration, (TBA), System based on analysis documents of client requirements. Configuring involves using graphical user interface tools to customize code to fix a system defect or update the system per change orders. SCSs are responsible for testing the code and debugging issues/defects prior to the code being moved to production.- Used best practices and methodologies for system testing and quality assurance- Implemented the Software Development Life Cycle principles and concepts- Applied relational database concepts- Used SQL to query, update, and manage relational databases- Wrote defense queries in-order to discover database and system issues- Assisted in troubleshooting system defects and system errors- Interpreted client requirements and implemented provisions to meet system functionality- Worked with JCL and SAS code- Assisted in the customization of code for various participant communication statements using Thunderhead software- Analyzed conversion error data reports to identify data verses system issues- Assisted in various advanced cross-client projects that were new to the Health and Welfare database- Able to communicate ideas in a both technical and user-friendly language

Master'S, Information Technology

Activities and Societies: Golden Key Honor Society, Iota Sigma Tau Honor Society, Net Impact

Bachelors, Media Communications

Activities and Societies: Media Club

Certificate, Full Stack Developer