Etl Developer Resume
5.00/5 (Submit Your Rating)
New York, NY
PROFESSIONAL SUMMARY:
12 Years of IT Experience & 8 Years of Marketing Cloud Experience. With a Masters in Computer Science and the passion for programming I began my career as an ETL Developer then transitioned into a role as a Marketing developer. Once ExactTarget was acquired by Salesforce.com I began taking on multiple roles as an ExactTarget SME, Salesforce Administrator, Salesforce developer and Salesforce Marketing Cloud Architect.
TECHNICAL SKILLS:
- SQL Server
- CSS
- Database design
- IP Forwarding proficient
- Journey Builder
- PSD to HTML
- ETL Informatica
- Mobile Connect
- Salesforce
- System backups
- ExactTarget
- Cloudingo Automation Studio
- API, SOAP API
- AMP Script
- Windows and Linux
- Java Fuel
- Unix
- Tableau
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
ETL DeveloperResponsibilities:
- Create journeys and implement marketing campaigns using marketing cloud tools like Journey Builder, Email Studio, and Automation Studio.
- Provide sales and marketing data analysis and reporting including metrics and results for the marketing campaigns ROI.
- Integrate campaign members to marketing cloud and used them in Journeys.
- Create Triggered sends for continuous flow.
- Deliver continuing support in the areas of SFDC Marketing Cloud configuration, administration, reporting, data migration, solution design and project coordination.
- Design workflow rules and specify related tasks, time triggered tasks, email alerts, filed updates to enable business logic.
- Work with Marketing Cloud Connect, Data Stream, query writing, data extensions and AMPScript.
- Worked on upgrading the connectors whenever there is a new version of the connector is available
- Developed emergency notification system to gather customer needs and pass it to the help center
- Develop different Email templates for implementation of dynamic email marketing program using AMPScript, HTML and CSS
- Manage ExactTarget / Marketing Cloud implementation for a large enterprise, including multiple business units troubleshooting
- Involve in the SDLC phases like Requirement Analysis, Implementation and estimating the time - lines for the project.
- Design and execute customized solutions, such as API integration and using Data Extensions, by leveraging Salesforce Marketing Cloud (SFMC) and other toolsets and leveraging industry best practices
- Serve as the technical subject matter expert for product and development teams to build and deliver email solutions based on business requirements; provide technical consultation on SFMC tool set and solutions
- Develop specialties in SFMC data management, scripting languages, API, and/or integrations
- Managing subscriber data, import and segmentation using a combination of Salesforce Marketing Cloud tools and database queries
- Working with Marketing managers and converting their strategy into implementations using Marketing cloud &ExactTarget.
- Design mobile responsive email mock-ups that are built out and integrated into the SalesForce Marketing Cloud (ExactTarget).
- Build and manage technical SFMC infrastructure for supporting the client's growing consumer marketing practice
- Collaborating with cross-functional teams - Marketing, Sales, Content, Analytics, Growth, Engineering, and International.
- Lead the tactical execution of email campaigns, including developing HTML email templates, executing QA test plans, managing deployment, and analyzing the delivery/inbox placement of marketing emails and automation programs.
- Developing and maintaining large volumes of deadline-driven email campaigns and assets Management of Email Channel Calendar and Direct Mail.
- Reporting on email campaigns (status and outcomes) for various stakeholders. Cross- departmental collaboration on major projects and new initiatives.
- Effectively communicate between technical, operational and strategy groups.
- Created many Data extensions to accommodate custom scenarios. Configured and designed journey's using journey Builder.
- Automated the import extract and Query activity using Automation Studio.
- Used Dynamic content for subject lines.
- Used AMP scripting to use data from Data Extensions.
- Used SOAP API in order to invoke triggers and create redundant data.
- Used SOQL for data manipulation needs of the application using platform database objects.
- Created different folders to store the reports of different groups and categories.
- Displayed the quarterly and yearly results on the Dashboards of the users.
- Experience in working with Cast Iron for Salesforce.com configuration.
- Involved in Data Migration using Data Loader and Informatica power exchange.
- Used the sandbox for testing and migrated the code to the deployment instance after testing.
- Building automations to make sure the quality control team is giving the commissions in the right way.
- Handling multiple number of projects at a time and delivering clients requirements on time.
- Worked in Agile & Scrum environments.
- Experience with multivariate testing, analysis and reporting.
- Create and maintain email reporting dashboards, conduct A/B testing and provide test results to the Marketing team to drive segmentation, delivery and content decisions.
- Created many Business units and maintained Under the same sandbox.
Confidential
ETL DeveloperResponsibilities:
- Completed several integrations using the Salesforce Marketing Cloud connector V5 to connect to multiple Salesforce Orgs.
- Developed useful reports within Salesforce to measure the data quality
- Resolved Salesforce sync issues by deleting the expired OAUTH tokens
- Heavily involved in setting up Sand Box account
- Experience with Multi-Org configuration
- Used SOAP & REST API in order to invoke triggered sends and create redundant data.
- Used the sandbox for testing and migrated the code to the deployment instance after testing.
- Built documentation for the end users and managers for easy navigation and access.
- Ability to quickly identify and address operational and process issues.
- Created many Data extensions to accommodate custom scenarios.
- Used AMP scripting to use data from Data Extensions.
- Involved in Data Migration using Data Loader and Informatica Power Exchange.
- Performed the roles of Salesforce.com Developer and Administrator in the organization.
- Designed various Visual Force pages for capturing various customer enquiries and Implemented logic for migrating cases to different queues based on the type of customer enquiry.
- Deployment through Eclipse IDE.
- Built automations to make sure the quality control team is giving the commissions in the right way. Build materials for the end users and managers for easy navigation and access.
- Create and maintain email reporting dashboards, conduct A/B testing, and provide test results to the Marketing team to drive segmentation, delivery, and content decisions.
Confidential
ETL DeveloperResponsibilities:
- Involved in requirement gathering requirements and analysis.
- Developed a new module for Purchase division.
- Designed and developed various Web forms using HTML, CSS.
- Developed windows forms for the windows based system using JavaScript.
- Coding site in XHTML, CSS.
- Designed and implemented the whole web site using HTML, XML, CSS, Flash and MySQL.
- Involved in Design UI Screen, created several mock up Using HTML, CSS and JavaScript.
- Used UI Development using HTML, and coded Java components which Retrieves data using SQL from Oracle database.
- Participated in analyzing the requirements and depicted them through use cases and scenarios.
- Participated in unit testing, integration testing and installation of the system.
- Involved in Web design and development for the UI interface design, graphic design for printed materials and presentations, illustration, logo design. Used HTML, CSS, and JavaScript.