Customer Service Sql Server

Peter Rosenblum

Email: *********@********.***

Address: **** ******** ***

City: Bellmore

State: NY

Zip: 11710

Country: USA

Phone: 516-***-****

Skill Level: Experienced

Salary Range: $114,000

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Peter Rosenblum

2996 Bellmore Avenue 516-***-****

Bellmore, New York 11710 *********@********.***

Programmer / Analyst ~ BI Developer ~ Application Support

Talented and motivated IT professional with 20+ years of success programming, developing, and supporting world-class software and data management solutions.

Career marked by highly visible roles and engagements with diverse clients from financial & banking, real estate, gas & energy, manufacturing, and high tech industries.

Extensive background in COBOL programming, mainframe systems & support, database development & maintenance, and network security. Demonstrated excellence in coding, testing, and debugging.

Successful in partnering with client stakeholders, management, and teams to evaluate needs, resolve issues, and develop programs and system enhancements to heighten business performance and user satisfaction.

Respected by managers, colleagues, and clients for customer service mentality, tenacious troubleshooting skills and unwavering commitment to quality, performance, and functionality.

Technical Background

Professional Experience

INDEPENDENT CONSULTANT, New York 2000-Present

IBM: Senior Programmer / Analyst (2011-2012)

Devloped Sql Server Packaages, Cubes and Reports under the SQL Server umbrella. Used packages in SSIS to import external data into Sql Server for processingNG. Created cubes in SSAS to analyze the data to allow users to report on the cubes provided. Modified and created reports to enhance the iser experience. Uploaded all files to SharePoint for user to use in daily practice.

Coverted JCL jobstrwams in mainframe to SQL Server applications. Was the first point of contact for BI based integration. Was on call 24/7 most weekdays. Would login form home to correct problems that arose during the night

Training of users on how to use SSAS to create output they are looking for. Discuss totaling routines with users to clarify what is needed for the business usage.

CUSHMAN & WAKEFIELD: Senior Information Solution Specialist (2006-2010)

Contracted by global real estate management firm to deliver high level programming and administration of business critical applications and systems supporting 2000+ users. Diagnosed, resolved, and documented 30-50 service requests daily via AdventNet Help Desk internal ticket system. Managed and optimized user security utilizing COBOL/DB2 database and Yardi Software. Established new user access and set up property lists. Modified back end COBOL and created Oracle scripts to repair menu issues for all security groups. Generated daily reports to measure output in VBA database.

Continued

Peter Rosenblum Page 2 *********@********.***

Spearheaded development of program changes, enhancements and bug fixes to heighten system performance.

Analyzed and optimized database performance, ensuring system stability, scalability, and integration of quality data architectures.

Maintained detailed documentation of data fixes, test results, and software code changes for database uploading.

Recognized as 'go-to' resource for quick resolution of all data and system performance issues.

STAR CHILDRENS DRESS COMPANY: Senior System Analyst, Manufacturing (2005-2006)

Conducted high level analysis, troubleshooting and maintenance of WANG COBOL/DB2 applications and data distribution system; skillfully applying patches, fixing bugs, and monitoring performance. Ran daily jobs, backups, and reports. Simultaneously administered and supported Windows 2003 Active Directory.

Led successful rollout of Microsoft Exchange for 300+ users.

Noted for enhancing programs and accelerating nightly data transmission process.

CABLEVISION: Internal Support Technician (2004-2005)

Provided highly responsive network and PC support in COBOL/DB2 Call Center environment with 4 million+ users. Addressed, prioritized and resolved technical issues and user requests surrounding Internet connectivity, hardware configuration, and software programs/installations.

Won promotion to supervisor due to outstanding work ethic and numerous recommendations from managers and colleagues.

Acknowledged for consistently delivering full-functionality and customer service excellence within fast-paced, deadline-driven environments.

IBM: IT User Support (2003-2004)

Installed and configured IT and network systems, hardware and equipment supporting 3000+ user base. Developed and deployed system/network maintenance plans and protocols, ensuring 24/7 connectivity, stability and reliability.

Tapped to lead large-scale project to replace 500+ laptops including hardware and software setup, configuration, and network connectivity. Completed project on time and within budget.

JPMORGAN CHASE: Programmer (2000-2002)

Performed in-depth analysis of business and user requirements, delivering advanced programming, development, and reporting solutions to elevate productivity, efficiency, and regulatory compliance. Maintained and supported ad-hoc user requests in FOCUS and COBOL II. Created loads for FOCUS master files in COBOL, and generated extracts for submission to the IRS. Crafted new programs to improve existing applications, and provided testing, end user support, debugging, and documentation.

Created CLISTS enabling user access to mainframe applications such as FOCUS in online mode.

Developed and analyzed new foreign accounts system.

Optimized overall operational performance as key contributor to critical application analysis, design, development, testing, maintenance, and implementation.

Earlier career history includes consulting positions as Programmer, Developer, and IT Support for clients including Marsh & McLennan Inc., Citibank N.A., and Reich & Tang.

Education & Credentials

Computer Programming Diploma

Grumman Data Systems Institute

Bachelor of Business Administration, Accounting

Baruch College

Network Security Diploma, Chubb Institute

Contact this candidate