We provide IT Staff Augmentation Services!

Sr. Msbi/power Bi Developer Resume

3.00/5 (Submit Your Rating)

Richardson, TX

SUMMARY

  • Professional experience over 8 years in the field of Business Intelligence applications as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services and using SQL Server, Power BI.
  • Good Experience and understanding on Database Development, Data warehousing, modeling, Design and Data Management.
  • Experience in installing, coding, implementation, upgrading, configuring of MS SQL Server 2005/2008/2008 R 2/2012/2014/2016 in Windows Environment.
  • Good Experience in Power BI for Data Visualization and Interactive reports using Power BI
  • Process SSAS cubes to store data in OLAP databases
  • Extensive experience on T - SQL and SQL Server on creating tables, triggers, user profiles, relational database model, data dictionaries, user defined functions, views, and data integrity.
  • Extensive experience in developing Power BI reports and data visualization from various data sources using Data Blending
  • Involved in improved transparency by publishing agile metrics with velocity chart, Confidential burndown, scrum board, and release burndown charts.
  • Extensive experience in data migration from different sources including flat files, My SQL, MS Access, Oracle 11g, and OLE DB sources to various Destinations by using SSIS 2008.
  • Expertise in creating Sub-Queries using Joins for complex queries involving multiple tables, Exception Handling.
  • Well Experience in SQL Server and T-SQL (DDL and DML Commands) in Constructing Tables, Normalization Technique on Database table.
  • Good Knowledge in Normalization and De-Normalization Techniques for optimum performance in relational and dimensional database environment implementing as per Business requirement.
  • Created Efficient T-SQL queries, Stored Procedures, Database Triggers and Exception Handlers.
  • Experience in OLTP and OLAP environment that include Production, development and implementation at maintain database schema from business requirements.
  • Expert in SSRS reports using Drill Down, Drill Through reports, Tabular reports, Matrix reports, Custom reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets.
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Expertise in Extraction, Transformation, Loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Experience in Dimensional Modeling, ER Modeling, Star Schema, Snowflake Schema, Fact and Dimensional tables and Operation Data Store (ODS).
  • Microsoft, Business Intelligence, Power Builder. Operating Systems Windows 7/XP/NT/2003/2000 Configuration Tools MS Visual SourceSafe, MS Team Foundation Server Framework Microsoft .NET Framework 4.0, 3.5, 3.0.
  • Expertise in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.Expertise knowledge using user interface using ASP.NET, C# .NET Microsoft .NET framework.

TECHNICAL SKILLS

Relational Databases: MS SQL Server 2005/2008/2008 R2/2012,2014,2016 Oracle8i/9i/10g/11g, SQL Server Management Studio (SSMS), MS Access.

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSAS, Erwin, DTS, Microsoft Visual Source Safe, Crystal Reports9.0, MDX, Visual Studio .Net, ProClarity, Db Pro, Octopus, Visual Source Team Foundation Server (TFS)

Languages: T-SQL, PL/SQL, V.B6.0, MDX, C, C#, ASP.Net, VB.Net.

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Database Design Tools: MS Visio, Erwin

Web Technologies: HTML, XML, XSL, JavaScript, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Power BI, Performance Point Server 2007, Tableau, Agile Methodology Micro strategy

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Sr. MSBI/POWER BI Developer

Responsibilities:

  • Provide database administration and day-to-day to support of MSSQLServer databases, including backup and recovery procedures, database utilities, and data replication technologies while supporting the development, test, and production environments.
  • Audits were created and initialized alerts for SQL Server 2016 and database.
  • Worked on tuning and performing queries and objects in the database.
  • Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
  • Worked on Power BI Dashboard to make some changes on behalf of Business requirements
  • Indexes and Tables were recreated as part of performance tuning exercise
  • ETL Programming for capturing data from disparate sources usingSQLServer Integration Services (SSIS, SSRS) with Visual Studio, and Analysis Services.
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Process SSAS cubes to store data in OLAP databases
  • Used Pivot and Un-Pivot to make changes of Power BI data to Excel Power Pivot.
  • To meet business requirements and to coordinate user testing, worked closely with users.
  • Worked on to Create Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
  • Worked on to Create Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization.
  • Worked on to Create new database/tables to put in the extracted data and rebuild the relationship.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Created various reports like Tabular reports and Matrix reports in Power BI.
  • Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
  • Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
  • Developed Stepped and Block reports using SSRS. Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
  • Created custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different locations.
  • Created various charts like Pie Charts and Line Charts to make easy understanding of the reports.

Environment: SQL Server 2014/16, MS Excel, SQL Profiler, ETL, T-SQL, Power BI, MS SQL Server Reporting Services, AGILE Methodology, MS SQL Server Integration Services, MS SQL Server Analysis Services, Visual Studio

Confidential, Atlanta, GA

Sr. SQL Server MSBI Developer

Responsibilities:

  • Worked for solving issues in production using on-call support.
  • Coordinating Database and Application, outages and maintenances to all end users.
  • Complete knowledge of Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from SAP, Agile source systems to destination systems in Micron Technology.
  • Team development, mentoring and planning for projects in an agile environment
  • Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server and Flat files.
  • Worked on daily batch loads into Staging and ODS areas, troubleshooting process and solving issues and errors using SQL Server Integration Services (SSIS).
  • Worked on complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in all the environments (Development and Production).
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, Fuzzy Lookups, variables and parameters
  • Worked on writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Worked on Normalization and De-Normalization of existing tables for quick query retrieval.

Environment: SQL Server 2012, T-SQL, Oracle 10g, AGILE Methodology, MS Excel,& Windows server, PowerBI, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential, Milwaukee

Sr. SQL Server/BI Developer

Responsibilities:

  • Created DTS packages to copy tables, schemas, views and to extract data from Excel using SSIS.
  • Transformed data from various data sources using OLE DB connection by creating various DTS packages.
  • Used BCP command line utility to replicate a database.
  • Worked on designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
  • Worked on migrating some of the DTS packages in to SSIS.
  • Used Recompile and with option query hints to avoid parameter sniffing problems.
  • Developed reports using SSRS and Crystal reports. Used table control and matrix control for cross tab reports.
  • Created standard Reports and Cross Tab Reports and Drill Through reports.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.

Environment: MS SQL Server 2008R2/12, SSIS, SSRS, Windows NT, UNIX, ASP.Net. SSIS, SSRS, SSAS.

Confidential, Fort Worth, TX

SQL Server ETL Developer

Responsibilities:

  • Involved in analysis, design and development of project to consume transactional data, consolidate into data warehouse and creating reports and dashboards, writing complex Stored Procedures for creating datasets for Reports and dashboards.
  • Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
  • Created ETL packages using SSIS to move data from various heterogeneous data sources.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Used XML and environmental variables in the package configuration for Deploying SSIS packages.
  • Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
  • Created Cross-Tabs, Drill-down and Sub-Reports using SSRS. Deployed RDLs to Report Server.
  • Responsible for maintaining cubes using SSAS and populate the cubes with the data.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.

Environment: MS SQL 2008,SSIS,SSRS, Windows Server, ASP, VB .Net, XML, T-SQL, MS Excel, Targit, MS Access. Visual Studio 2005, Oracle 9i/10g

Confidential, Kansas City, KS

SQL Server BI Developer

Responsibilities:

  • Gathered end user requirements and developed applications and different audit functionalities depending on the requirements acting both as a system analyst and an application developer.
  • Wrote user requirement documents and developed functions, indexes, stored procedures, views and triggers for automation. Converted fast views in to EUP views and validated data.
  • Used Team Foundation Server (TFS) as a tool for repository of codes and version control, also maintains test scripts and documentation following the standards.
  • Worked on UI Data pop and Meta-data for populating data in EXCEL using SQL macros.
  • Developed physical data models using ERWIN and created DDL scripts for database schema and objects.
  • Developed query for generating drill down and drill through reports in SSRS 2008.
  • Uploaded reports on to the report manager and organized them into folders.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008.
  • Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).

Environment: MS SQL Server 2008, T-SQL, DTS, SSAS, SSIS, SSRS, SQL Server Enterprise Manager, SQL Server Query Analyzer, MDX, SQL Server BIDS, MS- Visual Studio 2008.

Confidential

SQL Server Developer

Responsibilities:

  • Extract, Transform and Load source data into respective target tables to build the required data marts.
  • Install and configure servers and clients using SQL Server 2008. Create and upgrade SQL databases.
  • Understand user requirements and Data Model defined and developed by the business analysts and data architects.
  • Created functional specification document and technical specification document.
  • Constructed OLTP and OLAP Databases.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
  • Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
  • Implemented different types of constraints on tables. Designed and applied entity and attributes description and definition for the models.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Created Snapshots, Subscriptions and Transactions using Replication services.
  • Migrated data from SAS environment to SQL Server 2008 with SQL Server Integrated Services (SSIS).
  • Created ActiveX script to execute VBScript.
  • Created ETL process using SSIS to transfer data from heterogeneous data sources.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Created SSIS packages through .NET for incremental load.

Environment: MS SQL Server 2008, Performance Point Server 2007, C#, ER Win 4.0, Visio, MS SQL Analysis Services 2008, Business Objects 6.5.1/ XI r2, XML, ActiveX, MS Excel, Visual Studio 2008, Windows Server 2003, Oracle, Toad, ERWIN, Crystal Reports, Excel.

Confidential

SQL Server Developer

Responsibilities:

  • Worked on detailed design and requirements documents with logic to help team members understand the requirements and design.
  • Gather requirements and design of data warehouse and data mart entities·
  • Built Data marts (Fact and Dimension tables) from the warehouse tables.
  • Designed Multi Dimensional models, DATA MART/ WAREHOUSES and SSAS cubes
  • Performs design/code reviews to make sure that the design/code adheres to customers’ standards and meets industry’s best practices
  • Worked for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).
  • Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
  • Wrote various queries and store procedure, and Troubleshoot database related issues
  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
  • Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables.
  • Generated test cases to meet the functionalities deliverables in the project documentation and specifications.
  • Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions (UDF).
  • Performed DBA functions, installing, configuring and supporting SQL Server based database systems.

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, ERWIN, UML, MS Project, Windows 2003 Server, VB.NET, SSIS, SSRS, SSAS

We'd love your feedback!