Data Analyst
Resume:
***********@*****.***
LinkedIn Profile Link
TECHNICAL SKILLS
• Tools: SAS, MACRO & SQL
• Data query language: SQL & DAX
• ETL: SSIS, SSRS & SSAS
• Reporting Tools: Power BI, Excel & MS-Office
DECISION MAKING AUTHORITY & RESPONSIBILITY
• Importing data from Excel and SQL Server DB into SAS to generate reports.
• Installing and configuring Power BI Gateways to keep the dashboards and reports up to date by scheduling the Refresh.
• Knowledge in creating Workspaces and Subscriptions.
• Responsible to deliver functional programming errors.
• Investigating and understanding the cause of defects raised.
• Proactively rectify to minimize issues with deliverables, which adversely affects the value chain.
ACADEMIC QUALIFICATION
Bachelor of engineering in Electrical & Electronics from "Visvesvaraya Technological University" in 2012, India
PERSONAL DETAILS
Date of Birth: 16-Nov-1989
Work Permit: UK & India
Location: Birmingham B168FJ, UK
BRIJESH KUMAR
PROFESSIONAL SUMMARY
A multi-skilled & result oriented IT Professional with around 8 years of experience focusing on SAS, SQL, MACRO and Microsoft Power BI.
Experience in SAS, MACRO, STAT, GRAPH and SQL in Windows environments.
Working extensively on Microsoft Power BI Dashboards Development and Design.
Experience in Data Modelling, Extraction, Modification, Validation, Data Analysis, Code Analysis and Reporting using SAS and Power BI.
Reviewing code and identifying programming errors.
Investigating and understanding the cause of defects raised.
Interpretation, understanding and resolving support issues.
WORK EXPERIENCE
Data Analyst ARUP Birmingham United Kingdom
OCT 2022 to Present
Project: High Speed 2 (HS2) Railway, UK
• Working on data preparation, data structures and data modeling existed in both Overview and CRM.
• Writing code using SQL and Development of a power BI dashboard to display commercial and financial data for this project.
• Conducted and generated Daily, weekly and Monthly reports based on routine analysis in dashboard using business object.
• Expert in data Visualization in various chart that can visualize the data like Chart, Tree Maps, Bar chart, Scatter plots, KPI's, etc.
• Prepare holistic documentations (process and technical) to enable proper knowledge transfer of both process and solution to the production team.
Data Engineer IBM Bangalore India
AUG 2021 to SEP 2022
Project Objective: Risk Finance and Treasury
Worked on Debit card, Credit card and Forex card data issued through a bank.
• Write code using SAS and SQL to extract, clean and validate data from a flat file, excel file, access database.
• Data preparation, cleaning, manipulation, and visualization. Extract data from relational databases and perform complex data manipulations. Also conducted extensive data checks to ensure data quality.
• Documented all developed SAS programs and written other documentation as needed.
• Responsible for transfer of technical knowledge to facilitate implementation of the business solution provided.
Data Analyst Programmer IQVIA Bangalore India
MAY 2017 to AUG 2021
Being as a Data analyst and Sponsor lead, I developed SAS programs to extract the trial related data from the database and manipulated as per requirement and shared with the sponsors.
• Key deliverable worked on was generating report with SAS.
• Performed data cleansing widely, during the ETL’s extraction and loading phase by analyzing the raw data and writing SAS program and creating reusable Macros.
• Created required Measures, calculated columns using DAX.
• Prepare and define the data transmission requirements to outline the data transmission services.
• Initiate and perform quality control tasks for incoming and/or outgoing data files.
• Record all evidence of the data transmission process from data file definition to closure of study.
• Ensure that all specification and design documentation are filled and stored according to company policy.
SAS Programmer DSS Bangalore India
JAN 2015 -APR 2017
Project Objective: Pro- Card Analysis
Procurement Card is a Master Card issued through a bank, which gives the Cardholder freedom and authority to make small dollar purchases with ease. The advantages of Procurement card are that it drastically reduces the amount of time and paperwork required to purchase low dollar items, it speeds up the payment to vendors, it enables purchase of items online, and paperwork will be done once in a month vs every time you wish to make the purchase. I was involved in finding illegal transactions and unauthorized users of the card using SAS and SQL.
Trainee Engineer SIGMA-C Nagpur India
SEP 2012 – SEP 2014
• Commissioned ARTS erection process related to TG.
• Installed and supervised troubleshooting of instruments.
• Calibrated Valves, Transmitter, TS, PS, PG, TG, RTD, Thermocouple and LT.
• Commissioned Boiler/Vendor Packages at 1*270MW TPS.
Contact this candidate