SUMMARY:

Hardworking, dedicated professional with excellent analytical skills and 20 years of hands - on experience in logical design, testing, and implementation of information systems, combined with supervisory and management experience

QBJECTIVE

To provide value, experience and dedication to an employer who can challenge and grow my professional career by providing opportunities to learn and contribute to a dynamic team environment.

TECHNICAL EXPERTICE

Databases: Microsoft Access / SQL Server 2000 / SQL Server 2005 / SQL Server 2008 R2/ Data General Infos II

Development Tools: Visual Basic. NET / MS- Word / Access / Excel / COBOL / Dream weaver 8 / Visual Studio 2010/ SQL Server 2005 / SQL Server Integration Services SSIS / SSRS / Tableau

Operating Systems: AOS/VS / Windows XP PRO / Windows NT / UNIX / Windows Server 2003

Back office Tools: Microsoft Office - Excel / Word / Access / Project / Power Point / Adobe Photoshop

PROFESSIONAL EXPERIENCE:

Confidential, Plymouth Meeting, PA

Senior Consultant

Responsibilities:

• Created stored procedures for DimCalendar project with Holidays and weekends set for the next few years.
• Reviewed documentation for upcoming projects.
• Reviewed data structures for upcoming projects

Confidential, Emmaus, PA

Business Intelligence Systems Analysis

Responsibilities:

• Creating Data sources for Tableau
• Gather data for an E-tailing project using SSIS to retrieve files from various methods (FTP SFTP API)
• Build reports for an E-tailing project using SSRS that originally were published to SharePoint and the report server.
• Create subscriptions in SharePoint and Report server to distribute reports on a regular basis
• Create data points that are directed to Tableau for better data visualization
• Use SSIS with Configuration files to load staging and the data warehouse on a virtual SQL2008 r2
• Utilize the Agile scrum with JIRA ticketing system
• Developed Stored Procedures, Triggers, Functions, Views, Dynamic SQL, T-SQL
• Designed and wrote SSRS reports

Confidential, Wayne, PA

Responsibilities:

• Create a process in conjunction with a vendor using SP OAMethods to standardize USPS addresses
• Create ETL process using both T-SQL and SSIS.
• Create ETL process using just T-SQL reading Excel / Access /Text input
• T-SQL ETL process
• Satori Mailroom Toolkit Architect
• Establish core process on a freshly installed system
• Data Replication between SQL2005 and SQL2005 express
• Set up, create SSRS reports
• Perform daily, weekly, monthly and annual backups.
• Perform database restores as needed.
• Regularly perform checks on SQL Server agent jobs.
• Archive files and data. Set up job agents to perform regular data and file archiving.
• Developed Stored Procedures, Triggers, Functions, Views, Dynamic SQL

Confidential, Wyomissing, PA

Responsibilities:

• Create & Build a SQL 2005 databases.
• Load Databases using SQL Server Integration Services.
• MS Visual Studio 2005 Business Intelligence Development Studio SSIS to read an AS/400 database
• Develop a VB.NET process to create Microsoft Excel Workbook.

Confidential, Spring City PA

Responsibilities:

• Conversion of claims letters onto a document management package
• Coding in a Visual Basic formatted language
• Computer services business supporting small businesses and personal computing needs
• Write, test, and implement Automatic Document Generator
• Error tracking and resolution in multi-tier environment
• Wrote, tested, implemented Word 97 Macros & VBA, WordPerfect Macros
• Created testing environments for full automation of document publishing conversion
• Redefined, rewrote, tested, installed macros for firm’s entire airline system
• Design, wrote, tested, and installed a Word-to-Web Questionnaire system in Visual Basic
• Functional re-organization of mailroom facility, including software and workflow

Confidential, Norristown, PA

Programmer Analyst / Technician

Responsibilities:

• Designed, wrote and tested in COBOL for a Loss Ratio System.
• Provided full-time technical support to operations and field customers
• INFOS Database Administration, including logs, backups, differentials, space management
• Wrote & tested COBOL programs for macro merges of print documents on Xerox copier equipment

Confidential

Programmer /Operations Associate

Responsibilities:

• Contracts included writing a scheduling system, Operations Department review, printing of large mailing documents, installation of networks including cabling, writing a marketing production system.

Confidential, King of Prussia, PA

Operations Manager / Programmer

Responsibilities:

• Designed and established a new computer operations department
• Administrator Database batch jobs, backup, batch, printing, and distribution procedures
• INFOS Database Administration, including logs, backups, differentials, space management
• Administrated 13 database systems for daily, weekly, monthly and annual operations
• Completed projects, eliminating paper printouts and sending files electronically to internal company departments, credit card companies, banks and office support companies.
• Wrote & tested COBOL programs for macro merges of print documents on Xerox copier equipment
• Hired, trained and evaluated employees
• Designed and implemented multiple systems including Tape library database systemMailroom Instant Label System, Agent Production, New Business Products, Card Embossing
• Manage printing of Policies, Premium notices on a Xerox 4050