Management Customer Service
Resume:
[pic]
Carmen Radu-Din
** *********** ***., **** ****, ON
********@*****.***
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