Resume

Sign in

Analyst Data

Location:
Upper Darby Township, Pennsylvania, United States
Posted:
November 21, 2018

Contact this candidate

Resume:

ANTHONY J. COTELLESE

215-***-****

ac7rdp@r.postjobfree.com

SKILLS:

Language and Tools: Oracle 11g, Oracle APEX, Unix, Pl/SQL, SQL, Microsoft SQL 2012/2014, Oracle SQL Developer, MYSQL, PHP, Unix Shell Scripting, XML, XSL, Web Service, FTP, Telnet, Access DB, Excel, Powerpoint, Visio, JavaScript, HTML, Visual Studio.Net, Vb.Net, Ado.Net, Asp.Net, C#.Net, Crystal Reports, ODBC, Microsoft PowerShell Scripting, SalesForce\RemedyForce, Confluence, JIRA, Tableau, Visual Studio 2013/2017, TFS.

Client Server/PC: Microsoft - Windows 7 & 10, Office 2013/2016

EXPERIENCE:

Randstad (Client: Vanguard)

12/17 - Present

Analyst\Application Support

Support all Vanguard’s Web sites and Blogs using WordPress customizable website development.

Responsible for providing technical, functional, and troubleshooting for Vanguard’s Web Sites and Blogs.

Respond to employee’s emails in a timely matter. Gather detail information and log tickets to manage and keep track of issues in JIRA.

Diagnose, replicate, troubleshoot technical issues and provide a solution.

Run weekly scrum meetings with end users\developers to discuss and prioritize outstanding issues.

QA testing for all bugs\enhancements for all Vanguard Web Sites and Blogs.

Create detailed documentation.

Cross Media Works

9/14 – 9/17

Support Analyst\Release Manager\Help Desk

Manage requirements, procedures, plans, and priorities.

Create application environments as needed.

Perform troubleshooting and triage across all technology layers.

Create custom plug-ins, scripts and tools to improve the agility of development teams.

Write and manage MOPs (Methods of procedures).

Level 2 software support to incoming tickets for software applications & granting all SQL database permissions.

Respond to customer’s emails in a timely matter. Gather detail information and log tickets to keep track of issues in SalesForce -Remedy\Jira.

Run weekly scrum meetings with end users\developers to discuss and prioritize outstanding issues.

Liaison for the Users, Business area, Developers & the QA team.

Depoyment of new microsoft software releases, code patches, bug fixes and Hotfixes.

Responsible for QA, UAT & production microsoft environments. Make sure all environments are up and running. Run daily QA software deployments.

Manage and run SQL scripts to update SQL databases and Hotfix procedures to fix software issues.

Train users on all new application functionality & enhancements.

McKesson Health Solutions

4/13 – 8/14

Support Analyst

Support Clients that use McKesson’s EMR & EHR applications.

Responsible for providing technical, functional, and troubleshooting for McKesson’s EMR & EHR applications.

Respond to customer’s emails in a timely matter. Gather detail information and log tickets to keep track of issues.

Diagnose, replicate, troubleshoot technical issues and provide a solution.

Test fixes/enhancements for the EMR & EHR applications.

Run weekly scrum meetings with end users\developers to discuss and prioritize outstanding issues.

Create and run SQL queries to insert/update tables, generate reports from SQL Server / Oracle DB.

Train users\clients on all new application functionality & enhancements.

Innovative Development LLC (Client: AstraZeneca Pharmaceuticals)

3/12 – 7/12

Support Analyst/Data Analyst

Work closely with legal department, outside counsel, business and IS resources to define requirements of litigation database requests.

Responsible for maintenance and development of MS SQL/DQL queries for data retrieval to support litigation database requests.

Manage SQL-server & Oracle database backend environment using Management Studio, Toad, data manipulation & retrieval, integration, and generate SQL queries / Excel spreadsheets data manipulation & reporting.

Prioritization, collection, review and delivery of data for litigation databases utilizing Excel v-lookups.

Create full step by step data retrieval documentation to extract data from litigation databases.

LEAF Commercial Capital Inc.

7/11 – 2/12

Support Analyst/Programmer

Responsible for the company leasing/financial application, develop business solutions, troubleshooting user issues, analyze and build enhancements to application.

Develop Web Services to transfer data to and from the Rapport Leasing/Financial Application using XML, XSL, SOAP.

Manage SQL-server database backend environment using Management Studio, data manipulation & retrieval, integration, and generate SQL queries / Excel spreadsheets for reporting.

Build Legal, Financial & Leasing documents using XML/XSL, Stylus Studio.

Level 2 technical support for Rapport Leasing application.

Train users\clients on all new application functionality & enhancements.

La Salle University

3/08 – 1/11

Analyst/Programmer

Created custom reports using Oracle Application Express (APEX) & Evisions, Argos Reporting, SQL, Access, and / Excel spreadsheets.

Provide ongoing enhancements and maintenance of the Oracle 11g SunGard Banner System.

Created Oracle, Access, and MYSQL tables.

Developed, supported & maintained university web applications in Oracle, PHP, and MySQL database environment.

Created custom applications for Banner thru the Luminis Portal using PL/SQL, SQL, UNIX, Full Development Life Cycle, performed testing as it relates to Banner upgrades in Oracle.

Developed, tested and delivered university applications including Meal Plan Application, Student Survey Application, Alumni Voting Application, Facebook Application & Student Directory Application.

Worked with Citizen’s Bank to produce a lockbox data file to load into the University Banner Financial system. Wrote the step by step lockbox data file load process from the bank all the way into the Banner Financial system.

Interfaced with academic, business, technical clients, and upper management to gather requirements and deliver their software needs.

Troubleshoot server issues, mail routing, replication, server maintenance, and email issues.

Train users\staff on all new application functionality & enhancements.

Collins Consulting Inc (Client: GSA Federal Government (Security Clearance))

2/07 – 1/08

Analyst/Programmer

Gather requirements from management/users and develop/support Client/Web applications for the HR group through the Full Development Life Cycle.

Support and assist in all IT functions of the HR group.

Perform systems analysis activities, including system requirements analysis and definition, data analysis, and produced data reports.

Provide senior level system analysis, design, development, support, documentation, and implementation of applications and databases.

Test all aspects of HR databases and procedures.

Train users\staff on all new application functionality & enhancements.

Accenture/IIC Inc (Client: Vanguard Group)

9/06 – 2/07

Analyst/Programmer

Gather requirements from management/users and develop/support Client/Web R6.5 Lotus Notes applications through the Full Development Life Cycle.

Provide senior level system analysis, design, development, support, and implementation of applications and databases for Lotus Notes.

Perform systems analysis activities, including system requirements analysis and definition, data analysis, and produced data reports.

Elevate code into the development, test, and Production environments on schedule.

Train users\clients on all new application functionality & enhancements.

Forthright Consulting Inc (Client: DuPont & VWR International)

3/06 – 9/06

Analyst/Programmer

Gather requirements from users/managers.

Develop, fix, test, support Notes Client & Web applications through the Full Development Life Cycle.

Worked on several projects, which included - Workflow, Data Integration to and from Notes, Tracking, Change Mgr, Global Directory, User Access Management, Financial Adjustment and many more.

Make databases compliant to SOX guidelines and procedures.

Performed data integration, produced reports, and wrote complete system & user documentation.

Train users\clients on all new application functionality & enhancements.

Melmark Inc. (Non Profit)

10/02 – 3/06

Lead Analyst/Programmer

Manage & developed all Notes projects through the Full Development Life Cycle and mentor junior notes developers.

Gather requirements from management/users and develop, train users, support R5 / R6 Lotus Notes applications. Second level Notes Administrator. Train users\staff on all new application functionality & enhancements.

Data integration between Lotus Notes and Oracle DB, ACCESS DB, SQL, and EXCEL.

Applications include – Client DB, IEP DB, Application DB, Health & Safety DB, Overtime Tracking DB, Policies & Procedures DB, Web Application DB’s + others.

Major Accomplishment: Database was designed to integrate with other databases that were developed for fast access to all client needs. Wrote complete system & user documentation.

EDUCATION: Spring Garden College, Bachelor of Science, Computer Science, Associates Degree in Accounting

Certifications: CLP - Certified Lotus Notes Professional.

Webmaster Program Certificate: Penn State.

.Net Technology Accelerated Certificate Program: Penn State. I developed Customer Service Banking Application using VB.NET, ADO.NET, ASP.NET, SQL, ORACLE DB, C#, CRYSTAL REPORTS.



Contact this candidate