Business Systems Analyst Resume Fremont,CA - Hire IT People

SUMMARY:

Developing and optimizing complex SQL queries in DB2, Oracle, Microsoft SQL Server, MySQL
Over 13 years of experience in writing Triggers, Functions, Views and Stored Procedures in major databases
Data Modeling Tool - Erwin, PowerDesigner, Teradata LDM, IBM EZMart
Database - Oracle, DB2, Microsoft SQL Server, MySQL, Teradata, SAP IQ, Sybase, Informix
MDB - Cognos, Essbase, DB2 OLAP Server, BOARD MIT
ETL toolkit - Informatica PowerCenter Mappings, Mapplets, Transformations, Sessions, Workflows; Oracle DataIntegrator; and IBM DataStage for ETL processes
Reporting - OBIEE, Brio, ReportNet, BO, and knowledge of Crystal and Tableau
Architecture - Star schema, Snowflake schema, OLAP, Data Warehouse, Data Mart, ODS, ETL
Programming Languages - SQL, PL/SQL, JAVA, C, VB; HTML, JavaScript, JSP, ASP, XML
Operating System - Windows NT, Unix, Solaris, AS400, RS6000, Mac
Infrastructure - VMware, VSS, VNC
Project Management - Delivered 20+ large BI projects throughout the entire life cycle
SDLC – Agile and Waterfall

PROFESSIONAL EXPERIENCE:

Confidential,Fremont,CA

Business Systems Analyst

Responsibilities:

Gather and analyze the business requirements for different clients.
Create complex SQL, responsible for data integration and analysis.
Build specific business strategies and plans, help to win the new contracts.
Design and implement customized system architectures, IT solutions and services.
Manage clients’ expectations and project deliverables using Agile.
Maintained and optimized clients’ business requirements and systems.

Technology: MySQL, DB2, Oracle, Microsoft SQL Server, Erwin.

Confidential,Arkansas

E-Learning Graduate Assistant

Responsibilities:

Supported E-Learning requirements, such as developing requirements using Articulate Storyline and Camtasia; worked for Faculty Technology Showcase; performed research of suitable E-Learning software, such as Canvas, VoiceThread, Quizalize, CMS, Percussion CM1, etc.

Technology: MySQL, DB2, Oracle, Microsoft SQL Server, Erwin, multiple E-Learning software.

Confidential

Sr. Business Intelligence Lead

Responsibilities:

Gathered requirements, designed the system architecture, ETLs, and applications.
Developed code and provided technical consulting throughout life cycle.
Developed complex SQL, stored procedures, views, and functions.
Responsible for translating data to multiple sources.
Built and managed testing strategies and plans.
Managed stakeholders’ expectation and project deliverables using Agile.
Maintained and optimized the system.

Technology: DB2, Oracle, Microsoft SQL Server, MySQL, PLSQL Developer, Informatica PowerCenter, OBIEE.

Confidential

Sr. Business Intelligence Lead

Responsibilities:

Worked as a Pre-sale before project, wrote project proposal, and helped to win the contract.
Gathered and analyzed user requirements.
Designed the system architecture, ETLs, reports, and applications.
Developed the system prototype and ensured users’ sign-off.
Managed project execution in Waterfall.
Coded and provided technical consulting during implementation.
Built and managed testing strategies and plans.
Managed project environments, changes, and releases.