Data Sql Server
Resume:
Shaik Mehrajuddin
SQL BI Developer/SSIS - Providence Health Care
Montréal, QC
***********@*****.***
Over 3+ years of extensive experience in database design and development with MS SQL Server version 2014 using SSIS in Health Domain and extensive knowledge on T-SQL, Writing SQL Queries, Stored Procedure, Functions, SQL Server Integration Service (SSIS)
- Experienced with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation
- Strong experience in logical and physical database design and development, Normalization and data modeling using MiS SQL Server Enterprise manager
- Extensive experience in MS SQL Server 2014 Business Intelligence technologies like MS SQL Server Integration Services (SSIS)
- Worked extensively with Slowly Changing Dimension and lookup Transformation for implementing Inserts and Updates
- Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2014)
- Experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS
- Expertise in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server
- Expertise in creating, configuring and fine-tuning ETL workflows designed in DTSX and MS SQL Server Integration Services (SSIS)
- Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS
- Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
- Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, views, relational database models and data integrity, SQL joins and query writing
- Experienced in Query performance optimization.
- Experienced in creation, implementation and managing SQL server jobs.
- Migration of databases & database objects.
- Installing and Configuring of SQL Server 2008 & 2008R2 in normal environments.
- Diagnostic Ability - Ability to go to the core of the problem and able to meet deadline.
- Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication
- Involved in interaction with client & client requirement gathering. Maintained Positive Communications and working relationships at all business levels. Business/Technical Skills:
MS SQL Server, MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Visual Studio, Microsoft Visio, T-SQL, MS office, Windows, Advanced Server/Professional, SVN, JIRA, CONFLUENCE.
Willing to relocate: Anywhere
Work Experience
SQL BI Developer/SSIS
Providence Health Care
July 2017 to Present
Project: MPT AND PATNER VALIDATION
Client: Providence Health Care
Project: Main objective of project is that to get valid doctor's details (ME Number, NPI's and demo information like name, address, location etc). MPT having the doctor's data, but they want to check whether the data which they have is proper or not. For that they will get/purchase the data for the same doctors from vendors like Skipta, Dream etc and cross check both the data. Match rate should be high after cross checking the data. Depends on the match rate they will consider the vendors next time.
Responsibilities:
- Work closely with business users to congregate and comprehend requirements
- Analyzed data contained in the corporate database and identify data integrity issues with existing and proposed systems
- Optimized the stored procedures which are using cursors and increased the performance
- Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database
- Designed and worked on extraction, Transformation and Loading (ETL) process by pulling up large volume of data from various data sources using SSIS
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send mail task etc.
- Designed SSIS packages for tracking the Audit time in multiple databases in multiple servers and worked on data flow task, Script component, OLEDB command, derived column, data conversion
- Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output
- Effectively used various properties in SSIS package to improve the performance
- Worked on event handlers to prevent the error in propagating to rest of package, worked on native and custom logging
- Created different chart reports helped in analyzing perform counters using SSRS Environment: MS SQL Server-2014/2008R2, Enterprise Edition, SSIS, T-SQL, OLAP, OLTP Microsoft Visual studio.
SQL DEVELOPER/SSIS/SSRS
Merck Canada Inc
January 2016 to June 2017
Project Main objective of project is to predict the flu intensity level. Based on the historical and current data we are predicting the flue severity levels for the coming weeks. Responsibilities:
- Extracting and Loading data into SQL Server Database using SSIS
- Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database
- Modified, organized, and reloaded legacy data to new tables. Also work on partitioning tables to improve database objects' efficiency
- Worked on Requirements Elicitation, Gap Analysis, Requirements Documentation
- Created ETL packages(.dtsx files) to validate, extract, transform and load data to Data warehouse databases, data mart databases.
- Used DTS, T-SQL, scripts, stored procedures and views to run routine reports
- Worked on MS SQL Server tasks such as data loading, batch jobs, DTS, and Indexes
- Performed Unit Testing, managed and monitored system utilization, designed stored procedures and triggers
- Involved in Implementation of database m of SQL based databases
- Creating and importing source/target tables from respective databases
- Distributing Reports by e-mail, FTP or via web access
- Developed SQL scripts, Stored Procedures, functions and Views
- Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources Environment: MS SQL Server 2008 R2/2012, SSIS, SSRS, Windows Server 2008, Query Analyzer, FTP Server, Svn, JIRA, Agile Methodology
Education
Masters in Electrical & Computer Engineering
Concordia University
2015
Bachelors of Engineering in Engineering
Jawaharlal Nehru Technological University
2012
Skills
DATABASE (3 years), ETL (3 years), EXTRACT, TRANSFORM, AND LOAD (3 years), MICROSOFT SSRS (3 years), SSRS (3 years)
Additional Information
IT Skill set
Database: MSSQLSERVER 2008, 2008R2, 2014
Integration and Reporting: SSIS (ETL), SSRS
Repository Tools: JIRA, MSOffice, SVN
Operating system: Windows (All flavors)
Contact this candidate