SUMMARY:

• SAS Programmer with experience in software development, design, analysis, coding, implementation, maintenance and support as a SAS Programmer/Developer/Analyst with profound experience in banking, healthcare, financial, transportation, clinical and entertainment industries.
• A versatile SAS programmer with professional IT experience in software development, system design & documentation and implementation, as a SAS Programmer/Analyst with extensive knowledge in Banking, transportation, clinical and financial industries in different environments like UNIX, windows and worked with different databases like DB2, Teradata, Oracle and SQL Server
• Experience in developing different methods of Extraction, Transformation and Loading (ETL) into data warehouse
• Good knowledge of SAS Enterprise Guide
• Excellent understanding of data management principles, database design, data analysis, and data manipulation
• Experience working with SAS BI tools such as SAS Enterprise Guide, SAS Information Map studio, SAS Management Console, SAS Data Integration Studio, SAS Web Report Studio and SAS OLAP Cube Studio
• Extensive expertise in data manipulation, data analysis, data validation, data cleansing and data warehousing to generate customized reports with SAS data steps, procedures and macros
• Proficiency in using SAS/ACCESS to import various external data files into SAS library, and extensively used SAS Proc SQL for advanced data query
• Extensive experience and proficiency in using SAS ODS to create output files in a variety of formats including RTF, HTML and PDF
• Thorough work knowledge of using ODBC to connect SAS System with relational database management systems to retrieve data and create SAS datasets
• E xperience in developing routine codes with SAS Macro facility
• Solid knowledge of databases and ability to manage large volume data/database
• Proven ability in market segmentation by dividing customers into appropriate levels and recommending suitable techniques
• Proven ability in gathering customer behavior data from a wide variety of data sources to identify actionable insights for improvement
• Performed a crucial role in gathering report requirements and preparation of the report design documents
• Strong analytical background
• Met scheduled timelines for all projects, in an effort to be efficient while applying business solutions for the client
• Experience in resolving customer problems, ticket issues and troubleshooting support problems
• Confident, self - motivated and a team player. Self-oriented with analytical skills

TECHNICAL SKILLS:

Statistical Software: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/Access, SAS/EG, SAS/STAT, SAS/Access, SAS/CONNECT, SAS/ODS, SAS/IntrNet

Database: Teradata, Oracle, DB2, MS-SQL Server, MS Access

Operating Systems: UNIX, MS Windows (95, 98, 2000, NT, XP), MS-DOS, MVS

Languages: SQL, PL-SQL

Web Development: HTML, CGI/PERL, JavaScript, Microsoft office Frontpage 2003

Microsoft Office Software: MS Office (Word, Excel, Power Point, Access)

WORK EXPERIENCE:

Confidential

SAS Developer Analyst, Austin, TX

Responsibilities:

• Prepares a variety of reports, studies, and other deliverables containing analyses of health and human services data
• Planned and/or conducted highly advanced research on the agency’s programs
• Developed and implemented research methods and analytical procedures, assessed validity of statistical methods and/or procedures for appropriate application; applies advanced statistical methods to health and human services related data
• Coordinated project design, planning, statistical analysis, and/or reporting; and wrote advanced scripts and code for computer based statistics applications
• Provided consultation and assistance to internal staff and other HHS agencies in developing methods and strategies for effective reporting of data and analyses
• Provided for testing and evaluation of newly developed knowledge, methods, and techniques
• Defined requirements for development/modification of agency interface files and tests for accuracy, reliability, and validity
• Consulted in policy development and revision to determine impact on reporting capabilities and current/future research
• Performed other duties necessary to achieve the mission of the Health and Human Services Commission
• P rovided key research, analytical and reporting functions for the Data Quality and Dissemination teams, Strategic Decision Support Division, management, legislative entities, and HHSC constituents to support policy development and program evaluation
• Worked under minimal direction with extensive latitude for the use of initiative and independent judgment
• Applied advanced statistical methods to health and human services related eligibility, medical utilization and expenditure data
• Enhanced understanding of health and human service agencies, programs and issues, prepared a variety of reports, studies, and other deliverables for the administration and policy personnel containing analyses of health and human services data, the methods and procedures used
• Participated in the annual North American Association of Central Cancer Registries (NAACCR) certification process to produce new set of Cancer in North America (CiNA) data products
• Submitted incident cancer cases from Confidential registry for the years 1995 through 2014 to NAACCR to be used for cancer statistics, surveillance, and research projects and activities using the NAACCR Record Layout Version 16 for data
• All variables conformed to NAACCR standard definitions and codes, as described in Volume II, Version 16 of the NAACCR Standards for Cancer Registries: Data Standards and Data Dictionary
• Refreshed Tableau dashboard for Confidential Completeness dashboard to show Percentage completeness by Health Service Region, Percent complete by county and cases needed by county on a weekly basis
• Followed Multiple Primary and Histology coding rule standards from National Cancer Institute (NCI) and used SAS to pull lists for various body sites
• Coding Rules present first site-specific multiple primary and histology rules to promote consistent and standard coding by cancer registrars

Environment: Microsoft SQL Server 2012, MS SQL Server Management Studio v11.0, Tableau v9.3, SAS EG v7.1, Base SAS v9.4, SEER STAT v8.3.2, SEER PREP v2.5.3, CRS Plus

Confidential

Sr. SAS Programmer, Irving, TX

Responsibilities:

• Performed remediation work for previous validations performed for Cards department of Internal Audit group at Confidential
• Documented remediation work performed on behalf of the Cards Internal Audit team and provided the results to Director
• Served as the liaison and point of contact for data between business and Internal Audit teams
• Worked with consent orders (C.O.), corrective action plans (CAPs) and management action plans (MAPs)
• Wrote SAS programs and used statistical procedures like PROC SURVEYSELECT to random sample data population from entire pool of Citi Cards Customers
• Used the audit information management System (AIMS) to document audit work on a day to day basis

Sr. Specialist (Sr. SAS Programmer)

Confidential, El Segundo, CA

Responsibilities:

• Analyzing and documenting business processes with a focus on identifying areas of risk, existing control points and associated systems by consulting business process owners, subject matter experts and others
• To present complex corrections to Senior Management
• Profiling data to find themes and identify root causes for missing base packages scenarios for Confidential team. Focus on discovery, recovery and monitoring of various revenue uplifting scenarios including Missing Base Package, Active No Service account scenarios
• Increase efficiencies by implementing automation and/or replacing existing processes/programs
• Recommending and implementing corrective actions to address issues discovered through data analysis, including communication and project plans and recovery processes
• Lead complex projects that may require exploration of new and/or sensitive data sources
• Writing queries and configuring/managing data analysis tools
• Test business rules and validating errors identified through testing with subject matter experts
• Designing and developing reports and monitoring ongoing initiatives
• Coaching and mentoring team members on ad hoc query tools and techniques
• Data profiling, data analysis and data visualization with SAS new features, tools and technologies including SAS Visual Analytics
• Worked on database ad hoc work and SAS development. Accessed and compiled large amounts of data, analyzed data, interpreted and quantified trends on the operational aspects of various bundle partners and users associated with program
• Experience interacting with users and IT departments to analyze underlying business problems and design best possible solutions
• Effectively communicate concise findings and recommendations to senior management and leaders
• Design, develop and test SAS processes and move the code to production
• Reviewed and evaluated business specifications to determine their feasibility, implementation, and compatibility with current systems and architecture standards
• Produced appropriate project documentation including technical designs and testing plans and results Interfaced directly with development and operational groups in support of software and production releases
• Participated and serving as SAS subject matter expert for Business and internal Business intelligent user
• Used SAS Enterprise Guide for quick data analysis and to generate ad - hoc reports
• Analyzed functional problems and made recommendations for enhancements or modifications to deliver solutions
• Developed and executed SAS/MACRO to monitor ongoing analyses, produce data listings, summary tables and graphs
• Perform daily tasks within the scope of Linux and Unix
• Working knowledge of database including its functionality and structure: ORACLE, Teradata, MS SQL and MS Access
• Understanding of client/server infrastructure
• Comprehension of SAS BI, SAS Grid and SAS Platform Computing, SAS Management Console
• Knowledge and understanding of ETL (extract, transformation and load techniques)
• Proficient with the Microsoft Office Suite of applications
• Partner with cross functional teams such as Finance, Strategy, Business Analytics and Customer Care to understand enterprise trends, competitive environment and their impacts on subscriber behavior and provide conclusions and recommendations to business owners
• Providing insight into and develop new ideas and approaches to improve operational results
• Performed ad hoc analytics on large/diverse datasets using various tools and techniques
• Performed data extraction, aggregation, and quality checking from multiple data sources to prepares statistical and narrative recommendations
• Initiating proactive investigations into data issues that impact reporting, analysis, or program execution
• Consolidated information and present to program managers and senior management in a clear and concise manner
• Ability to prioritize and execute multiple overlapping projects while working in a fast-paced and dynamic environment
• Explored the natural language data exploration tools like Absolut-e BizStats and ThoughtSpot

Environment: Base SAS 9.4, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ETL, SAS/ETS, SAS/ODS, SAS/ AF, SAS/SQL, SAS/CONNECT, SAS Enterprise Guide 6.1, Windows and UNIX, Linux

Application Systems Engineer

Confidential, San Francisco, CA

Responsibilities:

• Possess thorough understanding of banking/Financial domain with respect to Real Estate (RE) credit risk data- i.e. forecasting risk experience and collection risk, collectively default credit risk
• Analyzed various loss mitigation solutions i.e. options to retain home
• Followed Federal Financial Institutions Examinations Council (FFIEC) guidelines for Real Estate Equity Analysis (EA) calculation and loss recognition
• Worked with short sale, deed in lieu data, bankruptcy data and Foreclosure sale data
• Used Net Available Equity (NAE) tool to estimate property’s equity calculation and estimate impacted processes
• Strong SAS/SQL scripting
• Wrote code, validated and verified other team members code for accuracy as a part of Data Validation and Data Migration project
• Developed different reports and dashboards using SAS Enterprise Guide
• Worked on validating an old database against new reporting database. Old database was initially used by Consumer Real Estates Portfolios in a centralized location using standardized naming conventions and credit related metrics
• Worked with different portfolio data within the old database including Confidential Home Mortgage (WFHM), Confidential Home Equity (WFHE), Confidential Home Mortgage San Antonio (WFHM-SA), Confidential Business Direct (WFBD), Nowline (WFNL), Confidential Financial (WFF), Confidential Wealth (WBR) as indicator flags
• Understood financial business requirements, translated them into SAS-coding, validations, control
• Used SAS E nterprise G uide, SAS/P roc, SQL, Unix
• Wrote SAS programs from scratch
• Performed Credit Loss Severity Calculation for WFHE data considering vintage months, state distribution
• Generated monthly reports for Confidential Home Equity (WFHE) data to calculate Severity Rate and split base population into either partial charge off, full charge off and no write-down (or) save population
• Worked independently with minimal support
• Calculated state-wise differences between Severity WFHE data to analyze state distribution of base population
• Worked extensively with Pivot Tables for data analysis
• Passion for learning and innovating new methodologies in the intersection of applied math/ probability /statistics /computer science. Proficient at translating unstructured business problems into an abstract mathematical framework

Environment: SAS 9.3, SAS EG 5.1, SAS/ETL, Oracle, DB2, SAS/Access, Teradata client 13.11, MS-SQL Server, Microsoft Office 2010, Microsoft Excel 2010, Windows 7 Enterprise 64-bit, LINUX Boks 6.5

SAS Programmer

Confidential, Memphis, TN

Responsibilities:

• Possess strong marketing experience and campaign management experience
• Worked with Confidential marketing team combined with analytics to analyze, combine technical expertise and use that to drive improved value for customer and corporation.
• Alliance Marketing team at Confidential would provide a single point of contact to the company who can understand business and can develop solutions to meet needs of the company. This provides more effective and timely support for the requests
• Good knowledge of SAS Enterprise Guide
• Created and developed projects using SAS EG
• Worked with Marketing team in developing the html based Web reports using SAS
• Developed web-pages which refreshes the data automatically from time to time when updates take place
• Knowledge of web-development ( JAVA Script, PERL, HTML)
• Experience with Oracle and Teradata databases
• Gained experience on Marketing/S ales data and developing the reports related to marketing
• Involved in data analysis and data cleansing
• Created stored processes in SAS EG
• Pulled data from databases, analyzed it in SAS and published it to web pages
• Used shell scripts to automate the whole process and Perl/HTML to publish it on to the web site
• Used CGI or JavaScript which is part of SAS UI framework
• Understood and worked on the company’s internal website/ Dashboard: Querying the backend data to populating the tabular columns and graphs on the website
• Developed graphs and tables using SAS and published them onto the Html page based on drop down selections
• Created reports in SAS and exported to Excel spreadsheets. Created web reports using SAS Web Report Studio
• Made several changes to the website including adding tags, drill down links using SAS and drop down lists using CGI/PERL
• Created pie charts using PROC Gchart and displayed tables containing information from SAS datasets on the website
• Worked on SAS macros, created drop down lists with selected functions and drilldown links
• Changed fonts, headings and CSS styles in dashboard
• Worked on monthly refresh of data on Dashboard by running backend and frontend queries
• Tested webpages and maintained quality control to make sure correct data is being populated

Environment: SAS 9.2, SAS EG 4.3, SAS ETL, Toad for Oracle 9.7.2, SAS/Access, Teradata, Microsoft Office, SOLARIS, Windows

SAS Programmer

Confidential, Fremont, CA

Responsibilities:

• Worked with marketing and related departments to develop required applications using SAS/STAT and SAS/MACRO
• Performed complicated analysis including customer retention analysis and portfolio performance tracking
• Analyzed and provided strategic recommendations, presented and communicated analytical results to clients
• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in UNIX environment
• Extracted, transformed, and loaded data using SAS
• Planned, designed and executed marketing campaigns for clients using Unica Campaign tool
• Designed criteria, developed algorithms and written code and executed campaign using SAS code and SAS tools
• Used SAS Enterprise Guide for quick slice and dice on the files created by Unica tool before doing reporting and analysis. Created and published reports using SAS Enterprise Guide
• Utilized OLAP cubes to report large volumes of data, provide hierarchical drill downs, and slice and dice capabilities
• Involved in frequency reporting and analysis on campaign generated output files with a help of third party reporting tool
• Used SAS Web Report Studio extensively to generate web based reports. Ensured the validity and accuracy of the analyzed data
• Defined requirements for the development of the exception reports and monthly performance reports
• Assisted Business User in identifying new requirements and recommended enhancements
• Modified the existed macros accordingly to the current requirements and made them concise and reusable
• Converted Oracle data tables into SAS data files using SAS SQL Pass through Facility
• Moved data sets across platforms (from PC to UNIX and Vice Versa). Developed and exported the SAS data to Excel pivot tables
• Raised queries on the existing Oracle and SQL Server databases to provide ad-hoc reports using SAS/SQL
• Designed user interface using SAS Information Delivery Portal. Displayed summary statistics reports
• Created custom portlets in SAS information delivery portal
• Extensively used SAS/ODS to generate HTML and PDF reports
• Submitted SAS/SQL Queries in UNIX shell to validate data
• Coordinated with the other teams to deliver the data to the clients on time
• Documented all programs, files and variables for accurate historical record and for future reference

Environment: SAS/BASE, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, SAS/ODS, SAS EG, SAS Web Report Studio, SAS Information Delivery Portal, Oracle, SQL Server, Unica Campaign Tool, VB, MS Access, UNIX

SAS Programmer/Developer

Confidential

Responsibilities:

• Generated summarized weekly and monthly reports
• Used SAS management console for different users and groups
• Creation of SAS master file that is done on a weekly and monthly basis: Used these weekly master files and SQL Server databases for report generation
• Designed and created PPT presentation of High level documents, Process flow diagrams and Project plan for the application
• Designed process flow diagrams and developed the Targeting and Sampling by creating various SAS Macros and SAS Formats to use across the systems
• Extracted data from SQL Server and converted into SAS data sets
• Copied SAS datasets using PROC COPY utility
• Created and maintained SAS datasets that are extracted from a SQL Server database which includes data management of SQL Server tables, programming in SAS and SQL for data management, analysis and presentation
• Extensive usage of PROC SQL, PROC Report, PROC Freq, PROC Tabulate, PROC Transpose to generate monthly reports for all the Management levels
• Produced efficient large datasets by combining individual datasets using various inner and outer joins and dataset merging techniques
• Troubleshoot and QC the SAS programs and the business rules used in the systems, helping the team and integrated testing by Unix Shell Job Runs
• Provided Code review at the client site to improve the performance and efficiency of using the resources
• Used macros facility to create macros for statistical analysis, results, data extraction, querying and reporting using PROC SQL

Environment: SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, MS Excel, SQL Server, UNIX