Project Sql Server

EYOEL GETACHEW

*** ********* ***. ***. #** | New York, NY 10032 | *********@*****.*** | 646-***-****

SUMMARY

Software developer with more than ten years of experience in database design and all aspects of full

software life cycle: Strong knowledge of business needs, financial constraints, and end user preferences.

Specification and user requirement gathering, system analysis and design, prototyping, GUI design,

presentation, development, testing, data modeling, integration, implementation, project management,

documentation, training, Consulting and knowledge of Advent's Geneva.

PERSONAL STRENGTH

Result-driven professional capable of analytically utilizing facts and data to create unique solutions to

problems. Able to quickly adapt to changes; reanalyze problems as new obstacles arise; explore various

alternatives to problems. Exposed to work environments ranging from individual project management to

large team development. Communication skills and forthrightness reduces time in getting to core of the

problem and quickly creating resolution.

Operating Systems

Microsoft Windows Architecture

Microsoft BackOffice Suite (Windows NT, IIS, Site Server, MS SQL Server, Index Server, and

Exchange Server, Transaction Server)

Development Tools

Microsoft Visual Studio 6.0 (VBA/Excel, VB 5.0, VB 6.0), VB.Net, C#.Net, ASP.Net,

ADO.NET, XML.NET, HTML, XML, XSD, XSLT, Crystal Reports, Visual Source Safe

Databases

SQL Server 2000, 2005,2008, Access, Oracle, Stored Procedures, knowledge of Advent's Geneva

database AGA

Software

Microsoft Office, Visio Professional 5.0, Microsoft Project, working knowledge of SAS and SAS

ETL, Install Shield, Wise Installer

SAMPLE OF PROJECT EXPERIENCE

Ryan Associates Technology, New York, NY June 2011 – September 2012

Implementation Consultant

• Experience in Bloomberg Integration for Advent Geneva.

• Integrated various reference and derived data in Geneva 8.0 using C#.NET.

• Designed an investment loader, Pay-down, Variable rate schedules and Price updates for a client

using off-the-shelf Bloomberg Data accelerators in Geneva 8.5.

• Interfaced with Business Analyst and end users to make updates and enhancements to an

application that reports tax lot closing methods for transactions.

• Worked on modifying RSLs to get required data from Geneva database.

• Worked on application that transfers transactions from one portfolio to another according to

business specifications.

• Experience in setting up Geneva Advantage for reconciliation and reporting using both built in

and Custom loaders.

• Financial instrument knowledge, including Equities, Options, Futures, Fixed

Income, FX, Exchange and OTC Traded Derivatives.

• Experience integrating systems with Geneva that involves transactions and creating security

master information for investments involved.

Gabriel’s Technology Solutions, New York, NY Aug 2006 – June 2011

Senior Data Analyst

• Extensive experience in the migration of data from Excel, Flat file and XML to MS SQL.

• Proficient in extracting, transforming and loading of data using SQL Server DTS and SSIS.

• Extended knowledge of using C#, VB.net and VBScript for data manipulation.

• Exclusively assisted supervisor in managing over 20 real estate clients like NYTimes and

CanWest.

• Some experience in managing and consulting clients by providing real time solutions to their data

needs.

• Received in house training on Endeca and implemented the software into our systems.

Carat Group: Wilton, Connecticut April 1998 – Dec 2005

Software Developer

• Design and maintain a suite of custom applications for both in-house and external clients using

VB, VB.Net and C#. These suites of applications were the integral part of the company that

allowed internal analysts retrieve and manipulate their data.

• Communicate with business and other technical teams to collect business requirements for new

projects and/or bug fixes.

• Prepare detailed technical specifications for projects implemented.

Responsibilities:

• Designed and developed custom software application that allows clients to build an access

database from a flat file using VB 6.0.

• Maintained and enhanced custom reporting software that generates a PowerPoint Presentation

retrieving data stored in Access database and creating a presentation according to client’s input

using VB 6.0.

• Maintained and enhanced a VBA project that creates an access database from data stored in Excel

sheet.

• Maintained a data processing project that stores data in both in access and SQL Server.

• Designed developed and shipped a user interactive .NET project. In this software users were able

to select their access database and manipulate their data using this software and save the results

back to their access database. This Software does a lot of complicated mathematical calculations

based on user’s input.

• Maintained an intranet application written in ASP.

• As a project member managed the design, development and shipping of a business-critical

client/server application. This was accomplished using Visual Basic 6.0, and MS Access 2000.

• Unit, Integration and end to end testing and installations using Rational Clearquest, Install Shield

and Wise Setup Programs.

Account: Kraft Foods

Designed, implemented, and delivered data processing software that allowed users to store data

using Visual Basic 5.0, and SQL Server 6.5. Project delivered on an aggressive time line of 6

weeks.

Telephonics Corporation: Farmingdale, NY June 1996 – August 1996

Responsibilities include conversion of C and FORTRAN codes to PDL (Program Design

Language) Testing modules that were the final part of the MTRACS (Multi – Tracking of

Radar Control Systems) project.

Polytechnic University: Farmingdale, NY June 1991 – August 1991

Studied the effects of Plasma in the shielding of airplanes from radar detection.

Carefully measured and studied the behavior of plasma in deflecting electromagnetic

waves away from a shielded airplane which was set up in the laboratory.

The project proved that plasma could be used in the shielding of airplanes, which resulted

in further research in plasma technology.

EDUCATION

STATE UNIVERSITY OF NEW YORK @ STONY BROOK, Stony Brook, NY

Bachelor of Science, Electrical Engineering 1997

Contact this candidate