Database Administrator/analyst Resume
3.00/5 (Submit Your Rating)
San Francisco, CA
TECHNICAL SKILLS
- Data Analytics and Visualization Tools: Tableau 10.3, Microsoft Excel, Qlikview, OBIEE, Google Analytics, Splunk Functional Skills: Requirements Analysis, Business Intelligence and Analytics, Data Mining and Data Warehousing, Reporting Programming Languages and Databases: PostgresSQL, Greenplum, Python, Java, MS SQL Server, Oracle 10g/11g, MS Access Software & Internet Tools: ZOC, Git, Unix/Linux, JIRA, Salesforce, MS Office Suite, SAP, Worksoft Certify, Protoshare.io
PROFESSIONAL EXPERIENCE
Confidential, San Francisco, CA
Database Administrator/Analyst
Responsibilities:
- Owner of the Data Warehouse; supported data driven decisions obtained after querying datasets to consolidate business.
- Generated reports supporting SAM, Finance, Product, IT and Marketing in performing critical tasks in a SaaS setup. Making sure seamless information is available across business units so as to help them take vital decisions and ensure customer satisfaction.
- Maintaining and Administering Client BI Reports across domains and creating, refreshing extracts for Tableau reports.
- Managing the addition or removal of tables, enabling or disabling of Clients and modifying data transformation tables. Working with the dev - ops team on resolving database related issues in User Acceptance Test and monitoring Production alerts.
Confidential, Redwood City, CA
Product Analyst
Responsibilities:
- Used predictive analytics for driving Arc platform performance using historical and real-time data extracted from Redshift. Applied data generation, mapping, extraction, transformation, loading techniques to create platform reports to monitor usage.
- Compiled impactful reports in Tableau for various KPI's that helped analyze buying, retention and churn. Created end-to-end game and user funnels in Google Analytics to match the impact of campaigns, spending potential and outcome achieved.
- Investigating the change requests for Arc Platform frontend and backend, prepare use case scenarios and propose workflow; initiate task after presenting it to the business users and driving the implementation through next release.
Confidential, Fremont, CA
IT Intern (Business Intelligence and Automation)
Responsibilities:
- Worked with cross-system Analysts, gathered relevant data sources, generated insights from analysis and presented findings to key stakeholders using Qlik; handled complex ad-hoc data & analysis requests for SAP business workflows.
- Participated in Business Process Optimization and Improvement for various SAP modules.
- Created automated test scripts for SAP FICO and Purchasing using Worksoft tools which improved the unit test cycle by 70-80%.
Confidential
Business Analyst
Responsibilities:
- Conducted requirements gathering, prepared feasibility reports, technical specification documents and outlined project targets.
- Performed data analysis using open source data after studying the market and identified opportunities available.
- Served as the liaison between the customer community (internal and external customers) and the IT development team.
- Collaborated with Product owner and scrum team on tasks related to the planning, scheduling and coordination of project activities. Participated in software estimation process and onboarding resources.
- Initiated the deployment of project releases, maintaining of status reports and business metrics.
- Dissect high-level information into details with appropriate documentation and communicated these details in a manner understood by relevant audiences and stakeholders.