SUMMARY

• 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 and solve 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, JIRA

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

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

PROFESSIONAL EXPERIENCE

ETL Tech Lead/ BI DEVELOPER

Confidential - Cincinnati, OH

Responsibilities:

• Conducted the online JRD (Joint Requirement Development) meetings with business users, offshore team members to discuss complex business rules such as data descriptions, environment setups, permission and access demands, etc., to generate proper design documentations and reports.
• Discussed future tasks and plans, updated on current project statusduring daily online scrum meetings with other offshore team members, team lead, and project manager, and provided thoughts, ideas, and inputs on project difficulties, deadlines, designs, and enhancements.
• Built and designed ETL solution architects, and presented the solution design to the tech team as well as the business users in terms of official design documents and technical demonstrations.
• Developed complicated ETL frameworks including customized process logging tables, process configuration tables, and varies validations in each step to ensure data integrity, data quality, data availability, and data security.
• Created SQL Server objects, such as stored procedures, views, temp tables, dynamic SQL and other technologies to solve complex framework requirements and logics.
• Wrote complex queries using varies functions, CTEs, and subqueries to complete complex business calculations, requirements, or other complex logics.
• Created additional tables, columns, and indexes to adjust the database and data warehouse structures for better usage or to work with the dimensional modeling team.
• Mapped the data from on-premises source systems to the target AWS SQL Server tables, and stored the mapping information in the process configuration tables for later look up use.
• Created and developed ETL packages using SSIS with features of looping through a folder or a query result, read the contents, dynamically lookup the mapping and metadata from the process configuration table, and load the data from varies on-premise sources to the target AWS SQL Server tables.
• Wrote C# scripts to loop through a folder of flat files, create SQL Server tables dynamically based on the contents of each files inside the script task in SSIS.
• Set up the customized logging strategies, error handling, and email notifications in SSIS packages to keep track of the data loading status on time.
• Deployed SSIS packages in AWS SQL Server and set up the SQL Server Job Agent to execute the packages in both development and production environment.
• Performed code reviews on SQL Server objects and SSIS packages to make necessary adjustments to increase its efficiencies or remove errors, such as removing correlated subqueries, recompiling stored procedures, using inner joins to do filtering.
• Performed varies rigorous unit testing on SSIS packages, SQL Server objects, or any relevant programs to remove errors, uncover bugs, troubleshoot issues, anticipate all possible scenarios, and generated unit testing reports.
• Explored and analyzed the newly established database, determined the appropriate relationships and reporting needs, form a new data warehouse for reporting purpose with corresponding ETL solutions as well.
• Translated legacy system’s viewpoint queries into SQL Server queries during the User Acceptance Testing after the data was migrated successfully into the AWS SQL Server tables.

SQL/ETL DEVELOPER

Confidential - Boston, MA

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.
• Developed stored procedures, CTEs, and dynamic SQL for each business requirement to build and implement business logic.
• Developed views, temp tables, 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.
• 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 sourcesto 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

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 improvetheirefficiencies.
• 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 integrationfrom 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

Responsibilities:

• 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 establishedappropriate 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 objectsin many places such as to establish data source for ETL and reporting packages, to link the SQL Server to the front end, etc.
• Troubleshotexisting 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.