PROFESSIONAL SUMMARY:

• Analytics professional and certified Tableau Desktop 10 Associate, Statistical Business Analyst with 8 years of experience in quantitative analysis, data mining, aggregation and validation, model development and validation of predictive models including financial time series models.
• Extensive experience in locate, acquire, and combine data from internal and external sources, evaluate the integrity of data and develop actionable data analytics
• Expertise in using the analytical and data visualization tools such as SQL, SAS, Advanced MS Excel, Tableau, Power BI, and SPSS.
• Well versed in machine learning algorithms such as Linear and Logistic Regression, Decision Trees, Random Forest, K nearest neighbors, Text Mining, Word Cloud and Sentiment Analysis.
• Extensive Experience in predictive and descriptive analytics of financial data sets using R and Python Programming.
• Extensive Experience with statistical analysis and data analytics methods.
• Experience with Hadoop and database management tools.

TECHNICAL SKILLS:

MS Excel/ Pivots / Marcos, MS Access, SPSS/STATA/SAS, Spark /HiveQL /MapReduce, QGIS, Tableau/ QlikView / Power BI, Project Management, Excellent attention to detail.

WORK HISTORY:

Sr. Data/BI Analytics Engineer

Confidential

Responsibilities:

• Gathered and documented business requirements for analytical reports. Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.
• Efficiently located, acquired, and combined data from internal and external sources like DB2, MDAW, Netezza, PEGA, MongoDB and Amazon Redshift. Evaluated the integrity of data and developed actionable data analytics.
• Create automated processes for gathering, transforming, manipulating data in the desired form and reporting using SQL, R, and SAS.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary tables to support Tableau.
• Provided continued maintenance and development of bug fixes for the existing and new Tableau.
• Designed & Implemented advanced statistical and machine learning models like Linear Regression, Logistic Regression, Decision Tree, Word cloud, Text Mining & Sentiment analysis on large scale data (Big Data) in R/Python.

Predictive Analyst Intern

Confidential

Responsibilities:

• Transformed project data requirements into project data models.
• Designed and developed schema data models.
• Monitored and forecast enrollment and student's trends.
• Analyzed data using statistical software WebFOCUS R Stat & built predictive models.
• Converted complex data and findings into understandable tables, graphs, and written reports.
• Prepared executive reports and present results to higher management.
• Participated in requirements meetings and data mapping sessions to understand business needs.
• Recommended data standardization and usage to ensure data integrity.

Sr. Data Analyst

Confidential

Responsibilities:

• Interpreted data, identified trends or patterns & analyzed results using statistical techniques with Micro - fit; E-views & Advanced Excel.
• Conducted predictive and descriptive analytics of financial data sets using R and Python Programming
• Provided analytical, transactional and administrative HR support to the Financial Management & Human Resources. This includes providing various reports, analysis and presentations to support business requests using Tableau.
• Compiled various financial data using Bloomberg Analytics and run historic spread analysis using Excel & Power BI.
• Filtered and prepared data, and review computer reports, printouts, and performance indicators to locate and correct.
• University website updations and posting using HTML.
• Developed database objects, including tables, views and materialized views using SQL.

Assistant Manager

Confidential

Responsibilities:

• Translated business problems into statistical problems, and developed statistical models using SAS Confidential o support business needs, such as ANOVA, linear regression, logistic regression, decision trees, clustering, recommendation systems and basket analysis.
• Combined data from many tables using SQL and transformed it.
• Experienced working on data pre-processing steps like aggregation, missing data imputation, sampling, feature selection and dimensionality reduction using SAS. Generated analysis reports, graphs using SAS and MS Excel.
• Derived customer insights through predictive modeling to address business needs, and recommend solutions.
• Designed data-driven marketing initiatives to manage customer relationship, drive sales, enhance executions, and increase productivity.
• Identified, analyzed and interpreted trends or patterns in complex data sets using data mining tools (SAS, Tableau)
• Documented analysis processes and results, summarize data insights, and present key findings to CDO office and other stakeholders.
• Used advanced analytics to assess portfolio performance, determine level of risk and drive critical business decisions. Designed, development and deployment of self-service reports and dashboards based on analytical data.

Financial Analyst

Confidential

Responsibilities:

• Appraised CAM (client application memorandum) of Large Enterprises & Channel finance up to 5 Cr INR ($800,000).
• Responsible for approving loans up to the limit of 1,000,000 INR for Small & Medium Enterprises (SME).
• Monitored and analyzed portfolio health, risk triggers, covenants & other credit conditions & other credit conditions with large data sets using Statistical tools and techniques (SAS & SQL).
• Ensured compliance of all internal & regulatory credit / other portfolio related policies.
• Reviewed financial statements and assisted in the preparation of reports while contributing in areas of budgeting, forecasting, financial planning, modeling, statistical reporting, and evaluation.
• Undertook a complete risk assessment analysis of the borrower e.g. modus Operandi, cash cycles, projections, etc. .
• Maintained & floated a daily business tracker spreadsheet highlighting sales, individual contributions using performance metrics, anomalies, oversights & routine management information.
• Created graphs and chart using Tableau & QlikView. Created permanent formatted cleaned data sets for present and future analysis, infilling several datasets and sorting and merging by common variables.
• Trained, guided and communicated credit department policy and procedures to company personnel.

Business Analyst Intern

Confidential

Responsibilities:

• Gathered, documented and analyzed information of financial products and market requirements.
• Designed and developed solutions that meet client requirements.
• Created requirements documentation and diagrams to assist in the support, development and/or analysis of a product and/or process. Documented business workflows for stakeholder review and automate the defined solution.
• Collaborated with business and IT resources on product deliverables implementation.
• Build and maintain client relationships through customer and product support.

Business Consultant

Confidential

Responsibilities:

• Worked with various Confidential across India for Data collection and analysis.
• Combined data from many tables using SQL and transformed it.
• Developed comprehensive reports and analyzes data in order to identify patterns and trends.
• Identified opportunities for improvement that can be addressed with educational initiatives.
• Identified and documented project constraints, assumptions, business impacts, risks and scope exclusions.