We provide IT Staff Augmentation Services!

Etl Developer/power Bi Developer Resume

DallaS

PROFESSIONAL SUMMARY:

  • 7 Years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
  • Strong technical knowledge in MS SQL Server development including SSIS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), SQL Server Integration Services (SSIS) (2008/2008R 2/2012/2014/2017 ).
  • Developing reports on SSAS & SSRS on SQL Server (2008/2012/2014/2017 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • SQL Server Integration Services (Package creation, Check Points implementation, Dynamic Configuring of package, Logging, Custom script writing, Package deployment using Manifest, Implementing Transactions, Package encryption.
  • Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (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.
  • SQL Server Reporting Services (Generating reports in the form of Tabular, Matrix, Chart and List Data Region from OLTP and OLAP Data bases, grouping and sorting, formatting, parameters including Cascading, Drilldown, Dash Boards, Sub and Linked Reports and Ad-hoc Reports).
  • SQL Server Analysis Services (Cube Creation, Knowledge on OLAP and designing Cubes, Populating data, Knowledge on writing MDX Queries.)
  • Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN.
  • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
  • Experienced in SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Enterprise Manager, and SQL Query Analyzer
  • Strong analytical problem-solving skills, self-starter with excellent inter-personal skills.
  • Familiarity with issue tracking systems (Bugzilla, QC, TFS, JIRA)
  • Add XML configuration files to each package to deal with different servers like Development, Testing and Production.
  • Multi-tasking and ability to work effectively under pressure meeting deadlines as an individual contributor and a committed team player.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Expert in creating and developing Power BI Dashboards in to rich look.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot.
  • Used various sources to pull data into Power BI such as Sql Server, Oracle, SQL Azure etc.
  • Developed Power BI reports and dashboards from multiple data sources using data blending.
  • Designed Power BI data visualization utilizing cross tabs, maps, scatter plots,pie,bar and density charts.
  • Involved in DBA activities such as backups, restores, replication etc.
  • Knowledge of Agile and Scrum methodologies.

TECHNICAL SKILLS:

Operating Systems: Windows 7/8/10,Vista,XP, Windows Server 2003/2008

Programming Languages: ASP.NET, C#.NET, VB.NET, C#.NET, C, C++

Database: SQL Server 2008/2008R 2/2012/2014/2017, Oracle, PL-SQL

Tools: SQL Server Management Studio,Redgate sql tool beltBusiness Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, SQL Server Agent, Visio, TFS, JIRA, Informatica,Mongo DB, Tableau, Power BI,VSTS,Azure Cloud.Hornbill,Pilot fish.

Web designing tools: HTML, XML,JAVA SCRIPT, Visual Studio, Share Point

Network Topologies: TCP/IP, DNS, FTP, SMTP

PROFESSIONAL EXPERIENCE:

Confidential, Dallas

ETL Developer/Power BI developer

Responsibilities:

  • We are using Pilot fish to convert the 834,835 and 837 files into XML Standards.
  • The EDI process begins when HCH receives Claims, Eligibility files client through the SFTP Server. After the file name has been assign, files are enriched, validated, compared and then converted in to XML, Then it Load the Raw data in to sql tables.
  • Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc.
  • We are getting some other Claims,Repriced claims, Eligibility files in different file formats like Text,Excel,CSV.Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
  • Created jobs using sql agent to automate the ETL Process and database Backups and Restore.
  • Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
  • Load the data into destination tables by both full and incremental load by truncating and using joins on multiple columns within the stored procedures.
  • Wrote C# code for Script ask in SSIS.
  • Creating the jobs using the job Agent and Scheduling jobs to automate the ETL Process and to deliver the automated reports on daily, weekly and monthly basis.
  • Using Power BI, Developed pie charts, bar graphs, table, donut, and matrix reports using DAX functions.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in power BI.
  • Creating Row level security with power bi and integration with power bi service portal.
  • Created complex Reports using Charts, Gauges, Tables, matrix.
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
  • Created Drill Down Reports, Drill Through Report by Region.
  • Install and configure on premise Gateway; utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Scheduled Automatic refresh and scheduling refresh in power bi service.

Environment: Windows10,Windows Server 2008,MSSQL Server 2017, SQL Server Integration services, Pilot fish Integration tool, Power BI.

Confidential, Spokane,WA

Data Engineer

Responsibilities:

  • Installed SQL Server 2017 and configured the databases.
  • Worked with T-SQL to create databases, Tables, views, Function, Stored Procedures, sub-queries and ad-hoc T-SQL statements.
  • Normalized the database tables and pushed into production server.
  • Modified existing tables, views and stored procedures based on the requests.
  • Setup Red gate SQL server monitor for the production servers.
  • Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data in to the tables from Text files, Excel file and CSV file.
  • Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop).
  • Created jobs using sql agent to automate the ETL Process and database Backups and Restore.
  • Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
  • Developed Excel Reports and modified based on the QI Requests.
  • Wrote C# code for Script ask in SSIS.
  • Developed Tableau reports and dashboards from multiple data sources using data blending.
  • Designed Tableau data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Scheduling jobs using SQL agent to automate the ETL Process.

Environment: Windows 10,Windows server 2008 MSSQL Server 2014/2017, SQL Server Integration Service, SQL Server Reporting Services,Redgate Toolbelt,SQLMonitor,TFS,Tableau,Hornbill ticketing System.

Confidential

SSIS/SSRS/POWER BI Developer

Responsibilities:

  • Installed SQL Server 2017 and configured the database.
  • Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data in to the tables from Text files, Excel file and CSV file.
  • Developed packages to handle data cleansing, loading multiple files and executing tasks multiple Times (using For Each Loop)
  • Modified the Existing SSIS Packages and added more audits and alerts in case of package failure
  • Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated Sub query, complex Stored Procedures and ad-hoc TSQL statement.
  • Identified the Data Source and defining them to build the Data Source Views.
  • Developed Query for generating drill down reports in SSRS 2017.
  • Designed and implemented stylish report layouts.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Identified and worked with Parameters for parameterized reports in SSRS 2017.
  • Developed Power BI reports and dashboards from multiple data sources using data blending.
  • Desingned Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Explored data a variety of ways and across multiple visualizations using Power BI.Strategic expertise in design of experiments,data collection, analysis and visualization.

Environment: MSSQL Server 2017, SQL Server Integration Service, SQL Server Reporting Services, Query Analyzer, Enterprise Manager, SQL Profiler, Windows XP, MDB Access, MS Word, TFS.

Confidential, Spokane, WA

ETL Developer

Responsibilities:

  • Installed SQL Server 2012/2014 and configured the database.
  • Migrated data from Heterogeneous data Sources (Excel, Flat file, CSV file) to centralize SQLServer databases using SQL Server Integration Services (SSIS) to overcome transformation Constraints.
  • Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to load underlying data in to the tables from Text files, Excel file and CSV file.
  • Developed packages to handle data cleansing, loading multiple files and executing tasks multiple Times (using For Each Loop).
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
  • Modified the Existing SSIS Packages and added more audits and alerts in case of package failure
  • Worked with T-SQL to create Tables, Function and Stored Procedures, sub-query, correlated Sub query, complex Stored Procedures and ad-hoc TSQL statement.
  • Identified the Data Source and defining them to build the Data Source Views.
  • Developed Query for generating drill down reports in SSRS 2014.Designed and implemented stylish report layouts.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Identified and worked with Parameters for parameterized reports in SSRS 2014.
  • Designed and implemented stylish report layouts using tableau.
  • Developed Tableau reports and dashboards from multiple data sources using data blending.
  • Designed Tableau data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
  • Developed both online and direct query reports in Tableau from various sources.
  • Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS).
  • Experience in Windows Azure, migrating database to Azure.
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.
  • Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, Power Shell.

Environment: MSSQL Server 2012/2014,SQL Server Integration Service, SQL Server Reporting Services, Query Analyzer, Enterprise Managers Profiler, Index Tuning Wizard), Windows XP, MS Access, MS Word,Tableau,Azure Cloud.

Confidential

SQL/SSIS/ SSRS/SSAS Developer

Responsibilities:

  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS Package
  • Extensively involved in designing the SSIS packages to load data into Data Warehouse.
  • Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
  • Extract Transform Load (ETL) development using SQL Server 2008, SQL 2014 Integration Services (SSIS).
  • Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
  • Involved in the Production Support of SSIS Packages.
  • Enhancing and deploying the SSIS Packages from development server to production server.
  • Involved in writing Visual C# Scripts in SSIS Packages.
  • Responsible for Designing and Creating SSAS Cubes from the Data Ware House.
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
  • Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services
  • Designing SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Created SSAS Cubes having Factless Fact Tables and Slowly Changing Dimensions.
  • Involved in writing MDX queries and performance optimization of the SSAS cubes.
  • Experience in writing complex MDX queries for calculated members and measure groups.
  • Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports through Report Builder Using SSRS 2014
  • Involved in creating SSRS Reports from the SSAS Cubes and writing Complex MDX Queries in the Reports.
  • Involved in gathering the business requirements for the SSRS Reports.
  • Worked on Performance tuning of T-SQL Long Running queries and Stored Procedures .
  • SQL Queries debugging and improvement through analyzing Execution Plan.
  • Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
  • Creating Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau users.

Environment: MSSQL Server 2012, SQL Server Integration Service, SQL Server Reporting Services, Enterprise Manager, DTS Designer, Tableau 9.6,Reader,Tableau server 7/8,Windows XP, MS Access, MS Word.

Hire Now