PROFESSIONAL SUMMARY:

• 6 years’ experience within database and business intelligence development by using Microsoft SQL Server 2012/2014/2016/2017 and Microsoft Access.
• Experience across different professional domains including healthcare, logistic, insurance, banking and engineering industries.
• Extensive experience in SDLC (Software Development Life Cycle) such as gathering business requirements, developing, testing, deploying and maintaining.
• Extensive experience within different methodologies including Agile, Scrum.
• Experience in JRD (Joint Requirement Development) and JAD (Joint Application Design) with business users, management team, tech team members and QA teams.
• Experience in data modeling like Inmon Methodology and Kimball Methodology with star schema and snowflake schema.
• Hands - on experience of drawing ER-Diagram for Chen’s Notation and Crow’s Foot Diagram in Data Modeling by using Microsoft Visio and Erwin.
• Strong ability of constructing Stored Procedures, User Defined Functions, Views, CTEs, and Subqueries to accomplish business logic and calculation.
• Expertise in setting constraints and transaction for ensuring data integrity.
• Skills in performance tuning in TSQL like reviewing Execution Plan, setting up Execution Logs, creating Indexes, SQL profiler, Database Engine Tuning.
• Skills in migrating different data sources, such as flat files, OLEDB, DB2, Excel files, XML files, applying data cleansing, data profiling, data transformation, and loading to various destinations.
• Strong expertise in developing SSIS packages within control flow by creating Stored Procedures with error handling and within data flow task.
• Experience in writing C# and Visual Basic language codes within Script task and sent error inputs to developers and business users.
• Expertise in using SSRS to create different types of reports such as drill down reports, drill through reports, and linked reports.
• Proficiency in generating analysis reports, dashboards, and ad-hoc reports using SSRS, Power BI, scheduling and deploying reports on the report server and report manager.
• Proficiency in troubleshooting, debugging and performance tuning in SSIS and SSRS.
• Extensive knowledge about Azure SQL Data Warehouse and Amazon Web Services (AWS).

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2008 R2, SQL Server 2012/2014/2016/2017 , My SQL, Microsoft Access

Structured Query Languages: T-SQL, MySQL

ETL Development Tools: SSIS, SSDT, Informatica

Reporting Development Tools: SSRS

Data Visualization Tools: Power BI, Tableau

Programming Languages: C#, Visual Basic, Python, R, MATLAB

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

Data Simulation: Arena

Data Optimization: AMPL, MAMPL

Job Scheduling & Work Automation: SQL Server Job Agent

Big Data & Cloud Service: Spark, Hadoop, AWS (Redshift, Glue, Ambari, Kafka, Storm, Pig, Hive), Azure (Azure SQL Database, Data Factory, Backup/Recovery, Azure Machine Learning)

Methodologies: Agile, Scrum, Waterfall

Project Management Tools: Jira, Confluence, SharePoint, Microsoft Project.

PROFESSIONAL EXPERIENCE:

Confidential, Elmwood Park, NJ

SQL Developer

Responsibilities:

• Gathered business requirement and attended JAD (Joint Application Design) meeting.
• Extended database and drew ER-Diagrams based on business needs.
• Created stored procedures with CTEs, dynamic SQL, aggregate functions, ranking functions, window functions based on business rules.
• Implemented transaction statements on DML activities and applied locks to improve performance.
• Improved query performance by reviewing execution plan, SQL Profiler and Database Engine Tuning Advisor.
• Implemented various index, such as non-clustered index and covering index and assigned hints to use specific joins to speed up stored procedure performance.
• Implemented user defined functions with data manipulation language to do mathematics calculation based on business rules.
• Utilized check constraints, primary key constraints, foreign key constraints, not null constraints, default constraints, and domain constraints to ensure data integrity.
• Developed control flow and used execute SQL task to build more than 30 SSIS packages.
• Created prestaging tables in SQL and wrote stored procedures to perform data cleansing, data validation and data profiling to deal with missing values, data not followed business rules.
• Utilized staging tables in SQL and transformed data into appropriate data types and loaded into data warehouse.
• Handled error inputs including duplicates and incorrect data, gave error message and sent back to business users with Excel file format by writing C# language in script tasks in SSIS.
• Implemented event handlers, utilized custom logging with execute SQL task, script task and log providers to provide information on each execution and to send summaries to users and team members via email.
• Implemented foreach loop and sequence containers, send mail task, variables and expression control, parents & child packages and variables.
• Divided tables into different packages, used execute package tasks to perform initial loading and incremental loading in synchronous transformation.
• Used timestamp, created date and modified date to perform incremental load.
• Deployed SSIS projects with environment into SQL server under project deployment model.
• Created cascading parameters, null value parameters and multi-value parameters within reports.
• Designed drill through reports by setting action and pass in same parameters for bypassing performance issues.
• Utilized conditional formatting, alternating row colors, keep header visible to provide good user interface.
• Held testing within team and UAT (User Acceptance Test) with business users and enclosed development process.
• Deployed reports into report server and report manager, and changed data driven subscription default settings like parameters, security, and rendering format.
• Worked on Team Foundation Server (TFS) to coordinate with the development team on the deliverables and for Version Control.

Confidential, Miami, FL

SQL Developer

Responsibilities:

• Conducted business requirements gathering meetings with other team members.
• Collaborated and Communicated with BA, end users and developers to translate from business understandings in BRD to technical languages in FRD and to ensure business and system requirements are met.
• Participated in Agile methodology and assigned time boxes for finished user stories.
• Designed, developed, tested, and released deliverables adhering to efficient communication, quality and time constraint.
• Created Crow’s Foot Notation by Microsoft Visio for easily understanding and communicated with team members.
• Created complex stored procedures, user defined functions, tables variables, views and CTEs and other queries in T-SQL to perform business logic and business calculation.
• Optimized existing stored procedures performance by using execution plan, SQL Profiler and extended indexes if needed, and solved parameter sniffing issues by using recompiling and updating statistics.
• Extended data marts for domain departments with dimension tables and fact tables included different constraints like key constraints, not null constraints and default constraints to ensure data integrity.
• Created staging tables in SQL Server and used control flow and data flow in SSIS to implement ETL.
• Extracted data from different source like Excel files, CSV files, JS files.
• Implemented complex SSIS packages to perform data cleansing, data validation and data profiling by using conditional split, data conversion, derived column, multicast, lookup, merge, sort, data row count, etc. for initial load and incremental load.
• Generated parent-child packages and assigned transaction properties and checkpoint to monitor package process.
• Wrote C# language in script task and sent email to team members when the whole process finished.
• Implemented troubleshooting by dealing with incorrect data, storing them into SQL Server and Excel format, creating custom logging and event handler on project level.
• Utilized parallel tasks, containers and synchronous components to increase SSIS packages performance.
• Deployed SSIS packages to SQL Server by using project deployment model.
• Used Team Foundation Server and Source Control Explorer to perform version control, troubleshooting, debugging, and error handling for the package and scripts; version backup and restore.
• Created drill through reports with cascading parameters, multi-value parameters, textbox, tables, charts, matrix, indicators and lists based on business users’ requirements.
• Deployed reports into report server and report manager, created data driven subscription for sending to various recipients with different rendering format, parameters and security.
• Implemented machine learning algorithm, classification in R and built prediction model and covered in reports.
• Attended UAT, enclosed the development cycle and released production.

Confidential

BI Developer

Responsibilities:

• Wrote complex stored procedures which included preventative error handling, multi-statement table-valued function, subqueries, CTEs, set operators, control flow statements, etc.
• Analyzed long-running queries and optimized application and system performance by examining execution plan, SQL profiler, SQL Server Agent and Database Engine Tuning Advisor.
• Recompiled existing stored procedures to avoid parameter sniffing.
• Performed initial load and incremental load using SSIS packages and stored procedures.
• Deployed over 30 SSIS packages to extract data from Excel files, OLEDB, and CSV files and implemented data conversion, derived columns, lookup, and conditional split to perform data cleansing, data validation and data profiling.
• Applied slowly changing dimension (SCD) policies including Type 2 and Type 4 dimension tables.
• Implemented checkpoints, created custom logging and error tables and enabled event handlers in SQL server to monitor the package process.
• Designed error handling by redirecting error output, storing in Excel files and sending back to business users by email.
• Generated mapping documents for ETL process.
• Designed templates and ensured data validation, formatting, delivery formats and frequency about reports.
• Utilized shared data source, embedded datasets for tables, matrix, indicators and line charts in SSRS reports.
• Designed over 20 SSRS drill down reports, drill through reports, linked reports, using tables, matrix, pie charts, etc.
• Created interactive dashboards with bar charts, line charts, and tree map to enable visualization of KPI for business users.
• Deployed reports in report server and built snapshot for monthly project analysis.
• Collaborated with team members by using TFS for source control and for maintaining a repository of TSQL objects, SSIS packages and reports.

Confidential

SQL Developer

Responsibilities:

• Translated business requirements to technical features based on gathering, understanding and analyzing end users’ requirements after participating JAD meetings.
• Involved in normalization and denormalization of existing tables for better query performance.
• Involved in performance tuning of database and T-SQL queries using execution plan. Created indexes (non-clustered index, filtered index, column store index) on database objects.
• Created scalar-valued and table-valued functions in T-SQL to implement complex business calculation for copay, deductible and maximum out of pocket.
• Implemented transaction statements on data manipulation activities and developed locks to improve performance and to protect data integrity.
• Created prestaging tables to perform data cleansing and data validation and staging tables to perform data transformation.
• Created stored procedures with dynamic SQL, and error handling such as try…catch, raise error, created date, end date and merge statements to perform initial load and incremental load.
• Utilized constraints such as primary key constraints, foreign key constraints, default constraints and domain constraints to ensure data integrity.
• Used transformation components in data flow task like lookup, conditional split, derived column transformation, merge join, and by using tasks and containers, like script task, execute SQL task, foreach loop container.
• Designed custom logging with execute SQL task to store error information into SQL Server.
• Created drill down, drill through reports with table, matrix, charts, cascading parameters and rendered into Excel format and PFD format.
• Deployed reports in SSRS and built snapshots for monthly sales performance and growth for various departments.
• 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.

Confidential

SQL Developer

Responsibilities:

• Attended business requirements gathering meeting with other team members and business users. Assisted in converting business logic to technical documents.
• Supported physical implementation requirements for dimension and fact tables, including normalization techniques and referential integrity.
• Modified existing databases by adding/removing columns, constraints according to requirements.
• Optimized query performance by extending appropriate index, such as covering and filter index.
• Tuned the existing SSIS packages with new T-SQL statements to perform data validation, data processing, data correction, and other functionality in SSIS.
• Created project parameters for changing connection manager and variables to store values during execution.
• Optimized packages by adjusting pipeline buffer size and applying parallel execution.
• 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.
• Collaborated and communicated Production SSIS packages schedules with DBA. Scheduled jobs to run packages automatically and send job alerts with SQL Agent Job.
• Utilized drill-down, drill-through, and scorecard report with dynamic grouping and sorting for business insight, like sales information in SSRS.
• Generated and maintained SSRS reports, using techniques like cascading parameters, multi-value parameters, custom functions, calculated fields etc.
• Troubleshooted slowly running reports by creating stored procedures for datasets, deleting built in filters, designing drill through reports and setting up subscription.
• Scheduled reports delivery on daily, weekly, and monthly basis utilizing standard and data driven subscriptions.
• Performed QA test on testing server, checked the product feasibility. Operated UAT with user and refined the completeness of products.
• Be responsible for production support and worked on Jira Scrum for job scheduling.

Confidential

Database Developer

Responsibilities:

• Prepared ERD and FRD by communicating with end-users, managers, tech team members and QA in JRD and JAD session.
• Drew Chen’s Notation to represent to business users and Crow’s Foot Natation to communicate within team.
• Extended data warehouse structure by adding dimension tables and fact tables.
• Wrote complex stored procedures with dynamic SQL, table variables to perform preventative error handling and data manipulation.
• Responded to error massage and help desk system tickets and solved issues according to user requirements.
• Added non-clustered indexes and covering indexes to improve the performance of data retrieval.
• Debugged errors, fixed malignant logics, and improved the debug process and methods for packages and stored procedures.
• Extracted data from various data source including Excel files, CSV files, JS files and OLEDB.
• Maintained the existing ETL packages, including SSIS packages and stored procedures according to the business metrics and developed SCD.
• Participated in complete SSIS life cycle in creating SSIS packages, building, testing, deploying, executing packages in both environments (development, UAT, and production).
• Developed standardized and ad-hoc reports in Power BI through utilizing production department data marts to support analysis and process improvement of various responsibilities of the business departments.
• Designed KPI dashboard reports for management using advanced filtering, analysis, drill down and parameters in Tableau.
• Performed system testing including unit tests and User Acceptance Testing (UAT) in various Automatic Work Distributor (AWD) platforms.