SUMMARY

• Experienced Data Analyst with more than four - year experience and having more than four-year experience in using SQL.
• Create dashboard/ ad-hoc reporting with SSRS,Excel, and Tableau.
• Process implementation in warehouse/ pipeline environment
• QA testing ensures data integrity and meet quality standard.
• Troubleshoots data issues, validate result sets, recommend and implement process improvements, provide ad-hoc reports and analysis.
• Supports SQL scripts maintenance, changes, and testing.
• Performed Intake of files and analyzes data using T-SQL.
• Responded to Business requests, including research and analysis data.
• Documented changes in system change and logic.
• Ensures Data Quality Metrics are under SLA
• Performed maintenance and Operational Support of automation solutions around file intake and processing.
• Follow change control process to maintain intake configurations and effect data fixes.
• Create EDI translation companion guide.

TECHNICAL SKILLS

• Data Analysis data mining data mapping
• SQL
• Advance Excel
• VBA
• Python
• Dashboard
• SSRS
• SSIS
• Ad-Hoc reporting
• Power BI
• XML
• HTM
• HTML5
• PHP
• Jira
• SourceTree
• Agile Methodology
• Water Fall Methodology Scrum
• Microsoft Office Suites
• Word
• Excel
• PowerPoint
• Google analytics
• CRM

PROFESSIONAL EXPERIENCE

Confidential - San Francisco

Data Engineer

Responsibilities:

• Analysis of database tables as they relate to a data warehouse model and determination of likely intra and inter-database relationships.
• Assess the quality and consistency of data stored in a source database and develop recommendations for data cleansing based upon data warehouse business rules.
• Prepare a Data Quality and Schema Structure Report, which document findings regarding the database analysis work performed.
• Prepare technique documentation on data migration process.
• Create mappings between the fields in the source and target systems as well as identifying relationships within a source (implicit foreign keys, lookup tables, etc.).
• Leverage mappings to create an ETL process to move the data from the source system to the target system. This includes data cleaning and value mapping.
• Performance tuning of queries and tables.
• Optimizing / Creating Stored Procedures.
• Documentation of source schemas to be used by other Data Analysts.
• Utilize Jira and SourceTree for bug tracking and coding tracking.

Confidential - Fremont, CA

Health Data Analyst (Data Quality)

Responsibilities:

• Perform quality data measurement in data warehouse and ensure meaningful use apply for all clinical data.
• Automate/configure daily/monthly report for stockholder.
• Lead efforts to ensure data integrity and validity and perform ongoing quality assurance of all data and reports.
• Gather and identify business need for ad-hoc reporting as needed.
• Suggest new business work flow and implementation for quality measure.
• Ensure data mapping in I2I system is correct and generate UDS report for federal government.
• Develop incident system to keep track the occurrences and analyze data.
• Develop/implement web base portal for clinical user to submit patient complain.
• Develop dashboard tough Tableau, SSRS, and excel.
• Develop SSRS and pivot table for end user to perform simply data task.
• Serve as project lead to ensure integrity and validity of annual UDS data submission.
• Improve the quality of data and information by working with users to identify reporting needs, define report specifications, and develop reports to meet business requirements, turning the reports/processes over to end users’ control whenever possible.

Confidential - Phoenix, AZ

Senior Data Analyst

Responsibilities:

• Perform data extraction, aggregation, analysis, and quality checking from multiple data sources to create and monitor tests and programs using tried and true platforms like SQL and SAS in a manufacturing and/or warehousing environments.
• Improve process flow in warehouse environment.
• Use the newest and most relevant technologies, like Hadoop, R, and Python, to uncover new insights that enable new opportunities
• Partner with management to drive new reporting or solutions that improve our ability to operate efficiently and improve continuously
• Initiate data mining and analysis activities to explore big data resulting in suggestions that lower costs and drive efficiencies
• Spearhead proactive investigations into data issues that impact reporting, analysis, or execution
• Perform ad hoc analytics on large/diverse datasets
• Help build business cases and lead definition of data strategies that support business strategy

Confidential - Chandler, AZ

Data Analyst

Responsibilities:

• Intake of files and analyze data using T-SQL.
• Responded to business requests, including research and analysis of member data.
• Communicated the status of file loads, issues and resolutions to stakeholders.
• Analyzed Health plan files to confirm that the format conforms to intake requirements.
• Documented changes in health plan files and formats, and logic to process.
• Performed maintenance and Operational Support of automation solutions around file intake and processing.
• Follow change control process to maintain intake configurations and effect data fixes.
• Create EDI translation companion guide. Ad-hoc report creation and analyze.

Confidential, Phoenix, AZ

Intranet Web Development (Intern)

Responsibilities:

• Redevelopment of HR intranet website via Share Point (over 3 month’s period).
• Re-designed intranet interface by introducing visualization content in website and revising navigation bar to be more efficient.
• Updated employee information regarding benefits, new hires, online management .
• Improved Share Point efficiency by removing old files, website and data.

Confidential - Phoenix, AZ

Data Analyst

Responsibilities:

• Researched and analyzed housing market and located houses on MLS for foreign investors and answered questions on transactions.
• Prepared contracts, submitted offers, and communicated with seller’s most up to date information after CEO approval.
• Responsible to pull data from MLS and do analysis in excel.
• Updated web design and social media networking, incorporated the BBB into company marketing.

Confidential - Scottsdale, AZ

Office Assistant/Data Analyst

Responsibilities:

• Provided IT support, software update, software installation, software troubleshoot.
• Maintained the network system by upgrade the firewall.
• Re designed the web site to more professional, send newsletter to subscriber for monthly health update. Medical billing and coding.