Data Services Manager Resume Profile

Business Systems Analyst

A committed and proactive professional with specialist skills in analyzing, managing, and developing effective software solutions. Capable of applying new technologies to improve business processes, while demonstrating a logical and analytical approach to dealing with complex issues. Possesses a strong attention to detail, with the ability to prioritize tasks wisely. Widely regarded as a strong and supportive leader, who thrives in fast-paced and challenging work environments.

Professional Experience

Independent Consultant,

Confidential

Designed, coded, and documented a prototype management system for an international educational institution. Developing mobile applications for a presentation consulting service in New Jersey.Accountable for a major contract to transfer Reader's Digest Oracle reporting systems to India, liaised extensively with the offshore project team to ensure minimum disruption to business operations.

Environment: SQL, PL/SQL, TOAD, VB.net, ADO.net, Visual Studio, MS Access, SQL Server, Java / Swing, SQL Developer, Linux

Confidential

Database Marketing ,

Business Data Services Manager

Hands-on manager responsible for the development, administration, and maintenance of three Oracle BI
reporting systems with over 1,000 reports supporting all magazines and book continuity products.
Acted as a central point of contact and liaised extensively with the user community, IT management, and corporate executives, utilizing strong interpersonal and communication skills.
Effectively managed multiple software development processes concurrently, involving the application of Agile iterative SDLC methodologies.

Environment: SQL, PL/SQL, TOAD, Oracle 10g, Discoverer 10g, SQL Loader, DB2, SQL Developer, UNIX, Solaris

Highlights

Designed and coded efficient SQL solutions to query a database of 111 million customers spanning several Oracle instances, the SQL-Server database, and DB2 tables using Oracle DBLinks ODBC .
Reduced reporting costs and response times by 95 via the creation of aggregated data marts. Automated the Reiman magazines reporting system enabling a 40 saving in labor costs.
Deconstructed 80 Business Objects reports and converted them to PL/SQL within a six-month period.

Confidential

Business Systems Consulting Analyst Environment: SQL, PL/SQL, TOAD, Oracle 9i, Discoverer 9i, SAS, DB2, HTML, MS Access, OS390, UNIX, SolarisProvided team leadership, software project management, and set priorities for all ad hoc report requests. Worked closely with the IT team on the development of business processes for the new Oracle data warehouse, developed user metadata documentation for the Oracle BI application, and provided training to end-users. Additionally responsible for providing analytical support to marketing, customer service, and digital groups.

Highlights

Successfully designed, coded, and maintained the Consumer Marketing Ailment Database which was used extensively by the advertising sales department to data mine ailment and medication patterns.
Spearheaded development of the Customer Service Very High Activity Reporting System, this was crucial in ensuring full compliance with the Attorneys General Sweepstake Assurance agreement.
Created a comprehensive Ailment Demographic Report which enabled the advertising sales team to increase sales of advertising space to pharmaceutical companies and substantially increase revenue.

Confidential Business Systems Specialist

Responsible for the design, coding, maintenance and documentation of all SQL queries across the Database Marketing function.
Conducted SAS statistics analysis and presented findings to Q/A statisticians and senior management. Monitored the periodic conversion legacy assembler system to in-house database system regression testing prior to production release.
Attended production mailing meetings, resolved query issues and made query recommendations. Successfully developed and guided a team of five junior business analysts to roles as SQL programmers.
Environment: SQL, SAS, DB2, HTML, MS Access, TSO/ISPF, OS/MVS, JCL, OS390

Highlights

One of the original participants sought out to interpret decades old legacy assembler code and convert the functionality to a logical and physical data model.
Supervised the construction of affinity-based SQL queries and managed all user acceptance testing UAT as part of a cross-functional marketing, quality assurance, and IT group.
Responsible for the Database Marketing Y2K testing and subsequent signoff.

Professional Development

Oracle Business Intelligence Discoverer Administrator End-User, Oracle University Oracle Database 10g: PL/SQL Programming, Oracle University
Direct Marketing Certificate, Western Connecticut State University
Unica Affinium Campaign, In-house training Managing for High Performance, Right Management
Registered iOS developer for iPhone / iPad / iPod, Apple, Inc.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship