Sr.SAS Programmer/Analyst - Neiman Marcus - Irving, Texas
(2020-05)
Strong SAS programming background for creating, maintaining existing code, ad hoc reporting and supporting the reporting functions. Worked with e-commerce operation team to develop various reports on daily business needs. Experience in Base SAS, SAS/MACROS, SAS/SQL, SAS/Access, SAS/ENTERPRISE GUIDE, and SAS/ODS on Windows as well as Mainframe platforms and competence in carrying out statistical analysis of large-scale data.
- Possess excellent skills with PROC SQL, SAS Arrays, SAS Base procedures, summary procedures and especially Data Step programming and reporting.
- Expertise in using various SAS report generating procedures such as: PROC REPORT, PROC FORMAT, PROC COMPARE, PROC EXPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE, PROC COPY, PROC SUMMARY, PROC IMPORT.
- Generated reports using PROC REPORT, DATA _NULL_ and PROC TABULATE for customized report writing.
- Generated daily, weekly and monthly reports using PROC REPORT and SQL.
- Experience in requirement gathering, analysis, planning, designing, coding and unit testing.
- Experience in SAS to extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
- Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and MS Access tables.
- Thorough hands-on experience in using SAS/ODS to generate different files including XML, CSV, MS Excel, PDF and HTML.
- Experience in Modifying existing SAS programs and creating new SAS Programs using SAS Macro to improve ease and speed of modifications as well as consistency of results.
- Involved extensively in Data Extraction, Transformation, Loading.
- Experience in developing complex SAS programs, macros for data updates, data cleansing, and reporting.
- Expertise in using Relational DBMS like Access, Oracle and DB2 Database Systems.
- Performed end-to-end SAS programming activities such as data processing, data collection, and analysis, testing and deployment of the prod code.
- Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
- Highly motivated, Organized Team player with excellent analytical, communication and leadership skills.
- Associated with Project managers, team members / associates, business analysts, statisticians, and internal customer's/ end users to consolidate and validate the reports.
- Possess strong ability to quickly adapt to new applications and platforms.
Sr.SAS Programmer/Analyst - JCPenney - Plano, Texas
(2013-05 - 2020-05)
J.C.
Penney Company
Inc. is a mid-range chain of American general merchandise & apparel retailing stores based in Plano, Texas, a suburb north of Dallas. The company operates 1,110 stores. J. C. Penney operates by stores, online and catalog sales merchant offices nationwide in many small markets. The overall goal of the project is to implement enhancements to the existing jQuery reporting Systems for eCom Operations. jQuery is a JCPenney in-house custom built application that caters to multitude of Business functions and users for their data-driven reporting needs. In current competitive retail business, JCPenney needs to change the reporting requirements quite often for data analytics and to take strategic decisions. The jQuery system needs changes to serve this purpose. As part of analytics team, my role was to extract the data from various sources, create an automated sas programs to load data into SAS datasets on schedules basis as well as create ad-hoc reports to fulfill the business needs.
- Created, modified/Updates SAS code to incorporate changes in new releases of the product.
- Involved in Analysis, development, testing, implementation and provided technical support to business needs.
- Produced ad hoc reports in SAS for various departments upon request for in-depth analysis.
- Data manipulation by merging, appending and sorting datasets.
- Extensive use of PROC SQL to create subsets of data for further analysis.
- Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures for in-depth analysis.
- Extensive use of DATA STEP, PROC MEANS, PROC SQL, MACROS, PROC FREQ, PROC TABULATE, DATA _NULL_, PROC MEANS, PROC SUMMARY, RETAIN.
- Used SAS - output delivery system ODS to format reports in HTML, PDF, CSV and RTF reports.
- Optimized SAS code to reduce run time and make the process more efficient.
- Developed efficient, well documented, readily comprehensible and modifiable SAS code using SAS/BASE and SAS/MACRO facility.
- Excellent team player with high level of personal initiatives
- Ability to handle multiple tasks simultaneously
- Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.
SAS Programmer - Tata Consultancy Services - Chennai
(2007-02 - 2012-12)
Nielsen Media Research is the world's leading provider of television, radio and print audience measurement and advertising information services. Nielsen provides comprehensive television audience measurement at national and local levels in the U.S. and, through its AGB Nielsen Media Research joint venture, in 30 countries around the world. Nielsen also provides information about advertising expenditures and creative content in worldwide markets.
They are headquartered in New York, with offices throughout the United States. The objective of the team is to provide Production Support for various applications and make enhancements to the systems when required as well as research on problems / discrepancies and recommendation of changes to processes.
- Created, modified/Updates SAS code to incorporate changes in new releases of the product.
- Used SAS Macros and procedures like Proc SQL, Proc Transpose, Proc Univariate, Proc Means, Proc Freq.
- Produced ad hoc reports in SAS using .txt files upon request for in-depth analysis.
- Extraction of data from Data Ware housing tables and Data marts.
- Extensive use of PROC SQL to create subsets of data for further analysis.
- Gathered the requirement business team and analyzed the data.
- Analyzed demographic data to identify outliers.
- Been a part of the project planning process and came up with valuable recommendations.
- Manipulated the data and modified the code wherever necessary using SAS functions and PROC SQL statements, formats, informats.
- Maintained and enhanced existing SAS reporting programs for Media Research team. Involved in the code review to make sure the output is as we expected and the efficiency is met.
- Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
- Optimized SAS code to reduce run time and make the process more efficient.
- Troubleshoot process failures and implemented process improvements.
