Sql Server Data

BASHIR F. SIDDIQUI

Phone: 773-***-****

******.****@*****.***

Experience Summary:

Microsoft Certified Technical Associate (MTA) with over 3 years of SQL Developer experience in Database and Business intelligence solutions (SSIS/SSRS) with Microsoft SQL server in development, testing & production environment.

Worked on maintaining, updating, debugging, and optimizing the existing databases and creating reports according to the business requirements.

Designed various reports such as Parameterized Reports, Matrix reports, Tabular Reports, Sub reports, Graph reports and Ad-hoc reports to enable management to make business decisions based on data.

Developed SSIS Packages to Extract, Transform and Load (ETL) data for integration using OLE DB connection from Heterogeneous databases such as Oracle, DB2, Flat Files, Excel and MS Access.

Created various database objects such as Stored Procedures, Views, Triggers, and UDF for validating the integrity of the data and implementing the business rules.

Performed back end testing by executing SQL Queries into SQL Server.

Conversant with all phases of SDLC involving Planning, Requirement Gathering and Analysis, Designing, Developing, Testing and Deployment.

Excellent communication & analytical skills, result oriented even in challenging situations, great team player, quick learner with creative ideas.

Professional Experience:

Echo Global Logistics, Chicago, IL

Junior Database Developer/Report Developer Feb 2017 - Present

As a Junior Database/ Report Developer in the Echo Global Logistics Data team, I contribute to database management of large scale web-based applications to enable Echo’s business while supporting architectural vision of quality, scalability, performance and function.

Projects summaries and responsibilities are elaborated below:

Refactor Project

Goal was to refactor the most inefficient reports to increase the efficiency & productivity by replacing the text queries on all Reports with the Stored Procedure (SP).

To analyze these reports, collected the data metrics like number of executions, subscriptions, status on those executions, date of last run, status on users, render type, parent/child dependencies, etc.

After analyzing these reports, created & ran the test cases on these existing reports prior to the refactoring.

Debugged the reports that were not working due to deprecated SPs, missing parameter’s values or no default / incorrect default values and no values in data filters.

While debugging, found broken SPs due to; deprecated tables, missing schemas, or referencing to missing tables or databases.

Re-ran the test cases on refactored reports in QA to ensure all the reports run in efficient manner and didn’t break any functionality.

Gathered and identified business requirements to set functional specifications, design, implement, test, and deploy a solution for reporting applications.

Enhanced the existing complex Drill down & Drill Through reports, Parameterized reports, Matrix reports, Tabular reports, Sub reports, and Ad-hoc reports by adding the requested columns and filters using SSRS.

Developed stored procedures, queries and views necessary to support SSRS reports.

Wrote and executed complex T-SQL queries using SQL Server Management Studio to test the data generated by the application for internal testing purpose.

DeadEndCode Project:

Database projects encounter warnings and errors at build time due to various reasons, which contributes to more time for overall build and adds complexity to the build and release cycle. In this cleanup effort, the intent was to eliminate errors and minimize warnings. Over past 6 months with 7 releases, worked with several teams such as DevOps, QA, and other development teams to address these issue and eliminated all the errors and brought the warnings in the Visual Studio down to zero for most of these projects.

Researched all incomplete code resulting in errors within the boundaries of scope. There were total of 17 databases and over 1,000 objects involved in this project.

Started resolving Object/Code dependencies and other issues and QA tested.

Created required release branches in SVN.

Scheduled release without impacting other teams.

Deployed to production.

Performance Tracking Process:

In this project a SQL Job will move a file from FTP to the shared drive and import it into a database. This database allows HR to track employee changes and see what impact it has on their ability to perform their job. This data will be used for analysis and reporting by the Strategic Analytics Team for HR.

The SQL job executes a SSIS Package.

The SSIS Package checks the FTP for one csv file.

The Data Flow task imports the data from the csv file to the Stage table.

The stored procedure processes the data.

It is stored as a type 2 slowly-changing dimension, meaning if there is a change to one of the tracked fields, a new row is inserted into the table and the old row is marked as inactive.

Northeastern Illinois University, Chicago, IL

MS SQL & SSRS Developer (Office Support Associate & Record Administrator), June 2014 – Jan 2017

As a part of the Record Management team, my role requires a broad range of skills and the ability to step into different roles depending on the size and scope of the projects.

Projects summaries and responsibilities are elaborated below:

Reporting Solutions for Student Application:

Developed different type of reports including: Major/Minor Declaration Reports, Advisee per Advisor Reports, Graduated per semester Reports, Enrollment Count Reports, Transfer Student Reports, Student Status Report, Active Students Reports etc. by using SSRS and SQL Server 2008R2/2012.

Created different database objects like Tables, Stored Procedures, Views, Triggers, and User Defined functions using T-SQL to implement the business logic.

ETL Solutions for Vendors Invoices:

Generated SSIS Packages to export and import Vendor Invoices data from CSV files, Text files and Excel Spreadsheets by using various control flow task and data flow transformation.

Involved in designing High Level of ETL Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge, For Loop, Container, and Derived Columns.

Worked on Data Cleansing, Data Scrubbing and Data Migration.

Designing & Developing Student Application:

Involved in reverse engineering of the MS Access application i.e. digging into the legacy application to understand the data flow and work flow and then trying to replicate the same functionality into the new SQL Server application along with the new business requirements. Created table structure into DB.

Involved in normalization of the database in OLTP.

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases. Used aggregate strategies to aggregate data.

Developed Data Dictionary. Documented and maintained database system specifications, diagrams, and charts.

Northeastern Illinois University, Chicago, IL

Office Support Associate & Record Administrator, June 2009 – May 2014

Primary duties included but not limited to:

Developed university-wide databases for various departments to streamline data entry and maintaining the databases through the use of Microsoft Access including forms, filters, reports, tables, and queries.

Wrote queries and generated various reports as per department needs and worked with end users to develop Ad-hoc reports using Access reporting tools.

Collaborated with Stakeholders to define functional and technical requirements.

Extensively used MS Excel to do data analysis and created graphs and charts in Excel showing trends over a time period and presented to the higher management.

Migrated data from the existing Excel sheets to the developed databases in Access.

Worked with business users, programmers, testing staff, and database administrators to develop database requirements, test plans and database schemas to transition MS Access databases to SQL Server.

Technical Skills:

Skills

Databases: SQL Server 2008R2/2012, Microsoft Access, Oracle

BI Tools: Microsoft BI Suite (SSIS, SSRS)

SQL Server Tools: SQL Profiler, Activity Monitor, SQL Query Analyzer, Import/Export Wizard, Performance Monitor, Database Engine Tuning Advisor

Data Modeling Tools: Erwin Data Modeler, MS Visio

PeopleSoft Tools: PeopleSoft HRMS module, People Tools, Application Designer etc.

Languages: T-SQL, HTML, C++, Visual Basic

Education:

Northeastern Illinois University, Chicago, IL

Master of Computer Science, Aug 2006

Bachelor of Computer Science, Aug 2000

Certifications:

Microsoft Technology Associate, July 2016, Certification No: F770-3045

Contact this candidate