Sql Server Data

Hasina Ullah

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

Cell: 732-***-****

Professional Experience Summary

Expertise in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL Server database.

Design, development and implementation of ETL processes to load the data on Oracle OBIEE dashboard.

Strong Knowledge of data warehouse concepts and architecture. Understanding of star schema design and dimension and fact tables.

Working on writing complex SQL Query to extract data and analyze data using SSIS on SQL Server 2012/2008/2005 environment.

Extensively working on creating SSIS packages and have used Sequence and For-each-loop containers for developing processes and loaded data using different transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Script Component, Merge Join, Union All and OLEDB Command to load data into SQL Server destination.

Create and maintain excellent documentation including data dictionaries, source-to-target maps, and database policies and guidelines.

Create batch file, script file, and create jobs for SSIS packages on scheduler. Produces the log file and verify the log file

Created and maintained Stored Procedure, UDFs, Triggers, Views, and create tables including temporary tables and copy tables to perform different type’s implementation.

Strong Knowledge of data warehouse concepts and architecture. Data modeling using Erwin with good understanding of (RDBMS), as well as dimension and fact tables.

Monitoring and maintaining Query Optimization, and Performance Tuning to optimize SQL Server database performance.

Assist database administrator with backup and restoration of the database on as needed basis.

Designed and developed database using Constraints Rules, Normalization, Transaction, and Clustered, Non-Clustered, and Column store Index for data in the tables for SQL Server and Oracle database.

Proficient with software development life cycle (SDLC), including business requirements, analysis, design, development, testing, and implementation of application.

Experiencing in designing, developing, and testing large reporting system utilizing SSRS in the form of PDF, Excel, and CSV formats for each module.

Familiar with development of Multi-dimensional Objects (Cubes, Dimensions) and process them by using SQL Server Analysis Services (SSAS).

Developing knowledge of maintaining, and customizing Web applications on ASP.Net platform.

Technical Skills

Server: Remote Server

Databases: SQL Server 2012/2008/2005/2000/7.0, Oracle10g and 8.0, 7, PL/SQL, and MS Access

Tools: SSIS, SSRS, and SSAS

Languages: T-SQL, PL/SQL, Microsoft C#.NET, Microsoft VB.NET, and Java

Web Technologies: ASP.NET, C#.NET, ADO.NET, Microsoft .Net Framework 4.5/4.0/3.0, VB.NET, HTML5, DHTML, VB Script, Java Script, IIS 7.0/6.0/5.0, XML/XSL/XSLT, and CSS

Environment: Microsoft Visual Studio 2012, 2010, 2008, and 2005, and Team Foundation Server

Operating System: Windows 8.0, 7.0, Windows XP/2000, NT 4.0, and UNIX

Protocols: TCP/IP, FTP

Other Software: Remedy, TFS, Quality Center/Test Director, Quick Test Professional, PVCS, and Visual Source Safe

Professional Experience:

Senior Database/ETL Developer (Consultant) November 2015 to Present

NYC Department of Building, NY

Working on BSMART (Buildings Strategic Metrics and Reporting Technology) project to support the analytics team and senior management for the report.

Responsibilities includes:

Lead of ETL process development and reconciliation of discrepancies users may find as well supporting analytics team.

SQL Server developer and working on ETL environment using SSIS to load the data from different source including Mainframe, Oracle, Excel, Access, flat file, and one database to another database for the project of Data Warehouse. Load the data from Staging database to production database.

Involve with writing Complex SQL Queries including views, Indexed view(materialized view), CTE, Merge Join, Joins, Union, Union All and also comparing the data for different tables.

Design and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying, and dynamic configuration of SSIS packages.

Expertise in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL Server.

Archive the tables and created the package for incremental load.

Responsible on SSIS package deployment and added on the scheduler to run the package daily/weekly/monthly and troubleshoot the SSIS Packages.

Responsible for managing the ETL/FTP process and sending the files to DOIIT for Open Data and as well as sending the data files to other applicable NYC agencies from Data Share database through FTP

Supports analytical team, internal and external stakeholders to understand their data and reporting requirements.

Define and build technical and data architectures within the City’s integrated data platform including data and dimensional modeling.

Work with the application developers, and database administrators to make sure database performance, and security.

Supports the development of reports through ETL process to OBIEE

Environment: Remote Server, SSIS, Visual Studio, SQL Server Database 2012/2008/2005, and Remedy

SQL Server/ETL Developer (Consultant) March 2015 to October 2015

Segal Group, New York, NY

Worked on a Large Health Claims data warehouse, which was used for providing health data analytics to clients. The warehouse generates reports based on client’s claims experience that involve fee schedule analysis, claim audits and benchmark reports.

Responsibilities:

Involved in design, code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.

Scheduled Jobs for executing the stored SSIS packages/Master Packages which were developed to update the database on Daily/Weekly/Monthly basis using SQL Server Agent.

Wrote complex T-SQL Queries to Migrating the data from Fox Pro Database to SQL Server 2012

Created and maintained Stored Procedure, Views, Indexes, UDFs, and create tables including temporary tables and copy tables to perform different type’s implementation.

Performed in designing and developing the database using Constraints Rules, Normalization, and plan. Also, applying the data types.

Loaded the data using SSIS Package tool from different types of source including Excel, Access, flat file, and one database to another database for the project of Health Data Warehouse (HDW). Load the data from development database to Staging and production.

Experienced in extracting and documentation of ETL data mapping using source table and destination base table in SSIS.

Create different format of report including PDF File, Excel, CSV File, and Flat file using SSRS.

Experience working with healthcare, and data sets involved HIPPA with compliance standards.

Analysis and mapping the data using DQ Analyzer.

Environment: SSIS, SQL Server 2012, Visual Studio, TFS, and DQ Analyzer.

SQL Server/ETL Developer August 2014 to February 2015

Designer Greetings, Edison, NJ

The Greeting Card Shop is an online greeting card store that is dedicated to providing a more convenient way to choose, personalize, and mail paper greeting cards.

Responsibilities:

Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2008/2012

Worked on different SSRS reports for the client to view reports by Sales, Products, and Region, and viewing/analyzing Reports by fiscal year, quarterly, and annually.

Experienced in creating and generating Ad-hoc Reports, Scheduled Reports, Data extracts for business analysis using SQL Server Reporting Services (SSRS) and Excel, PDF, and CSV. Created complex Drill Down/through reports, Chart Reports, Parameterized and Matrix SSRS reports.

Developing and adding new functionality and maintaining existing Web applications to meet business requirements on ASP.Net platform in C#.

Uploading cards, and updating in the SQL Server database in production and development environment.

Working closely with offshore team at India.

Environment: SQL Server 2012/2008, SSIS, SSRS, T-SQL, C#.NET, ASP.NET, HTML 5, JavaScript, and CSS

Database Developer June 2012 to August 2014

i-Parcel, Edison, NJ

i-parcel serves as a cutting edge technology company focused on helping internet retailers with their international online shopping experience, and serves as a pioneer in low cost international delivery for ecommerce parcels.

Responsibilities:

Expertise in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL Server.

Developed, and maintained Stored Procedures, Indexes, Functions, Complex SQL Queries, Cursors, and Views using SQL Servers T-SQL.

Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying, and dynamic configuration of SSIS packages.

Experienced in designing and developing large number of enterprise reports (SSRS) using the data from ETL loads and various heterogeneous data sources.

Worked on Complex SQL Query in development and production environment including different types of joins in Microsoft SQL Server.

Developing a web application on ASP.Net using C# and the database is using. Involved in Requirement gathering, Design, Development and Testing of Web Forms.

Environment: SSIS, SSRS, SQL Server 2012, Visual Studio 2010, C#.NET, and ASP.NET.

Software Developer February 2007 to Apr 2012

Capital One, McLean, VA

The company’s primary function is credit cards, auto finance, retail, and commercial banking. Capital One is one of the 10 largest banks by deposits in the country, and a Fortune 500 company. It is a diversified bank with a broad array of financial products and services.

Responsibilities:

Developed, and maintained Stored Procedures, Indexes, and Views using SQL Servers T-SQL.

Development of SSIS Packages to extract data from various sources and send the data to the destinations including tables, flat file, and Excel.

Expertise in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL Server.

Designed and developed database using knowledge of Constraints, Normalization, and Cluster for data in the tables.

Worked on Complex SQL Query in development and production environment including different types of joins in Microsoft SQL Server.

Developing Web applications using ASP.NET, JavaScript, HTML

Environment: C#.NET, ASP.NET, SQL Server 2008/2005, and SSIS

Senior Test Engineer May 2006 - January 2007

Fort Monmouth (US Army) Eatontown, NJ

The Financial Disclosure Management System (FDM) is a web based application intended to facilitate and creation and review process of the Public Financial Disclosure and Confidential Financial Disclosure Reports.

Responsibilities:

Testing Financial Disclosure Management application using machine readable CAC Card.

Create and Edit reports for Assets, Liabilities, Investment Income, Positions, Agreements, Gifts, and Other Income as part of testing of the application.

Analyzing business requirements using Visual Source Safe and DOORS. Writing Test Plan and Test Cases based on requirements.

Test the application and verify database for all transactions made in the application using Microsoft SQL Server2005.

Environment: Microsoft SQL Server2005, Java, Quality Center, Doors 8.0, Quick Test Professional, and Microsoft Visual Source Safe. Machine Reader for using CAC Card

Database Developer and Senior QA Specialist April 2001- May 2006

EDS/Defense Manpower Data Center (DoD)

Alexandria, VA

RAPIDS (Real-Time Automated Personnel Identification System) software allows its users to create, and modify user personnel information stored in DEERS (Defense Enrollment Eligibility Reporting System) Oracle database in order to provide identification (ID) cards and related personnel support to persons who are eligible for Uniformed Services benefits. DEERS was developed in response to a congressional mandate to improve the control and distribution of available military health care services

Responsibilities:

Tested RAPIDS application using machine readable CAC Card. Testing the application against the hardware integration for Special printer for CAC Card, Camera, Fingerprint Machine for verifying the user, Scanner, and Machine Reader for using CAC Card.

Worked independently for PIV when added on the application. Used scanner for verified the documents.

Creating, and maintaining Stored Procedures, Triggers, Indexes, and Views using in Oracle. Also, wrote on Complex SQL Query in development and production environment including different types of joins in ORACLE.

Recycled, updated, and verified the card number from database.

Verify User Maintain Portal and updated the e-mail id from production application.

Verify CAC Pin Reset and updated the pin number in the production application.

Prepare reports and maintain record of bugs in the bug database (Tracker) and regress them against current version. Maintain logs of all errors found during testing cycle.

Writing test cases and executing test cases and maintaining Matrix.

Environment: Java, J2EE, XML, Visual C++, Oracle 9i, 10g, and Windows XP. Hardware: Special Printer, Camera, Fingerprint Machine, Scanner, Machine Reader for CAC Card.

Software QA Analyst October1999- February2001

Kozmo.com Inc, New York, NY

The application at Kozmo.com is web-based software. The application is written in Visual Basic on Windows NT platform and the web application was E-Commerce based.

Responsibilities:

Used SQL Load to load the in Oracle tables and Unix Platform, and frequently used Unix commands and shell scripts.

Executing SQL to verify transaction of data from front end to backend as well as to verify sanity of data. Executing DML statements to test the database.

Worked extensively with the Oracle Financials ERP System including verified data on accounts payable and worked as an AP Manager to work in the Cash Management.

Environment: Silk Radar, Oracle 8, Oracle Financial, Test Director, Windows NT.

Education: Bachelor of Science in Mathematics

Middlesex County College, Edison, NJ

Associate Degree in Computer Information Systems

Certificate in Java Programming

Status: U.S Citizen

Contact this candidate