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.
• Expert - level 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, CSV…) by using multiple transformations provided by SSIS.
• Extensive experience in Migrating from SQL Server 2000 to SQL Server 2005 / 2008 / 2008R2 / 2012.
• Highly proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up, drill down operations and Data Driven Subscription in SSRS.
• Extensive experience with ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
• Extensive experience in creating interactive reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Extensive 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: MS SQL Server Reporting Services Server 2012/2008/2005, SSIS, Crystal Reports XI, Excel

ETL Tools: SSIS, DTS

Application Software: Microsoft Office, Macros, Visual Studio.

Change Management Tool: Visual Source Safe (VSS)

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Analysis and/or reporting role using T-SQL for creation of stored procedures / SSIS packages and Extract-Transfer-Load (ETL) of the data.
• Developing and organizing high-quality documentation.
• Working in a continuous integration environment which requires effective analysis and decision making in order to move forward on tasks even with ambiguous or changing requirements.
• Data extraction and manipulation of data architecture.
• Interfacing with multiple users across the organization in order to effectively ‘project-manage’ reporting requirements from start to finish.
• Managing own work flow to 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, Dallas, TX

SQL Developer

Responsibilities:

• 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, Carrollton, TX

Programmer/ Developer

Responsibilities:

• 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, Dallas, TX

SQL Server Developer/Analyst

Responsibilities:

• 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