Abdul Rehman (Green Card)

SQL/BI DEVELOPER

Email ID: adu6cz@r.postjobfree.com:adu6cz@r.postjobfree.com

Ph. No: +1-216-***-****

PROFESSIONAL SUMMARY:

Having 5 years of experience as SQL-BI Developer in OLTP/OLAP/BI environment for very large databases in SQL Server 2016/2012/2008r2/2005.

Experience with Relational and Dimensional data modeling, of Ralph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas.

Strong in SQL development, SQL reporting, analytics and business intelligence (SSIS, SSRS, SSAS) and Strong Database Optimization.

Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).

Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS and SSIS.

Validate Database integrity after ETL loads, trouble shoot nightly ETL loads.

Working closely with Development team, own Schema changes and Data Models, modifying existing DBs, support relational DB model deign and deployment to Cloud, code reviewing, Index tuning, implement Data compression, Dimensions, measure and measure group creations, adding KPIs.

Expert in creating and using Stored Procedures, SSIS, Views, User Defined Functions, complex queries involving multiple tables and partitions better ETL performance.

Excellent experience in creating Indexes, Indexed Views, Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard, execution plan, DMVs.

Deployed SSRS reports into a reporting server and implemented security measures at report server by implementing authentication and authorization methods.

Extensive experience in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2012/2016.

Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), replication, Always ON features, In-Memory tables

Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS, C#.

Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.

Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, Environment variables in SQL 2012, 2014, 2017 etc.

Self-motivated to learn new technology with Excellent verbal and written communication skills combined with interpersonal and conflict resolution and strong analytical skills.

TECHNICAL SKILLS:

ETL Tools

SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools

SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, Erwin

Source Control

TFS, GIT hub

Ticketing Tools

Service Desk, BMC remedy

Domain Knowledge

Health care, Insurance, Telecom

Languages

T-SQL, SQL, PL/SQL, C#, java, XML, HTML, VB.Net

Applications

Microsoft Office Suite, Acrobat Reader/Writer

Databases

MS SQL Server, SQL 2016/SQL 2012, MongoDB, MySQL, Hadoop

Operating Systems/SAN

Windows, Windows Server, Linux, Unix

PROFESSIONAL EXPERIENCE:

NCJUA/NCIUA Nov 2021 to Till date

Role: MSBI Developer

Responsibilities:

Met with business users, gathered business requirements and prepared the documentation for requirement analysis.

Provided training to the business users on how to use new data warehouse, browsing cubes from Excel and assisted them in rewriting their existing queries to point to the new warehouse.

Implementing ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.

Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.

Created centralized data warehouse (ODS) and developed de-normalized structures based on the requirements and to improve the query performance for end users.

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

Created SSIS packages to load data from Flat File to Data warehouse using transformations such as Lookup, Derived Columns, Conditional Split, Sort, Multicast, Aggregate and Slowly Changing Dimension.

Used various SSIS tasks such as Fuzzy Lookup, Fuzzy Grouping etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Responsible for creating database objects like Table, Views, Stored Procedure, Triggers, Functions etc. using T-SQL to provide structure to store and to maintain database efficiently.

Created Views and Indexed Views for the Performance Tuning.

Created SQL Server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis in specific areas using SSAS.

Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL Server. Responsible for implementation of data viewers, SSIS logging for error handling the packages.

Responsible for managing BI environment, which includes Data Model, Data Sources, ETL tools, target Data warehouse, Data marts, OLAP analysis and Reporting tools.

Created Tabular reports, Drill down, charts, Functions and Maps using SSRS. Created reports to retrieve data using Stored Procedures that accept parameters.

Worked with the business to create various dashboards related to different areas of the business to re-establish business model.

Responsible for the Performance tuning of the SQL Commands with the use of SQL Profiler and Database Engine Tuning Wizard.

Supported and Administered TFS for creating new user groups

Tools: MS SQL Integration Services 2012, MS SQL Server Reporting service 2012, MS SQL Server 2012, Crystal Reports, Windows Server 2012, MS Office 2013, Visual Studio 2013, Tableau Desktop, Tableau Reader, Power BI Pro.

Client: National General insurance April 2020– Sep 2021

Role: BI/SQL Developer

Responsibilities:

Participated in requirement gathering, cube design, application design and SSAS development.

Constructed cubes based on data volumes mostly adhering to Star Schema.

Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.

Created and scheduled SSIS package to nightly process the SSAS cube based on oracle data mart tables updates.

Worked on development/staging/production environments and used Team foundation server/visual source safe for version controls and communication’s well as defining Actions, translations and perspectives.

Develop store procedures, tables, views, triggers and functions implement best practices to maintain optimal performance.

Created automated T-SQL scripts to process summary database transactions that run off-hours.

Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.

Implemented SQL Server OLAP services (SSAS) for building the data cubes.

Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data.

Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.

Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Designed and implemented fact, dimensions and SSAS cubes using dimensional data modeling standards in SQL server 2012/ Business intelligence development studio.

Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.

Created and designed SSAS cube and promoted to production using XMLA scripts.

Designed and implemented parameterized, drill-through, drill-down, and tabular reports on SSRS using SSAS cube for performance point.

Implemented/Developed multi parameterized reports in Report Builder and SSRS using SSAS cube allowing users to make selections before executing the reports and making it more users friendly.

Worked with SQL profiler to improve and enhance the MDX query execution time as a part of performance tuning process.

Wrote several complex stored procedures for efficient handling of the application.

Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012.

Involved in the designing, development, modification and enhancing the database structures and database objects.

Tools: SQL Server 2012/2008 R2, T-SQL, Windows 7, SSRS, SSAS, SSIS, MS Visio, performance point services, Power Pivot, Report Builder, Excel.

Client: HCL Technologies F eb 2018 – March 2020

Role: SQL Developer

Responsibilities:

Extensive experience in Analysis, Design, Development and support of various applications using SQL Server.

Use of agile SDLC approach to complete and track tasks on time.

Create ETL packages to move data from feed files (XML, CSV and TXT) to database.

Create packages to migrate data from oracle to SQL server.

Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.

Proficient in Creating, Configuring ETL workflows designed in MS SQL Server Integration Services (SSIS).

Proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL Server.

Maintaining the Log and Audit information in SQL tables, experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages

Generated different SSIS packages using transformations such as fuzzy lookup, derived column and slowly changing Dimensions (SCD) to perform different business requirements.

Designed and developed dynamic SSIS packages to process dynamic queries and dynamically produce flat files at runtime.

Migrated data to transfer database objects among servers using different SSIS packages in Business Intelligence Development Studio (BIDS).

Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Sorting the data, defining data source and subtotals for the respective reports using SSRS 2008R2/2008.

Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports. Generated different reports such as parameterized reports, drill through reports, matrix reports, linked reports in SSRS.

Deployed reports on report manager and created different report models for the users to generate and customize ad-hoc reports.

Defined granularity within a measure group and drill through actions using SSRS 2005/2008.

Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.

Worked on with Report Manager, Report Builder, and Reporting Security and Reporting Services Configuration manager.

Involved in designing and implementing Parameterized Reports for generating Ad-Hoc SSRS reports as per the client requirements.

Tools: T-SQL, Query Analyzer, SQL Server 2008 Enterprise Edition, Windows 2003 advance server, SSIS, SSRS, C#, MS Access, Visual Studio 2008, and Windows.

Education Details:

Master of Science in Information Technology from Concordia University Wisconsin – May 2018

Bachelor of Commerce from Osmania University Hyderabad -2012

Contact this candidate