SUMMARY:

• Over 6 years of U.S. experience in SQL, ETL, Reporting, and BI development in various industries such as Insurance, Transportation, Healthcare, and Manufacturing .
• Expertise in programming languages including SQL, C#, Visual Basics, Shell Script, Python, SAS, and R.
• Proficiency in developing SQL Server objects such as stored procedures, user - defined functions, views, triggers, temp tables, and table variables to meet complex business requirements.
• Excellence in performance tuning in SQL Server to increase its efficiency, which including the optimization of queries and store procedures, and the creation of additional indexes and partitions to reduce execution time.
• Expertise in performing ETL (extracting, transforming, and loading) process using different BI tools, such as SQL Server and SSIS (SQL Server Integration Services).
• Skills in designing complex reports, dashboards using different tools, such as SSRS (SQL Server Reporting Services), Power BI, and Tableau.
• Exceptional interpersonal and communication skills to effectively communicate with both internal and external project-related stakeholders to discuss any concerns, issues, and gather relevant project requirements.
• Hands-on experiences in learning and adapting into a new and dynamic environment implementing different technologies and methodologies.

TECHNICAL SKILLS:

Database: SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, Microsoft Access, Oracle Database 11g, PostgreSQL 10.10, MySQL 5.6

Data Warehouse: Kimball and Inmon

Data Modeling Tools: Lucid-charts, Draw.io

Business Intelligence Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT), SQL Server Management Studio (SSMS), Power BI, Tableau, Visual Studio

Programming Languages: Python, R, SAS, C#, Visual Basic, Shell Script, T-SQL, PL/SQL, PostgreSQL, MySQL

Cloud Services: Microsoft Azure, AWS, Hadoop

Data Analysis Tools: SAS, R, SPSS, SAS Enterprise

SDLC Methodology: Agile, Scrum, Sprint, Waterfall

Tidal Scheduling & Work Automation: SQL Server job Agent, GIT, Control M, SSRS Report Subscription

Project Management Tools: Trello, LeanKit, JIRA

IDE & Text Editor: Spyder, PyCharm, Notepad ++

Version Control Tools: Team Foundation Server (TFS), GIT

PROFESSIONAL EXPERIENCE:

SQL/ETL DEVELOPER

Confidential, Boston, MA

• Conducted the JRD (Joint Requirement Development) session with business users to discuss complex business rules such as data descriptions, calculation formulas, etc., to generate requirement documentations.
• Discussed future tasks and updates on current projects in weekly Sprint meetings and daily scrum meetings with other team members, team lead, and scrum master / project manager, and provided inputs on expected deadlines, designs, and enhancements.
• Developed stored procedures, CTEs, and dynamic SQL for each business requirement to build and implement business logic.
• Developed views, temp tables, and table variables to facilitate efficient data manipulation and data consistency.
• Wrote complex queries using aggregate function, window function, analytic function, ranking function, string function, and system function to complete complex business calculations and requirements.
• Added additional constraints, such as key constraints, not null constraints, default constraints and check constraints to keep data integrity.
• Created additional tables, columns, indexes, and partitions to adjust the database and data warehouse structures for better usage.
• Performed code reviews on queries, stored procedures, and views to make necessary suggestions, such as removing correlated subqueries, recompiling stored procedures, using inner joins instead of in clause, to optimize the programming code.
• Set up Tidal Scheduling tools, such as SQL Server job agents to perform repetitive tasks, such as ETL packages, transactional statements, etc.
• Performed version control works using Shell scripts, such as pull, clone, to create new directory and new document.
• Mapped the data from source tables, which include the database, Excel, flat files, etc., to data warehouse or data mart tables.
• Created, developed, updated, deployed, and scheduled ETL packages from different sources to the data warehouse using SSIS.
• Utilized control flow tasks and data flow transformations to perform data cleansing, data transformation, and data integration from different sources such as Excel, flat files, XML, and OLEDB into the desired destinations.
• Wrote C# scripts to set up the XML destinations, customized error outputs, and other features inside the script task and script component in SSIS.
• Set up parent-child packages, sequence containers, and other tasks to establish the appropriate ETL workflows at control flow level.
• Set up checkpoints, customized loggings, event handlers, and data viewers to monitor the SSIS package process.
• Deployed several SSIS packages in project mode and set up the relevant environment in the SQL Server.
• Performed testing on SSIS packages, SQL Server objects, or any relevant programs to uncover bugs, and troubleshot all possible issues and errors before the application launches.
• Created, tested, deployed, and subscribed several SSRS reports with features such as cascading parameters, drill-down, drill-through, and pivot tables for the end-users.
• Wrote Visual Basic coding language in SSRS expression tabs to set up various customized features such as alternating row color, conditional formatting, etc.

SQL/ETL DEVELOPER

Confidential

• Developed new features within the Agile team environment and contributed ideas and suggestions during the team meetings.
• Consulted with business users about requirement documents, like data descriptions, data cleansing rules, and calculation formulas for complex business rules.
• Created new SQL Server objects and modified existing ones, such as stored procedures, views, functions, triggers, and other technologies to solve complex business requirements or to improve their efficiencies.
• Operated performance tuning by creating additional indexes and partitions to the database and data warehouse.
• Established table constraints, such as data types, different types of keys, null values, default values, and check to keep data integrity.
• Wrote complex queries using CTEs, subqueries, variables, and other necessary objects from the SQL Server.
• Performed code reviews to analyze inefficient or incorrect queries, and provided suggestions for optimizations or debugging purposes.
• Scheduled SQL Server job agents to perform recursive tasks, such as DML statements, backups, incremental loads, and etc.
• Created or updated existing ETL packages for both initial and incremental loads from different sources, such as Excel, flat file, XML, and OLEDB, into the ideal destinations using SSIS.
• Implemented stored procedures in many purposes, such as to perform DML statements in SQL Server, to establish datasets/ data source in ETL and reporting packages.
• Performed data cleansing, data transformation, and data integration from different source types in different task scopes, such as control flows and data flow transformations.
• Developed reports and dashboards packages with subscriptions using SSRS with features such as cascading parameters, drill-down reports, drill-through reports, and pivot tables.
• Performed troubleshooting for SQL Server objects, ETL and reporting packages, and provided solutions or suggestions to eliminate bugs or to solve issues by analyzing the project and business requirements.
• Demonstrated exceptional interpersonal and communication skills, which improved team collaboration.

SQL/BI DEVELOPER

Confidential, St. Louis, MO

• Dedicated to the Agile methodology proposed ideas and suggestions during team meetings with the team lead, the project manager and team members.
• Determined the technical requirements by analyzing daily operations, applications, and programming, as well as communicating with business users.
• Created and modified tables and columns by utilizing the normalization and de-normalization skills into the existing database and data warehouse and established appropriate constraints and relationships.
• Pictured the general database and data warehouse structure by utilizing the data modeling and dimensional modeling skills.
• Created queries, views, user-defined functions, and stored procedures that are used for front-end applications, such as websites, desktop applications, and cloud applications.
• Operated performance tuning by creating additional indexes and partitions to improve future execution efficiencies.
• Optimized existing queries, stored procedures, views, and other SQL Server objects to make necessary updates to improve efficiencies.
• Set up SQL Server job agent for automation, such as automatic email notifications, scheduled tasks, transaction statements, etc.
• Stored, retrieved, and manipulated the data from the existing database and data warehouse for analysis of system capabilities and requirements.
• Created ETL packages to extract data from various sources, perform transformations in different scopes, and load into the desired destinations using SSIS.
• Utilized SQL Server objects in many places such as to establish data source for ETL and reporting packages, to link the SQL Server to the front end, etc.
• Troubleshot existing SQL Server objects, SSIS and SSRS packages, and provided solutions and suggestions to eliminate problems by analyzing the project and business requirements.
• Communicated with the team lead, informed of any updates, provided detailed project reports, gathered feedbacks, and worked to resolve concerns or issues.
• Explored and proposed new technologies, tools, and methods that quality assurance the team that could use for all kinds of purposes during team meetings.

SQL/BI DEVELOPER

UniGroup Fenton, MO

• Played a key role in the process of gathering new business requirements with Agile methodology. Proposed critical ideas and constructive suggestions to the team lead, members, and the analytical team during the Joint Requirement Development Meeting.
• Informed the project manager on a regular basis to provide updates on current projects, discussed any concerns, and gathered feedbacks to resolve issues.
• Created the ER diagrams by utilizing the data modeling and dimensional modeling knowledge using Lucid charts, and Draw.io .
• Created tables, views, CTEs, temp tables, table variables, and other SQL Server objects to complete the given business tasks.
• Created table constraints to keep data integrity, and to establish relationships between existing tables.
• Implemented the data query language (DQL) to write queries to meet complex business requirements, or to be used for future developments, or to help perform managerial analysis.
• Created, developed, and tested stored procedures, and user-defined functions that are utilized in SQL Server, ETL and Reporting packages to meet complicated business rules.
• Designed ETL packages using SSIS to perform incremental loads from given sources into the data warehouse.
• Implemented stored procedures to establish and filter datasets in reporting packages, and to perform various tasks in ETL process.
• Utilized control flow tasks and data flow transformations to perform ETL process on different scopes to deal with different types of sources and destinations.
• Performed code reviews to for existing stored procedures, functions, views, queries, or any other objects to correct errors, let them adapt into new requirements, or to improve their efficiencies .

SQL DEVELOPER / PROGRAMMER

Confidential, MO

• Implemented the data definition language (DDL), data manipulation language (DML), and transaction control language (TCL) to complete the given tasks that will be used for future research purposes.
• Pictured the general database and data warehouse structure by utilizing the data modeling and dimensional modeling skills.
• Created SQL Server objects such as tables, views, CTEs, temp tables, and table variables to complete the given tasks.
• Created stored procedures and functions to meet required features or calculations that will be used for future research or maintenance purposes.
• Checked source data to verify the completeness and accuracy, and then utilized the DML and TCL commands to insert, update, or delete data from the data warehouse for future use in analyses or reports.
• Wrote new queries, modified the existing codes. Then, exported and filed the results into Excel files based on the given requirements.
• Modified existing functions, stored procedures, views, or any other database objects to eliminate bugs, to adapt new requirements, or to improve their efficiencies.
• Designed tables and columns for the existing data warehouse and established appropriate constraints and relationships.
• Developed ETL packages using SSIS to load data received from the team lead, including performing data transformation, data cleansing, data integration, and etc.
• Assigned to the statistical research team to help the statistical analysis process and produce relevant results using the Statistical Analysis System (SAS), R, and Statistical Package for the Social Sciences (SPSS).