We provide IT Staff Augmentation Services!

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

2.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 knowledge 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 knowledge in designing and deploying multi - dimensional databases for business intelligence analysis using SSAS.
  • Experience in designing aggregations and pre-calculating teh 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 knowledge 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 teh dimension, fact tables and designed teh data warehouse using star schema/snowflake schema
  • Involved in creating Data Mart specifically for Sales and Marketing department. This 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 teh 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 teh dashboard to SharePoint.
  • Fine-tuned SSAS cube
  • Regular responsibilities for updating staging and dimensional databases as well as rebuild teh 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 teh cube to simplify teh process of browsing for teh end users
  • Used Multi-dimensional Expressions (MDX) to create calculated members in teh cube
  • Used to support teh 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 teh Data Warehouse design and analyzed various approached for maintaining different dimensions and facts in teh process of building a data warehouse application.
  • Designed teh data warehouse structure, data modeling and developed it using teh 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 teh 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 teh performance of teh queries using T- SQL.
  • Creating stored procedures for claim matching.
  • Used SQL Profiler to monitor teh server performance, debug T-SQL and slow running queries
  • Generated test data and tested teh database to meet teh functionalities deliverables in teh 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 me, 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 teh logic in Procedures, Functions and Triggers for optimum performance.
  • Used Microsoft Source Safe for version control and configuration management.
  • Tuning teh 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 teh functionality of teh 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 teh 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 teh structure of teh model and cube in MS Analysis Services.
  • Reviewed Cube wif End user and changed teh cube and documentation according to their Requirements.
  • Prepared end user documentation, Technical documentation, dimension map, Contact list and published into teh Production server. Involved in training to teh end users to familiarize them about how to use teh 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!