SUMMARY:

• Data analytics professional with almost 10 years of experience, strong statistical background, expertise in data modeling, data analysis and machine learning. Domain knowledge and experience in healthcare and banking industries.
• Extensive skills in programming such as SAS, PYTHON, SPSS and SQL querying
• Expert in using different Python libraries such as Numpy, Pandas, boto3, Matplotlib, SciPy, Scikit - learn, Seaborn etc.
• Hands-on experience in using Amazon SageMaker for building, testing and deploying machine learning models
• Excellent knowledge on data mining, validation, manipulation, cleaning and treating missing values and outliers as part of preprocessing data for exploratory data analysis and machine learning model building
• Well versed in machine learning algorithms such as Linear regression, Logistic regression, Decision Trees, Random
• Forest, Support Vector Machines, K nearest neighbors in forecasting and clustering algorithms etc.
• Experience working on forecasting, predictive analytics, reporting on healthcare claims data and banking domains
• Hands-on experience with discovering, analyzing, and identifying key elements in the data thereby communicating the insights, trends, and future forecasts that impact consumer behavior
• Working knowledge in Financial and Healthcare domains
• Experience in working with development and lead data warehouse support teams
• Expertise in Oracle PL/SQL, Functions, Procedures, Packages, Triggers and Materialized Views
• Experience working on analyzing and reporting Facility, Professional, Medical and Pharmacy Claims data
• Strong knowledge of statistical methods like hypothesis testing, A/B testing, ANOVA, regression and classification
• Experience working with Data Analysis Tools (SAS Enterprise Miner, SAS Enterprise Guide, Tableau) to analyze and visualize data to solve data Analysis Problems
• Hands on Experience in Hadoop, HDFS, Map Reduce, Spark and Hadoop Ecosystem.
• Extensive hands-on experience and high proficiency with structures, semi-structured and unstructured data, using a broad range of data science programming languages including SAS, R, Python, SQL, Scikit-Learn
• Solid Experience in using T-tests, Anova, Chi-square, A/B testing and Advanced statistical techniques
• Experience in working with Spark SQL for processing the data in Hive tables
• Worked on Agile methodology of working and lead the teams in sprint planning
• Thorough knowledge and experience of using SAS Macro facility for code automation, customization, reusability and ad hoc reporting
• Have very good experience in customer management and dealing with client’s requirements
• Expert in writing and optimizing SQL queries and optimizing the queries in SQL Server and oracle database
• Proficient in handling large database using SQL Queries, strong skills in writing queries for joining multiple tables, complex stored procedures, function, view, and triggers
• Extensive knowledge of using various SAS Reporting Procedures, SAS Statistical Procedures and SAS Functions
• Excellent command in writing complex routines for data mapping, data validations, data extraction, data transformation, data manipulation and report writing using SAS, SQL, MS Excel in various environments
• Built models to identify & associate product sales with products from same category, aiding business decisions by cleansing, standardizing, pre-processing data & inferring hidden trends
• Implement agile management ideals by facilitating exercises such as sprint planning and team leading stand-ups.
• Solid team player, team builder, and an excellent communicator

TECHNICAL SKILLS:

Analytical Tools: SAS, SPSS, Python, Numpy, Pandas, Scikit-learn, SciPy, boto3Big Data Tools: Hadoop, Hive, Spark

Cloud services: Amazon S3, EC2, IAM, Amazon SageMaker, AWS Lambda

Operating Systems: Windows, Linux/UNIX, and Mac OS

Database: Oracle, MySQL, SQL Server, PL/SQL

Regression Techniques: Linear regression, Logistic Regression, Decision Trees, Time Series analysis, Random forests, K fold validation

Visual Analytics Tools: Tableau, Power Bi, Seaborn, Matplotlib

Statistical Methods: Hypothesis testing, T-tests, Anova, Chi-square, Regression and classification techniques

WORK EXPERIENCE:

SAS Developer

Confidential, Tempe, AZ

Responsibilities:

• Worked on data modelling projects using SAS and SQL. Specifically worked on creating ETL jobs using SAS for wires transactional data, foreign exchange, pitchbook and checks data
• Responsible for leading a team of professionals to oversee risk management of the Bank’s wholesale credit portfolio, including the identification and ongoing monitoring of current and emerging risks
• Have very good experience in talking to clients directly and understanding the requirements and documenting them after customer engagement
• Knowledge on data modelling. Experience in modelling the data to data warehouse and create data mapping
• Worked on multiple migration projects where we had to migrate our SAS codes to Python
• Worked on providing competitor analysis for foreign exchange sales team which helped in understanding and reaching out to clients that are sending money to our competitors
• Worked on creating multiple tableau dashboards to provide monthly and daily trends on foreign exchange, high dollar wires, checks data and validating the data
• Involved in designing of next recommendation model which helps in providing all payments related info at one place. It eases the team for reporting and machine learning models
• Worked on oracle database to create physical views, materialized views, Procedures, Indexes
• Worked on modelling CRM data in better structured format and make it usable easily for Data scientists
• Worked on SAS code and SQL query optimization to improve runtimes. Helped in decreasing our monthly batch runtimes from 29 hours to 14 hours
• Created an alert-based dashboard for FX sales team to provide analysis on new Forex clients, declined trades, credit report, international, inter-company wires and ACH transactions done by FX clients
• Designed alert system through the dashboard to observe customer’s activity and provide solutions to navigate Customer opportunities, activity trends
• Worked on modelling CRM data in better structured format and make it usable easily for Data scientists
• Designed alert system through the dashboard to observe customer’s activity and provide solutions to navigate Customer opportunities, activity trends
• Responsible for requirements gathering from business leads and coordinate team to address the challenges With effective solutions
• Worked effectively on Ad-hoc requests on priority bases when needed to support our the stake holders
• Experience in being working in Agile methodology of working

Data Analyst

Confidential, Pittsburgh, PA

Responsibilities:

• Integrated Healthcare data sources from different systems and mapped the data into data analytics mart
• Collaborate with healthcare clients to define requirements, clean, normalize messy data to model data to structured manner and used it actively for reporting and visualization
• Extensively used Python libraries Pandas, Numpy and SciPy for exploratory data analysis and read/write data using
• Pandas and calculating key metrics as part data analysis and reporting
• Performed analysis on health care costs, utilization trends, clinical conditions, and quality measurements
• Wrote larger and complex PL/SQL querying to create procedures, packages and functions to efficiently perform complex business logic to summarize data. Physical and materialized views are created.
• Built dashboards, business reports and presentations to communicate findings and results effectively to decision makers, business partners and clients using Python and Tableau
• Generated customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts using Python and Tableau
• Gathered Requirements and developed SQL programs to import and create Datasets from raw claim data files that are transferred to SFTP location
• Worked on mapping documents to maintain record of source and target attribute in transformation
• Worked on optimizing existing Python programs and scheduling jobs to auto generate reports on daily, weekly and monthly basis take care of the dependencies to run the batch smoothly
• Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues and performed data analysis and data profiling using complex SQL on various sources systems
• Generated Ad-hoc reports for members demographic for quarterly newsletter and reports for other criteria
• Pulled and Loaded Health Insurance data of members into the databases for analysis purposes

Statistical Modeler

Confidential

Responsibilities:

• Worked on patient’s historical behavioral data and demographic data from third party to build disease specific predictive models to predict probable patients to respond for different cancer diagnosis using SAS and SQL
• Expertise working with large volumes of data and creating analytical data reports and experience in performance tuning the SAS processes using advanced techniques
• Wrote SAS codes to validate the data with the descriptive, exploratory data analysis using univariate procedure
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards
• Used different data analysis and manipulation procedures like proc means, proc freq., proc sort, proc format, proc transpose, proc append, merging in SAS
• Extensively worked on SAS programming to optimize the existing codes to improve the job execution time and create robust codes and fix bugs in existing SAS processes
• Worked with cross-functional Marketing team to conduct test and control analysis of experimental customer group to measure the effects of marketing campaigns
• Involved in testing SQL Scripts for report development and handled the performance issues effectively
• Performed data cleaning depending on the requirement using SQL to ensure data quality and completeness to ensure proper accuracy of data
• Worked on UNIX scripts to schedule and run SAS codes automatically on daily, weekly and monthly basis using
• CRON scheduling and taken care of issue and bugs during batch process
• Supported ad-hoc analytic requests to provide accurate and timely data reports on monthly basis
• Created and maintained project plans, meeting summaries, status reports, issue logs and requirements/project change management

SAS Analyst

Confidential

Responsibilities:

• Analyzed large volume customers data to identify and created list of potential customers, supported risk management team mitigate the potential risks
• Performed statistical analysis of financial and operational data and supported operational team to resolve the issues in daily, weekly and quarterly processes
• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction
• Used SAS/ACCESS to extract data from different database management systems (DB2, and SQL SERVER)
• Created data visualizations using tools like power Bi and Tableau
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
• Developed PL/SQL interfaces using collections, stored procedures, functions, triggers, sequences, directory paths, and synonyms
• Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external
• RDBMS tables using LIBNAME and SQL PASSTHRU facility
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros using macros debug options like Symbolgen, Mlogic and Mprint
• Worked on writing and optimizing SQL queries and optimizing the queries in SQL Server and oracle database
• Generated high quality reports in the form of listing, TXT, HTML, RTF and PDF formats using SAS ODS
• Worked with project manager, Architects, and developers to escalate the process to beat the project’s target date