We provide IT Staff Augmentation Services!

Senior Sql Server Bi Developer Ssis/ssrs Resume

Oklahoma City, OK

SUMMARY

  • Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R2/2005/2000 with various business domains like Healthcare, Insurance, Finance in Development, Testing and Production Environments
  • Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2012/2008/2005.
  • Experience in Creating Tables, Joins, Views, Indexes, Triggers, Stored Procedures, User Defined Functions, synonyms, collections, Exception handling, Query Tuning using query optimizer.
  • Experience in writing T-SQL objects, stored procedure in SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012.
  • Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
  • Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor.
  • Successfully implemented indexes on tables and views for optimum performance tuning and debugging .
  • Experience in Error and Event Handling : Precedence Constraints, Break Points, Check Points, Logging.
  • Performed some of the DBA activities like Backup, Restore, monitoring etc.
  • Experience working with XML documents and extracted data from XML to SQL server .
  • Expert Knowledge of Integration Services (SSIS) and Reporting Services (SSRS). Worked Extensively on ETL process using SSIS packages.
  • Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Knowledge in creating SSIS Packages using oracle source and oracle destination and extensively used Team Foundation server (TFS) to check SSIS packages in to the source control.
  • Worked with re-directing outputs into different formats including XML Files and various other data sources.
  • Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
  • Responsible for designing ETL solutions/ framework with SSIS. Also responsible for the performance tuning of the ETL packages.
  • Involved in designing complex Crystal Reports 2011/2008/XI/10.0/8.5 including Cross-tab, Conditional, Drill-down/summary, Top/Bottom N and also reports involving multiple Sub reports, On Demand Sub reports, Charts, Conditional formatting, Summaries and Complex formulae.
  • Responsible for Data Migration from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 Databases.
  • Migration of SSRS reports from SQL 2005 to SQL 2008. Migration experience with DTS to SSIS 2008. Extensive experience with data modeling techniques, logical and physical database design.
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart, and Sub Reports and formatting them using both SSRS 2005/2008.Very good knowledge in scheduling and deploying reports on report manger.
  • Developing reports on SSRS on SQL Server (2000/2005/2008 ). Involved in SSAS, OLAP cube and MDX Queries.
  • Strong Knowledge on concepts of Data Modeling Star Schema/Snowflake modeling, FACT & Dimensions tables and Logical & Physical data modeling.
  • Experience in Designing, Developing and Maintaining Web Applications using Visual Studio .NET, ASP.NET MVC 3, C#, VB.NET, ADO.NET.
  • Good communication with the project team throughout all stages of design, managing time effectively, and work on multiple project timelines simultaneously in a demanding deadline driven environment.

TECHNICAL SKILLS

Programming Languages: C#, C, C++, VB.NET, Visual Basic for Applications (VBA), XML and ASP.NET.

RDBMS: MS SQL Server 2012, 2008 R2, 2008/2005/2000 , Oracle 8i/9i/10g, MS-Access 97- 2007

SQL Server Tools: SQL Server Management Studio (SSMS), Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), SSIS, SSAS, SSRS, Crystal Reports 9/10, TFS 2008/2010, Data Transformation Services.

Data Modeling Tool: ERwin r7.3/7x/4.0, MS Office Visio 2003/2007.

Operating System: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize.

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma City, OK

Senior SQL Server BI Developer SSIS/SSRS

Confidential is a public, American oil and natural gas company headquartered in Oklahoma City , United States. Confidential is the second-largest natural gas producer in the United States. The project involves merging of databases in to a new database which included, creating Tables, Stored procedures, Views and SSIS packages to populate data from databases.

Responsibilities:

  • Developed Databases using complex Stored Procedures, Triggers, Functions, Constraints, Indexes and Views as required in a SQL Server environment.
  • Dealt with Fine-Tuning stored procedures to improve performance with a Query Plan using SQL Tuning Advisor.
  • Worked with re-directing outputs into different formats including XML Files and various other data sources.
  • Created, loaded, and modified new packages added and configured components by using Control Flow Tools and Data Flow Tools in Microsoft SQL Server Integration Services (SSIS).
  • Knowledge in creating SSIS Packages using oracle source and oracle destination and extensively used Team Foundation server (TFS) to check SSIS packages in to the source control.
  • Created ETL tools and packages to extract heterogeneous data from Excel, Flat file, XML, OLE DB Source to SQL Server.
  • Implemented error handling and resolved issues by troubleshooting the scripts in failure to load the data into database.
  • Populated Data Warehouse using SSIS Packages.
  • Deployed SSIS packages dynamically into Development, Testing and Production environments by creating Environment variables and Windows variables.
  • Developed SQL Server Reporting Services (SSRS) reports using Global Variables, Expressions, and Functions.
  • Developed and deployed different types of reports like Drill Down, Drill Through, Parameterized, List, Tabular, Chart, Linked and Sub Reports etc. using SSRS and integrated into the web front end.
  • Monitored and Tuned SQL server Database Performance and Query Analysis for optimizing report performance.
  • Analysis and documentation of SSIS packages and existing reporting system.
  • Performed some of the DBA activities like Backup, Restore, monitoring etc .

Environment: SQL Server 2014/2012/2008 , T-SQL, MS Visual Studio 2012 (SSIS, SSRS), Query Analyzer, Enterprise Manager, Dashboards, C#, ASP.Net, Star Team.

Confidential, Miami, FL

Sr. SQL Server BI Developer SSIS/SSRS/SSAS

Confidential is part of Assurant , a premier provider of specialty insurance products. The project involves creating web applications, which involves front-end and back-end. I was involved in developing back-end operations i.e. creating Conceptual and Logical Entity Relationship Diagrams to creating Database, Tables, View, Triggers and Stored Procedures and executed SSIS packages to populate data from various data sources.

Responsibilities:

  • Created database objects like tables, complex Stored Procedures, Functions, Views, Triggers, Indexes and T-SQL queries (DDL and DML) to meet the business requirements using T-SQL.
  • Created Joins and sub-queries for complex queries involving multiple tables.
  • Used DDL and DML for writing Triggers, Stored Procedures, and Data manipulation.
  • Involved in writing SQL Stored Procedures to access data from MS Access. Developed SQL queries to check the database.
  • Created functions and developed procedures for implementing application functionality at the database side for performance improvement.
  • Pulling the data from T-SQL stored procedure to make the parameterized reports.
  • Hands on MS SQL Server configuration, performance tuning, debugging, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using SQL Server Profiler, Execution Plan, Performance Monitors.
  • Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component.
  • Responsible for Data Migration from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012 Databases.
  • Experience in providing Logging and Error handling by using Event Handler and Custom Logging for SSIS Packages and involved in scheduling and administering the SSIS packages .
  • Extracted data from XML to SQL server .
  • Deployed the created SSIS packages in Development and Testing environments.
  • Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS) version.
  • Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
  • Used VB.Net and other .NET languages for Script task. Script task is primarily to control the flow of SSIS package.
  • Backing up, Restoring system & other databases as per requirements, and also scheduled those backups.
  • Developed Query for generating drill down, drill through, parameterized, cascaded reports in Crystal Reports 2011.
  • Worked on SQL Server Reporting Services (SSRS) and Report Builder Model to generate custom reports.
  • Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.
  • Created and Managed OLAP Cubes using SSAS.
  • Involved in the design and development of the SSAS cubes and MDX queries.

Environment : SQL Server 2012, T-SQL, Crystal Reports 2011, MS SQL Server Integration Services (SSIS), Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling, ASP.NET Framework 3.5/4.0, C#, Visual Studio 2012, XML, ADO.NET.

Confidential, Buffalo, NY
SQL Server BI Developer SSIS/SSRS/SSAS

Confidential is the New York State Catholic Health Plan, providing quality, affordable, New York State-sponsored health insurance coverage. The objective of this project was maintenance and enhancement of a few databases for the claims and customer data. The enhancement was planned by importing a few tables from different databases, modifying the existing table structure, creating necessary views and temporary tables and loading the data in to database.

Responsibilities:

  • Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
  • Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
  • Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end.
  • Extensively used joins and sub queries to simplify complex queries involving multiple tables. Developed views using complex split week logics.
  • Performed Data Modeling in the initial stages of the project.
  • Worked in AGILE methodology using SQL Server 2008 R2.
  • Experience working with XML documents.
  • Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
  • Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary..
  • Involved in query optimization, performance tuning and debugging.
  • Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
  • Implemented error handling in several existing Stored Procedures using Try Catch blocks.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task 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.
  • Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
  • Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2.
  • Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008.
  • Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports, Tabular, Matrix etc.
  • Handled complex financial data and large databases.
  • Involved in the design and development of the SSAS cubes and MDX queries.
  • Used ADO.NET for retrieving, querying, storage, and data manipulation. Implementation of client side validations using ASP.NET validation controls.

Environment: SQL Server 2008 R2/2008, T-SQL, Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling, ASP.NET, C# 3.5/2.0, .NET Framework 3.5/2.0.WebService, ADO.NET, HTML .

Confidential, Livingston, NJ

SQL Server BI Developer SSIS/SSRS

CIT is a financial holding company which provides commercial financing and leasing capital and advisory services to its clients and their customers across more than 30 industries. The project was aimed at handling day-to-day transactions. Handling the data is done using packages created using SSIS.

Responsibilities:

  • Actively participate in gathering of user requirement and system specification.
  • Performing DBA functions, installing, configuring and supporting database systems.
  • Responsible for writing SQL queries , stored procedures , views, triggers, T-SQL and SSIS.
  • Increased query performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process. Indexed views, dimensions and stored outlines for optimal performance.
  • Check the performance of each and every query using SQL Profiler, Index Tuning Wizard and Estimated query plan optimize the performance tuning of SQL queries and stored procedure.
  • Created partition table for very large database for good performance.
  • Reviewed and developed data models and database designs with development teams.
  • Backups and Restoration / Database Recovery, Resource allocation / Monitoring
  • Involved in Data Migration from SQL Server 2000 to SQL Server 2005 Databases.
  • Deployed SSIS packages and Reports to Production Servers.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Responsible for designing ETL solutions/ framework with SSIS. Also responsible for the performance tuning of the ETL packages.
  • Generated database monitering and data validation reports in Proclarity and SQL Server Reporting Service (SSRS ). Reported all events and requirements through established reporting mechanisms in SSRS.
  • Designed and developed OLAP using MS SQL Server Analysis Services
  • Created complex business components in C# using .NET Class Library assemblies while migrating and implementing them in a multi-tier environment suitable for .NET Remoting, XML Web Services, Microsoft Transaction Server (MTS) to address application infrastructure issues associated with building scalable enterprise level applications for multiple clients.

Environment: SQL Server 2008 R2/ 2008/2005/2000 , Oracle 9i, T-SQL, Excel, MS Access, Advanced Windows 2000/2003 Server, Visual Basic .Net, SQL Server Data Tools, Query Analyzer, SQL Server Profiler.

Confidential, Houston, TX

SQL Server BI Developer SSIS/SSRS

Confidential Nextel offers a comprehensive range of wireless and wire line communications services bringing the freedom of mobility to consumers, businesses and government users. My responsibilities mainly focused on Migration of SQL server from 2005 to SQL 2008, created stored procedures and involved in error handling.

Responsibilities:

  • Installation, configuration of MS SQL Server 2005/2008.
  • SQL server Upgrade from 2005 to SQL 2008.
  • Designing and creation of tables and stored procedures with E-R diagrams.
  • Merging 2 different versions of databases to one single database and upgrading to SQL 2008.
  • Designed the Dimensional modeling of the Data warehouse using Erwin.
  • Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
  • Extensively involved in designing (Logical and Physical) of customer database.
  • Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity.
  • Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it.
  • Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them.
  • Ensured developers coordinated their efforts in managing and maintaining different application databases.
  • Reduced systems downtime risk through automatic offsite backup and recovery over network.
  • Data Warehousing using Data Transformation Services Package (SSIS).
  • Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Highly involved in creating, structuring, formatting using Report Designer and Report Builder.

Environment: MS SQL Server 2005/2008, Windows 2003 Server, SQL Query Analyzer, SSIS, TSQL, C#,ASP.NET.

Confidential, Clifton, NJ

SQL Server BI Developer

Roche is a one of the leading manufacturing company in the Pharmaceutical business. The Rx information provided by the NDC and IMS agencies are loaded in warehouse to be presented in Monthly and weekly Reports. The reports were developed according the Business requirements and published to corporate documents.

Responsibilities:

  • Gathered Functional requirements, Business requirements and wrote the technical specifications for building the Global Enterprise Data warehouse.
  • Actively involved as a part of a team for gathering and analyzing the User Requirement.
  • Modified existing database to fit new business requirement by adding tables and relationships.
  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults. Upgraded SQL Server 2000 databases to SQL Server 2005.
  • Managed the legacy data in the data warehouse from various data sources.
  • Created Indexed View to optimize query performance by facilitating easy user interface implementation.
  • Created Linked Server to retrieve data from other databases.
  • Worked on SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server.
  • Documented different Stages of Data Transformation, procedures and scripts.
  • Worked on XML parameters for inserting data into tables using FOR XML, OPEN XML.
  • Performed Backups and Restore of the databases.
  • Upgraded DTS Packages to SSIS Packages.
  • Involved in Import and Export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
  • Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
  • Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.
  • Created jobs using SQL Server Agent and generated SSRS (SQL Server Reporting Services) reports as a part of each job.

Environment: Windows 2000 Advance Server, SQL Server 2000/2005, T-SQL, DTS, BIDS, SSIS, SSRS.

Confidential

SQL Server Developer

Confidential is one of India’s leading life insurance companies. The Project started in 2003 with a life Insurance Plan. The requirement here was assisting building database and also modifying when required. Integrating different databases and finally giving report about the effective policies sales.

Responsibilities:

  • Involved in Physical and Logical design of the databases.
  • Developed DTS Packages to transfer the data between SQL server database and files and Scheduled Jobs for DTS packages.
  • Created and maintained Data Transformation Service (DTS) packages for migrating data.
  • Used BCP/Bulk Insert to publish table output to text files.
  • Created advanced T-SQL queries using DDL, DML and Indexes, Views, Cursors, Triggers, User Defined Functions and Stored Procedures.
  • Responsible for database development and performance tuning of the T-SQL queries using SQL Profiler and Activity Monitor.
  • Used all Declarative Constraints for maintaining Data Integrity.
  • Created Views to restrict access to data in a table for security.
  • Involved in performance tuning of T-SQL queries, stored Procedures and implemented Auditing using triggers.
  • Created schema objects, rules and granted roles to the users.
  • Used SQL Profiler to debug T-SQL and slow running queries.
  • Monitored the Database Performance using execution plans and Index tuning.
  • Optimized the query performance with modifications in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.

Environment: MS SQL Server 2000, T-SQL, Windows 2000 server, Windows NT 4.0.

Hire Now