We provide IT Staff Augmentation Services!

Led Analysis Solution Sesume Profile

2.00/5 (Submit Your Rating)

Summary of Competencies

AS 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

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.

We'd love your feedback!