We provide IT Staff Augmentation Services!

Bi Developer Resume

SUMMARY

  • 7 years of experience in the role of a Microsoft Business Intelligence Developer in the following:
  • Business Intelligence experience in Development, Client Analysis, Database Design, Reporting and Presentation using SQL Server 2008R 2/2012/2014/2016 , SSIS, SSAS and SSRS.
  • Proficient to build end to end data integration and workflow solutions from input source extraction, apply various transformations and data load
  • Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
  • Strong experience in using the Microsoft Suite (Management Studio, Business Intelligence Development Studio) (SQL) Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
  • Strong experience in client interaction and understanding business applications, Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
  • Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data
  • Good knowledge in designing OLAP (Online Analytical Processing) and OLTP (Online Transaction Processing).
  • A well - organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.
  • Performed data extraction, transformation and loading (ETL) between systems using SQL tools such as SSIS
  • Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
  • Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
  • Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
  • Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
  • Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports.
  • Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema.
  • Designing enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.
  • Good knowledge of Data Marts, operational data store (ODS), OLAP, Star schema modelling, Snow flake modeling for fact and Dimension tables.
  • Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
  • Created and maintained database objects (tables, stored procedures, and views).
  • Created Views to reduce database complexities.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/2003/ XP/NT/Vista/7/8/10, Windows Server 2003/2003 R2/2008/2008 R2

Database Tools: SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard

Data Modelling: Star-Schema Modeling, Snowflake-Schema Modeling, Fact and Dimension Tables, Pivot Tables

GUI Tools: SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2005/2008/2010/2015

Languages: T-SQL, VB Script, C#

OLAP Tools: SSIS, SSRS, SSAS

Source Control Tools: Visual Source Safe 2005, Team Foundation Server 2010

ETL Tools: SSIS, DTS, Import/Export Wizard

Microsoft Office: Word, Excel, PowerPoint, Outlook, Publisher, Access

PROFESSIONAL EXPERIENCE

Confidential

BI Developer

Responsibilities:

  • Created database objects like Tables, Views, Indexes and Stored Procedures.
  • Transcribed Progress queries to SQL queries.
  • Updated and worked with tables in Oracle.
  • Created SSIS Packages to migrate the data from Azure to SQL database.
  • Scheduled agent jobs to run at different intervals during the day to bring in data from Dynamic.
  • Re-created SSRS reports using current data and created subscriptions to send out reports.
  • Interacted with users to update previous reports.
  • Created new reports for users and customers.
  • Performed various tests to ensure data integrity of current data.
  • Configured DB mail that allowed help desk to create tickets for the team whenever any SQL jobs fails.
  • Create indexes to improve the query performance.
  • Updated and optimized existing stored procedures as well as create new stored procedures for migrated data.
  • Managed Axiom database in parallel to SQL Server Database.
  • Created documentation for various process during migration.

Environment: Windows 7/ Windows 10, SQL Server 2008R2/2015/2016 TSQL, SSIS, SSRS.

Confidential

SQL Server SSIS/SSRS ETL Developer

Responsibilities:

  • Created database objects like Tables, Views, Indexes and Stored Procedures.
  • Created Entity Relationship (ER) diagrams based on requirements.
  • Created SSIS Packages to migrate the data from database to Text files and developed SSIS packages for File Transfer from one location to the other using FTP task.
  • Expert in SSIS Look up, Fuzzy group transformations and Data flow tasks. Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into another database.
  • Worked on SSRS reports to report the Daily, Weekly and Monthly Statistics of various investors.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Involved in creation of various Dashboards used for reporting to the end user.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008.
  • Generated the drilldown, drill through and linked reports using the SSRS.
  • Transferred Data to data warehouse and exported files in various formats based on requirements using SSIS Packages.
  • Set up & configured DB mail and created jobs to send out an email whenever any SQL jobs fails.
  • Create the necessary indexes to improve the query performance.
  • Created SSRS server level, item level security and accessibility to various reports in a multi-user environment
  • Interacted with Business Analysts for understanding the Reporting Requirements for different investors.

Environment: Windows 2008, SQL Server 2008R2, TSQL, SSIS, SSRS, MS Visio.

Confidential

SQL Server SSIS/SSRS ETL Developer

Responsibilities:

  • Installed and configured SQL Server 2005 and 2008 on Windows server 2008.
  • Exported and imported data from text files and Excel to SQL Server using Bulk Insert and BCP utility.
  • Worked on SSIS packages for transferring data from various data sources like MS Access and Excel.
  • Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Designed SSIS Packages to extract data from various OLTP sources, Text Files, XML Files, Excel and MS Access to OLAP system like SQL Server.
  • Wrote complex T-SQL queries using Stored Procedures, Functions and Views.
  • Created various SSIS packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, Derived column, Lookup, Row Count.
  • Created reports in SQL Server Environment using SSRS in Business Intelligence Development Studio (BIDS).
  • Generated Sub-Reports, Drill down reports, Drill Through reports and Parameterized reports using SSRS for the end user requirements.
  • Worked with the front-end developers to deploy the reports.
  • Used MS SQL Server Profiler for auditing and analyzing the events.
  • Proper use of Indexes to enhance performance of individual queries for fast and efficient reporting.
  • Set up and configured DB mail and created operators to send out an email whenever any SQL jobs fails.
  • Created Views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.

Environment: SQL Server 2005/2008 Enterprise Edition, Windows 2008/XP, SSIS, SSRS.

Hire Now