We provide IT Staff Augmentation Services!

Sql Server/ssis/ssrs/ssas Developer Resume

Portland, OR

SUMMARY:

  • Over 8 years of IT Experience as a SQL Server Developer / Business Intelligence Developer in analysis, design, development, testing, Deployment and Maintenance of SQL Server Technologies.
  • Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005/ 2008 / 2012 / 2014 .
  • Experience in Database Design, Development and maintenance of database applications on SQL Server 2005/2008/2012/2014 R2 in OLTP / OLAP / BI environment.
  • Proficient in ETL (Extract - Transform - Load) using SQL Server Integration Services (SSIS).
  • Proficient in T-SQL Queries using Store Procedure, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, DDL and etc.
  • Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
  • Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Report on SSAS Cube and using SSRS to develop Drill-down, Drill-through And Cascading reports.
  • Experience in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
  • Expertise in OLTP / OLAP system study, developing Database Schemas like STAR Schema and Snowflake Schema used in relation, dimensional and multidimensional modelling.
  • Experience in creating various database objects in C#, Visual Studio and ASP.net and deploying them to the SQL Server.
  • Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
  • Data modeling experience focusing on high-activity, normalized transaction systems (OLTP), highly-usable de-normalized reporting systems (OLAP) as well as staging areas, Data marts.
  • Expert in Cube designer in Business Intelligence Development Studio (BIDS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
  • Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).
  • Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
  • Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
  • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
  • Good communication and interpersonal skills. Strong points include quicker grasp to new concepts, the ability to pursue matters in great detail and able to work in a team.

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012/2008 R2, 2005 & 2000, MS-Access 2000

Database Tools: SSMS, BIDS/Visual Studio

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS,SSRS, Database Tuning Advisor, SQL* Plus

Languages: C, C++, C#.NET, JAVA, UNIX, SQL, T-SQL, PL/SQL

RDBMS: SQL Server 2000/2005/2008 R2/2012/2014, Oracle 11g/10/9i

IDE: Visual Studio 2003/2005/2008 R2/2012

OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP, Windows 7/8

Other Tools: Erwin, Visio, Visual SourceSafe, MS Office suite

PROFESSIONAL EXPERIENCE:

Confidential, Portland, OR

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Worked as a developer in creating complex stored procedures, Triggers, Functions, Indexes, Tables, Views and SQL joins for applications.
  • Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
  • Optimized queries tuned and monitored server performance using SQL Profiler.
  • Implemented different types of constraints on tables.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Developed SSIS solution for developing a fully-fledged data warehouse solution.
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
  • Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like Execute SQL Task, Data Flow Task etc.
  • Responsible for creating the reports based on the requirements using SSRS 2012.
  • Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
  • Daily Worst Cell Analysis & recommendations for improving KPI through Sprint Optimization tools SNAP, Tableau, Reveal.
  • Identified and defined the Datasets for the report generation.
  • Deployed the generated reports directly on the client’s workstation.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Implemented the calculations to aggregate physical measures.
  • Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
  • Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
  • Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
  • Identified and defined Fact relationships in SSAS.
  • Involved in writing scripts for the clients requirements for reporting purposes.
  • Actively supported business users for change in requests. Gathered user requirements.
  • Implementing Dashboards and Score Cards using Microsoft Performance Point Server and integrated with share point.

Environment: SQL Server 2012, SSIS (2012/2008), SSRS (2012/2008), SSAS (2012/2008), Visual Studio 2010/2013, MS Excel 2010, T-SQL, C#, VB Script, Informatica 9.1.0, Window 7, Team Foundation Server.

Confidential, Conway, AR

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Involved in creating technical specification documents after gathering requirements from business users.
  • Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and automated stored procedures.
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
  • Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
  • Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
  • Worked with various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task, For each loop container.
  • Created and scheduled SQL jobs to run SSIS packages on a daily basis using SQL Server Agent.
  • Writing VB.NET and C# coding in Script task and script component.
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Managing and automating Control flow, Data flow, Events and Logging for SSIS packages.
  • Designed and developed different reports like Matrix and Tabular reports, Cascaded, Parameterized, and pie chart reports using SQL Server Reporting Services (SSRS).
  • Expertise in developing Ad-Hoc, Drill down, Drill through and Dashboard reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS). Promoted RDLs to Reporting Service Server.
  • Defined relationships between Dimensions and Measure groups.
  • Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
  • Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
  • Defined Granularity with in a measure group and drill through actions.
  • Planned Backup strategy based on projects requirements.
  • Resolved any deadlocks issues with the Databases/Servers on a real-time basis.

Environment: SQL Server 2008/2012, Business Intelligence Development Studio, SSRS 2008 R2, SSIS 2008 R2, MS Visual Studio 2008, T-SQL, C#, VB Script, Window 7, Team Foundation Server.

Confidential, Cleveland, OH

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, views and other SQL joins and statements for applications.
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
  • Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
  • Maintained data integrity by performing validation checks.
  • Developed SSIS project for transferring the data.
  • Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
  • Created SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
  • Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of the over-600 users.
  • 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.
  • Identified and defined the Datasets for report generation.
  • Created SQL Server Reports using SQL Server Reporting Services (SSRS).
  • Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis.
  • Created parameterized, drill-down and drill-through reports. Wrote the queries for the drill down reports.
  • Documented all database changes and follow and enforce change and release management processes.

Environment: SQL Server 2005/2008, BIDS 2005/2008, SSRS 2005/2008, SSIS 2005/2008, DTS, MS Access, Visual Studio, T-SQL, Windows.

Confidential, Chicago, IL

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
  • Created complex Stored Procedures, views, Triggers, Tables and other SQL joins.
  • Modified current database by adding tables, altering referential integrity and relationships to support the control system.
  • Created clustered /non-clustered indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
  • Used Triggers to generate customized error messages.
  • Created SSIS package to schedule the jobs for batch processing.
  • Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
  • Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
  • Worked with Package Configurations for SSIS package deployment.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
  • Expertise in generating reports using linked reports, sub reports and filters in SQL server reporting services (SSRS).
  • Created parameterized reports, Drill down and Drill through reports using SSRS.
  • Deployed and configured the reports in the Report Server.
  • Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis.
  • Developed stores procedures to transform the data from Enterprise Data Warehouse to data mart to build dimensions and load data to fact tables.

Environment: SQL Server 2005, SSIS (2005), SSAS (2005), Erwin, Windows Server 2003, MS Visual Studio 2008.

Confidential

MS SQL/BI Developer

Responsibilities:

  • Involved in requirements gathering, analysis, design, development, change management, deployment.
  • Installed and Configured SQL Server 2008 successfully.
  • Created Stored Procedures, User defined functions, Views, Triggers, Indexes and Wrote T- SQL codes maintaining query standards for the project.
  • Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and Worked on Index tuning, stored Procedure tuning.
  • Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
  • Created SSIS packages using SSIS designer for export heterogeneous data from OLE DB Source, Excel spread sheets and Flat files to SQL Server 2008.
  • Generated packages using various Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all and etc.
  • Utilized SSRS reporting services to generate different types of reports from the database.
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and Sub Reports.
  • Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in Visual Source Safe (VSS).
  • Evaluated database performance and performed maintenance duties such as Tuning, Replication, Backup and Recovery.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services, SQL Server Reporting Services, DTS, MS Access, MS Excel, Windows 2003 servers, T-SQL, PL/SQL, Visual Studio 2008.

Confidential

Junior SQL Server Developer

Responsibilities:

  • Installed and configured SQL Server 2005 successfully on Windows Server 2003.
  • Created other database objects like tables, views, Stored Procedures, User Defined Functions, Triggers and indexes.
  • Error handling using Try-Catch Block.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
  • Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
  • Used the Control Flow and Data Flow Tasks and Transformations in Creating SSIS (ETL) Packages.
  • Created Master Child package using variables and Execute package task in SSIS.
  • Assisted the front end application developers with their queries.
  • Taking Database full Backup, Transaction log backup & differential backups.
  • Configured Snapshot replication for reporting, user acceptance test and development servers.
  • Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: SQL Server 2005, T-SQL, VB, MS Word 2005, DTS, SQL Profiler, Visual Source Safe, DTS/SSIS 2005, Import and Export Wizard, BCP, Windows Server 2003, UNIX.

Hire Now