We provide IT Staff Augmentation Services!

Business Intelligence Engineer Ii Resume Profile

Background Summary:

  • 9 plus years of Development Experience in SQL Server Analysis Service SSAS , SQL Server Integration Service SSIS , SQL Server Reporting Service SSRS , Crystal Reports/BusinessObjects, Spotfire SmartView and Erwin data modeling.
  • Modeled and Created Enterprise Data Warehouse EDW and created all supporting ETL package.
  • Successfully Implemented Self-Service BI Initiative using SSAS Cubes and SQL Server Views.
  • Expert on Transact-SQL DDL, DML , Stored Procedure, Performance Tuning/ Query Optimization.
  • Extensively used CDC Change Data Capture to handle SCD Type 1 and SCD Type 2 Data Warehouse WH Load.
  • Experience in developing master/child package, package configurations and Logging.
  • Excellent knowledge on using Expressions and Variables in package to make it dynamic during run time.
  • Extensively used Sequence, For Loop and ForEach loop Containers to loop through the task until a criterion has been met or to group a set of tasks logically.
  • Experience in Importing/Exporting Data from various data sources like SQL Server, Spreadsheet, Oracle, DB2 and Flat files/Excel files using SSIS utilities.
  • Created Package Configuration and migrated to QA/Test/UAT/Production to make package more dynamic during run time. .
  • Expert in creating Indexes, Views, Indexed Views, Stored Procedure, User Defined Functions, Temporary Tables, Common Table Expression CTE , Table value parameters TVP and Triggers to facilitate efficient data manipulation and data consistency.
  • Created Logical Physical Data Model and used it to generate Relational/Dimensional Database Schema Forward Engineering . Also generated Logical/ Physical Data Model from Relational/Dimensional Database Schema Backward Engineering using Erwin r8.3.
  • Worked with End-To-End implementation of Data warehousing team and Strong understanding of Data warehouse concepts, Star Schema, Snowflake Schemas and Multi-Dimensional Models in respective to query and analysis requirements.
  • Expert in databases like SQL Server 2012/2008 R2/2005/2000, DB2 and MS-Access.
  • 5 years of experience in designing, developing and administering Reporting System using BusinessObjects. Worked on Full Client, Thin Client, Designer, Infoview and Broad Cast Agent.
  • Administer the BusinessObjects XI R2 application using Central Management Console CMC and Central Configuration Management CCM .
  • Expert in Designing and Developing Universe business view of the database , updating and maintaining the existing Universes. Created several Derived tables in Universe and Created Custom SQL to create more flexible and robust reports.
  • Experience in Installation, migration, maintenance, and troubleshooting and overall administration of the BusinessObjects Suite.
  • Expert in creating reports using the BusinessObjects functionalities like Prompts, Slice and Dice, Drill Mode, Filtering.
  • Expert on Application Foundation Configuration, System configuration, AF Universe Configuration and Application Foundation Security Configuration.
  • Software Professional with proven record of task achievement, excellent communication, interpersonal, analytical and functional skills.
  • Ability to effectively multitask, meet deadlines, quickly accommodate to different project environments and an excellent team player.

Technical Skills:

BI Tools: SQL Server Analysis Service SSAS 2005/2008/2012, SQL Server Integration Server SSIS 2005/2008/2012, SQL Server Reporting Service SSRS 2005/2008, BusinessObjects XI R2/6.5, Crystal Report, Spotfire SmartView .

ETL Tools: SQL Server Integration Service 2012/2008/2005 SSIS

Data Modeling Tool: ERwin r8.3

Platforms: Windows, UNIX/LINUX

Databases: MS SQL Server 2012/2008 R2/2005/2000, DB2, Oracle 10g/9i/8i, MS Access.

Languages: C, C , VB.NET, T-SQL and PL/SQL.

EXPERIENCE

Confidential

Business Intelligence Engineer II

  • Modeled and Created Enterprise Data Warehouse EDW using Ralph Kimball's Dimensional Modeling concept.
  • Created all supporting ETL packages to handle both Incremental Loading as well as any SCD Slowly Changing Dimension Type 1 and SCD Type 2 Changes.
  • Planned and Implemented Self-service BI application using both SSAS Cubes and SQL Server Views.
  • Automated user's data request using SSIS package and Stored Procedure.
  • Worked with Business to craft BRD Business Requirement Document and Translate that to self-service BI solution.
  • Spearheading the Align Network's WH expansion and Self-service BI initiative as a WH Owner.

Confidential

Development DBA

Extensively used Confidential and created several Confidential to move data around the data warehouse/data marts and from operational data source to the Data-Warehouse/ODS/Data Marts.

  • Extensively created and maintained SQL Server Analysis Service SSAS cubes.
  • Extensively used bottom up or top down methodology to build SSAS database, deploy to production and create agent job to build them
  • Expert on Data Modeling and created data marts/ ETL packages to support data structure for SSAS Cubes.
  • Extensively created Common Table Expression CTE , Table value Parameters TVP , Stored Procedure, Indexes and User Defined Functions.
  • Extensively used Erwin 8.3 to model the data mart using both forward and backward engineering.
  • Extensively used T-SQL Merges, variables and Expressions to make SSIS package more dynamic.
  • Extensively used SSIS Containers to loop through the task or files groups logically.
  • Created Package to handle errors/events automatically using Event Handlers.
  • Extensively used Breakpoints and Event Logs to debug package.
  • Extensively worked on Debugging and Tuning Stored Procedure.

Environment: SQL Server Analysis Service 2008 R2, SQL Server Integration Service 2008 R2/2012, SQL Server 2008 R2/2012, Erwin 8.3

BI Developer III

Extensively used Confidential and created several Confidential to move data around the data warehouse and from operational data source to the Data Warehouse tables.

  • Extensively created Tables, Temporary Tables, Common Table Expression CTE , Stored Procedure and User Defined Functions.
  • Extensively used variables and Expressions to make SSIS package more dynamic.
  • Extensively used SSIS Containers to loop through the task or files groups logically.
  • Created Package to handle errors/events automatically using Event Handlers.
  • Created Package logs in SQL Server/XML format for different events to debug the package.
  • Extensively used Breakpoints and Event Logs to debug package.
  • Extensively used Crystal Reporting 2008 to create dynamic reports.
  • Extensively worked on Debugging and Tuning Stored Procedure.

Environment: SQL Server Integration Service 2005/2008, SQL Server 2000/2005/2008, Microsoft SQL Server Management Studio 2005/2008, Crystal Report 2008.

Confidential

Business Intelligence Engineer II

Extensively used SQL Server Integration Service Confidential and created several Confidential to load data from feeder server and operational data source to the Data Warehouse tables.

  • Extensively created Database tables, Temporary Tables, Common Table Expression CTE , Stored Procedure and User Defined Functions.
  • Extensively used variables and Expressions to make package more dynamic.
  • Extensively used Containers to loop through the task or files groups logically.
  • Created Error Handling mechanism to make SSIS Package more dynamic.
  • Created Package to handle errors/events automatically using Event Handlers.
  • Created Package logs in SQL Server/XML format for different events to debug the package.
  • Extensively used Breakpoints and Event Logs to debug package.
  • Extensively used CheckPoints to restart the package from where it failed.
  • Created Package Configurations, Deployment Package SSISDeploymentManifest file and deployed to Production using Package Installation Wizard.
  • Extensively used SQL Server Reporting Service 2005 to create dynamic reports.
  • Created many views, stored procedure to create Information Link Info Link for SpotFire Smart View Application.
  • Administer Spitfire application along with its Users and Groups.
  • Extensively used Subversion for version control.

Environment: SQL Server Integration Service 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server 2000/2005/2008, Microsoft SQL Server Management Studio 2005/2008, Spotfire 3.2 Smart View , Subversion.

Confidential

Business Intelligence Developer

Extensively used SQL Server Integration Service Confidential and created several Confidential to load data from feeder server and operational data source to the Data Warehouse tables.

  • Extensively created Database tables, Temporary Tables, Common Table Expression CTE , Stored Procedure and User Defined Functions.
  • Extensively used variables and Expressions to make package more dynamic.
  • Extensively used Containers to loop through the task or files groups logically.
  • Created Error Handling mechanism to make SSIS Package more dynamic.
  • Created Package to handle errors/events automatically using Event Handlers.
  • Created Package logs in SQL Server/XML format for different events to debug the package.
  • Extensively used Breakpoints and Event Logs to debug package.
  • Extensively used Check Points to restart the package from where it failed.
  • Created Package Configurations, Deployment Package SSISDeploymentManifest file and deployed to Production using Package Installation Wizard.
  • Extensively used SQL Server Reporting Service 2005 to create dynamic reports.
  • Created many Conceptual Model Logical Model , Physical Model and Relational/Dimensional database schema forward engineering as well as generated conceptual model from Relational/Dimensional database schema backward engineering using ERwin Data Modeler r7.3.

Environment: SQL Server Integration Service 2005, SQL Server Reporting Services 2005, SQL Server 2000/2005/2008, Microsoft SQL Server Management Studio 2005/2008, Team Foundation Service TFS , ERwin r7.3.

Confidential

SQL Server SSIS Developer/Business Objects Developer

As part of consolidating and turning data into Information in LSV, I have been working as a SQL Server SSIS developer and Business Objects Administrator/Developer. As part of the product development team, I am involved in all aspects of SSIS package and report development from requirement gathering to migrating tested SSIS package/Web I reports to Production.

  • Created SSIS package to clean and load data to data warehouse.
  • Created SSIS package using Pivot Transformation, Fuzzy Lookup, Derived Column, Conditional Split, Sort Transformation, Merge, Merge Join, Multicast, OLE DB Command, Slowly Changing Dimension, Union All, Character map, Lookup, Term Extraction, Aggregate Transformation, Execute SQL Task, Data Flow Task to generate underlying data for reports and to export cleaned data from OLE DB data source, Text files, Excel Spreadsheets and flat files to data warehouse.
  • Extensively used Expressions and variables to make work flow and data pipe lines more dynamic at run time.
  • Extensively used Containers to loop through the task or to group the task logically.
  • Created tables to save dirty records for future analysis purpose.
  • Responsible for extracting data from source system to stage and stage to data warehouse on nightly basis.
  • Created SSIS packages to handle errors/events automatically using Event Handler.
  • Created package logs using different log provider type for different events to debug the package.
  • Extensively used Breakpoints and Event Logs to debug SSIS package.
  • Created performance tuning process by Limiting synchronous process, Reducing staging and disk I/O and reducing the reliance on the RDMS. Also increased performance by reducing number of execution trees, increasing execution threads and limiting synchronous component on the data flow design.
  • Extensively used Checkpoints to restart the package from where it failed.
  • Created Package Configurations and deployed to Production to dynamically configure a package at runtime.
  • Created Deployment Package SSISD elopement Manifest file and deployed to production using Package Installation Wizard.
  • Used Change Data Capture CDC to implement Incremental Data Extraction so that only the modified and new records will be extracted to the destination rather than full extraction.
  • Created Logical Model/Physical Model and used this to generate Relational/Dimensional Database Schema Forward Engineering as well as generated Logical Model using Relational/Dimensional Database Schema Backward Engineering using Erwin r7.3.
  • Responsible for analyzing business requirements and developing queries and reports using Business Objects.
  • Designed the Universe in Designer module of Business Objects XI R2.
  • Detected/resolved data Cardinalities and loops, checked integrity of Universes, created List of Values.
  • Edited Joins, resolved the loops using aliases and contexts in the universe and exported to CMS.
  • Created Classes, Dimension and Measure objects that are needed for reporting following the business usability.
  • Created custom hierarchies for Multi-dimensional analysis.
  • Set up Aggregate Awareness in universe to retrieve data quickly.
  • Extensively used Web intelligence to create reports.
  • Created the reports using Business Objects functionalities like Multiple Data Providers, Prompts and Drill Down.
  • Created and maintained thousands of scheduled Web I reports based upon the user requirement.
  • Administer and maintained Business Objects XI R2 Server, user license, Calendars and report security.
  • Installed Service Packs, monthly fixes, and hot fixes on BO XI R2 Server.
  • Created several reports using SQL Server Reporting Services SSRS .
  • Experienced on running ETL job using SQL Server Agent.
  • Involved in Documentation.

Environment: SQL Server Integration Service 2005/2008, SQL Server 2000/2005, DB2, SQL Query Analyzer, Microsoft SQL Server Management Studio, BusinessObjects XI R2 Designer, Web Intelligence XI R2, SQL Server Reporting Services 2005, Erwin r7.3.

Confidential

Sr. Business Objects Developer

Confidential is a leader in delivering innovative health care products, services and information to approximately 3.3 million members, Confidential served on behalf of other Confidential.

The scope of the project was to design BO Universes and used it to create reports regarding number of calls and inquiries from Providers and Members of the confidential insurance plans. The project also included creating and testing 33 reports related to confidential calls and inquiries. Prepared Business Objects System Design Document, which explains the Design of the BO Universe and Reporting Development Process, based on PRD Project Requirement Document and TRD Technical Requirement Document .

  • Identified the Data elements required for reporting.
  • Extensively used Designer to design universes.
  • Designed and developed a UNIVERSE in Designer module of Business Objects 6.5 based on Physical data model.
  • Resolved Loops using contexts created Dimension, Detail and Measure objects and exported Universe to the repository.
  • Created Hierarchies and customized LOV.
  • Created pre-defined conditions and Prompts as per requirement.
  • Created reports for multi Dimensional analysis using all BusinessObjects functionalities like Multiple Data Providers, prompts, Slice and Dice, Drill Down/Up/By.
  • Migrated Universe / Reports from Development/ QA to production.
  • Scheduled and Monitored Reports using Broad Cast Agent.
  • Executed SQL queries against database to verify the data quality in the Reports.
  • Published Reports to the Repository.
  • Generated Ad-Hoc Reports based on Use-Cases provided by the Business team and verified the Data Quality.
  • Used Crystal Reports to build Summary reports.
  • Extensively used Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master and Detail, Variables and Formulas.
  • Prepared Test Scenarios for Universes and Reports to ensure quality and Standards.
  • Design and Develop SSIS packages on BIDS Business Intelligence Development Studio platform to Extract, Transform and Load data from various data sources. Created Event Handlers to handle events raised during package execution. Created event logs, Debugged SSIS package using Breakpoints and SQL Profiler.

Environment: Business Objects 6.5, Desktop Intelligence, Crystal Reports, Oracle 9i/10g, SQL Server 2000/2005, SSIS 2005 SQL Server Integration Service , BIDS Business Intelligence

Confidential is a not-for-profit organization formed in Confidential as part of the restructuring of confidential electric power industry. Its mission is to ensure the reliable, safe and efficient operation of the State's major transmission system and to administer an open, competitive and nondiscriminatory wholesale market for electricity in Confidential. The scope of the project is to Configure Application Foundation, Repository Setup, Designing and Configuring metrics universe required to create Dashboard, System Configuration, Application Foundation Security Configuration and Enterprise metrics.

  • Installed and Configured
  • Set up Application Foundation Repository.
  • Created metrics Universe using Business Object Designer and pushed it to AF Repository to create enterprise metrics.
  • Configured AF calendar, created Sliced metrics based on dimension object and associated it with the users both manually importing users from BO repository as well as read from database based upon users rights .
  • Created dimensional analytics from metrics such as Interactive Metric trend, Speedometer and Traffic lights.
  • Used Performance Manager to assign goal or target to the different Dashboards.
  • Created Corporate Dashboards using Application builder and Personal Dashboards from Infoview home page.
  • Used Rules and Scheduler to automate Dashboards.
  • Created the secured Dashboard using BO Supervisor, which involves implementing security in Business Objects System and Application Foundation.
  • Used CI PROBE table and CI PROBE VALUE table to trouble shoot the metrics.
  • Created Metrics trees, Interactive Metric trend, Speedometer, Traffic lights etc.
  • Expert in designing BO universe and creating both ad hoc as well as canned report using BO designer.

Environment: Business Objects 6.5, Application Foundation 6.5, Infoview, Web Intelligence 6.5, Desktop Intelligence 6.5, Oracle 9i.

Hire Now