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
Project: Platform: Alternative Investments
One Platform
Tools
& Technologies Used:
Description:
Description:
The lockup is a web based reporting
tool for the global PB Risk Management team and senior Prime Services
management to monitor the Lockup agreements. Lockup agreements are negotiated
with clients and state pre-defined margin terms for a specified time period. In
order to retain access to these margin terms, clients must maintain their portfolios
within certain thresholds relating to position size, concentration, country
exposure, bond rating quality, asset class composition and other measures. This
application provides us a centralized and regular monitoring of all standard
lockup rules for these agreements.
Roles & Responsibilities:
Description:
Description:
Description:
Description:
Download Resume Format
Elina
Zou
Elina.Zou@hotmail.com (646)707-9876
SUMMARY
·
More
than 8 years of experience as Senior Developer in
architecting and implementing client/server, n-tiered, and enterprise-level distributed applications using a variety of technologies
·
Strong Experience in Microsoft Business Intelligence Suite (Integration Services,
Analysis Services, Reporting Services)
·
Extensive
experience in C#, VB, ASP.NET,
Web Forms, Win Forms, Windows Services, Web Services, Console Applications,
Visual Studio, XML, Silver Light, HTML, JavaScript, Windows NT/XP/2003
·
Expertise
in Microsoft product suite like SharePoint Services, IIS 5.0/6.0, Microsoft
Content Management Server 2003.
·
Extensive working experience in
using/generating Visual Studio 2005/2008 Business Intelligence Report, SQL
Server 2005 SSRS(SQL Server Reporting
Service), ad-hoc reports with Report Models
(SMDLs)and Crystal
Reports, Crystal Analysis and
development and deployment of Publishing Reports on the Intranet as well
·
Proficient in SSIS
(SQL Server Integration Service) project design, implementation and troubleshooting
·
Proficient in Data warehousing
and SSAS skills: MDDB/MDX, OLTP, OLAP (MOLAP, HOLAP, and ROLAP),
Relational and dimensional modeling skills (star schema and snowflake schema). Strong experience in design and construction of data marts and data
warehouse
·
Experience in creating,
managing Microsoft Silver light
application
·
Hands-on working experience in SQL database architecture, data modeling, logical and physical database design utilizing Erwin
Data Modeler
·
Thorough understanding of Performance
monitoring/tuning/troubleshooting and working experience on Devising and
Implementing Performance Tuning
strategies
·
Worked in
combination of both offshore and onshore teams to successful execution of multiple large
scale projects
·
Worked
on all major asset types like Equities, Fixed Income, Options, Futures,
Currency Futures, Warrants, T-Bills, T-Notes, ETFs, Reverse ETF, Commodity
Futures and various OTC products like CDO, CDS, MBS, Forwards, Swaps & Swaption
·
Experience in project planning.
·
Experience
in consuming XML Web Services .
·
Involved in
the day-to-day troubleshooting and maintenance of applications
·
Interacted with the business users to understand requirement, prioritize them and planned the implementation
timelines
·
Experience
in working in busy trading floor in Hedge Fund & Interaction with traders and
portfolio managers
·
Hands-on working experience
with analyzing query plans, using extended Stored Procedures, managing indexes
and troubleshooting deadlocks
·
Hands on experience in design
tools like Enterprise Architect, Visio, Poseidon
·
Experience with software development life cycle (SDLC)
and project methodologies
·
Hands on experience in Job
Automation Tool like Control-M
TECHNICAL SKILLS
|
Web Technology Suite
|
C#, ASP.NET,ADO.NET, Web
Services,
L,
|
|
Client Server
|
WPF, WCF,C#, VB.NET,
ADO.NET, Visual Basic 6.0, JSP
|
|
Servers
|
Microsoft Office
SharePoint Server 2007, Microsoft Content Management Server 2002, Active
Directory Server 2000, IIS 5.0/6.0
|
|
Business Intelligence
|
SQL Server Integrations
Services 2008/2005 (SSIS), SQL Server Reporting Service 2008/2005 (SSRS), SQL Server Analysis
Services 2008/2005, Tableau
|
|
Database
|
SQL Server 2008/2005, MS
Access 2002, DB2
|
|
Scripting Languages
|
JavaScript, Perl
|
|
Version Control Tools
|
Team Foundation Server
2008/2005, Visual Source Safe, CVS
|
|
Testing Tools / Code
Analyzer
|
NUnit
|
|
Reporting Tools
|
SQL Server Reporting
Services 2008/2005 , Crystal Reports 8.0, Ad Hoc Reporting
|
|
Design Tools
|
|
|
Methodologies
|
Data Structures, UML,
Object Oriented Analysis And Design, Configuration Management
|
|
Build
|
Team Build, Cruise Control
|
PROJECT DETAILS
Credit Suisse New York, NY
10/2008 – 11/2011
Project: Platform: Alternative Investments
One Platform
Tools
& Technologies Used:
C#, Win forms, Console Application, Windows
Services, ASP.NET, Web Services , Web Services, Microsoft Silverlight, AJAX,
Java Script, SQL Server 2008/2005, Visual Studio 2008/2005, SQL Server
2008/2005 Analysis Services, Reporting Services, Ad hoc Reporting with Report
Builder(SMDLs), Integration Services, Team Foundation Server 2008/2005,
XML/XSD/XSLT, HTML, DHTML, Java Scripts, Microsoft Office SharePoint Server
2007,Tableau, Component One Controls,
Dundas Charts.
Description:
Credit Suisse's Alternative Investments (AI) &
Traditional Asset Management Division delivers investment solutions across
alternative and traditional asset classes with approximately $750 billion of
Managed Assets. The funds are located all across the geography including New York , London , Zurich , Australia , Brazil , Japan and they
invest in all exchanges around the world. AIONE™ is the technology platform which
provides front-to-back functionality in the Investment Due-Diligence, Portfolio Management, Trading, Index, Risk
Management and Client reporting
domains to manage a diverse set of portfolios. The AIONE™ Platform Architecture
is built on Microsoft Technologies
and integrates with Wall Street Office,
RiskMetrics, Barra, FactSet, Moodys, S&P, Geneva ,
Intex and Prime Broker etc. The asset
classes covered are Equities, Fixed Income,
Commodities, Options, Futures, Forwards, Warrants, CDO, CDS, MBS, T-Bills,
T-Notes and various OTC Instruments.
Roles & Responsibilities
·
Interface
with business users for Requirement Analysis
·
Responsible
for design review, project planning, allocation of task and checking status on
work items
·
Involved in building the whole system from ground up. Since the time I have joined the project the system has grown to
support over 2000 funds across geographies, processes hundreds of thousands of
positions, interacts with multiple external systems and produces hundreds of
reports
·
The
application has dual presentation layers, windows
based thick client for NY based power users and Sharepoint based web front
end for Risk Analysts & Portfolio Managers.
·
Involved
in using and developing Microsoft Enterprise Library.
·
Involved in the
optimization of generic loaders, Assisted in the job design to load currency
exchange rates.
·
Architected and
implemented performance reporting
module, integration with RiskMetrics
and Prime Services group using windows application as front end and server side components using C# based console applications
communicating via web services.
·
Responsible
for architecting the permission control system
·
Have
worked on exposure analysis and attribution modules
·
Built
Ad Hoc reports using BI Report Builder
·
On each of the modules,
interacted with the business users and sponsors, gathered requirements and
documented them
·
Managed expectations of the
business by prioritizing their requirements and dividing the implementation
over multiple releases
·
Interacted with traders, front
office & middle office teams and risk business users on daily basis
·
Was involved in
integration with MCSI Barra , Bloomberg and Reuters Data Services too
·
Used
stored procedures to compute percentile,
median, rank of funds amongst its peer group funds
·
Coordinated
with onshore and offshore teams for implementation and support of existing
applications
·
Have
worked on integration with RiskMetrics™ to deliver risk reports with advanced
drill-down capabilities, both benchmark and absolute: VaR, CVaR, VaR Decomposition, alpha, beta, theta, gamma, volatility,
scenario and stress reports
·
Heavily
used Integration Services to load
data from different sources (Geneva ,
Bloomberg, WSO) in different format
·
Managed
SQL SERVER Analysis Services Cube
from RDS database
·
Intensively
using SQL SERVER Reporting Services
(DUNDAS also) for customers oriented reports.
·
Owned
and supported all the applications I have worked on and was single point of
contact for any issues/enhancements to those systems
·
Have
worked on performance tuning of sql
queries and integration services packages
·
Was involved in automation of
build processes and setting up continuous integration
·
Involved in the automation of
the monthly AlOne release solution and assisted with production support to
resolve data issues.
Project: Prime Services Lockup
Description:
The lockup is a web based reporting
tool for the global PB Risk Management team and senior Prime Services
management to monitor the Lockup agreements. Lockup agreements are negotiated
with clients and state pre-defined margin terms for a specified time period. In
order to retain access to these margin terms, clients must maintain their portfolios
within certain thresholds relating to position size, concentration, country
exposure, bond rating quality, asset class composition and other measures. This
application provides us a centralized and regular monitoring of all standard
lockup rules for these agreements.
Roles & Responsibilities:
·
Built a lockup monitoring
system for the Prime Service Group.
·
Designed jobs loading
position and security data from Beams, Paladyne and Geneva accounting
systems.
·
Designed and developed
Investment Guideline framework using Key Performance Indicators (KPI) as
part of reports, SharePoint and email
alerts.
·
Involved in the design and
development of Analysis service database, Tuned cube by removing unused
attributes, setting attributehierarchyoptimized, attributehierarchyenabled
properties on attributes and defining partitions.
·
Involved in tuning MDX
queries using subcube, building aggregations & natural hierarchies, using
non empty behavior for calculated members and filter function on a set.
·
Involved in the design and
development of exposure, dashboard and investment guideline reports
using SSRS. Created report subscription to automate delivery of reports.
·
Designed and developed SSIS
jobs to automate the processing of the AlOne Cube, loading data into data
warehouse and to email status of guideline calculations.
·
Involved in the design and
creation of data marts for each business module.
HRA/MIS of New York City Brooklyn,
NY
01/2007 – 08/2008
Description:
The project in
HRA/MIS of New York City was a part of effort to control and reduce the number
of people in the list who claim unemployment allowance in New York City. SSIS,
SSAS, SSRS and ASP.Net were involved in this project.
Roles
& Responsibilities:
·
Did data
extraction from various sources of different departments in HRA and ORACLE,
Informix Database, transformation and loading into the target SQL Server
databases using ETL tools, SSIS 2005.
·
Hands-on
software development skills and experience in Object Oriented Analysis, Design
and Programming using C++, C#.NET,
ASP.NET, HTML, XML, VB.NET etc.
·
Created SSIS
packages with which data resources such as Excel and XML were loaded daily in
order to create and maintain a centralized data warehouse. Made the package
dynamic so it fit the environment.
·
Scaled SSIS to
make it work more reliable.
·
Expertise
experience with administering and debugging SSIS.
·
Created
scheduled jobs to execute SSIS packages.
·
Transferred/Rewrote
DTS packages to SSIS programs. Hands on working experience with configuring
every aspects of SSIS 2005.
·
Created alerts,
notifications, and emails for scheduled SSIS packages execution.
·
Coordinated
other Reporting Analysts in analyzing data and creating management reports.
·
Utilized strong
knowledge of relational database modeling principles, techniques and
dimensional modeling to generate SQL/Crystal reports using OLTP data source or
SSAS cubes.
·
Assessed
internal and external report needs and designed solutions based on specific
requirements using SQL Server Reporting Service (SSRS) or Crystal Reporting
Service.
·
Developed
reports without formal specifications often.
·
Created and
developed the stored procedures, triggers, views, and user-defined functions to
support application development.
·
Worked closely
with IT project managers, programmers, and testers.
·
Participated in
the development of Web Application. Used C# for web programming. Solid
knowledge and experiences with .NET programming.
Medical College of Cornell Univeristy
New York, NY
08/2004 – 12/2006
Description:
The project in Weill
Medical College of Cornell University is among the top-ranked clinical and
medical research centers in the country. The project involved in creating new
databases, upgrading SQL Server 2000, backup/restore, replication, log
shipping, creating failover clustering, performance tuning and more.
Roles
& Responsibilities:
·
Created logical
and physical database design, data structures, and implemented large databases
using Erwin 3.5
·
Generated
database SQL scripts and deployed databases including installation and configuration
·
Update SQL
Server 2000 to SQL Server 2005 and migrated data to SQL Server 2005.
·
Managed database
security. Created and assigned appropriate roles and privileges to users
depending on the user activity.
·
Automated and
enhanced daily administrative tasks including space management, object
alteration, database backup and recovery.
·
Created and
developed the stored procedures, triggers to handle complex business rules,
history data and audit analysis
·
Developed,
modified, and optimized very complex queries to data retrieval and modification
·
Generated test
data and tested database to meet the functionalities deliverables in the
project documentation and specifications
·
Managed the
research and clinical databases including performance tuning, capacity planning,
SQL Server clustering, database security configuration, and database continuity
·
Scheduled and
monitored all maintenance activities of SQL Server 2005 including database
consistency check, and index defragment
·
Created the
lookup tables and generated the lookup data to meet the specification
·
Generated
database SQL scripts and deployed databases including installation and
configuration
·
Maintained day
to day operating procedures for SQL Server databases
ZTE Corporation R&D Center
Shanghai, China
03/2003 – 06/2004
Description:
ZTE Corporation is the first Chinese telecoms
equipment provider to pursue business in overseas markets, ZTE now has
about 50000 employees and 8,000 of them are working in about 100 representative
offices around the world.
Roles
& Responsibilities:
·
Involved in
extensive Object-Oriented Modeling for the application to access databases of
SQL Server 2000..
·
Involved
in the application design and implemented the functionality on Transportation
Layer with C/C++.
·
Designed
two core modules: System Module and Broadcasting using C/C++.
·
Managed
large-scale source code (>100-thousand lines) to implement functionalities
on RNC boards.
·
Tested
to implement inter-connection of the
two subsystems, RNC and NodeB according to protocols.
·
Gained
team leadership skill and experience/knowledge in Software Design Patterns and
Code Refactoring Techniques.
Environment: SQL Server 2000 Enterprise, Windows XP
Professional, Microsoft Visual Studio 6, Oracle 8i
China
International Trust Investment Corporation (CITIC) Shanghai, China
08/2000 - 01/2003
Description:
China
CITIC Bank is China’s seventh-largest lender in terms of total assets. It is
formerly known as CITIC Industrial Bank. China CITIC Bank, established in
February 1987, is a nationally comprehensive and internationally oriented
commercial bank.
Roles
& Responsibilities:
·
Developed
Console Application using C++
·
Developed and
maintained database administration with SQL Server 7.0
·
Maintained
databases, configured permissions, and conducted backup and recovery
·
Performed daily
administration, monitoring, and documentation of SQL Servers
·
Responsible for
tuning data, indexes, and queries
·
Provided
assistance to development teams on tuning data, indexes and queries
·
Automated and
enhanced daily administrative tasks, including space management, backup &
recovery and performance monitoring
·
Configured
securities and accesses to production databases and database servers
·
Provided
technical support to internal developers and external clients
EDUCATION & CERTIFICATIONS
M.S. in Computer Science, City College of New York, City University of
New York
Microsoft Certified Application Developer (MCAD)
Microsoft Certified Database Administrator (MCDBA)
Microsoft Certified Technology Specialist (MCTS) – SQL SERVER 2005
Download Resume Format
.JPG)
0 comments:
Post a Comment