Resume

Sign in

Data Sql

Location:
Falls Church, Virginia, United States
Posted:
August 13, 2018

Contact this candidate

Resume:

Falls Church, VA

( : 571-***-****

*: sheraz_b_*001 @yahoo.com

Sheraz Baig Mirza

Summary

Over 14 years of experience in working as a data person(Overall 15 years in IT) with detail oriented, analytical and troubleshooting experience in different aspect of SQL Server and Oracle Development, SQL Server installation and configurations, SQL Server Integration Services (SSIS), data modeling, DR (Disaster Recovery) Solution, backup/recovery, performance tuning, stored procedures, triggers, functions, constraints, indexes, statistics etc.

Experience of logical and physical data modeling, using tools like Erwin, ER Studio for data design, architecture, designing Star and Snowflake Schemas and creating data dictionaries; normalization and de-normalization techniques.

Expertise in TSQL programming and have created various SQL objects like stored procedures, triggers, user-defined functions, tables, views, cursors, constraints, and write other complex DML and DDL commands.

Solid working experience in managing large databases in 24/7 data processing environment. Data Modeling, and Performance Tuning using different Tools like Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, and Activity Monitor.

Data modeling experience in Physical and logical data modeling, Reverse Engineering, Forward Engineering by using Erwin Data Modeler, Toad Data Modeler and Microsoft Visio

Experience in upgrading and migrating the databases, backups & recovery, managing security, creating and managing users, roles, groups and assigning necessary permissions, and refreshing data across environments.

Working with different datasets (Flat files, MSExcel, Data Tables), working in some VBA Scripts to manipulate excel data.

Worked as front end developer by using Oracle Forms and reports by using Oracle Developer Rel 6i.

Worked on Reporting Tools like SSRS, Oracle Reports6i and Data Visualization via Tableau.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL Server

Experience of full System Development Life Cycle (SDLC) including system study, system analysis & evaluating business process, designing, development, testing, implementation & documentation of Client/Server applications.

Experience in Powershell scripts(specially data related) to convert, insert or process data.

Experience in batch files to call stored procedures, or any other required objective.

Technical Skills

Databases : SQL Server, Oracle9i/10g, MS-Access.

Other Tools : Aqua Data Studio, SQL Navigator, TOAD, SSDT, SQL Server Profiler, Tableau, PDFConverter, Notepad++,

Languages : C++, HTML, Shell, SQL, T-SQL, PL/SQL

Microsoft Tools : MS-Office

Operating System : UNIX, Linux, Windows XP/VISTA/Windows 10

Version Control : Visual Source Safe, IBM Clear case

Burgess Group, VA Jan 2016 – Present

Data Analyst

Description: As part of Product Development team, Data Analyst, Advisory plans, analyzes, creates and executes update plans for Burgess™ application solutions in accordance to company Software Development standards. The individual is able to consistently demonstrate the ability to deliver at a high level of competency in database development and software performance improvements as well as understand Healthcare claims processing technologies.

Work closely with Software Development and Medicare and Medicaid Reimbursement Research, to translate reimbursement content changes into technical specifications for software product updates/modifications. Draft technical specifications of business requirements.

Develop and maintain proficiency in Medicare, Medicaid and other public reimbursement-related data such as: claims data for various health care products and services, provider-specific cost data, “reimbursement weights”, relative value units, wage indices, billing and reimbursement codes.

Develop and maintain proficiency in the Company’s products (software, data) and services.

Perform varied Web-based research of reimbursement-related healthcare industry databases, summarizing and commenting on the results.

Insure secure management of client data and compliance with company security policies.

Actively seek and recommend improvement to the data update process and documentation.

Transfer data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2008 and later versions.

Extract Transform Load (ETL) development using SQL server and Integration Services (SSIS)to develop jobs for extracting, cleaning, transforming and loading data as part of software update cycles

Actively cultivate and maintain collaborative relationships with key technical and business stakeholders in order to collect and disseminate knowledge.

Analyze and query multiple, complex databases and systems to produce reports and databases. Create and edit databases, spreadsheets and other forms of healthcare payment data.

Recognize, investigate, and resolve data discrepancies and anomalies.

Analyzes raw data, draws conclusions and provides recommendations.

Participate in software database quality assurance and testing.

Provide data support – serve as a technical resource in resolving client issues related to database or other data issues.

State Dept of Corrections, KS Jan 2015 – Jan 2016

SQL Developer/DBA

Description:

Having Special Assignment of Migrating Legacy databases to the new system, responsible for all lifecycle i.e. Analyzing data, Modifying new systems, Modeling and Re-Modeling of new system, Creating SSIS Packages for ETL process.

Involved in routine DBA tasks Managing DBs, Logins, User Accesses, Development Support, Index Management, Statistics etc.

Involved in Migration Process Analyzing, Designing and Implementation from legacy to updated versions of databases.

Involved in Data Cleansing process, by detecting so many anomalies in current legacy system, capturing duplicates and analyzing its effects on data processing.

Using SSMA, MS-Access Upsizing Wizard and 2SQL for Data Transfer, Data Conversion from MS-Access to SQL Server.

Installed and configured SQL server 2008R2 and SQL Server 2012 on Windows Server2008 and Windows Server2008R2, applied service packs and security fixes.

Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.

Responsible for configuring and maintaining Database Mirroring and Log Shipping

Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server

Strong experience on user management, assigning permissions & roles

Working with SSIS and DTS package to import & export operations in and out of the SQL Servers.

Blue Cross Blue Shield, Jacksonville, FL Dec2011–Nov 2014

SQL Data Analyst:

Description: Project deals with building a platform that supports Claims Processing and grouping for the client data. Worked closely with senior executives to conceptualize, globalize, redesign certain Business functionalities like Providing Bulk Uploads for Data, Generation of Templates in Excel (with script) used by the business to directly upload the data in tables, Creating Scripts for DDL and DML Statements etc. And Supporting Third Party Tool (Ingenix Products like EasyGroup Grouper, Editor, Pricer, Inpatient Data, Outpatient Data etc.) giving for data integration, grouping and pricing etc. Version Control activities.

Participated in all phases of development like System Analysis, Design, Coding, Development and Implementation and provide support to existing client databases

Strong expertise in establishing QA policies, procedures, strategies, developing appropriate process and team to ensure the quality of product.

Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance

Coordinated and created all database change modifications and new object creations required by other programmers.

Extracting data from heterogeneous source systems like Flat files, Excel files, XML, from relational sources like SQL Server, MS-Access

Writing some SQL Analytical Functions by using Partition By, Over, Order by etc.

Involved in Verification and Validation of different work products

Developed procedures for structured walkthroughs, reviews, and testing to carry out validation and verification functions.

Proper versioning the code by using IBM Clear Case.

Environment: Microsoft SQL-Server 2008R2, 2012, Oracle 10g/11g, Windows 2008/XP, PL/SQL, SQL*PLUS, SQL*Loader, SQL Navigator, IBM Clear Case, MS SQL SERVER 2005/2008,Erwin, MS Outlook 2000/2003, MS Communicator

Ceres Tech Inc. VA Nov2010–Nov2011

Data Analyst.

Description: The company was supporting many clients by providing them different consultants to manage their work. I was working in Database Analysis and Development Department.

The position involved interaction with the end users and writing the new specifications and creating the new processes by using PL/SQL and UNIX. Responsible for logical and physical design of components, Query optimization, Performance tuning, automating Data extraction and cleansing from data warehouse, generating daily, weekly and monthly reports of customers, sales, Usage, promotions data that are used by executives and several departments

Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and maintained logs for the results.

Used Aqua Data Studio for Data Conversions and to load the flat files from other different sources

Used Oracle Reports 10g to generate monthly customer and sales report.

Wrote stored procedures and triggers in Oracle forms to facilitate insert, update and deletion of records from the underlying base tables.

Built Interface program to load the legacy Customer Management tool info from SYBASE and ORACLE 8 into Oracle 10g tables. Created PL/SQL Packages, Procedures and Functions

Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database

Involved in writing Test Cases and Test Scripts for Manual Testing from Use Cases

Wrote complex SQL queries to perform the Back End testing of the Oracle database using SQL and UNIX shell commands. Also, Back-end testing using SQL queries to verify the database integrity

Wrote SQL queries to perform Data Validation and Data Integrity testing.

Validated PL/SQL scripts that performed data loading into the ODS System.

Environment: T-SQL, SQL-Plus, PL/SQL, SQL*Loader, Oracle 10/11g, UNIX (Sun Solaris 2.8), Erwin, Oracle Forms and Reports

V-Net IT Solution AUG 2007–Nov 2010

Database Manager:

Roles and Responsibilities:

•Extensively involved in PL/SQL programming on Oracle 9i database engine.

•Provide database design support for new system development set.

•Set oracle standards for object names and usage.

•Front end development by using Developers 6i, Forms and Reports development.

•Making Strategies for SQL-Server Database Backup and Managing Recovery Plans, Disaster Recovery.

•Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication

•Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL Server

•Worked extensively on creating tables, Views, SQL stored procedures, functions, triggers and packages using PL/SQL.

•Used SQL Developer as an Oracle developer tool.

•Extensively worked on database cursors and collections in Oracle database.

Environment: Oracle 10g/11g, Developer 6i, SQL-Server, PL/SQL, MS Office, Windows XP

Era-Solve IT Solution, U.A.E. Jan 2004 – Aug 2007

Team Lead-Oracle Development

Era-Solve is a large Software Development Company of Abu-Dhabi, U.A.E. with its different solutions already running in the market with different clients, in Healthcare Industries. Main clients are Al-Jazeera Hospital. Sheikh Zaid Hospital Dubai, and Al-Ain Medical Center.

•Involved in preparing business requirement documents, technical specifications and data flow documents.

•Coordinated with the business users to collect requirements.

•Working on Oracle front end Forms and Reports by using Developer 6i Application.

•Created PL/SQL stored procedures, functions and packages for moving the data from staging.

•worked on logical and physical data modeling and created Materialized views.

•Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.

•Wrote SQL, PL/SQL queries, functions and triggers

•Utilized tools like Aqua Data Studio during development of the application.

•worked on performance issues while data loading process.

•Wrote SQL queries to test the data population from the tables according to business requirements.

•Performed data validation with data profiling. Involved in System Testing and User Acceptance Testing. Conducted manual testing for checking functionality, security and regression during the various phases of the development of the online application

Environment: SQL, PL/SQL, ORACLE 11g, Aqua Data Studio, MS-Office 2000,ERWin 2000,Windows 2000,UNIX

National Database and Registration Authority (NADRA)May2001 – Dec2003

System Engineer.

Roles and Responsibilities:

To look after the Technical/Management aspects of the site.

Management of NSRC Network, System and Databases and WAN connectivity with NADRA HQ.

Database Backup, Security and Disaster Recovery Planning, data transferring to data warehouse.

Implementation of RAID1 / RAID5 for data recovery. Managing network security by

omanaging groups and user. Installing and configuring new hardware / software on active

oLAN.Scripting (Batch Files).

Strong knowledge and working experience in Database Backup and Disaster Recovery.

User Creation and Rights Administration by using Active Directory.

On the spot Query Generation for any critical data requirement.

Reading log files for error handling.

Query Optimization for fast and Prompt data enquiry.

Environment: SQL Server 7, Oracle 9i, MS Office, Windows XP, Unix

BLOGS:

http://www.sqlservercentral.com/search/?q=sheraz+mirza

Education:

Masters in Computer Sciences in 2001.

Oracle Certified Professional (Developer Track Rel 2.1 and 6i)

Microsoft Certified Professional.

References:Will be Provided on request.



Contact this candidate