We provide IT Staff Augmentation Services!

Ms Sql Bi Developer Resume

Charlotte North, CarolinA

SUMMARY

  • 5 years of professional experience on Design, Development, and Maintenance of Database using tools of MS SQL Server 2008 to 2019 for both OLTP and OLAP Systems.
  • Experienced wif Software Development Life Cycle in all phases.
  • Expertise and experience in designing and developing, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Database objects such as Tables, Schema, Indexed Views and User Defined Functions for data definition, manipulation and access.
  • Extensive working experience in Normalization and De - Normalization techniques for both OLTP and OLAP systems.
  • Hands on in error handling and debugging coding issues and troubleshooting of production problems.
  • Expertise in performing ETL task using SSIS in between different systems such as Excel, MS Access, Flat Files, XML file and Oracle.
  • Experienced in Creating and Updating Clustered and Non-Clustered Indexes to keep up teh SQL Server Performance.
  • Expert in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor.
  • Experience in creating reports using Grouping and Sorting and creating Sub Reports, Cascading parameters Report, Report Snapshot, Drill-Through Reports, Parameterized Reports, and ad hoc reports using SQL Server Reporting Services (SSRS).
  • Highly motivated, committed and a natural team player wif good communication skills and Interpersonal skills coupled wif right ability to get things done.
  • Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS

  • MS SQL SERVER
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services(SSAS)
  • MS SQL Server Management Studio
  • SQL Server Business Intelligence Development Studio (BIDS)
  • DataTransformation Services (DTS)
  • SQL
  • T-SQL
  • IBM Optim
  • IBM DB2
  • Team Foundation Server (TFS)
  • MS ACCESS
  • Performance Point
  • Report Builder 2.0
  • XML
  • ERwin
  • MS VISIO
  • Normalization
  • De normalization.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

MS SQL BI Developer

Responsibilities:

  • Designed and developed data models and ER diagrams in Visio for teh Data Warehouse using star and snowflake schema.
  • Work wif teh database modeling manager to identify teh requisites of a project
  • Extracted data from various sources like SQL Server, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
  • Created SSIS packages for ETL and used various transformations like Lookup, Fuzzy grouping, Row count for data cleansing before loading.
  • Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
  • Created SSIS packages and used Analysis Services processing task to update teh cube wif current data.
  • Generated Drilldown, Drill through, Cross-Tab & Summary reports by using SSRS.
  • Used Report Builder to generate Ad Hoc Reports.
  • Generated complex reports such as Dashboard, Scorecards, and graph-charts.
  • Created and scheduled Report Snapshots in Report manager to improve teh performance of SSRS.

Environment: SQL Server 2016 and 2019, MS SQL Integration Services (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS), MS Visio, Report Builder 2.0, Power BI, TFS, SharePoint

Confidential, Charlotte, North Carolina

MS SQL / SSRS Developer

Responsibilities:

  • Worked on requirement Analysis, Logical and Physical design & development data model using ERwin, Normalization.
  • Design and Developed TSQL queries to get data from different sources and test results wif expected results.
  • Created reports using Cascading parameters and Drill-Through Reports, Sub reports, Parameterized Reports, Report Models and ad hoc reports.
  • Gather and translate business requirements into report designs.
  • Modified and tuned stored procedures, triggers, views, and indexes to provide best performance.
  • Involved in resolving blocking, dead lock issues, and performance issues.
  • Analyzed, identified, and implemented user roles and assigned relative database access privileges.
  • Securing Access to Reports, Authorizing Users at teh Home Level and Project Level, Managing Reporting Services Roles.
  • Worked wif SQL Server Job Agent to schedule packages, run and monitor them.

Environment: MS SQL Server 2016, DB2, Erwin, T-SQL, MS SQL Integration Services (SSIS), MS SQL Reporting Services (SSIS), MS SQL Analysis Services (SSAS) Oracle 9i, MS Excel

Confidential, Charlotte, North Carolina

MS SQL / SSRS Developer

Responsibilities:

  • Worked in gathering teh user requirements, involved in meetings, reviews and prepared detailed design document
  • Responsible for performing basic developer task like creating, altering and dropping tables.
  • Built T-SQL queries and stored procedures and used them in SSRS reports.
  • Successfully applied schema change scripts to existing objects to synchronize wif changing business rules.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Written, Tested and Debug stored procedures using T-SQL for teh data layer using SQL Server data adapter and performed tuning teh SQL queries.
  • Created Ad hoc reports using SSRS and Created Subscriptions and scheduled reports using subscriptions.
  • Generated Drill down and Drill through reports in SSRS.

Environment: MS SQL Server 2008/2008R2/2012, Erwin, T-SQL, MS SQL Integration Services (SSIS) 2005, MS SQL Reporting Services (SSRS) 2005, Oracle 9i, MS Excel

Hire Now