We provide IT Staff Augmentation Services!

Sql Server Ssis/ssrs/power Bi Developer Resume

Ashburn, VA

PROFESSIONAL SUMMARY:

  • Over 8 years of IT experience in Designing, Developing and Implementation of Integration, Analysis and Reporting projects using SQL Server, SSIS, SSAS, SSRS.
  • Strong Analytical and problem - solving skills coupled with excellent written, verbal and inter-personnel communication skills.
  • Involved in all phases of Software Development Life Cycle using Agile Methodology.
  • Expertise in using Microsoft BI suite: SQL Server Integration Services (SSIS), SQL Server Analysis Service (SSAS), SQL Server Reporting service (SSRS).
  • Good Programming knowledge on SQL, Confidential -SQL, .Net, Java, COBOL.
  • Worked extensively on Windows & Web-based applications using Microsoft Technologies ASP.NET with C#, VB.NET, SQL Server, Oracle JDE.
  • Good working knowledge on Cloud Technologies Azure, AWS.
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), Bulk Copy Program (BCP) and Bulk Insert.
  • Good knowledge on Relational Database Management System (RDBMS), OLTP and OLAP concepts, Data Migration, Data Analysis and TFS.
  • Expert in developing Confidential -SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
  • Hands on implementing ETL process using SQL Server Integration Services (SSIS).
  • Expert in creating Stored Procedures, Functions, Tables, Views, Scripts, Indexes, Triggers, SQL Jobs and Transaction Analysis.
  • Excellent in High Level Design of ETL DTS Packages& 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 working with SSAS in creating Data cubes, data source views, named queries, dimensions and deploying of analysis services projects.
  • Designed and developed ETL packages (SSIS) with variables, parameters, and expressions and scheduling SSIS packages in SQL agent to load data to  data warehouse or OLTP database using error handling, logging and deploying methodologies.
  • Experience in checking data quality using SQL/Integration Services, identifying errors and error patterns, and suggesting some data cleansing mechanisms.
  • Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
  • Experience in working on administration tasks such as data loading, batch jobs, data unloading, user and application table management, upgrades, creating databases/ file groups/ files/ transaction logs.
  • Experience in debug, maintenance of ETL packages and ETL optimization using SQL Server best practices.
  • Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
  • Expertise in generating reports using SQL Server Reporting Services (SSRS), POWER BI, Tableau, Business Objects, EXCEL services.
  • Good knowledge on SSRS architecture and Hands on experience in developing deploying and managing Parameterized reports and Linked reports, Sub reports, drilldown reports, drill through reports, ad-hoc reports and Crystal Reports with thorough knowledge of report service architecture. (Table, chart and matrix report) using SSRS.
  • Strong Knowledge in using Reporting service to deliver output according to client requirements, Dashboards, scorecards, Graphical Reports.
  • Experience in creation of Tabular model in SSAS for creating Power pivots, Power View reports.

TECHNICAL SKILLS:

BI Tools: SQL Server Management Studio, SQL Server Reporting Services (SSRS),SQL Server Integration Service(SSIS), SQL Server Analytical Services (SSAS), Business Intelligent Development Studio, Informatica.

Databases: SQL Server 2008/2008R2/2012,2014,2016, Oracle 11g, 10g

Designing Tools: Erwin, Visio

Reporting Tools: Excel, SQL Server Reporting Services, Power BI, Tableau, SAS, Business Objects.

Languages: C, Java, SQL, Confidential -SQL, PL/SQL, C#, .Net, SAS, PowerShell, COBOL

Web Technologies: HTML, XML, ASP.NET CSS, Visual Studio.

Operating Systems: Windows XP/7/8/10, Linux, Unix.

Software: Virtual Box, Putty, MS Office MS Excel, MS-Project

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

SQL Server SSIS/SSRS/Power BI Developer

Responsibilities:
  • Work with users, product management and business analysts to understand client requirements and help reach data deliverables.
  • Design, develop and deploy Business Intelligence solutions using SSIS, SSAS and SSRS.
  • Involved in migrating the present SSIS packages in 2014 to SQL Server 2016 environment.
  • Work on the file import framework process for the various flat files structures to get data imported into our database.
  • Create databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Work on data issues, performance and production problems to find root cause to maintain data and databases correctly.
  • Making use of Joins, Procedures, cursors, triggers and extracting data from different tables or Reporting. Works on setting up folders and environments for Package creation.
  • Created Application forms (Views) and other UI components using ASP.NET MVC Razor Engine.
  • Designed and developed the user interface for various tools and implemented ASP.NET /VB.NET validation controls, JavaScript, jQuery, CSS for server and client side validations respectively.
  • Created the applications by using vb.net and made enhancements of the projects for the .net applications.
  • Created ETL Projects using SSIS 2012 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.
  • Create SSIS package to pull data from different sources consolidate and merge into one single source.
  • Create   SSIS   Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition 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.
  • Developing and deploying packages by creating new packages or modifying and using existing packages.
  • Developed SSIS packages that fetches files from FTP, did transformation on those data base on business need before I loaded to destination.
  • Expertise in creating Metadata tables to log the activity of the packages, errors and change of the variable. Various techniques such as CDC, SCD and Hash bytes were used to capture the change of the data and execute incremental loading of the dimension tables.
  • Works on protecting data by encrypting the sensitive data using passwords.
  • Schedule jobs accordingly and implement logging functionality in order to get the execution time and start time and end time of the packages.
  • Used Merge in development, test and production for changing the referenced data.
  • Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
  • Create Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
  • Use data compression techniques to Back Up data in different servers.
  • Performed Confidential -SQL tuning, Performance Tuning, optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard & SQL Query.
  • Develop complex stored procedures using Confidential -SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS). 
  • Converted crystal reports to SQL Server reports using Reporting Services.
  • Develop complex Stored Procedures and views to generate various Drill-through, Drill Down reports, parameterized reports and linked reports using SSRS.
  • Explore data in a Variety of ways and across multiple visualizations using Power BI. 
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Expert on creating multiple kinds of Power BI Reports and Dashboards. 
  • Created, Maintained & scheduled various reports in Power BI like Tabular Reports. 
  • Experienced in creating multiple kinds of reports in Power BI and present it using Story Points.
  • Experience in writing reports based on the statistical analysis of the data from various time frame and division using PowerPivot, Power Query, Power View, Power BI.
  • Created visualization reports and dashboards using Power BI desktop and published them to the Power BI Service. 

Environment: SQL Server 2016/2014/2012 , Visual Studio 2012/2013, Oracle 11g, 10g, ASP.NET, C#.net, SSIS, SSAS, Confidential -SQL, SSRS, Power BI, Tableau.

Confidential, Bothell, WA

SQL Server/SSRS Developer

Responsibilities:
  • Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2012 databases servers.
  • Worked with business/functional analysts to determine reports and analytical requirements. 
  • Planning, coordinating and implementing security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
  • Documented Report Models and Report Templates for other Team Members. 
  • Involve with BI Support Team and QA Team in the development, testing and support of BI Solutions.
  • Design and develop SSIS packages, configuration files, stored procedures, tables, views and functions.
  • Responsible for development and maintenance of Web applications, get data and reports using ASP.NET, C#, SQL Server.
  • Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.
  • Created login-based members area that displays ASP.NET MVC web pages based on access levels and assigned Roles.
  • Working with SSIS for creating ETL jobs in migration of data from one database to other.
  • Develop complex queries, stored procedures, views, and constraints, triggers using inner and outer joins, unions, and SQL Statements for various applications in different environments. 
  • Design new reports considering accuracy, performance, maintainability, and clarity of presentation.
  • Switch from task to another based on higher-priority and work with required teams and complete the task immediately based on business requirement.
  • Create graphical outputs using SSRS according to the requirement.
  • Exporting output file from one environment to another environment.
  • Creating Dashboards, Scorecards, pie charts and bar graphs.

Environment: MS-SQL Server 2008R2 Enterprise Manager, MS Business intelligence SSIS, SSRS,SSAS, Power BI, SharePoint Server 2010, XML, MS Excel,ASP.NET, VB.Net, C#.Net, Visual Studio 2012.

Confidential, Boston, MA

SQL Server/SSIS/SSRS Developer

Responsibilities:
  • Participated in Project development life cycle SDLC.
  • Working closely with clients and gathering requirements.
  • Migration of Data from other environments into SQL environments using SSIS Packages.
  • Using SSIS Packages for day to day tasks like Sorting, Aggregative functions.
  • Writing Confidential -SQL Queries, creating Stored Procedures, Triggers, Sub-Query’s.
  • Create Data Cubes using SSAS and running reports from cubes using SSRS.
  • Develop dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Generate reports on all types like tables, matrix, charts, sub reports etc.
  • Export reports from SQL Environment to other destinations.
  • Involved in Debugging and Deploying reports on the production and UAT servers by modifying the RDL files using XML.
  • Made full use of .NET’s object oriented features(C#), event handling, error handling, caching and security feature.
  • Developed Web Services which can be used by several clients in getting useful data.
  • Developed complex Stored Procedures and Views to generate various reports using Excel Macro’s and SSRS.
  • Making use of SSRS service deriving Drill-Down, Drill-through reports.
  • Responsible for Scheduling reports to run daily, weekly and monthly basis using Report Manager.
  • Responsible for implementing Unit testing and performance tuning for process improvement purposes.
  • Using C#, VB, .NET in the process of reporting.

Environment: MS-SQL Server 2008R2 Enterprise Manager, MS Business intelligence SSIS, SSRS,SSAS, SharePoint Server 2010, XML, MS Excel, VB.Net, C#.Net, Visual Studio 2010.

Confidential

SQL Server Developer, SAS Programmer

Responsibilities:
  • Involve in Planning, Defining and Designing data based on business requirements and provided documentation.
  • Involve in each and every aspect of Project Development.
  • Maintaining good communication with clients and gathering requirements from them.
  • Performing tasks according to business people requirements.
  • Create Entity relationship (ER) diagrams for the proposed database.
  • Create Databases, tables, views using SQL, PL/SQL and Confidential -SQL.
  • Extract Data from different sources to different environments.
  • Work on SQL Server Management studio and Visual Studio for day to day activities.
  • Create Tables, views, Indexes, triggers for proposed system.
  • Create Data sets using SAS for further processing like Structuring Data, Reporting purpose.
  • Perform Operations using SAS Stat for Analytics purpose.
  • Extensively used transformations, control flow tasks, data flow tasks, containers and event handlers.
  • Defining Normalization forms and implementing them while table creation.
  • Using SSIS packages for integration of data from different source to SQL Server environment.
  • Generated reports for internal company purpose for Managers and team.
  • Work on SAS procedures for reporting, SAS Macro’s, SAS Graphs, SAS Stats.
  • Develop dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • According to requirement work on both SAS and SSRS for Reporting.

Environment: MS-SQL Server 2008R2 Enterprise Manager, MS Business intelligence SSIS, SSRS,SSAS, SharePoint Server 2010, XML, MS Excel, VB.Net, C#.Net, Visual Studio 2010.

Hire Now