SUMMARY

• Over 15 years of responsible IT experience with 10+ years in Microsoft SQL Server development migration, testing and support for Government, Finance, Communications, Food and Beverages, Pharmaceuticals, Aviation, Waste Management, Insurance domains.
• Hands on experience working with both AGILE SCRUM & WATERFALL methodologies
• Extensive experience in Data Modeling (Logical and Physical Design of Databases), Normalization, creating new data models, and data flows, data dictionaries & building referential integrity constraints.
• Excellent backend skills in creating SQL objects such as Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions
• Very good T - SQL & Dynamic SQL programming skills.
• Hands on experience in Legacy Data Conversion from complex systems
• Experience in optimization tools such as index tuning wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Fair experience in complete ETL cycle including data analysis, data cleansing, data validation, conversion & data Load
• Proficient in implementing business logic and procedures in backend Stored procedures & Functions.
• Experience in implementing SQL Server Database Security
• Experience in Custom Scripting using VB.NET / C# for ETL Operations & experience in creating CLR functions / procedures
• Good experience in creating ETL Packages using SSIS
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP databases.
• Hands on experience in designing Drill-Through, Parameterized, Adhoc and various other report models using SQL Server Reporting Services (SSRS) & SQL Server 2008
• Experience in re-writing Business Objects Reports to SQL Server 2008 Report Builder 2.0.
• Resourceful and deft in all phases of the SDLC (comprising requirement analysis, development, testing and troubleshooting), with strong programming, database and application support skills across technology platforms
• Sound knowledge in Data Warehouse, Dimensional Modeling, ER Modeling, Star Schema/ Snowflake FACT, Data Marts, Dimension Tables and creation of OLAP Databases.
• Experience working with offshore teams and usability teams
• Excellent experience in Customer facing, Requirement gathering & SDLC documentation
• Supervised and mentored junior developers throughout SDLC project lifecycle
• Performed multi-tasking roles in various projects depending upon client’s requirement.
• Well versed with estimation, planning, scheduling and task allocation
• Comfortable in interacting with people across hierarchical levels for smooth project execution.

TECHNICAL SKILLS

RDBMS: SQL Server 7.0 / 6.x / / R2, Oracle 8.0, MS-Access

RDBMS Tools: DTS, SSIS, Enterprise Manager, SSMS, SQL profiler, Tuning Advisor, Surface Area Configuration

Reporting Tool: SQL Server Reporting, Crystal Reports 8.0, Report Builder 2.0

ETL Tools: Business Intelligence Development Studio (BIDS), DTS Business Intelligence SSIS, SSRS

Data Modeling: Visio 2003/2007, System Architect 9.0, UML

.NET Frame Works: 1.0 /1.1 /2.0

GUI Tools: Visual Basic 6.0/ 5.0, Windows Forms

O/S: Windows NT, Windows 9x, Windows’2000/2003

Languages: T-SQL, Dynamic SQL, JavaScript, VB Script, VB.NET, C# .NET

Internet Tools & Other: Active Server Pages (ASP 2.0 / 3.0, COM, ASP.NET / XML, ADO.NET, Visual Studio.NET /2008, .NET Remoting & Web Services. Business Analysis Customer Facing, Business Requirement Gathering, SDLC documentation, Creation of WBS, Task Estimation

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

SQL Server Consultant

Responsibilities:

• Working at Confidential Integration *Houston, TX for the client Confidential - Tarrant county in complex Legacy Data Conversion Project.
• Worked on analyzing the demographic data to be moved into the new system.
• Created lattice data files to import to profiler depending upon the requirements.
• Worked on creating a Mapping document for the new /change requirements in data movement from legacy to profiler system.
• Moved data from flat files to staging tables using SSIS. Modified existing T-SQL queries and stored procedures which move data from staging tables to Profiler.
• Used C#.NET coding language for complex data business validations.
• Executed stored procedures provided by UNICARE to verify correctness of the migrated data
• Created process level documents for the data migration from legacy system.

Environment: SQL Server 2008, T-SQL, SSMS, SSIS, BIDS, Visio 2007, C#, .NET, Visual Studio 2008, Visual Source Safe

Confidential, Atlanta GA

Sr. SQL Server Programmer

Responsibilities:

• Performed SQL Server database schema modifications to facilitate changes in business rules related to transactions with banks and vendor payments
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build, maintain SQL scripts, indexes, complex queries for data analysis and extraction.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Provide database coding to support business applications using T-SQL
• Perform quality assurance and testing of SQL server environment.
• Develop new ETL processes to facilitate import / export flat files for bank transactions using SSIS
• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation and change management.
• Involved in Database Modeling and Normalization.
• Designed and developed reports for Government Procurement card discount purchases and Vendor Payments using SQL Server Reporting Services (SSRS).
• Audited database user’s using SQL profiler tool and costumed stored procedures and packages. Hide tables columns from the developers and non technical staff member using views.
• Identified and performance tuned long running queries. Resolved blocked and locked objects issues.
• Developed SQL Server Integration Services (SSIS) packages for ETL operations to upload procurement data and discounted information for government departments
• Gathering requirements for the new functionalities to be implemented for student special needs.
• Contributed in estimation of tasks and implemented jobs within tight deadlines.
• Involved in database schema changes and tuning T-SQL queries for data related to district schools in Education department.
• Created extensive stored procedures to analyze fund approval data.
• Worked on creating parameterized reports in SSRS for special education students
• Used custom scripting of .NET coding (VB.NET) for SSIS packages, created for mailing out the student test results.
• Provided production support in jobs related to T-SQL, SSIS & SSRS Reports

Environment: SQL Server Management Studio 2008 R2, T-SQL, SSMS, SSIS, SSRS, BIDS, VS.NET 2008, VB.NET, VSS, UML

Confidential, Texas

SQL Server Database Engineer

Responsibilities:

• Involved in Requirement gathering with Business Users for Creating Logical and Physical Design of Confidential Web Registration System.
• Involved in the SDLC phases of Design, Development, and Testing & Implementation
• Worked on ER & Data Flow Diagrams using Visio 2007
• Generated Database Schema using Visio DDL Scripts, refining the database model and synchronization between model and database.
• Developed Stored procedures, Triggers and User defined functions for the system.
• Responsible for creating Guess Tag stored procedures for identifying bin location and its relevant customers using GPS coordinates.
• Used ETL operations using SSIS Packages to export Bin Lift information to a comma delimited file which was uploaded using FTP to US Network location and automated the process to run daily.
• Responsible for creating Schema modifications & stored procedures for enhancements of functionality in Confidential CRM ticket logging system
• Created SSRS Reports for Waste Management and CRM ticketing systems
• Created stored procedures, views, tables, triggers, table-valued, scalar functions etc. for various client databases.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Worked on Performance Tuning of SQL queries and stored procedures using SQL profiler for client databases.
• Worked on database design anomalies in existing client schemas and rectified them.
• Worked on Web Services for Confidential Web Registration
• Integrated Realex Payment Objects in C# Application for Online Web Registration.
• Involved in providing support for database related issues.

Environment: SQL Server 2005, T-SQL, SSMS, SSIS, SSRS, BIDS, Visio 2007, C# Web ServicesVS.NET 2005, Releax Payment Objects & Visual Source Safe

Confidential

SQL Server Developer

Responsibilities:

• Requirement Gathering for re-design of PCOM (Performance Communication) application and also involved in drafting Specification documents such as Requirement / Technical / Traceability Matrix.
• Normalized the database into small tables by applying rules of Normalization defined Check Constraint and applied Business Rules
• Created Database and Database Objects like Tables Stored Procedures Views Triggers Rules Defaults user defined data types and functions
• Created and managed user’s roles and groups and handled database security for Content Management System.
• Used SQL Profiler to estimate the Slow Running queries and performed tuning
• Worked on proper use of Indexes to enhance the performance of individual queries and improvement of the Stored Procedures
• Implemented Full Text Search in SQL Server 2005
• Worked on N-Tier architecture for PCOM and created BAL/DAL Layers in C#.NET
• Documented of all changes involved in the database for future reference
• Worked on SQL Server Integration Services (SSIS) and automated the process of ETL operations of exporting mortality Data Feeds from Text files to Test Servers
• Responsible for Creating SQL Server Reports (SSRS) for Mortality Factors.
• Worked on existing Visual Basic Forms to implement enhancements in Mortality application.

Environment: SQL Server 2005, T-SQL, SSIS, SSMS, SSRS, Visual Basic 5.0 / C#.NET win Forms/ASP.NET, Visio 2003, VS.NET 2005, PVCS Source Control

Confidential

Sr SQL / Application Developer

Responsibilities:

• Worked in the Special Projects Group. Mainly involved in development of the new version of
• Passport Issuance System (PIS) for the State of Kuwait using Microsoft SQL Server 2000 and migrated the database to Microsoft SQL Server 2005. Passport Issuance system is one of the Kuwait Confidential Mission-Critical Projects assigned to the Special Projects Group
• Extensively involved in Gathering requirements from the Users of the Passport System and implemented UML and all the SDLC design phase documents.
• System Architect Database tool version 9.0 was used for Data modeling database for PIS System.
• Verified PIS Database Models and worked out comments and recommendations for PIS using System Architect.
• Extensively involved in Re-Design of Database for PIS System Migration in respect to the business rules and enhancements in the Passport System.
• Worked on Creating / Modifying Stored Procedures and Triggers for PIS RDBMS
• Created and maintained DTS Packages in SQL Server 2000
• Involved in Performance Tuning stored procedures and rectified their defects.
• Installing and Configuring SQL Server 2005
• Involved in Database Health Monitoring
• Created and Maintained Database Indexes
• Responsible for Query Optimization and Trouble Shooting.
• Worked on the Object oriented design to implement N-Tier architecture in .NET
• Created a Component in VB.NET which uses IBM Personal Communication Automation Objects to Interact with IBM Main Frame screens to extract data to front end applications
• Created .NET Win Forms for PIS System and implemented .NET Remoting in respect to re-design of existing PIS Visual Basic modules.
• Implemented Crystal Reports for the Passport (Printing / Distribution) departments.

Environment: SQL Server, SSMS, T-SQL, Dynamic SQL, Data Modeling Tool - System Architect 9.0 VB.NET Win Forms, VS.NET 2003/2005, IBM Personal Communications Ver 5.6, Visual Basic, COM, Crystal Reports 8.0, IIS 6.0, .NET Remoting

Confidential

ASP / SQL Developer

Responsibilities:

• Involved in Development of Telecommunication Application on ASP using SQL Server 2000
• Involved in Logical & Physical Design of the Database for the Telecommunication Application
• Created DTS Package to send a List of Calls per day handled by Email to the Manager.
• Created stored procedures, views, tables, triggers & User defined functions
• The telephone numbers and user’s extension (Caller Extension) and the dialed (Called Extension) were being stored in database and retrieved as and when required by the user.
• This module has been designed to allow the employees (or users) to dial telephone numbers (either internal, external or private numbers) thru the ASP page. This module takes advantage of Windows Socket Programming (WinSock Control), to send and receive messages across IP to IP.
• The user’s authentication is automatically picked up from the WinNT Login by the ASP Page and further validated with the SQL Server Database and provides access.
• Involved in Creating Stored Procedures and User defined Functions.
• If the user is not registered in the database, there is a provision (thru another ASP Page) for registering new users and simultaneously updating the database with the new user settings and extension numbers.
• The administrator’s had been provided with separate options in the ASP Pages (invisible for normal users) to keep track of the existing users, their calls made, their extension details and so on.
• The Reports had been provided with Crystal Reports 8 in co-ordination with ASP Pages. i) Customer Contract Number-Wise Call Back Time report, where the Customer Contract Number can be optionally provided by the user or left blank for all Contract Numbers. ii) Product Name-Wise Call Back Time report, where the Product Name can be optionally provided by the user or left blank for all Products. Had used the Parameter Passing option from ASP Page(s) to Crystal Reports.
• The ASP page facilitates Pop-Up window on receiving acknowledgement (or an incoming call / response from the Winsock Server) according to the user session/extension. By this, the user is not forced to be waiting on a single ASP page (restriction is not required so that the user can keep browsing with other pages).
• Worked on Migration of parts of ASP Pages to Beta Version of ASP.NET 1.0

Environment: SQL Server 2000, T-SQL, ASP.NET,ASP 2.0/3.0,Visual Interdev 6.0, VB Script, JavaScript, HTML,Visual Basic 6.0, Active X Data Objects 2.0,Crystal Reports 8, IIS 4.0/5.0, Windows’2000

Confidential, NE

ASP / SQL Developer

Responsibilities:

• Involved in the development of Internet application which keeps a track of an Employee, Managers within an Organization.
• Involved in creating Database Logical and Physical Design.
• Worked on Creating Stored Procedures, Triggers, Views, User defined functions.
• Worked on Query Analyzer to performance tune Queries and Stored procedures.
• Worked on Ecommerce Applications like Integrating http://www.proveit.com (Test Site) with the Career Tracker site. The application developed takes full advantage of Prove it Tests being listed in CT site where a user from CT site take a test of his choice in the prove it site, results being tracked in CT site.
• Worked on Integration of Selector http://Selector. Confidential .com (Profile Test Site) with Career Tracker where a user from Career Tracker can Access the Selector Test page and results being passed to CT site
• Worked on creation of Administrator pages in the Career Tracker site where the Admin can add a Job and specify Data requirements for a particular Job based upon the Tests taken by a Career Tracker user.
• The results being passed by ProveIT/Selector were displayed and Admin functionality was added to Search the results. The system takes care of the users Qualified for a particular job depending upon the requirements set previously by the Administrator
• Customized the result screens where the user can specify Action plan he needs to take to improve his skills for a particular test depending upon the score secured.
• The system keeps a track of timely Email responses/Alerts set by the user. Customized the Access screens for the user depending upon the position in the Organization.
• Worked on Creation/Display of Hot List screens where the Admin can add Jobs published to his favorite folders. The application allows the administrator the capacity of Adding/Modifying/Deletion of Folder Lists.
• Search capability was added for the Admin to query upon a particular Job.
• To Improve efficiency part of the application uses 3 Tier Architecture(DLL’s) created as COM Objects developed using Visual Basic 6.0
• This part of the application takes the full advantage of 3-tier architecture, web server IIS 4.0 on Windows NT 4.0 and database server SQL Server 7.0
• A standard XML document was created for Integration between Career Tracker and ProveIt

Environment: SQL Server 7.0, T-SQL, Visual Interdev 6.0, VB Script, JavaScript, HTMLVisual Basic 6.0 DLL’s (COM), Active X Data Objects 2.0, IIS 4.0, Windows NT 4.0, VSS 7.0

Confidential, CT

SQL Developer

Responsibilities:

• Involved in developing Intranet Applications for Confidential .
• This Intranet application is a 2-Tier Architecture, Web server IIS 4.0 on Windows NT 4.0 and Database server Oracle 8.0.
• Involved in creating a detailed Training Schedule Group report using ASP from a Text File which is updated daily by People Soft
• Worked on creating Web Polls for the intranet application. Extensively used Collaboration Data Objects for mailing results.
• Created an Electronic Survey Interface to keep a track of the user tastes, preferences that were mailed to the administrators.
• Developed a Microsoft Outlook application to send course Schedule Notification Mails to the Students registered on the Intranet. This application consists of a Sequential Text File where the data present is updated daily by people soft.
• Personalized Content specific to a department. To achieve this Customized the Screens as per User Preferences

Environment: Asp 2.0/3.0, Visual Interdev 6.0, Front page 98, VB Script, JavaScript, Oracle 8.0Active X Data Objects 2.0, Microsoft Outlook 2000, Visual Basic 6.0 IIS 4.0, Windows NT 4.0

Confidential, CT

SQL Server Analyst

Responsibilities:

• This application takes full advantage of 3-Tier Architecture, Web server IIS 4.0 on Windows NT 4.0 and Database server Oracle 8.0. ASP application uses the business objects developed using VB 6.0; these objects are in the form of DLL’s providing the necessary functionality.
• Worked on the enhancement of Creating a Search Page where the User (Author) can search for other users to include them as authors
• Modified the Lesson Capture pages by using Active X Data objects.
• VBScript was used at the server side and validations at the client level were handled using JavaScript (data validations)
• Used Collaboration Data Objects for the purpose of mail.

Environment: Asp 2.0, Visual Interdev 6.0, VB Script, JavaScript (for client side validations only), Oracle 8.0, Toad Tool (Oracle), Active X Data Objects 2.0, IIS 4.0

Confidential, CT

Web / SQL Server Developer

Responsibilities:

• The application takes full advantage of 2-Tier Architecture, Web server IIS 4.0 on Windows NT 4.0 and Database server SQL Server 7.0.
• Created Stored Procedures, views and user defined functions.
• Involved in creating new tables and modification of existing stored procedures and functions. Client side development was done by using tools such as Homesite4.0 and Visual Interdev 6.0 was used for developing Active server Pages. VB script was used on server side. Database used is SQL Server 7.0 and the connection was established using Active X Data Objects 2.0
• Designed and Integrated Search Page using Microsoft Site server by creating catalogs and Active x Data objects 2.0.
• Responsible for the development of HTML Layouts, client side validations and integration of POD movie files which provide the user graphical tutorial for all the sports.
• Data Collaboration Objects were used for the purpose of mass mailing and other purposes.
• Created Registration Screens, coding and handled the modifications of message boards (WWWthreads) using the database MySQL.

Environment: SQL Server 7.0, T-SQL, ASP 2.0, Visual Interdev 6.0,Visual Basic 6.0,HomeSite 4.0, VB Script, Microsoft Site Server(Search Page), T-SQL, Active X Data Objects 2.0,MySQL, Timbuktu Pro, IIS 4.0, Windows NT 4.0

Confidential, CA

ASP/VB / SQL Programmer

Responsibilities:

• This system provides a web interface to keep a track of the primary and franchisee restaurant locations throughout the country and their employee details, sales and (Taco bell/KFC/Pizza Hut) company activities. This is a web-enabled application with client as a browser and an Active Server Pages application running on the Web server. ASP application uses the business objects developed using VB 6.0, these objects are in the form of DLL’s and EXE’s provide the necessary functionality for invoice processing and calculation. It uses 3-tier architecture, which consists of a middle layer DLL (Dynamic Link Library).
• Involved as a team member in design and development of dynamic and interactive web pages, the necessary validation checks were being handled at the client level. Various reports were created using Crystal reports 7.0. ActiveX Data Objects are used for SQL Server 7.0 database connectivity. Client side development was done using Rapid Application Tool such as Visual Interdev and VB Script was used at Server side.
• This application takes the full advantage of 3-tier architecture, web server IIS 4.0 on Windows NT 4.0 and database server SQL Server 7.0.
• Various ASP components were used for developing interactive web pages. Visual Source Safe was used to manage the files in the project. Extensive use of queries, stored procedures and triggers.

Environment: SQL Server 7.0, T-SQL, Visual Basic 6.0, Visual Interdev 6.0, ASP 2.0, Active X, VB Script, HTML, Dynamic HTML (DHTML), ADO 2.0, IIS 4.0, Visual Source Safe 6.0, CSS (Cascading Style Sheets), MSIE Object Model, Crystal Reports, 7.0, Windows NT 4.0x

Confidential, MN

ASP / SQL Programmer

Responsibilities:

• Visual Interdev was used for developing Active Server Pages, VBScript for script development.
• I was also involved in handling few modules involving the design of HTML Layouts and scripting of Asp's to access the database using ADO.
• Various Interactive web pages were developed and the necessary validation checks were being handled at the client level. Also various ASP objects and components were extensively used.
• Designed various product screens and design time controls (DTC).
• This application takes the full advantage of 3-tier architecture, web server IIS 4.0 on Windows NT 4.0 and database server SQL Server 7.0.
• Created Stored Procedures, Views and User defined functions.
• The application gave access to Sales Information made by a particular sales center on the web. The information about the orders and products are updated on a daily basis, that includes daily logins, daily activation, daily sales made by each salesman etc. Queries and SQL Server procedures and triggers were used for this purpose. Special access is provided for the internal users of the system to update the products, and order information in the database over the web in the form of data entry screens.

Environment: SQL Server 7.0, T-SQL, Visual Basic 6.0, Visual Interdev 6.0, ASP 2.0, IIS 4.0, Active X, HTML, Dynamic HTML (DHTML), Windows NT 4.0

Confidential

Jr. Visual Basic Programmer / Inventory Controller

Responsibilities:

• Responsible for maintaining Inventor control files.
• Created a Visual basic Inventory application for Twyford materials imported from UK.
• Created Visual basic Active-X Objects for re-use.
• Worked on creating DLL’s to implement 3-tier architecture solution.
• Implemented T-SQL Stored procedures for efficiency.

Environment: SQL Server 7.0, T-SQL, Visual Basic 4.0, Active-X, VB DLL’s, Windows NT 4.0