Crm Analyst Resume
Chicago, IL
SUMMARY:
Resourceful, results - driven IT Professional with notable success with database application development while participating in planning, analyzing, and implementing solutions in support of business objectives.
TECHNICAL SKILLS:
Languages: Visual Basic (VBA), SQL
Tools: UNIX, Toad, DB Visualizer, Informatica Power Center, IBM DataStage, Unica Affinium Campaign, Qliksense
WORK EXPERIENCE:
Confidential, Chicago, IL
CRM Analyst
Responsibilities:
- On-going support of Campaign Management System and National Brand Campaigns.
- Creating ad hoc reports/Metrics to support decision making process.
- Preparing customer lists for multiple CRM initiatives.
- Sales match reports to report the Campaign effectiveness Directing CMS-IT in support of CRM initiatives.
- Created and updated Business Requirement documents and Functional Requirement documents.
Confidential, Chicago, IL
Data Analyst
Responsibilities:
- Delivered best processes for employers to ensure Confidential reporting compliance; understand data sets to onboard clients.
- Supported the setup and use of Secure File Transfer accounts for each client. Provide feedback to clients on data submissions.
- Established deadlines and manage clients to their commitments.
Confidential, Troy, MI
Data Analyst
Responsibilities:
- Work closely with the development teams to coordinate project tracks as they relate to quantifying data flow
- Generate reports and query the Oracle/SQL Data Warehouse.
- Focus on data mapping using IBM DataStage to analyze and apply current stored procedures utilizing Oracle/SQL queries to extract, load, and transform data
Confidential, Centreville, VA
Senior Business Data Analyst
Responsibilities:
- Oversaw and performed the planning, scheduling & testing of data loading to ensure that data met design specifications, product display and time to market to company’s key performance indicator metrics.
- Conducted data analysis for content and consistency for data quality and maximized the return of investment in the data.
- Identified and troubleshot data-related issues.
ETL Developer
Confidential
Responsibilities:
- Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
- Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, analysis, requirements gathering, data modeling, effort estimation, ETL design and development.
Confidential, Detroit, MI
Decision Support Analyst
Responsibilities:
- Provided data, analysis, and recommendations to support multiple technical operations to assure customer satisfaction.
- Perform prototyping, testing, and tuning of client desktop solutions.
- Built and executed multi-channel, multi-wave marketing campaigns that yielded profitable relationships throughout the customer life cycle.
