PROFESSIONAL SUMMARY:

• Over 6 years abundant working experience in SQL, ETL, Reporting, and BI development in numerous industries such as healthcare, manufacturing, aviation, education, power and utility, etc.
• Expertise in Software Development Life Cycle (SDLC) especially with Scrum and Agile methodologies.
• Supremacy in designing data warehouse with both Inmon and Kimball approach.
• Profound understanding of multidimensional schemas such as star schema, snowflake schema, and galaxy schema.
• Proficiency in developing SQL Server objects such as complex stored procedures, user - defined functions, views, triggers, temp tables, and table variables to meet complex business requirements.
• Excellence in SQL Server error handling methods that tackles even the knottiest errors at their appearance to increase the accuracy, integrity and efficiency of the system.
• Proficiency in SQL Server performance tunings practices including but not limited to execution plan inspection, queries and store procedures optimization, indexes and partitions application which prominently reduce execution time.
• Prowess in performing ETL (extracting, transforming, and loading) process using SQL Server and SSIS (SQL Server Integration Services) with Change Data Capture (CDC), Time Stamp or Checksum.
• Rich experience with Slow Changing Dimension (SCD) for both initial load and incremental load.
• Exquisiteness in designing complex reports and dashboards with different reporting tools, such as SSRS (SQL Server Reporting Services), Power BI, and Tableau.
• Tremendous interpersonal and communication skills to gather relevant project requirements and resolve project stakeholders’ concerns internally and externally.
• Strong perception with learning new technologies and methodologies in versatile working environment.

TECHNICAL SKILLS:

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

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, etc.

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

Big Data tools: Hadoop, Spark, Kafka, etc.

Cloud Services: Microsoft Azure, AWS, Hadoop

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

SDLC Methodology: Agile, Scrum, 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

WORK HISTORY:

Sr. DATA DEVELOPER (SQL/ETL)

Confidential, New York, NY

Responsibilities:

• 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.
• Established views, temp tables, table variables to facilitate efficient data manipulation and data consistency.
• Created multiple user-defined functions to handle complex data calculation in an efficient way.
• Developed stored procedures, CTEs, and dynamic SQL for each business requirement to build and implement business logic.
• Created additional tables, columns, indexes, and partitions to adjust the database and data warehouse structures for better usage.
• Carried out 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 SQL Server job agents to perform repetitive tasks, such as ETL packages, transactional statements, etc.
• Gathered data from several sources, which took up to over 60GB data including prescriptions and health records, payers histories, HCPCS, ICD10, etc.
• Designed packages for both initial load and incremental load.
• Performed data validation, data cleansing in prestaging phase and data profiling in staging phase.
• Mapped the data between data source and data warehouse for over 200 different dimensions and facts tables.
• 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.
• 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.
• Deployed several SSIS packages in project mode and set up the relevant environment in the SQL Server.
• Developed and modified the existing online applications using Visual Studio.Net Framework.
• 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.
• Designed and created numerous SSRS reports and packages providing data visualization, such as bar chart, line chart, conditional formatting, with visual appealing and reports interaction.
• Created monthly premium snapshot reports based on the data analysts’ requirements and utilized data-driven subscriptions.
• Developed SSRS reports using multiple data providers, reports variables, expressions, user-defined objects, aggregate-aware objects, line charts and bar charts, and synchronized queries for claim processing data and other information system data.
• Designed and implemented parameterized and cascading-parameterized reports with over 20 parameters using SSRS.
• Managed and secured reports by SSRS and rendered into Excel and PDF with good compatibility.
• Generated KPI dashboard reports using DAX and visualizations with Power BI according to the measure and dimension required by end users.
• Collaborated with team members using TFS for source control and for maintaining repository of T-SQL objects, SSIS packages, and reports.

SQL/ETL ENGINEER

Confidential, Taylor, TX

Responsibilities:

• 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.
• Constructed various types of table constraints to keep data integrity.
• Coded 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.
• Operated performance tuning by creating additional indexes and partitions to the database and data warehouse.
• 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.
• 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.
• Developed SSRS reports using multiple data providers, reports variables, expressions, user-defined objects, aggregate-aware objects, line charts and bar charts, and synchronized queries for claim processing data and other information system data.
• Designed and implemented parameterized and cascading-parameterized reports with numerous parameters using SSRS.
• Developed reports and dashboards packages with subscriptions using SSRS with features such as cascading parameters, drill-down reports, drill-through reports, and pivot tables.
• Managed and secured reports by SSRS and rendered into Excel and PDF with good compatibility.
• Created dashboards with Power BI to show real-time KPIs information for business user and schedule email to send alerts to users when contain KPI perform abnormal.
• Demonstrated exceptional interpersonal and communication skills, which improved team collaboration.

SQL/ETL DEVELOPER

Confidential, Dallas, TX

Responsibilities:

• Dedicated to the Agile methodology proposed ideas and suggestions during team meetings with the team lead, the project manager and team members.
• 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.
• Determined the technical requirements by analyzing daily operations, applications, and programming, as well as communicating with business users.
• Projected 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 PROGRAMMER

Confidential, Fort Worth, TX

Responsibilities:

• 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.
• 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.
• 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 . 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, Waco, TX

Responsibilities:

• Attended business requirements gathering meeting with other team members and business. Assisted in converting business logic to technical documents. Communicated with clients to finalize the requirements and handle the updating in requests and system environments.
• Dealt with different data sources: Oracle and Microsoft SQL server database, flat files and XML files from Azure cloud server and miscellaneous data from local server.
• Performed data profiling and data cleansing using Visual Studio BIDS and SQL server. Validated and vivificated the data accuracy before and after ETL process.
• Established over 70 incremental load packages, over 40 full load packages to complete ETL process of Enterprise data warehouse.
• Checked and modified all existing packages to perform performance tuning. Refined the T-SQL code and transformation properties within packages for tables from 8 records to over 1 billion records with help from Execution plan.
• Generated complex queries using aggregate function, window function, analytic function, ranking function, string function, and system function to complete complex business.
• Applied use of SSIS tasks and SQL stored procedures on SQL server to generate Log table and dictionary Meta data table which provided data for daily quality reports.
• Generated configuration files to store the properties of packages. Reduced the cost of maintenance.
• Deployed packages under package mode based on the requirements of business and situation of environments. Created and scheduled jobs for packages to perform different type of loading using SQL server Job Agent.
• Coded T-SQL query to make fields’ frequency analysis of tables and other ad-hoc tasks with help from CUSOR, Dynamic SQL, system tables and system defined functions and stored procedures etc.
• Utilized performance monitor to supervise the execution process of daily ETL jobs. Enlarged cache size, rebuilt indexes to further increase the performance according to the outputs of tools.
• Handled SQL server ad-hoc issue including killing improper long query and releasing log files space. Created new file groups to handle new tables based on the utilization.
• Coded views and stored procedures for reporting tools including Tableau, SSRS, based on the requirements of business, including reports for patient encounter, insurance coverage, etc. Provided technical support to the Tableau reports developers.
• Designed new and maintained existing SSRS reporting. Enabled drill down, drill through and added parameters, data regions based on the requirements of clients.
• Deployed reports using share point. Performed caching, snapshots and subscription to enhance the server performance and convenience.
• Created and scheduled jobs to backup database and send customized e-mail based on the condition of server utilizing power shell and SQL server Job Agent.
• Built minor database directly linked to OLTP system. Designed database structure, file groups and allocated disk space to ensure the safety and accuracy.
• Performed unit test and UAT test to ensure the packages, views, stored procedures and SSRS report to meet the requirement of business.
• Wrote supplemental documents, excel files to support other team members jobs. Recorded the progress of different projects helping the execution of project. Reflected the current issues of database allowing other members could be noticed and avoid unwanted influence.

BI REPORT DEVELOPER

Confidential, Waco, TX

Responsibilities:

• Attended joint application design (JAD) meetings with BI team and Actuarial Manager to obtain business requirements.
• Established comprehensive mapping documents.
• Developed 30+ SSIS packages to accomplish the ETL process to extract data from SQL Server and Excel files, apply data cleansing, data profiling and transformation using different tasks, containers and components.
• Performed initial load and incremental load using SSIS packages and stored procedures.
• Handled incremental load using checksum and timestamps methods.
• Applied various slowly changing dimension (SCD) policies, such as Type 1 and Type 2 to different dimension tables.
• Paralleled tasks to improve performance of SSIS packages.
• Wrote C# scripts to send emails to inform users about data cleansing, to create XML destination, etc.
• In SSIS, implemented checkpoints, created custom logging, enabled event handlers to monitor the package process.
• Implemented error handling on packages by redirecting errors and saving error log in SQL Server tables.
• Performed unit test of codes and packages with sample data following specific rules.
• Created stored procedures, user defined functions, temp tables and CTEs to support ETL and reports.
• Created various SSRS reports, such as drill down reports, drill through reports, cascading reports, sub-reports, linked reports, using tablix, matrix, bar chart, pie chart, etc.
• Wrote VB.net code functions to format data for reports, such as division by zero error.
• Implemented cache and snapshot for improving SSRS performance.
• Implemented various index, such as clustered index, non-clustered index and covering index.
• Tuned performance bottlenecks using execution plan, SQL Profiler and Database Engine Tuning Advisor.
• Recompiled existing stored procedures to avoid parameter sniffing.
• Responded to error massage and help desk system tickets and solved issues according to user requirements.
• Managed SSIS packages properly in Dev, Test and Production environments with TFS using check in and check out and maintained historical version for every minor change.
• Produced complex ad-hoc queries and reports using SSRS.
• Designed and developed data extracts from MS SQL database.
• Worked closely with clients and IT SME’s to define BI requirements.
• Be responsible for production support and worked on Jira Scrum for job scheduling.

SQL DEVELOPER

Confidential

Responsibilities:

• 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.
• Assisted 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 .
• Generated complex queries using aggregate function, window function, analytic function, ranking function, string function, and system function to complete complex business calculations and requirements.
• Constructed tables, views, CTEs, temp tables, table variables, and other SQL Server objects to complete the given business tasks.
• Generated 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 .