Banner Image

All Services

Programming & Development

SQL DWH and BIG data expert

$20/hr Starting at $500

Enterprising individual with 9+ years of techno-functional experience in areas of data warehouse and big data ecosystem for Banking and Retail. Experience in data mining and analytics across various business areas of Retail which include space-range-display (Planogram), store ordering, distribution, store sales, product, price and promotion. Data analysis techniques include campaign-promotion analysis, cross selling, product pricing, vendor performance, market basket analysis, e-commerce, channel profitability and shelf replenishment. Customer analytics in the banking domain, on the business and retail data, which includes customer profiling, data matching, fuzzy logic, trans-promotional campaigns, campaign management, product cross-selling and payments processing. Strong experience in Teradata (13.10) appliance performance data, workload management, development life cycle processes, performance benchmarks and capacity planning. Significant contribution in the Big Data space that includes data archival and access using optimal compression codec techniques. PIG and Hive used for complex business logic which helped in reducing batch times significantly. Event driven alert mechanism for server monitoring and maintenance implemented on (semi-structured) server logs. Good knowledge in Google BigQuery. Reducing the querying time on massive record sets(to the tune of few billions) was one of the hallmarks of my work experience. Tableau for visualization was implemented. Indexing mechanism using Apache SOLR on incremental transactional data thereby helping end users in search and faceting features. Implemented precision and recall algorithms using HPCC (Roxie and THOR) for linking personal bank prospect customers to existing customer. Experience in Data mining using BASE SAS 9.2, Blaze ISAAC, Informatica SSA, Dun & Bradstreet market insight tool and Teradata CM3 for campaign management. Exposure to reporting tools BO XI R2, SSRS

About

$20/hr Ongoing

Download Resume

Enterprising individual with 9+ years of techno-functional experience in areas of data warehouse and big data ecosystem for Banking and Retail. Experience in data mining and analytics across various business areas of Retail which include space-range-display (Planogram), store ordering, distribution, store sales, product, price and promotion. Data analysis techniques include campaign-promotion analysis, cross selling, product pricing, vendor performance, market basket analysis, e-commerce, channel profitability and shelf replenishment. Customer analytics in the banking domain, on the business and retail data, which includes customer profiling, data matching, fuzzy logic, trans-promotional campaigns, campaign management, product cross-selling and payments processing. Strong experience in Teradata (13.10) appliance performance data, workload management, development life cycle processes, performance benchmarks and capacity planning. Significant contribution in the Big Data space that includes data archival and access using optimal compression codec techniques. PIG and Hive used for complex business logic which helped in reducing batch times significantly. Event driven alert mechanism for server monitoring and maintenance implemented on (semi-structured) server logs. Good knowledge in Google BigQuery. Reducing the querying time on massive record sets(to the tune of few billions) was one of the hallmarks of my work experience. Tableau for visualization was implemented. Indexing mechanism using Apache SOLR on incremental transactional data thereby helping end users in search and faceting features. Implemented precision and recall algorithms using HPCC (Roxie and THOR) for linking personal bank prospect customers to existing customer. Experience in Data mining using BASE SAS 9.2, Blaze ISAAC, Informatica SSA, Dun & Bradstreet market insight tool and Teradata CM3 for campaign management. Exposure to reporting tools BO XI R2, SSRS

Skills & Expertise

AnalysisAnalyticsApacheApache SolrCapacity PlanningData AnalysisData MiningData WarehouseIndexingManagementMy SqlOracleProcessingSASSQLTableauTeradataVisualization

0 Reviews

This Freelancer has not received any feedback.