We provide IT Staff Augmentation Services!

Sql/etl Developer / Power Bi Developer Resume

0/5 (Submit Your Rating)

Chesapeake, VA

SUMMARY

  • Over 7+ years of in - depth experience in database Design, Modeling, development and maintenance of SQL Server 2016/2014/2012/ 2008 R 2/2008/20005 large scale databases.
  • Expertise in writing T-SQL queries, Joins, Constraints, DDL, DML, creating clustered and non-clustered Index, ETL Processes including Data Cleansing and Data Migration.
  • Experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization.
  • Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers
  • Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
  • Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
  • From unstructured data to dashboard with Azure Data Factory and Data Lake
  • Copying On - Premise SQL Server Data to Azure Data Lake
  • Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
  • Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
  • Highly experienced in database server performance tuning and optimization of Complex SQL queries.
  • Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
  • Solid understanding of various asset classes and financial instruments including equities, cash, bonds, Stock and derivatives (swaps, credit-default swaps, options and futures)
  • Developed power apps canvas in Power apps 1.0.5 in services
  • Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
  • Good Knowledge in designing Database Models using UML, MS Visio and Erwin.Experience with Microsoft Power Platform, using data connectors, and Common Data Services
  • Experience with SQL/Query tools to extract and update data
  • Experience using data reporting and data visualization tools including Power BI and Tableau.
  • Migrate existing SSRS reports to Power BI and created different reports and dashboards using power BI. Ability and willingness to learn new technology and deliver results in a timely manner.
  • A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

RDBMS: SQL Server 2005/2008/2008 R 2/2012/2014/2016

Database / ETL Tools: SSMS, SSIS, SSAS, Informatica, Talend, Power Apps

Reporting: SQL Server Reporting Service (SSRS), Power BI, Report Builder, MS Excel, Tableau

Languages: VB6.0, ASP.net, JavaScript, C#, C++, T-SQL

MS-Office: Microsoft Office Tools

Operating Systems: Linux, Unix, Windows Server 2008, 2008R2, 2012

PROFESSIONAL EXPERIENCE

Confidential, Chesapeake, VA

SQL/ETL Developer / Power BI Developer

Responsibilities:

  • Worked closely with SME’s end users/internal customers to understand project/requirement scope
  • Worked with Business Systems Analysts to fine tune specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes
  • Involved in the logical and physical data models of databases and prepared test cases for existing solution and new solutions to validate the solution met requirements. And prepared documentation for same.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules. (used CTE, temporary tables, user defined table types in codes developed)
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008/2012.
  • Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
  • Expertise in writing complex DAX functions in Power BI and Power Pivot
  • Used cascaded parameters to generate a report from two different Data Sets.
  • Established ETL design practices for optimization and performance of packages and Parameterized SSIS.
  • Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
  • Designed an OLAP system with the help of ERWIN to visualize data structure.
  • Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2012/2016.
  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
  • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
  • Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.
  • Migrated enterprise database to Microsoft Azure with Redgate and azure data factory.
  • Helped to develop backup and recovery strategy for databases on virtualization platform utilizing Microsoft Azure.

Environment: SQL Server 2016/2012, SQL BI Suite (SSIS, SSRS), T-SQL, Power BI, Power apps 10.0.5,SQL Profiler, MS Office, Erwin, Windows Server 2016.

Confidential

SQL/ETL Server Developer (SSRS, SSIS)

Responsibilities:

  • Interacted with the users for understanding and gathering business requirements.
  • Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.
  • Implemented data views and control tools for guarantee data transformation using SSIS.
  • Extensively worked on SCD transformation in SSIS package.
  • Successfully deployed SSIS packages with defined security.
  • Developed logical database and converted into physical database using Erwin.
  • Designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema.
  • Issuer Data Analytics (IDA), a multi-tiered ASP.Net web application that shows historical and current bond trades.
  • Developed various Charts and Graphs like bar charts, line charts, pie charts etc by using chart experts for BI needs.
  • Involved to write complex T-SQL queries and Stored Procedures for generating reports.
  • Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, fund Reports, Portfolio Report, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2005.
  • Use ETL to implement the slowly changing Transformation to maintain Historical Data in Data warehouse.
  • Successfully worked with Report Server and configured into SQL Server 2005.
  • Extensively worked with OLAP cubes to generate drill through reports in SSRS.
  • Created Custom Hierarchies to meet the Business requirement in Tableau.
  • Created Workbooks and dashboards for analyzing statistical billing data using Tableau.
  • Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
  • Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system.
  • Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
  • Tuned SQL queries using execution plans for better performance.
  • Optimized by assigning relative weights to the tables in the Catalog and Query Performance.

Environment: MS SQL Server 2005/2008/2008 R2, MS SQL Server 2008 Reporting Service, Tablue, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP.

We'd love your feedback!