We provide IT Staff Augmentation Services!

Resume

Graduate Assistant Senior Associate Toledo, OH

CAREER FOCUS:

Solution - driven and meticulous programmer with in-depth understanding of web technologies and focused on delivering streamlined and accurate reporting. Able to delegate time effectively, manage projects efficiently and work well independently or in a team environment. Resourceful in applying problem solving skills to overcome challenges with determination and commitment. Adept at learning quickly and easily grasps new concepts, ideas and technologies. Fluent in English, Telugu and Hindi. Strongly interested in a position as a SAS Programmer Analyst.

PROFILE SUMMARY:

  • Excellent knowledge of SAS Enterprise Guide, Base SAS, Macros, SAS SQL and SAS Access.
  • Worked closely with the project team and involved in development and enhancements of SAS Programs.
  • Extensive knowledge in data management like Merging, concatenating, interleaving and moving of SAS datasets between platforms.
  • Generated reports using data null and procedures like Proc Print, proc SQL, Proc Tabulate and Proc Report.
  • Created user defined Templates using Proc Template Procedure.
  • Successfully handled the extraction of data from different sources like Teradata and Sybase.
  • Strong working knowledge with the analysis of banking data, generated high quality reports using SAS ODS like HTML, PDF and RTF formats and summaries as per business requirements and company standards.
  • Experience with extraction, and migration of data and simple statistical data analysis using statistical functions, options and procedures such as Proc Freq and Proc Means.
  • Created Data mart to store the finalized historical data for future analysis.
  • Perform ad-hoc data analysis to support the business initiatives.
  • Respond to Ad hoc reporting requests by creating reports as needed for specific situations

TECHNOLOGY SKILLS:

Microsoft Word Microsoft Excel Microsoft PowerPoint Microsoft Access SQL Sybase Teradata SAS (Statistical Analysis System) Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential, Toledo, OH

Graduate Assistant Senior Associate

Responsibilities:

  • Compile JP Morgan’s P-Card packets monthly and reconcile supporting documentation to the printed transaction report.
  • Created report in Excel to track the Professors who are teaching Undergraduate level course but are now qualified to teach Graduate and Doctoral levels.
  • Collaborated with Senior Associate Dean on editing video lectures and integrating them into the media-site server.
  • Assisted the Senior Associate Dean in creating Data Input forms in Microsoft Access for storage of collected information about COBI Alumni.
  • Hosted the New Student Orientation for Graduate Programs in COBI, introduced the presenters such as the Dean, Professors and Staff Members as well as announced activities such as Speed Networking and Student Panels.
  • Worked for both the Senior Associate Dean and Graduate Advisor for a semester and assisted Advisor with the development of a robust website offering easy access of resources and materials to potential, new and current graduate students.
  • Trained by the Graduate Advisor to assist on answering graduate students’ plan of study questions as well as additional questions about the graduate program.
  • Collaborated with Graduate Advisor on analyzing tuition and stipend utilization in order to reconcile the budget that semester.

Confidential

SAS Programmer

Responsibilities:

  • Extraction of data from flat files, data warehouse and database.
  • Performing data validation using data step.
  • Created reports as per the Client requirement using different SAS Procedures like Proc Report, Proc Print, Proc Tabulate, Proc SQL and Proc Transpose.
  • Created drill downs using call define and complex macros in report procedure which helps the business user to view the report at different levels (location, zone, Region, Branch).
  • Automated the process of emailing the reports to respective recipients using Filename and ODS HTML.
  • Developed complex SAS Macros to expedite SAS programming activities and usage.
  • Collected the analyzed data and created a data mart to store data permanently in the database on a daily and monthly basis.
  • Transforming data from RDBMS oracle to SAS datasets.
  • Coordination among the team members on various enhancements in the process.
  • Excellent communication with the business people and understanding the business requirements.

Confidential

Team Member

Environment: SAS EG, SAS/MACROS, SAS/STAT, SAS/ACCESS, SYBASE.

Responsibilities:

  • Extraction of data from flat files and created into dataset.
  • Importing the data using LIBNAME and SQL Pass through Facility.
  • Performing data validation using data step.
  • Transforming data from RDBMS oracle to SAS datasets.
  • Data analysis and producing different reports using SAS.
  • Registering the libraries in the repositories created in the SAS Database.
  • Creating reports as per the Client requirement using different SAS Procedures like Proc Report, Proc Print, Proc SQL and Proc Transpose.
  • Creating customized reports in HTML and PDF format using SAS ODS facility.
  • Creating drill downs using call define and complex macros in the report which helps the business user can take a look at any levels (location, zone, Region, Branch).
  • Mailing the reports automatically to respective recipients using Filename and ODS HTML.
  • Providing the data dumps to Business for high end analysis purpose.
  • Transferring data between databases using import and export.
  • Collecting the analyzed data and creating a data mart to store data permanently in the database on a daily and monthly basis.

Confidential

Team Member

Environment: SAS EG, SAS/MACROS, SAS/ACCESS, SYBASE.

Responsibilities:

  • Extractions of data from flat files like csv, excel, txt etc. and created into dataset.
  • Importing the data using LIBNAME and SQL Pass through Facility.
  • Performing data validation using data step.
  • Data analysis and producing different reports using SAS.
  • Registered the libraries in the repositories created in the SAS Database.
  • Creating reports as per the Client requirement using different SAS Procedures like Proc Report, Proc Print, Proc SQL and Proc Transpose.
  • Creating customized reports in HTML and PDF format using SAS ODS facility.
  • Mailing the reports automatically to respective recipients using Filename and ODS HTML.
  • Providing the data dumps to Business for high end analysis purpose.

Hire Now