PROFESSIONAL SUMMARY:

• With total experience of more than 5.6 years in SAS, have been able to work as SAS Administrator, Developer and analytics on 6 different EBI environments with 3 SAS Tiers configured on 28 servers popular as SAS Grid (9.3) architecture.
• Exposure to concepts of Data warehouse, Business intelligence, ETL and Reporting.
• Having functional knowledge in Banking/Finance, Credit card domains.
• Experience in working in large and complex projects with tight time line.
• Have confident, articulate and professional communication skills with good customer facing ability.
• Experience in managing a team of 10 - 15 members as an offshore/Onsite team lead and prioritize the work to meet the timeline.

TECHNICAL SKILLS:

Languages: Base SAS, Unix/Linux shell scripting, PL/SQL, DOS

Database/Servers: SAS-SPDS,Oracle, MS-SQL,Informix

Operating Systems: Solaris/Linux,Windows, DOS

Other Software/Tools: DWH, BI, Autosys, Crontab, AT Schedulers,Weblogic Console, SQL Plus, SVN,SQL Developer,Informatica, Business Objects,WinSCP, Putty, PSFTP, R studio, Bigdata, Haddop, Hive, Cloud,AWS, Citrix and VNC viewer etc.

PROFESSIONAL EXPERIENCE:

Confidential

SAS/SPDS Administrator

Responsibilities:

• Experience in providing Administrative support for SAS GRID 9.x (30 Servers) and SAS Visual Analytics 7.3(15 blade Server) end to end.
• As a SAS Grid administrator, experienced with tasks of day-to-day issues, tickets and sas services maintenance along with Ad-hoc/emergency changes/modifications.
• Performing SAS services account password updates using SAS deployment Manager.
• Maintaining SAS services. Do a scheduled restart of web/meta/compute services.
• Knowledge in Setting up queues and server for Grid submission.
• Knowledge on using Server Migration Utility (SMU) to migrate data center.
• Doing Admin related work using SAS Management console like creating user/group/role in SMC, Creating libraries /servers/authentication domains, administering SAS metadata objects/folders etc.
• Analyzing SAS logs to find out the root cause of job failure or error and rectifying that as needed.
• Publishing reports into the SAS Information delivery portal. As a portal/content admin I make sure that required portal content should be shared with required group of people, to maintain the security of reporting/data.
• Maintaining SPDS Database, SPDS services, SPDS schemas/libraries and SPDS password database. Managing users/groups addition/updation/removal in SPDS database.
• Working on SPDS clustered tables to load/update data.
• Working on SPDS table/Library level ACL access, I ensure that the correct group/user is assigned correct ACL on the required SPDS objects, to maintain the data security.
• Worked on License renewal for SAS, SPDS, LSF, PM and RTM.
• Hotfix installation for desktop tools and for in SAS applications server level to improve the performance and avoid bugs.
• Installation of SAS client applications (Management Console, DI Studio, OLAP Studio, Information Map Studio, WRS and Enterprise Guide)
• Involved in Weekly maintenance of SAS severs. Restarting all SAS servers and sanity checks from SAS products.
• Implementing security on all metadata objects (using metadata ACTs) and File systems on linux/unix.
• Establish formal, regularly scheduled backup processes for metadata and other required objects.
• Knowledge in installing SQL standalone server and experience in using SQL management studio.
• SAS 9.3 Grid server administration, SAS consultation, Platform Administration and Maintenance, handling server issues, creating database connections using ODBC and TNS files from SAS to SQL, Oracle and Informix DB. Troubleshooting SAS server issues, providing maximum server availability etc.

SAS Consultant/ Developer

Confidential

Responsibilities:

• Experience in requirement gathering, analysis, planning, designing, coding and unit testing.
• Deciding project plan for implementation of ETL and Reporting capabilities with proper SDLC process.
• Proven skills in data cleansing, data archival, data migration, ad-hoc reporting.
• Experience in handling software development, enhancements, testing and documentation.
• Excellent communication, interpersonal skills and a good customer facing ability.
• Ability to manage a team as an offshore lead as well as Onsite team lead and prioritize the work to meet the timeline.
• Experience in mentoring the team members whenever it’s required.
• Participated in various technical interviews for selecting candidates for team/project.
• Testing each and every bit of code with various test cases before deploying it to production.
• 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, and PDF.
• Involved extensively in ETL tools (Extraction, Transformation, Loading) like BASE SAS,Advance SAS, SAS MACROS,SAS BI/DI, SAS EG,SAS Visual analytics.
• Experience in VA Data exploration, report designer and Administration.
• Experience in developing complex SAS programs, macros for data updates, data cleansing, and reporting in SAS Data integration studio using various transformation.
• Participated in code reviews.
• Developed SAS code using Macros to run recurring jobs and optimized code
• Following up with SAS Technical support for the issues faced. If needed, we install the required hotfix as suggested by SAS Tech Support.
• Taking care of ad-hoc client issues and resolving them ASAP. Ad-hoc client issues may include code modification, code development, admin related issues, SAS desktop tool issue or any SAS web applications based issue.
• Taking care of all the ad-hoc issues faced during ETL/reporting process.
• Create new reports/dashboards using SAS stored process/IMAP/Table/OLAP cubes.
• Taking care of all process improvements and developing codes when needed.
• Have experience in SQL. As we pull data using SQL queries for reporting purposes.
• Expert in using SAS EG and PC-SAS. Creating SAS stored process /programs/projects/reports in SAS EG 5.1/7.1.
• Used Data integration studio to create jobs and deploy jobs for scheduling using various schedulers.
• Have experience in using Job schedulers like Crontab,AT, Autosys and LSF scheduler.
• Used Information Map Studio for creating IMAPS from sas datasets/stored process/cube.
• Establishing connection from SAS to various DB like oracle/Informix.
• Creating sas/spds/oracle libraries in SAS management console.
• Skills in providing value add to save the manual effort which will be cost saving to the Business.
• Passionate & enthusiastic in analyzing and solving logical problems & real-time business scenarios
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction.
• Establish ssh password less connection from server to server (unix/linux). Establish the NDM connection from our SAS servers to external servers like First Data, Gentran etc.
• We receive data from external sources like Confidential, process and load them accordingly. Also create SAS reports from them as per business requirement.