We provide IT Staff Augmentation Services!

Bi Dveloper Resume

4.00/5 (Submit Your Rating)

IL

SUMMARY

  • I is a competent and detail oriented BI Data Analyst wif 6 plus years of work experience in Microsoft technologies such as SSIS, SSAS, SSRS, Power BI, EXCEL and Microsoft SQL Server
  • Working experience in Data Analysis, Data Conversion, Data Quality, Data Integration, Data Visualization, developing and updating data ware house, Managing SQL Server objects.
  • Experience in creating SSIS packages for data migration and building Enterprise level dashboards in Power BI for Data Analytics.
  • Having 3+ Years of experience on Microsoft BI Technologies (SSIS, SSRS, and SSAS).
  • Around 3 Years of experience on SQL database development.
  • Implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Financial, Insurance, Sales and Health domain. Experience in Data Warehousing & Business
  • Intelligence life cycle in design, developing, testing and implementation. And SQL developer and SQLDBA.
  • ETL Development using SSIS.
  • Authoring of Reports, KPIs and Dashboards using SSRS.
  • Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2005 (SSAS).
  • Build and deployment of BI solution.
  • Experience in creating jobs, and schedule SSIS Packages using SQL Server Agent. Good in troubleshooting SQL job failures.
  • Sound Experience in writing Stored Procedures.
  • Strong experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Aggregator, Joiner, Update Strategy etc.
  • Proficient in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLEDB connection from heterogeneous sources like (Excel, CSV, ARCOS, Oracle, flat file, Text Format
  • Data) by using multiple transformations.
  • Provided by SSIS such as Data Conversion, Derived Column, SCD, Conditional Split, and Look Up, Bulk Insert, Merge, And Union All etc.
  • Experienced in creating Tables, Stored Procedures, and Views, Indexes, Cursors, Triggers and complex queries using T - SQL in SQL Server 2014/2010.
  • Involved in the Development of different mappings and tuned for better performance.
  • Experience in DWH MSBI end to end Testing.
  • Knowledge in OLTP, OLAP, Dimensional Data Modeling Concepts, Star and Snowflake schema design and data warehousing methodologies.
  • Extensive experience in Installation, Configuration, Updates, Backups and Restore of SQL Server
  • Analysis of Business Specification document /Source map document for creating packages and Reports.
  • Performed Unit testing and validated the data.
  • Involved in the Requirement gathering from the business users.
  • Interacted wif Architect to understand the High level Design.
  • Expertise in data analysis for different domains.
  • Experience in Unit Testing and UAT.
  • Experience in various domains like Insurance, Healthcare, Banking and Retail industries.
  • Experience wif Waterfall and SCRUM process (Agile Methodology).
  • Design, develop and maintain web-based business process and database applications.
  • Tuned and optimized queries by analyzing different query options and indexing strategies.
  • Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Involved in ETL process from development to testing and production environments.

TECHNICAL SKILLS

BI tools: SRRS 2014, SSAS 2014

ETL: SSIS 2014/2010

Modeling Tools: Microsoft Visio

Database: SQL Server 2014/2012

Concepts: Data Warehousing, Relational & Dimensional Modeling

Operating Systems: Windows 10, UNIX

Reporting Tools: Excel Reporting, Microsoft Power BI, Tableau 10.4

Office Applications: MS Outlook, MS Project 2013, MS Excel, MS Office, MS Access

Programming Languages: SQL (SQL Server 2014 Management Studio), Python 3.6.2

Methodologies: Waterfall model, Agile, SDLC

PROFESSIONAL EXPERIENCE

BI Dveloper

Confidential, IL

Responsibilities:

  • Design, build, deploy and debug of ETL's.
  • Managing team for resolving production tickets and responsible for operational
  • KPI’s for data integrity, security and availability.
  • Extracted and Loaded data into SQL Server Database using SSIS for exporting data from flat file source to SQL Server database.
  • Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
  • Restricted data for particular users using Row level security and User filters.
  • Developed Tableau visualizations and dashboards using Tableau Desktop.
  • Developed Tableau workbooks from multiple data sources using Data Blending.
  • Provided 24/7-production support for Tableau users

BI Developer

Confidential

Responsibilities:

  • Designing Reports using SQL Server Reporting Services.
  • Daily ETL overnight jobs monitoring and support.
  • Developing SSIS package and creating job to run on quarterly basis.
  • Create interactive visualization reports and dashboards wif visual analytics on Power BI Desktop/Service dat help clients to find answers for most important questions in the data.
  • Actively collaborate wif the team for Development, Optimize, Maintenance of data quality in the SQL databases.
  • Data extraction & transformation, Data Analysis and Data Modeling using SQL queries to develop interactive Power BI dashboards and parameterized SSRS reports.

SQL Developer

Confidential

Responsibilities:

  • Developing Procedures, views and functions.
  • Analyze code for problem resolution and performance optimizations.
  • Provide technical support to application development teams.
  • Designing Reports using SQL Server 2005 Reporting Services.
  • Responsible for preparing SQL Scripts.
  • Auto updates data by weekly.
  • Developing stored procedures.
  • Responsible for preparing SQL Scripts and updating in both develop and production environment.
  • Frequently interact wif Client to meet his requirement.

We'd love your feedback!