Sr. Data Research Analyst Resume

SUMMARY:

Over twenty years Information Technology experience: applying systems solutions in the financial, manufacturing, and medical industries. A result oriented individual with proven ability to develop and enhance effective software and reporting programs and provide documentation for those programs. Experience includes Client Server and Mainframe environments.

SKILLS SUMMARY:

SQL 2008 stored procedures, views, DTS, ETL, SSIS, and SSRS. Aqua Data, Crystal XI, Business Objects, Visual Basic 6.0, Visual FoxPro 8.0, Access including database, procedures, data entry screens, and reports. Business Objects Universes and Xcelsius dashboards. Qlikview data extracts, transforms, data models and dashboards. I also have experience using Visual Source Safe, TFS, and SVN source control applications.

EXPERIENCE:

Confidential

Sr. Data Research Analyst

Responsibilities:

I consult with internal customers.
I write data queries from our Oracle and SQL Server databases for reporting in either Crystal Reports, SSRS, or Qlikview.
I create SSIS packages, stored procedures, and views in our SQL Server databases.
My role with Qlikview is to create data extracts, data transformations, data models, and front end dashboards.
Our main data sources are Epic Clarity and Lawon.

Confidential

Business Intelligence Developer

Responsibilities:

I wrote complex stored procedures in SQL for Crystal XI and 2008, Microsoft Reporting Services and Access reports.
I created views, functions, and DTS in SQL Server 2005.
Business Objects Universes, Xcelsius, Web Intelligence, Crystal XI, Crystal 2008.
I published Crystal reports to Business Objects Central Management Console.
I worked with the Business Unit to define requirements for all enterprise reporting.
I am now working with Crystal 2008 and Business Objects 3.1 new features that include universes as a data source and Xcelsius dashboard features connected to Crystal 2008 with SQL stored procedures as the data source.
I was also the Enterprise Reporting Release Manager.

Confidential

Systems Analyst

Responsibilities:

Define requirements, modify and enhance Sage Pro based on Company and user requirements.
Sage Pro is a Sage Software ERP written in Visual Confidential .
Perform analysis, design, and project management.

Confidential

Information Analyst

Responsibilities:

Generation of Mortgage industry reports utilizing SQL Server 2000 and Microsoft SQL Reporting Services.
Perform data analysis, ETL, DTS, report design and deployment.

Confidential

Senior Developer, Analyst, Project Manager

Responsibilities:

Coordinate and manage software development efforts for client meetings.
Work with internal staff and external clients to gather requirements for programming and reporting needs.
Maintain, enhance, and create new features of our custom application utilizing Visual Basic, Visual FoxPro, C/C++, SQL, and Crystal. SQL 2000: DTS client data from text and, or excel to SQL databases.
Define database structures, indexes, performance tuning, backup and restore, create and test stored procedures, triggers, user functions, and user data types.
Write registration, housing, and financial reports for meetings accessed internally and from the web.
Generate DTS packages to provide scheduled data to clients.
Mentor development staff, project management, web design data interface and stored procedures.
Provide initial and updated documentation for requirements, systems, and training.
Work with the Sales and Marketing and Financial departments to define requirements for custom reporting needs.
Write and test stored procedures to generate Crystal reports for the Sales and Marketing and Financial departments.
Write and test stored procedures to generate reports via SQL Reporting Services for our custom Event Guide application.

Confidential

Software Engineer

Responsibilities:

Design and development team leader for Advanced Allocations software.
Wrote code to interface our software to Great Plains Dynamics, Solomon, Epicore, and an open integration for other ERP software.
Participate in requirements gathering with upper level Management and Marketing to define version enhancements.
Database table design, stored procedures, and triggers in SQL.
I wrote VB6 code following defined standards, worked with core development team to implement application requirements using core components, and worked closely with QA staff for testing and modifications.
Provide initial and updated documentation for requirements, systems, and training.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship