SUMMARY

• 13+ years of IT experience in Development, Maintenance and Administration of database application on SQL Server in OLTP/OLAP environment.
• Proficient in creating DB Objects such as Tables, Views, Stored Procedures, Functions, Packages, Indexes, Joins in SQL Server and Teradata databases.
• Experience in Teradata Load utilities like Multi Load, Fast Load, BTEQ and Fast Export.
• Proficient in SSIS, DTS, Bulk Insert and BCP.
• Experience in developing, migrating and transforming DTS to SSIS packages.
• Experience in Backup/Restore, Query Optimization, Troubleshooting SQL Queries.
• Experienced in using Profiler, Index Tuning Wizard and Performance Monitor.
• Proficient in Data Modeling, Data Mapping using ERWin and MS Visio tool.
• Experience in creating reports using SSRS, Crystal Reports and Excel.
• Skilled in Developing, Deploying and Processing OLAP Cubes.
• Experienced in domain industry areas include Transportation, Healthcare, Education, Insurance, Automobile and Banking.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R 2/2008/2005/2000/7 , Teradata, Access 2003

Operating System: Windows Server 2012/2008/2003 , NT & Windows 9x, UNIX

Reporting Tools: SSRS, Crystal Reports 9/10/XI, Crystal Enterprise 10, Excel

Languages/Utilities: T - SQL, PL/SQL, VB 6.0, VB.NET, ASP, XML, XSL, VBScript

GUI Tools: Visual Studio 2003/2005/2008/2010 , BCP, DTS, SSIS, SSAS, SSMS, DTA, SQLCMD, Profiler, Erwin 4.1/7.0, MS VISIO, SQL Query Analyzer, Teradata SQL Assistant

Web Technologies: HTML, DHTML, XLST, XPATH, CSS, UML

Version Control: PVCS, VSS, TFS

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SQL Server Consultant

Responsibilities:

• Monitoring SQL Server performance using SQL Profiler to find performance and dead locks.
• Identifying and resolving locking, blocking for long running queries.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Experience in using DMV for finding out long running queries.
• Automate daily backups by backup database task on SQL 2012.
• Recovering the databases from backup using SSMS.
• Enforce Database Security by managing user logins, roles.
• Design and Development of SSIS Packages to load the Data from various Databases and Files like Text Files, Excel and OLEDB.
• Used Fuzzy Grouping task to maintain a standard of the table or quality of the data. Used Aggregate transformations like Group by, Count, Sum operations.
• Used Derived Column Task to do manipulation and transformed the data for the new column in the database.
• Used Conditional Split transformation based on conditions, evaluates and split the rows.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Generated ad-hoc query report through SSRS report builder.
• Developed various operational Tabular and Drill-down reports using SSRS.
• Deployed data sources and reports by selecting them.
• Work closely with project teams for long term scalability of SQL database environments.

Environment: Windows 2012 Server, Visual Studio, VB.NET, ADO.NET, VBA, MS SQL SERVER 20012, SSIS, SSMS, SSRS, MS Excel.

Confidential

SQL Consultant/SQL DBA

Responsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Performed backup and restore by using SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
• Performed daily backups on SQL 2008 by SSMS.
• Performed Index Fragmentation analysis on high transaction tables and fixed the issues.
• Monitoring performance improvement in databases involves index (creation, removal, modification) and adding scheduled jobs to re-index and update statistics in databases.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor
• Migration of data from heterogeneous data sources (Excel, Access and CSV Files) to data warehouse and data marts using SSIS.
• Designed and mapped using SSIS Transformations like OLEDB Command, Conditional Split, Aggregator, Multicast and Derived Column.
• Deployed and scheduled SSIS package.
• Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS 2008.
• Created OLAP Cubes and Dimensions, defining referenced relationships in SSAS.
• Designed OLAP cubes with star schema using SSAS.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated periodic reports based on statistical analysis of the data using SSRS.
• Developed various operational Tabular and Drill-down reports using SSRS.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Documenting database objects, jobs and the changes made to the database.

Environment: Windows 2008 Server, MS SQL SERVER 2008, SSIS, SSMS, SSAS, SSRS, Visual Studio 2008, VB.NET 4.0, ADO.NET, VBA, TFS, Excel.

Confidential, Chicago, IL

SQL Server Consultant

Responsibilities:

• Denormalize databases and created some redundant columns for performance.
• Tuned SQL queries using Show Plans and Execution Plans for better performance.
• Checked index fragmentation and re-index for efficient access on high transaction tables.
• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries.
• Created SSIS packages to load data from Source like Excel, Access and Text files.
• Transformed data from various data sources using OLE DB connection by creating various SSIS Packages.
• Created mappings such as sort, derived column, conditional split, pivot and lookup etc.
• Configured Server for sending automatic mails to the respective people when a DTS process success or failure.
• Used Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Designed facts and dimension tables and defined relationship between facts and dimensions in SSAS.
• Involved in creating OLAP Cubes and Dimensions for the new Data Warehouse using SQL Server Analysis Services (SSAS).
• Created and modified OLAP cubes (dimensions, facts, members).
• Developed reports on OLAP Cubes as data source in SSAS.
• Develop reports using formulas and generate reports using SSRS.
• Developed reports on SSAS Cubes as data source.
• Designed and implemented Security policy for SQL Servers.
• Performed daily backup task including backup and restore by SSMS.
• Writing ad-hoc queries and stored procedures for custom reporting.

Environment: MS SQL Server 2008, Windows 2008 Server, Visual Studio 2008, SSIS, SSMS, SSAS, SSRS, TFS, Visual Web Ripper, Excel 2007, Access, SQL Query Analyzer.

Confidential, Vallejo, CA

MSBI Consultant

Responsibilities:

• Used SSIS to create ETL packages to load data into data warehouse and data marts.
• Developed OLAP Cubes and Deployed and Processing SSAS objects.
• Created OLAP cube data source for Microsoft Query to retrieve a part of data from external database.
• Developed stored procedures, triggers to handle complex business rules.
• Created procedures and functions to manage the data and triggers for data automation.
• Normalized database tables and performed extensive query optimization.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Created the Indexed Views for better performance.
• Planning for backup and recovery of SQL database information.
• Traced long running queries and deadlocks using SQL Profiler.
• Tuned SQL queries using Show Plans and Execution Plans for better performance.
• Update statistics to make sure that the query optimizer uses the most recent statistics.
• Walkthrough the quality of the code written.
• Generated reports on weekly and monthly basis as per the client requirements.
• Maintained consistency in programming to support proper testing and maintenance.
• Created naming convention templates and documented it.

Environment: SQL Server 2005, Windows Server 2003, SSIS, SSAS, SSMS, T-SQL, IIS 6.0, VSS, BIDS, Excel 2003.

Confidential, Hartford, CT

Consultant/SQL Developer

Responsibilities:

• Developed ETL packages in SSIS to transfer data from flat file format to reinsurance source databases and data from reinsurance source loaded into EDW (Enterprise Data warehouse).
• Source to Staging were mapped using SSIS Transformations like OLEDB Command, Multicast and Derived Column.
• Involved in loading data into Teradata from legacy systems and flat files using Fastload.
• Distributed data from one database to another and then synchronizing between databases to maintain consistency using replication.
• Developed stored procedures, triggers to handle complex business rules.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Scheduled and monitored all maintenance activities of SQL Server 2005.
• Planning for backup and recovery of SQL database information.
• Automated log shipping process to ship transaction log backups to another server.
• Deployed database objects from development to testing environment.
• Perform ceded reinsurance monthly, quarterly and yearly process reports.
• Prepare reinsurance analysis reports for management review.
• Developed Teradata SQL queries to generate ad-hoc reports for the business analysts.
• Partitioned tables, which have frequent insert, delete and update to improve performance.

Environment: SQL Server 2005, Teradata V2R6, Windows Server 2003, SSIS, SSMS, T-SQL, IIS 6.0, Profiler, DTA, VSS, SQL Query Analyzer.

Confidential, Hartford, CT

Consultant/SQL Server Developer

Responsibilities:

• Work together with business analysts, team members for requirement gathering.
• Defined database upgrade strategy to relocate database to new servers.
• Upgrade the SQL Server 2000 databases to SQL Server 2005.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Based on the business needs created replication models on applications.
• Implementing Log Shipping standby servers.
• Performed back-ups, restores, scheduled SQL jobs and maintained SQL Server databases.
• Created clustered index & performed index tuning for optimization.
• Developed triggers to enforce data and referential integrity.
• Wrote SSIS Packages to migrate logins, stored procedures and functions.
• Monitored scheduled jobs and set up maintenance plans.
• Documenting database objects, jobs and the changes made to the database.
• Check databases with DBCC commands for maintaining data consistency and integrity.
• Creating and reviewing trace file using SQL Profiler to troubleshoot issues, as required.

Environment: MS SQL Server 2005/2000, Windows Server 2003/2000, T-SQL, DTS, SSIS, SSMS, BIDS, EM, IIS 6.0, VSS, SQL Query Analyzer.

Confidential

Associate Consultant/SQL Server Developer

Responsibilities:

• Created DTS packages to load data from Source like CSV, Excel, ORACLE, SQL 2000 and MS Access.
• Developed and modified stored procedures, triggers to handle complex business rules.
• Managed databases including performance tuning, database consistency checks.
• Developing guidelines for database activity with the view to ensure access to data.
• Creating roles and managing user permissions, resolved deadlocks.
• Created alerts, notifications and emails for database errors.
• Used SQL Profiler for troubleshooting and monitoring SQL Server.
• Tested and implemented Log Shipping and Replication for HA solution for databases.
• Setting standards for SQL database objects (e.g. naming conventions, index creation etc.) and ensuring compliance to these standards.
• Writing ad-hoc queries and stored procedures for custom reporting needs.
• Maintain all the SQL documents include installation and data transfer procedures documents.
• Worked closely with the team to create and modify functionalities to modules.

Environment: SQL Server 2000, Windows Server 2000, DTS, T-SQL, IIS 6.0, ASP.NET, Crystal Reports 10.

Confidential

Associate Consultant/SQL Server Developer

Responsibilities:

• Data Transfer from other systems to master tables using DTS-Import/Export wizard.
• Ensure standards for SQL Server database objects.
• Manage Database environments including trouble shooting, performance and backup/recovery.
• Monitoring of databases including database optimization and health checking.
• Developed SQL scripts for maintaining administration tasks.
• Monitoring the database including backup, performance.
• Troubleshoot and resolve database problems encountered by end users.
• Collaboratively work with team to ensure the issues don’t crop up.

Environment: MS SQL Server 2000, Windows Server 2000, T-SQL, DTS, .NET Framework, ASP.NET, PVCS.

Confidential

SQL Server Developer

Responsibilities:

• Designed VB forms and view reports in VB form using Crystal Reports. .
• Created VBCOM Components for transferring data from the front-end to the database.
• Created Triggers to enforce data and referential integrity.
• Involved in OFA (Order Fulfillment & Advanced Shipping Notification), VMI (Vendor Managed Inventory) and SSI (Self Service Invoicing), RFQ (Request For Quotation) modules for developing COM/XML components.

Environment: Windows NT 4.0, ASP 2.0, VB 6.0, VB Script, XML, SQL Server 7.0, Crystal Reports 8.0.

Confidential

Programmer

Responsibilities:

• Involved in screen designs, development and testing of the programs.
• Created procedures for calculation and database triggers to validate the data into the database.

Environment: Windows NT 4.0, ASP 2.0, VB 6.0, VBScript, HTML, XML, SQL Server 7.0, VB COM.