We provide IT Staff Augmentation Services!

Organizational Data Manager Resume

5.00/5 (Submit Your Rating)

San Francisco, CA

SUMMARY

  • Software Professional with more than five years of professional experience in the Business Intelligence Industry and a Master’s degree in Management Information Systems (MIS) with a purpose to empower business to make data driven decisions through data driven technologies and act as a solid bridge between the Business stakeholders and technical teams so as to bring the desired change.

HIGHLIGHTS OF EXPERTISE

  • Data Integration
  • Dimensional Modeling
  • Build Data Pipelines
  • BI Solution Design
  • Document BI requirements
  • Implement ETL
  • Provide Data Validations
  • Customer Onboarding
  • SQL, Python
  • Tableau, Power BI, R - Shiny
  • SAS - Data mining
  • Big Data (Sqoop, Hive, Rspark,)

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Organizational Data Manager

Responsibilities:

  • Collaborate with various stakeholders to understand their process, data collected and provide BI solutions which will help them get insights to operate better
  • Design, document and implement end to end BI solution based on the requirements provided in various phases
  • Often query the databases to analyze data in the systems and to test the changes
  • Integrate Data from various applications used by teams like finance, HR, sales, Customer Success though API / database connection for operational reporting and create data marts for BI reporting
  • Use Pentaho and SQL to transform the data and load data into reporting tables
  • Created end to end Performance and Adoption dashboard for the Product team using Power BI
  • Gather requirements from executive leadership or functional leaders on the data insights they need and build reports accordingly
  • Build visualization in Power BI/Tableau/Smartsheet/IBM Planning and Analytics as necessary depending on the tool preferred by the function
  • Document and Train users on the newly built BI process or dashboards
  • Current subject matter expert on the Internal BI process of the Product Organization
  • Analyze data and bring inconsistencies and problems to the attention of management
  • 20% of my role also engages in associating with Customer Success Group to identify Product gaps and then write solution documentation and Jira requirements for the respective product teams

AT&T Dallas, TX

Business Intelligence Analyst May 2017- February 2019

  • Designed End to End reporting framework for the data coming from the “Order Capture Engine” replacing Traditional BI systems with Bigdata System
  • Performed Data Ingestion using Sqoop and then built Staging Hive Tables on top of HDFS
  • Performed data transformations using SPARK R and load data into Data Marts
  • Developed reports on platforms like Tableau, Power BI and R-Shiny.
  • Integrated SparkR and Shiny which increased performance of reporting solution by 30%
  • Created Data Frames in R language using connection to SPARK and create a Web Application for Dashboard using shiny framework

Developed a minimum viable product (MVP) for real-time BI reporting solution using Sqoop, Hive and SparkR. The reports can be visualized in near real-time on Shiny app. Resulted in 30% efficiency and reduced cost equivalent to 2 FTE

Confidential Dallas, TX

Data Analyst

Responsibilities:

  • Conducted brainstorming sessions to define and provided AS IS and TO BE state of BI System
  • Provided solution to how real time predictive analytics can be done on IOT data
  • Integrated and synthesized Data from various schemas in DB2 and TERADATA using SQL and Big data Technologies
  • Analyzed and transformed data before loading to Datamart
  • Provided Data Mart Design which was built in Hadoop Ecosystem
  • Provide algorithm which would run using RPARK to predict when the wheel of train will break
  • Developed Tableau Dashboard based on the Datamart to perform data validation against the source
  • Gave demos to stakeholders on how these new capabilities will increase efficiency in their BI systems
  • Assisted professor in the lectures of Operations Management and Python

Confidential Dallas, TX

Business Intelligence Intern

Responsibilities:

  • Used MYSQL Database for SQL querying, Pentaho to Extract, Transform and load data in Data Warehouse and Tableau for reporting KPI.
  • Instrumental in presenting analysis findings to stakeholders and influenced to bring changes that reduced manual tasks.
  • One of the first employees to join the company and within 3 months supported about 15 customers
  • Collaborated with various cross functional departments to understand reporting requirements
  • Provide analysis using EXCEL reports using DAX capabilities
  • Reports were crucial to the operations of the Supply Chain Business

We'd love your feedback!