We provide IT Staff Augmentation Services!

Ms Sql Bi Developer Resume

Omaha, NE

Professional Summary:

  • 7+ years of Database Design and Development experience on SQL server 2008/2005 & SQL Server 2000 in OLTP and OLAP environment.
  • Ability to understand current business processes and implement efficient business process
  • Involved in defining the source to target data mappings, business rules and data definitions.
  • Expertise in generating reports using SQL Server Reporting Services (SSRS)2008/2005.
  • Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
  • Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
  • Experience in developing and monitoring SSIS Packages and DTS packages.
  • Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008/2005
  • Worked on SQL Server migration from SQL Server 2008 / 2005 for R2 Systems.
  • Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
  • Extensive experience in design, development and performance tuning of SSAS cubes and queries using Multidimensional Expressions (MDX).
  • Created star schema in SSAS and developed SSRS reports based on the cubes.
  • Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
  • Expertise with T-SQL in writing complex queries ,triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and maintaining data integrity
  • Experience with the .NET framework including C#, ASP.NET and Web Service.
  • Working Experience in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
  • Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
  • Experience in .NET framework including C#, ASP.NET and Web Service.
  • Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
  • Responsible for the administration, monitoring and backup of databases, Creating and maintaining user access, space management, along with Install and configure database (SQL Server and Oracle).
  • Maintaining, creating / Designing and monitoring databases (SQL server, Oracle), Monitors database for potential problems and creates end user reports. Also Security Administration and Replication, Database mirroring & clustering.

Technical Skills:

RDBMS: MS SQL Server 2008/2005/2000 , SQL Server 2008 R2, Oracle 8i/9i, MS Access.

Database Tools: SSIS, SSAS,SSRS , Enterprise Manager, Query Analyzer, SQL Profiler, Management Studio, SharePoint 2007,COGNOS 6.5/7.0, Crystal Reports 9.0/10

Languages: SQL, TSQL, VB.NET, C#, XML, C++, Java, VB 6.0

Scripts:: JavaScript, VBScript, HTML, DHTML and XML

Web Tools:: MS-Front Page, Macromedia Suite, IIS, Outlook Express

Applications:Microsoft Office, Visio, and Visual SourceSafe. Visual Studio, Team Foundation Server.

Operating Systems: Windows 9x/NT/2000/XP.Unix

Work Experience:

Confidential – Omaha, NE

MS SQL BI Developer

Project : Agent Information System

Confidential is an insurance company; it is a subsidiary of Berkshire Hathaway. The goal of the project is to bring the data that agents send from different sources and build a centralized database to access all the information.

Responsibilities:

  • Worked with Business Analysts to gather various business requirements and implemented them while designing various SSIS packages and SSRS reports.
  • Worked on designing, creating, deploying and troubleshooting SSIS packages for transferring data from flat files excel spreadsheets and Heterogeneous data sources to and from SQL Server using SQL Server data tools.
  • Used Event Handlers for Custom Logging using Complex Stored Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed).
  • Developed SSIS packages for Initial Data Loads and Incremental Loads.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced features of SQL Server Integration Services.
  • Created jobs and scheduled SSIS packages to run automatically to import data from flat files to SQL Server.
  • Designed and implemented Cross Tab, Drill Down and Drill Through reports, Parameterized, Ad hoc, Sub-Reports and charts using SQL Server Reporting Services (SSRS) and configured them to send emails to users on weekly basis.
  • Created and deployed cubes on SSAS.
  • Created Dimensions using STAR and SLOW FLAKE schema in SQL Server Analysis Services (SSAS).
  • Extensively involved in Data Mining Models, developing reports using MDX and SQL.
  • Created database objects like tables, stored procedures, functions, triggers as per the requirements and tuned slowly running queries.
  • Refreshed development, quality analysis and staging environments with the latest production database backups and created migration plan and scripts for every release.
  • Improved query performance by adding covered indexes, adding file groups.

Environment: SQL Server 2012, SQL Server Data Tools, SSIS, SSRS, T-SQL, Performance Point Server.

Client: Confidential, MN

Role: MS SQL BI Developer

Responsibilities:

  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Involved in defining the source to target data mappings , business rules and data definitions.
  • Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
  • Expertise in designing databases and capacity planning .
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Scheduled the backups for Databases and Transaction log . Performed restoration operations. Suggested backup strategies.
  • Archiving the Data onto Backup tapes
  • Upgraded SQL Server 2000 to SQL Server 2005 server for high volume processing databases.
  • Created Linked Servers between SQL Server 2008 R2 & Oracle 9i. Also created DTS package for data transfer between the two environments.
  • Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages.
  • Used SSIS to extract, transform and consolidate data from different sources into Data Warehouse.
  • Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
  • Created star schema in SSAS and developed SSRS reports based on the cubes.
  • Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
  • Experience with the .NET framework including C#, ASP.NET and Web Service .
  • Implemented 2-node Active/Active & Active Passive Clustering.
  • Successfully implemented Database Mirroring in SQL Server 2005.
  • Configured Central Publisher/Distributor Transactional Replication Model (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
  • Rebuilding the indexes at regular intervals for better performance.
  • Developed complex stored procedures, T-SQL functions, Joins, triggers and views using SQL Server Management Studio.
  • Responsible for Query optimization and Performance tuning , tuned SQL queries using Show Plans and Execution Plans .
  • Performed database backup and deployment to the production server.
  • Monitoring SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
  • Involved in configuration of Team Foundation environment along with Share point Services and Reporting Services.
  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults
  • Exported and imported data from text files and Excel T-SQL Server database using bulk copy insert and BCP utility.
  • Reviewed all code prior to production and moved team from Visual Source Safe to Subversion.
  • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

Environment : MS SQL Server 2000/2005 /2008 , SQL server 2008 R2, NETEZZA SQL, Windows Enterprises 2003 servers, VERITAS, SSMA, SAN, Index Tuning Wizard, Database Maintenance Plan Wizard, SQL Server Integration Services (SSIS), SSAS, Transact-SQL, Net Framework, Visual studio, Visual Source Safe.

Confidential, Champaign, Illinois

SQL Server Developer/ BI Developer

Confidential is international hobby product distributor. . It develops innovative products and distributes efforts that are supported not only by cutting-edge retailer services, but also by direct-to-consumer marketing through print media and e-commerce.

Responsibilities

  • Participated in gathering User Requirements and System Specifications.
  • Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
  • Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
  • Created and when required, modified already existing stored procedures, triggers, views,.
  • Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
  • Tested queries to optimize the procedures and triggers to be used in production.
  • Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
  • Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
  • Created the SSIS/DTS packages and scheduled them.
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Created SSIS Packages and used OLEDB Source as an existing Oracle Database.
  • Rebuilding Indexes and Tables as part of performance tuning exercise.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.
  • Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
  • Created simple Reports using SSRS.
  • Experience in creating snapshots of static reports and configure subscription.
  • Created and managed the databases in development environment.

Environment: SQL server 2008R2, Microsoft Share point Portal Server, Lumigent Log Explorer, VSS, SQL Diagnostic Manager, SQL LiteSpeed, Dell Power Edge 2650, 1750, 2600

Client: Confidential – Hartford, CT

Role: SQL Developer

Responsibilities:

  • Managed the complete migration of SQL Server 2000 databases to SQL Server 2005.
  • Involved in defining the source to target data mappings , business rules and data definitions .
  • Responsible for defining the functional requirement documents for each source to target interface .
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS .
  • Created SSIS Packages to import data daily from OLTP Applications to data warehouse.
  • Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
  • Provided organizational reporting and timely reports utilizing SSRS (SQL Server Reporting Services )
  • Integrated SharePoint with SSRS and managed reports subscriptions, delivery, generation, rendering, and snapshoting via SharePoint User Interface.
  • Created star schema in SSAS and developed SSRS reports based on the cubes.
  • Analyzed data from legacy systems for Data migration project (SQL 2000/Oracle – SQL 2005)
  • Developed several database structures, complex SQL queries , stored procedures, views, triggers and user-defined functions .
  • Managed Query Optimization and Performance Tuning of Stored Procedures, Functions etc
  • Managed production servers with multiple databases, with a couple over 3 terabytes both in clustered environment with mirroring and replication
  • Wrote triggers (After and Instead Of) and stored procedures to capture updated and deleted data from OLTP systems.
  • Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning wizard .
  • Implemented Log Shipping and Transactional Replications as part of disaster recovery plans.
  • Worked on Customized Team Foundation Item Work Item Templates and Workflow (Transitions Matrix) of the Work Items.
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases
  • Scheduled jobs for backup, and created alerts for error reporting.
  • Involved in migration of SQL and Oracle change requests.
  • Reviewed all code prior to production and moved team from Visual Source Safe to Subversion

Environment: SQL Server 2005,SSRS 2005,SSIS 2005,SSAS, T-SQL, ODBC, Excel, Access, Windows 2000/XP, IIS, .net Framework, Visual Studio, Visual Source Safe

Client: Confidential

Role: SQL Developer

  • Designed databases for OLTP applications
  • Created tables, indexes and constraints.
  • Created Triggers, Stored procedures for implementing the business logic.
  • Managed Database files, transaction log and estimated space requirements.
  • Configured and monitored database application.
  • Designed and implemented several complex reports
  • Designed VB forms using the forms and crystal reports were made for business reporting purpose.
  • Created stored procedures for module integrity and application.
  • Wrote database triggers in T-SQL to check the referential integrity of the database
  • Managed ongoing activities like importing and exporting, backup and recovery.
  • Administered of all SQL server database objects, logins, users and permissions in each registered server.

Hire Now