We provide IT Staff Augmentation Services!

Bi Developer Resume

Spring, TexaS

SUMMARY

  • 6+ years of IT experience comprising Microsoft Business Intelligence stack, database development, administration, and data modeling.
  • Strong knowledge in working with all phases of Software Development Life Cycle (SDLC) that involves system analysis, design, development and implementation by identifying teh business requirements and capable of handling responsibilities independently as well as a proactive team member.
  • Expertise in database design and modelling using MS SQL Server, SSIS, SSAS and SSRS; experience in installing, configuring and updating MS SQL Server database.
  • Extensive Experience in developing/Creating Visualizations using Power BI and Tableau.
  • Expertise in teh design and development of Tableau visualization and dashboard solutions using Tableau Desktop and publishing teh same on Tableau Server/ Public/ Reader and external websites.
  • Worked to a great extent with teh design and development of BI reports / dashboards using Tableau visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Waterfall Charts, Gantt Charts, Geographic Visualization and other making use of actions, other local and global filters according to teh business/client requirement.
  • Extensive experience in writing Stored Procedures as well as analyzing and debugging existing stored procedures.
  • Experience in optimizing teh queries by creating various clustered, non-clustered indexes and indexed views.
  • Involved inData Model Designfrom scratch for both normalized databases and data warehouses.
  • Extensive knowledge of Relational Database Management System (RDBMS) concepts.
  • Experience in creating reports using SQL Server Reporting Services (SSRS). Developing drill through reports, drill down reports, cascading parameterized reports, linked reports, sub reports, dynamic grouping reports, and charts in SSRS.
  • Experience in ETL tools like SQL Server Integration Services (SSIS) for Data Extraction, Transformation and Loading.
  • Strong knowledge in database development using T-SQL, Stored Procedures, Cursors, DTS/SSIS Triggers, Views and User Defined Functions.
  • Highly experienced in teh whole cycle of DTS/SQL Server Integration Services (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
  • Work with Business teams to develop visualizations / dashboards in PowerBI.
  • Expertise in writing DAX functions in Power BI and Power Pivot.
  • Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
  • Experience in performing Incremental Loads and Data Cleaning in SSIS. Expert in handling errors, logging using Event Handler using SSIS.
  • Experienced in designing Fact Tables with star schema using SQL Server Analysis Services (SSAS).
  • Extensive knowledge in Enterprise Reporting and Business Intelligence.
  • Worked in OLTP and OLAP environments that include QA, Production, development, implement and maintain database schema and Entity Relationship diagrams from business requirements.
  • Complete projects successfully and on-time in teh context of an Agile project management.
  • Excellent communication and interpersonal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
  • Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn clients business requirements.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2016/2 R2/2008/2005; Oracle 10g

SQL Server Tools: SQL Server Enterprise Manager, Management Studio, Business Intelligence Development Studio (BIDS), Visual Studio 2015/2013/2012/2010/2008 , SQL Data Compare, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Client Configuration Utility, Data Transformation Services (DTS), Integration Service (SSIS), Analysis Service (SSAS), Reporting Service(SSRS), ODBC, Data warehouse

Data Modeling Tools: MS Visio 2007, Power Designer

Data Warehousing: OLAP, OLTP, Star Schema Modeling, FACT and Dimension Tables

Methodologies: Logical and Physical Database Design, Star Schema, Snowflake SchemaDatabase Design and Normalization

Reporting Tools: Power BI, Tableau, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Spring Texas

BI Developer

Responsibilities:

  • Designed and Developed database tables, views, stored procedures and functions
  • Integrated data between multiple source systems that involves detailed data analysis of new or existing source systems, source-to-target mapping, data cleansing and ETL development.
  • Worked on data profiling, and data cleansing before loading data into Data Warehouse.
  • Involved in creating conceptual, logical and physical data models in Power Designer to design and model teh Facts, and Dimensions in teh Data Warehouse.
  • Worked on creating DataMarts in Snowflake schema and Data Warehouse in Star Schema.
  • Worked on maintaining database schema and code management using TFS and Redgate SQL Data Compare Tool.
  • Created paginated reports, cascading reports and performance appraisal reports with complex requirements using stored procedures and views.
  • Created reports in Power BI that involved MDX measures as per requirements of teh users.
  • Created Dashboards, multi KPIs and published teh same to Cloud in Power BI.
  • Integrated Power BI dashboards with internal SharePoint website for business users.
  • Worked on designing, developing, testing, maintaining and automating ETL processes.
  • Assist with teh design, development and implementation of staging areas and data marts.
  • Applied technical skills to implement an ETL solution to process heterogeneous text files, transform data into a format required by teh business and load data into SQL Server Data Warehouse.
  • Designed ETLs to unzip teh incoming source file folders and archive them in teh zipped folders after teh data load.
  • Worked with teh technical documentation to identify and create Facts and Dimensions.
  • Partitioned teh existing SSAS cubes to decrease teh processing time by processing only teh latest partition.
  • Developed drill down and drill through SSRS reports on teh cubes using MDX queries and dynamic SQL.
  • Integrated SSRS report server with SharePoint server and created web pages to make it easier for teh users to access teh reports.
  • Developed SSRS reports with dynamic groupings and cascading parameter selections.
  • Created reports in Power BI that involved complicated MDX measures as per requirements of teh users.
  • Scheduled Power BI reports in online version and knowledge of accessing dashboards in Power BI mobile version.
  • Created custom visuals, groups, paginated reports, graphs, charts, KPIs and slicers using Power BI.
  • Created map visualizations in Power BI using spatial data.
  • Used power query to extract and transform; power pivot to model and analyze; and power view and map to create reports and visualize teh data.
  • Organized user training sessions to help them create their own ad hoc reports in SSRS and Power BI.

Environment: MS SQL Server 2016/2014/2012 , Visual Studio 2015/2013, Pragmatic Workbench 5.7.0, Advanced Query Tool V9, TFS, SharePoint, SQL Profiler, Power Designer, Microsoft Excel 2010, ADO.net, C#, Windows Performance monitor, Red Gate SQL Prompt, MS Visio 2010.

Confidential, Piscataway New Jersey

SQL Server SSIS/SSRS Developer

Responsibilities:

  • Generated database monitoring and data validation reports in SQL Server Reporting Services (SSRS).
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
  • Deployed SSIS packages and Reports to Production Servers.
  • Worked on Migration of packages from DTS using SQL Server Integration Services (SSIS).
  • Implemented custom package and project level dynamic SSIS configurations to migrate teh SSIS projects with minimal human intervention.
  • Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Services (SSRS).
  • Created and developed teh stored procedures, triggers, views and user-defined functions to support application development.
  • Involved in Normalization and Denormalization of existing tables for faster query retrieval.
  • Deployed and configured teh reports in teh Report Server.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secure and extensible.
  • Generated test data and tested database to meet teh functionalities deliverables in teh project documentation and specifications.
  • Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2008.
  • Worked closely with IT project managers, programmers and testing team.

Environment: SQL Server 2008 Enterprise Edition, SSIS /SSRS 2008, T-SQL, XML, MS Excel, TFS, MS Access, Visual Studio 2008.

Confidential

SQL Server Developer

Responsibilities:

  • Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
  • Interpret data and analyze results using statistical techniques
  • Provide quality assurance of imported data, working with teh QA team as necessary
  • Troubleshoot teh reporting database environment and reports
  • Identify, analyze and interpret trends or patterns in complex data sets
  • Gather and translate business requirements into report designs
  • Design and monitor construction of user-facing presentation tools - SSRS and SSAS
  • Generate ad-hoc reports as needed
  • Provide reporting to customers and management to support business decisions and become more proficient in teh use of teh application
  • Communicate with team members to assess progress of deliverables
  • Examine, evaluate and develop reporting requirements for various business units; develop reports and reporting structures as required
  • Communicate reporting changes, enhancements and modifications verbally or through written documentation to team members
  • Work with other BI team members to prepare and deliver reports, recommendations or alternatives for improving processes in reporting systems across teh organization.

Environment: SQL Server, SQL, T-SQL, SSRS and SSAS

Hire Now