Over8 years of IT experience as a MS SQL Server Developer 2016/2014/2012/2008/2005 in various Industry verticals like Health Care, Finance and Insurance. Experience in Installationand Configuration of SQL Server2016/2014/2012/2008/2005. Experience in developing and managing reports and Dashboard using Power BI. Extensive experience in MS SQL Server 2016/2014/2012/2008/2005 BI tools (SSDT) like SQL Server Integration Services(SSIS), SQL ServerReporting Services (SSRS) and SQL server Analysis Services (SSAS). Experience on Performance Tuning, Client/Server Connectivity, Query Optimization, running database consistency check with DBCC Commands. Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, and User Defined Functions. Hands-on working experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks. Highly experienced in complete cycle of SQL Server Integration Services (2014/2012/2008/2005), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers. Highly proficient in the dealing with Complex Stored Procedures, Views, Data Import/Export, System Views and functions. Experience in Extraction and Migration of data from various data sources like Excel, MS Access and Oracle to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities. Strong Experience in writing, debugging, fine-tuning and optimizing complex Stored Procedures, Cursors and Triggers in SQL Server by analyzing the Query Execution Plan and using the Profiler. Experience in providing Logging,Error Handling by using event handlers and custom logging for SSIS Packages. Hand on Experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources.
Health Sun
-
Sql Bi DeveloperHealth Sun Jan 2017 - PresentMiami, Florida Analyze utilization data to identify patterns and trends that may impact overall performance. Work closely with PM and Development teams to create andtest the mappings to heterogeneous sources to the data ware house. Created Database Objects likeStored Procedures, Triggers andUser Defined Functions (UDF) for this project. Created Views to maintain security of customer data. Created Indexes to get the high level performance. PerformedETL operations to support incremental, historical data loads and transformations using SSIS. Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Created calculated measures and dimension members using Multi-Dimensional Expressions (MDX). Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages. Designed SSIS packages for synchronizing the data between two different servers. Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs. Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup. Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution. Created SSIS Packages to migrate slowly changing dimensions. Create Power View reports using Power Pivot Data models. Import data from SQL Server databases and Analysis services into power pivot data model. Designed, coded and implemented ad hoc reports in SSRS. Worked on formatting SSRS reports using the Global variables and expressions. Heavily worked on SSRS report performance, stored procedure tuning, table partitions. Design and develop Tabular Data model (SSAS) and deploy that on to the Share Point server.
-
Sql Server Bi DeveloperDignity Health Jul 2015 - Nov 2016Phoenix, Arizona Area Analyzing and understanding the existing reporting environment. Worked closely with the Business analysts for requirements gathering, designing the database and creating workflow for report. Implementing the new reporting requirements for the business by making use of the new database and schema changes. Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse Created one central SSIS Master Package to execute multiple child packages with Control Flow and Data Flow. Utilized Parent Package and XML Configuration to dynamically pass variable values on runtime. Developed dashboards using Power BI. Participated in identifying data migration issues and resolved them. Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Created and scheduling maintenance jobs in new environment using SQL Server Mailing Agent in SQL Server. Extensively used variables, break point, check point, logging, packageconfiguration and event handler in SSIS packages to meet the business needs. Involved in performance tuning to optimize queries and enhance the performance of databases, SQL queries, and stored procedures using SQL Profiler, Execution Plan and Index Tuning Wizard. Created Complex SSAS Cubes with multiple fact measure groups, and multiple hierarchies based on the OLAP reporting needs. Built MDX queries for Analysis Services & Reporting Services. Designed, developed, created and tested PivotTable/PivotChart reports based on OLAP cubes and offline cubes. Created multiple partitions and aggregations for the different measure groups for improving performance of the cubes. Resolving the SSAS cube connectivity and data issues as and when needed. -
Sql Server Bi DeveloperKodiak Networks Dec 2013 - Jun 2015Plano, Texas Analyzing the transactional data in DB2 and other source systems using Data Profiler. Worked with integration services for transferring and reviewing data from heterogeneous sources like (Progress Database, Excel, CSV, flat file, Text Format Data). Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables. Wrote complex Stored Procedures, functions and triggers as and when needed and to convert data logically as per the business requirements to improve the productivity of the claims processing system. Connected to the FTP Server and pull the group of Excel sheets into the SSIS from the folder located on FTP Server. Set up different kinds of transformations like Derived Column, Conditional Split, Lookup, Merge, Row Count, Data Conversion etc., in all the SSIS Packages. Set up ETL Jobs to run on a nightly basis into the Data marts by Scheduling SSIS Packages via SQL Server Agent. Coordinating the production deployment activities. Responsible for Performance Tuning of SQL commands and trouble shooting of Technical problems in SQL Server using SQL Profiler and the Database Engine Tuning Advisor. Documented all kinds of Reports and SSIS ETL Packages. Testing the new SSRS reports developed based on different filters and validating the outcome with the database. Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services. Experienced in creating Ad-hoc reports, data driven subscription reports by using parameters, queries and reports in SSRS Report Builder, Developed data-driven subscription to end-users. Ensure all code and versions are properly maintained in TFS while migration is in progress.
-
Sql Bi DeveloperMaq Software Jun 2012 - Oct 2013Hyderabad Area, India Perform ETL operations to support the data loads and transformations using SSIS. Created distributed partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones according to new requirements. Perform Ad-hoc analysis as and when required by the higher management. Change existing stored procedures upon request to implement new business logic. Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task and different data flow tasks using T- SQL and VB scripts. Update SSIS packages to populate new dimensions and facts. Design SSIS packages for synchronizing the data between two different servers. Schedule daily and weekly SSIS jobs on SQL Server Agent. User scatter plot chat,line chart,bar chart,funnel chart in various reports. Generate reports using SSRS that could be used to send information to different primary vendors, clients and mangers. Develop tabular, drill down, cascade and sub-reports using SSRS. Deploy reports onto the Reporting server and provide the data connections accordingly. Create roles and maintain the security by assigning users to appropriate permissions. Generated dynamic reports from the Multi-Dimensional databases. Involved in dimensional modeling with Star schema and created the data source views (DSV) and cubes using the identified fact and dimension tables. -
Sql Bi DeveloperCigniti Technologies Jul 2010 - May 2012Hyderabad Area, India Participated in installation of SQL Server and Enterprise manger tools using SQL Server Setup Program. Created tables, indexes and constraints. Created Views, Triggers in T-SQL. Defined stored procedures for module integrity and application. Involved in performance tuning of the database and T-SQL queries. Migrated access objects to SQL Server 2008. Extensively used Import/Export Wizard for performing the ETL operations. Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa. Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team. Designed and implemented several complex reports. Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports. Created different user level groups, and assigned appropriate permission level to the database. Preparation of project documentation.
Mohammed J Education Details
-
Information Technology
Frequently Asked Questions about Mohammed J
What company does Mohammed J work for?
Mohammed J works for Health Sun
What is Mohammed J's role at the current company?
Mohammed J's current role is SQL BI Developer at Health Sun.
What schools did Mohammed J attend?
Mohammed J attended Osmania University.
Not the Mohammed J you were looking for?
-
-
-
2se.com.sa, gmail.com -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial