We provide IT Staff Augmentation Services!

Senior Bi Developer Resume

SUMMARY :

  • Over 7+ Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008R2/2005, SSIS, SSAS and SSRS.
  • Overall 7+ years of experience in analyzing, design, development, maintenance and troubleshooting various business systems using Microsoft programming technologies
  • Experienced in interacting with Business Users for analyze the business processes and requirements, transforming the requirements into designing databases.
  • Have 7+ years of experience in developing Business packages using SSIS (SQL Server Integration Packages),developing reports using SSRS (SQL Server Reporting Services) and Have 6+ years of experience in creating cubes, dimensions and measures using SSAS(SQL Server Analysis Services)
  • Expertise in using SSIS tool like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Experience in migration of Data from heterogeneous databases like Excel, Flat files, MS Access, Oracle to SQL Server using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
  • Excellent in creating SSIS Packages for integrating data using OLE DB connection from various sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Look up, merge join and union all.
  • Experience in creating configuration files to deploy the SSIS packages across all environments.
  • Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row, Block and Unblock Transformations.
  • Experience in creating schedule jobs, SQL Mail Alerts and SSIS Packages using SQL Server Agent.
  • Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, partition and aggregation using SQL Server Analysis Services.
  • Expertise in Creating, Managing and Deploying SSRS Reports on the portal for user accessibility.
  • Strong Experience in creating Drill down, Drill through, parameterized, Cascade parameterized, Sub, Linked, Charts and Snapshots using SSRS based on Relational and Multidimensional databases.
  • Experienced in installing and configuring Reporting services and assigning permissions to different levels of users and worked with Report manager for deploying the reports across all the environments.
  • Absolute knowledge of software development life cycle(SDLC), database design, RDBMS, data warehousing and data modeling concepts.
  • Expertise in writing Confidential - SQL Queries, Dynamic-queries, sub-queries, complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions and Views
  • Expert in Performance Tuning and Optimization of SQL Server, SQL scripts and Stored Procedures
  • Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies
  • Experienced in building self-serve BI reports using Excel Power Pivots
  • Have extensive experience in creating and implementing DB’s using SQL Azure.
  • Experienced in working with SQL Azure, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008,2005 and Oracle
  • Have 3+ years of experience in developing SharePoint Applications using MOSS, and Sharepoint 2010. Experienced in Content Management, Custom Application Pages, Site Pages, Content Types, Data Manipulation, Business Intelligence and Administrative Utilities
  • Have more than 3 years of experience in developing Web applications using C#, ASP.NET 2.0, 3.5, 4.0 and Web Services using WCF
TECHNICAL SKILLS

DBMS: SQL Server 2012/2008/2008 R2/2005, SQL Server 2000, Oracle, SQL Azure

Report Designing Tools:

SSRS 2012/2008/2005 :

Crystal Reports Business Intelligence tools:

SQL Server Data Tools:

SQL Server 2008 Business Intelligence tool(SSRS, SSIS, SSAS), SQL Server 2005 Business Intelligence tool(SSRS, SSIS),:

OBIEE ETL Tools:

SSIS 2012, SSIS 2008, SSIS 2005:

Programming languages:

C#, VB.NET:

Server Side Programming Languages:

ASP.NET 4.5/4.0/3.5/3.0/2.0/1.1 :

OLAP Tools:

SSAS 2012, SSAS 2008, SSAS 2005 Versioning systems SVN, VSTF,VSS:

SharePoint Products:

WSS 3.0, MOSS 2007, Sharepoint 2010, Sharepoint 2013, Office 365:

Web Servers:

IIS 6/7/7.5 Analysis & Design Object-Oriented Programming (OOP):

Scripting Languages:

JavaScript, VBScript Web standards XML, HTML, CSS, HTTP, SMTP:

PROFESSIONAL EXPERIENCES

Confidential, WA

Senior BI Developer

RESPONSIBILITIES:

  • Responsible for interacting with business users and gathering system requirements, analysis of functional and technical specifications.
  • Identifying the technologies that suite for the customer requirements and preparing the proof of concepts
  • Developed and maintained multiple SQL Server Integration Services (SSIS) packages. Some are very simple table pulls, but many are very complex with Slowly Changing Dimensions, SharePoint list downloads and other complex functions. Experienced with many sources of data including flat files, XML, SharePoint, Access, and proprietary ODBC drivers.
  • Responsible for pulling data from Oracle database using SSIS
  • Responsible for developing complex SSRS reports using advanced features like tablix controls and other techniques.
  • Responsible for developing self-service reports using excel power pivots, and integrated with different types of SharePoint applications.
  • Responsible for developing and maintaining wide range of small to extremely complex cubes with large set of fact tables and measure groups using SSAS
  • Migrated a series of SSAS cube and the entire supporting solution from SQL Server 2005 to 2008, and also migrated SQL Server 2008 to SQL Server 2012. This involved multiple databases, SSIS packages, and SSAS cubes.
  • Responsible for migrating existing SSIS ETL packages to use Azure databases instead of on-premises databases.
  • Responsible for all administration tasks on 3 production SQL Servers. This includes setting up database authentication, performance tuning, and data base maintenance. Also responsible for maintenance items such as backups and patches. One of the servers is a virtual server using Windows 2008 Hyper V, so also experienced with the unique needs of virtual environments.
  • Developed windows service for transform and load sharepoint online lists data to and from SQL databases.
  • Developed web services (Asmx and WCF) to expose data onto different applications.

Environment: MS SQL Server 2012/2008R2, Visual Studio 2010/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SharePoint Server 2010, Visual Basic 6.0/VB.net, VB Script

Confidential, OR

MS SQL/BI Developer

RESPONSIBILITIES:

  • Working with complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Designed and developed SSIS Packages to extract sales data of the products from oracle ERP
  • Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bulk Insert task, Script task in SSIS Control Flow and Row sampling, Lookup, Derived column, aggregate grouping, merge join in SSIS Dataflow.
  • Enhancement of existing sales data flows, remodeling of the existing info providers and population of fields as per new requirements.
  • Designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
  • Created SSIS packages for File transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
  • Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
  • Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
  • Responsible for implementation of Data Viewers, SSIS Logging, Error Configurations for error handling the packages.
  • Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
  • Worked with Tabular reports, Matrix reports, Drill down, Drill through, parameterized reports and Ad-hoc reports as well as Interactive reports according to business requirements using SQL server reporting services(SSRS).
  • Implemented SSRS server level and item level security, subscription, performance tuning and access various reports in multi-user environment.
  • Reviewed and developed data models and database designs with development teams.
  • Inspected the reports and fixed bugs in stored procedures.

Environment: MS SQL Server 2012/2008R2, Visual Studio 2010/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SharePoint Server 2010, Visual Basic 6.0/VB.net, VB Script

Confidential, IA

SQL Server BI Developer

Responsibilities:

  • Migrated data from Flat files, MS Excel and SQL Server 2005 to 2008R2.
  • Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions in SQL Server 2008R2/2005.
  • Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Flat Files, Excel and other OLEDB, ODBC data sources.
  • Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services (SSIS).
  • Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent on a weekly/monthly basis.
  • Experience in configuring package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
  • Designed and developed enterprise reports (SSRS) using the data from Oracle, SSAS Cubes and various heterogeneous data sources.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data regarding competitive rates and financial market.
  • Developed various types of complex reports like Drill Down, Drill through, linked reports, cascading parameter reports for business loan, first time buyer or refinancing home mortgage.
  • Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
  • Coordinated with front-end for implementing logic in stored procedures and functions.

Environment: MS SQL Server 2008R2/2005, Oracle 9g, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, Confidential SQL, Erwin, MS Excel, ASP.NET, Visual Studio 2008, OLAP, Windows 2007/2003, VB.NET.

Confidential, RI

ETL Developer

RESPONSIBILITIES:

  • Analyzed the business requirements
  • Designed the database in SQL Server 2005
  • Developed the various ETL packages using SSIS to load the Oracle ERP into SQL Server staging tables and export that staging data into specific format files
  • Migrating DTS packages to SSIS packages
  • Configured the error logging in text files
  • Maintained the transactions in SSIS packages
  • Configured the various connection configuration settings into config file
  • Created the SQL Server jobs and scheduled the jobs
  • Created the notifications for jobs execution process

Environment: MS SQL Server 2008R2/2005/2000,DTS,Business Intelligence Studio (SSAS, SSIS, SSRS), Confidential SQL, MS Excel, ASP.NET, Visual Studio 2008, Windows 2007/2003, VB.NET.

Confidential

Senior Software Engineer

RESPONSIBILITIES:

  • Responsible for interacting with end users and gathering system requirements, analysis of functional and technical specifications.
  • Identifying the technologies that suite for the customer requirements and preparing the proof of concepts
  • Preparing the Prototype/Mock applications and demonstrating to the clients and end users and getting feedback from the team
  • Back-End Database Design and Implementation in SQL Server/Oracle. Writing Confidential -SQL and Oracle stored procedures and functions for data retrieval.
  • Developed SSIS Packages with different sources like excel, Oracle ERP, Text files and other sources, and used different data transformations.
  • Created the data marts from Oracle ERP database tables.
  • Created the Integration packages (ETL) using SSIS to load the data from different tables into different data marts
  • Analyzed the data marts and created the cubes with dimensions and measures using SSAS
  • Developed the various business intelligence reports using SSRS
  • Performed the reconciliation of reports data with source data.
  • Deployed the business intelligence reports to share point portal (MOSS 2007) using share point business intelligence web parts and excel servers
  • Developed the web applications using Asp.net 2.0, 3.5, and created web services to communicate the data through database to applications.
  • Performed unit testing for all the development activities and involved during the design phase of the project for requirement analysis, development, deployment and user training.
  • Understanding the performance requirements and designing the application for best performance.
  • Involved in production support and troubleshooting of data quality and enhancement issues.
  • Developing Technical Design Document, Deployment document and User Guide.
  • Understanding the best practices of .NET/SQL development and implementing those guidelines.

Environment: MS SQL Server 2008R2/2005/2000,DTS,Oracle 9g, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, Confidential SQL, MS Excel, ASP.NET, Visual Studio 2008, OLAP, Windows 2007/2003, VB.NET.

Hire Now