We provide IT Staff Augmentation Services!

Bi Solutions Specialist, Business Analyst Resume

TECHNICAL SKILLS

  • Business analysis and requirements specifications
  • BUS matrix, data mappings
  • Design, develop, test and maintain BI solutions
  • Data warehouse modeling
  • ETL, SQL scripts
  • Cubes, reports, dashboards
  • Migrate solutions to new environments
  • Install and configure SQL Server in cluster or stand - alone
  • Schedule daily/weekly backups
  • Schedule maintenance
  • Security considerations as per client requirements
  • Plan implementation schedules for CAB approvals
  • Schedule and automate data loads and processing
  • Efficient problem solving
  • Performance monitoring and enhancements
  • Agile methodologies

PROFESSIONAL EXPERIENCE

Confidential

BI Solutions Specialist, Business Analyst

Responsibilities:

  • Business analysis, data and system analysis (Murex) and requirements specifications
  • Data mappings
  • ETL using Informatica to load Oracle tables
  • Maintain data warehouse on Oracle, optimise data loads and views
  • Build Oracle Views to service SSAS cube
  • Build SSAS cube to summarize data
  • Reports using Excel, Power BI and Busines Objects.
  • Tasks maintenance and monitoring using Jira
  • Change management through CA Sercive Desk and CAB
  • Research possibilities of using Tableau desktop
  • Migrate solution from SQL Server 2008 to SQL Server 2016

Confidential

Analyst Developer

Responsibilities:

  • ETL using SSIS to load SQL data warehouse
  • Develop SQL XML scripts/stored procedures to write data to XML files
  • C# application development to talk to FIC servers and drop XML files
  • Automate process

Confidential

BI Solutions Specialist

Responsibilities:

  • Business analysis and requirements specifications
  • BUS matrix
  • POC using Excel Power BI
  • ETL using SSIS to load data from Oracle and text files to SQL Data Mart
  • Build cube to service Dashboard requirements
  • Create Dashboard to visualize company wide Capital Budget and Spend

Hire Now