SUMMARY:

• 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

TECHNICAL SKILLS:

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

EXPERIENCE:

Sr Data Analyst

Confidential, Plano, TX

Responsibilities:

• 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

Sr Data Analyst

Confidential, Plano, TX

Responsibilities:

• 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.

Technical Analyst

Confidential, Richardson, TX

Responsibilities:

• 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

Sr Data Analyst/SQL Developer

Confidential, Plano, TX

Responsibilities:

• 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

Developer

Confidential, Dallas, TX

Responsibilities:

• 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

Sr. Data Analyst/Business Objects Developer

Confidential, Plano, TX

Responsibilities:

• 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

Project Manager/Systems Architect

Confidential, Dallas, TX

Responsibilities:

• 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

Systems Consultant

Confidential, Plano, TX

Responsibilities:

• 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

Systems Development & Operations Manager

Confidential, Dallas, TX

Responsibilities:

• 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

Analyst/Developer

Confidential, Dallas, TX

Responsibilities:

• 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

Systems Consultant

Confidential, Dallas, TX

Responsibilities:

• 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