We provide IT Staff Augmentation Services!

Msbi/ssis/ssrs Developer Resume

Boston, MA

SUMMARY

  • Around 9 years of extensive experience in Database Design, Development and Administration of applications with MS SQL Server versions 2016/2014/2012/2008 R 2/2008/2005/2000 using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries.
  • Experience with Fragmentation and Query analyzer for SQL Server 2005/ 2008/2 and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing, and Performance Tuning.
  • Experience in writing dimensions using DAX language and KPI's based on the user requirement.
  • Experience in developing different types of reports using Tableau and Power BI
  • Technically and logically, I am aware of T - SQL Programming, SSIS, SSRS, SSAS, Data warehousing, Business Intelligence etc.
  • Deft in database designing skills and experience in installing, configuring, managing, upgrading, and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2016/2014/2012/ 2008 R2/2005. Experience in writing T-SQL (DDL and DML) scripts in all MS SQL server environments.
  • Expertise in Migrating Reports from SSRS to Power BI.
  • Developed Dashboard Reports using Performance Point Server on SharePoint, SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
  • 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.
  • Professional in creating and understanding Schemas Such as Star Schema, Snowflake Schema, Galaxy Schema.
  • Knowledge in all types of Database migrations with all the versions of SQL Server.
  • Expertise in designingSSISpackages to import and transform data between databases and external data sources using various transformations.
  • Developed OLTP system (s) and involved in creating facts, dimensions, and Star Schema representation for the data mart.
  • Handles multiple assignments simultaneously and successfully identify and coordinate key deliverables with stakeholders in cross-functional groups. Passions include ensuring data quality, scalability, performance, integrity, and security as well as standards development and process improvement.
  • Expertise in Creating, Deploying, and managing Reports through MS SQL Server Reporting Services (SSRS) and Crystal Reports.
  • Expert in database creation, maintenance, monitoring, backups, and recoveries using SQL Server Agent, Import/Export Wizard and Maintenance Plans.
  • Good in code migration, database change management and data management through the various stages of the development life cycle.
  • Experience in SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages, configuring Checkpoints, troubleshooting, debugging the data flow by using Data viewers, awareness on Transactions concepts to roll back the data of SSIS packages in case of failure.
  • Experience in developing Oracle scripts, Functions and Packages using Oracle SQL developer.
  • Implementing Logging features to the existing packages to track the record counts, package status by storing it in logging DB tables with their associated column values.
  • Familiar with Complex Reporting Requirements like Dashboard, Matrix, Cascading Summary, Sub reports and pass-through parameters from main report to the sub reports.
  • Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.

TECHNICAL SKILLS

DATABASES: MSSQL Server 2000/ 2005/ 2008/2 /2019 , Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007 , MYSQL.

PROGRAMMING: T-SQL, PL/SQL, C, HTML, C# .NET, VB.NET, ADO.NET

WEB TECHNOLOGIES: Active X, Internet Information Services (IIS).

ETL TOOLS: DTS, SQL Server Integration Services (SSIS).

OLAP TOOLS: SQL Server Analysis Services (SSAS).

REPORTINGTOOLS: SQL, SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS), Microsoft Power BI (Power Pivot, Power View, Power Query, Power Map), SQL Server Analytical Services (SSAS), Visual Studio, BIDS.

VERSION CONTROL: Team foundation Server (TFS), Visual Source Safe (VSS), SVN

OPERATING SYSTEMS: Windows XP/2007/2010

DATAMODELLING TOOLS: Erwin 4.x/7.x, MS Visio 2000/2003

AGILE TOOLS: Jama 4.0 and JIRA

SQL SERVER TOOLS: SSMS, Enterprise Manager, SSDT, Query Analyzer, Profiler, Performance Monitor

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

MSBI/SSIS/SSRS Developer

Responsibilities:

  • Assist data modelers in designing of dimensional model for Star schema.
  • Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
  • Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power Pivot, Power Query and Power BI.
  • Involved in database Schema design and development.
  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
  • Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS.
  • Created several SSIS packages for performing ETL (Extract, Transform and Load) operations from OLTP to OLTP and OLAP systems.
  • Involved in creating measure groups using different fact tables and created calculated members, Advanced KPI’sand named set inSSAS.
  • Developed the SQL Server Integration Services (SSIS) packages to transform data as well as created interface stored procedures used in SSIS to load/transform data to the database.
  • Migrating Oracle database source based SSRS reports to SQL source-based by changing the Oracle source code to SQL code compatible.
  • Used Phabricator tool to verify the changes between existing script which is in source control to the script which I developed.
  • Used JIRA project management system to track the enhancements and developments on a daily basis.
  • Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Strong experience in creating and publishing packages in Framework Manager.
  • Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.

Environment: Microsoft SQL Server 2005/ 2008/2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Power BI Desktop, SharePoint, Visual Studio 2015, SQL Server Analysis Services (SSAS), JIRA,T-SQL, SQL Profiler, XML, Team Foundation Server (TFS) 2012, MS Excel, Excess, Windows 8.

Confidential, Chicago, IL

Sr. MSBI/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
  • Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
  • Used Power BI Power Pivot to develop data analysis prototype, for advanced visualize reports.
  • Developed packages in SSIS with error handling.
  • Created DAX calculated columns in power pivot worksheets to extract, import and join data that coming from different sources.
  • Implemented Performance Tuning and Query Optimization.
  • Created Package Configurations to deploy packages from development to production server.
  • Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in SQL Reporting Services (SSRS)
  • UsingSQL Server Reporting Services (SSRS) generated periodic reports based on the statistical analysis of the data.
  • Created ETL process using SSIS to transfer data from heterogeneous data sources by extensively using PIVOT to Normalize the data also combining data from different sources using UNION ALL.
  • Worked with Marketing department to improve the external and internal website and posting latest updates.
  • Developing SSIS packages that upload multiple flat files using For Each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task.
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries also trimming lengthy queries by replacing sub queries with JOINS to enhance the performance of Databases.
  • Created and managed Database(s) on SQL AZURE. Setting up Connection Strings and connecting SQL Server Azure Databases from locally Installed SQL Server Management Studio.
  • Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Environment: SQL Server 2008/2012/2014 , Visual Studio2017, 2015,2013, Framework 4.5, C#.Net, XML, Entity Framework, Microsoft Office, Excel, Word, Windows server 2010,Business intelligence development studio, Tableau 10.4,SQL profiler, MS Visio, T-SQL, DTS, Data Analyzer.

Confidential, Los Angeles CA

MSBI/SSIS/SSRS Developer

Responsibilities:

  • Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and
  • Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Taking Database Full Backup, Transaction log backup &differential backup in daily routine.
  • Traced long running queries and deadlocks using SQL Profiler.
  • Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
  • Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
  • Worked on Power BI and prepared dashboards to make it more attractive and explored data in a variety of ways and across multiple visualizations using Power BI.
  • Involved in Installation, Configuration, and Deployment of Reports using SSRS.
  • Scheduled the reports to run on daily, weekly basis in the report manager.
  • Created SQL server jobs to execute SSIS packages according to the load type of the data.
  • Involved in writing stored procedures to create table structures in stage and pulling data from metadata.
  • Involved in creating marts and developing mart views used for the report building.
  • Created SSIS packages templates to clean and load data to parallel data warehouse, including error handling and metadata management.
  • Designed and deployed reports with Drill Down, Drill Through, Matrix Reports, Chart Reports and Drop down menu option and Parameterized and Linked reports.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
  • Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
  • Configured Server for sending mails when a SSIS process fails.
  • Used the SSIS Configuration files to make the packages connections, variables etc. configurable and maintained the same on Test and Production environments.
  • Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc
  • Experience in using SSRS gateway service calls to and from SSRS reports.
  • Created multiple Data Driven Subscriptions that delivers Power BI reports as excel and PDF output on network file system
  • Created multiple Email Data Driven Subscriptions that sends email to top-level executives consisting of different reports that helped in taking financial decision and future business strategies
  • Discovered and corrected critical bugs in the data migration process that led to in-correct data being reported to clients and government reporting
  • Generated daily, weekly and monthly reports for the managers
  • Developed Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse

Environment: MS SQL Server 2005/2008/2008 R2/2012, Business Intelligence Development studio (SSRS/ SSAS/SSIS), Oracle 11g/10g/9i, MS Office Access 2003 and Visual Studio 2008, .Net 3.5, Team Foundation Server 2010, Agile Methodology (Spring, SCRUM), T-SQL

Confidential, Boston, MA

SQL Server Developer

Responsibilities:

  • Designed various kinds of reports like Linked, cascaded, and parameterized reports and Worked on Drill Down and Drill-through Reports using SSRS.
  • Worked with Product Development Team to architect Database Design and strategy.
  • Worked with Business Users to architect Data Warehouse strategy based on reporting, analytical and dishoarding requirements.
  • Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL and SQL Analyzer.
  • Created, insert, update, and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
  • Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Defined the scope and business rules of the project, gathered business requirements, and documented them textually and used UML models.
  • Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Designed databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
  • Used Query Analyzer to optimize SQL Queries.
  • Worked on importing /transferring the data to database tables using DTS, Import and Export Utility.
  • Created automated regular jobs Daily/weekly Report Generations.
  • Monitored Performance and optimized SQL queries for maximum efficiency.
  • Generated reports using Crystal Reports to analyze data for Customer Churn.
  • Generated reports from the cubes by connecting to Analysis server from SSRS.
  • Prepared test plans based on User Requirements Document (URD).
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

Environment: MS SQL Server 2012/2008, SSIS, T-SQL, C#, Visual Basic 6.0, Data Analyzer, Visual Studio 2010, VB Script, MS Access, Excel, SQL Profiler, Windows 2007.

Confidential

SQL Developer

Responsibilities:

  • Gathered requirements and created requirement specification documents for all reports.
  • Developed documentation to reflect current design ETL processes.
  • Worked closely with Business Users in identifying the gaps between existing code and the business requirements in the ETL projects.
  • Database Design, Optimization of queries and Database, Performance Tuning using Index Wizard, SQL Profiler and Query Analyzer. Installed SQL Server Desktop Database and Standard Database.
  • Created Stored Procedures, User Defined Functions, and Triggers to work consistently with the dynamic databases.
  • Investigating and fixing the root cause of the problems that are encountered on in production environments on day-to-day basis.
  • Wrote and maintained database documentation, including data standards, procedures, definitions for data dictionary and logical and physical models of the database.
  • Involved in SQL Tuning by creation of Indexes, Rebuilding Indexes, and Clusters
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
  • Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
  • Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
  • Created Linked Servers and send data across multiple Servers.
  • Created Functions and Stored Procedures and Views.
  • Provided 24/7 production support for the production database and also to the code deployed into the production environment.
  • Involved in analyzing business requirements and design documents.
  • Involved in interacting with businesspeople on daily basis for better understanding and implementation.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS)

Hire Now