Business Intelligence Analyst Resume
Garden Grove, CA
SUMMARY:
Business Intelligence professional with strong analytical and technical skills. Proven aptitude to learn on the job and apply instantly, proactive to learn and adapt new/evolving technologies, tools and methodologies.
- Requirements Analysis
- Data Manipulation
- Database Programming
- Database Management
- Visualization
- Dashboard Reporting
TECHNICAL SKILLS:
Languages: R programming, SQL, Python, C, Visual Basic, Visual Studio, C#, HTML, CSS, XML, PHP, ASP, Java Script, Dojo framework, MVC Framework, Shell Script, Python, Ruby
Java: Spring MVC, Spring Web Services, JDBC, Junit, TestNG, JSP, Tomcat, Maven, Eclipse
Testing Tool: RPT (Rational Performance Tester), Selenium WebDriver, Selenium RC
Application Servers: WebSphere, WebLogic, Tomcat, Jboss
Web Services: REST, JSON, SOAP
Operating Systems: Windows, Linux, Unix
Database Packages: SQL Server, MySQL, Oracle, MS Access, Hadoop
Visualization Tools: Tableau, Alteryx
Software Development Test-Driven Development, Design-Driven Development, Waterfall, Agile, (Scrum, Sprint):
PROFESSIONAL EXPERIENCE:
Confidential, Garden Grove, CA
Business Intelligence Analyst
Responsibilities:
- Cleaning data using Alteryx and other data cleaning processing tools
- Social Network analysis visualization in Tableau
- Data visualization in R programming and Python
- Create Dashboards using Tableau
- ETL using T - SQL and SSIS
- Database management using SQL Server programming
Confidential, Costa Mesa, CA
Application Development Consultant'
Responsibilities:.
- Customized Confidential Case Manager and Confidential Content Navigator applications, by using Dojo framework with JavaScript and Java, as well as REST web services, meeting client’s requirements.
- Executed automated and manual functional and regression tests, collaborating with team of project managers, developers, analysts, and business partners in agile environment.
- Software Test Specialist, Intern (2013).
- Performed functional / regression testing to execute tasks for Confidential Case Manager and Confidential Content Navigator systems to ensure function according to specifications.
- Developed appropriate test scenario and prepared effective test plans and test cases for complex web- services-based product such as ICM and ICN, based on project requirements.
- Worked with other testers and key stakeholders, analyzing business and project requirements.
- Created automation framework in Selenium by using TestNG and Junit in Eclipse IDE to automate test cases, supporting automated software testing.
Confidential, Irvine, CA
Web Developer
Responsibilities:
- Created web pages for holiday campaign, supporting daily / weekly advertising emails.
- Troubleshot website errors / bugs in Visual Studio .NET application, keeping website updated.
- Developed Browser Driver application in JavaScript, enabling retrieval of browser-related data to meet user requirements.
Confidential, Long Beach, CA
Graduate IT Intern
Responsibilities:
- Developed MS Access application, enabling maintenance of records for CalWORKs program.
- Created and maintained user documentation, including documentation of set up and running of system processes, ensuring accuracy, and efficient processing.
Confidential, Aliso Viejo, CA
Database Analyst
Responsibilities:
- Managed website contents using content management systems Drupal and Joomla. Created and maintained fields and forms in ERP system. Managed database and ran DTS packages.
- Managed EDI maps and integration with ERP system and database consistency checks, ensuring data integrity.
Confidential, Laguna Hills, CA
Database Technician Intern
Responsibilities:
- Confidential, analyzed, and compiled data using MS Access and Excel from wide variety of data sources to process in MS Access macros for generating environmental site assessment reports.
- Developed, enhanced, and maintained build, deployment, and configurations for continuous integration and automated regression, acceptance testing, and deployment.
- Automated deployments in development and production environment by using configuration management using tools and framework.