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
Joy Pinner
20-65 49th Street
Astoria, New York 11001
Tel: 631-835-9876
e-mail: joy@gmail.com
SUMMARY
Over 15 years of proven technical leadership in managing and
developing database support teams globally for fortune 500 companies across
multiple database platforms. My years of
technical experience have enabled me to manage production
environments effectively with a 99.9% up time while dealing with the high
demands of day to day operations, development, database compliance requirements
and focusing on cost efficiencies.
Professional Experiences
JP Morgan Chase, New York, New
York 1/07 – 7/11
IB Risk Infrastructure and Compliance Manager - VP
§ Provide 24/7 production/UAT/development database support across multiple
database platforms within investment banking. Managing
and overseeing a team of27Oracle, Sybase and SQL Server DBAs within investment
banking across multiple time zones. Worked closely with the operate teams to
coordinating resources for daily and investment business activities. Provided
technical support in troubleshooting database issues and responsibility for
coordinating vendor support. Enhancing infrastructure monitoring by
implementing standards across the particular line of business to operate in a
proactive methodology to ensure a 99.9% up time. Responsible for setting up,
training and overseeing offshore level 1 and 3database support teams.
§ Also responsible
for ensuring that the Business unit is compliant to all SOX and IRR database security
standards to ensure successful internal and external database audits.This
required me to work closely with Corporate Security Engineering and the IB
Business Unit to ensure that all SOX workflows and procedures were all being met
while at the same time supporting newlydeliverable requirements by coordinating
resources and timelines. Developed and executed a comprehensive monitoring
program which entailed the operating effectiveness with the Business internal database
controls. Optimize processes and controls that support the Business environment
andfacilitates periodic reviews and audits to adhere to corporate policies and
procedures. Responsible in reporting daily compliance issues and progress to
senior management.
§ Project
Managed the restructuring of levels 1and 3 infrastructure support teams for the
Investment Banking Business Units. This
effort was part of streamlining the business support model which would enhance
the tracking and auditibity with theinfrastructure support teams while at the
same time ensuringa substancial cost savings approach allowing senior
management to track volume, response time and generate custom reports to
identify reoccurring issues. This involved incorporating an automated ticketing
processwhich would route database alerts to a netcool console for the L1 teams
to action or escalate. In addition,polocies
and procedures were drafted to manage a follow the sun support model globally.
Federal Home Loan Bank of Chicago,
Chicago, IL 10/05 – 1/07
Consultant
§ Managed the
database on an accounting system that would allow a mortgage banking client to
effectively hedge mortgage loans and eventually enable them to securitize those
loans in the secondary market. This hedge accounting system gathers data from
multiple sources, including derivative pricing feeds, loan origination systems,
accounting systems and loan servicing systems, and ultimately feeds into their
general ledger system. The core of this
system requires managing a cross-functional effort of the client’s treasury,
accounting and loan servicing business units. This system is a highly database
intensive processes utilizing DTS packages, SQL Server jobs, complex queries,
stored procedures, etc. For
optimization, database components where design and built to run the process in
parallel using multiple threads running across multiple application servers
controlled by Windows Services.
Performed database tuning and optimization tasks designing optimal
indexing schemes, data archiving, data caching, and bulk database transactions.
Production Support manager for the end users and IT group on logical business
issues and daily data verification based on the business requirement. Managed business process changes and
enhancement based on the business needs.
Dell
Professional Services, Dell Computer Corp., New York, New York 4/96– 10/05
(Formally MicroModeling Associate, Plural)
Database Architect/Technical Strategist
n Develop Service Offerings, Technical Sales and Marketing Support
n Internal Strategic Technology Consulting
n Lead DBA
n Project Managed DBA team
Client Projects Highlights:
n Federal Home Loan Bank of Chicago - Database developer and administrator of a loan analysis and
reporting system for Federal Home Loan Bank of Chicago. The application is a
.Net C# application with SQL Server as the database platform. Database product
used: Microsoft SQL Server 2000 with replication, Microsoft Cluster and
DTS.
n NASD
- Full life cycle (architecture, design, development, testing, deployment) of a
groundbreaking real time, mission critical core system for NASD. This system is
a real-time surveillance system that watches every quote/trade that occurs on
the NASDAQ market and alerts analysts if quotes and trades fall outside of
acceptable parameters. Responsibilities: Database architecture team lead,
designed logical data model and physical databases, high availability database
and remote warm backup system as the disaster recovery strategy. DBA team lead to provide development DBA
support and production support documentation. Database technologies and product
used: Microsoft SQL Server 2000 with replication, Microsoft Cluster Server, and
NetIQ.
n NASD
- Provided development and production DBA support for a real-time trade and
market information display system for NASDAQ. This display system provides
large display of financial market information at NASDAQ MarketSite located at
Times Square in NYC, also provides financial news broadcast information and
facility for TV networks.
n Barclay’s International – Full life cycle (architecture, design, development, testing,
and deployment) of a data warehouse to manage complex mathematical calculations
which drove the business strategy. Responsibilities: Database architecture team
lead, designed logical data model and physical databases, coded stored
procedures and managed production performance testing. technologies and product
used: Sybase.
n TV Guide Magazine - Full life cycle (architecture, design, development, testing, and
deployment) a CRM data warehouse for TV Guide Magazine. Utilized SQL Server
2000 as the database engine, this data warehouse contains 400+ GB of customer,
billing and payment information enable business units to perform detailed
market and demographic analysis and marketing campaign managements. Database technologies and product used:
Microsoft SQL Server 2000 with replication, Microsoft Cluster Server, DTS, Microstrategy
OLAP.
n TV Guide Online - On behalf of Microsoft Consulting Services, full life cycle
(architecture, design, development, testing, and deployment) of an online TV
listings system for TV Guide. TV Guide.com is part of the SQL Server 2000 EAP partner,
utilized SQL Server 2000 as the database backend serving this 90+ million
hits/month web site 24x7. This project won the Microsoft award as the first
customer with SQL Server 2000 production site and as part of the Microsoft SQL
Server case study. This high availability database server uses SQL Server 2000
and Microsoft Cluster Server for Windows 2000, SQL 2000 DTS, Full-text searches.
n Microsoft - As part of Microsoft’s Sybase to SQL Server 2000 Migrations
marketing initiative. Conducted seminar and presentation at Microsoft technical
centers on the methodology formigrating a Sybase database to Microsoft SQL
Server 2000 database. This presentation provided
a detailed understanding for Microsoft Sales and marketing teams on the
differences between the two database systems and the best approaches when
migrating these databases on different OS platforms. These techniques were
demonstrated by migratingafinancial application using a Sybase database on Sun
Ultra Sparc Server to Microsoft SQL Server 2000 database.
n Ernst & Young – Developed Tax software which was used to model tax scenario for
large corporations which have ownership percenatage of many other
corporation. Some of the clients which
had utilized this product was General Motor, Reebok, Database product used:
Microsoft SQL Server 7, Sybase, and Oracle.
Smith Barney Inc., New York, New York 3/93
- 4/96
Senior Database Analyst/DBA, Retail Branch Systems
DBA for NEXTGEN project utilizing GUI and client/server
methodology.This was a major under
taking to enhancing Smith Barney’s broker workstation in their retail branches
around the world which exceeded over 800 offices. This was a state of the art
broker worker station as it allowed the broker to manage their client account
more effectively by generate dynamic reports, tracking financial products and
generating graphs trends.
n Logical data modeling and physical database design for the NEXTGEN
applications using ADW Analysis and Design Workstations.
n Lead development DBA for the NEXTGEN Applications: developed
Stored procedures, performed SQL and database tuning, coded Unix shell scripts
to perform daily database server maintenance
n Installed, test and benchmark Sybase System 10, Open Client, Omni
SQL Gateways on IBM RISC 6000 and Power PCs with AIX 3.2.5.
n Conducted internal Sybase training classes.
Shearson Lehman Brothers, New
York, New York 4/89
- 12/93
Associate, Broker Technology
Provided support for an internal
electronic broker bookkeeping application called Wizard. This application managed the broker’s trades
by downloading all their transactions on a local computer allowing the broker
to review and generate reports on demand for clients ensuring accuracy which
met corporate compliance requirements.
n Provided technical design/ specifications, implemented logical and
physical database on SQL Servers.
n Support the brokers in the branches on installation and upgrades.
n Provided Level 3 production support.
n Technical liaison between brokers and dev team
n Provided training on application and upgrades.
DATABASES
|
Microsoft SQL Server, Microsoft Analysis Services, Reporting
Services, Sybase SQL Server, ORACLE
|
OPERATING
SYSTEMS
|
Microsoft Windows with Clustering, Unix and AIX
|
PROGRAMMING
LANGUAGES
|
SQL (Transact-SQL & PL/SQL), Visual Basic
|
DATABASE
CASE TOOLS
|
Computer Associate Erwin Data Modeler, Embarcadero ER-Studios,
S-Designers, Bachman Tool Sets
|
EDUCATION
|
New York Institute of Technology, NY USA
|
B.S. – Electro Mechanical Computer Technology, 1987
|
|
LANGUAGES
|
English and German
|
REFERENCES
|
Available upon request
|
Download Resume Format
.JPG)
0 comments:
Post a Comment