SUMMARY

• Over 14 years of professional experience in Information Technology with a focus in Mortgage Banking, Retail Banking, Finance, Sales and Marketing, and Insurance with over 10 years in implementing Data Warehouse, Data mart and Data Analysis applications.
• Around 3 years of experience in Data Science, with Knowledge Applied Statistics, Statistical Sampling, Data Mining and Machine Learning using SciKit Learn and TensorFLow.
• Currently working as Senior Manager - Analytics and Information Management to provide Data Science and Data Analytics solutions to our clients.
• Competent understanding in Data Wrangling, Data Munging, Data Mining, Statistical Data Modelling, Data Visualization and Statistical Sampling.
• Extensive experience in Python, Machine Learning, Regression and Classifications algorithms, SQL, SciKit Learn, Tensorflow, Tableau and UNIX / Linux.
• Experienced, Acquiring and Implementing Data Science, Applied Statistics, Data Mining and Machine Learning skills, using with my extensive experience and passion on Data Science and Data Analysis to provide deep insight into structured and unstructured data.
• Over 7 years of experience in Data Analytics, Data Modeler and Data Architect with demonstrated history of working with major financial and mortgage banks to provide Modelling and architecture solutions to their data integration and data consolidation problems.
• Extensive experience in Automation of Data Extraction, Data Mapping, Data Transformation, Data Loading and Data Migration from Legacy Systems, Teradata, Oracle, SQL Server, DB2 UDB and Flat files using Informatica.
• Complete knowledge of data warehouse methodologies (Ralph Kimball, Star schema and Snow flake schema, ODS, EDW and Master Data Management (MDM).
• Good people management experience, managing resources, resource training, quarterly and yearly performance appraisal, feedback and evaluation

TECHNICAL SKILLS

Data Management Systems: Teradata 13.10, Oracle /8i /9i /10g/11g, MS SQL Server, MYSQL, MongoDB.

Core Skills: Data Modeling, Data Architect, Data Science, Data Analytics.

Statistics and Data Science: Experimental Design, Statistical Sampling, T-tests, Analysis of Variance, Linear Regression, Diagnostics, and Checks for Statistical Methods. Model selection and validation.

Analytics Programming: SQL, SAS, Python - Numpy and Pandas, Scikit-Learn and TensorFLow, R.

ETL Tools: Informatica, SSIS.

Creative Coding: Processing 3.3.6

Other Utilities: ER Studio Data Architect, IBM Infoshpere, TFS, Cognos, Tableau, Unix.

Big Data Technologies: Hadoop, Hive and Pig

PROFESSIONAL EXPERIENCE

Confidential

Sr. Manager

Responsibilities:

• Define Volume, Productivity and Hiring views with adequate drill downs (such as Division, Region, Branch, LO) and Planned Vs Actual comparisons for the Retail channel
• Conceptualize a Productivity Index by benchmarking LO monthly Volume and number of units originated at a region level
• Compute LO Productivity and compare with the defined index
• Build the conceptualized views on Tableau for Realtime, easy dissemination
• Overlay macroeconomic factors (such as interest rate fluctuations, house prices, seasonality etc.) to explain productivity deviations where applicable.
• Predictive analysis on LO (Loan Officer) hiring using regression models (Ordinary Least Square, Ridge and LASSO) and classification models (Naïve Bayes, Random Forest) of LO (Loan Officer) performance busing performance index based on historical data analysis and seasonality factors.
• To compare the predictive model with (Financial Planning and Analysis) FP&A forecasting and actuals hiring to determine correct index for hiring and performance.

Confidential

Manager

Responsibilities:

• Defined the strategy roadmap for Marketing and IT group by providing solution including data model and architecture to implement data integration and data archival solution to automate marketing and lending campaign and advanced data analytics.
• Requirement analysis - Extended requirement sessions/interviews with SME of marketing group to understand, analyse the existing and future requirements, including existing source systems and data to design sustainable and scalable architecture to support current and future requirements.
• Architect and modelled, customer 360-degree view to provide an integrated solution to connect House hold, Customer and Account data from numerous source in complex banking environment.
• Identification and classification of accounts into household based using machine leaning classification techniques using Dimension Reduction, Support Vector Machines and Decision Tree.
• SQL Stored procedures to define and derive KPI’s for campaign and reporting.
• Coordinated with key stakeholders, subject matter experts, application owners, IT and other analysts for business requirements gathering and analysis.

Confidential

Manager - Analytics and Information Management

Responsibilities:

• Understanding different source systems and underlying data on sources like MSP, MLS, Dialer, PM to create sustainable architecture and design to integrate, preserve and make data available for daily and historical reporting.
• Consolidation of collection data from dialer with payment data from MSP.
• Prediction of call volume using Linear Regression and classification of call category by analysing historical data to predict hiring and skilling requirement.
• Prediction foreclosure timelines using regression methods for major category and sub categories stages by analysis and classification of historical data.
• Determine the relationship between different source systems, so that data from different system can communicate and reside under one umbrella.
• Data modelling/ designing the star schema that enable current and historical reporting.
• ETL architecture and detail design for efficient operation of data mart in case of issues like service failure, data issue etc.

Confidential

Manager

Responsibilities:

• Coordinating with foreclosures and bankruptcy VP, SME and business partners on project scope and requirements gathering.
• Involved in requirement gathering and data analysis, project plan, identifying and managing deliverables for each sprint.
• Defined a system to integrate data requirement from various systems to manage default loans to get compliance from Fannie May.
• Interacting with Business to translate business requirements to technical solutions for developing Operation Data Stores and Data Warehouse for servicing and IVR systems.
• Worked on IVR (Integrated Voice Response) system to help determine the call category based on historical data analysis and response by called.
• Predicting call volume for certain category based on seasonality, or special event like marketing campaign, error rate for category etc.
• Extensively used SAS - Proc Means, Proc Corr, Proc Reg, Proc glmselect, proc factor, proc logistic.

Confidential

Manager

Responsibilities:

• Worked as lead data analyst for foreclosure project.
• Involved in complete requirement gathering to enable critical foreclosure reports and risk reports using ICDW and maintaining change controls.
• Complete requirement analysis, identifying and closing requirement gaps.
• Involved in data profiling, identifying correct attributes required and logic required for requested in shared semantic.
• Design low level design documents (source to target mapping documents) for both Integration and shared semantic layer.
• Validating sample data with business before finalizing the logic to reduce chances of defects during advance stage of development.
• Reporting to management on the progress of data quality improvement and helping resolve data quality problems through appropriate process design strategies, as well as error detection and correction tests and procedures.
• Support the business users in performing timely analysis to identify data quality issues.

Confidential

Senior Associate (ETL / Data warehouse Developer)

Responsibilities:

• Develop and maintain systems documentation such as design specifications, technical manuals, description of application operations, and methodology documentation.
• Handling Production Support issues, change request and data maintenance issue and resolve the issue with in specified SLA that depend on the request priority.
• Designed and Developed Informatica mappings, creating sessions and workflows for Data Loads. Developed the design documents for ETL processes, defining the transformations and join conditions, which helped the users to better understand the type of data.

Confidential

Responsibilities:

• Created Detailed Low Level Design Documents using MS Visio, based on High Level Design and Data Map document.
• Reported gaps in Data map if any to Business Analyst and suggested solutions.
• Designed and developed Informatica code, created sessions and workflows for Data Loads. Used Transformations like Joiner, Expressions, Aggregator, Stored Procedure, Lookups, and Filter.
• Developed PL/SQL procedure for control totals (reconciliation). It is a process to reconcile the metadata daily and weekly load. Used workflow manager for session management, database connection management and scheduling of jobs.
• Requirement analysis. Created HLD for the Policy Module and worked as lead for policy module.