Resume

Sign in

Sql Server Data

Location:
South Plainfield, NJ, 07080
Posted:
May 13, 2020

Contact this candidate

Resume:

MD MOSTAQUE HOSSAIN

adc65f@r.postjobfree.com 408-***-****

Sr. MSBI Developer

8+ years of experience as SQL Server/Business Intelligence Developer in database designing, modeling, reporting, development, and support of using Microsoft SQL Server 2016/2014/2012/2008 R2/2005 Data Warehouse, Test and Production Environment. Proficient in Microsoft Stake such as (SSIS/SSRS/SSAS/Power BI).

Exceptionalof managing BI environment, which includes Business Objects, Data Model, Data Sources, ETL Tools,Data Marts, Data Analysis and Reporting Tools.

Experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity, SQL Joins and CTE’s.

Responsible for creating SSIS Packages using ETL tools such as SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.

Experience with all phases of software development life cycle (SDLC) and project methodologies.

Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.

Experience in developing custom reports and various Tabular Reports, Matrix Reports, Ad hoc Reports, Distributed Reports in multiple formats using SSRS and BIDS.

Extensively used the advanced features of PL/SQL like collections, nested table, and dynamic SQL.

Created Power BI Visualizations, Dashboards perrequirements.Worked on PowerView, Power Map for reporting.

Work with cursor and ref cursor in PL/SQL scripts. Used ref cursor in functions to write the record set of cursors.

Worked to establish connectivity between ASP.NET applications by using ODBC.

Experience in Logical and Physical Database design & development, Normalization and Data modeling using ERWIN and SQL Server Enterprise Manager.

Strong ability in defining query for generating Drill down, Drill through reports, handling Parameterized reports, and creating stylish report layouts in SSRS.

Participated in the bottleneck’s elimination of various packages, reports and implemented tuning standards.

Extensive experience in writing Transact - SQL (DDL/DML) queries.

Experienced in writing queries by using SQL commands, keywords, functions, Sub Queries, joins, stored procedures.

Reviewed & Tested packages and reports (Unit test, Report test and Reconciliation).

Maintained versioning in Version Tools such as TFS.

Knowledge in DQS (Data Quality Services).

SQL Server Administration skills including Backups, Disaster Recovery Model, Database Maintenance, User Authorizations, Database Creation, Tables, and Indexes.

Excellent Interpersonal and communication skills, logical and Analytical skills to solve complex problems, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.

Technical Skills

Operating System

Windows XP/VISTA/7/8/10, IOS, Unix

Programming Languages

T-SQL, SQL, C, PL SQL, ASP.NET

RDBMS

MSSQLServer2016/2014/2012/2008R2/2008/2005/2000, Oracle Database 11g/10g/9i.

BI Tools

SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server

Reporting Services (SSRS)

Data Modeling Tools

Visual Studio 2005/2008/20012/2015, MS-Visio, Erwin 7.2/4.5, Metadata Manager,Informatica tool.

Database Query Tools

SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Query Analyzer, SQL Profiler.

Professional Experience

Sr.MSBI/SSIS/SSRS Developer Care Source Dayton, OH 01.2019 -Till date

Responsibilities:

Creating stored Procedures, User defined functions, Views and modifying existed procedures, triggers, views,indexes depending on the requirement.

Used SSIS packages using Data flow Task, Script Task, Execute SQL task with different Transformation like Data Transformation, Fuzzy Lookup, Un-Pivot, Derived Columns, Conditional Split, etc.

Created SSRS Reports that have templates and cannot accommodate through SSIS such as ad-hoc, Drill down and Parameterized reports.

Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.

Using SQL Server Agent to create, Modify, Schedule jobs accordingly and send notifications.

Generated custom and parameterized reports, sub reports in SSRS.

Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.

Actively involved in developing Complex SSRS Reports, Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

Experience in creating complex SSIS Packages with error handling using control and dataflow elements.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.

Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects, Implemented Incremental load, used Event Handlers to clean data from different data sources.

Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes.

Having Experience on Exception Handling, Configurations and Project Deployment in SSIS.

Respond to ad-hoc requests from Business Analyst and Project Managers by providing accurate data/reports in a timely manner.

Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.

Installed and administered Microsoft SQL Server Integration Services and SQL Server Reporting Services. Designed and optimized various T-SQL database objects like tables (schemas), views, stored procedures, User Defined functions (UDF), indexes and triggers using Management Studio and SQLProfiler.

Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.

Responsible for Unit testing of the reports before moving them for validation by the Business Analysts.

Responsible for cleansing up database for maintenance work.

Worked in Agile environment and used JIRA for managing the project.

Environment: Microsoft SQL Server 2016/2014/2012/2008 R2, SSDT, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, Power BI, Visual Studio.

Sr. MSBI/SSIS/SSRS Developer Pearson Education Bloomington, MN 06.2017 – 12.2018

Responsibilities:

Expert in creating database objects such as Tables, Procedures, Triggers, Constraints, Indexes and Views.

Interacting with Business Analysts and Developers in identifying the requirements, designing, and implementing the Database Schema.

Documented and maintained database system specifications, diagrams, and connectivity charts.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Used SQL profiler to view indexes performance to mostly eliminate table scan.

Created various DTS packages for data transfer and migration.

Extract data from database and export to Excel files for Data Analyst to analyze the data.

Used overly complexT-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.

Created SSIS packages to load data by using for each loop Containers, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Data Conversion, Pivot Transformation, and Slowly Changing Dimension, FTP task, SMTP task.

Written complex T-SQL queries and created Stored Procedures, Triggers, functions, and Views.

Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transforms.

Excellent experienced in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User defined data types, effective functions, cursors, and indexes using T-SQL.

Created Databases, Data Marts, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

Created, modified Tables, Views, Indexes, Functions, Triggers,Stored Procedures according to Business Requirement.

Designed a Data Model with multiple Fact Tables and Dimensions depending on the business requirements.

Created reports by using Joins in multiple tables from multiples database using complex SQL queries.

Updated mapping tables related to assigned functional areas as directed by the Business Analysts.

Worked with Excel Power Pivot Tables.

Writing MDX queries to get the data from a tabular model.

Responsible for building reports in Power BI from the Scratch.

Responsible for creating and changing the visualizations on the Power BI reports and Dashboards on client requests.

Connecting Power BI to different data sources – SQL databases, Web services, Web trends, Excel, Azure.

Involved in database Schema Design, development and executed stored procedures Using Batch files.

Built integrated reporting tools (Using Microsoft Power BI) with data from Sales, Marketing, and Finance systems.

Implemented the project using Agile/SCRUM methodology.

Environments: SQL Server 2014/2012, T-SQL, Windows 7, SSRS, SSAS, SSIS, Jira, Power BI, Azure, MS Visio, Team Foundation Server (TFS).

MSBI Developer Cardinal Health Dublin, OH 07.2015 – 05.2017

Responsibilities:

Involved in analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.

Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.

Worked on SQL Joins, Sub Queries, Tracing and Performance Tuning for better running of queries.

Exclusively involved in BI solutions using T-SQL, SSRS, SSIS, SSAS and Programming using DDL, DML, DCL commands and Stored Procedures for various business applications.

Experience in using SQL server reporting Services (SSRS) and creating various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill DownReports.

Configuration of report server and report manager scheduling give permissions to different level of users in SQL Server Reporting Services (SSRS).

Developed complex programs in T-SQL, Writing Stored Procedures, Triggers and Queries with best execution plan.

Worked in DAX Expressions, Power Query, and Functions in Power BI.

Worked in creating solution driven views and dashboards by developing different chart types including Heat Maps,Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, ScatterPlots, and Histograms in Power BI.

Created SSIS packages using various Data transformations like Conditional Splitting, Look Up, For Each Loop, Multi Cast, Column Conversion and Fuzzy Look Up.

Interacted with business representatives and subject matter experts to analyze, collect and document clear and concise mappings and data quality rules enabling the development of complex data transformations.

Created and defined XML Message Schemas (XSD) and provided data mapping into XML structures.

Developed Data mapping specifications using Microsoft Excel Tables and customized pivot table reports for viewers with different information requirements.

Transform the data from the staging database and perform the transformation using the Data Flow Tasks.

Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.

Developed packages in SSIS with error handling.

Submitted and participated in daily defect review meetings emphasis was to help reduce the quantity of defects not being detected prior to UAT.

Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.

Implemented the project using Agile/SCRUM methodology.

Implementing customer scenarios in test environment providing best practices, good with Azure service model and Azure Resource Model.

Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2012/2008/2005, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ERWIN, ProClarity, MS Excel.

MSBI Developer Wal-Mart Bentonville, AR 02.2013 – 06.2015

Responsibilities:

Worked closely with the Business Users and SMEs to Define the Project scope for new clients and enhancement requests for existing clients.

Defined project deliverables, resources and timelines and documented them in MS Project.

Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.

Created packages using SSIS for data extraction from Flat Files, Excel Files and OLEDB to SQL Server.

Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.

Prepared wireframes and mockups for designing user Interface and process flow diagrams using MS Visio.

Prepared and maintained Requirement Traceability Matrix for Requirement, Change Control, Design, and Development and Testing.

Created and maintained Data Mapping based on client data and application requirement specifications.

Prepared data transformational rules documents and data dictionary for the downstream users.

Designed Logical and Physical Data Model with Erwin tools.

Created SSIS packages to populate data from various data sources.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Developed Tabular Reports, ad-hoc reports using SSRS Report Designer.

Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.

Improved the performance of SQL queries tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor.

Developed parameterized MDX, bottom count, top count, and cross join, non-ascendants, and log MDX queries for creating Calculations and KPI's on SSRS Reports.

Running DBCC consistency checks and fixing data corruption in application databases.

Implemented Power BI Pivot for data analysis by developing various aggregation and calculations.

Configured SSIS packages using Package configuration wizard to allow packages run on different environments.

Created census and test data for design and development, functional/regression and UAT testing

Executed SQL queries to extract data on SQL Server and DB2 Databases for data analysis and validation.

Deployed SSIS packages with a simple one-click deployment to the integration server.

Worked on Clustered and Non-Clustered index to improve the access of data within the database.

Created complex dashboards with area charts, pie charts and crosstab and list reports in Report Studio and Cognos workspace advanced.

Involved in performance tuning and monitoring of T-SQL blocks.

Deployed packages from development Server to production server.

Worked with application developers and production teams across functional units to identify business needs and discussed solution options.

Environment: MS SQL Server 2012, Microsoft Visual Studio 2010, MS Access, MS Excel, MS Visio, SQL Server Profiler, Windows XP, Vista, 7,8,2008/2008 R2/2012, SSIS, SSRS, SharePoint, TFS, Waterfall, Agile.

SQL Developer ICICI Bank India 04.2012 – 01.2013

Responsibilities:

Created and managed Stored Procedures, Indexed Views, user defined functions, Triggers, Database constraints to meet business requirements and policies.

Thorough analysis and testing of database objects &T-SQL statements before deployment to the production server.

Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.

Created and configured an OLTP replication database for disaster recovery purpose.

Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.

Extracted data from XML to SQL server.

Highly involved in creating, structuring, and formatting using Report Designer and Report Builder.

Created Tabular Reports, Matrix Reports, List and Chart Reports, Parameterized Reports, Sub Reports, Ad hoc Reports, Drill-Down Reports and Interactive Reports according to business requirements in time-restricted environment.

Used Event Handlers and logging for Exception Handling in SSIS packages.

Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.

Working with trainers and technical writers to develop user support materials.

Automated redundant and repetitive tasks using different tools and objects available in SQL Server.

Timely support and maintenance of the application to ensure uninterrupted business deliverables.

Worked on coding of all the change requests and performed code reviews for team members.

Resolved all the tickets which were raised during production support with agreed service levels.

Environment: MS SQL Server 2010/2008/2005, Transact-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel, Windows 7

Education

Bachelor’s in 2008 from National University



Contact this candidate