close
  • Dashboard
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Customer Service
      • Education
      • Sales
      • Manager
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Microsoft Word
      • Professional
      • Modern
      • Traditional
      • Creative
      • View All
    • Resume Services
    • Resume Formats
      • Resume Formats
      • Chronological
      • Functional
      • Combination
    • Resume Review
    • How to Write a Resume
      • How to Write a Resume
      • Summary
      • Experience
      • Education
      • Skills
        • Skills
        • Hard Skills
        • Soft Skills
    • Resume Objectives
  • CV
    • CV
    • CV Examples
    • CV Formats
    • CV Templates
    • How to Write a CV
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Customer Service
      • Marketing
      • Sales
      • Education
      • Accounting
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Questions
  • Resources
  • About
    • About
    • Reviews
  • Contact
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • BI Developer
Please provide a type of job or location to search!
SEARCH

BI Developer Resume Example

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, Cognizant Technology Solutions, August 2017-CurrentLas Piedras , PR
  • 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, Luxoft, May 2015-June 2017Jacksonville , FL
  • 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 centric components 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 2014City , STATE
  • 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, , CityStateIndiaAugust 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.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

78Average
Resume Strength
  • Formatting
  • Word choice
  • Length
  • Strong summary
  • Typos

Resume Overview

School Attended

  • Sacred Heart University

Job Titles Held:

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

Degrees

  • Master of Science

Create a job alert for [job role title] at [location].

×

Advertisement

Similar Resumes

View All
Lead-Power-BI-Data-Analyst-/-SQL-Developer-resume-sample

Lead Power BI Data Analyst / SQL Developer

Emd Millipore

Temecula , CA

ETL/BI-Developer----Contract-resume-sample

ETL/BI Developer - Contract

Jpmorgan Chase & Co.

Huntington , NY

Lead-Power-BI-Data-Analyst-/-SQL-Developer-resume-sample

Lead Power BI Data Analyst / SQL Developer

Emd Millipore

Urbana , IL

  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
  • Work Here
  • Contact Us
  • FAQs
  • Accessibility
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2022, Bold Limited. All rights reserved.