SUMMARY

• Over 6 years of experience in design, development, testing, performance optimization and documentation using SQL Server.
• Experience in working with SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Highly involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Support.
• Experience in Data Migration processing including data loading from flat files to the database tables using SQL*Loader.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake Schema Modeling.
• Extensive experiences in developing Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2005/2008.
• Excellent experience and understanding of database design, relational integrity, Constraints, OLTP, and normalizations.
• Expert in development, implementation, administration and support of ETL processes for large - scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Excellent experience as a Crystal Reports Developer working on large-scale enterprise projects involving complex business case functions, web integration, and data management.
• Proficient in using Crystal Management Console, Crystal Configuration Manager, Crystal Repository, Crystal Migration Wizard and Crystal Publishing Wizard for publishing reports on the Intranet.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008.
• Extensive experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix and chart report, web reporting by customizing URL Access.
• Experienced with converting Crystal reports to SSRS reports and migrate crystal reports to higher versions.
• Maintained positive communications and working relationships at all business levels.
• Excellent Analytical and Problem Solving skills with strong communication and interpersonal skills.
• Flexible, highly-adaptable, team-player, pro-active and eager to learn and perform new tasks.
• Involved in jobs scheduling, monitoring and Production Support in a 24/7 environment.

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008 R2
• SSIS
• SSRS
• OLTP
• Transact-SQL(T-SQL)
• DTS SQL Developer
• ETL
• MS Visual Studio 2008/2010
• MS SQL Enterprise Manager 2000
• Crystal Reports 8.5/9.0/10/X1
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• MS VISIO
• ASP.NET 1.1
• ASP.NET 2.0
• Microsoft Visual Stuidio.NET 2005

PROFESSIONAL EXPERIENCE

Confidential, WA

MSSQL BI Developer

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Involved in implementing SSIS package security, protecting packages, executing, monitoring, managing and deployed them.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Testing and loading the data on Development and Production.
• Running DBCC consistency checks, and fixing data corruption in application databases
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• DesignedSSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load intoDimension and Fact tables in Data Warehouse using SSIS Microsoft Visual Studio 2008
• Represents the customer and engages the customers or interfaces with them as required.
• Generated XML files from Database tables.
• Using SSIS, loaded XML data to the Database tables.
• Extensively worked in creating Database, database objects such as View, Table, Stored Procedures, Triggers, Cursors, Creating indexes and functions using T-SQL.
• Wrote complex Join queries using T-SQL.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and Managers using SQL server 2008 R2
• Involved in Report writing according to business requirement using SSRS.
• Involved in Performance Tuning activities including Query Tuning and Index Maintenance.
• Monitoring the application and database performance using SQL Profiler and Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.
• Created Triggers to monitor activities on server as well as database and generate alerts and notifications.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Provided support for in-house and off-shore Development Team.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
• Established a sound backup and recovery policies and procedures.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, deploying reports to report server using SSRS.
• Responsible for data conversion activity for System Integration and User acceptance testing.
• Involved in Production Support to resolve end-users data related reports issues.
• Actively participated in gathering and analyzing Business Requirements, Creating Directives, Data Analysis, Design, Development, Conversion, System Testing, Operational Readiness, Documentation, Production support issues.
• Involved in programming, debugging, and unit and system integration testing of modules.
• Used tools like SQL *Loader to load the data into the database tables from flat files and excel sheets.

Environment: MS SQL Server 2008 R2, SQL Server Reporting Services 2008 R2, MS SQL Server Integration Services, MS Visual Studio 2008/2010

Confidential, Naperville, IL

SQL Server/ BI Developer

Responsibilities:

• Responsible for the analyses of the requirements of the business, designing database tables.
• Modified applications according to the user’s requirements and Developed Web site administration and user management system.
• Developed Reports out of the Consolidated Data Warehouse for the Business Users using MS SQL Server Business Intelligence Development Studio (BIDS) 2008 R2
• Extensive knowledge in performance tuning
• Created ad hoc SSRS reports in the test environment for data validation.
• Created dynamic ssReports using SSRS 2005, and stored procedures.
• Extensively worked in writing Ad-hoc queries
• Created Tabular and Matrix Reports with all aggregate functions and expressions.
• Responsible for the testing, fixing the bugs and troubleshooting the technical problems.
• Created SSRS Data Model projects using Microsoft Visual Studio 2005 and using report Builder for report server to facilitate Ad-hoc reporting by the business users.

Environment: SQL Server 2005/2008, SSRS, SSIS

Confidential, Naperville, IL

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Designed and created different ETL packages using SSIS and transferred data from SQL source to MS SQL server destination.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach, Attach, Back up, Recovery and by Replication.
• Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
• Created SSIS packages to extract data and Scheduled Jobs to call the packages and Stored Procedures.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Experienced in Data Conversion, Normalization and data modeling, involved in creation of Fact Tables, Dimension Tables, and Star Schema and Snowflake dimensional schema using Erwin Tool.
• Responsible for transferring of the databases and database objects from Development to Production Server using DTS.
• Heavily involved in upgrading systems and maintained after implementation.
• Correct defects and failures using methods such as modifying code and fixing incorrect joins and altering sequence of program.
• Convert data from Legacy system to SQL Database.
• Correct defects and failures using methods such as modifying code and fixing incorrect joins and altering sequence of program.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.

Confidential, Chicago, IL

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• From one standard database for loans created diversified destinations for auto loans, student loans, home loans using SSIS packages.
• Extensively used SQL server reporting services to generate reports on a weekly basis for a particular loan type. Created report models for ad hoc reports when the end user wants to see the reports.
• Calculates loan details for existing customers applying for a second loan based on payment history and remaining amount of loan.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler. Established backup and recovery of SQL reporting services.

Environment: MS SQL Server 2005, MS Server Integration services, Data Transformation Services (DTS), SSRS, and SQL Server Profiler.