SUMMARY:

• Total 14 years of consistent database development and architecture experience
• Total 12 years of experience with Object Oriented Programming and Design
• Extensive experience in RDBMS design and deployment using SQL SERVER, MS Access, DB2, Oracle, and Sybase
• Client-server applications background, using VB.NET, C , ASP.NET
• Experience in design and coding of DTS and SSIS packages
• Hands-on experience in reporting tools: SSRS , Active Reports, Excel VBA , Crystal Reports

TECHNICAL SKILLS

• Utilities Tools: IIS, MSTS, MS Index Server, DTS, SSIS, SSRS, ErWin, BCP, WIN SDK
• Languages: T-SQL, C , Visual Basic 4/5/6, VB.NET, VBA, ASP.NET, XML, XSLT, HTML VB Script, JavaScript
• Databases: MS SQL Server 6.0/6.5/7.0/2000/2005/2008, MS Access 95/98/2000/2003, DB2, Oracl,Sybase

EXPERIENCE

Confidential

SQL Server/.NET/C Programmer-analyst - Consultant

Responsibilities:

• Worked on project architecture, introducing MVP Model View Presenter as a basis for the application, using Windows Forms .NET/C
• Built the presenter and model tiers personally. Collaborated with front-end UI developers on connection and presentation issues.
• Designed SQL Server SSIS Packages to extract, transform and load Medicare Claims in SQL Server system with output to government agencies. Wrote .NET scripts for script tasks/components to implement data extraction, cleansing and validation.
• Created databases, made db backups for development and test environments. Scheduled db backups and weekly reports SSIS / SSRS
• Implemented Rejected Claims/ Session Results reporting utilizing email alerts and notifications. SSIS FTP tasks for data upload/download were built and scheduled in SQL Server Agent utility.
• Developed model component for imaging system fluoroscopic images and X-rays with database interface.
• Created / modified the stored procedures, UDFs and views according to the functionalities using T-SQL. Designed Client Details, Session Results, Acceptance reports and demographic reports using SQL Server Report Services SSRS 2008
• Designed MIS Management Information System module that provides key reports integrated with different modules such as front office, billing, treatment, doctor reports and patient information. Rendered reports to HTML, PDF, Excel formats via SSRS
• Developed Treatment module which included prescription of medicine, medical procedures, diagnosis, treatment and patients' history.
• Performed some DBA duties. Creation of db objects such as databases, tables, indexes, space allocation, backups and user accounts.

Environment: SQL Server2008 SSRS, SSIS C 4.0 XML VBA Infragistics

Confidential

SQL Server/VB.NET/C Programmer-analyst Full Time

Responsibilities:

• Involved in designing back-end logic, implementing stored procedures and views, tracking investor activity in comparable deals.
• Using VB.NET / T-SQL, redesigned and rewrote Investor Merge Task, which combined Investor/Counterparty deals data. Introduced transaction processing into original design that fixed data integrity issues, placing data manipulation logic into stored procedures and db functions.
• Created presentation-quality deal status reports for borrowers, co-agents, senior management Active Report Tool was used .
• Developed business layer modules using C /ASP.NET, to process entry and retrieval of call notes and investor comments.
• Introduced numerous fixes and improvements on UI ASP.NET/Jquery/C and back-end to record deal invitations, calculations of commitment and allocation amounts.
• Wrote routines to combine transfer and migrate data, upgrading database from SQL Server 2000 to 2008.
• Migration of an Excel /MS Access data files to SQL Server 2008. via SSIS
• Advised programmers on optimization techniques, use of index, hit ratios, simple v. complex predicates.
• Build reports via Active Reports and light weight SSRS- RDLC , prepared documentation according to the client's requirements.
• As a SQL Server Developer, involved in physical database design, wrote stored procedures and triggers to minimize the workload at the front-end and for SSRS reports. Created class / entity diagrams.
• Rewrote stored procedures used in maintenance of production SQL Server 2008 databases. Replaced cursors with advanced T-SQL programming constructs.
• Developed Dimension and Fact table data ETL routines, utilizing Transact-SQL stored procedures

Environment: SQL Server2000/2005/2008 SSRS, SSIS Active Report 2.0 VB 6.0/VB.NET/C 3.5 ASP.NET JQuery XML VBA.

Confidential

SQL Server / .NET Software - Consultant

Responsibilities:

• Created technical solutions for The Statement Automation and Reporting System STARS , which is designed to replace manual process of preparing Production Residuals, Acquisitions and Participation Statements in New Line Cinema
• Implemented complex business logic through dynamically executed stored procedures. Optimized and tuned up data load, engaging indexing and Transaction Isolation Levels. Used Erwin as DB tool for data integrity checks, physical design and modifications. Wrote scripts for monthly scheduled data transfer tasks involving external Oracle ORFIN local SQL Server dbs.
• Based on stored procedures views, developed numerous dynamic Crystal Enterprise Reports, built and deployed SSIS packages.
• Involved in UNIT / SYSTEM testing maintenance of existing systems, interacting and collaborating with QA team.
• Wrote bulk update/insert st. procedures, using in-memory rowset applying SQL Server OPENXML.The Front-end was written in VB.NET
• Using VBA techniques, built Excel based Contract s Formula Elements for recalculation Participation Contract screen .

Environment: SQL Server2005 Crystal Report 10 SSIS VB.NET 2.0 XML VBA Erwin Infragistics.

Confidential

SQL Server /WEB/.NET Developer - Consultant

Responsibilities:

• Involved in logical and physical database design and optimization of current system. Created various stored procedures that searched and selected certified teachers in NY, separating them into subject groups. Designed data-mapping between heterogeneous sources like DB2, SQL Server and MS Excel.
• Performed technical analysis and revisions of the DOE web pages on selection of OMTS applicants and their license information.
• Created link servers connecting SQL Server with DB2 tables for cross-platform data transfer.
• Wrote DTS packages that performed miscellaneous activities such as collecting candidates data and sending e-mail notifications.
• Coded technical solutions for complex cross-database reports using Crystal Report/ C on candidate's personnel credentials.
• Using ASP.NET 2.0 / C , designed and built web pages, such as Certification Status of Employed Teachers, Professional development records, Online License Verifications and others.

Environment: SQL Server2000, DTS, OLAP MS Access Crystal Report 10 C ASP.NET 2.0/1.1 XML

Confidential

SQL Server /.NET/C Programmer-Analyst - Consultant

Responsibilities:

• Designed and built SQL Server 2000 databases and db schema objects.
• Setting up MS Index Server and creating data catalogs to optimize indexed search operations.
• Created custom Win forms using C that displayed information stored in the SQL Server database and indexed data catalogs.
• Developed search routines using VBA, designed for document management and accessibility.
• Performed database logical and physical design, coded db objects such as tables, indexes, procedures, triggers.
• Developed DB XSLT transformation procedures intended for UI and composite reports.
• Designed miscellaneous reports utilizing Crystal Report tool.

Environment: SQL Server2000 Crystal Report 9 C ASP.NET XML, XSLT , VBA

Confidential

SQL Server / VB.NET/ Developer

Responsibilities:

• Designed and developed VB.NET GUI based on business requirements including personnel history data access, general-purpose employee action screens, master-detail and search forms.
• Developed daily, weekly and monthly transaction, analysis, on-fly user requested reports, and letters using Crystal Report.
• Involved in database creation, data modeling, applying data integrity and normalization rules in SQL Server database.
• Designed ad-hoc queries and stored procedures, conducting search operations and complex validations on user input.

Environment: MS SQL Server 2000 Visual Basic.NET Crystal Report 8.0 VBA Word/Excel

Confidential

SQL Server / WEB/.NET/Programmer-analyst - Consultant

Responsibilities:

• Developed Dynamic Request Query Engine which enabled user to select predefined monthly based date/time span for customer account activity. Designed and developed multiple web-UI/presentation elements, business logic objects and various internal application modules utilizing ASP, C , Component One and Video Soft controls.
• Involved in development SQL Server's data-warehouse fact tables. Created database components: stored procedures, views and triggers in OLTP systems. Loading and presenting Sybase data via linked servers in SQL Server.
• Developed back-end SQL Server 2000 schema for Stock Research Module handling fundamental data, news and other related data.
• Using OLAP, assisted in the Star-Schema design of the fact and dimension tables.
• Formatted and converted incoming SQL server data into XML format for the presentation layer.
• Developed GUI elements for presentation Layer utilizing ASP, VB6, Video-Soft 3rd party controls
• Created technical solutions for miscellaneous reports based on Crystal Report 8.0.

Environment: SQL Server 7.0 / 2000 Sybase VB6 / VB.Net ASP / ASP.NET Crystal Report Infragistics / Video Soft controls.

Confidential

VB/WEB/SQL developer

Responsibilities:

• Took part, as database developer, in coding and deployment of the application that calculated price per square foot of given property. Interacted with end-users property managers, real estate brokers .
• During the development, the ActiveX code components were utilized to make extensive files manipulations, edit on the fly documents of MS Word format and then convert them into PDF format in order to display them over the internet and enable printing.
• Implemented Constraints Data Integrity on the existing database. Developed Stored Procedures and Triggers for customization. Tuned the database for performance by forcing the Index as needed. Used DBArtisan 5.1 Server on a Windows NT Server platform.
• Participated in front-end development, converting existing VB5.0 into ASP technology.

Environment: Oracle 8.0 SQL Server 6.5 ASP Visual Basic 5.0 Word/Excel Object OLE Libraries

Confidential

VB/MS Access developer

Environment: Visual Basic 4.0 MS Access.