Summary:

Information and Management Systems Analyst with specialization in data extraction, report building, documentation and testing. Excellent communicator who works well individually as well as within a team-oriented setting. Strong project management skills with a wide scope of industry knowledge.

Skills:

• Experienced with Visual Studio, SQL Server BIDS, SSMS, SharePoint Developer and TOAD for Data Analysts, AS400.

• Comfortable writing SQL queries to SQL Server 2005, 2008 and 2012 and IBM DB2.

• Comfortable with Joins, Stored Procedures, Views.

• Brief knowledge of programming languages VBA, VB, C#.

• Experience with editing/creating Sharepoint forms, pages and workflows with SharePoint Designer.

• Advanced experience with most Microsoft Office products.

• Testing and tracking of enhancements to UIs and back ends using Application Lifecycle Management (ALM).

• Use technical and operational experience to integrate data from diverse areas.

Experience:

Insight Global Data Analyst; Houston, Texas: October 2015 – January 2016

• Perform data cleansing, validation and testing

• Perform maintenance and enhancements to the Encounter Data Processing System database and supporting DTS, ETL, SSRS, and SSIS jobs

• Perform technical analysis and data mining for data reporting requests from internal and external customers.

• Acquire and abstract primary or secondary data from existing internal or external data sources

• In collaboration with others, develop and maintain databases and data systems necessary for projects and department function.

• In collaboration with others, interpret data and develop recommendations based on finding

• Training on EDI process.

Bank of America Consumer Product Strategic Analyst II; Ft. Worth, Texas: November 2012 – July 2015

• Project management and/or active involvement of data collection, analysis and reporting.

• Build from scratch, document, test and publish SQL queries for business customers reporting needs.

• Leverage data systems including SQL Server (2005 to 2012) and DB2 for reporting through programs such as Excel, Access (VBA).

• Generate new reports to replace aged reports by locating original data sourcing from SQL server tables.

• Utilize SSIS to create reports and data sets for stored queries.

• Oversee ETL processes for teams’ databases using SSIS.

• Perform data management and junior administrative duties for the team’s database.

• Site collection administrator/designer of multiple reporting SharePoint sites for my team.

• Coordinate with LOB during UAT to solve issues or concerns until sign off of enhancement.

PeopleLogics Business Analyst (Contract); Irving, Texas: May 2012 – November 2012

• Alter XML documents for loading into database.

• Designs and creates tables, charts, graphs and reports to support findings and develop recommendations.

• Create processes and tools to support and automate processes for the Data Enrichment Team.

• Project management and/or active involvement and ownership of data collection, analysis and reporting.

• Development and standardization of tools, methodologies and procedures for data and information collection.

• Ongoing process improvement through utilization and creation of Access databases, SQL queries, VBA scripting and audit procedures.

New Breed Logistics Supply Chain Planning Analyst; Ft. Worth, Texas: May 2011 – May 2012

• Communicate findings to the team resulting from weekly/daily reports.

• Research and find solutions to issues involving inventory imbalances.

• Develop ad-hoc reports upon request from the team and management.

• Provide analysis results to end users in an easy to understand format.

• Collaborate with different departments to understand the departmental needs and intentions of the needed reports.

• Anticipate future needed reports and create new procedures to improve reporting process, automated scripts.

• Support and train team members with reporting, software issues and new procedures.

• Develop and execute reports pulled from databases using Toad for Analysts.

• Analyze historical trends to project the impact on future forecasting.

Charter Communications QA Auditor; QA Audit Investigator; QC Technician and Technical Clerk;

Ft. Worth, Texas – June 2002 – May 2011

• Analyze and develop data solutions.

• Report daily/weekly technician production numbers, statistics, and trends for audit team to management.

• Consistently maintain data concerning audit team's performance for monthly, quarterly, yearly evaluations.

• Write SQL queries pulling data from an Oracle database for reports on daily or weekly basis.

• Assist our in house programmer in writing new programs for the Audit Team.

• Write instructions for various tasks to be completed by personal new to office.

Education:

Tarrant County College, Hurst, TX

• Certificate Earned: Database Programming

Studying online for SQL Server certs, SAP Basic and ASP.NET.

Military Service:

1994-2002 U. S. Army Reserves. Rank PFC, M.O.S. 13E

• Army Achievement Medal

• Command Sergeant Major Medal

Contact this candidate