SUMMARY

• Programmer Analyst with extensive experience in Data analysis, Reporting and Application development. Managing the full application implementation cycle using SDLC guidance.
• Detailed knowledge of CRM applications structure, business requirements, workflow and customizations.
• In-depth expertise in Relational Databases management and development.
• Highly creative application/IT support professional with strong problem solving and analytical skills. Proficient in prioritizing and completing tasks in a timely manner.

EXPERIENCE

Confidential

Application Developer / IT Support Consultant

• Maintained and supported Oracle/ SQL Server databases by developing tables, views and stored procedures
• Provided specifications and tested proprietary systems for enhancements, technical specifications, test plans and deployment methods
• Modified Sales Logix CRM application to increase data transfer speed conveyed technical documentation and analysis for the conversion from Sales Logix 6.2 to 7.5 version.
• Analyzed data integrity and performance created reports per clients specifications using SLX, query analyzer and Crystal Reports
• Revised technical documentation of related technologies, applications and upcoming releases
• Integrated new technological solutions across SDLC by establishing business process requirements
• Determined critical issues for clients by collaborating with vendors, management and team members
• Conducted technical support for Windows Server 2000/2003/2008 R2/2012, Remote Access, VPN
• Performed Zebra label printers configuration and troubleshooting
• Implemented Risk Analysis, Incidents Reports, CR, IQ , SRS, SOP, WP and Validation for applications improvement
• Collaborated with Application Managers and users to develop and troubleshoot in-house and vendor provided software for systems designed to support biopharmaceutical company's client enrollments and financial services
• Developed Graphic User Interfaces designed for import/export data from Web enrollment, finance and Oracle based Clinical and Laboratory applications, utilizing various third party tools and windows services for the data manipulation
• Provided data mapping, data transfer and database structure from Sales Logix to Sales Force integration

Confidential

Senior Programmer

• Deployed various enhancements to Sales Logix CRM application using Sales Logix Visual Basic Scripts, Visual Basic 6.X, SDK and DLL
• Created technical specifications, test plans and deployment methods, performed data transfer and manipulation from various data sources to the SLX front end within Sales Logix 6.2 functionality
• Conducted data monitoring, grouping and reporting, based on user requirements, daily data import utilizing XML program. Organized data export to the AS400 sales tracking system
• Managed complex Stored Procedure programming for the reporting needs utilizing Crystal Report 8.5 as a front-end
• Communicated with Product and Account Managers to troubleshoot, develop and enhance existing and new software for systems, designed to support financial services industry, specifically Mutual Funds sector by providing contact management and sales tracking
• Developed User Interface screens, data management, and codes designed to receive and import data from third party sources, submitted it to proprietary sales tracking system
• Supported troubleshooted and upgraded various applications provided clients with technical support and application service

Confidential

Senior Programmer

• Deployed custom functionality to Sales Logix CRM application using Sales Logix Basic scripts functions, SDK and DLL, Visual Basic 6.X
• Performed Database administration and end-user support, front-end design and report generation to support company sales force and marketing needs.
• Designed reports using Sales Logix IQ reporting tool, Crystal Report 8.0/8.5 and MS Excel
• Developed and maintained Web based site using reporting tools such as Crystal Reports, SQL Server, ASP and Java Scripts languages
• Implemented Complex Stored procedures using Crystal Reports as a front-end
• Coded and tested triggers for data flow monitoring

Confidential

Programmer/Analyst

• Implemented SQL stored procedures, formated list count reports, delivered promotion files to appropriate vendors
• Generated Post-campaign and Response Reports based on marketing specifications and ensured proper functioning of database
• Performed day-to-day administration and programming to support marketing and company IT application needs
• Developed programming solutions for business applications using VB 6.0 MS Access
• Programmed and tested SQL stored procedures and formatted reports using Business Objects 4.1
• Transferred data from MS SQL Server database to data file in a user specified format using BCP utilities
• Participated in migration from SQL 6.5 to SQL 7.X

Confidential

Programmer/Analyst

• Participated in user requirement analysis, creation of prototypes and interaction with users
• Designed front end user interface for data manipulation based on GUI standard utilizing advanced features of third party controls and touch screen technology, designed Database structure including development of tables, views, stored procedures and triggers
• Developed module for supporting touch screen technologies and credit card interface
• Created the POS system designed for full service hotel systems and restaurants
• Deployed remote printer management tool using Windows API, ActiveX and DCOM technology

TECHNICAL SKILLS

• OS: MS Windows ,UNIX , AS400
• Languages: C/C , T-SQL, PL/SQL , MS Visual Basic
• Databases: MS SQL Server 2012/08, SYBASE 10/11, DB/2, MS Access, Oracle 10g/11g
• Internet Tools: HTML, CSS, VBScript, JavaScript, MS IIS
• Tools: ActiveX/COM/DCOM, DAO/RDO/ADO, Win32 API, OPOS-2, Crystal Reports,
• MS Office, Business Objects, SalesLogix SLX