Employment History 

• BI Developer

  Colaberry INC.

  May 2019 - Present

  • Create SSIS package to load data from flat files, CSV files, and SQL server by using lookup, fuzzy
  lookup, derived columns, condition split, term extraction, aggregate, pivot transformation, and slowly
  changing dimension (data profiling, cleansing, and verification).
  • Create complex SQL queries and database objects to pull and manage data
  • Designing and implement stored procedures and triggers for automating tasks
  • Design SSRS reports for in-depth business analyses.
  • Design and develop Power BI graphical and visualization solutions with business requirement
  documents and plans for creating interactive dashboards.
  • Utilize Power BI (Power View) to create various analytical dashboards that depicts critical KPIs.
  • Implement several DAX functions for various fact calculations for efficient data visualization in Power
  BI.
  • Utilize Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
  • Convert business requirements into technical specifications and decide timeline to accomplish
  • Working with high-performance data integration solutions that connect multiple data sources for
  extracting and rapidly transforming the data for loading into the pre-designed data warehouses
  • Collaborate with senior management, subject matter experts, and IT teams to define business
  requirements.

• Staff Accountant

  On Stage Enterprises LLC

  January 2018 - December 2018

  • Managed financial operations, month-end reporting, financial schedules, and reconciliations
  • Performed in-depth analysis of business operations, trends, and obligations to complete accurate projections
  • Performed in-depth analysis of business operations, trends, and obligations to complete accurate projections
  • Managed large amounts of financial data using balance sheets, profit and loss reports and online databases
  • Gained accounting efficiency and improved documentation coordination through development of optimal journal entry schedules
  • Analyze business intelligence data to inform business and product decisions
  • Identifying and analyzing industry/geographic trends and competitor market strategies and monitoring current/potential customer trends.
  • Partners with other areas of the business (e.g., Marketing, Logistics, Customer Service, etc.) to model the outcome of implementing potential business strategies.
  • Generated dashboards with quick/context/global filters, parameters, and calculated fields on Tableau reports
  • Prepared and maintained documentations for reports, metrics, and processes
  • Collected and assembled financial data to analyze costs on year-to-year basis relative to fiscal planning and budgeting activities.

• Budget Analyst/Business Analyst

  Office Of Attorney General of Texas

  January 2020 - April 2022

  • Monitored budget execution work, including obligations incurred and actual expenditures of funds
  • Build & maintain data aggregation processes and dashboards, creating interactive and compelling visual, numeric, and written summaries
  • Created complex SQL queries and database objects to pull and manage data
  • Data Analysis and profiling to understand the dimensions, lineage, and Data quality checks in coordination with the technical and regulatory requirements
  • Developed and deployed dashboards, visualizations, and autonomous and dynamic management reports using PowerBI
  • Prepared and maintained documentations for reports, metrics, and processes
  • Assisted with the planning and preparation of the CSD Operating Budget, and Legislative Appropriations Request
  • Analyzed and provided explanations concerning budgetary issues that affect the agency\'s mission and resources
  • Developed annual budget and compared actual expenses against projected budget.
  • Submitted budget estimates, progress reports and cost tracking reports