We provide IT Staff Augmentation Services!

Sql Server/ssrs/ssis/ssas Developer Resume

Boise, IdahO

PROFESSIONAL SUMMARY:

  • Around 8 years of IT Experience in Database Design, BI - Development of Microsoft SQL Server 2012/2008/2005 on various development, test and production environments in various business domains.
  • Experience in writing T-SQL (DDL, DML and DCL) scripts in all MS SQL server environments.
  • Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes, Dynamic SQL, joins, Cursors, CTE and Constraints in T-SQL to facilitate data consistency in MS SQL Server 2012/2008/2005 .
  • Highly proficient in Tuning SQL queries and improving the query performance.
  • Experience in optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
  • Experience with file transfer protocols, including standard FTP and SFTP
  • Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
  • Created Configurations to make package portable and created Event handlers for handling package error.
  • Good experience in using Perl/Unix commands.
  • Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
  • Developed reports using global variables, expressions and functions.
  • Expert in Creating and managing roles for security in SSRS reports.
  • Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Experience in maintaining financial market domain.
  • Ability to define and develop Report Structure with data definition, report layout and report definition language.
  • Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and creating report layouts using SSRS 2012/2008.
  • Hands on experience in performance point.
  • Good Experience in using power builder which automatically generates SQL statements and also includes native database drivers for Oracle, Microsoft, Sybase and in power scripting language.
  • Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports, Conditional, List items, Charts, Sub reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Created various Complex Formula Reports to query the database for business Intelligence.
  • Experience in deploying created reports in various sources like Web browser, XML and PDF.
  • Deployed SQL Server Reports on to the report manager and delivering using ‘pulled’ and ‘pushed’ methodologies.
  • Expertise with parameterized reports and Cascade Parameterized Reports in SSRS 2005/2008/2012.
  • Experience in creating data driven subscriptions in Report Manager.
  • Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI’s and Filters.
  • Created various Performance Point filters like List, Tree and Multi-Select Tree using different filter Templates like Named Set, MDX Query and Custom Table.
  • Configured the Dashboard zones and connected different dashboard components to achieve Cascading Parameters and Parameter driven reports in Performance Point.
  • Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
  • Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions & MDX Queries using SQL Server 2012/2008 Analysis Services.
  • Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
  • Experience in SQL Queries and Macros.
  • Good experience in using Performance Point Server.
  • Good at PL/SQL in Oracle Database.
  • Has good knowledge in Health Care responsible programming
  • Has good hands-on experience in using ODBC(Open Database Connectivity).
  • Experience using different Version Control Tools like Microsoft Source Safe and TFS.
  • Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
  • Has good experience in Full Stack, SharePoint BI and PowerView. has good knowledge and hands on experience on QNXT database skills.
  • Has good programming experience in Visual Basic and Valid data entry.

TECHNICAL SKILLS:

Operating Systems: UNIX, W indow s NT/XP /Vi sta/7/2008, Mac, Linux, Windows server 2003

Programming: L anguages: C, Jav a, C#, T-SQL, XHTML, PHP, Java Script

Databas: e: MS Ac cess, MS SQL, SQL Se rver 2012,2008R 2/2008/ 2005/2000

I nternet Te: c hnologies: ASP.NET, Java Sc ript, VBSc ript, XML, C SS, HTML

Tool: s: MS Office, Visua lStudi o2010/, DTS, SSAS, SSIS, SSRS, VSTF.

PROFESSIONAL EXPERIENCE:

Confidential, Boise, Idaho

SQL Server/SSRS/SSIS/SSAS Developer

Responsibilities:

  • Responsible for creating SSIS packages to extract data from different sources to consolidate and merge into one single source.
  • Configured SSIS Packages using Environment Variables for Dynamic selection of Development and Production Environment.
  • Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
  • Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-threading Concepts with Synchronous and Asynchronous transactions.
  • Created SSIS and SSRS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
  • Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Design, deployment, and maintenance of various SSRS Reports in SQL Server 2012.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.
  • Created different types of SSRS reports like linked reports, tabular reports, charts, sub-reports, drill-down and various parameter based reports like drop down, Multi-Valued, Multi-select.
  • Developed custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
  • Created Ad-hoc reports Using Report Builder, Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created Dashboards using Performance Point Dashboard designer, added different dashboard items like Scorecards, KPI’s and Filters.
  • Deployed SSRS reports to SharePoint Integrated Server mode and later used these reports on different Dashboard tabs.
  • Created various Performance Point filters like List, Tree and Multi-Select Tree using different filter Templates Named Set, MDX Query and Custom Table.
  • Configured the Dashboard zones and connected different dashboard components to achieve Cascading Parameters and Parameter driven reports.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager.
  • Created subscriptions to provide a Daily/Monthly/Quarterly basis reports.
  • Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
  • Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
  • Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2012. Developed reports from OLAP cubes.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
  • Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
  • Created usage based aggregations in cube to minimize time for query retrieval from client tool.
  • Managed and troubleshoot report server related issues.
  • Involved in Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
  • Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.
  • Created logging, custom logging and error handling packages.

Environment: MS SQL Server 2012. Windows Server 2003/2008 and VM ware. ERWIN, SSRS, SSIS, SSAS, Litespeed, VERITAS netbakups, MS Excel Power Pivot, Windows7 and Windows 8, Performance Point Dashboard Designer, MS SharePoint Server 2010

Confidential, Hauppauge, NY

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

  • Designed and implemented stored procedures and triggers for automating tasks.
  • Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
  • Loading data from various sources like, flat files, to SQL Server database Using SSIS Package
  • Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs
  • Involved in writing MDX Scripts for the OLAP CUBES.
  • Developed multidimensional Objects (Cubes, Dimensions) using MS Analysis
  • Created Analytical Reports using Proclarity tool.
  • Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema
  • Using Sql server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
  • Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
  • Deployed SSRS Reports in SharePoint for web based access for multiple end users
  • Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
  • Created reports using stored procedure and also involved in scheduling, creating snapshots and subscriptions for the reports SSRS.
  • Involved in improving the performance of the system.
  • Developed and executed several optimized queries in SQL.
  • Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
  • Deployed SSRS Reports in SharePoint for web based access for multiple end users.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Oracle 9i/10g, Microsoft Office Share Point Server, XML, TFS 2010

Confidential, Herndon, VA

Sr. SSRS Developer

Responsibilities:

  • Interacted with Business team to collect data for the conceptual design of the system.
  • Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
  • Migrated crystal reports to SQL Server Reporting Services (SSRS).
  • Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
  • Created and developed the stored procedures, triggers, views and user-defined functions to support application development using T-SQL.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Deployed and configured the reports in the Report Server.
  • Worked closely with IT project managers, programmers, and testers.
  • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
  • Optimized Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
  • Responsible for Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production.
  • Trained end users with step-by-step instructions to access the pre-build or published reports.
  • Designed and developed various complex reports and different types of charts.
  • Generated reports that can handle dynamic grouping and dynamic sorting.
  • Created drill down, drill through, sub reports and many more complex reports.
  • Created interactive data exploration, visualization and presentation using power view.
  • Used power pivot to import data from sources such as SQL Server, XML, Microsoft Access and even web based data.

Environment: Windows XP, MS SQL Server 2008R2, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential, Los Angles, CA

SQL Server SSIS/SSRS Developer

Responsibilities:

  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
  • Developed ETL jobs to load information into Data Warehouse from different relational databases and flat files.
  • Created Stored Procedures and T-SQL code for complex business logic.
  • Developed some scripts in C#.Net used in ETL Process that works as transformation.
  • Configure SSIS Package for run time Parameters and Configuration file.
  • Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Developed an automated report subscription process using SSRS.
  • Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
  • Created SSIS Packages for Incremental Loading and slowly changing dimensions.
  • Implemented Type 2 Slowly Changing Dimension to maintain Dimension History.
  • Created parameterized reports for the brokers and clients.
  • Formatted the report layout for the requirement of the end users.
  • Deployment of the developed reports on to the server for the end users.
  • Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
  • Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
  • Supported 24/7 for the production system for post deployment Reports on the server.
  • Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
  • Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
  • Designed and implemented data access stored procedures and triggers for automating tasks.
  • Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
  • Calculated members, named sets, and execute other script commands to extend the capabilities of a MS SQL Server 2005 Analysis Services (SSAS) cube.

Environment: MS SQL Server 2008R2/2008/2005, SQL Server Reporting Services (SSRS 2008R2/2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, C#, ASP.Net, Informatica, MDX, Shell Scripting, DTS, MS Visio, UDB, Erwin.

Confidential, Chantilly, VA

SSRS and SQL Developer

Responsibilities:

  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Generated database monitering and data validation reports in Proclarity and SQL Server Reporting Service (SSRS ).
  • Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS) .
  • Deployed SSIS packages and Reports to Production Servers.
  • Upgraded databases from SQL Server 2000 to SQL Server 2005.
  • Responsible for the design and development of .Net web applications for firm's Solutions.
  • Migrated data using ETL Tool in SSIS.
  • Maintained system monitoring jobs and provide high availability support.
  • Created partition table for very large database for good performance.
  • Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).
  • Participated Databases Architecture and data Modoling design.
  • Performing DBA functions, installing, configuring and supporting database systems.
  • Reported all events and requirements through established reporting mechanisms in SSRS.
  • Fully supported change management procedures.
  • Reviewed and developed data models and database designs with development teams
  • Wrote store procedures for some job automations.
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
  • Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
  • Designed and developed OLAP using MS SQL Server Analysis Services
  • Designed and developed MS SQL Server Reporting Services(SSRS) under SQL Server 2000 and SQL Server 2005
  • In charge of converting data using SQL Server 2005 using SSIS

Environment: MS SQL Server 2005 and 2000, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS, Proclarity, MS SQL Server Analysis Services 2000, C#, ASP.NET,VB.NET, OLAP, UML, Erwin, DTS/SSIS,BIDS.

Hire Now