avp sr bi engineer data analyst research resume example with 12+ years of experience
JessicaClaire
, , 609 Johnson Ave., 49204, Tulsa, OK100 Montgomery St. 10th Floor
H: (555) 432-1000
C:
resumesample@example.com
Date of Birth:
India:
:
single:
:
Professional Summary
Certified AWS Cloud Practitioner with knowledge of the cloud architecture and database services.
Certified Alteryx Designer with experience in building workflows and preparing data required for dashboard reporting.
Certified Tableau Associate and IBM Cognos Developer with over 11+ years of experience in data warehousing and BI reporting environment across various domains like Banking,pharmaceuticals,Telecom and Rental domains.
Experience in ETL big data integration tools using Pentaho Data Integrator(PDI) and other analytical tools like HIVE/Hue .
Experience in integration of Python with Tableau using TabPY API for data cleaning and predictive algorithms.
Experienced Business Intelligence specialist with proficiency in multiple BI tools like Cognos,Tableau,Qlikview development/Qlikview Administration.
Skills
Data Analysis,Data Modelling,Data visualization,Dashboards
Tableau, Cognos Analytics, Qlik Desktop, Qlik Administrator, MicroStrategy, Power BI
Python,Big Data , Pentaho Data Integrator ,HIVE , Impala, HUE
GIT stash,Source Tree, JAMA , JIRA
Work History
AVP, Sr. BI Engineer/Data Analyst, Research, 10/2014 - Current Motion Recruitment – Andover, VA,
Provided Insight-driven, quantitative and qualitatively accurate Research reports to Research directors and Research Co-heads.
Solving business problems like Inefficient Client Billing process , improper entitlements on client readership using data analysis/reporting tools like Tableau, Clickhouse,Qlikview.
Data preparation using Alteryx workflows for scenarios where data had to be sourced from multiple sources to implement client specific dashboards.
Managed end-to-end regulatory reporting process from requirements gathering stage to report distribution stage. This included ESMA ,HKMA and MIFID II regulatory reporting.
Worked on ingesting Trade data to Hadoop cluster using Big data tools like Pentaho Data Integrator and creating reports of BI tools to provide analytics to business.
Achievements
Created analytics for the Research group which enabled to them to fix client invoicing issues . The analytics enabled to them to deep dive into clients who consumed more research but were not billed properly.
Automated the application monitoring process for different business lines ,which was initially monitored and maintained through spreadsheets. This saved a lot of manual effort and resource utilization.
Designed a stable star schema model by reverse engineering the multiple lines of code . This served as single central data source for multiple reports/dashboards and reduced the maintenance efforts.
Associate, Sr. BI Developer, 06/2011 - 10/2014 Volvo Rents – City, STATE,
Implemented various financial , P&L and equipment utilization dashboards for top level management.
Developed and published meta-data packages and OLAP Models for producing reports for stakeholders.
Created KPI's to monitor analysis and provide strategic insights to drive growth and performance.
Interfaced with data miners and analysts to extract, transform and load data from a wide variety of data sources using SQL.
Led the development of visual analytical applications from wireframe and storyboards to complete production-ready applications.
Published dashboards(Cognos Active Reports )on mobile platform for ease and flexibility.
Achievements
Lead offshore BI team and managed the deliverables to the stakeholders.
Deployed the mobile platform for dashboards. This enabled users who were on field to access the real-time Utilization (Product/Cost) stats.
Automated the P&L dashboard for the finance department with write back facility.
Successfully participated in migration of data from Oracle 9I to SQL SERVER.
Support Engineer, 08/2008 - 04/2011 Telefonica,O2 – City, STATE,
Involved in the Installation , configuration and migration of content from Cognos ReportNet to Cognos 8 version for the network group.
Developed ROLAP/OLAP models to support the global reporting requirements across the company.
Created databases and schema objects including tables, indexes, stored procedures and functions as a part of the data migration initiative.
Performed Analysis using BI tools on customer based to provide some KPI's to the high level management.
Achievements
Created analytical dashboard for sales with customer information providing them ability to sell the products more proactively and increase the customer base for the company.
Redesigned the Relational model which cut down lot of execution time on reporting and load on database.
Education
Master of Science: Information Systems, Expected in - Leeds University , Leeds, UK - , GPA: Status -
Bachelor of Technology: , Expected in - Jawaharlal Nehru Technological University - , GPA: Status -
Certifications
AWS Certified Cloud Practitioner
Alteryx Designer Core 2020
Tableau Desktop Certified Associate (Candidate ID - 1000118)
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.