We provide IT Staff Augmentation Services!

Senior Sql/bi Developer Resume

MarylanD

OBJECTIVE:

More than nine years of experience in IT including SQL Database, BI/ETL and Data Analytics. Able to build and maintain complex support systems with a proven track record of high client satisfaction. Successful history of leading Database Design and Development. Expert in developing procedures that improve information security and business continuity.

PROFFESIONAL EXPERIENCE SUMMARY:

  • Planned, modeled, designed, developed, implemented, and maintained Microsoft SQL Server 2016/2014/2012/2008 R2 databases
  • Developed ETL packages with SSIS, Report development with SSRS using SSDT on Visual Studio 2015, 2013,2010
  • Experience in Data modeling with MS Visio, Erwin, Toad and Lucid Chart
  • Created Database Users and SQL Server Logins and managing permissions
  • Responsible for data quality testing and leading a team that performs data reconciliation to identify data anomalies
  • Performed data cleansing using different transformations within SSIS packages
  • Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large set of data
  • Extracted data using SSIS from OLTP to OLAP systems, identified various data sources and established the connections using SSIS and constructed data source view
  • Implemented error and failure handlings within SSIS packages using event handlers, row redirects, check points, custom logs to monitor execution
  • Created SSIS configurations and SSIS catalog to provide an easy solution to packages migrations in different business environments
  • Created complex mappings using SSIS to transform/load data from heterogeneous source systems into target staging databases
  • Established Cascading parameters, Drill - Through Reports, Parameterized Reports and Report Models and Adhoc reports using SQL Server Reporting Services (SSRS)
  • Developed interactive data visualizations, dashboards and reports using Power BI and Tableau
  • Performed database backups and restorations, and recovers corrupted databases
  • Identified, evaluated and recommended network related tools and emerging network technologies
  • Configured network hardware including servers, routers, switches, firewall and other network devices
  • Maintained up-to-date detailed knowledge of the IT security industry including: awareness of new or revised security solutions, improved security processes and the development of new attacks and threat vectors
  • Designed, developed, tested and implemented the completed models of embedded hardware and software
  • Created Confidential layouts, performed component placements, determined wire routings and maintained schematic designs using Confidential CAD software like Altium, and Proteus

KEY QUALIFICAITONS:

  • Proficient with SDLC and Agile Methods
  • SQL,BI, Power BI and Tableau Development
  • Software Development and Testing
  • Network Security and Configuration
  • System Hardening
  • Information Assurance
  • Embedded Systems and Circuit Board Designs
  • Installing and Configuring SQL Server 2008R2/12/14/16
  • Critical Thinker
  • Detail and Result Driven
  • Project Coordination/Management

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008 , Azure SQL

Data Modeling Tools: SQL Diagrams, MS Visio, Lucid chart, Erwin, Toad

ETL Tools: SQL 2012/2014/2016 SSIS

Developer Tools: Visual Studio 2015/2013/2010 , Visual C++ 6, Quincy, NetBeans IDE, Eclipse

Databases Tools: SQL Server Management Studio, Business Intelligence Development Studio

Software Development Lifecycle: Waterfall, Agile

BI and Reporting Tools: SSAS, SSRS, Tableau, PowerBI

Programming Languages: T/SQL, JAVA, C, C++, C#.Net, VB.Net, Assembly

Network Devices: Router, Switch, Firewall

Network Simulator and Analyzer tools: Packet tracer,Wireshark

Microcontrollers Architectures: ARM,8051

Hardware Debug and Simulation Tools: - Keil, PSPICE, Multisim, Altium, Proteus

Routing and Switching Protocols: RIP, RIPv2, IGRP, EIGRP, IS-IS BGP,STP,RSTP,VTP

CAREER NARATIVE:

Senior SQL/BI Developer

Confidential, Maryland

Responsibilities:

  • Analyzed requirements and transform them into technical designs
  • Discuss database requirements with application and business teams to architect and propose database solutions for a target application
  • Developed data modeling to visualize database structure
  • Used MS Visio and Lucid char data modeler tools for OLTP database and OLAP and performed the logical and physical data modeling accordingly
  • Involved in Joint Application Development (JAD) sessions with technical lead, Developers, Data Architects, and Design Modelers to evaluate progress, discuss issues in the projects
  • Involved in complete Software Development Lifecycle (SDLC)
  • Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs
  • Created table indexes to improve database performance
  • Designed SSIS packages using various Transformations (Multicast, Merge Join, Lookup, Fuzzy Lookup, Slowly Changing Dimension, Aggregate, Conditional Split, and Derived Column Transformations)
  • Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables
  • Designed parent-child SSIS packages for better maintenance and efficient performance
  • Implemented error & failure handlings in SSIS packages using event handlers, row redirects, and check points for monitoring the execution
  • Developed many Tabular Reports, Matrix Reports, Drill-down Reports and Charts using SQL Server Reporting Services (SSRS)
  • Designed a summarized report for the end users for their analysis of the organization data
  • Built, published customized interactive reports and dashboards, report scheduling using Tableau server
  • Developed Tableau visualizations and dashboards using Tableau Desktop
  • Developed Power BI reports, interactive data visualizations, and dashboards after gathering and translating end user requirements
  • Plays a principal role in the development and implementation of Azure and AWS Cloud workflow automation processes and procedures
  • Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL .
  • Installs and maintains Cloud management tools
  • Participated in material development and provide multiple s
  • Team Leading and acting as cross communicator

Database Developer

Confidential

Responsibilities:

  • Used both System and User-Defined functions to enhance the functionality of my T-SQL code
  • Built database scheme, tables, procedures and permissions
  • Gathered user requirements, analyzed and designed database software solution based on the requirements
  • Created repeatable processes for data extraction, classification, enhancement, and analysis activities in Tableau
  • Experience in Microsoft BI reporting tools (SSRS, SSAS) and other reporting tools e.g. Power BI and Tableau
  • Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse
  • Created Parameterized, matrix and drill down reports using SSRS
  • Used SSIS to transfer data from various sources to be used for generating reports using SSRS
  • Designed and documented database architecture
  • Performed database backups and restorations, and recovers corrupted databases
  • Evaluated and recommended new database technologies
  • Implemented and maintained database security and encryption
  • Prepared written materials for the purpose of documenting activities
  • Engaged on executive dashboard to represent the organization’s reports to end users by providing ad-hoc query
  • Deployed reports to the report servers and troubleshot related issues
  • Prepared and distributed reports, including but not limited to weekly and monthly status reports
  • Liaised with project management teams, third-line engineers and service desk engineers on a regular basis
  • Spoke to customers via email and phone for initial requirement capture

Hardware and Network Security Engineer

Confidential

Responsibilities:

  • Designed, developed and implemented secure embedded hardware, software and PCB
  • Developed embedded C/C++ applications/firmware
  • Developed Confidential layouts, perform component placements and determine wire routings
  • Prepared prototype model diagrams, schematics, test cases and documentations
  • Built, tested and modified product prototypes, using working models or theoretical models constructed using computer simulation
  • Conferred with engineering staff and consulted specifications to evaluate interface between hardware and software and operational and performance requirements of overall system
  • Monitored functioning of equipment and make necessary modifications to ensure system operates in conformance with specifications
  • Tested and verified hardware and supported peripherals to ensure that they meet specifications and requirements, analyzing and recording test data
  • Wrote detailed functional specifications that document the hardware development process and supported hardware introduction
  • Direct technicians, engineering designers or other technical support personnel as needed
  • Development and information security policies and standards
  • Designed, developed, and implemented highly complex security architectures, frameworks and infrastructures
  • Researched, designed, tested, evaluated, and selected network solutions to secure and protect the infrastructure Web and Email Security
  • Designed and deployed LANs, WANs, and wireless networks, including servers, routers, switches, firewall, and other hardware
  • Developed, reviewed & approved configurations for all wired & wireless network elements
  • Monitor and test network performance and provide network performance statistics and reports
  • Installed and configured network security protocols

Hire Now