Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. Be sure to respond with the years of experience for each skill and the last time each skill was used.

Add or delete rows, as needed.

• SQL Server Integration Services SSIS packages
• ETL processes internal/external sources
• Strong experience with data transformation
• SQL Server 2005
• Experience in interacting with customers regarding application requirements
• Developing error checking and resolution routines Unit and system testing
• Convert other Databases to SQL
• Load data to OLAP databases
• Familiarity with eScholar CDW
• Knowledge of and experience working with education data

Confidential

MS SQL Developer/BI Developer

Responsibilities:

• Wrote stored procedures and queries for creating reports from data marts.
• Worked with various report items like tables, matrices and image.
• Created reports with drill down, drill through, cascading parameters, conditional formatting, interactive sorting, dynamic grouping functionalities and custom assembly
• Formatted reports to export to Excel as well as to print.
• Published reports to testing and production environments and facilitated the testing process.
• Responsible for resolving report defects in the dashboard application.
• Responsible for creating SSIS packages to load data to dimension and fact tables in SQL Server data mart.
• Responsible for adding new fact and dimension tables to data mart using SSIS.
• Worked with different control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks.
• Involved in complete life cycle of ETL process from loading data to generating acknowledgment files.
• Extensively used SCD, derived column, union all, conditional split, audit, script, lookup, copy column, row count in SSIS packages.
• Created Deployment Manifest folder to deploy SSIS packages in production.
• Responsible for scheduling SSIS jobs using SQL Server Agent
• Responsible for writing stored procedures for widgets in dashboard application.
• Optimized queries using Database Engine Tuning Advisor and SQL Profiler.
• Developed SQL scripts to transfer data from development to testing environments.
• Created database objects like tables, views and indexes, user defined functions and triggers.
• Responsible for creating SSAS cubes and deploying them.
• Created partitions, perspectives, calculations and hierarchies.
• Responsible for creating calculations and named sets using MDX.

Environment: MS SQL Server 2005/2008, ETL, MS Visual Studio 2005, Windows XP Professional, Subversion, MS SharePoint, SQL Server Reporting Services SSRS 2005/2008, SQL Server Integration Services SSIS 2005/2008, SQL Server Analysis Services SSAS 2005/2008, Performance Point Server.

Confidential

MS SQL Developer/BI Developer

Responsibilities:

• Worked in gathering the user requirements, Involved in meetings, reviews and prepared detailed design document
• Responsible for performing basic developer task like creating, altering and dropping tables.
• Generated reports using and Crystal Reports.
• Created SQL Server Integration Service SSIS packages between enterprise databases and Third party data source to transfer data.
• Managed and executed SSIS packages by designing ETL architecture for overall data transfer from the source server to the data warehouse.
• Written Stored procedures related to the modules using data adapters for reporting those xml documents on the web forms using XSLT.
• Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
• Handled slowly changing dimensions to maintain history of the data and created cubes and dimensions using SSAS
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Written, Tested and Debug stored procedures using T-SQL for the data layer using SQL Server data adapter and performed tuning the SQL queries
• Created Ad hoc reports using SSRS And also Created Subscriptions and scheduled reports using subscriptions.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Environment: MS SQL Server 2005, ETL, SQL Server Integration Services SSIS 2005, SQL Server Reporting Services SSRS 2005, SQL Server Analysis Services SSAS 2005, Visual Studi.Net 2005, MS Access, T-SQL, SSRS, XSLT.

Confidential

MS SQL Developer/BI Developer

Responsibilities:

• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
• Developed T-SQL DDL-Data Definition Language, DML-Data Manipulation Language statements using dynamically generated SQL.
• Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
• Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2008.
• Generated daily, weekly and monthly reports using SSRS 2005.
• Developed measures and dimension members using Multi Dimensional Expression MDX to meet additional needs that were calculated from existing measures. Implemented the calculations to aggregate physical measures using management studio.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression MDX to access them.
• Created business critical KPIs using SQL Server Analysis Services SSAS representing aggregations hierarchically and using custom groupings that the company will use to analyze performance.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues. Established a sound backup and recovery policies and procedures.

Environment: ETL, MS SQL Server 2005/2008 Enterprise Edition, SQL Server Analysis Services SSAS 2005/2008, SQL Server Reporting Services SSRS 2005/2008, SQL Server Integration Services SSIS 2005/2008, Data Transformation Services DTS , T-SQL, VB Script, Windows Server 2003, Erwin 4.0.

Confidential

MS SQL Server Developer/SSRS/SSIS Developer

Responsibilities:

• Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
• Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
• Involved in complete life cycle of ETL process from loading data to generating acknowledgment files.
• Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
• Involved in working with eScholar CDW.
• Used various SSIS tasks such as conditional split, derived column, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS to send information to different primary vendors, clients, and managers.
• Generated ad hoc reports using MS Reporting services and crystal reports.

Environment: MS SQL Server 2005/2000, T-SQL, ETL, SSRS 2005, SSIS 2005, DTS, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access, Crystal Reports.