We provide IT Staff Augmentation Services!

Sql And Bi Developer Resume

SUMMARY

  • I am a dedicated and detail - oriented person with more than 12 years of IT experience from which more than 6 years SQL server/BI Developer in Database and Business Intelligence Technologies with expertise in SQL Server Database, ETL and Report development using SQL Server 2008/ 2012/2014/2016 , SSRS, SSIS, and Power BI.
  • Proficient in database activities like data profiling, data modeling, database design, development, database creation and maintenance, performance monitoring and tuning, troubleshooting, and normalization
  • Proficient in writing T-SQL queries, dynamic-queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views, relational database models, data dictionaries, and maintaining data integrity.
  • Experienced in Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
  • Expert on Configuring MS SQL Integration Service Catalogs, creating Dynamic SSIS Packages with Parameters, local and environmental variables, and check points.
  • Performed data migration using import/export, BULK INSERT and Bulk Copy Program (BCP) between heterogeneous systems and SQL Server; Created Alerts and Scheduled SSIS Packages.
  • SSRS- created reports with SQL Server Reporting Services (SSRS) and Created Drill Through reports, Drill Down reports, Sub-reports, Cascading Parameters, Linked reports, Matrix etc.
  • Power BI- created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
  • Quick in learning and applying new technologies and tools and outstanding analytical, presentation and time-management skills. Possess a strong ability to quickly adapt to new applications and platforms.

TECHNICAL SKILLS

  • MCSA - Developing SQL Server 2016
  • Microsoft BI (SSIS, SSAS, SSRS), T-SQL development
  • Network +, Security +, Windows Server 2008/2012
  • Salesforce Administration/ development
  • T-SQL, C++, Apex, Visualforce, HTML, DAX
  • SQL Server Management Studio, Visual Studio (Visual Studio 2010/2012/2015/2016/2017 ), and Microsoft Office (MS)
  • Good exposure to entire Software Development Life Cycle (SDLC)
  • Jira Agile methodology

PROFESSIONAL EXPERIENCE

SQL and BI Developer

Confidential

Responsibilities:

  • Analyzed business requirements and built conceptual, logical, and physical data models that describe all the data and relationships between the data
  • Installed and Configured SQL Server 2014/2016 on physical Server and Virtual environments.
  • Created T-SQL Stored Procedures, User Defined Functions, Indexes, Views, Constraints, Triggers and wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTEs (Common Table Expression).
  • Built and deploy SSIS packages for data extraction and loading including such transformations as Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
  • Performed data migration using import/export, Bulk Insert and BCP (Bulk Copy Program) between heterogeneous systems and SQL Server. Scheduled SSIS Packages
  • Created reports with SQL Server Reporting Services (SSRS) and Created Drill Through reports, Drill Down reports, Sub-reports, Cascading Parameters, Linked reports, Matrix etc.
  • Power BI- created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc.
  • Develop, publish, and schedule interactive Power BI reports and dashboards to meet business requirements .
  • Developed relational databases and multidimensional OLAP data warehouses

Environment: Power BI , DAX, SQL Server 2014/16, SSMS, SSIS, SSRS, SSAS, T-SQL, MS Excel, Windows 10, Jira, Lucid Chart, Visual Studio 2016/2017

BI and Database Developer

Confidential

Responsibilities:

  • Interacting with Business users, gathering and analyzing requirements
  • Built and deployed SSIS packages for data extraction and loading including such transformations as Slowly Changing Dimensions, Lookup, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
  • Created reports that contained Parameters, Sub-Reports, charts, gauges with Drilldown and Drill through features in MS SSRS 2012/2014/2016
  • Analyzed the Sources, Targets, Transforming the data, and Mapping the data and Load the data into Targets using SSIS
  • Created complex stored procedures and functions to support efficient data manipulation
  • Recovering the databases from backup in disasters
  • Implemented Error handling and utilized Event handlers for automated notification using SSIS

Environment: Power BI , SQL Server 2014/16, SSMS, SSIS, SSRS, T-SQL, Windows 10, MS Excel, Visual Studio 2014/16

IT Support Specialist

Confidential

Responsibilities:

  • Monitor various servers from a dedicated command center.
  • Provide onsite support for hardware failures on various Virtual Tape Servers.
  • Prepare problem tickets via Confidential ’s internal incident management applications (Maximo).
  • Perform daily/weekly full and incremental backups for Confidential Z/VM servers.
  • Provide user’s account support for local/remote users.
  • Run scripts daily to check database growth.
  • Runs scripts daily to check systems performances.
  • Write logs to keep track of activities using Confidential ’s internal application.
  • Update online procedural documentation accordingly.
  • Ensure all security measures are applied accordingly.
  • Secure all customers’ data in respective of each customer.
  • Configure and build Confidential 2105 and 2107 Shark Disks according to customer specification

Environment: Confidential Maximo, Lotus Notes, MVS, VM, Microsoft Office, Disaster Recovery test, ATL (Automated Tape Library), Confidential Z/VM server, Confidential Shark Disk

Hire Now