SUMMARY:

• About 8 years working experience in SQL, ETL, Reporting, and BI development in numerous industries such as healthcare, manufacturing, aviation,, power and utility, etc.
• Experience in SDLC (Software Development Life Cycle) including requirement gathering, development, testing, deployment, production, and maintenance.
• Proficiency in data cleansing, migration, troubleshooting, debugging, performance tuning and error handling in SQL Server and related tools, including SSIS and SSRS.
• Extensive experience in data modeling, dimensional modeling, data mart design.
• In - depth knowledge in T-SQL development, using DQL, DML and DDL to create user-defined store procedures, user-defined functions views, triggers, cursors, CTEs, indexes and other ad-hoc T-SQL queries.
• Expertise in data cleansing, migration, troubleshooting, debugging, performance tuning and error handling in SQL Server.
• Great ability to utilize execution plan, index, execution log, SQL profiler, and other performance tuning techniques.
• 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 performing ETL (extracting, transforming, and loading) process using different BI tools, such as SQL Server and SSIS (SQL Server Integration Services).
• Rich experience with Slow Changing Dimension (SCD) for both initial load and incremental load.
• Skills in designing complex reports, dashboards using different tools, such as Tableau, Power BI and SSRS (SQL Server Reporting Services).
• Tremendous interpersonal and communication skills to gather relevant project requirements and resolve project stakeholders’ concerns internally and externally.
• Extensive exposure to statics fundamentals, machine learning and data mining using Python and R.
• Excellent communication and interpersonal skills, being able to work both collaboratively and independently.
• Strong perception with learning new technologies and methodologies in versatile working environment.

TECHNICAL SKILLS:

Database: 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, Looker and Microstrategy

Programming Languages: Python, R, SAS, T-SQL, PL/SQL, PostgreSQL, MySQL

Job Scheduling & Work Automation:: SQL Server Job Agent, Control-M

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

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

SQL/ETL Developer

Responsibilities:

• Participated in business analysis activities to gather business requirements from business users and converted the business rules into technical approaches.
• Wrote complex SQL queries with techniques of CTEs, joins, set operators, aggregate functions, window functions, etc. to combine multiple data sources into one single dataset for modeling preparation.
• Established table constraints, such as data types, different types of keys, null values, default values, and check to keep data integrity.
• Created stored procedures and functions to meet required features or calculations that will be used for future research or maintenance purposes.
• Pictured the general database and data warehouse structure by utilizing the data modeling and dimensional modeling skills.
• Created stored procedures and functions to meet required features or calculations that will be used for future research or maintenance purposes.
• 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.
• Performed code reviews to analyze inefficient or incorrect queries, and provided suggestions for optimizations or debugging purposes.
• Developed ETL packages using SSIS to load data received from the team lead, including performing data transformation, data cleansing, data integration, and etc.
• Designed and developed ETL SSIS packages to facilitate initial and incremental load process.
• Building, publishing customized interactive reports and dashboards, report scheduling using Power BI server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Power BI.
• Developed complex calculated measures using stored procedures, common table expressions, temporary table to support Power BI reports.
• Developed complex calculated measures using Data Analysis Expression language(DAX) in Power BI to satisfy business needs.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Conducted the JRD 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.
• Created new SQL Server objects and modified existing ones, such as stored procedures, views, functions, cursors, 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.
• 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 code reviews to analyze inefficient or incorrect queries, and provided suggestions for optimizations or debugging purposes.
• 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.
• 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 Power BI reports and dashboards from multiple data sources using data blending.
• Exported data in a variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Created, tested, deployed, and subscribed several Power BI reports with features such as cascading parameters, drill-down, drill-through, and pivot tables for the end-users.

Confidential, Chicago, IL

SQL Server BI Developer

Responsibilities:

• Created CTEs, stored procedures and dynamic SQL for each business requirement to build and perform 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.
• Optimized the existing stored procedures and queries with execution plans to improve performance and reduce inefficiency on the purpose of cleaning, standardizing, and normalizing data of raw tables.
• Performed code reviews on queries, stored procedures, and views to make necessary suggestions, such as removing correlated sub queries, recompiling stored procedures, using inner joins instead of in clause, to optimize the programming code.
• Created SSIS packages with which data from different resources were loaded daily in order to create and maintain a centralized data warehouse.
• Supported product department to create ad-hoc reports and interactive dashboards to integrate information and transactions by using SQL query and DAX calculations in PBI.
• Modeled and forecasted database and platform resource utilization to meet user needs and respond to anticipate technological innovations.
• Built reports to visualize required data and calculations in the layout which business users indicated. Sent reports to users and set different levels of data security. Migrated reports from various retired reporting tools to a single unified server.
• Troubleshot issues in jobs, reports, SSIS packages and so on. Trained the business users to create Ad hoc reports of their own.
• Wrote enterprise reports and stored procedures upon requests. Designed report models to meet business requirements and allowed users to perform fast queries.
• Worked with charts to provide dashboard effect in Tableau report. Created Ad-hoc reports, data driven subscription reports by using Report Builder in Tableau.
• Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.

Confidential

SQL Database Developer

Responsibilities:

• Wrote complex SQL queries with techniques of wildcard, CTEs, joins, set operators, aggregate functions, window functions, etc. to combine multiple data sources into one single dataset for modeling preparation.
• Developed stored procedures and dynamic SQL to perform data validation, data cleansing, data profiling and data partition to prepare data for modeling.
• Executed scripts written in supported languages including Python and R in SQL Server.
• Implemented machine learning algorithms such as Decision Trees, Random Forest, SVM, Multivariate LSTMs, and time series models such as ARIMA, Exponential Smoothing, Facebook Prophet in order to enhance the accuracy of the software’s predictive analysis feature using different packages in Python and libraries in R.
• Created views and tables with DML to store the results of the forecasting results and model accuracy statistics, so as to display the results in the reports generated by the software.
• Integrated the software with developed new features with Power BI, Azure and Azure Services for testing purpose.
• Created SQL Server reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
• Schedule the reports to run daily, weekly and monthly and also automatically emailed reports to department directors and analyst to review it.

Confidential

SQL/ETL Developer

Responsibilities:

• Responsible for all aspects of projects from gathering requirements, designing, coding, testing, documenting, implementing,, support, and maintenance of applications.
• 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.
• Wrote stored procedures, views, triggers and functions in support of the applications.
• Designed and modeled database structure to support business needs using ER/Studio.
• Developed and supported web financial systems using MS SQL Server and T-SQL coding.
• Developed SSIS packages to export and import data across environments with different business logic.
• Created stored procedure, indexes, and views using complex queries and scripting.
• Involved in critical database releases to testing, staging, and production environments.
• Used SQL Profiler to troubleshoot issues and for query optimization.

Confidential

BI Developer

Responsibilities:

• Played a key role in the process of gathering new business requirements with Agile methodology. planned important ideas and constructive suggestions to the team lead, members, and also the analytical team throughout the Joint demand 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 .
• Utilized T-SQL to tug information from numerous databases and created numerous dashboards, scorecards and reports to support loan business deciding.
• Used SSIS to create ETL package to validate, extract, transform and load data to data warehouse and data mart databases.
• Used ETL tools to implement the Slowly Changing Dimensional maintain Historical Data in Data warehouse.
• Generated ad-hoc reports, sub-reports, drill-down reports, drill-through reports and parameterized reports to provide visible data for data analysts and business using SSRS and Power BI.
• Created Stored Procedures, user-defined functions, views for handling business logic and functionality such as Email Alerts.
• Built daily, weekly, monthly graphs and charts of loan data using Stored Procedures.
• Involved in designing, developing and testing of the ETL strategy to populate the data from various source systems using SSIS.

Confidential

Data Analyst

Responsibilities:

• Delivered recommendations and insights based on analysis and key performance metrics observed, evaluating the impact of the recommendation across the business.
• Designed and developed models to support the business and implement these models in R and Python.
• Expertise in transforming business requirements into analytical models, designing algorithms, building models, developing data mining and reporting solutions that scale across a massive volume of structured and unstructured data.
• Experience in using numerous packages in R and python like ggplot2, NLP, pandas, NumPy, Seaborn, SciPy, Matplotlib, sci-kit-learn.
• Worked with IT and other internal resources to develop prototypes for various projects involving large data sets in the Hadoop cluster.