Data Analyst

Muhammad Bilal Bhatti

**** **** * ******* **** Jersey City NJ, 073**-***-*** 2291 *********@*****.***

EXPERIENCE

Data Quality Analyst– Stryker – Mahwah, NJ July 2014 - Present

• Responsible to ensure all Master data is accurate, properly authorized and integrated between all relevant systems

• Resolve and escalate data quality issues, research and implement solutions to correct problems at the source where possible.

• Review source system to determine accuracy, audit data for discrepancies, correct errors where appropriate

• Verifying data entry & ensuring accuracy and completeness of information

• Update records to include deleting, changing or additions to data files

• Maintains computerized collection and tracking of relevant data

• Organizes workflow and Produces database summaries, statistics and reports/data extracts as requested

• Use Oracle BI tool, Access, Excel and SQL queries to extract and interpret data from multiple

ERP’s(Oracle,BPCS,AS400,IBM Sphere, GIM)

• Diagnose problems by using established fact-finding procedures, knowledge of processes and procedures

• Responsible to perform ad-hoc data investigations when necessary to profile and analyze data to address inquiries around

data quality and integrity

• Evaluate processes for gaps, inefficiencies and additional opportunities and provide suggestions for improvement

• Ensure Data migration is as efficient as possible

• Automating reporting & metrics

Pricing/Data Analyst- Frederick Goldman Inc. – New York City, USA October 2013-June

2014

• Responsible for building price optimization models based on an analysis of variables including value to the customer,

market research data, country and/or region specific pricing conditions, and competitor price

• Analyze the underlying assumptions, economic logic, and key variables in pricing proposals

• Resolve and escalate data quality issues, research and implement solutions to correct problems at the source where possible

• Investigate and recommend enhancements to existing pricing program

• Proactively identify relevant trends and do follow-up analysis

• Identify and implement new methods of increasing efficiency and improving processes by providing an insight of the

strengths and weaknesses of the company’s internal controls.

• Preparing Margin Analysis for Precious Metal Lock Customers for Executive approval and maintain BOM.

• Responsible for data quality, governance & integrity of data being migrated from AS400 to MS Dynamics.

• Building Dashboard/Visualization with tableau

• Work collaboratively with multiple teams (Development, Production Support, etc.) and execute applicable tasks to support

shared CRM initiatives

• Develop, revise and maintain process flow maps for current CRM operational work flow and proposed solutions

• Perform gap analysis on current CRM implementation and formulate innovative solutions for gap closures; proposed

solutions should increase efficiency, improve structure and increase simplicity for end users

• Collaborate with IT to transition customer business requirements into technical specifications

1

Jr. AML Data Analyst, Standard Chartered Bank – Lahore, Pakistan January 2012 – August 2013

• Organize and review data for security and systems integrity audits

• In collaboration with others, develop and implement strategies that optimize statistical efficiency and data quality.

• Escalation of unusual activity to the AML Manager

• Supported quantitative and qualitative analysis of surveillance model performance, including evaluation of automated

models/scenarios, custom-built models, AML-related reports generated in various systems.

• Track deadlines, milestones, calendars/meetings

• Provide documentation including detailed descriptions of data issues found in reviews

• Identify possible enhancements to AML tools and processes and communicate them to the Managers.

• Analyze key performance indicators to ensure requirements of the AML policies and programs are maintained at a level

commensurate with regulatory expectations

• Work effectively with multiple complex data sources and technical analytical tools/ resources

• Work and contribute in a team-oriented and collaborative environment to improve the analytical and reporting processes.

• Transaction monitoring of assigned accounts to assess potential suspicious activity on the accounts.

INTERNSHIPS

Research & Development Executive, SKANS – Lahore, Pakistan July 2011 – January 2012

Creation and maintenance of study material related to Professional Accountancy Qualifications

Provided support in selection of materials and books for book banks.

Assisted with underwriting of deals and conducting market research and analysis

Established relationships with potential vendors

Responsible for preparation and review of reports in Excel using charts and graphs as well as PowerPoint presentations

Initiated discussions / raised questions when elements of the data were inconsistent with prior findings or expectations

Designed and implemented custom surveys and analyzed and interpreted findings

Provide SEO support for specific editorial campaigns

Help develop, manage, and execute SEO strategies

Ensure websites are filled with optimal keywords.

Auditor, Zulfiqar Ahmed & Co – Lahore, Pakistan January 2011- June 2011

Planned financial audits by understanding organization objectives, structure, policies, processes, internal controls, and

external regulations; identifying risk areas; preparing audit scope and objectives; preparing audit programs.

2

Assessed compliance with financial regulations and controls by executing audit program steps; testing general ledger,

account balances, balance sheets, income statements, and related financial statements; examining and analyzing records, reports,

operating practices, and documentation

Assessed risks and internal controls by identifying areas of non-compliance; evaluating manual and automated financial

processes; identifying process weaknesses and inefficiencies and operational issues

Verified assets and liabilities by comparing and analyzing items and collateral to documentation

Completed audit work papers and memoranda by documenting audit tests and findings

Communicated audit progress and findings by providing information in status meetings; highlighting unresolved issues;

reviewing working papers; preparing final audit reports

Provided financial control information by collecting, analyzing, and summarizing data and trends

Examined and evaluated financial and information systems, recommending controls to ensure system reliability and data

integrity

Inspected account books and accounting systems for efficiency, effectiveness, and use of accepted accounting procedures to

record transactions

EDUCATION

Professional Certification;

Association of Chartered Certified Accountants (ACCA) -2012

Post Graduate Diploma in International Finance -EduQual - 2014

Certified Internal Auditor (CIA) - 2014- Present

Graduate;

BSc (Hons) degree in Applied Accounting- Oxford Brookes University (UK) (2012)

SKILLS

PC and MAC user, Proficient in Advance Excel (pivot tables, Index-match, lookups, VBA excel Macros etc.),

PowerPoint, Microsoft Word, QuickBooks, Peachtree, SAGE, Oracle, BPCS, GIM, Oracle BI Tool Microsoft

Navision(Dynamics), AS400, Microsoft Outlook, Lotus notes, Microsoft Visio, Microsoft Access and SQL,R,

SAS,SAP,Python,Java.

3

Contact this candidate