SUMMARY

• 6+ years of experience in IT field including Database Design, Analysis, Reporting, and Administration of MS SQL Server 2000/2005/2008 R2 on development, testing and Production environments.
• Extensive experience as a Database Developer involving Analysis, Design and Implementation of project requirements through interacting with client and development teams for Data Modeling and Data Management.
• Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Tables, Table Normalization, User Defined Data Types, Indexes, Stored Procedures, and Triggers.
• Proficient Knowledge in planning and implementing MS SQL Server Security and database Permissions.
• Experience in taking the Database Backup/Restores, Log Shipping & Database Mirroring.
• Experience in performance tuning using performance monitor and SQL profiler in MS SQL Server 2000/2005/2008.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user profiles, relational database models and data integrity, SQL joins and query writing.
• Supported internal/external teams in resolving T-SQL related tuning issues and Proficiency in writing complex T-SQL Queries.
• Experience in migrating SQL server 2000 databases to SQL server 2005 databases and SQL Server 2005 to SQL Server 2008.
• Expert in extracting and transforming data (ETL) using DTS/SSIS.
• Worked on analyzing and performance tuning queries by looking at Query Statistics and execution plans
• Extensive working knowledge in converting/migrating (ETL) DTS packages into SSIS.
• Experience in Creating and Maintaining the Analysis Services Databases and Cubes using SSAS.
• In-depth knowledge of Transact-SQL DDL and DML.
• Created the interdependent jobs using SQL Server Agent to call the SSIS Packages, Batch files, Stored Procedures.
• Ability to document environments via the use of MS Visio, MS Excel and MS Word.
• Ability to generate quick Ad-hoc reports using MS-EXCEL with number of Pivots and Charts to help the business in decision making.
• Ability to adapt to fast changing environment at work.
• Excellent communication, interpersonal, problem solving and analytical skills.

TECHNICAL SKILLS

DBMS/RDMBS: MS SQL Server 2008/2005/2000/7.0 , Oracle8i/9i, MS Access.

Data Modeling: Erwin, MS Visio, MS Power Point

ETL Tools: DTS, SSIS

Development languages: T-SQL, PL/SQL

Web development: Database tools

HTML, XML.: SQL Query Analyzer, SSMS (SQL Server Management Studio), SQL Server Agent, SQL Profiler, SQL Server BI Studio, Replication, Visual Source Safe

OLAP: SSAS (SQL Server Analysis Services).

Programming languages: Reporting toolsC, C++, VB 6.0, ASP. SSRS (SQL Server Reporting Services), Crystal Reports, MS Excel- 2000/2003/2007/2010.

FTP Tools: SSH F-secure, Regular FTP

Operating systems: Windows 98/NT/Server 2000/Server 2003, Windows XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Irving, Texas

SQL Server Architect

Responsibilities:

• Participated in the Client meetings from starting to gather all the requirements from various business perspectives.
• Actively participated in database modeling and gathering System Specification as required.
• Doing in depth analysis considering various use case scenarios by generating the Ad-hoc reports for decision support.
• Designed process flow and data flow diagrams by using Visio.
• Developed, Tested and Maintained the T-SQL Code in terms of Stored Procedures, Triggers, and User defined Data types.
• Created table partitions to handle huge data as part of performance tuning.
• Loaded the Collateral source system to EDW using SSIS, T-SQL,
• Building and dropping indexes to speed up the ETL Loads and Data retrievals.
• Created and maintained Analysis Database and Cube using MOLAP.
• Created (ETL) SSIS Package(s) to make the process to run on daily basis including the processing the Cube.
• Extensively used Star Schema for the whole process.
• Involved in data replication, data migration and data integration etc.
• Created Indexed Views for fast retrieval of Data.
• Automating the whole process including the Database backups.
• Participated in creating/enhancing the Scorecards that gets refreshed from Cube Pivots.
• Supported production environment.
• Sending the Various Metric Scorecards to various Sales Channel and Marketing Clients.
• Participated in setting up Database mirroring between SQL Server 2005/2008 servers.

Environment: SQL Server 2008/2005, SQL Server 2008/2005 Integration Services (SSIS), SSMS, MS Excel 2003, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MDX, SQL Server BI Studio 2003/2008, VB Script, IIS, Visio 2003, Erwin, F-Secure SFTP, Microsoft Outlook 2007, IBM Sametime IM, Windows 2003 Server/XP, Visual Source Safe.

Confidential, Dallas, Texas

SQL Server Developer

Responsibilities:

• Collecting all the requirements from various business documents and creating the initial design by interacting to clients and supervisors.
• Did analysis considering various use case scenarios by generating the Ad-hoc reports for decision support.
• Query optimization and performance tuning and running DBCC commands for consistency check.
• Tuning the T-SQL Statements by using the Execution plan and SQL Profiler.
• Used Star Schema as part of Normalization.
• Designed process flow and data flow diagrams by using Visio.
• Creating triggers, writing stored procedures, User defined Data types and optimizing them.
• Creating and dropping indexes to speed up the ETL Loads and Data retrievals.
• Created and maintained Analysis Database (SSAS) and Cube using MOLAP.
• Partitioned the Analysis Database on weekly basis to improve the cube performance and scalability.
• Created the Indexed Views to boost the performance of the query
• Created (ETL) SSIS Packages to make the process to run on daily basis including the processing the Cube.
• Loading data from SQL Server to EDW using SSIS, T-SQL, BTEQ, and TeraData Utilities.
• Supported production environment.
• Participated in creating/enhancing the Scorecards that gets refreshed from Cube Pivots.
• Sending the Metric Scorecards to distro.

Environment: SQL Server 2005 Database Engine, SQL Server 2005 Integration Services (SSIS), SQL Server Analysis Services (SSAS), MDX, SSMS, MS Excel 2003, SQL Server BI Studio 2003,VB Script, IIS, Visio 2003, F-Secure SFTP, Microsoft Outlook 2003, Lotus Notes, IBM Sametime IM, Windows 2003 Server/XP, Visual Source Safe.

Confidential, Plano, Texas

SQL Server Developer

Responsibilities:

• Designed and applied schema change scripts to existing objects to synchronize with changing business rules.
• Build table relationships and wrote stored procedure to clean the existing data Coordinated with the front-end developer to put in the business rules. Wrote stored Procedure to check some of the rules at the backend at the time of entering data
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
• Developed the project using iterative approach
• Managed database changes based on feedback
• Migrating and converting (ETL) DTS packages from SQL Server 2000 to SSIS in SQL Server 2005.
• Created new SSIS packages according to the business rules.
• Created Stored Procedures, triggers, views and added/modified tables for data load, transformation, extraction and manipulation.
• Participated in creating reports using SSRS.
• Took part in data normalization process along with senior data base analyst.
• Filtered bad data using complex T-SQL statements, Cursors and UDFs and implemented various constraint and triggers for data consistency.
• Configured SQL mail agent for sending automatic emails to employees for Invoices Using SSIS packages.

Environment: SQL Server 2005/2000, SQL Server 2005 Integration Services (SSIS), SQL Server 2005 Reporting Services (SSRS), SQL Server 2000 DTS, MS Access 2003, MS Excel 2003, VB Script, IIS, Visio 2003, Zone Labs Integrity Flex, Microsoft Outlook 2003, Windows 2003 Server/XP, Visual Source Safe.

Confidential

SQL Server Developer/System Analyst

Responsibilities:

• Participated in database modeling
• Normalized the database.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
• Created reports from database onto excel spread sheet using DTS.
• Wrote complex stored procedures to process employees’ requirement
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Checks, Update Database Statistics and Re-indexing.

Environment: MS SQL Server 2000, Visual Basic 6, MS office, MS Outlook.