Sr Data Analyst

Edward Lee Coyle

**** ****** **** 972-***-**** Tel

Plano, TX 75025 214-***-**** Cell

ac306v@r.postjobfree.com

Experience in developing and managing systems within budget and on-time.

• Able to work independently to deliver key milestones

Managed projects with on time completion

Team motivator with ability to identify and solve complex problems

Able to work independently to deliver key milestones

• Installed and administrated Informatica Power Centers

• Administered Informatica Metadata Manager and Glossary Development

• Analyzed complex and large volume of data from multiple sources

Developed Business Objects universes and reports

• Designed complex transactional and analytical data structures

Experience

March 2016 to November 2017, Sr Data Analyst XO Communications, Plano, TX

• Managed Data Governance Project to install standards for data and processes

• Installed, configured and administrated Informatica Proactive Monitoring

• Installed, configured and administrated Informatica Metadata Manager.

Installed, upgraded and administrated Informatica Power Centers

• Created and Managed Infomatica Metadata for hundreds of ETL workflows

• Created and Managed Model development

• Managed Informatica Power Center Workflows/Mappings

June 2015 to December 2015, Sr Data Analyst, Capital One, Plano, TX

• Wrote UNIX shell automation scripts for SQL Server, Teradata and oracle programs

• Converted programs to run under SAS

• Wrote SAS programs in SAS and proc sql

• Wrote SQL Server and Teradata scripts.

July 2014 to December 2014, Technical Analyst, Blue Cross, Richardson, TX

• Coordinated Narrow/Tiered Networks mapping project

• Developed complex ETL maps for Teradata and DB2 Databases

• Developed complex ETL maps for Data Vault Data Model Databases

• Developed ETL packages in Data Stage

• Developed complex SQL queries for analysis and as a part of mapping

July 2013 to May 2014, Sr Data Analyst/SQL Developer, Bank of America, Plano, TX

• Developed complex T-SQL queries for analysis of Loan Modification Data

• Developed SSIS packages to load various data sources to sql server

• Developed SSIS package to automate excel downloads for reporting

• Developed Access Database for Loan Upload History

April 2013 to July 2013, Developer, Men’s Edge Medical Clinics, Dallas, TX

• Developed SQL Server database for Medical Clinics patient record and pharmaceutical tracking system

• Designed and managed team which developed asp.net interface to the SQL Server database

October 2012 to April 2013, Sr. Data Analyst/Business Objects Developer, Capital One Bank, Plano, TX

Analyzed large datasets in Teradata data warehouse

• Coordinated the realigning data sources project

• Developed SQL scripts for data loading and table creation in Teradata

• Managed SAS scripts and report outputs

• Mapped complex data sources to move to data warehouse

• Worked with Empower and Unifi loan origination systems

• Developed universes and reports in Business Objects versions 3 & 4

• Mapped complex data sources for analysis and report development

July 2011 to October 2012, Project Manager/Systems Architect, Homevestors, Dallas, TX

• Managed Project with outside and in-house developers

• Designed complex SQL Server database and asp.net front-end

• Upgraded servers to server 2008 and SQL Server 2008

• Mapped data sources and used SSIS for data migration and data loads

• Installed SSRS 2008 Reporting Services

• Managed SQL Server 2005 and 2008

December 2008 to July 2011, Systems Consultant, Afinian, Inc, Plano, TX

• Performed data analysis on complex data

• Developed legal reporting database in SQL Server

• Did analysis on Oracle databases

• Developed DataMart and setup Informatica for data migration

• SQL Server databases for medical management company

July 2005 to December 2008, Systems Development & Operations Manager, Intellecare, Inc, Dallas, TX

• Managed the development of a large healthcare clinical records repository

• Worked with Clinics on system installation and training

• Developed and managed a Linux/Windows network

• Setup SSIS and SSRS for internal reporting

• Setup DTS for data migration

• Performed large scale data analysis

• Used content management software to management and publish website information

• Developed the architecture for the repository network and interface programs

• Managed programming staff including off site programmers

• Developed some of the interface programs in VB and .net

• Setup network servers with Linux with high security

• Setup and managed the network active directory, dns, exchange, switches and routers

• Developed and administered SQL 2005, Access, MySQL and Postgres Databases

• Developed company reporting with Crystal 9 and 10

March 2003 to July 2005, Analyst/Developer, Guaranty Bank, Dallas, TX

• Used SAS in data analysis and modeling

• Developed reports in Crystal 10

• Managed the development of a cost/benefit bank profitability model

• Worked with all aspects of bank including mortgage operations

• Used web management tools to publish dashboards and reports

• Managed the development of a Datamart using Informatica as the ETL tool

• Developed logical and physical data models

• Developed table structure for dimension and transaction data

• Installed Hyperion/Brio and developed reporting queries for users

• Managed the development of Hyperion/Brio reporting and drill down applications

• Developing management Reports and Dashboards in Hyperion 9

• Developed database applications for SQLServer and Access

• Managed the development and administration of SQL 2000, 2005 and Oracle databases

April 1998 to March 2003, Systems Consultant, Spherion, Dallas, TX

• Completed projects at Pizza Hut, Nortel Networks, AT&T, Washington Mutual and others

• Developing management Reports and Dashboards in excel

• Developed reports in Crystal 6 through 9

• Completed reporting system for large mortgage operations center

• Did work on Great Plains Soloman system including the development of reports with FRx

• Developed Access applications with forms, reports and automated operations

• Managed integrated windows and Novell network

• Developed database applications for SQLServer and Access

• Analyzed large volumes of data from billing and provisioning systems

• Worked with Hyperion Essbase and financial reporting

• Managed projects with MS Project, word and other tools

• Constructed complex excel spreadsheets to consolidate data from many sources

• Wrote access, SQL and PLSQL queries to work with Oracle databases and financial applications

• Developed front end applications to oracle in Access as well as stand alone applications with VB code

• Setup automated data input from Oracle database into an Access 2000 database

May 1995 - April 1998, IT Operations Manager, Hospital Staffing Services, Ft Lauderdale, FL

• Developed Access databases, crystal reports and VB/VBA code for Sales Tracking and Reporting

• Managed the development of a data warehouse and SQL report writer

• Analyzed requirements for Informix/UNIX and NT based systems

• Upgraded and managed an internal Citrix installation

• Maintained programs written in C for patient reporting and billing system

• Manager for the SCO/UNIX, NT and Novell networks, and the company wide WAN

June 1987 - May 1995, Consultant, Business Support Group, Los Angeles, CA

• Improved Point Of Sale operations for a furniture retailer

• Installed and managed AS400 operations

• Installed financial applications such as Soloman, MAS90 and other ledger systems

• Maintenance on IBM COBOL programs for financial and production control applications

• Project Manager/Business Analyst for several large system and application projects

• Setup and coded EDI interface applications for purchase orders and invoicing

• Evaluated requirements, selected hardware/software and installed systems including LAN’s & WAN’s

• Developed tracking system in FoxPro for circuit board manufacturer

• Worked with PICK operating system in developing applications which I wrote in PICK Basic

• Developed HP3000 based applications in COBOL and setup and trained operating staff

Technology Skills

Microsoft Access, Microsoft Excel, Microsoft Word, Hyperion/Brio, SAS, SQLServer, Oracle, Linux, SSRS, Microsoft Project, LAN / WAN, Visual Basic, C++, COBOL, SQL, PLSQL

Education

University of Arizona - B.S. in Economics and Computer Science

Pepperdine University – MBA Program

Additional Training in Access, SQL, VB and C++.

Contact this candidate