Business Intelligence Architect/Analyst/ Developer Resume




Title
Business Intelligence Architect/Analyst/ Developer

Primary Skills
Business Objects, Cognos 8, Crystal Reports, Business Analyst, SQL, Oracle, DB/2, MS SQL Server, SQL, PL/SQL

Location
Canada-AB-Calgary (will consider relocating)

Posted
Nov-03-09

RESUME DETAILS
DMITRY LERNER

CANDIDATE: Business Intelligence Architect/Analyst/ Developer

IT Software Development ~ Data Warehousing ~ Data Bases ~ System Analysis ~ Business Intelligence ~ Business Modeling ~ Data Modeling ~ Information Modeling and Architecture ~ Banking, Finance, Insurance Systems

Forward-looking IT professional with outstanding background in software development for Great-West Life Assurance Company and solid knowledge of Financial, Banking and Insurance Systems. Consistently assumes responsibility to complete projects within time and budget constraints, both independently and on teams. Fluent in English. Technically proficient in Analysis, Design, Development, Implementation, Operation, Testing and Support of Applications for Financial Banking Systems, Insurance Companies, Data Warehousing, Government Reports and Lines of Business.

CAREER ACCOMPLISHMENTS

Great-West Life Assurance Company
• Planned, coordinated and developed high-technology software installation projects in the insurance sphere, including all steps of SDLC.
Log-On Software Company, First International Bank
• Resolve yield problems and optimized existing processes by streaming design, acquiring data, and conducting several fruitful projects in Financial Banking Systems.

PROFESSIONAL EXPERIENCE

GREAT-WEST LIFE ASSURANCE COMPANY, Winnipeg, MB 2007 - 2009
Group System Support Services, System Administration, Policy Administrative System.

Business Intelligence Architect/Analyst/ Developer
• Design, development, testing, support and implementation of Policy Administrative System;
• Work closely with project managers, system analysts, share responsibility for application delivery and quality of solutions;
• Extensive experience with Business Objects (including Universe Builder, Reporter, Designer, Supervisor, Desktop Intelligence, Web Intelligence, Central Management Console), SQL, Oracle, PL/SQL (including Cursors, Exceptions, Packages, Procedures and Functions, Triggers and PL/SQL Blocks), Excel, MS SQL Server, Microsoft Reporting Tools, SQL Reports.
• Strong development experience in a mainframe environment;
• Business/Data Analysis, Information Modeling and Architecture, Development Government Reports, Lines of Business jointly with Oracle Corp. Project Management Headquarter;
• Data Dimensional Modeling (CA ERwin Data Modeler), Data Migration (ETL), Data Warehouse/Business Intelligence analysis, design, development implementation and training of Policy Administrative System with Business Objects;
• Develop and enhance software applications in response to user requests in new business areas;
• Planning and implementing Extract - Transform - Load (ETL) processes.
• Responsible for troubleshooting issues, On Call 24/7 Systems Support.

ROBERT HALF TECHNOLOGY, Calgary, AB 2007

Business Intelligence Architect/Analyst/ Developer
• Providing Information Services and value-added information technology solutions for GWL Assurance Company;
• Delivering I.S. solutions that meet business objectives while ensuring adherence to change m anagement processes;
• Extensive experience with Business Objects, SQL, Oracle, PL/SQL, SQL Server applications;
• Maintaining a high level of customer service focus.

LOG-ON SOFTWARE COMPANY, FIRST INTERNATIONAL BANK , Tel-Aviv, Israel 2003-2007

Business Intelligence Architect/Analyst/ Developer
• Analysis, Design, Development, Implementation, Operation and Support of Financial Banking Applications jointly with IBM Developer's Team for the First International Bank.
• Development Shares Trading System closely connected to the New York Stock Exchange.
• Hands-on development experience with Business Objects ( including Universe Builder, Designer, Desktop and Web Intelligence), SQL, Oracle, PL/SQL (including Cursors, Exceptions, Packages, Procedures and Functions, Triggers and PL/SQL Blocks), SQL Server applications;
• Business Analysis, Data Dimensional Modeling (CA ERwin Data Modeler), Data Migration (ETL), Data Warehouse/Business Intelligence analysis, design, development the System for the managing accounts of VIP clients, First International Bank.

ISRAEL ELECTRIC COMPANY (IT DEPARTMENT), Haifa, Israel 1991-2003

Programmer Analyst/ Developer
• Analysis, Design, Development, Implementation, Operation and Support of Clients and Customers Accounting System of the Israel Electric Company;
• Development Applications for connecting Accounting Systems of the Israel Electric Company;
• Extensive experience with COBOL, CICS, DB2, IMS, PL/1, Adabas/Natural, VSAM , JCL, TSO/ISPF, SQL, Oracle, PL/SQL, SQL Server tools and applications;
• Data Modeling and creating Data Warehouse for the Clients and Customers Accounting System and Oil/Gas Projects of the Israel Electric Company;
• Data Migration (ETL) from Mainframe DB2, IMS/DB, Adabas environment to Oracle and SQL Server Databases.

EDUCATION

NATIONAL TECHNICAL UNIVERSITY of Ukraine Kiev Polytechnic Institute, Ukraine,
ranked first nationally, and is world recognized in graduate programs.

Master's Degree in Electrical Engineering and Computer Science (MSEE)

CERTIFICATIONS

ORACLE UNIVERSITY, Tel Aviv, Israel
Certificate Master DBA in Oracle environment, 2002-2003

TIDHAR EDUCATION CENTRE, Haifa, Israel
Certificate Expanded Engineering Administration (Project Management and System Analysis) (400 hours), 2001-2002

NEW APPLICOM SOFTWARE COMPANY, Tel Aviv, Israel, 2002
Certificate Business Objects Enterprise Reporter, Designer, Supervisor, Desktop Intelligence, Web Intelligence, Central Management Console

CERTIFICATION ASSESSMENTS
Robert Half Certification Assessments:
Advanced CICS COBOL Programming, Jul, 2007
Advanced CICS COBOL Application Programming, Jul, 2007
PreVisor's Certification Assessments (Modis IT):
Advanced DB2 Programming, Sept, 2009
Advanced IMS Programming , Sept, 2009

PROFESSIONAL MEMBERSHIPS
Member of ISRAEL ORGANIZATION OF ENGINEERS & ARCHITECTS since 1991.

PROFESSIONAL SKILLS

Programming Languages: COBOL, SQL, PL/SQL ( including Cursors, Exceptions, Packages, Procedures and Functions, Triggers and PL/SQL Blocks), PL/1, Natural, Natural/DB2, DL/I, HTML, XML, VB.NET, C#, ASP.NET, T-SQL, FORTRAN

Databases: DB2, IMS/DB, VSAM, Adabas, Oracle 9i, 10g, 11g, MS SQL Server 2005,2008, MS Access 2007.

Applications/ Utilities: Business Objects Enterprise XI R3(Universe Builder, Designer, Desktop and Web Intelligence, Xcelsius, Crystal Reports), Cognos 8, Erwin Data Modeler, CICS, JCL, TSO/ SPF/ ISPF, QMF, IMS/DC, IBM MQ Series, SPUFI, Syncsort, Endevor, Xpediter, Abend-AID, File-AID, Predict, Excel, Easytrieve, BMC Catalogue Manager & Utilities, DB2 Utilities, TELON, PANVALET, Microsoft Visual Studio 2005, 2008, ETL, ASP.NET, Natural Construct, Control-M.

Operating Systems: IBM MVS/ESA, IBM z/OS, UNIX, Microsoft Windows NT/XP/Vista.

Communications/ Networks: 3270 Emulation, PCOM, XCOM, MQ Series, FTP.

Technique & Methodology: Business Intelligence, Business Analysis, Data Warehousing, Project Management, System Analysis, Data Modeling,Data Migration, SDLC

PROFESSIONAL COURSES

2008 Course Changeman, Telon, CA7, Data Dictionary( Great West Life Company, Winnipeg, MB)
2008 Course ISPF, Job Submission IOF, Job Control Language, Programmer's Workbench & Panvalet (Training and Education, Winnipeg, MB Learning Centre)
2006 Course Microsoft C#.NET for Developers (SELA University)
2005 Course CICS/TS Application Programming Training - IBM CI170 (Visa Corp.)
2004 Attending forums of Oracle Corp. on up-to-date features of Oracle DBA
2002-2003 Certificate Master DBA in Oracle 9i environment include DBA I, DBA II,DBA III, SQL, PL/SQL, Database Administration, Recovery, Backup, Network Administration, Database Tuning, Oracle Installation on UNIX Platforms, Integrity Systems Management, SQL and Application Tuning and Configuration, Advanced Oracle Topics, Oracle OEM (Oracle University, John Bryce Oracle Education Centre)
2001 Course Oracle Forms Developer and Forms Server 6i (Oracle Education Centre)
2001 Course Advanced PL/SQL Oracle 8i Development (John Bryce/Oracle Education Centre)
2001 Certificate Business Objects Reporter, Designer, Supervisor, Desktop Intelligence, Web Intelligence, Central Management Console (New Applicom Software Company).
2001 Course Developing in Internet environment (HTML, XML, Javascript), IT Education Centre
2001-2002 Certificate Expanded Engineering Administration (Project Management and System Analysis) (400 hours), Tidhar Education Centre
2001 Course Microsoft Excel Applications Development (IT Education Centre)
2000 Course Microsoft Visual Basic Applications Development (IT Education Centre)
1998 Course Performance with Natural Programming, Natural Construct Application Development, Mastering Natural Tips and Techniques (SPL Software/ Software AG)
1997 Course COBOL, PL/1, VSAM, JCL, MVS (Mainframe Training Centre)

Certifications
ORACLE UNIVERSITY, Tel Aviv, Israel
Certificate Master DBA in Oracle environment, 2003

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »


Resumes in Calgary, AB | Resumes in Alberta

View other Business Intelligence Architect/Analyst/ Developer resumes, Programmer / Developer resumes