SUMMARY

• Having 5+ years of experience in systems analysis, design and development of complex software applications in Banking, Retail and Finance sectors.
• Experience in Base SAS, SAS/STAT, SAS/CONNECT, SAS/ACCESS, SAS/GRAPH, SAS SQL, SAS ARRAYS, SAS MACROS, SAS PC, SAS ODS, SAS MA, SAS CIS, SAS IMAP in Windows and UNIX environments.
• Interacted with Business Analysts from Risk, Marketing and Sales Departments to provide SAS programming in analyzing the data, generating reports, tables, listings and graphs.
• Experience in direct marketing process, List Processing and marketing analytical methods.
• Hands on experience in SAS Programming, Merging SAS Data Sets, Developing SAS procedures, Macros, Preparing Data, Producing Reports, SAS Formats, SAS Functions, Storing and Managing Data in SAS Files.
• Extensively worked on concatenating, interleaving, and merging large SAS datasets.
• Experience with PROC SQL, PROC DATASETS, PROC FORMAT, PROC PRINT, PROC APPEND, PROC TABULATE, PROC GPLOT, PROC GCHART, PROC COMPARE, PROC IMPORT, PROC EXPORT, PROC TRANSPOSE, SAS/STAT procedures such as PROC FREQ, PROC MEANS.
• Administrating client applications, connection profiles, single sign - on, Users, User access to Servers, and using pre-defined roles to control access to Application functionality.
• Administrating and Developing SAS BI Client applications like Enterprise Guide, SAS CIS, SAS IMAP, SAS MA, Information Delivery Portal, Web Report Studio and OLAP Cube Studio.
• Experience on creating jobs using various transformations from the vendor sources into the target data marts using SAS DI Studio.
• Experience in deploying jobs for scheduling using SAS Management Console.
• Skill in PROC SQL joins and PROC SQL set operators to combine tables horizontally and vertically.
• Extensive experience in deployment of SAS programs/UNIX shell scripts and version controlling (PVCS) in different environments.
• Used SFTP/FTP to transfer data between different servers and used ODS to display outputs in HTML, CSV or other file formats.
• Strong experience in testing methodologies. Involved in System, Integration & UAT.
• Having good knowledge in Finance and Credit Cards Business Domain.
• Good Communication Skills and ability to contribute as an Individual and also a good team player.

TECHNICAL SKILLS

ETL: SAS 8/9 (SAS BASE, SAS/MACRO, SAS/ACCESS SAS/CONNECT, SAS/SQLSAS/ODS, SAS ASSIST), Enterprise Guide, SASMA 5.4, SASCIS, SAS IMAP.

Platforms: UNIX, Solaris, Mainframes, Windows NT/2000.

Languages: SQL, C, UNIX.

Databases: Oracle 8i/9i/10g, SQL Server 2000, PL /SQL, MS Access 98/2000

Tools: Toad, Win CVS, F-Secure, Ultra Edit.

Scripts: Shell Scripts (Korn, Bourn, C).

Internet: HTML, XML, Java Script, Front Page, Dream Weaver

PROFESSIONAL EXPERIENCE

Confidential, Johnson City, TN

SAS Developer

Responsibilities:

• Collaborate with business unit counterparts to establish new account marketing goals and develop strategic and tactical plans to achieve them.
• Track and review campaign performance and generate recommendations based on learnings, established best practices and competitive landscape.
• Act as a subject-matter expert with business unit counterparts and on cross functional projects.
• Stay up-to-date on the latest marketing trends and bring innovation and new thinking to the group.
• Manage multiple initiatives to completion under concurrent, rigorous deadlines in a fast-paced dynamic environment.
• Coordinate and execute enhancements and tests with internal Chase teams and third party vendors.
• Maintain reporting on channel performance and individual test results.
• Deliver analytical/quantitative projects on default and credit risk issues impacting the portfolio.
• Developed the target Database table as per the requirement by writing the source qualifier Queries.
• Created Data Steps and PROC SQL to combine and aggregate data for accessing and manipulating database system. Wrote various queries using SAS/Base, SAS/SQL, and SAS/Macro for creating reports according to the Users requirement, extensively used Proc SQL to retrieve, update and report information on from sas dataset and other database products.
• Created Store Procedures, Functions and Views, modified existing SAS macros to assist with producing reports and deliverables.
• Created complex SQL queries using Inner, Left, Right, Outer, and cross Joins and transformed these queries into SAS code.
• Good experience in using Aggregates, Analytical functions like RANK, DENSE RANK, Sequence in the queries.
• Involved in Identifying, analyzing, and interpreting trends or patterns in complex data sets.
• Developed several on demand Excel reports/dashboard to higher management.
• Created crosstabs to display underlying data based on various graphs and charts created for further data analysis.
• Distributed reports using techniques like Presentations, PDF, and Reports to different user community.

Environment: SAS, SAS/BASE, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS/SQL, Excel/Access, Windows - XP.

Confidential, Charlotte, NC

SAS BI Developer

Responsibilities:

• Imported the data from different source systems and registered the tables in SAS Management Console.
• Created IMAP adding all the data items and established the relationship of the tables to create the Campaigns using SAS IMAP.
• Using Information Map Studio created the calculated fields and created multiple pre-defined filters.
• Developed Campaign’s to select the Target Audience for Multiple Channels (Direct mail, Email, TMK, SMS, Branch and PCAS) using SAS CIS.
• Analyzing the data by using MS Excel, SQL, and SAS. Extensively worked using Query Analyzer for querying the data base to fix the Data issue that show up on the output files.
• Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning.
• Administrating client applications, connection profiles, single sign-on, Users, User access to Servers, and using pre-defined roles to control access to Application functionality.
• Involved in analyzing complex data structures to generate useful business insights.
• Communicated with business customers to establish data requirements and presented final analysis to customers.
• Generated SAS reports using both Interactive and Batch Processing.
• Assisting in the analysis, design, and development of tables, Excel files and Ad-hoc reports.
• Understood basic business analysis concepts for logical data modeling, data flow processing and data base design.
• Extracted data from existing data source and performed ad-hoc queries by using SQL.
• Developed SQL, PL/SQL Queries in Teradata, SQL Server and access those databases through SAS using LIBNAME Engine and SQL Pass-through.
• Developed Test Plans and Test Cases as part of the Verification and Validation using HP Quality Center.
• Monitoring the existing performance of the Bank’s internal departments and to change the processes for better performance and customer satisfaction.
• Achieving deadlines for timely submission of data analysis, reports by performing data extractions and retrievals.

Environment: SAS 9.1.3/9.2, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/STAT, DDE, SAS/SQL, ODS, SAS CIS, SAS IMAP, SAS MA 5.4, Enterprise Guide, Enterprise Miner, Excel 2000, VBA, Microsoft Visio 2003, SQL Server, DB2, Window NT/ XP, UNIX.

Confidential, Battle Creek, Michigan

SAS Analyst/Programmer

Responsibilities:

• Gathering functional requirements from business customers, analyzing and transforming them into business intelligence reporting specifications.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Designed and developed snowflake /star schemas for better understanding of models using SAS.
• Created, modified/Updates SAS code to in corporate changes in new releases of the product.
• Responsible for data cleansing using various data pre-processing techniques such as imputation, transformation, reduction, integration, etc. using SAS and R.
• Extracting data from the database using SAS SQL procedures and create SAS data sets.
• Extraction of data from Data Ware housing tables and Data marts.
• Performing data analysis on various data of the customer using the Python Pandas libraries.
• 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.
• Worked on different phases of System development life cycle (SDLC) like preliminary analysis, systems design development.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Coding SAS programs with the use of BASE SAS and SAS/MACROS for ad hoc jobs
• Working collaboratively with customers, as well as internal and external stakeholders.
• Work with change management teams on creating/modifying business requirements document.
• Update the Configuration files for Better Performance.
• Using R to build models and verify results.
• Developing and executing test cases (developer, unit and regression), evaluating test results, and resolving defects.
• Created or modified queries to download data from multiple source systems to create reports according to customer specifications.
• Work as POC with multiple IT and business groups in identifying issues, deploy fixes and enhancements etc.
• Performed automate data validations manually across the division to ensure that there are automated controls in place designed to meet Freddie Mac standards and audit requirements using SAS Data Flux.
• Troubleshoot and work with customers to resolve their EUC related issues and close the loop on delegated tasks.
• Perform unit testing and integration testing and document test results.
• Analyze public policy projects via Python, SAS and R
• Work on Prod/non-prod VDI (Virtual desktop infrastructure) to generate report in Developer environment.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Provide support for alternative and innovative solutions that meet business requirements.
• Work with UNIX to check difference between two large datasets, run reports in different environment.
• Used SQL, Oracle and MS Office analysis tools to complete analysis requirements.

Environment: SAS 9.1.3/9.2, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/STAT, DDE, SAS/SQL, ODS, Enterprise Guide, Enterprise Miner, Excel 2000, VBA, Microsoft Visio 2003, SQL Server, Oracle 9i/10G, Teradata, DB2, Window NT/ XP, MVS (TSO), UNIX, Toad.