SUMMARY

IT Professional with extensive experience of application development and system analysis in various mainframe, client server and PC environments. Effective problem-solver with exceptional technical expertise and strong goal orientation. Proven ability to take analysis to development, effectively develop team members by building competencies through coaching and on-the-job training. Creative, motivated, customer focused, well organized, detail oriented, fast learning, very productive with excellent analytical and troubleshooting skills. Deep knowledge of ETL, Datawarehouse. More than 8 years of AbInitio. More than 5 years of Unica. Outstanding ability to work independently or as part of a collaborative team.

Seeking a Senior level position in application programming and systems analysis.

Software Skills

Ab Initio
Unica (EMM) Marketswitch
Oracle
SQL
Teradata
C
C++
Perl
Unix Scripting
Cold Fusion
COBOL
COBOL II
Micro Focus COBOL PL/1
EASYTRIEVE
SAS
OS/JCL TSO/ISPF/PDF
CICS
IBM Utilities
Fileaid
Xpediter
Animator
Endevor
Maestro OPCA(CA11) Changeman Panvalet
MS Word
MS Excel
MS Access
MS Visio
MS Project
Microstrategy
CL
FTP/SFTP

Hardware

IBM Mainframe IBM-Compatible PC
AS/400

Database

ORACLE
DB2
Teradata

Operating Systems

MVS/ESA
MS DOS
WINDOWS
UNIX Based

EXPERIENCE

Senior Associate2000 2009
Confidential, Riverwoods, Illinois
Abinitio Experience:

• Abinitio Developer for Daily and Monthly common Objects. Applications gathered input information from multiple input files and Oracle databases, separated on frequency of creation. Final output went to Mfiles . Used version was 1.10. Applications used different components, including Normalize and Denormalize, Partition, Filter by Expression, Merge, Sort in Groups, etc. Was developed in 2002-2003.
• Lead Programmer for Automated Audit System. Applications checked more than 200 fields used in selection cardmembers for marketing campaigns. Applications used a lot of different Abinitio Components, including numerous Rollups . Output went to flat files and automated reporting system. Application was developed in years 2003-2004 and was re-written in 2008, giving ability customers to see output in XML files. Used version was 1.13 and in 2008 1.14.
• Member of Development team for USA UNICA ETL. ETL included more than 20 ABI applications. Applications extracted and transformed information from more than 40 different files and Oracle databases and did final load into Unica database (Oracle). During conversion behind Abinitio next programming languages and systems were used: Cobol, JCL, DB2, SAS, Oracle, Unix, Unica, Perl. Conversion was done in years 2003-2005. Version was 1.13.
• Technical lead for maintenance and support USA ETL and Automated Audit System, Daily and Monthly Objects All applications were Abinitio based. 2003-2006.
• Lead Programmer for UK Goldfish Unica Data Warehouse. Major responsibilities included development and support of Unica Front End ETL and Internal Oracle database Source Code Management System utilizing ColdFusion for Front End. Unica ETL included more than 40 Abinitio applications and was developed by International team from US, UK, and India.
  Used version was 1.14 (EME). 2006-2008.
• Project Lead for UK Goldfish Unica production support (Front End ETL, run campaigns, Back End ETL). 2006-2008,
• Data Analyst for integration Abinitio Telemarketing System into Unica ETL. All projects related to Abinitio were developed according with Software Development Life Cycle (SDLC) requirements and documented. 2009, Version 1.14.

Unica Experience:

• Member of the team, responsible for Conversion Legacy System from mainframe to Unica. Was responsible for profiling data loaded on front end in the different Unica tables and design tables as well. Worked with data modeling team and assigned DBAs. October, 2003 April, 2004.
• Business analyst for new campaigns (especially e-commerce) converted to Unica. Worked with business partners (marketing team). Gathered user requirements, facilitated white boarding session, created required by project development process (PDP) documentation.

May, 2004 May, 2005.

• Campaign and flowcharts developer. Worked closely with business partners in US and UK. Responsibilities included analysis of SQL and tuning flowcharts in the case of abnormal run time. Another major responsibility was analysis of data and providing recommendations for configuration processes. May, 2005 February, 2008.
• Developer for strategic segments for major campaigns areas (Cash, Balance Transfer, New Initiatives, E-commerce). February, 2004 July, 2005.
• Administrator for Unica Security manager. July,2005 - January, 2007.
• Developer for Campaign folders and required Unix scripts. Another responsibility included addition of new requisites to campaigns (Campaign owner, campaign codes, etc) and required because of this web server bounce. May, 2005 July, 2006.
• Project Lead for UK Goldfish Unica production support (Front end ETL, run campaigns, Back End ETL). Campaigns were running in US and delivered from Unica server via mainframe to UK .July, 2007- February,2008.

Other related to Campaign Management experience:

• Mainframe developer (April, 2000 June, 2001), Technical Lead (June, 2001 April, 2004) for Legacy Customer Campaign Management System. (COBOL, JCL, DB2, Fileaid, IBM Utilities).
• Coordinator for development, testing and implementation team projects for offshore and onsite resources. 2004-2008.
• Release coordinator for Endevor and Maestro. 2001-2007.
• Business Analyst for ongoing team small to medium projects. Closely worked with the business partners to define business requirements. Created required Project documentation Project Proposals, High level and Detail Level Technical Designs. Developed User Cases, Test Plans and Test Cases. Conducted and analyzed results of String, Regression, Unit and User Acceptance Tests. 2008-2009.

Senior Systems Consultant 1998 1999
Confidential,Naperville, Illinois

• Participated in the technical and coding design of functional modules of Dining ala Card system using COBOL, Easytrieve, JCL , VSAM utilities, File Aid.
• Modified existing Cobol and Easytrieve programs using Endeavor and Xpediter.
• Was responsible for maintenance of enrollment process for participating members from major USA and International airlines.
• Created new job streams using OS/JCL

Software Consultant 1996 1998
Confidential, Chicago, Illinois

• Participated in the technical and coding design for the projects of the new and existing lines of auto-insurance, using CSP, CICS, COBOL,Flowcharting 3, LOTUS 1-2-3, JCL , CL , Changeman, AS/400 and Mainframe.
• Modified existing applications for discounts, coverages and surcharges
• Designed and implemented new CSP application for Allstate New Jersey Insurance Company.

Programmer/Analyst 1995 1996
Confidential, Chicago, Illinois

• Modified and maintained existing claims analytical information system, using PL/1, COBOL, OS/JCL and SAS System

Systems Analyst 1983 1994
Confidential,Moscow, Russia

• Evaluated effectiveness of information processing systems.
• Analyzed project specifications and flowcharts.

Senior Programmer 1971 1983
Confidential,Moscow, Russia

• Analyzed and appraised text-retrieval system. Elaborated and programmed problems of calculation production powers. Programs used linear and dynamic programming methods.

EDUCATION

Java Developer Program
Computer Career Program
Advanced Courses in Programming
Master of Science

DFS Training

• Based and Advanced ColdFusion, 2009.
• Oracle SQL Tuning, 2006
• Based Perl Scripting, 2006
• Advanced Ab Initio, 2006.
• Based and Advanced Unica Tools, 2005.
• Based Marketswitch, 2005.
• Unix and Korn Shell Scripting, 2002.
• Based Ab Initio, 2001.