SUMMARY

• An accomplished IT Professional wif Over 9+ years of experience wif extensive experience in Database Administration and 3 Years in Salesforce Marketing Cloud consultant.
• A Microsoft certified Professional in Database Administration.
• A Salesforce Certified Marketing Cloud Email Specialist and Marketing Cloud Administrator.
• Experience in teh complete life cycle of project development (SDLC) including System Analysis, Design, Development, Testing, Deployment and Maintenance.
• Possesses excellent interpersonal, communication as well as analytical skills wif demonstrated abilities in customer relationship management.
• Work wif Asset ManagementMarketingteam, Internal staff and Production team to plan and execute development cycle.
• Designing, developing and implementing teh workflow program, presentation and handling various phases of interface development based on technical specifications.
• Support teh EmailMarketingManager in teh development of new business requirements.
• Managing subscriber data, import and segmentation using Automation Studio in Salesforce Marketing Cloud and queried to pull teh data from Sales & service cloud from Synchronized Data Extension.
• Extensive experience in segmenting teh data using SQL, Data Filters etc.
• Experience in creating email strategies, test plans and detailed reports.
• Experience working wif Digital and Marketing Managers and deploying their strategy wif teh help ofEmail studio, Contact builder, Automation studio & Journey Builder.
• Worked wifA/B Testingin determine teh winner and publishing emails based on teh result.
• Executed data - driven campaigns including Email, Mobile Push Notifications, SMS.
• Worked on Agile Methodologies of Software Development using JIRA, Mingle.
• Performed Initial quality assurance on emails to ensure dat they render on various browser combinations wif teh help of LITMUS.
• Used AMP Script to build custom Email Templates dat renders data from Data Extension.
• Built HTTP POST, GET calls Using Amp Script and used them in teh HTML templated to get teh desired values from External System.
• Written SSJS in Automation Studio to call another Automation.
• Designed campaigns based on teh file dat is coming from FTP Server and exported teh file/ Deleted teh file from FTP Server after Import.
• Involved in teh Business team where we enabled DMP to Marketing Cloud.
• Has Knowledge to integrate Tableau and other external systems using DMP.
• Integration of Salesforce Marketing Cloud wif Salesforce. (Single org / multi-org).
• Knowledge on Salesforce Service, Sales Cloud.
• Expertise in planning and implementing SQL Server security and database permissions like user creation, Schemas and roles.
• Helped to create standards in Deployment procedures and communicated wif Offshore Developers and lead teh Team
• Redesigning web applications from old look to new look by incorporating teh interactivity features.
• Configured and maintained Transactional replication for standby/Reporting environments and having outstanding capabilities in troubleshooting replication errors and handling logs.
• Experience in scheduling batch jobs thru SQL Server Agent, Maintenance plans.
• Created Linked Servers between SQL Server, Oracle, DB2 Databases.
• Expertise in using various high availability techniques such as Always on Availability groups, Replication, Windows clustering, Log shipping, Database Mirroring, Failover clustering etc.
• Designed teh cost-effective Database Disaster Recovery solution across teh enterprise for teh SQL Databases.
• Strong documentation skills.
• 24 X 7 Production Database on Call Support
• Deep understanding of teh technology wif focus on delivering business solutions.
• Strong interpersonal skills and ability to communicate wif developers and business in teh terminology they understand.
• Highly Enthusiastic in learning new things and enjoys challenges and puzzles.

TECHNICAL SKILLS

Databases: MSSQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000/ Oracle 11gR2/11g/ 12c

Programming: T-SQL, SQL+, PERL, Shell Scripts, PowerShell, PLSQL, JavaScript, HTML, CSS, AMP Script, SSJS Cloud Salesforce Marketing Cloud, Service Cloud, Work Bench, Data Loader.

Operating System: Windows 2012/2008R2/2003R2/2003/2000 Advanced Server, NT, XP

Other Software: Active X, IIS, Microsoft Transaction Server, VBScripts, HTML, XML

Hardware: Net apps storage, EMC Storage, HP Server.

Tools: SQL DB Access, Performance Monitor, Eclipse, Jira, ERWIN, Spotlight, Toad for Oracle, Idera tools, SQL developer, ignite (solar winds DPA), Postma

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

SR Marketing Cloud Consultant

Responsibilities:

• Build relational data models to meet client requirements.
• Work wif clients, business partners and technology partners to identify, define, interpret and clarify scope of problems/issues in terms of business and/or system requirements and processes.
• Document and maintain operational processes.
• Manage Exact Target/Marketing Cloud implementation for a large enterprise, including multiple Business Units.
• Development of complex roles, permissions sets and assigning to users.
• Setting up all kinds of emails using HTML, CSS, Amp Script and personalization.
• Integration of Salesforce Marketing Cloud wif Salesforce and synchronized teh required objects and fields for teh campaigns.
• Client discussions facilitate marketing discovery and lead marketing projects/initiatives as needed.
• Using Amp Script functions to modify data in Marketing Cloud as well as used HTTP Post function to post data in Salesforce.
• Using Email studio, Automation Studio, Contact Builder, Journey Builder to build personalized campaigns.
• Compiling and setting up data using Query/Filter Activity. Providing support on SQL queries dat clients can run in their account to segmenting or group subscribers.
• Setting up Salesforce objects Service Cloud, Sales Cloud and their integration to Marketing Cloud via Marketing Cloud Connector.
• Developed Different Input methods for Salesforce Marketing Cloud to initiate Email campaigns, Triggered Emails, SMS, Push Notifications.
• User story gathering sessions for Digital Marketing engagements. Fetching/Modification of data using REST API.
• Used Journey builder in running more TEMPthan 250 different campaigns along wif Automation Studio and Contact Builder.

Environment: HTML, CSS3, Responsive Design, Email Marketing, Marketing Automation, Exact Target, Journey Builder, Postman, Deselect.

Confidential, Lincolnshire, IL

Salesforce Marketing Cloud Developer

Responsibilities:

• To develop, QA, and deploy journeys using teh marketing applications for marketing email, marketing web, and in-product Communications.
• Executed data-driven campaigns, email, mobile push, SMS.
• Drilling down problems and Designing solutions for Email Marketing Cloud Users using SQL Management Studio and Notepad++.
• Enabling dynamic content management and personalization usingAMP Script.
• Sent emails through Exact Target and track campaign results and efficacy. Leverage existing email templates to create new email campaigns.
• Built and maintained a dynamic email program, targeting email subscribers while collaborating wif clients to ensure relevant and impactful messaging for all recipients.
• Taking calls from Clients around teh world mainly US, UK and Australia and attending to their problems raised on emails, understanding teh issue and then connecting dat wif teh application knowledge dat has been imparted to me through rigorous training over teh year
• Monitoring their Email Jobs Mass Sends and Clearing teh Database Queues if they encounter any error
• Requesting teh details for Configuring Private Domains and Dedicated IP and Sender Authentication packages
• Constantly meeting teh SLA's defined for each client.
• Providing support on HTML based emails
• Providing support on SQL queries dat clients can run in their account to segregate or group subscribers
• Aggregating teh data collected for teh team over teh month and derive teh important information about monthly case closure and other information.
• Responsible for deployment to production including management of deployment logs and go-live release schedule. Consistently learn teh ins and outs of SalesforceExact Targetand its capabilities to stay competitive in teh email marketing space, including but not limited to: Automation Studio, Journey Builder, Amp Script, SQL, and SaaS.
• Primarily involved in developing prototype of teh application as Proof of Concept (POC) for business team and as a guideline for development team.

Environment: Marketing Cloud, Postman, Deselect, Toad, HTML, CSS, JavaScript, SSMS.

Confidential, Houston, TX

SQL Server DBA & Marketing Cloud

Responsibilities:

• Installed & Configured SQL Server 2016/ 2014/2012/2008 R 2/20 /32 bit versions on Windows 2012/2008/2003 R2 64/32-bit servers on Enterprise systems. Both on Windows Physical servers and Virtual Servers.
• Developed dynamic and personalized email campaigns using Exact Target (Amp Script, HTML, CSS), prepared SQL queries for teh Java-based platform tool to automate teh generation of segmented data extensions, connected live-site email trigger and off-site email platform wif Exact Target using interactions, tested emails in Linux environment, monitored email performances and remediated operational issues.
• Worked on generative data models using agile data.
• Deliver continuing support in teh 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.
• Migrated SQL Server SSIS packages from SQL 2005/2008/2012 to SQL 2008/2012/2014 wif effective planning.
• Engineered and implemented a database design to consolidate number of database instances.
• Reviewing and Deploying SQL changes as per teh software development life cycle
• Created email alerts wif teh reports of daily backups, maintenance jobs and security checks.
• Automating Database Backups of various user databases per teh requirement.
• Implemented Windows/ SQL Authentication scheme per teh application requirement.
• In depth knowledge and practical experience of implementing MSSQL HA/DR/Maintenance/Backup/Monitoring/Data Archiving strategies
• Monitored teh jobs using SQL Server Agent.
• Development and documentation strategy, of company best practices, policies, and directives
• Worked on SQL Server 2012 migration from SQL Server 2008.
• To ensure recoverability of teh Data Warehouse wif minimal loss of teh information which includes extensive testing of teh backup and recovery processes and taking backups full and incremental as needed

Environment: SQL Server 2005/2008R2 /2012, Windows Enterprise Server 2003, ORACLE 10g, IIS 6.0, UNIX, Erwin, Microsoft Visio 2003, SSRS, SFTP, Oracle RAC, DB2, Microsoft Silver light, Microsoft Reporting Services(SSRS)

Confidential, Houston, TX

SR DBA

Responsibilities:

• Worked wif a team for data access programming, physical database design, and implementation of Microsoft SQL Server.
• Database Analysis of each database which is part of old or unsupported Hardware and software.
• Documented and Maintained teh database instances across teh environment and worked wif teh procurement to allocate appropriate licensing to all teh servers
• Engineered and implemented a database design to consolidate number of database instances.
• Datacenter Migration wif SQL Server upgrades
• Worked wif a team responsible for teh 24x7 support of Microsoft SQL Server databases.
• Installed & Configured SQL Server 2014/2012/2008 R 2/20 /32 bit versions on Windows 2012/2008 R2 64/32-bit servers on Enterprise systems. Both on Windows Physical servers and Virtual Servers.
• Worked on Security and troubleshooting.
• Migrated SQL Server databases from SQL 2005/2008R2/2012/2014 to SQL 2008/2012/2014/2016 wif effective planning.
• Implemented teh new SQLServer 2012 mechanisms like data compressions, online indexing.
• Worked on Clustering and server consolidation, troubleshooting production issues and raising high availability.
• Worked on SQL Server 2012 migration from SQL Server 2008.
• To ensure recoverability of teh Data Warehouse wif minimal loss of teh information which includes extensive testing of teh backup and recovery processes and taking backups full and incremental as needed
• Create logical and Physical data models for various applications
• Designed and developed data models for new applications.
• Upgraded teh database from oracle 9i to 10g using DBUA, export/import utilities.
• Migrated SQL Server SSIS packages from SQL 2005/2008/2012 to SQL 2008/2012/2014 wif effective planning.

Environment: SQL Server 2005/2008R2 /2012, Windows Enterprise Server 2003, ORACLE 10g, IIS 6.0, UNIX, Erwin, Microsoft Visio 2003, SSRS, SFTP, Oracle RAC, DB2, Microsoft Silver light, Microsoft Reporting Services(SSRS), DB2, Share Point Server, SSIS, DTS, Erwin, Cluster Environments, Red Gate, Spot light, Solaris, SSIS, Oracle Clustered Environments, Oracle Replication environments, ADABAS. TCP/IP, Named pipes, LAN Sockets

Confidential, Minneapolis, MN

SQL DBA

Responsibilities:

• Designed and developed Asset tracker application including requirement gathering.
• Provide a high level of loan surveillance support to teh Asset Management team by monitoring and reporting on property level cash flows, rent rolls, market conditions and property valuations for a nationwide portfolio
• Upgraded SQL server 2000/ 2005/2008/2012 to SQL Server 2012/2008 R2/ 2008/2012/2014/2016 on Operating Systems Windows Server 2003 R2/ 2008 R2/2012
• Migrated SQL Server SSIS packages from SQL 2005/2008//2012 to SQL 2008/2012/2014 wif effective planning.
• Designed different database backup strategies for effective use of space and minimum time to recover when needed.
• Strategically invested in tools to minimize teh storage costs along wif teh time taken for running backup jobs.
• Automating Database Backups of various user databases per teh requirement.
• Automated refreshes from production to development database on a regular basis using PowerShell.
• Implemented backup and recovery strategy and performed full, incremental and cumulative backup using RMAN.
• Involved in Source Data Analysis and designing mappings for data extraction
• Developing, deploying, scheduling and troubleshooting for performing data transfers and ETL purposes across different database/file servers using SSIS.
• Responsible for Design and Development of SSIS Packages to load teh Data from various Databases and Files.
• Upgraded and redesigned several DTS/SSIS packages from SQL 2000/20 / 2008/2012/2014
• Upgraded and redesigned several SSRS RDL files from SQL 20 /2012/2014.
• Scheduled SSIS Package Jobs and monitored teh jobs using SQL Server Agent.

Environment: SQL 2000, SQL Server 2005, WINDOWS 2000, 2003, SSRS, SSIS, Crystal Reports 10.0, MS Access, Red Gate SQL

Confidential, Irving, TX

ORACLE/SQL SERVER DBA

Responsibilities:

• Organized database server system previously managed by non-DBA to support SDLC process and securing to eliminate teh vulnerabilities.
• Designed Disaster recovery process.
• Designed new security system to organize all teh security requirements.
• Responsible for data integrity, user security, daily monitoring for production and non-production systems.
• Involved in various Audit meetings both internal and external auditors.
• Designed and automated various Security/Audit reports using teh SSRS for auditors.
• Database Performance improvements by introducing various techniques.
• Consolidating database systems.
• Upgrade several database servers to teh latest versions.
• Experience on SSMS.
• Expert in implementation and administration of Oracle 11g/10g HA/DR architecture using RAC and Data guard.
• Extensive experience in Oracle 11g RAC and ASM installation and configuration on Linux and UNIX.
• Technical Consultation for teh entire database related items.
• Created email alerts wif teh reports of daily backups, maintenance jobs and security checks.
• Documenting teh database physical and logical design.
• Maintaining teh Application data flow from various systems.
• Created database snapshots before a deployment to ensure teh changes are rolled back wifout compromising teh time of availability in case of errors.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment. Performed teh Switchover, Switchback and Failure tests of teh primary and physical standby and verified teh successful catching up of standby wif teh primary DB.

Environment: SQL Server 2000/2005/2008/2008 R2 /2012, .NET, SSRS, SSIS, SSAS, DB2, DTS, Erwin, Cluster Environments, Red Gate, TFS, Spotlight.