Business Intelligence Analyst Resume
San Jose, CA
SUMMARY:
Seeking a position that helps me to build a professional career and enhance my skills in my area of interest.
TECHNICAL SKILLS:
Programming Languages: C, C++, Core Java, Python.
Scripting Languages: Java script, Python.
Database: Microsoft Access, MySQL, SQL, ORACLE 11g/12c
Search engines: Elastic Search.
Frameworks: Django and Bootstrap.
Web development: HTML, CSS, XML.
Application Software: MS Office.
Operating Systems: Windows and Linux.
Reporting Tools: BRIO, OBIEE, TABLEAU.
Other Software: JIRA
MANAGEMENT SKILLS:
- Client Interactions
- Technical Presentations
- Functional Design Involvement
- Software Asset Management.
EXPERIENCE:
Confidential, SAN JOSE, CA
Business Intelligence Analyst
Responsibilities:
- Hands on experience on tools such as BRIO, OBIEE AND TABLEAU.
- Acquired working knowledge on Report Analysis and Data Analysis.
- Worked on Report/Dashboard design and Relational data - warehouse Modelling.
- Exposure to Writing Data-extraction queries using SQL.
- Got trained in ETL and Software/BI Testing.
- Good experience in developing SQL queries to validate the databases tables and reports data for backend database testing.
- Developed documents, Business Requirement documents, Functional requirements documents and system requirement specifications.
- Worked on Microsoft Word, Power point and Excel for creating project plans and documentation.
- Aiming to use my strong communication skills and analytical ability to achieve the goals of your company.
Environment: Oracle 12 C, BRIO, OBIEE, MS EXCEL, WINDOWS7, NOTEPAD++, TABLEAU, DBEAVER.ITC
Confidential, San Jose, CA
Software Developer
Responsibilities:
- Built a web portal for importing data from external databases and excel files.
- The data can be viewed using simple html pages.
- Used “Django” as the framework.
- Used “Elastic search” and created the search mechanism.
- Worked on “Logstash” which is used to collect, store and parse logs for future use. And “Kibana” which is a visualization plugin for ElasticSearch.
- Handled both Front-end and back-end for the project.
- Worked on new technologies and gained good confidence.
Environment: WINDOWS7,MS EXCEL, NOTEPAD++, PYCHARM, PYTHON 3.6, ELK(Elasticsearch,logstash,kibana), MYSQL WORKBENCH.
Graduate Assistant
Confidential, Springfield, IL
Responsibilities:
- Involved in understanding of business processes to learn business requirements
- Learned data extraction from different systems into Source
- Understood and implemented ETL development by defining and implementing approaches to load and extract data from database using Data Stage
- Worked closely with data warehouse architect and business intelligence analyst in developing solutions
- Involved in design, source to target mappings between sources to operational staging targets, using Data Stage Designer.
- Good verbal and communication skills.
Environment: Data Stage 8.x/7.x (Designer, Manager, Director), Oracle 9i, MS Access, SQL-Server2000/2005, SQL, PL/SQL, Toad, UNIX.
Confidential
Business Data Analyst
Responsibilities:
- Performed analysis of product/process launches in the environment
- Worked closely with developers, Quality assurance analysts, architects, Business partners and other technology teams to ensure requirements and design are completely understood
- Participated in agile meetings
- Understanding/documenting the requirements of the client request and build SQL reports. Used our company ETL model tools to load and map the data into the homegrown layout
- Used Oracle and SQL server databases in loading/mapping the data into the product layout.
- Performed testing and troubleshooting the software
- Used Microsoft access, text format, excel for retrieving accessing the data
- Participated in scheduling automation runs and written test cases on the product functionality.
- Good understanding, documenting and communicating skills in a non-technical manner.
Environment: Oracle 11g, MS SQL Server 2008/2005, Windows7, XP, MS office, JAVA, Eclipse, MS Excel.
