We provide IT Staff Augmentation Services!

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.

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
  • 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.
  • Perform analysis, design, and project management.

Confidential

Information Analyst

Responsibilities:

  • Generation of Confidential 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.
  • 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, Confidential, 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.

Confidential

Senior Programmer Analyst

Responsibilities:

  • I met with new and existing clients to define their software requirements.
  • I developed prototypes, wrote and test software enhancements and added modules to Confidential in Visual Basic 3.0, VBA script, and Confidential proprietary controls to look, feel, and function like Confidential Software.
  • I wrote code in Access and Confidential for clients to enable their custom software to be interfaced to Confidential .
  • Database table design, procedures, and functions in Pervasive Btrieve SQL.
  • I wrote all reports for our custom modules and custom Confidential reports in R&R report writer, FRX Reports, and Crystal reports depending on the version of Confidential and the Client Requirements.
  • I performed extensive testing, documentation, implementation, training, and support.

Confidential

Programmer Analyst

Responsibilities:

  • Utilizing Visual Basic version 3.0, Sybase T - SQL, and SQR I was a part of multiple development teams to replace all Agency legacy applications (COBOL, C/C++, and Paradox) with one new and robust application called written in VB3 and T-SQL.
  • I attended and led RAD/JAD sessions, worked within module teams to design, write, test, implement, train, and support the application.
  • I wrote data conversion programs utilizing SQR and wrote reports for all application modules in SQR.
  • Provide initial and updated documentation for requirements, systems, and training.
  • Develop test plans and kiosk training materials.

Hire Now