We provide IT Staff Augmentation Services!

Sr. Sas Developer/analyst Resume

2.00/5 (Submit Your Rating)

Northbrook, IL

SUMMARY:

  • Certified SAS Analyst/ Programmer & Data Modeller with more than 8 years of experience in E - Commerce, Financial Industry & Supply Chain.
  • Worked with Supply Chain Managers for requirement gathering and providing solutions that affect the business directly which include taking decisions and inventory management processes.
  • Closely worked with statisticians to provide analysis on business problems like Revenue Loss Analysis, System Monitoring, Deletion Model etc.
  • Structured &optimized programming techniques implemented on various legacy systems to improve execution time and faster delivery of results.
  • Successfully worked with marketing team for analysing campaigns and conversions results for increasing the business opportunities.
  • Lead Data Management team for 3 years. The primary goal of the team was to provide datasets required by statisticians and other teams for revenue analysis & reporting.
  • Weekly, Quarterly and adhoc reports requests delivered by using SAS Programming to analyse revenue, cost, margin and performance reports.
  • Communicated with Engineering, Infrastructure and other teams for better flow of data in SAS through Oracle, MySQL, Hadoop, and raw files etc.
  • Optimized legacy systems by improving programming methodologies by using Macros and dynamic user input methods to make system more independent and user friendly.
  • Strong experience in in- corporation various Google search engine updates: Hummingbird, Mobile User Friendly Update, Panda, and Penguin etc.
  • Excellent interpersonal, communication & problem solving skills for delivering useful and time efficient solution.

PROFESSIONAL EXPERIENCE:

Confidential, Northbrook, IL

Sr. SAS Developer/Analyst

Responsibilities:

  • Worked on critical complex problems and provided mathematical solutions.
  • Optimize various database related processes and auto scheduling.
  • Worked on processes that directly impact the decision of Supply Chain Managers.
  • Automating various processes that includes high use of macros and inputs from clients.
  • Worked with various SCMs to gather requirement and developed processes with flexibility to modify certain parameters if required.
  • SCMs various requests on new processes and excluding/including various parameters that impact the decision.
  • Worked on various Inventory Management processes that shows the exact stack requirement in various stores and when delivery needs to be done.
  • Helped in building various Tableau reports by providing data-marts depending on requirements which include various databases like Netezza/DB2/Hadoop

Environment: SAS Studio, SAS/BASE v9.4, SAS EG v7.12, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/ACCESS, Hadoop, Netezza, DB2, MS EXCEL

Confidential, Jersey City, NJ

Senior Analyst/ Data Modeler

Responsibilities:

  • Generate various reports to measure marketing campaign using Tableau.
  • Develop various excel/pivot table based reports to SAS.
  • Extensively used Macros in order to run report for different matrices and periods.
  • Work on campaigns related to promoting new products and successfully analyze data for those campaigns and educating clients.
  • Successfully maintained the Adhoc process and enhanced the process to turn around reports to business partners in a timely manner.
  • Campaigns were evaluated based on various matrix, a new account cost associated with the offers in the campaign and also based on client responded v/s non-responded.
  • Created monthly and quarterly reports with overall base client profiles to be shared with upper management in order to make more informed decisions using Tableau.
  • Contribute to the teams on intra projects as a team player.

Environment: Tableau, SAS/BASE v9.4, SAS EG v7.12, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/ACCESS, Hadoop, MS EXCEL

Confidential

Sr. SAS Developer

Responsibilities:

  • Developed data simulation and graphical presentation for various clients.
  • Implemented ad-hoc SAS programs to create result reports for simulation
  • Successfully created, modified and generated Week over Week (WOW) reports and Month over Month (MOM) reports summarizing sales business activity.
  • Discussed & implemented various DB changes to smoothen various ongoing projects data storing/fetching/reporting problems.

Environment: SAS/BASE v9.3, SAS/SQL, SAS/MACROS, UNIX, MS EXCEL

Confidential

Marketing & Data Analytics/Modeler

Responsibilities:

  • Involved in Marketing Project to gather data from different sources and generating various business reports with metrics in various business areas like Revenue Monitoring, Revenue Loss, Deletion Model, Line of Business Forecasting etc.
  • Developed optimised and time based solution for revenue business problem driven by data to support hypothesis.
  • Measured key performing indicators to identify which variables are helpful in reducing or projecting revenue loss/gain for business problem in hand.
  • Interacted with Marketing Managers and data management team to validate the data import and missing value transformation by writing edit checks as per SEMrequirement.
  • Analysis of data for ensuring data is reliable for creating and updating various data definition tables w.r.t most recent data populated.

Environment: SAS/BASE v9.2, SAS EG v7.1, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/ACCESS, Hadoop,UNIX, MS EXCEL

Confidential

Sr. SAS Developer

Responsibilities:

  • Worked on several Adhoc requests received from Marketing Analysts in order to fulfil their business needs, monthly, quarterly reports requirements.
  • Worked towards Automation, Optimization and effective utilization of legacy system.
  • Worked on Migration of In-house Developed Applications/reports from SAS Datasets to SAS BI in order to optimize the execution time, resources and to reduce the cost of process.
  • Created Data transformation and Data Loading (ETL) scripts for Data Warehouses.
  • QC and Validation of data with various team for resolving missing data issues w.r.t various teams/fields.

Environment: SAS 9.2, Windows SAS, UNIX, Hadoop, MySQL, Oracle

Confidential

Lead Data Management/ Developer

Responsibilities:

  • Lead a team of 12 members, whose primary goal was to collect data from various sources in system and provide datasets for Statistical/modelling purpose .
  • Adhoc requests include creating datasets for reporting, macro based codes for reuse and user input, creating monitors for successful data downloads, flowcharts indicating input datasets & techniques for desired problem solution.
  • Supporting data analyst with legacy systems development changes.
  • Used various sources like Oracle, MySQL, and Rawunstructured Data File etc. for gathering data and generate data marts .
  • Raising risks providing mitigation plans for the same.

Environment: SAS, SEMRush, Putty, Ad-Words/adCenter, Unix Scripting, Bug tracking tools

We'd love your feedback!