SUMMARY:

Experienced IT professional with expertise in systems, analysis, design and programming for a variety of business applications, development of new and enhancement of existing systems and including systems regulated by government agencies. Demonstrated abilities in management of multi - dimensional projects. SQL Server Database Developer with experience developing and implementing applications under Windows Operating System using MS SQL Server, ETL, .Net framework and Reporting Tools to deliver best technical solutions.

TECHNICAL SKILLS:

Databases: MS SQL Server 2000/ 2005/2008/2008 R2; Oracle Servers 7.x/9.x/10.x; MS Access; Progress; FoxPro

Programming: T SQL; Visual Basic; VBA for MS Access and Excel; PL/SQL; Java

Languages: DevelopmentSQL Server Management Studio; MS Visual Studio 2005/2008/2010 ; IIS; Enterprise Manager;

Tools: ODBC; SalesForce.com; SFA Workbench Tool; ReportNet1 Cognos Tool; Query Analyzer Cognos Tool; .Net

Internet: HTML; DHTML; VBScript; Jscript; ASP; XML; VB.NET; ASP.NET.

ETL Tools: DTS/SSIS MS SQL Server 2000/ 2005/2008/2008 R2; Pervasive djCosmos Tool; Apex DataLoader

Reporting: Crystal Reports; SSRS 2005/2008/2008 R2; Report Writer

Operation: Windows NT/XP/7; UNIX; Linux

PROFESSIONAL EXPERIENCE:

Confidential, NJ

ETL Developer

Responsibilities:

• Was responsible for setup and scheduled an integration process for new organization between Veeva and CAST systems. Provided daily integration process and errors related reports for data services group using Pervasive Integration Tools and MS SQL Server.
• Designed, developed and implemented data import using MS SQL SSIS to load data from various files into database. Created Pervasive integration processes and scheduled server jobs according established business rules. Setup as a part of an enhanced system to refresh tables daily, using delta update method.
• Analyzed and provided daily integration reports, using MS SQL Server ad hoc queries, views and stored procedures for defining integration errors, data evaluation, cleaning ingoing and outgoing data including extract, transfer and load data.
• Based on business requirements, developed SSIS packages for setting up sales market data process on weekly and monthly basic between client and company database services sides.
• Designed, developed and implemented data import using SSIS to load data from various files into database for setting up TOT data processes on daily basic between client activity on web sites and company database services sides. Created packages and scheduled server jobs according established business rules.

Confidential, New York, NY

Developer/Analyst

Responsibilities:

• Managed the entire project life cycle such as: development, testing and maintenance of user interface for entering customer’s information and data regarding the Internet Confidential or the Get Loaded applications and faxes via MS Excel.
• Designed and created new databases and structure of tables to extract, transfer and load “order entry” data using SSIS and MS SQL Server.
• Created new reports based on the business rules and user request using SSRS and Crystal Reports.
• Designed documentation for the process. Provided user support and troubleshoot server related issues.

Confidential, New York, NY

Programmer/Analyst

Responsibilities:

• Designed and developed the ANALISYS AND TRAKING TEAM RESULTS SYSTEM that allowed to analyze and track individual and group results through the visual graphs and schemas.
• Designed template for memorandum holiday letters and information regarding sport team members and coaches recommendations.
• Managed exporting data into different file formats using Java, XML and MS Excel.

Confidential, Parsippany, NJ

Analyst/Programmer/Sr. Technical Analyst

Responsibilities:

• Used MS SQL Server and MS Access for various queries and functions for special evaluation and cleaning ingoing/ outgoing data.
• Used SSIS to extract, transfer and load data, based on business requirements.
• Created new and modified an existing Crystal and Cognos reports based on the business rules and user request, published the information into Report System.
• Design database ad hoc queries and procedures for reports using MS SQL Server.
• Prepared specifications, technical analysis and normalization techniques for moving data between MS SQL Server and Oracle databases and performance tuning of database applications. Administer custom Windows Services and file management.
• Created maps of specification for setting up tables and relations in ODS system. Maintained processes between internal and external database systems using ETL tools. Create process files for automating tasks under the Windows Server using Pervasive Business Integrator Engine and MS SQL Server.
• Maintained and supported in-house intranet report system using ASP, Crystal Report and MS SQL Server.
• Lead technical analyst for primary interface design with outside consulting firms on various projects for restructuring PULSE to PDSM systems. Developed and maintained SQL Server DTS packages to load data from various feed systems such as MS Access, Oracle, Excel and text files. Formatting uploaded data from different sources.

Confidential, Jersey City, NJ

Programmer/Sr. Programmer

Responsibilities:

• Maintained and supported TotalHR Payroll System to restore structure file, setting up security level for users, updating system from Internet and creating R&R reports related to special tasks. Developed and maintained the auxiliary systems that are support TotalHR Payroll System using FoxPro, Report Writer, Crystal Reports, VB 6 and MS Access.
• Developed and maintained the IBM MIGRATION Systems to convert existing programs from IBM to PC according to PC library using MICROFOCUS CA-REALIA COBOL II WORKBENCH, CA-EASYTRIEVE WORKSTATION and creating batch files to convert from IBM print layout format to PC print layout format and installing MS-DOS programs under WINDOWS operation system.