SUMMARY

• Highly Motivated IT professional with over 7+ years of experience in Database Design, Development and Implementation of SQLSERVER 2008/2005/2000 and providing ETL/Business Intelligence applications using Microsoft components.
• Effectively involved in all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects.
• Working experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T - SQL Programming using DDL, DML, DCL commands for various business applications.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements
• Extensive SQL Development experience in a Banking & Healthcare environment & Financial with a strong understanding of data & analytics
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes
• Expert in using SQL Server Agent to Schedule and monitor Jobs
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Experience in Error handling and debugging coding issues and troubleshoot production problems
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMF’s and Query Execution Plans
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
• Expertise in conversion of DTS to SSIS packages and troubleshooting the migration issues
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations
• Experience in providing System and User-defined Variables, Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data
• Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions (2005/2008/2008R2) & features
• Expertise in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports
• Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms

TECHNOLOGY EXPERIENCE

Tools/Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SQL SERVER BIDS, Visual Studio 2003/2005

Programming Languages: Pascal, C, C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL,HTML,XML T-SQL, Oracle

Tools: DTS, SSIS,SSRS,SSAS, Erwin

DATABASE: MS Access, MS SQL Server 2005/2008/2008 R2, Oracle8i/9i/10g, DB2

Operating Systems: Windows NT/98/2000/XP/2003/2008 server

Software: MS Office Visio, MS-Project 2000

IT Processes: Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS
• Created SSIS process design architecting the flow of data from various sources to target
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages
• Using Dtsx Change tool converted DTS packages to SQL Server 2005 SSIS packages
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created ETL SSIS packages both design and code to process data to target databases
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Responsible for maintaining cubes using SSAS and populate the cubes with the data
• Created Tabular Matrix reports, Charts and graphs as per customer requirements Using SSRS.
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security.
• Created reports with Analysis Services Cube as the data source using SSRS 2005/2008.
• Created and developed query for Drill Down and AD Hoc Reports using SQL SSRS
• Involved in designing the physical database models on SQL Server 2005 RDBMS using DML/DDL implementing constraints and triggers for data integrity.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Created incremental data load task using SQl Server Integration services
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server.
• Worked with development teams in the design of physical databases and in modification.
• Involved in migration from SQL Server 2005 to SQL Server 2008
• Used techniques like backups, restore, replication, and standby databases to ensure higher availability in Production Environment.

Environment: MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, IIS 6.0, Oracle 9i,Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005, MS Access, Crystal Reports, MS Excel 2007.

Confidential, San Antonio TX

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User defined Data type, Clustered & Non-clustered Indexes
• Installed and configure servers and clients using SQL Server 2008,Upgraded SQL databases
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards
• Managed database portioning across multiple disks
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Query optimizations (T SQL or Query Analyzer) using query analyzer and Index tuning wizards
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties
• Knowledge of Database Performance monitoring tools
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created ETL SSIS packages both design and code to process data to target databases
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on monthly and weekly basis
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages
• Created Partition Tables based upon Partition Functions and Partition Schemas
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Created jobs to collect status information from various servers and feed them to the Master Server
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc
• Implement automated Index Maintenance strategy run as SQL Job on a daily basis
• Created Snapshots, Subscriptions and Transactions using Replication services
• Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server
• Resolving any dead locks issues with the Databases/Servers on a real-time basis.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database

Environment: SQL Server 2005/2008, T-SQL Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, Oracle 11g,10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, BizTalk Server 2004 Erwin, Microsoft Visio 2003, SFTP

Confidential, Detroit MI

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification
• Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2000
• Successfully migrated old data from legacy system into SQL Server 2000 using DTS Packages
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
• 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
• Documentation of all the processes involved in maintaining the database for future reference
• Actively participated in User Acceptance Testing, and debugging of the system
• Developed Store procedure and Triggers in T-SQL
• Worked with SSIS. 50 packages are transferred to some flat file and some to the SQL Server from SQL server.
• Created database objects like Table, View, Roles and Indexes
• Used DBCC to check Data Base consistency
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer
• Fine tuned database objects and server to ensure efficient data retrieval
• Reviewed and fine tuned stored procedures and triggers before production migration
• Installed and maintained MS SQL Server 2005
• Worked with Crystal report, SSRS for creating a report
• Generated OLAP cubes and DTS scripts
• Published the databases from old servers to new servers using snapshot replication
• Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations
• Supported development effort by providing T-SQL statement tuning and optimize data loading processes
• Provided back-end support for functional testing and performance testing
• Generated various reports using reporting services
• As a technical specialist assisted in solving technical and non technical issues
• Debugging and troubleshooting the technical issues while implementing the applications
• Identify and resolve problems encountered during both development and release of the SSIS code
• Designed new dynamic DTS Packages to transfer data between servers, load data into database and tuned the existing packages.
• Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications. Developed complex TSQL code for the application.

Environment: SQL Server 2005/2000, SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services),Business Intelligent Studio, SQL Server Management Studio MS Access 97, ASP, Crystal Report, Enterprise Manager, Excel, Windows XP/2003 Server

Confidential, Bloomington, Illinois

MS SQL Server Developer

Responsibilities:

• Involved in gathering the requirements from the client and converting them in to design specifications
• Created logical and Physical database design, data structures, primary key, foreign key and implemented large databases using Erwin
• Involved in extracting the data using SSIS from OLTP to OLAP
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic email notification and SQL Server backup strategy and automation
• Used Active-X Scripting in SSIS (SQL Server Integration Services) for transformation of data in to staging tables and also to extract data from database tables and write the data to text files
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment
• Proper use of Indexes to enhance the performance of individual queries for very fast and efficient reporting process
• Filtered, purged and cleansed bad data from legacy system using complex T-SQL, PL/SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Responsible for testing to optimize the procedures and triggers to be used in production
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions
• Involved in analysis and design of disaster recovery strategies with business managers to meet the business requirements
• Designed and implemented the warehouse data model, dimension, fact and summary tables
• Experience in developing DAL (Data Access Layer), Reusable Code (.dll) using C# OOPS Concepts
• Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions (UDF)
• Perform weekly database checkup, shrink database according to instructions, and document weekly database activities
• Experience in generating reports and deploying it in to the server using SSRS (SQL Server Reporting Services)
• Provided back-end support for functional testing and performance testing
• Daily monitor the systems and check the performance of systems
• Generates the report into Excel Spreadsheet form from SQL server6.5/7.0
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables

Environment: SQL Server 2000/2005, Windows 2003/XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, C#, .Net 2.0, SQL Server Profiler, SSRS, SSIS, T-SQL, PL/SQL, Erwin.

Confidential

MS SQL Developer/DBA

Responsibilities:

• Actively involved designing the logical and physical architecture for Liberty group database
• Created new tables, stored procedures for Application Developers and some user defined functions
• Performed data conversions from flat files into a normalized database structure
• Managing of databases objects like Tables, views, indexes, functions, and procedures
• Extensively used joins and sub queries to simplify complex queries involving multiple tables
• Developed DTS Packages to transfer the data between SQL server database and files
• Created Reports in MS Access 2002 based on SQL Server 2000 stored procedures
• Used BCP utility to publish table output to text files
• Installing and Configuring of SQL Server 2000 on windows 2003 Server OS
• Implementing Backups and restoring strategy and maintaining them
• Implemented Snapshot and Transactional Replication from SQL 7 to 2000 database
• Migrated SQL 7 databases to SQL 2000 databases as per requirement
• Creation and management of database maintenance plan for various database consistency checks
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
• Created and managed users, roles and groups and handled database security
• Created Triggers to enforce data and referential integrity
• Defined Check constraints, Business Rules, Indexes, and Views
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success
• Migrated data from My SQL to SQL Server.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server
• Data migration (import & export - BCP) from Text to SQL Server
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis
• In-Depth working knowledge of ODBC
• Created DTS Packages for extracting data from Flat Files, Excel, MS Access, Oracle and MS SQL Server 2000
• Documented and maintained history of changes for future reference

Environment: SQL Server 2000, Visual Studios 2000, ASP, Excel, MS Access, Visual Basic 6.0, and Windows 2000/NT 4.0