SUMMARY

• A skilled software professional with Over 8 years of industry experience in design, development and implementation of business requirements with Microsoft SQL Server 2012/2008 R 2/ 2008/2005/2000 database system in client/server environment.
• Experience in design and development of Enterprise Data warehouse and DataMart.
• Domain expertise in Enterprise Services, Salvage Auto Auctions, Consulting, Transportation, Banking and Finance.
• Expert level skills in Data Mapping, Table Normalization, Optimization and Performance Tuning.
• Expert in writing T - SQL queries with DDL and DML commands, complex stored procedures, indexes, triggers and views.
• Experience in writing complex T-SQL queries using Joins, Functions.
• Expert in handling Source Control tools like Visual Source Safe (VSS), Subversion, TeamForge and Team Foundation Server (TFS).
• Optimized the performance of queries with modifications in T-SQL queries, and eliminated redundant and inconsistent data.
• Worked extensively on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle (SDLC).
• Worked extensively on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Expert skills in handling different Data warehousing methodologies such as Bill Inmon (Top Down design) and Ralph Kimball (Bottom-up design).
• Experience in developing, deploying and monitoring packages for ETL tasks using SQL Server Integration Services (SSIS), DTS Import/Export Utility, DTS packages.
• Followed the Microsoft recommended best strategies in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services (SSIS).
• Expert in providing logging, error handling by using event handler and break points for SSIS packages.
• Migrated organization orders, adjustments, objectives and data in various formats like text based files, excel spreadsheets, to SQL Server databases using SSIS to overcome the transformation constraints.
• Experience in handling Performance Tuning of SSIS using Horizontal Partitioning and Vertical Partitioning.
• Experienced in monitoring and scheduling ETL processes using DTS EXEC utilities and batch files.
• Experience in Online Analysis Processing (OLAP), created cubes, dimensions, partitions and perspectives.
• Experience in developing reports using SQL Server Reporting Services (SSRS) in share point integrated mode and ad hoc reports using Report Builder 3.0
• Creating various types of reports like Drill Down, Drill Through, Parameterized, Ad hoc and Cascaded Parameterized.
• Experience in developing Memex Reports.
• Migrated and recreated existing dimensions and cubes using star schema on SQL Server 2008 to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Excellent hands on experience in scheduling SQL Server Agent Jobs for database Backups, Restoration and Disaster Recovery Procedures and implementing Backup strategies.
• Created and administered all SQL Server databases, objects, logins, users, and permissions in each registered server.
• Played an important role in improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Highly committed, motivated and a natural team player with strong analytical ability.

TECHNICAL SKILLS

RDBMS/ Database: SQL Server 2000/2005/2008 R2/2012, MS-Access XP/2007, Sybase. ORACLE 10g/9i, PL/SQL

Reporting tools: SQL Server (SSIS, SSAS, SSRS),Crystal Reporting 10.0, Memex

Data Modeling: Microsoft Vision 2000, Erwin 4.0/3.5

Languages: T-SQL, PL/SQL C#.NET, ASP.NET, XML, VB.NET, Visual Basic 6.0

GUI: Visual Studio.Net, Visual Studio 6.0/2005

SQL Tools: IDERA Performance Monitor, SSMS, SQL Profiler, DTS, Database Tuning Advisor DTA, IDERA SQL Backup.

Web Design Tools: Dream Weaver CS3, FrontPage 2002, Outlook Express, Adobe Flash

Scripting Languages: Shell scripting, Perl Scripting

Operating Systems: MS-DOS, Windows 2000/XP/NT/Vista, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr. MS SQL/BI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design and development.
• Migration of data to Memex platform from various sources like flat files, excel, oracle, SQL etc. with SQL server as medium.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Used Stored Procedures to transform the data and load to the reporting table.
• Employed various constraints such as Primary Key constraint and Foreign Key constraint on tables to maintain Data Integrity and also created user defined Functions, Stored Procedures, and Triggers.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Written complex queries using FOR XML (RAW, AUTO, EXPLICIT) to convert SQL data to XML format.
• Involved in Optimization and Performance tuning of the queries.
• Developed complex reports in Memex reporting system.
• Design, deployment, and maintenance of various SSIS packages in SQL Server 2012.

Environment: SQL Server 2008 R2/2012, SQL, T-SQL, MS Access, MS Excel, FlatFiles, Windows 2003 server, Business Intelligent technologies like SSIS, Memex, SVN, TeamForge.

Confidential, Austin, TX

Sr. MS SQL/ETL Developer

Responsibilities:

• Worked on different Data warehousing methodologies such as Bill Inmon and Ralph Kimball.
• Worked on designing and development of Enterprise Data Warehouse.
• Involved in Data Modeling using ERWIN.
• Worked on creating an Enterprise Data Warehouse.
• Worked on SQL and Vertica servers and migrated data using SSIS and Informatica.
• Created tables, views, users, logins, indexes (indices), check constraints and business rules using T-SQL and maintained databases.
• Used Stored Procedures to transform the data and load to the reporting table instead of using SSIS.
• Involved in Query Optimizations and performance tuning for the stored procedures.
• Worked Extensively with SSIS to import, export and transform the data between data sources.
• Used SHELL Scripting on UNIX platform to load data directly to the Vertica server, instead of ETL.
• Involved in gathering requirements from Business.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Migration of data to SQL 2012 from various sources like SQL, Oracle, Access, Excel, CSV etc.
• Migrated Databases from SQL Server 2008 R2 to 2012. Also from SQL 2012 to Vertica DB.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Manage connections dynamically through SQL XML config files in SSIS.
• Replicating the desired data from Production to different environments (Test, Dev) using a single SSIS package.
• Used VB Script to pass multiple parameters for Stored Procedures to read and write database table
• Automated and enhanced daily administrative tasks including space management, object alteration, database backup and recovery.
• Providing permissions to the Staff and Business.
• Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers. Prepared technical and functional documentation and system configuration.
• Worked with off shore teams in Galway, India and China.
• Involved in using SVN (Subversion) and TeamForge to check in and check out the tasks and Jira-Ticketing System for case tracking..
• Provided 7 x 24 Production support for the database and application issues.
• Experience in leading ETL team for 3months, in absence of my Tech Lead.
• Involved inGUI designfor the project usingMasterandContent Pagesalong withUser Controls.
• Designed and developed rich User interfaces.
• Involved in developing a user interface for manual entry of data using C# and ADO.Net.

Environment: SQL Server 2008 R2/2012, Vertica, .NET Visual Studio, SQL, T-SQL, MS Access, MS Excel, Windows 2003 server, Business Intelligent technologies like SSIS,SSRS, Informatica, SVN, TeamForge, Jira, Shell Scripting.

Confidential, Tallahassee, FL

MS SQL/BI Developer

Responsibilities:

• Written SQL joins, sub queries, performance tuning for better running of queries.
• Created tables, views, users, logins, indexes (indices), check constraints and business rules using T-SQL and maintained databases.
• Migrated Databases from SQL Server R2. Determine the technical approach of Migration used when migrating from SQL Server R2.
• Migrating data from various sources into the SQL Server 2008 R2 using SQL Server Integration Services (SSIS).
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers and Log Providers etc.
• Extensively involved in using SSIS tools like Import and Export Wizard for developing the packages.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Involved in writing T-SQL stored procedures, functions for generating various customer review SSRS reports.
• Maintained performance and analysis of the customers billing information in the form of reports using SSRS.
• Involved in implementing conditional formatting using reporting services.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Worked on a large database of 50TB.
• Designed and developed web user controls in .NET using C#.
• Designed and Developed ASP.NET web applications, custom control for navigation.

Environment: SQL Server 2005/2008 R2 Enterprise Edition. .NET Visual Studio, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS,SSRS, TFS.

Confidential, Los Angeles, CA

MS SQL/BI Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2005 with latest Service Packs.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Developed ETL’s using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Creating package dependencies by calling Child packages within Parent.
• Using Configurations to make dynamic changes to packages. Configurations like XML, SQL Server and Environment Variables have been used.
• Using the Default logging as well as Custom Log to keep track of the package.
• Migrating SQL Server 2000 DTS packages to SSIS Packages.
• Designed, administrated and developed Star Schema Data marts
• Experience in creating multiple reports (SSRS) in Drillmode using tables, crossestabs and charts.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.
• Developed stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2005, MS SQL Server Reporting service 2005, MS SSIS, T-SQL, Sybase, Windows 2003

Confidential, New York, NY

MS SQL Developer

Responsibilities:

• Migrated Databases from SQL Server . Determine the technical approach of Migration used when migrating from SQL Server .
• Created tables, views, users, logins, indexes (indices), check constraints and business rules using T-SQL and maintained databases.
• Involved in writing T-SQL stored procedures, functions, views, triggers
• Written SQL joins, sub queries, performance tuning for better running of queries.
• Migrating data from various sources into the SQL Server 2008 using ETL (Extract, Transform, Load) tool SQL Server Integration Services (SSIS).
• Worked extensively on SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Log Providers etc.
• Extensively involved in using SSIS tools like Import and Export Wizard for developing the packages.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Maintained performance and analysis of the customers billing information in the form of reports using SSRS.
• Involved in implementing conditional formatting using reporting services.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• All data were migrated to the staging server and then those data were later populated to the OLAP (Online Analytical Processing) Server to use with SSAS for analysis purpose.
• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.

Environment: Windows XP, MS SQL Server 2008, MS SQL Server Reporting Services 2008,MS SQL Server Integration Services 2008, Excel, Acrobat Reader.

Confidential, Manhattan, NY

MS SQL Developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Used SSIS/ETL transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on wealth information, account information, research reports using adhoc reporting to be used by the clients and advisors.
• Developed and deployed data transfers packages to the appropriate destinations using ETL.
• Identified and worked with multivalued parameters for parameterized reports in SSRS.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Conducted re-occurring weekly meetings to capture agency level issues in Oracle.
• Developed, documented, and executed Standard Operating Procedure in Oracle.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SSAS.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly.
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Environment: MS SQL Server 2005, SSIS, SSRS, T-SQL, Crystal Reports 10, Visual Studio 2005, MS Office 2007, SQL Profiler

Confidential

SQL Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management Developed backup restore scripts for SQL Server as needed.
• Upgraded to latest version from SQL server 7.0 to 2000.
• Written various stored procedures for the purpose of application development.
• Tuned SQL statements (Using Indexes) and Stored Procedures.
• Disaster recovery and database maintenance plan.
• Replication of data using Transactional method.
• Migrated data from Sql server 7 to Sql server 2000 successfully
• Data conversion from Text File into SQL Server Table.
• Created constraints and validated database integrity.
• Designed and implemented data access stored procedures and triggers for automating tasks. Job scheduling and alerts.
• Designed and implemented user log in and security.
• Extracted Data from MS Access.
• Created many complex Stored Procedures / Functions and used them in Matrix Reports.
• Created reports and hosting it in the web for the users.

Environment: MS SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler.