Aleksandr Alksnis Email & Phone Number

Plymouth Meeting

 Worked on SSIS packages conversion, migration and server deployment from 2008R2 to 2013 SSDT. Build Staging DW database for new internal Health Advocate processes. Build SSIS processes to load data from multiple environments into Staging DW. Worked with Tableau report development team and build views for internal Health Advocate Dashboard project.

Princeton, New Jersey

IT- CORE Department (Commercial Operation and Risk)Senior level IT System Analyst – Lead requirements analysis, solution design and implementation to support complex end-user self-service reporting and analysis for NRG CORE Departments. IT- Finance Department Senior level IT System Analyst - Managed development and support of all company related Financial.

Horsham, PA

Performed full project life-cycle for the Nextgen EMR (Electronic Medical Records) software, including development, maintenance and supportWorked directly with clients to troubleshoot and fix various database and software issues using WebEx Provided custom support for merging databases on client’s side using WebEx and database management toolsTroubleshoot.

Princeton, NJ

Migrated an MS Access Database to SQL Server 2005 using Import/Export Utility.Redesigned and Normalized migrated database by utilizing new SQL Server 2005 futures. In addition, created indexes and statistics on the tables to improve database performance. Analyzed and reconciled data between two databases, Oracle 9i production database and SQL Server 2005.

Ewing, NJ

Performed data correction, data parsing, data cleansing and data transaction quality control using SQL Server 2000 and RetailRemote software.Developed T-SQL stored procedures, triggers, SQL Server Jobs and DTS packages for data load, transformation, and data extraction. Optimized SQL queries for efficient data load for databases over one terabyte in.

Cinnaminson, NJ

Created several reports containing sub-reports using Crystal Reports 8.5.Added and modified formulas to automate report processing.Modified tables and queries in Access 2000 database in order to optimize performance of the reports

Conshohocken, PA

 Designed and implemented large legal information systems for clients such as: Merit Systems Protection Board, Food and Drug Administration, Philip Morris, Inc, Federal Deposit Insurance Corporation, Federal Election Commission, Marriott International, etc. Each system gives users the ability to manage every aspect of the organization - cases, records.

East Brunswick, NJ

Designed and developed Claim Financial Adjustment System (CFAS).  Participated in all phases of Client/Server Application development.  Designed GUI and applications using Visual Basic 5.0 and Oracle 7.3.  Provided post implementation production support and problems resolution.