We provide IT Staff Augmentation Services!

Sql/ssis/ssrs/ssas Developer Resume

2.00/5 (Submit Your Rating)

WashingtoN

PROFESSIONAL SUMMARY:

  • Over 8 years of IT Experience in Database Design, Data Analysis Development and business intelligence of Microsoft SQL Server 2000/2005/2008/ 2012/2014/2016
  • Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS), Team Foundation Server .
  • Experience in Creating and writing complex SQL and T - SQL queries, Views, Indexes, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
  • Proficient in DW, OLTP, OLAP, Relational Database Systems (RDBMS),Data Analysis, Data Modelling, Normalization, Multi-Dimensional (Star) and Snowflake logical and Data Warehousing Design concepts.
  • Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
  • Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
  • Worked in AGILE/SCRUM methodology in development of Database Objects in SQL Server 2005/2008/2012.
  • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Look Up, Conditional Split, Bulk Insert, Aggregate, Merge and union all .
  • Experience in Crystal Reports, MS Access and report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
  • Experience in creating OLAP cubes, OLTP, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services (SSAS).
  • Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
  • Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables.
  • Worked in Creating DAX Expressions and implement Partitions in Tabular models
  • Hands-on Experience in MDX Expressions, DAX Expressions, Power BI Power Pivot, Power Query integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.
  • Worked on PowerBI in creating dashboards and reports and visualizing data.
  • Experience in creating reports from scratch using Power BI from Excel workbook that contains Power View sheets.

TECHNICAL SKILLS:

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS Tabular, DTS), OLAP, OLTP,T-SQL,DAX,MDX.

Reporting Tools: SSRS 2012/2008/2005/2000, Crystal Reports XI/X/9/8, Excel, Tableau, Power BI.

Database: MS SQL Server 2014/2008/2005/2000, Oracle 10g/9i/8i, MYSQL, MS-ACCESS.

Programming: C, C++, Visual C++ 6.0, C#,.Net, VB.Net, PL/SQL, TSQL.

IT Processes: Software Development Life Cycle (SDLC), Project Management

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

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

PROFESSIONAL EXPERIENCE:

Confidential, Washington

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Involved in gathering business requirement and technical specifications and design documents for developing the data warehouse.
  • Experienced on writing complex queries, performance tuning and optimized SQL queries using D-SQL T-SQL, SQL Profiler in SQL Server 2012/2014/2016 .
  • Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
  • Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
  • Worked on delivering source control, tracking work item, Team Foundation Build, reporting with the help of Team foundation Server.
  • Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
  • Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
  • Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environment.
  • Implemented Data Cleansing, Incremental Data Loading, Logging,Data Analysis, Event Handling and Error Handling.
  • 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
  • Loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
  • Created various types of reports such as sub reports, Tablix and Matrix using SQL Server Reporting Services and also created Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
  • Designed and architected Report Layout including both simple and complex report using SSRS 2005.
  • Created reports on both cascading and standard parameters.
  • Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors.
  • Experienced in using DAX Expressions to creating calculate fields in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular Model Projects(SSAS).
  • Experience in creating SSAS Tabluar models by importing from various data sources like SQL Server, Excel..etc
  • Worked on creating DAX Calculated Columns, KPI’s, Hierarchies on Tabular analysis service model.
  • Created calculated measures using MDX and DAX implementing business requirement
  • Experienced working on Star and Snowflake Schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them to SSAS database.
  • Expertise in OLAP and OLTP and Datawarehouse Concepts.
  • Worked on PowerBI in creating dashboards and reports and visualizing data.
  • Creating Gateway and publishing reports to users according to the client requirement.
  • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
  • Worked on Cloud platform Azure for storage applications.
  • Implemented Row level Security to restrict the access to users.
  • Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.

Environment: Windows server 2007,DW,MS SQL Server-2012/14/16 Enterprise Edition,TFS, SSIS, SSAS, SSRS, T-SQL,.NET, DTS, SQL Profiler,DAX, C#,OLAP, OLTP, Office-2007, Team Foundation Server(TFS),Azure,MS Excel,PowerBI, Kimball.

Confidential, Texas

SSRS/SSAS Developer

Responsibilities:

  • Worked in AGILE methodology in development of Database Objects in T-SQL, SQL Server 2005/2008/ 2008 R2/2012.
  • Involved in analysis of Report design requirements and generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
  • Added subscription and snapshot option to deployed reports for end users.
  • Expertise in Creating SSRS reports using Report Designer as well as Report Builder.
  • Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
  • Designed Subscriptions and Security for Reports.
  • Created reports on both cascading and standard parameters.
  • 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.
  • Worked on Tableau to create extensive eye-catching reports according to the client requirement.
  • Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
  • Implementing Dashboards and Score Cards using Microsoft Performance Point Server and integrated with share point.
  • Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements
  • Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas..
  • Developed Aggregations, partitions and calculated members for cube and SSAS Tabular Model as per business requirements.
  • Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model.
  • Developed normalized Logical and Physical database models to design OLTP.
  • Created a cube and Tabular Model using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
  • Experience in creating reports from scratch using Power BI from Excel workbook that contains Power View sheets.
  • Sound Experience and understanding of SSAS, DAX, Tabular Model,OLAP and OLTP cube, Data mining and Architecture.
  • Applied Inmon ER model for the enterprise data warehouse. Used dimensional model for data marts. Created data marts as physical separation from enterprise data warehouse and built them for departmental uses
  • Experience in creating OLAP cubes, identifying dimensions, KPI’s, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services(Tabular and cube Models). Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).
  • Designed, Build the Dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS). .

Environment: SQL Server 2012/2008R2/2008, SQL BI Suite (SSAS, SSIS, SSRS),Inmon, Report Builder,Power BI, MS Excel, SQL Profiler, MDX,DAX, MS Office, Visual Studio, Tableau,OLAP,OLTP.

Confidential, Texas

MSBI Developer

Responsibilities:

  • Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.
  • Developed, monitored and deployed SSIS packages.
  • Developed normalized Logical and Physical database models to design OLTP.
  • Created indexes both non clustered and clustered indexes in order to maximize the query performance.
  • Modified queries and stored procedures to improve the performance.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions
  • Generated multiple enterprise reports like SSRS and Crystal report, worked on Tableau.
  • Created various types of reports such as sub reports, parameterized, Tablix and Matrix using SQL Server Reporting Services.
  • Involved in creating MDX,DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
  • Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP,DAX, Tabular Model, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Environment: MS SQL Server 2008,Report Builder, T-SQL,Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),DAX, OLTP, SQL Server Analysis Services (SSAS), MS Excel, Windows 7, Crystal Reports, Data Migration, Toad,Tableau.

Confidential, MD

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Extensive experience in developing T-SQL Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
  • Performed Data Modeling in ER Studio 9.0 in the initial stages of the project.
  • Developed T-SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
  • Developed Packages using most of the Tasks, Containers and Transformations in SSIS.
  • Created SSIS packages to do incremental data load and logging.
  • Met SLA’s fine tuning the SSRS and long running ETL queries.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Worked on dimensional data modeling, dimensions and facts for OLAP cubes configured report server environment and deployed reports to the database.
  • Worked on creating cubes, calculations, KPI's, deploy of cubes using SSAS.

Environment: SQL Server /2012/2008 R2/2008,OLAP,OLTP, T-SQL, Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, Query Analyzer, SQL Server Profiler 2008.

Confidential

MSBI Developer

Responsibilities:

  • Developed normalized Logical and Physical database models to design OLTP.
  • Created indexes both non clustered and clustered indexes in order to maximize the query performance in T-SQL.
  • Modified queries and stored procedures to improve the performance.
  • Developed, monitored and deployed SSIS packages.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.
  • Generated multiple enterprise reports like SSRS and Crystal reports.
  • Created various types of reports such as sub reports, parameterized, Tablix and Matrix using SQL Server Reporting Services.
  • Involved in creating Cubes using SQL Analysis Services (SSAS).

Environment: MS SQL Server 2008/2005,T-SQL, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Excel, Windows XP, Crystal Reports.

Confidential

SQL Developer

Responsibilities:

  • Involved in all phases of SDLC, and gathered business requirements from business people.
  • Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
  • Worked extensively on DTS Package designs for Import/Export from various Data Sources.
  • Involved in performance tuning of T-SQL queries and Stored Procedures.
  • Implemented Auditing using triggers.
  • Involved in Physical and Logical design of the databases.
  • Developed DTS Packages to transfer the data between SQL server database and files.
  • Created and maintained Data Transformation Service (DTS) packages for migrating data.
  • Used SQL Profiler to debug T-SQL and slow running queries
  • Maintained Client relationship by communicating daily statuses and weekly reports.
  • Monitored performance and optimized SQL queries for maximum efficiency.

Environment: MS SQL Server 2000/2005, T-SQL, Windows 2000 server, DTS, SQL Profiler.

We'd love your feedback!