SUMMARY

• Over 7+ years experience as MS - SQL Server Developer, involved in Design, Development and Support of MS SQL Server 2005/2008 for both OLTP and OLAP Systems.
• Performed database administration tasks: Installing, Configuring, Managing, Monitoring and Troubleshooting MS SQL Server 2000/2005 on Windows NT, 2000 and 2003 servers.
• Experience in Data Warehouse and RDBMS concepts as SQL Server database & BI Developer.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Extensive experience in writing Complex Dynamic SQL queries, T-SQL Queries, Sub queries, Co-related sub queries, Triggers, Common Table Expressions (CTE), Views and Indexes.
• Developing complex stored procedures using Cursors and Temporary tables.
• Good knowledge of object-oriented concepts and a fair understanding of component based architecture and database systems.
• Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using SQL Server Reporting Services 2005
• Expertise in upgrading or migrating from DTS to SSIS packages and resolving complex issues SSIS.
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2005/2008. Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages
• Expertise includes FACT & Dimension Tables
• Knowledge of Backup, Security, Isolation Levels.
• Expert in maintaining Error logging using Exceptional Handling in SSIS.
• Expertise in Developing and Extending SSAS Cubes, Partitioning, Data Mining Models, Deploying and Processing SSAS objects, writing MDX queries for multi-dimensional cubes.
• Experience in SQL Server Analysis Server MDX Queries.
• Created Scorecards/Dashboard Pages in SSRS.
• Worked extensively on BCP transferring the data from one server to another server and used DBCC utilities to check the performance of the databases.
• Developing complex stored procedures using Cursors and Temporary tables.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Hands on Experience in LINQ.
• Excellent communication skills, both oral and written and pleasing interpersonal skills.
• Highly intuitive, hardworking, motivated and easily adaptable to challenging environments.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL. C, C++, Visual C#, Perl, Shell Scripting

Databases: SQL Server 2008/2005/2000/7.0 , Oracle 9i/10g, MS Access

Data Modeling: Microsoft Visio 2003/2007

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy Program (BCP), Informatica 7.x

Database Tools: SQL Enterprise Manager, Management Studio, SQL Server Query Editor, SQL Query Analyzer, Solution Explorer, Analysis Manager, Reporting Server, Windows Server 2003/2008.

Operating Systems: Windows / 98/2000/2003/ XP/Vista/Windows 7, UNIX, LINUX, AIX.

Other Tools: Windows Virtual PC, Oracle Virtual Box, VMware, Visual Source, Safe

PROFESSIONAL EXPERIENCE

Confidential, Thousand Oaks CA

SQL SERVER DEVELOPER

Responsibilities:

• Worked Extensively on SQL Server 2008, Integration Services, and Analysis Services and Reporting Services.
• Used SQL Server 2008 Reporting Services (SSRS) for generating various different kinds of reports such as Tabular, Freeform, Drill through, Drilldown, Charts, Graphs, Cascading, Sub reports and Parameterized Reports.
• Involved in performing Extraction, Transformation and Loading using complex SSIS packages from various sources like XML, CSV, Excel, Oracle and SQL Server.
• Developed all the required Stored Procedures, User Defined Functions, Triggers, Views using T-SQL as per business logic.
• Managedreport development/deploymentandreport server administration.
• Involved in data modeling designing and entity relationships.
• Experience with reporting stored procedures and views.
• Report Builder 2.0 used for creating business Model for the Ad-Hoc reports.
• MDX queries utilized in both SSAS cube and to manipulate the SSRS Reports.
• Created PPS Dashboard for the business using SSAS OLAP database and integrated with SharePoint.
• Used SharePoint Enterprise Portal for hosting Scorecards and SSRS Reports.
• Worked extensively with client/business gathering requirements to generate customized SQL Reports (Subscriptions Created).
• Created Partitions and Aggregations for the performance enhancement of OLAP cube.
• Used SQL Server profiler and Performance Monitor for auditing, analyzing and performance tuning of ETL Loads, Cube and Reports processing.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, unnecessary Joins and created Indexes whenever necessary.
• Promoted database objects from DEV/TEST to Production after Regression testing.
• Worked extensively on all the Environments: Development, Testing and Production.
• Worked on Perl scripting.
• Worked with front-end application developers to understand their requirements and create Procedures and Reports.
• Automated Database Maintenance tasks by creating Jobs and Alerts through SQL Server Agent.

Environment: SQL Server 2008 Enterprise, T-SQL, MS-Excel, MS-Access, XML, SSIS, SSRS, SSAS, MDX, OLAP, PPS, Windows SharePoint Services 3.0, Report Builder 2.0, Erwin, Visio, Microsoft Visual Studio 2010/2008, Windows Server 2003, Microsoft BI Intelligence Suite, SQL Server 2005/2008,Reporting Services, Integration Services.

Confidential, Philadelphia, PA

SQL developer /SSIS /SSRS developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up & Recovery.
• Developed stored procedures, functions, views and triggers.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Transformed data from one server to other servers using tools like Bulk Copy Program.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• 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.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created indexes, constraints and rules on database objects.
• Automated Database Maintenance tasks by creating Jobs and Alerts through SQL Server Agent.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows XP Professional, SQL Server 2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2008/2005, ADO.Net, OLE DB, DTS Package, SSIS.

Confidential, San Diego, CA

SQL Server/BI Developer

Responsibilities:

• Gathered business requirements and system specification from business users and business analyst.
• Analyzed existing DB2 database for different business units and documented.
• Created physical and logical structure of the new data warehouse (SQL database) and process work flow by using MS Visio 2007
• Created several tables, views and stored procedures using SQL Server 2008 and Toad SQL.
• Developed several ETL packages and data flow tasks by using SSIS.
• Efficiently designed a data warehouse to store all the information from OLTP to Staging and Staging to Enterprise data warehouse at the center for analysis.
• Good Knowledge in Physical and Logical Data Modeling.
• Developed Data Models (logical and physical models) based on given models.
• Created SSIS (SQL Server Integration Service) packages to extract data from OLTP (DB2) to OLAP systems (SQL Server) and automated the process by scheduled Jobs to call the packages and Stored Procedures.
• Created SSIS Packages to load data from transactional system DB2 to staging (ODS) and staging to Enterprise Data-warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
• Designed package configurations, logging/auditing, package error/event handling, data error logging and checkpoint in SSIS Package model.
• Extensively used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Bulk data migration using SSIS from flat files.
• Created deployment utility to deploy SSIS packages over Production, QA and Local System.
• Developed several complex MDX queries and used those to build the reports by using SSRS.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Responsible to create all the SSRS report using Cube as data source.
• Developed several Ad-hoc reports and automated some of these Ad-hoc reports based upon business demand.
• Responsible for creating several SSIS scheduled tasks (JOBS).
• Analyzed the error output and error log of an automated process in case of failure of the process.
• Developed Corporate Overview Report (Summary) and ELS Report by writing Complex SQL queries, Stored Procedures and Expressions using SSRS 2008.

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, Windows Server 2003, DB2, Toad for SQL, Excel 2007, MS Visio 2007, Visual SourceSafe 2005.

Confidential, Dallas, TX

DATABASE/SQL SERVER DEVELOPER

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up & Recovery.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed source/target analysis of data structures & content.
• Converted crystal reports to SQL Server reports using Reporting Services.
• Published reports and dashboards on WEB.
• Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Used the SSIS ActiveX script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
• Created package configuration using environment variables.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• 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.
• Used data compression techniques for Back Up.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Performed CDC and Change tracking on OLTP systems.
• Created OLAP cubes & wrote MDX queries for user reports.
• Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: SQL Server 2008/2005, SSRS, SSIS, Business Intelligent Studio, SQL Server Management Studio, T-SQL, ODBC, Excel, Access, DTS Packages, Windows 2000/XP, Excel, Windows XP/2003 Server

Confidential, Houston, TX

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Gathered requirements and design of data warehouse entities.
• Conduct code walkthroughs and review peer code and documentation.
• Created and maintained the data mart for different LOB.
• Fine tuned of database objects and server to ensure efficient data retrieval.
• Developed complex programs using T-SQL queries, including Procedures, Triggers, and functions.
• Worked extensively on Data model and ERD.
• Used Visio for diagramming in the design phases.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Designed and developed SSIS packages, designed stored procedures, configuration files, tables, views, and functions.
• Created SSIS log files and configuration files to store configuration and to log execution of packages.
• Implemented complex transformations by creating custom transformations in addition to using built-in ones.
• Created and Configured OLAP Cubes using SSAS
• Performed Data Migration from SQL Server 2000 to SQL Server 2005.
• Assisted in defining Query for generating drill down reports in SSRS.
• Developed SQL Server Integration Services (SSIS) packages to transform data from various data sources to MS SQL 2005.
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Experience in using global variables, expressions and functions for the reports.
• Experience in handling parameterized reports in SSRS.
• Deployed packages from one environment to another (Development to testing to production).
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Created indexes, constraints and rules on database objects.
• Monitoring performance and optimizing SQL queries for maximum efficiency.
• Defined the sequence for the tables involved in import based on foreign key constraints.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Implemented best practices to maintain optimal performance and optimized SQL queries for maximum efficiency.
• Performed documentation of standards, best practices, and ETL procedures
• Work with developers, DBA, and systems support personnel in elevating and automating successful code to production.

Environment: Windows 2000 Server, Windows 2003 Server, Rational Clear Quest SSIS 2005, DTS, Oracle 9i/ 10g, SQL Server 2005, MS Access, T-SQL, PL/ SQL, SQL, Erwin 4.2, SSRS.

Confidential, Farmington Hills, MI

SQL Server developer

Responsibilities:

• Writing complex Stored Procedures to meet the business requirements.
• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives
• Frequent teleconferencing and e-mail communication with business leads from across the globe to understand business rules and data structure
• Creating tables, relationships, triggers and indexes for enforcing business rules
• Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Designing and building data load procedures, using MS SQL Server
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Configured product meta-data tables to support client data reporting needs.
• Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Written SQL scripts using joins, sub queries and correlated sub queries.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Involved in creating Technical Specification Document (TSD) for the project.
• Migration: copied production SQL Server 7.0 databases to test server running Windows 2000 Advanced Server and SQL Server 2000

Environment: SQL Server 2000, Transact-SQL, Active X, .Net, ASP, MS-Excel, Oracle 9i, MS Access, Windows 2000/NT/XP.

Confidential

MS SQL Developer/SSIS/SSRS

Responsibilities:

• Created stored procedures, scripts, views in Oracle database design and create SQL database, tables, indexes, and views.
• Created user defined functions, stored procedures, triggers, and suggested creating clustered and non-clustered indexes on tables for performance improvement.
• Used for data population from different sources and create DTS packages for data conversions and load data from flat flies or excel files.
• Created and used stored procedures for database transactions in SQL Server.
• Create database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing, data backups, fine tune complex SQL queries and stored procedures to increase performance.
• Extensively used XML documents to pass multiple parameters for stored procedures to read and write database table.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Worked on DTS Package, DTS import for transferring data from Oracle and lotus notes.
• Worked as a developer in creating complex stored procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, instances, linked servers and indexes.
• Extensively used enterprise manager, query analyzer, and SQL Server profiler to create custom and standard reports using crystal reports and also involved in database capacity plan.
• Created parameterized reports for the clients, based on requirements using SSRS and deployed reports on to the server for the end users.

Environment: MS SQL Server 2000, SSIS, SSRS, SQL Management Studio, SQL Server Business Intelligence tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler.