PROFESSIONAL SUMMARY

• 8 years of experience in Data Analysis, Marketing and statistical analysis, Design, Development, Statistical Modelling, SQL, SAS, Python, Hadoop.
• Excellent skills in Data mining and Statistical models. Proficiency in Data creation, extraction, cleansing, manipulation, migration, transformation, exploration, summarization, visualization/reporting.
• Experienced on ETL concepts and Data preparation for various statistical modeling which includes data cleaning, descriptive analysis, missing data analysis, data validations, data triangulations and preliminary data reporting.
• Experienced coding in Python and utility PyCharm.
• Experienced working with Hadoop data and databases such as Teradata and its utilities, Oracle 11g. Strong expertise in writing SQL queries, stored procedures.
• Good knowledge on BI tools OBIEE (certified) and Tableau
• Experienced working with scripting languages such as Shell scripting, VBscript.
• Experience in using various MS office tools for analyzing, arranging and presenting data analysis.
• Good knowledge on SDLC and tools like Agile, ALM, and SVN methodologies of project lifecycle management.
• Strong logical, assessment and interpretation skills
• Self - starter with excellent analytical, organizational, problem solving, critical thinking and reporting skills
• Capable of handling and managing multiple tasks and projects simultaneously. Ability to prioritize responsibilities and work in high speed and hectic environment as need arises,
• Strong leadership, interpersonal and oral/written communication skills.
• Ability to work independently as well as collectively

TECHNICAL SKILLS

Languages: SQL, SAS(certified), Python, Shell Scripting

Databases: Oracle, Teradata

Big Data: Hadoop, Mapreduce (coursera certified), Spark

Reporting: Tableau, OBIEE (certified)

MS Office: Excel Pivots, V Look up, H Look up, MS Access

Operating System: Windows 2000/2003/7/8, UNIX, LINUX

Packages/Tools: MS office, MS Project Management, Erwin data modeling tool.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Data Analyst (Remote)

Responsibilities:

• Performed quantitative analysis to identify sources of variability in sales team performance, product targeting, relationship deepening, and market opportunity sizing.
• Strategize with business partners on email and online marketing offer campaign concepts for Credit Cards, Credit Card Services, and Online Banking Line of Business.
• Gather and finalize technical requirements of campaigns including targeting criteria’s.
• Analysedcustomers data by running mapreduce jobs on HDFS.
• Utilizedanalytical skills and interpreted data to assess individual campaign effectiveness across all channels and make recommendations where appropriate.
• Determine/select data sources required to meet campaign requirements and run data queries to check on reliability of the data.
• Validate & QA campaign list selection logic, offers and dynamic output - confirming the development output meets final campaign requirement.
• Validate campaigns are being launched with expected quantities and response data is being tracked appropriately.
• Provide post-launch campaign reports providing success metrics, test comparisons, insights and recommendations based on data analytics using Teradata, SQL Assistance and Tableau.

Environment:Teradata, HDFS, ORACLE 11g, Tableau, SAS EG, Unix, Windows 7

Confidential, Mc Lean, VA

Data Analyst(Remote)

Responsibilities:

• Dealt with Basel model implementation and monitoring for various portfolios.
• Extensively involved in Data validation, Model validation, and quarterly back testing report generation and documentation.
• Involved in converting SAS codes to python as a part of technology migration.
• Worked on data extraction and performed data analysis using Python using scipy and numpy libraries in python. Created a visual representation of the report using Python’s seaborn library on top of Jupyter notebooks.
• Involved in programming mapreduce jobs using Python 2.7.
• Worked extensively on economic models likerecovery rate analysis, LLF(loan level loss Forecasting) models and assisted in multiplier analysis of LGD model.
• Involved in updating the existing code or create new code by using SQL and SAS advanced concepts to implement new requirements.
• Developed SAS code to validate data of different portfolios.
• Developed SQL and SAS code for conducting ETL from Teradata, Oracle, Excel and flat files that can be used repeatedly.
• Worked extensively on Teradata and ORACLE databases and utilities like BTEQ and oracle SQL .
• Professional Debugging, Revision and Testing of all deliverables, including Production Code, to abide by QC Checks, Execution standards and Maintenance requirements.
• As part of BASEL project implementation, worked on tools like GITHUB and TortoiseCVS and used HP ALM to document development and testing efforts
• Used Agile methodology of Version One for sprint planning.

Environment:Teradata, Hadoop, ORACLE 11g, SAS EG, Python 2.7, Tableau, Unix, Windows 7

Confidential, Atlanta, GA

Data Analyst

Responsibilities:

• Assisted in analysis of the business requirements and preparation of functional spec document, Issue tracker and Use cases
• Preparation of weekly marketing reports on providing success metrics, test comparisonsand updating same to the Project manager.
• Responsible for importing, manipulating and generating weekly and monthly list reports using SAS Enterprise Guide
• Developed and maintained Tableau Dashboards to take monitoring and reporting time from two weeks/month to two days/month
• Determining data sources required to meet campaign requirements and run data queries to check on reliability of the data.
• Performed quantitative analysis to identify sources of variability in sales team performance, product targeting, relationship deepening, and market opportunity sizing.
• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge.
• Worked extensively on Teradata, SQL Server.

Environment:SAS Enterprise Guide v5.1, LINUX, UNIX, Predictive Modeling, Tableau, SQL Server

Confidential, Detroit, MI

Data Analyst

Responsibilities:

• Assisted in Functional requirement analysis, design, development/enhancements and deployment in finance modules.
• Formulated procedures for data extraction, transformation and integration of health care data.
• Ability to dig into raw data to find and evaluate actionable insights that will help the organization.
• Reviewed customer claims and eligibility data to ensure they meet the required QA standards and are sufficient to meet the reporting needs of the customer contract. If the data is deficient, worked with the claims processing team, Account Executives and project managers to correct issues in a timely fashion.
• Checked the validity of the received data from the facility or the physician.Merged the client’s data with the data provided by the facility to check the eligibility for that claim
• Responsible for creating and delivering recurring as well as ad hoc reports within strict timelines while under constantly changing requirements using SAS, SAS SQL, and Teradata SQL in a UNIX environment with Oracle, Teradata relational databases and Informatica.
• Analyze and interpret results based on data summaries.
• Extract the data from a data warehouse and create tables, graphs and ad-hoc reports, according to Business needs.
• Testing and debugging of all ETL and Oracle db objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Used various procedures such as Proc Tabulate, Proc Means and Proc Report to generate tables, listings, graphs and reports.
• Present statistical results using the appropriate graphs, charts, tables and written reports.

Environment:Base SAS v9.2, SAS Enterprise Guide v4.2, Oracle, Teradata,Informatica, ER Win, UNIX.

Confidential, Miami lakes, FL

Business Systems Analyst

Responsibilities:

• Assisted in Functional requirement analysis, design, development/enhancements and deployment in finance modules.
• Integrate results of the Marketing Mix Analysis, Consumer risk Analysis, Price Elasticity and other advanced analyses into business planning process.
• Assist in the creation of quantitative and qualitative primary research and present the findings.
• Ability to dig into raw data to find and evaluate actionable insights that will help the organization.
• Responsible for creating and delivering recurring as well as ad hoc marketing campaign programming within strict timelines while under constantly changing requirements using SAS, SAS SQL, and Teradata SQL in a UNIX environment with Oracle, Informix, and Teradata relational databases.
• Analyze and interpret significant results based on data summaries.
• Evaluating and recommending affordable options to mortgagor to help reduce financial loss.
• Run daily report to help determined how many loans are in foreclosure or will be in foreclosure within the next ten days.
• Extract the data from a data warehouse and create ad-hoc reports, tables, and graphs according to Business needs.
• Testing and debugging of all ETL and Teradata objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• Used various procedures such as Proc Tabulate, Proc Means and Proc Report to generate tables, listings, graphs and reports.
• Reviewing results of & make recommendations for next generation of mortgage (portfolio) prepayment and retention models
• Present statistical results using the appropriate graphs, charts, tables and written reports.

Environment:Base SAS v9.2, SAS Enterprise Guide v4.2, SAS/Macros, SAS/SQL, SAS/ACCESS, SAS/STAT, Teradata, DB2, IBM Mainframes, ER Win, UNIX.

Confidential

Data Analyst

Responsibilities:

• Worked on Auto Loans Data.
• Involved in many aspects of the Project Management including gathering of requirements, converting requirements to data logic and preparing the tables for models, performed QA/UAT to ensure precise and timely deliverables.
• Assisted in developing Functional Spec Document, Assessment and Heat Map Scoring related to Fair and Responsible Lending (FRL) and Unfair, Deceptive or Abusive Acts or Practices (UDAAP) used in the DIRAT - FRL Calculator.
• Developed SAS programs for statistical analyses and data displays.
• Extracted data from sources like Oracle, MS Access and excel files and built input SAS data sets
• Raw data was transformed/processed to create datasets in the required format and tabulated so as to easily analyze data. Extensively used Proc Tabulate procedure for the purpose.
• Data Analysis and graphical presentation for various summary reports using Base SAS and SAS/Graph facility.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.
• Extensively used data export techniques. The data after being analyzed was directed to different output files such as Excel Spreadsheets and DBF files

Environment:SAS, Oracle SQL, UNIX, MS Access and MS Excel.