Rizwan Mubeen

Email id: ad3fhq@r.postjobfree.com

contact no: 773-***-****

Summary:

Over 6 years of IT Experience as MS SQL Server Developer, and involved in Design, Development and Support of MSSQL Server for various business domains like Pharmaceuticals, Constructions, financial services and Health Care.

Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Experience in SDLC and Agile environments of project including requirement gathering, creating technical specifications, development and testing of end product.

Involved in Migrating MYSQL to SQL Server 2008 databases.

Experience in installing and configuring SQL Server […] […] SQL Server versions.

Experienced in writing complex SQL queries which involves multiple tables' joins, common table expressions (CTEs), user defined functions, indexed views, cursors and DDL/DML triggers for data consistency and data manipulation according to the business and configuration prerequisites utilizing T-SQL.

Experience in advanced T-SQL features like Merge, Try-Catch, sequence objects and Column stored indexes.

Experience in performance tuning using Index strategies, Data profiling and analyzing execution plans.

Hands on experience in using SSIS transformations like Aggregate, Row Count, Data Conversion, Lookup, Merge, Union all, Derived Column, Multi Cast, OLEDB Command and Conditional Split in different scenarios.

Tested the changes for the front end screens in FACETS related to following modules, test the FACETS batches.

Experience with data modeling Erwin tools, entity relationship diagrams and data analysis concepts on data warehouse.

Experience in using features like logging, event handlers, configuration files and deployment of SSIS packages.

Experience in Data Migration processing including data loading from flat files to the database tables using SQL Loader.

Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.

Used Erwin modeling tool for designing database objects.

Skills

Software Development, SQL, Database Management, codereview, unit testing, dao, Oracle, Web Services, ide, Business Development.

Levi Strauss & Co Oct 2022-Present

SQL Developer

Project Abstract - The objective of the project was to implement a mobile point of sale solution in the brick and mortar stores in Levi Strauss & Co. Asia pacific division. Apart from improving customer engagement and driving sales the mobile solution was expected to ease back office functionalities like inventory receiving and physical inventory.

Responsibilities –

As an application developer for the project, the following were some of my key responsibilities

Analyzing clients existing systems and business models

Mapping and Documenting interfaces between legacy and new systems

Developing complex queries, stored procedures, UDFs in support of the ETL processes, front end applications and reports.

Developing and optimizing SQL queries using SQL Server profiler, indexed views and indexes.

Creating ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loading data into destination tables by performing different kinds of transformations using SSIS packages

Analyzing complex business reporting and data requirement to be solved with automated data processing to support business solutions

Investigating data issues and recommending solutions based on operational constraints

Generating custom SQL reports to address ad-hoc requests from Business communities

Basic usage of Visio for representation of data model

Designing, developing and implementing database processes and programs to import, export and process data for reporting and analysis

Overseeing implementation of a new system including data migration

Supporting users on change control and system updates and training support/ QA team members.

Tools & Technologies -MS SQL server 2008/2012, MS Visual Studio 2010, SSIS, SSRS, Visio, MS Excel, VBA, ETL, asp .net

AudLink, Minneapolis, MN Aug 2020-Sep 2022

SQL Developer

Responsibilities:

Responsible for gathering/refining requirements from the customer for developing reports.

Developed functions, procedures, and packages to implement the system's business logic using PL/SQL.

Handled the responsibility for the physical as well as logical design on the storage media.

Analyzed data access controls and provided suggestions in enhancing the security.

Created and managed the database triggers and subprograms.

Provided training to the managers in using the system, generating reports, and executing complex queries.

Evaluated, examined, and implemented user roles and assigned relative database access privileges

Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Created Grouping, sorting columns and writing expressions as per the business requirements.

Transferred the data using SSIS packages.

Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS.

Created new tables, written stored procedures for applications developers and some user defined functions and created SQL scripts

Created SSIS packages to Export data from text file to SQL Server Database.

Created SQL Server Reports and developed query for generating drill down and drill through reports using

SSRS.

Generated Reports using Global Variables, Expressions, and Functions for the reports.

Monitored Scheduled jobs and alerts.

Environment: MS SQL Server 2008/2012 Enterprise Edition, MS SQL Server Reporting Services 2012, Pervasive, Windows Server 2007.

Hess Corporation, Houston, TX Feb 2017- July 2020

SQL Developer

The Hess Corporation is an American integrated oil company headquartered in New York City, and a Fortune 100 corporation. The company explores, produces, transports, and refines crude oil and natural gas. The aim of project to create a data warehouse, which uses various data sources (SQL Server 2008R2/2008 and Oracle) to provide valuable information to discover its needs and provide the information to the marketing department to aid them and identifying customer needs that may be also satisfied by existing quality.

Responsibilities:

Worked with complex SQL statements using joins, sub queries and correlated sub queries for report generations using SSRS.

Designed and developed monthly, quarterly and yearly reports at branch and bank level.

Involved in creation of data modeling techniques and set up SQL Server configuration settings.

Analyzed complex queries and tune the same to optimize application and system performance.

Created tables, perform DDL changes, complex data migration using SQL and T- SQL for the environment.

Experience in Logical Data Modelling and Entity relationship diagram (ERD)

Coordinated with DBA in creating and managing tables, indexes, triggers etc.,

Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.

Involved in converting all existing earlier versions of SQL Server DTS packages by using different SSIS tasks.

MySQL best practice engine, demon variable configuration and optimization

Worked with different methods of logging in SSIS.

Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.

Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.

Developed custom transformations with VB6 code to load data from Oracle to SQL Server.

Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.

Configured Database Mail for sending automatic emails when a SSIS package is failed or succeed.

Defined and deployed new web applications on classic Asp.NET with help from other teams.

Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.

MySQL, PL/SQL, SQL (DDL, DML), XML, shell programming code development.

Data conversion from any data source to MySQL database - custom code development configuration and implementation

Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

Have deployed packages on different servers by configuring it.

Optimized long running Stored Procedures and Queries for effective data retrieval.

Involved in Data migration, development and implementation of SSIS on an enterprise level.

Environment: SQL Server 2005/2008/2012, T-SQL, SQL Profiler, SSIS, SSRS, MS Visio, MS Excel, Enterprise Manager, SharePoint server 2007.

Contact this candidate