BUSINESS & TECHNOLOGY DATA ANALYST

Data Analysis Data Quality Quality Assurance

Current State/Target State assessment

Business Requirements Assessments

Data Analytics/Visualization

End-to-end Test Execution

Data Migration / ETL Tools

Data Quality/Data Lineage

Change Management

Gap Assessments

Agile/Waterfall/Hybrid Methodologies

Certified AWS Solution Architect with over 5 year of experience in defining standards for business processes, data quality, data analysis & facilitating consistent adoption of data principles frameworks across the enterprise.

Steller history to rollout Data Quality Assurance & Data Migration projects that include development of Data Quality rulesets, ETLs, dashboards & critical data elements (CDEs).

Exposure in leading cross functional scrums & daily triage meetings using JIRA & HP ALM; Solid experience in leading end-to-end Software Development Testing including hands on experience in creation of Test Cases, Test Plans & Traceability Matrix.

Excellent Interpersonal & analytical skills with a proven ability in working with cross functional business & technology leads

TECHNICAL PROFICIENCIES

Programming Languages: SQL, VB, VB Scripting, Java, Java Script, . Net, C, C++, R, Python, HTML, CSS3, XML, Hadoop, Spark, WEKA

Database & Operating Systems: Oracle 9i, MS Access, SQL Server, MySQL, UNIX, LINUX, Win. 98, 2000 & XP, MS DOS, Windows XP/7, Java, QTP

Big Data Tools: Working knowledge of Hadoop Eco-system, YARN, HDFS, SOOOP, Hive/Impala, Kafka on Cloudera, AWS, Kinesis, Redhat,S3

Data Governance/ Quality: Ab-Initio, Data Rulesets (CDEs), Scorecard Development, Data Lineage/Tracing

Reporting & PM Tools: Tableau, JIRA, HP ALM, Selenium, Crystal Reports

Methodologies: Sys. Development Lifecycle (SDLC), Rapid Application Development (RAD), Automated Testing, Business Process Testing

EDUACATION & CERTIFICATIONS

Montclair State University (MSU), Montclair NJ, USA, 2018

Masters in Science (MS), Information Management – CGPA : 3.8/4.0

Bahria University, Pakistan, 2007

Bachelors in Science (BS), Software Engineering

Certifications

AWS Solution Architect-Associate, Amazon AWS, US, 2018

ITIL V3 Foundation, ITIL, US, 2013

PROFESSIONAL EXPERIENCE

Drew Marine, Whippany January 2019– Present

DATA ANALYST WHIPPANY-USA

Working as Data Analyst to interpret large volume of client data sets across multiple source systems & perform data quality checks as per the prescribed criteria; Managing teams in developing custom reports for management using JD Edwards & Customer Information SysteM.

KEY RESPONSIBILITIES

Create & maintain customers data on JD Edward/ Customer Information System to ensure data tracing

Create Data Flow Diagrams & update the Data Ware house on AWS

Tracking defects on a daily triage meeting for each group using JIRA & clear the blockers to make sure that data is accurately entered

Analyze different data sets using Advanced Excel, VLOOKUP & Pivot tables for executive reporting purposes

Critical Mention, Newark February 2018 – July 2018

DATA QUALITY INTERN DATA ANALYTICS NEWARK- USA

Worked as Data Quality Intern responsible to conduct Data Quality testing using leading industry best practices & tools; Responsible to validate Data Quality issues using Data Quality Scorecard & prepared error reports

KEY RESPONSIBILITIES

Validated Data Quality issues by applying Data Quality rules in source systems data &prepared DQ error report

Extracted data from database using SQL queries & performed completeness check

Checked the sever operations using Nagios & Sensu & troubleshoot the server for issues identified

Montclair State University, Montclair January 2017 – June 2017

Research Assistant – Data Quality MONTCLAIR- USA

Worked as Research Analyst responsible to conduct research on Cloud Computing & the Associated Data Quality issues; Also wrote a research paper on “how to preserve privacy in a federated cloud while performing different computations”

SILKBANK April 2010 – October 2013

Data Quality Control Analyst Chief Data Office

Worked as Data Quality Control Analyst to validate source systems data in accordance with BCBS 239 principles; Assisted teams in creation of DQ rulesets for Critical Data Elements (CDE) and helped developing DQ scorecard to assess Data Quality issues.

Developed Data Quality (DQ) dashboards & reconciliation plan to define timelines, governance across different regions

Defined DQ business rules, scorecards & designed DQ error reports to track DQ & reconciliation issues

Worked with the team in converting data from legacy system to new system with ETL

Raised defects in Quality Center & reported defects in triage meetings with IT & business users

Provided daily/weekly testing status to Project Team Stakeholders

Worked with the project team to define, write, review & sign off the test plan /test strategy

KALSOFT August 2008 – March 2010

Data Analyst Chief Data Office

Interpreted data, analyzing results using statistical techniques for executive and management reporting

Implemented data collection systems & other strategies that optimize statistical efficiency & quality

Analyzed & maintained data from primary or secondary data sources using SQL &T-SQL for data extraction

KEY ACADEMICS DATA ANALYSIS PROJECTS

Project Name

YEAR

Description

BIG DATA &HADOOP, SPARK (Final Project)

July 2018 - Present

Worked on large dataset of banking sector to analyze how many customers will enroll for term deposits

Reduces large banking dataset in spark & apply different statistical techniques to approach to the result & analyze using Tableau

WORLD CONGRESS CS-IT WEBSITE

Sept Dec 2017

This Web application project demonstrated a professional duplicity of World Congress CS-IT Website

Registration from all over the world can be made through this website

The website also had different options to log in as a student, as a teacher

REAL TIME TUTORING SYSTEM

Sept – Dec 2017

Developed in Drupal &MS Visio, The system allowed users to utilize mobile devices to post questions & receive answers to assignment. It also allowed instructor to give responses that includes graphics to the questions

Contact this candidate