Data Sql Server
Resume:
VIOLETTA AYRAPETOVA
New York, NY 1005
**********@*****.***
SUMMARY
An accomplished Information Technology professional with an extended business background specializing in the full life cycle of the software development process, including requirements gathering, prototyping, coding, testing and maintenance. Capable of managing technology projects from concept to completion with a remarkable deadline sensitivity and ability to multitask in a fast paced environment.
PROFESSIONAL EXPERIENCE
American International College 2016 –Present
SQL Developer (contract)
Work with Business Analysts to understand and analyze the different business requirements,
and perform ETL processes using SSIS tool for SQL Server.
Created mappings and workflows to extract and load data from relational databases, flat file sources, and specific file formats.
Designed/Developed complex queries efficiently and used various transformation tasks to create ETL packages for data conversion including MS SQL Server, and Informix database on the linked server.
Loaded flat files (4GB) data into database using SQL Server Integration
Services (SSIS) after applying various transformations like Lookup, Conditional Split,
Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
Generated various reports like parameterized, drill down, drill through, sub reports using SQL Server Reporting Services (SSRS) for various projects.
Developed, implemented and maintained Cognos report 10 using Report Studio, Query Studio, Cognos Workspace, etc.
Mount Holyoke College 2013- 2015
SQL Developer (contract)
• Utilized MS SSIS 2008 R2 and MS SSIS 2013 to integrate different data sources, to filter, to merge and to transform the data according to set of business rules and to load the transformed data into the destination target - data warehouse.
• Translated functional and technical specifications into efficient, scalable and maintainable BI solutions.
• Utilized SSIS 2013 to create stored procedures for generating calculated data based on existing values. Developed a solid understanding of the various sources that feed into the warehouse and assist in laying out the overall architecture of the ETL application.
Implemented slowly changing dimensions (SCD) and changed data capture (CDC) procedures. Created supporting documents that describe in details the overall ETL architecture, and data dictionary.
• Developed reports through SSRS - Query Builder.
Asnuntuck Community College 2012-2013
Systems Analyst (contract)
Provided and managed special assistance and technical implementation of the Banner software system for financial ERP system. Maintained and generated new reports for users utilizing MS SSRS 2008.
Connoly 2010-2012
System Analyst (contract)
Designed, created and modified reports in Crystal X with performing integration testing utilizing MS SQL Server 2007. Developed and modified stored procedures in MS SQL Server to increase system performance. Evaluated data mining request requirements and developed the queries for the requests.
Celebration Foods LLC 2006 –2009
Applications System Developer
Worked with project management and business analysis teams to generate requirements and developing and implementing data analysis and data quality utilizing SSIS SQL 2005.
Identified discrepancy in system functionality and developed support procedures defining system strategy to bridge the gap between technical and functional individuals implementing ERP MAS500 Financial system. Created Crystal reports using SSRS to provide data analysis.
US Food Service 2004 – 2006
Regional HR Data Analyst
At a regional level provided technical implementation of PeopleSoft 8.8 HR module for successful design of databases and reports to facilitate superior performance. Developed reports in SQR and SQL in PeopleSoft HR module utilizing Oracle RDMS. Used Process Scheduler for running different Processes and generate various organizational decision making reports. Generate Crystal reports per user’s request.
Modified existing Payroll and Benefit Administration reports in SQR.
UMASS 2001 – 2004
Systems Analyst
Developed, customized and modified reports in MS Access for interactive processing with users.
Involved in creating of queries for reporting using PeopleSoft HRIS system.
Created various reports using SQR, Crystal and SQL utilizing Oracle 11i RDMS.
Participated in requirements gathering and functional interviews with users to determine their specific needs for system enhancements and modifications.
GUNTHER INTERNATIONAL, Norwich, CT 1997 – 2001
Programmer / Analyst
Developed and enhanced embedded software for document finishing/high-speed mailing equipment.
Designed and implemented a statistical reporting application.
Developed conversion utilities to re-format the system log files to interface with third-party software products with extensive use of C and C++.
Designed test procedures for verification of software functionality.
NEW AMERICAN FINANCIAL SERVICES, Hartford, CT 1995 -1997
Programmer / Analyst
Designed, coded and maintained programs in MS Visual C for business application. Systems components included order entry, inventory control and sales/cost analysis.
Used SQL*Plus to manage Oracle RDMS database with implementing DML statements.
EDUCATION
BS, EE, University of Gas and Oil, Russia
Contact this candidate