SUMMARY:

• A Microsoft Certified Professional with 9+ years of extensive experience in Database Solutions and BI Solutions using Microsoft Technologies.
• Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012/2014 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS).
• Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server based applications.
• Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.
• Build data visualizations and reports from DW and OLAP cubes using PowerBI, SSRS, and possibly Tableau.
• Excellent knowledge of performance tuning in tuning stored procedures, Queries using tools like SQL Profiler, Database Tuning Advisor, Execution Plans, DMV’s and Efficient coding standards.
• Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all etc...
• Strong knowledge and experience in error handling of SSIS packages using transactions, check points (package restart ability features), break points and error logging procedures.
• Experienced in Huge data migrations, huge data transfers, ETL processes using SSIS, DTS for Data warehouse implementation Projects involving conversion of data from heterogeneous sources like DB2, and Oracle, Sybase, Teradata.
• Highly experienced in full cycle of DTS/SQL server integration services (SSIS 2005/2008/2012/2014 ) Packages (Developing, Scheduling, Configuring, Troubleshooting and monitoring) for performing data transfers and ETL Purposes across different servers.
• Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Experienced in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2005/2008/2012/2014 across various environments.
• Expert in designing Crystal reports, Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 ) and Excel Pivot
• Migrated SQL Server 2008 database to Windows Azure SQL Database and updating the Connection Strings based on Azure.
• Created SSRS projects and reports in BIDS, sort and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.
• Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterized (Cascading parameters), TopN, Summary, OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2005/2008/2012/2014 .
• Extensive experience in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Highly skilled in developing OLAP cubes using SSAS 2005/2008/2012/2014, calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling DSV diagrams, Fact and Dimensions Tables using Analysis Services.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Developed cubes using Partitions added the Key Performance Indicators (KPI), partition aggregations, Perspectives, slow changing dimensions etc. and created various user roles.

TECHNICAL SKILLS:

BI Tools: SSIS, SSAS, SSRS, QlikView, Business Objects, Power BI, Business Intelligence Development studio(BIDS), Visual Studio, Crystal Reports 9.0, Teradata, Performance Point Server, ProClarity, SQL*Plus, SQL*Loader, Erwin, Jasper Soft Studio, Toad Data Point.

Databases: SQL Server 2005/2008/2012/2014, Access, MySQL, Oracle 10g, 11gOperating Systems: Windows Server 2003, 2007, 2010, 2013, Windows 8/NT/XP/Professional, MS-DOS, Red Hat Linux

Application package: MS Office Suite, Visio, Power BI, Azure.

Languages: T-SQL, PL/SQL, C/C++, HTML, XML, C#.Net, ActiveX, XML, MS Access, HTML, DHTML, Shell Scripting

Tools: SQL Server Enterprise Manager, SQL Server Management Studio, Team Foundation Server (TFS), SharePoint Sync

Protocol: FTP, TCP/IP, Named Pipes

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta GA

Sr. MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development.
• T-SQL development included queries using joins, sub-queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Build data visualizations and reports from DW and OLAP cubes using Power BI, SSRS, and possibly Tableau.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Experience in creating master and child packages, using package configurations (SQL Server) and SSIS logging.
• Work on creating scripts (Cache SQL) in Toad Data Point for data from IDX-GE Systems and Created Data extracts in SSIS.
• Created the ETL (SSIS) packages and ETL procedures scheduled them for Jobs.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Involved in Source Data Analysis and Designing Mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s.
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors.
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer.
• Used Fuzzy grouping transformation to consolidate data and submitted data cleansing reports to the client.
• Created custom Logging and Auditing framework incorporated in an SSIS package template that was used in the project's ETL packages.
• Identifying, and documenting ETL Standards and best practices for the development team.
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions.
• Hosted SSIS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Used Team Foundation Server 2010 to check in code artifacts and Techno solutions Top Team third party tool for process oriented tasks like assigning tasks, logging & assigning code defects, check in key decisions, documents etc.
• Implemented framework for Reference/Lookup data changes, Automation of Applying Database Change Request scripts to the target DB.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions. Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB,SIT, UAT, Data Reconciliation and validation.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client, SSIS introduction material to the client.
• Worked with Managers to prepare WBS for SSIS/Database development work.
• Implemented free text parser for FTP and web data feed in C# .Net
• Generated Custom ETL scripts using SSIS 2008 and unit test SSIS load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in migration and conversion of Reports from SSRS 2008 to 20012
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation.
• Deployment of SSIS packages to the Conversion Server.
• Create and configure SSIS logging to capture log-enabled events that occur at run time.
• Developed staging tables to house the data and developed exception/error handlers to prevent issues with data being written to the new DB within SQL SERVER SSIS.
• Used XML Package configurations to allow users to modify the package without using BIDS.

ENVIRONMENT: MS SQL Server 2010/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, Oracle 10g, Dashboard, Power BI, Azure, SQL Server Management Studio, Team Foundation Server (TFS), WAND PM, SQL Server Business Intelligence Development Studio (BIDS), Toad Data Point.

Confidential, Austin TX

Sr. MS SQL Database Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created the ETL (SSIS) packages and ETL procedures scheduled them for Jobs.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Involved in Source Data Analysis and Designing Mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL.
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Rewrite the existing code for long running queries by replacing cursors with various joins, common table expression (CTE) and indexing.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Created several tables, views using SQL Server management studio, based upon the functional specifications and primary key & foreign key constraint
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Implemented free text parser for FTP and web data feed in C# .Net
• Generated Custom ETL scripts using SSIS 2008 and unit test SSIS load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in migration and conversion of Reports from SSRS 2008 to 20012
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

ENVIRONMENT: MS SQL Server 2010/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, Oracle 10g, Dashboard, Power BI, SQL Server Management Studio, Team Foundation Server (TFS), Clarity PM, SQL Server Business Intelligence Development Studio (BIDS), GIT Extensions.

Confidential, Atlanta GA

Sr. MS SQL Database Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in Source Data Analysis and Designing Mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Extensively worked in data integration in developing ETL mappings and scripts using SSIS.
• Data migration (import & export - BCP) from Text to SQL Server.
• Implemented batch processing using Jobs and DTS.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources (SQL Server, Oracle, DB2 etc.).
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
• Designed the user interface screens and implemented application logic under the Microsoft .NET framework using C# to use .NET features powered with CLR.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting User Needs and Requirements from both technical and strategic views of an organization.
• Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
• Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source webi reports for the live office and changing the live office refresh option to pick from the latest instance.
• Formatted webi reports and scheduled them to be bursted as pdf to the report to web server.
• Modified the existing universes for performance tuning and maintained common dimensions across all the universes with unique naming as a part of clean up activity.
• Successfully tested all task in staging and stored all versions of data using Team Foundation Server (TFS).
• Upgraded InfoPath forms to 2010 and published it to SharePoint form libraries and Utilized excel web services and web parts to access the excel spreadsheet.
• Worked on rewriting the existing BO Webi reports into Jasper soft report using the redesigned data model.
• Created custom web parts using SharePoint Designer 2010 and Visual Studio 2010 templates.
• Developed Workflows for approvals using Office 2010 and SharePoint Designer 2010.
• Knowledge of developing reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

ENVIRONMENT: MS SQL Server 2010/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, Oracle 10g, Dashboard, Power BI, SQL Server Management Studio, Team Foundation Server (TFS), SQL Server Business Intelligence Development Studio (BIDS), Business Objects, Jasper Soft Studio, Power Designer.

Confidential, West Des Moines,IA

Sr. MS SQL Database Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Experience in SSIS script tasks, look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping.
• Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Improved data load performance by analyzing database design and query plans.
• Modified and Create Joins to Improve the Database and execution speed.
• Using Tableau server versions (7.0 and 8.2) as a front-end BI tool and Microsoft SQL Server 2012 as a back end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
• Worked with visualization tools such as Tableau in Building the Reports.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs by Using Tableau.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Designed and Developed matrix, tabular and parametric Reports using SSRS 2012.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Strong knowledge of managed claims management process, Knowledge of Medicaid and Medicare Services. CMS, Health Assessment Systems, Hl7 Standards, HIPAA, PPACA (Patient Protection and Affordable Care Act), Compliance issues, HL7 Message Validation, ICD 9, Electronic Health Records, Electronic Medical Records.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Involved in mock testing, Unit Testing and Integration testing in SSIS, SSAS.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server Analysis Services (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Published detailed guide describing data file content and structure for business partners; created quick reference guide for HIPAA EDI ASC X12 834 transaction set for Medicaid enrollment.
• Involved in Performance Tuning using SQL Server Profiler and SQL server Hints. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2012.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Used Team Foundation Server (TFS) for source control, and data collection.
• Used C# in Script Tasks (SSIS Packages).

ENVIRONMENT: SQL Server 2008R2, 2012,SSIS, SSRS, SSAS, Teradata, Visual Source Safe 2012, Erwin 4.0, QlikView, Power BI, MS Excel 2010, C#, Team Foundation Server (TFS), Windows Server 2010,Tableau.

Confidential, Atlanta, GA

Sr. SQL SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed and created databases, DB Objects based on the business requirements.
• Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Involve in create table-valued functions.
• Used joins and sub queries to simplify complex queries involving multiple tables.
• Provided technical support to move databases from development to test and production for multiple applications.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Improved performance of SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Worked with SQL server profiler to generate traces.
• Created SSIS script tasks, look up transformations and Data flow tasks using T- SQL, C# and Visual Basic scripts.
• Writing the stored procedures, checking the code for efficiency, Routine backups and restoration.
• Used SQL server business Intelligence Development Studio to designs SSIS packages to transfer data between servers and deploy the data.
• Scheduled the job to do this task periodically.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Developed Cubes using SQL Analysis Services (SSAS) and Dimensions using cube wizard and also Generated Named calculations and named queries.
• Deploying and scheduling reports using SSRS to generate all daily, weekly, and monthly and Quarterly Reports including current status.
• Involved in creating report datasets and using stored procedure parameters in SSRS.

ENVIRONMENT: MS SQL Server 2008, SSIS/SSAS/SSRS 2008, T-SQL, Visual Studio 2008/2010, QlikView, C#, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS).

Confidential, Chicago, IL

Sr. MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Created various database objects such as tables, indexes and views based on the requirement.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Developed Cubes using SQL Analysis Services (SSAS) and Dimensions using cube wizard and also Generated Named calculations and named queries.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to analysis server from SSRS (2005/2008).
• Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created data sources, connection strings and defined the datasets for generating the report.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Migrated Crystal reports to SSRS reports.

ENVIRONMENT: T-SQL, PL/SQL, MS SQL Server 2005/2000, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports.

Confidential

MS SQL Developer/BI developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• Actively participated in gathering of Requirement and System Specification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Wrote Transact SQL utilities to generate table insert and update statements.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE)
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

ENVIRONMENT: SQL Server 2008/2005, T-SQL, .Net, Microsoft Framework 2.0, Erwin, MS Visio.