Sql Server Data
Resume:
Tony Yuwakittisit
acr3oc@r.postjobfree.com
Newark, DE
Professional Summary:
Over 7+ years of strong MS SQL Server Developer Experience in Healthcare, Insurance, Online-Marketing and Banking domain with expertise in Microsoft SQL Server 2014/2012/2008R2/2008/2005/2000) and Business Intelligence including SSIS, SSAS and SSRS.
2+ years of oracle developer experience in Oracle database 9i/10g/11g.
Expert in Analysis, Design, Development, Testing, Implementation, Administration and Maintenance of databases, data warehouses, data mining, reports and business intelligence applications.
Experience in all phases of Project Development Life Cycle both in SDLC and Agile methodologies (Requirement Gathering, Analysis, Architecture, Design, Building, Unit & Integration Testing, Migration and Training, Deployment and Production Support).
Excellent knowledge and experience in ER Modeling, Dimensional data Modeling, Star Schema and Snowflake Schema.
Highly proficient in the use of T-SQL/PL-SQL for developing complex Stored Procedures, Triggers, Tables, Views, Indexes, User Defined Functions, Relational Database models, Data integrity and SQL joins.
Experienced in creating complex SSIS packages to perform Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems (Oracle, DB2, MS SQL server, Flat file and XML).
Expertise in working on all activities related to designing, developing, implementing, testing and maintaining of ETL processes for large-scale Data Warehouses using DTS and SSIS with MS SQL server 2014/2012/2008R2/2008/2005.
Competent in working with multi-dimensional data model (OLAP cube) such as designing cube and dimension, creating measures measure groups, calculations, KPIs, actions, perspectives by using SSAS.
Good experienced in creating pivot tables and charts in Excel using power pivot with data sources in SQL Server, SSAS cubes, Access.
Experienced in creating standard and ad-hoc report using SSRS and proficiency in creating different types of reports such as, Drill Down reports, Drill through, Sub reports, Parameterized reports, Cascaded reports and Dashboard such as Graph, Chart, Gauge and Map using MS excel and Power BI.
Managed report by using SSRS tools such as report management, report delivery and report security.
Proficient in Database Performance Tuning, Query Optimization, Database consistency checks using the SQL Profiler, Index Tuning Wizard, DBCC, DMV and DMF.
Extensive knowledge and experienced in DBA jobs on MS SQL server such as backup and recovery, log shipping, database mirroring, database migration and security management.
Good team player, strong leadership and communication skills with self-motivation and multi-tasking abilities.
Demonstrated capability of learning new technologies in a short span of time, integrating well into any environment and working well in fast- paced environment and under pressure.
Good analytical and problem-solving skills and experienced in data analysis by using R programming, SAS, Excel, Python. (Master Degree Course Project)
Certification:
MCSA: SQL Server 2012
70-461 Querying Microsoft SQL Server 2012
70-462 Administering Microsoft SQL Server 2012 Databases
70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012
Education:
Master in Computer Science & Information Systems from University of Michigan-Flint, 2012
Master in Information Technology from King Mongkut’s University of Technology Thonburi, Bangkok, Thailand, 2002
B.S. in Communication Arts from Bangkok University, Bangkok, Thailand, 1997
Technical Skills:
MS SQL Server2014/2012/2008R2/2008/2005/2000,MS Access2010/2007, MS Excel2010/2007/2003, Excel VBA, Oracle9i//10g/11g, Windows Server 2000/2003/2008/2008R2/2012, MS Team Foundation Server2008/2010/2012, SQL Server Management Studio, Query Analyzer, System Performance Monitor, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Data Transformation Services (DTS), Business Intelligence Development Studio (SSIS, SSAS, SSRS), SQL Server Data Tools (SSDT), Power View, Power Pivot, Power Query, Tableau, SQLCMD, T-SQL, MDX, DAX, DMX, PL/SQL, Informatica, MS windows, C#, VB.net, ASP.net, Core Java, Powershell script, Unix script, Crystal Reports, HTML, XML, CSS, JavaScript, Jquery, MS Visio, Erwin, Data Modeling in relational database and data warehouse, R Programming, Python, SAS.
Professional Experience:
Bank of America, Simi vally, CA Dec 2014 – Sep 2015
MS SQL server/BI Developer (SSIS/SSAS/SSRS)
The project here was working in Loan modification group. Several kinds of report were created to display a list of loans. A lot of SSIS packages were used to extract data from other applications in order to create data warehouse for trial and perm evaluation. In addition, data mining was implemented to create predictive model for financial analysis.
Responsibilities:
Worked with data warehouse architecture to analyze, design and develop data mart database.
Created logical and physical data models for loan modification data mart database, which is created for accessing data from Web Portal.
Wrote T-SQL, designed and modified database objects such as Tables, Stored Procedures, and Functions for SSRS report requirement and ETL requirement.
Extracted, transformed and loaded (ETL) data from transactional databases including databases used for loan evaluation to loan modification Data mart for reporting purpose.
Created custom task, script task and script component to perform specific ETL jobs such as loading unstructured data by using C#.
Widely used Execute SQL task, Data Flow task, Execute Package task to create SSIS packages. The packages use transformations like Lookup, Derived Column, Conditional Split, Merge, OLEDB Command and etc. to migrate data.
Deployed .ispac file in DEV and PROD SSIS server and creating the DTEXEC Scripts (Command Line) to run the SSIS package directly on demand in different environment.
Involved in SSIS package deployment and maintenance. Created and managed package configuration in SSIS packages to support DEV, QA, UAT and PROD environments.
Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data.
Created MDX script for calculation processes in Cube using SSAS.
Developed various reports from OLAP Cubes to show different kinds of list of loans.
Generated data models and DAX on Power Pivot and developed dashboard by using Power View.
Created ad hoc report in order to identify unusual trends and activity.
Created complex financial trend and data analysis reports for decision-making management.
Responsible for ongoing maintenance, change management and report performance optimization on existing report.
Environment: Oracle11g, MS SQL Server 2012, Visual Studio2012 (.Net, C#), Windows server 2003, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, T-SQL, SQL-Profiler, Index Tuning Wizard
Fabric.com, Kennesaw, GA Jul 2014 to Nov 2014
MS SQL server/BI Developer (SSIS/SSAS/Crystal Report)
The project was to develop ClickStream Data Mart and Business Intelligence Solution from CoreMetrics Database in order to identify the behavior of web visitor and customer. The extra project was to convert all reports on RIB web application to Crystal Report.
Responsibilities:
Designed ClickStream Data Mart (Fact Tables, Dimension Tables) from CoreMetrics Database.
Created Fact Tables and Dimension Tables on development server and production server.
Implemented reverse engineering from ClickStream Data Mart by using Microsoft visio.
Created T-SQL scripts and SSIS packages to perform initial load and incremental load for Fact Tables and Dimension Tables on development server and production server.
Designed and Created OLAP cube from ClickStream Data Mart and added measures, dimensions, calculations to the cube.
Deployed OLAP cube to production server and configured security for cube.
Developed and implemented SSIS package to automatically update OLAP cube.
Wrote MDX queries to create calculated members in OLAP cube
Designed and developed SSRS reports from OLAP cube.
Gathered end user requirements regarding reports on RIB web application and checked which report is currently in use and want to be replaced by Crystal Report.
Created Crystal Reports to replace reports on RIB web application.
Environment: SQL Server, MS Visual Studio 2012, MS Visio, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, ETL, T-SQL, Crystal report 2011.
Partners Healthcare, Boston, MA Dec 2013 to Jun 2014
MS SQL server/BI Developer (SSIS/SSAS/SSRS)
The main project was to develop a Data warehouse that can exploit data from various sources and different locations such as health record, medical record, health insurance and clinical evaluation in order to support decision making by management and executive level in claim and billing department and accounting department.
Responsibilities:
Involved in database performance tuning by using Execution Plan, Clustered and Non-clustered Indexes to optimize queries.
Optimized database performance by using SQL Profiler for monitoring T-SQL code and stored procedures.
Analyzed detailed end user specifications. Designed and configured BI metadata layer.
Created SSIS Packages to import and export data between Flat files, Excel spreadsheet and SQL server 2008 (R2)/2012.
Designed and created data model for relational data warehouse.
Created partitioned table and index to support data loading between OLTP and OLAP system.
Created SSIS packages to transform raw data into information stored in tables.
Created SSIS packages to automatically update tables with monthly data using scheduled jobs.
Performed various SSIS Tasks such as Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task in order to load data into Data Warehouse.
Created script task and custom task to perform specific ETL jobs by using C#.
Designed and generated OLAP cubes. Built reports, dashboards and scorecards on OLAP cubes by using SSRS and Power View.
Modified and maintained cube Dimensions, Hierarchies and adding Aggregations to Cube.
Created perspectives to reduce the apparent complexity.
Wrote MDX queries to define calculations including calculated members, named sets. Created Key Performance Indicators (KPIs) to evaluate the result of claims.
Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using SSRS. Stylishly designed layout like Pie charts, Graphs and Linked Reports.
Generated Parameterized Reports and cascaded Parameterized Reports.
Created Powershell Script to render SSRS report and deploy SSIS 2012 packages ISPAC files.
Provided support for production deployments and automation. Assisted in monitoring, job control and production support. Provided second level support for production issues related to the BI environment.
Performed implementation and maintaining security in report development and report access at multiple levels including report groups, role-based and record level. Created report models for generating specific reports as per the client requirements and used row level security filters for report model.
Environment: MS SQL Server 2012, MS Visual Studio 2012, Windows server 2008/2012, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, T-SQL, SQL-Profiler, Index Tuning Wizard, Power View.
First American Home Buyers Protection, Santa Rosa, CA Jun 2013 to Nov 2013
MS SQL server/BI Developer (SSIS/SSAS/SSRS)
First American Home Buyers Protection is a leader in the home warranty industry that provides reliable, innovative and affordable home warranty plans. The project involved data migration from the old system to the new in-house application. There was a variety of reports created to support activities of the strategy planner teams. The effectiveness of the home warranty plans was analyzed using the detailed reports created using SQL server BI.
Responsibilities:
Worked with Payment Analysis, New Orders, Renewals, and Accounting departments to ensure the accuracy of data migration from the old system to the new in-house application called FALCON by utilizing SSIS packages.
Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
Created various database objects such as tables, views, stored procedure, function, trigger and index based on the requirements and business rules.
Performed performance tuning by using SQL Profiler, index tuning wizard and examined execution plans, created covering indexes and filtered indexes when necessary for tuning SQL queries.
Created SSIS Packages for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server.
Extracted data from disparate sources and loaded into staging database and data warehouse by performing extensive ETL operation.
Performed ETL Processes by using Informatica to prepare data for Java application in accounting department.
Wrote PL/SQL script to support Java application in accounting department.
Cooperated with DBA team to create Scheduled Jobs to run the SSIS packages every 15 minutes/24 hours for DEV, IT and UAT environment using Active Batch.
Took charge of developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, SQL Server automatic e-mail notification and SQL Server backup strategy.
Developed tabular models from relational data warehouse designed by data warehouse development team by using SSAS and coded DAX queries to retrieve from these data models.
Generated various reports with drilldowns, calculated members, dropdowns from the tabular model by connecting to Analysis server from SSRS.
Used various report items like tables, sub report and charts to develop standard and customized reports in SSRS to help tracking performance/productivity and other issues.
Created interactive Dashboard to show analyzed data by using Tableau.
Environment: MS SQL Server 2008R2/2012, Oracle11g, PL/SQL, Visual Studio 2010, Java Application, Windows server 2008R2/2012, SSIS, SSRS, SSAS, DAX, MS Excel 2010, OLTP, OLAP, T-SQL SQL-Profiler, Index Tuning Wizard.
Bank United, New York, NY Oct 2012 to May 2013
MS SQL server/BI Developer (SSIS/SSAS/SSRS)
Bank United is a savings and loan association . The goal of the project was to collect of data from heterogeneous database and integrate it into the SQL Server database as backend, also generate annual consolidated statement of operation/financial statements reports and deploy them on production server, and to cleaned up old server environment and set up new server environment. The extra project was about creating OLAP cubes and developed reports to support financial analyst.
Responsibilities:
Worked as part of an application development team; created structured code for integration into larger systems, documented work for maintenance in a production environment, created task lists, timelines and deliverables, worked to meet project schedules determined by others.
Created logical and physical data models for new requirements by using Erwin after discussion with technical team and application users as per agile methodology.
Designed and created SSIS packages to extract structured and unstructured data from various source systems such as OLE DB, Excel, flat files and XML, transformed the data to fit business performance management needs, and loaded it into new database server.
Involved in Deploying and Monitoring SSIS packages and also created dynamic configuration packages in SSIS to support different system environment.
Wrote T-SQL/PL-SQL, designed and modified database objects such as tables, views, triggers, indexes, Stored Procedures, defaults, function to meet the business and audit specifications.
Wrote CLR to develop database objects like stored procedures, triggers using C#.net.
Worked with Data warehouse architect to design and implement facts, dimensions and OLAP cubes.
Created SSIS packages to extract data from OLTP to OLAP data warehouse databases, and Scheduled Jobs to call the packages.
Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data. And developed various reports from OLAP Cubes for managing various securities and assets to meet specified investment goals.
Defined measure groups and dimensions attributes for a cube and dimension, created and deployed cubes to an instance of analysis services on the development server.
Wrote MDX queries to define calculations including calculated members, named sets. Created Key Performance Indicators (KPIs) to evaluate the business.
Created report based on those developed cubes and Designed and maintained view and stored procedure to retrieve data from data warehouse to create corresponding data set for the Reporting Services (SSRS).
Built advanced reports using query parameters, report parameters, user access restrictions, filters and interactive sorts.
Generated reports on assets information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
Environment: Oracle11g, MS SQL Server 2008R2/2012, Visual Studio 2005/2008 (.Net, C#), Windows server 2003/2008, SSIS, SSRS, SSAS, MDX, OLTP, OLAP, T-SQL, SQL-Profiler, Index Tuning Wizard
Hurley Medical Center, Flint, MI Sep 2011 to Sep 2012
MS SQL server/BI Developer (SSIS/SSAS/SSRS)
Hurley Medical Center is a public non-profit hospital serving Genesee, Lapeer, and Shiawassee counties in eastern Michigan. The project here was about redesign and database modification for claim and billing application system. Also Data mart and OLAP cube were created to support claim data analysis.
Responsibilities:
Generated database SQL scripts and deployed databases including installation and configuration.
Design and Build Extract Transform Load procedures in SQL Server to import/export data feeds to/from data warehouse.
Worked with SSIS to import, export and transform the data between the linked servers.
Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB data sources to SQL Server.
Designed and developed Packages using Lookup, Merge, Merge Join, Conditional Split, Aggregate and Export Column.
Created SSIS packages to extract data from OLTP to OLAP data mart databases, and Scheduled Jobs to call the packages.
Defined measure groups and further tuned dimensions attributes for a cube, created and deployed cubes to an instance of analysis services on the development server.
Modified dimensions in the cube, created hierarchy and relationships among attributes, wrote SQL expressions to define named calculation.
Defined different types of relationships between dimensions and measure groups and specified the properties of these relationships, such as referenced relationship, fact relationship and many-to-many relationship.
Wrote MDX queries to define calculations including calculated members, named sets. Created Key Performance Indicators (KPIs) to evaluate the business.
Created Drill-through, Drill-down, Cross Tab and Sub-Report using SQL Server Reporting Services (SSRS).
Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services (SSRS).
Worked on Stored Procedures and Database Triggers and business analytical functions.
Tuned the database to perform efficiently by managing databases using the option grow or shrink database files and monitor the size of transaction log.
Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
Used Microsoft Source Safe for version control and configuration management.
Environment: MS SQL Server 2012/2008R2, SQL Server Management Studio, MS Visual Studio 2010/2008, T-SQL, SSIS, SQL Profiler, Index Tuning Wizard, Microsoft Team Foundation.
Thai Agri Foods Public Company Limited, Bangkok, Thailand Jun 2007 - Mar 2010
MS SQL Server Developer/ SSIS & SSRS Developer
Thai Agri Foods Public Company Limited, the leading export food manufacturing companies in Thailand, is a food processing company providing frozen and canned food products that are processed hygienically from fresh materials, such as seafood, fruits, vegetables, etc. The scope of the project was to work on the project for the Sales & Marketing Team and create detailed reports for analysis and support the Sales & Marketing system.
Responsibilities:
Involved in gathering business requirements from the clients.
Translated business processes to applicable requirement types such as functional and technical specification.
Designed, created and analyzed data model and define metadata.
Created stored procedures, triggers, indexes, rules, integrity constraints, cursors, views and
ad hoc queries for the business logic.
Created SSIS packages and migrate DTS packages to SSIS packages for the data cleansing/ transfer and transformation.
Created and scheduled Jobs using SQL Server Agent. And created alerts for Error reporting.
Developed windows forms that connect to database by using VB.net.
Tuned SQL queries and stored procedures for better performance using Query analyzer, SQL Profiler and Index Tuning Wizard.
Wrote Stored Procedures for Reporting purpose. Also developed various reports using SQL Server Reporting Services.
Created users and roles for security purpose on the development server.
Developed custom and standard reports using Crystal Reports.
Environment: Oracle9i, MS SQL Server 2000/2005/2008/2008R2, MS Visual Studio 2005/2008, Windows 2000/2003, SSIS, SSRS, OLTP, T-SQL, Enterprise Manager/Query Analyzer, SSMS, SQL-Profiler, Index Tuning Wizard, Crystal Reports.
Bangkok First Engineering, Bangkok, Thailand Aug 2005 - May 2007
Visual Basic.net/ Database Programmer
Developed program specific routines for Inventory Management, Hotel Management System, Human Resource Management and Purchasing System.
Designed user interface screens for each system mentioned above and developed codes to manage data in database via application.
Designed and Created database and database objects for each system mentioned above by using MS SQL server 2000 or MS Access depend on scale of the data in each system.
Created DTS packages to load data from different kinds of source to MS SQL server 2000 or MS Access.
Bara Advanced Info Tech, Bangkok, Thailand Feb 2003 – July 2005
Account Manager
Responsible for finding new prospects, assess opportunities for solution selling (Oracle Database and ERP)
Coordinated with presales teams to develop projects’ scopes and prepare proposal.
Advised offering products/solutions to customers/prospects.
Provided product updates and technical advice to customers.
Coordinated and collaborated with channel partners to determine client requirements.
Contact this candidate