Professional Summary
Over 6+ years of professional experience in the Information Technology field as SQL/BI developer in MS SQL server2014/2016/2017/2012/2008R2/2008 environment covering various domains. Excellent in writing T-SQL queries, creating clustered and non-clustered Index, Data Cleansing, Data Migration and using them to alter and build objects. Ability to assign different types of keys with their preferred data types. Experienced in installing, upgrading, and configuring Microsoft SQL Server and Databases. Hands on experience in database normalization, de-normalization, optimization, Tuning, Back-up, migration, conversion, and document processing using data modeling tools. Experienced in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers. Confident with operators, variables, wildcards, views, triggers in T-SQL. Clear cut idea about data warehouse, dimensional modeling, OLAP, OLTP, RDBMS and schemas. Proficient in creating dynamic packages for Incremental loads and data cleansing in data warehouse using SSIS. Involve in all phase of SDLC, create detail analysis-design document with source to target mapping. Develop DataStage jobs to do ETL (load collection of data from multiple source to different destination with required business transformation.) Experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS. Extracted, transformed, and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, flat files using connectors, tasks and transformations provided by SSIS. Accomplished in creating Packages, scheduling Job, and sending Alerts using SQL Mail. Ability to build data marts and cube by analysis tool SSAS. Easy to build and deploy analytic solutions for decision support systems. Ability to measure, edit and compare business data with different queries. Good experience on KPI (Key Performance Indicators) areas. Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures Experience in Application systems and understanding how the data resides in the source system to effectively create OLAP Structures to support reporting. Excellent experience in developing drill down, cascading, parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users. Experienced with visualization tools like Power BI and Tableau Experienced in creating Ad hoc reports with complex design to query the database for Business Intelligence. A well-organized, goal-oriented, highly motivated effective team member.