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.
• Experienced in database administration tasks like Installing, Configuring, Managing, Monitoring and Troubleshooting MS SQL Server 2000/2005 on Windows NT, 2000 and 2003 servers.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Experience in Data Warehouse and RDBMS concepts as SQL Server database & BI Developer.
• 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.
• Experience in developing complex stored procedures using Cursors and Temporary tables.
• Good knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Good working experience in 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.
• Experience in designing and creating Report templates, bar graphs and pie charts.
• Expertise in upgrading or migrating from DTS to SSIS packages and resolving complex issues SSIS.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP and XML).
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc
• Experience 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.
• Expert in configuring report server using reporting services configuration manager and developing & deploying Complex Reports in SSRS.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Expertise includes FACT & Dimension Tables.
• Experience in SQL Server Analysis Server MDX Queries.
• Expert in maintaining Error logging using Exceptional Handling in SSIS.
• Experience in creating Scorecards/Dashboard Pages in SSRS.
• Experience in creating BCP transferring the data from one server to another server.
• Used DBCC utilities to check the performance of the databases.
• Deploying Reports to TFS server in Development and test environments.
• Experience Team Foundation Server (TFS) for version control, source control and reporting.
• Developing complex stored procedures using Cursors and Temporary tables.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Excellent communication skills, both oral and written and pleasing interpersonal skills.

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, SAP BO

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

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, LINUX, UNIX.

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

PROFESSIONAL EXPERIENCE

Confidential, Thousand Oaks CA

SQL SERVER DEVELOPER

Responsibilities:

• Worked Extensively on SQL Server 2008, Integration Services and Reporting Services.
• Used SQL Server 2008 Reporting Services (SSRS) for generating various different kinds of reports such as Tabular, Freeform, Drillthrough, Drilldown, Charts, Graphs, Cascading, Subreports and Parameterized Reports.
• 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.
• Developed stored procedures, functions, views and triggers.
• 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.
• Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.
• Worked with reporting stored procedures and views.
• Report Builder 2.0 used for creating business Model for the Ad-Hoc reports.
• Used SharePoint Enterprise Portal for hosting Scorecards and SSRS Reports.
• Worked extensively with client/business gathering requirements to generate customized SQL Reports (Subscriptions Created).
• Used SQL Server profiler and Performance Monitor for auditing, analyzing and performance tuning of ETL Loads and Reports processing.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Performed Error logging using Exceptional Handling in SSIS.
• 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 with front-end application developers to understand their requirements and create Procedures and Reports.
• Formatted the reports using Global variables and expressions.
• Automated Database Maintenance tasks by creating Jobs and Alerts through SQL Server Agent.
• Used Event Handlers for Exception Handling in SSIS packages.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

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.
• 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 the SSIS to extract Data from Databases such as Oracle and Access database, flat files to centralized IT destination.
• 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.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• 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.
• Worked on Normalization and De-Normalization techniques.
• 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.
• Built Conceptual, Logical and Physical data model.
• Created the logical model for the EDW with approximately 75 entities and 1000 attributes using ER Studio.
• The logical model was fully attributed till 3rd normalization and contains both current and history tables.
• Data model is divided in number of sub models for the ease of understanding and comprehension.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Created technical specifications report by gathering information from end user.
• Written SQL scripts using joins, sub queries and correlated sub queries.
• Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
• Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements.
• Created rationalized domains to bring consistency in the tables.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.

Environment: Windows XP Professional, SQL Server 2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2008/2005,OLE DB, DTS Package, Erwin 7.3, ER Studio 7.1.1/8.0.3

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 several tables, views and stored procedures using SQL Server 2008 and Toad SQL.
• Developed several A 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.
• 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.
• Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
• Involved in creating Cubes using SQL Analysis Services (SSAS)
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting, Conditional Split, Derived column.
• Participated in business requirement gathering sessions.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• 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, and 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.
• 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.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).
• 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:

• 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.
• Published reports and dashboards on WEB.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• 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.
• 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.
• 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 PPS Dashboard for the business using SSAS OLAP database and integrated with SharePoint.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).
• 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

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 creates 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.