ADVERTISERS
Register now and you can post an unlimited number of job ads at no cost. Register & post jobs
IT PROFESSIONALS
Create an account now and you can receive targeted technology jobs via email.
Register & post jobs
SOFTWARE RESUMES

Preview Resumes

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |

SAS Analyst , Database Marketing

SAS Analyst – Database Marketing
PROFILE
Business Analyst with a background in administrating and managing relational databases along with SAS programming now seeks next-level job. I am currently working with CITIFINANCIAL EUROPE PLC as SAS Analyst-Database Marketing. Before this, worked at ANZ Bank (Australian and New Zealand Banking group) as a MIS/Database Marketing Analyst. I am looking to advance my career and that’s the reason for coming to the UK. Having completed two years towards a Bachelor of Science degree, I am a graduate with a double major degree in Bachelor of Commerce and Administration.

SKILL SUMMARY
Skill Years/Months Experience
Programming BASE SAS - 17 Month of Programming (Data extract and Analysis)
10 months in Administrating & Managing Mainframe Jobs


Databases
MS Access (Million Records)– 2 Years in administrating and managing database.
MS Excel – 1 Year in data analysis and manipulation.
MS SQL Server2000/2005 - Half a Year in data analysis.


Operating systems
Microsoft Windows family.
Citrix /Novel.


Other tools
Brio – 1 Year exp as a Query tool (DB2 Tables).
Valex – 1 Year exp as campaign analysis tool (Oracle Tables)
University exp in ERD, DFD, UML – Rational Rose and Visio and Macromedia. Family (Fireworks, Dream weaver and Macromedia Flash).


Non-Technical Analysis – 2 Year (approx) exp as Business Analyst and Assistant Data Analyst.
Management – 2 Year exp as Duty Manager at Supermarket.
Sales/Service/Support – 6 Month exp as Sales Rep for www.textdirect.co.nz.
Project Management – Twice Project Manager for Academic Projects.


EDUCATION AND QUALIFICATIONS
Year
2005-2006 SQL Server 2000 – ANZ National E-Learning Course.

Year
2002-2005 Bachelor of Commerce and Administration.
Major - Information System and E-commerce.
Victoria University, Wellington. New Zealand.

Year
2000-2002 Bachelor of Science (Year1 and Year2 Only).
Major - Mathematics and chemistry.
S.D.S.M. College, Mumbai University, India.

Year
1990-1997/98 Anand Ashram Convent English High School.

WORK EXPERIENCE
CITIFINANCIAL EUROPE PLC
SAS Analyst – Database Marketing

CitiFinancial is a member of Citigroup, the world\'s largest financial services provider with some 200 million customer accounts in more than 100 countries. Other major brand names under Citigroup\'s trademark red umbrella include Citi Cards, CitiFinancial, CitiMortgage, CitiInsurance, Primerica, Diners Club, The Citigroup Private Bank, and CitiCapital. CitiFinancial provides community-based lending services through a strong branch network system. Decisions are made locally by CitiFinancial team members who live and work in the locations they serve.

Deliver first rate analysis utilising all data sources to the full and where necessary locating, obtaining, manipulating and analysing additional data.
Primarily using SAS and Excel, monitor and analyse the performance and profitability of both Customer and Prospect marketing initiatives and incorporate learning’s into future campaigns.
Work as required to deliver analysis/ data from suppliers such as Feather Brooksbank and Experian and on projects which deliver further capability to the Marketing Analytics team and the company as a whole.
Practice Self Assessment (SA).

SAS and MS Family


ANZ NATIONAL BANK LIMITED (Wellington, New Zealand) - Business Analyst
Company Information ANZ is a wholly owned subsidiary of the Melbourne-based Australia and New Zealand Banking Group Limited (ANZ Group). By assets, ANZ Group is one of the world\'s 100 largest banks, with representation in 29 countries.

Responsibilities Capturing business requirements for information from Global Information Warehouse (DB2 tables) ,SAS Datasets and related databases (MS Access, SQL Server 2000 & Excel) fleshing them out into comprehensive specifications that enable a solution to be designed in detail
Managing Ad Hoc Projects that includes work requests from all parts of the bank
Liaising with external clients and senior management
Evaluating alternative solutions to meeting the business need and recommending the most appropriate, accounting solution for both short-term cost-effectiveness and longer-term strategic objectives
Working with the MIS Reporting Analysts to design and test solutions.
Co-ordinating Marketing campaign i.e. extracting customer list for direct mailing campaign by applying various selection/exclusion criteria to a set of few million records
Co-ordinating the delivery of solutions to the business including documentation and training.

Technology used Mainframe JCL, Base SAS, MS Family (MS Access, SQL, MS Excel, SQL Server 2000 etc) , BRIO, Valex
Key Projects / Achievements Increased Reporting efficiency by developing/maintaining a centralised data-hub i.e. a database that provides streamline information about all work requests that has been developed or productionised by the team.
Restored Transaction dataset from Mainframe into SQL Server to ease its use. Further administered and maintained this transaction dataset which records more then million transaction per day.
Mentor data requirement for Lead Management Project by productionising more then 5 monthly campaign for current year.
Developed monthly reporting efficiency for business that included ad hoc work request from Ground manager to General manager. This avoids running manual processes for monthly management reporting.

CAPITAL & COAST DISTRICT HEALTH BOARD (Wellington, New Zealand)
Assistant Data Analyst (Planning & Funding)

Company Information C&C DHB is the leading provider of specialist health services in the central region of New Zealand. The planning & funding arm of C&C DHB helps design and provides better health care services. The area is responsible for buying health services based on the needs of the region.

Responsibilities Capturing and amalgamating data from multiple sources (internal/external client, databases etc) into a centralised dataset.
Analysing the dataset and keeping it updated with regular maintenance.
Reporting relevant information to senior manager
Hosting group and individual meetings on behalf of C&C DHB
Liaising with internal and external client
Technology used MS Family (MS Access, SQL, MS Excel, Power-point etc)

Key Projects / Achievements Reported a dataset graphing Health Board’s active ‘General Practitioner’ list and their movements.

HOBBIES/SKILLS
Socialising i.e. meeting and interacting with people of all nationalities/cultures.
Playing and watching sports like cricket, table tennis and ruby etc.
Leisure time enjoying music, videos and voluntary work.
`