We provide IT Staff Augmentation Services!

Senior Bi Analyst/business Intelligence Resume

2.00 Rating

SUMMARY

  • Extensive experience in Business Intelligence (BI), ETL, Data Warehousing, Reporting, Data Modeling, Data Analysis, and OLAP. Strong in Informatica, SSIS, Cognos, Business Objects, MicroStrategy, SQL, T - SQL, Oracle PL/SQL, and other BI/Reporting tools.
  • Extensive experience wif ETL and Business Intelligence (BI) Tools including Informatica ETL, SQL Server (T-SQL, SSIS, SSRS), Business Objects, MicroStrategy, Cognos, Oracle PL/SQL, SQL, Data Modeling, Analytics, OLAP, and Data Mining Tools.
  • Strong Experience in SQL, T-SQL, PL/SQL, Oracle, SQL Server, and other databases.
  • More than 12 years of IT experience in Business Intelligence(BI), Data Warehousing, ETL, Reporting, Data Modeling, Star Schema/Dimensional Modeling, Data Analysis, Data Mining, Business Analysis, Requirements gathering, design, coding, testing, and implementation.
  • Extensive experience wif Informatica ETL PowerCenter.
  • Developed ETL processes using Informatica, SSIS, Oracle PL/SQL, SQL, and SQL*Loader.
  • Well experienced wif SQL Server BI Tools - Microsoft BI (SSIS, SSRS, T-SQL).
  • Well experienced in MicroStrategy BI Tools Suite including MicroStrategy Desktop, Architect, MicroStrategy Web, Report Services, Intelligence Server, and NarrowCast Server.
  • Experience in designing and developing MicroStrategy Projects including Schema Objects, Attributes, Facts, Metrics, Filters, Prompts, Reports, Dashboards, and Free Form SQL (FFS).
  • Well experienced in Cognos BI Tools including Framework Manager, Report Studio, Cognos Connection, Query Studio, Analysis Studio, and Metric Studio.
  • Well experienced wif Business Objects XI (BO XI) BI Suite - Universe Designer, Web Intelligence (Webi), Deski, Crystal Reports, Xcelsius, CMC (Management Console), Infoview.
  • Advanced Excel and VBA skills including Macros, VBA, complex formulas, pivot tables etc.
  • Extensively used Cognos Framework Manager to develop Reporting Models and Packages.
  • Created complex reports, metrics, KPIs, and dashboards using Cognos Report Studio.
  • Designed and developed Business Objects Universes, Webi Reports, Dashboards, and Metrics.
  • Experience in OBIEE (Oracle BI), SQL Server BI (SSIS, SSRS), Tableau, Excel, VBA.
  • Developed and maintained complex SQL Server T-SQL and Oracle PL/SQL Stored Procedures, Packages, Views, Materialized Views, Functions, and various other database objects.
  • Well experienced in Extracting, Transforming, and Loading (ETL) data for data analysis, reporting, data migration, data conversion, and other data integration tasks.
  • Strong database skills in Oracle, SQL Server, Access and other relational databases (RDBMS).
  • Excellent Analytical skills wif strong experience in data analysis and business analysis.
  • Extensive work experience wif Healthcare data, Claims, Encounters, HIPAA EDI Transactions.
  • Familiarity wif Epic Clarity Data Warehouse and Reporting.
  • Broad business functional experience in Reporting and Analyzing data from various business areas including Healthcare / Clinical, Sales, Finance, Marketing, CRM, Call Center Operations.
  • Data from Customer Support, Supply Chain, Manufacturing, and other functional areas.
  • Experience in business analysis, project management, business modeling, and data modeling.
  • Extensive experience in assessment, requirements gathering, business analysis, gap analysis, design, planning, and project management.
  • Excellent communication skills, strong business and system analytical skills.
  • Successful in Planning, analyzing, coding, documenting, and meeting user requirements.
  • Proven track of record on all stages of project and Software Development Life Cycle (SDLC).

TECHNICAL SKILLS

BI/ET: Informatica ETL, SSIS, SSRS, SQL, Business Objects, MicroStrategy, Cognos, Oracle PL/SQL

Databases/Tools: Oracle, SQL Server, T-SQL, Oracle PL/SQL, SQL, SQL*Loader, SQL*Plus, MySQL, Informix, Access, TOAD, OBIEE, MS Excel, Excel Macros/VBA, Power BI, Tableau, Talend, Hadoop, Hive

Business Objects: Universe Designer, Webi (Web Intelligence), Crystal Reports, Xcelsius, InfoView

Cognos BI: Framework Manager, Report Studio, Query Studio, Cognos Connection, Analysis Studio

MicroStrategy: MicroStrategy Desktop, Architect, MicroStrategy Web, Report Services (Dashboards and Documents), Intelligence Server, and NarrowCast Server

Operating Systems: Unix, Linux, Windows, HP-UX (Unix), Solaris, SCO Unix

PROFESSIONAL EXPERIENCE

Senior BI Analyst/Business Intelligence

Confidential

Responsibilities:

  • Design and development of Reports, Dashboards, Analytics, and Business Intelligence (BI) solutions using Business Objects (BO XI), MicroStrategy, Cognos, SQL, PL/SQL, and Oracle.
  • Extensively used Informatica Powercenter designer, workflow manager, and workflow monitor for various ETL activities; Created Informatica mappings, sessions and workflows for ETL.
  • Developed and maintained complex ETL (Extract, Transform, and Load) processes using Informatica ETL, PL/SQL, SQL, SQL*Loader, Stored Procedures, Packages, Materialized Views.
  • Interacted wif different business teams to gather requirements for reporting and analysis.
  • Designed and developed MicroStrategy Projects, Schema Objects, Metrics, Reports, Dashboards, Free Form SQL Reports, and other public objects using MicroStrategy BI suite.
  • Extensively used MicroStrategy Desktop, Architect, Report Services, Narrowcast, me Server.
  • Developed various Reports, Dashboards, Metrics, and analytics using Cognos Report Studio.
  • Designed and developed reporting models and packages using Cognos Framework Manager.
  • Developed Query subjects/item, Filters, Calculations, Parameter maps, query prompts, cascading prompts, and other objects using Cognos Framework Manager and Report Studio.
  • Design, Modeling, and development of various Business Objects Universes using Designer.
  • Created Reports, Dashboards, and Metrics using Business Objects Webi, Deski (BO XI).
  • Performance tuning of Reports - Tuning and optimization of database queries and SQL scripts to resolve issues wif reports generation and better performance of reports.
  • Reporting, Data Analysis, Data Mining, and Querying using MicroStrategy, Business Objects, Cognos BI, SQL, Oracle PL/SQL, TOAD, and other database query tools.
  • Created views, materialized views, summary tables, and aggregates for reporting, analytics, and OLAP using Cognos, MicroStrategy, Business Objects XI etc.
  • Developed and delivered ad hoc reporting via SQL queries, PL/SQL Scripts, Views, MS Excel.
  • Extraction and Conversion of data from various data sources for reporting and data analysis.
  • Maintenance and modification of existing reports as well as creation of new reports.
  • Developed ETL processes using Informatica, Oracle PL/SQL, SQL, and SQL*Loader.
  • Developed Informatica ETL mappings, PL/SQL, SQL scripts, SQL Loader, and Unix Shell scripts to perform data extraction and load for various reporting and data mart requirements.
  • Wrote SQL and PL/SQL scripts to create and modify database objects including tables, views, materialized views, stored procedures, packages, functions, triggers, indexes, constraints etc.
  • Data Warehouse/Data Mart design and modeling (Star Schema, Snowflake Schema, Slowly changing dimensions, Facts, Aggregate tables etc).
  • Developed complex SQL queries and fine-tuned the SQL queries for performance.
  • Profiling of source system data to ensure data quality, and developed data conversion rules.
  • Performed requirements analysis and gap analysis, worked wif business users and source data SMEs to deliver data to meet the business intelligence and data analysis needs.
  • Extraction of data from database tables to Flat files and various other formats.
  • Extensively involved in the requirements gathering, user interviews, business analysis, design, coding, user acceptance testing, and implementation.
  • Prepared Business Requirements Spec and Functional Design Documents.
  • Developed project plan, test plan, and related project management documents as needed.
  • Preparation of test plans; perform unit and integrated testing, and user acceptance testing.
  • Troubleshooting of problems during the testing, bug fixing, and documentation.

Environment: Informatica Powercenter, SSIS, Cognos BI, MicroStrategy, Business Objects, SSRS, SQL, T-SQL, Oracle PL/SQL, Oracle database, SQL Server, Cognos Framework Manager, Report Studio, BO Universe Designer, Webi, Deski, CMC, Tableau, Erwin, Unix, Shell scripts, Python, FTP, XML

Database Developer/Analyst

Confidential

Responsibilities:

  • Requirements gathering, business analysis, gap analysis, and design for HIPAA and EDI.
  • Modification, enhancement and testing of programs and data for HIPAA compliance.
  • Development and implementation of daily and periodically run reports and automated batch processes using PL/SQL, SQL, Unix cron jobs calling Unix scripts.
  • Wrote SQL scripts and programs to extract data into flat files from database tables.
  • Wrote SQL scripts and programs to load data from flat files into database tables.
  • Wrote a data migration utility to transfer data from different sources to the central database using Oracle PL/SQL, SQL, SQL*Loader, Informix 4GL, Unix, Shell scripts.
  • Design, implementation, support and maintenance of database, tables, and related objects.
  • Preparation of test plans, Testing and troubleshooting of problems during the testing.
  • Post implementation support, bug identification and resolution.

Environment: Oracle PL/SQL, SQL, Informix 4GL, Crystal Reports, Shell scripts, Unix

Programmer Analyst

Confidential

Responsibilities:

  • Data mapping and conversion from the legacy system into Oracle database and testing.
  • Data migration from old system to the new system, all related tests and process.
  • Design and development of various Reports using SQL, PL/SQL, and Cognos Impromptu.
  • Analysis, design, development and implementation of the back-end batch processes.
  • Developed and maintained stored procedures, packages, functions, views, triggers, and other database objects using Oracle PL/SQL and SQL for Reporting and batch processes.

Environment: Oracle PL/SQL, Oracle database, SQL, Cognos Impromptu, Informix, SQL*PLUS, SQL*Loader, Forms, Reports, Unix Shell scripts, HP 9000 (HP-UX)

We'd love your feedback!