We provide IT Staff Augmentation Services!

Sql Bi Consultant Resume

Norfolk, VA

SUMMARY:

  • 5+ years of experience in Data Modeling, Database Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2008/2008R 2/2012/2014/2016.
  • Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
  • Working Experience of clearing Adhoc requests and SSRS Reports.
  • Experience in using Microsoft BI studio products like SSIS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
  • Good Exposure to entire Software Development Life Cycle (SDLC), documentation of software products with Agile Scrum methodology and also experienced in working with waterfall model.
  • Expertise in generating reports using SQL Server Reporting Services and MS Excel spread sheets for the claims department
  • Expert in designing Enterprise reports using SQL Server Reporting Services generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2010/2012.
  • Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

T: SQL, PL/SQL 11g, Vb.Net

Databases: MS SQL Server 2014,2012,2008R2,2008,PL SQL

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Business Intelligence Development Studio (BIDS), Visual Studio, SQL,T SQL, Tableau 2019.1

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS),Microsoft Office(MS), Excel Power Pivot, Excel Data Explorer.

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

SQL BI Consultant

Responsibilities:

  • Working with the SQL Stored Procedures, tables, Views depending upon the project requirement.
  • Working with Encounters Remediation team to Support GBD teams by creating Scrubs (Stored Procedures), SSIS packages, SSRS reports.
  • Created different kinds of SSRS reports like Tablix, Matrix, Drill Down and Drill through, Sub report, main Reports for sales and Macess team.
  • Involved in the business calls to load care more data and writing the Logic for new Applications called BRT.
  • Worked with the facets Providers data, Claim data and Knowledge of Members data.
  • Cleared the Adhoc requests generated by the business.
  • Trouble shoots the SSIS/SQL job Agent whenever necessary. Working in the agile environment and used SVN to commit the code.
  • Worked on SSRS reports like matrix, Tablix, Parameterized, main, sub report, Linked reports.
  • Worked on Testing and fixing the bugs with tester and providing test artic rafts.
  • Worked on Creating SSIS Packages for Care more data and ssrs reports.
  • Working on creating different tableau worksheets and dashboards and publishing them based on business requirements.
  • Worked with MSI code changes in VB.net and fixed the major issue regarding the markets.
  • Working experience on SSIS Packages, SQL store procedures, SQL Tables for the claim and Providers data.
  • Working with the IT Encounters mailbox rotation and team and helping the business according to schedule.
  • Involved in Business Meetings and DEMOS with Market Analysts
  • Working experience with Business Analysts to understand the requirement and preparing the BRD’s .

Environment: SQL Server 2008/2012, SQL Server Business Intelligence Development Studio, 2010, SSIS, SSRS, T-SQL, Vb.Net, Agile, Tableau 2019.1.

Confidential, Omaha, NÉ

SQL BI Consultant

Responsibilities:

  • Created the Stored Procedures, tables, Views depending upon the project requirement.
  • Created the deployment scripts after the development is done for every project.
  • Automated the SSIS Packages using the SQL Server Agent Jobs and Octopus.
  • Created tabular, matrix, chart, drilldown reports and parameterized, cascaded reports, MDX, DAX scripts, Store procedures in SSRS Reports also deployed into report builder.
  • Trouble shoots the SSIS /SQL job Agent whenever necessary. Working in the agile environment and used Microsoft TFS to commit the code and t for the tickets.
  • Worked with the different teams from the offshore and onshore for the production support and maintain the SQL data and SSIS packages and SQL agent jobs with 24/7 on call tech support and resolved the issues. Involved in demoing the reports to the business in making a good decisions.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Environment: SQL Server 2008/2012, SQL Server Business Intelligence Development Studio, 2013, SSIS, SSRS 2012, T-SQL, VSTS Dashboard, T-SQL.

Confidential, New York

SQL BI Consultant

Responsibilities:

  • Created the Stored Procedures, tables, Views depending upon the project requirement.
  • Created the deployment scripts after the development is done for every project.
  • Automated the SSIS Packages using the SQL Server Agent Jobs and Autosys.
  • Created tabular, matrix, chart, and drilldown reports and parameterized in SSRS Reports also deployed into report builder.
  • Trouble shoots the SSIS /SQL job Agent whenever necessary. Working in the agile environment and used TFS to commit the code and share point for the tickets.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Involved in Documentation for all kinds of SSRS reports and SSIS packages into the Confluence Page.

Environment: SQL Server 2008/2012, SQL Server Business Intelligence Development Studio 2010,2013, SSIS, SSRS 2014/ 2016, TFS,T-SQL, .Net, PL SQL, Share Point, Jira Dashboard, T-SQL.

Confidential, Atlanta, Georgia

SQL BI /MSBI (SSIS,SSRS)

Responsibilities:

  • Worked as a Reverse Engineer in this project based on the existing project created the new SSIS Packages and SSRS Reports.
  • Designed and developed SSIS Packages to import the data from multiple flat files located on the FTP site to the SQL Server database using various SSIS transformations like script task, Derived Column, Data Conversion etc, for each loop container, Execute SQL task and Execute Process task.
  • Created different kinds of SSRS reports as per business needs.
  • Worked with the different teams from Canada and Troy for 24/7 On call Production support and maintenance for SQL agent jobs and ssis packages scheduled.
  • Involved in designing the schemas for new database and migrated the data using SSIS Packages.
  • Expert on creating multiple kinds of SSRS Reports like Tablix, Matrix, Drill Down, Drill Through, Sub Reports, Main Reports using Store Procedures and Direct SQL and also MDX Queries in data.
  • Published reports on to the Share point and created Web pages in Share-point to show various reports generated from Excel and SSRS in one web part page also customized the report using CSS.
  • Wrote complex T-SQL queries for data extraction, loading the Data in RDB (Relational Database) Landing through SSIS Packages.
  • Worked on Team Foundation Server (TFS) for version controlling.

Environment: MS SQL Server 2016/2014 SQL Server Integration Services, TFS, SQL Server Reporting Services 2012, Team foundation server (TFS) 2010,PL SQL,T-SQLMS Excel, Windows 2008 Server.

Confidential

SQL/ BI (MSBI-SSIS, SSRS Developer)

Responsibilities:

  • Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
  • Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
  • Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
  • Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
  • Created Stored Procedures, Triggers, Functions, Indexes, and Tables, Views and other T - SQL code and SQL joins for applications.
  • Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.

Environment: MS SQL Server 2008R2/2008, T-SQL, MS Access, MS Excel,& Windows 2003 server, PL/SQL, Business Intelligent technologies like SSIS, SSRS, SSAS.

Hire Now