SUMMARY:

• 6 years of overall experience as a SAS Developer on the UNIX and Windows Platforms.
• Good understanding and In - depth knowledge on SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/MACROs, SAS/ODBC and SAS/ACCESS.
• Worked with Statisticians in analyzing the Clinical Trial Data, generated reports, tables, listings and graphs. Used Statistical procedures like PROC FREQ, PROC MEANS and PROC UNIVARIATE on Clinical Trials using Data Validation and Data Cleaning.
• Expertise in Problem solving and Created Macros to improve the efficiency of report generation and automation of programs and data creation.
• Have written daily, weekly and monthly reports using Proc Tabulate, Proc Report, Data null and SQL.
• Experience in requirement gathering, analysis, planning, designing, coding and unit testing in Windows and UNIX environments.
• Experienced inmigration of data and current SAS programs to new versions.
• Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and access tables.
• Worked on SAS/Base, SAS/Stat, SAS/Access, SAS/Graphs and SAS/Macro.
• Experience in developing Macros using SAS procedures.
• Generated reports using PROC REPORT, DATA NULL and PROC TABULATE for customized report writing.
• Experience in developing, validating and implementing SAS programs and produce derived datasets for analysis and generating & documenting tables, listings and graphs for clinical study reports.
• Developed new and/or modified existing SAS programs to load data from the source and created study specific datasets in UNIX and Windows Operating System.
• Experience writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis. Experience in performing Ad Hoc Queries for various application and reports on a daily, weekly and monthly basis using complex SQL Queries.
• Extensive experience in DATA merging sub setting with the use of PROC SQL, Merge and SET statements.
• Extensive experience in working on different SAS versions like (8.2, 9.1, 9.2) using SAS/BASE, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/ETL, SAS/SQL.
• Hands on experience in working with SAS Enterprise Guide Software (4.1 version) for reporting and analytical tasks.
• Extensive experience in MS SQL Server, BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, common table expressions (CTEs, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, Hadoop, DB2, Sybase, Excel and MS Access CSV, Oracle, flat file.
• Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various heterogeneous data sources. 

TECHNICAL SKILLS:

Databases/RDBMS: Oracle, DB2, Teradata, Sybase 

Operating System: Windows, UNIX, LINUX, Mainframes 

ETL Technologies: IBM Info Sphere / Web sphere Data Stage 9.1/8.5/8.1/8.0/7. x

Scripting Languages: UNIX Shell Scripting

Packages: MSWord, MS Excel, MS PowerPoint, MS Visio, MS Project Management 

Functional Knowledge: Retail, Banking and Health care.

SAS Tools: SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS,SPSS, ETL, SAS/ACCESS, SAS Enterprise Guide(EG), SAS Visual Analytics(VA) SAS Web Reporting Studio(WRS), SAS Information Map Studio(IMS), SAS Data Integration(DI) Studio, SAS Information Delivery Portal. 

Other tools: SQL server 2012, DQS 2012 SSIS 2012, SSRS 2012, SSAS 2012 - tab, POWER PIVOT 2012, share point 2010, TFS 2012

BI Tools: TIBCO Spotfire Professional 3.x, 4.x, 5.x, 7.x TIBCO Spotfire Server, Spotfire Webplayer, Tableau, SSIS/SSRS, SAP BI, IBM Cognos, OBIEE

PROFESSIONAL EXPERIENCE:

SAS Analyst

Confidential, Eagan, MN

Responsibilities:

• Worked with the analysis teams and management teams and supported them by providing variables based on their requirements.
• Involved in extraction, transformation and loading of data directly from different source systems (flat files/Excel/Oracle/MSSQL/Teradata) using SAS/SQL, SAS/macros.
• Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Extensively read different forms of Input files like CSV and other formatted files using In-file, Proc Import and documented using SAS scripting to develop data cleaning operation
• Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages, Functions and Triggers using SQL and PL/SQL.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base.
• Calculating statistics with IMS Data, selecting and combining IMS Data, Updating SAS data file with IMS data.
• Appending IMS data With IMS procedures.
• By Using SQL procedures retrieve, update data from IMS databases
• By using FSVIEW Procedure which produce multiple observations in a tabular format like PRINT procedure AND PROC FSVIEW which enables you both browse and update IMS data
• Extensively worked on Shell scripts for running SAS programs in batch mode on UNIX.
• Validated regulatory finance data and created automated adjustments using advanced SAS Macros, PROC SQL, UNIX (Korn Shell) and various reporting procedures.
• SAS/STAT procedures such as UNIVARIATE, FREQ, and MEANS were used to carry out analyses and the SAS REPORT procedure is generally used to display results.
• Performed statistical data analysis, generated ad-hoc reports, tables, listings and graphs using tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL and SAS/STAT.
• Automated Risk division reporting process using SPSS, SAS and MS Excel. 
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging different sources.
• Created reports using analysis output and exported them to the web to enable the customers to have access through Internet.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.

Environment: Windows 8, SAS v9.4, SAS/EG, Python, SAS/Base, SAS/Access, SAS/Macro, Ims Data, SPSS SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, MS SQL Server, Oracle, Teradata, MS-Excel, Tableau 8.2, Qlikview 9.0.

SAS Analyst

Confidential, Wilmington, DE

Responsibilities:

• Imported and Exported data files to and from SAS using Proc Import and Proc Export from Excel and various delimited text based data files such as .TXT (tab delimited) and .CSV (comma delimited) files into SAS datasets for analysis.
• Extensively used SAS/Macro facility to create macros for statistical analysis, results reporting and data extraction.
• Released the reports through UNIX shell scripting every month based on requirement.
• Involved in writing code using Base SAS & SAS/Macros to clean and validate data from tables.
• Involved in designing the project and process flow diagrams.
• Extensively used SAS enterprise miner and developed predictive models in decision tree, interactive decision tree, gradient boosting, regression and neural networks
• Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
• Used SAS Procedures like PROC FREQ, PROC SUMMARY, PROC MEANS, PROC SQL, PROC SORT,
• PROC PRINT, PROC Tabulate, PROC UNIVARIATE, PROC PLOT and PROC REPORT to generate various regulatory and ad-hoc reports.
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.
• Built complex formulas in Tableau for various business calculations.
• Developed Geo/Area Maps to show details on which states have more patients who are hospitalized using Tableau.
• Created Bar Charts which is compiled with data sets and added trend lines and forecasting on future trend of the financial performance.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server with Quick Filters for on demand needed information with just a click of a button.

Environment: Windows 7, SAS v9.4, SAS Enterprise miner, Python, SAS/BASE, SAS/ODS, SAS/MACRO,SAS/EG, SAS/SQL, UNIX, MS SQL, TERADATA, Teradata SQL Assistant, Access, Excel, Tableau 8.0.

SAS Analyst

Confidential, Austin, TX

Responsibilities:

• Make the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales organizations.
• Performed statistical analysis and data management on study data by utilizing appropriate statistical methods using SAS and SAS tools.
• Assist in the creation of quantitative and qualitative primary research and present the findings.
• Integrate results of the Marketing Mix Analysis, Price Elasticity and other advanced analyses into business planning process.
• Ability to dig into raw data to find and evaluate actionable insights that will help the organization.
• Analyze and interpret significant results based on data summaries.
• Work closely with different Marketing Groups in designing and analyzing the data.
• Extract the data from a data warehouse and create ad-hoc reports, tables, and graphs according to Business needs.
• Provide support for, and automation of, routine SAS-EBI stored procedures
• Used SAS DATA NULL and PUT statements to create the customized reports.
• Develop new macros for report generation using SAS/Macros as per the customer's requirements.
• Extracted, performed validation and generated SAS data sets from Teradata; applied SQL Pass through Facility.
• Used FTP to download SAS Formatted Data into EXCEL AND CSV format.
• Used base SAS and SAS/SQL to generate tables.
• Used PROC compare to compare the data before and after editing
• Developed various SAS reports for Survey project and involved in code reviews for all the developed reports

Environment: SAS 9.1.3/9.2, BASE/SAS, SAS Enterprise Guide, SAS/MACRO, SAS BI, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle 11g, Teradata, UNIX and Windows.

Data Analyst

Confidential

Responsibilities:

• Interacted with the client as part of the Requirements engineering team to understand the reporting requirements and finalize the project scope.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS by running upgrade advisor tool against DTS packages, troubleshooting issues and converting into SSIS through DTS migration wizard.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis. 
• Designing and building data load procedures, using MS SQL Server SSIS
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Created the enhanced logical model in 3NF using ER/Studio and the many to many relationships between the entities are resolved using associate tables.
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and loaded them into Fact and Dimension tables of data warehouse
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Developed Stored Procedures, Functions and Database Triggers.
• Developed various reports using SQL Server Reporting Services (SSRS) and Landscape reports.
• Extensively developed Oracle PL/SQL stored procedures using TOAD to implement different business logics and perform backend testing (Oracle 9i) to verify the transactions and business logic.
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.
• Developing a Report as per user requirement using MS Reporting Services
• Published reports in PDF, Word and Excel formats.

Environment: SQL Server 2008 R2, ER Studio, Tableau, Windows 2008, C# 3.0, .NET 3.5, Excel, TSQL, MS Visual Studio 2005/2008, SSIS, SSRS.

Data Analyst

Confidential

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Canter.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Performed data mining on Claims data using very complex SQL queries and discovered Health care claims pattern.
• Responsible for different Data mapping activities from Source systems to Teradata
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Executed campaign based on customer requirements
• Followed company code standardization rule
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed
• Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: MS SQL Server 2008 client & Server, MS office, ETL Tools, Legacy - Mainframes, Titanium, Rational Clear Quest, Clear Case.