SUMMARY

• 5 years of experience in IT industry with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applications.
• 5 + years of strong Experience with Base SAS, SAS SQL, SAS/MACROS and SAS/ODS in UNIX Environment.
• 4 years Strong working Experience with Data Visualizations tool Tableau.
• Domain Knowledge in Banking and Financial, Mortgage and Railways.
• Programming Experience in Basic SAS with different Procedures like Proc SQL, Proc Report, proc tabulate, Proc Import, Proc Export, Proc Print, Proc Freq, Proc Contents, Proc Sort, drop, keep, retain, and date manipulations, formats and SAS EG etc.
• Good Experience in writing Complex SQL scripts and Stored Procedures, PL/SQL Procedures in various databases like Oracle, DB2, MS QL Server and performance tuning.
• Good Experience in Data analysis, data extraction using SQL and SAS.
• Worked on Designing the Dashboard / KPI Reports and Drill down Reports for Management as well as operations use.
• Experience with creating Tableau worksheets, Dashboards, Calculated fields, Table Calculations, Parameters, actions and Filters.
• Experience in creating complex Tableau Dashboards line charts, bar charts, pie charts, Combination charts, tree maps and Map charts.
• Knowledge in Data warehousing Concepts in OLTP/OLAP System Analysis and developing Database Schemas like Star Schema and Snowflake Schema for Relational and Dimensional Modeling.
• Experience on ETL tools like Informatica Power center, workflow manager and workflow Monitor.
• Good Programming Experience in COBOL, DB2 and JCL.
• Proven ability to understand business problems and able to apply technology to formulate workable solutions with excellent Interpersonal and Communication Skills.
• Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau 6.0,7.0,9.0,10.5 Tableau Reader

Operating Systems: Windows 7/ XP/ 2000/, UNIX.

Databases: Microsoft SQL Server, Oracle11g/10g, Teradata, Hive, MS Access and DB2. MongoDB

Programming Languages: SAS, SQL

PROFESSIONAL EXPERIENCE

Confidential

Lead SAS Programmer

Responsibilities:

• Created complex SQL queries, stored procedures against various RDBMS databases oracle, Microsoft SQL server and Teradata.
• Using Oracle SQL Developer and Toad for Oracle to retrieve the input data from Oracle.
• Create driver data to get the input results.
• Create rules in SAS Profitability Management Studio to filter the data from the input tables and driver tables from Oracle.
• Perform the deployment procedure using with UNIX shell scripting.
• Working with business users and gathering the requirements and perform data analysis and Reporting.
• Backup the files using the shell scripting.
• In SAS Profitability Management Studio configured the rules and behaviors.
• Extracted data from various data sources using Pass - through SQL, created macros, exported and imported data into SAS, created PROC sort, email automation etc.
• Published the reports on to the tableau server and provide access depending on the type of users.
• Using SAS Procedures, data step, pass-through SQL, proc report, drop, keep and various date functions.
• Performed data profiling and data cleansing with SAS data step, SAS Libraries, SAS Macros and SAS ODS.
• Using the Tidal Enterprise Scheduler (TES) / Tidal Workload Automation (TWA) to schedule the jobs and run the batch jobs.
• Being the POC for migration the jobs from Tidal to BMC Control-M sandbox.
• After Migration validated all application jobs in the control M sandbox.
• Perform adhoc customer analysis using SAS, SQL, and Excel.
• Using SAS/Access and Pass-through SQL for connecting various RDBMS databases.
• Used Proc Report, Proc Tabulate, Proc Transpose, Proc freq, proc Import, Proc Export for data analysis and Reporting.

Environment: SAS 9.2,9.4,SAS EG 4.3,SAS Profitability Management Client 2.2, Oracle, MS SQL server, Unix, Toad for Oracle, UNIX shell scripting

Confidential

SAS Programmer /SAS Developer

Responsibilities:

• Working with business users and gathering the requirements and perform data analysis and Reporting.
• Created complex SQL queries, stored procedures against various RDBMS databases oracle, Microsoft SQL server, Netezza and Teradata.
• Using Hadoop environment tools SQOOP, HIVE, HDFS and Pig for data storing and data transfer.
• Create Hive tables and involved in performance tuning of Hive.
• Extracted data from various data sources using Pass-through SQL, created macros, exported and imported data into SAS, created PROC sort, email automation etc.
• Created line charts, Bar charts, Map charts, cross tables, Pie charts etc using Tableau.
• Developed YTD, QTD, MTD Reports in Tableau.
• Working with various aggregate functions, quick filters, parameters, and tableau action controls, LODS, context filters, sets, grouping, calculated fields and table calculations using Tableau.
• Published the reports on to the tableau server and provide access depending on the type of users.
• Created Tableau data extracts (tde) and schedule updates.
• Using SAS Procedures, data step, pass-through sql, proc report, drop, keep and various date functions.
• Performed data profiling and data cleansing with SAS data step, SAS Libraries, SAS Macros and SAS ODS.
• Perform adhoc customer analysis using SAS, SQL, Tableau and Excel.
• Using SAS/Access and Pass-through SQL for connecting various RDBMS databases.
• Used Proc Report, Proc Tabulate, Proc Transpose, Proc freq, proc Import, Proc Export for data analysis and Reporting.
• Developed Complex Tableau Dashboards which shows/track the Inventory over period, Servicers Information, Billing Issued, collections and Reconciliation of receipts.
• Participated in Hadoop and Tableau integration and build reports on the data stored in Hive tables.

Environment: SAS 9.3,SAS EG, Tableau10.0,10.5,Netezza,Oracle,MS SQL server, Unix, Teradata, Teradata SQL Assistance.

Confidential

SAS Programmer

Responsibilities:

• Gathered Business requirements and designed functional and technical requirements documentation.
• Used BASE SAS and SAS SQL to extract the data from various data sources, data analysis and data validation.
• Created complex SAS programs to validate the existing data and the new DataMart.
• Created SAS programs with SAS data Step, SAS Libraries, SAS Macros and utilized various procedures like Proc Sort, Proc SQL, Proc Report, Proc Export and Proc Import to read / write the data into xls, csv.
• Utilized various data functions like INTCK, INTNX, CATX, MIN, MAX, INPUT, PUT etc.
• Prepared actuarial valuations and reports in conjunction with various consultants.
• Created Complex SQL scripts and executed them on Oracle, SQl server and Netezza and performed data extraction and analysis.
• Created tabular reports using Base SAS & Advanced SAS/Reports procedures.
• Prepared actuarial valuations and reports to calculate the minimum and maximum IRS pension
• Worked on data related to Smart meters installation, reading tracking and Billing information.
• Created Tableau KPI s using Line chart, Bar Chart and Map charts and presented the huge data in the form of visualizations.
• Created Tableau Dashboards and published the same to the Tableau server for business users use and implemented the row level security.
• Created tableau data extracts (tde) and scheduled the same on the server for automatic data refresh.
• Worked on IBM Optim tool to Extract and Load the data from Production to Development Environments.
• Worked on developing program, user guide for Tableau in terms of best developing and design practices.

Environment: SAS 9.1,SAS EG 5.1,MS SQL Server, Oracle, Teradata, Netezza, Toad, SQL server Studio, Tableau 9.0, Tableau reader, Unix

Confidential

Senior SAS Developer

Responsibilities:

• Gathered Business requirements and perform data analysis and reporting.
• Responsible for consolidating the reports and re writing the SAS programs.
• Extract the data from SAP HANA views, Teradata and various RDBMS data bases.
• Expert in writing the SQL quires against Oracle, SAP HANA, Teradata and DB2.
• Identified data anomalies and reported the issues for the business to correct.
• Created Hive tables, Partitioning and performance tuning.
• Utilized Teradata utilities Fast Load, Fast Export and Multi load for loading and Exporting data to Teradata tables.
• Extracted data from various data sources using Pass through SQL, created macros, exported and imported data into SAS, created PROC sort, email automation etc.
• Experience with various formats and date maupulations and sas functions.
• Build and enhanced Tableau dashboards and created and scheduled the data sources.
• Experience in SQL performance tuning.

Environment: SAS, SAS EG, Tableau 6.0, SAP HANA, Teradata, Teradata SQL assistant, SAP HANA Studio, DB2, Control-M.

Confidential, New York, NY

Analyst Programmer

Responsibilities:

• Analyzing the requirements and prepared technical documentation and LLD.
• Written one time batch programs for creating the empty files which are required.
• Written new programs and changed existing programs.
• Modified the existing programs as per the new functionality.
• Reviewing the Program Specifications and Program Code.
• Prepared Impact Analysis Document before changing the existing programs.
• Program development using COBOL, JCL, DB2, CICS, VSAM.
• Used Implicit and Explicit SQL to extract the data from various databases.
• Monitoring the Batch jobs and providing remittance support.
• Involved in creation of DB2 stored procedures.
• Identifying, Unloading and Loading Test data from Production to Test regions.
• Used CHNGEMAN Tool to work with Production and Test environments.
• Used XPEDITOR tool to check the flow of the batch and online programs after code changes.
• Writing the SQL quires against the database using QMF and SPUFI.
• Extracting (Data Carving) the collection of data from larger data sets.
• Used NDM (Connect Direct) for transferring the data sets across the regions.
• Developed new CICS screens (MAPS).
• Comparing the test results before performing the test and after performing the test.
• Preparing Unit Test Cases as per the new code.
• Involved in Code review, Test results review and documentation.
• Involved in Unit testing, online system testing, functional, integration and regression testing.
• Prepared Program hierarchy flow-charts by using VISIO tool.
• Estimated time and efforts for the Enhancements.
• Used Quality center to write test cases and also used as a repository to store all the Test documentation and Test cases.
• Involved in SQA Testing and prepared Test Cases, Test Plans, and Scenarios.
• Define requirements using Quality Centre and generate Traceability Matrices to ensure that all the requirements are covered by the test cases
• Involved in internal reviews like code walkthroughs, inspection and unit-review tests of converted programs, copybooks and JCL’s etc. and review of quality control documents.

Environment: COBOL, CICS, DB2, JCL, CHANGE MAN, XPEDITOR, INTERTEST, IMS DB, SQL, FILE-AID, SPUFI, QMF, IDCAMS, FTP, ABEND-AID, DB2 PLATINUM, SORT.