Software Engineer Sql Server

Andrei Khodzitsky

Email: a ****************@***.***

Phone: 7-03-350-****

OBJECTIVE AND PROFESSIONAL SUMMARY

To obtain a technical leadership position that utilizes my 15 years of software development experience

(including over 7 years of leading software development teams and projects and over 8 years of

independent consulting), extensive experience with the entire software development life cycle (SDLC),

project management, configuration control management and production support.

QUALIFICATIONS

Industries: Telecom Billing, Mortgage/Finance, Data Warehousing.

Databases: DB2 UDB, Oracle, Sybase, Access, MySQL, SQL Server.

Languages: C, UNIX/Linux shells, SQL, PL/SQL, Perl, Pro*C, COBOL, SAS, ASP, VB Script, Java Script,

HTML, XML, JCL.

Tools & Utilities: DataStage, Informatica, Erwin, Vantive, Remedy, Autosys, Maestro, AWK, DBstat, Toad,

SQL*Plus, Visio, MS Project, Test Director, AspPdf.

Version Controls: ClearQuest, ClearCase, Amdocs CC, Merant PVCS

Systems: Amdocs’ Ensemble, Verizon’s ExpressTrack, Freddie Mac’s MIDAS and Project Enterprise.

Platforms: UNIX, MVS/TSO, Windows NT, DOS, WWW, Client/Server (NT).

Security Clearance: Public Trust.

PROFESSIONAL EXPERIENCE

Software Engineer – ETL Architect/Developer – Consultant.

Fortis Bank, Brussels, Belgium, June 2009 – Present

Responsible for architecture, design, code construction, testing and implementation of

ETL components of Liquidity Data Warehouse, which is a apart of bank wide Liquidity Risk System

prototype. Development is done in Informatica 8.6.0, Oracle 10g, SQL Server and PL/SQL on UNIX AIX

platform.

Software Engineer – ETL Developer – Consultant.

Lockheed Martin, Merrifield, VA, August 2008 – June 2009.

Responsible for all aspects of analysis, requirement gathering, design, code construction, testing,

implementation and production support of a large number (50+) of ETLs comprising 3 external

interfaces (Monster, HDB and PAN) into the Transportation Security Administration (TSA) Non

Integrated Data Warehouse (NIDW). Development was done in IBM DataStage 8.5, Linux scripts, SQL

and PL/SQL using Oracle 10g and SQL Server database.

Executed performance analysis and performance tuning of a number of key ETL processes.

Performed data and process modeling, data analysis, data cleansing and ad-hoc report generation.

Installed and configured WebSphere Information Integration suite.

Provided 24*7 production support of all NIDW ETL systems. Supported new environment creation and

application deployments. Documented and provided status to the program management.

Software Engineer – Architect/Project Leader – Consultant.

Kiranco, McLean, VA, June 2007 – August 2008.

Performed analysis, requirement gathering, design, code construction, testing, implementation and

production support of a web-based real-time inventory control, order processing and billing system used

by a publishing company. Development was done in ASP, VB Script, Java Script, HTML, AspPdf, SQL,

PL/SQL and Informatica with MySQL, Oracle and SQL Server databases.

Created logical and physical data models of system's database.

Software Engineer – ETL/Data Architect – Consultant.

Freddie Mac, McLean, VA, May 2004 – June 2007.

Designed, developed, tested, implemented and production supported CDW (Corporate Data

W arehouse) ETLs in C, Pro-C, SQL, SQL PL and SAS on Unix (AIX) and Mainframe platforms utilizing

DB2 UDB and DataStage.

Managed investigation and resolution of production issues utilizing ClearCase, ClearQuest, Remedy,

ERWIN and Vantive.

Executed performance analysis and implemented performance improvements in main ETL processes

including SQL tuning using DBstat.

Performed large volume data conversion, data and process modeling, data analysis, data cleansing and

production report generation for a number of Data Marts and Operational Data Stores within CDW.

Set up and maintained Autosys job scheduling.

Software Engineer – Production Support Manager – Consultant.

Cable & Wireless, Bridgetown, Barbados, July 2003 – January 2004.

Supervised execution and production support of the EOD (End of Day) processes utilizing Maestro in

operations of Amdocs Ensemble CC&BS (Customer Care and Billing System) for a wireless

telecommunications operator.

Managed investigation and resolution of production issues arising in execution of Ensemble batch

processes utilizing Test Director.

Executed deployment and production preparedness testing of 100+ batch processes comprising EOD in

the course of new CCB&S version rollout and new billing cycle setup.

Defined and implemented new operational procedures on the production support team. Automated

building and deployment processes for more than 50 applications with multiple environments and

different technologies.

Software Engineer – Training Specialist – Consultant.

CenturyTel, Monroe, LA, January 2002 – July 2003.

Managed investigation and resolution of issues arising in operations of MAF, MPS and EMS modules of

Amdocs Ensemble CC&BS.

Tested, validated and coordinated new Ensemble software releases for MAF/MPS/EMS.

Provided architectural and technical expertise supporting conversion of Amdocs CC (Configuration

Control tool) into Merant PVCS.

Conducted knowledge transfer to production support team members on operations of MAF, MPS and

EMS modules of Ensemble and use of Amdocs CC.

Coached production support team members on code development in C, Pro*C, COBOL, PL/SQL,

ASP,VB script, JAVA script and KORN shell using Amdocs integrated development environment on

UNIX/Oracle/SQL Server platform utilizing Toad and SqlPlus.

Software Engineer – Consultant.

Freddie Mac, McLean, VA, September 2001 – January 2002.

Designed and developed DB2 UDB ETL code generator combining C, Pro C, SQL, KSH, AWK, Perl,

Autosys and OptiLoad interface for CDW (Corporate Data Warehouse).

Performed large volume data conversion, data and process modeling, data analysis, data cleansing and

production report generation for a number of Data Marts and Operational Data Stores within CDW.

Software Engineer – Team/Project Leader.

Verizon, Arlington, VA, October 1998 – August 2001.

Designed, developed, tested, implemented and production supported large USAGE processing

application - EPP (AMA) - based on Amdocs MAF platform. Development was done in C, Pro-C,

COBOL and SQL on Mainframe using DB2.

Lead team responsible for development and maintenance of Product Catalog module of Express Track

CC&B system.

Software Engineer.

Amdocs, Ramat Gan, Israel, May 1994 – March 1998.

Developed and maintained MAF module of Ensemble CC&BS in C, SQL and PL/SQL on UNIX and

Mainframe using Oracle and DB2 for a number of wireline and wireless telecommunications companies

such as Verizon, AT&T and Telstra.

Functioned as configuration control manager using Amdocs CC.

EDUCATION

M.S. in Information Systems Technology, George Washington University, Washington DC, 2001.

B.S. in Mathematics and Computer Science, University of Haifa, Israel, 1994.

Contact this candidate