SEARCH

BI Developer Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
BI DEVELOPER
Summary
  • 7 Year of extensive experience in all phases of Software Development Life Cycle (SDLC) including identification of business needs and constraints, collection of requirements, architecture,
  • In-depth knowledge of T-SQL, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
  • Good hands on experience in RDBMS concepts, data models.
  • ETL implementation using SQL Server Integration Services (SSIS). Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Experience in designing SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, union all etc.,
  • Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports, and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studios BIDS.
  • Experience in Enterprise Reporting in generating reports using linked reports, sub reports and filters charts in SQL server reporting services.
  • Strong experience in creating various reports like Drill through, Drill down and Ad-hoc according to the user requirement using SQL Server Reporting Services SSRS.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS packages.
Skills
  • MS SQL Server 2012/2008R2/2008 ,SQL Server Management Studio
  • T-SQL
  • Business Intelligence Development Studio BIDS
  • SQL Server Agent, Data Transformation Services DTS
  • SQL Server Integration Services SSIS
  • SQL Server Reporting Services SSRS
  • SQL Server Analysis Services SSAS
  • BI, Enterprise
  • Charts, OLAP
  • Data dictionary, Oracle,DTS, PL/SQL
  • Data warehouse, Pick
  • Database, Quality
  • Designing, Reporting
  • ETL, Requirements Analysis
  • Graphs, MS SQL Server
  • DB2, SQL,Access, Tables
  • MS Access, T-SQL,MS Excel, T- SQL
Experience
BI Developer, Lowes, August 2017-CurrentMooresville, NC
  • Use Statistical and Quantitative Analysis to bring insights to client issues and business problems.
  • Created a report in Tableau to identify the target market for the applicationand brainstormed over the strategies to help expand the market reach
  • Develop Advanced Analytics Platform for Risk Management and FraudDetection.
  • Promote Data-Driven decision-making and strategic planning across the business.
  • Manage the operations of a Big Data Analytics platform using SQL, Hive,Spark,Tableau, Power BI
  • Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
  • Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
MS SQL Server/ BI Developer, Northern Trust, May 2015-June 2017Chicago, IL
  • Develop advanced SQL stored procedures, functions, triggers, views.
  • Create, modify and automate business reports in SSIS,SSRS and ETL Packages.
  • Work with senior developers to facilitate creation of high performing data centriccomponents and applications
  • Manage, monitor, and resolve issues with Scheduled Jobs, Database Mail, and other back ends system data flow
  • Provide support for database objects and performing code review
  • Responsible for performing SQL development and SSIS /SSRS development
  • Review the designs, code, and test plans of other developers and provide recommendations for improvement or optimizations
  • Perform data validation checks and filtered bad data.
  • Used Sequence Container, Execute SQL Task, Send Mail Task, Precedence Constraint, Script Task to achieve business requirement in the control flow.
  • Responsible for the ad-hoc reporting, modification and regenerating on request.
  • Building scorecards and dashboards using the Performance Point Services 2010 with BI application.
  • Schedule the reports to run daily, weekly, and monthly and automatically emailed reports to department directors and analyst to review it.
  • Environment: MS SQL Server 2008R2 SSRS/SSAS/SSIS, Point Services 2010, Microsoft office 2010, T-SQL, Windows 7.
MS SQL Developer, Orawaves InfoTech Private Limited , August 2012-March 2014Banglore, India
  • Involved in Planning Defining and Designing data based on business requirements and provided documentation.
  • Used SSIS and T- SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Developed and Deployed data transfers packages to the appropriate destinations using SSIS.
  • Experience in creating jobs, Alerts, SQL Mail Agent, and schedule SSIS packages.
  • Created SQL server configurations for SSIS packages.
  • Responsible for creating reports based on the requirements using SSRS 2008-R2.
  • Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed, implemented, and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
  • Developed and implemented procedures to ensure the quality, usability, and accuracy of reports
  • Environment: MS SQL Server 2008/2008R2, MS SQL Server Integration Services SSIS, MS SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Erwin.
Education and Training
Master of ScienceComputer Science, , , Sacred Heart University, , FairfieldCTIndiaAugust 2014
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • Lowes
  • Northern Trust
  • Orawaves InfoTech Private Limited

School Attended

  • Sacred Heart University

Job Titles Held:

  • BI Developer
  • MS SQL Server/ BI Developer
  • MS SQL Developer

Degrees

  • Master of Science

Similar Resumes

View All
BI-Developer-resume-sample

BI Developer

VMware

Seattle, Washington