We provide IT Staff Augmentation Services!

Ms Sql/ssis/ssrs/ssas Developer/data Modeler Resume

4.00/5 (Submit Your Rating)

Wilmington, DE

SUMMARY

  • Over 8 years of IT experience as SQL Developer in Microsoft Business Intelligence framework (SQL Server, SSIS, SSRS, SSAS).
  • Experience in OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.
  • Expert noledge and extensive experience using SQL Server Integration Services (SSIS) to perform ETL and data integration processes.
  • Experience in migrating data from heterogeneous data sources like Excel, flat file, MS Access, Oracle, DB2, online, to MS SQL Server by using SSIS.
  • Good at SQL Server SSIS package design, constructing, and deployment.
  • Expert experience in Data Mart/Data Warehouse design, development, testing, deployment and production support in various business domains.
  • Extensive experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
  • Extensively used Report Wizard, Report Builder for developing and deploying reports in SSRS.
  • Experience in developing different types of reports such as Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
  • Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
  • Excellent working noledge in designing and deploying multi - dimensional databases for business intelligence analysis using SSAS.
  • Experience in designing aggregations and pre-calculating the same in SSAS, in creating groups and measures, KPIs, and understanding of database design, relational integrity constraints OLAP, OLTP, Cubes and normalizations.
  • Extensive SQL Server database experience and expert noledge in scripting Stored Procedures, Triggers and User-defined Functions in T-SQL.
  • Expertise in MS SQL Server installation, configuration, query optimization, performance tuning, backup/recovery. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Experienced in all phases of project life cycle starting from business requirement gathering, analysis, design, implementation, testing, and production.
  • Excellent interpersonal communication, problem solving, documentation and business analytical skills wif an ability to adapt new technology quickly and a strong team player.

TECHNICAL SKILLS

  • MS SQL Server 2005/2008/R2/2012
  • MS Visual Studio 2005/2008/2010
  • SSIS
  • SSRS
  • SSAS
  • ETL
  • DTS
  • MS-Office
  • MS-Access 2007/2003
  • Microsoft Project2007/2010
  • Oracle 8i/9i
  • MySQL
  • C/C++
  • C#
  • JAVA
  • J2SE
  • J2EE
  • Eclipse
  • SQL
  • Transact-SQL
  • HTML
  • ASP
  • ASP.NET
  • VB
  • VB.NET
  • XML
  • Crystal Reports
  • SQL Profiler
  • SQL Server Management Studio(SSMS)
  • ERWIN
  • MS Visio 2008/2010
  • SharePoint 2010
  • Business intelligence development studio (BIDS)/SQL Server Data Tools
  • Performance Point Server(PPS).

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

MS SQL/SSIS/SSRS/SSAS Developer/Data Modeler

Responsibilities:

  • Create new logical and physical design of Data Warehouse to fit new business requirement and implemented new design into SQL server 2012.
  • Identified the dimension, fact tables and designed the data warehouse using star schema/snowflake schema
  • Involved in creating Data Mart specifically for Sales and Marketing department. dis involved integrating data from various database systems like SAP, MS Access, Excel, flat file, etc.
  • Used various transformations in SSIS like Lookup, Fuzzy grouping and Row Count Transformations
  • Played role in design of scalable, reusable, and low maintenance ETL templates
  • Build efficient SSIS packages for processing fact and dimension tables wif complex transforms and type 1 and type 2 Slowly Changing Dimensions (SCD)
  • Modeled SSIS packages and used Analysis Services processing task to update the cube wif current data
  • Developed Ad-hoc Reports, Tabular, drill down, parameterized, cascaded and sub-reports by using SQL Server Reporting Services (SSRS)
  • Deployed reports in various sources like Web browser in XML and PDF formats.
  • Created Analytic Grid Report using data source (SSAS) in Performance Point Server (PPS) and integrated wif SharePoint.
  • Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.
  • Fine-tuned SSAS cube
  • Regular responsibilities for updating staging and dimensional databases as well as rebuild the dimensions and Cubes in Analysis Services
  • Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions
  • Constructed Cubes based on data volumes mostly adhering to Star Schema
  • Created Perspectives of the cube to simplify the process of browsing for the end users
  • Used Multi-dimensional Expressions (MDX) to create calculated members in the cube
  • Used to support the data processing engine in database intensive operations like query
  • Performance tuning, parallel query algorithm, data mining by writing Stored Procedures.
  • Implemented Complex Stored Procedures and automated them using SQL Server Agent
  • Programmed Triggers (Instead Of and After) for Auditing Purpose
  • Working wif Different methods of taking Database Backup and Recovery procedures.

Environment: MS SQL Server 2012, T-SQL, SharePoint 2010, MS Excel 2007/2003, Windows Server 2008R2, VB.NET, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio, ERWIN 8.0/MS Visio 2010, Performance Point Server (PPS).

Confidential, Nashville, TN

MS SQL Server/SSRS/SSIS Developer

Responsibilities:

  • Worked on the Data Warehouse design and analyzed various approached for maintaining different dimensions and facts in the process of building a data warehouse application.
  • Designed the data warehouse structure, data modeling and developed it using the Erwin tool, MS Visio.
  • Modifying existing cursors into optimized stored procedures for a better performance.
  • Extensively worked in extracting data from various sources such as flat files, MS Excel, Oracle etc.
  • Created ETL packages wif different data sources and loaded data into destination files wif various kinds of transformations.
  • Designed dynamic SSIS wif C#/VB.Net to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
  • Developed highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, For Loop Sequence Container, etc.
  • Involved in designing and deploying complex queries to perform various data base maintenance operations involving data profiling and data verification
  • Developed Procedures to implement type 1 and type 2 Slowly Changing Dimension
  • Defined the report layout and created, parameterized and drill through reports using SSRS
  • Developed reports using SSRS and Crystal reports, used table control, matrix control for cross tab reports.
  • Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
  • Extensively usedTeradataSQLAssistant to extract data from Data warehouse.
  • Redesigned and tuned existing stored procedures, triggers, views dat ultimately improved the performance of the queries using T- SQL.
  • Creating stored procedures for claim matching.
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
  • Generated test data and tested the database to meet the functionalities deliverables in the project documentation and specifications
  • Involved in installing and migrating legacy databases from MS SQL Server 2008 R2 to MS SQL Server 2012.

Environment: MS SQL Server 2008 R2/2012, Windows Server 2008, T-SQL, MS Excel 2010/2007, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Crystal reports 2010, SQL Server Business Intelligence Development Studio, Erwin 8.0, MS Visio 2010, SQL Profiler.

Confidential, Livingston, NY

MS SQL Server Developer/BI Developer/Data Modeler

Responsibilities:

  • Developed System Standards, System Architecture, Scenarios, detailed Screen Specifications and documented Logical and physical Data Model.
  • Built Star schema and Snow Flake schema depending on business requirements.
  • Implement Type I, II changes in Slowly Changing Dimension(SCD) tables
  • Built physical data structures like tables, views, constraints & Indexes
  • Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2008 R2.
  • Implemented SSIS for data transformation logic process.
  • Configured product meta-data tables to support client data reporting needs.
  • Working wif Different methods of taking Database Backup and Recovery procedures.
  • Generated database SQL scripts and deployed databases including installation and configuration
  • Worked on Stored Procedures and Database Triggers.
  • Worked on large number of business analytical functions.
  • Working wif different types of Replication Models like Snapshot, Merge and Transactional.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
  • Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
  • Used Microsoft Source Safe for version control and configuration management.
  • Tuning the Performance of Database, Query Optimization and Application tuning.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), T-SQL, DB2, Oracle, Microsoft Source safe, SQL Profiler, MS Visio 2008, Microsoft Source Safe, ActiveX.

Confidential, Chicago, IL

MS SQL/BI Developer/DBA

Responsibilities:

  • Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
  • DDL Scripts for generating Tables, Views, Functions.
  • Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
  • Performance tuning, query optimization and execution plan of queries for better performance.
  • Scheduling Backups and Restore database
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Performance tuning, query optimization and execution plan of queries for better performance.
  • Extended Data to XML and Excel Spread Sheet.
  • Developed reports using SSRS 2005/2008 and Crystal reports.
  • Created reports for analysis of data using SQL Server Reporting Services, Report Builder.
  • Assisted end users in user acceptance testing, by explain all the functionality of the data warehouse and its applications.
  • Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
  • Writing and testing stored procedures
  • Responsible for upgrading database SQL Server 2005 to SQL Server 2008.

Environment: Microsoft SQL Server 2005/2008, SQL Server Management Studio, T-SQL Stored Procedures, SQL Server reporting services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports 2008(12), Office, MS Excel.

Confidential

MS SQL Developer/DBA

Responsibilities:

  • Involved in transferring old data from various sources like flat files, MS Access, and MS Excel into MS SQL Server 2000.
  • Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
  • Created various Table and Views to ensure the performance growth of application.
  • Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-Defined functions.
  • Installed configured SQL Server 2005 successfully
  • Responsible for upgrading database from SQL Server 2000 to SQL Server 2005.
  • Created the structure of the model and cube in MS Analysis Services.
  • Reviewed Cube wif End user and changed the cube and documentation according to their Requirements.
  • Prepared end user documentation, Technical documentation, dimension map, Contact list and published into the Production server. Involved in training to the end users to familiarize them about how to use the Cube.

Environment: Windows Server 2003, Visual Studio 2005, MS SQL Server 2000/2005, DTS, MS SQL Server Analysis Services 2005(SSAS), MS Access, MS SQL Server Integration Services 2005(SSIS), T-SQL, MS Excel.

We'd love your feedback!