BI/SQL Developer with .NET Expertise

Ayaz Niazi

**** ****** **** ******, ******** ****4 847-***-**** *********@*****.***

Qualifications Profile

Expertise in Relational database design, and programming techniques using SQL.

Troubleshooting OBIEE reports and creating reports from scratch.

Worked on T-SQL in OBIEE reports

Validating OBIEE report outputs and comparison between older platforms

Worked extensively on the BI stack (SSRS/SSIS/SSAS).

Strong experience working on modifying, updating SSRS reports.

Excellent on working with SSIS packages..

Superior interpersonal communication abilities contributing to exceptional teamwork and customer service.

Excellent multi-tasking skills aided by focused approach to prioritization and time management.

Well-organized self-starter with proven ability to quickly learn and apply new technologies.

Good exposure to SQL Server environments.

Strong development skills in the .NET framework using C#

Strong experience in coding, designing in MS SQL Server SQL and stored procedures.

Strong experience in both web and winform applications.

Strong experience with concepts, procedures for software development.

Good understanding of Agile methodologies.

Excellent verbal and written communicational skills.

Strong experience working independently and in team environments.

Experience in programming and software development of custom applications using ASP.NET, ADO.NET, Visual C# .NET, VB.NET and MS SQL SERVER.

Expertise in 3-tier Client/Server development architecture.

Expertise in Code reviews, defining coding standards and performance optimization using .NET technologies.

Strong understanding of Ajax, LINQ and .NET 3.5 technologies.

Technical Competencies

Databases: SQL Server 2014, SQL Server 2008, SQL Server 2005, Oracle 8.0i, Oracle Designer, ToadOracle.

Languages: Visual Basic, C++, C#, VB.NET, Visual Basic 6.0, VBA.

BI Stack: SSRS, SSIS, SSAS, BIDS 2005, Visual Studio 2012, Visual Studio 2017

Applications: ASP.NET 2.0, ASP.NET 1.1, Visual Studio 2005, Visual Studio 2008, .NET Framework 3.5,.NET Framework 2.0, .NET Framework 1.1, MS Office APIS, Adobe Acrobat, MS Visio & FrontPage.

Education

Master in Information System Management, 2011

Keller Graduate School of Management. Chicago, IL

Bachelor of Science in Information and Decision Sciences, 2002

The University of Illinois at Chicago. Chicago, IL

Professional Experience

Southern Company Gas- Full time Feb 2022-Jan 2026

Data Analyst/Production Support

Involved in the RNI cutover project. Validated data during pre and post cutover process.

Created/Modified different SSIS packages in the GAMI project.

Worked on troubleshooting different AutoSys jobs in GAMI and RNI.

Created documentation on different AutoSys jobs and their processes

Worked on understand and monitoring the CMEP process. Monitoring weekly CMEP files and provided update to the business on data anomalies.

Involved in replacing old process with PowerShell, and recoding them using in SSIS.

Involved int enhancing different process/ with notification processing using SSIS.

Understanding/Working of the MHS portal system which is similar to the EMS tool

Performed data repairs on different client related issues

Abbvie Jan 2021-2022

Data Analyst

Data validation for data originating from different sources

Identifying anomalies between different sources

Using data to generate different reports in Spotfire and analyze different patterns

Running SAP queries to resolve data anomalies

Writing SQL queries for comparison of different data sources

Performing data fixes and coming up ideas for automation

Rapid7, Boston(remote) Sept 2020-Nov2020

Data Analyst/Data Modeller

Involved in data modeling with SQL in a production data warehouse environment.

Involved in building tables, data structures and views using T-SQL, MySQL

Involved in documentation in Confluence and creating ERDS that represent the newly created model

Worked on different data requests from the business unit

Created the data model using these integrated data of the front end(Pendo) into Snowflake database.

Documented and created ERD for the data model

Worked with a team and worked on tasks in a two week sprint. Worked specifically on JIRA for updates.

Wrote store procedures in Snowflake by consolidating different queries and automating them for future use.

Optimized SQL queries in the Snowflake database for better performance.

ComEd/Calico Energy, Oakbrook Terrace IL April 2017 – Feb 2020

BI Data Analyst

Worked as a Calico contractor for ComEd projects in the Demand response and Energy Efficiency department

Developed SQL queries for analyzing energy data for customers that performed in the rebate program.

Analyzed data to remove anomalies and duplicates

Created SSIS packages for generating customer files.

Worked on OBIEE in creating reports

Involved in conversion of reports from OBIEE to Hypherion

Troubleshooting reports in the OBIEE environment

Worked on documentation of different data processes

Worked on PowerBI reports for data presentation purposes

Involved in training other developers towards OBIEE.

Heitman LLC. Chicago, IL Nov 2016 – Feb 2017

Data Analyst

Modified store procedures, SQL scripts to automate different processes for clients.

Worked with the clients on follow up on different requirements.

Involved in data load using SSIS/SQL.

Involved in modifying and creating SSIS packages.

Monitoring SQL jobs and troubleshooting issues for clients.

PNC Bank Downers Grove, IL Jan 2016 – Sep 2016

SQL Server/SSRS Developer

Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Generated several drill down and drill through reports using SSRS.

Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Created SQL server Reports using SSRS 2008.Identified the data source and defined them to build the data source views.

Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS.

Created Parameterized reports, Cross-Tab reports, Drill down reports & summary reports by using SSRS.

Applied conditional formatting in SSRS to highlight key areas in the report data.

Work with BAs, DBAs and other Developers to understand the existing system.

Scheduled the reports to run on daily, weekly basis in the report manager.

Enterprise Recovery Systems Woodridge, IL Aug 2015 – Nov 2015

SQL Server/BI Developer

Collect, store, and retrieve business data for analysis and reporting.

Collaborate with the BI team for development of BI architecture and components.

Define the scope, use, and requirements of business data warehousing.

Determine business and systems requirements and create reports.

Solve technical problems related to data and guide team members.

Develop and implement best practices in creating BI solutions.

Collaborated with business users, understood and delivered their reporting needs.

Developed and maintained reporting infrastructure and documented technical specifications.

Worked closely with business analysts and developers on BI projects.

Assisted the QA team in creating and validating reporting parameters and deliverables.

Fixed the bugs present in already existing reports.

Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS).

Identified and worked with Parameters for parameterized reports in SSRS 2005.

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

Deployed the generated reports directly on the client’s workstation.

Created many multi valued parameters in the reports.

Created many Cascaded parameters in the reports using MDX and T-SQL.

Improved Report Performance and performed unit testing.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data,normalized tables, established joins and created indexes whenever necessary.

Modified existing reports according to requirements of the end users.

Modified, updated SSIS packages that were used for File Processing

Involved in troubleshooting issues related to the cube.

Environment: SSIS, SQL Server 2008, SSIS, SSAS, SQL Server Business Intelligence Studio.

RR Donnelley Warrenville, IL Oct 2014 – July 2015

SQL Server Developer

Backend development using SQL Server 2012. Mainly involved in writing, modifying store procedures, views.

Involved in the merge of two environments. Included clean-up of data and modifying store procedures to suit the new merge.

Worked on different enhancement projects for users that allowed modification in the back-end side.

Used C# as one of the middle tier languages in modifying newer features.

Involved in working on different production requests for users.

Worked on resolving replication issues i.e. modifying table structures, store procedures.

Involved in minor enhancements on the front layer using jQuery.

Eddie Bauer Westmont, IL May 2014 – Oct 2014

SQL/SSIS Developer

Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.

Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.

Used Execution Plan to optimize queries and enhance the performance of databases.

Use the SQL analyzer, and Profiler for studying the SQL statements and procedures.

Experience in SQL joins, sub queries, and performance tuning for better running of queries.

Designed SSIS Packages to transfer data to flat files from SQL Server using Business Intelligence Development Studio.

Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Linked business processes to organizational objectives, performing critical path analysis, analysing ER diagrams.

Used SSRS to develop different kinds of reports like ad-hoc reports and parameterized reports for their different stores.

Worked on formatting SSRS reports using the Global variables and expressions.

Environment: SSIS, SQL Server 2008, SSIS, SSRS, ASP.NET 3.5, Visual Studio 2010, SQL Server Business Intelligence Studio

Bank of America Chicago, IL Feb 2013 – May 2014

Application Developer

Part of a team working on the ARM(Access Request Management) tool. The project involved collaboration of four site holders with the existing ARM tool.

Involved in development, coding and modification of store procedures with SQL Server as the back end.

Involved in all different phases of the SDLC

Working on analyzing business requirements and estimating deadlines during the requirements phase.

Worked on developing and modifying SSIS packages

Involved in application development of the front UI using ExtJS.

Worked on the Business layer using the MVC framework

Involved in Unit testing and developing test cases in the NUnit framework.

Communicated technical and non-technical information to the clients.

Replicated different servers during the deployment phase.

Environment: SSIS, SQL Server 2008, SQL Server 2005 ASP.NET 3.5,, Visual Studio 2010, Team Foundation Server,, ExtJS, JavaScript, AJAX, IIS

JPMorgan Chase Chicago, IL Feb 2012 – Feb2013

Production Support Engineer

Provided in-depth analysis to resolve production and application issues.

Involved in modifying code in existing DTS packages for client fixes.

Analyzed production support related issues, inquiries and requests.

Provided a concrete explanation of resolutions to issues, inquiries and requests.

Managed to works in group and independently on side projects.

Troubleshot problems involving timeliness of services.

Communicated technical and non-technical information.

Involved in implementing different projects related to code fixes

Worked with the project manager to ensure deadlines were met related to the different projects

Worked with the QA team to review fixes and test plans.

Environment: Environment: Windows Server 2008, SQL Server 2005, SSIS, SSRS, ASP.NET 3.5, ASP.NET 2.0, ADO.NET, Visual Studio 2010, Team Foundation Server.

JSSI Chicago, IL June 2010 – Dec 2011

ASP.NET Developer

Modified the distributed applications which involved CRM and Great Plains

Strong understanding of the CRM system.

Worked with the Sales department in troubleshooting CRM related issues

Working on creating workflow that allowed integration of two systems

Workflows were created by modifying code in C# and SQL Server,

Involved in code review and testing

Modified stored procedures in SQL Server

Strong experience in SQL Server Management Studio(SSMS)

Worked with senior developers as a team providing documentation of code

Modified code using Visual Source Safe

Worked with senior .net developers to create documentation

Worked with SharePoint Report Center for organizing and managing reports

SharePoint was used for displaying business data in dynamic dashboards

Interacted with the end users on scope requirements

Environment:, ASP.NET 3.5, ADO.NET, Visual Studio 2008, Visual Source Safe, WF, SQL Server 2005, CRM, Great Plains, SharePoint, SSMS.

Synovate Chicago, IL May 2009 – April 2010

ASP.NET Developer

Involved in software development using Agile methodologies

Gathered requirement from clients to have an understanding of the system.

Worked on the .NET framework 2.0 using C# as the code-behind.

Had a strong understanding of object orientated analysis and design.

Designed html pages.

Created technical specifications and design documents.

Participated in design reviews.

Provided end user support and training.

Involved in troubleshooting of different system related issues.

SQL Server 2005 was used as the back-end.

Conducted design and integration walk-thru reviews with end users.

Worked with SharePoint for document management.

Environment:. C#, ASP.NET 2.0, SQL Server 2005, ADO.NET, Visual Studio 2008, XML, HTML,CSS, SharePoint, SSMS

R-Square Inc. Princeton, NJ Jan 2007 – Mar 2009

ASP.NET/Web Developer (Design and Development)

Had a strong understand of Object orientated analysis and design.

Implemented an Employee tracking system allowing different validation, security, editing features.

Part of UI Layer team in creating the front-end system that could integrate with their agile system.

Created the Business Services Platform solution using Microsoft Visual Studio 2005 and the Microsoft .NET Framework 2.0 and deployed Microsoft SQL Server 2005 Enterprise Edition as a relational database.

Implemented form rendering using C# and ASP.net for code behind.

Tested the system from a perspective of a user.

End user support and training.

Worked on database integration from Oracle to SQL Server.

Environment: C#, ASP.NET 3.5,ASP.NET 2.0, ASP.net 1.1, SQL Server 2005, SQL Server 2008, ADO.NET, Visual Studio 2008, XML, HTML, CSS, Oracle

Quality Flow Inc. Northbrook, IL Jan 2002 – Oct 2006

System Analyst (Design & Development)

Integral member of project team tasked with designing new database system.

Developed user interfaces and automated data entry application using Visual Basic.

Designed different module for admin and client enabling them to perform different functions.

Admin module was mainly for internal use allowing data entry with VB controls.

Client module allowed selection of different data, using Adhoc SQL queries in VB code.

Provided database connectivity with existing and new software.

Tested software and databases.

Used Crystal Reports tool.

Siemens Building Technologies Buffalo Grove, IL May 2001 – Aug 2001

Software Design Internship

Created software installation and distribution procedures for numerous projects.

Evaluated computer hardware to ensure smooth software installation process and performed systems troubleshooting.

Wrote procedures for hardware compatibility reporting.

Modified issue tracking software.

Created PowerPoint training slides for projects and data entry purposes.

Maintained data collection reports; edited business documents.

Certifications

MCTS (Microsoft Certified Technology Specialist)

70-528 .NET Framework 2.0 Web Based Client Development

70-536 .NET Framework 2.0 Application Development Foundation

Contact this candidate