SUMMARY

• EIGHT plus years of IT experience with more than Seven years in Database Administration, Development and Maintenance of SQL Server 2008, SQL Server 2005, SQL Server 2000 and SQL Server 7.0 with various business domains like Pharmaceutical, Financials, Insurance, Manufacturing and Hospitality.
• Expert in Extracting, Transforming and Loading (ETL) using SQL Server 2005 Integration Services (SSIS) and DTS.
• Expert in creating SSIS Package using File System Task, Script Task, Data Flow Task, XML Task using OLE DB, SQL Server, Excel & Flat file connection manager.
• Implemented various SSIS Data Transformations like Derived Column, Conditional Split, Lookup, Data Conversion, Merge Join transformation.
• Debugged SSIS Packages using Breakpoints, Data Viewer & watch window.
• Implemented Transactions using Checkpoints. Created XML based & SQL Server based SSIS Package Configurations & deployed packages using DTExecUI, Dtutil.
• Experience in migration of Data from Excel, Flat file to MS SQL Server by using SSIS, DTS and BCP utilities.
• Experience with SQL Server Analysis Services ( SSAS - 2008 & SSAS - 2005 ) for Creating data sources and data source views (DSV’s), named calculations and named queries, Cubes, Dimensions, Measures, Measure groups & Aggregations, Deploying and processing SSAS objects.
• Exposure to Cube properties like DefaultMeasure, StorageMode and ErrorConfigurations and Dimension properties like OrderBy and AllMemberName.
• Expert in developing / modifying / performance tuning reports with SQL Server Reporting Services (SSRS - 2008 & SSRS - 2005) like Sub-Report, Parameterized Report, Matrix & Tablix Report.
• Expert in Advanced SQL Server 2005 features like XML Datatype, MAX specifier, TOP & OUTPUT, TABLESAMPLE Clause, TRY-CATCH & Common Table Expression CTE, Ranking functions like ROW NUMBER, RANK.
• Expert in transforming complex business logic into database design by creating database objects such as Tables, Stored Procedures, User Defined Functions, Views, User Defined Data Types, Indexes, Cursors, DDL/DML Triggers.
• Experience in Performance Tuning Stored Procedure, Query Optimization using proper Inner/Outer Joins, Index Optimization by analyzing query plans and usage of DBCC Utilities.
• Hands-on programming knowledge in WebForms, Web Service using ADO.NET, C#.NET, VB.NET, ASP.NET with Visual Studio 2003 & Visual Studio 2005.
• Familiar with New features of ASP.NET 3.5 like Implicitly Typed Variable, Collection Initializer, Object Initializer, Anonymous Type and Automatic Properties, LINQ.
• Extensive experience with Version Control Tools like Visual Studio Team System 2005 VSTS, Visual Source Safe, Team Foundation Build Server
• Familiarity with Visual Studio Unit Tests and NUnit Framework, XML Based Stored Procedure, querying XML data using XQuery & SQLXML.
• Good knowledge of tools like DTA (Database Tuning Advisor), Index tuning Wizard, Performance monitor, SQL Profiler and SHOWPLAN Feature of Query Analyzer.
• Written T-SQL scripts to monitor database growth, Backup/Restore, Data Import/Export.
• Good Experience in writing SQL, PL-SQL scripts and using Oracle Forms and Reports with Oracle 10g, 9i, 8i.
• Good team player having strong analytical, excellent interpersonal and communication skills.

TECHNICAL SKILLS

Languages: C, C++, T-SQL, PL/SQL, XML, HTML, VB script

RDBMS: SQL Server / 2000 / 7.0, Oracle 8i/9i/10g, MS-Access

Front End: VB 6.0, VB.NET 3.5/2.0, C#.NET 3.5/2.0, JAVA, Oracle Developer 2000

Version Control: Visual Studio Team System, Visual Source Safe, Serena ChangeMan Dimensions.

Operating Systems: Windows Server 2003, Windows 2000 Advanced Server, Windows NT 4.0 / 3.51, Windows 95/98

Other Tools: Compaq Insight Manager, Idera Diagnostic Manager, NetIQ, Quest Spotlight, Lumigent Log Explorer, Veritas NetBackup, SQL Light speed, ERWIN 4.0, Toad, Crystal Reports, SQL*Plus, Dundas Charts for SSRS v2.2, Beyond Compare2, SQL Server 2005 Reporting Services, PerformancePoint Server 2007 (PPS), SharePoint Server 2007, MS Visio, Erwin Data Modeler.

Hardware: Compaq ProLiant 8000, 6500, 6000, 5000 Servers, IBM PC AT, HP ProLiant BL25P, IBM x225, Dell PowerEdge 8450

PROFESSIONAL EXPERIENCE

Confidential, San Leandro, CA

BI / SQL Server Developer

Responsibility:

• Implemented Business Intelligence using SSIS 2008 Package to Import/Export data from Flat Files to SQL Server using Data Flow Task, File System Task and Execute SQL Task, with ForEach Loop Container.
• Used Constraints, Variables & Expressions to dynamically change path of SSIS Package. Debugged package using Breakpoints and Data Viewers.
• Deployed SSIS Package from DEV to UAT/PROD SQL Server using XML based SSIS Package configurations.
• Used SSIS Transformations like Derived Column Transformation to create new column, Conditional Split Transformation to split data flow.
• Involved in Database Design, Table & Relationship creation. Updated Stored Procedure, Functions & Views. Used Dynamic SQL & SP EXECUTESQL.
• Involved in performance tuning of Stored Procedures & T-SQL Queries using Indexes & Query execution plan.
• Enhanced Web Application using Session, View State, Postback, Try-Catch exception handling, performed String validation, Type Casting, utilized StringBuilder class and TreeView control.
• Connected ASP.NET Web Pages to SQL Server using C#/ADO.NET with help of DataSet, DataView and DataTable.
• Using SQL Server Analysis services 2008 created & enhanced Cubes, Dimensions, Measures based on the business requirement.
• Utilized Cube wizard to create Cube, Created Cube Perspectives & Enhanced Cube using properties e.g. DefaultMeasure, StorageMode and ErrorConfigurations.
• Using Dimension Creation wizard created Standard Dimensions with attributes, relationships, Levels and hierarchies and tested using Dimensions browsers.
• Enhanced Dimension's Attribute e.g. sorting using OrderBy property, making visible/enable using AttributeHierarchyEnabled and AttributeHierarchyVisible.
• Utilized Measure properties like AggregateFunction, Visible and FormatString.
• Participated in Build and Deployment of SSAS Cubes as well as processed them.
• Created/ Modified SSRS based reports based on T-SQL, MDX and Stored Procedure with Input parameters.

Environment: Visual Studio Professional 2008, SQL Server 2008 SP1, SQL Server 2005 SP3, .NET Framework 2.0, Windows Server 2003. TFS Source Control.

Confidential, Parsippany, NJ

SSIS / SQL Server Developer

Responsibility:

• Created/Updated SSIS Package to Import/Export data from Flat Files, Excel, SQL Server using Data Flow Task, Send Mail Task, File System Task, Execute SQL Task, ForEach Loop and Sequence Container as well as Recordset Destination.
• Implemented Script Task using C#/VB.NET language for downloading files from FTP Server, for connecting to OLE-DB Database, for sending Email using SMTP Server, for creating /modifying TEXT Files using File System Object.
• Used SSIS Expressions to create TEXT File-Name with Date stamp (mmddyyyy), changing connection string dynamically, used CAST Operators to cast String/DateTime data types, TRIM Spaces, Concatenate Strings.
• Involved in Extraction, Transformation and Loading (ETL) of data using SQL Server Integration Services 2008.
• Involved in Database Design and Normalization of Tables. Created Stored Procedures, Functions and Views. Used BULK INSERT Statement, Dynamic SQL, SP EXECUTESQL & DBCC Utilities.
• Used Constraints and Expressions with Variables to dynamically change Flow of package execution. Also created XML based SSIS Package configurations.
• Converted Unicode to Non-Unicode data using Data Conversion Transformation, filtered records using Conditional Split Transformation, Created new column using Derived Column Transformation.
• Used Breakpoints, Data Viewers, Locals and Watch Window for debugging Package.
• Implemented Transactions, Checkpoints for restarting failed package.
• Involved in performance tuning of Stored Procedures & T-SQL Queries using Indexes & Query execution plan.
• Created/ Modified SSRS based reports like Sub-Report, Report based on T-SQL and Stored Procedure with Input parameters.
• Using Analysis services 2008 made various cubes based on the business requirement.
• Created a number of Cubes, Dimensions, Measures and Aggregates using SQL Server Analysis Services 2008.
• Created Standard Dimensions with attributes, relationships & hierarchies and tested them using Dimensions browsers.
• Involved in Build, Deployment & processing of SSAS Cubes.

Environment: Visual Studio 2008, SQL Server 2008 SP1, SQL Server 2005 SP3, SQL Server 2000, Visual Studio Team System 2008, .NET Framework 3.5, Windows Server 2003.

Confidential, Simi Valley, CA

SSIS / SQL Server Developer

Responsibility:

• Created SSIS Packages using Execute SQL Task, File System Task, Send Mail Task, Foreach Loop container and Sequence container.
• Created SSIS Package with various Variables, Expressions and Transformations like Conditional Split, Derived Column, Data Conversion, Lookup, Merge Join, Sort and Aggregate.
• Debugged SSIS Packages using Breakpoints, Data Viewers & watch windows.
• Created XML based SSIS Package Configurations & deployed packages using DTExec & Dtutil.
• Implemented logging using Text File Log provider & SQL Server Table Log provider.
• In SSIS package, created Event handlers for handling runtime events and Implemented Transactions using Checkpoints.
• Involved in data migration from Excel, CSV files into SQL Server using SSIS Packages.
• Created/Modified Sub-report, Parameterized report and reports based on Script as well as Stored Procedure and deployed them onto Reports Server.
• Involved in performance tuning of report by analyzing underlying Stored Procedure and error solving by analyzing Execution-Log of Reports.
• Enhanced report by adding Report Header/Footer with Execution Date/Time, No of Pages, No of Records retrieved using Business Intelligence Development Studio.
• Created Report Sub-Scription for scheduled execution of report and subsequent export of data. Also written Report Expressions using VB.
• Involved in the performance tunning of queries with modifications in T-SQL queries, eliminated inconsistent data using Data-Clean script, normalized tables, established Inner/Outer Joins and created indexes whenever necessary.
• With Analysis Services 2008 created various Cubes, Dimensions, Measures and Aggregates based on the business requirement.
• Also involved in creation, build, deployment & processing of SSAS Cubes.
• Created Data Source View (DSV) based on star schema & snowflake schema in BIDS.
• Created Standard & Time Dimensions with Attributes. Also implemented Attribute Relationships with their Hierarchies and tested them using Dimensions Browser.
• Created Dimensions using Dimension wizard as well as Cube wizard.
• Exposure to the Source Control Tool like Serena Change Management Dimension’s and SQL Server 2000 DTS Designer, Dundas Charts for SSRS, Beyond Compare2 for Code comparison.
• Updated/Modified Web Services Projects based on C#.NET as part of enhancement activity. Also updated various WebForms created using ASP.NET & C#.NET.

Environment: Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2005 SP1, SQL Server 2000, Serena ChangeMan Dimensions, Dundas Charts for SSRS v2.2, Beyond Compare2, .NET Framework 2.0, PerformancePoint Server 2007 (PPS), SharePoint Server 2007.

Confidential, Redmond, WA

SQL Server Developer

Responsibility:

• Created SSIS Package using Execute SQL Task, Execute Process Task, FTP Task, Forloop container.
• Implemented various Data Flow Transformations like Character Map, Multicast and Pivot transformation.
• Created SQL Server based SSIS Package configurations & deployed Packages using Package Deployment Utility, DTExecUI.
• Involved in Extraction, Transformation and Loading (ETL) of data using SSIS & DTS.
• Enabled SSIS Package logging with Text File Log provider.
• Created Parent-Child, Parameterized SSRS Reports based on T-SQL script & Stored Procedures. Also changed Report-Level properties like Execution-Timeout.
• Written Report Expressions using VB and SQL Server functions as well as created Data-Clean up scripts.
• Creating & Managing DB objects like Table, Stored Procedures, Views, Triggers and User Defined Functions.
• Writing query using Diff type of Joins like INNER, OUTER, CROSS. Writing INLINE Query & AdHoc Query using DISTINCT & UNION clause with very good understanding of Transaction Isolation Level, Locking Modes, Transaction Management and Indexed Views.
• Implementation of various integrity constraints e.g. Primary Key, Foreign Key, Unique Key.
• Creating XML Based Stored Procedure using XQuery.
• Very well familiarity with SharePoint Server 2007, Visual Studio Team System 2005 VSTS, Creating Workspace, Tasks, Work Items, Check - IN & Check - Out of Files.
• Writing & executing Unit Tests in C#.NET, Using XML files for ANSI/UNICODE text conversion.
• Analyzing BRD, F-Spec & Tech-Spec as well as providing ROM/ETA for the Task as an active team member of the Sprint of SCRUM Methodology.
• Installation of Security Patches & preparing environment as per requirement like DUT, DIT and SIT.
• Expert in troubleshooting by trapping events using SQL Server 2005 Profiler.
• Exposure to Configuring IIS 5.0 / 6.0, Creating Virtual Directory, Modifying Web.Config & App.Config files.
• Familiarity with configuration of X509 Security certificate with Confidential Management Console MMC, Terminal services, Remote Desktop Connectivity.

Environment: .NET Framework 2, 3, 3.5, ASP .NET 3.5, C# .NET, ADO.NET, Visual Studio Team System 2008/2005, XML, SQL Server 2008, SQL Server 2005, SQL Server 2000, Windows Server 2003 Enterprise Edition, HP ProLiant DL380 G4 with Intel Xenon processor.

Confidential, Jacksonville, FL

SQL Server Developer/ DBA

Responsibility:

• Installed and configured SQL Server 2005 in Test environment with latest service packs.
• Part of core team in requirements analysis and database design.
• Responsible for the architecting of the system to enhance performance and scalability.
• Extensively used T-SQL queries, Stored Procedures, Views for the database transactions.
• Optimized SQL queries using hints and sub-queries.
• Managed production support and defect/enhancement request tracking.
• Used SSIS package for import and export of data between SQL Server and Access, Text File and EXCEL files.
• Involved in Extraction, Transformation and Loading (ETL) of data using SSIS & DTS.
• Designed Cubes, Dimensions and Aggregations in Analysis Service 2005 environment.
• Created Time based Dimension with Attributes & Hierarchies.
• Using Data Source Views, created Dim & Fact Table layout in Snowflake Schema and Star Schema Designs.
• Written DDL / DML Triggers based on application business rule.
• Written T-SQL scripts for finding nth highest number in column, populating database table with error log.
• Used Catalog views, System Stored Procedures, DBCC commands for monitoring Database performance.
• Involved in Data Modeling for the application and created ER diagram using ERWin.
• Involved in performance tuning, query optimization using SQL Server Profiler, Database Tuning Advisor, and SQL Server execution plan.
• Addressed issues related to migration from SQL Server 2000 to SQL Server 2005, along with administration & installation of SQL Server 2005.
• Involved in connecting C# based WebForms to Database with help of ADO.NET.
• Prepared Disaster Recovery Plan as per functional and technical lead guidance and performed disaster recovery on test environment.
• Created scheduled jobs that update statistics of database tables and distribute reports to technical lead.

Environment: .NET Framework 1.1, ASP .NET 1.1, C# .NET, ADO.NET, Visual Studio 2003, XML, MS SQL Server 2005, MS SQL Server 2000, BizTalk Server 2006, Oracle 9i, Windows 2000 Advanced Server, Windows Server 2003 Enterprise Edition, HP ProLiant BL25P with AMD Opteron processor.

Confidential, San Francisco, CA

SQL Server Developer/ DBA

Responsibility:

• Responsible for MS SQL Server 2000 configuration, tuning & provide 24 * 7 production support to Production, Development and Clustered Servers.
• Used DBCC Commands, Index Tuning Wizard to rebuild indexes for faster query responses.
• Creating and managing schema objects such as tables, views, indexes, User-Defined functions, triggers, Clustered and Non-clustered Indexes.
• Created Indexed Views and implemented Instead Of & After Trigger & specified their order of execution.
• Created customized DTS package for data conversions and load data from Flat files, Excel files. For Extraction, Transformation and Loading (ETL) of data.
• Involved in creating Cubes, Measures and Aggregates using Analysis Service 2000.
• Involved in Build, Deployment & processing of SSAS Cubes.
• Written queries using Inner join, Left-Outer join, Right-Outer join & Cross join.
• Performance tuning of Stored Procedures & SQL queries.
• Installed and Configured Active/Passive Cluster on Testing server.
• Administered Active/Passive Clustered SQL Server on DEV and PROD server.
• Created SQL scripts to monitor SQL Servers. These scripts monitor backup, drive space, log, db size and service status monitoring.
• Configured SQL Server 2000 log shipping from primary server to hot backup server.
• Designing and building relational databases and created the logical and physical data modeling using Erwin tool.

Environment: .NET Framework 1.1, ASP .NET 1.1, C# .NET, ADO.NET, XML, Visual Studio 2003, MS SQL Server 2000 Enterprise Edition, Oracle 9i,MS Windows Server 2003 R2 Enterprise Edition, IBM x225 with Intel Xenon processor.

Confidential

SQL Server DBA /Developer

Responsibilities:

• Installed, configured SQL Server 2000 with Windows Server 2000 with latest service packs.
• Had good experience in 24/7 production support.
• General responsibilities include Administering, maintaining all existing SQL Servers across Enterprise.
• Develop and implement policies and procedures for ensuring the security and integrity of the company database.
• Troubleshoot SQL Server performance issues for development teams regarding performance review and the correct usage of database objects.
• Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Confidential SQL Server 2000.
• Used Transact SQL to create queries and stored procedures to produce reports for end-users.
• Worked on Client/Server tools like SQL Server Enterprise Manager & Query Analyzer to Administer SQL Server.
• Created queries with Inner Join, Outer Join, Co-related sub-query with String function, Mathematical function, Aggregate function, Date and Time function.
• Performance monitoring with SQL Profiler, Windows System Monitor.
• Involved in migration of Data from Excel, Flat file, Oracle, XML files to SQL Server by using bcp and DTS utility.
• Extensively involved in designing the DTS packages to make the automated synchronization of data from one system to another system.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables wherever possible.

Environment: Windows Server 2000, MS SQL Server 7.0/2000, IIS 5.0, VB 6.0, ASP 1.0, VBScript 5.5, Java Script 1.3, HTML, Oracle 9i, ADO 2.5, I.E 5.0/5.5.

Confidential

SQL Developer

Responsibilities:

• Involved in various stages of SDLC like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation.
• Designing and validating the VB forms according to client requirement.
• Importing and Exporting of the data using DTS utility.
• Creating, maintaining the users, roles and granting privileges.
• Wrote stored procedures and functions to implement business logic
• Developed and coded applications in Oracle - PL/SQL.
• Designed a report on the monitoring of SQL Server Performance. This detailed report shows Performance of the server.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.

Environment: HTML 4.0, ASP 1.0, VBScript 5.5, JavaScript 1.3, ADO 2.5, IIS 4.0, I.E. 5.0, SQL Server 7.0, Oracle 8i and Windows NT 4.0/98.