Business Intelligence Engineer Resume

SUMMARY

Over 12 years of IT experience with 10 Years of experience, specializing in Business Intelligence.
12 Years of experience in Metadata Modelling.
Conducted research and made recommendations on BI products and services.
Directed, organized, and lead projects in the full life cycle development, implementation, production support, and performance tuning of the Enterprise Business Intelligence Reporting environments.
Proficiency in SQL and relational database design.
Experience in JavaScript and other Client - side technologies.
Vast experience in working with various RDBMS such as SQL Server, Oracle, DB2.
Excellent communication, presentation, project management skills.
Ability to work independently and collaboratively within a team.

TECHNICAL SKILLS

Data Warehousing: Microsoft SSIS, Informatica Power Center 8.1/7.3/7.1, IBM DataStage 8.1

Business Intelligence: Cognos Analytics, Tableau and Power BI

Data modeling tools: ERwin 3.x/4.0

Operating systems: Windows 10/8/7

RDBMS: Oracle 7.x/8.0/8i/9i/10g, DB2 7.2/8.1, MS-SQL Server 2016, MS Access 2016.

Oracle Tools: SQL Plus, SQL loader.

Languages: SQL, PL/SQL, C, C++.

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Engineer

Responsibilities:

Planned, installed, monitored and performance tuned business intelligence platforms and performed periodic upgrading and patching of the BI software.
Built Principal dashboards, scorecards and Cubes projecting the Graduation, Dropout and Suspension rates of schools and which provided actionable data to initiate a remedial action for following School Years.
Collaborated with enterprise data warehouse, data governance, and business teams on data quality issues, as well as architecture or structure of data repositories.
Worked closely with network team to enhance and maintain Windows Active Directory security groups used to enable single sign on access to various business intelligence tools and portals.
Ensured conformity of data sources to student and employee data privacy protocols.
Designed and developed universal semantic layer to ensure the end users access data autonomously using common business terms.
Designed and developed data modules for rapid visualization and actionable insight through self-service analytics.
Designed and delivered end-user training and training materials.

Environment: Cognos, Tableau, Power BI, SQL Server, Windows Server

Confidential, NY

BI Admin

Responsibilities:

Responsible for building maintaining and supporting the Reporting, Dashboarding and Scorecarding environments.
Close interaction with Business Users.
Part of Data warehouse team, providing technical inputs in building robust Reporting Model.
Performance tuned FM models and reports by reducing number of query joins and using modeling best practices.
Recommended building MQT or aggregated tables for monthly or yearly aggregations for highly summarized reporting requirements.
Assisted in migration from Cognos 8.4 to Cognos 10 and building proof of concepts of new Cognos 10 features such as Business Insight, Active Reports.

Environment: Cognos 10,8.4,8.2, Cognos Metrics Manager, Event Studio, Report Studio, Query Studio, Analysis Studio, Framework Manager, Powerplay Transformer, IBM DataStage, DB2, SQL plus, Computer Associates’ SQL-Station.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship