Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
Ruby Feldleit
|
309 McGregor Dr
|
704-787-9876 (H)
704-706-1230 (C)
|
ruby.feldleit@gmail.com
|
||
.
SUMMARY
|
Strong SQL
Server Developer/DBA (18 years) and VB.NET skills (3 years). Created and supported risk management tools
including IRR, amortization and price calculations.
|
|||||||||||||||||||||
COMPUTER
SKILLS
|
Programming Languages:
Visual Basic
.NET, ASP.NET, .NET Framework 2.0, VBA, Transact SQL, Javascript, HTML, XML, XSLT
and ASP classic
Applications / Technologies:
SQL Server
2008, SSIS, SSRS 2005, ADO.NET, Informatica, Erwin SQL, MS Access, Rational
ClearCase
|
|||||||||||||||||||||
WORK
EXPERIENCE
|
Wells Fargo,
Charlotte, NC
·
Acted as lead database
developer on conversion of SNAPSHOT application. Rewrite of legacy application to permit finer
grained control over which accounts were reconciled. Project was completed under intense
pressure because previous team had attempted and failed at rewrite; only a
three month window to complete project before corporate conversion
event. Leveraged existing code base
and made modifications to facilitate new features and to add more robust
error handling and automated failure recovery.
·
Reduced processing time of
General Ledger Extract process by 90%.
GL Extract application is source of all data for reconciliation
platform. Delays in extract were
causing missed deadlines downstream.
Quickly analyzed package and determined key areas where performance
could be improved without prolonged development effort. Changes were quickly made and moved into
production which resolved problem.
·
Developed SSIS package for
loading trial balance files to General Ledger database in order to remediate error-prone
and difficult to maintain c# application.
Package is responsible for loading around 80 files daily. While each file was supposed to follow common
format, many did not, so package was setup to facilitate a number of data
lookups and one-off conversions to standardized the data before being loaded.
·
Created/enhanced numerous
SSRS reports to support internal business users and support team to monitor
various processes.
·
Modified various SSIS
packages used in GL extract to process more efficiently in terms of time and
subdividing output files to facilitate downstream applications.
·
Provided training in SSIS and
Transact-SQL to support team to enable them to help themselves and provide
better service. Greatly reduced
problem tickets which were negatively impacting area performance.
Optcapital,
·
Converted SQL Server 2000 DTS
packages to SQL Server 2005 SSIS.
·
Migrated SQL Server 2005 to
2008.
·
Enhanced automated overnight
data feed and nightly processing process, replacing Windows scheduler and
some DLLs with SSIS package incorporating email notification identifying if
and where problems arose and data driven model to support multiple databases.
·
Created SSIS/SSRS system to
collect data feed and nightly processing results from all the production, QA
and development SQL Servers and produce report identifying results to
facilitate maintenance.
·
Created SSIS system based on
customized data objects to emulate data driven subscriptions (feature of SQL
Server Enterprise which we lacked) to suppress delivery of empty reports both
internally and to external clients.
·
Created numerous SSRS reports
to support internal business users, external clients and IT staff, including
use of system tables to monitor timing and destination of SSRS subscriptions.
·
Created data dictionary
application to allow us to enter business definitions of tables and fields in
system tables along with stored procedure facilitating IT documentation and
development by allowing searches from a multitude of perspectives.
·
Eliminated many
instances of hard to maintain dynamic Transact-SQL in stored
procedures with table function converting comma delimited list of IDs
into a table used in JOINs.
·
Replace
·
Maintain front end
application for NQDC accounts written in ASP classic, Javascript and VB
script.
Bond &
Corporate Finance Dept – John Hancock Financial Services,
·
Consult with users to
identify current operating procedures and to clarify program objectives
·
Design, analyze and implement
software applications based on program objectives obtained
·
Support and maintain fixed
income financial application systems:
o
Equity Aggregation – VB.Net and SQL
Server application collects and aggregates holdings data from all different
areas of the company. Various reports used to monitor monthly company
compliance with SEC regulations on limits of equity position held in
individual company. Automated
retrieval of shares outstanding and prices from Bloomberg FTP server. VBA code in Word template pulls SQL Server data to produce
filings to SEC, replacing HotDocs software, saving license costs and
eliminating high maintenance efforts associated with it.
o
Securities Valuation Office System – VB.Net and SQL Server application tracks filings and NAIC ratings
of held securities.
o
Mezzanine Portfolio System – MS Access system permits tracking of mezzanine portfolio. Captures partner, issuer, investment,
transactions, capital calls,
acquisitions and distributions.
Produces holdings, cashflow, investment summary and investment
summary. Provides IRR calculation for
issuer and portfolio.
o
Portfolio Management –
Maintain/enhance MS Access data maintenance and reporting system for third
party holdings. Tracks trades.
Provides oversight of and reconciliation with custodian. Prices securities. Tracks benchmarks. Generates monthly client reports, including
investment portfolio compliance, asset values, performance, inventory and
transactions. Automated customized
client reports in Word VBA, which pulls in assorted Access reports into a
single document, allowing distribution of single PDF file.
o
Holdings – Extract accounting data of
holdings of internal John Hancock customers from mainframe system on daily
basis and third party customers from MS Access system on monthly basis into SQL
Server. Created MS Access front end to monitor portfolio status in terms of
amounts, ratings and allocation at portfolio level. Facilitates oversight of accounting area
transaction processing. Measures
exposure from slew of perspectives, such as quality, industry, national
origin and user defined groupings.
Produce amortization schedules from transactions and sinking
funds. Report on sales and resulting
gains and losses to various management committees. Feeds monthly pricing of securities and
problem loan review application.
o
Loan Review System – key risk management
tool. MS Access front end to SQL
Server back end providing problem loan review monitoring by management to
help shape strategic thinking to minimize losses. Feed by Holdings system, permits quarterly
analyst writeup of various business categories. Maintains history of positions and
commentary, facilitating trend analysis.
Review of rating changes affects reserve levels. Standardizes output for each industrial
team, streamlines data collection, reduces errors and facilitates grouping at
the department level.
Hancock Timber
Resource Group – John Hancock Financial Services,
o
Portfolio Management Plan – Visual
Basic and SQL Server application allowing browsing/editing of all aspects of
portfolio management in a centralized fashion. System currently used internally, but will
be made available to clients to permit them to monitor portfolio
results/strategy and provide feedback electronically.
o
Historical Performance – Visual Basic
and SQL Server application aggregating financial data in user defined fashion
over varying timeframes and levels of aggregation. Performed different
financial analysis such as ROR and IRR calculations (nominal and real).
Created an extract that fed an industry indexing system.
o
Data Modeling – Conducted sessions
with business users to map data requirements of business. Subsequently created structures within SQL
Server.
o
Client/Prospect Tracking – Visual
Basic and SQL Server application allowing browsing/editing of company data,
associated contacts and call reports. Provided contact selection, which fed
Word macro application for used for mail merges.
o
General Ledger – Extracted administrative
assistants to be accounting data from mainframe system on quarterly basis in
SQL Server. Visual Basic application facilitated a variety of accounting
needs, including data verification and quarterly financial system by allowing
user to query for individual transaction components over varying timeframes
and levels of aggregation.
o
Group Schedule – Visual Basic and SQL
Server application allowing group members throughout all regional offices to
view all members schedules, make appointments, accept invitations and update
their own calendar. Tied into ccMail as a redundant backup to system
invitation.
o
Disposition Tracking – Visual Basic
and SQL Server application allowing browsing/editing of property disposition
process. Measured performance of each step of process against goals. Created reports for voting committees.
Corporate
Information Systems – John Hancock Financial Services,
o
Clientell – Visual Basic and SQL
Server application allowing browsing/editing of extracts from participating
business areas within sector. Permitted sharing of information between
business areas and centralized data retrieval for sector level officers.
Financial Sector
Systems – John Hancock Financial Services,
o
Maintain and develop
mainframe and PC systems (Paradox, SQL/DS, IMS, Focus, Cobol, PL/1, Rexx and
APL).
o
Created and maintained PL/1
programs front-ending IMS databases on MVS mainframe.
H.J. Behrman,
|
|||||||||||||||||||||
EDUCATION
|
B.S. Computer
Science 1986
B.S.
Accounting 1978
|
GPA: 3.9
GPA: 3.4
|
||||||||||||||||||||
Download Resume Format
.JPG)
.JPG)
0 comments:
Post a Comment