Livecareer-Resume

Lead Bi Developer Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA 94105
:
Summary

Ingenious and Insightful BI developer with 6+ years of experience in analyzing business processes. Strong knowledge in scoping, designing, developing and executing Data warehouse/Data marts and Business Intelligence efforts. Communicative and team-oriented with proficiency in Microsoft Business Intelligence Stack (SQL Server, SSIS, SSRS and SSAS 2012/2014/2016), Power BI, Qlik Sense & Pentaho BI Suite.

Skills
  • Expertise in SQL development and in performance tuning and data mirroring, using SQL Server and Netezza; Fluency in T-SQL, MDX, DAX and PL/SQL.
  • Strong knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.
  • Hands on experience on Tableau Desktop, Tableau Reader and Tableau Server.
  • Extensive experience in handling large(multi million row) database design techniques and defining ETL and system integration architectures; combining data from heterogeneous source systems using SSIS.
  • Experience in OLTP/OLAP system study, Analysis and modelling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modelling.
  • Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
  • Developed executive Dashboards, performance Scorecards and retail analytics Reports with business KPIs using Power BI and SSRS.
  • Expertise in reporting, developing cubes, ETL jobs/transformation in Pentaho BI Suite.
  • Expertise in developing reports using Tableau Desktop
  • Minimal Experience in developing applications using ASP.Net, C#.Net and VB.Net.
  • Excellent interpersonal skills – able to work within a team
  • Excellent organizational skills – ability to prioritize work and meet deadlines
  • Attention to detail, accuracy, and quality of output
Education and Training
Texas A&M University - Commerce Commerce, TX Expected in 2015 Master of Science : Computational Science - GPA :
Kakatiya Institute of Technology And Science Warangal, TG, Expected in 2013 Bachelor of Science : Computer Science - GPA :
Experience
Rightpoint - Lead BI Developer
Atlanta, GA, 03/2017 - Current
  • Completed Data Warehouse project resulting in performing data analysis and reporting.
  • Worked with Managing Directors & Executives in departmental meetings for gathering requirements & provided presentations.
  • Recognized by management for providing exceptional customer service.
  • Designed databases, stored procedures, reports, and data input interfaces using SQL Server 2014.
  • Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2014 that maintained data.
  • As a BI subject matter expert, assessed BI needs for business users and mapped those needs to appropriate back-end solution architectures (OLTP/transactional databases, data marts, data warehouses and local data sources).
  • Involved in the complete data warehouse development life cycle and actively supported business users for change requests (Service Now).
  • Experience in creating SSRS Reports like Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix, drill-down, drill-through report).
  • Created pivot tables in Excel Services/PowerPivot 2013 and integrated within SharePoint.
  • Created scorecards, 360 dashboards in Power BI using multiple sources.
  • Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Involved in Managing and scheduling daily jobs related to data transfers, backup and Recovery.
  • Created Dax Queries to generated computed columns & computed tables in Power BI.
  • Worked on all types of transformations that are available in Power BI query editor.
  • Scheduled Automatic refresh and scheduling refresh in Power BI service.
  • Imported, exported and manipulated large data sets in multi-million-row databases and their associated data for rapid delivery to clients under tight deadlines using SSIS.
  • Created SSIS packages to pull data from SQL Server and exported to flat files, CSV files and Excel Spreadsheets and vice versa
  • Identified data issues and provided recommendations for resolution to ensure optimal performance.
  • Performed and conducted complex reporting analytics.
  • Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs
  • Designed and Populated specific tables, databases for collection, tracking and reporting of data.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Created ETL Jobs, transformations in Pentaho and developed cubes for reporting.
  • Designed Linked reports, parametrized, charts & gauges in Pentaho Reporting.
Cognizant Technology Solutions - BI Developer
Southfield, MI, 06/2015 - 03/2017
  • Improved customer satisfaction by finding creative solutions to problems.
  • Recognized defective material and reported issues to management to facilitate prompt resolution.
  • Created tax, SDSS, CDSS Dashboard using Power BI and SQL Server Integration Services (SSIS), that enables key tax information to be automatically updated and available for business use.
  • Created Compliance and CFPB Reports in Tableau with Drill Down and Drop down menu option and Parameters using Tableau.
  • Utilized Tableau server to publish and share the reports with the business users.
  • Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.
  • Working with various business teams to build data marts and populate data into EDW & ODS.
  • Designed and developed ETL/ELT processes using SQL Server Integration Services (SSIS).
  • Extensively used Aginity Netezza workbench to perform various DML, DDL operations on Netezza Database.
  • Rendered SSRS reports in different formats like .pdf, excel etc. to be executed automatically on daily, weekly or monthly basis and managed subscriptions.
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards that improve access to operational data for Decision Support Systems.
  • Involved in developing, deploying and scheduling Cognos reports.
General Electric - BI Developer Analyst
Ontario, CA, 03/2012 - 05/2015
  • Created and deployed reports for executives, business analyst for various categories and regions based on business needs using SSRS and Performance Point and also integrated reports from SSRS with SharePoint 2010/2012.
  • Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
  • Developed the T-SQL programs and involved in optimizing stored procedures and queries for faster retrieval and Server efficiency.
  • Created views, triggers and constrains to implement the database consistency and integrity.
  • Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
  • Created DTS, SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
  • Designed and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirement using SSRS.
  • Involved in designing, developing and implementing of web applications using ASP.Net, C#.Net, VB.Net.
  • Developed a customized application to track the usage of the tools developed by our team in ASP.Net with SQL as back-end Database.
  • Understand the business model and the marketing initiatives to provide support to the users.
Cleveland Clinic - Research Assistant
New Philadelphia, OH, 01/2011 - 12/2011
  • Created several SQL materialized views, stored procedures, triggers, cursors, indexes, joins and correlated sub queries to be accessed by the front-end school applications and implemented best practices to maintain optimal performance.
  • Designed and developed SSIS packages to load the data into SQL Server.
  • Prepared and edited reports, presentations and articles using SSRS and MS Power Point.
  • Prepared tables, graphs, fact sheets and written reports summarizing research results.
  • Assisted Professor in creating and publishing KPI metrics dashboards using Crystal Reports.

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

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:

75Average

Resume Strength

  • Formatting
  • Length
  • Measurable Results
  • Personalization
  • Target Job

Resume Overview

School Attended
  • Texas A&M University - Commerce
  • Kakatiya Institute of Technology And Science
Job Titles Held:
  • Lead BI Developer
  • BI Developer
  • BI Developer Analyst
  • Research Assistant
Degrees
  • Master of Science
  • Bachelor of Science