SUMMARY

• Over 8 years of IT Professional experience in Development, Client Analysis, Database Design and Presentation using SQL Server 7.0/ 2000/2005/2008.
• Experienced in Administration and Installation of Windows 2000 Advanced Server, Windows 2003 Enterprise Server and Windows 2008 Enterprise Server.
• Excellent knowledge of Normalization/De - Normalization, Data Design methodology and build Referential Integrity across multiple tables.
• Experienced in T-SQL (DDL, DML) documentation, coding, programming and implementation of Business Intelligence solutions using SQL Server 2000/2005/2008.
• Expertise in creating Complex Stored Procedures, Queries for the application team and for the end users based on the business requirement.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS).
• Involved in Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Expert in web designing using HTML, CSS, XML and JavaScript to display reports on the server.
• Experienced in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views and DTS.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using SQL Server tools like SSIS, DTS, Bulk Insert, BCP and XML.
• Expert in developing skills in stored procedures, Ad-Hoc SQL Queries, triggers, UDF, custom DTS packages using Visual Basic.
• Involved in Reviewed, analyzed, and modified programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.
• Experienced in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).
• Extensively used ADO.NET objects such as Typed Datasets, Data Tables and Data Views for consistent access to SQL Server 2005 data source.
• Monitored strategies, processes and procedures to ensure the Data Integrity and maintained the required level of security for production and test environments.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

• Microsoft SQL Server 7.0/ 2000/2005/2008
• Windows 95/98/NT/XP/ 2000/2003/2008 Advanced Server
• Windows Exchange Server 2003/2007
• Unix
• Linux
• Red Gate
• Oracle 8i/9i/10g/11g
• MySQL
• C
• C++
• C#
• Java
• J2EE
• MS-Access
• SQL
• T-SQL
• HTML
• DHTML
• ASP
• ASP.NET
• VB
• VB.NET
• XML
• MS Visual Studio 2005/2008
• Crystal Reports
• SSRS
• SSIS
• SSAS
• DTS
• SQL Profiler
• DTA
• Management Studio
• ERWIN
• MS Visio 2003/2005/2008
• ClearCase
• Control-M

PROFESSIONAL EXPERIENCE

Confidential, Latham, NY

MS SQL Server/SSIS/DBA

Environment: Microsoft SQL Server 6.5/ 2000/2005/2008 Enterprise Edition, MS Windows Server 2003, Oracle 10g, Visual Studio 2005/2008, C#, ASP.NET, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services 2005, Vault, ignite, crystal Reports.

Responsibilities:

• Created complex stored procedures and user defined functions to manipulate data.
• Extracted data from SQL Server 2000/2005/2008 source and transform and send to Excel, Text file destinations.
• Worked in Enrollment Client files processing.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created ETL packages to Validate, Extract, Transform and Load data to different locations.
• Implemented 277/277CA/835/837 files Processing.
• Deployed and Scheduled SIS packages into Various Systems(Dev/Testing/Production)
• Based on the request worked on Data corrections for Members/Subscribers /Dependent records
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Tuning Advisor, SQL Enterprise Manager .

Confidential, Irving, TX

MS SQL Server/SSIS/SSAS Developer

Environment: Microsoft SQL Server 2005/2008, MS Windows Server 2003/2008, SSAS, SSIS, SSRS, Unix, Oracle 10g/11g, Visual Studio 2008, C#, ASP.NET, T-SQL, JAVA, XML, IIS 6.0/7.0, ERWIN,TFS.

Responsibilities:

• Installed upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008.
• Develop and implement standards for data object naming and database design.
• Designed ER diagrams and mapped the data into database objects.
• Involved in the analyzing and solved problems doing the Client Application system's installing, upgrading and running stages.
• Designed and created different ETL packages using SSIS from Oracle source to SQL Server as destination.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Wrote SQL scripts to Insert, Update and Delete data in MS SQL database.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager, Task Manager, Index Tuning Advisor.
• Created database, tables and procedures to update and clean the old data.
• Checkout the scripts from TFS and Modify code and Check in scripts in TFS.
• Created SSIS Packages to import and export data from Excel, XML and Text files.
• Configured SQL mail Agent for sending Automatic emails on Errors.
• Involved in writing different testing scripts for the testing of the Codes in ASP.Net.
• Created star schema in SSAS and developed SSRS reports based on the cubes.
• Involved in Foreign key constraints and Referential Integrity checks to maintain the optimal performance.

Confidential, Dayton, OH

MS SQL Server /SSIS/SSRS Developer

Environment: Microsoft SQL Server 2000/2005 Enterprise Edition, MS Windows Server 2000/2003, Oracle 10g, Visual Studio 2005, C#, ASP.NET, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services 2005, Visual Source Safe.

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2000 to SQL Server 2005 with appropriate hot fixes and service packs.
• Reviewed system requirements and the upgrade matrix for SQL Server 2005.
• Migration of DTS to SQL Server Integration Service (SSIS).
• Wrote Stored Procedures for report generation in migration process and replication.
• Wrote several scripts such as finding long running queries, blocking sessions, archiving data from production server to archive server and populating reporting.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Created Stored Procedures to perform calculation and update of data in the database.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Maintained SQL Scripts for creation of Database Objects.
• Involved in various stages like Development, System Analysis & Design and Creating Stored Procedures.
• Designed and developed Interfaces which were used for connecting to SQL Server databases.
• Used HTML code to make Report manager more functional and customizable.
• Used Data Grids and CSS Style Sheets to display the data in a customized way.
• Configured SQL Database Mirroring, Log Shipping on the development server.
• Maintained reliability and availability of existing MS SQL environments.
• Suggested Cost saving Techniques. Designing/ Implementing Backup policies for databases.
• Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Involved in project management and coordinated with offshore development team.

Confidential, Omaha, NE

MS SQL Server/SSIS Developer

Environment: MS SQL Server 2000/2005 Enterprise Edition, Windows 2003 Enterprise Edition, Windows 2000 Advanced Server, SSIS, SSRS, SSAS, Oracle 9i, Red Gate, DB2, MS Performance Point Server, Visio 2005, T-SQL, Advanced Windows 2000 Server, Crystal Reports 10.0, IIS, XML, PVCS version manager, TOAD, SOAP and Microsoft Access.

Responsibilities:

• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Actively involved in designing the logical and physical architecture for Liberty group database.
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Experience in Designing, Building the Dimensions, cubes with Star schema and Snowflake using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Created and modified data driven subscriptions, fine-tuning subscription execution.
• Created automated stored procedures for day end operations using SQL Server agent.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (DB2 and Text files and Excel files) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2005.

Confidential, Newport, NJ

MS SQL Server Developer

Environment: MS SQL Server 2000, T-SQL, DTS, Windows 2003/2000

Responsibilities:

• Involved in Designing logical and physical databases using Erwin tool.
• Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Join statements for several applications.
• Implemented Constraints, Rules, Defaults, User defined data types and Indexes on tables.
• Developed complex T-SQL code for data retrieval to generate reports using crystal reporting tool.
• Transferred the data to data mart from different servers using DTS packages.
• Resolved deadlocks issues with the Databases/Servers on a real-time basis.
• Developed and executed test plans, test cases with the help of Quality Center and filed the bugs with its snap shots.
• Performed Black Box testing, Functional testing, Integration testing, Automation testing and Performance testing for the applications.
• Used database maintenance plans for backing up the database and transaction log files.
• Involved in Implementation and maintenance of disaster recovery solutions such asReplicationand Log Shipping.
• Used XML Web Services to get the customer information from backend database.
• List Controls like Repeater controls; Data List Controls and Data Grid Controls were used in displaying rows of data in a customized template format.

Confidential

MS SQL Server Developer

Environment: MS SQL Server 2000/2005, Windows 2000/2003 Advance Server, Erwin 3.5.2 with Crystal Reports 10.0, SSIS, SSRS, DTS, SQL Management Studio, SQL Server Business Intelligence Tools, Query Analyzer, SQL Profiler.

Responsibilities:

• Created stored procedures, scripts, views in Oracle database design and create SQL Database, tables, indexes and views, Functions, Stored Procedures and Triggers, joins
• Used DTS for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.
• Fine tune complex SQL queries and Stored Procedures to increase performance.
• Worked on Exception Handling with @@error and Try/Catch blocks.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in Database Capacity Plan.
• Extensively used XML documents to pass multiple parameters for Stored Procedures to read and write database tables.
• Looked at the reports and fixing bugs in stored procedures, tables and ETL process.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Linked Servers and Indexes.
• Extensively used Enterprise Manager, Query Analyzer and SQL Server Profiler.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals and alerting.