Job description:
insight global is looking for an accountant to join a large materials distributor company in santa ana, california. this candidate will be responsible for managing the entire customer rebates portfolio, handling the customer contracts, calculating monthly accruals and supporting payouts. this individual will be responsible for the entire portfolio, handling around 400 accounts. this role is 5 days onsite in santa ana, ca. qualifications:ba degree in accounting, finance, or related field3+ years of accounting experience within a mid-size or large companystrong in excel (sql and macros are not needed but are a plus)team-focused mindset, ready to collaborate with others plusses: fp&a experiencepublic accounting experiencevendor customer rebate experience

Resume:
<< sql, db2, accesslanguagesc++ ,java , /sqlinternet technologiesphp, perl, html, javascript, jspsoftware and toolsmicrostrategy, informatica, eclipse , data mining -wekaoperating systemswindows 7/vista/xp/2000/9x, linux experience 06/2013tocurrentdata & business intelligence engineerjones lange lasalle inc.–.3+ years of hands-on experience in bi and data warehousing projects experience in areas of r-olap, m-olap, star/snow-flake schema design, creation and maintenance of data marts/data warehouses 3+ years of hands-on experience in various database technologies including oracle, sql server , postgresql and db2 experience d microstrategy developer with expertise in microstrategy desktop, microstrategy web, dashboards certified oracle pl/sql developer associate good hands on data mining algorithms.for e.g.classification algorithms like c4.5, naive bayesian classifier, clustering algorithms like k-means, k-meloids, dbscan excellent understanding of etl techniques and tools experience in java enterprise edition (java ee), java server pages (jsp) and java database connectivity (jdbc) technologies.excellent, analytical and communication skills well acquainted with all stages of sdlc. 08/2012to 06/2013data analystsolarbridge technologies–.working closely with product team to understand business and responsible for modeling data and designing data warehouse.responsible for creation, interpretation and management of large datasets to achieve business goals.identify and solve issues concerning data management to improve data quality.responsible for data updates, indexing, and maintenance in production database responsible for developing end to end java application for database migration from postgresql to mysql responsible for developing unix shell scripts to automate production database scripts. 01/2008to 01/2011bi and database developer–.designed and implemented data warehouse and dashboard based solution for the toll systems in capacity of a team leader, handled a team of two developers to implement end to end solution for the toll systems using dashboards and data warehousing technologies analyzed various key performance indicators for toll system such as generated revenue, budgeted amount, forecasted amount and net profit designed and developed various dashboards to display key performance indicators designed, developed and deployed the desktop and web based reports using bi and data warehousing tool microstrategy created and managed oracle application table spaces, tables, views, indexes, schemas, synonyms required for the project handled deployment and administration of the application in production environments optimized performance of dashboards by developing summarized oracle database views analyzed, documented, and transformed user requirements to the technical team designed and developed database and dashboard based solution for leading retail manufacturer in usa participated in data warehouse design to provide solutions to various business needs in capacity of a senior database developer designed and developed the pl/sql stored procedures, functions and packages worked with the etl team and managed the user acceptance testing to ensure to data quality built object prompts like metric prompts and attribute prompts created facts and metrics using pass through functions like applysimple created transformations for time cycle reports that is fiscal year or month designed the database and dashboard based solution for leading home construction materials supplier company in usa created analytical report containing order kpi/analytics, status tracking, ageing analysis, and ranking top 10 customers built metrics like conditional and level metrics using microstrategy desktop designed and developed the static sql, /sql stored procedures, functions, packages to extract, transform and migrate data from various data sources to staging database with exception handling created reports, prompts, provided hyperlinks for drilling/navigation interacted with end users for creating customized reports. education expected in2013totomasters:computer sciencetexas state university-san marcos,gpa:computer scienceexpected in2008totobachelor of engineering:computer science-,gpa: , c++, clustering, communication skills, data management, data mining, modeling data warehouse, data warehouses, databases, database, data warehousing, designing, eclipse, etl, html, php, db2, indexing, informatica, internet technologies, interpretation, java, jsp, java server pages (jsp), javascript, jdbc, team leader, linux, access, windows 7, 2000, 9x, microstrategy, migration, sql, enterprise, navigation, olap, operating systems, oracle 9, oracle application, oracle database, developer, oracle pl/ /sql, perl, postgresql, profit, quality, retail, sdlc, scripts, sql server, sql server, tables, design, vista.