Summary

• Over 7 years of extensive experience in the IT industry as a MS SQL Developer/BI Developer SSRS,SSIS,SSAS in MS SQL Server 2000/2005/2008R2.
• Strong experience in MS SQL Server 2008/2005 working with business intelligence tools in SSIS SQL Server Integration Services , SSRS SQL Server Reporting Services .
• Expert in Creating Views, Complex Triggers, effective Functions and appropriate stored procedures to facilitate efficient data manipulation and data consistency.
• Expertise in writing complex queries using joins, common table expressions and temporary tables.
• Excellent Experience in tuning the performance of database and queries by creating indexes, views and verifying execution plan.
• Excellent Experience in deploying and enhancing the SSIS Packages from development to production server.
• Experience in defining queries, generating drill-down reports, complex formulas, sub-reports, and on-demand reports and also expert at basic and advanced report creation table, chart, matrix report, web reporting using SSRS along with excellent experience in report serving architecture.
• Highly experienced in strategically implementing the indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Experienced in creating packages, running packages, designing, compiling and testing and excellent knowledge in creating reports based on the requirements using SSRS 2008 and scheduled the monthly/weekly/daily reports to run automatically
• Excellent knowledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables.
• Excellent knowledge in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio.
• Hands on in Extraction and Migration of Data from heterogeneous data sources like Excel, Access, Oracle and DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP Bulk Insert utilities.
• Strong Knowledge of developing complex stored procedures, User Defined and System Defined functions, and partitions.
• Good Knowledge in database activities like database creation and maintenance, performance monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Knowledge in installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008 in windows environment, BI components DTS/SSIS, SSRS .
• Familiarity in designing reports using SQL Server Reporting Services SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Good Understanding of designing cubes using SSAS and creation of reports using analysis services cubes.
• Involved in various admin level activities such as creating and maintaining of databases and other security objects like logins, Roles, Users and Schemas.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client requirement.

Technical Skill:

MS SQL Server 2008/2005/2000, SSIS, SSRS, SSAS, T-SQL, PL-SQL, Business Intelligence Development Studio BIDS , DTS, Import/Export Data, Bulk Insert, BCP, SQL Profiler/Analyzer, Database Engine Tuning Advisor, SSMS, SQL Agent, Service Manager, Oracle 10G/8i, MS Office Suite, Microsoft Visual Studio, SQL Server Integration Services, .NET, C , VB 6.0, HTML, XML

Professional Experience:

Confidential

MS SQL Server / SSRS / SSAS/ SSIS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements, Data Migration from SQL Server 2005 to SQL Server 2008 and provided documentation
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created SQL server configurations for SSIS packages and experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created complex stored procedures, efficient triggers, and required functions, creating indexes, and indexed views for improving performance.
• Responsible for creating reports based on the business requirements using SSRS 2008
• Identified the database tables for defining queries to generate reports for analysis of data using SSRS in Report Builder.
• Created various reports including Cross-tab, Conditional, Drill-down, Sub reports, parameterized reports and also created number of complex formulae in sub report.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically. .
• Scheduled JAD Sessions and involved in gathering the report specifications by interacting with the business users.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Implemented Star Schema for OLAP cubes using SSAS.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2008 SSRS , SQL Server Analysis Services 2008 SSAS , SQL Server Integration Services 2008 SSIS , VSS, Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, Erwin, C .

Confidential

MS SQL Server / SSRS / SSAS/ SSIS Developer

Roles and Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, Testing of application.
• Worked as a developer in creating Stored Procedures, triggers, function, tables, and other SQL joins and statements for applications.
• Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQL queries.
• Handled slowly changing dimensions to maintain the history of data.
• Included Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Developed data access queries/programs using SQL Query to run in production on a regular basis.
• Created report snapshots to improve the performance of SSRS.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Created report models for ad hoc reports when the end user wants to see the reports on the fly.
• Responsible for Monitoring and Tuning Report performance by analyzing the execution plan of the report.
• 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 2008.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing.
• Performed ETL process by pulling large volumes of data using SSIS, BCP into the staging database from various data sources like Access, Excel.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Environment: MS SQL Server 2005/2008R2, SQL Server Integration Services 2008 SSIS , SQL Server Reporting Services 2008 SSRS , SQL Server Analysis Services 2008 SSAS , Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, HTML.

Confidential

MS SQL Server / BI Developer

Roles and Responsibilities:

• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.
• Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Migrated legacy database and spreadsheets Access/Excel to SQL Server 2000 using Data Transformation Services DTS and T-SQL scripts.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, , statement using the TOP operator to limit the Select statement in certain queries.
• Created views to restrict access to data in a table for security.
• Developed computer information resources, providing for data security and control, strategic computing, and disaster recovery.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQL 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, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services SSRS .

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, T-SQL, OLAP Services, ASP.NET, XML, Windows 2003 Server, MS VISIO, ERWIN.

Confidential

MS SQL Server Developer

Roles and Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 using SSRS, T-SQL, scripts, stored procedures and views .
• Data Migration - Migrated and converted data to be sent across different servers and databases to accomplish database mirroring. This involved setting up automated Unix Shell Scripts to extract and massage data from Informix and Oracle databases into text files. These text files were then FTP's to destination servers where another automated process was executed to load the text files into the desired target tables
• Configured and normalized and SQL Server query language.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database Access database and xml format data to SQL Server.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Created Dashboards and reporting services web parts.
• Performance tuning of SQL queries and stored proc using SQL Profiler and Index Tuning Wizard.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Environment: SQL Server 2008, DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VBScripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, C .Net, HTML.

Confidential

SQL Server Developer

Roles and Responsibilities:

• Extracted required mapping fields from different sources schema, CDW to Sales Force Warehouse for Staging Table.
• Performed all Conversion goals and objectives which include identifying data for processing sales, and validating of historical sales is available in CDW for migrating the data to Sales Force.
• Developed and modified many Scalar Valued Functions, Stored Procedures for parsing data required for mapping in Sale Force. Tweaked low performance functions.
• Developed Store Procedure and Staging table for data push from CDW to Sales Force.
• Preformed QA Testing for all the Store Procedures to validate the sales results.
• Developed SSIS Packages not only for particular table's fields and required data types for lookup tables in Staging but also for data Warehouse requirements of CDW.
• Increased query performance by 20 , which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Created SSIS Packages by using advanced tools i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting .
• Developed and modified the existing reports from basic Chart and tabular to parameterized reports including Single/Multi/Boolean valued parameters and linked reports based on new business logic.
• Created SQL server configurations for SSIS packages and XML Windows event logs.
• Used sub reports functionality for complex report calculations.
• Created parameterized reports passing parameter through report screen.
• Rendered reports in different formats like Pdf, excel etc to be executed automatically on weekly or monthly basis and managed subscriptions.

Environment: Windows XP/2003 Enterprise edition, MS SQL Server 2005, Excel 2003, Visual Studio 2005, TFS, VBScript, Database Engine Tuning Advisor, Profiler SQL Server Management Studio 05, SQL Server Business Intelligence Development Studio, Reporting Services Configuration, SSIS, SSRS.