Technical Support Information Technology

Emmanuel L. Constant

Phone: 347-***-**** E-mail: ********.****.*****@*****.***

Objective: Full-time systems analysis in information technology. Keen on

database and software design and management and web application support.

Overview: 10 years of IT analysis, relational database, and SQL. Know

Java, PHP, C# and ASP.NET programming languages; Ubuntu and Debian

Unix/Linux operating systems; Oracle Virtual Box, VMware, and Microsoft

Hyper V VM software; and GIMP and Photoshop graphic editing software.

Motivated self-starter. Meet deadlines. Learn and apply skills fast.

Solid grasp of development life cycle.

Experience:

Mt Sinai Department of Medicine, New York, NY - 10/11-Present Technical

Specialist/System Analyst

Environment: Windows Server 2008, Tomcat 6, SQL Server 2008, Visual Studio

2008/2010, Apache HTTP Server, MySQL

Frameworks: Bitrix CMS, LifeRay 6.2

Languages: C#, ASP.NET, CSS, JavaScript, XHTML, SQL, PHP

Tool: Excel, Visio, Word

Applications: PatientKeeper, Intellicred

> Application and technical support -- training, maintenance, and

upgrades for mission- critical systems.

> Liaison with software vendors to find and resolve software bottlenecks

and bugs.

> Researched and evaluated technical solutions, to improve department's

system operations.

> Helpdesk support.

> Designed department's intranet. Integrated traditional and social

media tools for managing employee communications.

> Developed backend solution to manage login request via intranet.

> Designed frontend concepts for department's Appointments and

Promotions web application.

> Analyzed, modeled and developed a 2-tier web solution concept to

support Grand Rounds Attendance and MICU Insulin distribution.

Sony Music Entertainment, New York, NY - 02/09-1/11 Technical

Operations Manager

Environment: Solaris, Oracle, Windows XP

Tools: Jira, Excel, Eclipse, Pl/SQL Developer

Languages: PL/SQL, SQL, Perl, Bash Scripting, XML, XSLT, Java

> Technical liaison for digital content partners. Provided support

during initial integration and content backfill and go-live process.

> Design dashboard to providing delivery statistics to management staff

and global operations teams.

> Analyzed data and provided ad-hoc reports for new partner backfills;

reconcile both delivery history and metadata discrepancies for digital

content partners.

> Tech support for global affiliates during import and registration of

audio, video, and mobile assets.

> Eliminated bottlenecks in testing and production environments.

> Created and updated digital content metadata for mobile partners.

> Prepared and maintained enterprise testing environment for UAT

software development phase.

> Monitored and provided first level application support for production

systems.

Sony Music Entertainment, New York, NY - 11/07-2/09 Technical

Operations Engineer

Environment: Solaris, Oracle, Windows XP

Tools: Jira, Excel, Eclipse, Pl/SQL Developer

Languages: PL/SQL, SQL, Perl, Bash Scripting, XML, XSLT

> Provided technical direction to potential digital content and mobile

partners by providing business rules and technical requirements for

ingesting Sony Music audio, video and graphic assets during

integration period. These directions included:

. Reviewed/sanity checked of content format requirements and

metadata

. Provided content test drops to partners for ingestion

development

. Confirm that the required hardware is used

. Test partner's secure network communication for the backfill,

and go-live phases.

> Maintained technical and business specifications.

> Provided front line technical support on systems' setup, ordering and

delivery of digital content to global partners.

> Improved daily workflow. Coordinated technical tasks with the global

Digital Operations Groups, US Digital Asset Management/Distribution

and software development teams.

> Application and technical support

Jewish Board of Family and Children's Services, New York, NY - 4/06-11/07

Senior Data Analyst

Environment: Windows Server 2003, SQL Server 2005, SQL Server Reporting

Services 2005, MS Access 2002, Window 7

Languages: VBA, SQL, Classic ASP, Visual Basic 6.0

> Produced reports on compliance and quality to provide management with

statistics for decision-making.

> Identified underpayment cases by designing database-tracking solution

to cross-reference with city systems for reconciliation.

> Provided data analysis expertise for department's Evaluation and

Review initiatives.

Catholic Guardian Society, New York, NY - 11/05- 4/06 IT Support

Technician

Environment: Windows Server 2003, Window XP, MS Access

Languages: VBA, SQL

Tool: MS Access, Excel

> Developed Information Technology training manuals and materials.

> Reconciled SSPS billing by providing data analysis and reporting.

> Desktop technical support.

The New York Foundling Hospital, New York, NY - 8/03-9/05 Data

Operations Supervisor

Environment: Windows Server 2003, Window XP, Oracle

Languages: VBA, SQL, Classic ASP, Visual Basic 6.0

Tool: MS Access, Excel

> Maintained and organized data from agency legacy system and state

systems.

> Desktop technical support.

> Designed data quality solution to support Medicaid eligibility,

information mismatches.

> Provided agency wide technical and analytical support by improving

data analysis and report distribution via dashboard.

> Trained department Management and staff to use Oracle Discoverer.

> Developed training manuals and materials

> Helped implement SSPS billing analysis.

Lutheran Social Services, New York, NY - 4/02-8/03 Data

Operation/Network Support Technician

Environment: Windows NT Server, Novell Window XP

Languages: VBA, SQL, Classic ASP, Visual Basic 6.0

Tool: MS Access, Excel

> Updated state systems with case data and provided data management

support for agency database systems

> Organized FCA data workflow analysis for Youth Service Department

> Designed a tracking solution for QA Department using ASP and SQL

queries

> Provided agency wide technical and analytical support which include

data preparation & backfill via legacy

> Provided technical support for both in-house and Connections computer

network, desktops, laptops and all computer peripherals

> Maintained storage area and computer room in an organized and

accessible manner

> Performed routine system backup and maintenance

> Updated and maintain equipment inventory

Education:

> New York University SCPS, New York, NY - 2/08-12/09

Java, Project Management and Oracle Intro to SQL

> Micropower, New York, NY - 02/06-4/06

Certificate for completing Oracle 9i courses

> Katharine Gibbs School, New York, NY - 10/00-9/02

AAS in Computer Programming -GPA: 3.46, President and Dean List

Contact this candidate