Tom Dai Email & Phone Number

Mansfield, Ma

• Created SSIS package to load data from Flat File, and Excel to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, and Slowly Changing Dimension.• Tested, Cleaned and Standardized data records.• Imported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package. • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures• Wrote complex SQL queries using joins, sub-queries and correlated… Show more • Created SSIS package to load data from Flat File, and Excel to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, and Slowly Changing Dimension.• Tested, Cleaned and Standardized data records.• Imported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package. • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures• Wrote complex SQL queries using joins, sub-queries and correlated sub-queries to retrieve data from the database.• Created/Updated database objects like tables, views, stored procedures, function and packages.• Generated Drill down, Drill through, Matrix, parameterized reports using SSRS.• Designed and developed monthly, quarterly and yearly reports.• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance. • Used SQL Server Profiler to trace the slow running queries and the server activity. • Automated and enhanced daily administrative tasks including database backup and recovery. • Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery. Show less

Greater Boston Area

• Gathered requirements from the business users, created technical specification documents• Developed SSIS packages to migrate and integrate multiple data sources into dimensional tables.• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules.• Designed and implemented Stored Procedures and Triggers for automating tasks.• Wrote T-SQL queries, Store Procedures and used them to build packages.• Installed MS SQL Server 2008 and Management tools using… Show more • Gathered requirements from the business users, created technical specification documents• Developed SSIS packages to migrate and integrate multiple data sources into dimensional tables.• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules.• Designed and implemented Stored Procedures and Triggers for automating tasks.• Wrote T-SQL queries, Store Procedures and used them to build packages.• Installed MS SQL Server 2008 and Management tools using MS SQL Server Setup Program. Designed and developed packages for a data warehousing and Data Migrations projects using Integration services. (SSIS) on BIDS. • Extracted the data from Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS.• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2008.• Created reports using SSRS 2008 from the OLAP cubes for end user analysis.• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources. • Tested required queries and reports before publishing.• Scheduled the reports on capacity levels of different servers to run on daily/weekly monthly basis and email the results to the business users in the required format.• Added/modified Users, Groups, folders and rights. Show less

Greater Milwaukee Area

• Responsible for ETL Operation, which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS) worked with users. • Created Stored Procedure and Reports SSRS 2005 for one of their existing Management System (Suspect Loan).• Developed Dynamic packages using SSIS.• Created star schema and snowflake schema in SSAS and developed SSRS reports based on the cubes designed in the Data warehouse.• Created SSIS packages to pull data from flat files,… Show more • Responsible for ETL Operation, which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS) worked with users. • Created Stored Procedure and Reports SSRS 2005 for one of their existing Management System (Suspect Loan).• Developed Dynamic packages using SSIS.• Created star schema and snowflake schema in SSAS and developed SSRS reports based on the cubes designed in the Data warehouse.• Created SSIS packages to pull data from flat files, FTP server, Excel and schedules using SQL server agent.• Developed and maintained stored procedures for front end development.• Developed formatted, complex expressions for reports with advanced features such as conditional formatting. • Generated parameterized, Drill-Through as well as Drill-Down reports for the internal users as well as the company clients.• Did extensive Unit Testing on the reports before assigning to QA personnel. Show less

Greater Minneapolis-St. Paul Area

• Created Stored Procedures, SSIS packages, user defined functions, triggers, tables, and views and other SQL joins and statements. • Created Clustered and Non-Clustered indexes on tables.• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.• Created SSIS Packages to import and export data from Excel, XML and Text files.• Identified slow running query and optimization of stored procedures and tested applications for performance… Show more • Created Stored Procedures, SSIS packages, user defined functions, triggers, tables, and views and other SQL joins and statements. • Created Clustered and Non-Clustered indexes on tables.• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.• Created SSIS Packages to import and export data from Excel, XML and Text files.• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler. • Created database, tables and procedures to update and clean the old data.• Extensively used Query Analyzer, and SQL Server Profiler. Show less

Kansas City, Missouri Area

• Gathered requirements from the business users, created technical specification document.• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules.• Wrote T-SQL statement using DML and DDL for retrieval of the data.• Managed all indexing, debugging, optimization and performance tuning using T-SQL.• Wrote T-SQL queries, store procedures, functions, views and triggers.• Performance tuning to optimize SQL queries using query analyzer.• Used SQL… Show more • Gathered requirements from the business users, created technical specification document.• Created/modified SQL Joins, sub-queries, and other T-SQL implement business rules.• Wrote T-SQL statement using DML and DDL for retrieval of the data.• Managed all indexing, debugging, optimization and performance tuning using T-SQL.• Wrote T-SQL queries, store procedures, functions, views and triggers.• Performance tuning to optimize SQL queries using query analyzer.• Used SQL Profiler for tracking execution time of T-SQL Statements.• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.• Scheduling and managing jobs on MS SQL Server.• Created indexes, constraints and rules on database objects.• Documenting design, and implementation. Show less

Master Of Science (Ms), Information Technology, 3.5

Bachelor Of Science (Bs), Management Information Systems, 3.3