“In God we trust, all others must bring data.” – W. Edwards Deming***Passionate and Experienced Data Analyst***• 5+ years’ experience in data analysis and business analysis. Programmed in T-SQL, fulfilled business and system requirements• Experienced in data-driven software engineering environment, including Relational Database Management Systems (RDBMS), ETL, OLTP, OLAP/Cubes database infrastructure and Data Warehouse• Developed Business Intelligence (BI) SSIS, SSAS, SSRS and ETL process using SQL Server SSMS and BIDS/SSDT and Excel• Skilled in data collection, data cleansing, data manipulation, data reconciliation and data migration under SQL Server 2008/2012/2016• Experienced in SQL Server data synchronization, disaster recovery and performance tuning for a highly available, efficient and secured database system• Analyzed key performance variables, optimized SQL and T-SQL queries, developed parameterized reports and dashboards with drill-down and drill-through reporting functionalities in SQL Server Reporting Services (SSRS)• Designed SSIS packages to extract, transform and load large dataset from multiple data sources (flat files, CSV, Excel, Access, SQL, Oracle and DB2)• Experienced in system development life cycle (SDLC), including planning, requirements gathering, designing (High Level, Functional and Detail Design), implementation, testing (Unit Testing, SIT and UAT), Production Deployment and maintenance• Experienced in Microsoft Excel advanced functions. Designed dashboards using VBA/macro and data analysis (Formulas, V-lookup, Pivot table, conditional format, text to column, array formula, string operations and trend analysis), created data visualizations to convey findings using Pie Charts, Bar Charts, Sparklines, Pivot chart, Histogram, Scatter plot and Trend line• Expertise in creation of Use Case Diagrams, Data Flow Diagrams and Business Process Diagrams using Microsoft Visio• Experienced in an Agile environment