We provide IT Staff Augmentation Services!

Sql Ssis, Power Bi Developer Resume

2.00/5 (Submit Your Rating)

Dayton, OH

uhjhhjkkSUMMARY

  • Over 8 years of professional experience in working wif projects driven on SQL Microsoft Business Intelligence tools, Data Warehousing and ETL processes.
  • Expert in T - SQL (DDL, DML): functions, views, triggers, cursors, stored procedures on an SQL Server.
  • Strong experience in SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS), and POWER BI.
  • Experience in Coding, Modifying and Debugging new/ existing code.
  • Involved in generating Test Plans and Test Specifications as per Business requirements
  • Involved in conducting Manual and Automated testing at various phases of the project development.
  • Solid experience wif ETL processes, worked extensively on data extraction, data integration and loading from different data sources using SSIS.
  • Worked on all activities related to the development, implementation, administration and support of ETL process for large-scale Data ware houses using SSIS 2008/2012/2013/2014.
  • Designed, developed and implemented various SSIS Packages and deployed using Deployment Wizard.
  • Good hands on experience on performance tuning of SQL server for handling transactions at high volume.
  • Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
  • Hands on experience in generating on-demand and scheduled reports for business analysis or management decisions using SSRS.
  • Used Microsoft Power BI Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
  • Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
  • Worked on both live and import data to Power BI for creating reports.
  • Expertise in publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for live data in Power BI server.
  • Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
  • Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations.
  • Experience in Creating and managing relationships between tables in Power BI to calculate accurate results.
  • Excellent knowledge in Dimensional Data Modeling and analyzing the Data Warehouse by building multi-dimensional cubes using SQL Server Analysis Services (SSAS).
  • Good experience in writing MDX queries to access cubes data in SSAS.
  • Experience in optimization of cubes for better query performance.
  • Set-up Enterprise Gateway and SSAS Connector on Azure VM forPOWER BIReport Deployments.
  • Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked wif Data mining and slowly changing dimensions.
  • Experience wif logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
  • Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
  • Extracted data from various sources like SQL Server 2008/10/12/14, Oracle, CSV, Excel and Text file from Client servers and through FTP.
  • Working knowledge in Agile/Scrum environments.
  • Experience wif Software Development Life Cycle (SDLC), Agile, Scrum and Project Management Methodologies.
  • Hands on experience in using Version Control software like VSS, Rational Clear Case and (TFS) Team Foundation Server.
  • Very good hands on experience in TWS Scheduler tool for scheduling ETL jobs.
  • Flexible, enthusiastic and project oriented team player wif solid communication and leadership skills to develop creative solution for challenging client needs.
  • Migrate projects from Informatica to SSIS along wif Teradata to SQL
  • Good knowledge on continuous deployment tool like Octopus and Team city deploy.

TECHNICAL SKILLS

Data Warehousing/ BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS,POWER BI, DTS, BI Stack (Power pivot, Power query, Power map)

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, MOLAP, ROLAP, OLTP, Cubes

Reporting Tools: SQL Server Reporting Services, MS Excel, Power BI

Application Packages: MS-Front Page, Microsoft Office Suite, SSIS, SSAS, SSRS

Operating Systems: Windows 8 - 2003, XP, 2000, NT, ME, 98, Macintosh

Programming Languages: C, C++, Java, Java Script, ASP.Net, VB.Net

Other Software: Work Shelf, Adobe Software

PROFESSIONAL EXPERIENCE

Confidential

SQL SSIS, Power BI Developer

Responsibilities:

  • Developed Power BI model used for financial reporting of P & L and Headcount.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot and Power MAP.
  • Developed Monthly, Daily, Quarterly, Yearly Reports in Power BI.
  • Extensive Experience in Data Modeling using Power BI Relationship tab Designer.
  • Familiar wif all the types of cardinality relationships such as ONE-ONE, MANY-ONE, ONE MANY, MANY MANY.
  • Used Power Query, 'M' Language for data cleansing activities in power BI desktop editor.
  • Used some of the most important DAX Functions Such as, CALCULATE, CALCULATETABLE, FILTER, SUM, SUMX, DATEDIFF, COUNTX, RANKX, VARIABLES, USERELATIONSHIP, USERPRINCIPLENAME, FUNCTIONS, YTD, MTD, FISCAL YEAR.
  • Familiar wif Visualization such as Column chart, Clustered Column chart, Stacked charts, Scatter plots, Card, Slicers, Gauges, Funnel chart, Map, ArcGIS, Shape Map, Synoptic Maps
  • Utilized Power BI gateway to keep dashboards and reports up to-date wif on premise data sources. And formatted dashboards, multiple chart types, trends and KPIs wif Power View to support analysis.
  • Implemented Drilldowns, Drill throughs, Bookmarks in Power BI to make the dashboard effective and clear understanding
  • Installed and configured Enterprise gateway and Personal gateway in Power BI service for scheduling refresh jobs.
  • Created Workspace and content packs for business users to view the developed reports and maintained them.
  • Scheduled Automatic refresh and scheduling refresh in power BI service.
  • As a Power BI Admin Responsible for Maintaining, Monitoring Datasets, Performance tuning for reports/dashboards and control capacities in Power BI Service
  • Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques in Power BI Desktop
  • Weekly presentation to the business users about the reports and their changes as required.
  • Worked on all types of transformations dat are available in Power BI query editor.
  • Created stored procedures and SQL queries to pull data into power pivot model.
  • Participated in project planning sessions wif project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Established Power BI Premium and Embedding Environment and maintained its daily-to daily activities and troubleshooting it.
  • Scheduled Refresh Jobs wif the halp of Incremental Refresh concept in Power Bi Premium tier

Environment: Power BI, SQL Server 2012, SSMS,, T-SQL, Tableau, Power BI, Windows 7, MS Word, MS Excel, C#, Visio, Share Point Jira, SQL Profiler

Confidential, Dayton, OH

SQL/SSIS/ ETL Developer

Responsibilities:

  • Worked as a SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Gather business requirements from users and translated them as technical specs and design docs for development.
  • Actively involved in requirements gathering/analysis meetings wif Business and provide description about the analysis and approach.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables wif incremental load using Visual Studio.
  • Created and developed SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a particular time depending on requirements.
  • Extensively used SSIS to move data from text files to SQL Server.
  • Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot)
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
  • Hands on experience working wif SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
  • Created SSIS/DTS packages to copy tables, schemas, views to extract data from Excel.
  • Designed ETL packages dealing wif 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).
  • Create complex DTS Packages in SSIS for Data load from CSV/Excel Sheets wif more TEMPthan 200 columns and wif different file layouts to SQL Server database.
  • Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
  • Migrate projects from Informatica to SSIS along wif Teradata to SQL
  • Involved in SQL testing to meet business deadlines.
  • Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.
  • Good knowledge on continuous deployment tool like Octopus and Teamcity deploy.
  • Coordinated and attended every day standup’s/scrum/agile meetings and weekly sprint meetings to evaluate completed work.
  • Ensured HIPPA and regulatory compliance rules are addressed for all data movement
  • Good knowledge of HIPAA security and privacy guidelines
  • Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: MS SQL Server 2016, Excel, SQL, T-SQL, SSIS,SSRS, Microsoft Visual Studio 2014, Microsoft Visio, Teradeta,Informatica,TeamCity, Octopus, Agile/Scrum, TFS.

Confidential, Baltimore MD

SQL/SSIS/Power BI Developer

Responsibilities:

  • Designed and implemented the ETL processes using SSIS which involved collection of data from sources like SQL Server 2012/2014.
  • Developed and deployed SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files, Flat files.
  • Troubleshooting reports issues, ETL job failures, optimizing query performances.
  • Automated File Transfer Processes and mail notifications by using FTP Task and Send Mail task in packages.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
  • Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
  • Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Performed debugging, performance checks and performed index tuning and query optimization.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Coordinating wif business users in analyzing business requirements and translating them to technical specifications.
  • Creating and managing schema objects such as, Tables, Views, Indexes and referential integrity depending on user requirements.
  • Conducted Business Requirements, Functional and Technical meetings wif Business groups
  • Introduced Power BI in company by evaluating Power BI and Tableau as earlier Crystal Reports were used.
  • Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.
  • Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BIaccording to the requirements.
  • Used One Drive for storing different versions of Power BI report.
  • Published Power BI Reports in the required originations and Made Power BIDashboards available in Web clients and mobile apps.
  • Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
  • Built Ad-Hoc reports in Power BI depending on business requirements was one of the major responsibilities.
  • Create reports in Power BIpreview portal utilizing the SSAS TabularModel via Analysis connector.
  • Created many Complex Query’s and used them in Power BI Reports directly to generate reports on the fly.
  • Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
  • Created DAX and VB scripts for Excel reporting and calculated members.
  • Created jobs using TWS tools to run at regular intervals of time if the given condition is satisfied and then refreshes the database wif new data.
  • Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
  • Monitoring the TWS Scheduler on daily basis. Working on job and communicating wif IDS team and users.

Environment: MS SQL Server 2014/2016, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), DAX, POWER BI, Visual Studio 2014, Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel, Toad, TWS, Excess, Windows 8

Confidential, Baltimore MD

MSBI/Power BI Developer

Responsibilities:

  • Involved in creating database objects like Tables, Stored Procedures, Views, and user defined functions for this project.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Developed queries using joins, unions, sub-queries, date and time functions, co-relation sub-query etc.
  • Gatheird requirements from the end user and involved in developing logical model and implementing requirements in SQL Server 2014.
  • Primarily responsible for developing applications in SSIS as per Business Rules and features of the tool.
  • Used Control Flow Tasks like for Each Loop Container, Execute SQL Task, Bulk Insert Task, File System Task and Data Flow Task.
  • Assisted in creating SSIS packages using Microsoft SQL Server 2014 database sources, Oracle 11g database, Flat Files, Excel files and CSV files.
  • Deploying, Scheduling, Monitoring, Debugging, and Troubleshooting SSIS Packages.
  • Used Breakpoint and Data Viewer in SSIS packages to review the data status, while transferring data from source to destination files.
  • Developed Invoices Reports, Expenditure Trend Analysis Reports, and Asset Depreciation reports using SSRS for departments
  • Built, published and scheduled SSRS Reports for both Dev and PRODEnvironments.
  • Created Power BI Visualizations and Dashboards in order to display the customers’ information.
  • Built Ad-Hoc reports in Power BI depending on business requirements.
  • Created SQL datasets forPowerBIand Ad-hoc Reports.
  • Used One Drive for storing different versions of Power BI report.
  • Developed reports and configured/managed the report services environment using PowerBI.
  • Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on a daily basis.
  • Creating Multi-Dimensional cubes using SSAS and designing DW schemas.
  • Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
  • Developed tabular models for reporting, came up wif design based on requirements and volume of data, whether to develop SSAS OLAP cube or Tabular Model.
  • Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
  • Maintained and optimized the existing databases; monitored databaseperformance and growth,performance tuning, generated reports according to the business requirements using SQL Server.
  • Monitored performance and optimized SQL queries for maximum efficiency.
  • Created perspectives in SSAS and configured security levels for the Cubes.
  • Installed, configured and maintained SQL Server 2012/2008R2/2008.
  • Created hierarchies and aggregations using DAX.
  • Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
  • Responsible in developing the Star Schema in a Data Warehouse design.

Environment: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), T-SQL Server, DAX, Windows 7, MS Office, Toad, Excel, Agile, Power BI, Visual Studio 2012

Confidential, Irving TX

SQL/SSRS/SSAS Developer

Responsibilities:

  • Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views in SQL Server 2008 and 2012.
  • Designed and deployed reports wif Drill Down, Drill Through and Drop down menu option and Parameterized and Linked Reports.
  • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Developed critical SSRS reports using T-SQL stored procedures and complex SQL queries wif custom coding for dynamic parameter change and formatting.
  • Developed various trend reports using matrix reports and cascading prompts wif charts and graphs to analyze the earned revenue and accounts receivables over a period of times.
  • T-SQL stored procedures wif parameters and wifout parameters and complex SQL queries wif custom coding for dynamic tables.
  • Deployed and shared the reports wif rules and permissions defined on the report manager for data driven subscriptions.
  • Participated in the SCRUM meetings and provided the updates and successfully delivered the work in the Sprint.
  • Experience in designing and developing multiple analytical reports from multiple data sources by data blending on a single worksheet in Tableau Desktop.
  • Strong experience in creating and publishing packages in Framework Manager.
  • Developed complex SSAS cubes wif multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
  • Experience in creating multi-dimensional cubes using SSAS and designing DW Schemas.
  • Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2012.
  • Created Calculate Member in MOLAP cube using MDX in SSAS 2012.
  • Implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes wif SSAS 2012 and in adding calculations using MDX
  • Database backups and troubleshooting production databases and cube sync processing issues and SSAS issues.
  • Created Star Schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
  • Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.

Environment: Server Data Tools, T-SQL, SSRS, SSAS, Excel 2012, Power View, Agile, Power Pivot, Performance Point, MDX, Report Builder 3.0, Windows Server 2008,DAX,OLAP, Visual Studio 2012.

Confidential, Palo Alto CA

SSIS/SSRS Developer

Responsibilities:

  • Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool.
  • Developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data Warehouse.
  • Extensively used SSIS Import/Export Wizard for performing the ETL operations.
  • Complex business requirements were transformed into ETL using a variety of transformations like Aggregate, Derived Column, Data Conversion, Union All, Merge Join, and Lookup.
  • Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
  • Developed several reports wif consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
  • Developed Cross-Tabbed and Sub-Reports in SSRS 2008R2.
  • Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
  • Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Deployed the SSIS Packages to the MSDB as well as File System based on the requirements.
  • Designed ETL Packages wif Microsoft SSIS 2010 to pull data from various sources like DB2, SQL Server, Teradata, Flat Files and other systems to individual Data marts which ultimately go into Enterprise Data Warehouse (EDW).
  • Involved in the development of custom SQL, T-SQL, custom stored procedures, functions, and triggers.
  • Writing complexDAXfunctions in Power Pivot.
  • Created calculated columns using DAX to display in Dashboard.
  • Created hierarchies and aggregations using DAX.
  • Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages to run sequentially using SQL Server Agent job and windows Scheduler.
  • Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008R2.

Environment: SQL Server 2008R2/2010/2012 Enterprise Edition, .NET Framework, XML, T-SQL, SSIS, SSRS, DAX, VisualStudio.NET IDE, Agile, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access, Visual Studio 2010.

Confidential, Rochester NY

SQL Developer

Responsibilities:

  • Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
  • Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.
  • Used SQL profiler to view indexes performance to mostly eliminate table scan.
  • Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
  • Extensively used TSQL to manipulate and architect to produce results for users. Used multiple join statements to retrieve data from multiple tables.
  • Extract Transform and Load source data into respective target tables to build the required data marts.
  • Install and configure servers and clients using SQL Server 2005. Create and upgrade SQL databases.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
  • Experience in Creating stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
  • Worked on creating documents in Mongo database. Worked on multiple BSON type objects and used based on requirement.
  • Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization.
  • Creation, configuration and monitoring Shards sets. Analysis of the data to be shared, choosing a shard Key to distribute data evenly. Implemented scripts for mongo DB import, export, dump and restore.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
  • Created various DTS packages for data transfer and migration.

Environment: SQL Server 2005, T-SQL, Mongo Database.

We'd love your feedback!