Data Warehouse Analyst Resume Profile

Summary of qualifications

Application programming: Visual and Unix C , Visual Studio 2005/2008/2010, Report Builder 3.0, Perl, VB 6, Java, JSP, Class, Crystal Reports 7/11, WebFocus 4.3.6/ 5.3/7.1

Database programming: SQL Server 2000/2005/2008/2008R2, SSIS, SSRS, PLSQL Oracle , MS Access 2000, Phoenix, Informix, DB2 Fiserv.

Database applications: DbWrench, RSScripter

Web programming/ developments: HTML, XML, Perl, TCL, CGI, JavaScript, Tomcat, Weblogic, Eclipse, Share Point 2010

Operating systems: Windows 3.1/95/98/Me/XP/7, DOS, UNIX, and Linux.

Network platforms: Windows NT 4.0, Windows 2000/2003/XP/2008/2008R2.

Clients: Lotus Notes 4.6 8.0.2, Novell Client,SmartBatch32, SmartBatch Enterprise 2006, ActiveBatch 6/7/8/9.

General Applications: MS Office 2000/2003/2007/2010.

Internet Browsers: IE, Mozilla, Chrome

Russian Language.

Work Experience

Confidential

Data Warehouse Analyst

Provided guidance in upgrading Reporting Services to new higher version.
Helped supporting existing reports and create new ones as needed.
Analyzed and created new procedures/training to improve efficiency of reporting team.
Determined database/data mart business requirements. Created the logical and physical database/data mart design for Data Warehouse.
Helped purchasing department with analysis and recommendations for new third-party software.
Created dimensions and fact tables to analyze expense, purchasing and revenue data.
Learned Analysis Services SSAS to be able to provide support to existing cubes and create new ones as needed.
Database programming: SQL Server 2005/2008/2008R2, SSIS, SSRS, SSAS.

Confidential

Programmer Analyst/System Analyst

Analyze assignment objectives and determine how to meet goals and schedules
Support existing and create new reports for all departments within the company.
Responsible to support and create new Integration packages processes and load client's data into our SQL Server environments
Provide database support including data modeling and creating stored procedures.
Provide support to all existing Reporting and non-reporting store procedures.
Work closely with DBA's on designing and implementing Data Warehouse.
Monitor and support all of the company report cycles.
Support and maintain payment activity with card payment companies.
Maintain company's intranet in providing easy to use tools and report retrieval.
Analyze assignment objectives and determine how to meet goals and schedules.
Help analyze core application data to identify bugs and application errors.
Converting all existing WebFocus reports and number of Crystal Reports into Reporting Services.
Work closely with people from other departments to help in developing different system projects.
Help support various application that is being used by the company.
Conduct user training on use of the new and existing software and information on the company core business.
Worked closely with other departments to achieve and support PCI Certification and SAS70 Certification for the company
Batch scripting.
Database programming: SQL Server 2000/2005/2008/2008R2, SSIS, SSRS, DB2 Fiserv.

Confidential

Programmer Analyst

Convert flat files into reports for Clients.
Created reports using Perl and its modules.
Use Perl, TCL, HTML, JavaScript, JSP, and PHP to develop websites to serve as utility applications that allow clients to control IVR processes such as allocating customers between call centers and executing calls to be out dialed.
Detail emphasis in producing well-organized SQL queries that contributes to application success and efficiency using Informix and DB2 databases.
Automate most of the scripts that loads data or creates reports on the daily basis.
Provide quality control of the data for the client and account managers.
Construct Web page to view the daily-created Excel reports or statuses of live application.
Create programs to accept the calls on IVR and by using voice recognition VRU to process these calls.
Work with several of departments on creating the project to meet client requirement.
Create applications using various different languages and provide documentation and support to the application created.
Work closely with people and provide guidance to other on developing the project.

Confidential

Intern

Intern for West Interactive Division
Constructed web sites using TCL and Perl scripting languages and HTML that will serve as the interface for maintenance of an Informix database.
Designed and implemented an Interactive Voice Response program using Class code.
Created reports for Interactive Voice Response program using Perl, Shell Scripting and TCL.

Confidential

Intern

IT support of computer software and hardware.
Connected all of the computers to each computer to the server to be able to access files from any computer in the building.
Provided training on Access, Excel, Outlook 2000, NT Server, and WindowsXP.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship