SUMMARY:

• 20 years of overall experience in IT Industry
• 15 years Management of Application Lifecycle from conception to support. System selection, development, implementation and process optimizations.
• Installations and configurations, Analysis, Design, Development, Testing, Administration, and implementation of Client/Server applications and relational databases Data Warehouse Design, Development, Database Schema and Modeling skills.
• 16+ years expert in designing and creating Index, Views, Stored Procedures, Query tuning, Database Architecture, testing Disaster Recovery Plans, nesting Triggers, planning and implementing Server Security and authentication utilizing, Develop Queries, T - SQL Scripts and MDX queries in MS SQL 7.0/ 2000/2005/2008/2012 using Query Analyzer and Enterprise Manager, MS Access.
• Oracle 10/11, PL/SQL Development i.e. SQL Loader, Packages, Stored Procedures, Functions & Triggers using SQL Developer and Toad as development tools.
• Profiler and Index Tuning Wizard. Strong skills in Microsoft SQL Server Database with three years of backend administration, performed tuning and programming experience with analytical.
• Confidential SQL Scripting, Confidential (Enterprise, Voyager 6, 7, 7S). Investran(Report Wizard, Investran CRM, Investran SDK, Crystal Reports, SungardDX, Investor Reporting, NAV)
• Business Intelligence (BI), SQL Server Reporting Services, Crystal Reports, DTS/SSIS, SSAS.
• C#, VB .NET, ASP.NET.
• Excellent interpersonal and communication skills. Quick learner in new technologies. Financial Services Experience and Banking Technology.

TECHNICAL SKILLS:

Programming Languages: SQL, T-SQL, PL/SQL, VBA, MDX, C#

Software/Databases: SQL Server 6.5/7.0/8/2000/2005 /2008/2012 , Business Intelligence (BI) Analysis, SSRS,SSIS,SSAS, MySQL, MS Access, Oracle 10/11, VBScript, ODBC, OLEDB, COM, DCOM, SQL Server Reporting Services 2000/2005/2008/2012 , Crystal Reports 7.0/8.0/8.5/9/10/11/12 , MS Office 97/2000/XP/2010, MS Outlook, MS Visio, Photoshop, DTS, Stored Procedures, OLTP, OLAP, Data Warehouse, DBA, MS Excel 95/97/2000/XP, SAS, Confidential SQL Scripting, Confidential (Enterprise, Voyager 6, 7, 7S), Confidential Citrix, yClient, Investran 5.x, 6.x, SharePoint.

Operating Systems: Windows 95/98/2000/NT/4.0/ME/XP/CE/Windows 2008R2/Windows 10, MS DOS, UNIX, LINUX

Hardware: Intel Pentium PC's, HP, Compaq, Dell

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Application Developer

Responsibilities:

• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Management of Application Lifecycle from conception to support.
• Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems. Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace. Crystal Reports 10/11
• Oracle 10/11, using Oracle Export, Import, SQL*Loader and data pump utilities.
• Helped in creating technical specifications by mapping the interface tables with the base tables. Designed database tables as per technical specifications.

Confidential, New York, NY

SQL Server Developer

Responsibilities:

• Create reports using SQL Server 2000/2005 Reporting Services reports, Crystal Reports 10/11.
• Extracting and transforming data using SSIS.
• Created Triggers to enforce data and referential integrity.
• Database Schema and Modeling.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Wrote queries, store procedure in Oracle 10g.
• Worked on SSIS Package, Import/Export for transferring data between SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Take participation in migration from SQL server 2000 to SQL server 2005.
• Handled large volumes of Data Warehouse database. Designing and loading the data into data warehouse (ETL).
• Using VBScript in ActiveX for DTS and SSIS packages.
• Expert in extracting and transforming data using DTS/SSIS Import Export Data, DTS/SSIS Packages, Bulk Insert and BCP.
• MS SQL Server 2000/2005/2008 backend programming of stored procedures and queries.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system, query tuning.
• Monthly and daily reports for the number of transactions using SSAS, create cubes, MDX queries .
• Was making changes in store procedure in Oracle and code in C# .
• Involved in Migration from heterogeneous sources including Oracle to MS SQL Server.
• Created new tables, written stored procedures for application Developers and some user defined functions.

Confidential, Port Washington, NY

SQL Report Analyst

Responsibilities:

• Database Architecture Database Warehouse including support for existing and new projects (1 server- MS SQL Server 2000 and 8 servers - MS SQL Server 2005), about of 10 TB size of databases and include tables with 80 millions rows.
• MS SQL Server 2005/2000 created databases, store procedures, triggers, queries, monitoring and tuning, optimizing and troubleshooting, data modeling, migration and reports, SSAS, OLAP cubes, SSRS.
• Regular responsibilities for updating staging and dimensional databases in SSAS
• Created and rebuilt multidimensional cubes in SSAS to support high speed and flexible analytics.
• Writing MDX queries to SQL Server Analysis Services (SSAS).
• Created mapping spread sheet to map columns from current OLTP systems (source sequel Source) to DSS System (Target sequel server)
• Written stored procedures for Application Developers and some user defined functions.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Updated ETL packages into the SSIS Packages.
• Wrote VBScript code in DTS packages.
• Assist in the development and maintenance of ETL scripts for efficiently loading and extracting data from the database when necessary maintain, create, and improve database related documentation
• Handled large volumes of Data Warehouse database. D esigning and loading the data into data warehouse (ETL).
• Perform tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created Jobs to extract data from different sources using SSIS packages. Stored Procedures called the SSIS package that would aggregate the data and load them in globally temporary table, having the same architecture as the table for which the import is done.
• Install, setup and configure Database - SQL Server 2000/2005, clustering, mirroring, replications.
• Implement daily database backup schedules and/or routines for disaster/recovery.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Trig gers.
• Used SSIS packages to roll our data to Live Tables and to Claim Processing Database.
• SSRS, Crystal Reports, Cognos.
• Cognos report development, Cognos Connection, Cognos SQL generation
• Design and implementation of Cognos 8 analysis applications/reports (Report Studio 8, Framework Manager 8, Power Cube, Transformer)
• Cognos cube design and development and MDX
• Create parameterized Crystal Reports using Charts, Cross-Tab, Sub-reports, Running Totals
• Used SQL Server 2005 Reporting Services to generate different types of Reports.
• I optimized Crystal Reports and implemented parameters to avoid redundancy of reports.
• Configured Crystal Reports Server XI to have clients to get reports directly from the Webb browser.
• Designed and developed an Access database including custom queries, forms, macros, and Visual Basic modules, to maintain contract information.

Confidential

Data Warehouse Developer

Responsibilities:

• Wrote stored procedures, giving permissions to tables, database and views.
• Defined user roles and security logins through Enterprise Manager.
• Used SQL Profiler to monitor the execution sequence of SQL scripts.
• Created, backed-up and restored databases through SQL Wizards.
• Database Administration, Data warehousing, Database Modeling, Architecting, design and development in SQL Server 2000
• Wrote Stored Procedures, Triggers, Functions.
• Developer of applications and reports using Visual Basic 6, Crystal Reports 7/8/8.5/9
• Created parameterized and custom reports using Crystal Reports
• Architect and designed a MS SQL Server 2000 database for Arrival and Charge of the Goods.
• Optimization and automation of data loading procedures for accounting, pricing and catalog, development of data test and staging servers and creation of policies to guide use of same.
• Performed operating system and database performance monitoring and tuning.
• Utilized OLTP, OLAP, ODBC, OLE-DB and T-SQL for monitoring SQL Server jobs in Windows NT applications.
• Created new and modified existing databases, Tables, Indexes, Stored Procedures and Triggers in SQL Server 6.5/7.0 as necessary based on organizational needs.
• Established backup and recovery procedures for all application production data.
• Overhauled Access 2.0/VBA application featuring data-bound controls.
• Developed Access forms and sub-forms for data-editing, data-file import and export.