SAS PROGRAMMER, Business

Analytics

• Results-driven lead SQL programming analyst with extensive experience in financial services and other verticals. SAS 9 Base, Advance certified.
• Able to incorporate user needs into clearly-defined, actionable and measurable solutions based on large and small data sets.
• Innovative thinker of next-generation data solutions for P L improvements.

Technical Summary

• MS Office 2013/2010/2007 MCAS objectives : Access, Excel advanced add-in and built-in tools PivotTables, ODBC Links, vlookups, Macros, Statistical and Data analysis Functions, Charts , Word, PowerPoint, Outlook
• Operating Systems: Windows 8.1/7/Vista/XP, Mainframe, Unix AIX , Windows Server
• Programming Languages: SQL, SAS Base, HTML, JCL, VB, ASP.Net
• RDBMS: DB2, Oracle 10g, MS Access, MS SQL Server 2008/2005/2000
• CRM BI: SAS Base/EG/EM/STAT, Business Objects, ATG, Crystal Reports, Cognos ReportNet, Unica Affinium, SalesForce, Market2Lead, Epiphany

Experience

Confidential

• Developed and supported marketing and finance programs analyses using reusable SQL and SAS codes and related MS office tools. Accomplishments:
• Developed SQL code, maintained programming plans for daily, monthly and ad hoc report solutions. Coordinated pilot programs rollout based on reporting and analysis deliverable.
• Replaced time-consuming, error-prone manual processes with elegant, process automation, macros and functionality enhancement solutions.
• Validated test segments to find, report and ensure data quality.

Confidential

• Analyzed codes for testing, benchmarking and debugging for support of e-mail marketing measurements and communications. Accomplishments:
• Led solutions leveraging Epiphany, MS Access data processing and functionality enhancement for post-programs metrics analysis.
• Guided integrated marketing strategic plans through industry analysis and quantitative company and IT client audience attributes.

Confidential

• Led analysis solutions that involved Unica Affinium data processes and functionality enhancement. Accomplishments:
• Extracted customer lists of various sample sizes for a range of direct mail, event marketing and corporate initiatives.
• Monitored and resolved agency vendor file processing issues. Reviewed NCOA/CASS exception reports with MS Access and Excel.

Confidential

• Progressed through promotion, culminating in responsibility for database-focused programming applications within high-demand report volume setting.
• Led solutions that involved process automation, macro conversion and functionality enhancement. Replaced time-consuming, error-prone manual processes with elegant, automated SAS code for scheduled data processes.
• Delivered a minimum 150 customer lists, recurring reports and ad hoc analyses yearly using SAS codes, Business Object Universes and Microsoft Excel PivotTables. Designed PowerPoint presentations with executive summary of key findings.
• Leveraged SAS Base procedures and data steps including PROC SUMMARY, PROC UNIVARIATE, PROC REPORT, PROC MEANS, PROC TABULATE, PROC COMPARE, PROC DATASETS, and ODS for automated deliverable summaries.
• Reengineered multiple systems that fueled improvements to productivity, efficiency, uptime and accuracy for national retail and third party business marketing operations. Developed code, system design and test/QA plans for all solutions and often coordinated multi-dimensional rollouts.
• Supported the launch of several mutual fund products, including Premier High Income, Premier Balanced Opportunity, Premier Yield Advantage. Provided lists for marketing and investor fund prospectus notifications.
• Delivered automated back-end analysis KPIs based on program promotion history to support direct mail, e-mail, call center initiatives, enabling company to compete more effectively in the top 10 investment firms' marketplace.
• Conducted extensive and frequent user acceptance tests and helped improve data hygiene before and after direct response database files daily, weekly and monthly load processes.
• Managed database marketing services across distribution channels. Supervised a team of two analysts for close to two years. Promoted from lead analyst to Assistant Vice President within two years.

Confidential

• Developed new procedures for requirements gathering, needs analysis, testing, scripting and documentation to strengthen quality and functionality of business-critical data warehouse applications.
• Served as a core group member in defining and prioritizing technology investments for the next two years, ensuring the alignment of process, technology and business objectives.
• Trained and guided team analysts, new hires, intern, and IT programmers in SAS, data analysis methodologies and best practices.

Confidential

• Designed and automated monthly MIS reports to track acquisition campaign results of consumer credit card offers, including Reward products such as Sony card and ClickCredit online-only-product.
• Developed SQL and SAS code, designed and tested QA plans for all solutions and coordinated monthly and ad hoc marketing rollout.
• Supported reengineering of datamart systems to fuel improvements to productivity, efficiency, uptime and accuracy for global business MIS operations reports.