SUMMARY:

• Over 10 years of work experience with Microsoft SQL Server development and administration, object oriented and web - based programming in C#, ASP.NET and Classic ASP. Experience with Project Management.

TECHNICAL SKILLS:

Languages: ASP, ASP.NET, C#, JavaScript C++, C, SQL, VB, Java, Java Servlets, Assembly, Scheme, Prolog, VBScript, PHP, HTML, DHTML

Administration: Services, Data Transformation Services, RDBMS, Database Maintenance - Re-indexing, Restoring and Back-up

Network: LAN, Windows 2000/2003 Domain Controller, Active Directory, DNS, DHCP, web-proxy

Administration: routers, firewalls, VPN, Exchange Server, Barracuda Spam Filter, Symantec Endpoint Protection, Veritas Backup exec, ISA server

Other: FTP, SSH, IIS, Telnet, ODBC/JDBC, TCP/IP, UDP, Crystal Reports, Batch Files, MS- Office, UNIX and Linux shell Commands, Apache, Tomcat Jakarta, Dreamweaver, Fireworks, GoLive, ImageReady, Photoshop, SMARTI document and image scanning software, Dataview document imaging and management software, SCP

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Senior Business Intelligence/SQL Developer/DBA

• Develop and adapt a comprehensive technical strategy to design, implement, administer and enhance new and existing Business Intelligence (BI) solutions for scalability and flexibility. The BI solutions help business users make critical decisions for planning, buying, budgeting and analyzing clients’ marketing needs.
• Conduct and participate in meetings with business stakeholders to gather business requirements. Work closely with managers and team members to analyze business requirements, project milestones, project deliverables and change management to achieve long term goals.
• Responsible for consolidating data from various data sources into a large scale data warehouse. Perform transition and integration of the historical data from legacy media system to current media system. Recommend hardware specifications for optimum performance of database servers. Perform development using SQL Server 2008, SSIS, C#, VB.Net, advanced T-SQL and ASP.NET.
• Administer, monitor and setup SQL database maintenance plans, user security, replications and scheduled jobs. Implement best practices and conduct performance tuning of SQL Server databases.

Confidential, Levittown, PA

IT Manager/Senior Software Developer

• Work closely with upper management to collect business requirements, design, develop, test, enhance, maintain and support existing business application developed in ASP.NET 3.5, Classic ASP and SQL Server 2008. The application makes extensive use of C#, Web Forms, User Controls, Validation Controls, Third party Data Access Components like Obout Grid Control, Forms Authentication, Master pages, AJAX Controls, XML, CSS, HTML/DHTML, SQL Stored Procedures and Web Services.
• Responsible for design, development, enhancement and maintenance of SQL Server 2008 databases. Design, develop and enhance normalized relational databases, complex stored procedures, views triggers and user defined functions using advanced T-SQL. Design and implement SSIS packages for ETL from multiple data sources like Providex, SQL Server, Access and text files into a Data warehouse. Implement maintenance plans to create/re-create indexes, update statistics, backups and manage transaction logs. Configure database mail in conjunction with SQL Server Agent for sending and scheduling reports/subscriptions pertinent to business users. Conduct performance tuning by analyzing queries using Database Engine Tuning advisor and SQL Server Profiler.
• Responsible for integration of SQL Databases as well as software applications of an acquired company.
• Perform due diligence administrative tasks for the upkeep of database servers and web servers.
• Designed, developed and implemented technical as well as business aspects of a web based Customer Satisfaction Survey for Confidential including the questionnaire and results analysis as part of a group project for one of the MBA classes. The survey was scheduled to be sent out every month via email to new customers including one reminder after 15 days.

Confidential, NYC, NY

Operations Engineering Manager/Senior SQL Developer

• Responsible for development, management and upkeep of SQL 2005 & MySQL databases in a clustered environment. Create, develop and design various statistical reports using SSRS in conjunction with SSIS. Design and develop normalized databases, schemas, complex stored procedures, views, triggers and user defined functions. Manage cluster, replication and log shipping. Implement maintenance jobs to re/create database indexes, update statistics, backups and manage transactional logs. Create user accounts and manage database security via user roles.
• Responsible to streamline operational processes in an environment consisting of ASP.NET, PHP, and MySQL including deployments to QA, Stage and Production environments. Implement checks and balances to monitor web applications, conserve SAN disk space utilization and performance tuning of blade servers
• Manage virtual infrastructure consisting of Windows and Linux servers loaded on an ESX cluster. Conserve SAN disk space utilization and performance tuning of blade servers. Automate administrative tasks and process via batch files and cron jobs. Administer Active Directory, Sharepoint, and Jira. Manage Domain Registrations/Renewal, software license purchase/renewals and SSL Certificates.
• Work closely with software development and customer service group to troubleshoot technical issues.

Confidential, Levittown, PA

IT Manager/Software Developer

• Create, develop, administer and configure SQL 2005/2000 databases for the telemarketing department. Replicate telemarketing data across various corporate servers using replication services, stored procedures and triggers. Design and implement SSIS packages for ETL from multiple data sources like Providex, SQL Server, Access and text files into a Data warehouse. Perform scheduled backup, data integrity check and re-indexing of databases. Restore database on demand. Configure SQL mail services to receive database maintenance reports and replication alerts.
• Developed an add-on reporting application to aid critical business decisions in field of marketing, sales and accounting. The ASP and ASP.NET front-end of the application interacts with SQL 2005 and Providex databases to create various types of statistical reports, graphs and gauges. The system keeps track of the effectiveness of various marketing campaigns in terms of incoming phone calls, sales appointments and sales revenue. The application also generates appointment reminder fliers, salesmen commission ledger, chargeback report, and address verification and correction report.
• Fully responsible for product conceptualization, design, implementation, quality assurance, and maintenance of a web-based software. The software is an SQL 2000 database driven ASP application. The core application helps ADT Alarm security systems dealer group to keep track of their new and existing customers, audit inventory, calculate commissions, generate payroll and funding reports, track and manage jobs, calculate financial as well as employee performance statistics, trigger email alerts and manage time schedule. Continuously adapt the designs and implementations based on user feedback and changing requirements.

Confidential, Woodbridge, NJ

Student Technical Assistant

• Assisted students in troubleshooting technical difficulties on windows 2000 and UNIX platforms
• Assisted students in debugging and programming in C++, Java, Visual Basic and Assembly
• Installed and configured software/hardware, and troubleshoot technical problems
• Maintained and diagnosed lab computers and workstations