Bi Reporting Developer Resume
5.00/5 (Submit Your Rating)
Seattle, WA
SUMMARY:
- Over 5 years experiences of SQL Server 2008R2/2012/2014, Oracle 10g/11g, Access 2007/2010 database and Data Loading and Reporting tools such as: SSIS, SSAS, SSRS, Tableau, Power BI and Crystal Reports 2008/2011
- Professional experience on Tableau Dashboard Design. Creating satisfied visualization interactivity for users by using various filters, parameters, calculations, functions and other advance features. Impacting and improving the effectiveness reporting.
- High level SSRS Reporting design experience, sourcing data from files, SQL connections, or from OLAP Cubes. Generating parameter dashboard, cascading report and other report types by adding drill down detail reports or other advanced functions
- Strong ETL solution experience. Extract data from various data sources, transform and loading into destination with GUI tool, SQL query, or SSIS package.
- Professional experience of SQL Server 2008/2012/2014 on Relational Database, Data warehouse. Data Mapping, Data Cleansing, Data Validation. SQL, T - SQL skills.
- An excellent team player & technically strong person who has capability to work with business users, project managers, team members, architects. Maintaining healthy environment in the project.
- Proven ability to approach problems effectively, prioritize and complete multiple tasks.
- Quick learner, take initiator, and hard worker. Willing to take responsibilities.
TECHNICAL SKILLS:
Database: SQL Server 2008/2012/2014, Oracle10g/11g, MSBI 2008/2012, Access 2007/2010
Reporting: Access 2007/2010, SSRS, Crystal Reports 2008/2011, Power BI, Tableau
Language: SQL, T-SQL, Excel Visual Basic, MDX
MS Office: Word, Excel, PowerPoint, Access
PROFESSIONAL EXPERIENCE:
BI Reporting Developer
Confidential, Seattle WA
Responsibilities:
- Gathering business requirements from internal and external users. Producing documentations to make sure changings of each of process.
- Extracting data from different data sources, such as relational database, CSV files or remote servers to data destination by using GUI tool or other tools like SSIS package, T-SQL query.
- Performing data cleansing, data mapping, data modeling. Defining the relationship between these tables, and optimizing performance with queries
- Generating various reports depends on business requirements by using Tableau, SSRS, SSAS, Power BI and so on.
- Deployment of reports according to users’ need. Effectively complete the lifecycle of report.
- Report maintenance with debugging and performance improvement
Data Analyst
Confidential
Responsibilities:
- Collected data from different department, loaded data from data source to data destination, generated daily, monthly, quarterly, yearly report to support company business running.
- Conducted data mining for new product to help new customers for R&D Department for business development.
- Maintained all of monthly, quarterly, yearly reports, keeping refresh data from data sources. Using data mining in new project and analyzing what products customers may be interested in based on the shopping habits
