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