We provide IT Staff Augmentation Services!

Sr. Sql Server/ Ssis/ Ssas / Ssrs Developer Resume

0/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • 8+ Years Microsoft BI Professional
  • Proficient in writing T - SQL Statements, Complex Stored Procedures, Dynamic SQL queries, Batches, Scripts, Functions, Triggers, Views, Cursors and Query Optimization.
  • Sound knowledge of SQL server administrative skills including, backups, user roles authentication and authorizations and database creation.
  • Experience in Installations, Up-gradations, Configuring and Maintenance of Microsoft SQL Server 2008/2012/2014/2016 , Microsoft Visual Studio 2010/2012/2013/2015.
  • Extensive experience in BI suite comprising integration services (SSIS) for ETL (Extraction, Transformation & Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.
  • Skilled in High Level Design of ETL Packages using SSIS for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
  • Hands on experience in Dimensional Modelling.
  • Expertise in writing MDX Scripts to create datasets, reports and dashboards.
  • Expert in designing Enterprise reports using SSRS and Report Builder which includes drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and charts.
  • Developed Tableau and QlikView reports
  • Extremely motivated, diligent, conceptually strong team player with ability to take new roles and adapt quickly to new technology.
  • Good communication skills paired with expertise analytical skills to help deliver successful results in the projects.

TECHNICAL SKILLS

BI Tools: MS BI (SSIS, SSAS, SSRS), QlikView, Tableau, Report Builder, Google Analytics, Google AdWords, Business Objects

ETL Tools: SSIS

Database: MS SQL Server 2008/2008R 2/2012/2014/2016 , Oracle 11g/10g, MS-EXCEL, MS-ACCESS

Data Modeling: Erwin

Programming: C#.Net, PL/SQL, T-SQL, VB.Net

Productivity Applications: MS Word, MS Excel, MS Access, Visio, SSMS

Web Technologies: HTML, XML, CSS, JavaScript

Operating System: Windows 10/8/7/Vista/XP/2000/NT 4.0/98

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. SQL Server/ SSIS/ SSAS / SSRS Developer

Responsibilities:

  • Understanding the report requirements
  • Consolidation of all the requirements and identifying the unique variables required per scope
  • Data analysis based on the data dictionary for various source systems and CDR files
  • Identifying the gaps between the requirements and data analysis
  • Involved in ETL design documentation
  • Developed ETL packages using SSIS which involves applications of various transformations
  • Developed stored procedures and functions in SQL Server
  • Involved in Dimensional Modelling
  • Developed Data Migration related ETL packages.
  • Created jobs, schedules and performed other DB related tasks in SSMS.
  • Monitored the jobs activity through the job activity monitor.
  • Designed and developed cubes in SSAS as per the requirements.
  • Designed and developed reports in SSRS.
  • Maintained check lists at various stages of the project
  • Developed audit scripts for integrity check and reconciliations
  • Performed unit testing, system integration testing, UAT, stress test and operational readiness test.
  • Performed root cause analysis for the issues raised and fixed them

Environment: SQL Server 2014, SQL Server Data Tools for Visual Studio 2015 (SSIS, SSAS, SSRS)

Confidential

Senior MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

  • Developed SSIS ETL Packages which involved usage of various transformations for the data loading of staging area, ware house and DataMart.
  • Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.
  • Worked with different methods of logging in SSIS.
  • Developed stored procedures and functions in SQL Server
  • Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.
  • Migration of code from one environment to other. Ex: development to SIT
  • Designed and implemented a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
  • Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.

Environment: SQL Server 2014, SQL Server Data Tools for Visual Studio 2015 (SSIS, SSAS, SSRS)

Confidential, Philadelphia

MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

  • Created the Cubes and Dimensions.
  • Created partitions and designed aggregations in Cubes.
  • Defined relationships between Measure groups and Dimensions.
  • Defined granularity with in a measure group and drill through actions.
  • Implemented the calculations to aggregate physical measures.
  • Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
  • Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
  • Created ETL package for data conversion using various transformations tasks.
  • Created partitions (employed storage modes and usage based optimization), calculated members, KPI's and perspectives to enhance the cube's utilization. Also used MDX to query them.
  • Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
  • Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2012.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Created dash board to show the business performance.
  • Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports, Matrix Reports.
  • Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculations.
  • Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.

Environment: SQLServer 2012,SSIS(2012/2008),SSRS(2012/2008),SSAS2012/2008, Visual Studio 2010/2013, MS Excel 2010, MS PowerBI

Confidential, Irving, Texas

MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

  • Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and other complex SQL statements.
  • Developed the SQL programs and optimized stored procedures, queries for faster retrieval.
  • Created jobs, alerts to run SSAS, SSRS packages periodically. Created automated processes for activities such as database backup processes.
  • Implemented failure alerts using email in SSIS.
  • Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server Analysis Services (SSAS).
  • Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008r/2012(SSAS).
  • Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS.
  • Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports, Drill-through and Drill-down using SSRS/Report Builder 3.0
  • Created dashboards for Inpatient, outpatient, finance and safety using benchmarked data to provide an analytical snapshot of point in time data.
  • Deployed various SSIS Packages, SSRS Reports and SSAS Cubes as per the business requirements.

Environment: SQL Server 2012 (SQL Server Management Studio, SQL Profiler, Integration Service (SSIS),Reporting Services (SSRS)),.NET, C#

Confidential

SQL Developer Intern

Responsibilities:

  • Involved in configuring and converting MS SQL Server 2000 database to MS SQL Server 2005.
  • Partially involved in Database design and Database objects.
  • Created backups for databases.
  • Partly Involved in Performance tuning.
  • Created ActiveX DLL COM Components using Visual Basic 6.0.
  • Responsible for Developing GUI Screens
  • Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
  • Responsible for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions.
  • Developed various management reports using SSRS.
  • Maintain the application as per the user requirement.

Environment: SQL Server 2000/2005, ASP .Net, VB Script, SSRS, Access, Excel

We'd love your feedback!