Dinesh K Purushotham Email and Phone Number

• Gathered client’s business requirements and analyzed through document analysis and workflow analysis. Also communicated client’s business requirements by constructing easy-to-understand data and process models• Built and managed various marketing campaigns for various channels like Email, Direct Mail, Telemarketing and SMS using CRM tools such as SAS Customer Intelligence and SAS Enterprise Guide• Supported Marketing Automation for campaigns, reports, and database processes, and implemented effective solutions using existing systems• Monitored, tracked, and reported on campaign performance on a regular basis and provide recommendations to evolve future campaigns• Provided leadership in following up on various stakeholders’ campaign processes and adherence to timelines in campaign delivery as well as in evaluating the industry KPI’s on the different business units• Developed analytical files for marketing databases to support modeling/profiling and marketing activities; as well as developed analytical reporting for Marketing and Finance• Acted as a key contact on data insights and management between various marketing units and IT teams to provide necessary information and data analysis for customer and market knowledge• Established credibility with internal client-partners and to be the seen as a partner to the business with a deep expertise in campaign execution and delivering impactful results• Performed tests and validated all data flows and prepared all ETL processes according to business requirements and incorporated all business requirements into all design specifications• Supported as Subject Matter Expert (SME) for the projects in Marketing Data

Project: Campaign Lifecycle Reporting and Data Analytics Responsibilities• Gathered client’s business requirements and analyzed through document analysis and workflow analysis. Also communicated client’s business requirements by constructing easy-to-understand data and process models.• Provided input into developing and modifying systems to meet client needs and developed business specifications to support these modifications.• Performed source data model/data analysis, and target EDW data model/data analysis.• Analyzed and Retrieved appropriate data from the enterprise data warehouse (EDW) and BI table using the analytical tools like Alteryx, Teradata Studio Express and SAS Enterprise Guide based on the businessrequirements for the Enterprise Marketing Analytics Team.• Built SAS datasets and developed SAS coding and table templates for preparing, processing and analyzing data.• Designed and maintained the Logical /Physical Dimensional Data models and generating the DDL statements and working with the Database team in creating the tables, views, keys in the database.• Worked on cleansing of master data for challenges raised via Salesforce for Data Governance team.• Assisted the Data Stewards through ad-hoc analysis by writing queries that will extract information from the data warehouse.• Validated results from development and work with Data QA on repeatable data validation scripts.• Created and maintained data mapping documents including data lineage.• Created processes for maintaining or/and capturing metadata.• Maintained data dictionary.• Identified and documented all requirements for both fresh and current data warehouse components and reports by working with end users.• Ensured that data management methodologies include the steps, activities and deliverables required toconsistently achieve high-quality secure data.• Developed reports on Excel Write analysis based on compiled data.• Created multiple artifacts for CMMI Compliance.

Project: Campaign Performance ReportingResponsibilities:• Worked closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end to end designs meet the business and data requirements.• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.• Analyzed and interpreted all complex data on all target systems and analyzed and provided resolutions to all data issues and coordinated with data analyst to validate all requirements.• Created tables, views, procedures, functions and packages in database.• Developed all data warehouse models and prepared reports for all metadata integration into systems and drafted all ETL scripts and prepared required reports for all end users.• Performed tests and validated all data flows and prepared all ETL processes according to business requirements and incorporated all business requirements into all design specifications.• Monitored all business requirements and validated all designs and scheduled all ETL processes and prepared documents for all data flow diagrams.• Documented all technical and system specifications documents for all ETL processes and performed unit tests on all processes and prepared required programs and scripts.• Built and published customized interactive reports and dashboards and report scheduling using Tableau server.

Project: Directory Data Finder (DDF)As Data Analyst, my responsibilities are,• Collaborated with external teams to identify trends and system issues- analyzed data and identify ways to streamline system processes. • Created and perform SQL queries as per customer requirements. • Created and maintained documentation of incident analysis, system and reporting requirements, and operational processes. • Reviewed error reports post data load to Production environment to determine data gaps or areas for improvement. • Tested any scripts built by team and deployed them in Production via Sales Force tickets. • Analyzed, documented, and communicated project risks to senior level executives. • Provided design and development requirements for the Engineering Team. • Research & Development of the Product enhancement with regard to the Customer’s requirements. • Provided Product Demo and Product training to Business Customers. • Created and documented the Methods and Procedures for the process. • Subject Matter Expert (SME) for the process. Project : Non Bonded Trading Partner Setup – Inter Connection AgreementResponsibilities include,• Reported directly to the onshore team.• Worked/Created SalesForce tickets for the request received from internal/external customers/Account Managers to add new carriers for porting using Client’s systems for LSR/ASR interface.• Located the new Carrier contact information using resources such as Google and contacted the company to procure the porting information that client requires via phone/email.• Created Non Bonded Routing information to add/change/delete/ tables in production and verified the same after completion of maintenance window.• Created and perform SQL queries as per customer requirements.• Troubleshooted issues related to Non Bonded Routing and escalated to the next level via Email/ SalesForce Tickets if changes need to be made in Production.

Responsibilities included configuration of routers, troubleshooting of networking devices, server backup and wifi security. Maintains records of work completed and in-progress; and updates network documentation to record installations, upgrades and configurations. Assists with Engineers for network components, cabling, and wiring for new implementations or upgrades. As IT Admin responsibilities included maintaining the day-to-day operations of the IT infrastructure such as system back up, server and network maintenance and hardware and software related issues..