SUMMARY:

• Data Analytics/Scientist with 14+ years of experience in business process analysis; predictive, prescriptive and descriptive data modeling; statistical and econometric data analysis; engineering and testing
• Business intelligence, data mining, databases and data warehouses; data governance and controls in all information life cycle management for managing data quality, metadata, master data and data security

PROFESSIONAL EXPERIENCE:

Data Scientist, Advanced Predictive Analytics

Confidential

Responsibilities:

• Designing and building campaign measurement and treatment optimization advanced predictive analytics solutions including data discovery, analysis, cleansing, variable formulation & selection, data transformation, univariate, bivariate and multivariate analysis, multicollinearity analysis, model selection, building & diagnostics,, scoring, validating and deployment
• Business understanding, data understanding, data preparation, modelling, evaluation and deployment of churn prediction, behavioral segmentation and churn segmentation of wholesale and retail telecom data using Cross Industry Standard Process for Data Mining/ CRISP - DM
• Developing and implementing prototype product recommendation model using Sample, Explore, Modify, Model and Assess/SEMMA methodology
• Data discovery, data transformation, model building and diagnostics using IBM Netezza, IBM SPSS modeler, R, Python, NZ-SQL, PL/SQL, tableau, Hadoop, shell scripting, Microstrategy and angular java script
• Extract, aggregate & synthesize data from structured and unstructured data sources to predict telecom customer retention & campaign targeting insights by classification, segmentation & association models
• Designing and implementing information life cycle management through effective requirements management, data management, storage, integration, reporting and analytics
• Designing and implementing data governance and controls in all information life cycle management for managing data quality, metadata, master data and data security

Sr. IT specialist, Data Management

Confidential

Responsibilities:

• Plan, design, manage, execute data modeling, mining, provision and reporting using R data mining, tableau, spotfire, micro strategy, Informatica, Grid tools, IBM InfoSphere Optim
• Develop test data management strategy in accordance with data governance policies, to provide right sized test data and maximize test data reuse, safety, initial state repeatability, profiling, catalog and versioning
• Discover test data by analysis of business flows, system integrations, data architectures, business data objects, business data rules and data entities & relationships
• Profile, transform, enrich, cleanse, extract, subset, load, validate production copy data to test systems
• Generate production like fabricated test data meeting complex business data rules of integrated applications
• Maintain test data by refreshing, roll forward, roll back ward, aging, reset, archive and cleaning techniques
• Information Life Cycle management (Data modelling, Data development & Data base administration)
• Analysis of data governance which includes data quality, information life cycle management (data modelling, data development and admin), metadata, master data management and data security
• Identify and mask sensitive test data to meet security requirements and data rules of integrated systems
• Perform root cause analysis and resolve data defects and issues of data load and downstream data impacts
• Create data models and test data and perform data masking, data mining and reporting for insurance & retail
• Statistical and quantitative analysis, rules-based methods, and explanatory and predictive modeling using CRISP-DM
• Support testing by addressing data related defects, providing any potential new data required as a result of changes and performing data maintenance activities: harvest and archive potential re-usable test data assets

Data Analytics Consultant

Confidential

Responsibilities:

• Developed Sourcing level document for SAP Bank Analyzer (SAP BA) at Bank of America's multiple year, Financial strategy road map data warehousing project
• Developed sourcing logic, codes, data flow processes, account linkage processes, return on risk adjusted capital processing, product derivation, customer segmentation, general ledger account processing, customer relationship management, parity centric house hold processing and related global and product level processes for SAP Bank Analyzer implementation as system of records for BOA financial road map
• Accessed, validated and developed SQL queries on Oracle, SAP and Teradata Data warehouse for MDM, account and transaction level verifications and sourcing and mapping of business objects and data elements in financial transactions, result data layers and source data layers
• Developed data sourcing and element mapping and ETL logic for SAP bank analyzer reporting
• Analyzed, modified and converted abintio codes to IBM InfoSphere data stage development for SAP BA
• Prepared and performed Unit, integration, system and user acceptance Test plans and tests using HP QC
• Accessed and analyzed loan, insurance, cards, investment, deposit and related financial data on W, BW, BACARDI using teradata SQL assistant, TOAD for Oracle and SAP Bank Analyzer
• Analyzed and converted business requirements, high level design documents, low level design documents, business requirement document(BRD ) into Extraction, transformation and loading logic to SAP BA
• Created, escalated and resolved open items, dirt logs and business review protocols and performed gap and root cause analysis using traceability matrix for SAP bank analyzer implementation
• Owned data extract full cycle data sourcing through client sign off, following ASAP, RUP, DMAIC, perform document review( participate in JAD sessions) with SAP BA team, business team and ETL team
• Analyzed and designed SAP BA business workflow scenarios, data sourcing, mapping, and transformation
• Developed SAP BA use cases, activity diagrams, ERD, class diagrams, user screens, user stories

Consultant, Data analytics and Business Intelligence

Confidential

Responsibilities:

• Gathered business requirements for SQL server database and business intelligence
• Developed reporting and data analysis & that incorporates dashboards, tools and processes to track the financial, operational and social results of projects using SEMMA approach
• Developed and modified functional, structural and behavioral design document using UML
• Designed for SQL server database by analyzing workflow charts and use case, class, interaction diagrams and design ERD, UI and data models
• Designed databases, ETL, reporting and analysis servicesusing SQL server 2005
• Analyzed, coded, and tested SQL queries, stored procedures, triggers, custom codes and user defined functions from design specifications
• Designed and conducted data collection and cleansed data, performed data analysis and reporting
• Designed relief distribution, non-profit project evaluation and need assessment systems projects

Data Analytics & Business Intelligence, Manager

Confidential

Responsibilities:

• Led exploratory and predictive and prescriptive data modeling to attain the revenue and profitability goals using CRISP-DM
• Managed firm’s marketing resources and designed marketing and ISO 9001 quality management strategies
• Conducted marketing research using SPSS and STATA and performed database query, data extrapolation and interpretation, statistical analysis, forecasting and trending, and report production
• Designed SQL server 2000/ 2005 for production for multi-million dollar beverage sales system
• Designed logic, data and process models for ISO 9001 Quality Management System and predictive models
• Designed, built, tested, trained and validated models on a continuous basis using SPSS and STATA
• Developed analyses and predictive models on customer segmentation, acquisition, attrition, enhanced cross sell and profitability using SPSS, excel, SQL server 2005 and MS access
• Performed systems and factory expansion project feasibility and conducted various staff and user s

Socio-economist, Employment Generation Schemes

Confidential

Responsibilities:

• Developed knowledge of government using spreadsheet, access and SPSS to support socioeconomic, employment generation scheme, microfinance and non-profit project management systems
• Assessed user requirements, procedures, and problems to create project monitoring and evaluation
• Managed data and data quality operations support of shared data repositories
• Performed data analysis and reports leveraging datasets, data and process models and decisions
• Gathered, analyzed, evaluated data issues and documented business processes and UML models
• Determined how new systems or system enhancements may improve process flow and business function
• Managed the extraction, transformation, and population of data files and databases using SQL & STATA