Amey Yogesh Email & Phone Number

Houston, Texas Area

• Responsibilities:
• Participated in marketing campaign- planning meetings with Marketing managers, Managers in order to develop and document campaigns specifications.
• Gathered Business Requirement specification, Table Specs and Functional specification documents and communicated with the marketing manager to know the type of reports to be developed.
• Understand Behavior, Bankruptcy and other Scoring models developed by Line of Business.
• Worked on the Attrition report to analyze the in depth attritions and knowing their impacts.
• Developed and operated Portfolio acceptance report.

Houston, Texas Area

• Responsibilities:
• Provided insights on effectively running of marketing campaigns including direct mail, email, mobile and other digital channels.
• Meetings with business stakeholders and end users to development segmentation strategies and add efficiencies to the campaign development and execution process.
• Developed marketing agenda for learning the market and designed the testing cells as well as executed the implementation of the learning plan.
• Generate reports, listings and graphs using SAS/Base, SAS/Macro and SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS and SAS/connect.
• Extract the data from a data warehouse and create ad-hoc reports, tables, and graphs according to Business needs.

Buffalo/Niagara, New York Area

• Responsibilities:
• Imported data in the form of SAS datasets from flat files of various formats like delimited,.CSV,.XPT etc.
• Created SAS datasets using BASE SAS and SAS/SQL using SQL Pass-through facility from tables related to clinical trial data stored in Oracle databases.
• Cleaned and analyzed the data sets using DATA _NULL_, PROC FREQ PROC MEANS and PROC UNIVARIATE.
• Developed programs for analyzing datasets, summarizing key clinical trial data.
• Generated tables, listings and graphs in accordance with approved statistical analysis plan (SAP).

Greater New York City Area

• Responsibilities:
• Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Worked on updating and maintenance of data warehouse and generation of various sales and marketing reports.
• Worked on creating SAS Data sets from flat files and merging data.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.

Illinois

• Responsibilities:
• Coordinated and monitored the exchange of millions of records daily between internal teams, industry clearinghouses, other billing vendors, and data centers in the US and Mexico
• Assigned/managed workload for a team of programmers
• Supervised and participated in development reviews and code walkthroughs
• Analysis and software development
• Performed all phases of software development life cycle as an individual contributor

India

• Responsibilities:
• Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data.
• Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database.
• Created customer mailing lists for Direct Mailing and Telemarketing using PROC Forms.
• Extensively used PROC Import and PROC Export procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables.
• Maintained and enhanced existing SAS Reporting programs using PROC Tabulate, PROC Report, PROC Print, ODS RTF, and ODS PDF for marketing campaigns.