Business Intelligence analyst /Data analyst Resume

SUMMARY:

Over 2 and half years’ experience as a BI analyst/data analyst in gathering requirements, analyzing the data, writing use cases, creating workflow diagrams, ERD’s, creating reports, and applications ( Confidential ).
Experience in Microsoft Excel reporting and Confidential reporting.
Experience in Life Cycle Development including Planning, Analysis, Design, testing and Implementation and Maintenance data warehouse.
Experience in SharePoint update and cleanup.
Expertise in Data Modeling using Star Schema/Snowflake Schema and Fact and Dimensions tables, understanding of database concepts including Kimball model, and Inmon model.
Expertise in identifying fact and dimension tables, Logical and physical data modeling, Star, Snow - Flake modeling, and Query Optimization.
Strong understanding of Strategy concepts includes SWOT analysis, Porter five forces, Competitive advantage (cost effective and diversity) and Blue Ocean.
Strong understanding of production, manufacturing, Quality Assurance, Six sigma, automobile and engines concepts through my undergraduate.
Applies strategies to achieve the goals by using resources, ability to work in a challenging environment where my inherent skills are efficiently used by the organization, work with different kind of people and continuously upgrade my skills to keep pace with the rapidly changing environment.

TECHNICAL SKILLS:

Skills: Database concepts, Data warehousing concepts, System Development Life Cycle (SDLC), USE cases, Entity Relationship Diagrams (ERD s), UML diagrams, SQL, ANSI SQL, T-SQL, PLSQL, SQL Developer, Oracle Data Modeler, Unix s, Oracle Application Express ( Confidential ), TOAD, OBIEE, ETL (Informatica), SQL Plus, Microsoft Excel pivot tables, Microsoft Word, Microsoft PowerPoint, HTML, Tableau, SharePoint, SWOT analysis, Porter five forces, and Competitive advantage.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

I honed my database skills and Confidential development Skills by helping Confidential with their Database and Confidential needs. I helped university with updating and cleaning in SharePoint. As part of this practicum course, we helped Confidential with Database installation, Upgrading, and on-call support. As part of my Practicum II we did Confidential project (Team Project) for DCI Organization ( Confidential Inc. ) DCI is a non-profit organization and it helps to build better communities by providing assistance to Colorado downtowns, commercial districts, and town centers.
I created a survey for their members by using survey builder application in the Confidential . Survey builder app includes tables, sample surveys, and features to create the survey (create surveys, add questions, sections, answers, and logo). We changed survey builder application according to our requirements.
I created some interactive and bar chart reports (with filters) for the survey responses and changed some queries in packages to add one more skip condition.

Confidential

Business Intelligence analyst /Data analyst

Responsibilities:

Queried the database using Structure Query Language (SQL) and created reports using Excel and SQL developer.
Gathered business requirements from the users, wrote use cases and created logical, physical ERD’s for the Confidential applications.
In addition, I created reports for those applications by using Oracle Application Express ( Confidential ).
I also drafted, searched mechanical, general and software patents.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship