Data and Post Market Analyst Resume Orange County, California - Hire IT People

SUMMARY

Over 12 years of progressive experience across a broad range of IT organizational functions and diverse industry segments.
Skills to turn data into information and apply algorithms to make statistically informed predictions and recommendations, coupled with well - developed project management and leadership qualities to support real-time discoveries and data research projects.
Proven ability to undertake complex assignments, meet tight deadlines, and deliver superior performance.

AREAS OF EXPERTISE

TECHNICAL SKILLS

Analytics and Reporting Software: SQL Server Reporting Services, Tableau, iPython Notebook, Microsoft Excel (VBA)

Languages: Python, R, Visual Basic, XML, HTML, SAS, SQL, Java

Other Software: Microsoft Office Suite, Microsoft Project, Microsoft Visio, Informatica, webMethods

Database: Oracle, Microsoft SQL Server, TaminoDB, Teradata

Platform: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Orange County, California

Data and Post Market Analyst

Responsibilities:

Analyze data related to post-market product complaints and reporting on trends to ensure compliance with all applicable corporate and federal agencies using tools such as SQL, Excel, Tableau, SAS, and Python.
Improve efficiency and reduce costs by automating ad-hoc activities, dashboard, and data visualization by utilizing Tableau and SSRS.
Apply the most appropriate modeling and analytic techniques to the problem at hand using Python, Tableau, and Excel and maintain them for effectiveness and accuracy.

Confidential

Business Insight Analyst

Responsibilities:

Perform thorough research and analysis on market pricing to determine the best target price for all products using Excel, Python, SQL and other proprietary tools.
Automate the ETL process by 80% using Python scripts and SQL Server stored procedures.
Analyze data from a various data source (SQL Server, Spreadsheets, Flat Files) and presenting actionable information to help executives and other corporate end users make informed business decisions.

Confidential

Customer Project/Program Manager

Responsibilities:

Establishing a strong working relationship with project stakeholders such that plans and requirements are fully understood and issues are resolved effectively and efficiently.
Align project objectives with company goals, and make sure the project team is clear on the objective.
Report overall program status to the steering group at regular intervals and on an ad-hoc basis.
Manage a team of ETL analyst and database administrators through performance management which resulted to consistently exceeding operational performance goals, KPI metrics, and quality expectations.
Collaborate with stakeholders to define project requirements by identifying project milestone, phases, and other resources.
Deliver SIP (Service Improvement Plans) to advance the quality of service and service delivery effectiveness by identifying opportunities from a large dataset and develop data-driven strategies.

ITO Service Delivery Consultant

Confidential

Responsibilities:

Develop, test, and implement Unix scripts, SAP BO, Informatica artifacts and other reporting objects related to Enterprise Data Warehouse (EDW).
Design and develop analytical dashboard using Excel and SAP BI to support the EDW application monitoring team.
Develop DDL, T-SQL implementation/back-out plans and support DDL PROD implementation.

Confidential

Programmer Analyst

Responsibilities:

Use Oracle PL/SQL, VB.NET and Webmethods to design and develop ETL solutions
Develop ETL solutions using webMethods, XML and data mining systems that process records every few hours.
Conduct and facilitate technical training about the implementation and maintenance of newly developed ETL application across the Global team.
Participate in analysis and design to understand business and functional requirements and determine the technical approach to deliver requirements.
Spearhead the design, development, and implementation of Amkor’s data collection of turnkey products in a cross-functional role.
Pioneer in Customer Focus Technical-SME Team, who performed data analysis, disaster recovery, and problem resolution for high priority incident. Reduced ticket resolution time to 15%.
Develop and analyze ETL and B2B application in a production support capacity using RPG ILE, SQL400 and Control Language as development tools.
Work closely with Business and System Analysts situated across different Amkor factories worldwide to better serve and understand customer data and reporting requirements.
Collaborate with the CRM Implementation Team to document and implement process improvements which resulted in CMMI promotion to Level 3.