SUMMARY

• SQL Server database Developer and Administrator in a wide variety of software applications.
• Particularly, client/server applications and relational databases using MySQL, MSSQL Server, Postgresql, Oracle; design Star Schemas, Snowflake Schemas and migration database projects, close interaction with the DB manufacturers, health care, business services…on Windows and Unix/Linux systems.

PROFESSIONAL EXPERIENCE

Learn Software QA Testing

Confidential

Responsibilities:

• Build database architecture and schemas for new projects and requirements.
• Analyze customer s operation, current systems and technologies to implement new database schemas.
• Develop database systems by developing data flow diagram.
• Build, install and maintain database from logical to physical structure and functional capabilities, back - up and recovery specifications.
• Develop the ETL packages to transform data from raw data to production data by SSIS, T-SQL.
• Analyze and design automation for ETL and ELT.
• Involve in analyze and design database for internal applications.
• Build and run query on Teradata and PDW.
• Build SSIS package to extract data from Teradata and other source, transform and load to PDW.
• Build dynamic query for ETL automation.
• Create variables to pass setting data from database to ETL package for automation.
• Create Stored Procedures with parameters to process updated data as automatically.

Technologies: MSSQL Server, Teradata, Big Data with Kimball Data Warehouse architecture, Parallel Data Warehouse (PDW), SSIS, SQL, Git Extension, Source Tree, Teradata SQL Assistant.

SQL Developer and DBA

Confidential

Responsibilities:

• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins using T - SQL, PostgreSQL
• Develop the ETL packages to transform data from raw data to production data by SSIS
• Schedule the DTS/SSIS package for migration data from legacy system on MS SQL 2008, 2012, 2014.
• Maintain of Stored Procedures to improve performance of different front end Applications.
• Work on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers from SQL-Server to RDBMS like PostgreSQL
• Design database architecture from logical to physical models
• Extract the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate or staging Database using the SSIS.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Experience in Developing and Extending OLAP Cubes, multiple dimensional data source view.
• Develop complex stored procedure using T-SQL to generate Ad hoc reports using SSRS and T-SQL programming.
• Schedule the Reports to run on hourly, daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports
• Prepare the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Interact with the business users to gather information about the report.
• Create numerous sub reports, drill down reports as part of the project according to business requirements using PostgreSQL, Reporting Services (SSRS 2012/2014).
• Design multiple stored procedures for the Report data sources.
• Create and maintain User Security/Permission
• Migrate the database objects from one server to another server between SQL Server databases and PostgreSQL databases.
• Work with plan administrators to research and resolve data issues and troubleshoot system problems/outages.

Technologies: Big Data, PostgreSQL, MySQL, MSSQL Server 2012, 2014, SSIS, SSRS, T-SQL, XML, Visual Basic, C# in SSIS/SSRS, ASP.NET MVC, Rake, Win Server 2008, 2012, Inmon Datawarehouse.

Database Developer and Database Architecture

Confidential

Responsibilities:

• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans.
• Worked with Technical Architects and Business Analysts to design database architects and report.
• Populate or refresh OLAP database for report on dashboard by running ETL automation processes for user acceptance testing and loading history data into OLTP database.
• Develop ETL processes by T - SQL scripts to add the logic by getting the related data from the multiple sources.
• Design the functional and technical documents.
• Create report templates and reporting standards for the developers to work on the report development with T-SQL.
• Develop Cubes and Regression Statistic using T-SQL programming
• Create MDX queries to create cube by T-SQL programming.
• Refreshing the cube to get the latest information updated for OLAP databases.
• Extract, Transform and Load data to dashboard as Business Intelligence Web applications.
• Use Talend Open Studio tool is used to clean data and import raw data to SQL Server.
• Use parameters to communicate between Talend and SQL Server and configure Talend to run ETL as automation tasks.
• Shell scripting use to call Talend automation tasks and refresh ETL tasks.
• Analysis and Design Logical and Physical Data Modeling, import, export, backup, restore, migration... databases.
• Python programming for Geocode location.
• SQL Programming as stored procedures, functions, views, triggers, index, constraints, statistics on relational databases.
• Database server administration, query optimization, stored procedure development and performance analysis.
• Create Entity-relationship and UML diagrams will be employed to model new data import in batch scripting scenarios, combined with command-line scripting in order to transfer, validate and import new information.
• Interface with subject matter experts, customer IT departments and business intelligence experts on a daily basis.
• Self-starter and strongly motivated to operate within this small and rapidly growing Toronto office.

Technologies: Microsoft SQL Server 2000/2005/2008/2012/2014, SSRS, SSIS, SSAS, MySQL, Unix, Talend, Crystal Report, Spy Schema modeling tool via ER diagram, OLTP, OLAP, DML, and DDL, T-SQL, Python, Java, Unix scripting, Kimball Data Warehouse methodology.

SQL Developer and DBA

Confidential

Responsibilities:

• SQL programming as Stored Procedures, Functions, Views, Triggers in SQL language to do ETL, import/export data to/from database for aviation application written in Java language.
• Technologies: programming on MSSQL Server 2005/ 2008/ 2008 R2, SSRS, SSIS, SSAS, SQL Server Management Studio, Oracle, Java, Tomcat, Eclipse, JIRA.
• Performs all activities required to support the Information Systems Service Desk; lead and guide day to day operations of IT Help desk.
• Provides remote support over the phone, through email or remote desktop control.
• Supports after hours IT Help desk activities by being the on - call support analyst to respond to issues within 15 minutes 24 hours a day on a rotation basis.
• Creates user accounts in AD, Blackberry and other applications as required for new staff and updates access rights for existing staff.
• Backup/Restore data and database.
• Printers: Install, troubleshoot issues, Sharing and Security, Maintenance
• Windows Server 2003: Administration/Troubleshooting/Configuration
• Group Policy Administration/Creation/Deployments
• Basic Network troubleshooting
• Windows2000/XP/7 Installation/Configuration/Troubleshooting/Administration
• MSSQL Server /Client side administration/configuration
• Project Management for the IT Help desk
• Contacts vendors for product information, pricing and support as required.

ASP/ASP.NET Web Developer

Confidential, Colleyville, TX

Responsibilities:

• Technologies used: ASP, ASP.NET, ADO/ADO.NET, C#, T - SQL, MSSQL 2008/2008 R2 SQL Server Management Studio, .NET framework 3.5, IIS, Visual Studio 2008/2010 with Visual Studio Management.
• Databases: MSSQL 2005/2008, using stored procedure, trigger, function, batch.
• Operating Systems: Windows Server 2008.
• Write code and calculations for all applications.
• Designed and implemented the database.
• User interface: Designed the GUI and all Web form.
• Created and edited documentation for the flow of the GUI.
• Created all stored procedures, triggers, and views.
• Ensured the integrity of all data and calculations, and made changes as necessary.
• Debugged and maintain the Sterling web application for accounting and financial organization. The YTS Web application is health care web application using in hospital manage

Application Developer

Confidential, Redmond, WA

Responsibilities:

• Develop, test and maintain modules for a manufacturing information system of Screen Designer, Inventory projects.
• Technology used: VB 6.0, COM, ADO, OLE DB, T - SQL, MSSQL 7.0/2000/2005, Visual Studio 6.0, Visual Studio 2008 as coding language, MS Dynamics
• Database: Oracle and MSSQL 2000/2005 database.
• Writing code and calculations for all application.
• User interface: Designing and implementing database and designed the GUI and all Web forms
• Created and edited documentation on the flow of GUI
• Creating all stored procedure, triggers.
• Ensured the integrity of all data and calculations and made changes as necessary
• Debugging the program and Preparing it for Presentation The Screen Designer is the latest project I worked on at VMC, Redmond. The software is a tool for engineers to design graphical user interface with bitmaps as pictures or text, the screen is used
• ETL, develop, maintain and do administration on manufacturing information system with Access, MSSQL Server 7/2000, 2005, Oracle 7, 8, 9, C, C++, Visual Basic, Classic ASP, Java Script, VB Script, Shell Script on Unix...Windows administration, network management and help desk for more than 500 workstations.
• Manage large Oracle and MSSQL databases Server for about 500 workstations.
• Support users in office and manufacturing system in 24/7 with helpdesk, network, hardware, software