We provide IT Staff Augmentation Services!

Sql/ssis/ssrs/ssas Developer Resume

NewyorK

SUMMARY:

  • 8+Years of Extensive Experience in Business Intelligence Applications Design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
  • Expert in working with the Business Intelligence Development Studio (BIDS), which includes SQL server Integrated Services (SSIS), SQL Server Analytical Services (SSAS) and SQL Server Reporting Services (SSRS).
  • Four years of IT experience as a BI developer working with Microsoft BI Tools Power BI, SSIS, SSRS, SSAS and T - SQL using SQL Server 2005/2008R2/2012 in Telecom, financial and nonprofit industry.
  • Experience in various states of System Development Life Cycle (SDLC).
  • Good experience in Agile Scrum Methodology and Waterfall Model Projects.
  • Experience in creating Power BI dashboards/reports using tabular models and good in managing Gateways and content packs.
  • Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
  • Explore data in a variety of ways and across multiple visualizations using Power BI.
  • Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
  • Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
  • Used DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.
  • Excellent experience in writing T-SQL Queries using various objects like views, tables, Joins, Sub Queries, triggers, stored procedures, and other advanced SQL concepts.
  • Expertise in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2014/2012/2008/2005.
  • Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, functions (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQL SERVER 2005/2008 R 2/2012/2014.
  • Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Expert in working with SSIS for creating packages to transform data from different OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle and Automate the ETL.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Experience in creating/deploying Data Transformation Services (DTS), Knowledge of Integration Services (SSIS) packages, Analysis Services (SSAS) and Reporting Services (SSRS).
  • Expertise in Extraction, Transformation and Loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Strong Experience in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, Joins, triggers, clustering, T-SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity.
  • 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.
  • Published Power BI reports from Power BI desktop to Power BI service.
  • Created different visualization in Power BI according to the requirements.
  • Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
  • Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and P ower Pivot.
  • Experienced in working on Agile environment by creating user stores, sprint planning, sprint meetings.
  • Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.

TECHNICAL SKILLS:

Data Warehousing & BI: SQL SERVER Business Intelligence Studio (SSIS, SSAS, SSRS, DTS), MS Access, Oracle, DB2, PostgreSQL

Reporting Tools: SSRS: 2016/2014/2008 R2/2005, Crystal Reports 13/11/08/XI, Excel, POWER BI Desktop, SAP Lumira, and Tableau.

Database: MS SQL SERVER 2016/2012/2014/2008 R2, Oracle 12c/11g/10g/9i, MS-Access.

Programming: JavaScript, Java, HTML, PHP, ASP.Net, VB6.0, C#.Net, VB.Net, PL/SQL.

Tools: Performance Point Server 2007(ProClarity), Enterprise Manager, SSMS, EMC Networker, Database Tuning Advisor, DTS, Analysis Manager, BCP, Visual Studio, QTP, Microsoft Office SharePoint Server 2010, MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, Adobe Photoshop, Adobe Flash, Adobe illustrator, Adobe Animator

Operating System: Windows Vista/NT/XP/ 2010/2008/2007 , Windows 2016/2012/2008 Server, UNIX.

Application Servers: Microsoft IIS 10/8.5/8, Apache.

PROFESSIONAL EXPERIENCE:

Confidential, Newyork

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

  • 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 SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL SERVER.
  • Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.
  • Designed ETL packages dealing with different data sources (SQL SERVER, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL SERVER Integration Services (SSIS).
  • Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in POWER BI.
  • Created Roles and implemented Row level security for user Authentication in POWER BI.
  • Developed and maintained multiple POWER BI dashboards/reports and content packs.
  • Installed On premise data gateway and scheduled daily data refresh in POWER BI.
  • Involved in designing, developing, and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
  • Defined report layouts and created Parameterized, Drill down, Drill through and Aggregation reports in MS SQL environment using SSRS.
  • Migrated existing self-service reports and Ad-hoc reports to POWER BI
  • Developed custom calculated measures using DAX in POWER BI to satisfy business needs
  • Used Team Foundation Server (TFS) for source control and sprint planning
  • Built Ad-Hoc reports in POWER BI depending on business requirements was one of the major responsibilities
  • Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries
  • Designed databases and relevant objects through preparation of tables, groups, and indexes.
  • Created Dimensions and cubes with star schema using SQL SERVER Analysis Services (SSAS).
  • Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.
  • Involved in Agile Sprint Methodologies to go through the requirement gathering, planning and analysis, and development and testing.
  • Design, deployment, and maintenance of various SSRS Reports in SQL SERVER.
  • 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.
  • Developed Snowflake schema using SSAS cubes.

Environment: MS SQL Server- 2016/2014/2008 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, TFS-Team Foundation Server Version Manager, Ceridian HR Tool, SQL Agent, Office-2013, MS Excel, SharePoint, Power BI, Power-Pivot, .Net (C#, VB), Service Now, Erwin r7.3, ER Studio

Confidential, Spring House, PA

Tableau Developer

Responsibilities:

  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
  • Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
  • Developed Tableau data visualization using Pareto's, Combo charts, Box and Whisker chartsGeographic Map, Cross tabs, Histograms etc.
  • Developed donut charts for analyzing sales planning data.
  • Created different KPI's using Table calculations and calculated key figures Manipulating's stringsarithmetic calculations, aggregation options and Logical functions.
  • Projected and forecasted future growth in terms of number of subscribers based on upgrading to
  • LTE by developing Area Maps to show details on which states were connected the most.
  • Created Bullet graphs to determine profit generation by using measures and dimensions data from
  • Oracle SQL Server and MS Excel.
  • Involved in extraction, transformation and loading of data directly from different source systems like flat files, Oracle, Teradata and SQL Server.
  • Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
  • Analysis of functional and non - functional categorized data elements for data profiling and mapping from source to target data environment.
  • Developed working documents to support findings and assign specific tasks.

Environment: Tableau Desktop 9.x, 10.x, Tableau Server, MS Office Suite, Oracle SQL Server R2Amazon Redshift, MS Excel.

Confidential, Findlay, OH

SSIS/SSRS/SSAS/POWER BI Developer

Responsibilities:

  • Created complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and T-SQL statements.
  • Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, Linked Servers.
  • Designed and implemented Stored Procedures and Triggers for automating tasks.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
  • Extracted data from various sources like SQL Server, Oracle, CSV, Excel and Text file from Client FTP servers.
  • Successfully migrated SSIS packages from development to test to Production environments using SSIS Configuration files and deployment wizard.
  • Used various SSIS transformations such as Conditional Split and Derived Column which were used for Data Scrubbing, data validation checks during Staging, before loading the data into Production tables.
  • Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Created Drilldown and Drill through reports, Summary Reports, and Sub-reports in SSRS.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS.
  • Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
  • Worked on modeling the data in Power BI involving creating measures, calculating columns, etc.
  • Used Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
  • Worked on importing and displaying Key Performance Indicators (KPIs).
  • Created and managed relationships between tables in Power BI in order to calculate accurate results.
  • Transformed and combined the data using Query Editor in the Power BI.
  • Created Power BI Visualizations and Dashboards as per the requirements.
  • Published Power BI Desktop reports created in Report view to the Power BI service.
  • Worked on Power View and Power Map to visualize reports.
  • Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on a timely basis.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures, and Refreshing Database on a weekly basis.

Environment: SQL Server 2012/2014, SSIS, SSRS, SSAS, Power BI, SharePoint, TFS, ASP.Net, Visual Studio 2013

Confidential, Vernon Hills, IL

SQL Developer

Responsibilities:

  • Interacted with end users to gather Requirements. Created technical, user documentation.
  • Studied and designed the system.
  • Install, Update, Configure and Maintain the MS SQL Server.
  • Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
  • T-SQL queries for the retrieval of the data.
  • Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
  • Tuning front-end applications like Visual Basic, which query the SQL Server databases.
  • Written Various ASP codes for user interactions.
  • Written Java Script for different validations
  • Used SQL Statements to Present Query responses.

Environment: SQL Server, T-SQL, UNIX, .NET, VB Script, JavaScript, ASP, Microsoft Excel, FrontPage 2005.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

  • Created a lot of complex stored procedures, triggers, functions, indexes, views with T-SQL statements in SQL Server Management Studio (SSMS).
  • Involved in designing and managing schema objects such as Tables, Views, Indexes, Stored Procedures, Triggers and maintained referential integrity using SQL Server Management Studio.
  • Processed ETL to transfer data from remote data centers to local data centers using SSIS. Cleansing, messaging of the data is done on the local database.
  • Designed an ETL strategy to transfer data from source to landing, staging, and destination in the data warehouse using SSIS and DTS (Data Transformation Service).
  • Developed SSIS packages to export data from Excel/Access to SQL Server, automated all the SSIS packages and monitored errors using SQL Server Agent Job.
  • Used reporting service (SSRS) created several reports based on cube and local data warehouse.
  • Prepared reports using SSRS (SQL Server Reporting Service) to declare discrepancies between user expectations and service efforts involved in scheduling the subscription reports via the subscription report wizard.
  • Interacted with subject matter experts in understanding the business logic, implemented complex business requirements in backend using efficient stored procedures and flexible function.

Environment: MS SQL Server Management Studio 2008 R2/2012 (SSMS), SQL Server Integration Service (SSIS), SQL Server Reporting Services (SSRS), MS Visual Studio 2012, SQL Server Profiler, SQL Server Import/Export Wizard, MS Office 2010.

Hire Now