[pic]

Carmen Radu-Din

** *********** ***., **** ****, ON

acc7md@r.postjobfree.com

416-***-****

Profile

I'm an Oracle Certified professional with 15 years of experience

specializing in database architecture, design and development. My skill set

includes, SQL Server, Oracle, PL/SQL, Extract Transform Load and data

conversion. I have in-depth knowledge about the SDLC from understanding

client requirements, taking the business solution to design, develop, QA,

testing, implementation and support. Recipient of Technologies Reward &

Recognition Award from AMEX

Key Skills

Over 15 years in IT including:

Operating Systems: Windows,UNIX,Linux, Solaris, Z/OS, Citrix

Data Communications. TCP/IP, Ethernet, and Client/Server, Tumbleweed File

Transfer, IIS

Languages: VB, PL/SQL

Technologies: OOP, Data Modeling, Store Procedure, Real-time programming,

Crystal Reports, SSIS, SSRS, WebSphere

Databases: SQL2005, SQL2008,DB2, Oracle, and MS-Access2003- 2010

Techniques: Lotus Notes, MS-Office, System Management

Certification: OCP Oracle Developer 6.I - Oracle University

Professional Experience

Springs Global US, Inc.

Data and Information Systems Manager 11/2012 - present

. Analyze existing operations and make recommendations for the

improvement and growth of the network infrastructure and IT systems

(MAGIC, EDI/AS400, Forecast tool).

. Prepare monthly reports (Crystal Reports) of Key Performance

Indicators to Director of Finance.

. Build MicroStrategy reports/Business Intelligence Development Studio

for financial department.

. Report to Director of Finance on all technical matters related to

clients and external stakeholders.

. Perform analysis, ad-hoc query requests, reports, creating and

maintaining databases in MS Access 2010 VBA 2010, SQL, DB, Macros,

Dashboards for forecast department.

. Supervise and ensure the efficient operation of the company's network,

client servers, databases, and equipment. This includes managing the

IT staff responsible for monitoring and diagnosing network and

hardware problems.

. Work closely with the IT executive staff and decision makers in other

departments in order to identify, recommend, develop, implement, and

support cost-effective technology solutions.

. Oversee all reports and documentation related to network and systems

operations.

. Manage the deployment, monitoring, maintenance, development, upgrade,

and support of IT systems, including networks, servers, PCs, operating

systems, and associated hardware. Serve as EDI technical point of

contact during the Implementation phase as required.

. Coordinate and share knowledge, as well as, offer assistance to other

members of the team to resolve technical issues.

. Approve purchase of equipment and supplies in order to meet

operational requirements of the business.

WEBCOM 05/2012 - 11/2012

Database Developer / Data Analyst

. Work with Marketing and Production departments to diagnose and analyze

business issues, and understand and support the definition reporting

requirements.

. Extracting transform and load data from multiple data sources/systems

(POEM, NAVISON, CRM, Data Warehouse schema - Star Schema) and

importing into SQL 2008 (SSIS) and building reports in SSRS SQL 2008

Reporting System.

. Create queries and stored procedures for marketing, financial and

production department.

. Assist with what technology to use to set up the data warehouse.

. Support Microsoft CRM System including projects involving system

reporting.

. Support clients and internal staff requiring technical assistance.

Professional Experience

Kenna 03/2012 - 05/2012

Database Developer

. Authoring stored procedures / packages and user-defined functions from

design documents.

. Develop data models for applications, metadata tables, views or

related database structures.

. Perform data conversions from flat files into a normalized database

structure.

. Construct ETL packages based on the business and functional

requirements.

. Writing or collaborating on technical specifications, logical data

models, flowcharts and data flow diagrams, etc.

. Admin, maintain and monitor internal databases for clients.

. Provide Ad-Hoc reports to Analytics and Account teams in SQL/PLSQL for

specific external clients.

Thomas Cook Travel 03/2011 - 10/2011

SME (Subject Matter Expert) Oracle financials eBusiness application systems

. Applied advanced subject matter knowledge to business issues

pertaining to R12 Oracle financials eBusiness application systems,

developing, implementing and maintaining system technology solutions

by developing extensions for and integration solutions to ERP systems.

. Investigation and troubleshooting of Oracle financials eBusiness R12

application problems, working with large database tables.

. Working with managers to determine options, impact, and

recommendations in clear and non-technical terms to all issues related

to eBusiness R12 applications.

. Contributed to the development of new ideas, methods and processes for

the supported business units.

. Led and/ analyzed business processes and conducted business system

reviews to project teams and other IT staff.

. Wrote and/or maintained application Support documents in accordance

with current standards.

. Established and managed effective test strategy, test plans, test

cases and executed test scripts; ensuring business requirements are

met in the process.

. Extracted large amounts of data and manipulated it using SQL2005, MS

Access and Excel for Audit Deloitte Canada team. Consolidated and

verified data integrity / validated reports as per business

requirements.

Amex Canada Inc. - Technologies 09/2005 - 03/2011

SME (Subject Matter Expert) TECHNICAL SPECIALIST

. Developed and /or maintained all AMEX Canadian Production Distributed

Enteprise Systems on Windows 2003/2008 (approximately 100) through day-

to-day operational support - Problem Management, Change Management

Requests, Implementation Processes, Configuration.

. Technical Troubleshooting (anticipating, recognizing, and resolving

technical hardware, software, application or operational problems), to

the EDGE application (J2EE, Oracle, UNIX/LINUX, Tumbleweed File

Transfer) - externally known as Merced Performance Management Suite -

a tool that provides business monitor and reports for International

Call Centers - data fed from Avaya, Nice, Witness, CTT, CFS, ISP,

Paradissi, SSP etc.

. Initiated corrective action to resolve system and infrastructure

application errors (mainframe files, SQL 2005/2008 Server - SSIS,

IIS, WebSphere, DB2, Oracle, .Net, ETL process, Cube and Data

Modeling).

. Create supporting technical documentation for all reporting system

development; ensure adherence to standard code authoring/commenting

best practices.

. Single point of contact for support conceptual, logical, and physical

OLAP cubes - datamart schema - Star/Snowflake Schema, ETL SQL 2008.

Work with reporting staff to deploy, schedule, and set-up report

distribution in SSRS; Manage / Monitor Enterprise Reporting Server(s)

and Clarify reporting requirements for CardPro system designed to

track and measure the profitability of corporate accounts as well as

calculating incentives of sales, commissions etc.

. Participated in the design, development, testing, and implementation

of enhancements to existing databases and/or creation of new databases

in order to provide assistance to the Senior Dev DBA.

. Participated in Disaster Recovery exercises, as a member of the

technical recovery team and contribute to the success of the Disaster

Recovery tests.

. Managed multiple concurrent objectives, projects, groups or

activities. Effective judgment in prioritizing and time allocation for

all AMEX Canadian distributed production applications.

. Participated in and contributed to project and team meetings, for Bank

Audit Reporting (Anti-Money Laundering, Payments), Travel Department,

together with the Senior DevDBA team, interacting and collaborating

with team members and other departments, as appropriate, in order to

understand project requirements.

. Performed basic database administration functions (including

installation of database software, creation / modification of database

servers, account set-up, maintenance, access, and permissions) by

applying required changes to multiple databases.

. Worked process design, implementation, documentation and reporting for

the ITIL processes of Incident Management, INFOMAN, Problem Management

and Change Management within a medium/large IT environment and,

communicated with clients to resolve opened tickets in accordance with

Service Level Management Agreement within AMEX Canadian Distributed

Applications.

. Production Control utilization of production scheduling, review file

feeds including transactions received as well as completion of file

transfer, follow up on any alerts and any loading errors, control

procedures and maintaining of AMEX distributed processing service

deliverables.

. Escalated / lead when appropriate to business partners to ensure

problems or requests are communicated effectively to provide research,

analysis and documentation of business process improvement

opportunities and business requirements.

. Assumes the role of Lead Support Analyst in major projects and

initiatives, interacting and collaborating with team members and other

departments, as appropriate, in order to gain knowledge relevant to

application support (such as understanding new functionalities, what

parts of the system is being changed, and required environmental

changes) to ensure successful implementation of the environment

changes.

. For AMEX Bank Project effective identify, define and document detailed

business and system requirements utilizing the system development life

cycle (SDLC) methodology; gather and translate business requirements

into functional specification, including process flow and data model

documents; Translate requirements into test conditions and expected

results for product, performance and user acceptance testing;

. Integrate technical solutions with the business environment,

recognizing systems interdependencies, reusability and ensuring

seamless delivery.

. Created, maintained database and operational production documentation

for AMEX distributed application, using Share Point (e.q., Production

procedures and recommend preventative measures, business data

definitions, Design decisions, Change Request).

. Interacted with systems programming, server, database and network

support staff to maintain a responsive and available infrastructure

for the applications.

. Provided after hours (including weekend and evening work) to support

system changes, support pager 24x7.

CIBC 06/2004 - 09/2005

Sr Programmer/Analyst

. Developed Tactical Consolidated Remediation Reporting, which

consolidated deficiencies and action plans from various sources

including CCP and Audit.

. Developed multi-user secured replicable MSSQL /MS Access database for

Non-Financial Controls, distributed among thirty-five business lines

of CIBC bank worldwide.

. Developed sophisticated analytical Crystal Reports for Regulatory NFC

OOU department.

. Specific accountability for ensuring the completeness and currency of

the Repository of Controls.

. Recommended changes to the repository application to improve controls

evaluation process.

. Provided updates, reports and assessments to the NFC OOU Lead.

. Extracted Large Data conversion and manipulation using SQL2005,

Crystal, MS Access and Excel for the final ICR solution. Consolidated

and verified data integrity / validated reports per business

requirements.

. Supported and trained users for production support.

IT Specialist - IBM/Amex Canada Inc. - Technologies

11/1999 - 06/2004

Owned a project for the Point of Sale department, which fully automated a

manual process that incorporated the full sales cycle, from the original

order placement to the deployment and follow on support, responsibilities

included:

. Research conducted with all departments to understand full scope of

their manual process to ensure new automated solution would meet the

needs of their job requirements and the clients' requirements.

. Research conducted on various database products to determine possible

solutions for automated process; this enabled the leadership team to

have a comprehensive solution that met their needs and the needs of

the business.

. Build and Support online productions' databases - Debit Terminal Order

Form in Lotus Domino 5 for Electronic Merchant Services - Sales

Representative, thus increasing productivity, accuracy, leading to

increased customer service levels and meet our ten-day commitment -

received AMEX Award.

. Developed a Front End Transactions (Debit and Credit Card

Transactions) application from files imported from Stratus system,

with multiple database connections and multiple GUIs, using Visual

Basic, MS Access for Electronic Merchant Services. This Debit and

Credit Card Transactions database produces batch reports in real-time,

reducing calls to Point of Sale department, and, increased customer

satisfaction levels.

. Developed Deployment and Replacement Terminals database using Visual

Basic and MS Access on Windows server, for EMS Warehouse Department,

tracking inventory (how many terminals etc. are in/out of service) and

better manage the deployment and replacements of the assets, also

eliminating the need for traveling back and forth from the warehouse

to AMEX.

. Developed Call Track databases (have accurate reports by Merchant,

like history calls, agents volume calling, volume of orders etc.)

using Visual Basic and MS Access on Windows NT as a server database in

connection with Deployment and Replacement Terminals database and

Transactions (Debit and Credit) applications. This database assists

the helpdesk to monitor any on-going problems for Merchants by giving

information about Merchants such as name, address, phone number,

banking information, status of terminal order, terminal circuit info

etc.

. Designed Asset Management database using Visual Basic and MS Access on

Windows server database for Asset Management Department. This database

was created to provide a tool that would enable the Asset Management

Department to manage information about their computer assets - i.e.

who had them, lease expiry, location, etc. - the entire full life

cycle.

. Designed and Implemented the 'Courses' database on Windows NT, MS

Access application for Technologies Operations - Service Management;

this enabled the management team to have reports on courses taken by

each employee, and ensure appropriately funding was allocated.

Education

MS - Computer Information System - Universitatea "Lucian Blaga" Sibiu

(ULBS)

IBM Courses

Getting Results through Communication

Project Managers and IT Architects in Partnership - Reality or Utopia?

Project Management Orientation (PMTO)

IT Professions and careers, Becoming a Certified professional

IBM Professions: IT Architect Profession

The IT Architect: An Introduction

BIS Solutions, Assets and the critical role of the IT Architect

[pic][pic]

Contact this candidate