SUMMARY

• Over 10 years of IT experience in database design, development and administration in the Microsoft SQL Server Suite of Products business domains such as Financial.
• Good experience in Information Technology field as a SQL server Developer with strong expertise in SQL server development, designing Stored Procedures/Transact-SQL coding.
• Expert in working with the Business Intelligence Development Studio BIDS , which includes SSIS and SSRS.
• Design of ETL DTS Packages SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, flat file, Text Format Data by using multiple transformations provided by SSIS
• Experience in Migrating from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008. 2012.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS.
• Experience with ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Experience in creating interactive reports using Crystal Reports and SQL Server Reporting Services SSRS .
• Experience in report writing using SQL Server Reporting Services SSRS and in creating various types of reports like table, matrix, and chart report.
• Worked very closely with Customers, End users and powered users collect requirements or resolve any business process related issues.

TECHNICAL SKILLS:

• Programming Languages: T-SQL, VB, VB.net, Clipper, Pascal
• Database Application Software: SQL Server 2012/2008R2/2008/2005/2000, MS Access RDO, DAO, ADO.net, ODBC, SQL , DBF
• DB Utilities: SQL Server Management Utilities, Query Analyzer.
• Reporting: Crystal Reports XI, Excel, MS SQL Server Reporting Services Server 2012/2008/2005, SSIS. ETL Tools: SSIS, DTS
• Application Software: Microsoft Office, Macros, Visual Studio. Change Management Tool: Visual Source Safe VSS . EXPERIENCE:

Confidential

SQL Developer/Global Report Analyst

• Analysis and/or reporting role, with skills in T-SQL, SSIS packages, and stored procedures.
• ETL
• Develop and organize high-quality documentation.
• Effectively move forward on tasks even with ambiguous or changing requirements and work in a fast-paced environment.
• SQL Server 2008.
• Data extraction and manipulation data architecture.
• SSRS
• Interface with multiple users across the organization and effectively project manager reporting requirements from start to finish.
• Manage own work flow and meet deadlines while responding to frequent demands of multiple customers internal and external

Environment: SQL Server 2008R2, SSIS, SSRS , T-SQL, XML, MS Excel, MS Access, MS Visual Studio 2005/2010, Crystal Reports XI, SFTP.

Confidential

SQL Developer

• Creation of various policies and form letters for different insurance issues like: billing, form letters, statistical reports loss, damages, claims, premiums, workers comp, financial calls, etc.
• Created Databases, Tables, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Created views, and appropriate indexes to optimized complex queries.
• Generated custom and parameterized reports using SSRS
• Configuration and Deployment of all Reports
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Extensive experience in multi complex / combined report development in Crystal Reports as requested by the client
• Responsible for deploying SSRS reports on Production Server
• Created several packages in SSIS
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals

Environment: SQL Server 2012/2008/2005/2000 Enterprise Edition, SSIS 2005, SSRS 2005/2012, ADO.NET, T-SQL, VisualStudio.NET, MS Excel, MS Access, MS Visual Studio 2005/2010, Crystal Reports XI.

Confidential

Programmer/ Developer

Responsible for development and maintenance of: 'General Ledger', 'Accounts Receivable', 'Accounts Payable', 'Payroll', 'Point Of Sales', 'Food And Beverage', 'Purchase', 'Timekeeping System' and many other projects for conversion from DOS written in Cobol into Windows.

Environment: Access, Visual Basic, Crystal Reports, SQL Server, T-SQL, Active Reports, TDB Grid, ISAM Files, etc.

Confidential

SQL Server Developer / Analyst

• Responsible for development and maintenance variety of applications and programs to generate credit reports and support customer service.
• Adjustment of Client Data, such as credit history and identification, in accordance to Mega Bureau Database standards.
• Maintained, controlled, and formatted collected client information in order to be sent for approval.
• Input / Transform of various file formats
• Output / Transform of reports with compliance to Mega Bureau formats.
• Tested new software and their ability to generate reports about clients' credit qualifications.
• Data Migration and Security.
• Mega Bureaus: Equifax, Transunion, Experian

Environment: Access, SQL 6.0 6.5 , T-SQL, and Visual Basic

Confidential

Programmer / Manager of Computer Center Finance and Accounting

Confidential

Director of Finance Department