SUMMARY:

15 years of experience in software development. Full project lifecycle experience with system design, implementation, testing and deployment. Excellent analytical and problem - solving skills. Hands on experience with ETL, OLTP, OLAP, DW, object-oriented software development methodology OOP, documentation protocols, unit and integration testing, change management and release procedures. Self-motivated, able to work independently, excellent communication skills.

CORE COMPETENCIES INCLUDE:

• MS SQL Server T/SQL SSIS SSRS ETL Oracle RDBMS PL/SQL MS Visual Studio .NET C# ADO.NET WinForms
• TFS MS IIS HTML Crystal Reports PowerBuilder Windows & Linux OS

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior Software Developer

Responsibilities:

• Evaluated large and complex data sets.
• Created new SSIS packages and modified existing SSIS packages to support business requirements, utilized best practices SSIS patterns.
• Developed T-SQL code to support data migration project.
• Created Dynamic SQL, stored procedures, triggers, batches to control various aspects of data quality, used by Financial models.
• Debugged CLR / C# Stored Procedures.
• Utilized SSRS to design and build various Ad Hoc Reports.
• Resolved multiple issues related to code performance. Troubleshooted technical issues in various production T-SQL code, system configuration files.

Confidential, New York, NY

Senior Software Developer

Responsibilities:

• Developed PL/SQL stored procedures and DDL code to support PREMIUM/LOSS Data reconciliation.
• Created SQL Loader scripts to load/transform historic data into Oracle Database
• Developed PL/SQL code for an actuarial quarterly data segmentation process. This data further used to create DVR Triangles. Build WPF GUI application to monitor process results.
• Created PL/SQL Scripts to processed historic international data tables with hundreds of million rows.
• Developed C# code to process large datafiles utilizing Microsoft Visual Studio .Net 2017

Confidential, Middletown, NJ

Senior Software Engineer

Responsibilities:

• Managed multiple SQL Server databases in Development, QA and UAT environments.
• Worked with offshore development teams.
• Utilized SSIS to build and deploy ETL packages.
• Provided continues code integration and deployment.
• Managed QA and UAT environments.

Confidential, Hoboken, NJ

Senior Software Developer

Responsibilities:

• Worked on database PL/SQL code performance optimization and fine tuning.
• Utilized Oracle PL/SQL collections, BULK COLLECT, FORALL processing to improve speed of data retrieval, inserts and updates operations.
• Performed various Oracle DBA tasks in development environment, schema dumps and data loads.
• Deployment PL/SQL code testing in Development, QA and UAT environments.
• Provided continues customer support and issues tracking, utilizing Microsoft TFS as a version control system.
• Developed new and updated existing PL/SQL stored procedures, schema deployment scripts.

Confidential, White Plains, NY

Senior Software Developer

Responsibilities:

• Developed and implemented a C# code to support new NASDAQ and CME exchanges billing requirements. The changes affected all three tiers including XML Web Services, stored procedures, table definitions, front-end WinForms.
• Build and deployed various SSRS business reports. Modified a billing algorithm for UK subsidiary unit to accommodate national tax codes. Utilized SSIS for ETL activities.
• Upgraded the WCF service to provide additional product functionality, utilizing Visual Studio .Net 2012.
• Provided System builds, testing and deployments according to pre-planned schedules. Worked in Team Foundation Server (TFS) Environment.

Confidential, White Plains, NY

Senior Software Developer

Responsibilities:

• Created a SQL Server 2008 data model, stored procedures, tables and functions using T-SQL.
• Utilized Java script, CSS technologies for front-end page validation and creating custom page layouts.
• Developed a C# code, using ASP.NET and ADO.NET frameworks, HTTP Web services.
• Used Web UI controls by Telerik as well as standard ASP.Net Web Form controls.

Confidential, Jersey City, NJ

Senior Software Developer

Responsibilities:

• Developed ETL processes using Visual Studio .NET, C# and ADO.NET framework. Build various business reports.
• Created a SQL Server 2008 data model, stored procedures, triggers and UDFs using T-SQL.

Confidential, New York, NY

Senior Software Developer

Responsibilities:

• Created a large number of MS SQL Server 2008 schema objects including table /indexes creation, stored procedures, functions, batch jobs.
• Developed WinForms GUI for a Case Tracker case management System, which is used for investigation of potential OFAC violations and suspicious transactions.
• Utilized MS Visual Studio 2008 .Net and C#.
• Participated in Oracle Mantas 5.7 AML deployment. Configured and tested file adapters for Data Ingestion Server.
• Used Mantas Developer Toolkit to create detection scenarios, fine tune thresholds. Worked on improving overall performance of sequence and rule patterns.

Confidential, White Plains, NY

Senior Software Developer

Responsibilities:

• Participated in initial System design, Data Model creation, optimization and usability analysis.
• Developed a multi-tier application framework including WinForms front-end, XML Web Services, IIS Web Server, ADO.Net data access layer and Oracle 10g back-end database. Utilized Microsoft Visual Studio .Net 2005.
• Developed Equipment Inventory Module, Work Que Module, Reporting Module using C# .Net 3.0
• Developed a Bandwidth calculator component for the System it is utilized by the Order Wizard component in real-time as well as a stand-alone reporting process. Utilized Crystal Reports dlls.
• Developed a direct access functionality to MS SharePoint Server for a storage of related order documents.
• Ported a java written multithreaded Download Server Process component to C#.

Confidential, Lyndhurst, NJ

Software Developer

Responsibilities:

• Created a database interfaces between RPS and GDS systems, which allowed a record label Companies to be responsible as a single point of entry for the planning and manufacturing of their physical releases.
• Developed Oracle 9i PL/SQL scripts, stored procedures and triggers to support systems integration and reporting.