SUMMARY:

• More than 6 years of combined experience as both Business Intelligence Analyst/Developer.
• Knowledge in analyzing, designing, testing, and delivering Business Intelligence solutions which include but not limit to application database design (OLTP), data warehousing design (OLAP) and implementation, SSIS (for ETL Processes), SSAS (Multi - Dimensional Modeling), SSRS for authoring and distribution of reports.
• Knowledge or using R and Excel to build Data and Mathematical Models, Data Exploration, and Data Explanation.
• Proficient in developing visualizations in Tableau, Excel 2013 - 201 6 and Power BI.
• Exposure to Machine Learning Algorithm from a consumer perspective.
• Advanced Knowledge in T-SQL programming, T-SQL Performance Tuning, T-SQL Unit test and Data Test.
• Advanced Knowledge in MS Business Intelligence Stack (i.e. SSIS, SSAS, SSRS, Sharepoint/performance point, power pivot, power BI, power map, etc…).
• Experience in developing Multi-Dimensional and Tabular Model in SSAS.
• Strong understanding of Data Warehouse and ETL Architecture and process.
• Strong Knowledge in processes related to the entire BI ecosystem.
• Proficient in .Net Programming languages such as Visual C#, VB.Net, ASP.Net.
• Proficient in Microsoft Office: Access, Excel, Word, and PowerPoint.
• Proficient in Microsoft SQL Servers 2005, 2008, 2008R2, 2012.
• Proficient in using Statistical software such as Mini Tab, and Mathematica.
• Extensive coursework in Mathematics including Statistical Analysis and Probability theory.
• Strong interpersonal and communication skills, both oral and written.
• Ability to work collaboratively, autonomously under demanding and tight deadlines with a high level of accuracy.
• Some knowledge in finance, Marketing and Operation Management.
• Quick learner, Attention to details.

PROFESSIONAL EXPERIENCE:

Application Database Developer and Administrator

Confidential, Lacey, WA

Responsibilities:

• Analyze requirements and design, develop operational and management SSRS reports.
• Provide operational support for reports related questions/issues.
• Manage the data sources required for the reporting.
• Develop and maintain documentation (report specs).
• Provide data extracts to meet the customers ad-hoc data needs.
• Assist in Report Server administration, including maintaining the library of reports, security access to the reports, and offer training and consultation in report development.
• Application Development DBA.
• Create and maintain database scripts for application releases.
• Assist in setup and configuration management of testing, training, and practice databases for various applications.
• Create, publish and maintain Data Models for application databases.
• Create, publish and maintain Data Dictionary for application databases.
• Assist application developers in database object design to meet the application requirements and enforce naming standards. DB Programming & Data.
• Perform Unit Test, Data Test, and Query performance tuning.
• Design, develop and maintains the data interfaces using SQL Server Integration Services (SSIS) packages.
• Develop and maintain Interface documentation.
• Develop database routines/scripts to fulfill operational data change requests.
• Code the views, procs, and other programs necessary for report, interface development.
• Produce highly efficient and well-documented SQL code, modifying the code as new requirements occur.

Confidential , Redmond, WA

Finance BI Analyst

Responsibilities:

• Establish and improve business processes governing financial reporting system includes Master Data Management, Data Quality Management.
• Collaborate with diverse groups to establish quality audit processes, process improvements, and minimize impact on the reporting system.
• Collaborate with data architects and BI developers to translate requirements into technical specifications
• Provide exceptional customer service to users for escalated tier 2 support
• Provide insight on new business or system change.
• Determine and validate potential data sources, build validation plan, assisting with or building scripts, executing the scripts, and communicating results in non-production environment
• Create test plan, test cases for UAT (User Acceptance Tests) to ensure quality solutions delivered to end users.
• Conduct peer reviews to solicit feedback on materials created
• Deriving business insight from financial and operational data, improving financial processes, and solving problems.
• Develop data entry application to ensure data integrity and data quality.
• Authoring Standard Operating Procedures and managing of updating and maintaining system related documents.

Confidential , San Jose, CA

Business Intelligence/ Database developer

Responsibilities:

• Using SQL Server Report Services, SQL Server Analysis Services, SQL Server Integrating Services, MS Access, and MS Excel to develop Business Intelligence solutions.
• Gathering, planning, translating, analyzing, organizing and designing back end business applications according to the requirements from upper management teams from different departments such as marketing, finance or internal operation.
• In charge of utilizing SSIS and C# scripts to develop automation processes and report definitions in Microsoft Visual Studio.
• Managing SSRS portals, provide technical support and create data driven distribution of reports to recipients.
• Work closely with web team, database administrators, and managers to develop plans and processes for business applications.
• Create and document application development cycle, production deployment process. Analyzing these processes for continued improvement.
• Direct responsibilities in planning, designing, and managing databases and adhoc reports in the enterprise environment
• Analyzing Data to keep track of performance metrics for different projects to measure time, cost, resources, quality, and actions. Therefore, helped reducing unnecessary costs and improving productivity.