PROFESS IONAL SUMMARY

• 5+year experience Business Intelligence professional including SQL server, ETL(SSIS), Reporting (SSRS), BI (Power BI) in multiple industries such as Quantitative Finance, Insurance, Bank.
• Extensive Experience in Data warehouse/Data mart structure design, creating SSIS packages to implement ETL, performance tuning and troubleshooting both in SQL server and SSIS, data visualization using Power BI & Tableau.
• Good knowledge of system development life cycle (SDLC)
• Experience in developing TSQL objects such as Stored procedure, User defined function, Views based on complex joins
• Proficiency in developing SSIS packages to implement ETL (Extract, Transform, Load) process with various data sources (flat files, Excel, SQL server database, Oracle database, Hadoop)
• Familiar with data profiling, data cleansing and data cleansing using SSIS control flow tasks.
• Proficiency in developing reports using SSRS in both native mode and SharePoint mode
• Good communication skills with both teammates and client s
• Fundamental knowledge and academic background in SQL server, data analysis, finance

TECHNICAL SKILLS:

• SQL Server (2008, 2012, 2014, 2016)
• SSIS
• SSRS
• Power BI
• C++
• Python
• Matlab
• R
• VBA

PROFESSIONAL EXPERIENCE:

Confidential, East Setauket, NY

ETL /SQL developer

Tools & Environments: SQL server 2014, Oracle database 11g, SSMS, TSQL, SSIS, SSDT

Responsibilities:

• Gathered business requirements, definition and design of the data warehouse and data flows, data quality analysis. Created mapping documents after reviewing each column in each data source and structure of data warehouse.
• Wrote TSQL scripts and maintained existing scripts to created database objects such as stored procedures, user defined functions, triggers for different functions and enforce data integrity.
• Created over 30 SSIS packages to implement data extraction, data cleansing, data transformation and load into data warehouse for both initial load and incremental load based on specific business requirements
• Built packages to handle slow changing dimensions for maintaining the historic data.
• Created configuration files and enabling logging and error handling in SSIS and using user defined variables to dynamically configure packages during runtime in SSIS.
• Generated the Reconciliation Report on daily basis, research on each discrepancy records, providing the IT comments for the Business to sign off
• Deployed SSIS packages on test server and production server using SSIS project deployment model and SSMS integration service catalog. Used SQL server Job agent to make schedule for automatically running packages.
• Involved in performance tuning on query, stored procedure and SSIS package to improve the performance overall
• Monitored deployed jobs for UAT testing process, prepared the IT evidence and document for the SDLC process for Monthly release
• Cooperated with QA team with trouble shooting and debugging by writing test scripts.
• Scheduled SSIS package jobs using job scheduling tools and SQL agent.
• Modified existing packages for production issues
• Performance turning with SQL Queries for maximum efficiency using SQL Profiler and Database Engine Tuning Advisor

Confidential

BI Developer

Tools and En vironment: SQL server 2012, TSQL, SSIS2012, SSDT, Oracle database, Python3.6, Apache Hadoop2.6

Responsibilities:

• Communicate with each fund manage to gather his/her requirements such as what data need to be load into data warehouse, specific data type of each column, what’s the scale of initial load and increment load.
• Collaborated with data architect to design data warehouse structure, each dimension table and fact table, link each fact table with different dimension tables
• Created complex stored procedures, user define functions, views in SQL server database to
• Developed over 20 SSIS packages to extract, transform data from various sources including SQL server database, Oracle database, CSV files, EXCEL files and load into data warehouse
• Worked with Production Management Team to troubleshoot the production issue, mostly required to fix the price issue within a very short time window.
• Performed Web Crawler to extra text data from various stock forums using Python packages such as Request, Sqlite, Beautiful soup, Pandas and stored in Hadoop
• Utilized NLP (natural language process) and Naïve Bayes classifier to do public sentiment analysis.

Confidential, Indianapolis, Indiana

BI Developer/Report Analyst

Tools & Environments: SQL server 2008, Oracle database 11g, TSQL, SSMS, SSRS, SharePoint, SSIS

Responsibilities:

• Integrated data from different data sources to generate RegAB regulatory reports for bank products - -mortgage loans
• Created tables, indexes, functions and stored procedures in SQL Server and Oracle database
• Utilized existing or created new SSIS packages to extract data from Data warehouse into flat file folders and operational SQL database
• Communicated with report end user to learn about their requirements on report’s structure, format, context
• Developed over 30 SSRS reports with visualization features including bar char(stacked), pie chart, line chart, conditional formatting
• Applied drill-down, drill-through, Cross-tab, parameterized methods to highlight general information, hidden detailed records and enable user interaction which fits the business logic
• Customized each SSRS report with user defined parameters, filtering, grouping procedure conditional format from both blank tab or drop-down list
• Created subscriptions to render amortization schedule report, refinance and cash out report to each mortgage borrower, KPI reports to finance department, stress test reports to government regulatory institution, banks in different granularities
• Used Snapshots and Caching options to improve performance of Report Server
• Configured snapshot replication for reporting, user acceptance test and development servers
• Involved in trouble shooting, performance evaluation, performance turning with DBA, BA