We provide IT Staff Augmentation Services!

Sql Server Developer Resume

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Developer

Responsibilities:

  • Development of Retail Management Call Center reporting solution using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Retail Management Call Center cube design and development with 10 Facts and 28 Dimensions using Agile Software Development.
  • Implemented efficient SSAS designs by incorporating leaf level calculations at the database level to gain performance compared to calculations design.
  • Implemented Delta processing for SSAS multi - dimensional cubes by implementing Current partition creation for every measure group and implementing XMLA-driven processing jobs.
  • Implemented Incremental Deployment Strategy for SSAS objects using SSAS Deployment Wizard and capturing Calculations using SQL Profiler for use in Calculations-only Deployments. Utilization of ASCMD command in XMLA execution for TIDAL jobs.
  • Implementation of a total of 36 Crystal Reports migration to SSRS in multiple phases using SDLC in a rapid implementation phase that contained 30 development days and 15 QA days.
  • Implemented Delta processing for SSAS multi-dimensional cubes by implementing Current partition creation for every measure group and implementing XMLA-driven processing jobs.
  • Performance tuning of SSAS Server by intelligently switching between Partition design and Aggregation design to achieve maximum network efficiency. Involved in creating advanced Aggregation designs using BIDS helper application.
  • Implementation of SQL-driven SSRS dataset code migration to Multi-Dimensional Expressions (MDX) using SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

Confidential

SSAS/SSIS/SSRS Developer

Responsibilities:

  • Implemented a mid-size Ware house/data mart Vontik Application solution with 5 facts and 12 dimensions for analyzing Vontik application using SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
  • Designed and supported a scalable ETL process for the Vontik data mart using SQL Server Integration Services (SSIS) and T-SQL Stored Procedures.
  • Streamlined data imports for Vontik data mart by re-designing existing legacy ETL Structure using SQL Server Integration Services (SSIS) for various data feeds such as Sql Server, MS Excel.. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Designed and developed several calculations such as #Member Count per Customer, Profile Entity Count at Customer, company, profile level, #Account by Ranges, etc. using SQL Server Analysis Services (SSAS) and Server side Multi-dimensional Expressions (MDX).
  • Performance tuning of SSAS Server by intelligently switching between Partition design and Aggregation design to achieve maximum network efficiency. Involved in creating advanced Aggregation designs using BIDS helper application.

Confidential

SSAS/SSIS/SSRS Developer

Responsibilities:

  • Implemented a mid-size Ware house/data mart TCR (Transmissions Conversion Repository) solution with 5 facts and 8 dimensions for analyzing Wachovia Migration Process Tracking using SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
  • Designed and supported a scalable ETL process for the TCR (Transmissions Conversion Repository) data mart using SQL Server Integration Services (SSIS); and responsible for setting up DEV/SIT/UAT/PROD environments for improved efficiency and minimizing average error count per month.
  • Streamlined data imports for TCR data mart by re-designing existing legacy ETL Structure using SQL Server Integration Services (SSIS) for various data feeds such as Oracle, MS Access, MS Excel, CSV files. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Developed and maintained an enterprise Reporting Solution using SSRS with an emphasis on -through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
  • Designed and developed several non-additive measures such as #DaysCompanyOnCompleteStatus, #AgingDays at relationship, company, application profile level, #ActualMonthlyTargetForCompanies, etc. using SQL Server Analysis Services (SSAS) and Server side Multi-dimensional Expressions (MDX).

Confidential

SSAS/SSIS/SSRS Developer

Responsibilities:

  • Designed and developed enterprise warehouse solution containing 18 Dimensions and 12 Facts based on Star Schema using SQL Server technologies T-SQL, SSIS, SSAS and SSRS from multiple text, CSV files and Relational systems such as Oracle, DB2 and SQL Server.
  • Performance tuning of SSAS Server by intelligently switching between Partition design and Aggregation design to achieve maximum network efficiency. Involved in creating advanced Aggregation designs using BIDS helper application.
  • Implemented efficient SSAS designs by incorporating leaf level calculations at the database level to gain performance compared to calculations design.
  • Experience in designing reports for the end user using SQL Server Reporting Services (SSRS) and creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
  • Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports.
  • Expert in calculating measures and dimension members using multi-dimensional expression (MDX) and mathematical formulas. Deployed and maintained SSAS Objects using deployment wizard or using Synchronize database wizard.
  • Created static and dynamic named sets for financial reporting needs using multi-dimensional expressions (MDX).
  • Improvised existing stored procedures by applying performance tuning methods with clustered/non-clustered index creation, statistics, and creation of primary key constraint, removal of duplicates, replacing sub-queries with left and inner joins for underlying tables.
  • Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard.
  • Wrote complex stored procedures for streamlining incremental data loads using left join.

Confidential

SSAS/SSIS/SSRS Developer

Responsibilities:

  • Wrote Client-side as well as Server-side MDX for multiple report types such as parameterized, drill down, drill through, URL and dashboard reports.
  • Involved in client interactions as well as functional requirement document (FRD) generation.
  • Worked with complex MDX functions such as Periods To Date, Year to Date, etc. to compute FOH/100 (Front Office Hours per hundred guests), BOH/100 (Back office hours per 100 guests), PPA (Price Per Averages) and plotting historical versus current sales, labor, guests statistics.
  • Developed and maintained report models to be used as data source for ad-hoc reports.
  • Facilitated on the fly and ad-hoc report request grants to financial team members on daily basis.
  • Migrated existing SQL sourced reports to MDX sourced reports to facilitate faster report rendering and more transparency to the end user.
  • Implemented conditional formatting in SQL SERVER Reporting Services to facilitate various report requests from finance, marketing, etc. departments.
  • Developed Visual Basic (VB) Code for facilitating complex business logic in Reporting Services Code property for custom-report generation and converting date parameters into SSAS time dimension members.
  • Expert in data verification in SQL Server database systems as well as SQL SERVER Analysis Services cubes for quality data preservation.
  • Worked with MacMarket front end application developers for facilitating the ad-hoc query requests as well as embedding crucial company reports such as dashboards, Labor productivity, Sales margin reports in a .NET front end.
  • Created Company health determining measures, KPI’s as well as defining Actions, translations and perspectives. Deployed and maintained SSAS Objects using deployment wizard or using Synchronize database wizard.

Hire Now