Sr. Data Science Specialist
Saudi Aramco Rowan
مجموع سنوات الخبرة :14 years, 6 أشهر
Managing the offshore drilling analytics requirements for Rig operations department.
Achievements:
▪ Drilling data acquisition from offshore rigs utilizing Kepware IoT gateway and MQTT broker.
▪ Rig performance KPIs visualization on Power BI dashboard.
▪ Enhancing rig drilling state algorithm by considering M/D Totco RigSense tags.
Orchestrated data ingestion solutions on Hadoop based data platform.
Achievements:
▪ Lead and managed Data Lake initiatives for future vision analytics.
▪ Defined and implemented data ingestion strategy along with data stream handling methodology for future enhancements.
▪ Devised data ingestion framework in Apache Nifi.
▪ Facilitated consumer and corporate customer usage trends aggregation on Apache phoenix over HBase using Spark.
▪ Ingested CDR data for DPI analysis leading to campaign building.
Direct concurrent business problem resolutions in the telecom and banking industries, utilizing statistical data mining approaches that include cluster analysis, regression, classification, and pattern identification.Oversee and implement analytical frameworks that solve business problems for clients, for educated decision-making processes.
Achievements.
Followed CRISP-DM and SEMMA methodologies for exploratory data analysis and analytical solution development.
Maintained analytical wrangled data sets for white and black box modeling.
Isolated global and collective outliers from data sets using K-Means, Z-score and K-Nearest neighbors.
Performed central tendency data imputations for handling missing data values and replacing outliers.
Features selection through decision tree induction, forward selection and backward elimination techniques.
Exploration and discovery of new features using principal component analysis.
K-means and hierarchical clustering customers base in residential, geographical and lifestyle segments facilitating profile analysis leading to product marketing campaign building and MROI analysis.
Clusters evaluation using elbow method determining inlaying distortion for optimum segments count.
Devised credit score model for loan and credit card application goodness tracking. Utilized logistic regression, naive bayes, decision trees and random forest.
Analyzed and implemented automatic credit card application ratings using credit score to identify potential and non-potential new customer segments.
Up lifted credit fraud prediction model using SNA graph technique. Identified defaulters’ customer in network for model lift.
Upsold product bundle packages using upselling models, in collaboration with sales and marketing team. Utilized apriori market basket analysis and association rules facilitating next best offer inferation for potential customers.
Enhanced the predictive model to prevent customer and revenue churn rate by imposing SVM.
Facilitated in-depth return on investment analysis with smart CapEx implementation utilizing traffic usage predictions. Performed near real time stream analytics using Kafka, Zookeeper, Avro, Hive, Hadoop, Spark and Tableau.
Facilitated monthly analysis offering a clear overview of monthly churners, credit recharge, fake sales, port-ins, and port-outs.
Explored upsell and cross sell opportunities through a multi-simcustomer prediction model based on customer surveys.
Initiated and implemented predictive to prescriptive analytics shift. Configured alarm notifications for gold segment predicted churners.
Evaluated models for comparison and selection through R-squared, adjusted R-squared, ROC Curve, cross validation, confusion matrix and Gini index.
Enhanced model performance by parameter tuning in XGboost model.
Deployed and monitored up and running models to prevent over fitting.
Orchestrated system functionality and enterprise level ETL, for Oracle Siebel-CRM, Geneva-IRB, and IBM ICMS, to include Oracle financials, Genesys CTI and non-relational sources such as flat files into company CLDM. Implemented ETL utilizing Abinitio and IBM data stage designer, repository manager, workflow manager, and workflow monitor. Developed BTEQ, Fastload, Fast export, and Mulitload script for data extraction, transformation and loading.
Achievements.
Established ETL mappings with multiple data transformation systems, like Source qualifier, JAVA,
Expression, Lookup, Aggregate, Update Strategy and Joiner.
Developed stored procedures, functions, views and triggers, to include intermediate ETL layers
such as leftover processing and full extract processing.
Performed ETL layer-Heterogeneous source system integration; technical specifications, job
designs, job documentation, and optimized Teradata EDW ETL queries.
Devised documentation for entire EDW design, implementation, and deployment procedures.
Initiated CDC, SCD-2 data integration applications, and performed migration projects designed to
shift source system database object to Teradata EDW.
Provided data mappings migration from data stage to Abinitio.
Analyzed the current system and its short comings, worked with team as analyst and developer to re-design the modules in accordance with business rules.
Achievements:
Implemented ERP consisting of 5 modules HR & payroll, Accounts, Inventory, Sales and Order log.
Developed procurement management system to handle purchase processes, quotations prioritizations, approvals and inventory management.
Extensively involve in Requirements elicitation, System designing and ERP development activities of Pakistan telecommunication authority.
Achievements:
Developed UAN, UIN, Toll free, Mobile Short codes number allocation and management system.
Developed communication equipment type allocation and management system.
MS Software Engineering helps to learn advance skill in software engineering and prepare the students to take high level jobs in software industry. The program helps academically oriented students who wish to continue education and pursue advance and highly technological aspects of software engineering.
The mission of software engineering program is to prepare technically strong engineering students who can contribute effectively towards nation, society and the world at large through innovation, research, entrepreneurship, leadership and healthy lifelong learning attitude. This can be evidenced by their career satisfaction, promotions / raises, and leadership at levels appropriate to their experience and success in their post undergraduate study as evidenced by satisfaction with the decision to further their education, advanced degrees earned and professional visibility.