SUMMARY

• 7 years of total IT experience which includes analyzing, designing and translating the business requirements into the SQL Server 2008, SQL Server 2005 and SQL Server 2000database management system as a SQL Server developer in warehouse, development and production environments.
• In - depth knowledge of T-SQL (DDL, DML), Integration Service (SSIS), Reporting Service (SSRS).
• Experience in Database administration activities like Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization.
• Experience in implementing different types of Replication models like Transactional, Snapshot.
• Expertise in connecting to remote Oracle Servers and SQL Servers as Remote Servers and Linked Servers.
• Proficient in usingSQLProfiler, Performance Monitorfor monitoring and tuning MSSQL Serverperformance.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Designed schemas using Kimball and Inmon methodologies.
• Experienced in Migration from SQL Server 2005 to SQL Server 2008 using SQL Server Upgrade Advisor.
• Experience in creating store procedures, cursors, triggers, functions, constraintsat various stages of migration, reports and data validation.
• Excellent knowledge in using transformations for cleansing of datalike derived columns, lookups, data conversions, Slowly Changing Dimensions (SCD) and conditional splits.
• Experience in creating Master Child Packages and worked with XML and SQL Table configurations for modifying the SSIS packages from a test/development environment to the production servers for day to day operation.
• Experience in Error and Event Handling Precedence Constraints, Break Points, Check Points, Logging.
• Expert in extracting and transforming data between homogeneous and heterogeneous systems using dynamic DTS Packages, Integration Service (SSIS), Data Integrator (DI) technologies.
• Good understanding ofdata migration (using tools like DTS, BCP, XML and Replication) between different homogeneous/heterogeneous systems and SQL Server.
• Configured Workflows with email task, which would send mail with session, log Failure of a session and for theTarget Failed Rows.
• Generation of the weekly Drilled down Reports using SSRS for internal consumption deployed on IIS server
• Experience in SQL Server Reporting Services (SSRS) designing various kinds of ad-hoc, drilled-down reports, Standard reports, parameterized, Drilldown reports, Drill through reports using SSRS.
• Excellent communication and interpersonal skills, self-motivated, quick learnerand determination to learn new technologies, strong troubleshooting skilland good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Database technologies: SQL SERVER 2000/ 2005/ 2008, MS Access,MS SQL Server 7.0

BI Tools: Database Engine, SSIS, SSRS(Visual Studio 2008, 2005)

Programming Languages: T-SQL, PL/SQL, C++, C#, J2EE, .NET

Reporting Tools: BIDS, Report Builder 2.0,Cognos

Environment: Windows 98/2000/2005/ XP/Vista/7,Unix (Sun Solaris2.6), Excel, Power point.

Office/Business Tools: Microsoft office, Adobe, Photoshop.

Web technologies: HTML, DHTML, XML, andVB Script

Data Modeling: DB Designer, Erwin 4.1, Front Page

Other Tools: DTA, SQL Profiler, DTS XCHANGE, Citrix, Diagnostic Manager, SQL Litespeed

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

SQL DBA Developer

Responsibilities:

• Expertisein installing, configuring, monitoring and troubleshootingSQLServer 2005/2008.
• Good experience in migration of SQL Server and .
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Reviewed third party tools like Tidal5.xto help automate routine tasks such as scheduling of jobs.
• Using MS SQL Profiler to estimate slow running queries and performance tuning purpose.
• Involved in creation and scheduling of back up strategies for execution.
• Configured Log shipping to create a Disaster Recovery Stand by servers.
• Responsible in creation of logins and assigning permissions to users.
• Monitored memory, processor, Disk I/O and user connections for fine-tuning.
• Extracted data from Sun Solaris 2.6 and then loading data in Dimension Tables in SQL Server database using SSIS Packages.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Configured Workflows with email task, which would send mail with session, log Failure of a Session and for Target Failed Rows.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Created different type of reports including Cross-tab, Conditional, Drill-down and Sub reports using SSRS.
• Involved in WritingTSQL Queries and Views on SQLServer 2008.

Environment: -SQL Server 2008, SQL Server 2005,SQL Server 2000,SSIS, SSRS, T-SQL, Unix (Sun Solaris 2.6), Windows 2008.

Confidential, Northridge, CA

SQL Database Developer

Responsibilities:

• Designed dynamic DTS Packages for Landing-Pad to transfer data between servers, load data into database, and archived data file from different DBMS.
• DTSto SQL Server 2005Integration Services (SSIS) Migration using the Upgrade Advisor.
• Created basic SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• CreatedSSIS Packages to migrate users, logins, stored procedures, and tables.
• Implemented Source Control and Version Control using SSIS 2005.
• Imported and exported data using BCP and Bulk Insert.
• Created SSIS packages in SQL Server 2008 to successfully migrate data from SQL server 2005.
• Created reports based on the requirements using SSRS 2005.
• Used SSRS to create ad-hoc, parameterized, drill-down and drill-through reports.
• Debugging, Troubleshooting very large stored procedures and assisted Data Cleansing over the ODBC.
• Created and developed the stored procedures to handle complex business rules, history data and audit analysis.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check, and index defragmentation.
• Created SQL Server Profiler traces and used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors.
• Developed, modified, and optimized complex queries to data retrieval and modification.
• Created DML/DDL triggers as per company policy.
• Created logical and physical database design, data structures, and implemented large databases using Erwin 4.1
• Monitored and Tuned queries and stored procedures for optimum performance.
• Worked with development teams in the design of physical databases and in modification including Denormalization of physical databases and partial reconstruction of Stored Procedures.
• Provided technical support to internal developers and external clients.

Environment: -Microsoft Windows Server 2003 Enterprise Edition, Microsoft Windows 2000 Server, SQL Server 2000/2005/2008, DTS, SSRS, SSIS, Erwin 4.1.

Confidential, Costa Mesa, CA

SQL/BI Developer

Responsibilities:

• Installation of the Microsoft SQL Server 2000 and 2005 on New Production and Test servers with latest Security updates involving Service Packs and Security patches.
• Performed data migration from SQL Server 2000 to SQL Server 2005.
• Created and deployed SSIS Packages to import and export data from various flatfiles.
• Involved in Performance tuning with the help of SQL Server Profiler, Database Engine Tuning advisor & windows performance monitor.
• Created, altered, maintained system roles and permissions to users on various database objects.
• Configured Transactional replication between Primary Server and Dedicated servers, with separate Distributor server and experience in troubleshooting replication issues.
• Prepared and documented Backup & Restore Plans.
• Implemented backup process using SQL LiteSpeed a Backup solution for MS SQL Server.
• Implemented and successfully tested Log Shipping in SQL Server 2000 and SQL Server 2005.
• Backing up master & system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Performing administration tasks on the live databases like re-indexing, shrinking databases, rebuilding full text catalogs.
• Designed the Data warehouse data models using Erwin 4.1.
• Resolved locking (Dead Locks) andblockingissues.
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM.
• Partitioning tables to achieve better performance for access and writes.
• Create new databases, tables, and fields for data entry, performing database capacity planning.

Environment: -SQL server 2000/2005 Enterprise edition, Windows 2003 Standard Edition,Windows2000 Advanced Server, SQL LiteSpeed, Erwin 4.1

Confidential, KY

SQL DBA Developer

Responsibilities:

• Extensively involved in gathering business requirements as endeavor that will facilitate the planning and the implementation phase of a data warehouse.
• Designed logical and physical database structure to facilitate and hold operational and customer data.
• Configured snapshot Replication.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Created roles and set permissions to ensure that company’s security policies are enforced and in effect.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Designed both the pre staging and the staging database ensuring the quality and consistency of the data in both repositories.
• Involved in creating SSIS packages for complete ETL Strategy to populate data marts, cleaning data and loading data from various sources.
• Created SSIS packages for the data transformation that included Merge Joins, Sort, Lookup, Derived Column and Data Conversion.
• Built SSRS project to generate reports with desired rendering formats like PDF, Excel and CSV to present statistics information according to business requirements.
• Created models with the help ofReport Builder3.0to provide a template for end-users for creating reports by themselves with preselected group of relational tables.
• Involved in creating Sub-Reports, Drilldown-Reports, Summary reports, drill through reports, linked and sub reports, ad-hoc Reports and Matrix reports in SSRS.

Environment: Erwin 4.1, SQL Server 2005,SQL Server 2000, SQL Server Agent, SSIS, SSRS, Report Builder 3, Microsoft Excel

Confidential, Richardson, TX

SQL Developer/BI Developer

Responsibilities:

• Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables& calculations from different databases.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Assisted in creation ofOLAP cubes for the data mart.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS using upgrade advisor.
• Created ETL processes using Microsoft DTS and SSIS.
• Create SSRS for Design and implement reporting and business intelligence platforms across multiple applications.
• Created DTS packages for cleansing and transformation. .
• Handled Errors and Transaction Processing in the Procedures.
• Testing the Performance of the database.
• Developed template Excel 2005reports to allow the manager to analyze the data directly accessing SQL Server.
• Creating new databasetables to put in the extracted data and rebuilding the relationship.
• Created parameterized reports and matrix reports using Report builder 3 for the roles of the customers.
• Managed the security of the servers (Logins and users).
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Applied constraints and writing triggers to apply the business rules.

Environment: SQLServer 2005, SQL Server 2000,SSIS, SSAS, T-SQL, SSRS, MS Excel 2005, MS Report builder 3.

Confidential 

SQL Server Developer

Responsibilities:

• Install SQL Server on Windows 2000 Server.
• Define relationship between tables and enforced the referential integrity constraints.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Optimized query performance by removing unnecessary columns, eliminating redundant and inconsistent data and normalizing tables.
• Defined various facts and Dimensions in the data and created several confirmed dimension ensuring the data in these dimension meets the requirements of the sharing departments.
• Wrote user requirement documents based on functional specification.
• Developed source to target specifications for Data Transformation Services.
• Developed functions, views and triggers for automation.
• Tune the SQL queries using SQL profiler, tune the database.
• Created DTS package to schedule the jobs for batch processing.
• Created indexes, Constraints and rules on database objects for optimization.

Environment: SQL Server 2000, MS Access, SQL Query Analyzer, SQL Developer, Windows server 2000.